42 total queries
(query time) (total time) (query)
0.0021 0.0021 (SET NAMES 'utf8')
0.0005 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.0004 0.003 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page='search' AND parent_page=1 AND lang_id='2' AND page_details.live='yes') [0 row(s)]
0.0046 0.0076 (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.0015 0.0091 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page='' AND parent_page=4 AND lang_id='2' AND page_details.live='yes') [0 row(s)]
0.0004 0.0095 (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.0016 0.0111 (SELECT * FROM cms76_languages WHERE lang_id=2) [1 row(s)]
0,0029 0,014 (SELECT * FROM cms76_languages WHERE lang_id!=2) [1 row(s)]
0,0003 0,0143 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page_id='4' AND lang_id='2' AND page_details.live='yes') [0 row(s)]
0,0003 0,0146 (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,0014 0,016 (SELECT * FROM cms76_modules LEFT JOIN page_includes USING (module_id) WHERE page_id=4 ORDER BY page_order) [2 row(s)]
0,0003 0,0163 (SELECT * FROM page_details WHERE page_id='4') [1 row(s)]
0,0003 0,0166 ( 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,0003 0,0169 ( 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 ) [14 row(s)]
0,0002 0,0171 ( 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,0002 0,0173 ( 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='2' AND resources.live='yes' ) [6 row(s)]
0,001 0,0183 ( SELECT sdg_content.sdg_id as id, sdg_content.title FROM sdg_content WHERE sdg_content.lang_id='2' ORDER BY sdg_content.sdg_id ASC ) [18 row(s)]
0,0003 0,0186 ( 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,0003 0,0189 ( 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 ) [14 row(s)]
0,0003 0,0192 ( 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,0003 0,0195 ( 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 ) [14 row(s)]
0,0003 0,0198 ( 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,0016 0,0214 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1461' ) [1 row(s)]
0,0003 0,0217 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='3230' ) [1 row(s)]
0,0003 0,022 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1380' ) [1 row(s)]
0,0003 0,0223 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='381' ) [1 row(s)]
0,0002 0,0225 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2680' ) [1 row(s)]
0,0002 0,0227 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1934' ) [1 row(s)]
0,0012 0,0239 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2835' ) [1 row(s)]
0,0003 0,0242 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2855' ) [1 row(s)]
0,0003 0,0245 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2462' ) [1 row(s)]
0,0003 0,0248 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1539' ) [1 row(s)]
0,0003 0,0251 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='3236' ) [1 row(s)]
0,0003 0,0254 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1197' ) [1 row(s)]
0,0016 0,027 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2858' ) [1 row(s)]
0,0003 0,0273 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1880' ) [1 row(s)]
0,0003 0,0276 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2692' ) [1 row(s)]
0,0003 0,0279 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2169' ) [1 row(s)]
0,0003 0,0282 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1706' ) [1 row(s)]
0,0003 0,0285 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1707' ) [1 row(s)]
0,0019 0,0304 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1520' ) [1 row(s)]
0,0003 0,0307 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='3234' ) [1 row(s)]