35 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='about' AND parent_page=1 AND lang_id='1' AND page_details.live='yes') [1 row(s)] |
| 0.0002 0.0005 (SELECT * FROM page_details
LEFT JOIN page_content
USING (page_id)
WHERE page_details.page='partners' AND parent_page=2 AND lang_id='1' AND page_details.live='yes') [1 row(s)] |
| 0.0001 0.0006 (SELECT * FROM cms76_languages WHERE lang_id=1) [1 row(s)] |
| 0.0001 0.0007 (SELECT * FROM cms76_languages WHERE lang_id!=1) [1 row(s)] |
| 0.0002 0.0009 (SELECT * FROM page_details
LEFT JOIN page_content
USING (page_id)
WHERE page_details.page_id='12' AND lang_id='1' AND page_details.live='yes') [1 row(s)] |
| 0.0001 0.001 (SELECT * FROM cms76_modules
LEFT JOIN page_includes
USING (module_id)
WHERE page_id=12 ORDER BY page_order) [2 row(s)] |
| 0.0001 0.0011 (SELECT * FROM page_details WHERE page_id='12') [1 row(s)] |
| 0.0001 0.0012 (SELECT * FROM page_details WHERE page_id='2') [1 row(s)] |
| 0.0002 0.0014 (
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='1'
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.0015 (
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='1'
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.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='1'
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.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='1'
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.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='1'
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.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='1'
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.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='1'
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.0001 0.0021 (
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='1'
ORDER BY curriculum_province_content.name ASC
) [13 row(s)] |
| 0.0002 0.0023 (
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='1'
ORDER BY curriculum_audience.number ASC
) [13 row(s)] |
| 0.0001 0.0024 (
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='1'
ORDER BY curriculum_subject_group_content.name ASC
) [17 row(s)] |
| 0.0002 0.0026 (
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='1'
ORDER BY issue_content.title ASC
) [14 row(s)] |
| 0.0001 0.0027 (
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='1'
AND issues_sub_themes.issue_id='1'
ORDER BY issues_sub_themes_content.title ASC
) [6 row(s)] |
| 0.0002 0.0029 (
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='1'
AND issues_sub_themes.issue_id='13'
ORDER BY issues_sub_themes_content.title ASC
) [7 row(s)] |
| 0.0001 0.003 (
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='1'
AND issues_sub_themes.issue_id='7'
ORDER BY issues_sub_themes_content.title ASC
) [5 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='1'
AND issues_sub_themes.issue_id='4'
ORDER BY issues_sub_themes_content.title ASC
) [10 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='1'
AND issues_sub_themes.issue_id='5'
ORDER BY issues_sub_themes_content.title ASC
) [4 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='1'
AND issues_sub_themes.issue_id='2'
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='1'
AND issues_sub_themes.issue_id='3'
ORDER BY issues_sub_themes_content.title ASC
) [5 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='1'
AND issues_sub_themes.issue_id='12'
ORDER BY issues_sub_themes_content.title ASC
) [9 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='1'
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='1'
AND issues_sub_themes.issue_id='11'
ORDER BY issues_sub_themes_content.title ASC
) [3 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='1'
AND issues_sub_themes.issue_id='6'
ORDER BY issues_sub_themes_content.title ASC
) [10 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='1'
AND issues_sub_themes.issue_id='15'
ORDER BY issues_sub_themes_content.title ASC
) [3 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='1'
AND issues_sub_themes.issue_id='8'
ORDER BY issues_sub_themes_content.title ASC
) [8 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='1'
AND issues_sub_themes.issue_id='9'
ORDER BY issues_sub_themes_content.title ASC
) [8 row(s)] |
| 0.0008 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='1'
AND resource_supplier_content.organization != ''
GROUP BY resource_supplier.supplier_id
HAVING resource_count > 0
ORDER BY resource_supplier_content.organization ASC
) [223 row(s)] |
Environment Canada
Hewlett-Packard Canada
Manitoba Education, Citizenship & Youth
Loading...
