Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

0.34 ms Query time

9 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.34 ms	SELECT t0.k_adherent AS k_adherent_1, t0.k_mag AS k_mag_2, t0.siret AS siret_3, t0.siren AS siren_4, t0.lib AS lib_5, t0.k_pays AS k_pays_6, t0.k_langue AS k_langue_7, t0.lat AS lat_8, t0.lon AS lon_9, t0.k_user_suivi AS k_user_suivi_10, t0.k_logiciel AS k_logiciel_11, t0.created_at AS created_at_12, t0.updated AS updated_13, t0.deleted AS deleted_14, t0.deleted_at AS deleted_at_15, t0.adh_mm AS adh_mm_16, t0.k_niveauadh AS k_niveauadh_17, t0.k_type_client AS k_type_client_18, t0.l_blacklist AS l_blacklist_19, t0.user_rs AS user_rs_20, t0.user_cpv AS user_cpv_21, t0.user_adv AS user_adv_22, t0.user_achat AS user_achat_23, t0.user_paiement AS user_paiement_24, t0.user_op AS user_op_25, t0.user_cpv_conf AS user_cpv_conf_26, t0.adh_site_web AS adh_site_web_27, t0.adh_crm AS adh_crm_28, t0.adh_mm_stat AS adh_mm_stat_29, t0.pack_opc AS pack_opc_30, t0.centrale AS centrale_31, t0.want_facturation_papier AS want_facturation_papier_32, t0.avis_gmb_active AS avis_gmb_active_33, t0.aff_avis_crm_opc AS aff_avis_crm_opc_34, t0.consent_serv_spec_info_comple AS consent_serv_spec_info_comple_35, t0.conviction_fr AS conviction_fr_36, t0.conviction_nl AS conviction_nl_37, t38.id AS id_39, t38.presentation AS presentation_40, t38.presentation_nl AS presentation_nl_41, t38.verbatim AS verbatim_42, t38.verbatim_nl AS verbatim_nl_43, t38.signature AS signature_44, t38.signature_nl AS signature_nl_45, t38.photo_equipe AS photo_equipe_46, t38.magasin AS magasin_47, t48.id AS id_49, t48.active_ia AS active_ia_50, t48.auto_publish AS auto_publish_51, t48.created_at AS created_at_52, t48.updated_at AS updated_at_53, t48.magasin AS magasin_54 FROM magasin t0 LEFT JOIN magasin_equipe t38 ON t38.magasin = t0.k_adherent LEFT JOIN crm_settings t48 ON t48.magasin = t0.k_adherent WHERE t0.k_adherent = ? Parameters: [`"C4230"`] View formatted query View runnable query Explain query SELECT t0.k_adherent AS k_adherent_1, t0.k_mag AS k_mag_2, t0.siret AS siret_3, t0.siren AS siren_4, t0.lib AS lib_5, t0.k_pays AS k_pays_6, t0.k_langue AS k_langue_7, t0.lat AS lat_8, t0.lon AS lon_9, t0.k_user_suivi AS k_user_suivi_10, t0.k_logiciel AS k_logiciel_11, t0.created_at AS created_at_12, t0.updated AS updated_13, t0.deleted AS deleted_14, t0.deleted_at AS deleted_at_15, t0.adh_mm AS adh_mm_16, t0.k_niveauadh AS k_niveauadh_17, t0.k_type_client AS k_type_client_18, t0.l_blacklist AS l_blacklist_19, t0.user_rs AS user_rs_20, t0.user_cpv AS user_cpv_21, t0.user_adv AS user_adv_22, t0.user_achat AS user_achat_23, t0.user_paiement AS user_paiement_24, t0.user_op AS user_op_25, t0.user_cpv_conf AS user_cpv_conf_26, t0.adh_site_web AS adh_site_web_27, t0.adh_crm AS adh_crm_28, t0.adh_mm_stat AS adh_mm_stat_29, t0.pack_opc AS pack_opc_30, t0.centrale AS centrale_31, t0.want_facturation_papier AS want_facturation_papier_32, t0.avis_gmb_active AS avis_gmb_active_33, t0.aff_avis_crm_opc AS aff_avis_crm_opc_34, t0.consent_serv_spec_info_comple AS consent_serv_spec_info_comple_35, t0.conviction_fr AS conviction_fr_36, t0.conviction_nl AS conviction_nl_37, t38.id AS id_39, t38.presentation AS presentation_40, t38.presentation_nl AS presentation_nl_41, t38.verbatim AS verbatim_42, t38.verbatim_nl AS verbatim_nl_43, t38.signature AS signature_44, t38.signature_nl AS signature_nl_45, t38.photo_equipe AS photo_equipe_46, t38.magasin AS magasin_47, t48.id AS id_49, t48.active_ia AS active_ia_50, t48.auto_publish AS auto_publish_51, t48.created_at AS created_at_52, t48.updated_at AS updated_at_53, t48.magasin AS magasin_54 FROM magasin t0 LEFT JOIN magasin_equipe t38 ON t38.magasin = t0.k_adherent LEFT JOIN crm_settings t48 ON t48.magasin = t0.k_adherent WHERE t0.k_adherent = ? SELECT t0.k_adherent AS k_adherent_1, t0.k_mag AS k_mag_2, t0.siret AS siret_3, t0.siren AS siren_4, t0.lib AS lib_5, t0.k_pays AS k_pays_6, t0.k_langue AS k_langue_7, t0.lat AS lat_8, t0.lon AS lon_9, t0.k_user_suivi AS k_user_suivi_10, t0.k_logiciel AS k_logiciel_11, t0.created_at AS created_at_12, t0.updated AS updated_13, t0.deleted AS deleted_14, t0.deleted_at AS deleted_at_15, t0.adh_mm AS adh_mm_16, t0.k_niveauadh AS k_niveauadh_17, t0.k_type_client AS k_type_client_18, t0.l_blacklist AS l_blacklist_19, t0.user_rs AS user_rs_20, t0.user_cpv AS user_cpv_21, t0.user_adv AS user_adv_22, t0.user_achat AS user_achat_23, t0.user_paiement AS user_paiement_24, t0.user_op AS user_op_25, t0.user_cpv_conf AS user_cpv_conf_26, t0.adh_site_web AS adh_site_web_27, t0.adh_crm AS adh_crm_28, t0.adh_mm_stat AS adh_mm_stat_29, t0.pack_opc AS pack_opc_30, t0.centrale AS centrale_31, t0.want_facturation_papier AS want_facturation_papier_32, t0.avis_gmb_active AS avis_gmb_active_33, t0.aff_avis_crm_opc AS aff_avis_crm_opc_34, t0.consent_serv_spec_info_comple AS consent_serv_spec_info_comple_35, t0.conviction_fr AS conviction_fr_36, t0.conviction_nl AS conviction_nl_37, t38.id AS id_39, t38.presentation AS presentation_40, t38.presentation_nl AS presentation_nl_41, t38.verbatim AS verbatim_42, t38.verbatim_nl AS verbatim_nl_43, t38.signature AS signature_44, t38.signature_nl AS signature_nl_45, t38.photo_equipe AS photo_equipe_46, t38.magasin AS magasin_47, t48.id AS id_49, t48.active_ia AS active_ia_50, t48.auto_publish AS auto_publish_51, t48.created_at AS created_at_52, t48.updated_at AS updated_at_53, t48.magasin AS magasin_54 FROM magasin t0 LEFT JOIN magasin_equipe t38 ON t38.magasin = t0.k_adherent LEFT JOIN crm_settings t48 ON t48.magasin = t0.k_adherent WHERE t0.k_adherent = 'C4230';

