Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2
FROM
  static_page t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2 FROM static_page t0 WHERE t0.slug = 'categories' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.slug AS slug_2,
  c0_.left_id AS left_id_3,
  c0_.right_id AS right_id_4,
  c0_.level AS level_5,
  c0_.business_key AS business_key_6,
  c0_.show_in_main_page AS show_in_main_page_7,
  c0_.is_enabled AS is_enabled_8,
  c0_.created_at AS created_at_9,
  c0_.updated_at AS updated_at_10,
  c0_.parent_id AS parent_id_11,
  c0_.media_id AS media_id_12
FROM
  category c0_
WHERE
  c0_.parent_id IS NULL
  AND c0_.slug = ?
  AND c0_.is_enabled = 1

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.left_id AS left_id_3, c0_.right_id AS right_id_4, c0_.level AS level_5, c0_.business_key AS business_key_6, c0_.show_in_main_page AS show_in_main_page_7, c0_.is_enabled AS is_enabled_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.parent_id AS parent_id_11, c0_.media_id AS media_id_12 FROM category c0_ WHERE c0_.parent_id IS NULL AND c0_.slug = 'categories' AND c0_.is_enabled = 1;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.is_new AS is_new_3,
  p0_.is_popular AS is_popular_4,
  p0_.width AS width_5,
  p0_.length AS length_6,
  p0_.business_id AS business_id_7,
  p0_.is_active AS is_active_8,
  p0_.is_sold AS is_sold_9,
  p0_.sold_date AS sold_date_10,
  p0_.is_enabled AS is_enabled_11,
  p0_.created_at AS created_at_12,
  p0_.updated_at AS updated_at_13,
  p0_.brand_id AS brand_id_14
FROM
  product p0_
  LEFT JOIN product_category p2_ ON p0_.id = p2_.product_id
  LEFT JOIN category c1_ ON c1_.id = p2_.category_id
  LEFT JOIN category c3_ ON c1_.parent_id = c3_.id
  LEFT JOIN product_variant p4_ ON p0_.id = p4_.product_id
  LEFT JOIN product_translations p5_ ON p0_.id = p5_.translatable_id
  LEFT JOIN variant_properties v7_ ON p4_.id = v7_.variant_id
  LEFT JOIN value v6_ ON v6_.id = v7_.value_id
  LEFT JOIN property p8_ ON v6_.property_id = p8_.id
  INNER JOIN variant_properties v10_ ON p4_.id = v10_.variant_id
  INNER JOIN value v9_ ON v9_.id = v10_.value_id
  INNER JOIN property p11_ ON v9_.property_id = p11_.id
