GET https://iarecrut.clicketcloud.com/quiz/result/3550cac2ec8663ca62423dc5c94c4d3c

Query Metrics

3 Database Queries
3 Different statements
53.75 ms Query time
4 Invalid entities

Queries

Group similar statements

# Time Info
1 51.55 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.location AS location_3, t0.first_name AS first_name_4, t0.phone AS phone_5, t0.email AS email_6, t0.seniority AS seniority_7, t0.score AS score_8, t0.created_at AS created_at_9, t0.cv_url AS cv_url_10, t0.cv AS cv_11, t0.applicant_id AS applicant_id_12, t0.vacancy_id AS vacancy_id_13, t0.candidate_id AS candidate_id_14, t0.cv_key AS cv_key_15, t0.score_compare AS score_compare_16, t0.quiz_done AS quiz_done_17, t0.other_analyses AS other_analyses_18, t0.id_comment_flatchr AS id_comment_flatchr_19, t0.time_transport_fiche_poste AS time_transport_fiche_poste_20, t0.time_transport_company AS time_transport_company_21, t0.quiz_start AS quiz_start_22, t0.token AS token_23, t0.category_id AS category_id_24, t0.status_id AS status_id_25, t0.fiche_id AS fiche_id_26, t0.question_rh_id AS question_rh_id_27 FROM cv t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
  "3550cac2ec8663ca62423dc5c94c4d3c"
]
2 1.52 ms
SELECT t0.id AS id_1, t0.topic AS topic_2, t0.created_at AS created_at_3, t0.score AS score_4, t0.applicant_id AS applicant_id_5, t0.done AS done_6 FROM quiz_result t0 WHERE t0.applicant_id = ? LIMIT 1
Parameters:
[
  "mQNJ9WD4ozMp5LwD"
]
3 0.67 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.answer AS answer_3, t0.ia_score AS ia_score_4, t0.ia_comment AS ia_comment_5, t0.choices AS choices_6, t0.quiz_id AS quiz_id_7 FROM question_result t0 WHERE t0.quiz_id = ?
Parameters:
[
  389
]

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\Cv
  • The association App\Entity\Cv#category refers to the inverse side field App\Entity\Category#cv which does not exist.
App\Entity\Category No errors.
App\Entity\Status No errors.
App\Entity\Fiche
  • The association App\Entity\Fiche#category refers to the inverse side field App\Entity\Category#cv which does not exist.
  • The field App\Entity\Fiche#compared is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Compared#fiche does not contain the required 'inversedBy="compared"' attribute.
  • The association App\Entity\Fiche#quiz refers to the owning side field App\Entity\Quiz#quiz which does not exist.
App\Entity\QuestionRH No errors.
App\Entity\Techno No errors.
App\Entity\Compared No errors.
App\Entity\ScoreCV No errors.
App\Entity\Functional No errors.
App\Entity\QuizResult
  • The field 'App\Entity\QuizResult#score' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
  • The mappings App\Entity\QuizResult#questions and App\Entity\QuestionResult#quiz are inconsistent with each other.
App\Entity\QuestionResult
  • The association App\Entity\QuestionResult#quiz refers to the inverse side field App\Entity\QuizResult#questionsResult which does not exist.