2.26 ms (21.42%)
|
1 |
SELECT b0_.id AS id_0, b0_.is_enable AS is_enable_1, b0_.position AS position_2, b0_.is_public AS is_public_3, b0_.created_at AS created_at_4, b0_.updated_at AS updated_at_5, b0_.publication_at AS publication_at_6, b1_.name AS name_7, b1_.slug AS slug_8, b2_.id AS id_9, b3_.name AS name_10 FROM brand b0_ LEFT JOIN brand_lang b1_ ON b0_.id = b1_.brand_id AND (b1_.language_id = ?) LEFT JOIN brand_type b2_ ON b0_.brand_type_id = b2_.id LEFT JOIN brand_type_lang b3_ ON b2_.id = b3_.brand_type_id AND (b3_.language_id = ?) WHERE b0_.deleted_at IS NULL AND b0_.draft_id IS NULL AND b0_.is_enable = ? AND b0_.publication_at <= ? ORDER BY b2_.id ASC, name_7 ASC
Parameters: [
3
3
1
"2024-11-25 17:44:51"
]
SELECT b0_.id AS id_0, b0_.is_enable AS is_enable_1, b0_.position AS position_2, b0_.is_public AS is_public_3, b0_.created_at AS created_at_4, b0_.updated_at AS updated_at_5, b0_.publication_at AS publication_at_6, b1_.name AS name_7, b1_.slug AS slug_8, b2_.id AS id_9, b3_.name AS name_10 FROM brand b0_ LEFT JOIN brand_lang b1_ ON b0_.id = b1_.brand_id AND (b1_.language_id = 3) LEFT JOIN brand_type b2_ ON b0_.brand_type_id = b2_.id LEFT JOIN brand_type_lang b3_ ON b2_.id = b3_.brand_type_id AND (b3_.language_id = 3) WHERE b0_.deleted_at IS NULL AND b0_.draft_id IS NULL AND b0_.is_enable = 1 AND b0_.publication_at <= '2024-11-25 17:44:51' ORDER BY b2_.id ASC, name_7 ASC;
|
2.15 ms (20.35%)
|
1 |
SELECT b0_.id AS id_0, b0_.position AS position_1, b0_.is_public AS is_public_2, b0_.is_enable AS is_enable_3, b0_.is_show_in_mosaic AS is_show_in_mosaic_4, b0_.publication_at AS publication_at_5, b0_.deleted_at AS deleted_at_6, b0_.created_at AS created_at_7, b0_.updated_at AS updated_at_8, b1_.id AS id_9, b1_.slug AS slug_10, b1_.name AS name_11, b1_.presentation AS presentation_12, b1_.presentation_public AS presentation_public_13, b1_.description AS description_14, b1_.description_public AS description_public_15, b0_.brand_type_id AS brand_type_id_16, b0_.draft_id AS draft_id_17, b1_.language_id AS language_id_18, b1_.brand_id AS brand_id_19 FROM brand b0_ LEFT JOIN brand_lang b1_ ON b0_.id = b1_.brand_id AND (b1_.language_id = ?) WHERE b0_.deleted_at IS NULL AND b0_.is_enable = ? AND b0_.publication_at <= ? ORDER BY b1_.name ASC
Parameters: [
3
1
"2024-11-25 17:44:51"
]
SELECT b0_.id AS id_0, b0_.position AS position_1, b0_.is_public AS is_public_2, b0_.is_enable AS is_enable_3, b0_.is_show_in_mosaic AS is_show_in_mosaic_4, b0_.publication_at AS publication_at_5, b0_.deleted_at AS deleted_at_6, b0_.created_at AS created_at_7, b0_.updated_at AS updated_at_8, b1_.id AS id_9, b1_.slug AS slug_10, b1_.name AS name_11, b1_.presentation AS presentation_12, b1_.presentation_public AS presentation_public_13, b1_.description AS description_14, b1_.description_public AS description_public_15, b0_.brand_type_id AS brand_type_id_16, b0_.draft_id AS draft_id_17, b1_.language_id AS language_id_18, b1_.brand_id AS brand_id_19 FROM brand b0_ LEFT JOIN brand_lang b1_ ON b0_.id = b1_.brand_id AND (b1_.language_id = 3) WHERE b0_.deleted_at IS NULL AND b0_.is_enable = 1 AND b0_.publication_at <= '2024-11-25 17:44:51' ORDER BY b1_.name ASC;
|
1.62 ms (15.33%)
|
1 |
SELECT b0_.id AS id_0, b1_.name AS name_1, b1_.slug AS slug_2, b2_.id AS id_3, b3_.name AS name_4 FROM brand b0_ LEFT JOIN brand_lang b1_ ON b0_.id = b1_.brand_id AND (b1_.language_id = ?) LEFT JOIN brand_type b2_ ON b0_.brand_type_id = b2_.id LEFT JOIN brand_type_lang b3_ ON b2_.id = b3_.brand_type_id AND (b3_.language_id = ?) WHERE b0_.deleted_at IS NULL AND b0_.is_enable = ? AND b0_.publication_at <= ? AND b0_.is_public = 1 ORDER BY b2_.id ASC, b0_.position ASC, b1_.name ASC
Parameters: [
3
3
1
"2024-11-25 17:44:51"
]
SELECT b0_.id AS id_0, b1_.name AS name_1, b1_.slug AS slug_2, b2_.id AS id_3, b3_.name AS name_4 FROM brand b0_ LEFT JOIN brand_lang b1_ ON b0_.id = b1_.brand_id AND (b1_.language_id = 3) LEFT JOIN brand_type b2_ ON b0_.brand_type_id = b2_.id LEFT JOIN brand_type_lang b3_ ON b2_.id = b3_.brand_type_id AND (b3_.language_id = 3) WHERE b0_.deleted_at IS NULL AND b0_.is_enable = 1 AND b0_.publication_at <= '2024-11-25 17:44:51' AND b0_.is_public = 1 ORDER BY b2_.id ASC, b0_.position ASC, b1_.name ASC;
|
1.44 ms (13.66%)
|
1 |
SELECT m0_.id AS id_0, m0_.position AS position_1, m0_.is_enable AS is_enable_2, l1_.id AS id_3, m0_.title AS title_4, p2_.slug AS slug_5, m0_.page_statique AS page_statique_6, m0_.type AS type_7, c3_.slug AS slug_8, p4_.id AS id_9 FROM menu m0_ LEFT JOIN page p4_ ON m0_.page_id = p4_.id LEFT JOIN page_lang p2_ ON p4_.id = p2_.page_id AND (p2_.language_id = ?) LEFT JOIN category c5_ ON m0_.category_id = c5_.id LEFT JOIN category_lang c3_ ON c5_.id = c3_.category_id AND (c3_.language_id = ?) LEFT JOIN language l1_ ON m0_.language_id = l1_.id WHERE m0_.deleted_at IS NULL AND l1_.id = ? AND m0_.is_enable = ? ORDER BY m0_.position ASC
Parameters: [
3
3
3
"1"
]
SELECT m0_.id AS id_0, m0_.position AS position_1, m0_.is_enable AS is_enable_2, l1_.id AS id_3, m0_.title AS title_4, p2_.slug AS slug_5, m0_.page_statique AS page_statique_6, m0_.type AS type_7, c3_.slug AS slug_8, p4_.id AS id_9 FROM menu m0_ LEFT JOIN page p4_ ON m0_.page_id = p4_.id LEFT JOIN page_lang p2_ ON p4_.id = p2_.page_id AND (p2_.language_id = 3) LEFT JOIN category c5_ ON m0_.category_id = c5_.id LEFT JOIN category_lang c3_ ON c5_.id = c3_.category_id AND (c3_.language_id = 3) LEFT JOIN language l1_ ON m0_.language_id = l1_.id WHERE m0_.deleted_at IS NULL AND l1_.id = 3 AND m0_.is_enable = '1' ORDER BY m0_.position ASC;
|
0.96 ms (9.15%)
|
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.presentation AS presentation_3, p0_.description AS description_4, p0_.is_enable AS is_enable_5, p0_.publication_at AS publication_at_6, p0_.language_id AS language_id_7, p0_.page_id AS page_id_8 FROM page_lang p0_ WHERE p0_.language_id = ? AND p0_.page_id = ?
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.presentation AS presentation_3, p0_.description AS description_4, p0_.is_enable AS is_enable_5, p0_.publication_at AS publication_at_6, p0_.language_id AS language_id_7, p0_.page_id AS page_id_8 FROM page_lang p0_ WHERE p0_.language_id = 3 AND p0_.page_id = '3';
|
0.89 ms (8.44%)
|
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.route AS route_3, t0.parameter AS parameter_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.no_index AS no_index_7, t0.language_id AS language_id_8 FROM seo t0 WHERE t0.language_id = ? AND t0.parameter IS NULL AND t0.route = ? LIMIT 1
Parameters: [
3
"app_registration"
]
SELECT t0.id AS id_1, t0.title AS title_2, t0.route AS route_3, t0.parameter AS parameter_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.no_index AS no_index_7, t0.language_id AS language_id_8 FROM seo t0 WHERE t0.language_id = 3 AND t0.parameter IS NULL AND t0.route = 'app_registration' LIMIT 1;
|
0.69 ms (6.54%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_enable AS is_enable_4, t0.is_default AS is_default_5 FROM language t0 WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_enable AS is_enable_4, t0.is_default AS is_default_5 FROM language t0 WHERE t0.code = 'fr' LIMIT 1;
|
0.54 ms (5.10%)
|
1 |
SELECT t0.id AS id_1, t0.is_public AS is_public_2, t0.is_show_front_connect AS is_show_front_connect_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.category_id AS category_id_7, t0.draft_id AS draft_id_8 FROM page t0 WHERE t0.id IN (?)
SELECT t0.id AS id_1, t0.is_public AS is_public_2, t0.is_show_front_connect AS is_show_front_connect_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.category_id AS category_id_7, t0.draft_id AS draft_id_8 FROM page t0 WHERE t0.id IN (3);
|