24 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.0003 0.0017 (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.002 (SELECT * FROM page_details
LEFT JOIN page_content
USING (page_id)
WHERE page_details.page='monarch-migration' AND parent_page=5 AND lang_id='1' AND page_details.live='yes') [0 row(s)] |
| 0.0002 0.0022 (SELECT * FROM cms76_languages WHERE lang_id=1) [1 row(s)] |
| 0.0003 0.0025 (SELECT * FROM cms76_languages WHERE lang_id!=1) [1 row(s)] |
| 0.0003 0.0028 (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.0002 0.003 (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.0033 (SELECT * FROM page_details WHERE page_id='5') [1 row(s)] |
| 0.0003 0.0036 (
SELECT resource_content.title
FROM resources
LEFT JOIN resource_content USING (resource_id)
WHERE resources.language_id='1'
AND resources.slug='monarch-migration'
) [1 row(s)] |
| 0.0003 0.0039 (
SELECT resource_content.description
FROM resources
LEFT JOIN resource_content USING (resource_id)
WHERE resources.language_id='1'
AND resources.slug='monarch-migration'
) [1 row(s)] |
| 0.0002 0.0041 (
SELECT resource_content.title
FROM resources
LEFT JOIN resource_content USING (resource_id)
WHERE resources.language_id='1'
AND resources.slug='monarch-migration'
) [1 row(s)] |
| 0.0004 0.0045 (
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='monarch-migration'
AND resources.live='yes'
GROUP BY resource_content.resource_id
) [1 row(s)] |
| 0.0003 0.0048 (
SELECT
resource_supplier_content.organization,
resource_supplier.website as organization_website
FROM resource_supplier
LEFT JOIN resource_supplier_content ON resource_supplier_content.supplier_id=resource_supplier.supplier_id
WHERE
resource_supplier.supplier_id='87'
AND resource_supplier_content.lang_id = 1
) [1 row(s)] |
| 0.0003 0.0051 (
SELECT compilation_content.compilation_id, compilation_content.title as compilation_title
FROM resource_compilation
LEFT JOIN compilation USING (compilation_id)
LEFT JOIN compilation_content USING (compilation_id)
WHERE resource_compilation.resource_id='2102'
AND compilation.in_sidebar='yes'
AND compilation_content.lang_id='1'
) [4 row(s)] |
| 0.0003 0.0054 (
SELECT
curriculum_audience_content.name as audience
FROM resources
LEFT JOIN resource_curriculum USING (resource_id)
LEFT JOIN curriculum_units ON curriculum_units.curriculum_id=resource_curriculum.curriculum_id
LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id=curriculum_units.audience_id
WHERE
curriculum_audience_content.lang_id='1'
AND resource_curriculum.weight>0
AND resource_curriculum.resource_id='2102'
AND resources.live='yes'
GROUP BY curriculum_units.audience_id
ORDER BY audience
) [4 row(s)] |
| 0.0003 0.0057 (
SELECT
resource_resource_types.type_id as icon
FROM resources
LEFT JOIN resource_resource_types USING (resource_id)
WHERE resource_id='2102'
) [1 row(s)] |
| 0.0004 0.0061 (
SELECT
resource_assessment_questions_content.question_field,
resource_assessment_questions_content.question_short as question,
resource_assessment_questions_content.question as question_long
FROM resource_assessment_questions
LEFT JOIN resource_assessment_questions_content USING (question_field)
WHERE
resource_assessment_questions_content.lang_id='1'
AND resource_assessment_questions_content.question_field like 'resource_assessment.%'
ORDER BY display_order ASC
) [8 row(s)] |
| 0.0003 0.0064 (
SELECT *
FROM resource_assessment
WHERE
resource_id='2102'
) [1 row(s)] |
| 0.0004 0.0068 (
SELECT curriculum_audience_content.name as audience, curriculum_subject_content.name as subject, curriculum_province_content.name as province, GROUP_CONCAT(DISTINCT curriculum_content.title SEPARATOR ';') as units
FROM resources
LEFT JOIN resource_curriculum USING (resource_id)
LEFT JOIN curriculum_units ON curriculum_units.curriculum_id=resource_curriculum.curriculum_id
LEFT JOIN curriculum_content ON curriculum_content.curriculum_id=resource_curriculum.curriculum_id
LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id=curriculum_units.audience_id
LEFT JOIN curriculum_subject_content ON curriculum_subject_content.subject_id=curriculum_units.subject_id
LEFT JOIN curriculum_province_content ON curriculum_province_content.province_id=curriculum_units.province_id
WHERE curriculum_content.lang_id='1'
AND curriculum_audience_content.lang_id='1'
AND curriculum_subject_content.lang_id='1'
AND curriculum_province_content.lang_id='1'
AND resource_curriculum.weight>0
AND resource_curriculum.resource_id='2102'
AND resources.live='yes'
GROUP BY curriculum_units.audience_id,curriculum_units.subject_id,curriculum_units.province_id
ORDER BY province, audience, subject
) [22 row(s)] |
| 0.0003 0.0071 (
SELECT issue_content.issue_id, issue_content.title as issue_title, issues_sub_themes_content.title as theme_title
FROM resources
LEFT JOIN resource_theme ON resource_theme.resource_id=resources.resource_id
LEFT JOIN issues_sub_themes ON issues_sub_themes.theme_id=resource_theme.theme_id
LEFT JOIN issues_sub_themes_content ON issues_sub_themes_content.theme_id=resource_theme.theme_id
LEFT JOIN issue_content ON issue_content.issue_id=issues_sub_themes.issue_id
WHERE issues_sub_themes_content.lang_id='1'
AND issue_content.lang_id='1'
AND resource_theme.resource_id='2102'
AND resources.live='yes'
GROUP BY issues_sub_themes.theme_id
ORDER BY issue_title, theme_title
) [2 row(s)] |
| 0.0002 0.0073 (SELECT review_type FROM resources WHERE resources.resource_id='2102') [1 row(s)] |
| 0.0002 0.0075 (SELECT review_type FROM resources WHERE resources.resource_id='2102') [1 row(s)] |
| 0.0008 0.0083 (
SELECT issue_content.issue_id, issue_content.title as issue_title, issues_sub_themes_content.title as theme_title
FROM resources
LEFT JOIN resource_theme ON resource_theme.resource_id=resources.resource_id
LEFT JOIN issues_sub_themes ON issues_sub_themes.theme_id=resource_theme.theme_id
LEFT JOIN issues_sub_themes_content ON issues_sub_themes_content.theme_id=resource_theme.theme_id
LEFT JOIN issue_content ON issue_content.issue_id=issues_sub_themes.issue_id
WHERE issues_sub_themes_content.lang_id='1'
AND issue_content.lang_id='1'
AND resource_theme.resource_id='2102'
AND resources.live='yes'
GROUP BY issues_sub_themes.issue_id
ORDER BY RAND()
LIMIT 0,5
) [1 row(s)] |
