Query Metrics

27 Database Queries
15 Different statements
4.60 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.83 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.id = ?
Parameters:
[
  "13"
]
2 0.06 ms
"START TRANSACTION"
Parameters:
[]
3 0.19 ms
UPDATE actualites SET views = ?, updated_at = ? WHERE id = ?
Parameters:
[
  10
  "2026-03-03 14:28:05"
  13
]
4 0.28 ms
"COMMIT"
Parameters:
[]
5 1.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_.id <> ? ORDER BY RAND() ASC LIMIT 3
Parameters:
[
  13
]
6 0.13 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
]
7 0.15 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
]
8 0.07 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
]
9 0.23 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
]
10 0.17 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
]
11 0.07 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
]
12 0.06 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
]
13 0.07 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
]
14 0.09 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
]
15 0.07 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
]
16 0.07 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
]
17 0.10 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
]
18 0.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM categories t0 WHERE t0.id = ?
Parameters:
[
  2
]
19 0.19 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.actualites_id AS actualites_id_5 FROM mediasactualites t0 WHERE t0.actualites_id = ?
Parameters:
[
  13
]
20 0.08 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
]
21 0.06 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
]
22 0.06 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:
[]
23 0.15 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
]
24 0.07 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
]
25 0.07 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
]
26 0.07 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
]
27 0.06 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\Actualites\Actualites No errors.
App\Entity\Actualites\Categories No errors.
App\Entity\Actualites\Mediasactualites No errors.
App\Entity\Categorieacteurs 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\Mainsliders 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.