POST https://app103.fr/app/offer/consult

Query Metrics

5 Database Queries
5 Different statements
3.05 ms Query time
0 Invalid entities
2 Managed entities

Queries

Group similar statements

# Time Info
1 0.82 ms
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 = ?
Parameters:
[
  2
]
2 0.16 ms
"START TRANSACTION"
Parameters:
[]
3 0.46 ms
UPDATE user SET last_activity = ? WHERE id = ?
Parameters:
[
  "2025-07-07 15:19:12"
  2
]
4 0.13 ms
"COMMIT"
Parameters:
[]
5 1.48 ms
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 (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "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"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\User 1
App\Entity\Company 1