GET http://avissacresfrancais.kaiman.fr/

Query Metrics

32 Database Queries
17 Different statements
2.72 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.46 ms
(17.01%)
4
SELECT t1.id AS id_2, t1.email AS email_3, t1.username AS username_4, t1.roles AS roles_5, t1.password AS password_6, t1.api_token AS api_token_7, t1.created_at AS created_at_8, t1.reset_token AS reset_token_9, t1.token_expiration_date AS token_expiration_date_10, t1.updated_at AS updated_at_11, t0.civility AS civility_12, t0.first_name AS first_name_13, t0.last_name AS last_name_14, t0.date_naissance AS date_naissance_15, t1.marque_id AS marque_id_16, t0.adresse_id AS adresse_id_17, t0.contact_id AS contact_id_18, t1.type FROM consommateur t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
  42
]
0.41 ms
(14.99%)
1
SELECT t1.id AS id_2, t1.email AS email_3, t1.username AS username_4, t1.roles AS roles_5, t1.password AS password_6, t1.api_token AS api_token_7, t1.created_at AS created_at_8, t1.reset_token AS reset_token_9, t1.token_expiration_date AS token_expiration_date_10, t1.updated_at AS updated_at_11, t0.name AS name_12, t0.slug AS slug_13, t1.marque_id AS marque_id_14, t0.adresse_id AS adresse_id_15, t0.contact_id AS contact_id_16, t1.type FROM marque t0 INNER JOIN user t1 ON t0.id = t1.id
Parameters:
[]
0.37 ms
(13.53%)
6
SELECT * FROM categorie_question WHERE id = 2
Parameters:
[]
0.15 ms
(5.34%)
2
SELECT * FROM question WHERE id = 2
Parameters:
[]
0.13 ms
(4.85%)
2
SELECT * FROM question WHERE id = 1
Parameters:
[]
0.13 ms
(4.85%)
2
SELECT * FROM categorie_question WHERE id = 1
Parameters:
[]
0.13 ms
(4.81%)
1
SELECT t0.id AS id_1, t0.commentaire_libre AS commentaire_libre_2, t0.score AS score_3, t0.date_achat AS date_achat_4, t0.date_experience AS date_experience_5, t0.country AS country_6, t0.postalcode AS postalcode_7, t0.filepath AS filepath_8, t0.participation_date AS participation_date_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.state AS state_12, t0.marque_id AS marque_id_13, t0.consommateur_id AS consommateur_id_14, t0.questionnaire_id AS questionnaire_id_15 FROM participation t0 WHERE t0.state = ?
Parameters:
[
  1
]
0.13 ms
(4.70%)
1
SELECT t0.id AS id_1, t0.commentaire_libre AS commentaire_libre_2, t0.score AS score_3, t0.date_achat AS date_achat_4, t0.date_experience AS date_experience_5, t0.country AS country_6, t0.postalcode AS postalcode_7, t0.filepath AS filepath_8, t0.participation_date AS participation_date_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.state AS state_12, t0.marque_id AS marque_id_13, t0.consommateur_id AS consommateur_id_14, t0.questionnaire_id AS questionnaire_id_15 FROM participation t0 WHERE t0.state = ? ORDER BY t0.participation_date DESC
Parameters:
[
  1
]
0.12 ms
(4.56%)
2
SELECT * FROM question WHERE id = 3
Parameters:
[]
0.12 ms
(4.56%)
2
SELECT * FROM question WHERE id = 4
Parameters:
[]
0.12 ms
(4.56%)
2
SELECT * FROM question WHERE id = 5
Parameters:
[]
0.12 ms
(4.37%)
2
SELECT * FROM categorie_question WHERE id = 3
Parameters:
[]
0.08 ms
(2.98%)
1
SELECT * FROM questions_participation WHERE participation_id = 5
Parameters:
[]
0.06 ms
(2.24%)
1
SELECT * FROM questions_participation WHERE participation_id = 4
Parameters:
[]
0.06 ms
(2.24%)
1
SELECT * FROM questions_participation WHERE participation_id = 3
Parameters:
[]
0.06 ms
(2.21%)
1
SELECT * FROM questions_participation WHERE participation_id = 2
Parameters:
[]
0.06 ms
(2.20%)
1
SELECT * FROM questions_participation WHERE participation_id = 1
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\User No errors.
App\Entity\Marque
  • The mappings App\Entity\Marque#questionnaires and App\Entity\Questionnaire#marque are inconsistent with each other.
  • The association App\Entity\Marque#categorieQuestions refers to the owning side field App\Entity\CategorieQuestion#marque which does not exist.
App\Entity\Adresse No errors.
App\Entity\Contact No errors.
App\Entity\Question No errors.
App\Entity\Participation No errors.
App\Entity\Questionnaire No errors.
App\Entity\CategorieQuestion
  • The mappings App\Entity\CategorieQuestion#category and App\Entity\CategorieQuestion#parent are inconsistent with each other.
  • The association App\Entity\CategorieQuestion#parent refers to the owning side field App\Entity\CategorieQuestion#categorieQuestion which does not exist.
App\Entity\Consommateur No errors.