Symfony Profiler

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
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.category AS category_2,
  p0_.composition AS composition_3,
  p0_.quantity AS quantity_4,
  p0_.weight AS weight_5,
  p0_.main_image AS main_image_6,
  p0_.price AS price_7,
  p0_.retail_price AS retail_price_8,
  p0_.description AS description_9,
  p0_.ean AS ean_10,
  p0_.slug AS slug_11,
  p0_.stripe_id AS stripe_id_12,
  p0_.color AS color_13,
  p0_.images AS images_14,
  p0_.promotion_rate AS promotion_rate_15,
  p0_.profit_margin AS profit_margin_16,
  p0_.stripe_obj_id AS stripe_obj_id_17,
  p0_.api_last_updated AS api_last_updated_18,
  p0_.selling_price AS selling_price_19,
  p0_.api_id AS api_id_20,
  p0_.media_path AS media_path_21,
  p0_.product_id AS product_id_22
FROM
  product_variant p0_
  INNER JOIN option_value o1_ ON p0_.id = o1_.product_variant_id
WHERE
  p0_.product_id = ?
  AND o1_.value = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.category AS category_2, p0_.composition AS composition_3, p0_.quantity AS quantity_4, p0_.weight AS weight_5, p0_.main_image AS main_image_6, p0_.price AS price_7, p0_.retail_price AS retail_price_8, p0_.description AS description_9, p0_.ean AS ean_10, p0_.slug AS slug_11, p0_.stripe_id AS stripe_id_12, p0_.color AS color_13, p0_.images AS images_14, p0_.promotion_rate AS promotion_rate_15, p0_.profit_margin AS profit_margin_16, p0_.stripe_obj_id AS stripe_obj_id_17, p0_.api_last_updated AS api_last_updated_18, p0_.selling_price AS selling_price_19, p0_.api_id AS api_id_20, p0_.media_path AS media_path_21, p0_.product_id AS product_id_22 FROM product_variant p0_ INNER JOIN option_value o1_ ON p0_.id = o1_.product_variant_id WHERE p0_.product_id = 676 AND o1_.value = 'olive';

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_
WHERE
  o0_.product_variant_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )
  AND o0_.product_option_id = ?
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_ WHERE o0_.product_variant_id IN (4660, 4661, 4662, 4663, 4664, 4665, 4666, 4667, 4668, 4669, 4670, 4671, 4672, 4673, 4674, 4675, 4676, 4677, 4678, 4679, 4680, 4681, 4682, 4683) AND o0_.product_option_id = 1351 GROUP BY o0_.value;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.category AS category_3,
  t0.composition AS composition_4,
  t0.quantity AS quantity_5,
  t0.weight AS weight_6,
  t0.main_image AS main_image_7,
  t0.price AS price_8,
  t0.retail_price AS retail_price_9,
  t0.description AS description_10,
  t0.ean AS ean_11,
  t0.slug AS slug_12,
  t0.stripe_id AS stripe_id_13,
  t0.color AS color_14,
  t0.images AS images_15,
  t0.promotion_rate AS promotion_rate_16,
  t0.profit_margin AS profit_margin_17,
  t0.stripe_obj_id AS stripe_obj_id_18,
  t0.api_last_updated AS api_last_updated_19,
  t0.selling_price AS selling_price_20,
  t0.api_id AS api_id_21,
  t0.media_path AS media_path_22,
  t0.product_id AS product_id_23
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.composition AS composition_4, t0.quantity AS quantity_5, t0.weight AS weight_6, t0.main_image AS main_image_7, t0.price AS price_8, t0.retail_price AS retail_price_9, t0.description AS description_10, t0.ean AS ean_11, t0.slug AS slug_12, t0.stripe_id AS stripe_id_13, t0.color AS color_14, t0.images AS images_15, t0.promotion_rate AS promotion_rate_16, t0.profit_margin AS profit_margin_17, t0.stripe_obj_id AS stripe_obj_id_18, t0.api_last_updated AS api_last_updated_19, t0.selling_price AS selling_price_20, t0.api_id AS api_id_21, t0.media_path AS media_path_22, t0.product_id AS product_id_23 FROM product_variant t0 WHERE t0.product_id = 676;

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
  t0.id AS id_1,
  t0.value AS value_2,
  t0.name AS name_3,
  t0.product_variant_id AS product_variant_id_4,
  t0.product_option_id AS product_option_id_5
FROM
  option_value t0
