Symfony Profiler

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.sort AS sort_1,
  c0_.name AS name_2
FROM
  category c0_
  LEFT JOIN languages l1_ ON c0_.language_id = l1_.id
  LEFT JOIN category c2_ ON c0_.translation_id = c2_.id
  LEFT JOIN category c3_ ON c0_.id = c3_.translation_id
ORDER BY
  c0_.sort ASC,
  c0_.name ASC
LIMIT
  30

SELECT DISTINCT c0_.id AS id_0, c0_.sort AS sort_1, c0_.name AS name_2 FROM category c0_ LEFT JOIN languages l1_ ON c0_.language_id = l1_.id LEFT JOIN category c2_ ON c0_.translation_id = c2_.id LEFT JOIN category c3_ ON c0_.id = c3_.translation_id ORDER BY c0_.sort ASC, c0_.name ASC LIMIT 30;

SELECT
  c0_.id AS id_0,
  c0_.date_entered AS date_entered_1,
  c0_.date_modified AS date_modified_2,
  c0_.created_by AS created_by_3,
  c0_.modified_user_id AS modified_user_id_4,
  c0_.name AS name_5,
  c0_.slug AS slug_6,
  c0_.status AS status_7,
  c0_.description AS description_8,
  c0_.main AS main_9,
  c0_.type AS type_10,
  c0_.product_cnt AS product_cnt_11,
  c0_.site_product_cnt AS site_product_cnt_12,
  c0_.sort AS sort_13,
  c0_.seo_title AS seo_title_14,
  c0_.seo_description AS seo_description_15,
  l1_.id AS id_16,
  l1_.name AS name_17,
  l1_.key AS key_18,
  c2_.id AS id_19,
  c2_.date_entered AS date_entered_20,
  c2_.date_modified AS date_modified_21,
  c2_.created_by AS created_by_22,
  c2_.modified_user_id AS modified_user_id_23,
  c2_.name AS name_24,
  c2_.slug AS slug_25,
  c2_.status AS status_26,
  c2_.description AS description_27,
  c2_.main AS main_28,
  c2_.type AS type_29,
  c2_.product_cnt AS product_cnt_30,
  c2_.site_product_cnt AS site_product_cnt_31,
  c2_.sort AS sort_32,
  c2_.seo_title AS seo_title_33,
  c2_.seo_description AS seo_description_34,
  c3_.id AS id_35,
  c3_.date_entered AS date_entered_36,
  c3_.date_modified AS date_modified_37,
  c3_.created_by AS created_by_38,
  c3_.modified_user_id AS modified_user_id_39,
  c3_.name AS name_40,
  c3_.slug AS slug_41,
  c3_.status AS status_42,
  c3_.description AS description_43,
  c3_.main AS main_44,
  c3_.type AS type_45,
  c3_.product_cnt AS product_cnt_46,
  c3_.site_product_cnt AS site_product_cnt_47,
  c3_.sort AS sort_48,
  c3_.seo_title AS seo_title_49,
  c3_.seo_description AS seo_description_50,
  c0_.parent_id AS parent_id_51,
  c0_.media_id AS media_id_52,
  c0_.language_id AS language_id_53,
  c0_.translation_id AS translation_id_54,
  c2_.parent_id AS parent_id_55,
  c2_.media_id AS media_id_56,
  c2_.language_id AS language_id_57,
  c2_.translation_id AS translation_id_58,
  c3_.parent_id AS parent_id_59,
  c3_.media_id AS media_id_60,
  c3_.language_id AS language_id_61,
  c3_.translation_id AS translation_id_62
FROM
  category c0_
  LEFT JOIN languages l1_ ON c0_.language_id = l1_.id
  LEFT JOIN category c2_ ON c0_.translation_id = c2_.id
  LEFT JOIN category c3_ ON c0_.id = c3_.translation_id
WHERE
  c0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  c0_.sort ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.date_entered AS date_entered_1, c0_.date_modified AS date_modified_2, c0_.created_by AS created_by_3, c0_.modified_user_id AS modified_user_id_4, c0_.name AS name_5, c0_.slug AS slug_6, c0_.status AS status_7, c0_.description AS description_8, c0_.main AS main_9, c0_.type AS type_10, c0_.product_cnt AS product_cnt_11, c0_.site_product_cnt AS site_product_cnt_12, c0_.sort AS sort_13, c0_.seo_title AS seo_title_14, c0_.seo_description AS seo_description_15, l1_.id AS id_16, l1_.name AS name_17, l1_.key AS key_18, c2_.id AS id_19, c2_.date_entered AS date_entered_20, c2_.date_modified AS date_modified_21, c2_.created_by AS created_by_22, c2_.modified_user_id AS modified_user_id_23, c2_.name AS name_24, c2_.slug AS slug_25, c2_.status AS status_26, c2_.description AS description_27, c2_.main AS main_28, c2_.type AS type_29, c2_.product_cnt AS product_cnt_30, c2_.site_product_cnt AS site_product_cnt_31, c2_.sort AS sort_32, c2_.seo_title AS seo_title_33, c2_.seo_description AS seo_description_34, c3_.id AS id_35, c3_.date_entered AS date_entered_36, c3_.date_modified AS date_modified_37, c3_.created_by AS created_by_38, c3_.modified_user_id AS modified_user_id_39, c3_.name AS name_40, c3_.slug AS slug_41, c3_.status AS status_42, c3_.description AS description_43, c3_.main AS main_44, c3_.type AS type_45, c3_.product_cnt AS product_cnt_46, c3_.site_product_cnt AS site_product_cnt_47, c3_.sort AS sort_48, c3_.seo_title AS seo_title_49, c3_.seo_description AS seo_description_50, c0_.parent_id AS parent_id_51, c0_.media_id AS media_id_52, c0_.language_id AS language_id_53, c0_.translation_id AS translation_id_54, c2_.parent_id AS parent_id_55, c2_.media_id AS media_id_56, c2_.language_id AS language_id_57, c2_.translation_id AS translation_id_58, c3_.parent_id AS parent_id_59, c3_.media_id AS media_id_60, c3_.language_id AS language_id_61, c3_.translation_id AS translation_id_62 FROM category c0_ LEFT JOIN languages l1_ ON c0_.language_id = l1_.id LEFT JOIN category c2_ ON c0_.translation_id = c2_.id LEFT JOIN category c3_ ON c0_.id = c3_.translation_id WHERE c0_.id IN (58, 61, 118, 59, 123, 120, 74, 71, 122, 131, 73, 72, 121, 119, 60, 9, 69, 52, 127, 21, 14, 22, 15, 16, 13, 10, 57, 23, 128, 132) ORDER BY c0_.sort ASC, c0_.name ASC;

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  category c0_
  LEFT JOIN languages l1_ ON c0_.language_id = l1_.id
  LEFT JOIN category c2_ ON c0_.translation_id = c2_.id
  LEFT JOIN category c3_ ON c0_.id = c3_.translation_id

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM category c0_ LEFT JOIN languages l1_ ON c0_.language_id = l1_.id LEFT JOIN category c2_ ON c0_.translation_id = c2_.id LEFT JOIN category c3_ ON c0_.id = c3_.translation_id;