Query Metrics
5
Database Queries
5
Different statements
11.64 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
4.14 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.created_at AS created_at_5, t0.username AS username_6, t0.token AS token_7, t0.lastname AS lastname_8, t0.phone AS phone_9, t0.address AS address_10, t0.ville AS ville_11, t0.reset_token AS reset_token_12, t0.naissance AS naissance_13, t0.experience AS experience_14, t0.sociale AS sociale_15, t0.bancaire AS bancaire_16, t0.cv AS cv_17, t0.identite AS identite_18, t0.logo AS logo_19, t0.etablissement AS etablissement_20, t0.a_propos AS a_propos_21, t0.matricule AS matricule_22, t0.is_blocked AS is_blocked_23, t0.enabled AS enabled_24, t25.id AS id_26, t25.image_name AS image_name_27, t25.updated_at AS updated_at_28, t25.user_images_id AS user_images_id_29 FROM user t0 LEFT JOIN user_image t25 ON t25.user_images_id = t0.id
Parameters:
[] |
3.10 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.description AS description_2, t0.salaire AS salaire_3, t0.bloque AS bloque_4, t0.epingle AS epingle_5, t0.etat AS etat_6, t0.created_at AS created_at_7, t0.titre AS titre_8, t0.part AS part_9, t0.tax AS tax_10, t0.total AS total_11, t0.type AS type_12, t0.start_time AS start_time_13, t0.end_time AS end_time_14, t0.end_date_cdi AS end_date_cdi_15, t0.start_period AS start_period_16, t0.end_period AS end_period_17, t0.user_id AS user_id_18, t0.souscategorie_id AS souscategorie_id_19 FROM demande t0
Parameters:
[] |
2.53 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 WHERE d0_.etat = ? AND d0_.epingle = ? AND (d0_.start_period >= ? OR d0_.end_date_cdi >= ?) ORDER BY d0_.created_at DESC
Parameters:
[ "DISPONIBLE" 1 "2024-12-25 23:16:45" "2024-12-25 23:16:45" ] |
1.18 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM categorie t0
Parameters:
[] |
0.69 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.categorie_id AS categorie_id_3 FROM sous_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\Demande | No errors. |
App\Entity\Categorie | No errors. |
App\Entity\User | No errors. |
App\Entity\Offre |
|
App\Entity\SousCategorie | No errors. |
App\Entity\Comments | No errors. |
App\Entity\Candidature | No errors. |
App\Entity\UserImage | No errors. |
App\Entity\CommentOffre | No errors. |