Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.content AS content_1,
  c0_.date AS date_2,
  c0_.show AS show_3,
  p1_.id AS id_4,
  p1_.name AS name_5,
  p1_.date_entered AS date_entered_6,
  p1_.date_modified AS date_modified_7,
  p1_.description AS description_8,
  p1_.code1c AS code1c_9,
  p1_.barcode AS barcode_10,
  p1_.status AS status_11,
  p1_.price AS price_12,
  p1_.price_income AS price_income_13,
  p1_.mark_up AS mark_up_14,
  p1_.min_mark_up AS min_mark_up_15,
  p1_.packing_type AS packing_type_16,
  p1_.packing_type_count AS packing_type_count_17,
  p1_.discounts AS discounts_18,
  p1_.count_order AS count_order_19,
  p1_.product_to_order AS product_to_order_20,
  p1_.article AS article_21,
  p1_.nds AS nds_22,
  p1_.service AS service_23,
  p1_.transport_service AS transport_service_24,
  p1_.exise AS exise_25,
  p1_.expiration_date AS expiration_date_26,
  p1_.unit_volume AS unit_volume_27,
  p1_.net_weight AS net_weight_28,
  p1_.gross_weight AS gross_weight_29,
  p1_.go_by_weight AS go_by_weight_30,
  p1_.packaging AS packaging_31,
  p1_.old_code AS old_code_32,
  p1_.show AS show_33,
  p1_.balance AS balance_34,
  p1_.deleted AS deleted_35,
  p1_.category_cnt AS category_cnt_36,
  p1_.price_category AS price_category_37,
  p1_.is_salle AS is_salle_38,
  p1_.is_new AS is_new_39,
  p1_.is_top AS is_top_40,
  p1_.old_price AS old_price_41,
  p1_.discount_percent AS discount_percent_42,
  p1_.date_last_price_income AS date_last_price_income_43,
  p1_.video AS video_44,
  p1_.is_video AS is_video_45,
  p1_.is_free_shipping AS is_free_shipping_46,
  p1_.warranty_period AS warranty_period_47,
  p1_.min_balance AS min_balance_48,
  p1_.min_balance_admin AS min_balance_admin_49,
  p1_.main_category_id AS main_category_id_50,
  p1_.discontinued AS discontinued_51,
  p1_.seo_title AS seo_title_52,
  p1_.seo_description AS seo_description_53,
  p1_.salle_price AS salle_price_54,
  p1_.normal_price AS normal_price_55,
  u2_.id AS id_56,
  u2_.username AS username_57,
  u2_.roles AS roles_58,
  u2_.password AS password_59,
  u2_.first_name AS first_name_60,
  u2_.last_name AS last_name_61,
  u2_.phone AS phone_62,
  u2_.address AS address_63,
  u2_.status AS status_64,
  u2_.email AS email_65,
  u2_.code_user AS code_user_66,
  u2_.code_manager AS code_manager_67,
  u2_.work_schedule AS work_schedule_68,
  u2_.telegram AS telegram_69,
  u2_.viber AS viber_70,
  u2_.action_token AS action_token_71,
  u2_.action_time AS action_time_72,
  c0_.product_id AS product_id_73,
  c0_.users_id AS users_id_74,
  p1_.modified_user_id AS modified_user_id_75,
  p1_.created_by_id AS created_by_id_76,
  p1_.measurement_unit_id AS measurement_unit_id_77,
  p1_.site_product_id AS site_product_id_78,
  p1_.storage_id AS storage_id_79,
  p1_.storage_element_id AS storage_element_id_80,
  p1_.language_id AS language_id_81,
  p1_.translation_id AS translation_id_82,
  p1_.main_media_id AS main_media_id_83,
  p1_.main_media_hover_id AS main_media_hover_id_84,
  u2_.location_id AS location_id_85
FROM
  comments c0_
  INNER JOIN products p1_ ON c0_.product_id = p1_.id
  LEFT JOIN users u2_ ON c0_.users_id = u2_.id
WHERE
  c0_.id IN (
    SELECT
      c3_.id
    FROM
      comments c3_
      INNER JOIN products p4_ ON c3_.product_id = p4_.id
    WHERE
      p4_.id = ?
  )
ORDER BY
  c0_.id ASC
LIMIT
  30

