Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 3
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Serializer
• VichUploader
• Mercure
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.old_id AS old_id_2, t0.username AS username_3, t0.name AS name_4, t0.master_image AS master_image_5, t0.bio AS bio_6, t0.capacity AS capacity_7, t0.etat AS etat_8, t0.comment AS comment_9, t0.statut AS statut_10, t0.pattern AS pattern_11, t0.datetime AS datetime_12, t0.expiration AS expiration_13, t0.slug AS slug_14, t0.view AS view_15, t0.user_id AS user_id_16, t0.brand_id AS brand_id_17, t0.parent_category_id AS parent_category_id_18, t0.category_id AS category_id_19, t0.box_id AS box_id_20 FROM bt_products t0 WHERE t0.id = ?

[
  152938
]

SELECT
  t0.id AS id_1,
  t0.old_id AS old_id_2,
  t0.username AS username_3,
  t0.name AS name_4,
  t0.master_image AS master_image_5,
  t0.bio AS bio_6,
  t0.capacity AS capacity_7,
  t0.etat AS etat_8,
  t0.comment AS comment_9,
  t0.statut AS statut_10,
  t0.pattern AS pattern_11,
  t0.datetime AS datetime_12,
  t0.expiration AS expiration_13,
  t0.slug AS slug_14,
  t0.view AS view_15,
  t0.user_id AS user_id_16,
  t0.brand_id AS brand_id_17,
  t0.parent_category_id AS parent_category_id_18,
  t0.category_id AS category_id_19,
  t0.box_id AS box_id_20
FROM
  bt_products t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.old_id AS old_id_2, t0.username AS username_3, t0.name AS name_4, t0.master_image AS master_image_5, t0.bio AS bio_6, t0.capacity AS capacity_7, t0.etat AS etat_8, t0.comment AS comment_9, t0.statut AS statut_10, t0.pattern AS pattern_11, t0.datetime AS datetime_12, t0.expiration AS expiration_13, t0.slug AS slug_14, t0.view AS view_15, t0.user_id AS user_id_16, t0.brand_id AS brand_id_17, t0.parent_category_id AS parent_category_id_18, t0.category_id AS category_id_19, t0.box_id AS box_id_20 FROM bt_products t0 WHERE t0.id = 152938;

SELECT t0.id AS id_1, t0.title AS title_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.slug AS slug_6, t0.nb_products AS nb_products_7, t0.root_id AS root_id_8, t0.parent_id AS parent_id_9 FROM bt_categories t0 WHERE t0.id = ?

