Symfony Profiler

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.image_name AS image_name_3,
  t0.image_url AS image_url_4,
  t0.chapo AS chapo_5,
  t0.url AS url_6,
  t0.content AS content_7,
  t0.nombre_visite AS nombre_visite_8,
  t0.avis_positif AS avis_positif_9,
  t0.avis_negatif AS avis_negatif_10,
  t0.date_update AS date_update_11,
  t0.alias_url AS alias_url_12,
  t0.order_service AS order_service_13,
  t0.view_count AS view_count_14,
  t0.statut_id AS statut_id_15
FROM
  service t0
WHERE
  t0.alias_url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image_name AS image_name_3, t0.image_url AS image_url_4, t0.chapo AS chapo_5, t0.url AS url_6, t0.content AS content_7, t0.nombre_visite AS nombre_visite_8, t0.avis_positif AS avis_positif_9, t0.avis_negatif AS avis_negatif_10, t0.date_update AS date_update_11, t0.alias_url AS alias_url_12, t0.order_service AS order_service_13, t0.view_count AS view_count_14, t0.statut_id AS statut_id_15 FROM service t0 WHERE t0.alias_url = 'fonds-de-solidarite-pour-le-logement-fsl-espace-partenaires' LIMIT 1;

UPDATE
  service
SET
  view_count = ?
WHERE
  id = ?

UPDATE service SET view_count = 34 WHERE id = 509;

"COMMIT"

"COMMIT";

SELECT
  s0_.id AS id_0,
  s0_.titre AS titre_1,
  s0_.image_name AS image_name_2,
  s0_.image_url AS image_url_3,
  s0_.chapo AS chapo_4,
  s0_.url AS url_5,
  s0_.content AS content_6,
  s0_.nombre_visite AS nombre_visite_7,
  s0_.avis_positif AS avis_positif_8,
  s0_.avis_negatif AS avis_negatif_9,
  s0_.date_update AS date_update_10,
  s0_.alias_url AS alias_url_11,
  s0_.order_service AS order_service_12,
  s0_.view_count AS view_count_13,
  s0_.statut_id AS statut_id_14
FROM
  service s0_
WHERE
  s0_.id = ?

SELECT s0_.id AS id_0, s0_.titre AS titre_1, s0_.image_name AS image_name_2, s0_.image_url AS image_url_3, s0_.chapo AS chapo_4, s0_.url AS url_5, s0_.content AS content_6, s0_.nombre_visite AS nombre_visite_7, s0_.avis_positif AS avis_positif_8, s0_.avis_negatif AS avis_negatif_9, s0_.date_update AS date_update_10, s0_.alias_url AS alias_url_11, s0_.order_service AS order_service_12, s0_.view_count AS view_count_13, s0_.statut_id AS statut_id_14 FROM service s0_ WHERE s0_.id = 53;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.alias_url AS alias_url_3,
  t0.grandprofil_id AS grandprofil_id_4
FROM
  service_sous_profil t0
  INNER JOIN service_service_sous_profil ON t0.id = service_service_sous_profil.service_sous_profil_id
WHERE
  service_service_sous_profil.service_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.alias_url AS alias_url_3, t0.grandprofil_id AS grandprofil_id_4 FROM service_sous_profil t0 INNER JOIN service_service_sous_profil ON t0.id = service_service_sous_profil.service_sous_profil_id WHERE service_service_sous_profil.service_id = 509;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.active AS active_3,
  t0.couleur AS couleur_4,
  t0.contenu AS contenu_5,
  t0.visible_nordinfo AS visible_nordinfo_6,
  t0.visible_lenord AS visible_lenord_7,
  t0.visible_services AS visible_services_8,
  t0.visible_section_politiques AS visible_section_politiques_9,
  t0.visible_section_institution AS visible_section_institution_10,
  t0.visible_section_services AS visible_section_services_11,
  t0.visible_accueil_lenord AS visible_accueil_lenord_12,
  t0.visible_accueil_services AS visible_accueil_services_13,
  t0.visible_espace_documentaire AS visible_espace_documentaire_14,
  t0.visible_pages_legales_lenord AS visible_pages_legales_lenord_15,
  t0.visible_pages_legales_services AS visible_pages_legales_services_16,
  t0.visible_pages_legales_nordinfo AS visible_pages_legales_nordinfo_17,
  t0.visible_glossaire_lenord AS visible_glossaire_lenord_18,
  t0.visible_glossaire_services AS visible_glossaire_services_19,
  t0.visible_mesinfos AS visible_mesinfos_20,
  t0.visible_a_la_une AS visible_a_la_une_21,
  t0.visible_agenda AS visible_agenda_22,
  t0.visible_videos AS visible_videos_23,
  t0.visible_nordinfo_ledepartement AS visible_nordinfo_ledepartement_24,
  t0.visible_cartographie AS visible_cartographie_25,
  t0.color_id AS color_id_26
