Query Metrics
7
Database Queries
5
Different statements
17.85 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
5.40 ms (30.24%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.annonce_id AS annonce_id_3 FROM image t0 WHERE t0.annonce_id = ?
Parameters:
[
1
]
|
5.34 ms (29.93%) |
1 |
SELECT a0_.id AS id_0, a0_.ref AS ref_1, a0_.titre AS titre_2, a0_.prix AS prix_3, a0_.description AS description_4, a0_.nbchambre AS nbchambre_5, a0_.nbsdb AS nbsdb_6, a0_.adresse AS adresse_7, a0_.surface AS surface_8, a0_.status AS status_9, a0_.general AS general_10, a0_.espext AS espext_11, a0_.parking AS parking_12, a0_.chauffage AS chauffage_13, a0_.cuisine AS cuisine_14, a0_.climatisation AS climatisation_15, a0_.date AS date_16, a0_.categorie_id AS categorie_id_17, a0_.type_id AS type_id_18, a0_.publierpar_id AS publierpar_id_19, a0_.devise_id AS devise_id_20, a0_.unite_id AS unite_id_21 FROM annonce a0_ WHERE a0_.status = 1
Parameters:
[] |
2.51 ms (14.03%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.categorie_id AS categorie_id_3 FROM type t0
Parameters:
[] |
2.34 ms (13.10%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.symbole AS symbole_3 FROM devise t0 WHERE t0.id = ?
Parameters:
[
2
]
|
2.27 ms (12.69%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM categorie t0
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\Categorie | No errors. |
App\Entity\Type | No errors. |
App\Entity\Annonce | No errors. |
App\Entity\User | No errors. |
App\Entity\Devise | No errors. |
App\Entity\Unite | No errors. |
App\Entity\Image | No errors. |