36.72 ms (34.72%)
218
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 = 53 ;
Copy
31.26 ms (29.56%)
1
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
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 ;
Copy
26.07 ms (24.65%)
115
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 ;
Copy
2.61 ms (2.47%)
9
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 . activity_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 . activity_id = 1 ;
Copy
1.34 ms (1.26%)
1
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
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 ;
Copy
1.14 ms (1.08%)
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 . email = ? LIMIT 1
Parameters :
[
"khalil.khattab@linxens.com "
]
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 . email = 'khalil.khattab@linxens.com' LIMIT 1 ;
Copy
1.10 ms (1.04%)
1
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
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 ;
Copy
0.92 ms (0.87%)
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_ . status IN ('INIT' , 'DRAFT' , 'OK' , 'Autre' ) 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_ . status IN ('INIT' , 'DRAFT' , 'OK' , 'Autre' ) ORDER BY c0_ . createdat DESC ;
Copy
0.81 ms (0.77%)
3
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_REQUEST "
]
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_REQUEST' ;
Copy
0.56 ms (0.53%)
1
SELECT p0_ . id AS id_0 , p0_ . titre AS titre_1 , p0_ . refinterne AS refinterne_2 , p0_ . workcenter AS workcenter_3 , p0_ . plant AS plant_4 , p0_ . controlkey AS controlkey_5 , p0_ . textkey AS textkey_6 , p0_ . unit AS unit_7 , p0_ . setupquantity AS setupquantity_8 , p0_ . checknotif AS checknotif_9 , p0_ . crcy AS crcy_10 , p0_ . createdon AS createdon_11 , p0_ . baseqty AS baseqty_12 FROM process_prod p0_ WHERE p0_ . refinterne = ? AND p0_ . checknotif = ? ORDER BY p0_ . refinterne DESC
SELECT p0_ . id AS id_0 , p0_ . titre AS titre_1 , p0_ . refinterne AS refinterne_2 , p0_ . workcenter AS workcenter_3 , p0_ . plant AS plant_4 , p0_ . controlkey AS controlkey_5 , p0_ . textkey AS textkey_6 , p0_ . unit AS unit_7 , p0_ . setupquantity AS setupquantity_8 , p0_ . checknotif AS checknotif_9 , p0_ . crcy AS crcy_10 , p0_ . createdon AS createdon_11 , p0_ . baseqty AS baseqty_12 FROM process_prod p0_ WHERE p0_ . refinterne = '-' AND p0_ . checknotif = 1 ORDER BY p0_ . refinterne DESC ;
Copy
0.54 ms (0.51%)
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 . status = ? ORDER BY t0 . createdat DESC
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 . status = 'SIMUL' ORDER BY t0 . createdat DESC ;
Copy
0.50 ms (0.47%)
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_ . status NOT IN ('SIMUL' , 'STD_CONFIG' , 'Autre' ) AND c0_ . createur_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_ . status NOT IN ('SIMUL' , 'STD_CONFIG' , 'Autre' ) AND c0_ . createur_id = 2 ORDER BY c0_ . createdat DESC ;
Copy
0.49 ms (0.47%)
1
SELECT p0_ . id AS id_0 , p0_ . titre AS titre_1 , p0_ . refinterne AS refinterne_2 , p0_ . workcenter AS workcenter_3 , p0_ . plant AS plant_4 , p0_ . controlkey AS controlkey_5 , p0_ . textkey AS textkey_6 , p0_ . unit AS unit_7 , p0_ . setupquantity AS setupquantity_8 , p0_ . checknotif AS checknotif_9 , p0_ . crcy AS crcy_10 , p0_ . createdon AS createdon_11 , p0_ . baseqty AS baseqty_12 FROM process_prod p0_ WHERE p0_ . refinterne < > ? AND p0_ . checknotif = ? ORDER BY p0_ . refinterne DESC
SELECT p0_ . id AS id_0 , p0_ . titre AS titre_1 , p0_ . refinterne AS refinterne_2 , p0_ . workcenter AS workcenter_3 , p0_ . plant AS plant_4 , p0_ . controlkey AS controlkey_5 , p0_ . textkey AS textkey_6 , p0_ . unit AS unit_7 , p0_ . setupquantity AS setupquantity_8 , p0_ . checknotif AS checknotif_9 , p0_ . crcy AS crcy_10 , p0_ . createdon AS createdon_11 , p0_ . baseqty AS baseqty_12 FROM process_prod p0_ WHERE p0_ . refinterne < > '-' AND p0_ . checknotif = '1' ORDER BY p0_ . refinterne DESC ;
Copy
0.40 ms (0.38%)
1
SELECT t0 . id AS id_1 , t0 . refinterne AS refinterne_2 , t0 . titre AS titre_3 FROM cost_center t0
SELECT t0 . id AS id_1 , t0 . refinterne AS refinterne_2 , t0 . titre AS titre_3 FROM cost_center t0 ;
Copy
0.36 ms (0.34%)
1
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . stdrequest_id AS stdrequest_id_3 FROM std_configuration t0
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . stdrequest_id AS stdrequest_id_3 FROM std_configuration t0 ;
Copy
0.34 ms (0.33%)
1
SELECT m0_ . id AS id_0 , m0_ . titre AS titre_1 , m0_ . prixref AS prixref_2 , m0_ . refinterne AS refinterne_3 , m0_ . bomusage AS bomusage_4 , m0_ . bomunit AS bomunit_5 , m0_ . createdon AS createdon_6 , m0_ . inforec AS inforec_7 , m0_ . pint AS pint_8 , m0_ . mtyp AS mtyp_9 , m0_ . proctype AS proctype_10 , m0_ . crcy AS crcy_11 , m0_ . checknotif AS checknotif_12 , m0_ . updatedon AS updatedon_13 FROM matiere_premiere m0_ WHERE m0_ . refinterne = ? AND m0_ . checknotif = ? ORDER BY m0_ . refinterne DESC
SELECT m0_ . id AS id_0 , m0_ . titre AS titre_1 , m0_ . prixref AS prixref_2 , m0_ . refinterne AS refinterne_3 , m0_ . bomusage AS bomusage_4 , m0_ . bomunit AS bomunit_5 , m0_ . createdon AS createdon_6 , m0_ . inforec AS inforec_7 , m0_ . pint AS pint_8 , m0_ . mtyp AS mtyp_9 , m0_ . proctype AS proctype_10 , m0_ . crcy AS crcy_11 , m0_ . checknotif AS checknotif_12 , m0_ . updatedon AS updatedon_13 FROM matiere_premiere m0_ WHERE m0_ . refinterne = '-' AND m0_ . checknotif = 1 ORDER BY m0_ . refinterne DESC ;
Copy
0.30 ms (0.29%)
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 ;
Copy
0.28 ms (0.27%)
1
SELECT m0_ . id AS id_0 , m0_ . titre AS titre_1 , m0_ . prixref AS prixref_2 , m0_ . refinterne AS refinterne_3 , m0_ . bomusage AS bomusage_4 , m0_ . bomunit AS bomunit_5 , m0_ . createdon AS createdon_6 , m0_ . inforec AS inforec_7 , m0_ . pint AS pint_8 , m0_ . mtyp AS mtyp_9 , m0_ . proctype AS proctype_10 , m0_ . crcy AS crcy_11 , m0_ . checknotif AS checknotif_12 , m0_ . updatedon AS updatedon_13 FROM matiere_premiere m0_ WHERE m0_ . refinterne < > ? AND m0_ . checknotif = ? ORDER BY m0_ . refinterne DESC
SELECT m0_ . id AS id_0 , m0_ . titre AS titre_1 , m0_ . prixref AS prixref_2 , m0_ . refinterne AS refinterne_3 , m0_ . bomusage AS bomusage_4 , m0_ . bomunit AS bomunit_5 , m0_ . createdon AS createdon_6 , m0_ . inforec AS inforec_7 , m0_ . pint AS pint_8 , m0_ . mtyp AS mtyp_9 , m0_ . proctype AS proctype_10 , m0_ . crcy AS crcy_11 , m0_ . checknotif AS checknotif_12 , m0_ . updatedon AS updatedon_13 FROM matiere_premiere m0_ WHERE m0_ . refinterne < > '-' AND m0_ . checknotif = '1' ORDER BY m0_ . refinterne DESC ;
Copy