GET https://base.aproximite.fr/_fragment?_path=_format%3Dhtml%26_locale%3Dru%26_controller%3DApp%255CController%255CFilController%253A%253Aliste

Response
200 OK
IP
216.73.216.112
Profiled on
Token
6926e0

Query Metrics

21 Database Queries
12 Different statements
37.73 ms Query time
0 Invalid entities
20 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.05 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
]
View formatted query    View runnable query    Explain query
2 0.65 ms 
SELECT t0.id AS id_1, t0.sujet AS sujet_2, t0.datecreation AS datecreation_3, t0.type AS type_4, t0.createur_id AS createur_id_5 FROM fil t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "59"
]
View formatted query    View runnable query    Explain query
3 0.90 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
]
View formatted query    View runnable query    Explain query
4 0.59 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
]
View formatted query    View runnable query    Explain query
5 0.66 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
]
View formatted query    View runnable query    Explain query
6 10.89 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: 
[
  "/ru/fil/answer/blog/59/2"
]
View formatted query    View runnable query    Explain query
7 15.38 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: 
[
  "/ru/fil/answer/blog/59/2"
]
View formatted query    View runnable query    Explain query
8 0.25 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
9 0.51 ms 
UPDATE visite SET compteur = ?, IP = ? WHERE id = ?
Parameters: 
[
  448
  "216.73.216.112"
  20905
]
View formatted query    View runnable query    Explain query
10 1.02 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
11 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
]
View formatted query    View runnable query    Explain query
12 0.58 ms 
SELECT f0_.id AS id_0, f0_.sujet AS sujet_1, f0_.datecreation AS datecreation_2, f0_.type AS type_3, f0_.createur_id AS createur_id_4 FROM fil f0_ WHERE f0_.type = ? ORDER BY f0_.datecreation DESC LIMIT 5 OFFSET 5
Parameters: 
[
  "blog"
]
View formatted query    View runnable query    Explain query
13 0.63 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT f0_.id AS id_0, f0_.sujet AS sujet_1, f0_.datecreation AS datecreation_2, f0_.type AS type_3 FROM fil f0_ WHERE f0_.type = ? ORDER BY f0_.datecreation DESC) dctrn_result) dctrn_table
Parameters: 
[
  "blog"
]
View formatted query    View runnable query    Explain query
14 0.52 ms 
SELECT t0.id AS id_1, t0.datecreation AS datecreation_2, t0.url AS url_3, t0.corps AS corps_4, t0.fil_id AS fil_id_5, t0.expediteur_id AS expediteur_id_6 FROM message t0 WHERE t0.fil_id = ?
Parameters: 
[
  78
]
View formatted query    View runnable query    Explain query
15 0.59 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 = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
16 0.47 ms 
SELECT t0.id AS id_1, t0.datecreation AS datecreation_2, t0.url AS url_3, t0.corps AS corps_4, t0.fil_id AS fil_id_5, t0.expediteur_id AS expediteur_id_6 FROM message t0 WHERE t0.fil_id = ?
Parameters: 
[
  59
]
View formatted query    View runnable query    Explain query
17 0.47 ms 
SELECT t0.id AS id_1, t0.datecreation AS datecreation_2, t0.url AS url_3, t0.corps AS corps_4, t0.fil_id AS fil_id_5, t0.expediteur_id AS expediteur_id_6 FROM message t0 WHERE t0.fil_id = ?
Parameters: 
[
  48
]
View formatted query    View runnable query    Explain query
18 0.49 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 = ?
Parameters: 
[
  174
]
View formatted query    View runnable query    Explain query
19 0.47 ms 
SELECT t0.id AS id_1, t0.datecreation AS datecreation_2, t0.url AS url_3, t0.corps AS corps_4, t0.fil_id AS fil_id_5, t0.expediteur_id AS expediteur_id_6 FROM message t0 WHERE t0.fil_id = ?
Parameters: 
[
  37
]
View formatted query    View runnable query    Explain query
20 0.50 ms 
SELECT t0.id AS id_1, t0.datecreation AS datecreation_2, t0.url AS url_3, t0.corps AS corps_4, t0.fil_id AS fil_id_5, t0.expediteur_id AS expediteur_id_6 FROM message t0 WHERE t0.fil_id = ?
Parameters: 
[
  35
]
View formatted query    View runnable query    Explain query
21 0.49 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 = ?
Parameters: 
[
  108
]
View formatted query    View runnable query    Explain query

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\Message 7
App\Entity\Fil 5
App\Entity\User 4
App\Entity\Parametres 1
App\Entity\Theme 1
App\Entity\Typesite 1
App\Entity\Visite 1

Entities Mapping

Class Mapping errors
App\Entity\Fil No errors.
App\Entity\Messagedonnees No errors.
App\Entity\Parametres No errors.
App\Entity\User No errors.
App\Entity\Theme No errors.
App\Entity\Fildonnees No errors.
App\Entity\Message No errors.
App\Entity\Typesite No errors.
App\Entity\Style 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\Visite No errors.