Symfony Profiler

SELECT
  r0_.nom_recherche AS nom_recherche_0,
  r0_.nb_resultats AS nb_resultats_1,
  r0_.pointeur AS pointeur_2
FROM
  fusacq_dbo.recherche_mots_cles_prestataire r0_
WHERE
  (
    r0_.id_service_prestataire IS NULL
    OR r0_.id_service_prestataire = ''
  )
  AND r0_.type IN (?, ?, ?)
ORDER BY
  r0_.nb_resultats DESC

SELECT r0_.nom_recherche AS nom_recherche_0, r0_.nb_resultats AS nb_resultats_1, r0_.pointeur AS pointeur_2 FROM fusacq_dbo.recherche_mots_cles_prestataire r0_ WHERE (r0_.id_service_prestataire IS NULL OR r0_.id_service_prestataire = '') AND r0_.type IN ('societe', 'secteur', 'service') ORDER BY r0_.nb_resultats DESC;

SELECT
  r0_.nom_recherche AS nom_recherche_0,
  r0_.nb_resultats AS nb_resultats_1,
  r0_.pointeur AS pointeur_2
FROM
  fusacq_dbo.recherche_mots_cles_prestataire r0_
WHERE
  (
    r0_.id_service_prestataire IS NULL
    OR r0_.id_service_prestataire = ''
  )
  AND r0_.type IN (?, ?, ?)
ORDER BY
  r0_.nb_resultats DESC

SELECT r0_.nom_recherche AS nom_recherche_0, r0_.nb_resultats AS nb_resultats_1, r0_.pointeur AS pointeur_2 FROM fusacq_dbo.recherche_mots_cles_prestataire r0_ WHERE (r0_.id_service_prestataire IS NULL OR r0_.id_service_prestataire = '') AND r0_.type IN ('societe', 'secteur', 'service') ORDER BY r0_.nb_resultats DESC;

SELECT
  DISTINCT (s0_.id_service_prestataire) AS sclr_0,
  s0_.id_localisation_prestataire AS id_localisation_prestataire_1,
  s0_.titre_service AS titre_service_2,
  s0_.nom_commercial_societe AS nom_commercial_societe_3,
  s0_.date_mise_en_ligne AS date_mise_en_ligne_4,
  s0_.resume_service AS resume_service_5,
  s0_.url_site_web AS url_site_web_6,
  s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_7,
  s0_.utiliser_artviper AS utiliser_artviper_8,
  c1_.code_postal AS code_postal_9,
  c1_.ville AS ville_10,
  c1_.nom_contact1 AS nom_contact1_11
FROM
  fusacq_dbo.services_prestataire s0_
  LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s2_ ON (
    s0_.id_secteur_new = s2_.pointe_vers
  )
  LEFT JOIN localisations_prestataire l3_ ON (
    s0_.id_localisation_prestataire = l3_.id_localisation_prestataire
  )
  LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c1_ ON (
    s0_.id_service_prestataire = c1_.id_service_prestataire
  )
WHERE
  s0_.statut LIKE 'publique%'
  AND s0_.visibilite LIKE '%prestataire%'
ORDER BY
  s0_.date_mise_en_ligne DESC,
  s0_.id_service_prestataire DESC
LIMIT
  3

SELECT DISTINCT (s0_.id_service_prestataire) AS sclr_0, s0_.id_localisation_prestataire AS id_localisation_prestataire_1, s0_.titre_service AS titre_service_2, s0_.nom_commercial_societe AS nom_commercial_societe_3, s0_.date_mise_en_ligne AS date_mise_en_ligne_4, s0_.resume_service AS resume_service_5, s0_.url_site_web AS url_site_web_6, s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_7, s0_.utiliser_artviper AS utiliser_artviper_8, c1_.code_postal AS code_postal_9, c1_.ville AS ville_10, c1_.nom_contact1 AS nom_contact1_11 FROM fusacq_dbo.services_prestataire s0_ LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s2_ ON (s0_.id_secteur_new = s2_.pointe_vers) LEFT JOIN localisations_prestataire l3_ ON (s0_.id_localisation_prestataire = l3_.id_localisation_prestataire) LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c1_ ON (s0_.id_service_prestataire = c1_.id_service_prestataire) WHERE s0_.statut LIKE 'publique%' AND s0_.visibilite LIKE '%prestataire%' ORDER BY s0_.date_mise_en_ligne DESC, s0_.id_service_prestataire DESC LIMIT 3;

