Query Metrics
19
Database Queries
5
Different statements
8.66 ms
Query time
3
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.74 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.evenement_id_id AS sclr_1 FROM payement_method p0_ LEFT JOIN congre c1_ ON p0_.evenement_id_id = c1_.id ORDER BY p0_.evenement_id_id ASC LIMIT 20 OFFSET 1660
Parameters:
[] |
| 2 | 2.19 ms |
SELECT p0_.id AS id_0, p0_.url AS url_1, p0_.phone AS phone_2, p0_.nom AS nom_3, p0_.prenom AS prenom_4, p0_.email AS email_5, p0_.file AS file_6, p0_.montant AS montant_7, p0_.order_number AS order_number_8, p0_.date_ad AS date_ad_9, p0_.supp AS supp_10, p0_.pai AS pai_11, p0_.total AS total_12, p0_.accomp AS accomp_13, p0_.pourcentage AS pourcentage_14, p0_.surplace AS surplace_15, p0_.virement AS virement_16, p0_.ordernumberid AS ordernumberid_17, p0_.adhesion AS adhesion_18, p0_.id_user_id AS id_user_id_19, p0_.evenement_id_id AS evenement_id_id_20, p0_.evenementautre_id AS evenementautre_id_21 FROM payement_method p0_ LEFT JOIN congre c1_ ON p0_.evenement_id_id = c1_.id WHERE p0_.id IN (?) ORDER BY p0_.evenement_id_id ASC
Parameters:
[
[
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
]
]
|
| 3 | 0.87 ms |
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM payement_method p0_ LEFT JOIN congre c1_ ON p0_.evenement_id_id = c1_.id
Parameters:
[] |
| 4 | 0.42 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.category AS category_3, t0.description AS description_4, t0.url_maps AS url_maps_5, t0.image_principale AS image_principale_6, t0.desplay AS desplay_7, t0.user_id AS user_id_8, t0.date_evenement AS date_evenement_9, t0.evenementcongre_id AS evenementcongre_id_10 FROM congre t0 WHERE t0.id = ?
Parameters:
[
19
]
|
| 5 | 0.37 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.type AS type_5, t0.password AS password_6, t0.phone AS phone_7 FROM connexion_user t0 WHERE t0.id = ?
Parameters:
[
513
]
|
| 6 | 0.28 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.type AS type_5, t0.password AS password_6, t0.phone AS phone_7 FROM connexion_user t0 WHERE t0.id = ?
Parameters:
[
514
]
|
| 7 | 0.20 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.type AS type_5, t0.password AS password_6, t0.phone AS phone_7 FROM connexion_user t0 WHERE t0.id = ?
Parameters:
[
515
]
|
| 8 | 0.23 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.type AS type_5, t0.password AS password_6, t0.phone AS phone_7 FROM connexion_user t0 WHERE t0.id = ?
Parameters:
[
494
]
|
| 9 | 0.20 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.type AS type_5, t0.password AS password_6, t0.phone AS phone_7 FROM connexion_user t0 WHERE t0.id = ?
Parameters:
[
516
]
|
| 10 | 0.19 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.type AS type_5, t0.password AS password_6, t0.phone AS phone_7 FROM connexion_user t0 WHERE t0.id = ?
Parameters:
[
518
]
|
| 11 | 0.24 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.type AS type_5, t0.password AS password_6, t0.phone AS phone_7 FROM connexion_user t0 WHERE t0.id = ?
Parameters:
[
519
]
|
| 12 | 0.25 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.type AS type_5, t0.password AS password_6, t0.phone AS phone_7 FROM connexion_user t0 WHERE t0.id = ?
Parameters:
[
520
]
|
| 13 | 0.19 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.type AS type_5, t0.password AS password_6, t0.phone AS phone_7 FROM connexion_user t0 WHERE t0.id = ?
Parameters:
[
291
]
|
| 14 | 0.19 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.type AS type_5, t0.password AS password_6, t0.phone AS phone_7 FROM connexion_user t0 WHERE t0.id = ?
Parameters:
[
521
]
|
| 15 | 0.20 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.type AS type_5, t0.password AS password_6, t0.phone AS phone_7 FROM connexion_user t0 WHERE t0.id = ?
Parameters:
[
522
]
|
| 16 | 0.19 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.type AS type_5, t0.password AS password_6, t0.phone AS phone_7 FROM connexion_user t0 WHERE t0.id = ?
Parameters:
[
6
]
|
| 17 | 0.28 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.type AS type_5, t0.password AS password_6, t0.phone AS phone_7 FROM connexion_user t0 WHERE t0.id = ?
Parameters:
[
415
]
|
| 18 | 0.21 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.type AS type_5, t0.password AS password_6, t0.phone AS phone_7 FROM connexion_user t0 WHERE t0.id = ?
Parameters:
[
525
]
|
| 19 | 0.19 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.type AS type_5, t0.password AS password_6, t0.phone AS phone_7 FROM connexion_user t0 WHERE t0.id = ?
Parameters:
[
526
]
|
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\PayementMethod |
|
| App\Entity\Congre |
|
| App\Entity\ConnexionUser | No errors. |
| App\Entity\EvenementAVenir | No errors. |
| App\Entity\Event |
|
| App\Entity\AttachmentCongre | No errors. |
| App\Entity\PrixVariableCongre | No errors. |
| App\Entity\Etape | No errors. |
| App\Entity\Speakers | No errors. |
| App\Entity\Sponsored | No errors. |
| App\Entity\Document | No errors. |