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.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.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
  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 = '736';

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 = '6828';

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 = 6828;

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 = 736 AND o1_.value = 'navy';

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 = 736;

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 = 736;

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 (6828, 6829, 6830, 6831, 6832, 6833, 6834, 6835, 6836, 6837, 6838, 6839, 6840, 6841, 6842, 6843, 6844, 6845, 6846, 6847, 6848, 6849, 6850, 6851, 6852, 6853, 6854, 6855, 6856, 6857, 6858, 6859, 6860, 6861, 6862, 6863, 6864, 6865, 6866, 6867, 6868, 6869, 6870, 6871, 6872, 6873, 6874, 6875, 6876, 6877, 6878, 6879, 6880, 6881, 6882, 6883, 6884, 6885, 6886, 6887, 6888, 6889, 6890, 6891, 6892, 6893, 6894, 6895, 6896, 6897, 6898, 6899, 6900, 6901, 6902, 6903, 6904, 6905, 6906, 6907, 6908, 6909, 6910, 6911, 6912, 6913, 6914, 6915, 6916, 6917, 6918, 6919, 6920, 6921, 6922, 6923, 6924, 6925, 6926, 6927, 6928, 6929, 6930, 6931, 6932, 6933, 6934) AND o0_.product_option_id = 1471 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  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 (6828, 6829, 6830, 6831, 6832, 6833, 6834, 6835, 6836, 6837) AND o0_.product_option_id = 1472;

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 = 736;

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;

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
  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 = 144;

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 = 148;

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 = 150;

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 = 152;

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 = 154;

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 = ?