Query Metrics
18
Database Queries
14
Different statements
54.07 ms
Query time
3
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
17.85 ms (33.02%) |
1 |
"COMMIT"
Parameters:
[] |
|
12.10 ms (22.37%) |
2 |
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[] |
|
10.85 ms (20.06%) |
4 |
SELECT DATABASE()
Parameters:
[] |
|
2.94 ms (5.43%) |
1 |
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.email = ?
Parameters:
[
"imendai123@yahoo.com"
]
|
|
2.88 ms (5.33%) |
1 |
SELECT t0.id AS id_1, t0.url AS url_2, t0.phone AS phone_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.email AS email_6, t0.file AS file_7, t0.montant AS montant_8, t0.order_number AS order_number_9, t0.date_ad AS date_ad_10, t0.supp AS supp_11, t0.pai AS pai_12, t0.total AS total_13, t0.accomp AS accomp_14, t0.pourcentage AS pourcentage_15, t0.surplace AS surplace_16, t0.virement AS virement_17, t0.ordernumberid AS ordernumberid_18, t0.adhesion AS adhesion_19, t0.id_user_id AS id_user_id_20, t0.evenement_id_id AS evenement_id_id_21, t0.evenementautre_id AS evenementautre_id_22 FROM payement_method t0 WHERE t0.email = ? AND t0.url = ?
Parameters:
[ "imendai123@yahoo.com" "123456789" ] |
|
1.54 ms (2.85%) |
1 |
SELECT t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'
Parameters:
[] |
|
1.27 ms (2.35%) |
1 |
SELECT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME /*!50116 , c.UPDATE_RULE, c.DELETE_RULE */ FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE k /*!50116 INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_NAME = 'doctrine_migration_versions' AND k.TABLE_SCHEMA = 'astp' /*!50116 AND c.CONSTRAINT_SCHEMA = 'astp' */ORDER BY k.ORDINAL_POSITION
Parameters:
[] |
|
1.18 ms (2.18%) |
1 |
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'astp' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC
Parameters:
[] |
|
0.97 ms (1.79%) |
1 |
SELECT MAX(p0_.order_number) AS sclr_0 FROM payement_method p0_
Parameters:
[] |
|
0.93 ms (1.73%) |
1 |
"START TRANSACTION"
Parameters:
[] |
|
0.80 ms (1.49%) |
1 |
INSERT INTO payement_method (url, phone, nom, prenom, email, file, montant, order_number, date_ad, supp, pai, total, accomp, pourcentage, surplace, virement, ordernumberid, adhesion, id_user_id, evenement_id_id, evenementautre_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => null 2 => null 3 => null 4 => null 5 => null 6 => null 7 => "0" 8 => 2255 9 => "2025-12-30 02:01:49" 10 => null 11 => 0 12 => "0" 13 => null 14 => null 15 => null 16 => null 17 => null 18 => null 19 => 652 20 => null 21 => null ] |
|
0.28 ms (0.52%) |
1 |
SELECT MAX(p0_.id) AS sclr_0 FROM payement_method p0_
Parameters:
[] |
|
0.27 ms (0.49%) |
1 |
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'astp' ORDER BY SEQ_IN_INDEX ASC
Parameters:
[] |
|
0.21 ms (0.39%) |
1 |
SELECT * FROM doctrine_migration_versions
Parameters:
[] |
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\ConnexionUser | No errors. |
| App\Entity\PayementMethod |
|
| App\Entity\Congre |
|
| App\Entity\EvenementAVenir | No errors. |
| App\Entity\Event |
|
| App\Entity\Document | No errors. |
| 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\Attachment | No errors. |
| App\Entity\PrixVariable | No errors. |