1
4.04 ms
SELECT DISTINCT s0_ . parameter_id AS parameter_id_0 FROM statement_parameters s0_ WHERE (s0_ . deleted_at IS NULL ) LIMIT 20 OFFSET 20
SELECT DISTINCT s0_ . parameter_id AS parameter_id_0 FROM statement_parameters s0_ WHERE (s0_ . deleted_at IS NULL ) LIMIT 20 OFFSET 20 ;
Copy
2
0.59 ms
SELECT s0_ . parameter_id AS parameter_id_0 , s0_ . created_at AS created_at_1 , s0_ . deleted_at AS deleted_at_2 , s0_ . name AS name_3 , s0_ . key AS key_4 , s0_ . parameter_type_id AS parameter_type_id_5 , s0_ . unit_id AS unit_id_6 , s0_ . formula_id AS formula_id_7 , s0_ . calculate_parameter_id AS calculate_parameter_id_8 FROM statement_parameters s0_ WHERE (s0_ . parameter_id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )) AND (s0_ . deleted_at IS NULL )
Parameters :
[
21
22
23
24
25
26
27
28
29
30
31
32
]
SELECT s0_ . parameter_id AS parameter_id_0 , s0_ . created_at AS created_at_1 , s0_ . deleted_at AS deleted_at_2 , s0_ . name AS name_3 , s0_ . key AS key_4 , s0_ . parameter_type_id AS parameter_type_id_5 , s0_ . unit_id AS unit_id_6 , s0_ . formula_id AS formula_id_7 , s0_ . calculate_parameter_id AS calculate_parameter_id_8 FROM statement_parameters s0_ WHERE (s0_ . parameter_id IN (21 , 22 , 23 , 24 , 25 , 26 , 27 , 28 , 29 , 30 , 31 , 32 )) AND (s0_ . deleted_at IS NULL );
Copy
3
0.40 ms
SELECT count (* ) AS sclr_0 FROM statement_parameters s0_ WHERE (s0_ . deleted_at IS NULL )
SELECT count (* ) AS sclr_0 FROM statement_parameters s0_ WHERE (s0_ . deleted_at IS NULL );
Copy
4
0.88 ms
SELECT t0 . parameter_type_id AS parameter_type_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 FROM statement_parameters_types t0 WHERE t0 . parameter_type_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . parameter_type_id AS parameter_type_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 FROM statement_parameters_types t0 WHERE t0 . parameter_type_id = 2 AND ((t0 . deleted_at IS NULL ));
Copy
5
0.62 ms
SELECT t0 . formula_id AS formula_id_1 , t0 . class AS class_2 , t0 . created_at AS created_at_3 , t0 . deleted_at AS deleted_at_4 , t0 . name AS name_5 FROM statement_formulas t0 WHERE t0 . formula_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . formula_id AS formula_id_1 , t0 . class AS class_2 , t0 . created_at AS created_at_3 , t0 . deleted_at AS deleted_at_4 , t0 . name AS name_5 FROM statement_formulas t0 WHERE t0 . formula_id = 5 AND ((t0 . deleted_at IS NULL ));
Copy
6
2.14 ms
SELECT t0 . prop_id AS prop_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . prop_type_id AS prop_type_id_6 FROM statement_props t0 INNER JOIN statement_parameters_items_props ON t0 . prop_id = statement_parameters_items_props . prop_id WHERE statement_parameters_items_props . parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . prop_id AS prop_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . prop_type_id AS prop_type_id_6 FROM statement_props t0 INNER JOIN statement_parameters_items_props ON t0 . prop_id = statement_parameters_items_props . prop_id WHERE statement_parameters_items_props . parameter_id = 21 AND ((t0 . deleted_at IS NULL ));
Copy
7
0.49 ms
SELECT t0 . formula_id AS formula_id_1 , t0 . class AS class_2 , t0 . created_at AS created_at_3 , t0 . deleted_at AS deleted_at_4 , t0 . name AS name_5 FROM statement_formulas t0 WHERE t0 . formula_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . formula_id AS formula_id_1 , t0 . class AS class_2 , t0 . created_at AS created_at_3 , t0 . deleted_at AS deleted_at_4 , t0 . name AS name_5 FROM statement_formulas t0 WHERE t0 . formula_id = 2 AND ((t0 . deleted_at IS NULL ));
Copy
8
0.66 ms
SELECT t0 . prop_id AS prop_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . prop_type_id AS prop_type_id_6 FROM statement_props t0 INNER JOIN statement_parameters_items_props ON t0 . prop_id = statement_parameters_items_props . prop_id WHERE statement_parameters_items_props . parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . prop_id AS prop_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . prop_type_id AS prop_type_id_6 FROM statement_props t0 INNER JOIN statement_parameters_items_props ON t0 . prop_id = statement_parameters_items_props . prop_id WHERE statement_parameters_items_props . parameter_id = 22 AND ((t0 . deleted_at IS NULL ));
Copy
9
0.38 ms
SELECT t0 . parameter_type_id AS parameter_type_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 FROM statement_parameters_types t0 WHERE t0 . parameter_type_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . parameter_type_id AS parameter_type_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 FROM statement_parameters_types t0 WHERE t0 . parameter_type_id = 1 AND ((t0 . deleted_at IS NULL ));
Copy
10
0.35 ms
SELECT t0 . formula_id AS formula_id_1 , t0 . class AS class_2 , t0 . created_at AS created_at_3 , t0 . deleted_at AS deleted_at_4 , t0 . name AS name_5 FROM statement_formulas t0 WHERE t0 . formula_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . formula_id AS formula_id_1 , t0 . class AS class_2 , t0 . created_at AS created_at_3 , t0 . deleted_at AS deleted_at_4 , t0 . name AS name_5 FROM statement_formulas t0 WHERE t0 . formula_id = 3 AND ((t0 . deleted_at IS NULL ));
Copy
11
0.64 ms
SELECT t0 . prop_id AS prop_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . prop_type_id AS prop_type_id_6 FROM statement_props t0 INNER JOIN statement_parameters_items_props ON t0 . prop_id = statement_parameters_items_props . prop_id WHERE statement_parameters_items_props . parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . prop_id AS prop_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . prop_type_id AS prop_type_id_6 FROM statement_props t0 INNER JOIN statement_parameters_items_props ON t0 . prop_id = statement_parameters_items_props . prop_id WHERE statement_parameters_items_props . parameter_id = 23 AND ((t0 . deleted_at IS NULL ));
Copy
12
0.54 ms
SELECT t0 . parameter_id AS parameter_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . parameter_type_id AS parameter_type_id_6 , t0 . unit_id AS unit_id_7 , t0 . formula_id AS formula_id_8 , t0 . calculate_parameter_id AS calculate_parameter_id_9 FROM statement_parameters t0 WHERE t0 . parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . parameter_id AS parameter_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . parameter_type_id AS parameter_type_id_6 , t0 . unit_id AS unit_id_7 , t0 . formula_id AS formula_id_8 , t0 . calculate_parameter_id AS calculate_parameter_id_9 FROM statement_parameters t0 WHERE t0 . parameter_id = 1 AND ((t0 . deleted_at IS NULL ));
Copy
13
0.60 ms
SELECT t0 . prop_id AS prop_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . prop_type_id AS prop_type_id_6 FROM statement_props t0 INNER JOIN statement_parameters_items_props ON t0 . prop_id = statement_parameters_items_props . prop_id WHERE statement_parameters_items_props . parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . prop_id AS prop_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . prop_type_id AS prop_type_id_6 FROM statement_props t0 INNER JOIN statement_parameters_items_props ON t0 . prop_id = statement_parameters_items_props . prop_id WHERE statement_parameters_items_props . parameter_id = 24 AND ((t0 . deleted_at IS NULL ));
Copy
14
0.43 ms
SELECT t0 . parameter_id AS parameter_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . parameter_type_id AS parameter_type_id_6 , t0 . unit_id AS unit_id_7 , t0 . formula_id AS formula_id_8 , t0 . calculate_parameter_id AS calculate_parameter_id_9 FROM statement_parameters t0 WHERE t0 . parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . parameter_id AS parameter_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . parameter_type_id AS parameter_type_id_6 , t0 . unit_id AS unit_id_7 , t0 . formula_id AS formula_id_8 , t0 . calculate_parameter_id AS calculate_parameter_id_9 FROM statement_parameters t0 WHERE t0 . parameter_id = 6 AND ((t0 . deleted_at IS NULL ));
Copy
15
0.60 ms
SELECT t0 . prop_id AS prop_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . prop_type_id AS prop_type_id_6 FROM statement_props t0 INNER JOIN statement_parameters_items_props ON t0 . prop_id = statement_parameters_items_props . prop_id WHERE statement_parameters_items_props . parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . prop_id AS prop_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . prop_type_id AS prop_type_id_6 FROM statement_props t0 INNER JOIN statement_parameters_items_props ON t0 . prop_id = statement_parameters_items_props . prop_id WHERE statement_parameters_items_props . parameter_id = 25 AND ((t0 . deleted_at IS NULL ));
Copy
16
0.33 ms
SELECT t0 . formula_id AS formula_id_1 , t0 . class AS class_2 , t0 . created_at AS created_at_3 , t0 . deleted_at AS deleted_at_4 , t0 . name AS name_5 FROM statement_formulas t0 WHERE t0 . formula_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . formula_id AS formula_id_1 , t0 . class AS class_2 , t0 . created_at AS created_at_3 , t0 . deleted_at AS deleted_at_4 , t0 . name AS name_5 FROM statement_formulas t0 WHERE t0 . formula_id = 7 AND ((t0 . deleted_at IS NULL ));
Copy
17
0.56 ms
SELECT t0 . prop_id AS prop_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . prop_type_id AS prop_type_id_6 FROM statement_props t0 INNER JOIN statement_parameters_items_props ON t0 . prop_id = statement_parameters_items_props . prop_id WHERE statement_parameters_items_props . parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . prop_id AS prop_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . prop_type_id AS prop_type_id_6 FROM statement_props t0 INNER JOIN statement_parameters_items_props ON t0 . prop_id = statement_parameters_items_props . prop_id WHERE statement_parameters_items_props . parameter_id = 26 AND ((t0 . deleted_at IS NULL ));
Copy
18
0.58 ms
SELECT t0 . prop_id AS prop_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . prop_type_id AS prop_type_id_6 FROM statement_props t0 INNER JOIN statement_parameters_items_props ON t0 . prop_id = statement_parameters_items_props . prop_id WHERE statement_parameters_items_props . parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . prop_id AS prop_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . prop_type_id AS prop_type_id_6 FROM statement_props t0 INNER JOIN statement_parameters_items_props ON t0 . prop_id = statement_parameters_items_props . prop_id WHERE statement_parameters_items_props . parameter_id = 27 AND ((t0 . deleted_at IS NULL ));
Copy
19
0.59 ms
SELECT t0 . prop_id AS prop_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . prop_type_id AS prop_type_id_6 FROM statement_props t0 INNER JOIN statement_parameters_items_props ON t0 . prop_id = statement_parameters_items_props . prop_id WHERE statement_parameters_items_props . parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . prop_id AS prop_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . prop_type_id AS prop_type_id_6 FROM statement_props t0 INNER JOIN statement_parameters_items_props ON t0 . prop_id = statement_parameters_items_props . prop_id WHERE statement_parameters_items_props . parameter_id = 28 AND ((t0 . deleted_at IS NULL ));
Copy
20
0.52 ms
SELECT t0 . parameter_id AS parameter_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . parameter_type_id AS parameter_type_id_6 , t0 . unit_id AS unit_id_7 , t0 . formula_id AS formula_id_8 , t0 . calculate_parameter_id AS calculate_parameter_id_9 FROM statement_parameters t0 WHERE t0 . parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . parameter_id AS parameter_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . parameter_type_id AS parameter_type_id_6 , t0 . unit_id AS unit_id_7 , t0 . formula_id AS formula_id_8 , t0 . calculate_parameter_id AS calculate_parameter_id_9 FROM statement_parameters t0 WHERE t0 . parameter_id = 3 AND ((t0 . deleted_at IS NULL ));
Copy
21
0.59 ms
SELECT t0 . prop_id AS prop_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . prop_type_id AS prop_type_id_6 FROM statement_props t0 INNER JOIN statement_parameters_items_props ON t0 . prop_id = statement_parameters_items_props . prop_id WHERE statement_parameters_items_props . parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . prop_id AS prop_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . prop_type_id AS prop_type_id_6 FROM statement_props t0 INNER JOIN statement_parameters_items_props ON t0 . prop_id = statement_parameters_items_props . prop_id WHERE statement_parameters_items_props . parameter_id = 29 AND ((t0 . deleted_at IS NULL ));
Copy
22
0.69 ms
SELECT t0 . prop_id AS prop_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . prop_type_id AS prop_type_id_6 FROM statement_props t0 INNER JOIN statement_parameters_items_props ON t0 . prop_id = statement_parameters_items_props . prop_id WHERE statement_parameters_items_props . parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . prop_id AS prop_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . prop_type_id AS prop_type_id_6 FROM statement_props t0 INNER JOIN statement_parameters_items_props ON t0 . prop_id = statement_parameters_items_props . prop_id WHERE statement_parameters_items_props . parameter_id = 30 AND ((t0 . deleted_at IS NULL ));
Copy
23
0.73 ms
SELECT t0 . prop_id AS prop_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . prop_type_id AS prop_type_id_6 FROM statement_props t0 INNER JOIN statement_parameters_items_props ON t0 . prop_id = statement_parameters_items_props . prop_id WHERE statement_parameters_items_props . parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . prop_id AS prop_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . prop_type_id AS prop_type_id_6 FROM statement_props t0 INNER JOIN statement_parameters_items_props ON t0 . prop_id = statement_parameters_items_props . prop_id WHERE statement_parameters_items_props . parameter_id = 31 AND ((t0 . deleted_at IS NULL ));
Copy
24
0.68 ms
SELECT t0 . prop_id AS prop_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . prop_type_id AS prop_type_id_6 FROM statement_props t0 INNER JOIN statement_parameters_items_props ON t0 . prop_id = statement_parameters_items_props . prop_id WHERE statement_parameters_items_props . parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . prop_id AS prop_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . name AS name_4 , t0 . key AS key_5 , t0 . prop_type_id AS prop_type_id_6 FROM statement_props t0 INNER JOIN statement_parameters_items_props ON t0 . prop_id = statement_parameters_items_props . prop_id WHERE statement_parameters_items_props . parameter_id = 32 AND ((t0 . deleted_at IS NULL ));
Copy