1
4.25 ms
SELECT DISTINCT w0_ . price_id AS price_id_0 , w0_ . work_id AS sclr_1 FROM work_prices w0_ LEFT JOIN work_works w1_ ON w0_ . work_id = w1_ . work_id AND (w1_ . deleted_at IS NULL ) WHERE (w0_ . deleted_at IS NULL ) ORDER BY w0_ . work_id DESC LIMIT 20
SELECT DISTINCT w0_ . price_id AS price_id_0 , w0_ . work_id AS sclr_1 FROM work_prices w0_ LEFT JOIN work_works w1_ ON w0_ . work_id = w1_ . work_id AND (w1_ . deleted_at IS NULL ) WHERE (w0_ . deleted_at IS NULL ) ORDER BY w0_ . work_id DESC LIMIT 20 ;
Copy
2
0.85 ms
SELECT w0_ . price_id AS price_id_0 , w0_ . created_at AS created_at_1 , w0_ . deleted_at AS deleted_at_2 , w0_ . key AS key_3 , w0_ . price AS price_4 , w0_ . current AS current_5 , w0_ . work_id AS work_id_6 FROM work_prices w0_ LEFT JOIN work_works w1_ ON w0_ . work_id = w1_ . work_id AND (w1_ . deleted_at IS NULL ) WHERE (w0_ . price_id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )) AND (w0_ . deleted_at IS NULL ) ORDER BY w0_ . work_id DESC
Parameters :
[
30
29
28
27
26
25
24
23
22
21
20
19
18
17
16
15
14
13
12
11
]
SELECT w0_ . price_id AS price_id_0 , w0_ . created_at AS created_at_1 , w0_ . deleted_at AS deleted_at_2 , w0_ . key AS key_3 , w0_ . price AS price_4 , w0_ . current AS current_5 , w0_ . work_id AS work_id_6 FROM work_prices w0_ LEFT JOIN work_works w1_ ON w0_ . work_id = w1_ . work_id AND (w1_ . deleted_at IS NULL ) WHERE (w0_ . price_id IN (30 , 29 , 28 , 27 , 26 , 25 , 24 , 23 , 22 , 21 , 20 , 19 , 18 , 17 , 16 , 15 , 14 , 13 , 12 , 11 )) AND (w0_ . deleted_at IS NULL ) ORDER BY w0_ . work_id DESC ;
Copy
3
0.42 ms
SELECT count (DISTINCT w0_ . price_id ) AS sclr_0 FROM work_prices w0_ LEFT JOIN work_works w1_ ON w0_ . work_id = w1_ . work_id AND (w1_ . deleted_at IS NULL ) WHERE (w0_ . deleted_at IS NULL )
SELECT count (DISTINCT w0_ . price_id ) AS sclr_0 FROM work_prices w0_ LEFT JOIN work_works w1_ ON w0_ . work_id = w1_ . work_id AND (w1_ . deleted_at IS NULL ) WHERE (w0_ . deleted_at IS NULL );
Copy
4
0.25 ms
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = 30 AND ((t0 . deleted_at IS NULL ));
Copy
5
0.24 ms
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = 29 AND ((t0 . deleted_at IS NULL ));
Copy
6
0.22 ms
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = 28 AND ((t0 . deleted_at IS NULL ));
Copy
7
0.24 ms
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = 27 AND ((t0 . deleted_at IS NULL ));
Copy
8
0.24 ms
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = 26 AND ((t0 . deleted_at IS NULL ));
Copy
9
0.23 ms
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = 25 AND ((t0 . deleted_at IS NULL ));
Copy
10
0.23 ms
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = 24 AND ((t0 . deleted_at IS NULL ));
Copy
11
0.33 ms
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = 23 AND ((t0 . deleted_at IS NULL ));
Copy
12
0.33 ms
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = 22 AND ((t0 . deleted_at IS NULL ));
Copy
13
0.33 ms
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = 21 AND ((t0 . deleted_at IS NULL ));
Copy
14
0.33 ms
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = 20 AND ((t0 . deleted_at IS NULL ));
Copy
15
0.26 ms
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = 19 AND ((t0 . deleted_at IS NULL ));
Copy
16
0.39 ms
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = 18 AND ((t0 . deleted_at IS NULL ));
Copy
17
0.33 ms
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = 17 AND ((t0 . deleted_at IS NULL ));
Copy
18
0.41 ms
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = 16 AND ((t0 . deleted_at IS NULL ));
Copy
19
0.33 ms
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = 15 AND ((t0 . deleted_at IS NULL ));
Copy
20
0.27 ms
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = 14 AND ((t0 . deleted_at IS NULL ));
Copy
21
0.33 ms
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = 13 AND ((t0 . deleted_at IS NULL ));
Copy
22
0.33 ms
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = 12 AND ((t0 . deleted_at IS NULL ));
Copy
23
0.41 ms
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . work_id AS work_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . key AS key_4 , t0 . name AS name_5 , t0 . type_id AS type_id_6 , t0 . group_id AS group_id_7 FROM work_works t0 WHERE t0 . work_id = 11 AND ((t0 . deleted_at IS NULL ));
Copy