POST https://cogs.sirona-cs.com/requests/292/edit

Query Metrics

9 Database Queries
9 Different statements
4.21 ms Query time
0 Invalid entities
2 Managed entities

Queries

Group similar statements

# Time Info
1 0.56 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5, t0.currency AS currency_6, t0.recent_requests AS recent_requests_7, t0.recent_materials AS recent_materials_8, t0.recent_routings AS recent_routings_9 FROM user t0 WHERE t0.id = ?
Parameters:
[
  8
]
2 0.28 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.createdat AS createdat_3, t0.updatedat AS updatedat_4, t0.status AS status_5, t0.refclient AS refclient_6, t0.quantite AS quantite_7, t0.description AS description_8, t0.drawing AS drawing_9, t0.alttext AS alttext_10, t0.drawinga AS drawinga_11, t0.isactivesimul AS isactivesimul_12, t0.createur_id AS createur_id_13, t0.parent_id AS parent_id_14, t0.stdconfig_id AS stdconfig_id_15 FROM cotation t0 WHERE t0.id = ?
Parameters:
[
  "292"
]
3 0.21 ms
"START TRANSACTION"
Parameters:
[]
4 0.30 ms
UPDATE cotation SET titre = ?, updatedat = ?, drawing = ? WHERE id = ?
Parameters:
[
  "eDP_TH"
  "2026-06-29"
  "D-17099"
  292
]
5 0.17 ms
"COMMIT"
Parameters:
[]
6 1.58 ms
SELECT count(m0_.id) AS sclr_0 FROM cotation_detail c1_ LEFT JOIN matiere_premiere m0_ ON c1_.matierepremiere_id = m0_.id WHERE c1_.cotation_id = ? AND m0_.refinterne <> ? AND c1_.bomunit = m0_.bomunit AND c1_.costbool = 1 AND c1_.cotation_id = ?
Parameters:
[
  292
  "-"
  292
]
7 0.61 ms
SELECT count(p0_.id) AS sclr_0 FROM cotation_process c1_ LEFT JOIN process_prod p0_ ON c1_.processprod_id = p0_.id WHERE c1_.cotation_id = ? AND p0_.refinterne <> ? AND c1_.baseunit = p0_.unit AND c1_.costbool = 1 AND c1_.cotation_id = ?
Parameters:
[
  292
  "-"
  292
]
8 0.25 ms
SELECT count(m0_.id) AS sclr_0 FROM cotation_detail c1_ LEFT JOIN matiere_premiere m0_ ON c1_.matierepremiere_id = m0_.id WHERE ((c1_.cotation_id = ? AND (m0_.refinterne = ? AND c1_.costbool = 1)) OR (c1_.bomunit <> m0_.bomunit AND c1_.costbool = 1)) AND c1_.cotation_id = ?
Parameters:
[
  292
  "-"
  292
]
9 0.25 ms
SELECT count(p0_.id) AS sclr_0 FROM cotation_process c1_ LEFT JOIN process_prod p0_ ON c1_.processprod_id = p0_.id WHERE ((c1_.cotation_id = ? AND (p0_.refinterne = ? AND c1_.costbool = 1)) OR (c1_.baseunit <> p0_.unit AND c1_.costbool = 1)) AND c1_.cotation_id = ?
Parameters:
[
  292
  "-"
  292
]

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\User 1
App\Entity\Cotation 1

Entities Mapping