Symfony Profiler

SELECT
  t0.name AS name_1,
  t0.filename AS filename_2,
  t0.id AS id_3,
  t0.ordre AS ordre_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.categories_id AS categories_id_7
FROM
  enimages t0
WHERE
  t0.categories_id = ?

SELECT t0.name AS name_1, t0.filename AS filename_2, t0.id AS id_3, t0.ordre AS ordre_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.categories_id AS categories_id_7 FROM enimages t0 WHERE t0.categories_id = 6;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.description AS description_3,
  c0_.ordre AS ordre_4,
  c0_.menu AS menu_5,
  c0_.filename AS filename_6,
  c0_.updated_at AS updated_at_7,
  c0_.laus AS laus_8,
  a1_.name AS name_9,
  a1_.slug AS slug_10,
  a1_.extrait AS extrait_11,
  a1_.urlvideo AS urlvideo_12,
  a1_.content AS content_13,
  a1_.filename AS filename_14,
  a1_.online AS online_15,
  a1_.views AS views_16,
  a1_.circuitslies AS circuitslies_17,
  a1_.bandeaufile AS bandeaufile_18,
  a1_.featured AS featured_19,
  a1_.incontournable AS incontournable_20,
  a1_.incontournablename AS incontournablename_21,
  a1_.id AS id_22,
  a1_.ordre AS ordre_23,
  a1_.created_at AS created_at_24,
  a1_.updated_at AS updated_at_25,
  a1_.user_id AS user_id_26,
  a1_.updated_by_id AS updated_by_id_27,
  a1_.categories_id AS categories_id_28
FROM
  categoriearticles c0_
  LEFT JOIN articles a1_ ON c0_.id = a1_.categories_id
WHERE
  c0_.menu = ?
ORDER BY
  c0_.ordre ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.ordre AS ordre_4, c0_.menu AS menu_5, c0_.filename AS filename_6, c0_.updated_at AS updated_at_7, c0_.laus AS laus_8, a1_.name AS name_9, a1_.slug AS slug_10, a1_.extrait AS extrait_11, a1_.urlvideo AS urlvideo_12, a1_.content AS content_13, a1_.filename AS filename_14, a1_.online AS online_15, a1_.views AS views_16, a1_.circuitslies AS circuitslies_17, a1_.bandeaufile AS bandeaufile_18, a1_.featured AS featured_19, a1_.incontournable AS incontournable_20, a1_.incontournablename AS incontournablename_21, a1_.id AS id_22, a1_.ordre AS ordre_23, a1_.created_at AS created_at_24, a1_.updated_at AS updated_at_25, a1_.user_id AS user_id_26, a1_.updated_by_id AS updated_by_id_27, a1_.categories_id AS categories_id_28 FROM categoriearticles c0_ LEFT JOIN articles a1_ ON c0_.id = a1_.categories_id WHERE c0_.menu = 0 ORDER BY c0_.ordre ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.link AS link_3,
  t0.filename AS filename_4,
  t0.position AS position_5,
  t0.online AS online_6,
  t0.updated_at AS updated_at_7
FROM
  publicites t0
WHERE
  t0.online = ?
  AND t0.position = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.filename AS filename_4, t0.position AS position_5, t0.online AS online_6, t0.updated_at AS updated_at_7 FROM publicites t0 WHERE t0.online = 1 AND t0.position = 3 ORDER BY t0.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.link AS link_3,
  t0.description AS description_4,
  t0.filename AS filename_5,
  t0.updated_at AS updated_at_6
FROM
  titles t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.link AS link_3, t0.description AS description_4, t0.filename AS filename_5, t0.updated_at AS updated_at_6 FROM titles t0 WHERE t0.id = 1 LIMIT 1;

SELECT
  a0_.name AS name_0,
  a0_.description AS description_1,
  a0_.content AS content_2,
  a0_.filename AS filename_3,
  a0_.online AS online_4,
  a0_.featured AS featured_5,
  a0_.views AS views_6,
  a0_.published AS published_7,
  a0_.bandeaufile AS bandeaufile_8,
  a0_.id AS id_9,
  a0_.ordre AS ordre_10,
  a0_.created_at AS created_at_11,
  a0_.updated_at AS updated_at_12,
  a0_.slug AS slug_13,
  a0_.user_id AS user_id_14,
  a0_.categories_id AS categories_id_15,
  a0_.updated_by_id AS updated_by_id_16
FROM
  actualites a0_
WHERE
  a0_.online = ?
ORDER BY
  a0_.id DESC
LIMIT
  5

