http://comorostourism.km/decouverte_ile/3

Query Metrics

38 Database Queries
6 Different statements
20.17 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.00 ms
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_ile e2_ ON e0_.id = e2_.entiteeconomique_id LEFT JOIN ile i1_ ON i1_.id = e2_.ile_id WHERE i1_.id IN (?) AND e0_.is_actif = 1
Parameters:
[
  "3"
]
2 0.61 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.parametre AS parametre_3 FROM ile t0 WHERE t0.id = ?
Parameters:
[
  "3"
]
3 0.60 ms
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
]
4 0.79 ms
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:
[
  "%histoire%"
]
5 0.61 ms
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:
[
  "%traditions_&_culture%"
]
6 0.58 ms
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:
[
  "%geographie%"
]
7 0.55 ms
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:
[
  "%gastronomie%"
]
8 0.55 ms
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:
[
  "%faune_&_flore%"
]
9 0.54 ms
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:
[
  17
]
10 0.71 ms
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:
[
  17
]
11 0.42 ms
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:
[
  18
]
12 0.49 ms
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:
[
  18
]
13 0.39 ms
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:
[
  19
]
14 0.45 ms
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:
[
  19
]
15 0.40 ms
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:
[
  48
]
16 0.62 ms
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:
[
  48
]
17 0.50 ms
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:
[
  61
]
18 0.61 ms
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:
[
  61
]
19 0.43 ms
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:
[
  62
]
20 0.45 ms
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:
[
  62
]
21 0.43 ms
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:
[
  63
]
22 0.44 ms
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:
[
  63
]
23 0.55 ms
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:
[
  68
]
24 0.49 ms
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:
[
  68
]
25 0.55 ms
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:
[
  70
]
26 0.65 ms
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:
[
  70
]
27 0.49 ms
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:
[
  75
]
28 0.42 ms
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:
[
  75
]
29 0.36 ms
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:
[
  79
]
30 0.40 ms
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:
[
  79
]
31 0.38 ms
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:
[
  80
]
32 0.39 ms
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:
[
  80
]
33 0.38 ms
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:
[
  81
]
34 0.38 ms
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:
[
  81
]
35 0.35 ms
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:
[
  83
]
36 0.49 ms
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:
[
  83
]
37 0.36 ms
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:
[
  85
]
38 0.40 ms
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:
[
  85
]

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\Ile No errors.
App\Entity\Admin\ImagesEntiteeconomique No errors.
App\Entity\Admin\Categorie No errors.
App\Entity\Admin\Carouselaccueil No errors.
App\Entity\User No errors.
App\Entity\Admin\Page No errors.
App\Entity\Admin\Optionssystem No errors.