Query Metrics
38
Database Queries
11
Different statements
27.75 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.33 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:
[
"%plages%"
]
|
| 2 | 0.31 ms |
"START TRANSACTION"
Parameters:
[] |
| 3 | 0.90 ms |
UPDATE page SET nombre_click = ? WHERE id = ?
Parameters:
[ 4844 21 ] |
| 4 | 5.20 ms |
"COMMIT"
Parameters:
[] |
| 5 | 0.77 ms |
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:
[
21
]
|
| 6 | 2.28 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_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:
[
[
7
]
"%ngz%"
]
|
| 7 | 1.69 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_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:
[
[
7
]
"%ngz%"
]
|
| 8 | 0.65 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
]
|
| 9 | 0.85 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%"
]
|
| 10 | 0.80 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%"
]
|
| 11 | 0.68 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%"
]
|
| 12 | 0.62 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%"
]
|
| 13 | 0.63 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%"
]
|
| 14 | 0.70 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:
[
53
]
|
| 15 | 0.78 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:
[
53
]
|
| 16 | 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:
[
10
]
|
| 17 | 0.54 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:
[
10
]
|
| 18 | 0.44 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:
[
88
]
|
| 19 | 0.52 ms |
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:
[
88
]
|
| 20 | 0.52 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:
[
88
]
|
| 21 | 0.45 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:
[
74
]
|
| 22 | 0.48 ms |
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:
[
74
]
|
| 23 | 0.48 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:
[
74
]
|
| 24 | 0.41 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:
[
73
]
|
| 25 | 0.45 ms |
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:
[
73
]
|
| 26 | 0.46 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:
[
73
]
|
| 27 | 0.37 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:
[
23
]
|
| 28 | 0.33 ms |
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:
[
23
]
|
| 29 | 0.33 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:
[
23
]
|
| 30 | 0.30 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:
[
8
]
|
| 31 | 0.48 ms |
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:
[
8
]
|
| 32 | 0.33 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:
[
8
]
|
| 33 | 0.34 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
]
|
| 34 | 0.34 ms |
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:
[
83
]
|
| 35 | 0.37 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
]
|
| 36 | 0.30 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
]
|
| 37 | 0.32 ms |
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:
[
81
]
|
| 38 | 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:
[
81
]
|
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. |