Symfony Profiler

SELECT 
  c0_.id AS id_0, 
  c0_.lft AS lft_1, 
  c0_.lvl AS lvl_2, 
  c0_.rgt AS rgt_3, 
  c0_.root AS root_4, 
  c0_.created_at AS created_at_5, 
  c0_.updated_at AS updated_at_6, 
  c0_.deleted_at AS deleted_at_7, 
  c0_.active AS active_8, 
  c1_.id AS id_9, 
  c1_.name AS name_10, 
  c1_.metaTitle AS metaTitle_11, 
  c1_.sort_order AS sort_order_12, 
  c1_.created_at AS created_at_13, 
  c1_.updated_at AS updated_at_14, 
  c1_.deleted_at AS deleted_at_15, 
  c1_.culture AS culture_16, 
  c2_.id AS id_17, 
  c2_.lft AS lft_18, 
  c2_.lvl AS lvl_19, 
  c2_.rgt AS rgt_20, 
  c2_.root AS root_21, 
  c2_.created_at AS created_at_22, 
  c2_.updated_at AS updated_at_23, 
  c2_.deleted_at AS deleted_at_24, 
  c2_.active AS active_25, 
  c3_.id AS id_26, 
  c3_.name AS name_27, 
  c3_.metaTitle AS metaTitle_28, 
  c3_.sort_order AS sort_order_29, 
  c3_.created_at AS created_at_30, 
  c3_.updated_at AS updated_at_31, 
  c3_.deleted_at AS deleted_at_32, 
  c3_.culture AS culture_33, 
  c4_.id AS id_34, 
  c4_.sort_order AS sort_order_35, 
  c5_.id AS id_36, 
  c5_.sort_order AS sort_order_37, 
  c0_.parent_id AS parent_id_38, 
  c1_.category_id AS category_id_39, 
  c1_.langage_id AS langage_id_40, 
  c2_.parent_id AS parent_id_41, 
  c3_.category_id AS category_id_42, 
  c3_.langage_id AS langage_id_43, 
  c4_.category_translation_id AS category_translation_id_44, 
  c4_.carac_id AS carac_id_45, 
  c5_.category_translation_id AS category_translation_id_46, 
  c5_.carac_id AS carac_id_47 
FROM 
  category c0_ 
  LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id 
  LEFT JOIN category c2_ ON c0_.parent_id = c2_.id 
  LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id 
  LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id 
  LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id 
WHERE 
  c0_.id = ? 
ORDER BY 
  c4_.sort_order DESC, 
  c5_.sort_order DESC

SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.lvl AS lvl_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c0_.active AS active_8, c1_.id AS id_9, c1_.name AS name_10, c1_.metaTitle AS metaTitle_11, c1_.sort_order AS sort_order_12, c1_.created_at AS created_at_13, c1_.updated_at AS updated_at_14, c1_.deleted_at AS deleted_at_15, c1_.culture AS culture_16, c2_.id AS id_17, c2_.lft AS lft_18, c2_.lvl AS lvl_19, c2_.rgt AS rgt_20, c2_.root AS root_21, c2_.created_at AS created_at_22, c2_.updated_at AS updated_at_23, c2_.deleted_at AS deleted_at_24, c2_.active AS active_25, c3_.id AS id_26, c3_.name AS name_27, c3_.metaTitle AS metaTitle_28, c3_.sort_order AS sort_order_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.deleted_at AS deleted_at_32, c3_.culture AS culture_33, c4_.id AS id_34, c4_.sort_order AS sort_order_35, c5_.id AS id_36, c5_.sort_order AS sort_order_37, c0_.parent_id AS parent_id_38, c1_.category_id AS category_id_39, c1_.langage_id AS langage_id_40, c2_.parent_id AS parent_id_41, c3_.category_id AS category_id_42, c3_.langage_id AS langage_id_43, c4_.category_translation_id AS category_translation_id_44, c4_.carac_id AS carac_id_45, c5_.category_translation_id AS category_translation_id_46, c5_.carac_id AS carac_id_47 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id LEFT JOIN category c2_ ON c0_.parent_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id LEFT JOIN category_title c4_ ON c1_.id = c4_.category_translation_id LEFT JOIN category_title c5_ ON c3_.id = c5_.category_translation_id WHERE c0_.id = 1 ORDER BY c4_.sort_order DESC, c5_.sort_order DESC;

