GET https://cogs.sirona-cs.com/requests/288/Synthesis

Query Metrics

588 Database Queries
12 Different statements
95.59 ms Query time
0 Invalid entities
135 Managed entities

Grouped Statements

Show all queries

Time Count Info
81.72 ms
(85.49%)
524
SELECT t0.id AS id_1, t0.cname AS cname_2, t0.cvalueint AS cvalueint_3, t0.cvaluedate AS cvaluedate_4, t0.cvaluefloat AS cvaluefloat_5 FROM cogsconfig t0 WHERE t0.cname = ? LIMIT 1
Parameters:
[
  "UNIT_PER_REQUEST"
]
3.77 ms
(3.95%)
22
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.refinterne AS refinterne_3, t0.workcenter AS workcenter_4, t0.plant AS plant_5, t0.controlkey AS controlkey_6, t0.textkey AS textkey_7, t0.unit AS unit_8, t0.setupquantity AS setupquantity_9, t0.checknotif AS checknotif_10, t0.crcy AS crcy_11, t0.createdon AS createdon_12, t0.baseqty AS baseqty_13 FROM process_prod t0 WHERE t0.id = ?
Parameters:
[
  244
]
2.92 ms
(3.06%)
12
SELECT t0.id AS id_1, t0.refinterne AS refinterne_2, t0.titre AS titre_3 FROM cost_center t0 INNER JOIN process_prod_cost_center ON t0.id = process_prod_cost_center.cost_center_id WHERE process_prod_cost_center.process_prod_id = ?
Parameters:
[
  244
]
2.20 ms
(2.30%)
12
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.prixref AS prixref_3, t0.refinterne AS refinterne_4, t0.bomusage AS bomusage_5, t0.bomunit AS bomunit_6, t0.createdon AS createdon_7, t0.inforec AS inforec_8, t0.pint AS pint_9, t0.mtyp AS mtyp_10, t0.proctype AS proctype_11, t0.crcy AS crcy_12, t0.checknotif AS checknotif_13, t0.updatedon AS updatedon_14 FROM matiere_premiere t0 WHERE t0.id = ?
Parameters:
[
  41392
]
1.60 ms
(1.67%)
7
SELECT t0.id AS id_1, t0.thbunit AS thbunit_2, t0.eurunit AS eurunit_3, t0.currency AS currency_4, t0.costcenter_id AS costcenter_id_5, t0.activity_id AS activity_id_6 FROM cost_center_line t0 WHERE t0.costcenter_id = ?
Parameters:
[
  62
]
0.92 ms
(0.97%)
5
SELECT c0_.id AS id_0, c0_.cname AS cname_1, c0_.cvalueint AS cvalueint_2, c0_.cvaluedate AS cvaluedate_3, c0_.cvaluefloat AS cvaluefloat_4 FROM cogsconfig c0_ WHERE c0_.cname = ?
Parameters:
[
  "UNIT_PER_ACTIVITY"
]
0.65 ms
(0.68%)
1
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:
[
  "288"
]
0.50 ms
(0.53%)
1
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:
[
  9
]
0.41 ms
(0.43%)
1
SELECT t0.id AS id_1, t0.costbool AS costbool_2, t0.baseunit AS baseunit_3, t0.linenb AS linenb_4, t0.setup AS setup_5, t0.machine AS machine_6, t0.hpucat AS hpucat_7, t0.repair AS repair_8, t0.supplies AS supplies_9, t0.urilities AS urilities_10, t0.other AS other_11, t0.baseqty AS baseqty_12, t0.cotation_id AS cotation_id_13, t0.processprod_id AS processprod_id_14 FROM cotation_process t0 WHERE t0.cotation_id = ?
Parameters:
[
  288
]
0.37 ms
(0.39%)
1
SELECT t0.id AS id_1, t0.prix AS prix_2, t0.bomusage AS bomusage_3, t0.costbool AS costbool_4, t0.scrap AS scrap_5, t0.bomunit AS bomunit_6, t0.linenb AS linenb_7, t0.ischip AS ischip_8, t0.cotation_id AS cotation_id_9, t0.matierepremiere_id AS matierepremiere_id_10 FROM cotation_detail t0 WHERE t0.cotation_id = ?
Parameters:
[
  288
]
0.26 ms
(0.27%)
1
SELECT t0.id AS id_1, t0.refinterne AS refinterne_2, t0.titre AS titre_3, t0.activitycost AS activitycost_4 FROM activity t0
Parameters:
[]
0.26 ms
(0.27%)
1
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.parent_id = ?
Parameters:
[
  288
]

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\CostCenterLine 43
App\Entity\CotationProcess 23
App\Entity\ProcessProd 22
App\Entity\CotationDetail 12
App\Entity\MatierePremiere 12
App\Entity\Activity 9
App\Entity\CostCenter 7
App\Entity\Cogsconfig 5
App\Entity\Cotation 1
App\Entity\User 1