SELECT a0_.name AS name_0, a0_.description AS description_1, a0_.content AS content_2, a0_.filename AS filename_3, a0_.online AS online_4, a0_.featured AS featured_5, a0_.views AS views_6, a0_.published AS published_7, a0_.bandeaufile AS bandeaufile_8, a0_.id AS id_9, a0_.ordre AS ordre_10, a0_.created_at AS created_at_11, a0_.updated_at AS updated_at_12, a0_.slug AS slug_13, a0_.user_id AS user_id_14, a0_.categories_id AS categories_id_15, a0_.updated_by_id AS updated_by_id_16 FROM actualites a0_ WHERE a0_.online = 1 ORDER BY a0_.id DESC LIMIT 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.filename AS filename_5,
  t0.filenamecover AS filenamecover_6,
  t0.documents AS documents_7,
  t0.documentcover AS documentcover_8,
  t0.ordre AS ordre_9,
  t0.online AS online_10,
  t0.menu AS menu_11,
  t0.updated_at AS updated_at_12,
  t0.role AS role_13
FROM
  categorieposts t0
WHERE
  t0.menu = ?
  AND t0.online = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.filename AS filename_5, t0.filenamecover AS filenamecover_6, t0.documents AS documents_7, t0.documentcover AS documentcover_8, t0.ordre AS ordre_9, t0.online AS online_10, t0.menu AS menu_11, t0.updated_at AS updated_at_12, t0.role AS role_13 FROM categorieposts t0 WHERE t0.menu = 0 AND t0.online = 1 ORDER BY t0.ordre ASC;

SELECT
  r0_.name AS name_0,
  r0_.description AS description_1,
  r0_.filename AS filename_2,
  r0_.bandeaufile AS bandeaufile_3,
  r0_.address AS address_4,
  r0_.type AS type_5,
  r0_.contacts AS contacts_6,
  r0_.email AS email_7,
  r0_.siteweb AS siteweb_8,
  r0_.facebook AS facebook_9,
  r0_.twitter AS twitter_10,
  r0_.instagram AS instagram_11,
  r0_.ambiance AS ambiance_12,
  r0_.joursouvrables AS joursouvrables_13,
  r0_.online AS online_14,
  r0_.activated AS activated_15,
  r0_.othersspecialites AS othersspecialites_16,
  r0_.othersservices AS othersservices_17,
  r0_.longitude AS longitude_18,
  r0_.latitude AS latitude_19,
  r0_.featured AS featured_20,
  r0_.id AS id_21,
  r0_.ordre AS ordre_22,
  r0_.created_at AS created_at_23,
  r0_.updated_at AS updated_at_24,
  r0_.slug AS slug_25,
  r0_.user_id AS user_id_26,
  r0_.cities_id AS cities_id_27
FROM
  restaurants r0_
WHERE
  r0_.online = 1
  AND r0_.activated = 1
ORDER BY
  RAND() ASC
LIMIT
  1

SELECT r0_.name AS name_0, r0_.description AS description_1, r0_.filename AS filename_2, r0_.bandeaufile AS bandeaufile_3, r0_.address AS address_4, r0_.type AS type_5, r0_.contacts AS contacts_6, r0_.email AS email_7, r0_.siteweb AS siteweb_8, r0_.facebook AS facebook_9, r0_.twitter AS twitter_10, r0_.instagram AS instagram_11, r0_.ambiance AS ambiance_12, r0_.joursouvrables AS joursouvrables_13, r0_.online AS online_14, r0_.activated AS activated_15, r0_.othersspecialites AS othersspecialites_16, r0_.othersservices AS othersservices_17, r0_.longitude AS longitude_18, r0_.latitude AS latitude_19, r0_.featured AS featured_20, r0_.id AS id_21, r0_.ordre AS ordre_22, r0_.created_at AS created_at_23, r0_.updated_at AS updated_at_24, r0_.slug AS slug_25, r0_.user_id AS user_id_26, r0_.cities_id AS cities_id_27 FROM restaurants r0_ WHERE r0_.online = 1 AND r0_.activated = 1 ORDER BY RAND() ASC LIMIT 1;

SELECT
  h0_.name AS name_0,
  h0_.description AS description_1,
  h0_.filename AS filename_2,
  h0_.address AS address_3,
  h0_.standing AS standing_4,
  h0_.email AS email_5,
  h0_.contacts AS contacts_6,
  h0_.siteweb AS siteweb_7,
  h0_.facebook AS facebook_8,
  h0_.instagram AS instagram_9,
  h0_.twitter AS twitter_10,
  h0_.totalchambres AS totalchambres_11,
  h0_.online AS online_12,
  h0_.activated AS activated_13,
  h0_.longitude AS longitude_14,
  h0_.latitude AS latitude_15,
  h0_.otherscommodites AS otherscommodites_16,
  h0_.superficie AS superficie_17,
  h0_.bandeaufile AS bandeaufile_18,
  h0_.featured AS featured_19,
  h0_.id AS id_20,
  h0_.ordre AS ordre_21,
  h0_.created_at AS created_at_22,
  h0_.updated_at AS updated_at_23,
  h0_.slug AS slug_24,
  h0_.user_id AS user_id_25,
  h0_.cities_id AS cities_id_26