SELECT 
  MAX(p0_.price) AS sclr_0, 
  MIN(p0_.price) AS sclr_1 
FROM 
  product p0_ 
  INNER JOIN category c1_ ON p0_.category_id = c1_.id 
WHERE 
  p0_.status = ? 
  AND c1_.lft >= ? 
  AND c1_.rgt <= ? 
  AND c1_.root = ?

SELECT MAX(p0_.price) AS sclr_0, MIN(p0_.price) AS sclr_1 FROM product p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id WHERE p0_.status = 'VALIDATED' AND c1_.lft >= 1 AND c1_.rgt <= 296 AND c1_.root = 1;

SELECT 
  COUNT(*) AS dctrn_count 
FROM 
  (
    SELECT 
      DISTINCT id_0 
    FROM 
      (
        SELECT 
          p0_.id AS id_0, 
          p0_.created_at AS created_at_1, 
          p0_.updated_at AS updated_at_2, 
          p0_.deleted_at AS deleted_at_3, 
          p0_.price AS price_4, 
          p0_.quantity AS quantity_5, 
          p0_.initial_stock AS initial_stock_6, 
          p0_.status AS status_7, 
          p0_.featured AS featured_8, 
          p0_.reassortable AS reassortable_9, 
          p0_.km AS km_10, 
          p0_.db AS db_11, 
          p0_.is_published AS is_published_12, 
          p0_.weight AS weight_13, 
          i1_.id AS id_14, 
          i1_.name AS name_15, 
          p2_.id AS id_16, 
          p2_.title AS title_17, 
          p2_.description AS description_18, 
          p2_.head AS head_19, 
          p2_.reverse AS reverse_20, 
          p2_.comment AS comment_21, 
          p2_.notes AS notes_22, 
          p2_.head_caption AS head_caption_23, 
          p2_.reverse_caption AS reverse_caption_24, 
          p2_.culture AS culture_25 
        FROM 
          product p0_ 
          INNER JOIN image i1_ ON p0_.id = i1_.product_id 
          INNER JOIN product_translation p2_ ON p0_.id = p2_.product_id 
          INNER JOIN category c3_ ON p0_.category_id = c3_.id 
          INNER JOIN product_caracteristicvalue p5_ ON p0_.id = p5_.product_id 
          INNER JOIN caracteristic_value c4_ ON c4_.id = p5_.carac_value_id 
        WHERE 
          p0_.status = ? 
          AND p0_.quantity >= 1 
          AND p0_.price >= ? 
          AND p0_.price <= ? 
          AND c3_.lft >= ? 
          AND c3_.rgt <= ? 
          AND c3_.root = ? 
          AND c4_.carac_id = 170 
        ORDER BY 
          p0_.price DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.deleted_at AS deleted_at_3, p0_.price AS price_4, p0_.quantity AS quantity_5, p0_.initial_stock AS initial_stock_6, p0_.status AS status_7, p0_.featured AS featured_8, p0_.reassortable AS reassortable_9, p0_.km AS km_10, p0_.db AS db_11, p0_.is_published AS is_published_12, p0_.weight AS weight_13, i1_.id AS id_14, i1_.name AS name_15, p2_.id AS id_16, p2_.title AS title_17, p2_.description AS description_18, p2_.head AS head_19, p2_.reverse AS reverse_20, p2_.comment AS comment_21, p2_.notes AS notes_22, p2_.head_caption AS head_caption_23, p2_.reverse_caption AS reverse_caption_24, p2_.culture AS culture_25 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN product_translation p2_ ON p0_.id = p2_.product_id INNER JOIN category c3_ ON p0_.category_id = c3_.id INNER JOIN product_caracteristicvalue p5_ ON p0_.id = p5_.product_id INNER JOIN caracteristic_value c4_ ON c4_.id = p5_.carac_value_id WHERE p0_.status = 'VALIDATED' AND p0_.quantity >= 1 AND p0_.price >= '9.99' AND p0_.price <= '1000.00' AND c3_.lft >= 1 AND c3_.rgt <= 296 AND c3_.root = 1 AND c4_.carac_id = 170 ORDER BY p0_.price DESC) dctrn_result) dctrn_table;

