5.23 ms (43.72%)
|
15 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.section AS section_4, t0.type AS type_5 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters: [
"website_name"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.section AS section_4, t0.type AS type_5 FROM setting t0 WHERE t0.name = 'website_name' LIMIT 1;
|
2.49 ms (20.79%)
|
2 |
SELECT m0_.id AS id_0, m0_.name AS name_1, m1_.id AS id_2, m1_.name AS name_3, m1_.position AS position_4, m1_.url AS url_5, m2_.id AS id_6, m2_.name AS name_7, m2_.position AS position_8, m2_.url AS url_9, p3_.id AS id_10, p3_.title AS title_11, p3_.thumbnail AS thumbnail_12, p3_.seo_title AS seo_title_13, p3_.slug AS slug_14, p3_.brief AS brief_15, p3_.content AS content_16, p3_.created_at AS created_at_17, p3_.updated_at AS updated_at_18, p4_.id AS id_19, p4_.title AS title_20, p4_.thumbnail AS thumbnail_21, p4_.seo_title AS seo_title_22, p4_.slug AS slug_23, p4_.brief AS brief_24, p4_.content AS content_25, p4_.created_at AS created_at_26, p4_.updated_at AS updated_at_27, m1_.menu_id AS menu_id_28, m1_.parent_id AS parent_id_29, m1_.page_id AS page_id_30, m2_.menu_id AS menu_id_31, m2_.parent_id AS parent_id_32, m2_.page_id AS page_id_33 FROM menu m0_ LEFT JOIN menu_item m1_ ON m0_.id = m1_.menu_id LEFT JOIN menu_item m2_ ON m1_.id = m2_.parent_id LEFT JOIN page p3_ ON m1_.page_id = p3_.id LEFT JOIN page p4_ ON m2_.page_id = p4_.id WHERE m0_.name = ? ORDER BY m1_.position ASC, m2_.position ASC
SELECT m0_.id AS id_0, m0_.name AS name_1, m1_.id AS id_2, m1_.name AS name_3, m1_.position AS position_4, m1_.url AS url_5, m2_.id AS id_6, m2_.name AS name_7, m2_.position AS position_8, m2_.url AS url_9, p3_.id AS id_10, p3_.title AS title_11, p3_.thumbnail AS thumbnail_12, p3_.seo_title AS seo_title_13, p3_.slug AS slug_14, p3_.brief AS brief_15, p3_.content AS content_16, p3_.created_at AS created_at_17, p3_.updated_at AS updated_at_18, p4_.id AS id_19, p4_.title AS title_20, p4_.thumbnail AS thumbnail_21, p4_.seo_title AS seo_title_22, p4_.slug AS slug_23, p4_.brief AS brief_24, p4_.content AS content_25, p4_.created_at AS created_at_26, p4_.updated_at AS updated_at_27, m1_.menu_id AS menu_id_28, m1_.parent_id AS parent_id_29, m1_.page_id AS page_id_30, m2_.menu_id AS menu_id_31, m2_.parent_id AS parent_id_32, m2_.page_id AS page_id_33 FROM menu m0_ LEFT JOIN menu_item m1_ ON m0_.id = m1_.menu_id LEFT JOIN menu_item m2_ ON m1_.id = m2_.parent_id LEFT JOIN page p3_ ON m1_.page_id = p3_.id LEFT JOIN page p4_ ON m2_.page_id = p4_.id WHERE m0_.name = 'Header' ORDER BY m1_.position ASC, m2_.position ASC;
|
2.00 ms (16.74%)
|
1 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.brief AS brief_3, p0_.content AS content_4, p0_.source AS source_5, p0_.photo AS photo_6, p0_.seo_title AS seo_title_7, p0_.seo_desc AS seo_desc_8, p0_.published AS published_9, p0_.deleted_at AS deleted_at_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, c1_.id AS id_13, c1_.name AS name_14, c1_.slug AS slug_15, c1_.photo AS photo_16, c1_.description AS description_17, u2_.id AS id_18, u2_.email AS email_19, u2_.roles AS roles_20, u2_.password AS password_21, u2_.name AS name_22, u2_.gender AS gender_23, p0_.created_by_id AS created_by_id_24, c1_.parent_id AS parent_id_25 FROM post p0_ LEFT JOIN post_category p3_ ON p0_.id = p3_.post_id LEFT JOIN category c1_ ON c1_.id = p3_.category_id LEFT JOIN user u2_ ON p0_.created_by_id = u2_.id WHERE p0_.published = 1 AND p0_.slug = ?
Parameters: [
"verification-de-la-verticalite-sur-chantier"
]
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.brief AS brief_3, p0_.content AS content_4, p0_.source AS source_5, p0_.photo AS photo_6, p0_.seo_title AS seo_title_7, p0_.seo_desc AS seo_desc_8, p0_.published AS published_9, p0_.deleted_at AS deleted_at_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, c1_.id AS id_13, c1_.name AS name_14, c1_.slug AS slug_15, c1_.photo AS photo_16, c1_.description AS description_17, u2_.id AS id_18, u2_.email AS email_19, u2_.roles AS roles_20, u2_.password AS password_21, u2_.name AS name_22, u2_.gender AS gender_23, p0_.created_by_id AS created_by_id_24, c1_.parent_id AS parent_id_25 FROM post p0_ LEFT JOIN post_category p3_ ON p0_.id = p3_.post_id LEFT JOIN category c1_ ON c1_.id = p3_.category_id LEFT JOIN user u2_ ON p0_.created_by_id = u2_.id WHERE p0_.published = 1 AND p0_.slug = 'verification-de-la-verticalite-sur-chantier';
|
0.74 ms (6.23%)
|
1 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.brief AS brief_3, p0_.content AS content_4, p0_.source AS source_5, p0_.photo AS photo_6, p0_.seo_title AS seo_title_7, p0_.seo_desc AS seo_desc_8, p0_.published AS published_9, p0_.deleted_at AS deleted_at_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.created_by_id AS created_by_id_13 FROM post p0_ WHERE p0_.updated_at > ? AND p0_.published = 1 ORDER BY p0_.updated_at ASC LIMIT 1
Parameters: [
"2025-08-21 16:27:58"
]
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.brief AS brief_3, p0_.content AS content_4, p0_.source AS source_5, p0_.photo AS photo_6, p0_.seo_title AS seo_title_7, p0_.seo_desc AS seo_desc_8, p0_.published AS published_9, p0_.deleted_at AS deleted_at_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.created_by_id AS created_by_id_13 FROM post p0_ WHERE p0_.updated_at > '2025-08-21 16:27:58' AND p0_.published = 1 ORDER BY p0_.updated_at ASC LIMIT 1;
|
0.54 ms (4.48%)
|
1 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.brief AS brief_3, p0_.content AS content_4, p0_.source AS source_5, p0_.photo AS photo_6, p0_.seo_title AS seo_title_7, p0_.seo_desc AS seo_desc_8, p0_.published AS published_9, p0_.deleted_at AS deleted_at_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.created_by_id AS created_by_id_13 FROM post p0_ WHERE p0_.published = 1 ORDER BY p0_.updated_at DESC LIMIT 5
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.brief AS brief_3, p0_.content AS content_4, p0_.source AS source_5, p0_.photo AS photo_6, p0_.seo_title AS seo_title_7, p0_.seo_desc AS seo_desc_8, p0_.published AS published_9, p0_.deleted_at AS deleted_at_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.created_by_id AS created_by_id_13 FROM post p0_ WHERE p0_.published = 1 ORDER BY p0_.updated_at DESC LIMIT 5;
|
0.48 ms (4.05%)
|
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.photo AS photo_3, c0_.description AS description_4, c0_.parent_id AS parent_id_5 FROM category c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.name ASC
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.photo AS photo_3, c0_.description AS description_4, c0_.parent_id AS parent_id_5 FROM category c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.name ASC;
|
0.48 ms (3.99%)
|
1 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.brief AS brief_3, p0_.content AS content_4, p0_.source AS source_5, p0_.photo AS photo_6, p0_.seo_title AS seo_title_7, p0_.seo_desc AS seo_desc_8, p0_.published AS published_9, p0_.deleted_at AS deleted_at_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.created_by_id AS created_by_id_13 FROM post p0_ WHERE p0_.updated_at < ? AND p0_.published = 1 ORDER BY p0_.updated_at DESC LIMIT 1
Parameters: [
"2025-08-21 16:27:58"
]
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.brief AS brief_3, p0_.content AS content_4, p0_.source AS source_5, p0_.photo AS photo_6, p0_.seo_title AS seo_title_7, p0_.seo_desc AS seo_desc_8, p0_.published AS published_9, p0_.deleted_at AS deleted_at_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.created_by_id AS created_by_id_13 FROM post p0_ WHERE p0_.updated_at < '2025-08-21 16:27:58' AND p0_.published = 1 ORDER BY p0_.updated_at DESC LIMIT 1;
|