| 1 |
0.80 ms |
SELECT e0_.id AS id_0, e0_.code AS code_1, e0_.name AS name_2, e0_.slug AS slug_3, e0_.short_description AS short_description_4, e0_.icon AS icon_5, e0_.tone_color AS tone_color_6, e0_.enabled AS enabled_7, e0_.position AS position_8 FROM environmental_objective e0_ WHERE e0_.enabled = 1 ORDER BY e0_.position ASC
SELECT e0_.id AS id_0, e0_.code AS code_1, e0_.name AS name_2, e0_.slug AS slug_3, e0_.short_description AS short_description_4, e0_.icon AS icon_5, e0_.tone_color AS tone_color_6, e0_.enabled AS enabled_7, e0_.position AS position_8 FROM environmental_objective e0_ WHERE e0_.enabled = 1 ORDER BY e0_.position ASC;
|
| 2 |
5.67 ms |
SELECT a0_.id AS id_0, a0_.public_id AS public_id_1, a0_.title AS title_2, a0_.sl_no AS sl_no_3, a0_.business_model AS business_model_4, a0_.published AS published_5, a0_.position AS position_6, s1_.id AS id_7, s1_.name AS name_8, s1_.position AS position_9, a2_.id AS id_10, a2_.in_scope AS in_scope_11, a2_.has_green AS has_green_12, a2_.has_amber AS has_amber_13, a2_.has_red AS has_red_14, a2_.tsc_heading AS tsc_heading_15, e3_.id AS id_16, e3_.code AS code_17, e3_.name AS name_18, e3_.slug AS slug_19, e3_.short_description AS short_description_20, e3_.icon AS icon_21, e3_.tone_color AS tone_color_22, e3_.enabled AS enabled_23, e3_.position AS position_24, a0_.sector_id AS sector_id_25, a2_.activity_id AS activity_id_26, a2_.objective_id AS objective_id_27 FROM activity a0_ INNER JOIN sector s1_ ON a0_.sector_id = s1_.id INNER JOIN activity_objective a2_ ON a0_.id = a2_.activity_id INNER JOIN environmental_objective e3_ ON a2_.objective_id = e3_.id WHERE e3_.enabled = 1 AND a0_.published = 1 ORDER BY a0_.position ASC, a0_.title ASC
SELECT a0_.id AS id_0, a0_.public_id AS public_id_1, a0_.title AS title_2, a0_.sl_no AS sl_no_3, a0_.business_model AS business_model_4, a0_.published AS published_5, a0_.position AS position_6, s1_.id AS id_7, s1_.name AS name_8, s1_.position AS position_9, a2_.id AS id_10, a2_.in_scope AS in_scope_11, a2_.has_green AS has_green_12, a2_.has_amber AS has_amber_13, a2_.has_red AS has_red_14, a2_.tsc_heading AS tsc_heading_15, e3_.id AS id_16, e3_.code AS code_17, e3_.name AS name_18, e3_.slug AS slug_19, e3_.short_description AS short_description_20, e3_.icon AS icon_21, e3_.tone_color AS tone_color_22, e3_.enabled AS enabled_23, e3_.position AS position_24, a0_.sector_id AS sector_id_25, a2_.activity_id AS activity_id_26, a2_.objective_id AS objective_id_27 FROM activity a0_ INNER JOIN sector s1_ ON a0_.sector_id = s1_.id INNER JOIN activity_objective a2_ ON a0_.id = a2_.activity_id INNER JOIN environmental_objective e3_ ON a2_.objective_id = e3_.id WHERE e3_.enabled = 1 AND a0_.published = 1 ORDER BY a0_.position ASC, a0_.title ASC;
|
| 3 |
1.00 ms |
SELECT n0_.id AS id_0, n0_.location AS location_1, n0_.label AS label_2, n0_.url AS url_3, n0_.published AS published_4, n0_.position AS position_5, p1_.id AS id_6, p1_.label AS label_7, p1_.file_name AS file_name_8, p1_.file_path AS file_path_9, p1_.published AS published_10, p1_.position AS position_11, n0_.pdf_document_id AS pdf_document_id_12 FROM navigation_item n0_ LEFT JOIN pdf_document p1_ ON n0_.pdf_document_id = p1_.id WHERE n0_.location = ? AND n0_.published = 1 ORDER BY n0_.position ASC
Parameters: [
"navbar_docs"
]
SELECT n0_.id AS id_0, n0_.location AS location_1, n0_.label AS label_2, n0_.url AS url_3, n0_.published AS published_4, n0_.position AS position_5, p1_.id AS id_6, p1_.label AS label_7, p1_.file_name AS file_name_8, p1_.file_path AS file_path_9, p1_.published AS published_10, p1_.position AS position_11, n0_.pdf_document_id AS pdf_document_id_12 FROM navigation_item n0_ LEFT JOIN pdf_document p1_ ON n0_.pdf_document_id = p1_.id WHERE n0_.location = 'navbar_docs' AND n0_.published = 1 ORDER BY n0_.position ASC;
|
| 5 |
0.95 ms |
SELECT n0_.id AS id_0, n0_.location AS location_1, n0_.label AS label_2, n0_.url AS url_3, n0_.published AS published_4, n0_.position AS position_5, p1_.id AS id_6, p1_.label AS label_7, p1_.file_name AS file_name_8, p1_.file_path AS file_path_9, p1_.published AS published_10, p1_.position AS position_11, n0_.pdf_document_id AS pdf_document_id_12 FROM navigation_item n0_ LEFT JOIN pdf_document p1_ ON n0_.pdf_document_id = p1_.id WHERE n0_.location = ? AND n0_.published = 1 ORDER BY n0_.position ASC
Parameters: [
"footer_legal"
]
SELECT n0_.id AS id_0, n0_.location AS location_1, n0_.label AS label_2, n0_.url AS url_3, n0_.published AS published_4, n0_.position AS position_5, p1_.id AS id_6, p1_.label AS label_7, p1_.file_name AS file_name_8, p1_.file_path AS file_path_9, p1_.published AS published_10, p1_.position AS position_11, n0_.pdf_document_id AS pdf_document_id_12 FROM navigation_item n0_ LEFT JOIN pdf_document p1_ ON n0_.pdf_document_id = p1_.id WHERE n0_.location = 'footer_legal' AND n0_.published = 1 ORDER BY n0_.position ASC;
|
| 6 |
0.65 ms |
SELECT n0_.id AS id_0, n0_.location AS location_1, n0_.label AS label_2, n0_.url AS url_3, n0_.published AS published_4, n0_.position AS position_5, p1_.id AS id_6, p1_.label AS label_7, p1_.file_name AS file_name_8, p1_.file_path AS file_path_9, p1_.published AS published_10, p1_.position AS position_11, n0_.pdf_document_id AS pdf_document_id_12 FROM navigation_item n0_ LEFT JOIN pdf_document p1_ ON n0_.pdf_document_id = p1_.id WHERE n0_.location = ? AND n0_.published = 1 ORDER BY n0_.position ASC
Parameters: [
"footer_quick_links"
]
SELECT n0_.id AS id_0, n0_.location AS location_1, n0_.label AS label_2, n0_.url AS url_3, n0_.published AS published_4, n0_.position AS position_5, p1_.id AS id_6, p1_.label AS label_7, p1_.file_name AS file_name_8, p1_.file_path AS file_path_9, p1_.published AS published_10, p1_.position AS position_11, n0_.pdf_document_id AS pdf_document_id_12 FROM navigation_item n0_ LEFT JOIN pdf_document p1_ ON n0_.pdf_document_id = p1_.id WHERE n0_.location = 'footer_quick_links' AND n0_.published = 1 ORDER BY n0_.position ASC;
|