Redirect 303 redirect from GET @app_cotation_setconfiguration (856e86)

GET https://cogs.sirona-cs.com/requests/289/SavedConfiguration

Query Metrics

1350 Database Queries
12 Different statements
150.19 ms Query time
0 Invalid entities
177 Managed entities

Grouped Statements

Show all queries

Time Count Info
138.37 ms
(92.13%)
1288
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"
]
2.79 ms
(1.85%)
13
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:
[
  52817
]
2.49 ms
(1.66%)
15
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.08 ms
(1.39%)
15
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
]
1.73 ms
(1.15%)
10
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.69 ms
(0.46%)
2
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:
[
  289
]
0.62 ms
(0.41%)
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:
[
  "289"
]
0.44 ms
(0.29%)
2
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:
[
  289
]
0.34 ms
(0.23%)
1
SELECT c0_.id AS id_0, c0_.titre AS titre_1, c0_.createdat AS createdat_2, c0_.updatedat AS updatedat_3, c0_.status AS status_4, c0_.refclient AS refclient_5, c0_.quantite AS quantite_6, c0_.description AS description_7, c0_.drawing AS drawing_8, c0_.alttext AS alttext_9, c0_.drawinga AS drawinga_10, c0_.isactivesimul AS isactivesimul_11, c0_.createur_id AS createur_id_12, c0_.parent_id AS parent_id_13, c0_.stdconfig_id AS stdconfig_id_14 FROM cotation c0_ WHERE c0_.parent_id = ? ORDER BY c0_.createdat DESC
Parameters:
[
  289
]
0.27 ms
(0.18%)
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:
[
  2
]
0.21 ms
(0.14%)
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.16 ms
(0.10%)
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:
[
  289
]

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 60
App\Entity\CotationProcess 34
App\Entity\CotationDetail 28
App\Entity\ProcessProd 15
App\Entity\MatierePremiere 13
App\Entity\CostCenter 10
App\Entity\Activity 9
App\Entity\Cogsconfig 4
App\Entity\Cotation 2
App\Entity\User 2