#▲

Time

Info

0.34 ms

SELECT t0.k_adherent AS k_adherent_1, t0.k_mag AS k_mag_2, t0.siret AS siret_3, t0.siren AS siren_4, t0.lib AS lib_5, t0.k_pays AS k_pays_6, t0.k_langue AS k_langue_7, t0.lat AS lat_8, t0.lon AS lon_9, t0.k_user_suivi AS k_user_suivi_10, t0.k_logiciel AS k_logiciel_11, t0.created_at AS created_at_12, t0.updated AS updated_13, t0.deleted AS deleted_14, t0.deleted_at AS deleted_at_15, t0.adh_mm AS adh_mm_16, t0.k_niveauadh AS k_niveauadh_17, t0.k_type_client AS k_type_client_18, t0.l_blacklist AS l_blacklist_19, t0.user_rs AS user_rs_20, t0.user_cpv AS user_cpv_21, t0.user_adv AS user_adv_22, t0.user_achat AS user_achat_23, t0.user_paiement AS user_paiement_24, t0.user_op AS user_op_25, t0.user_cpv_conf AS user_cpv_conf_26, t0.adh_site_web AS adh_site_web_27, t0.adh_crm AS adh_crm_28, t0.adh_mm_stat AS adh_mm_stat_29, t0.pack_opc AS pack_opc_30, t0.centrale AS centrale_31, t0.want_facturation_papier AS want_facturation_papier_32, t0.avis_gmb_active AS avis_gmb_active_33, t0.aff_avis_crm_opc AS aff_avis_crm_opc_34, t0.consent_serv_spec_info_comple AS consent_serv_spec_info_comple_35, t0.conviction_fr AS conviction_fr_36, t0.conviction_nl AS conviction_nl_37, t38.id AS id_39, t38.presentation AS presentation_40, t38.presentation_nl AS presentation_nl_41, t38.verbatim AS verbatim_42, t38.verbatim_nl AS verbatim_nl_43, t38.signature AS signature_44, t38.signature_nl AS signature_nl_45, t38.photo_equipe AS photo_equipe_46, t38.magasin AS magasin_47, t48.id AS id_49, t48.active_ia AS active_ia_50, t48.auto_publish AS auto_publish_51, t48.created_at AS created_at_52, t48.updated_at AS updated_at_53, t48.magasin AS magasin_54 FROM magasin t0 LEFT JOIN magasin_equipe t38 ON t38.magasin = t0.k_adherent LEFT JOIN crm_settings t48 ON t48.magasin = t0.k_adherent WHERE t0.k_adherent = ?