SELECT 
  DISTINCT id_0 
FROM 
  (
    SELECT 
      p0_.id AS id_0, 
      p0_.created_at AS created_at_1, 
      p0_.updated_at AS updated_at_2, 
      p0_.deleted_at AS deleted_at_3, 
      p0_.price AS price_4, 
      p0_.quantity AS quantity_5, 
      p0_.initial_stock AS initial_stock_6, 
      p0_.status AS status_7, 
      p0_.featured AS featured_8, 
      p0_.reassortable AS reassortable_9, 
      p0_.km AS km_10, 
      p0_.db AS db_11, 
      p0_.is_published AS is_published_12, 
      p0_.weight AS weight_13, 
      i1_.id AS id_14, 
      i1_.name AS name_15, 
      p2_.id AS id_16, 
      p2_.title AS title_17, 
      p2_.description AS description_18, 
      p2_.head AS head_19, 
      p2_.reverse AS reverse_20, 
      p2_.comment AS comment_21, 
      p2_.notes AS notes_22, 
      p2_.head_caption AS head_caption_23, 
      p2_.reverse_caption AS reverse_caption_24, 
      p2_.culture AS culture_25, 
      c3_.lft AS lft_26, 
      c3_.rgt AS rgt_27, 
      c3_.root AS root_28 
    FROM 
      product p0_ 
      INNER JOIN image i1_ ON p0_.id = i1_.product_id 
      INNER JOIN product_translation p2_ ON p0_.id = p2_.product_id 
      INNER JOIN category c3_ ON p0_.category_id = c3_.id 
      INNER JOIN product_caracteristicvalue p5_ ON p0_.id = p5_.product_id 
      INNER JOIN caracteristic_value c4_ ON c4_.id = p5_.carac_value_id 
    WHERE 
      p0_.status = ? 
      AND p0_.quantity >= 1 
      AND p0_.price >= ? 
      AND p0_.price <= ? 
      AND c3_.lft >= ? 
      AND c3_.rgt <= ? 
      AND c3_.root = ? 
      AND c4_.carac_id = 170
  ) dctrn_result 
ORDER BY 
  price_4 DESC 
LIMIT 
  21 OFFSET 0

SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.deleted_at AS deleted_at_3, p0_.price AS price_4, p0_.quantity AS quantity_5, p0_.initial_stock AS initial_stock_6, p0_.status AS status_7, p0_.featured AS featured_8, p0_.reassortable AS reassortable_9, p0_.km AS km_10, p0_.db AS db_11, p0_.is_published AS is_published_12, p0_.weight AS weight_13, i1_.id AS id_14, i1_.name AS name_15, p2_.id AS id_16, p2_.title AS title_17, p2_.description AS description_18, p2_.head AS head_19, p2_.reverse AS reverse_20, p2_.comment AS comment_21, p2_.notes AS notes_22, p2_.head_caption AS head_caption_23, p2_.reverse_caption AS reverse_caption_24, p2_.culture AS culture_25, c3_.lft AS lft_26, c3_.rgt AS rgt_27, c3_.root AS root_28 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN product_translation p2_ ON p0_.id = p2_.product_id INNER JOIN category c3_ ON p0_.category_id = c3_.id INNER JOIN product_caracteristicvalue p5_ ON p0_.id = p5_.product_id INNER JOIN caracteristic_value c4_ ON c4_.id = p5_.carac_value_id WHERE p0_.status = 'VALIDATED' AND p0_.quantity >= 1 AND p0_.price >= '9.99' AND p0_.price <= '1000.00' AND c3_.lft >= 1 AND c3_.rgt <= 296 AND c3_.root = 1 AND c4_.carac_id = 170) dctrn_result ORDER BY price_4 DESC LIMIT 21 OFFSET 0;

