Query Metrics
21
Database Queries
18
Different statements
149.64 ms
Query time
3
Invalid entities
6
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
16.99 ms (11.36%) |
2 |
"COMMIT"
Parameters:
[] |
|
13.97 ms (9.34%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.etat AS etat_3, t0.env AS env_4, t0.mode AS mode_5, t0.traductionSite AS traductionSite_6, t0.langue AS langue_7, t0.operateurApi AS operateurApi_8, t0.rgbd AS rgbd_9, t0.logoSalon AS logoSalon_10, t0.fond AS fond_11, t0.plansalon AS plansalon_12, t0.logoLegend AS logoLegend_13, t0.publicite AS publicite_14, t0.produitExposant AS produitExposant_15, t0.awardInnovation AS awardInnovation_16, t0.updated_at AS updated_at_17, t0.started_at AS started_at_18, t0.ended_at AS ended_at_19, t0.logo_exposant AS logo_exposant_20, t0.logo_produit AS logo_produit_21, t0.organisateur_id AS organisateur_id_22, t0.chart_id AS chart_id_23, t0.pac_expo_id AS pac_expo_id_24 FROM salon t0
Parameters:
[] |
|
12.00 ms (8.02%) |
2 |
"START TRANSACTION"
Parameters:
[] |
|
9.41 ms (6.29%) |
1 |
SELECT count(p0_.id) AS sclr_0 FROM produit p0_
Parameters:
[] |
|
8.56 ms (5.72%) |
1 |
SELECT count(e0_.id) AS sclr_0 FROM exposant e0_
Parameters:
[] |
|
7.40 ms (4.94%) |
1 |
SELECT count(c0_.id) AS sclr_0 FROM conference c0_
Parameters:
[] |
|
7.19 ms (4.80%) |
1 |
SELECT count(s0_.id) AS sclr_0 FROM sync s0_
Parameters:
[] |
|
7.11 ms (4.75%) |
1 |
SELECT count(s0_.id) AS sclr_0 FROM stand s0_
Parameters:
[] |
|
7.09 ms (4.74%) |
1 |
SELECT t0.id AS id_1, t0.level AS level_2, t0.label AS label_3, t0.name AS name_4, t0.access AS access_5, t0.actions_disabled AS actions_disabled_6, t0.menus_app_manager AS menus_app_manager_7, t0.is_admin AS is_admin_8, t0.is_app_manager AS is_app_manager_9, t0.is_patrimony_manager AS is_patrimony_manager_10, t0.date_created AS date_created_11 FROM role t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"ROLE_ADMIN"
]
|
|
7.05 ms (4.71%) |
1 |
INSERT INTO user_log (user, path, method, query, ip, created_at, user_agent) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "superadmin" "/easyadmin" "GET" "[]" "10.75.11.100" "2026-06-18 09:42:14" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:152.0) Gecko/20100101 Firefox/152.0" ] |
|
6.91 ms (4.62%) |
1 |
SELECT t0.id AS id_1, t0.password AS password_2, t0.token AS token_3, t0.username AS username_4, t0.username_canonical AS username_canonical_5, t0.roles AS roles_6, t0.email AS email_7, t0.email_canonical AS email_canonical_8, t0.salt AS salt_9, t0.confirmation_token AS confirmation_token_10, t0.password_requested_at AS password_requested_at_11, t0.last_login AS last_login_12, t0.enabled AS enabled_13, t0.ip AS ip_14 FROM app_user t0 WHERE t0.id = ?
Parameters:
[
15
]
|
|
6.83 ms (4.57%) |
1 |
SELECT count(d0_.id) AS sclr_0 FROM device d0_
Parameters:
[] |
|
6.75 ms (4.51%) |
1 |
SELECT count(t0_.id) AS sclr_0 FROM tsalle t0_
Parameters:
[] |
|
6.54 ms (4.37%) |
1 |
SELECT count(p0_.id) AS sclr_0 FROM produit p0_ WHERE p0_.vch_innovation = 1
Parameters:
[] |
|
6.53 ms (4.36%) |
1 |
SELECT count(p0_.id) AS sclr_0 FROM participant p0_
Parameters:
[] |
|
6.51 ms (4.35%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM organisateur t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
6.48 ms (4.33%) |
1 |
UPDATE app_user SET last_login = ? WHERE id = ?
Parameters:
[ "2026-06-18 11:42:14" 15 ] |
|
6.33 ms (4.23%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.ville AS ville_3 FROM pac_expo t0 WHERE t0.id = ?
Parameters:
[
2
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| urlappsalon | doctrine.dbal.urlappsalon_connection |
| sqlite | doctrine.dbal.sqlite_connection |
Entity Managers
| Name | Service |
|---|---|
| urlappsalon | doctrine.orm.urlappsalon_entity_manager |
| default | doctrine.orm.default_entity_manager |
| sqlite | doctrine.orm.sqlite_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
urlappsalon entity manager
| Class | Amount of managed objects |
|---|
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\User | 1 |
| App\Entity\Salon | 1 |
| App\Entity\Organisateur | 1 |
| App\Entity\Chart | 1 |
| App\Entity\PacExpo | 1 |
| App\Entity\UserLog | 1 |
sqlite entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
urlappsalon entity manager
No loaded entities.
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Salon | No errors. |
| App\Entity\Organisateur | No errors. |
| App\Entity\Chart |
|
| App\Entity\PacExpo | No errors. |
| App\Entity\Dates | No errors. |
| App\Entity\Device | No errors. |
| App\Entity\SalonPage | No errors. |
| App\Entity\UserLog | No errors. |
| App\Entity\TExhibitors |
|
| App\Entity\TAtelier |
|
| App\Entity\TSalle | No errors. |
| App\Entity\TMateriel | No errors. |
| App\Entity\TIntervenat | No errors. |
| App\Entity\TExhibitionStand | No errors. |
| App\Entity\Sync | No errors. |
| App\Entity\Role | No errors. |
| App\Entity\THall | No errors. |
sqlite entity manager
No loaded entities.