1
4.34 ms
SELECT DISTINCT c0_ . id AS id_0 , c0_ . gross_weight AS gross_weight_1 FROM copper_bundles c0_ ORDER BY c0_ . gross_weight ASC OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY
SELECT DISTINCT c0_ . id AS id_0 , c0_ . gross_weight AS gross_weight_1 FROM copper_bundles c0_ ORDER BY c0_ . gross_weight ASC OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY ;
Copy
2
3.50 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_ . gross_weight ASC
Parameters :
[
24
16
111
77
4
38
97
5
106
42
91
78
56
54
40
8
32
25
22
11
]
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_ . gross_weight ASC
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 (24 , 16 , 111 , 77 , 4 , 38 , 97 , 5 , 106 , 42 , 91 , 78 , 56 , 54 , 40 , 8 , 32 , 25 , 22 , 11 ) ORDER BY c0_ . gross_weight ASC ;
Copy
3
2.25 ms
SELECT count (* ) AS sclr_0 FROM copper_bundles c0_
SELECT count (* ) AS sclr_0 FROM copper_bundles c0_ ;
Copy
4
3.68 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
1.20 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
2.96 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
7
5.69 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
3.34 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
16.68 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
10
3.34 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
11
4.08 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
12
4.34 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
13
2.91 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
14
1.01 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
15
4.24 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
16
3.19 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
17
6.74 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
18
6.60 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
19
1.81 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
2.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 = 6 ;
Copy
21
8.36 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
22
5.47 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
23
0.52 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