Query Metrics
7
Database Queries
5
Different statements
17.50 ms
Query time
0
Invalid entities
4326
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
11.32 ms (64.67%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.firstname AS firstname_3, t0.phone_number AS phone_number_4, t0.company_name AS company_name_5, t0.number_card AS number_card_6, t0.date_expiration AS date_expiration_7, t0.status_generate AS status_generate_8, t0.type AS type_9, t0.logo AS logo_10, t0.standard AS standard_11, t0.mobile AS mobile_12, t0.fax AS fax_13, t0.bp AS bp_14, t0.client_web AS client_web_15, t0.numero_carre AS numero_carre_16, t0.maison AS maison_17, t0.email AS email_18, t0.anniversaire AS anniversaire_19, t0.tva AS tva_20, t0.ifu AS ifu_21, t0.observation AS observation_22, t0.civilite AS civilite_23, t0.nom_dg AS nom_dg_24, t0.password AS password_25, t0.regime_fiscal AS regime_fiscal_26, t0.code_client AS code_client_27, t0.direct AS direct_28, t0.adresse_physique AS adresse_physique_29, t0.personne_contact AS personne_contact_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.deleted_at AS deleted_at_33, t0.created_by AS created_by_34, t0.updated_by AS updated_by_35, t0.zone_id AS zone_id_36, t0.activite_id AS activite_id_37, t0.quartier_id AS quartier_id_38, t0.client_de_id AS client_de_id_39, t0.categorie_client_id AS categorie_client_id_40 FROM client t0
Parameters:
[] |
|
2.64 ms (15.07%) |
3 |
SELECT t0.id AS id_1, t0.status AS status_2, t0.operation_id AS operation_id_3, t0.client_id AS client_id_4, t0.client_name AS client_name_5, t0.client_firstname AS client_firstname_6, t0.amount AS amount_7, t0.poid AS poid_8, t0.user_id AS user_id_9, t0.destination_id AS destination_id_10, t0.date AS date_11, t0.raison_sociale AS raison_sociale_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17 FROM notification t0 WHERE t0.user_id = ? AND t0.status = ? AND t0.date = ?
Parameters:
[ 47 1 "2026-04-02" ] |
|
1.67 ms (9.55%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.corpate AS corpate_7, t0.active AS active_8, t0.date_embauche AS date_embauche_9, t0.date_depart AS date_depart_10, t0.interphone AS interphone_11, t0.date_naissance AS date_naissance_12, t0.code_employer AS code_employer_13, t0.code_pays AS code_pays_14, t0.mobile AS mobile_15, t0.fax AS fax_16, t0.telephone_employer AS telephone_employer_17, t0.email_employer AS email_employer_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.deleted_at AS deleted_at_21, t0.created_by AS created_by_22, t0.updated_by AS updated_by_23, t0.affiliate_id AS affiliate_id_24, t0.service_id AS service_id_25 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
47
]
|
|
1.03 ms (5.90%) |
1 |
SELECT v0_.id AS id_0, v0_.nom_ville AS nom_ville_1, v0_.code_ville AS code_ville_2, v0_.tarif_puclic_courrier AS tarif_puclic_courrier_3, v0_.tarif_perso_courrier AS tarif_perso_courrier_4, v0_.delai AS delai_5, v0_.observation AS observation_6, v0_.nombre_ticket AS nombre_ticket_7, v0_.created_at AS created_at_8, v0_.updated_at AS updated_at_9, v0_.deleted_at AS deleted_at_10, v0_.created_by AS created_by_11, v0_.updated_by AS updated_by_12, v0_.pays_id AS pays_id_13 FROM ville v0_
Parameters:
[] |
|
0.84 ms (4.80%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM role t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"ROLE_ACCUEIL"
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Client | 4110 |
| App\Entity\Ville | 214 |
| App\Entity\User | 1 |
| App\Entity\Role | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Service | No errors. |
| App\Entity\ZoneUser | No errors. |
| App\Entity\Rapport | No errors. |
| App\Entity\Bordereau | No errors. |
| App\Entity\Client | No errors. |
| App\Entity\Affectation | No errors. |
| App\Entity\Demande | No errors. |
| App\Entity\Ville | No errors. |
| App\Entity\Zone | No errors. |
| App\Entity\Activite | No errors. |
| App\Entity\Quartier | No errors. |
| App\Entity\CategorieClient | No errors. |
| App\Entity\Pays | No errors. |
| App\Entity\Role | No errors. |
| App\Entity\RoleHasPermission | No errors. |
| App\Entity\Notification | No errors. |