FROM
  epingle t0
WHERE
  t0.active = ?
  AND t0.visible_services = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.active AS active_3, t0.couleur AS couleur_4, t0.contenu AS contenu_5, t0.visible_nordinfo AS visible_nordinfo_6, t0.visible_lenord AS visible_lenord_7, t0.visible_services AS visible_services_8, t0.visible_section_politiques AS visible_section_politiques_9, t0.visible_section_institution AS visible_section_institution_10, t0.visible_section_services AS visible_section_services_11, t0.visible_accueil_lenord AS visible_accueil_lenord_12, t0.visible_accueil_services AS visible_accueil_services_13, t0.visible_espace_documentaire AS visible_espace_documentaire_14, t0.visible_pages_legales_lenord AS visible_pages_legales_lenord_15, t0.visible_pages_legales_services AS visible_pages_legales_services_16, t0.visible_pages_legales_nordinfo AS visible_pages_legales_nordinfo_17, t0.visible_glossaire_lenord AS visible_glossaire_lenord_18, t0.visible_glossaire_services AS visible_glossaire_services_19, t0.visible_mesinfos AS visible_mesinfos_20, t0.visible_a_la_une AS visible_a_la_une_21, t0.visible_agenda AS visible_agenda_22, t0.visible_videos AS visible_videos_23, t0.visible_nordinfo_ledepartement AS visible_nordinfo_ledepartement_24, t0.visible_cartographie AS visible_cartographie_25, t0.color_id AS color_id_26 FROM epingle t0 WHERE t0.active = 1 AND t0.visible_services = 1;

SELECT
  t0.id AS id_1,
  t0.adresse AS adresse_2,
  t0.lien_acceo AS lien_acceo_3,
  t0.telephone AS telephone_4,
  t0.telephone_url AS telephone_url_5,
  t0.reseaux_sociaux AS reseaux_sociaux_6
FROM
  footer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.adresse AS adresse_2, t0.lien_acceo AS lien_acceo_3, t0.telephone AS telephone_4, t0.telephone_url AS telephone_url_5, t0.reseaux_sociaux AS reseaux_sociaux_6 FROM footer t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.active AS active_3,
  t0.couleur AS couleur_4,
  t0.contenu AS contenu_5,
  t0.visible_nordinfo AS visible_nordinfo_6,
  t0.visible_lenord AS visible_lenord_7,
  t0.visible_services AS visible_services_8,
  t0.visible_section_politiques AS visible_section_politiques_9,
  t0.visible_section_institution AS visible_section_institution_10,
  t0.visible_section_services AS visible_section_services_11,
  t0.visible_accueil_lenord AS visible_accueil_lenord_12,
  t0.visible_accueil_services AS visible_accueil_services_13,
  t0.visible_espace_documentaire AS visible_espace_documentaire_14,
  t0.visible_pages_legales_lenord AS visible_pages_legales_lenord_15,
  t0.visible_pages_legales_services AS visible_pages_legales_services_16,
  t0.visible_pages_legales_nordinfo AS visible_pages_legales_nordinfo_17,
  t0.visible_glossaire_lenord AS visible_glossaire_lenord_18,
  t0.visible_glossaire_services AS visible_glossaire_services_19,
  t0.visible_mesinfos AS visible_mesinfos_20,
  t0.visible_a_la_une AS visible_a_la_une_21,
  t0.visible_agenda AS visible_agenda_22,
  t0.visible_videos AS visible_videos_23,
  t0.visible_nordinfo_ledepartement AS visible_nordinfo_ledepartement_24,
  t0.visible_cartographie AS visible_cartographie_25,
  t0.color_id AS color_id_26
FROM
  epingle t0
WHERE
  t0.active = ?
  AND t0.visible_section_services = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.active AS active_3, t0.couleur AS couleur_4, t0.contenu AS contenu_5, t0.visible_nordinfo AS visible_nordinfo_6, t0.visible_lenord AS visible_lenord_7, t0.visible_services AS visible_services_8, t0.visible_section_politiques AS visible_section_politiques_9, t0.visible_section_institution AS visible_section_institution_10, t0.visible_section_services AS visible_section_services_11, t0.visible_accueil_lenord AS visible_accueil_lenord_12, t0.visible_accueil_services AS visible_accueil_services_13, t0.visible_espace_documentaire AS visible_espace_documentaire_14, t0.visible_pages_legales_lenord AS visible_pages_legales_lenord_15, t0.visible_pages_legales_services AS visible_pages_legales_services_16, t0.visible_pages_legales_nordinfo AS visible_pages_legales_nordinfo_17, t0.visible_glossaire_lenord AS visible_glossaire_lenord_18, t0.visible_glossaire_services AS visible_glossaire_services_19, t0.visible_mesinfos AS visible_mesinfos_20, t0.visible_a_la_une AS visible_a_la_une_21, t0.visible_agenda AS visible_agenda_22, t0.visible_videos AS visible_videos_23, t0.visible_nordinfo_ledepartement AS visible_nordinfo_ledepartement_24, t0.visible_cartographie AS visible_cartographie_25, t0.color_id AS color_id_26 FROM epingle t0 WHERE t0.active = 1 AND t0.visible_section_services = 1;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.pictogramme_vert AS pictogramme_vert_3,
  t0.pictogramme_bleu AS pictogramme_bleu_4,
  t0.alias_url AS alias_url_5
