Symfony Profiler

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

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 = 256 LIMIT 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 = ?
  AND m1_.id = ?
  AND m0_.ispublish = ?
  AND (
    m0_.is_accordiant IS NULL
    OR m0_.is_accordiant = 0
  )
ORDER BY
  m0_.rang ASC

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 = 76 AND m1_.id = 226 AND m0_.ispublish = 1 AND (m0_.is_accordiant IS NULL OR m0_.is_accordiant = 0) ORDER BY m0_.rang ASC;

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
FROM
  menuitems m0_
  INNER JOIN menus m1_ ON m0_.menus_id = m1_.id
WHERE
  (
    m0_.parentid = ?
    AND m0_.is_accordiant = ?
  )
  AND m0_.ispublish = ?
ORDER BY
  m0_.rang ASC

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 FROM menuitems m0_ INNER JOIN menus m1_ ON m0_.menus_id = m1_.id WHERE (m0_.parentid = 43 AND m0_.is_accordiant = 1) AND m0_.ispublish = 1 ORDER BY m0_.rang ASC;

SELECT
  t0.id AS id_1,
  t0.thumb AS thumb_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.color AS color_5,
  t0.type AS type_6,
  t0.externallink AS externallink_7,
  t0.rang AS rang_8,
  t0.parentid AS parentid_9,
  t0.is_accordiant AS is_accordiant_10,
  t0.subjectid AS subjectid_11,
  t0.ispublish AS ispublish_12,
  t0.widgetId AS widgetId_13,
  t0.menus_id AS menus_id_14
FROM
  menuitems t0
WHERE
  t0.slug = ?
  AND t0.parentid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.thumb AS thumb_2, t0.name AS name_3, t0.slug AS slug_4, t0.color AS color_5, t0.type AS type_6, t0.externallink AS externallink_7, t0.rang AS rang_8, t0.parentid AS parentid_9, t0.is_accordiant AS is_accordiant_10, t0.subjectid AS subjectid_11, t0.ispublish AS ispublish_12, t0.widgetId AS widgetId_13, t0.menus_id AS menus_id_14 FROM menuitems t0 WHERE t0.slug = 'nettoyage-ponctuel' AND t0.parentid = 0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.thumb AS thumb_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.color AS color_5,
  t0.type AS type_6,
  t0.externallink AS externallink_7,
  t0.rang AS rang_8,
  t0.parentid AS parentid_9,
  t0.is_accordiant AS is_accordiant_10,
  t0.subjectid AS subjectid_11,
  t0.ispublish AS ispublish_12,
  t0.widgetId AS widgetId_13,
  t0.menus_id AS menus_id_14
FROM
  menuitems t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.thumb AS thumb_2, t0.name AS name_3, t0.slug AS slug_4, t0.color AS color_5, t0.type AS type_6, t0.externallink AS externallink_7, t0.rang AS rang_8, t0.parentid AS parentid_9, t0.is_accordiant AS is_accordiant_10, t0.subjectid AS subjectid_11, t0.ispublish AS ispublish_12, t0.widgetId AS widgetId_13, t0.menus_id AS menus_id_14 FROM menuitems t0 WHERE t0.id = 43 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.author AS author_3,
  t0.seotitle AS seotitle_4,
  t0.seodescription AS seodescription_5,
  t0.canonical AS canonical_6,
  t0.seokeywords AS seokeywords_7,
  t0.slug AS slug_8,
  t0.contenu AS contenu_9,
  t0.is_public AS is_public_10,
  t0.nbrvisite AS nbrvisite_11,
  t0.created AS created_12,
  t0.updated AS updated_13,
  t0.imagealaune AS imagealaune_14,
  t0.categoriespages_id AS categoriespages_id_15
