Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.designation AS designation_1,
  p0_.description AS description_2,
  p0_.titre_page AS titre_page_3,
  p0_.couleurtitre AS couleurtitre_4,
  p0_.parametremenu AS parametremenu_5,
  p0_.contenu AS contenu_6,
  p0_.imagemenu AS imagemenu_7,
  p0_.updated_at AS updated_at_8,
  p0_.nombre_click AS nombre_click_9,
  p0_.en_designation AS en_designation_10,
  p0_.en_description AS en_description_11,
  p0_.en_titre_page AS en_titre_page_12,
  p0_.en_contenu AS en_contenu_13
FROM
  page p0_
WHERE
  p0_.parametremenu LIKE ?

SELECT p0_.id AS id_0, p0_.designation AS designation_1, p0_.description AS description_2, p0_.titre_page AS titre_page_3, p0_.couleurtitre AS couleurtitre_4, p0_.parametremenu AS parametremenu_5, p0_.contenu AS contenu_6, p0_.imagemenu AS imagemenu_7, p0_.updated_at AS updated_at_8, p0_.nombre_click AS nombre_click_9, p0_.en_designation AS en_designation_10, p0_.en_description AS en_description_11, p0_.en_titre_page AS en_titre_page_12, p0_.en_contenu AS en_contenu_13 FROM page p0_ WHERE p0_.parametremenu LIKE '%vols_inter_iles%';

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  page
SET
  nombre_click = ?
WHERE
  id = ?

UPDATE page SET nombre_click = 1911 WHERE id = 18;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.designation AS designation_2,
  t0.en_designation AS en_designation_3
FROM
  categorie t0
  INNER JOIN page_categorie ON t0.id = page_categorie.categorie_id
WHERE
  page_categorie.page_id = ?

SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0 INNER JOIN page_categorie ON t0.id = page_categorie.categorie_id WHERE page_categorie.page_id = 18;

SELECT
  e0_.id AS id_0,
  e0_.designation AS designation_1,
  e0_.description AS description_2,
  e0_.adresse AS adresse_3,
  e0_.tel AS tel_4,
  e0_.email AS email_5,
  e0_.urlsiteweb AS urlsiteweb_6,
  e0_.is_actif AS is_actif_7,
  e0_.en_description AS en_description_8
FROM
  entiteeconomique e0_
  LEFT JOIN entiteeconomique_categorie e2_ ON e0_.id = e2_.entiteeconomique_id
  LEFT JOIN categorie c1_ ON c1_.id = e2_.categorie_id
  LEFT JOIN entiteeconomique_ile e4_ ON e0_.id = e4_.entiteeconomique_id
  LEFT JOIN ile i3_ ON i3_.id = e4_.ile_id
WHERE
  c1_.id IN (?)
  AND i3_.parametre LIKE ?
ORDER BY
  e0_.designation ASC

SELECT e0_.id AS id_0, e0_.designation AS designation_1, e0_.description AS description_2, e0_.adresse AS adresse_3, e0_.tel AS tel_4, e0_.email AS email_5, e0_.urlsiteweb AS urlsiteweb_6, e0_.is_actif AS is_actif_7, e0_.en_description AS en_description_8 FROM entiteeconomique e0_ LEFT JOIN entiteeconomique_categorie e2_ ON e0_.id = e2_.entiteeconomique_id LEFT JOIN categorie c1_ ON c1_.id = e2_.categorie_id LEFT JOIN entiteeconomique_ile e4_ ON e0_.id = e4_.entiteeconomique_id LEFT JOIN ile i3_ ON i3_.id = e4_.ile_id WHERE c1_.id IN (5) AND i3_.parametre LIKE '%ngz%' ORDER BY e0_.designation ASC;

SELECT
  e0_.id AS id_0,
  e0_.designation AS designation_1,
  e0_.description AS description_2,
  e0_.adresse AS adresse_3,
  e0_.tel AS tel_4,
  e0_.email AS email_5,
  e0_.urlsiteweb AS urlsiteweb_6,
  e0_.is_actif AS is_actif_7,
  e0_.en_description AS en_description_8
FROM
  entiteeconomique e0_
  LEFT JOIN entiteeconomique_categorie e2_ ON e0_.id = e2_.entiteeconomique_id
  LEFT JOIN categorie c1_ ON c1_.id = e2_.categorie_id
  LEFT JOIN entiteeconomique_ile e4_ ON e0_.id = e4_.entiteeconomique_id
  LEFT JOIN ile i3_ ON i3_.id = e4_.ile_id
