GET https://projitask.api.7ap.tech/api_v2/getCvInfos?p=api_v2%2FgetCvInfos

Query Metrics

7 Database Queries
7 Different statements
3.68 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.86 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.54 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 1.00 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 0.29 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.28 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.49 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.22 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.