Symfony Profiler

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '28' AND e0_.locale = 'es' AND e0_.object_class = 'App\\Entity\\Category';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.level AS level_4,
  t0.image AS image_5,
  t0.slug AS slug_6,
  t0.parent_category_id AS parent_category_id_7
FROM
  category t0
WHERE
  t0.parent_category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.level AS level_4, t0.image AS image_5, t0.slug AS slug_6, t0.parent_category_id AS parent_category_id_7 FROM category t0 WHERE t0.parent_category_id = 4;

SELECT
  o0_.id AS id_0,
  o0_.value AS value_1,
  o0_.name AS name_2,
  o0_.product_variant_id AS product_variant_id_3,
  o0_.product_option_id AS product_option_id_4
FROM
  option_value o0_
  INNER JOIN product_variant p1_ ON o0_.product_variant_id = p1_.id
  INNER JOIN product p2_ ON p1_.product_id = p2_.id
  INNER JOIN product_category p4_ ON p2_.id = p4_.product_id
  INNER JOIN category c3_ ON c3_.id = p4_.category_id
WHERE
  c3_.id = ?
  AND o0_.name = ?
GROUP BY
  o0_.value

SELECT o0_.id AS id_0, o0_.value AS value_1, o0_.name AS name_2, o0_.product_variant_id AS product_variant_id_3, o0_.product_option_id AS product_option_id_4 FROM option_value o0_ INNER JOIN product_variant p1_ ON o0_.product_variant_id = p1_.id INNER JOIN product p2_ ON p1_.product_id = p2_.id INNER JOIN product_category p4_ ON p2_.id = p4_.product_id INNER JOIN category c3_ ON c3_.id = p4_.category_id WHERE c3_.id = 28 AND o0_.name = 'Color' GROUP BY o0_.value;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.composition AS composition_2,
  p0_.quantity AS quantity_3,
  p0_.weight AS weight_4,
  p0_.main_image AS main_image_5,
  p0_.price AS price_6,
  p0_.retail_price AS retail_price_7,
  p0_.description AS description_8,
  p0_.ean AS ean_9,
  p0_.slug AS slug_10,
  p0_.collection_name AS collection_name_11,
  p0_.images AS images_12,
  p0_.profit_margin AS profit_margin_13,
  p0_.promotion_margin AS promotion_margin_14,
  p0_.api_last_updated AS api_last_updated_15,
  p0_.model_id AS model_id_16,
  p0_.api_id AS api_id_17,
  p0_.media_path AS media_path_18,
  p1_.id AS id_19,
  p1_.name AS name_20,
  p1_.category AS category_21,
  p1_.composition AS composition_22,
  p1_.quantity AS quantity_23,
  p1_.weight AS weight_24,
  p1_.main_image AS main_image_25,
  p1_.price AS price_26,
  p1_.retail_price AS retail_price_27,
  p1_.description AS description_28,
  p1_.ean AS ean_29,
  p1_.slug AS slug_30,
  p1_.stripe_id AS stripe_id_31,
  p1_.color AS color_32,
  p1_.images AS images_33,
  p1_.promotion_rate AS promotion_rate_34,
  p1_.profit_margin AS profit_margin_35,
  p1_.stripe_obj_id AS stripe_obj_id_36,
  p1_.api_last_updated AS api_last_updated_37,
  p1_.selling_price AS selling_price_38,
  p1_.api_id AS api_id_39,
  p1_.media_path AS media_path_40,
  o2_.id AS id_41,
  o2_.value AS value_42,
  o2_.name AS name_43,
  o3_.id AS id_44,
  o3_.value AS value_45,
  o3_.name AS name_46,
  p0_.supplier_id AS supplier_id_47,
  p1_.product_id AS product_id_48,
  o2_.product_variant_id AS product_variant_id_49,
  o2_.product_option_id AS product_option_id_50,
  o3_.product_variant_id AS product_variant_id_51,
  o3_.product_option_id AS product_option_id_52
FROM
  product p0_
  LEFT JOIN product_variant p1_ ON p0_.id = p1_.product_id
  LEFT JOIN option_value o2_ ON p1_.id = o2_.product_variant_id
  AND (o2_.name = ?)
  LEFT JOIN option_value o3_ ON p1_.id = o3_.product_variant_id
  AND (o3_.name = ?)
WHERE
  EXISTS (
    SELECT
      1
    FROM
      product_category p4_
    WHERE
      p4_.product_id = p0_.id
      AND p4_.category_id IN (?)
  )