SELECT 
  p0_.id AS id_0, 
  p0_.created_at AS created_at_1, 
  p0_.updated_at AS updated_at_2, 
  p0_.deleted_at AS deleted_at_3, 
  p0_.price AS price_4, 
  p0_.quantity AS quantity_5, 
  p0_.initial_stock AS initial_stock_6, 
  p0_.status AS status_7, 
  p0_.featured AS featured_8, 
  p0_.reassortable AS reassortable_9, 
  p0_.km AS km_10, 
  p0_.db AS db_11, 
  p0_.is_published AS is_published_12, 
  p0_.weight AS weight_13, 
  i1_.id AS id_14, 
  i1_.name AS name_15, 
  p2_.id AS id_16, 
  p2_.title AS title_17, 
  p2_.description AS description_18, 
  p2_.head AS head_19, 
  p2_.reverse AS reverse_20, 
  p2_.comment AS comment_21, 
  p2_.notes AS notes_22, 
  p2_.head_caption AS head_caption_23, 
  p2_.reverse_caption AS reverse_caption_24, 
  p2_.culture AS culture_25, 
  p0_.created_by AS created_by_26, 
  p0_.updated_by AS updated_by_27, 
  p0_.tax_id AS tax_id_28, 
  p0_.category_id AS category_id_29, 
  i1_.product_id AS product_id_30, 
  p2_.langage_id AS langage_id_31, 
  p2_.product_id AS product_id_32 
FROM 
  product p0_ 
  INNER JOIN image i1_ ON p0_.id = i1_.product_id 
  INNER JOIN product_translation p2_ ON p0_.id = p2_.product_id 
  INNER JOIN category c3_ ON p0_.category_id = c3_.id 
  INNER JOIN product_caracteristicvalue p5_ ON p0_.id = p5_.product_id 
  INNER JOIN caracteristic_value c4_ ON c4_.id = p5_.carac_value_id 
WHERE 
  p0_.status = ? 
  AND p0_.quantity >= 1 
  AND p0_.price >= ? 
  AND p0_.price <= ? 
  AND c3_.lft >= ? 
  AND c3_.rgt <= ? 
  AND c3_.root = ? 
  AND c4_.carac_id = 170 
  AND p0_.id IN (?) 
ORDER BY 
  p0_.price DESC

SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.deleted_at AS deleted_at_3, p0_.price AS price_4, p0_.quantity AS quantity_5, p0_.initial_stock AS initial_stock_6, p0_.status AS status_7, p0_.featured AS featured_8, p0_.reassortable AS reassortable_9, p0_.km AS km_10, p0_.db AS db_11, p0_.is_published AS is_published_12, p0_.weight AS weight_13, i1_.id AS id_14, i1_.name AS name_15, p2_.id AS id_16, p2_.title AS title_17, p2_.description AS description_18, p2_.head AS head_19, p2_.reverse AS reverse_20, p2_.comment AS comment_21, p2_.notes AS notes_22, p2_.head_caption AS head_caption_23, p2_.reverse_caption AS reverse_caption_24, p2_.culture AS culture_25, p0_.created_by AS created_by_26, p0_.updated_by AS updated_by_27, p0_.tax_id AS tax_id_28, p0_.category_id AS category_id_29, i1_.product_id AS product_id_30, p2_.langage_id AS langage_id_31, p2_.product_id AS product_id_32 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN product_translation p2_ ON p0_.id = p2_.product_id INNER JOIN category c3_ ON p0_.category_id = c3_.id INNER JOIN product_caracteristicvalue p5_ ON p0_.id = p5_.product_id INNER JOIN caracteristic_value c4_ ON c4_.id = p5_.carac_value_id WHERE p0_.status = 'VALIDATED' AND p0_.quantity >= 1 AND p0_.price >= '9.99' AND p0_.price <= '1000.00' AND c3_.lft >= 1 AND c3_.rgt <= 296 AND c3_.root = 1 AND c4_.carac_id = 170 AND p0_.id IN (1, 2180, 2435, 2747, 1480, 2434, 3650, 3671, 3691, 3672, 3692, 3673, 3693, 3675, 3694, 3676, 3695, 3677, 3696, 3658, 3678) ORDER BY p0_.price DESC;

