Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.path AS path_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.deleted_by AS deleted_by_7,
  t0.slug AS slug_8,
  t0.product_id AS product_id_9,
  t0.supplier_activity_id AS supplier_activity_id_10
FROM
  image t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.path AS path_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.deleted_by AS deleted_by_7, t0.slug AS slug_8, t0.product_id AS product_id_9, t0.supplier_activity_id AS supplier_activity_id_10 FROM image t0 WHERE t0.product_id = 851;

SELECT
  t0.id AS id_1,
  t0.place_type AS place_type_2,
  t0.price AS price_3,
  t0.place_name AS place_name_4,
  t0.product_id AS product_id_5
FROM
  place_price t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.place_type AS place_type_2, t0.price AS price_3, t0.place_name AS place_name_4, t0.product_id AS product_id_5 FROM place_price t0 WHERE t0.product_id = 851;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.description AS description_2,
  p0_.enabled AS enabled_3,
  p0_.created_at AS created_at_4,
  p0_.updated_at AS updated_at_5,
  p0_.slug AS slug_6,
  p0_.has_publicity AS has_publicity_7,
  p0_.code AS code_8,
  p0_.stockcode AS stockcode_9,
  p0_.sales_unit AS sales_unit_10,
  p0_.view AS view_11,
  p0_.nb_buyers AS nb_buyers_12,
  p0_.varieties AS varieties_13,
  p0_.quality AS quality_14,
  p0_.colors AS colors_15,
  p0_.sizes AS sizes_16,
  p0_.origin AS origin_17,
  p0_.rate AS rate_18,
  p0_.expiration_date AS expiration_date_19,
  p0_.production_date AS production_date_20,
  p0_.nb_rates AS nb_rates_21,
  p0_.deleted_at AS deleted_at_22,
  p0_.flavors AS flavors_23,
  p0_.is_grouped AS is_grouped_24,
  p0_.group_slug AS group_slug_25,
  p0_.is_collection AS is_collection_26,
  p0_.is_agromwinda_promotion AS is_agromwinda_promotion_27,
  p0_.enabled_provinces AS enabled_provinces_28,
  p0_.attribut_id AS attribut_id_29,
  p0_.category_id AS category_id_30,
  p0_.default_image_id AS default_image_id_31,
  p0_.agent_id AS agent_id_32,
  p0_.life_time_id AS life_time_id_33,
  p0_.shipping_id AS shipping_id_34,
  p0_.suppliers_id AS suppliers_id_35
FROM
  product p0_
  INNER JOIN image i1_ ON p0_.id = i1_.product_id
  INNER JOIN attribut a2_ ON p0_.attribut_id = a2_.id
  INNER JOIN category c3_ ON p0_.category_id = c3_.id
  LEFT JOIN product p4_ ON (
    p0_.category_id = p4_.category_id
    AND p0_.id < p4_.id
  )
  INNER JOIN supplier s5_ ON p0_.suppliers_id = s5_.id
WHERE
  p0_.deleted_at IS NULL
  AND a2_.unit_discount IS NOT NULL
  AND i1_.filename IS NOT NULL
  AND c3_.department_id IS NOT NULL
  AND p0_.enabled = ?
  AND p0_.is_collection = ?
  AND s5_.id IS NOT NULL
GROUP BY
  p0_.id
HAVING
  COUNT(p0_.id) < 6