WHERE
  p0_.is_active = 1
  AND p11_.id = ?
  AND v9_.id = ?

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.is_new AS is_new_3, p0_.is_popular AS is_popular_4, p0_.width AS width_5, p0_.length AS length_6, p0_.business_id AS business_id_7, p0_.is_active AS is_active_8, p0_.is_sold AS is_sold_9, p0_.sold_date AS sold_date_10, p0_.is_enabled AS is_enabled_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.brand_id AS brand_id_14 FROM product p0_ LEFT JOIN product_category p2_ ON p0_.id = p2_.product_id LEFT JOIN category c1_ ON c1_.id = p2_.category_id LEFT JOIN category c3_ ON c1_.parent_id = c3_.id LEFT JOIN product_variant p4_ ON p0_.id = p4_.product_id LEFT JOIN product_translations p5_ ON p0_.id = p5_.translatable_id LEFT JOIN variant_properties v7_ ON p4_.id = v7_.variant_id LEFT JOIN value v6_ ON v6_.id = v7_.value_id LEFT JOIN property p8_ ON v6_.property_id = p8_.id INNER JOIN variant_properties v10_ ON p4_.id = v10_.variant_id INNER JOIN value v9_ ON v9_.id = v10_.value_id INNER JOIN property p11_ ON v9_.property_id = p11_.id WHERE p0_.is_active = 1 AND p11_.id = '16' AND v9_.id = '1354';

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.is_available AS is_available_4,
  t0.product_id AS product_id_5
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.is_available AS is_available_4, t0.product_id AS product_id_5 FROM product_variant t0 WHERE t0.product_id = 551021;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.is_available AS is_available_4,
  t0.product_id AS product_id_5
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.is_available AS is_available_4, t0.product_id AS product_id_5 FROM product_variant t0 WHERE t0.product_id = 551134;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.is_available AS is_available_4,
  t0.product_id AS product_id_5
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.is_available AS is_available_4, t0.product_id AS product_id_5 FROM product_variant t0 WHERE t0.product_id = 551617;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.is_available AS is_available_4,
  t0.product_id AS product_id_5
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.is_available AS is_available_4, t0.product_id AS product_id_5 FROM product_variant t0 WHERE t0.product_id = 551676;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.is_available AS is_available_4,
  t0.product_id AS product_id_5
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.is_available AS is_available_4, t0.product_id AS product_id_5 FROM product_variant t0 WHERE t0.product_id = 551872;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.is_available AS is_available_4,
  t0.product_id AS product_id_5
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.is_available AS is_available_4, t0.product_id AS product_id_5 FROM product_variant t0 WHERE t0.product_id = 551977;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.is_available AS is_available_4,
  t0.product_id AS product_id_5
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.is_available AS is_available_4, t0.product_id AS product_id_5 FROM product_variant t0 WHERE t0.product_id = 552186;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.is_available AS is_available_4,
  t0.product_id AS product_id_5
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.is_available AS is_available_4, t0.product_id AS product_id_5 FROM product_variant t0 WHERE t0.product_id = 552187;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.is_available AS is_available_4,
  t0.product_id AS product_id_5
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.is_available AS is_available_4, t0.product_id AS product_id_5 FROM product_variant t0 WHERE t0.product_id = 552188;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.is_available AS is_available_4,
  t0.product_id AS product_id_5
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.is_available AS is_available_4, t0.product_id AS product_id_5 FROM product_variant t0 WHERE t0.product_id = 552199;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.is_available AS is_available_4,
  t0.product_id AS product_id_5
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.is_available AS is_available_4, t0.product_id AS product_id_5 FROM product_variant t0 WHERE t0.product_id = 552205;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.is_available AS is_available_4,
  t0.product_id AS product_id_5
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.is_available AS is_available_4, t0.product_id AS product_id_5 FROM product_variant t0 WHERE t0.product_id = 552374;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.is_available AS is_available_4,
  t0.product_id AS product_id_5
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.is_available AS is_available_4, t0.product_id AS product_id_5 FROM product_variant t0 WHERE t0.product_id = 552670;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.is_available AS is_available_4,
  t0.product_id AS product_id_5
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.is_available AS is_available_4, t0.product_id AS product_id_5 FROM product_variant t0 WHERE t0.product_id = 552756;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.is_available AS is_available_4,
  t0.product_id AS product_id_5
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.is_available AS is_available_4, t0.product_id AS product_id_5 FROM product_variant t0 WHERE t0.product_id = 552757;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.is_available AS is_available_4,
  t0.product_id AS product_id_5
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.is_available AS is_available_4, t0.product_id AS product_id_5 FROM product_variant t0 WHERE t0.product_id = 552766;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.is_available AS is_available_4,
  t0.product_id AS product_id_5
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.is_available AS is_available_4, t0.product_id AS product_id_5 FROM product_variant t0 WHERE t0.product_id = 552824;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.is_available AS is_available_4,
  t0.product_id AS product_id_5
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.is_available AS is_available_4, t0.product_id AS product_id_5 FROM product_variant t0 WHERE t0.product_id = 552853;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.is_available AS is_available_4,
  t0.product_id AS product_id_5
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.is_available AS is_available_4, t0.product_id AS product_id_5 FROM product_variant t0 WHERE t0.product_id = 552885;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.is_available AS is_available_4,
  t0.product_id AS product_id_5
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.is_available AS is_available_4, t0.product_id AS product_id_5 FROM product_variant t0 WHERE t0.product_id = 552910;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.is_available AS is_available_4,
  t0.product_id AS product_id_5
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.is_available AS is_available_4, t0.product_id AS product_id_5 FROM product_variant t0 WHERE t0.product_id = 552913;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.is_available AS is_available_4,
  t0.product_id AS product_id_5
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.is_available AS is_available_4, t0.product_id AS product_id_5 FROM product_variant t0 WHERE t0.product_id = 552914;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.is_available AS is_available_4,
  t0.product_id AS product_id_5
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.is_available AS is_available_4, t0.product_id AS product_id_5 FROM product_variant t0 WHERE t0.product_id = 552915;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.is_available AS is_available_4,
  t0.product_id AS product_id_5
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.is_available AS is_available_4, t0.product_id AS product_id_5 FROM product_variant t0 WHERE t0.product_id = 552916;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.is_available AS is_available_4,
  t0.product_id AS product_id_5
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.is_available AS is_available_4, t0.product_id AS product_id_5 FROM product_variant t0 WHERE t0.product_id = 552917;