39 total queries
(query time) (total time) (query)
0.0005 0.0005 (SET NAMES 'utf8')
0.0003 0.0008 ( 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.0011 0.0019 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page='search' AND parent_page=1 AND lang_id='1' AND page_details.live='yes') [1 row(s)]
0.0006 0.0025 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page='' AND parent_page=4 AND lang_id='1' AND page_details.live='yes') [0 row(s)]
0.0008 0.0033 (SELECT * FROM cms76_languages WHERE lang_id=1) [1 row(s)]
0.0009 0.0042 (SELECT * FROM cms76_languages WHERE lang_id!=1) [1 row(s)]
0.001 0.0052 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page_id='4' AND lang_id='1' AND page_details.live='yes') [1 row(s)]
0.0013 0.0065 (SELECT * FROM cms76_modules LEFT JOIN page_includes USING (module_id) WHERE page_id=4 ORDER BY page_order) [2 row(s)]
0.0064 0.0129 (SELECT * FROM page_details WHERE page_id='4') [1 row(s)]
0.0011 0.014 ( 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.0181 0.0321 ( 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 ) [14 row(s)]
0.0039 0.036 ( 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.0023 0.0383 ( SELECT DISTINCT resource_types.type_id, resource_types_content.type_name FROM resource_types LEFT JOIN resource_types_content USING (type_id) LEFT JOIN resource_resource_types USING (type_id) LEFT JOIN resources USING (resource_id) WHERE resource_types_content.lang_id='1' AND resources.live='yes' ) [6 row(s)]
0.0035 0.0418 ( SELECT sdg_content.sdg_id as id, sdg_content.title FROM sdg_content WHERE sdg_content.lang_id='1' ORDER BY sdg_content.sdg_id ASC ) [18 row(s)]
0.0019 0.0437 ( 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.0047 0.0484 ( 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 ) [14 row(s)]
0.0032 0.0516 ( 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.0003 0.0519 ( 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 ) [14 row(s)]
0.0025 0.0544 ( 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.0033 0.0577 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1346' ) [1 row(s)]
0.0029 0.0606 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='479' ) [1 row(s)]
0.0029 0.0635 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1031' ) [1 row(s)]
0.0029 0.0664 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1045' ) [1 row(s)]
0.0029 0.0693 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2839' ) [1 row(s)]
0.0029 0.0722 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1866' ) [1 row(s)]
0.0003 0.0725 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='3139' ) [1 row(s)]
0.0025 0.075 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2376' ) [1 row(s)]
0.0029 0.0779 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='590' ) [1 row(s)]
0.0029 0.0808 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2257' ) [1 row(s)]
0.0039 0.0847 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1510' ) [1 row(s)]
0.0039 0.0886 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2116' ) [1 row(s)]
0.0029 0.0915 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2585' ) [1 row(s)]
0.0039 0.0954 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2644' ) [1 row(s)]
0.0003 0.0957 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='3256' ) [1 row(s)]
0.0035 0.0992 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='3271' ) [1 row(s)]
0.0059 0.1051 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1491' ) [1 row(s)]
0.0039 0.109 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2020' ) [2 row(s)]
0.0009 0.1099 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1740' ) [1 row(s)]
0.0029 0.1128 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1391' ) [1 row(s)]