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"
]
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 = 'UNIT_PER_REQUEST' LIMIT 1;
|
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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = '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 = ?
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 = 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
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 = 289 ORDER BY c0_.createdat DESC;
|
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 = ?
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 = 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
SELECT t0.id AS id_1, t0.refinterne AS refinterne_2, t0.titre AS titre_3, t0.activitycost AS activitycost_4 FROM activity t0;
|
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 = ?
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 = 289;
|