SELECT c0_.id AS id_0, c0_.content AS content_1, c0_.date AS date_2, c0_.show AS show_3, p1_.id AS id_4, p1_.name AS name_5, p1_.date_entered AS date_entered_6, p1_.date_modified AS date_modified_7, p1_.description AS description_8, p1_.code1c AS code1c_9, p1_.barcode AS barcode_10, p1_.status AS status_11, p1_.price AS price_12, p1_.price_income AS price_income_13, p1_.mark_up AS mark_up_14, p1_.min_mark_up AS min_mark_up_15, p1_.packing_type AS packing_type_16, p1_.packing_type_count AS packing_type_count_17, p1_.discounts AS discounts_18, p1_.count_order AS count_order_19, p1_.product_to_order AS product_to_order_20, p1_.article AS article_21, p1_.nds AS nds_22, p1_.service AS service_23, p1_.transport_service AS transport_service_24, p1_.exise AS exise_25, p1_.expiration_date AS expiration_date_26, p1_.unit_volume AS unit_volume_27, p1_.net_weight AS net_weight_28, p1_.gross_weight AS gross_weight_29, p1_.go_by_weight AS go_by_weight_30, p1_.packaging AS packaging_31, p1_.old_code AS old_code_32, p1_.show AS show_33, p1_.balance AS balance_34, p1_.deleted AS deleted_35, p1_.category_cnt AS category_cnt_36, p1_.price_category AS price_category_37, p1_.is_salle AS is_salle_38, p1_.is_new AS is_new_39, p1_.is_top AS is_top_40, p1_.old_price AS old_price_41, p1_.discount_percent AS discount_percent_42, p1_.date_last_price_income AS date_last_price_income_43, p1_.video AS video_44, p1_.is_video AS is_video_45, p1_.is_free_shipping AS is_free_shipping_46, p1_.warranty_period AS warranty_period_47, p1_.min_balance AS min_balance_48, p1_.min_balance_admin AS min_balance_admin_49, p1_.main_category_id AS main_category_id_50, p1_.discontinued AS discontinued_51, p1_.seo_title AS seo_title_52, p1_.seo_description AS seo_description_53, p1_.salle_price AS salle_price_54, p1_.normal_price AS normal_price_55, u2_.id AS id_56, u2_.username AS username_57, u2_.roles AS roles_58, u2_.password AS password_59, u2_.first_name AS first_name_60, u2_.last_name AS last_name_61, u2_.phone AS phone_62, u2_.address AS address_63, u2_.status AS status_64, u2_.email AS email_65, u2_.code_user AS code_user_66, u2_.code_manager AS code_manager_67, u2_.work_schedule AS work_schedule_68, u2_.telegram AS telegram_69, u2_.viber AS viber_70, u2_.action_token AS action_token_71, u2_.action_time AS action_time_72, c0_.product_id AS product_id_73, c0_.users_id AS users_id_74, p1_.modified_user_id AS modified_user_id_75, p1_.created_by_id AS created_by_id_76, p1_.measurement_unit_id AS measurement_unit_id_77, p1_.site_product_id AS site_product_id_78, p1_.storage_id AS storage_id_79, p1_.storage_element_id AS storage_element_id_80, p1_.language_id AS language_id_81, p1_.translation_id AS translation_id_82, p1_.main_media_id AS main_media_id_83, p1_.main_media_hover_id AS main_media_hover_id_84, u2_.location_id AS location_id_85 FROM comments c0_ INNER JOIN products p1_ ON c0_.product_id = p1_.id LEFT JOIN users u2_ ON c0_.users_id = u2_.id WHERE c0_.id IN (SELECT c3_.id FROM comments c3_ INNER JOIN products p4_ ON c3_.product_id = p4_.id WHERE p4_.id = '29132') ORDER BY c0_.id ASC LIMIT 30;

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  comments c0_
  INNER JOIN products p1_ ON c0_.product_id = p1_.id
  LEFT JOIN users u2_ ON c0_.users_id = u2_.id
WHERE
  c0_.id IN (
    SELECT
      c3_.id
    FROM
      comments c3_
      INNER JOIN products p4_ ON c3_.product_id = p4_.id
    WHERE
      p4_.id = ?
  )

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM comments c0_ INNER JOIN products p1_ ON c0_.product_id = p1_.id LEFT JOIN users u2_ ON c0_.users_id = u2_.id WHERE c0_.id IN (SELECT c3_.id FROM comments c3_ INNER JOIN products p4_ ON c3_.product_id = p4_.id WHERE p4_.id = '29132');