106.62 ms (86.87%)
|
786 |
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;
|
5.46 ms (4.45%)
|
22 |
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;
|
3.79 ms (3.09%)
|
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 = ?
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;
|
2.18 ms (1.78%)
|
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 = ?
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 = 41392;
|
1.62 ms (1.32%)
|
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 = ?
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.56 ms (0.45%)
|
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 = ?
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 = 288;
|
0.54 ms (0.44%)
|
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 = '288';
|
0.52 ms (0.43%)
|
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"
]
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 = 'UNIT_PER_ACTIVITY';
|
0.51 ms (0.41%)
|
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 = 9;
|
0.48 ms (0.39%)
|
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 = ?
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 = 288;
|
0.34 ms (0.28%)
|
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.13 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 = 288;
|