Search for Resources
13 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.0003 0.0011 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page='resource' AND parent_page=1 AND lang_id='1' AND page_details.live='yes') [1 row(s)]
0.0003 0.0014 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page='the-corporation-resources-for-classroom-teachers' AND parent_page=5 AND lang_id='1' AND page_details.live='yes') [0 row(s)]
0.0002 0.0016 (SELECT * FROM cms76_languages WHERE lang_id=1) [1 row(s)]
0.0003 0.0019 (SELECT * FROM cms76_languages WHERE lang_id!=1) [1 row(s)]
0.0003 0.0022 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page_id='5' AND lang_id='1' AND page_details.live='yes') [1 row(s)]
0.0003 0.0025 (SELECT * FROM cms76_modules LEFT JOIN page_includes USING (module_id) WHERE page_id=5 ORDER BY page_order) [1 row(s)]
0.0003 0.0028 (SELECT * FROM page_details WHERE page_id='5') [1 row(s)]
0.0002 0.003 ( SELECT resource_content.title FROM resources LEFT JOIN resource_content USING (resource_id) WHERE resources.language_id='1' AND resources.slug='the-corporation-resources-for-classroom-teachers' ) [1 row(s)]
0.0003 0.0033 ( SELECT resource_content.description FROM resources LEFT JOIN resource_content USING (resource_id) WHERE resources.language_id='1' AND resources.slug='the-corporation-resources-for-classroom-teachers' ) [1 row(s)]
0.0002 0.0035 ( SELECT resource_content.title FROM resources LEFT JOIN resource_content USING (resource_id) WHERE resources.language_id='1' AND resources.slug='the-corporation-resources-for-classroom-teachers' ) [1 row(s)]
0.0004 0.0039 ( SELECT resources.resource_id, resources.*, resource_content.* FROM resources LEFT JOIN resource_content USING (resource_id) LEFT JOIN resource_curriculum ON resource_curriculum.resource_id=resources.resource_id LEFT JOIN curriculum_units ON curriculum_units.curriculum_id=resource_curriculum.curriculum_id WHERE resources.language_id='1' AND resources.slug='the-corporation-resources-for-classroom-teachers' AND resources.live='yes' GROUP BY resource_content.resource_id ) [0 row(s)]