WHERE
  c1_.id IN (?)
  AND i3_.parametre NOT LIKE ?
LIMIT
  7

SELECT e0_.id AS id_0, e0_.designation AS designation_1, e0_.description AS description_2, e0_.adresse AS adresse_3, e0_.tel AS tel_4, e0_.email AS email_5, e0_.urlsiteweb AS urlsiteweb_6, e0_.is_actif AS is_actif_7, e0_.en_description AS en_description_8 FROM entiteeconomique e0_ LEFT JOIN entiteeconomique_categorie e2_ ON e0_.id = e2_.entiteeconomique_id LEFT JOIN categorie c1_ ON c1_.id = e2_.categorie_id LEFT JOIN entiteeconomique_ile e4_ ON e0_.id = e4_.entiteeconomique_id LEFT JOIN ile i3_ ON i3_.id = e4_.ile_id WHERE c1_.id IN (5) AND i3_.parametre NOT LIKE '%ngz%' LIMIT 7;

SELECT
  t0.id AS id_1,
  t0.emailadministrateur AS emailadministrateur_2,
  t0.url_facebook AS url_facebook_3,
  t0.url_instagram AS url_instagram_4,
  t0.url_twitter AS url_twitter_5,
  t0.url_youtube AS url_youtube_6,
  t0.adressepostale AS adressepostale_7,
  t0.telephonecontact AS telephonecontact_8,
  t0.emailcontact AS emailcontact_9,
  t0.meta_description AS meta_description_10
FROM
  optionssystem t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.emailadministrateur AS emailadministrateur_2, t0.url_facebook AS url_facebook_3, t0.url_instagram AS url_instagram_4, t0.url_twitter AS url_twitter_5, t0.url_youtube AS url_youtube_6, t0.adressepostale AS adressepostale_7, t0.telephonecontact AS telephonecontact_8, t0.emailcontact AS emailcontact_9, t0.meta_description AS meta_description_10 FROM optionssystem t0 WHERE t0.id = 1;

SELECT
  p0_.id AS id_0,
  p0_.designation AS designation_1,
  p0_.description AS description_2,
  p0_.titre_page AS titre_page_3,
  p0_.couleurtitre AS couleurtitre_4,
  p0_.parametremenu AS parametremenu_5,
  p0_.contenu AS contenu_6,
  p0_.imagemenu AS imagemenu_7,
  p0_.updated_at AS updated_at_8,
  p0_.nombre_click AS nombre_click_9,
  p0_.en_designation AS en_designation_10,
  p0_.en_description AS en_description_11,
  p0_.en_titre_page AS en_titre_page_12,
  p0_.en_contenu AS en_contenu_13
FROM
  page p0_
WHERE
  p0_.parametremenu LIKE ?

SELECT p0_.id AS id_0, p0_.designation AS designation_1, p0_.description AS description_2, p0_.titre_page AS titre_page_3, p0_.couleurtitre AS couleurtitre_4, p0_.parametremenu AS parametremenu_5, p0_.contenu AS contenu_6, p0_.imagemenu AS imagemenu_7, p0_.updated_at AS updated_at_8, p0_.nombre_click AS nombre_click_9, p0_.en_designation AS en_designation_10, p0_.en_description AS en_description_11, p0_.en_titre_page AS en_titre_page_12, p0_.en_contenu AS en_contenu_13 FROM page p0_ WHERE p0_.parametremenu LIKE '%histoire%';

SELECT
  p0_.id AS id_0,
  p0_.designation AS designation_1,
  p0_.description AS description_2,
  p0_.titre_page AS titre_page_3,
  p0_.couleurtitre AS couleurtitre_4,
  p0_.parametremenu AS parametremenu_5,
  p0_.contenu AS contenu_6,
  p0_.imagemenu AS imagemenu_7,
  p0_.updated_at AS updated_at_8,
  p0_.nombre_click AS nombre_click_9,
  p0_.en_designation AS en_designation_10,
  p0_.en_description AS en_description_11,
  p0_.en_titre_page AS en_titre_page_12,
  p0_.en_contenu AS en_contenu_13
FROM
  page p0_
WHERE
  p0_.parametremenu LIKE ?

SELECT p0_.id AS id_0, p0_.designation AS designation_1, p0_.description AS description_2, p0_.titre_page AS titre_page_3, p0_.couleurtitre AS couleurtitre_4, p0_.parametremenu AS parametremenu_5, p0_.contenu AS contenu_6, p0_.imagemenu AS imagemenu_7, p0_.updated_at AS updated_at_8, p0_.nombre_click AS nombre_click_9, p0_.en_designation AS en_designation_10, p0_.en_description AS en_description_11, p0_.en_titre_page AS en_titre_page_12, p0_.en_contenu AS en_contenu_13 FROM page p0_ WHERE p0_.parametremenu LIKE '%traditions_&_culture%';

