Premières étapes
46 total queries
(query time) (total time) (query)
0.0011 0.0011 (SET NAMES 'utf8')
0.0003 0.0014 ( 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.0005 0.0019 (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.0004 0.0023 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page='nature-guides-archive' AND parent_page=50 AND lang_id='2' AND page_details.live='yes') [1 row(s)]
0.0003 0.0026 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page='page' AND parent_page=155 AND lang_id='2' AND page_details.live='yes') [0 row(s)]
0.0004 0.003 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page='page' AND parent_page=155 AND lang_id='1' AND page_details.live='yes') [0 row(s)]
0.0007 0.0037 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page='early-october-2020' AND parent_page=155 AND lang_id='2' AND page_details.live='yes') [0 row(s)]
0.0006 0.0043 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page='early-october-2020' AND parent_page=155 AND lang_id='1' AND page_details.live='yes') [0 row(s)]
0.0003 0.0046 (SELECT * FROM cms76_languages WHERE lang_id=2) [1 row(s)]
0,0003 0,0049 (SELECT * FROM cms76_languages WHERE lang_id!=2) [1 row(s)]
0,0003 0,0052 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page_id='155' AND lang_id='2' AND page_details.live='yes') [1 row(s)]
0,0003 0,0055 (SELECT * FROM cms76_modules LEFT JOIN page_includes USING (module_id) WHERE page_id=155 ORDER BY page_order) [3 row(s)]
0,0004 0,0059 (SELECT * FROM page_details WHERE page_id='155') [1 row(s)]
0,0004 0,0063 (SELECT * FROM page_details WHERE page_id='50') [1 row(s)]
0,0004 0,0067 ( 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 ) [7 row(s)]
0,0016 0,0083 ( 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,0004 0,0087 ( 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='195' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [5 row(s)]
0,0002 0,0089 ( 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='225' 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,0091 ( 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='223' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0,0003 0,0094 ( 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='245' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0,0016 0,011 ( 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='253' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0,0003 0,0113 ( 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='282' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0,0003 0,0116 ( 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,0003 0,0119 ( 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,0003 0,0122 ( 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,0003 0,0125 ( 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,0016 0,0141 ( 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,0003 0,0144 ( 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='28' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [6 row(s)]
0,0003 0,0147 ( 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='178' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0,0003 0,015 ( 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='179' 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,0152 ( 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='180' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0,004 0,0192 ( 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='181' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0,0003 0,0195 ( 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='182' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0,0003 0,0198 ( 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='183' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0,0003 0,0201 (SELECT path FROM page_details WHERE page_id = 50) [1 row(s)]
0,0003 0,0204 (SELECT path FROM page_details WHERE page_id = 50) [1 row(s)]
0,0017 0,0221 ( 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 ) [5 row(s)]
0,0003 0,0224 ( 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,0227 ( 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,0003 0,023 ( 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,0233 ( 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,0008 0,0241 ( 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,0013 0,0254 ( 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,0003 0,0257 ( 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,026 ( 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,0004 0,0264 (SELECT * FROM page_details LEFT JOIN page_content ON page_content.page_id = page_details.page_id WHERE page = 'early-october-2020' AND page_details.live = 'yes' AND lang_id = 2 AND page_details.live='yes') [0 row(s)]