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
  COUNT(a0_.id) AS sclr_0
FROM
  article a0_
  LEFT JOIN article_blogcategories a2_ ON a0_.id = a2_.article_id
  LEFT JOIN blogcategories b1_ ON b1_.id = a2_.blogcategories_id
WHERE
  a0_.ispublic = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM article a0_ LEFT JOIN article_blogcategories a2_ ON a0_.id = a2_.article_id LEFT JOIN blogcategories b1_ ON b1_.id = a2_.blogcategories_id WHERE a0_.ispublic = 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,
  b1_.id AS id_21,
  b1_.name AS name_22,
  b1_.seotitle AS seotitle_23,
  b1_.seodescription AS seodescription_24,
  b1_.seokeywords AS seokeywords_25,
  b1_.canonical AS canonical_26,
  b1_.slug AS slug_27,
  b1_.description AS description_28,
  b1_.created AS created_29,
  b1_.updated AS updated_30
FROM
  article a0_
  LEFT JOIN article_blogcategories a2_ ON a0_.id = a2_.article_id
  LEFT JOIN blogcategories b1_ ON b1_.id = a2_.blogcategories_id
WHERE
  a0_.slug = ?

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, b1_.id AS id_21, b1_.name AS name_22, b1_.seotitle AS seotitle_23, b1_.seodescription AS seodescription_24, b1_.seokeywords AS seokeywords_25, b1_.canonical AS canonical_26, b1_.slug AS slug_27, b1_.description AS description_28, b1_.created AS created_29, b1_.updated AS updated_30 FROM article a0_ LEFT JOIN article_blogcategories a2_ ON a0_.id = a2_.article_id LEFT JOIN blogcategories b1_ ON b1_.id = a2_.blogcategories_id WHERE a0_.slug = 'des-vitres-a-laver-difficilement-atteignables-s-offrir-un-lumbago-et-un-physio';

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

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 (214, 212, 210) AND m0_.modulename = 'BLOG';

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 = 70 AND m0_.modulename = 'BLOG';

SELECT
  COUNT(a0_.id) AS sclr_0,
  b1_.name AS name_1,
  b1_.slug AS slug_2
FROM
  blogcategories b1_
  INNER JOIN article_blogcategories a2_ ON b1_.id = a2_.blogcategories_id
  INNER JOIN article a0_ ON a0_.id = a2_.article_id
WHERE
  a0_.ispublic = ?
GROUP BY
  b1_.id

SELECT COUNT(a0_.id) AS sclr_0, b1_.name AS name_1, b1_.slug AS slug_2 FROM blogcategories b1_ INNER JOIN article_blogcategories a2_ ON b1_.id = a2_.blogcategories_id INNER JOIN article a0_ ON a0_.id = a2_.article_id WHERE a0_.ispublic = 1 GROUP BY b1_.id;

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
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.excerpt AS excerpt_4,
  t0.isblogarticle AS isblogarticle_5,
  t0.content AS content_6,
  t0.created AS created_7,
  t0.datearticle AS datearticle_8,
  t0.orderartc AS orderartc_9,
  t0.nbrvisite AS nbrvisite_10,
  t0.updated AS updated_11,
  t0.author AS author_12,
  t0.ceotitle AS ceotitle_13,
  t0.ceodescription AS ceodescription_14,
  t0.canonical AS canonical_15,
  t0.seokeywords AS seokeywords_16,
  t0.imagealaune AS imagealaune_17,
  t0.imagealaunethumb AS imagealaunethumb_18,
  t0.ispublic AS ispublic_19,
  t0.isinhomepage AS isinhomepage_20,
  t0.isfuture AS isfuture_21
FROM
  article t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.excerpt AS excerpt_4, t0.isblogarticle AS isblogarticle_5, t0.content AS content_6, t0.created AS created_7, t0.datearticle AS datearticle_8, t0.orderartc AS orderartc_9, t0.nbrvisite AS nbrvisite_10, t0.updated AS updated_11, t0.author AS author_12, t0.ceotitle AS ceotitle_13, t0.ceodescription AS ceodescription_14, t0.canonical AS canonical_15, t0.seokeywords AS seokeywords_16, t0.imagealaune AS imagealaune_17, t0.imagealaunethumb AS imagealaunethumb_18, t0.ispublic AS ispublic_19, t0.isinhomepage AS isinhomepage_20, t0.isfuture AS isfuture_21 FROM article t0 WHERE t0.slug = 'des-vitres-a-laver-difficilement-atteignables-s-offrir-un-lumbago-et-un-physio' LIMIT 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

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 = 1 AND a0_.isinhomepage = 1 AND (a0_.isfuture = 0 OR a0_.isfuture IS NULL) ORDER BY a0_.datearticle DESC LIMIT 3;

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;

"COMMIT"

"COMMIT";

UPDATE
  article
SET
  nbrvisite = ?
WHERE
  id = ?

UPDATE article SET nbrvisite = 4037 WHERE id = 70;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.devis_link AS devis_link_4,
  t0.guaranteed_link AS guaranteed_link_5,
  t0.devis_text AS devis_text_6,
  t0.guaranteed_text AS guaranteed_text_7
FROM
  blog_page_signature t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.devis_link AS devis_link_4, t0.guaranteed_link AS guaranteed_link_5, t0.devis_text AS devis_text_6, t0.guaranteed_text AS guaranteed_text_7 FROM blog_page_signature t0;

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