Query Metrics
13
Database Queries
12
Different statements
8.23 ms
Query time
5
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.52 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.roles AS roles_4, t0.password AS password_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.slug AS slug_8, t0.birthdate AS birthdate_9, t10.id AS id_11, t10.qr_code_image AS qr_code_image_12, t10.points AS points_13, t10.apple_wallet_token AS apple_wallet_token_14, t10.apple_wallet_push_token AS apple_wallet_push_token_15, t10.device_library_identifier AS device_library_identifier_16, t10.updated_at AS updated_at_17, t10.last_notification AS last_notification_18, t10.user_id AS user_id_19 FROM user t0 LEFT JOIN card t10 ON t10.user_id = t0.id WHERE t0.id = ?
Parameters:
[
2
]
|
2 | 0.41 ms |
SELECT t0.id AS id_1, t0.is_winning AS is_winning_2, t0.is_scratched AS is_scratched_3, t0.created_at AS created_at_4, t0.scratched_at AS scratched_at_5, t0.slug AS slug_6, t0.qr_code_path AS qr_code_path_7, t0.active AS active_8, t0.date_used AS date_used_9, t0.user_id AS user_id_10, t0.offre_id AS offre_id_11 FROM ticket_gratter t0 WHERE t0.user_id = ? AND t0.is_scratched = ? LIMIT 1
Parameters:
[ 2 0 ] |
3 | 0.32 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prix AS prix_3, t0.deleted AS deleted_4, t0.categorie_id AS categorie_id_5 FROM prestation t0 WHERE t0.id = ?
Parameters:
[
"319"
]
|
4 | 0.31 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM type_paiement t0 WHERE t0.id = ?
Parameters:
[
"2"
]
|
5 | 0.25 ms |
"START TRANSACTION"
Parameters:
[] |
6 | 0.83 ms |
INSERT INTO recette (date, nom_client, acompte, total) VALUES (?, ?, ?, ?)
Parameters:
[ "2025-05-02 17:49:41" "celia derradji" 25.0 25.0 ] |
7 | 0.52 ms |
INSERT INTO paiement_recette (somme_payee, recette_id, type_paiement_id) VALUES (?, ?, ?)
Parameters:
[ 0.0 1400 2 ] |
8 | 0.31 ms |
UPDATE prestation SET prix = ? WHERE id = ?
Parameters:
[ 25.0 319 ] |
9 | 0.32 ms |
INSERT INTO recette_prestation (recette_id, prestation_id) VALUES (?, ?)
Parameters:
[ 1400 319 ] |
10 | 1.34 ms |
"COMMIT"
Parameters:
[] |
11 | 0.78 ms |
SELECT SUM(r0_.acompte) AS sclr_0 FROM recette r0_ WHERE r0_.date >= ? AND r0_.date < ?
Parameters:
[ "2025-05-02 00:00:00" "2025-05-02 23:59:59" ] |
12 | 0.67 ms |
SELECT SUM(p0_.somme_payee) AS sclr_0 FROM paiement_recette p0_ INNER JOIN recette r1_ ON p0_.recette_id = r1_.id WHERE r1_.date >= ? AND r1_.date < ? AND p0_.type_paiement_id = ?
Parameters:
[ "2025-05-02 00:00:00" "2025-05-02 23:59:59" 1 ] |
13 | 0.64 ms |
SELECT SUM(p0_.somme_payee) AS sclr_0 FROM paiement_recette p0_ INNER JOIN recette r1_ ON p0_.recette_id = r1_.id WHERE r1_.date >= ? AND r1_.date < ? AND p0_.type_paiement_id = ?
Parameters:
[ "2025-05-02 00:00:00" "2025-05-02 23:59:59" 2 ] |
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\User | No errors. |
App\Entity\Card |
|
App\Entity\CouponUser | No errors. |
App\Entity\TicketGratter | No errors. |
App\Entity\CardTransaction | No errors. |
App\Entity\Offre | No errors. |
App\Entity\Prestation |
|
App\Entity\Categorie |
|
App\Entity\Recette |
|
App\Entity\TypePaiement | No errors. |
App\Entity\PaiementRecette |
|