FROM
  hotels h0_
WHERE
  h0_.online = 1
  AND h0_.activated = 1
ORDER BY
  RAND() ASC
LIMIT
  1

SELECT h0_.name AS name_0, h0_.description AS description_1, h0_.filename AS filename_2, h0_.address AS address_3, h0_.standing AS standing_4, h0_.email AS email_5, h0_.contacts AS contacts_6, h0_.siteweb AS siteweb_7, h0_.facebook AS facebook_8, h0_.instagram AS instagram_9, h0_.twitter AS twitter_10, h0_.totalchambres AS totalchambres_11, h0_.online AS online_12, h0_.activated AS activated_13, h0_.longitude AS longitude_14, h0_.latitude AS latitude_15, h0_.otherscommodites AS otherscommodites_16, h0_.superficie AS superficie_17, h0_.bandeaufile AS bandeaufile_18, h0_.featured AS featured_19, h0_.id AS id_20, h0_.ordre AS ordre_21, h0_.created_at AS created_at_22, h0_.updated_at AS updated_at_23, h0_.slug AS slug_24, h0_.user_id AS user_id_25, h0_.cities_id AS cities_id_26 FROM hotels h0_ WHERE h0_.online = 1 AND h0_.activated = 1 ORDER BY RAND() ASC LIMIT 1;

SELECT
  p0_.name AS name_0,
  p0_.extrait AS extrait_1,
  p0_.content AS content_2,
  p0_.online AS online_3,
  p0_.views AS views_4,
  p0_.filename AS filename_5,
  p0_.bandeaufile AS bandeaufile_6,
  p0_.email AS email_7,
  p0_.telephone AS telephone_8,
  p0_.lieu AS lieu_9,
  p0_.heuredetravail AS heuredetravail_10,
  p0_.siteweb AS siteweb_11,
  p0_.facebook AS facebook_12,
  p0_.twitter AS twitter_13,
  p0_.instagram AS instagram_14,
  p0_.reserved AS reserved_15,
  p0_.longitude AS longitude_16,
  p0_.latitude AS latitude_17,
  p0_.featured AS featured_18,
  p0_.id AS id_19,
  p0_.ordre AS ordre_20,
  p0_.created_at AS created_at_21,
  p0_.updated_at AS updated_at_22,
  p0_.slug AS slug_23,
  p0_.user_id AS user_id_24,
  p0_.updated_by_id AS updated_by_id_25,
  p0_.categories_id AS categories_id_26
FROM
  posts p0_
WHERE
  p0_.online = 1
  AND p0_.featured = 1
ORDER BY
  p0_.updated_at DESC
LIMIT
  1

SELECT p0_.name AS name_0, p0_.extrait AS extrait_1, p0_.content AS content_2, p0_.online AS online_3, p0_.views AS views_4, p0_.filename AS filename_5, p0_.bandeaufile AS bandeaufile_6, p0_.email AS email_7, p0_.telephone AS telephone_8, p0_.lieu AS lieu_9, p0_.heuredetravail AS heuredetravail_10, p0_.siteweb AS siteweb_11, p0_.facebook AS facebook_12, p0_.twitter AS twitter_13, p0_.instagram AS instagram_14, p0_.reserved AS reserved_15, p0_.longitude AS longitude_16, p0_.latitude AS latitude_17, p0_.featured AS featured_18, p0_.id AS id_19, p0_.ordre AS ordre_20, p0_.created_at AS created_at_21, p0_.updated_at AS updated_at_22, p0_.slug AS slug_23, p0_.user_id AS user_id_24, p0_.updated_by_id AS updated_by_id_25, p0_.categories_id AS categories_id_26 FROM posts p0_ WHERE p0_.online = 1 AND p0_.featured = 1 ORDER BY p0_.updated_at DESC LIMIT 1;