[
  31
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.lft AS lft_3,
  t0.lvl AS lvl_4,
  t0.rgt AS rgt_5,
  t0.slug AS slug_6,
  t0.nb_products AS nb_products_7,
  t0.root_id AS root_id_8,
  t0.parent_id AS parent_id_9
FROM
  bt_categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.slug AS slug_6, t0.nb_products AS nb_products_7, t0.root_id AS root_id_8, t0.parent_id AS parent_id_9 FROM bt_categories t0 WHERE t0.id = 31;

SELECT t0.id AS id_1, t0.title AS title_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.slug AS slug_6, t0.nb_products AS nb_products_7, t0.root_id AS root_id_8, t0.parent_id AS parent_id_9 FROM bt_categories t0 WHERE t0.id = ?

[
  3
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.lft AS lft_3,
  t0.lvl AS lvl_4,
  t0.rgt AS rgt_5,
  t0.slug AS slug_6,
  t0.nb_products AS nb_products_7,
  t0.root_id AS root_id_8,
  t0.parent_id AS parent_id_9
FROM
  bt_categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.slug AS slug_6, t0.nb_products AS nb_products_7, t0.root_id AS root_id_8, t0.parent_id AS parent_id_9 FROM bt_categories t0 WHERE t0.id = 3;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

UPDATE bt_products SET view = ? WHERE id = ?

[
  580
  152938
]

UPDATE
  bt_products
SET
  view = ?
WHERE
  id = ?

UPDATE bt_products SET view = 580 WHERE id = 152938;

"COMMIT"

[]

"COMMIT"

"COMMIT";

SELECT COUNT(b0_.id) AS sclr_0 FROM bt_trocs b1_ LEFT JOIN bt_trocs_products b0_ ON b1_.id = b0_.troc_id WHERE b0_.user_id = b1_.user_slave_id AND b0_.product_id = ?

[
  152938
]

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  bt_trocs b1_
  LEFT JOIN bt_trocs_products b0_ ON b1_.id = b0_.troc_id
WHERE
  b0_.user_id = b1_.user_slave_id
  AND b0_.product_id = ?

SELECT COUNT(b0_.id) AS sclr_0 FROM bt_trocs b1_ LEFT JOIN bt_trocs_products b0_ ON b1_.id = b0_.troc_id WHERE b0_.user_id = b1_.user_slave_id AND b0_.product_id = 152938;

SELECT COUNT(b0_.id) AS sclr_0 FROM bt_trocs b1_ LEFT JOIN bt_trocs_products b0_ ON b1_.id = b0_.troc_id WHERE b0_.product_id = ? AND b1_.termined = 0 AND b1_.canceled = 0

[
  152938
]

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  bt_trocs b1_
  LEFT JOIN bt_trocs_products b0_ ON b1_.id = b0_.troc_id
WHERE
  b0_.product_id = ?
  AND b1_.termined = 0
  AND b1_.canceled = 0

SELECT COUNT(b0_.id) AS sclr_0 FROM bt_trocs b1_ LEFT JOIN bt_trocs_products b0_ ON b1_.id = b0_.troc_id WHERE b0_.product_id = 152938 AND b1_.termined = 0 AND b1_.canceled = 0;

SELECT b0_.id AS id_0, b0_.old_id AS old_id_1, b0_.username AS username_2, b0_.name AS name_3, b0_.master_image AS master_image_4, b0_.bio AS bio_5, b0_.capacity AS capacity_6, b0_.etat AS etat_7, b0_.comment AS comment_8, b0_.statut AS statut_9, b0_.pattern AS pattern_10, b0_.datetime AS datetime_11, b0_.expiration AS expiration_12, b0_.slug AS slug_13, b0_.view AS view_14, b1_.id AS id_15, b1_.title AS title_16, b1_.lft AS lft_17, b1_.lvl AS lvl_18, b1_.rgt AS rgt_19, b1_.slug AS slug_20, b1_.nb_products AS nb_products_21, b2_.id AS id_22, b2_.title AS title_23, b2_.lft AS lft_24, b2_.lvl AS lvl_25, b2_.rgt AS rgt_26, b2_.slug AS slug_27, b2_.nb_products AS nb_products_28, b0_.user_id AS user_id_29, b0_.brand_id AS brand_id_30, b0_.parent_category_id AS parent_category_id_31, b0_.category_id AS category_id_32, b0_.box_id AS box_id_33, b1_.root_id AS root_id_34, b1_.parent_id AS parent_id_35, b2_.root_id AS root_id_36, b2_.parent_id AS parent_id_37 FROM bt_products b0_ LEFT JOIN bt_categories b1_ ON b0_.parent_category_id = b1_.id LEFT JOIN bt_categories b2_ ON b0_.category_id = b2_.id WHERE LOWER(b0_.name) LIKE ? AND b0_.statut = 1 AND b0_.id <> ? ORDER BY LOWER(b0_.name) ASC LIMIT 12

[
  "%hydratant%hydra-zen%"
  152938
]

SELECT
  b0_.id AS id_0,
  b0_.old_id AS old_id_1,
  b0_.username AS username_2,
  b0_.name AS name_3,
  b0_.master_image AS master_image_4,
  b0_.bio AS bio_5,
  b0_.capacity AS capacity_6,
  b0_.etat AS etat_7,
  b0_.comment AS comment_8,
  b0_.statut AS statut_9,
  b0_.pattern AS pattern_10,
  b0_.datetime AS datetime_11,
  b0_.expiration AS expiration_12,
  b0_.slug AS slug_13,
  b0_.view AS view_14,
  b1_.id AS id_15,
  b1_.title AS title_16,
  b1_.lft AS lft_17,
  b1_.lvl AS lvl_18,
  b1_.rgt AS rgt_19,
  b1_.slug AS slug_20,
  b1_.nb_products AS nb_products_21,
  b2_.id AS id_22,
  b2_.title AS title_23,
  b2_.lft AS lft_24,
  b2_.lvl AS lvl_25,
  b2_.rgt AS rgt_26,
  b2_.slug AS slug_27,
  b2_.nb_products AS nb_products_28,
  b0_.user_id AS user_id_29,
  b0_.brand_id AS brand_id_30,
  b0_.parent_category_id AS parent_category_id_31,
  b0_.category_id AS category_id_32,
  b0_.box_id AS box_id_33,
  b1_.root_id AS root_id_34,
  b1_.parent_id AS parent_id_35,
  b2_.root_id AS root_id_36,
  b2_.parent_id AS parent_id_37
FROM
  bt_products b0_
  LEFT JOIN bt_categories b1_ ON b0_.parent_category_id = b1_.id
  LEFT JOIN bt_categories b2_ ON b0_.category_id = b2_.id
WHERE
  LOWER(b0_.name) LIKE ?
  AND b0_.statut = 1
  AND b0_.id <> ?
ORDER BY
  LOWER(b0_.name) ASC
LIMIT
  12

SELECT b0_.id AS id_0, b0_.old_id AS old_id_1, b0_.username AS username_2, b0_.name AS name_3, b0_.master_image AS master_image_4, b0_.bio AS bio_5, b0_.capacity AS capacity_6, b0_.etat AS etat_7, b0_.comment AS comment_8, b0_.statut AS statut_9, b0_.pattern AS pattern_10, b0_.datetime AS datetime_11, b0_.expiration AS expiration_12, b0_.slug AS slug_13, b0_.view AS view_14, b1_.id AS id_15, b1_.title AS title_16, b1_.lft AS lft_17, b1_.lvl AS lvl_18, b1_.rgt AS rgt_19, b1_.slug AS slug_20, b1_.nb_products AS nb_products_21, b2_.id AS id_22, b2_.title AS title_23, b2_.lft AS lft_24, b2_.lvl AS lvl_25, b2_.rgt AS rgt_26, b2_.slug AS slug_27, b2_.nb_products AS nb_products_28, b0_.user_id AS user_id_29, b0_.brand_id AS brand_id_30, b0_.parent_category_id AS parent_category_id_31, b0_.category_id AS category_id_32, b0_.box_id AS box_id_33, b1_.root_id AS root_id_34, b1_.parent_id AS parent_id_35, b2_.root_id AS root_id_36, b2_.parent_id AS parent_id_37 FROM bt_products b0_ LEFT JOIN bt_categories b1_ ON b0_.parent_category_id = b1_.id LEFT JOIN bt_categories b2_ ON b0_.category_id = b2_.id WHERE LOWER(b0_.name) LIKE '%hydratant%hydra-zen%' AND b0_.statut = 1 AND b0_.id <> 152938 ORDER BY LOWER(b0_.name) ASC LIMIT 12;

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.lft AS lft_2, b0_.lvl AS lvl_3, b0_.rgt AS rgt_4, b0_.slug AS slug_5, b0_.nb_products AS nb_products_6 FROM bt_categories b0_ ORDER BY b0_.root_id ASC, b0_.lft ASC

[]

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.lft AS lft_2,
  b0_.lvl AS lvl_3,
  b0_.rgt AS rgt_4,
  b0_.slug AS slug_5,
  b0_.nb_products AS nb_products_6
FROM
  bt_categories b0_
ORDER BY
  b0_.root_id ASC,
  b0_.lft ASC

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.lft AS lft_2, b0_.lvl AS lvl_3, b0_.rgt AS rgt_4, b0_.slug AS slug_5, b0_.nb_products AS nb_products_6 FROM bt_categories b0_ ORDER BY b0_.root_id ASC, b0_.lft ASC;