Query Metrics

20 Database Queries
10 Different statements
16.92 ms Query time
0 Invalid entities
40 Managed entities

Queries

Group similar statements

# Time Info
1 0.93 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.forename AS forename_4, t0.fullname AS fullname_5, t0.plain_password AS plain_password_6, t0.password AS password_7, t0.roles AS roles_8, t0.IP AS IP_9, t0.telephone AS telephone_10, t0.logincount AS logincount_11, t0.first_login AS first_login_12, t0.last_login AS last_login_13, t0.photo AS photo_14, t0.titre AS titre_15, t0.enabled AS enabled_16, t0.autorisationmail AS autorisationmail_17, t0.autorisationsms AS autorisationsms_18, t0.pseudo AS pseudo_19, t0.salt AS salt_20 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "0"
]
2 0.72 ms
SELECT q0_.id AS id_0, q0_.nom AS nom_1, q0_.description AS description_2, q0_.rangaffichage AS rangaffichage_3 FROM questionniveau q0_ ORDER BY q0_.rangaffichage ASC
Parameters:
[]
3 0.59 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.rangaffichage AS rangaffichage_4 FROM questionniveau t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "1"
]
4 0.74 ms
SELECT t0.id AS id_1, t0.notification AS notification_2, t0.actif AS actif_3, t0.imagefond AS imagefond_4, t0.site AS site_5, t0.description AS description_6, t0.optionblog AS optionblog_7, t0.optionmessagerie AS optionmessagerie_8, t0.photo AS photo_9, t0.adresse AS adresse_10, t0.telephone AS telephone_11, t0.info1 AS info1_12, t0.info2 AS info2_13, t0.nbdiapos AS nbdiapos_14, t0.optionconseil AS optionconseil_15, t0.optionproduits AS optionproduits_16, t0.email AS email_17, t0.optionfinance AS optionfinance_18, t0.adresseinternet AS adresseinternet_19, t0.licence AS licence_20, t0.administrateur_id AS administrateur_id_21, t0.proprietaire_id AS proprietaire_id_22, t0.theme_id AS theme_id_23 FROM parametres t0 WHERE t0.actif = ? LIMIT 1
Parameters:
[
  1
]
5 0.69 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.typesite_id AS typesite_id_3 FROM theme t0 WHERE t0.id = ?
Parameters:
[
  4
]
6 0.78 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.finance AS finance_3, t0.peche AS peche_4, t0.produit AS produit_5, t0.mathmuse AS mathmuse_6, t0.paginationblog AS paginationblog_7, t0.deltapageblog AS deltapageblog_8, t0.paginationmessagerie AS paginationmessagerie_9, t0.deltapagemessagerie AS deltapagemessagerie_10, t0.paginationchapitrefaq AS paginationchapitrefaq_11, t0.deltapagechapitrefaq AS deltapagechapitrefaq_12, t0.paginationarticlefaq AS paginationarticlefaq_13, t0.deltapagearticlefaq AS deltapagearticlefaq_14, t0.paginationproduits AS paginationproduits_15, t0.deltapageproduits AS deltapageproduits_16, t0.paginationpeche AS paginationpeche_17, t0.deltapagepeche AS deltapagepeche_18, t0.paginationmathmuse AS paginationmathmuse_19, t0.deltapagemathmuse AS deltapagemathmuse_20 FROM typesite t0 WHERE t0.id = ?
Parameters:
[
  4
]
7 1.52 ms
SELECT q0_.id AS id_0, q0_.titrequestion AS titrequestion_1, q0_.textequestion AS textequestion_2, q0_.textereponse AS textereponse_3, q0_.actif AS actif_4, q0_.rangaffichage AS rangaffichage_5, q0_.photoquestion AS photoquestion_6, q0_.photoreponse AS photoreponse_7, q0_.dateaffichage AS dateaffichage_8, q0_.niveau_id AS niveau_id_9 FROM question q0_ INNER JOIN questionniveau q1_ ON q0_.niveau_id = q1_.id AND (q1_.id = ?) WHERE q0_.actif = ? ORDER BY q0_.rangaffichage DESC LIMIT 10 OFFSET 70
Parameters:
[
  1
  1
]
8 0.69 ms
SELECT q0_.id AS id_0, q0_.lastconsultation AS lastconsultation_1, q0_.nombreconsultations AS nombreconsultations_2, q0_.question_id AS question_id_3, q0_.user_id AS user_id_4 FROM questionvu q0_ WHERE q0_.user_id = ? AND q0_.question_id = ? ORDER BY q0_.lastconsultation DESC
Parameters:
[
  null
  120
]
9 0.69 ms
SELECT q0_.id AS id_0, q0_.lastconsultation AS lastconsultation_1, q0_.nombreconsultations AS nombreconsultations_2, q0_.question_id AS question_id_3, q0_.user_id AS user_id_4 FROM questionvu q0_ WHERE q0_.user_id = ? AND q0_.question_id = ? ORDER BY q0_.lastconsultation DESC
Parameters:
[
  null
  119
]
10 0.69 ms
SELECT q0_.id AS id_0, q0_.lastconsultation AS lastconsultation_1, q0_.nombreconsultations AS nombreconsultations_2, q0_.question_id AS question_id_3, q0_.user_id AS user_id_4 FROM questionvu q0_ WHERE q0_.user_id = ? AND q0_.question_id = ? ORDER BY q0_.lastconsultation DESC
Parameters:
[
  null
  118
]
11 0.67 ms
SELECT q0_.id AS id_0, q0_.lastconsultation AS lastconsultation_1, q0_.nombreconsultations AS nombreconsultations_2, q0_.question_id AS question_id_3, q0_.user_id AS user_id_4 FROM questionvu q0_ WHERE q0_.user_id = ? AND q0_.question_id = ? ORDER BY q0_.lastconsultation DESC
Parameters:
[
  null
  117
]
12 0.67 ms
SELECT q0_.id AS id_0, q0_.lastconsultation AS lastconsultation_1, q0_.nombreconsultations AS nombreconsultations_2, q0_.question_id AS question_id_3, q0_.user_id AS user_id_4 FROM questionvu q0_ WHERE q0_.user_id = ? AND q0_.question_id = ? ORDER BY q0_.lastconsultation DESC
Parameters:
[
  null
  62
]
13 0.73 ms
SELECT q0_.id AS id_0, q0_.lastconsultation AS lastconsultation_1, q0_.nombreconsultations AS nombreconsultations_2, q0_.question_id AS question_id_3, q0_.user_id AS user_id_4 FROM questionvu q0_ WHERE q0_.user_id = ? AND q0_.question_id = ? ORDER BY q0_.lastconsultation DESC
Parameters:
[
  null
  61
]
14 0.72 ms
SELECT q0_.id AS id_0, q0_.lastconsultation AS lastconsultation_1, q0_.nombreconsultations AS nombreconsultations_2, q0_.question_id AS question_id_3, q0_.user_id AS user_id_4 FROM questionvu q0_ WHERE q0_.user_id = ? AND q0_.question_id = ? ORDER BY q0_.lastconsultation DESC
Parameters:
[
  null
  60
]
15 0.61 ms
SELECT q0_.id AS id_0, q0_.lastconsultation AS lastconsultation_1, q0_.nombreconsultations AS nombreconsultations_2, q0_.question_id AS question_id_3, q0_.user_id AS user_id_4 FROM questionvu q0_ WHERE q0_.user_id = ? AND q0_.question_id = ? ORDER BY q0_.lastconsultation DESC
Parameters:
[
  null
  59
]
16 1.55 ms
SELECT q0_.id AS id_0, q0_.lastconsultation AS lastconsultation_1, q0_.nombreconsultations AS nombreconsultations_2, q0_.question_id AS question_id_3, q0_.user_id AS user_id_4 FROM questionvu q0_ WHERE q0_.user_id = ? AND q0_.question_id = ? ORDER BY q0_.lastconsultation DESC
Parameters:
[
  null
  21
]
17 0.70 ms
SELECT q0_.id AS id_0, q0_.lastconsultation AS lastconsultation_1, q0_.nombreconsultations AS nombreconsultations_2, q0_.question_id AS question_id_3, q0_.user_id AS user_id_4 FROM questionvu q0_ WHERE q0_.user_id = ? AND q0_.question_id = ? ORDER BY q0_.lastconsultation DESC
Parameters:
[
  null
  17
]
18 1.64 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT q0_.id AS id_0, q0_.titrequestion AS titrequestion_1, q0_.textequestion AS textequestion_2, q0_.textereponse AS textereponse_3, q0_.actif AS actif_4, q0_.rangaffichage AS rangaffichage_5, q0_.photoquestion AS photoquestion_6, q0_.photoreponse AS photoreponse_7, q0_.dateaffichage AS dateaffichage_8 FROM question q0_ INNER JOIN questionniveau q1_ ON q0_.niveau_id = q1_.id AND (q1_.id = ?) WHERE q0_.actif = ? ORDER BY q0_.rangaffichage DESC) dctrn_result) dctrn_table
Parameters:
[
  1
  1
]
19 0.78 ms
SELECT t0.id AS id_1, t0.notification AS notification_2, t0.actif AS actif_3, t0.imagefond AS imagefond_4, t0.site AS site_5, t0.description AS description_6, t0.optionblog AS optionblog_7, t0.optionmessagerie AS optionmessagerie_8, t0.photo AS photo_9, t0.adresse AS adresse_10, t0.telephone AS telephone_11, t0.info1 AS info1_12, t0.info2 AS info2_13, t0.nbdiapos AS nbdiapos_14, t0.optionconseil AS optionconseil_15, t0.optionproduits AS optionproduits_16, t0.email AS email_17, t0.optionfinance AS optionfinance_18, t0.adresseinternet AS adresseinternet_19, t0.licence AS licence_20, t0.administrateur_id AS administrateur_id_21, t0.proprietaire_id AS proprietaire_id_22, t0.theme_id AS theme_id_23 FROM parametres t0 WHERE t0.actif = ? LIMIT 1
Parameters:
[
  1
]
20 0.82 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.taillepolice AS taillepolice_3, t0.couleurtexte AS couleurtexte_4, t0.couleurfond AS couleurfond_5, t0.couleurlien AS couleurlien_6, t0.couleurhovertexte AS couleurhovertexte_7, t0.couleurhoverfond AS couleurhoverfond_8, t0.couleurbordure AS couleurbordure_9, t0.stylebordure AS stylebordure_10, t0.taillebordure AS taillebordure_11, t0.decoration AS decoration_12, t0.epaisseurpolice AS epaisseurpolice_13, t0.stylepolice AS stylepolice_14, t0.theme_id AS theme_id_15 FROM style t0 WHERE t0.theme_id = ?
Parameters:
[
  4
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Style 20
App\Entity\Question 10
App\Entity\Questionniveau 5
App\Entity\User 2
App\Entity\Parametres 1
App\Entity\Theme 1
App\Entity\Typesite 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Questionniveau No errors.
App\Entity\Question No errors.
App\Entity\Parametres No errors.
App\Entity\Theme No errors.
App\Entity\Typesite No errors.
App\Entity\Style No errors.
App\Entity\Questionchallenge No errors.
App\Entity\Questionvu No errors.