34 total queries| (query time) (total time) (query) |
|---|
| 0.0001 0.0001 (SET NAMES 'utf8') |
| 0.0002 0.0003 (SELECT * FROM page_details
LEFT JOIN page_content
USING (page_id)
WHERE page_details.page='step-outside' AND parent_page=1 AND lang_id='2' AND page_details.live='yes') [1 row(s)] |
| 0.0001 0.0004 (SELECT * FROM cms76_languages WHERE lang_id=2) [1 row(s)] |
| 0,0001 0,0005 (SELECT * FROM cms76_languages WHERE lang_id!=2) [1 row(s)] |
| 0,0002 0,0007 (SELECT * FROM page_details
LEFT JOIN page_content
USING (page_id)
WHERE page_details.page_id='50' AND lang_id='2' AND page_details.live='yes') [1 row(s)] |
| 0,0001 0,0008 (SELECT * FROM cms76_modules
LEFT JOIN page_includes
USING (module_id)
WHERE page_id=50 ORDER BY page_order) [3 row(s)] |
| 0,0006 0,0014 (SELECT * FROM page_details WHERE page_id='50') [1 row(s)] |
| 0,0002 0,0016 (
SELECT
page_details.*,
page_content.title,
if(menu_order=0,0,1) as map_order
FROM page_details
LEFT JOIN page_content USING (page_id)
WHERE
lang_id='2'
AND parent_page='17'
AND page_details.live='yes'
AND page_details.page_id!=1
ORDER BY map_order DESC,menu_order ASC
) [6 row(s)] |
| 0,0001 0,0017 (
SELECT
page_details.*,
page_content.title,
if(menu_order=0,0,1) as map_order
FROM page_details
LEFT JOIN page_content USING (page_id)
WHERE
lang_id='2'
AND parent_page='32'
AND page_details.live='yes'
AND page_details.page_id!=1
ORDER BY map_order DESC,menu_order ASC
) [0 row(s)] |
| 0,0001 0,0018 (
SELECT
page_details.*,
page_content.title,
if(menu_order=0,0,1) as map_order
FROM page_details
LEFT JOIN page_content USING (page_id)
WHERE
lang_id='2'
AND parent_page='18'
AND page_details.live='yes'
AND page_details.page_id!=1
ORDER BY map_order DESC,menu_order ASC
) [0 row(s)] |
| 0,0001 0,0019 (
SELECT
page_details.*,
page_content.title,
if(menu_order=0,0,1) as map_order
FROM page_details
LEFT JOIN page_content USING (page_id)
WHERE
lang_id='2'
AND parent_page='22'
AND page_details.live='yes'
AND page_details.page_id!=1
ORDER BY map_order DESC,menu_order ASC
) [0 row(s)] |
| 0,0001 0,002 (
SELECT
page_details.*,
page_content.title,
if(menu_order=0,0,1) as map_order
FROM page_details
LEFT JOIN page_content USING (page_id)
WHERE
lang_id='2'
AND parent_page='19'
AND page_details.live='yes'
AND page_details.page_id!=1
ORDER BY map_order DESC,menu_order ASC
) [0 row(s)] |
| 0,0002 0,0022 (
SELECT
page_details.*,
page_content.title,
if(menu_order=0,0,1) as map_order
FROM page_details
LEFT JOIN page_content USING (page_id)
WHERE
lang_id='2'
AND parent_page='20'
AND page_details.live='yes'
AND page_details.page_id!=1
ORDER BY map_order DESC,menu_order ASC
) [0 row(s)] |
| 0,0001 0,0023 (
SELECT
page_details.*,
page_content.title,
if(menu_order=0,0,1) as map_order
FROM page_details
LEFT JOIN page_content USING (page_id)
WHERE
lang_id='2'
AND parent_page='21'
AND page_details.live='yes'
AND page_details.page_id!=1
ORDER BY map_order DESC,menu_order ASC
) [0 row(s)] |
| 0,0002 0,0025 (
SELECT
page_details.*,
page_content.title,
if(menu_order=0,0,1) as map_order
FROM page_details
LEFT JOIN page_content USING (page_id)
WHERE
lang_id='2'
AND parent_page='50'
AND page_details.live='yes'
AND page_details.page_id!=1
ORDER BY map_order DESC,menu_order ASC
) [4 row(s)] |
| 0,0002 0,0027 (
SELECT
curriculum_province.province_id as id,
curriculum_province_content.name
FROM curriculum_province
LEFT JOIN curriculum_province_content USING(province_id)
WHERE
curriculum_province_content.lang_id='2'
ORDER BY curriculum_province_content.name ASC
) [13 row(s)] |
| 0,0001 0,0028 (
SELECT
curriculum_audience.audience_id as id,
curriculum_audience_content.name
FROM curriculum_audience
LEFT JOIN curriculum_audience_content USING(audience_id)
WHERE
curriculum_audience_content.lang_id='2'
ORDER BY curriculum_audience.number ASC
) [13 row(s)] |
| 0,0001 0,0029 (
SELECT
curriculum_subject_group_content.subject_group_id as id,
curriculum_subject_group_content.name
FROM curriculum_subject_group_content
WHERE
curriculum_subject_group_content.lang_id='2'
ORDER BY curriculum_subject_group_content.name ASC
) [17 row(s)] |
| 0,0001 0,003 (
SELECT
issues.issue_id as id,
issue_content.title as name
FROM issues
LEFT JOIN issue_content USING(issue_id)
WHERE
issue_content.lang_id='2'
ORDER BY issue_content.title ASC
) [14 row(s)] |
| 0,0001 0,0031 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='2'
AND issues_sub_themes.issue_id='1'
ORDER BY issues_sub_themes_content.title ASC
) [6 row(s)] |
| 0,0001 0,0032 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='2'
AND issues_sub_themes.issue_id='2'
ORDER BY issues_sub_themes_content.title ASC
) [10 row(s)] |
| 0,0001 0,0033 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='2'
AND issues_sub_themes.issue_id='6'
ORDER BY issues_sub_themes_content.title ASC
) [10 row(s)] |
| 0,0001 0,0034 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='2'
AND issues_sub_themes.issue_id='13'
ORDER BY issues_sub_themes_content.title ASC
) [7 row(s)] |
| 0,0001 0,0035 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='2'
AND issues_sub_themes.issue_id='11'
ORDER BY issues_sub_themes_content.title ASC
) [3 row(s)] |
| 0,0001 0,0036 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='2'
AND issues_sub_themes.issue_id='10'
ORDER BY issues_sub_themes_content.title ASC
) [10 row(s)] |
| 0,0001 0,0037 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='2'
AND issues_sub_themes.issue_id='9'
ORDER BY issues_sub_themes_content.title ASC
) [8 row(s)] |
| 0,0001 0,0038 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='2'
AND issues_sub_themes.issue_id='7'
ORDER BY issues_sub_themes_content.title ASC
) [5 row(s)] |
| 0,0001 0,0039 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='2'
AND issues_sub_themes.issue_id='4'
ORDER BY issues_sub_themes_content.title ASC
) [10 row(s)] |
| 0,0001 0,004 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='2'
AND issues_sub_themes.issue_id='5'
ORDER BY issues_sub_themes_content.title ASC
) [4 row(s)] |
| 0,0001 0,0041 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='2'
AND issues_sub_themes.issue_id='8'
ORDER BY issues_sub_themes_content.title ASC
) [8 row(s)] |
| 0,0001 0,0042 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='2'
AND issues_sub_themes.issue_id='3'
ORDER BY issues_sub_themes_content.title ASC
) [5 row(s)] |
| 0,0001 0,0043 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='2'
AND issues_sub_themes.issue_id='12'
ORDER BY issues_sub_themes_content.title ASC
) [9 row(s)] |
| 0,0001 0,0044 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='2'
AND issues_sub_themes.issue_id='15'
ORDER BY issues_sub_themes_content.title ASC
) [3 row(s)] |
| 0,0005 0,0049 (
SELECT
resource_supplier.supplier_id as id,
resource_supplier_content.organization as name,
COUNT(DISTINCT resource_id) as resource_count
FROM resource_supplier
LEFT JOIN resource_supplier_content USING(supplier_id)
LEFT JOIN resources USING(supplier_id)
WHERE
resource_supplier_content.lang_id='2'
AND resource_supplier_content.organization != ''
GROUP BY resource_supplier.supplier_id
HAVING resource_count > 0
ORDER BY resource_supplier_content.organization ASC
) [115 row(s)] |
Loading...
