Query Metrics
19
Database Queries
11
Different statements
490.73 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 84.39 ms |
SELECT t0_.id_translation AS id_translation_0, t0_.md5_fr AS md5_fr_1, t0_.texte_fr AS texte_fr_2, t0_.contexte_fr AS contexte_fr_3, t0_.md5_en AS md5_en_4, t0_.texte_en AS texte_en_5, t0_.contexte_en AS contexte_en_6, t0_.md5_fr_ca AS md5_fr_ca_7, t0_.texte_fr_ca AS texte_fr_ca_8, t0_.contexte_fr_ca AS contexte_fr_ca_9, t0_.md5_generique AS md5_generique_10, t0_.texte_generique AS texte_generique_11, t0_.contexte_generique AS contexte_generique_12, t0_.md5_es AS md5_es_13, t0_.texte_es AS texte_es_14, t0_.contexte_es AS contexte_es_15, t0_.md5_de AS md5_de_16, t0_.texte_de AS texte_de_17, t0_.contexte_de AS contexte_de_18, t0_.md5_nl AS md5_nl_19, t0_.texte_nl AS texte_nl_20, t0_.contexte_nl AS contexte_nl_21, t0_.md5_it AS md5_it_22, t0_.texte_it AS texte_it_23, t0_.contexte_it AS contexte_it_24, t0_.etat_en AS etat_en_25, t0_.etat_es AS etat_es_26, t0_.etat_de AS etat_de_27, t0_.etat_nl AS etat_nl_28, t0_.etat_it AS etat_it_29, t0_.etat_fr_ca AS etat_fr_ca_30, t0_.traduit_deepl AS traduit_deepl_31, t0_.created_at AS created_at_32, t0_.page_url AS page_url_33, t0_.etat_fr_ch AS etat_fr_ch_34, t0_.md5_fr_ch AS md5_fr_ch_35, t0_.texte_fr_ch AS texte_fr_ch_36, t0_.contexte_fr_ch AS contexte_fr_ch_37 FROM partage_dbo.translation t1_, partage_dbo.translation t0_ WHERE t0_.md5_generique = ?
Parameters:
[
"9931d7b0dc41636b0f4cd5e8eb644985"
]
|
| 2 | 46.37 ms |
SELECT t0_.id_translation AS id_translation_0, t0_.md5_fr AS md5_fr_1, t0_.texte_fr AS texte_fr_2, t0_.contexte_fr AS contexte_fr_3, t0_.md5_en AS md5_en_4, t0_.texte_en AS texte_en_5, t0_.contexte_en AS contexte_en_6, t0_.md5_fr_ca AS md5_fr_ca_7, t0_.texte_fr_ca AS texte_fr_ca_8, t0_.contexte_fr_ca AS contexte_fr_ca_9, t0_.md5_generique AS md5_generique_10, t0_.texte_generique AS texte_generique_11, t0_.contexte_generique AS contexte_generique_12, t0_.md5_es AS md5_es_13, t0_.texte_es AS texte_es_14, t0_.contexte_es AS contexte_es_15, t0_.md5_de AS md5_de_16, t0_.texte_de AS texte_de_17, t0_.contexte_de AS contexte_de_18, t0_.md5_nl AS md5_nl_19, t0_.texte_nl AS texte_nl_20, t0_.contexte_nl AS contexte_nl_21, t0_.md5_it AS md5_it_22, t0_.texte_it AS texte_it_23, t0_.contexte_it AS contexte_it_24, t0_.etat_en AS etat_en_25, t0_.etat_es AS etat_es_26, t0_.etat_de AS etat_de_27, t0_.etat_nl AS etat_nl_28, t0_.etat_it AS etat_it_29, t0_.etat_fr_ca AS etat_fr_ca_30, t0_.traduit_deepl AS traduit_deepl_31, t0_.created_at AS created_at_32, t0_.page_url AS page_url_33, t0_.etat_fr_ch AS etat_fr_ch_34, t0_.md5_fr_ch AS md5_fr_ch_35, t0_.texte_fr_ch AS texte_fr_ch_36, t0_.contexte_fr_ch AS contexte_fr_ch_37 FROM partage_dbo.translation t1_, partage_dbo.translation t0_ WHERE t0_.md5_generique = ?
Parameters:
[
"b1c26b4d4b2a9c7ef500d23366bf60da"
]
|
| 3 | 38.56 ms |
SELECT t0_.id_translation AS id_translation_0, t0_.md5_fr AS md5_fr_1, t0_.texte_fr AS texte_fr_2, t0_.contexte_fr AS contexte_fr_3, t0_.md5_en AS md5_en_4, t0_.texte_en AS texte_en_5, t0_.contexte_en AS contexte_en_6, t0_.md5_fr_ca AS md5_fr_ca_7, t0_.texte_fr_ca AS texte_fr_ca_8, t0_.contexte_fr_ca AS contexte_fr_ca_9, t0_.md5_generique AS md5_generique_10, t0_.texte_generique AS texte_generique_11, t0_.contexte_generique AS contexte_generique_12, t0_.md5_es AS md5_es_13, t0_.texte_es AS texte_es_14, t0_.contexte_es AS contexte_es_15, t0_.md5_de AS md5_de_16, t0_.texte_de AS texte_de_17, t0_.contexte_de AS contexte_de_18, t0_.md5_nl AS md5_nl_19, t0_.texte_nl AS texte_nl_20, t0_.contexte_nl AS contexte_nl_21, t0_.md5_it AS md5_it_22, t0_.texte_it AS texte_it_23, t0_.contexte_it AS contexte_it_24, t0_.etat_en AS etat_en_25, t0_.etat_es AS etat_es_26, t0_.etat_de AS etat_de_27, t0_.etat_nl AS etat_nl_28, t0_.etat_it AS etat_it_29, t0_.etat_fr_ca AS etat_fr_ca_30, t0_.traduit_deepl AS traduit_deepl_31, t0_.created_at AS created_at_32, t0_.page_url AS page_url_33, t0_.etat_fr_ch AS etat_fr_ch_34, t0_.md5_fr_ch AS md5_fr_ch_35, t0_.texte_fr_ch AS texte_fr_ch_36, t0_.contexte_fr_ch AS contexte_fr_ch_37 FROM partage_dbo.translation t1_, partage_dbo.translation t0_ WHERE t0_.md5_generique = ?
Parameters:
[
"dc3e586afa106ba0eb4804d9e5571a00"
]
|
| 4 | 32.47 ms |
SELECT a0_.id_pays AS id_pays_0, l1_.nom_localisation AS nom_localisation_1 FROM fusacq_dbo.annonces_vendeur a0_ LEFT JOIN fusacq_dbo.localisations l1_ ON (l1_.id_localisation = a0_.id_pays) WHERE a0_.mode_annonce = 'publique' AND a0_.id_pays <> '00' GROUP BY a0_.id_pays ORDER BY l1_.nom_localisation ASC
Parameters:
[] |
| 5 | 10.24 ms |
SELECT p0_.valeur_parametre AS valeur_parametre_0 FROM partage_dbo.parametres_divers p0_ WHERE p0_.id_type_parametre_divers = 1 AND p0_.nom_parametre = 'list_nombres_acueil_fusacq'
Parameters:
[] |
| 6 | 121.66 ms |
SELECT a0_.identifiant_profil AS identifiant_profil_0, COUNT(DISTINCT a1_.id_annonce_vendeur) AS sclr_1 FROM fusacq_dbo.annonces_vendeur a1_ LEFT JOIN fusacq_dbo.annonces_vendeur_profils_standards a0_ ON (a0_.id_annonce = a1_.id_annonce_vendeur) WHERE a1_.mode_annonce = ? AND a0_.identifiant_profil IS NOT NULL GROUP BY a0_.identifiant_profil
Parameters:
[
"publique"
]
|
| 7 | 13.45 ms |
SELECT a0_.id_pays AS id_pays_0, a0_.autres_localisations AS autres_localisations_1 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.mode_annonce = 'publique' AND ((a0_.type_raprochement = 'acquisition' OR a0_.type_raprochement IS NULL))
Parameters:
[] |
| 8 | 12.77 ms |
SELECT a0_.id_pays AS id_pays_0, a0_.autres_localisations AS autres_localisations_1 FROM fusacq_dbo.annonces_acheteur a0_ WHERE a0_.mode_annonce = 'publique' AND ((a0_.type_raprochement = 'acquisition' OR a0_.type_raprochement IS NULL))
Parameters:
[] |
| 9 | 11.25 ms |
SELECT i0_.id_localisations_recherchees AS id_localisations_recherchees_0 FROM fusacq_dbo.investisseurs_prives i0_ WHERE i0_.mode = 'publique' AND i0_.id_localisations_recherchees IS NOT NULL
Parameters:
[] |
| 10 | 11.27 ms |
SELECT i0_.id_localisations_recherchees AS id_localisations_recherchees_0 FROM fusacq_dbo.investisseurs_prives i0_ WHERE i0_.mode = 'publique' AND i0_.id_localisations_recherchees IS NOT NULL
Parameters:
[] |
| 11 | 24.02 ms |
SELECT l.nom_localisation ,s0_.id_service_prestataire,s0_.titre_service, s0_.src_image_si_artviper_desactive,s0_.url_site_web, s0_.date_mise_en_ligne , s0_.titre_service AS titre_service_0 FROM fusacq_dbo.recherche_mots_cles_prestataire r1_ LEFT JOIN fusacq_dbo.services_prestataire s0_ ON (s0_.id_service_prestataire = r1_.id_service_prestataire) LEFT JOIN fusacq_dbo.localisations l ON (l.id_localisation = r1_.id_localisation_prestataire) WHERE NULLIF(s0_.id_service_prestataire, '') IS NOT NULL AND r1_.type IN ('societe', 'secteur', 'service') AND (s0_.id_pays =32 OR s0_.pays =32) UNION SELECT l.nom_localisation ,s0_.id_service_prestataire,s0_.titre_service, s0_.src_image_si_artviper_desactive,s0_.url_site_web, s0_.date_mise_en_ligne , s0_.titre_service AS titre_service_0 FROM fusacq_dbo.recherche_mots_cles_prestataire r1_ LEFT JOIN fusacq_dbo.services_prestataire s0_ ON (s0_.id_service_prestataire = r1_.id_service_prestataire) LEFT JOIN fusacq_dbo.localisations l ON (l.id_localisation = r1_.id_localisation_prestataire) WHERE NULLIF(s0_.id_service_prestataire, '') IS NOT NULL AND r1_.type IN ('societe', 'secteur', 'service') AND (r1_.id_localisation_prestataire LIKE '32,%' OR r1_.id_localisation_prestataire LIKE '%,32,%' OR r1_.id_localisation_prestataire LIKE '%,32' ) UNION SELECT l.nom_localisation ,s0_.id_service_prestataire,s0_.titre_service, s0_.src_image_si_artviper_desactive,s0_.url_site_web, s0_.date_mise_en_ligne , s0_.titre_service AS titre_service_0 FROM fusacq_dbo.recherche_mots_cles_prestataire r1_ LEFT JOIN fusacq_dbo.services_prestataire s0_ ON (s0_.id_service_prestataire = r1_.id_service_prestataire) LEFT JOIN fusacq_dbo.localisations l ON (l.id_localisation = r1_.id_localisation_prestataire) WHERE NULLIF(s0_.id_service_prestataire, '') IS NOT NULL AND r1_.type IN ('societe', 'secteur', 'service') AND (s0_.id_pays =33 OR s0_.pays =33) LIMIT 5
Parameters:
[] |
| 12 | 11.88 ms |
SELECT b0_.id_actualite AS id_actualite_0, b0_.titre_actualite AS titre_actualite_1, b0_.description_actualite AS description_actualite_2, b0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_3, s1_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_4, b0_.date_mise_en_ligne AS date_mise_en_ligne_5 FROM fusacq_dbo.buzz_actualites b0_ LEFT JOIN fusacq_dbo.buzz_operations b2_ ON (b0_.id_operation = b2_.id_operation) LEFT JOIN fusacq_dbo.services_prestataire s1_ ON (b0_.id_service_principal = s1_.id_service_prestataire) WHERE SUBSTRING(b0_.id_localisation FROM 1 FOR 2) = '32' AND b0_.mode_actualite = ? AND b2_.type_operation = ? AND b0_.date_mise_en_ligne <= ? ORDER BY b0_.date_mise_en_ligne DESC LIMIT 5
Parameters:
[ "publique" "fusion_acquisition" "20260425201456" ] |
| 13 | 10.14 ms |
SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ?
Parameters:
[
258828
]
|
| 14 | 10.24 ms |
SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ?
Parameters:
[
258789
]
|
| 15 | 10.96 ms |
SELECT b0_.id_actualite AS id_actualite_0, b0_.photo_actualite AS photo_actualite_1 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_operation = ? AND b0_.id_actualite <> ? AND b0_.mode_actualite = ? AND b0_.photo_actualite IS NOT NULL AND b0_.photo_actualite <> '' AND b0_.photo_actualite <> 'NULL' ORDER BY b0_.date_mise_en_ligne DESC LIMIT 1
Parameters:
[ 43458 258789 "publique" ] |
| 16 | 10.34 ms |
SELECT s0_.image_filename AS image_filename_0 FROM fusacq_dbo.buzz_operations b1_ LEFT JOIN fusacq_dbo.secteurs_activite s0_ ON (b1_.id_secteur_activite = s0_.id_secteur_activite) WHERE b1_.id_operation = ? AND s0_.image_filename IS NOT NULL AND s0_.image_filename <> '' LIMIT 1
Parameters:
[
43458
]
|
| 17 | 10.25 ms |
SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ?
Parameters:
[
258771
]
|
| 18 | 10.26 ms |
SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ?
Parameters:
[
258737
]
|
| 19 | 10.21 ms |
SELECT b0_.photo_actualite AS photo_actualite_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = ?
Parameters:
[
258723
]
|
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\Translation | No errors. |
| App\Entity\AnnoncesVendeur | No errors. |
| App\Entity\Localisations | No errors. |
| App\Entity\ParametresDivers | No errors. |
| App\Entity\AnnoncesVendeurProfilsStandards | No errors. |
| App\Entity\AnnoncesAcheteur | No errors. |
| App\Entity\InvestisseursPrives | No errors. |
| App\Entity\AnnuaireRepreneurs | No errors. |
| App\Entity\ServicesPrestataire | No errors. |
| App\Entity\BuzzActualites | No errors. |
| App\Entity\BuzzOperations | No errors. |
| App\Entity\SecteursActivite | No errors. |