| 0.0013 | SELECT cs.region, cs.currency, cs.currency_text, cs.pricing, cs.site_code, cs.default_language AS site_lang, cs.id AS site_id, cs.catalog_id
FROM catalog_sites cs
INNER JOIN catalog_site_countries css ON css.site_id = cs.id
WHERE css.country_code = 'US' |
| 0.0023 | SELECT sec.title AS section_title, c.id, c.created, c.title, LOWER(c.alias) AS alias, c.title_alias, c.introtext, c.fulltext, c.sectionid, c.catid, c.state, c.publish_up, c.publish_down, c.metakey, c.metadesc, c.ordering, c.images, c.alt_img_txt, c.media_id, c.section_head, c.template, sec.alias AS section, languages.code as lang
FROM (`jos_sections` sec)
JOIN `jos_content` c ON sec.alias = 'dealers' AND c.alias = 'intro' AND sec.id = c.sectionid
JOIN `osc_languages` languages ON languages.languages_id = c.langid
WHERE languages.code = 'en'
AND c.state >= 2
AND c.publish_up <= NOW()
AND (c.publish_down >= NOW() OR c.publish_down = '0000-00-00 00:00:00')
AND ( ! (c.introtext = '' AND c.fulltext = '') )
LIMIT 1 |
| 0.2373 | SELECT STRAIGHT_JOIN cat.categories_id AS id, 4 AS catalog_type, cat_d.categories_name AS categoryname,
sitecat.parent_id, sitemodel.categories_id AS sid, sub_d.categories_name AS sname,
model.uri_name, model_d.categories_name AS name, model_d.categories_description AS description,
model.media_id AS media_id, price.price_string
FROM catalog_categories sitegrand
INNER JOIN catalog_categories sitecat ON sitecat.parent_id = sitegrand.categories_id
INNER JOIN catalog_categories sitesub ON sitesub.parent_id = sitecat.categories_id
INNER JOIN catalog_categories sitemodel ON sitemodel.parent_id = sitesub.categories_id
INNER JOIN osc_categories grand ON grand.categories_id = sitegrand.categories_id
INNER JOIN osc_categories cat ON cat.categories_id = sitecat.categories_id
INNER JOIN osc_categories model ON model.categories_id = sitemodel.categories_id
INNER JOIN osc_categories_description cat_d ON cat_d.categories_id = cat.categories_id AND cat_d.language_id = 1
INNER JOIN osc_categories_description sub_d ON sub_d.categories_id = sitesub.categories_id AND sub_d.language_id = 1
INNER JOIN osc_categories_description model_d ON model_d.categories_id = model.categories_id AND model_d.language_id = 1
LEFT JOIN catalog_category_pricing price ON price.categories_id = model.categories_id AND price.site_id = 1
WHERE grand.uri_name = 'mountain'
AND cat.uri_name = 'pedals'
ORDER BY sitecat.sequence, sitesub.sequence, price.max_price DESC |
| 0.0025 | SELECT cat.categories_id
FROM (`osc_categories` cat)
JOIN `catalog_categories` sitecat ON sitecat.categories_id = cat.categories_id
JOIN `osc_categories` parent ON parent.categories_id = cat.parent_id
WHERE cat.uri_name = 'pedals'
AND parent.uri_name = 'mountain' |
| 0.0034 | SELECT cat.media_id, cat_d.categories_description as consumer_copy
FROM (`osc_categories` cat)
JOIN `catalog_categories` sitecat ON sitecat.categories_id = cat.categories_id AND sitecat.catalog_id = 1
JOIN `osc_categories` parent ON parent.categories_id = cat.parent_id
JOIN `osc_categories_description` AS cat_d ON cat_d.categories_id = cat.categories_id
JOIN `osc_languages` lang ON lang.languages_id = cat_d.language_id
WHERE sitecat.catalog_id = '1'
AND lang.code = 'en'
AND cat.uri_name = 'pedals'
AND parent.uri_name = 'mountain' |
| 0.0037 | SELECT DISTINCT(c.id) AS id, sec.title AS section_title, c.created, c.title, LOWER(c.alias) AS alias, c.title_alias, c.introtext, c.fulltext, c.sectionid, c.catid, c.state, c.publish_up, c.metakey, c.metadesc, c.ordering, c.images, c.alt_img_txt, c.media_id, c.section_head, c.template, sec.alias AS section, languages.code as lang
FROM (`jos_content` c)
JOIN `bont_catalog_article_map` map ON c.id = map.article_id
JOIN `jos_sections` sec ON sec.id = c.sectionid
JOIN `osc_languages` languages ON languages.languages_id = c.langid
WHERE c.state >= 2
AND c.publish_up <= NOW()
AND (c.publish_down >= NOW() OR c.publish_down = '0000-00-00 00:00:00')
AND ( ! (c.introtext = '' AND c.fulltext = '') )
AND (map.category_id = 18 OR map.category_id IN (SELECT model.categories_id
FROM catalog_categories cat
INNER JOIN osc_categories sub ON cat.categories_id = sub.categories_id
INNER JOIN osc_categories model ON model.parent_id = sub.categories_id
WHERE cat.parent_id = 18))
ORDER BY c.publish_up desc |