SELECT
  DISTINCT (s0_.id_service_prestataire) AS sclr_0,
  s0_.id_localisation_prestataire AS id_localisation_prestataire_1,
  s0_.titre_service AS titre_service_2,
  s0_.nom_commercial_societe AS nom_commercial_societe_3,
  s0_.date_mise_en_ligne AS date_mise_en_ligne_4,
  s0_.resume_service AS resume_service_5,
  s0_.url_site_web AS url_site_web_6,
  s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_7,
  s0_.utiliser_artviper AS utiliser_artviper_8,
  c1_.code_postal AS code_postal_9,
  c1_.ville AS ville_10,
  c1_.nom_contact1 AS nom_contact1_11
FROM
  fusacq_dbo.services_prestataire s0_
  LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s2_ ON (
    s0_.id_secteur_new = s2_.pointe_vers
  )
  LEFT JOIN localisations_prestataire l3_ ON (
    s0_.id_localisation_prestataire = l3_.id_localisation_prestataire
  )
  LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c1_ ON (
    s0_.id_service_prestataire = c1_.id_service_prestataire
  )
WHERE
  s0_.statut LIKE 'publique%'
  AND s0_.visibilite LIKE '%prestataire%'
ORDER BY
  s0_.date_mise_en_ligne DESC,
  s0_.id_service_prestataire DESC
LIMIT
  3

SELECT DISTINCT (s0_.id_service_prestataire) AS sclr_0, s0_.id_localisation_prestataire AS id_localisation_prestataire_1, s0_.titre_service AS titre_service_2, s0_.nom_commercial_societe AS nom_commercial_societe_3, s0_.date_mise_en_ligne AS date_mise_en_ligne_4, s0_.resume_service AS resume_service_5, s0_.url_site_web AS url_site_web_6, s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_7, s0_.utiliser_artviper AS utiliser_artviper_8, c1_.code_postal AS code_postal_9, c1_.ville AS ville_10, c1_.nom_contact1 AS nom_contact1_11 FROM fusacq_dbo.services_prestataire s0_ LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s2_ ON (s0_.id_secteur_new = s2_.pointe_vers) LEFT JOIN localisations_prestataire l3_ ON (s0_.id_localisation_prestataire = l3_.id_localisation_prestataire) LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c1_ ON (s0_.id_service_prestataire = c1_.id_service_prestataire) WHERE s0_.statut LIKE 'publique%' AND s0_.visibilite LIKE '%prestataire%' ORDER BY s0_.date_mise_en_ligne DESC, s0_.id_service_prestataire DESC LIMIT 3;

SELECT
  s0_.id_service_prestataire AS id_service_prestataire_0
FROM
  fusacq_dbo.services_prestataire s0_
WHERE
  s0_.statut LIKE 'publique%'
  AND s0_.visibilite LIKE '%prestataire%'

SELECT s0_.id_service_prestataire AS id_service_prestataire_0 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.statut LIKE 'publique%' AND s0_.visibilite LIKE '%prestataire%';

SELECT
  s0_.id_service_prestataire AS id_service_prestataire_0
FROM
  fusacq_dbo.services_prestataire s0_
WHERE
  s0_.statut LIKE 'publique%'
  AND s0_.visibilite LIKE '%prestataire%'

SELECT s0_.id_service_prestataire AS id_service_prestataire_0 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.statut LIKE 'publique%' AND s0_.visibilite LIKE '%prestataire%';

SELECT
  DISTINCT (s0_.id_service_prestataire) AS sclr_0,
  s0_.id_localisation_prestataire AS id_localisation_prestataire_1,
  s0_.titre_service AS titre_service_2,
  s0_.nom_commercial_societe AS nom_commercial_societe_3,
  s0_.date_mise_en_ligne AS date_mise_en_ligne_4,
  s0_.resume_service AS resume_service_5,
  s0_.url_site_web AS url_site_web_6,
  s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_7,
  s0_.utiliser_artviper AS utiliser_artviper_8,
  c1_.code_postal AS code_postal_9,
  c1_.ville AS ville_10,
  c1_.nom_contact1 AS nom_contact1_11
FROM
  fusacq_dbo.services_prestataire s0_
  LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s2_ ON (
    s0_.id_secteur_new = s2_.pointe_vers
  )
  LEFT JOIN localisations_prestataire l3_ ON (
    s0_.id_localisation_prestataire = l3_.id_localisation_prestataire
  )
  LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c1_ ON (
    s0_.id_service_prestataire = c1_.id_service_prestataire
  )
WHERE
  s0_.statut LIKE 'publique%'
  AND s0_.visibilite LIKE '%prestataire%'
ORDER BY
  s0_.date_mise_en_ligne DESC,
  s0_.id_service_prestataire DESC
LIMIT
  3

