Query Metrics

1194 Database Queries
15 Different statements
442.82 ms Query time
1 Invalid entities
1457 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
58.85 ms
(13.29%)
197
"COMMIT"
Parameters:
[]
55.32 ms
(12.49%)
197
"START TRANSACTION"
Parameters:
[]
47.76 ms
(10.78%)
93
SELECT t0.id AS id_1, t0.code AS code_2, t0.created_at AS created_at_3, t0.sale_id AS sale_id_4, t0.lot_number AS lot_number_5, t0.expire_at AS expire_at_6, t0.quantite_disponible AS quantite_disponible_7, t0.quantite_initial AS quantite_initial_8, t0.total_value AS total_value_9, t0.last_mouvement_at AS last_mouvement_at_10, t0.slug AS slug_11, t0.animatrice_id AS animatrice_id_12, t0.product_id AS product_id_13 FROM product_stock t0 WHERE t0.animatrice_id = ?
Parameters:
[
  2
]
43.37 ms
(9.79%)
93
SELECT t0.id AS id_1, t0.code AS code_2, t0.numero AS numero_3, t0.designation AS designation_4, t0.unit AS unit_5, t0.price AS price_6, t0.filename AS filename_7, t0.color AS color_8, t0.survente AS survente_9, t0.is_enabled AS is_enabled_10, t0.last_update_at AS last_update_at_11, t0.multiplier AS multiplier_12 FROM product t0
Parameters:
[]
42.62 ms
(9.63%)
101
UPDATE animatrice_numero SET last_sync_at = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "2026-10-19 16:30:06"
  "2026-10-19 16:30:06"
  99
]
39.37 ms
(8.89%)
93
SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.created_at AS created_at_2, a0_.updated_at AS updated_at_3, a0_.numero AS numero_4, a0_.is_enabled AS is_enabled_5, a0_.last_sync_at AS last_sync_at_6, a0_.animatrice_id AS animatrice_id_7, a0_.created_by_id AS created_by_id_8, a0_.product_id AS product_id_9 FROM animatrice_numero a0_ WHERE a0_.animatrice_id = ? AND (a0_.is_enabled = 1 OR a0_.is_enabled IS NULL)
Parameters:
[
  2
]
37.90 ms
(8.56%)
93
UPDATE animatrice SET last_updated_at = ? WHERE id = ?
Parameters:
[
  "2026-10-19 16:30:06"
  2
]
37.87 ms
(8.55%)
93
SELECT COALESCE(SUM(p0_.total_value), 0) AS sclr_0 FROM product_stock p0_ WHERE p0_.animatrice_id = ?
Parameters:
[
  2
]
34.33 ms
(7.75%)
101
SAVEPOINT DOCTRINE_2
Parameters:
[]
24.98 ms
(5.64%)
101
RELEASE SAVEPOINT DOCTRINE_2
Parameters:
[]
11.68 ms
(2.64%)
18
SELECT t0.id AS id_1, t0.code AS code_2, t0.created_at AS created_at_3, t0.facture_ref AS facture_ref_4, t0.total_value AS total_value_5, t0.livraison_at AS livraison_at_6, t0.animatrice_numero_id AS animatrice_numero_id_7 FROM facturation t0 WHERE t0.facture_ref = ? LIMIT 1
Parameters:
[
  "FA116406"
]
4.14 ms
(0.94%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom_prenom AS nom_prenom_3, t0.created_at AS created_at_4, t0.code_collaborateur AS code_collaborateur_5, t0.last_updated_at AS last_updated_at_6, t0.adresse AS adresse_7, t0.phone_number AS phone_number_8, t0.total_vente AS total_vente_9, t0.valeur_stock AS valeur_stock_10, t0.total_paiement_restant AS total_paiement_restant_11, t0.is_soazaza AS is_soazaza_12, t0.soazaza_started_at AS soazaza_started_at_13, t0.soazaza_funnel_status AS soazaza_funnel_status_14, t0.soazaza_recommended_decision AS soazaza_recommended_decision_15, t0.soazaza_stagnation_alert AS soazaza_stagnation_alert_16, t0.soazaza_funnel_months AS soazaza_funnel_months_17, t0.soazaza_funnel_evaluated_at AS soazaza_funnel_evaluated_at_18, t0.is_risque AS is_risque_19, t0.is_eligible_relegation AS is_eligible_relegation_20, t0.risque_level AS risque_level_21, t0.risque_reasons AS risque_reasons_22, t0.risque_evaluated_at AS risque_evaluated_at_23, t0.objectif_unites_mois AS objectif_unites_mois_24, t0.projection_unites_fin_mois AS projection_unites_fin_mois_25, t0.trajectoire_status AS trajectoire_status_26, t0.alerte_projection AS alerte_projection_27, t0.objectif_evaluated_at AS objectif_evaluated_at_28, t0.objectif_ventes_mois AS objectif_ventes_mois_29, t0.projection_ventes_fin_mois AS projection_ventes_fin_mois_30, t0.trajectoire_status_ventes AS trajectoire_status_ventes_31, t0.paiements_projetes_fin_mois AS paiements_projetes_fin_mois_32, t0.exposition_cash_projetee AS exposition_cash_projetee_33, t0.last_visite_at AS last_visite_at_34, t0.is_enabled AS is_enabled_35, t0.region_id AS region_id_36, t0.coach_id AS coach_id_37 FROM animatrice t0 WHERE t0.is_enabled = ?
Parameters:
[
  1
]
3.28 ms
(0.74%)
9
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.description AS description_4, t0.value AS value_5, t0.value_type AS value_type_6, t0.options AS options_7, t0.config_group AS config_group_8 FROM configuration t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "ENABLE_EBP_SYNC"
]
0.88 ms
(0.20%)
3
UPDATE configuration SET value = ? WHERE id = ?
Parameters:
[
  "2026-10-19T16:30:05+00:00"
  36
]
0.47 ms
(0.11%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.created_at AS created_at_6, t0.nom_prenom AS nom_prenom_7, t0.ebp_client_code AS ebp_client_code_8, t0.is_enabled AS is_enabled_9, t0.last_activity_at AS last_activity_at_10, t0.last_visite_at AS last_visite_at_11, t0.last_update_at AS last_update_at_12, t0.last_login_at AS last_login_at_13, t0.utilisateur_role_id AS utilisateur_role_id_14, t0.region_id AS region_id_15 FROM utilisateur t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "TLS6A2F0A6BD2DA620260614200915"
]

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\ProductStock 1204
App\Entity\AnimatriceNumero 101
App\Entity\Animatrice 93
App\Entity\Product 26
App\Entity\Facturation 18
App\Entity\Configuration 7
App\Entity\Utilisateur 6
App\Entity\UtilisateurRole 1
App\Entity\Region 1

Entities Mapping

Class Mapping errors
App\Entity\Configuration No errors.
App\Entity\Utilisateur No errors.
App\Entity\UtilisateurRole No errors.
App\Entity\Region No errors.
App\Entity\Animatrice
  • The field App\Entity\Animatrice#statusHistories is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AnimatriceStatusHistory#animatrice does not contain the required 'inversedBy: "statusHistories"' attribute.
App\Entity\MiscellaneousMouvement No errors.
App\Entity\ProductStockMouvement No errors.
App\Entity\Visite No errors.
App\Entity\Paiement No errors.
App\Entity\Ajustement No errors.
App\Entity\AnimatriceNumero No errors.
App\Entity\MiscellaneousStock No errors.
App\Entity\ProductStock No errors.
App\Entity\MiscellaneousFacturation No errors.
App\Entity\AnimatriceStatusHistory No errors.
App\Entity\Product No errors.
App\Entity\Facturation No errors.
App\Entity\Retour No errors.
App\Entity\Vente No errors.
App\Entity\TerrainStockLine No errors.
App\Entity\PaiementReliquatRegularisation No errors.