Query Metrics
6
Database Queries
6
Different statements
1.53 ms
Query time
4
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.37 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:
[
"C9920"
]
|
| 2 | 0.25 ms |
SELECT t0.id AS id_1, t0.adherent AS adherent_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM webfactory_actualite_category t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
713
]
|
| 3 | 0.25 ms |
SELECT w0_.id AS id_0, w0_.adherent AS adherent_1, w0_.author AS author_2, w0_.created_at AS created_at_3, w0_.updated_at AS updated_at_4, w0_.active AS active_5, w0_.lock_copie AS lock_copie_6, w0_.actualite_bibliotheque_id AS actualite_bibliotheque_id_7, w0_.actualite_category_id AS actualite_category_id_8 FROM webfactory_actualite w0_ INNER JOIN webfactory_actualite_category w1_ ON (w0_.actualite_category_id = w1_.id) WHERE w0_.adherent = ? AND w1_.id = ? AND w0_.active = ? ORDER BY w0_.updated_at DESC
Parameters:
[ "C9920" 713 1 ] |
| 4 | 0.24 ms |
SELECT w0_.id AS id_0, w0_.adherent AS adherent_1, w0_.author AS author_2, w0_.created_at AS created_at_3, w0_.updated_at AS updated_at_4, w0_.active AS active_5, w0_.lock_copie AS lock_copie_6, w0_.actualite_bibliotheque_id AS actualite_bibliotheque_id_7, w0_.actualite_category_id AS actualite_category_id_8 FROM webfactory_actualite w0_ INNER JOIN webfactory_actualite_category w1_ ON (w0_.actualite_category_id = w1_.id) WHERE w0_.adherent = ? AND w1_.id = ? AND w0_.active = ? ORDER BY w0_.updated_at DESC LIMIT 6
Parameters:
[ "C9920" 713 1 ] |
| 5 | 0.24 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.image AS image_4, t0.metatitle AS metatitle_5, t0.metadesc AS metadesc_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.lang AS lang_9, t0.metakeywords AS metakeywords_10, t0.slug AS slug_11, t0.short_description AS short_description_12, t0.statut AS statut_13, t0.date_debut_publication AS date_debut_publication_14, t0.date_fin_publication AS date_fin_publication_15, t0.article_id AS article_id_16 FROM webfactory_actualite_contenu t0 WHERE t0.article_id = ?
Parameters:
[
2295
]
|
| 6 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.lang AS lang_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.webfactory_category_id AS webfactory_category_id_8 FROM webfactory_actualite_category_contenu t0 WHERE t0.webfactory_category_id = ?
Parameters:
[
713
]
|
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.