https://crm.ffcb.fr/admin/advanced-search/entreprise

Query Metrics

38 Database Queries
10 Different statements
16.88 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.58 ms
SELECT t0.status AS status_1, t0.id AS id_2, t0.email AS email_3, t0.roles AS roles_4, t0.first_name AS first_name_5, t0.password AS password_6, t0.last_name AS last_name_7, t0.type AS type_8, t0.change_password AS change_password_9, t0.contact_id AS contact_id_10, t0.region_id AS region_id_11, t0.commission_id AS commission_id_12 FROM user t0 WHERE t0.id = ?
Parameters:
[
  437
]
2 1.99 ms
SELECT count(DISTINCT e0_.id) AS sclr_0 FROM entreprise e0_ WHERE e0_.status <> ?
Parameters:
[
  88
]
3 1.26 ms
SELECT DISTINCT e0_.id AS id_0 FROM entreprise e0_ WHERE e0_.status <> ? LIMIT 15
Parameters:
[
  88
]
4 1.19 ms
SELECT e0_.status AS status_0, e0_.id AS id_1, e0_.raison_social AS raison_social_2, e0_.adresse AS adresse_3, e0_.tel1 AS tel1_4, e0_.tel2 AS tel2_5, e0_.fax AS fax_6, e0_.email AS email_7, e0_.code_siren AS code_siren_8, e0_.code_ape AS code_ape_9, e0_.num_tva_intracom AS num_tva_intracom_10, e0_.ancien_identifiant AS ancien_identifiant_11, e0_.identifiant_compta AS identifiant_compta_12, e0_.num_ede_negoce AS num_ede_negoce_13, e0_.num_ede_centre AS num_ede_centre_14, e0_.num_ede_elevage AS num_ede_elevage_15, e0_.nombre_employes AS nombre_employes_16, e0_.autre_specialite AS autre_specialite_17, e0_.volume_animaux AS volume_animaux_18, e0_.souhaite_adherer AS souhaite_adherer_19, e0_.figurer_annuaire_adherents AS figurer_annuaire_adherents_20, e0_.figurer_annuaire_internet AS figurer_annuaire_internet_21, e0_.figurer_au_nom_de AS figurer_au_nom_de_22, e0_.statut_paiement AS statut_paiement_23, e0_.raison_non_adhesion AS raison_non_adhesion_24, e0_.date_cessation AS date_cessation_25, e0_.chiffre_dernier_total AS chiffre_dernier_total_26, e0_.commentaires AS commentaires_27, e0_.is_transporter AS is_transporter_28, e0_.transport_pour_autrui AS transport_pour_autrui_29, e0_.lien_url AS lien_url_30, e0_.ville AS ville_31, e0_.code_postal AS code_postal_32, e0_.adresse2 AS adresse2_33, e0_.nombre_veaux AS nombre_veaux_34, e0_.nombre_maigres AS nombre_maigres_35, e0_.nombre_elev_prod AS nombre_elev_prod_36, e0_.nombre_boucherie AS nombre_boucherie_37, e0_.nombre_ovins AS nombre_ovins_38, e0_.nombre_porcins AS nombre_porcins_39, e0_.nombre_equins AS nombre_equins_40, e0_.nombre_caprins AS nombre_caprins_41, e0_.autre_activite AS autre_activite_42, e0_.code_adherent AS code_adherent_43, e0_.is_quali_negoce AS is_quali_negoce_44, e0_.quali_negoce_certification_date AS quali_negoce_certification_date_45, e0_.quali_negoce_contact_name AS quali_negoce_contact_name_46, e0_.raison_non_adhesion_autre AS raison_non_adhesion_autre_47, e0_.total_count_species AS total_count_species_48, e0_.quali_negoce_pre_audit_date AS quali_negoce_pre_audit_date_49, e0_.is_member AS is_member_50, e0_.groupe_entreprise_id AS groupe_entreprise_id_51, e0_.departement_id AS departement_id_52, e0_.syndicat_id AS syndicat_id_53, e0_.transporteur_id AS transporteur_id_54, e0_.contact_responsable_id AS contact_responsable_id_55, e0_.home_region_id AS home_region_id_56, e0_.commission_id AS commission_id_57, e0_.quali_negoce_contact_id AS quali_negoce_contact_id_58, e0_.firm_type_id AS firm_type_id_59 FROM entreprise e0_ WHERE e0_.status <> ? AND e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  88
  286
  499
  774
  916
  1037
  1140
  1258
  1305
  1348
  1484
  1500
  1510
  1522
  1536
  1559
]
5 0.61 ms
SELECT COUNT(*) FROM user_question t0 WHERE t0.is_new = ?
Parameters:
[
  1
]
6 0.33 ms
SELECT COUNT(*) FROM user_question t0 WHERE t0.is_new = ?
Parameters:
[
  1
]
7 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.tag AS tag_3, t0.color AS color_4 FROM firm_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
8 0.35 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.num_depart AS num_depart_3, t0.is_billed_by_department AS is_billed_by_department_4, t0.region_id AS region_id_5 FROM departement t0 WHERE t0.id = ?
Parameters:
[
  53
]
9 0.44 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM region t0 INNER JOIN departement_region ON t0.id = departement_region.region_id WHERE departement_region.departement_id = ?
Parameters:
[
  53
]
10 0.31 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.nom AS nom_3, t0.comment AS comment_4, t0.syndicat_regional_id AS syndicat_regional_id_5, t0.region_id AS region_id_6, t0.departement_id AS departement_id_7 FROM syndicat t0 WHERE t0.id = ?
Parameters:
[
  12
]
11 0.32 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.num_depart AS num_depart_3, t0.is_billed_by_department AS is_billed_by_department_4, t0.region_id AS region_id_5 FROM departement t0 WHERE t0.id = ?
Parameters:
[
  82
]
12 0.39 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM region t0 INNER JOIN departement_region ON t0.id = departement_region.region_id WHERE departement_region.departement_id = ?
Parameters:
[
  82
]
13 0.44 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.nom AS nom_3, t0.comment AS comment_4, t0.syndicat_regional_id AS syndicat_regional_id_5, t0.region_id AS region_id_6, t0.departement_id AS departement_id_7 FROM syndicat t0 WHERE t0.id = ?
Parameters:
[
  21
]
14 0.36 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.num_depart AS num_depart_3, t0.is_billed_by_department AS is_billed_by_department_4, t0.region_id AS region_id_5 FROM departement t0 WHERE t0.id = ?
Parameters:
[
  22
]
15 0.37 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM region t0 INNER JOIN departement_region ON t0.id = departement_region.region_id WHERE departement_region.departement_id = ?
Parameters:
[
  22
]
16 0.35 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.nom AS nom_3, t0.comment AS comment_4, t0.syndicat_regional_id AS syndicat_regional_id_5, t0.region_id AS region_id_6, t0.departement_id AS departement_id_7 FROM syndicat t0 WHERE t0.id = ?
Parameters:
[
  31
]
17 0.30 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.nom AS nom_3, t0.comment AS comment_4, t0.syndicat_regional_id AS syndicat_regional_id_5, t0.region_id AS region_id_6, t0.departement_id AS departement_id_7 FROM syndicat t0 WHERE t0.id = ?
Parameters:
[
  34
]
18 0.32 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.num_depart AS num_depart_3, t0.is_billed_by_department AS is_billed_by_department_4, t0.region_id AS region_id_5 FROM departement t0 WHERE t0.id = ?
Parameters:
[
  44
]
19 0.39 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM region t0 INNER JOIN departement_region ON t0.id = departement_region.region_id WHERE departement_region.departement_id = ?
Parameters:
[
  44
]
20 0.38 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.num_depart AS num_depart_3, t0.is_billed_by_department AS is_billed_by_department_4, t0.region_id AS region_id_5 FROM departement t0 WHERE t0.id = ?
Parameters:
[
  72
]
21 0.46 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM region t0 INNER JOIN departement_region ON t0.id = departement_region.region_id WHERE departement_region.departement_id = ?
Parameters:
[
  72
]
22 0.38 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.num_depart AS num_depart_3, t0.is_billed_by_department AS is_billed_by_department_4, t0.region_id AS region_id_5 FROM departement t0 WHERE t0.id = ?
Parameters:
[
  12
]
23 0.46 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM region t0 INNER JOIN departement_region ON t0.id = departement_region.region_id WHERE departement_region.departement_id = ?
Parameters:
[
  12
]
24 0.35 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.num_depart AS num_depart_3, t0.is_billed_by_department AS is_billed_by_department_4, t0.region_id AS region_id_5 FROM departement t0 WHERE t0.id = ?
Parameters:
[
  15
]
25 0.34 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM region t0 INNER JOIN departement_region ON t0.id = departement_region.region_id WHERE departement_region.departement_id = ?
Parameters:
[
  15
]
26 0.33 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.nom AS nom_3, t0.comment AS comment_4, t0.syndicat_regional_id AS syndicat_regional_id_5, t0.region_id AS region_id_6, t0.departement_id AS departement_id_7 FROM syndicat t0 WHERE t0.id = ?
Parameters:
[
  25
]
27 0.28 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.num_depart AS num_depart_3, t0.is_billed_by_department AS is_billed_by_department_4, t0.region_id AS region_id_5 FROM departement t0 WHERE t0.id = ?
Parameters:
[
  59
]
28 0.30 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM region t0 INNER JOIN departement_region ON t0.id = departement_region.region_id WHERE departement_region.departement_id = ?
Parameters:
[
  59
]
29 0.27 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.num_depart AS num_depart_3, t0.is_billed_by_department AS is_billed_by_department_4, t0.region_id AS region_id_5 FROM departement t0 WHERE t0.id = ?
Parameters:
[
  73
]
30 0.33 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM region t0 INNER JOIN departement_region ON t0.id = departement_region.region_id WHERE departement_region.departement_id = ?
Parameters:
[
  73
]
31 0.27 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.nom AS nom_3, t0.comment AS comment_4, t0.syndicat_regional_id AS syndicat_regional_id_5, t0.region_id AS region_id_6, t0.departement_id AS departement_id_7 FROM syndicat t0 WHERE t0.id = ?
Parameters:
[
  56
]
32 0.21 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM region t0 WHERE t0.id = ?
Parameters:
[
  4
]
33 0.26 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.num_depart AS num_depart_3, t0.is_billed_by_department AS is_billed_by_department_4, t0.region_id AS region_id_5 FROM departement t0 WHERE t0.id = ?
Parameters:
[
  81
]
34 0.29 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM region t0 INNER JOIN departement_region ON t0.id = departement_region.region_id WHERE departement_region.departement_id = ?
Parameters:
[
  81
]
35 0.29 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.nom AS nom_3, t0.comment AS comment_4, t0.syndicat_regional_id AS syndicat_regional_id_5, t0.region_id AS region_id_6, t0.departement_id AS departement_id_7 FROM syndicat t0 WHERE t0.id = ?
Parameters:
[
  6
]
36 0.23 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.num_depart AS num_depart_3, t0.is_billed_by_department AS is_billed_by_department_4, t0.region_id AS region_id_5 FROM departement t0 WHERE t0.id = ?
Parameters:
[
  50
]
37 0.34 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM region t0 INNER JOIN departement_region ON t0.id = departement_region.region_id WHERE departement_region.departement_id = ?
Parameters:
[
  50
]
38 0.28 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.nom AS nom_3, t0.comment AS comment_4, t0.syndicat_regional_id AS syndicat_regional_id_5, t0.region_id AS region_id_6, t0.departement_id AS departement_id_7 FROM syndicat t0 WHERE t0.id = ?
Parameters:
[
  54
]

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\EntityStatus No errors.
App\Entity\User No errors.
App\Entity\Contact No errors.
App\Entity\Region No errors.
App\Entity\Commission No errors.
App\Entity\UserQuestion No errors.
App\Entity\UserCart No errors.
App\Entity\SyndicatUser No errors.
App\Entity\LogConnection No errors.
App\Entity\Order No errors.
App\Entity\Entreprise No errors.
App\Entity\GroupeEntreprise No errors.
App\Entity\Departement No errors.
App\Entity\Syndicat No errors.
App\Entity\EntrepriseTransporteur No errors.
App\Entity\FirmType No errors.
App\Entity\Etablissement No errors.
App\Entity\CommissionEntreprise No errors.
App\Entity\Cotisation No errors.
App\Entity\EntrepriseActivity No errors.
App\Entity\FirmQualiNegoceDocument No errors.
App\Entity\CotisationNotification No errors.
App\Entity\FormUser No errors.
App\Entity\FirmContactQualiNegoce No errors.
App\Entity\SyndicatContact No errors.