Query Metrics
23
Database Queries
11
Different statements
3.37 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.84 ms |
SELECT t0.name AS name_1, t0.extrait AS extrait_2, t0.content AS content_3, t0.online AS online_4, t0.views AS views_5, t0.filename AS filename_6, t0.bandeaufile AS bandeaufile_7, t0.email AS email_8, t0.telephone AS telephone_9, t0.lieu AS lieu_10, t0.heuredetravail AS heuredetravail_11, t0.siteweb AS siteweb_12, t0.facebook AS facebook_13, t0.twitter AS twitter_14, t0.instagram AS instagram_15, t0.reserved AS reserved_16, t0.longitude AS longitude_17, t0.latitude AS latitude_18, t0.featured AS featured_19, t0.id AS id_20, t0.ordre AS ordre_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.slug AS slug_24, t0.user_id AS user_id_25, t0.updated_by_id AS updated_by_id_26, t0.categories_id AS categories_id_27 FROM posts t0 WHERE t0.id = ?
Parameters:
[
"317"
]
|
| 2 | 0.84 ms |
SELECT p0_.name AS name_0, p0_.extrait AS extrait_1, p0_.content AS content_2, p0_.online AS online_3, p0_.views AS views_4, p0_.filename AS filename_5, p0_.bandeaufile AS bandeaufile_6, p0_.email AS email_7, p0_.telephone AS telephone_8, p0_.lieu AS lieu_9, p0_.heuredetravail AS heuredetravail_10, p0_.siteweb AS siteweb_11, p0_.facebook AS facebook_12, p0_.twitter AS twitter_13, p0_.instagram AS instagram_14, p0_.reserved AS reserved_15, p0_.longitude AS longitude_16, p0_.latitude AS latitude_17, p0_.featured AS featured_18, p0_.id AS id_19, p0_.ordre AS ordre_20, p0_.created_at AS created_at_21, p0_.updated_at AS updated_at_22, p0_.slug AS slug_23, m1_.id AS id_24, m1_.name AS name_25, m1_.filename AS filename_26, m1_.updated_at AS updated_at_27, c2_.id AS id_28, c2_.name AS name_29, c2_.slug AS slug_30, c2_.description AS description_31, c2_.filename AS filename_32, c2_.filenamecover AS filenamecover_33, c2_.documents AS documents_34, c2_.documentcover AS documentcover_35, c2_.ordre AS ordre_36, c2_.online AS online_37, c2_.menu AS menu_38, c2_.updated_at AS updated_at_39, c2_.role AS role_40, u3_.email AS email_41, u3_.roles AS roles_42, u3_.password AS password_43, u3_.username AS username_44, u3_.contacts AS contacts_45, u3_.address AS address_46, u3_.filename AS filename_47, u3_.enabled AS enabled_48, u3_.created_at AS created_at_49, u3_.updated_at AS updated_at_50, u3_.last_login AS last_login_51, u3_.nom AS nom_52, u3_.prenoms AS prenoms_53, u3_.id AS id_54, p0_.user_id AS user_id_55, p0_.updated_by_id AS updated_by_id_56, p0_.categories_id AS categories_id_57, m1_.posts_id AS posts_id_58, u3_.domaines_id AS domaines_id_59 FROM posts p0_ LEFT JOIN mediaposts m1_ ON p0_.id = m1_.posts_id LEFT JOIN categorieposts c2_ ON p0_.categories_id = c2_.id LEFT JOIN user u3_ ON p0_.user_id = u3_.id WHERE p0_.id <> ? AND c2_.id = ? ORDER BY RAND() ASC LIMIT 3
Parameters:
[ 317 18 ] |
| 3 | 0.12 ms |
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
]
|
| 4 | 0.09 ms |
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 ] |
| 5 | 0.05 ms |
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 ] |
| 6 | 0.21 ms |
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
]
|
| 7 | 0.16 ms |
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:
[
1
]
|
| 8 | 0.05 ms |
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 4 ] |
| 9 | 0.04 ms |
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 4 ] |
| 10 | 0.05 ms |
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 ] |
| 11 | 0.05 ms |
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:
[ 1 1 ] |
| 12 | 0.05 ms |
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:
[ 2 1 ] |
| 13 | 0.05 ms |
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:
[ 3 1 ] |
| 14 | 0.07 ms |
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 ] |
| 15 | 0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.filename AS filename_3, t0.updated_at AS updated_at_4, t0.posts_id AS posts_id_5 FROM mediaposts t0 WHERE t0.posts_id = ?
Parameters:
[
317
]
|
| 16 | 0.05 ms |
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 1 ] |
| 17 | 0.05 ms |
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 1 ] |
| 18 | 0.04 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2 FROM categories c0_ ORDER BY c0_.id DESC LIMIT 10
Parameters:
[] |
| 19 | 0.13 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.content AS content_3, t0.filename AS filename_4, t0.online AS online_5, t0.featured AS featured_6, t0.views AS views_7, t0.published AS published_8, t0.bandeaufile AS bandeaufile_9, t0.id AS id_10, t0.ordre AS ordre_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.slug AS slug_14, t0.user_id AS user_id_15, t0.categories_id AS categories_id_16, t0.updated_by_id AS updated_by_id_17 FROM actualites t0 WHERE t0.categories_id = ?
Parameters:
[
2
]
|
| 20 | 0.05 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.content AS content_3, t0.filename AS filename_4, t0.online AS online_5, t0.featured AS featured_6, t0.views AS views_7, t0.published AS published_8, t0.bandeaufile AS bandeaufile_9, t0.id AS id_10, t0.ordre AS ordre_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.slug AS slug_14, t0.user_id AS user_id_15, t0.categories_id AS categories_id_16, t0.updated_by_id AS updated_by_id_17 FROM actualites t0 WHERE t0.categories_id = ?
Parameters:
[
1
]
|
| 21 | 0.05 ms |
SELECT a0_.name AS name_0, a0_.description AS description_1, a0_.content AS content_2, a0_.filename AS filename_3, a0_.online AS online_4, a0_.featured AS featured_5, a0_.views AS views_6, a0_.published AS published_7, a0_.bandeaufile AS bandeaufile_8, a0_.id AS id_9, a0_.ordre AS ordre_10, a0_.created_at AS created_at_11, a0_.updated_at AS updated_at_12, a0_.slug AS slug_13, a0_.user_id AS user_id_14, a0_.categories_id AS categories_id_15, a0_.updated_by_id AS updated_by_id_16 FROM actualites a0_ WHERE a0_.online = ? ORDER BY a0_.id DESC LIMIT 3
Parameters:
[
1
]
|
| 22 | 0.05 ms |
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 2 ] |
| 23 | 0.05 ms |
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 2 ] |
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\Posts\Posts | No errors. |
| App\Entity\Posts\Categorieposts | No errors. |
| App\Entity\Posts\Mediaposts | No errors. |
| App\Entity\Categorieacteurs | No errors. |
| App\Entity\Actualites\Actualites | No errors. |
| App\Entity\Logs\Logs | No errors. |
| App\Entity\Institutions | No errors. |
| App\Entity\Brochures | No errors. |
| App\Entity\Articles\Articles | 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. |
| App\Entity\Hotels\Hotels |
|
| App\Entity\Restaurants\Restaurants | 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\Salons\Categoriesalons | No errors. |
| App\Entity\Actualites\Categories | No errors. |
| App\Entity\Mainsliders | No errors. |
| App\Entity\Parametres | No errors. |
| App\Entity\Articles\Mediaarticles | No errors. |
| App\Entity\Pages\Mediapages | No errors. |
| App\Entity\Actualites\Mediasactualites | No errors. |