FROM
  service_theme t0
  INNER JOIN service_service_theme ON t0.id = service_service_theme.service_theme_id
WHERE
  service_service_theme.service_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.pictogramme_vert AS pictogramme_vert_3, t0.pictogramme_bleu AS pictogramme_bleu_4, t0.alias_url AS alias_url_5 FROM service_theme t0 INNER JOIN service_service_theme ON t0.id = service_service_theme.service_theme_id WHERE service_service_theme.service_id = 509;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.active AS active_3,
  t0.couleur AS couleur_4,
  t0.contenu AS contenu_5,
  t0.visible_nordinfo AS visible_nordinfo_6,
  t0.visible_lenord AS visible_lenord_7,
  t0.visible_services AS visible_services_8,
  t0.visible_section_politiques AS visible_section_politiques_9,
  t0.visible_section_institution AS visible_section_institution_10,
  t0.visible_section_services AS visible_section_services_11,
  t0.visible_accueil_lenord AS visible_accueil_lenord_12,
  t0.visible_accueil_services AS visible_accueil_services_13,
  t0.visible_espace_documentaire AS visible_espace_documentaire_14,
  t0.visible_pages_legales_lenord AS visible_pages_legales_lenord_15,
  t0.visible_pages_legales_services AS visible_pages_legales_services_16,
  t0.visible_pages_legales_nordinfo AS visible_pages_legales_nordinfo_17,
  t0.visible_glossaire_lenord AS visible_glossaire_lenord_18,
  t0.visible_glossaire_services AS visible_glossaire_services_19,
  t0.visible_mesinfos AS visible_mesinfos_20,
  t0.visible_a_la_une AS visible_a_la_une_21,
  t0.visible_agenda AS visible_agenda_22,
  t0.visible_videos AS visible_videos_23,
  t0.visible_nordinfo_ledepartement AS visible_nordinfo_ledepartement_24,
  t0.visible_cartographie AS visible_cartographie_25,
  t0.color_id AS color_id_26
FROM
  epingle t0
  INNER JOIN epingle_service ON t0.id = epingle_service.epingle_id
WHERE
  epingle_service.service_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.active AS active_3, t0.couleur AS couleur_4, t0.contenu AS contenu_5, t0.visible_nordinfo AS visible_nordinfo_6, t0.visible_lenord AS visible_lenord_7, t0.visible_services AS visible_services_8, t0.visible_section_politiques AS visible_section_politiques_9, t0.visible_section_institution AS visible_section_institution_10, t0.visible_section_services AS visible_section_services_11, t0.visible_accueil_lenord AS visible_accueil_lenord_12, t0.visible_accueil_services AS visible_accueil_services_13, t0.visible_espace_documentaire AS visible_espace_documentaire_14, t0.visible_pages_legales_lenord AS visible_pages_legales_lenord_15, t0.visible_pages_legales_services AS visible_pages_legales_services_16, t0.visible_pages_legales_nordinfo AS visible_pages_legales_nordinfo_17, t0.visible_glossaire_lenord AS visible_glossaire_lenord_18, t0.visible_glossaire_services AS visible_glossaire_services_19, t0.visible_mesinfos AS visible_mesinfos_20, t0.visible_a_la_une AS visible_a_la_une_21, t0.visible_agenda AS visible_agenda_22, t0.visible_videos AS visible_videos_23, t0.visible_nordinfo_ledepartement AS visible_nordinfo_ledepartement_24, t0.visible_cartographie AS visible_cartographie_25, t0.color_id AS color_id_26 FROM epingle t0 INNER JOIN epingle_service ON t0.id = epingle_service.epingle_id WHERE epingle_service.service_id = 509;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.alias_url AS alias_url_3,
  t0.grandprofil_id AS grandprofil_id_4
FROM
  service_sous_profil t0

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.alias_url AS alias_url_3, t0.grandprofil_id AS grandprofil_id_4 FROM service_sous_profil t0;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.alias_url AS alias_url_3
FROM
  service_grand_profil t0
  INNER JOIN service_service_grand_profil ON t0.id = service_service_grand_profil.service_grand_profil_id
WHERE
  service_service_grand_profil.service_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.alias_url AS alias_url_3 FROM service_grand_profil t0 INNER JOIN service_service_grand_profil ON t0.id = service_service_grand_profil.service_grand_profil_id WHERE service_service_grand_profil.service_id = 509;