http://comorostourism.km/sejour_cle_en_main/consulats_etrangers/km

Query Metrics

13 Database Queries
8 Different statements
39.21 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
27.91 ms
(0.00%)
1
"COMMIT"
Parameters:
[]
5.24 ms
(0.00%)
6
SELECT p0_.id AS id_0, p0_.designation AS designation_1, p0_.description AS description_2, p0_.titre_page AS titre_page_3, p0_.couleurtitre AS couleurtitre_4, p0_.parametremenu AS parametremenu_5, p0_.contenu AS contenu_6, p0_.imagemenu AS imagemenu_7, p0_.updated_at AS updated_at_8, p0_.nombre_click AS nombre_click_9, p0_.en_designation AS en_designation_10, p0_.en_description AS en_description_11, p0_.en_titre_page AS en_titre_page_12, p0_.en_contenu AS en_contenu_13 FROM page p0_ WHERE p0_.parametremenu LIKE ?
Parameters:
[
  "%consulats_etrangers%"
]
1.41 ms
(0.00%)
1
SELECT e0_.id AS id_0, e0_.designation AS designation_1, e0_.description AS description_2, e0_.adresse AS adresse_3, e0_.tel AS tel_4, e0_.email AS email_5, e0_.urlsiteweb AS urlsiteweb_6, e0_.is_actif AS is_actif_7, e0_.en_description AS en_description_8 FROM entiteeconomique e0_ LEFT JOIN entiteeconomique_categorie e2_ ON e0_.id = e2_.entiteeconomique_id LEFT JOIN categorie c1_ ON c1_.id = e2_.categorie_id WHERE c1_.id IN (?) ORDER BY e0_.designation ASC
Parameters:
[
  [
    21
  ]
]
1.25 ms
(0.00%)
1
UPDATE page SET nombre_click = ? WHERE id = ?
Parameters:
[
  1774
  9
]
1.22 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0 INNER JOIN page_categorie ON t0.id = page_categorie.categorie_id WHERE page_categorie.page_id = ?
Parameters:
[
  9
]
0.99 ms
(0.00%)
1
SELECT e0_.id AS id_0, e0_.designation AS designation_1, e0_.description AS description_2, e0_.adresse AS adresse_3, e0_.tel AS tel_4, e0_.email AS email_5, e0_.urlsiteweb AS urlsiteweb_6, e0_.is_actif AS is_actif_7, e0_.en_description AS en_description_8 FROM entiteeconomique e0_ LEFT JOIN entiteeconomique_categorie e2_ ON e0_.id = e2_.entiteeconomique_id LEFT JOIN categorie c1_ ON c1_.id = e2_.categorie_id WHERE c1_.id IN (?) LIMIT 7
Parameters:
[
  [
    21
  ]
]
0.79 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.emailadministrateur AS emailadministrateur_2, t0.url_facebook AS url_facebook_3, t0.url_instagram AS url_instagram_4, t0.url_twitter AS url_twitter_5, t0.url_youtube AS url_youtube_6, t0.adressepostale AS adressepostale_7, t0.telephonecontact AS telephonecontact_8, t0.emailcontact AS emailcontact_9, t0.meta_description AS meta_description_10 FROM optionssystem t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.40 ms
(0.00%)
1
"START TRANSACTION"
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\Admin\Entiteeconomique No errors.
App\Entity\Admin\Page No errors.
App\Entity\Admin\Categorie No errors.
App\Entity\User No errors.
App\Entity\Admin\Optionssystem No errors.