Symfony Profiler

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

Query Metrics

SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.need_password_update AS need_password_update_4, t0.tryout AS tryout_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.image AS image_10, t0.theme AS theme_11, t0.status AS status_12, t0.last_login AS last_login_13, t0.last_activity AS last_activity_14, t0.note AS note_15, t0.acl AS acl_16, t0.widgets AS widgets_17, t0.preferences AS preferences_18, t0.notification AS notification_19, t0.id AS id_20, t0.uuid AS uuid_21, t0.company_id AS company_id_22 FROM user t0 WHERE t0.id = ?

[
  2
]

SELECT
  t0.email AS email_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.need_password_update AS need_password_update_4,
  t0.tryout AS tryout_5,
  t0.firstname AS firstname_6,
  t0.lastname AS lastname_7,
  t0.phone AS phone_8,
  t0.mobile AS mobile_9,
  t0.image AS image_10,
  t0.theme AS theme_11,
  t0.status AS status_12,
  t0.last_login AS last_login_13,
  t0.last_activity AS last_activity_14,
  t0.note AS note_15,
  t0.acl AS acl_16,
  t0.widgets AS widgets_17,
  t0.preferences AS preferences_18,
  t0.notification AS notification_19,
  t0.id AS id_20,
  t0.uuid AS uuid_21,
  t0.company_id AS company_id_22
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.need_password_update AS need_password_update_4, t0.tryout AS tryout_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.image AS image_10, t0.theme AS theme_11, t0.status AS status_12, t0.last_login AS last_login_13, t0.last_activity AS last_activity_14, t0.note AS note_15, t0.acl AS acl_16, t0.widgets AS widgets_17, t0.preferences AS preferences_18, t0.notification AS notification_19, t0.id AS id_20, t0.uuid AS uuid_21, t0.company_id AS company_id_22 FROM user t0 WHERE t0.id = 2;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

UPDATE user SET last_activity = ? WHERE id = ?

[
  "2025-07-07 15:19:12"
  2
]

UPDATE
  user
SET
  last_activity = ?
WHERE
  id = ?

UPDATE user SET last_activity = '2025-07-07 15:19:12' WHERE id = 2;

"COMMIT"

[]

"COMMIT"

"COMMIT";

SELECT o.id, o.uuid, o.vintage, o.type as offerType, o.price, o.qty, o.unoficial_price, o.unoficial_qty, o.format_filled, f.name as formatName, pack.name as packagingName, o.packaging_flat, o.packaging_value, o.is_flat, o.comment, e.provisioning, o.status, vint.price as releasePrice, vint.recommended_price as recommandedPrice,
    CASE
        WHEN e.display_name IS NOT NULL AND e.display_name != '' 
            THEN e.display_name 
        ELSE e.name 
    END AS entityDisplayName,
    CASE
        WHEN pr.display_name IS NOT NULL AND pr.display_name != '' 
            THEN pr.display_name 
        ELSE pr.name 
    END AS productDisplayName
    FROM offer o
    LEFT JOIN entity e ON o.entity_id = e.id
    LEFT JOIN product pr ON o.product_id = pr.id
    LEFT JOIN product_format f ON o.format_id = f.id
    LEFT JOIN product_packaging pack ON o.packaging_id = pack.id
    LEFT JOIN product_vintage vint ON o.product_id = vint.product_id AND o.vintage = vint.year
    WHERE o.uuid IN (?, ?, ?, ?, ?, ?, ?)

[
  "2b78420f-3cd8-411a-82dd-b72ac562e254"
  "1fff2c69-f0aa-46f2-8079-e6c6c4ef96e3"
  "2152e813-ddad-421d-9cdc-64b326de9a3f"
  "0ffadbeb-b949-4029-8c87-4d7c967622d0"
  "1f6be9a9-1571-4245-93b7-d924cf7ec5b1"
  "40340a77-85ff-4684-88ef-4068db954af3"
  "145af212-8c74-4089-89bc-6bd91ee449aa"
]

SELECT
  o.id,
  o.uuid,
  o.vintage,
  o.type as offerType,
  o.price,
  o.qty,
  o.unoficial_price,
  o.unoficial_qty,
  o.format_filled,
  f.name as formatName,
  pack.name as packagingName,
  o.packaging_flat,
  o.packaging_value,
  o.is_flat,
  o.comment,
  e.provisioning,
  o.status,
  vint.price as releasePrice,
  vint.recommended_price as recommandedPrice,
  CASE WHEN e.display_name IS NOT NULL
  AND e.display_name != '' THEN
    e.display_name
  ELSE
    e.name
  END AS entityDisplayName,
  CASE WHEN pr.display_name IS NOT NULL
  AND pr.display_name != '' THEN
    pr.display_name
  ELSE
    pr.name
  END AS productDisplayName
FROM
  offer o
  LEFT JOIN entity e ON o.entity_id = e.id
  LEFT JOIN product pr ON o.product_id = pr.id
  LEFT JOIN product_format f ON o.format_id = f.id
  LEFT JOIN product_packaging pack ON o.packaging_id = pack.id
  LEFT JOIN product_vintage vint ON o.product_id = vint.product_id
  AND o.vintage = vint.year
WHERE
  o.uuid IN (?, ?, ?, ?, ?, ?, ?)

SELECT o.id, o.uuid, o.vintage, o.type as offerType, o.price, o.qty, o.unoficial_price, o.unoficial_qty, o.format_filled, f.name as formatName, pack.name as packagingName, o.packaging_flat, o.packaging_value, o.is_flat, o.comment, e.provisioning, o.status, vint.price as releasePrice, vint.recommended_price as recommandedPrice,
    CASE
        WHEN e.display_name IS NOT NULL AND e.display_name != '' 
            THEN e.display_name 
        ELSE e.name 
    END AS entityDisplayName,
    CASE
        WHEN pr.display_name IS NOT NULL AND pr.display_name != '' 
            THEN pr.display_name 
        ELSE pr.name 
    END AS productDisplayName
    FROM offer o
    LEFT JOIN entity e ON o.entity_id = e.id
    LEFT JOIN product pr ON o.product_id = pr.id
    LEFT JOIN product_format f ON o.format_id = f.id
    LEFT JOIN product_packaging pack ON o.packaging_id = pack.id
    LEFT JOIN product_vintage vint ON o.product_id = vint.product_id AND o.vintage = vint.year
    WHERE o.uuid IN ('2b78420f-3cd8-411a-82dd-b72ac562e254', '1fff2c69-f0aa-46f2-8079-e6c6c4ef96e3', '2152e813-ddad-421d-9cdc-64b326de9a3f', '0ffadbeb-b949-4029-8c87-4d7c967622d0', '1f6be9a9-1571-4245-93b7-d924cf7ec5b1', '40340a77-85ff-4684-88ef-4068db954af3', '145af212-8c74-4089-89bc-6bd91ee449aa') ;