Query Metrics
7
Database Queries
7
Different statements
3.67 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.68 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.token AS token_7, t0.available_requests AS available_requests_8, t0.is_actif AS is_actif_9, t0.code_activation AS code_activation_10, t0.device_id AS device_id_11, t0.last_resend_verif AS last_resend_verif_12, t0.number_resend_verif AS number_resend_verif_13, t0.ip AS ip_14, t0.secret AS secret_15, t0.full_name AS full_name_16, t0.profil_title AS profil_title_17, t0.top_desc AS top_desc_18, t0.location AS location_19, t0.email_address AS email_address_20, t0.phone AS phone_21 FROM `user` t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
"7XkPRBJBw40hNQJTZ52eUr4Aqdtvl3kmlfL7ex52cnMyc7eky36NmP4dadfCzJjSEPQH7w77MmsDaRxJtScAdh7Zzofpzy3LvaghXC3xdGMSS182EYH8egXo"
]
|
| 2 | 0.52 ms |
SELECT t0.id AS id_1, t0.date_from AS date_from_2, t0.date_to AS date_to_3, t0.title AS title_4, t0.employe AS employe_5, t0.description AS description_6, t0.technologies AS technologies_7, t0.created_by_id AS created_by_id_8 FROM experience t0 WHERE t0.created_by_id = ?
Parameters:
[
1
]
|
| 3 | 0.24 ms |
SELECT t0.id AS id_1, t0.date_from AS date_from_2, t0.date_to AS date_to_3, t0.diplome AS diplome_4, t0.university AS university_5, t0.domain AS domain_6, t0.created_by_id AS created_by_id_7 FROM formation t0 WHERE t0.created_by_id = ?
Parameters:
[
1
]
|
| 4 | 1.06 ms |
SELECT t0.id AS id_1, t0.date_success AS date_success_2, t0.title AS title_3, t0.organisation AS organisation_4, t0.created_by_id AS created_by_id_5 FROM certification t0 WHERE t0.created_by_id = ?
Parameters:
[
1
]
|
| 5 | 0.18 ms |
SELECT t0.id AS id_1, t0.domain AS domain_2, t0.skills AS skills_3, t0.created_by_id AS created_by_id_4 FROM skill t0 WHERE t0.created_by_id = ?
Parameters:
[
1
]
|
| 6 | 0.20 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_by_id AS created_by_id_3 FROM expertise t0 WHERE t0.created_by_id = ?
Parameters:
[
1
]
|
| 7 | 0.79 ms |
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.niveau AS niveau_3, t0.created_by_id AS created_by_id_4 FROM langue t0 WHERE t0.created_by_id = ?
Parameters:
[
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\User | No errors. |
| App\Entity\Experience | No errors. |
| App\Entity\Formation | No errors. |
| App\Entity\Certification | No errors. |
| App\Entity\Skill | No errors. |
| App\Entity\Expertise | No errors. |
| App\Entity\Langue | No errors. |
| App\Entity\Cvjob | No errors. |