Query Metrics
22
Database Queries
10
Different statements
13.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.24 ms (0.00%) |
7 |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.description AS description_3, t0.adresse AS adresse_4, t0.tel AS tel_5, t0.email AS email_6, t0.urlsiteweb AS urlsiteweb_7, t0.is_actif AS is_actif_8, t0.en_description AS en_description_9 FROM entiteeconomique t0 WHERE t0.id = ?
Parameters:
[
44
]
|
|
3.13 ms (0.00%) |
5 |
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%"
]
|
|
1.24 ms (0.00%) |
1 |
SELECT s0_.id AS id_0, s0_.designation AS designation_1, s0_.video AS video_2, s0_.image AS image_3, s0_.updated_at AS updated_at_4, s0_.is_actif AS is_actif_5 FROM slider_revolution s0_ WHERE s0_.is_actif = 1
Parameters:
[] |
|
1.09 ms (0.00%) |
2 |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.pour_la_description AS pour_la_description_3, t0.article_id AS article_id_4 FROM article_image t0 WHERE t0.article_id = ?
Parameters:
[
6
]
|
|
1.04 ms (0.00%) |
1 |
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_.nombre_click <> 0 ORDER BY p0_.nombre_click DESC LIMIT 6
Parameters:
[] |
|
0.96 ms (0.00%) |
1 |
SELECT c0_.id AS id_0, c0_.designation AS designation_1, c0_.image AS image_2, c0_.url AS url_3, c0_.updated_at AS updated_at_4, c0_.is_actif AS is_actif_5, c0_.categorie AS categorie_6, c0_.couleurcategorie AS couleurcategorie_7, c0_.en_categorie AS en_categorie_8, c0_.entiteeconomique_id AS entiteeconomique_id_9 FROM carouselaccueil c0_ WHERE c0_.is_actif = 1
Parameters:
[] |
|
0.90 ms (0.00%) |
2 |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM theme t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.77 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.contenu AS contenu_3, t0.date_ajout_at AS date_ajout_at_4, t0.pour_accueil AS pour_accueil_5, t0.en_titre AS en_titre_6, t0.en_contenu AS en_contenu_7, t0.theme_id AS theme_id_8 FROM article t0
Parameters:
[] |
|
0.69 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.63 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.imagemenu AS imagemenu_3, t0.updated_at AS updated_at_4, t0.entiteeconomique_id AS entiteeconomique_id_5 FROM imageiles t0
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\SliderRevolution | No errors. |
| App\Entity\Admin\Article | No errors. |
| App\Entity\Admin\Carouselaccueil | No errors. |
| App\Entity\Admin\Imageiles | No errors. |
| App\Entity\Admin\Page | No errors. |
| App\Entity\Admin\Entiteeconomique | No errors. |
| App\Entity\Admin\Theme | No errors. |
| App\Entity\Admin\ArticleImage | No errors. |
| App\Entity\Admin\Categorie | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Admin\Optionssystem | No errors. |
| App\Entity\Admin\Ile | No errors. |
| App\Entity\Admin\ImagesEntiteeconomique | No errors. |