GROUP BY
  p1_.color

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.composition AS composition_2, p0_.quantity AS quantity_3, p0_.weight AS weight_4, p0_.main_image AS main_image_5, p0_.price AS price_6, p0_.retail_price AS retail_price_7, p0_.description AS description_8, p0_.ean AS ean_9, p0_.slug AS slug_10, p0_.collection_name AS collection_name_11, p0_.images AS images_12, p0_.profit_margin AS profit_margin_13, p0_.promotion_margin AS promotion_margin_14, p0_.api_last_updated AS api_last_updated_15, p0_.model_id AS model_id_16, p0_.api_id AS api_id_17, p0_.media_path AS media_path_18, p1_.id AS id_19, p1_.name AS name_20, p1_.category AS category_21, p1_.composition AS composition_22, p1_.quantity AS quantity_23, p1_.weight AS weight_24, p1_.main_image AS main_image_25, p1_.price AS price_26, p1_.retail_price AS retail_price_27, p1_.description AS description_28, p1_.ean AS ean_29, p1_.slug AS slug_30, p1_.stripe_id AS stripe_id_31, p1_.color AS color_32, p1_.images AS images_33, p1_.promotion_rate AS promotion_rate_34, p1_.profit_margin AS profit_margin_35, p1_.stripe_obj_id AS stripe_obj_id_36, p1_.api_last_updated AS api_last_updated_37, p1_.selling_price AS selling_price_38, p1_.api_id AS api_id_39, p1_.media_path AS media_path_40, o2_.id AS id_41, o2_.value AS value_42, o2_.name AS name_43, o3_.id AS id_44, o3_.value AS value_45, o3_.name AS name_46, p0_.supplier_id AS supplier_id_47, p1_.product_id AS product_id_48, o2_.product_variant_id AS product_variant_id_49, o2_.product_option_id AS product_option_id_50, o3_.product_variant_id AS product_variant_id_51, o3_.product_option_id AS product_option_id_52 FROM product p0_ LEFT JOIN product_variant p1_ ON p0_.id = p1_.product_id LEFT JOIN option_value o2_ ON p1_.id = o2_.product_variant_id AND (o2_.name = 'Color') LEFT JOIN option_value o3_ ON p1_.id = o3_.product_variant_id AND (o3_.name = 'Size') WHERE EXISTS (SELECT 1 FROM product_category p4_ WHERE p4_.product_id = p0_.id AND p4_.category_id IN (28)) GROUP BY p1_.color;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.level AS level_4,
  t0.image AS image_5,
  t0.slug AS slug_6,
  t0.parent_category_id AS parent_category_id_7
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.level AS level_4, t0.image AS image_5, t0.slug AS slug_6, t0.parent_category_id AS parent_category_id_7 FROM category t0 WHERE t0.id = '28';

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  category c1_
  INNER JOIN product_category p2_ ON c1_.id = p2_.category_id
  INNER JOIN product p0_ ON p0_.id = p2_.product_id
WHERE
  c1_.id = ?

SELECT COUNT(p0_.id) AS sclr_0 FROM category c1_ INNER JOIN product_category p2_ ON c1_.id = p2_.category_id INNER JOIN product p0_ ON p0_.id = p2_.product_id WHERE c1_.id = 28;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.level AS level_4,
  t0.image AS image_5,
  t0.slug AS slug_6,
  t0.parent_category_id AS parent_category_id_7
FROM
  category t0
WHERE
  t0.level = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.level AS level_4, t0.image AS image_5, t0.slug AS slug_6, t0.parent_category_id AS parent_category_id_7 FROM category t0 WHERE t0.level = 1;

SELECT
  MAX(p0_.price) AS sclr_0,
  MIN(p0_.price) AS sclr_1
FROM
  product_variant p0_
  INNER JOIN product p1_ ON p0_.product_id = p1_.id
  INNER JOIN product_category p3_ ON p1_.id = p3_.product_id
  INNER JOIN category c2_ ON c2_.id = p3_.category_id
WHERE
  c2_.id = ?

SELECT MAX(p0_.price) AS sclr_0, MIN(p0_.price) AS sclr_1 FROM product_variant p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id INNER JOIN product_category p3_ ON p1_.id = p3_.product_id INNER JOIN category c2_ ON c2_.id = p3_.category_id WHERE c2_.id = 28;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.level AS level_4,
  t0.image AS image_5,
  t0.slug AS slug_6,
  t0.parent_category_id AS parent_category_id_7
FROM
  category t0
WHERE
  t0.parent_category_id = ?
  AND t0.level = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.level AS level_4, t0.image AS image_5, t0.slug AS slug_6, t0.parent_category_id AS parent_category_id_7 FROM category t0 WHERE t0.parent_category_id = 1 AND t0.level = 2;