Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.priority AS priority_4,
  t0.image AS image_5,
  t0.department_id AS department_id_6
FROM
  category t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.priority AS priority_4, t0.image AS image_5, t0.department_id AS department_id_6 FROM category t0 WHERE t0.name = 'Equipements sportifs' LIMIT 1;

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,
  i2_.id AS id_46,
  i2_.filename AS filename_47,
  i2_.path AS path_48,
  i2_.created_at AS created_at_49,
  i2_.updated_at AS updated_at_50,
  i2_.deleted_at AS deleted_at_51,
  i2_.deleted_by AS deleted_by_52,
  i2_.slug AS slug_53,
  c3_.id AS id_54,
  c3_.name AS name_55,
  c3_.code AS code_56,
  c3_.priority AS priority_57,
  c3_.image AS image_58,
  p0_.attribut_id AS attribut_id_59,
  p0_.category_id AS category_id_60,
  p0_.default_image_id AS default_image_id_61,
  p0_.agent_id AS agent_id_62,
  p0_.life_time_id AS life_time_id_63,
  p0_.shipping_id AS shipping_id_64,
  p0_.suppliers_id AS suppliers_id_65,
  i2_.product_id AS product_id_66,
  i2_.supplier_activity_id AS supplier_activity_id_67,
  c3_.department_id AS department_id_68
FROM
  product p0_
  INNER JOIN attribut a1_ ON p0_.attribut_id = a1_.id
  INNER JOIN image i2_ ON p0_.id = i2_.product_id
  INNER JOIN category c3_ ON p0_.category_id = c3_.id
  INNER JOIN department d4_ ON c3_.department_id = d4_.id
WHERE
  p0_.deleted_at IS NULL
  AND a1_.unit_discount IS NOT NULL
  AND p0_.enabled = ?
  AND c3_.name = ?
  AND i2_.filename IS NOT NULL
ORDER BY
  p0_.id DESC

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, i2_.id AS id_46, i2_.filename AS filename_47, i2_.path AS path_48, i2_.created_at AS created_at_49, i2_.updated_at AS updated_at_50, i2_.deleted_at AS deleted_at_51, i2_.deleted_by AS deleted_by_52, i2_.slug AS slug_53, c3_.id AS id_54, c3_.name AS name_55, c3_.code AS code_56, c3_.priority AS priority_57, c3_.image AS image_58, p0_.attribut_id AS attribut_id_59, p0_.category_id AS category_id_60, p0_.default_image_id AS default_image_id_61, p0_.agent_id AS agent_id_62, p0_.life_time_id AS life_time_id_63, p0_.shipping_id AS shipping_id_64, p0_.suppliers_id AS suppliers_id_65, i2_.product_id AS product_id_66, i2_.supplier_activity_id AS supplier_activity_id_67, c3_.department_id AS department_id_68 FROM product p0_ INNER JOIN attribut a1_ ON p0_.attribut_id = a1_.id INNER JOIN image i2_ ON p0_.id = i2_.product_id INNER JOIN category c3_ ON p0_.category_id = c3_.id INNER JOIN department d4_ ON c3_.department_id = d4_.id WHERE p0_.deleted_at IS NULL AND a1_.unit_discount IS NOT NULL AND p0_.enabled = 1 AND c3_.name = 'Equipements sportifs' AND i2_.filename IS NOT NULL ORDER BY p0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.enabled AS enabled_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.slug AS slug_7,
  t0.has_publicity AS has_publicity_8,
  t0.code AS code_9,
  t0.stockcode AS stockcode_10,
  t0.sales_unit AS sales_unit_11,
  t0.view AS view_12,
  t0.nb_buyers AS nb_buyers_13,
  t0.varieties AS varieties_14,
  t0.quality AS quality_15,
  t0.colors AS colors_16,
  t0.sizes AS sizes_17,
  t0.origin AS origin_18,
  t0.rate AS rate_19,
  t0.expiration_date AS expiration_date_20,
  t0.production_date AS production_date_21,
  t0.nb_rates AS nb_rates_22,
  t0.deleted_at AS deleted_at_23,
  t0.flavors AS flavors_24,
  t0.is_grouped AS is_grouped_25,
  t0.group_slug AS group_slug_26,
  t0.is_collection AS is_collection_27,
  t0.is_agromwinda_promotion AS is_agromwinda_promotion_28,
  t0.enabled_provinces AS enabled_provinces_29,
  t0.attribut_id AS attribut_id_30,
  t0.category_id AS category_id_31,
  t0.default_image_id AS default_image_id_32,
  t0.agent_id AS agent_id_33,
  t0.life_time_id AS life_time_id_34,
  t0.shipping_id AS shipping_id_35,
  t0.suppliers_id AS suppliers_id_36
FROM
  product t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.enabled AS enabled_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.slug AS slug_7, t0.has_publicity AS has_publicity_8, t0.code AS code_9, t0.stockcode AS stockcode_10, t0.sales_unit AS sales_unit_11, t0.view AS view_12, t0.nb_buyers AS nb_buyers_13, t0.varieties AS varieties_14, t0.quality AS quality_15, t0.colors AS colors_16, t0.sizes AS sizes_17, t0.origin AS origin_18, t0.rate AS rate_19, t0.expiration_date AS expiration_date_20, t0.production_date AS production_date_21, t0.nb_rates AS nb_rates_22, t0.deleted_at AS deleted_at_23, t0.flavors AS flavors_24, t0.is_grouped AS is_grouped_25, t0.group_slug AS group_slug_26, t0.is_collection AS is_collection_27, t0.is_agromwinda_promotion AS is_agromwinda_promotion_28, t0.enabled_provinces AS enabled_provinces_29, t0.attribut_id AS attribut_id_30, t0.category_id AS category_id_31, t0.default_image_id AS default_image_id_32, t0.agent_id AS agent_id_33, t0.life_time_id AS life_time_id_34, t0.shipping_id AS shipping_id_35, t0.suppliers_id AS suppliers_id_36 FROM product t0 WHERE t0.category_id = 60;