| 1 |
1.11 ms |
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = ? ORDER BY c4_.sort_order DESC, c5_.sort_order DESC
Parameters: [0 => 24]
SELECT
c0_.id AS id_0,
c0_.lft AS lft_1,
c0_.lvl AS lvl_2,
c0_.rgt AS rgt_3,
c0_.root AS root_4,
c0_.created_at AS created_at_5,
c0_.updated_at AS updated_at_6,
c0_.deleted_at AS deleted_at_7,
c0_.active AS active_8,
c1_.id AS id_9,
c1_.name AS name_10,
c1_.metaTitle AS metaTitle_11,
c1_.sort_order AS sort_order_12,
c1_.created_at AS created_at_13,
c1_.updated_at AS updated_at_14,
c1_.deleted_at AS deleted_at_15,
c1_.culture AS culture_16,
c2_.id AS id_17,
c2_.lft AS lft_18,
c2_.lvl AS lvl_19,
c2_.rgt AS rgt_20,
c2_.root AS root_21,
c2_.created_at AS created_at_22,
c2_.updated_at AS updated_at_23,
c2_.deleted_at AS deleted_at_24,
c2_.active AS active_25,
c3_.id AS id_26,
c3_.name AS name_27,
c3_.metaTitle AS metaTitle_28,
c3_.sort_order AS sort_order_29,
c3_.created_at AS created_at_30,
c3_.updated_at AS updated_at_31,
c3_.deleted_at AS deleted_at_32,
c3_.culture AS culture_33,
c4_.id AS id_34,
c4_.sort_order AS sort_order_35,
c5_.id AS id_36,
c5_.sort_order AS sort_order_37,
c0_.parent_id AS parent_id_38,
c1_.category_id AS category_id_39,
c1_.langage_id AS langage_id_40,
c2_.parent_id AS parent_id_41,
c3_.category_id AS category_id_42,
c3_.langage_id AS langage_id_43,
c4_.category_translation_id AS category_translation_id_44,
c4_.carac_id AS carac_id_45,
c5_.category_translation_id AS category_translation_id_46,
c5_.carac_id AS carac_id_47
FROM
category c0_
LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id
LEFT JOIN category c2_ ON c0_.parent_id = c2_.id
LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id
LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id
LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id
WHERE
c0_.id = ?
ORDER BY
c4_.sort_order DESC,
c5_.sort_order DESC
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = 24 ORDER BY c4_.sort_order DESC, c5_.sort_order DESC;
|
| 2 |
1.07 ms |
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = ? ORDER BY c4_.sort_order DESC, c5_.sort_order DESC
Parameters: [0 => 19]
SELECT
c0_.id AS id_0,
c0_.lft AS lft_1,
c0_.lvl AS lvl_2,
c0_.rgt AS rgt_3,
c0_.root AS root_4,
c0_.created_at AS created_at_5,
c0_.updated_at AS updated_at_6,
c0_.deleted_at AS deleted_at_7,
c0_.active AS active_8,
c1_.id AS id_9,
c1_.name AS name_10,
c1_.metaTitle AS metaTitle_11,
c1_.sort_order AS sort_order_12,
c1_.created_at AS created_at_13,
c1_.updated_at AS updated_at_14,
c1_.deleted_at AS deleted_at_15,
c1_.culture AS culture_16,
c2_.id AS id_17,
c2_.lft AS lft_18,
c2_.lvl AS lvl_19,
c2_.rgt AS rgt_20,
c2_.root AS root_21,
c2_.created_at AS created_at_22,
c2_.updated_at AS updated_at_23,
c2_.deleted_at AS deleted_at_24,
c2_.active AS active_25,
c3_.id AS id_26,
c3_.name AS name_27,
c3_.metaTitle AS metaTitle_28,
c3_.sort_order AS sort_order_29,
c3_.created_at AS created_at_30,
c3_.updated_at AS updated_at_31,
c3_.deleted_at AS deleted_at_32,
c3_.culture AS culture_33,
c4_.id AS id_34,
c4_.sort_order AS sort_order_35,
c5_.id AS id_36,
c5_.sort_order AS sort_order_37,
c0_.parent_id AS parent_id_38,
c1_.category_id AS category_id_39,
c1_.langage_id AS langage_id_40,
c2_.parent_id AS parent_id_41,
c3_.category_id AS category_id_42,
c3_.langage_id AS langage_id_43,
c4_.category_translation_id AS category_translation_id_44,
c4_.carac_id AS carac_id_45,
c5_.category_translation_id AS category_translation_id_46,
c5_.carac_id AS carac_id_47
FROM
category c0_
LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id
LEFT JOIN category c2_ ON c0_.parent_id = c2_.id
LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id
LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id
LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id
WHERE
c0_.id = ?
ORDER BY
c4_.sort_order DESC,
c5_.sort_order DESC
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = 19 ORDER BY c4_.sort_order DESC, c5_.sort_order DESC;
|
| 3 |
0.91 ms |
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = ? ORDER BY c4_.sort_order DESC, c5_.sort_order DESC
Parameters: [0 => 20]
SELECT
c0_.id AS id_0,
c0_.lft AS lft_1,
c0_.lvl AS lvl_2,
c0_.rgt AS rgt_3,
c0_.root AS root_4,
c0_.created_at AS created_at_5,
c0_.updated_at AS updated_at_6,
c0_.deleted_at AS deleted_at_7,
c0_.active AS active_8,
c1_.id AS id_9,
c1_.name AS name_10,
c1_.metaTitle AS metaTitle_11,
c1_.sort_order AS sort_order_12,
c1_.created_at AS created_at_13,
c1_.updated_at AS updated_at_14,
c1_.deleted_at AS deleted_at_15,
c1_.culture AS culture_16,
c2_.id AS id_17,
c2_.lft AS lft_18,
c2_.lvl AS lvl_19,
c2_.rgt AS rgt_20,
c2_.root AS root_21,
c2_.created_at AS created_at_22,
c2_.updated_at AS updated_at_23,
c2_.deleted_at AS deleted_at_24,
c2_.active AS active_25,
c3_.id AS id_26,
c3_.name AS name_27,
c3_.metaTitle AS metaTitle_28,
c3_.sort_order AS sort_order_29,
c3_.created_at AS created_at_30,
c3_.updated_at AS updated_at_31,
c3_.deleted_at AS deleted_at_32,
c3_.culture AS culture_33,
c4_.id AS id_34,
c4_.sort_order AS sort_order_35,
c5_.id AS id_36,
c5_.sort_order AS sort_order_37,
c0_.parent_id AS parent_id_38,
c1_.category_id AS category_id_39,
c1_.langage_id AS langage_id_40,
c2_.parent_id AS parent_id_41,
c3_.category_id AS category_id_42,
c3_.langage_id AS langage_id_43,
c4_.category_translation_id AS category_translation_id_44,
c4_.carac_id AS carac_id_45,
c5_.category_translation_id AS category_translation_id_46,
c5_.carac_id AS carac_id_47
FROM
category c0_
LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id
LEFT JOIN category c2_ ON c0_.parent_id = c2_.id
LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id
LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id
LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id
WHERE
c0_.id = ?
ORDER BY
c4_.sort_order DESC,
c5_.sort_order DESC
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = 20 ORDER BY c4_.sort_order DESC, c5_.sort_order DESC;
|
| 4 |
0.83 ms |
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = ? ORDER BY c4_.sort_order DESC, c5_.sort_order DESC
Parameters: [0 => 30]
SELECT
c0_.id AS id_0,
c0_.lft AS lft_1,
c0_.lvl AS lvl_2,
c0_.rgt AS rgt_3,
c0_.root AS root_4,
c0_.created_at AS created_at_5,
c0_.updated_at AS updated_at_6,
c0_.deleted_at AS deleted_at_7,
c0_.active AS active_8,
c1_.id AS id_9,
c1_.name AS name_10,
c1_.metaTitle AS metaTitle_11,
c1_.sort_order AS sort_order_12,
c1_.created_at AS created_at_13,
c1_.updated_at AS updated_at_14,
c1_.deleted_at AS deleted_at_15,
c1_.culture AS culture_16,
c2_.id AS id_17,
c2_.lft AS lft_18,
c2_.lvl AS lvl_19,
c2_.rgt AS rgt_20,
c2_.root AS root_21,
c2_.created_at AS created_at_22,
c2_.updated_at AS updated_at_23,
c2_.deleted_at AS deleted_at_24,
c2_.active AS active_25,
c3_.id AS id_26,
c3_.name AS name_27,
c3_.metaTitle AS metaTitle_28,
c3_.sort_order AS sort_order_29,
c3_.created_at AS created_at_30,
c3_.updated_at AS updated_at_31,
c3_.deleted_at AS deleted_at_32,
c3_.culture AS culture_33,
c4_.id AS id_34,
c4_.sort_order AS sort_order_35,
c5_.id AS id_36,
c5_.sort_order AS sort_order_37,
c0_.parent_id AS parent_id_38,
c1_.category_id AS category_id_39,
c1_.langage_id AS langage_id_40,
c2_.parent_id AS parent_id_41,
c3_.category_id AS category_id_42,
c3_.langage_id AS langage_id_43,
c4_.category_translation_id AS category_translation_id_44,
c4_.carac_id AS carac_id_45,
c5_.category_translation_id AS category_translation_id_46,
c5_.carac_id AS carac_id_47
FROM
category c0_
LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id
LEFT JOIN category c2_ ON c0_.parent_id = c2_.id
LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id
LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id
LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id
WHERE
c0_.id = ?
ORDER BY
c4_.sort_order DESC,
c5_.sort_order DESC
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = 30 ORDER BY c4_.sort_order DESC, c5_.sort_order DESC;
|
| 5 |
0.66 ms |
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = ? ORDER BY c4_.sort_order DESC, c5_.sort_order DESC
Parameters: [0 => 1]
SELECT
c0_.id AS id_0,
c0_.lft AS lft_1,
c0_.lvl AS lvl_2,
c0_.rgt AS rgt_3,
c0_.root AS root_4,
c0_.created_at AS created_at_5,
c0_.updated_at AS updated_at_6,
c0_.deleted_at AS deleted_at_7,
c0_.active AS active_8,
c1_.id AS id_9,
c1_.name AS name_10,
c1_.metaTitle AS metaTitle_11,
c1_.sort_order AS sort_order_12,
c1_.created_at AS created_at_13,
c1_.updated_at AS updated_at_14,
c1_.deleted_at AS deleted_at_15,
c1_.culture AS culture_16,
c2_.id AS id_17,
c2_.lft AS lft_18,
c2_.lvl AS lvl_19,
c2_.rgt AS rgt_20,
c2_.root AS root_21,
c2_.created_at AS created_at_22,
c2_.updated_at AS updated_at_23,
c2_.deleted_at AS deleted_at_24,
c2_.active AS active_25,
c3_.id AS id_26,
c3_.name AS name_27,
c3_.metaTitle AS metaTitle_28,
c3_.sort_order AS sort_order_29,
c3_.created_at AS created_at_30,
c3_.updated_at AS updated_at_31,
c3_.deleted_at AS deleted_at_32,
c3_.culture AS culture_33,
c4_.id AS id_34,
c4_.sort_order AS sort_order_35,
c5_.id AS id_36,
c5_.sort_order AS sort_order_37,
c0_.parent_id AS parent_id_38,
c1_.category_id AS category_id_39,
c1_.langage_id AS langage_id_40,
c2_.parent_id AS parent_id_41,
c3_.category_id AS category_id_42,
c3_.langage_id AS langage_id_43,
c4_.category_translation_id AS category_translation_id_44,
c4_.carac_id AS carac_id_45,
c5_.category_translation_id AS category_translation_id_46,
c5_.carac_id AS carac_id_47
FROM
category c0_
LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id
LEFT JOIN category c2_ ON c0_.parent_id = c2_.id
LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id
LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id
LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id
WHERE
c0_.id = ?
ORDER BY
c4_.sort_order DESC,
c5_.sort_order DESC
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = 1 ORDER BY c4_.sort_order DESC, c5_.sort_order DESC;
|
| 6 |
0.90 ms |
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = ? ORDER BY c4_.sort_order DESC, c5_.sort_order DESC
Parameters: [0 => 3]
SELECT
c0_.id AS id_0,
c0_.lft AS lft_1,
c0_.lvl AS lvl_2,
c0_.rgt AS rgt_3,
c0_.root AS root_4,
c0_.created_at AS created_at_5,
c0_.updated_at AS updated_at_6,
c0_.deleted_at AS deleted_at_7,
c0_.active AS active_8,
c1_.id AS id_9,
c1_.name AS name_10,
c1_.metaTitle AS metaTitle_11,
c1_.sort_order AS sort_order_12,
c1_.created_at AS created_at_13,
c1_.updated_at AS updated_at_14,
c1_.deleted_at AS deleted_at_15,
c1_.culture AS culture_16,
c2_.id AS id_17,
c2_.lft AS lft_18,
c2_.lvl AS lvl_19,
c2_.rgt AS rgt_20,
c2_.root AS root_21,
c2_.created_at AS created_at_22,
c2_.updated_at AS updated_at_23,
c2_.deleted_at AS deleted_at_24,
c2_.active AS active_25,
c3_.id AS id_26,
c3_.name AS name_27,
c3_.metaTitle AS metaTitle_28,
c3_.sort_order AS sort_order_29,
c3_.created_at AS created_at_30,
c3_.updated_at AS updated_at_31,
c3_.deleted_at AS deleted_at_32,
c3_.culture AS culture_33,
c4_.id AS id_34,
c4_.sort_order AS sort_order_35,
c5_.id AS id_36,
c5_.sort_order AS sort_order_37,
c0_.parent_id AS parent_id_38,
c1_.category_id AS category_id_39,
c1_.langage_id AS langage_id_40,
c2_.parent_id AS parent_id_41,
c3_.category_id AS category_id_42,
c3_.langage_id AS langage_id_43,
c4_.category_translation_id AS category_translation_id_44,
c4_.carac_id AS carac_id_45,
c5_.category_translation_id AS category_translation_id_46,
c5_.carac_id AS carac_id_47
FROM
category c0_
LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id
LEFT JOIN category c2_ ON c0_.parent_id = c2_.id
LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id
LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id
LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id
WHERE
c0_.id = ?
ORDER BY
c4_.sort_order DESC,
c5_.sort_order DESC
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = 3 ORDER BY c4_.sort_order DESC, c5_.sort_order DESC;
|
| 7 |
0.87 ms |
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = ? ORDER BY c4_.sort_order DESC, c5_.sort_order DESC
Parameters: [0 => 15]
SELECT
c0_.id AS id_0,
c0_.lft AS lft_1,
c0_.lvl AS lvl_2,
c0_.rgt AS rgt_3,
c0_.root AS root_4,
c0_.created_at AS created_at_5,
c0_.updated_at AS updated_at_6,
c0_.deleted_at AS deleted_at_7,
c0_.active AS active_8,
c1_.id AS id_9,
c1_.name AS name_10,
c1_.metaTitle AS metaTitle_11,
c1_.sort_order AS sort_order_12,
c1_.created_at AS created_at_13,
c1_.updated_at AS updated_at_14,
c1_.deleted_at AS deleted_at_15,
c1_.culture AS culture_16,
c2_.id AS id_17,
c2_.lft AS lft_18,
c2_.lvl AS lvl_19,
c2_.rgt AS rgt_20,
c2_.root AS root_21,
c2_.created_at AS created_at_22,
c2_.updated_at AS updated_at_23,
c2_.deleted_at AS deleted_at_24,
c2_.active AS active_25,
c3_.id AS id_26,
c3_.name AS name_27,
c3_.metaTitle AS metaTitle_28,
c3_.sort_order AS sort_order_29,
c3_.created_at AS created_at_30,
c3_.updated_at AS updated_at_31,
c3_.deleted_at AS deleted_at_32,
c3_.culture AS culture_33,
c4_.id AS id_34,
c4_.sort_order AS sort_order_35,
c5_.id AS id_36,
c5_.sort_order AS sort_order_37,
c0_.parent_id AS parent_id_38,
c1_.category_id AS category_id_39,
c1_.langage_id AS langage_id_40,
c2_.parent_id AS parent_id_41,
c3_.category_id AS category_id_42,
c3_.langage_id AS langage_id_43,
c4_.category_translation_id AS category_translation_id_44,
c4_.carac_id AS carac_id_45,
c5_.category_translation_id AS category_translation_id_46,
c5_.carac_id AS carac_id_47
FROM
category c0_
LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id
LEFT JOIN category c2_ ON c0_.parent_id = c2_.id
LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id
LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id
LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id
WHERE
c0_.id = ?
ORDER BY
c4_.sort_order DESC,
c5_.sort_order DESC
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = 15 ORDER BY c4_.sort_order DESC, c5_.sort_order DESC;
|
| 8 |
0.91 ms |
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = ? ORDER BY c4_.sort_order DESC, c5_.sort_order DESC
Parameters: [0 => 16]
SELECT
c0_.id AS id_0,
c0_.lft AS lft_1,
c0_.lvl AS lvl_2,
c0_.rgt AS rgt_3,
c0_.root AS root_4,
c0_.created_at AS created_at_5,
c0_.updated_at AS updated_at_6,
c0_.deleted_at AS deleted_at_7,
c0_.active AS active_8,
c1_.id AS id_9,
c1_.name AS name_10,
c1_.metaTitle AS metaTitle_11,
c1_.sort_order AS sort_order_12,
c1_.created_at AS created_at_13,
c1_.updated_at AS updated_at_14,
c1_.deleted_at AS deleted_at_15,
c1_.culture AS culture_16,
c2_.id AS id_17,
c2_.lft AS lft_18,
c2_.lvl AS lvl_19,
c2_.rgt AS rgt_20,
c2_.root AS root_21,
c2_.created_at AS created_at_22,
c2_.updated_at AS updated_at_23,
c2_.deleted_at AS deleted_at_24,
c2_.active AS active_25,
c3_.id AS id_26,
c3_.name AS name_27,
c3_.metaTitle AS metaTitle_28,
c3_.sort_order AS sort_order_29,
c3_.created_at AS created_at_30,
c3_.updated_at AS updated_at_31,
c3_.deleted_at AS deleted_at_32,
c3_.culture AS culture_33,
c4_.id AS id_34,
c4_.sort_order AS sort_order_35,
c5_.id AS id_36,
c5_.sort_order AS sort_order_37,
c0_.parent_id AS parent_id_38,
c1_.category_id AS category_id_39,
c1_.langage_id AS langage_id_40,
c2_.parent_id AS parent_id_41,
c3_.category_id AS category_id_42,
c3_.langage_id AS langage_id_43,
c4_.category_translation_id AS category_translation_id_44,
c4_.carac_id AS carac_id_45,
c5_.category_translation_id AS category_translation_id_46,
c5_.carac_id AS carac_id_47
FROM
category c0_
LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id
LEFT JOIN category c2_ ON c0_.parent_id = c2_.id
LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id
LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id
LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id
WHERE
c0_.id = ?
ORDER BY
c4_.sort_order DESC,
c5_.sort_order DESC
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = 16 ORDER BY c4_.sort_order DESC, c5_.sort_order DESC;
|
| 9 |
0.92 ms |
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = ? ORDER BY c4_.sort_order DESC, c5_.sort_order DESC
Parameters: [0 => 14]
SELECT
c0_.id AS id_0,
c0_.lft AS lft_1,
c0_.lvl AS lvl_2,
c0_.rgt AS rgt_3,
c0_.root AS root_4,
c0_.created_at AS created_at_5,
c0_.updated_at AS updated_at_6,
c0_.deleted_at AS deleted_at_7,
c0_.active AS active_8,
c1_.id AS id_9,
c1_.name AS name_10,
c1_.metaTitle AS metaTitle_11,
c1_.sort_order AS sort_order_12,
c1_.created_at AS created_at_13,
c1_.updated_at AS updated_at_14,
c1_.deleted_at AS deleted_at_15,
c1_.culture AS culture_16,
c2_.id AS id_17,
c2_.lft AS lft_18,
c2_.lvl AS lvl_19,
c2_.rgt AS rgt_20,
c2_.root AS root_21,
c2_.created_at AS created_at_22,
c2_.updated_at AS updated_at_23,
c2_.deleted_at AS deleted_at_24,
c2_.active AS active_25,
c3_.id AS id_26,
c3_.name AS name_27,
c3_.metaTitle AS metaTitle_28,
c3_.sort_order AS sort_order_29,
c3_.created_at AS created_at_30,
c3_.updated_at AS updated_at_31,
c3_.deleted_at AS deleted_at_32,
c3_.culture AS culture_33,
c4_.id AS id_34,
c4_.sort_order AS sort_order_35,
c5_.id AS id_36,
c5_.sort_order AS sort_order_37,
c0_.parent_id AS parent_id_38,
c1_.category_id AS category_id_39,
c1_.langage_id AS langage_id_40,
c2_.parent_id AS parent_id_41,
c3_.category_id AS category_id_42,
c3_.langage_id AS langage_id_43,
c4_.category_translation_id AS category_translation_id_44,
c4_.carac_id AS carac_id_45,
c5_.category_translation_id AS category_translation_id_46,
c5_.carac_id AS carac_id_47
FROM
category c0_
LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id
LEFT JOIN category c2_ ON c0_.parent_id = c2_.id
LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id
LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id
LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id
WHERE
c0_.id = ?
ORDER BY
c4_.sort_order DESC,
c5_.sort_order DESC
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = 14 ORDER BY c4_.sort_order DESC, c5_.sort_order DESC;
|
| 10 |
1.14 ms |
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = ? ORDER BY c4_.sort_order DESC, c5_.sort_order DESC
Parameters: [0 => 38]
SELECT
c0_.id AS id_0,
c0_.lft AS lft_1,
c0_.lvl AS lvl_2,
c0_.rgt AS rgt_3,
c0_.root AS root_4,
c0_.created_at AS created_at_5,
c0_.updated_at AS updated_at_6,
c0_.deleted_at AS deleted_at_7,
c0_.active AS active_8,
c1_.id AS id_9,
c1_.name AS name_10,
c1_.metaTitle AS metaTitle_11,
c1_.sort_order AS sort_order_12,
c1_.created_at AS created_at_13,
c1_.updated_at AS updated_at_14,
c1_.deleted_at AS deleted_at_15,
c1_.culture AS culture_16,
c2_.id AS id_17,
c2_.lft AS lft_18,
c2_.lvl AS lvl_19,
c2_.rgt AS rgt_20,
c2_.root AS root_21,
c2_.created_at AS created_at_22,
c2_.updated_at AS updated_at_23,
c2_.deleted_at AS deleted_at_24,
c2_.active AS active_25,
c3_.id AS id_26,
c3_.name AS name_27,
c3_.metaTitle AS metaTitle_28,
c3_.sort_order AS sort_order_29,
c3_.created_at AS created_at_30,
c3_.updated_at AS updated_at_31,
c3_.deleted_at AS deleted_at_32,
c3_.culture AS culture_33,
c4_.id AS id_34,
c4_.sort_order AS sort_order_35,
c5_.id AS id_36,
c5_.sort_order AS sort_order_37,
c0_.parent_id AS parent_id_38,
c1_.category_id AS category_id_39,
c1_.langage_id AS langage_id_40,
c2_.parent_id AS parent_id_41,
c3_.category_id AS category_id_42,
c3_.langage_id AS langage_id_43,
c4_.category_translation_id AS category_translation_id_44,
c4_.carac_id AS carac_id_45,
c5_.category_translation_id AS category_translation_id_46,
c5_.carac_id AS carac_id_47
FROM
category c0_
LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id
LEFT JOIN category c2_ ON c0_.parent_id = c2_.id
LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id
LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id
LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id
WHERE
c0_.id = ?
ORDER BY
c4_.sort_order DESC,
c5_.sort_order DESC
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = 38 ORDER BY c4_.sort_order DESC, c5_.sort_order DESC;
|
| 11 |
1.19 ms |
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = ? ORDER BY c4_.sort_order DESC, c5_.sort_order DESC
Parameters: [0 => 43]
SELECT
c0_.id AS id_0,
c0_.lft AS lft_1,
c0_.lvl AS lvl_2,
c0_.rgt AS rgt_3,
c0_.root AS root_4,
c0_.created_at AS created_at_5,
c0_.updated_at AS updated_at_6,
c0_.deleted_at AS deleted_at_7,
c0_.active AS active_8,
c1_.id AS id_9,
c1_.name AS name_10,
c1_.metaTitle AS metaTitle_11,
c1_.sort_order AS sort_order_12,
c1_.created_at AS created_at_13,
c1_.updated_at AS updated_at_14,
c1_.deleted_at AS deleted_at_15,
c1_.culture AS culture_16,
c2_.id AS id_17,
c2_.lft AS lft_18,
c2_.lvl AS lvl_19,
c2_.rgt AS rgt_20,
c2_.root AS root_21,
c2_.created_at AS created_at_22,
c2_.updated_at AS updated_at_23,
c2_.deleted_at AS deleted_at_24,
c2_.active AS active_25,
c3_.id AS id_26,
c3_.name AS name_27,
c3_.metaTitle AS metaTitle_28,
c3_.sort_order AS sort_order_29,
c3_.created_at AS created_at_30,
c3_.updated_at AS updated_at_31,
c3_.deleted_at AS deleted_at_32,
c3_.culture AS culture_33,
c4_.id AS id_34,
c4_.sort_order AS sort_order_35,
c5_.id AS id_36,
c5_.sort_order AS sort_order_37,
c0_.parent_id AS parent_id_38,
c1_.category_id AS category_id_39,
c1_.langage_id AS langage_id_40,
c2_.parent_id AS parent_id_41,
c3_.category_id AS category_id_42,
c3_.langage_id AS langage_id_43,
c4_.category_translation_id AS category_translation_id_44,
c4_.carac_id AS carac_id_45,
c5_.category_translation_id AS category_translation_id_46,
c5_.carac_id AS carac_id_47
FROM
category c0_
LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id
LEFT JOIN category c2_ ON c0_.parent_id = c2_.id
LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id
LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id
LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id
WHERE
c0_.id = ?
ORDER BY
c4_.sort_order DESC,
c5_.sort_order DESC
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = 43 ORDER BY c4_.sort_order DESC, c5_.sort_order DESC;
|
| 12 |
1.04 ms |
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = ? ORDER BY c4_.sort_order DESC, c5_.sort_order DESC
Parameters: [0 => 27]
SELECT
c0_.id AS id_0,
c0_.lft AS lft_1,
c0_.lvl AS lvl_2,
c0_.rgt AS rgt_3,
c0_.root AS root_4,
c0_.created_at AS created_at_5,
c0_.updated_at AS updated_at_6,
c0_.deleted_at AS deleted_at_7,
c0_.active AS active_8,
c1_.id AS id_9,
c1_.name AS name_10,
c1_.metaTitle AS metaTitle_11,
c1_.sort_order AS sort_order_12,
c1_.created_at AS created_at_13,
c1_.updated_at AS updated_at_14,
c1_.deleted_at AS deleted_at_15,
c1_.culture AS culture_16,
c2_.id AS id_17,
c2_.lft AS lft_18,
c2_.lvl AS lvl_19,
c2_.rgt AS rgt_20,
c2_.root AS root_21,
c2_.created_at AS created_at_22,
c2_.updated_at AS updated_at_23,
c2_.deleted_at AS deleted_at_24,
c2_.active AS active_25,
c3_.id AS id_26,
c3_.name AS name_27,
c3_.metaTitle AS metaTitle_28,
c3_.sort_order AS sort_order_29,
c3_.created_at AS created_at_30,
c3_.updated_at AS updated_at_31,
c3_.deleted_at AS deleted_at_32,
c3_.culture AS culture_33,
c4_.id AS id_34,
c4_.sort_order AS sort_order_35,
c5_.id AS id_36,
c5_.sort_order AS sort_order_37,
c0_.parent_id AS parent_id_38,
c1_.category_id AS category_id_39,
c1_.langage_id AS langage_id_40,
c2_.parent_id AS parent_id_41,
c3_.category_id AS category_id_42,
c3_.langage_id AS langage_id_43,
c4_.category_translation_id AS category_translation_id_44,
c4_.carac_id AS carac_id_45,
c5_.category_translation_id AS category_translation_id_46,
c5_.carac_id AS carac_id_47
FROM
category c0_
LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id
LEFT JOIN category c2_ ON c0_.parent_id = c2_.id
LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id
LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id
LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id
WHERE
c0_.id = ?
ORDER BY
c4_.sort_order DESC,
c5_.sort_order DESC
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = 27 ORDER BY c4_.sort_order DESC, c5_.sort_order DESC;
|
| 13 |
0.93 ms |
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = ? ORDER BY c4_.sort_order DESC, c5_.sort_order DESC
Parameters: [0 => 28]
SELECT
c0_.id AS id_0,
c0_.lft AS lft_1,
c0_.lvl AS lvl_2,
c0_.rgt AS rgt_3,
c0_.root AS root_4,
c0_.created_at AS created_at_5,
c0_.updated_at AS updated_at_6,
c0_.deleted_at AS deleted_at_7,
c0_.active AS active_8,
c1_.id AS id_9,
c1_.name AS name_10,
c1_.metaTitle AS metaTitle_11,
c1_.sort_order AS sort_order_12,
c1_.created_at AS created_at_13,
c1_.updated_at AS updated_at_14,
c1_.deleted_at AS deleted_at_15,
c1_.culture AS culture_16,
c2_.id AS id_17,
c2_.lft AS lft_18,
c2_.lvl AS lvl_19,
c2_.rgt AS rgt_20,
c2_.root AS root_21,
c2_.created_at AS created_at_22,
c2_.updated_at AS updated_at_23,
c2_.deleted_at AS deleted_at_24,
c2_.active AS active_25,
c3_.id AS id_26,
c3_.name AS name_27,
c3_.metaTitle AS metaTitle_28,
c3_.sort_order AS sort_order_29,
c3_.created_at AS created_at_30,
c3_.updated_at AS updated_at_31,
c3_.deleted_at AS deleted_at_32,
c3_.culture AS culture_33,
c4_.id AS id_34,
c4_.sort_order AS sort_order_35,
c5_.id AS id_36,
c5_.sort_order AS sort_order_37,
c0_.parent_id AS parent_id_38,
c1_.category_id AS category_id_39,
c1_.langage_id AS langage_id_40,
c2_.parent_id AS parent_id_41,
c3_.category_id AS category_id_42,
c3_.langage_id AS langage_id_43,
c4_.category_translation_id AS category_translation_id_44,
c4_.carac_id AS carac_id_45,
c5_.category_translation_id AS category_translation_id_46,
c5_.carac_id AS carac_id_47
FROM
category c0_
LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id
LEFT JOIN category c2_ ON c0_.parent_id = c2_.id
LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id
LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id
LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id
WHERE
c0_.id = ?
ORDER BY
c4_.sort_order DESC,
c5_.sort_order DESC
SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = 28 ORDER BY c4_.sort_order DESC, c5_.sort_order DESC;
|
| 14 |
0.77 ms |
SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.deleted_at AS deleted_at_3, p0_.price AS price_4, p0_.quantity AS quantity_5, p0_.initial_stock AS initial_stock_6, p0_.status AS status_7, p0_.featured AS featured_8, p0_.reassortable AS reassortable_9, p0_.km AS km_10, p0_.db AS db_11, p0_.is_published AS is_published_12, p0_.weight AS weight_13, p1_.id AS id_14, p1_.title AS title_15, p1_.description AS description_16, p1_.head AS head_17, p1_.reverse AS reverse_18, p1_.comment AS comment_19, p1_.notes AS notes_20, p1_.head_caption AS head_caption_21, p1_.reverse_caption AS reverse_caption_22, p1_.culture AS culture_23, i2_.id AS id_24, i2_.name AS name_25, p0_.created_by AS created_by_26, p0_.updated_by AS updated_by_27, p0_.tax_id AS tax_id_28, p0_.category_id AS category_id_29, p1_.langage_id AS langage_id_30, p1_.product_id AS product_id_31, i2_.product_id AS product_id_32 FROM product p0_ INNER JOIN product_translation p1_ ON p0_.id = p1_.product_id INNER JOIN image i2_ ON p0_.id = i2_.product_id WHERE p0_.status = ? AND p0_.id IN (?)
Parameters: [
0 => VALIDATED,
1 => []
]
SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.deleted_at AS deleted_at_3, p0_.price AS price_4, p0_.quantity AS quantity_5, p0_.initial_stock AS initial_stock_6, p0_.status AS status_7, p0_.featured AS featured_8, p0_.reassortable AS reassortable_9, p0_.km AS km_10, p0_.db AS db_11, p0_.is_published AS is_published_12, p0_.weight AS weight_13, p1_.id AS id_14, p1_.title AS title_15, p1_.description AS description_16, p1_.head AS head_17, p1_.reverse AS reverse_18, p1_.comment AS comment_19, p1_.notes AS notes_20, p1_.head_caption AS head_caption_21, p1_.reverse_caption AS reverse_caption_22, p1_.culture AS culture_23, i2_.id AS id_24, i2_.name AS name_25, p0_.created_by AS created_by_26, p0_.updated_by AS updated_by_27, p0_.tax_id AS tax_id_28, p0_.category_id AS category_id_29, p1_.langage_id AS langage_id_30, p1_.product_id AS product_id_31, i2_.product_id AS product_id_32 FROM product p0_ INNER JOIN product_translation p1_ ON p0_.id = p1_.product_id INNER JOIN image i2_ ON p0_.id = i2_.product_id WHERE p0_.status = 'VALIDATED' AND p0_.id IN ();
|