Query Metrics

219 Database Queries
19 Different statements
74.96 ms Query time
3 Invalid entities
99 Managed entities

Grouped Statements

Show all queries

Time Count Info
53.57 ms
(71.47%)
187
SELECT m0_.id AS id_0, m0_.thumb AS thumb_1, m0_.name AS name_2, m0_.slug AS slug_3, m0_.color AS color_4, m0_.type AS type_5, m0_.externallink AS externallink_6, m0_.rang AS rang_7, m0_.parentid AS parentid_8, m0_.is_accordiant AS is_accordiant_9, m0_.subjectid AS subjectid_10, m0_.ispublish AS ispublish_11, m0_.widgetId AS widgetId_12 FROM menuitems m0_ WHERE m0_.id = ? LIMIT 1
Parameters:
[
  61
]
5.95 ms
(7.94%)
9
SELECT m0_.id AS id_0, m0_.thumb AS thumb_1, m0_.name AS name_2, m0_.slug AS slug_3, m0_.color AS color_4, m0_.type AS type_5, m0_.externallink AS externallink_6, m0_.rang AS rang_7, m0_.parentid AS parentid_8, m0_.is_accordiant AS is_accordiant_9, m0_.subjectid AS subjectid_10, m0_.ispublish AS ispublish_11, m0_.widgetId AS widgetId_12, m1_.id AS id_13, m1_.title AS title_14, m1_.position AS position_15, m1_.ispublish AS ispublish_16, m1_.rang AS rang_17, m0_.menus_id AS menus_id_18 FROM menuitems m0_ INNER JOIN menus m1_ ON m0_.menus_id = m1_.id WHERE m0_.parentid = ? AND m1_.id = ? AND m0_.ispublish = ? AND (m0_.is_accordiant IS NULL OR m0_.is_accordiant = 0) ORDER BY m0_.rang ASC
Parameters:
[
  5
  226
  1
]
3.88 ms
(5.17%)
5
SELECT m0_.id AS id_0, m0_.objectid AS objectid_1, m0_.modulename AS modulename_2, m0_.isfuture AS isfuture_3, m0_.ordernumber AS ordernumber_4, m0_.created AS created_5, m0_.updated AS updated_6, m1_.id AS id_7, m1_.name AS name_8, m1_.imagedescription AS imagedescription_9, m1_.picturename AS picturename_10, m1_.picturenamewebp AS picturenamewebp_11, m1_.thumbname AS thumbname_12, m1_.thumbnamewebp AS thumbnamewebp_13, m1_.picturesize AS picturesize_14, m1_.picturetype AS picturetype_15, m1_.picturetypewebp AS picturetypewebp_16, m1_.folderpath AS folderpath_17, m1_.path AS path_18, m1_.widget AS widget_19, m1_.actus AS actus_20, m1_.title AS title_21, m1_.description AS description_22, m1_.created AS created_23 FROM mediapages m0_ INNER JOIN media m1_ ON m0_.media_id = m1_.id WHERE m0_.objectid = ? AND m0_.modulename = ?
Parameters:
[
  48
  "SETTINGSITE"
]
1.34 ms
(1.79%)
2
SELECT m0_.id AS id_0, m0_.objectid AS objectid_1, m0_.modulename AS modulename_2, m0_.isfuture AS isfuture_3, m0_.ordernumber AS ordernumber_4, m0_.created AS created_5, m0_.updated AS updated_6, m1_.id AS id_7, m1_.name AS name_8, m1_.imagedescription AS imagedescription_9, m1_.picturename AS picturename_10, m1_.picturenamewebp AS picturenamewebp_11, m1_.thumbname AS thumbname_12, m1_.thumbnamewebp AS thumbnamewebp_13, m1_.picturesize AS picturesize_14, m1_.picturetype AS picturetype_15, m1_.picturetypewebp AS picturetypewebp_16, m1_.folderpath AS folderpath_17, m1_.path AS path_18, m1_.widget AS widget_19, m1_.actus AS actus_20, m1_.title AS title_21, m1_.description AS description_22, m1_.created AS created_23 FROM mediapages m0_ INNER JOIN media m1_ ON m0_.media_id = m1_.id WHERE m0_.objectid IN (?, ?, ?) AND m0_.modulename = ?
Parameters:
[
  111
  110
  109
  "ACTUALITE"
]
1.11 ms
(1.49%)
1
SELECT t0.id AS id_1, t0.entity_name AS entity_name_2, t0.changed_fields AS changed_fields_3, t0.content AS content_4, t0.operation AS operation_5, t0.created_at AS created_at_6, t0.user_id AS user_id_7 FROM database_activity_logger t0 ORDER BY t0.id DESC LIMIT 1
Parameters:
[]
1.01 ms
(1.35%)
1
SELECT m0_.id AS id_0, m0_.objectid AS objectid_1, m0_.modulename AS modulename_2, m0_.isfuture AS isfuture_3, m0_.ordernumber AS ordernumber_4, m0_.created AS created_5, m0_.updated AS updated_6, m1_.id AS id_7, m1_.name AS name_8, m1_.imagedescription AS imagedescription_9, m1_.picturename AS picturename_10, m1_.picturenamewebp AS picturenamewebp_11, m1_.thumbname AS thumbname_12, m1_.thumbnamewebp AS thumbnamewebp_13, m1_.picturesize AS picturesize_14, m1_.picturetype AS picturetype_15, m1_.picturetypewebp AS picturetypewebp_16, m1_.folderpath AS folderpath_17, m1_.path AS path_18, m1_.widget AS widget_19, m1_.actus AS actus_20, m1_.title AS title_21, m1_.description AS description_22, m1_.created AS created_23 FROM mediapages m0_ INNER JOIN media m1_ ON m0_.media_id = m1_.id WHERE m0_.objectid IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND m0_.modulename = ?
Parameters:
[
  9
  18
  13
  10
  4
  15
  8
  23
  14
  30
  21
  "OURSERVICE"
]
0.95 ms
(1.26%)
2
SELECT s0_.id AS id_0, s0_.groupname AS groupname_1, s0_.grouplibeller AS grouplibeller_2, s0_.libeller AS libeller_3, s0_.name AS name_4, s0_.fieldtype AS fieldtype_5, s0_.helptext AS helptext_6, s0_.settingvalue AS settingvalue_7, s0_.witheditor AS witheditor_8, s0_.ordre AS ordre_9, s0_.created AS created_10, s0_.updated AS updated_11 FROM settingsite s0_ WHERE s0_.groupname IN (?) ORDER BY s0_.ordre ASC
Parameters:
[
  "seokeywords"
]
0.93 ms
(1.24%)
1
SELECT o0_.id AS id_0, o0_.title AS title_1, o0_.libeller AS libeller_2, o0_.description AS description_3, o0_.picture AS picture_4, o0_.thumb AS thumb_5, o0_.ispublic AS ispublic_6, o0_.displayinhomepage AS displayinhomepage_7, o0_.displayinglobalservicepage AS displayinglobalservicepage_8, o0_.openinotherwindow AS openinotherwindow_9, o0_.url AS url_10, o0_.orderservice AS orderservice_11, o0_.nbrvisite AS nbrvisite_12, o0_.linktype AS linktype_13, o0_.menuitemid AS menuitemid_14, o0_.landpageid AS landpageid_15, o0_.created AS created_16, o0_.updated AS updated_17 FROM ourservices o0_ WHERE o0_.ispublic = ? AND o0_.displayinhomepage = ? ORDER BY o0_.orderservice ASC
Parameters:
[
  1
  1
]
0.92 ms
(1.23%)
1
SELECT s0_.id AS id_0, s0_.groupname AS groupname_1, s0_.grouplibeller AS grouplibeller_2, s0_.libeller AS libeller_3, s0_.name AS name_4, s0_.fieldtype AS fieldtype_5, s0_.helptext AS helptext_6, s0_.settingvalue AS settingvalue_7, s0_.witheditor AS witheditor_8, s0_.ordre AS ordre_9, s0_.created AS created_10, s0_.updated AS updated_11 FROM settingsite s0_ WHERE s0_.groupname IN (?, ?, ?) ORDER BY s0_.ordre ASC
Parameters:
[
  "homepage"
  "actualitypage"
  "blogpage"
]
0.81 ms
(1.08%)
1
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.excerpt AS excerpt_3, a0_.isblogarticle AS isblogarticle_4, a0_.content AS content_5, a0_.created AS created_6, a0_.datearticle AS datearticle_7, a0_.orderartc AS orderartc_8, a0_.nbrvisite AS nbrvisite_9, a0_.updated AS updated_10, a0_.author AS author_11, a0_.ceotitle AS ceotitle_12, a0_.ceodescription AS ceodescription_13, a0_.canonical AS canonical_14, a0_.seokeywords AS seokeywords_15, a0_.imagealaune AS imagealaune_16, a0_.imagealaunethumb AS imagealaunethumb_17, a0_.ispublic AS ispublic_18, a0_.isinhomepage AS isinhomepage_19, a0_.isfuture AS isfuture_20 FROM article a0_ WHERE a0_.isfuture = ? AND a0_.ispublic = ? LIMIT 1
Parameters:
[
  1
  1
]
0.76 ms
(1.02%)
1
SELECT o0_.id AS id_0, o0_.title AS title_1, o0_.refinterne AS refinterne_2, o0_.newscoreaffect AS newscoreaffect_3, o0_.nbrvisite AS nbrvisite_4, o0_.ispublish AS ispublish_5, o0_.publishdate AS publishdate_6, o0_.expiration_date AS expiration_date_7, o0_.datebeginwork AS datebeginwork_8, o0_.usemainlogo AS usemainlogo_9, o0_.logo AS logo_10, o0_.emailpost AS emailpost_11, o0_.telpost AS telpost_12, o0_.introduction AS introduction_13, o0_.titlepostaffichage AS titlepostaffichage_14, o0_.description AS description_15, o0_.duresanonces AS duresanonces_16, o0_.tauxactvity AS tauxactvity_17, o0_.tauxactvityfrom AS tauxactvityfrom_18, o0_.tauxactvityto AS tauxactvityto_19, o0_.displaymentionlegaleagenceplacement AS displaymentionlegaleagenceplacement_20, o0_.sendautoresponsetonotqualificationcondidate AS sendautoresponsetonotqualificationcondidate_21, o0_.sendnotifpermail AS sendnotifpermail_22, o0_.receivealertemailexpiration AS receivealertemailexpiration_23, o0_.display_coordonnee_adresse AS display_coordonnee_adresse_24, o0_.display_coordonnee_tel AS display_coordonnee_tel_25, o0_.display_coordonnee_site AS display_coordonnee_site_26, o0_.display_coordonnee_mail AS display_coordonnee_mail_27, o0_.activatecandidatureenligne AS activatecandidatureenligne_28, o0_.displayonlycontons AS displayonlycontons_29, o0_.type_notification_postulation AS type_notification_postulation_30, o0_.coordonneeaffichersurannonce AS coordonneeaffichersurannonce_31, o0_.newscorequestions AS newscorequestions_32, o0_.created AS created_33, o0_.updated AS updated_34, o0_.isdeleted AS isdeleted_35, o0_.author AS author_36, o0_.seotitle AS seotitle_37, o0_.seodescription AS seodescription_38, o0_.seokeywords AS seokeywords_39, o0_.localiteafficher AS localiteafficher_40, o1_.id AS id_41, o1_.name AS name_42, o1_.code AS code_43, c2_.id AS id_44, c2_.name AS name_45, c2_.parentid AS parentid_46, c2_.isdeleted AS isdeleted_47, c2_.ispublish AS ispublish_48, c2_.orderlist AS orderlist_49, c2_.isexcluded AS isexcluded_50, c3_.id AS id_51, c3_.name AS name_52 FROM offresemplois o0_ INNER JOIN offresemploistatus o1_ ON o0_.offresemploistatus_id = o1_.id LEFT JOIN offreemploi_categories o4_ ON o0_.id = o4_.offresemplois_id LEFT JOIN categorieemplois c2_ ON c2_.id = o4_.categorieemplois_id LEFT JOIN contracttypes c3_ ON o0_.contracttypes_id = c3_.id WHERE o1_.code = ? ORDER BY o0_.id DESC LIMIT 2
Parameters:
[
  "publish"
]
0.69 ms
(0.92%)
1
SELECT m0_.id AS id_0, m0_.thumb AS thumb_1, m0_.name AS name_2, m0_.slug AS slug_3, m0_.color AS color_4, m0_.type AS type_5, m0_.externallink AS externallink_6, m0_.rang AS rang_7, m0_.parentid AS parentid_8, m0_.is_accordiant AS is_accordiant_9, m0_.subjectid AS subjectid_10, m0_.ispublish AS ispublish_11, m0_.widgetId AS widgetId_12, m1_.id AS id_13, m1_.title AS title_14, m1_.position AS position_15, m1_.ispublish AS ispublish_16, m1_.rang AS rang_17, m0_.menus_id AS menus_id_18 FROM menuitems m0_ INNER JOIN menus m1_ ON m0_.menus_id = m1_.id WHERE (m0_.parentid IS NULL OR m0_.parentid = ?) AND m1_.id = ? AND m0_.ispublish = ? AND (m0_.is_accordiant IS NULL OR m0_.is_accordiant = 0) ORDER BY m0_.rang ASC
Parameters:
[
  0
  226
  1
]
0.55 ms
(0.73%)
1
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.excerpt AS excerpt_3, a0_.isblogarticle AS isblogarticle_4, a0_.content AS content_5, a0_.created AS created_6, a0_.datearticle AS datearticle_7, a0_.orderartc AS orderartc_8, a0_.nbrvisite AS nbrvisite_9, a0_.updated AS updated_10, a0_.author AS author_11, a0_.ceotitle AS ceotitle_12, a0_.ceodescription AS ceodescription_13, a0_.canonical AS canonical_14, a0_.seokeywords AS seokeywords_15, a0_.imagealaune AS imagealaune_16, a0_.imagealaunethumb AS imagealaunethumb_17, a0_.ispublic AS ispublic_18, a0_.isinhomepage AS isinhomepage_19, a0_.isfuture AS isfuture_20 FROM article a0_ WHERE a0_.ispublic = ? AND a0_.isinhomepage = ? AND (a0_.isfuture = ? OR a0_.isfuture IS NULL) ORDER BY a0_.datearticle DESC LIMIT 3
Parameters:
[
  1
  1
  0
]
0.55 ms
(0.73%)
1
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.descriptions AS descriptions_3, a0_.excerpt AS excerpt_4, a0_.imagealaune AS imagealaune_5, a0_.thumb AS thumb_6, a0_.alune AS alune_7, a0_.created AS created_8, a0_.updated AS updated_9, a0_.ispublic AS ispublic_10, a0_.isfuture AS isfuture_11, a0_.dateactu AS dateactu_12, a0_.orderact AS orderact_13, a0_.nbrvisite AS nbrvisite_14, a0_.ceotitle AS ceotitle_15, a0_.ceodescription AS ceodescription_16, a0_.seokeywords AS seokeywords_17, a0_.canonical AS canonical_18, a0_.author AS author_19 FROM actualites a0_ WHERE a0_.isfuture = ? AND a0_.ispublic = ? LIMIT 1
Parameters:
[
  1
  1
]
0.50 ms
(0.67%)
1
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.descriptions AS descriptions_3, a0_.excerpt AS excerpt_4, a0_.imagealaune AS imagealaune_5, a0_.thumb AS thumb_6, a0_.alune AS alune_7, a0_.created AS created_8, a0_.updated AS updated_9, a0_.ispublic AS ispublic_10, a0_.isfuture AS isfuture_11, a0_.dateactu AS dateactu_12, a0_.orderact AS orderact_13, a0_.nbrvisite AS nbrvisite_14, a0_.ceotitle AS ceotitle_15, a0_.ceodescription AS ceodescription_16, a0_.seokeywords AS seokeywords_17, a0_.canonical AS canonical_18, a0_.author AS author_19 FROM actualites a0_ WHERE a0_.ispublic = ? AND a0_.alune = ? AND (a0_.isfuture = ? OR a0_.isfuture IS NULL) ORDER BY a0_.dateactu DESC, a0_.orderact ASC LIMIT 3
Parameters:
[
  1
  1
  0
]
0.47 ms
(0.63%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.position AS position_3, t0.ispublish AS ispublish_4, t0.rang AS rang_5 FROM menus t0 WHERE t0.position = ? LIMIT 1
Parameters:
[
  "MAIN"
]
0.40 ms
(0.53%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.position AS position_3, t0.texttitles AS texttitles_4 FROM galeries t0 WHERE t0.position IN (?) LIMIT 1
Parameters:
[
  "top"
]
0.33 ms
(0.43%)
1
SELECT m0_.id AS id_0, m0_.iscurrentmonthemploye AS iscurrentmonthemploye_1, m0_.name AS name_2, m0_.surname AS surname_3, m0_.description AS description_4, m0_.post AS post_5, m0_.picture AS picture_6, m0_.link AS link_7, m0_.created AS created_8, m0_.updated AS updated_9 FROM monthemployes m0_ WHERE m0_.iscurrentmonthemploye = ? LIMIT 1
Parameters:
[
  1
]
0.23 ms
(0.31%)
1
SELECT g0_.id AS id_0, g0_.title AS title_1, g0_.position AS position_2, g0_.texttitles AS texttitles_3 FROM galeries g0_ WHERE g0_.position = ? LIMIT 1
Parameters:
[
  "top"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Menuitems 91
App\Entity\Settingsite 4
App\Entity\DatabaseActivityLogger 1
App\Entity\User 1
App\Entity\Galeries 1
App\Entity\Menus 1

Entities Mapping

Class Mapping errors
App\Entity\DatabaseActivityLogger No errors.
App\Entity\User
  • The field App\Entity\User#profilexperiences is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Profilexperiences#user does not contain the required 'inversedBy="profilexperiences"' attribute.
App\Entity\Settingsite No errors.
App\Entity\Mediapages No errors.
App\Entity\Media No errors.
App\Entity\Ourservices No errors.
App\Entity\Menuitems No errors.
App\Entity\Actualites No errors.
App\Entity\Article No errors.
App\Entity\Galeries No errors.
App\Entity\Offresemplois
  • The field App\Entity\Offresemplois#supplimentcriterias is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Supplimentcriterias#offresemplois does not contain the required 'mappedBy="supplimentcriterias"' attribute.
  • If association App\Entity\Offresemplois#supplimentcriterias is many-to-one, then the inversed side App\Entity\Supplimentcriterias#offresemplois has to be one-to-many.
App\Entity\Offresemploistatus No errors.
App\Entity\Categorieemplois
  • The field App\Entity\Categorieemplois#postulations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Postulations#categorieemplois does not contain the required 'inversedBy="postulations"' attribute.
App\Entity\Contracttypes No errors.
App\Entity\Monthemployes No errors.
App\Entity\Menus No errors.