Query Metrics
29
Database Queries
4
Different statements
4.58 ms
Query time
9
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.52 ms (55.02%) |
23 |
SELECT t0.id AS id_1, t0.adherent AS adherent_2, t0.name AS name_3, t0.extension AS extension_4, t0.weight AS weight_5, t0.width AS width_6, t0.height AS height_7, t0.alt AS alt_8, t0.quality AS quality_9, t0.profile_default AS profile_default_10, t0.logo_default AS logo_default_11, t0.active AS active_12, t0.original AS original_13, t0.commentaire AS commentaire_14, t0.deleted AS deleted_15, t0.created_at AS created_at_16, t0.cropped_at AS cropped_at_17, t0.deleted_at AS deleted_at_18, t0.print_quality AS print_quality_19, t0.communication_print AS communication_print_20, t0.generique_id AS generique_id_21, t0.type_id AS type_id_22 FROM image t0 WHERE t0.id = ?
Parameters:
[
11110
]
|
|
1.35 ms (29.40%) |
1 |
SELECT t0.id AS id_1, t0.k_adh AS k_adh_2, t0.sort AS sort_3, t0.id_image_id AS id_image_id_4 FROM opc_image t0 WHERE t0.k_adh = ? ORDER BY t0.sort ASC
Parameters:
[
"R1223"
]
|
|
0.38 ms (8.32%) |
1 |
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:
[
"R1223"
]
|
|
0.33 ms (7.26%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM img_type t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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 |
|
| 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 |
|
| App\Entity\Adherent\MagasinMarques |
|
| App\Entity\Webfactory\Navigation | No errors. |
| App\Entity\Adherent\MagasinUrl |
|
| App\Entity\Adherent\MagasinJuridique |
|
| App\Entity\Adherent\Annuaire\MagasinContact | No errors. |
| App\Entity\Retrocession\Annonce |
|
| App\Entity\Adherent\MagasinAlert | No errors. |
| App\Entity\Alertes\MagasinMarquesAlertes |
|
| App\Entity\VenteRechercheMagasins\VenteRechercheMagasinsAlertes |
|
| App\Entity\Adherent\MagasinConsentements | No errors. |
| App\Entity\EvenementsGroupeAll\AvisEvenement |
|
| 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. |
| App\Entity\Webfactory\Opc\OpcImage | No errors. |
| App\Entity\Image\Image | No errors. |
| App\Entity\Image\ImgType | No errors. |
| App\Entity\Webfactory\Widget\Classique\Gallery | No errors. |
| App\Entity\Image\ImgPublication | No errors. |