1
24.25 ms
SELECT DISTINCT c0_ . id AS id_0 , c0_ . nb_sheets AS nb_sheets_1 FROM copper_bundles c0_ ORDER BY c0_ . nb_sheets DESC OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY
SELECT DISTINCT c0_ . id AS id_0 , c0_ . nb_sheets AS nb_sheets_1 FROM copper_bundles c0_ ORDER BY c0_ . nb_sheets DESC OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY ;
Copy
2
10.70 ms
SELECT c0_ . id AS id_0 , c0_ . production_date AS production_date_1 , c0_ . bundle_number AS bundle_number_2 , c0_ . mine_bundle_code AS mine_bundle_code_3 , c0_ . bundle_lot_number AS bundle_lot_number_4 , c0_ . bundle_lot_range AS bundle_lot_range_5 , c0_ . bundle_lot_code AS bundle_lot_code_6 , c0_ . net_weight AS net_weight_7 , c0_ . nb_sheets AS nb_sheets_8 , c0_ . auto_stripping AS auto_stripping_9 , c0_ . comment AS comment_10 , c0_ . entry_date AS entry_date_11 , c0_ . shift AS shift_12 , c0_ . tare AS tare_13 , c0_ . washed AS washed_14 , c0_ . gross_weight AS gross_weight_15 , c0_ . seal1 AS seal1_16 , c0_ . seal2 AS seal2_17 , c0_ . net_weight_from_scale AS net_weight_from_scale_18 , c0_ . gross_weight_from_scale AS gross_weight_from_scale_19 , c0_ . encoded_by_id AS encoded_by_id_20 , c0_ . checked_by_id AS checked_by_id_21 , c0_ . inspected_by_id AS inspected_by_id_22 , c0_ . visual_grade_id AS visual_grade_id_23 , c0_ . status_id AS status_id_24 , c0_ . unit_id AS unit_id_25 FROM copper_bundles c0_ WHERE c0_ . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ORDER BY c0_ . nb_sheets DESC
Parameters :
[
40
48
79
9
60
101
98
111
39
52
77
8
7
108
1
54
12
38
72
82
]
SELECT
c0_ . id AS id_0 ,
c0_ . production_date AS production_date_1 ,
c0_ . bundle_number AS bundle_number_2 ,
c0_ . mine_bundle_code AS mine_bundle_code_3 ,
c0_ . bundle_lot_number AS bundle_lot_number_4 ,
c0_ . bundle_lot_range AS bundle_lot_range_5 ,
c0_ . bundle_lot_code AS bundle_lot_code_6 ,
c0_ . net_weight AS net_weight_7 ,
c0_ . nb_sheets AS nb_sheets_8 ,
c0_ . auto_stripping AS auto_stripping_9 ,
c0_ . comment AS comment_10 ,
c0_ . entry_date AS entry_date_11 ,
c0_ . shift AS shift_12 ,
c0_ . tare AS tare_13 ,
c0_ . washed AS washed_14 ,
c0_ . gross_weight AS gross_weight_15 ,
c0_ . seal1 AS seal1_16 ,
c0_ . seal2 AS seal2_17 ,
c0_ . net_weight_from_scale AS net_weight_from_scale_18 ,
c0_ . gross_weight_from_scale AS gross_weight_from_scale_19 ,
c0_ . encoded_by_id AS encoded_by_id_20 ,
c0_ . checked_by_id AS checked_by_id_21 ,
c0_ . inspected_by_id AS inspected_by_id_22 ,
c0_ . visual_grade_id AS visual_grade_id_23 ,
c0_ . status_id AS status_id_24 ,
c0_ . unit_id AS unit_id_25
FROM
copper_bundles c0_
WHERE
c0_ . id IN (
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ?
)
ORDER BY
c0_ . nb_sheets DESC
Copy
SELECT c0_ . id AS id_0 , c0_ . production_date AS production_date_1 , c0_ . bundle_number AS bundle_number_2 , c0_ . mine_bundle_code AS mine_bundle_code_3 , c0_ . bundle_lot_number AS bundle_lot_number_4 , c0_ . bundle_lot_range AS bundle_lot_range_5 , c0_ . bundle_lot_code AS bundle_lot_code_6 , c0_ . net_weight AS net_weight_7 , c0_ . nb_sheets AS nb_sheets_8 , c0_ . auto_stripping AS auto_stripping_9 , c0_ . comment AS comment_10 , c0_ . entry_date AS entry_date_11 , c0_ . shift AS shift_12 , c0_ . tare AS tare_13 , c0_ . washed AS washed_14 , c0_ . gross_weight AS gross_weight_15 , c0_ . seal1 AS seal1_16 , c0_ . seal2 AS seal2_17 , c0_ . net_weight_from_scale AS net_weight_from_scale_18 , c0_ . gross_weight_from_scale AS gross_weight_from_scale_19 , c0_ . encoded_by_id AS encoded_by_id_20 , c0_ . checked_by_id AS checked_by_id_21 , c0_ . inspected_by_id AS inspected_by_id_22 , c0_ . visual_grade_id AS visual_grade_id_23 , c0_ . status_id AS status_id_24 , c0_ . unit_id AS unit_id_25 FROM copper_bundles c0_ WHERE c0_ . id IN (40 , 48 , 79 , 9 , 60 , 101 , 98 , 111 , 39 , 52 , 77 , 8 , 7 , 108 , 1 , 54 , 12 , 38 , 72 , 82 ) ORDER BY c0_ . nb_sheets DESC ;
Copy
3
3.72 ms
SELECT count (* ) AS sclr_0 FROM copper_bundles c0_
SELECT count (* ) AS sclr_0 FROM copper_bundles c0_ ;
Copy
4
21.42 ms
SELECT t0 . id AS id_1 , t0 . username AS username_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . full_name AS full_name_5 , t0 . email AS email_6 , t0 . phone AS phone_7 , t0 . is_template AS is_template_8 , t0 . status_id AS status_id_9 , t0 . fonction_id AS fonction_id_10 , t0 . service_id AS service_id_11 FROM [user] t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . username AS username_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . full_name AS full_name_5 , t0 . email AS email_6 , t0 . phone AS phone_7 , t0 . is_template AS is_template_8 , t0 . status_id AS status_id_9 , t0 . fonction_id AS fonction_id_10 , t0 . service_id AS service_id_11 FROM [user] t0 WHERE t0 . id = 5 ;
Copy
5
7.86 ms
SELECT t0 . id AS id_1 , t0 . username AS username_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . full_name AS full_name_5 , t0 . email AS email_6 , t0 . phone AS phone_7 , t0 . is_template AS is_template_8 , t0 . status_id AS status_id_9 , t0 . fonction_id AS fonction_id_10 , t0 . service_id AS service_id_11 FROM [user] t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . username AS username_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . full_name AS full_name_5 , t0 . email AS email_6 , t0 . phone AS phone_7 , t0 . is_template AS is_template_8 , t0 . status_id AS status_id_9 , t0 . fonction_id AS fonction_id_10 , t0 . service_id AS service_id_11 FROM [user] t0 WHERE t0 . id = 7 ;
Copy
6
22.69 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . type AS type_4 FROM list_bundle_grades t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . type AS type_4 FROM list_bundle_grades t0 WHERE t0 . id = 3 ;
Copy
7
4.58 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . value AS value_3 , t0 . description AS description_4 FROM list_status t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . value AS value_3 , t0 . description AS description_4 FROM list_status t0 WHERE t0 . id = 1 ;
Copy
8
0.73 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . code AS code_3 , t0 . short_name AS short_name_4 , t0 . ew_id AS ew_id_5 FROM list_unit t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . code AS code_3 , t0 . short_name AS short_name_4 , t0 . ew_id AS ew_id_5 FROM list_unit t0 WHERE t0 . id = 2 ;
Copy
9
18.32 ms
SELECT t0 . id AS id_1 , t0 . username AS username_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . full_name AS full_name_5 , t0 . email AS email_6 , t0 . phone AS phone_7 , t0 . is_template AS is_template_8 , t0 . status_id AS status_id_9 , t0 . fonction_id AS fonction_id_10 , t0 . service_id AS service_id_11 FROM [user] t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . username AS username_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . full_name AS full_name_5 , t0 . email AS email_6 , t0 . phone AS phone_7 , t0 . is_template AS is_template_8 , t0 . status_id AS status_id_9 , t0 . fonction_id AS fonction_id_10 , t0 . service_id AS service_id_11 FROM [user] t0 WHERE t0 . id = 6 ;
Copy
10
11.02 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . type AS type_4 FROM list_bundle_grades t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . type AS type_4 FROM list_bundle_grades t0 WHERE t0 . id = 4 ;
Copy
11
11.94 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . code AS code_3 , t0 . short_name AS short_name_4 , t0 . ew_id AS ew_id_5 FROM list_unit t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . code AS code_3 , t0 . short_name AS short_name_4 , t0 . ew_id AS ew_id_5 FROM list_unit t0 WHERE t0 . id = 3 ;
Copy
12
11.93 ms
SELECT t0 . id AS id_1 , t0 . username AS username_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . full_name AS full_name_5 , t0 . email AS email_6 , t0 . phone AS phone_7 , t0 . is_template AS is_template_8 , t0 . status_id AS status_id_9 , t0 . fonction_id AS fonction_id_10 , t0 . service_id AS service_id_11 FROM [user] t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . username AS username_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . full_name AS full_name_5 , t0 . email AS email_6 , t0 . phone AS phone_7 , t0 . is_template AS is_template_8 , t0 . status_id AS status_id_9 , t0 . fonction_id AS fonction_id_10 , t0 . service_id AS service_id_11 FROM [user] t0 WHERE t0 . id = 10 ;
Copy
13
6.87 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . code AS code_3 , t0 . short_name AS short_name_4 , t0 . ew_id AS ew_id_5 FROM list_unit t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . code AS code_3 , t0 . short_name AS short_name_4 , t0 . ew_id AS ew_id_5 FROM list_unit t0 WHERE t0 . id = 4 ;
Copy
14
18.18 ms
SELECT t0 . id AS id_1 , t0 . username AS username_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . full_name AS full_name_5 , t0 . email AS email_6 , t0 . phone AS phone_7 , t0 . is_template AS is_template_8 , t0 . status_id AS status_id_9 , t0 . fonction_id AS fonction_id_10 , t0 . service_id AS service_id_11 FROM [user] t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . username AS username_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . full_name AS full_name_5 , t0 . email AS email_6 , t0 . phone AS phone_7 , t0 . is_template AS is_template_8 , t0 . status_id AS status_id_9 , t0 . fonction_id AS fonction_id_10 , t0 . service_id AS service_id_11 FROM [user] t0 WHERE t0 . id = 37 ;
Copy
15
12.60 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . value AS value_3 , t0 . description AS description_4 FROM list_status t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . value AS value_3 , t0 . description AS description_4 FROM list_status t0 WHERE t0 . id = 2 ;
Copy
16
1.19 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . code AS code_3 , t0 . short_name AS short_name_4 , t0 . ew_id AS ew_id_5 FROM list_unit t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . code AS code_3 , t0 . short_name AS short_name_4 , t0 . ew_id AS ew_id_5 FROM list_unit t0 WHERE t0 . id = 1 ;
Copy
17
4.08 ms
SELECT t0 . id AS id_1 , t0 . username AS username_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . full_name AS full_name_5 , t0 . email AS email_6 , t0 . phone AS phone_7 , t0 . is_template AS is_template_8 , t0 . status_id AS status_id_9 , t0 . fonction_id AS fonction_id_10 , t0 . service_id AS service_id_11 FROM [user] t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . username AS username_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . full_name AS full_name_5 , t0 . email AS email_6 , t0 . phone AS phone_7 , t0 . is_template AS is_template_8 , t0 . status_id AS status_id_9 , t0 . fonction_id AS fonction_id_10 , t0 . service_id AS service_id_11 FROM [user] t0 WHERE t0 . id = 11 ;
Copy
18
12.31 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . type AS type_4 FROM list_bundle_grades t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . type AS type_4 FROM list_bundle_grades t0 WHERE t0 . id = 2 ;
Copy
19
28.86 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . code AS code_3 , t0 . short_name AS short_name_4 , t0 . ew_id AS ew_id_5 FROM list_unit t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . code AS code_3 , t0 . short_name AS short_name_4 , t0 . ew_id AS ew_id_5 FROM list_unit t0 WHERE t0 . id = 5 ;
Copy
20
30.06 ms
SELECT t0 . id AS id_1 , t0 . username AS username_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . full_name AS full_name_5 , t0 . email AS email_6 , t0 . phone AS phone_7 , t0 . is_template AS is_template_8 , t0 . status_id AS status_id_9 , t0 . fonction_id AS fonction_id_10 , t0 . service_id AS service_id_11 FROM [user] t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . username AS username_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . full_name AS full_name_5 , t0 . email AS email_6 , t0 . phone AS phone_7 , t0 . is_template AS is_template_8 , t0 . status_id AS status_id_9 , t0 . fonction_id AS fonction_id_10 , t0 . service_id AS service_id_11 FROM [user] t0 WHERE t0 . id = 9 ;
Copy
21
8.43 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . type AS type_4 FROM list_bundle_grades t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . type AS type_4 FROM list_bundle_grades t0 WHERE t0 . id = 1 ;
Copy
22
16.46 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . type AS type_4 FROM list_bundle_grades t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . type AS type_4 FROM list_bundle_grades t0 WHERE t0 . id = 5 ;
Copy
23
21.70 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . type AS type_4 FROM list_bundle_grades t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . type AS type_4 FROM list_bundle_grades t0 WHERE t0 . id = 6 ;
Copy