Parameters:

[
  "C4230"
]

View formatted query View runnable query Explain query

SELECT
  t0.k_adherent AS k_adherent_1,
  t0.k_mag AS k_mag_2,
  t0.siret AS siret_3,
  t0.siren AS siren_4,
  t0.lib AS lib_5,
  t0.k_pays AS k_pays_6,
  t0.k_langue AS k_langue_7,
  t0.lat AS lat_8,
  t0.lon AS lon_9,
  t0.k_user_suivi AS k_user_suivi_10,
  t0.k_logiciel AS k_logiciel_11,
  t0.created_at AS created_at_12,
  t0.updated AS updated_13,
  t0.deleted AS deleted_14,
  t0.deleted_at AS deleted_at_15,
  t0.adh_mm AS adh_mm_16,
  t0.k_niveauadh AS k_niveauadh_17,
  t0.k_type_client AS k_type_client_18,
  t0.l_blacklist AS l_blacklist_19,
  t0.user_rs AS user_rs_20,
  t0.user_cpv AS user_cpv_21,
  t0.user_adv AS user_adv_22,
  t0.user_achat AS user_achat_23,
  t0.user_paiement AS user_paiement_24,
  t0.user_op AS user_op_25,
  t0.user_cpv_conf AS user_cpv_conf_26,
  t0.adh_site_web AS adh_site_web_27,
  t0.adh_crm AS adh_crm_28,
  t0.adh_mm_stat AS adh_mm_stat_29,
  t0.pack_opc AS pack_opc_30,
  t0.centrale AS centrale_31,
  t0.want_facturation_papier AS want_facturation_papier_32,
  t0.avis_gmb_active AS avis_gmb_active_33,
  t0.aff_avis_crm_opc AS aff_avis_crm_opc_34,
  t0.consent_serv_spec_info_comple AS consent_serv_spec_info_comple_35,
  t0.conviction_fr AS conviction_fr_36,
  t0.conviction_nl AS conviction_nl_37,
  t38.id AS id_39,
  t38.presentation AS presentation_40,
  t38.presentation_nl AS presentation_nl_41,
  t38.verbatim AS verbatim_42,
  t38.verbatim_nl AS verbatim_nl_43,
  t38.signature AS signature_44,
  t38.signature_nl AS signature_nl_45,
  t38.photo_equipe AS photo_equipe_46,
  t38.magasin AS magasin_47,
  t48.id AS id_49,
  t48.active_ia AS active_ia_50,
  t48.auto_publish AS auto_publish_51,
  t48.created_at AS created_at_52,
  t48.updated_at AS updated_at_53,
  t48.magasin AS magasin_54
