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 = 6 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 = 5 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
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.postal_code AS postal_code_2,
  c0_.country AS country_3,
  c0_.state AS state_4,
  c0_.visible AS visible_5
FROM
  cities c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.postal_code AS postal_code_2, c0_.country AS country_3, c0_.state AS state_4, c0_.visible AS visible_5 FROM cities c0_;

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 = 24 AND m0_.modulename = 'WIDGET';

"COMMIT"

"COMMIT";

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;

SELECT
  d0_.id AS id_0,
  d0_.orderwidget AS orderwidget_1,
  d0_.position AS position_2,
  d1_.id AS id_3,
  d1_.pagetitle AS pagetitle_4,
  d1_.description AS description_5,
  d1_.faq AS faq_6,
  d1_.txtbtnsend AS txtbtnsend_7,
  d1_.emaildest AS emaildest_8,
  d1_.urldest AS urldest_9,
  d1_.ceotitle AS ceotitle_10,
  d1_.ceodescription AS ceodescription_11,
  d1_.ceokeywords AS ceokeywords_12,
  d1_.ceoauhor AS ceoauhor_13,
  d1_.nbrvisite AS nbrvisite_14,
  w2_.id AS id_15,
  w2_.title AS title_16,
  w2_.url AS url_17,
  w2_.menuitemid AS menuitemid_18,
  w2_.objectid AS objectid_19,
  w2_.linktype AS linktype_20,
  w2_.addcontactform AS addcontactform_21,
  w2_.showtitle AS showtitle_22,
  w2_.addlink AS addlink_23,
  w2_.linkdestination AS linkdestination_24,
  w2_.description AS description_25,
  w2_.ispublic AS ispublic_26,
  w2_.nbrview AS nbrview_27
FROM
  devispageconfigwidgets d0_
  INNER JOIN devispageconfig d1_ ON d0_.devispageconfig_id = d1_.id
  INNER JOIN widget w2_ ON d0_.widget_id = w2_.id
WHERE
  d1_.id = ?
  AND d0_.position = ?
  AND w2_.ispublic = ?
ORDER BY
  d0_.orderwidget ASC

SELECT d0_.id AS id_0, d0_.orderwidget AS orderwidget_1, d0_.position AS position_2, d1_.id AS id_3, d1_.pagetitle AS pagetitle_4, d1_.description AS description_5, d1_.faq AS faq_6, d1_.txtbtnsend AS txtbtnsend_7, d1_.emaildest AS emaildest_8, d1_.urldest AS urldest_9, d1_.ceotitle AS ceotitle_10, d1_.ceodescription AS ceodescription_11, d1_.ceokeywords AS ceokeywords_12, d1_.ceoauhor AS ceoauhor_13, d1_.nbrvisite AS nbrvisite_14, w2_.id AS id_15, w2_.title AS title_16, w2_.url AS url_17, w2_.menuitemid AS menuitemid_18, w2_.objectid AS objectid_19, w2_.linktype AS linktype_20, w2_.addcontactform AS addcontactform_21, w2_.showtitle AS showtitle_22, w2_.addlink AS addlink_23, w2_.linkdestination AS linkdestination_24, w2_.description AS description_25, w2_.ispublic AS ispublic_26, w2_.nbrview AS nbrview_27 FROM devispageconfigwidgets d0_ INNER JOIN devispageconfig d1_ ON d0_.devispageconfig_id = d1_.id INNER JOIN widget w2_ ON d0_.widget_id = w2_.id WHERE d1_.id = 1 AND d0_.position = 'left' AND w2_.ispublic = 1 ORDER BY d0_.orderwidget ASC;

SELECT
  t0.id AS id_1,
  t0.pagetitle AS pagetitle_2,
  t0.description AS description_3,
  t0.faq AS faq_4,
  t0.txtbtnsend AS txtbtnsend_5,
  t0.emaildest AS emaildest_6,
  t0.urldest AS urldest_7,
  t0.ceotitle AS ceotitle_8,
  t0.ceodescription AS ceodescription_9,
  t0.ceokeywords AS ceokeywords_10,
  t0.ceoauhor AS ceoauhor_11,
  t0.nbrvisite AS nbrvisite_12
FROM
  devispageconfig t0
LIMIT
  1

SELECT t0.id AS id_1, t0.pagetitle AS pagetitle_2, t0.description AS description_3, t0.faq AS faq_4, t0.txtbtnsend AS txtbtnsend_5, t0.emaildest AS emaildest_6, t0.urldest AS urldest_7, t0.ceotitle AS ceotitle_8, t0.ceodescription AS ceodescription_9, t0.ceokeywords AS ceokeywords_10, t0.ceoauhor AS ceoauhor_11, t0.nbrvisite AS nbrvisite_12 FROM devispageconfig t0 LIMIT 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_

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_;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.menuitemid AS menuitemid_4,
  t0.objectid AS objectid_5,
  t0.linktype AS linktype_6,
  t0.addcontactform AS addcontactform_7,
  t0.showtitle AS showtitle_8,
  t0.addlink AS addlink_9,
  t0.linkdestination AS linkdestination_10,
  t0.description AS description_11,
  t0.ispublic AS ispublic_12,
  t0.nbrview AS nbrview_13,
  t0.widget_category_id AS widget_category_id_14
