Query Metrics
2
Database Queries
2
Different statements
12.51 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
8.55 ms (0.00%) |
1 |
SELECT d0_.id AS id_0, d0_.description AS description_1, d0_.salaire AS salaire_2, d0_.bloque AS bloque_3, d0_.epingle AS epingle_4, d0_.etat AS etat_5, d0_.created_at AS created_at_6, d0_.titre AS titre_7, d0_.part AS part_8, d0_.tax AS tax_9, d0_.total AS total_10, d0_.type AS type_11, d0_.start_time AS start_time_12, d0_.end_time AS end_time_13, d0_.end_date_cdi AS end_date_cdi_14, d0_.start_period AS start_period_15, d0_.end_period AS end_period_16, s1_.id AS id_17, s1_.title AS title_18, d0_.user_id AS user_id_19, d0_.souscategorie_id AS souscategorie_id_20, s1_.categorie_id AS categorie_id_21 FROM demande d0_ INNER JOIN sous_categorie s1_ ON d0_.souscategorie_id = s1_.id INNER JOIN user u2_ ON d0_.user_id = u2_.id WHERE d0_.etat = ? AND (d0_.start_period >= ? OR d0_.end_date_cdi >= ?) AND d0_.souscategorie_id = ? ORDER BY d0_.created_at DESC
Parameters:
[ "DISPONIBLE" "2025-01-14 00:00:00" "2025-01-14 00:00:00" 12 ] |
3.96 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\Demande | No errors. |
App\Entity\SousCategorie | No errors. |
App\Entity\Categorie | No errors. |
App\Entity\Offre |
|
App\Entity\User | No errors. |