ORDER BY
  FIELD(
    c3_.priority, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  ) ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.enabled AS enabled_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.slug AS slug_6, p0_.has_publicity AS has_publicity_7, p0_.code AS code_8, p0_.stockcode AS stockcode_9, p0_.sales_unit AS sales_unit_10, p0_.view AS view_11, p0_.nb_buyers AS nb_buyers_12, p0_.varieties AS varieties_13, p0_.quality AS quality_14, p0_.colors AS colors_15, p0_.sizes AS sizes_16, p0_.origin AS origin_17, p0_.rate AS rate_18, p0_.expiration_date AS expiration_date_19, p0_.production_date AS production_date_20, p0_.nb_rates AS nb_rates_21, p0_.deleted_at AS deleted_at_22, p0_.flavors AS flavors_23, p0_.is_grouped AS is_grouped_24, p0_.group_slug AS group_slug_25, p0_.is_collection AS is_collection_26, p0_.is_agromwinda_promotion AS is_agromwinda_promotion_27, p0_.enabled_provinces AS enabled_provinces_28, p0_.attribut_id AS attribut_id_29, p0_.category_id AS category_id_30, p0_.default_image_id AS default_image_id_31, p0_.agent_id AS agent_id_32, p0_.life_time_id AS life_time_id_33, p0_.shipping_id AS shipping_id_34, p0_.suppliers_id AS suppliers_id_35 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN attribut a2_ ON p0_.attribut_id = a2_.id INNER JOIN category c3_ ON p0_.category_id = c3_.id LEFT JOIN product p4_ ON (p0_.category_id = p4_.category_id AND p0_.id < p4_.id) INNER JOIN supplier s5_ ON p0_.suppliers_id = s5_.id WHERE p0_.deleted_at IS NULL AND a2_.unit_discount IS NOT NULL AND i1_.filename IS NOT NULL AND c3_.department_id IS NOT NULL AND p0_.enabled = 1 AND p0_.is_collection = 0 AND s5_.id IS NOT NULL GROUP BY p0_.id HAVING COUNT(p0_.id) < 6 ORDER BY FIELD(c3_.priority, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, NULL) ASC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.description AS description_2,
  p0_.enabled AS enabled_3,
  p0_.created_at AS created_at_4,
  p0_.updated_at AS updated_at_5,
  p0_.slug AS slug_6,
  p0_.has_publicity AS has_publicity_7,
  p0_.code AS code_8,
  p0_.stockcode AS stockcode_9,
  p0_.sales_unit AS sales_unit_10,
  p0_.view AS view_11,
  p0_.nb_buyers AS nb_buyers_12,
  p0_.varieties AS varieties_13,
  p0_.quality AS quality_14,
  p0_.colors AS colors_15,
  p0_.sizes AS sizes_16,
  p0_.origin AS origin_17,
  p0_.rate AS rate_18,
  p0_.expiration_date AS expiration_date_19,
  p0_.production_date AS production_date_20,
  p0_.nb_rates AS nb_rates_21,
  p0_.deleted_at AS deleted_at_22,
  p0_.flavors AS flavors_23,
  p0_.is_grouped AS is_grouped_24,
  p0_.group_slug AS group_slug_25,
  p0_.is_collection AS is_collection_26,
  p0_.is_agromwinda_promotion AS is_agromwinda_promotion_27,
  p0_.enabled_provinces AS enabled_provinces_28,
  a1_.id AS id_29,
  a1_.stock AS stock_30,
  a1_.taxe AS taxe_31,
  a1_.code AS code_32,
  a1_.price AS price_33,
  a1_.promotion AS promotion_34,
  a1_.rate AS rate_35,
  a1_.unit_discount AS unit_discount_36,
  a1_.weight AS weight_37,
  a1_.weight_kg AS weight_kg_38,
  a1_.min_purchase AS min_purchase_39,
  a1_.max_purchase AS max_purchase_40,
  a1_.created_at AS created_at_41,
  a1_.updated_at AS updated_at_42,
  a1_.deleted_at AS deleted_at_43,
  a1_.deleted_by AS deleted_by_44,
  a1_.slug AS slug_45,
  c2_.id AS id_46,
  c2_.name AS name_47,
  c2_.code AS code_48,
  c2_.priority AS priority_49,
  c2_.image AS image_50,
  p0_.attribut_id AS attribut_id_51,
  p0_.category_id AS category_id_52,
  p0_.default_image_id AS default_image_id_53,
  p0_.agent_id AS agent_id_54,
  p0_.life_time_id AS life_time_id_55,
  p0_.shipping_id AS shipping_id_56,
  p0_.suppliers_id AS suppliers_id_57,
  c2_.department_id AS department_id_58