SELECT 
  p0_.id AS id_0, 
  p0_.created_at AS created_at_1, 
  p0_.updated_at AS updated_at_2, 
  p0_.deleted_at AS deleted_at_3, 
  p0_.price AS price_4, 
  p0_.quantity AS quantity_5, 
  p0_.initial_stock AS initial_stock_6, 
  p0_.status AS status_7, 
  p0_.featured AS featured_8, 
  p0_.reassortable AS reassortable_9, 
  p0_.km AS km_10, 
  p0_.db AS db_11, 
  p0_.is_published AS is_published_12, 
  p0_.weight AS weight_13, 
  p1_.id AS id_14, 
  p1_.title AS title_15, 
  p1_.description AS description_16, 
  p1_.head AS head_17, 
  p1_.reverse AS reverse_18, 
  p1_.comment AS comment_19, 
  p1_.notes AS notes_20, 
  p1_.head_caption AS head_caption_21, 
  p1_.reverse_caption AS reverse_caption_22, 
  p1_.culture AS culture_23, 
  i2_.id AS id_24, 
  i2_.name AS name_25, 
  p0_.created_by AS created_by_26, 
  p0_.updated_by AS updated_by_27, 
  p0_.tax_id AS tax_id_28, 
  p0_.category_id AS category_id_29, 
  p1_.langage_id AS langage_id_30, 
  p1_.product_id AS product_id_31, 
  i2_.product_id AS product_id_32 
FROM 
  product p0_ 
  INNER JOIN product_translation p1_ ON p0_.id = p1_.product_id 
  INNER JOIN image i2_ ON p0_.id = i2_.product_id 
WHERE 
  p0_.status = ? 
  AND p0_.id IN (?)

SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.deleted_at AS deleted_at_3, p0_.price AS price_4, p0_.quantity AS quantity_5, p0_.initial_stock AS initial_stock_6, p0_.status AS status_7, p0_.featured AS featured_8, p0_.reassortable AS reassortable_9, p0_.km AS km_10, p0_.db AS db_11, p0_.is_published AS is_published_12, p0_.weight AS weight_13, p1_.id AS id_14, p1_.title AS title_15, p1_.description AS description_16, p1_.head AS head_17, p1_.reverse AS reverse_18, p1_.comment AS comment_19, p1_.notes AS notes_20, p1_.head_caption AS head_caption_21, p1_.reverse_caption AS reverse_caption_22, p1_.culture AS culture_23, i2_.id AS id_24, i2_.name AS name_25, p0_.created_by AS created_by_26, p0_.updated_by AS updated_by_27, p0_.tax_id AS tax_id_28, p0_.category_id AS category_id_29, p1_.langage_id AS langage_id_30, p1_.product_id AS product_id_31, i2_.product_id AS product_id_32 FROM product p0_ INNER JOIN product_translation p1_ ON p0_.id = p1_.product_id INNER JOIN image i2_ ON p0_.id = i2_.product_id WHERE p0_.status = 'VALIDATED' AND p0_.id IN ();