FROM
  pages t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.author AS author_3, t0.seotitle AS seotitle_4, t0.seodescription AS seodescription_5, t0.canonical AS canonical_6, t0.seokeywords AS seokeywords_7, t0.slug AS slug_8, t0.contenu AS contenu_9, t0.is_public AS is_public_10, t0.nbrvisite AS nbrvisite_11, t0.created AS created_12, t0.updated AS updated_13, t0.imagealaune AS imagealaune_14, t0.categoriespages_id AS categoriespages_id_15 FROM pages t0 WHERE t0.id = 107 LIMIT 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

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 = 'MAIN' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.orderwidget AS orderwidget_1,
  p0_.position AS position_2,
  p1_.id AS id_3,
  p1_.title AS title_4,
  p1_.author AS author_5,
  p1_.seotitle AS seotitle_6,
  p1_.seodescription AS seodescription_7,
  p1_.canonical AS canonical_8,
  p1_.seokeywords AS seokeywords_9,
  p1_.slug AS slug_10,
  p1_.contenu AS contenu_11,
  p1_.is_public AS is_public_12,
  p1_.nbrvisite AS nbrvisite_13,
  p1_.created AS created_14,
  p1_.updated AS updated_15,
  p1_.imagealaune AS imagealaune_16,
  w2_.id AS id_17,
  w2_.title AS title_18,
  w2_.url AS url_19,
  w2_.menuitemid AS menuitemid_20,
  w2_.objectid AS objectid_21,
  w2_.linktype AS linktype_22,
  w2_.addcontactform AS addcontactform_23,
  w2_.showtitle AS showtitle_24,
  w2_.addlink AS addlink_25,
  w2_.linkdestination AS linkdestination_26,
  w2_.description AS description_27,
  w2_.ispublic AS ispublic_28,
  w2_.nbrview AS nbrview_29
FROM
  pagewidgets p0_
  INNER JOIN pages p1_ ON p0_.pages_id = p1_.id
  INNER JOIN widget w2_ ON p0_.widget_id = w2_.id
WHERE
  p1_.id = ?
  AND p0_.position = ?
  AND w2_.ispublic = ?
ORDER BY
  p0_.orderwidget ASC

SELECT p0_.id AS id_0, p0_.orderwidget AS orderwidget_1, p0_.position AS position_2, p1_.id AS id_3, p1_.title AS title_4, p1_.author AS author_5, p1_.seotitle AS seotitle_6, p1_.seodescription AS seodescription_7, p1_.canonical AS canonical_8, p1_.seokeywords AS seokeywords_9, p1_.slug AS slug_10, p1_.contenu AS contenu_11, p1_.is_public AS is_public_12, p1_.nbrvisite AS nbrvisite_13, p1_.created AS created_14, p1_.updated AS updated_15, p1_.imagealaune AS imagealaune_16, w2_.id AS id_17, w2_.title AS title_18, w2_.url AS url_19, w2_.menuitemid AS menuitemid_20, w2_.objectid AS objectid_21, w2_.linktype AS linktype_22, w2_.addcontactform AS addcontactform_23, w2_.showtitle AS showtitle_24, w2_.addlink AS addlink_25, w2_.linkdestination AS linkdestination_26, w2_.description AS description_27, w2_.ispublic AS ispublic_28, w2_.nbrview AS nbrview_29 FROM pagewidgets p0_ INNER JOIN pages p1_ ON p0_.pages_id = p1_.id INNER JOIN widget w2_ ON p0_.widget_id = w2_.id WHERE p1_.id = 366 AND p0_.position = 'left' AND w2_.ispublic = 1 ORDER BY p0_.orderwidget ASC;

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
FROM
  menuitems m0_
  INNER JOIN menus m1_ ON m0_.menus_id = m1_.id
WHERE
  m0_.parentid = ?
  AND m0_.ispublish = ?
ORDER BY
  m0_.rang ASC

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 FROM menuitems m0_ INNER JOIN menus m1_ ON m0_.menus_id = m1_.id WHERE m0_.parentid = 255 AND m0_.ispublish = 1 ORDER BY m0_.rang ASC;

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 = ?

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 = 366 AND m0_.modulename = 'PAGES';

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

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 = 0) AND m1_.id = 226 AND m0_.ispublish = 1 AND (m0_.is_accordiant IS NULL OR m0_.is_accordiant = 0) ORDER BY m0_.rang ASC;

"COMMIT"

"COMMIT";

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

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 ('globalparams') ORDER BY s0_.ordre ASC;

UPDATE
  pages
SET
  nbrvisite = ?
WHERE
  id = ?

UPDATE pages SET nbrvisite = 2730 WHERE id = 366;

"START TRANSACTION"

"START TRANSACTION";