Query Metrics

23 Database Queries
15 Different statements
31.75 ms Query time
0 Invalid entities
856 Managed entities

Queries

Group similar statements

# Time Info
1 0.43 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
]
2 0.36 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
]
3 0.43 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
]
4 8.32 ms
SELECT t0.id AS id_1, t0.ipadresse AS ipadresse_2, t0.operateur AS operateur_3, t0.adresse AS adresse_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.lastlogin AS lastlogin_7, t0.user_id AS user_id_8 FROM ip t0 WHERE t0.ipadresse = ? LIMIT 1
Parameters:
[
  "216.73.216.112"
]
5 8.60 ms
SELECT t0.id AS id_1, t0.ipadresse AS ipadresse_2, t0.operateur AS operateur_3, t0.adresse AS adresse_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.lastlogin AS lastlogin_7, t0.user_id AS user_id_8 FROM ip t0 WHERE t0.ipadresse = ? LIMIT 1
Parameters:
[
  "216.73.216.112"
]
6 0.29 ms
"START TRANSACTION"
Parameters:
[]
7 0.40 ms
UPDATE ip SET lastlogin = ? WHERE id = ?
Parameters:
[
  "2026-02-04 03:49:47"
  50225
]
8 0.72 ms
"COMMIT"
Parameters:
[]
9 1.70 ms
SELECT t0.id AS id_1, t0.page AS page_2, t0.chemin AS chemin_3, t0.lastvisite AS lastvisite_4, t0.compteur AS compteur_5, t0.IP AS IP_6, t0.user_id AS user_id_7 FROM visite t0 WHERE t0.chemin = ? LIMIT 1
Parameters:
[
  "/de"
]
10 1.52 ms
SELECT t0.id AS id_1, t0.page AS page_2, t0.chemin AS chemin_3, t0.lastvisite AS lastvisite_4, t0.compteur AS compteur_5, t0.IP AS IP_6, t0.user_id AS user_id_7 FROM visite t0 WHERE t0.chemin = ? LIMIT 1
Parameters:
[
  "/de"
]
11 0.33 ms
"START TRANSACTION"
Parameters:
[]
12 0.51 ms
UPDATE visite SET compteur = ? WHERE id = ?
Parameters:
[
  3155
  2550
]
13 0.68 ms
"COMMIT"
Parameters:
[]
14 0.55 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
]
15 0.63 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
]
16 0.43 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.commentaire AS commentaire_4, t0.prix AS prix_5, t0.prixactif AS prixactif_6, t0.diapoproduits AS diapoproduits_7, t0.rangaffichage AS rangaffichage_8, t0.urlphoto AS urlphoto_9 FROM produits t0 WHERE t0.diapoproduits = ?
Parameters:
[
  1
]
17 0.48 ms
SELECT c0_.id AS id_0, c0_.conseil AS conseil_1, c0_.parution AS parution_2, c0_.compteur AS compteur_3 FROM conseil c0_ WHERE c0_.parution BETWEEN ? AND ? ORDER BY c0_.parution ASC
Parameters:
[
  "2026-02-04 00:00:00"
  "2026-02-05 00:00:00"
]
18 2.73 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
Parameters:
[]
19 0.53 ms
SELECT m0_.id AS id_0, m0_.lu AS lu_1, m0_.message_id AS message_id_2, m0_.participant_id AS participant_id_3 FROM messagedonnees m0_ WHERE m0_.participant_id = ? AND m0_.lu = ?
Parameters:
[
  null
  0
]
20 0.56 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
]
21 0.45 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.diapo0 AS diapo0_3, t0.actif AS actif_4, t0.reponse1 AS reponse1_5, t0.diapo1 AS diapo1_6, t0.reponse2 AS reponse2_7, t0.diapo2 AS diapo2_8, t0.reponse3 AS reponse3_9, t0.diapo3 AS diapo3_10, t0.reponse4 AS reponse4_11, t0.diapo4 AS diapo4_12, t0.gagnant_id AS gagnant_id_13 FROM quizz t0 WHERE t0.actif = ? ORDER BY t0.id ASC LIMIT 1
Parameters:
[
  0
]
22 0.52 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
]
23 0.58 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\User 829
App\Entity\Style 20
App\Entity\Parametres 1
App\Entity\Theme 1
App\Entity\Typesite 1
App\Entity\IP 1
App\Entity\Visite 1
App\Entity\Conseil 1
App\Entity\Quizz 1

Entities Mapping

Class Mapping errors
App\Entity\Parametres No errors.
App\Entity\User No errors.
App\Entity\Theme No errors.
App\Entity\Typesite No errors.
App\Entity\Style No errors.
App\Entity\Fil No errors.
App\Entity\Fildonnees No errors.
App\Entity\Message No errors.
App\Entity\Messagedonnees No errors.
App\Entity\Vuproduits No errors.
App\Entity\Questionchallenge No errors.
App\Entity\Questionvu No errors.
App\Entity\Quizzreponse No errors.
App\Entity\Questionmembre No errors.
App\Entity\Questionmembrevu No errors.
App\Entity\Quizz No errors.
App\Entity\IP No errors.
App\Entity\Visite No errors.
App\Entity\Produits No errors.
App\Entity\Conseil No errors.