Symfony Profiler

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.date_entered AS date_entered_2,
  d0_.type AS type_3,
  d0_.description AS description_4,
  p1_.id AS id_5,
  p1_.name AS name_6,
  p1_.date_entered AS date_entered_7,
  p1_.date_modified AS date_modified_8,
  p1_.description AS description_9,
  p1_.code1c AS code1c_10,
  p1_.barcode AS barcode_11,
  p1_.status AS status_12,
  p1_.price AS price_13,
  p1_.price_income AS price_income_14,
  p1_.mark_up AS mark_up_15,
  p1_.min_mark_up AS min_mark_up_16,
  p1_.packing_type AS packing_type_17,
  p1_.packing_type_count AS packing_type_count_18,
  p1_.discounts AS discounts_19,
  p1_.count_order AS count_order_20,
  p1_.product_to_order AS product_to_order_21,
  p1_.article AS article_22,
  p1_.nds AS nds_23,
  p1_.service AS service_24,
  p1_.transport_service AS transport_service_25,
  p1_.exise AS exise_26,
  p1_.expiration_date AS expiration_date_27,
  p1_.unit_volume AS unit_volume_28,
  p1_.net_weight AS net_weight_29,
  p1_.gross_weight AS gross_weight_30,
  p1_.go_by_weight AS go_by_weight_31,
  p1_.packaging AS packaging_32,
  p1_.old_code AS old_code_33,
  p1_.show AS show_34,
  p1_.balance AS balance_35,
  p1_.deleted AS deleted_36,
  p1_.category_cnt AS category_cnt_37,
  p1_.price_category AS price_category_38,
  p1_.is_salle AS is_salle_39,
  p1_.is_new AS is_new_40,
  p1_.is_top AS is_top_41,
  p1_.old_price AS old_price_42,
  p1_.discount_percent AS discount_percent_43,
  p1_.date_last_price_income AS date_last_price_income_44,
  p1_.video AS video_45,
  p1_.is_video AS is_video_46,
  p1_.is_free_shipping AS is_free_shipping_47,
  p1_.warranty_period AS warranty_period_48,
  p1_.min_balance AS min_balance_49,
  p1_.min_balance_admin AS min_balance_admin_50,
  p1_.main_category_id AS main_category_id_51,
  p1_.discontinued AS discontinued_52,
  p1_.seo_title AS seo_title_53,
  p1_.seo_description AS seo_description_54,
  p1_.salle_price AS salle_price_55,
  p1_.normal_price AS normal_price_56,
  m2_.id AS id_57,
  m2_.upload_timestamp AS upload_timestamp_58,
  m2_.main AS main_59,
  m2_.file_path AS file_path_60,
  m2_.type AS type_61,
  m2_.name AS name_62,
  m2_.size AS size_63,
  m2_.sort AS sort_64,
  d0_.media_id AS media_id_65,
  d0_.product_id AS product_id_66,
  p1_.modified_user_id AS modified_user_id_67,
  p1_.created_by_id AS created_by_id_68,
  p1_.measurement_unit_id AS measurement_unit_id_69,
  p1_.site_product_id AS site_product_id_70,
  p1_.storage_id AS storage_id_71,
  p1_.storage_element_id AS storage_element_id_72,
  p1_.language_id AS language_id_73,
  p1_.translation_id AS translation_id_74,
  p1_.main_media_id AS main_media_id_75,
  p1_.main_media_hover_id AS main_media_hover_id_76,
  m2_.product_id AS product_id_77,
  m2_.orders_id AS orders_id_78,
  m2_.users_id AS users_id_79,
  m2_.account_worker_id AS account_worker_id_80,
  m2_.form_answer_id AS form_answer_id_81,
  m2_.job_id AS job_id_82,
  m2_.resize_img_parent_id AS resize_img_parent_id_83
FROM
  documents d0_
  INNER JOIN products p1_ ON d0_.product_id = p1_.id
  LEFT JOIN media_object m2_ ON d0_.media_id = m2_.id
WHERE
  d0_.id IN (
    SELECT
      d3_.id
    FROM
      documents d3_
      INNER JOIN products p4_ ON d3_.product_id = p4_.id
    WHERE
      p4_.id = ?
  )
ORDER BY
  d0_.id DESC
