Query Metrics
2
Database Queries
2
Different statements
28.11 ms
Query time
0
Invalid entities
Queries
| #▲ | 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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\ServicesPrestataire | No errors. |
| App\Entity\SecteursActivitePrestataireNewNew | No errors. |
| App\Entity\LocalisationsPrestataire | No errors. |
| App\Entity\CoordonneesServicePrestataire | No errors. |
| App\Entity\CertificationExpert | No errors. |
| App\Entity\TypeCertificationExpert | No errors. |