SELECT
  p0_.id AS id_0,
  p0_.designation AS designation_1,
  p0_.description AS description_2,
  p0_.titre_page AS titre_page_3,
  p0_.couleurtitre AS couleurtitre_4,
  p0_.parametremenu AS parametremenu_5,
  p0_.contenu AS contenu_6,
  p0_.imagemenu AS imagemenu_7,
  p0_.updated_at AS updated_at_8,
  p0_.nombre_click AS nombre_click_9,
  p0_.en_designation AS en_designation_10,
  p0_.en_description AS en_description_11,
  p0_.en_titre_page AS en_titre_page_12,
  p0_.en_contenu AS en_contenu_13
FROM
  page p0_
WHERE
  p0_.parametremenu LIKE ?

SELECT p0_.id AS id_0, p0_.designation AS designation_1, p0_.description AS description_2, p0_.titre_page AS titre_page_3, p0_.couleurtitre AS couleurtitre_4, p0_.parametremenu AS parametremenu_5, p0_.contenu AS contenu_6, p0_.imagemenu AS imagemenu_7, p0_.updated_at AS updated_at_8, p0_.nombre_click AS nombre_click_9, p0_.en_designation AS en_designation_10, p0_.en_description AS en_description_11, p0_.en_titre_page AS en_titre_page_12, p0_.en_contenu AS en_contenu_13 FROM page p0_ WHERE p0_.parametremenu LIKE '%geographie%';

SELECT
  p0_.id AS id_0,
  p0_.designation AS designation_1,
  p0_.description AS description_2,
  p0_.titre_page AS titre_page_3,
  p0_.couleurtitre AS couleurtitre_4,
  p0_.parametremenu AS parametremenu_5,
  p0_.contenu AS contenu_6,
  p0_.imagemenu AS imagemenu_7,
  p0_.updated_at AS updated_at_8,
  p0_.nombre_click AS nombre_click_9,
  p0_.en_designation AS en_designation_10,
  p0_.en_description AS en_description_11,
  p0_.en_titre_page AS en_titre_page_12,
  p0_.en_contenu AS en_contenu_13
FROM
  page p0_
WHERE
  p0_.parametremenu LIKE ?

SELECT p0_.id AS id_0, p0_.designation AS designation_1, p0_.description AS description_2, p0_.titre_page AS titre_page_3, p0_.couleurtitre AS couleurtitre_4, p0_.parametremenu AS parametremenu_5, p0_.contenu AS contenu_6, p0_.imagemenu AS imagemenu_7, p0_.updated_at AS updated_at_8, p0_.nombre_click AS nombre_click_9, p0_.en_designation AS en_designation_10, p0_.en_description AS en_description_11, p0_.en_titre_page AS en_titre_page_12, p0_.en_contenu AS en_contenu_13 FROM page p0_ WHERE p0_.parametremenu LIKE '%gastronomie%';

SELECT
  p0_.id AS id_0,
  p0_.designation AS designation_1,
  p0_.description AS description_2,
  p0_.titre_page AS titre_page_3,
  p0_.couleurtitre AS couleurtitre_4,
  p0_.parametremenu AS parametremenu_5,
  p0_.contenu AS contenu_6,
  p0_.imagemenu AS imagemenu_7,
  p0_.updated_at AS updated_at_8,
  p0_.nombre_click AS nombre_click_9,
  p0_.en_designation AS en_designation_10,
  p0_.en_description AS en_description_11,
  p0_.en_titre_page AS en_titre_page_12,
  p0_.en_contenu AS en_contenu_13
FROM
  page p0_
WHERE
  p0_.parametremenu LIKE ?

SELECT p0_.id AS id_0, p0_.designation AS designation_1, p0_.description AS description_2, p0_.titre_page AS titre_page_3, p0_.couleurtitre AS couleurtitre_4, p0_.parametremenu AS parametremenu_5, p0_.contenu AS contenu_6, p0_.imagemenu AS imagemenu_7, p0_.updated_at AS updated_at_8, p0_.nombre_click AS nombre_click_9, p0_.en_designation AS en_designation_10, p0_.en_description AS en_description_11, p0_.en_titre_page AS en_titre_page_12, p0_.en_contenu AS en_contenu_13 FROM page p0_ WHERE p0_.parametremenu LIKE '%faune_&_flore%';