LIMIT
  30

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.date_entered AS date_entered_2, d0_.type AS type_3, d0_.description AS description_4, p1_.id AS id_5, p1_.name AS name_6, p1_.date_entered AS date_entered_7, p1_.date_modified AS date_modified_8, p1_.description AS description_9, p1_.code1c AS code1c_10, p1_.barcode AS barcode_11, p1_.status AS status_12, p1_.price AS price_13, p1_.price_income AS price_income_14, p1_.mark_up AS mark_up_15, p1_.min_mark_up AS min_mark_up_16, p1_.packing_type AS packing_type_17, p1_.packing_type_count AS packing_type_count_18, p1_.discounts AS discounts_19, p1_.count_order AS count_order_20, p1_.product_to_order AS product_to_order_21, p1_.article AS article_22, p1_.nds AS nds_23, p1_.service AS service_24, p1_.transport_service AS transport_service_25, p1_.exise AS exise_26, p1_.expiration_date AS expiration_date_27, p1_.unit_volume AS unit_volume_28, p1_.net_weight AS net_weight_29, p1_.gross_weight AS gross_weight_30, p1_.go_by_weight AS go_by_weight_31, p1_.packaging AS packaging_32, p1_.old_code AS old_code_33, p1_.show AS show_34, p1_.balance AS balance_35, p1_.deleted AS deleted_36, p1_.category_cnt AS category_cnt_37, p1_.price_category AS price_category_38, p1_.is_salle AS is_salle_39, p1_.is_new AS is_new_40, p1_.is_top AS is_top_41, p1_.old_price AS old_price_42, p1_.discount_percent AS discount_percent_43, p1_.date_last_price_income AS date_last_price_income_44, p1_.video AS video_45, p1_.is_video AS is_video_46, p1_.is_free_shipping AS is_free_shipping_47, p1_.warranty_period AS warranty_period_48, p1_.min_balance AS min_balance_49, p1_.min_balance_admin AS min_balance_admin_50, p1_.main_category_id AS main_category_id_51, p1_.discontinued AS discontinued_52, p1_.seo_title AS seo_title_53, p1_.seo_description AS seo_description_54, p1_.salle_price AS salle_price_55, p1_.normal_price AS normal_price_56, m2_.id AS id_57, m2_.upload_timestamp AS upload_timestamp_58, m2_.main AS main_59, m2_.file_path AS file_path_60, m2_.type AS type_61, m2_.name AS name_62, m2_.size AS size_63, m2_.sort AS sort_64, d0_.media_id AS media_id_65, d0_.product_id AS product_id_66, p1_.modified_user_id AS modified_user_id_67, p1_.created_by_id AS created_by_id_68, p1_.measurement_unit_id AS measurement_unit_id_69, p1_.site_product_id AS site_product_id_70, p1_.storage_id AS storage_id_71, p1_.storage_element_id AS storage_element_id_72, p1_.language_id AS language_id_73, p1_.translation_id AS translation_id_74, p1_.main_media_id AS main_media_id_75, p1_.main_media_hover_id AS main_media_hover_id_76, m2_.product_id AS product_id_77, m2_.orders_id AS orders_id_78, m2_.users_id AS users_id_79, m2_.account_worker_id AS account_worker_id_80, m2_.form_answer_id AS form_answer_id_81, m2_.job_id AS job_id_82, m2_.resize_img_parent_id AS resize_img_parent_id_83 FROM documents d0_ INNER JOIN products p1_ ON d0_.product_id = p1_.id LEFT JOIN media_object m2_ ON d0_.media_id = m2_.id WHERE d0_.id IN (SELECT d3_.id FROM documents d3_ INNER JOIN products p4_ ON d3_.product_id = p4_.id WHERE p4_.id = '29184') ORDER BY d0_.id DESC LIMIT 30;

SELECT
  count(DISTINCT d0_.id) AS sclr_0
FROM
  documents d0_
  INNER JOIN products p1_ ON d0_.product_id = p1_.id
  LEFT JOIN media_object m2_ ON d0_.media_id = m2_.id
WHERE
  d0_.id IN (
    SELECT
      d3_.id
    FROM
      documents d3_
      INNER JOIN products p4_ ON d3_.product_id = p4_.id
    WHERE
      p4_.id = ?
  )

SELECT count(DISTINCT d0_.id) AS sclr_0 FROM documents d0_ INNER JOIN products p1_ ON d0_.product_id = p1_.id LEFT JOIN media_object m2_ ON d0_.media_id = m2_.id WHERE d0_.id IN (SELECT d3_.id FROM documents d3_ INNER JOIN products p4_ ON d3_.product_id = p4_.id WHERE p4_.id = '29184');