FROM
  widget t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.menuitemid AS menuitemid_4, t0.objectid AS objectid_5, t0.linktype AS linktype_6, t0.addcontactform AS addcontactform_7, t0.showtitle AS showtitle_8, t0.addlink AS addlink_9, t0.linkdestination AS linkdestination_10, t0.description AS description_11, t0.ispublic AS ispublic_12, t0.nbrview AS nbrview_13, t0.widget_category_id AS widget_category_id_14 FROM widget t0 WHERE t0.id = 24 LIMIT 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

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;

SELECT
  l0_.id AS id_0,
  l0_.title AS title_1,
  l0_.maintextbanner AS maintextbanner_2,
  l0_.subtextbanner AS subtextbanner_3,
  l0_.slogan AS slogan_4,
  l0_.description AS description_5,
  l0_.textsendbutton AS textsendbutton_6,
  l0_.ispublic AS ispublic_7,
  l0_.islandpage AS islandpage_8,
  l0_.isseo AS isseo_9,
  l0_.urldest AS urldest_10,
  l0_.nbrvisite AS nbrvisite_11,
  l0_.slug AS slug_12,
  l0_.model AS model_13,
  l0_.created AS created_14,
  l0_.updated AS updated_15,
  l0_.ceotitle AS ceotitle_16,
  l0_.ceodescription AS ceodescription_17,
  l0_.ceokeywords AS ceokeywords_18,
  l0_.ceoauhor AS ceoauhor_19
FROM
  landpages l0_

SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.maintextbanner AS maintextbanner_2, l0_.subtextbanner AS subtextbanner_3, l0_.slogan AS slogan_4, l0_.description AS description_5, l0_.textsendbutton AS textsendbutton_6, l0_.ispublic AS ispublic_7, l0_.islandpage AS islandpage_8, l0_.isseo AS isseo_9, l0_.urldest AS urldest_10, l0_.nbrvisite AS nbrvisite_11, l0_.slug AS slug_12, l0_.model AS model_13, l0_.created AS created_14, l0_.updated AS updated_15, l0_.ceotitle AS ceotitle_16, l0_.ceodescription AS ceodescription_17, l0_.ceokeywords AS ceokeywords_18, l0_.ceoauhor AS ceoauhor_19 FROM landpages l0_;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.libeller AS libeller_3,
  t0.description AS description_4,
  t0.picture AS picture_5,
  t0.thumb AS thumb_6,
  t0.ispublic AS ispublic_7,
  t0.displayinhomepage AS displayinhomepage_8,
  t0.displayinglobalservicepage AS displayinglobalservicepage_9,
  t0.openinotherwindow AS openinotherwindow_10,
  t0.url AS url_11,
  t0.orderservice AS orderservice_12,
  t0.nbrvisite AS nbrvisite_13,
  t0.linktype AS linktype_14,
  t0.menuitemid AS menuitemid_15,
  t0.landpageid AS landpageid_16,
  t0.created AS created_17,
  t0.updated AS updated_18
FROM
  ourservices t0
WHERE
  t0.ispublic = ?
  AND t0.displayinglobalservicepage = ?
ORDER BY
  t0.orderservice ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.libeller AS libeller_3, t0.description AS description_4, t0.picture AS picture_5, t0.thumb AS thumb_6, t0.ispublic AS ispublic_7, t0.displayinhomepage AS displayinhomepage_8, t0.displayinglobalservicepage AS displayinglobalservicepage_9, t0.openinotherwindow AS openinotherwindow_10, t0.url AS url_11, t0.orderservice AS orderservice_12, t0.nbrvisite AS nbrvisite_13, t0.linktype AS linktype_14, t0.menuitemid AS menuitemid_15, t0.landpageid AS landpageid_16, t0.created AS created_17, t0.updated AS updated_18 FROM ourservices t0 WHERE t0.ispublic = 1 AND t0.displayinglobalservicepage = 1 ORDER BY t0.orderservice ASC;

UPDATE
  widget
SET
  nbrview = ?
WHERE
  id = ?

UPDATE widget SET nbrview = 177875 WHERE id = 24;

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;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1
FROM
  personstatuslist p0_

SELECT p0_.id AS id_0, p0_.name AS name_1 FROM personstatuslist p0_;

UPDATE
  devispageconfig
SET
  nbrvisite = ?
WHERE
  id = ?

UPDATE devispageconfig SET nbrvisite = 386067 WHERE id = 1;