WHERE
  t0.product_variant_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.name AS name_3, t0.product_variant_id AS product_variant_id_4, t0.product_option_id AS product_option_id_5 FROM option_value t0 WHERE t0.product_variant_id = 4668;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.category AS category_3,
  t0.composition AS composition_4,
  t0.quantity AS quantity_5,
  t0.weight AS weight_6,
  t0.main_image AS main_image_7,
  t0.price AS price_8,
  t0.retail_price AS retail_price_9,
  t0.description AS description_10,
  t0.ean AS ean_11,
  t0.slug AS slug_12,
  t0.stripe_id AS stripe_id_13,
  t0.color AS color_14,
  t0.images AS images_15,
  t0.promotion_rate AS promotion_rate_16,
  t0.profit_margin AS profit_margin_17,
  t0.stripe_obj_id AS stripe_obj_id_18,
  t0.api_last_updated AS api_last_updated_19,
  t0.selling_price AS selling_price_20,
  t0.api_id AS api_id_21,
  t0.media_path AS media_path_22,
  t0.product_id AS product_id_23
FROM
  product_variant t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.composition AS composition_4, t0.quantity AS quantity_5, t0.weight AS weight_6, t0.main_image AS main_image_7, t0.price AS price_8, t0.retail_price AS retail_price_9, t0.description AS description_10, t0.ean AS ean_11, t0.slug AS slug_12, t0.stripe_id AS stripe_id_13, t0.color AS color_14, t0.images AS images_15, t0.promotion_rate AS promotion_rate_16, t0.profit_margin AS profit_margin_17, t0.stripe_obj_id AS stripe_obj_id_18, t0.api_last_updated AS api_last_updated_19, t0.selling_price AS selling_price_20, t0.api_id AS api_id_21, t0.media_path AS media_path_22, t0.product_id AS product_id_23 FROM product_variant t0 WHERE t0.id = '4668';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.composition AS composition_3,
  t0.quantity AS quantity_4,
  t0.weight AS weight_5,
  t0.main_image AS main_image_6,
  t0.price AS price_7,
  t0.retail_price AS retail_price_8,
  t0.description AS description_9,
  t0.ean AS ean_10,
  t0.slug AS slug_11,
  t0.collection_name AS collection_name_12,
  t0.images AS images_13,
  t0.profit_margin AS profit_margin_14,
  t0.promotion_margin AS promotion_margin_15,
  t0.api_last_updated AS api_last_updated_16,
  t0.model_id AS model_id_17,
  t0.api_id AS api_id_18,
  t0.media_path AS media_path_19,
  t0.supplier_id AS supplier_id_20
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.composition AS composition_3, t0.quantity AS quantity_4, t0.weight AS weight_5, t0.main_image AS main_image_6, t0.price AS price_7, t0.retail_price AS retail_price_8, t0.description AS description_9, t0.ean AS ean_10, t0.slug AS slug_11, t0.collection_name AS collection_name_12, t0.images AS images_13, t0.profit_margin AS profit_margin_14, t0.promotion_margin AS promotion_margin_15, t0.api_last_updated AS api_last_updated_16, t0.model_id AS model_id_17, t0.api_id AS api_id_18, t0.media_path AS media_path_19, t0.supplier_id AS supplier_id_20 FROM product t0 WHERE t0.id = '676';

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;

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_
WHERE
  o0_.product_variant_id IN (?, ?, ?, ?, ?, ?, ?, ?)
  AND o0_.product_option_id = ?

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_ WHERE o0_.product_variant_id IN (4668, 4669, 4670, 4671, 4672, 4673, 4674, 4675) AND o0_.product_option_id = 1352;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.product_id AS product_id_3
FROM
  `option` t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.product_id AS product_id_3 FROM `option` t0 WHERE t0.product_id = 676;

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
  INNER JOIN product_category ON t0.id = product_category.category_id
WHERE
  product_category.product_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 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = 676;

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,
  p0_.supplier_id AS supplier_id_19
FROM
  product p0_
WHERE
  EXISTS (
    SELECT
      1
    FROM
      product_category p1_
    WHERE
      p1_.product_id = p0_.id
      AND p1_.category_id IN (NULL)
  )
LIMIT
  10

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, p0_.supplier_id AS supplier_id_19 FROM product p0_ WHERE EXISTS (SELECT 1 FROM product_category p1_ WHERE p1_.product_id = p0_.id AND p1_.category_id IN (NULL)) LIMIT 10;