Query Metrics
18
Database Queries
6
Different statements
28.80 ms
Query time
5
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 4.88 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.72 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 | 12.06 ms |
SELECT r0_.id AS id_0, r0_.date AS date_1, r0_.nom_client AS nom_client_2, r0_.acompte AS acompte_3, r0_.total AS total_4, p1_.id AS id_5, p1_.somme_payee AS somme_payee_6, p1_.recette_id AS recette_id_7, p1_.type_paiement_id AS type_paiement_id_8 FROM recette r0_ LEFT JOIN paiement_recette p1_ ON r0_.id = p1_.recette_id WHERE r0_.date >= ? AND r0_.date < ?
Parameters:
[ "2025-05-02 00:00:00" "2025-05-02 23:59:59" ] |
4 | 2.52 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" ] |
5 | 2.07 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 ] |
6 | 0.90 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 ] |
7 | 1.80 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 INNER JOIN recette_prestation ON t0.id = recette_prestation.prestation_id WHERE recette_prestation.recette_id = ?
Parameters:
[
1387
]
|
8 | 0.42 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 INNER JOIN recette_prestation ON t0.id = recette_prestation.prestation_id WHERE recette_prestation.recette_id = ?
Parameters:
[
1388
]
|
9 | 0.34 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 INNER JOIN recette_prestation ON t0.id = recette_prestation.prestation_id WHERE recette_prestation.recette_id = ?
Parameters:
[
1389
]
|
10 | 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 INNER JOIN recette_prestation ON t0.id = recette_prestation.prestation_id WHERE recette_prestation.recette_id = ?
Parameters:
[
1390
]
|
11 | 0.47 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 INNER JOIN recette_prestation ON t0.id = recette_prestation.prestation_id WHERE recette_prestation.recette_id = ?
Parameters:
[
1392
]
|
12 | 0.38 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 INNER JOIN recette_prestation ON t0.id = recette_prestation.prestation_id WHERE recette_prestation.recette_id = ?
Parameters:
[
1394
]
|
13 | 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 INNER JOIN recette_prestation ON t0.id = recette_prestation.prestation_id WHERE recette_prestation.recette_id = ?
Parameters:
[
1395
]
|
14 | 0.35 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 INNER JOIN recette_prestation ON t0.id = recette_prestation.prestation_id WHERE recette_prestation.recette_id = ?
Parameters:
[
1396
]
|
15 | 0.31 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 INNER JOIN recette_prestation ON t0.id = recette_prestation.prestation_id WHERE recette_prestation.recette_id = ?
Parameters:
[
1397
]
|
16 | 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 INNER JOIN recette_prestation ON t0.id = recette_prestation.prestation_id WHERE recette_prestation.recette_id = ?
Parameters:
[
1398
]
|
17 | 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 INNER JOIN recette_prestation ON t0.id = recette_prestation.prestation_id WHERE recette_prestation.recette_id = ?
Parameters:
[
1399
]
|
18 | 0.33 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 INNER JOIN recette_prestation ON t0.id = recette_prestation.prestation_id WHERE recette_prestation.recette_id = ?
Parameters:
[
1400
]
|
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\Recette |
|
App\Entity\PaiementRecette |
|
App\Entity\TypePaiement | No errors. |
App\Entity\Prestation |
|
App\Entity\Categorie |
|