SELECT DISTINCT (s0_.id_service_prestataire) AS sclr_0, s0_.id_localisation_prestataire AS id_localisation_prestataire_1, s0_.titre_service AS titre_service_2, s0_.nom_commercial_societe AS nom_commercial_societe_3, s0_.date_mise_en_ligne AS date_mise_en_ligne_4, s0_.resume_service AS resume_service_5, s0_.url_site_web AS url_site_web_6, s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_7, s0_.utiliser_artviper AS utiliser_artviper_8, c1_.code_postal AS code_postal_9, c1_.ville AS ville_10, c1_.nom_contact1 AS nom_contact1_11 FROM fusacq_dbo.services_prestataire s0_ LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s2_ ON (s0_.id_secteur_new = s2_.pointe_vers) LEFT JOIN localisations_prestataire l3_ ON (s0_.id_localisation_prestataire = l3_.id_localisation_prestataire) LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c1_ ON (s0_.id_service_prestataire = c1_.id_service_prestataire) WHERE s0_.statut LIKE 'publique%' AND s0_.visibilite LIKE '%prestataire%' ORDER BY s0_.date_mise_en_ligne DESC, s0_.id_service_prestataire DESC LIMIT 3;

SELECT
  DISTINCT (s0_.id_service_prestataire) AS sclr_0,
  s0_.id_localisation_prestataire AS id_localisation_prestataire_1,
  s0_.titre_service AS titre_service_2,
  s0_.nom_commercial_societe AS nom_commercial_societe_3,
  s0_.date_mise_en_ligne AS date_mise_en_ligne_4,
  s0_.resume_service AS resume_service_5,
  s0_.url_site_web AS url_site_web_6,
  s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_7,
  s0_.utiliser_artviper AS utiliser_artviper_8,
  c1_.code_postal AS code_postal_9,
  c1_.ville AS ville_10,
  c1_.nom_contact1 AS nom_contact1_11
FROM
  fusacq_dbo.services_prestataire s0_
  LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s2_ ON (
    s0_.id_secteur_new = s2_.pointe_vers
  )
  LEFT JOIN localisations_prestataire l3_ ON (
    s0_.id_localisation_prestataire = l3_.id_localisation_prestataire
  )
  LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c1_ ON (
    s0_.id_service_prestataire = c1_.id_service_prestataire
  )
WHERE
  s0_.statut LIKE 'publique%'
  AND s0_.visibilite LIKE '%prestataire%'
ORDER BY
  s0_.date_mise_en_ligne DESC,
  s0_.id_service_prestataire DESC
LIMIT
  3

SELECT DISTINCT (s0_.id_service_prestataire) AS sclr_0, s0_.id_localisation_prestataire AS id_localisation_prestataire_1, s0_.titre_service AS titre_service_2, s0_.nom_commercial_societe AS nom_commercial_societe_3, s0_.date_mise_en_ligne AS date_mise_en_ligne_4, s0_.resume_service AS resume_service_5, s0_.url_site_web AS url_site_web_6, s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_7, s0_.utiliser_artviper AS utiliser_artviper_8, c1_.code_postal AS code_postal_9, c1_.ville AS ville_10, c1_.nom_contact1 AS nom_contact1_11 FROM fusacq_dbo.services_prestataire s0_ LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s2_ ON (s0_.id_secteur_new = s2_.pointe_vers) LEFT JOIN localisations_prestataire l3_ ON (s0_.id_localisation_prestataire = l3_.id_localisation_prestataire) LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c1_ ON (s0_.id_service_prestataire = c1_.id_service_prestataire) WHERE s0_.statut LIKE 'publique%' AND s0_.visibilite LIKE '%prestataire%' ORDER BY s0_.date_mise_en_ligne DESC, s0_.id_service_prestataire DESC LIMIT 3;

SELECT
  s0_.id_service_prestataire AS id_service_prestataire_0
FROM
  fusacq_dbo.services_prestataire s0_
WHERE
  s0_.statut LIKE 'publique%'
  AND s0_.visibilite LIKE '%prestataire%'

SELECT s0_.id_service_prestataire AS id_service_prestataire_0 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.statut LIKE 'publique%' AND s0_.visibilite LIKE '%prestataire%';

SELECT
  s0_.id_service_prestataire AS id_service_prestataire_0
FROM
  fusacq_dbo.services_prestataire s0_
WHERE
  s0_.statut LIKE 'publique%'
  AND s0_.visibilite LIKE '%prestataire%'

SELECT s0_.id_service_prestataire AS id_service_prestataire_0 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.statut LIKE 'publique%' AND s0_.visibilite LIKE '%prestataire%';