Query Metrics
11
Database Queries
10
Different statements
55.17 ms
Query time
0
Invalid entities
Grouped Statements
reservation connection
| Time▼ | Count | Info |
|---|---|---|
|
41.89 ms (75.92%) |
1 |
ALTER TABLE operator_secure_action AUTO_INCREMENT = 259
Parameters:
[] |
|
2.96 ms (5.36%) |
2 |
SELECT t0.id AS id_1, t0.code_activity AS code_activity_2, t0.date AS date_3, t0.creneau AS creneau_4, t0.token AS token_5, t0.key_token AS key_token_6 FROM `operator_secure_action` t0 WHERE t0.code_activity = ? AND t0.date = ? AND t0.creneau = ? LIMIT 1
Parameters:
[ "laser-game" "2026-01-28 00:00:00" "16:40:00" ] |
|
2.10 ms (3.80%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
9
]
|
|
2.07 ms (3.75%) |
1 |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.code_activity AS code_activity_3, t0.date AS date_4, t0.creneau AS creneau_5, t0.quantity AS quantity_6, t0.nbre_parties AS nbre_parties_7, t0.id_customer AS id_customer_8, t0.shortname AS shortname_9, t0.deleted AS deleted_10, t0.is_unavailable AS is_unavailable_11 FROM `operator_booking` t0 WHERE t0.code_activity = ? AND t0.date = ? AND t0.creneau = ? ORDER BY t0.id ASC
Parameters:
[ "laser-game" "2026-01-28" "16:40:00" ] |
|
1.86 ms (3.38%) |
1 |
"COMMIT"
Parameters:
[] |
|
1.82 ms (3.31%) |
1 |
SELECT b0_.id AS id_0, b0_.designation AS designation_1, b0_.forfait AS forfait_2, b0_.formule AS formule_3, b0_.code_activity AS code_activity_4, b0_.date AS date_5, b0_.creneau AS creneau_6, b0_.nbre_parties AS nbre_parties_7, b0_.quantity AS quantity_8, b0_.pu_ttc AS pu_ttc_9, b0_.taux_TVA AS taux_TVA_10, b0_.total_ht AS total_ht_11, b0_.montant_tva AS montant_tva_12, b0_.total_ttc AS total_ttc_13, b0_.reservation_id AS reservation_id_14 FROM `booked_activity` b0_ INNER JOIN `reservation` r1_ ON (b0_.reservation_id = r1_.id) WHERE r1_.active = 1 AND b0_.date = ? AND b0_.code_activity = ?
Parameters:
[ "2026-01-28 00:00:00" "laser-game" ] |
|
0.92 ms (1.67%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.mention_anniversaire AS mention_anniversaire_4, t0.url_activity AS url_activity_5, t0.temps_limite_resa AS temps_limite_resa_6, t0.jauge_mini AS jauge_mini_7, t0.mention AS mention_8, t0.jauge_maxi AS jauge_maxi_9, t0.temps_activite AS temps_activite_10, t0.presence_avant AS presence_avant_11, t0.espaces_jeu AS espaces_jeu_12, t0.is_creneau_activity AS is_creneau_activity_13, t0.is_tarification_multiple AS is_tarification_multiple_14, t0.heure_ouverture_creneau AS heure_ouverture_creneau_15, t0.heure_fermeture_creneau AS heure_fermeture_creneau_16, t0.temps_creneau AS temps_creneau_17, t0.creneau_obligatoire AS creneau_obligatoire_18, t0.block_room AS block_room_19, t0.is_draft AS is_draft_20, t0.billboard_type AS billboard_type_21, t0.waiting_time AS waiting_time_22, t0.espaces_jeu_reel AS espaces_jeu_reel_23, t0.jauge_maxi_reel AS jauge_maxi_reel_24, t0.temps_creneau_reel AS temps_creneau_reel_25, t0.ignored_creneau AS ignored_creneau_26, t0.temps_activite_joueur AS temps_activite_joueur_27 FROM `activity` t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"laser-game"
]
|
|
0.85 ms (1.54%) |
1 |
INSERT INTO `operator_secure_action` (code_activity, date, creneau, token, key_token) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "laser-game" "2026-01-28 00:00:00" "16:40:00" "2026-01-28 16:28:11" "bGFzZXItZ2FtZTIwMjYwMTI4MTY6NDAyMDI2MDEyOCAxNjoyODoxMQ==" ] |
|
0.41 ms (0.75%) |
1 |
"START TRANSACTION"
Parameters:
[] |
|
0.29 ms (0.52%) |
1 |
SELECT t0.id AS id_1, t0.code_activity AS code_activity_2, t0.date AS date_3, t0.creneau AS creneau_4, t0.token AS token_5, t0.key_token AS key_token_6 FROM `operator_secure_action` t0
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| reservation | doctrine.dbal.reservation_connection |
| customer | doctrine.dbal.customer_connection |
Entity Managers
| Name | Service |
|---|---|
| main | doctrine.orm.main_entity_manager |
| customer | doctrine.orm.customer_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
main entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Main\User | No errors. |
| App\Entity\Main\OperatorSecureAction | No errors. |
| App\Entity\Main\Activity | No errors. |
| App\Entity\Main\BookedActivity | No errors. |
| App\Entity\Main\Reservation | No errors. |
| App\Entity\Main\BookedActivityOptions | No errors. |
| App\Entity\Main\OperatorBooking | No errors. |
customer entity manager
No loaded entities.