Query Metrics
6
Database Queries
4
Different statements
15.19 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 6.11 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.alpha2 AS alpha2_3, t0.alpha3 AS alpha3_4, t0.nom_en_gb AS nom_en_gb_5, t0.nom_fr_fr AS nom_fr_fr_6 FROM pays t0
Parameters:
[]
|
||||||||||||||||||||||||||
| 2 | 2.19 ms |
SELECT q0_.id AS id_0, q0_.type AS type_1, q0_.question AS question_2, q0_.date_creation AS date_creation_3, q0_.date_update AS date_update_4, q0_.etat AS etat_5 FROM questions q0_ WHERE q0_.type = ? AND q0_.etat = ?
Parameters:
[ "particulier" 1 ]
|
||||||||||||||||||||||||||
| 3 | 1.88 ms |
SELECT t0.id AS id_1, t0.nom_formule AS nom_formule_2, t0.description AS description_3, t0.type AS type_4, t0.date_creation AS date_creation_5, t0.date_update AS date_update_6, t0.prix AS prix_7, t0.unite AS unite_8, t0.etat AS etat_9, t0.destination AS destination_10 FROM formules t0
Parameters:
[]
|
||||||||||||||||||||||||||
| 4 | 1.80 ms |
SELECT t0.id AS id_1, t0.nom_option AS nom_option_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4, t0.prix AS prix_5, t0.unite AS unite_6, t0.description AS description_7, t0.etat AS etat_8, t0.formule_id AS formule_id_9 FROM formule_options t0 WHERE t0.formule_id = ? AND t0.etat = ?
Parameters:
[ 53 1 ]
|
||||||||||||||||||||||||||
| 5 | 1.56 ms |
SELECT t0.id AS id_1, t0.nom_option AS nom_option_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4, t0.prix AS prix_5, t0.unite AS unite_6, t0.description AS description_7, t0.etat AS etat_8, t0.formule_id AS formule_id_9 FROM formule_options t0 WHERE t0.formule_id = ? AND t0.etat = ?
Parameters:
[ 56 1 ]
|
||||||||||||||||||||||||||
| 6 | 1.66 ms |
SELECT t0.id AS id_1, t0.nom_option AS nom_option_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4, t0.prix AS prix_5, t0.unite AS unite_6, t0.description AS description_7, t0.etat AS etat_8, t0.formule_id AS formule_id_9 FROM formule_options t0 WHERE t0.formule_id = ? AND t0.etat = ?
Parameters:
[ 58 1 ]
|
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\Pays | No errors. |
| App\Entity\Questions | No errors. |
| App\Entity\Formules | No errors. |
| App\Entity\FormuleOptions | No errors. |