https://preprod.fusacq.com/activite-1153,conseil-en-transmission-d-entreprise_fr_

Query Metrics

2 Database Queries
2 Different statements
28.11 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 17.60 ms
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_.id_societe_prestataire AS id_societe_prestataire_3, s0_.nom_commercial_societe AS nom_commercial_societe_4, s0_.id_pays AS id_pays_5, s0_.date_mise_en_ligne AS date_mise_en_ligne_6, s0_.statut AS statut_7, s0_.resume_service AS resume_service_8, s0_.description_service AS description_service_9, s0_.url_site_web_visible AS url_site_web_visible_10, s0_.url_site_web AS url_site_web_11, s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_12, s0_.utiliser_artviper AS utiliser_artviper_13, s0_.id_secteur_new AS id_secteur_new_14, c1_.code_postal AS code_postal_15, c1_.adresse AS adresse_16, c1_.ville AS ville_17, c1_.pays AS pays_18, c1_.nom_contact1 AS nom_contact1_19, c1_.email_contact1 AS email_contact1_20, c1_.nom_contact2 AS nom_contact2_21, c1_.email_contact2 AS email_contact2_22, c1_.telephone AS telephone_23, c1_.indicatif_telephone AS indicatif_telephone_24, c1_.telephone_contact1 AS telephone_contact1_25, c1_.indicatif_telephone_contact1 AS indicatif_telephone_contact1_26, c1_.telephone_contact2 AS telephone_contact2_27, c1_.indicatif_telephone_contact2 AS indicatif_telephone_contact2_28 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_.id_service_prestataire = ? LIMIT 1
Parameters:
[
  1153
]
2 10.51 ms
SELECT c0_.id_certification_expert AS id_certification_expert_0, c0_.id_societe_prestataire AS id_societe_prestataire_1, c0_.valeur_certification AS valeur_certification_2, t1_.nom_certification AS nom_certification_3, t1_.nom_affichage_certification AS nom_affichage_certification_4, t1_.legende AS legende_5 FROM fusacq_dbo.certification_expert c0_ LEFT JOIN fusacq_dbo.type_certification_expert t1_ ON (c0_.id_type_certification = t1_.id_type_certification) WHERE c0_.id_societe_prestataire = ?
Parameters:
[
  1524
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.