SELECT
  a0_.name AS name_0,
  a0_.slug AS slug_1,
  a0_.extrait AS extrait_2,
  a0_.urlvideo AS urlvideo_3,
  a0_.content AS content_4,
  a0_.filename AS filename_5,
  a0_.online AS online_6,
  a0_.views AS views_7,
  a0_.circuitslies AS circuitslies_8,
  a0_.bandeaufile AS bandeaufile_9,
  a0_.featured AS featured_10,
  a0_.incontournable AS incontournable_11,
  a0_.incontournablename AS incontournablename_12,
  a0_.id AS id_13,
  a0_.ordre AS ordre_14,
  a0_.created_at AS created_at_15,
  a0_.updated_at AS updated_at_16,
  a0_.user_id AS user_id_17,
  a0_.updated_by_id AS updated_by_id_18,
  a0_.categories_id AS categories_id_19
FROM
  articles a0_
WHERE
  a0_.online = 1
  AND a0_.featured = 1
ORDER BY
  a0_.updated_at DESC
LIMIT
  1

SELECT a0_.name AS name_0, a0_.slug AS slug_1, a0_.extrait AS extrait_2, a0_.urlvideo AS urlvideo_3, a0_.content AS content_4, a0_.filename AS filename_5, a0_.online AS online_6, a0_.views AS views_7, a0_.circuitslies AS circuitslies_8, a0_.bandeaufile AS bandeaufile_9, a0_.featured AS featured_10, a0_.incontournable AS incontournable_11, a0_.incontournablename AS incontournablename_12, a0_.id AS id_13, a0_.ordre AS ordre_14, a0_.created_at AS created_at_15, a0_.updated_at AS updated_at_16, a0_.user_id AS user_id_17, a0_.updated_by_id AS updated_by_id_18, a0_.categories_id AS categories_id_19 FROM articles a0_ WHERE a0_.online = 1 AND a0_.featured = 1 ORDER BY a0_.updated_at DESC LIMIT 1;

SELECT
  a0_.name AS name_0,
  a0_.slug AS slug_1,
  a0_.extrait AS extrait_2,
  a0_.urlvideo AS urlvideo_3,
  a0_.content AS content_4,
  a0_.filename AS filename_5,
  a0_.online AS online_6,
  a0_.views AS views_7,
  a0_.circuitslies AS circuitslies_8,
  a0_.bandeaufile AS bandeaufile_9,
  a0_.featured AS featured_10,
  a0_.incontournable AS incontournable_11,
  a0_.incontournablename AS incontournablename_12,
  a0_.id AS id_13,
  a0_.ordre AS ordre_14,
  a0_.created_at AS created_at_15,
  a0_.updated_at AS updated_at_16,
  a0_.user_id AS user_id_17,
  a0_.updated_by_id AS updated_by_id_18,
  a0_.categories_id AS categories_id_19
FROM
  articles a0_
WHERE
  a0_.online = 1
  AND a0_.incontournable = 1
ORDER BY
  a0_.id DESC
LIMIT
  6

SELECT a0_.name AS name_0, a0_.slug AS slug_1, a0_.extrait AS extrait_2, a0_.urlvideo AS urlvideo_3, a0_.content AS content_4, a0_.filename AS filename_5, a0_.online AS online_6, a0_.views AS views_7, a0_.circuitslies AS circuitslies_8, a0_.bandeaufile AS bandeaufile_9, a0_.featured AS featured_10, a0_.incontournable AS incontournable_11, a0_.incontournablename AS incontournablename_12, a0_.id AS id_13, a0_.ordre AS ordre_14, a0_.created_at AS created_at_15, a0_.updated_at AS updated_at_16, a0_.user_id AS user_id_17, a0_.updated_by_id AS updated_by_id_18, a0_.categories_id AS categories_id_19 FROM articles a0_ WHERE a0_.online = 1 AND a0_.incontournable = 1 ORDER BY a0_.id DESC LIMIT 6;

SELECT
  t0.name AS name_1,
  t0.filename AS filename_2,
  t0.online AS online_3,
  t0.menu_id AS menu_id_4,
  t0.menu_name AS menu_name_5,
  t0.content AS content_6,
  t0.bandeaufile AS bandeaufile_7,
  t0.extrait AS extrait_8,
  t0.id AS id_9,
  t0.ordre AS ordre_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.slug AS slug_13
FROM
  pages t0
WHERE
  t0.online = ?
  AND t0.menu_id = ?
ORDER BY
  t0.ordre ASC

SELECT t0.name AS name_1, t0.filename AS filename_2, t0.online AS online_3, t0.menu_id AS menu_id_4, t0.menu_name AS menu_name_5, t0.content AS content_6, t0.bandeaufile AS bandeaufile_7, t0.extrait AS extrait_8, t0.id AS id_9, t0.ordre AS ordre_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.slug AS slug_13 FROM pages t0 WHERE t0.online = 1 AND t0.menu_id = 2 ORDER BY t0.ordre ASC;

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.urlbutton AS urlbutton_3,
  t0.textbutton AS textbutton_4,
  t0.filename AS filename_5,
  t0.online AS online_6,
  t0.id AS id_7,
  t0.ordre AS ordre_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  mainsliders t0