FROM
  product p0_
  INNER JOIN attribut a1_ ON p0_.attribut_id = a1_.id
  INNER JOIN category c2_ ON p0_.category_id = c2_.id
  INNER JOIN image i3_ ON p0_.id = i3_.product_id
WHERE
  p0_.deleted_at IS NULL
  AND a1_.unit_discount IS NOT NULL
  AND p0_.enabled = ?
  AND p0_.is_collection = ?
ORDER BY
  FIELD(
    c2_.priority, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  ) ASC
LIMIT
  36

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.enabled AS enabled_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.slug AS slug_6, p0_.has_publicity AS has_publicity_7, p0_.code AS code_8, p0_.stockcode AS stockcode_9, p0_.sales_unit AS sales_unit_10, p0_.view AS view_11, p0_.nb_buyers AS nb_buyers_12, p0_.varieties AS varieties_13, p0_.quality AS quality_14, p0_.colors AS colors_15, p0_.sizes AS sizes_16, p0_.origin AS origin_17, p0_.rate AS rate_18, p0_.expiration_date AS expiration_date_19, p0_.production_date AS production_date_20, p0_.nb_rates AS nb_rates_21, p0_.deleted_at AS deleted_at_22, p0_.flavors AS flavors_23, p0_.is_grouped AS is_grouped_24, p0_.group_slug AS group_slug_25, p0_.is_collection AS is_collection_26, p0_.is_agromwinda_promotion AS is_agromwinda_promotion_27, p0_.enabled_provinces AS enabled_provinces_28, a1_.id AS id_29, a1_.stock AS stock_30, a1_.taxe AS taxe_31, a1_.code AS code_32, a1_.price AS price_33, a1_.promotion AS promotion_34, a1_.rate AS rate_35, a1_.unit_discount AS unit_discount_36, a1_.weight AS weight_37, a1_.weight_kg AS weight_kg_38, a1_.min_purchase AS min_purchase_39, a1_.max_purchase AS max_purchase_40, a1_.created_at AS created_at_41, a1_.updated_at AS updated_at_42, a1_.deleted_at AS deleted_at_43, a1_.deleted_by AS deleted_by_44, a1_.slug AS slug_45, c2_.id AS id_46, c2_.name AS name_47, c2_.code AS code_48, c2_.priority AS priority_49, c2_.image AS image_50, p0_.attribut_id AS attribut_id_51, p0_.category_id AS category_id_52, p0_.default_image_id AS default_image_id_53, p0_.agent_id AS agent_id_54, p0_.life_time_id AS life_time_id_55, p0_.shipping_id AS shipping_id_56, p0_.suppliers_id AS suppliers_id_57, c2_.department_id AS department_id_58 FROM product p0_ INNER JOIN attribut a1_ ON p0_.attribut_id = a1_.id INNER JOIN category c2_ ON p0_.category_id = c2_.id INNER JOIN image i3_ ON p0_.id = i3_.product_id WHERE p0_.deleted_at IS NULL AND a1_.unit_discount IS NOT NULL AND p0_.enabled = 1 AND p0_.is_collection = 0 ORDER BY FIELD(c2_.priority, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, NULL) ASC LIMIT 36;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.code AS code_2,
  d0_.created_at AS created_at_3,
  d0_.updated_at AS updated_at_4,
  d0_.deleted_at AS deleted_at_5,
  d0_.deleted_by AS deleted_by_6,
  d0_.slug AS slug_7
FROM
  department d0_
  INNER JOIN category c1_ ON d0_.id = c1_.department_id
  INNER JOIN product p2_ ON c1_.id = p2_.category_id
ORDER BY
  p2_.name ASC

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.code AS code_2, d0_.created_at AS created_at_3, d0_.updated_at AS updated_at_4, d0_.deleted_at AS deleted_at_5, d0_.deleted_by AS deleted_by_6, d0_.slug AS slug_7 FROM department d0_ INNER JOIN category c1_ ON d0_.id = c1_.department_id INNER JOIN product p2_ ON c1_.id = p2_.category_id ORDER BY p2_.name ASC;