Symfony Profiler

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;