Query Metrics
19
Database Queries
12
Different statements
3.62 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.94 ms (25.99%) |
1 |
SELECT t0.name AS name_1, t0.description AS description_2, t0.filename AS filename_3, t0.bandeaufile AS bandeaufile_4, t0.address AS address_5, t0.type AS type_6, t0.contacts AS contacts_7, t0.email AS email_8, t0.siteweb AS siteweb_9, t0.facebook AS facebook_10, t0.twitter AS twitter_11, t0.instagram AS instagram_12, t0.ambiance AS ambiance_13, t0.joursouvrables AS joursouvrables_14, t0.online AS online_15, t0.activated AS activated_16, t0.othersspecialites AS othersspecialites_17, t0.othersservices AS othersservices_18, t0.longitude AS longitude_19, t0.latitude AS latitude_20, t0.featured AS featured_21, t0.id AS id_22, t0.ordre AS ordre_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.slug AS slug_26, t0.user_id AS user_id_27, t0.cities_id AS cities_id_28 FROM restaurants t0 WHERE t0.id = ?
Parameters:
[
"1"
]
|
|
0.75 ms (20.64%) |
1 |
SELECT r0_.name AS name_0, r0_.description AS description_1, r0_.filename AS filename_2, r0_.bandeaufile AS bandeaufile_3, r0_.address AS address_4, r0_.type AS type_5, r0_.contacts AS contacts_6, r0_.email AS email_7, r0_.siteweb AS siteweb_8, r0_.facebook AS facebook_9, r0_.twitter AS twitter_10, r0_.instagram AS instagram_11, r0_.ambiance AS ambiance_12, r0_.joursouvrables AS joursouvrables_13, r0_.online AS online_14, r0_.activated AS activated_15, r0_.othersspecialites AS othersspecialites_16, r0_.othersservices AS othersservices_17, r0_.longitude AS longitude_18, r0_.latitude AS latitude_19, r0_.featured AS featured_20, r0_.id AS id_21, r0_.ordre AS ordre_22, r0_.created_at AS created_at_23, r0_.updated_at AS updated_at_24, r0_.slug AS slug_25, r0_.user_id AS user_id_26, r0_.cities_id AS cities_id_27 FROM restaurants r0_ WHERE r0_.id <> ? ORDER BY RAND() ASC LIMIT 3
Parameters:
[
1
]
|
|
0.37 ms (10.24%) |
2 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.ordre AS ordre_4, c0_.menu AS menu_5, c0_.filename AS filename_6, c0_.updated_at AS updated_at_7, c0_.laus AS laus_8, a1_.name AS name_9, a1_.slug AS slug_10, a1_.extrait AS extrait_11, a1_.urlvideo AS urlvideo_12, a1_.content AS content_13, a1_.filename AS filename_14, a1_.online AS online_15, a1_.views AS views_16, a1_.circuitslies AS circuitslies_17, a1_.bandeaufile AS bandeaufile_18, a1_.featured AS featured_19, a1_.incontournable AS incontournable_20, a1_.incontournablename AS incontournablename_21, a1_.id AS id_22, a1_.ordre AS ordre_23, a1_.created_at AS created_at_24, a1_.updated_at AS updated_at_25, a1_.user_id AS user_id_26, a1_.updated_by_id AS updated_by_id_27, a1_.categories_id AS categories_id_28 FROM categoriearticles c0_ LEFT JOIN articles a1_ ON c0_.id = a1_.categories_id WHERE c0_.menu = ? ORDER BY c0_.ordre ASC
Parameters:
[
0
]
|
|
0.28 ms (7.62%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.filename AS filename_5, t0.filenamecover AS filenamecover_6, t0.documents AS documents_7, t0.documentcover AS documentcover_8, t0.ordre AS ordre_9, t0.online AS online_10, t0.menu AS menu_11, t0.updated_at AS updated_at_12, t0.role AS role_13 FROM categorieposts t0 WHERE t0.menu = ? AND t0.online = ? ORDER BY t0.ordre ASC
Parameters:
[ 0 1 ] |
|
0.26 ms (7.31%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.filename AS filename_4, t0.position AS position_5, t0.online AS online_6, t0.updated_at AS updated_at_7 FROM publicites t0 WHERE t0.online = ? AND t0.position = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[ 1 3 ] |
|
0.26 ms (7.31%) |
1 |
SELECT t0.name AS name_1, t0.filename AS filename_2, t0.id AS id_3, t0.ordre AS ordre_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.restaurants_id AS restaurants_id_7 FROM mediasrestaurants t0 WHERE t0.restaurants_id = ?
Parameters:
[
1
]
|
|
0.20 ms (5.57%) |
1 |
SELECT t0.name AS name_1, t0.id AS id_2, t0.ordre AS ordre_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.slug AS slug_6 FROM specialites t0 INNER JOIN restaurants_specialites ON t0.id = restaurants_specialites.specialites_id WHERE restaurants_specialites.restaurants_id = ?
Parameters:
[
1
]
|
|
0.20 ms (5.41%) |
1 |
SELECT t0.name AS name_1, t0.id AS id_2, t0.ordre AS ordre_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.slug AS slug_6 FROM servicesrestaurants t0 INNER JOIN restaurants_servicesrestaurants ON t0.id = restaurants_servicesrestaurants.servicesrestaurants_id WHERE restaurants_servicesrestaurants.restaurants_id = ?
Parameters:
[
1
]
|
|
0.11 ms (3.01%) |
1 |
SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.username AS username_4, t0.contacts AS contacts_5, t0.address AS address_6, t0.filename AS filename_7, t0.enabled AS enabled_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.last_login AS last_login_11, t0.nom AS nom_12, t0.prenoms AS prenoms_13, t0.id AS id_14, t0.domaines_id AS domaines_id_15 FROM user t0 WHERE t0.id = ?
Parameters:
[
4
]
|
|
0.10 ms (2.68%) |
1 |
SELECT t0.name AS name_1, t0.filename AS filename_2, t0.online AS online_3, t0.menu_id AS menu_id_4, t0.menu_name AS menu_name_5, t0.content AS content_6, t0.bandeaufile AS bandeaufile_7, t0.extrait AS extrait_8, t0.id AS id_9, t0.ordre AS ordre_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.slug AS slug_13 FROM pages t0 WHERE t0.online = ? AND t0.menu_id = ? ORDER BY t0.ordre ASC
Parameters:
[ 1 2 ] |
|
0.09 ms (2.43%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.telephone AS telephone_4, t0.cellulaire AS cellulaire_5, t0.email AS email_6, t0.filename AS filename_7, t0.adresses AS adresses_8, t0.updated_at AS updated_at_9, t0.complements AS complements_10, t0.activite AS activite_11, t0.slogan AS slogan_12, t0.keywords AS keywords_13, t0.facebook AS facebook_14, t0.twitter AS twitter_15, t0.googleplus AS googleplus_16, t0.instagram AS instagram_17, t0.youtube AS youtube_18, t0.incontournable_text_fond AS incontournable_text_fond_19, t0.incontournable_text_title AS incontournable_text_title_20, t0.incontournable_text_content AS incontournable_text_content_21, t0.filenamepopup AS filenamepopup_22, t0.video_popup AS video_popup_23, t0.type_popup AS type_popup_24, t0.enable_popup AS enable_popup_25 FROM parametres t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.06 ms (1.79%) |
1 |
SELECT t0.name AS name_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.slug AS slug_5 FROM cities t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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\User | No errors. |
| App\Entity\Restaurants\Restaurants | No errors. |
| App\Entity\Localizations\Cities | No errors. |
| App\Entity\Restaurants\Specialites | No errors. |
| App\Entity\Restaurants\Servicesrestaurants | No errors. |
| App\Entity\Restaurants\Mediasrestaurants | No errors. |
| App\Entity\Parametres\Titles | No errors. |
| App\Entity\Pages\Pages | No errors. |
| App\Entity\Publicites\Publicites | No errors. |
| App\Entity\Articles\Categoriearticles | No errors. |
| App\Entity\Posts\Categorieposts | No errors. |
| App\Entity\Salons\Categoriesalons | No errors. |
| App\Entity\Actualites\Categories | No errors. |
| App\Entity\Mainsliders | No errors. |
| App\Entity\Actualites\Actualites | No errors. |
| App\Entity\Parametres | No errors. |
| App\Entity\Articles\Articles | No errors. |
| App\Entity\Articles\Mediaarticles | No errors. |
| App\Entity\Posts\Posts | No errors. |
| App\Entity\Pages\Mediapages | No errors. |
| App\Entity\Hotels\Hotels |
|
| App\Entity\Localizations\Communes | No errors. |
| App\Entity\Categorieacteurs | No errors. |
| App\Entity\Logs\Logs | No errors. |
| App\Entity\Institutions | No errors. |
| App\Entity\Brochures | No errors. |
| App\Entity\Directions | No errors. |
| App\Entity\Partenaires | No errors. |
| App\Entity\Documentations | No errors. |
| App\Entity\Salons\Salons | No errors. |
| App\Entity\Seminaires | No errors. |