Symfony Profiler

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 
  AND (
    (
      i2_.product_id = p0_.id 
      AND (
        i2_.name LIKE '%r.web%' 
        OR i2_.name LIKE '%a.web%' 
        OR i2_.name LIKE '%-1.web%' 
        OR i2_.name LIKE '%-2.web%'
      )
    )
  ) 
WHERE 
  p0_.status = ? 
  AND p1_.culture = ? 
  AND p0_.quantity >= 1 
GROUP BY 
  p0_.id, 
  i2_.id 
ORDER BY 
  p0_.id DESC 
LIMIT 
  24

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 AND ((i2_.product_id = p0_.id AND (i2_.name LIKE '%r.web%' OR i2_.name LIKE '%a.web%' OR i2_.name LIKE '%-1.web%' OR i2_.name LIKE '%-2.web%'))) WHERE p0_.status = 'VALIDATED' AND p1_.culture = 'fr' AND p0_.quantity >= 1 GROUP BY p0_.id, i2_.id ORDER BY p0_.id DESC LIMIT 24;

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 
  AND (
    (
      i2_.product_id = p0_.id 
      AND (
        i2_.name LIKE '%r.web%' 
        OR i2_.name LIKE '%a.web%' 
        OR i2_.name LIKE '%-1.web%' 
        OR i2_.name LIKE '%-2.web%'
      )
    )
  ) 
WHERE 
  p0_.status = ? 
  AND p1_.culture = ? 
  AND p0_.featured = 1 
  AND p0_.quantity >= 1 
GROUP BY 
  p0_.id, 
  i2_.id 
ORDER BY 
  p0_.id DESC 
LIMIT 
  12

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 AND ((i2_.product_id = p0_.id AND (i2_.name LIKE '%r.web%' OR i2_.name LIKE '%a.web%' OR i2_.name LIKE '%-1.web%' OR i2_.name LIKE '%-2.web%'))) WHERE p0_.status = 'VALIDATED' AND p1_.culture = 'fr' AND p0_.featured = 1 AND p0_.quantity >= 1 GROUP BY p0_.id, i2_.id ORDER BY p0_.id DESC LIMIT 12;

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 = 24 ORDER BY c4_.sort_order DESC, c5_.sort_order 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_.quantity >= 1 
  AND p1_.culture = ? 
GROUP BY 
  i2_.id 
ORDER BY 
  p0_.price DESC 
LIMIT 
  2

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_.quantity >= 1 AND p1_.culture = 'fr' GROUP BY i2_.id ORDER BY p0_.price DESC LIMIT 2;

SELECT 
  t0.id AS id_1, 
  t0.username AS username_2, 
  t0.username_canonical AS username_canonical_3, 
  t0.firstname AS firstname_4, 
  t0.lastname AS lastname_5, 
  t0.email AS email_6, 
  t0.email_canonical AS email_canonical_7, 
  t0.salt AS salt_8, 
  t0.password AS password_9, 
  t0.enabled AS enabled_10, 
  t0.role AS role_11, 
  t0.type AS type_12, 
  t0.active AS active_13, 
  t0.created_at AS created_at_14, 
  t0.updated_at AS updated_at_15, 
  t0.deleted_at AS deleted_at_16, 
  t0.confirmationToken AS confirmationToken_17, 
  t0.passwordRequestedAt AS passwordRequestedAt_18, 
  t0.optinEmail AS optinEmail_19, 
  t0.anonymized AS anonymized_20, 
  t0.langage_id AS langage_id_21 
FROM 
  customer t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.username_canonical AS username_canonical_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.email_canonical AS email_canonical_7, t0.salt AS salt_8, t0.password AS password_9, t0.enabled AS enabled_10, t0.role AS role_11, t0.type AS type_12, t0.active AS active_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.confirmationToken AS confirmationToken_17, t0.passwordRequestedAt AS passwordRequestedAt_18, t0.optinEmail AS optinEmail_19, t0.anonymized AS anonymized_20, t0.langage_id AS langage_id_21 FROM customer t0 WHERE t0.id = 101;