Query Metrics
2
Database Queries
2
Different statements
10.42 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
6.95 ms (0.00%) |
1 |
SELECT o0_.id AS id_0, o0_.description AS description_1, o0_.created_at AS created_at_2, o0_.salaire AS salaire_3, o0_.etat AS etat_4, o0_.publier AS publier_5, o0_.type AS type_6, o0_.epingle AS epingle_7, o0_.titre AS titre_8, s1_.id AS id_9, s1_.title AS title_10, o0_.user_id AS user_id_11, o0_.souscategorie_id AS souscategorie_id_12, s1_.categorie_id AS categorie_id_13 FROM offre o0_ INNER JOIN sous_categorie s1_ ON o0_.souscategorie_id = s1_.id INNER JOIN user u2_ ON o0_.user_id = u2_.id WHERE o0_.publier = 1 AND o0_.etat = ? ORDER BY o0_.created_at DESC
Parameters:
[
"DISPONIBLE"
]
|
3.47 ms (0.00%) |
1 |
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.categorie_id AS categorie_id_2 FROM sous_categorie s0_ ORDER BY s0_.title ASC
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\Offre |
|
App\Entity\SousCategorie | No errors. |
App\Entity\Categorie | No errors. |
App\Entity\Demande | No errors. |
App\Entity\User | No errors. |