WHERE
  t0.online = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.urlbutton AS urlbutton_3, t0.textbutton AS textbutton_4, t0.filename AS filename_5, t0.online AS online_6, t0.id AS id_7, t0.ordre AS ordre_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM mainsliders t0 WHERE t0.online = 1;

SELECT
  b0_.name AS name_0,
  b0_.extrait AS extrait_1,
  b0_.content AS content_2,
  b0_.filename AS filename_3,
  b0_.views AS views_4,
  b0_.online AS online_5,
  b0_.pdffilename AS pdffilename_6,
  b0_.featured AS featured_7,
  b0_.id AS id_8,
  b0_.ordre AS ordre_9,
  b0_.created_at AS created_at_10,
  b0_.updated_at AS updated_at_11,
  b0_.slug AS slug_12,
  b0_.user_id AS user_id_13,
  b0_.updated_by_id AS updated_by_id_14
FROM
  brochures b0_
WHERE
  b0_.online = 1
ORDER BY
  b0_.updated_at DESC
LIMIT
  6

SELECT b0_.name AS name_0, b0_.extrait AS extrait_1, b0_.content AS content_2, b0_.filename AS filename_3, b0_.views AS views_4, b0_.online AS online_5, b0_.pdffilename AS pdffilename_6, b0_.featured AS featured_7, b0_.id AS id_8, b0_.ordre AS ordre_9, b0_.created_at AS created_at_10, b0_.updated_at AS updated_at_11, b0_.slug AS slug_12, b0_.user_id AS user_id_13, b0_.updated_by_id AS updated_by_id_14 FROM brochures b0_ WHERE b0_.online = 1 ORDER BY b0_.updated_at DESC LIMIT 6;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.filename AS filename_3,
  c0_.updated_at AS updated_at_4,
  c0_.content AS content_5
FROM
  categorieimages c0_
ORDER BY
  c0_.id DESC
LIMIT
  6

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.filename AS filename_3, c0_.updated_at AS updated_at_4, c0_.content AS content_5 FROM categorieimages c0_ ORDER BY c0_.id DESC LIMIT 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.filename AS filename_3,
  t0.updated_at AS updated_at_4,
  t0.enable AS enable_5
FROM
  homevideos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.filename AS filename_3, t0.updated_at AS updated_at_4, t0.enable AS enable_5 FROM homevideos t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.telephone AS telephone_4,
  t0.cellulaire AS cellulaire_5,
  t0.email AS email_6,
  t0.filename AS filename_7,
  t0.adresses AS adresses_8,
  t0.updated_at AS updated_at_9,
  t0.complements AS complements_10,
  t0.activite AS activite_11,
  t0.slogan AS slogan_12,
  t0.keywords AS keywords_13,
  t0.facebook AS facebook_14,
  t0.twitter AS twitter_15,
  t0.googleplus AS googleplus_16,
  t0.instagram AS instagram_17,
  t0.youtube AS youtube_18,
  t0.incontournable_text_fond AS incontournable_text_fond_19,
  t0.incontournable_text_title AS incontournable_text_title_20,
  t0.incontournable_text_content AS incontournable_text_content_21,
  t0.filenamepopup AS filenamepopup_22,
  t0.video_popup AS video_popup_23,
  t0.type_popup AS type_popup_24,
  t0.enable_popup AS enable_popup_25
FROM
  parametres t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.telephone AS telephone_4, t0.cellulaire AS cellulaire_5, t0.email AS email_6, t0.filename AS filename_7, t0.adresses AS adresses_8, t0.updated_at AS updated_at_9, t0.complements AS complements_10, t0.activite AS activite_11, t0.slogan AS slogan_12, t0.keywords AS keywords_13, t0.facebook AS facebook_14, t0.twitter AS twitter_15, t0.googleplus AS googleplus_16, t0.instagram AS instagram_17, t0.youtube AS youtube_18, t0.incontournable_text_fond AS incontournable_text_fond_19, t0.incontournable_text_title AS incontournable_text_title_20, t0.incontournable_text_content AS incontournable_text_content_21, t0.filenamepopup AS filenamepopup_22, t0.video_popup AS video_popup_23, t0.type_popup AS type_popup_24, t0.enable_popup AS enable_popup_25 FROM parametres t0 WHERE t0.id = 1;