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;

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 (?)

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 ();