0.60 ms (8.61%)
|
1 |
SELECT p0_.id AS id_0, p0_.is_home AS is_home_1, p0_.privacy AS privacy_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p1_.id AS id_5, p1_.title AS title_6, p1_.slug AS slug_7, p1_.description AS description_8, p1_.keywords AS keywords_9, p1_.locale AS locale_10, t2_.id AS id_11, t2_.name AS name_12, t2_.filename AS filename_13, t3_.id AS id_14, t3_.position AS position_15, f4_.id AS id_16, f4_.collection_id AS collection_id_17, f4_.locale AS locale_18, f4_.value AS value_19, f4_.updated_at AS updated_at_20, f5_.id AS id_21, f5_.name AS name_22, f5_.identifier AS identifier_23, f5_.required AS required_24, f5_.position AS position_25, f6_.id AS id_26, f6_.name AS name_27, f6_.slug AS slug_28, f7_.id AS id_29, f7_.name AS name_30, f7_.value AS value_31, f7_.position AS position_32, p0_.template_id AS template_id_33, p1_.page_id AS page_id_34, t3_.template_id AS template_id_35, t3_.block_id AS block_id_36, f4_.page_id AS page_id_37, f4_.field_id AS field_id_38, f4_.parent_id AS parent_id_39, f5_.type_id AS type_id_40, f5_.block_id AS block_id_41, f5_.parent_id AS parent_id_42, f6_.parent_id AS parent_id_43, f7_.field_id AS field_id_44 FROM page p0_ LEFT JOIN page_meta p1_ ON p0_.id = p1_.page_id AND (p1_.locale = ?) LEFT JOIN template t2_ ON p0_.template_id = t2_.id LEFT JOIN template_block t3_ ON t2_.id = t3_.template_id LEFT JOIN field_value f4_ ON p0_.id = f4_.page_id AND (f4_.locale = ?) LEFT JOIN field f5_ ON f4_.field_id = f5_.id LEFT JOIN field_category f6_ ON f5_.type_id = f6_.id LEFT JOIN field_option f7_ ON f5_.id = f7_.field_id WHERE p0_.is_home = ?
Parameters: [
"fr"
"fr"
1
]
SELECT
p0_.id AS id_0,
p0_.is_home AS is_home_1,
p0_.privacy AS privacy_2,
p0_.created_at AS created_at_3,
p0_.updated_at AS updated_at_4,
p1_.id AS id_5,
p1_.title AS title_6,
p1_.slug AS slug_7,
p1_.description AS description_8,
p1_.keywords AS keywords_9,
p1_.locale AS locale_10,
t2_.id AS id_11,
t2_.name AS name_12,
t2_.filename AS filename_13,
t3_.id AS id_14,
t3_.position AS position_15,
f4_.id AS id_16,
f4_.collection_id AS collection_id_17,
f4_.locale AS locale_18,
f4_.value AS value_19,
f4_.updated_at AS updated_at_20,
f5_.id AS id_21,
f5_.name AS name_22,
f5_.identifier AS identifier_23,
f5_.required AS required_24,
f5_.position AS position_25,
f6_.id AS id_26,
f6_.name AS name_27,
f6_.slug AS slug_28,
f7_.id AS id_29,
f7_.name AS name_30,
f7_.value AS value_31,
f7_.position AS position_32,
p0_.template_id AS template_id_33,
p1_.page_id AS page_id_34,
t3_.template_id AS template_id_35,
t3_.block_id AS block_id_36,
f4_.page_id AS page_id_37,
f4_.field_id AS field_id_38,
f4_.parent_id AS parent_id_39,
f5_.type_id AS type_id_40,
f5_.block_id AS block_id_41,
f5_.parent_id AS parent_id_42,
f6_.parent_id AS parent_id_43,
f7_.field_id AS field_id_44
FROM
page p0_
LEFT JOIN page_meta p1_ ON p0_.id = p1_.page_id
AND (p1_.locale = ?)
LEFT JOIN template t2_ ON p0_.template_id = t2_.id
LEFT JOIN template_block t3_ ON t2_.id = t3_.template_id
LEFT JOIN field_value f4_ ON p0_.id = f4_.page_id
AND (f4_.locale = ?)
LEFT JOIN field f5_ ON f4_.field_id = f5_.id
LEFT JOIN field_category f6_ ON f5_.type_id = f6_.id
LEFT JOIN field_option f7_ ON f5_.id = f7_.field_id
WHERE
p0_.is_home = ?
SELECT p0_.id AS id_0, p0_.is_home AS is_home_1, p0_.privacy AS privacy_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p1_.id AS id_5, p1_.title AS title_6, p1_.slug AS slug_7, p1_.description AS description_8, p1_.keywords AS keywords_9, p1_.locale AS locale_10, t2_.id AS id_11, t2_.name AS name_12, t2_.filename AS filename_13, t3_.id AS id_14, t3_.position AS position_15, f4_.id AS id_16, f4_.collection_id AS collection_id_17, f4_.locale AS locale_18, f4_.value AS value_19, f4_.updated_at AS updated_at_20, f5_.id AS id_21, f5_.name AS name_22, f5_.identifier AS identifier_23, f5_.required AS required_24, f5_.position AS position_25, f6_.id AS id_26, f6_.name AS name_27, f6_.slug AS slug_28, f7_.id AS id_29, f7_.name AS name_30, f7_.value AS value_31, f7_.position AS position_32, p0_.template_id AS template_id_33, p1_.page_id AS page_id_34, t3_.template_id AS template_id_35, t3_.block_id AS block_id_36, f4_.page_id AS page_id_37, f4_.field_id AS field_id_38, f4_.parent_id AS parent_id_39, f5_.type_id AS type_id_40, f5_.block_id AS block_id_41, f5_.parent_id AS parent_id_42, f6_.parent_id AS parent_id_43, f7_.field_id AS field_id_44 FROM page p0_ LEFT JOIN page_meta p1_ ON p0_.id = p1_.page_id AND (p1_.locale = 'fr') LEFT JOIN template t2_ ON p0_.template_id = t2_.id LEFT JOIN template_block t3_ ON t2_.id = t3_.template_id LEFT JOIN field_value f4_ ON p0_.id = f4_.page_id AND (f4_.locale = 'fr') LEFT JOIN field f5_ ON f4_.field_id = f5_.id LEFT JOIN field_category f6_ ON f5_.type_id = f6_.id LEFT JOIN field_option f7_ ON f5_.id = f7_.field_id WHERE p0_.is_home = 1;
|
0.25 ms (3.53%)
|
1 |
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.location AS location_2, m1_.id AS id_3, m1_.type AS type_4, m1_.label AS label_5, m1_.url AS url_6, m1_.locale AS locale_7, m1_.position AS position_8, m2_.id AS id_9, m2_.type AS type_10, m2_.label AS label_11, m2_.url AS url_12, m2_.locale AS locale_13, m2_.position AS position_14, m1_.menu_id AS menu_id_15, m1_.parent_id AS parent_id_16, m2_.menu_id AS menu_id_17, m2_.parent_id AS parent_id_18 FROM menu m0_ LEFT JOIN menu_link m1_ ON m0_.id = m1_.menu_id AND (m1_.locale = ?) LEFT JOIN menu_link m2_ ON m1_.id = m2_.parent_id AND (m2_.locale = ?) WHERE m1_.parent_id IS NULL ORDER BY m1_.position ASC, m2_.position ASC
Parameters: [
"fr"
"fr"
]
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.location AS location_2, m1_.id AS id_3, m1_.type AS type_4, m1_.label AS label_5, m1_.url AS url_6, m1_.locale AS locale_7, m1_.position AS position_8, m2_.id AS id_9, m2_.type AS type_10, m2_.label AS label_11, m2_.url AS url_12, m2_.locale AS locale_13, m2_.position AS position_14, m1_.menu_id AS menu_id_15, m1_.parent_id AS parent_id_16, m2_.menu_id AS menu_id_17, m2_.parent_id AS parent_id_18 FROM menu m0_ LEFT JOIN menu_link m1_ ON m0_.id = m1_.menu_id AND (m1_.locale = 'fr') LEFT JOIN menu_link m2_ ON m1_.id = m2_.parent_id AND (m2_.locale = 'fr') WHERE m1_.parent_id IS NULL ORDER BY m1_.position ASC, m2_.position ASC;
|