Query Metrics

1338 Database Queries
15 Different statements
1090.75 ms Query time
1 Invalid entities
1154 Managed entities

Grouped Statements

Show all queries

Time Count Info
171.71 ms
(15.74%)
223
"COMMIT"
Parameters:
[]
167.72 ms
(15.38%)
223
"START TRANSACTION"
Parameters:
[]
104.90 ms
(9.62%)
106
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:
[]
96.59 ms
(8.85%)
106
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:
[
  1
]
92.21 ms
(8.45%)
106
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:
[
  1
]
91.39 ms
(8.38%)
106
UPDATE animatrice SET last_updated_at = ? WHERE id = ?
Parameters:
[
  "2026-09-03 11:15:06"
  1
]
91.12 ms
(8.35%)
114
UPDATE animatrice_numero SET last_sync_at = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "2026-09-03 11:15:06"
  "2026-09-03 11:15:06"
  1
]
84.72 ms
(7.77%)
106
SELECT COALESCE(SUM(p0_.total_value), 0) AS sclr_0 FROM product_stock p0_ WHERE p0_.animatrice_id = ?
Parameters:
[
  1
]
84.09 ms
(7.71%)
114
SAVEPOINT DOCTRINE_2
Parameters:
[]
80.38 ms
(7.37%)
114
RELEASE SAVEPOINT DOCTRINE_2
Parameters:
[]
9.13 ms
(0.84%)
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"
]
6.28 ms
(0.58%)
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.risque_level AS risque_level_20, t0.risque_reasons AS risque_reasons_21, t0.risque_evaluated_at AS risque_evaluated_at_22, t0.last_visite_at AS last_visite_at_23, t0.is_enabled AS is_enabled_24, t0.region_id AS region_id_25, t0.coach_id AS coach_id_26 FROM animatrice t0 WHERE t0.is_enabled = ?
Parameters:
[
  1
]
6.15 ms
(0.56%)
6
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.retour_at AS retour_at_6, t0.animatrice_numero_id AS animatrice_numero_id_7 FROM retour t0 WHERE t0.facture_ref = ? LIMIT 1
Parameters:
[
  "AV14423"
]
2.30 ms
(0.21%)
3
UPDATE configuration SET value = ? WHERE id = ?
Parameters:
[
  "2026-09-03T11:15:06+00:00"
  26
]
2.06 ms
(0.19%)
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.is_enabled AS is_enabled_8, t0.last_activity_at AS last_activity_at_9, t0.last_visite_at AS last_visite_at_10, t0.last_update_at AS last_update_at_11, t0.last_login_at AS last_login_at_12, t0.utilisateur_role_id AS utilisateur_role_id_13, t0.region_id AS region_id_14 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 887
App\Entity\AnimatriceNumero 114
App\Entity\Animatrice 106
App\Entity\Product 26
App\Entity\Configuration 7
App\Entity\Utilisateur 6
App\Entity\Retour 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.