Query Metrics
32
Database Queries
17
Different statements
4.42 ms
Query time
2
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.93 ms (43.56%) |
1 |
SELECT t1.id AS id_2, t1.email AS email_3, t1.username AS username_4, t1.roles AS roles_5, t1.password AS password_6, t1.api_token AS api_token_7, t1.created_at AS created_at_8, t1.reset_token AS reset_token_9, t1.token_expiration_date AS token_expiration_date_10, t1.updated_at AS updated_at_11, t0.name AS name_12, t0.slug AS slug_13, t1.marque_id AS marque_id_14, t0.adresse_id AS adresse_id_15, t0.contact_id AS contact_id_16, t1.type FROM marque t0 INNER JOIN user t1 ON t0.id = t1.id
Parameters:
[] |
|
0.56 ms (12.65%) |
4 |
SELECT t1.id AS id_2, t1.email AS email_3, t1.username AS username_4, t1.roles AS roles_5, t1.password AS password_6, t1.api_token AS api_token_7, t1.created_at AS created_at_8, t1.reset_token AS reset_token_9, t1.token_expiration_date AS token_expiration_date_10, t1.updated_at AS updated_at_11, t0.civility AS civility_12, t0.first_name AS first_name_13, t0.last_name AS last_name_14, t0.date_naissance AS date_naissance_15, t1.marque_id AS marque_id_16, t0.adresse_id AS adresse_id_17, t0.contact_id AS contact_id_18, t1.type FROM consommateur t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
42
]
|
|
0.35 ms (7.87%) |
6 |
SELECT * FROM categorie_question WHERE id = 2
Parameters:
[] |
|
0.22 ms (5.08%) |
1 |
SELECT t0.id AS id_1, t0.commentaire_libre AS commentaire_libre_2, t0.score AS score_3, t0.date_achat AS date_achat_4, t0.date_experience AS date_experience_5, t0.country AS country_6, t0.postalcode AS postalcode_7, t0.filepath AS filepath_8, t0.participation_date AS participation_date_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.state AS state_12, t0.marque_id AS marque_id_13, t0.consommateur_id AS consommateur_id_14, t0.questionnaire_id AS questionnaire_id_15 FROM participation t0 WHERE t0.state = ? ORDER BY t0.participation_date DESC
Parameters:
[
1
]
|
|
0.16 ms (3.64%) |
1 |
SELECT t0.id AS id_1, t0.commentaire_libre AS commentaire_libre_2, t0.score AS score_3, t0.date_achat AS date_achat_4, t0.date_experience AS date_experience_5, t0.country AS country_6, t0.postalcode AS postalcode_7, t0.filepath AS filepath_8, t0.participation_date AS participation_date_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.state AS state_12, t0.marque_id AS marque_id_13, t0.consommateur_id AS consommateur_id_14, t0.questionnaire_id AS questionnaire_id_15 FROM participation t0 WHERE t0.state = ?
Parameters:
[
1
]
|
|
0.14 ms (3.26%) |
2 |
SELECT * FROM question WHERE id = 1
Parameters:
[] |
|
0.13 ms (2.96%) |
2 |
SELECT * FROM question WHERE id = 2
Parameters:
[] |
|
0.13 ms (2.94%) |
2 |
SELECT * FROM categorie_question WHERE id = 1
Parameters:
[] |
|
0.12 ms (2.72%) |
2 |
SELECT * FROM question WHERE id = 5
Parameters:
[] |
|
0.12 ms (2.65%) |
2 |
SELECT * FROM question WHERE id = 3
Parameters:
[] |
|
0.12 ms (2.60%) |
2 |
SELECT * FROM question WHERE id = 4
Parameters:
[] |
|
0.11 ms (2.53%) |
2 |
SELECT * FROM categorie_question WHERE id = 3
Parameters:
[] |
|
0.10 ms (2.37%) |
1 |
SELECT * FROM questions_participation WHERE participation_id = 5
Parameters:
[] |
|
0.06 ms (1.34%) |
1 |
SELECT * FROM questions_participation WHERE participation_id = 4
Parameters:
[] |
|
0.06 ms (1.31%) |
1 |
SELECT * FROM questions_participation WHERE participation_id = 3
Parameters:
[] |
|
0.06 ms (1.27%) |
1 |
SELECT * FROM questions_participation WHERE participation_id = 2
Parameters:
[] |
|
0.06 ms (1.26%) |
1 |
SELECT * FROM questions_participation WHERE participation_id = 1
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\User | No errors. |
| App\Entity\Marque |
|
| App\Entity\Adresse | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\Question | No errors. |
| App\Entity\Participation | No errors. |
| App\Entity\Questionnaire | No errors. |
| App\Entity\CategorieQuestion |
|
| App\Entity\Consommateur | No errors. |