Symfony Profiler

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_
WHERE
  c0_.postal_code = ?

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_ WHERE c0_.postal_code = '';

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.type AS type_2,
  p0_.order AS order_3
FROM
  permistravails p0_
WHERE
  p0_.type IN ('s', 'a')

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.type AS type_2, p0_.order AS order_3 FROM permistravails p0_ WHERE p0_.type IN ('s', 'a');

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
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.code AS code_2,
  p0_.alias AS alias_3,
  p0_.orderlist AS orderlist_4
FROM
  pays p0_

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.code AS code_2, p0_.alias AS alias_3, p0_.orderlist AS orderlist_4 FROM pays p0_;

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;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.code AS code_2,
  p0_.alias AS alias_3,
  p0_.orderlist AS orderlist_4
FROM
  pays p0_
WHERE
  p0_.alias LIKE ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.code AS code_2, p0_.alias AS alias_3, p0_.orderlist AS orderlist_4 FROM pays p0_ WHERE p0_.alias LIKE '%region%';

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1
FROM
  civilstates c0_

SELECT c0_.id AS id_0, c0_.name AS name_1 FROM civilstates c0_;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.type AS type_2,
  p0_.order AS order_3
FROM
  permistravails p0_
WHERE
  p0_.type = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.type AS type_2, p0_.order AS order_3 FROM permistravails p0_ WHERE p0_.type = 'p';

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

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

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1
FROM
  contracttypes c0_

SELECT c0_.id AS id_0, c0_.name AS name_1 FROM contracttypes c0_;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.country AS country_2,
  s0_.language AS language_3,
  s0_.visible AS visible_4
FROM
  states s0_

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.country AS country_2, s0_.language AS language_3, s0_.visible AS visible_4 FROM states s0_;

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1
FROM
  typeemplois t0_

SELECT t0_.id AS id_0, t0_.name AS name_1 FROM typeemplois t0_;

SELECT
  n0_.id AS id_0,
  n0_.name AS name_1
FROM
  notice_period n0_

SELECT n0_.id AS id_0, n0_.name AS name_1 FROM notice_period n0_;

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.parentsregions AS parentsregions_2,
  r0_.pays_id AS pays_id_3
FROM
  regions r0_

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.parentsregions AS parentsregions_2, r0_.pays_id AS pays_id_3 FROM regions r0_;