FROM
  magasin t0
  LEFT JOIN magasin_equipe t38 ON t38.magasin = t0.k_adherent
  LEFT JOIN crm_settings t48 ON t48.magasin = t0.k_adherent
WHERE
  t0.k_adherent = ?

SELECT t0.k_adherent AS k_adherent_1, t0.k_mag AS k_mag_2, t0.siret AS siret_3, t0.siren AS siren_4, t0.lib AS lib_5, t0.k_pays AS k_pays_6, t0.k_langue AS k_langue_7, t0.lat AS lat_8, t0.lon AS lon_9, t0.k_user_suivi AS k_user_suivi_10, t0.k_logiciel AS k_logiciel_11, t0.created_at AS created_at_12, t0.updated AS updated_13, t0.deleted AS deleted_14, t0.deleted_at AS deleted_at_15, t0.adh_mm AS adh_mm_16, t0.k_niveauadh AS k_niveauadh_17, t0.k_type_client AS k_type_client_18, t0.l_blacklist AS l_blacklist_19, t0.user_rs AS user_rs_20, t0.user_cpv AS user_cpv_21, t0.user_adv AS user_adv_22, t0.user_achat AS user_achat_23, t0.user_paiement AS user_paiement_24, t0.user_op AS user_op_25, t0.user_cpv_conf AS user_cpv_conf_26, t0.adh_site_web AS adh_site_web_27, t0.adh_crm AS adh_crm_28, t0.adh_mm_stat AS adh_mm_stat_29, t0.pack_opc AS pack_opc_30, t0.centrale AS centrale_31, t0.want_facturation_papier AS want_facturation_papier_32, t0.avis_gmb_active AS avis_gmb_active_33, t0.aff_avis_crm_opc AS aff_avis_crm_opc_34, t0.consent_serv_spec_info_comple AS consent_serv_spec_info_comple_35, t0.conviction_fr AS conviction_fr_36, t0.conviction_nl AS conviction_nl_37, t38.id AS id_39, t38.presentation AS presentation_40, t38.presentation_nl AS presentation_nl_41, t38.verbatim AS verbatim_42, t38.verbatim_nl AS verbatim_nl_43, t38.signature AS signature_44, t38.signature_nl AS signature_nl_45, t38.photo_equipe AS photo_equipe_46, t38.magasin AS magasin_47, t48.id AS id_49, t48.active_ia AS active_ia_50, t48.auto_publish AS auto_publish_51, t48.created_at AS created_at_52, t48.updated_at AS updated_at_53, t48.magasin AS magasin_54 FROM magasin t0 LEFT JOIN magasin_equipe t38 ON t38.magasin = t0.k_adherent LEFT JOIN crm_settings t48 ON t48.magasin = t0.k_adherent WHERE t0.k_adherent = 'C4230';

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\Adherent\Magasin	The association App\Entity\Adherent\Magasin#operateursRemboursement refers to the inverse side field App\Entity\Adherent\OperateursRemboursement#magasins which does not exist. The mappings App\Entity\Adherent\Magasin#magasinUrl and App\Entity\Adherent\MagasinUrl#magasin are inconsistent with each other. The mappings App\Entity\Adherent\Magasin#magasinJuridiques and App\Entity\Adherent\MagasinJuridique#magasin are inconsistent with each other. The association App\Entity\Adherent\Magasin#annonces refers to the owning side field App\Entity\Retrocession\Annonce#adherent which does not exist. The mappings App\Entity\Adherent\Magasin#magasinMarquesAlertes and App\Entity\Alertes\MagasinMarquesAlertes#k_adherent are inconsistent with each other. The field App\Entity\Adherent\Magasin#venteRechercheMagasinsAlertes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\VenteRechercheMagasins\VenteRechercheMagasinsAlertes#magasin does not contain the required 'inversedBy="venteRechercheMagasinsAlertes"' attribute. The mappings App\Entity\Adherent\Magasin#avis35ans and App\Entity\EvenementsGroupeAll\AvisEvenement#k_adh are inconsistent with each other. The association App\Entity\Adherent\Magasin#faqs refers to the owning side field App\Entity\Webfactory\Widget\Createur\Faq#adherent which does not exist. The field App\Entity\Adherent\Magasin#kpiObjectifs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Kpi\KpiObjectifs#magasin does not contain the required 'inversedBy="kpiObjectifs"' attribute.
App\Entity\Adherent\MagasinEquipe	No errors.
App\Entity\Crm\CrmSettings	No errors.
App\Entity\Adherent\MagasinCoordonnees	No errors.
App\Entity\Adherent\MagasinHoraires	No errors.
App\Entity\Adherent\MagasinHorairesExceptionnelles	No errors.
App\Entity\Adherent\MagasinConviction	No errors.
App\Entity\Adherent\Service	No errors.
App\Entity\Adherent\Specialite	No errors.
App\Entity\Adherent\Complement	No errors.
App\Entity\Adherent\OperateursRemboursement	No errors.
App\Entity\Webfactory\Widget\WidgetAbstract	No errors.
App\Entity\Webfactory\Page\PageAbstract	No errors.
App\Entity\Adherent\MagasinCollaborateurs	The association App\Entity\Adherent\MagasinCollaborateurs#pagesMagasinClassique refers to the owning side field App\Entity\Webfactory\Page\Classique\Store#equipeVerbatim which does not exist.
App\Entity\Adherent\MagasinMarques	The field App\Entity\Adherent\MagasinMarques#magasinMarquesException is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\BrandExceptionCategory#magasinMarque does not contain the required 'inversedBy="magasinMarquesException"' attribute.
App\Entity\Webfactory\Navigation	No errors.
App\Entity\Adherent\MagasinUrl	The association App\Entity\Adherent\MagasinUrl#magasin refers to the inverse side field App\Entity\Adherent\Magasin#magasinSocialMedia which does not exist.
App\Entity\Adherent\MagasinJuridique	The association App\Entity\Adherent\MagasinJuridique#magasin refers to the inverse side field App\Entity\Adherent\Magasin#presentations which does not exist.
App\Entity\Adherent\Annuaire\MagasinContact	No errors.
App\Entity\Retrocession\Annonce	The mappings App\Entity\Retrocession\Annonce#magasin and App\Entity\Adherent\Magasin#annonces are inconsistent with each other.
App\Entity\Adherent\MagasinAlert	No errors.
App\Entity\Alertes\MagasinMarquesAlertes	The association App\Entity\Alertes\MagasinMarquesAlertes#k_adherent refers to the inverse side field App\Entity\Adherent\Magasin#MagasinMarquesAlertes which does not exist.
App\Entity\VenteRechercheMagasins\VenteRechercheMagasinsAlertes	The association App\Entity\VenteRechercheMagasins\VenteRechercheMagasinsAlertes#departements refers to the inverse side field App\Entity\Departement#venteRechercheAlertes which does not exist.
App\Entity\Adherent\MagasinConsentements	No errors.
App\Entity\EvenementsGroupeAll\AvisEvenement	The association App\Entity\EvenementsGroupeAll\AvisEvenement#k_adh refers to the inverse side field App\Entity\Adherent\Magasin#avisEvenement which does not exist.
App\Entity\Adherent\MagasinReseaux	No errors.
App\Entity\Webfactory\SeoVilles	No errors.
App\Entity\Webfactory\Widget\Createur\Faq	No errors.
App\Entity\ImagePartner	No errors.
App\Entity\Kpi\KpiParameters	No errors.
App\Entity\Kpi\KpiObjectifs	No errors.
App\Entity\Crm\CrmResponseIa	No errors.

Symfony Profiler

https://espace-adherentpp.groupeall.com/api/image/photos/C4230

Configuration Settings

Theme