http://comorostourism.km/sejour_cle_en_main/art_et_artisanat/ndz

Query Metrics

24 Database Queries
11 Different statements
18.58 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
5.04 ms
(0.00%)
1
"COMMIT"
Parameters:
[]
4.18 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:
[
  "%art_et_artisanat%"
]
1.98 ms
(0.00%)
4
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0 INNER JOIN entiteeconomique_categorie ON t0.id = entiteeconomique_categorie.categorie_id WHERE entiteeconomique_categorie.entiteeconomique_id = ?
Parameters:
[
  41
]
1.81 ms
(0.00%)
4
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.is_thumb AS is_thumb_3, t0.entiteeconomique_id AS entiteeconomique_id_4 FROM images_entiteeconomique t0 WHERE t0.entiteeconomique_id = ?
Parameters:
[
  41
]
1.43 ms
(0.00%)
3
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.parametre AS parametre_3 FROM ile t0 INNER JOIN entiteeconomique_ile ON t0.id = entiteeconomique_ile.ile_id WHERE entiteeconomique_ile.entiteeconomique_id = ?
Parameters:
[
  38
]
1.21 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 LEFT JOIN entiteeconomique_ile e4_ ON e0_.id = e4_.entiteeconomique_id LEFT JOIN ile i3_ ON i3_.id = e4_.ile_id WHERE c1_.id IN (?) AND i3_.parametre LIKE ? ORDER BY e0_.designation ASC
Parameters:
[
  [
    8
  ]
  "%ndz%"
]
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 LEFT JOIN entiteeconomique_ile e4_ ON e0_.id = e4_.entiteeconomique_id LEFT JOIN ile i3_ ON i3_.id = e4_.ile_id WHERE c1_.id IN (?) AND i3_.parametre NOT LIKE ? LIMIT 7
Parameters:
[
  [
    8
  ]
  "%ndz%"
]
0.71 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:
[
  23
]
0.56 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.47 ms
(0.00%)
1
UPDATE page SET nombre_click = ? WHERE id = ?
Parameters:
[
  2047
  23
]
0.20 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\Admin\Ile No errors.
App\Entity\Admin\ImagesEntiteeconomique No errors.
App\Entity\Admin\Carouselaccueil No errors.
App\Entity\User No errors.
App\Entity\Admin\Optionssystem No errors.