1
4.17 ms
SELECT DISTINCT p0_ . project_item_parameter_value_id AS project_item_parameter_value_id_0 , p0_ . integer AS integer_1 FROM project_items_parameters_values p0_ WHERE (p0_ . deleted_at IS NULL ) ORDER BY p0_ . integer ASC LIMIT 20 OFFSET 40
SELECT DISTINCT p0_ . project_item_parameter_value_id AS project_item_parameter_value_id_0 , p0_ . integer AS integer_1 FROM project_items_parameters_values p0_ WHERE (p0_ . deleted_at IS NULL ) ORDER BY p0_ . integer ASC LIMIT 20 OFFSET 40 ;
Copy
2
0.94 ms
SELECT p0_ . project_item_parameter_value_id AS project_item_parameter_value_id_0 , p0_ . created_at AS created_at_1 , p0_ . deleted_at AS deleted_at_2 , p0_ . string AS string_3 , p0_ . integer AS integer_4 , p0_ . float AS float_5 , p0_ . boolean AS boolean_6 , p0_ . project_item_parameter_id AS project_item_parameter_id_7 , p0_ . value_id AS value_id_8 , p0_ . enum_value_id AS enum_value_id_9 FROM project_items_parameters_values p0_ WHERE (p0_ . project_item_parameter_value_id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )) AND (p0_ . deleted_at IS NULL ) ORDER BY p0_ . integer ASC
Parameters :
[
41
42
43
44
45
46
47
48
49
50
51
52
]
SELECT p0_ . project_item_parameter_value_id AS project_item_parameter_value_id_0 , p0_ . created_at AS created_at_1 , p0_ . deleted_at AS deleted_at_2 , p0_ . string AS string_3 , p0_ . integer AS integer_4 , p0_ . float AS float_5 , p0_ . boolean AS boolean_6 , p0_ . project_item_parameter_id AS project_item_parameter_id_7 , p0_ . value_id AS value_id_8 , p0_ . enum_value_id AS enum_value_id_9 FROM project_items_parameters_values p0_ WHERE (p0_ . project_item_parameter_value_id IN (41 , 42 , 43 , 44 , 45 , 46 , 47 , 48 , 49 , 50 , 51 , 52 )) AND (p0_ . deleted_at IS NULL ) ORDER BY p0_ . integer ASC ;
Copy
3
0.59 ms
SELECT count (* ) AS sclr_0 FROM project_items_parameters_values p0_ WHERE (p0_ . deleted_at IS NULL )
SELECT count (* ) AS sclr_0 FROM project_items_parameters_values p0_ WHERE (p0_ . deleted_at IS NULL );
Copy
4
1.35 ms
SELECT t0 . project_item_parameter_id AS project_item_parameter_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . project_item_id AS project_item_id_4 , t0 . parameter_id AS parameter_id_5 FROM project_projects_items_parameters t0 WHERE t0 . project_item_parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . project_item_parameter_id AS project_item_parameter_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . project_item_id AS project_item_id_4 , t0 . parameter_id AS parameter_id_5 FROM project_projects_items_parameters t0 WHERE t0 . project_item_parameter_id = 53 AND ((t0 . deleted_at IS NULL ));
Copy
5
1.56 ms
SELECT t0 . project_item_id AS project_item_id_1 , t0 . name AS name_2 , t0 . level AS level_3 , t0 . created_at AS created_at_4 , t0 . deleted_at AS deleted_at_5 , t0 . key AS key_6 , t0 . project_id AS project_id_7 , t0 . item_id AS item_id_8 , t0 . parent_id AS parent_id_9 FROM project_projects_items t0 WHERE t0 . project_item_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . project_item_id AS project_item_id_1 , t0 . name AS name_2 , t0 . level AS level_3 , t0 . created_at AS created_at_4 , t0 . deleted_at AS deleted_at_5 , t0 . key AS key_6 , t0 . project_id AS project_id_7 , t0 . item_id AS item_id_8 , t0 . parent_id AS parent_id_9 FROM project_projects_items t0 WHERE t0 . project_item_id = 1 AND ((t0 . deleted_at IS NULL ));
Copy
6
0.82 ms
SELECT t0 . project_id AS project_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 . updated_at AS updated_at_6 FROM project_projects t0 WHERE t0 . project_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . project_id AS project_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 . updated_at AS updated_at_6 FROM project_projects t0 WHERE t0 . project_id = 1 AND ((t0 . deleted_at IS NULL ));
Copy
7
0.82 ms
SELECT t0 . item_id AS item_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_items t0 WHERE t0 . item_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . item_id AS item_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_items t0 WHERE t0 . item_id = 1 AND ((t0 . deleted_at IS NULL ));
Copy
8
1.75 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 = 30 AND ((t0 . deleted_at IS NULL ));
Copy
9
0.70 ms
SELECT t0 . value_id AS value_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_values t0 WHERE t0 . value_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . value_id AS value_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_values t0 WHERE t0 . value_id = 2 AND ((t0 . deleted_at IS NULL ));
Copy
10
0.27 ms
SELECT t0 . project_item_parameter_id AS project_item_parameter_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . project_item_id AS project_item_id_4 , t0 . parameter_id AS parameter_id_5 FROM project_projects_items_parameters t0 WHERE t0 . project_item_parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . project_item_parameter_id AS project_item_parameter_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . project_item_id AS project_item_id_4 , t0 . parameter_id AS parameter_id_5 FROM project_projects_items_parameters t0 WHERE t0 . project_item_parameter_id = 54 AND ((t0 . deleted_at IS NULL ));
Copy
11
0.27 ms
SELECT t0 . project_item_id AS project_item_id_1 , t0 . name AS name_2 , t0 . level AS level_3 , t0 . created_at AS created_at_4 , t0 . deleted_at AS deleted_at_5 , t0 . key AS key_6 , t0 . project_id AS project_id_7 , t0 . item_id AS item_id_8 , t0 . parent_id AS parent_id_9 FROM project_projects_items t0 WHERE t0 . project_item_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . project_item_id AS project_item_id_1 , t0 . name AS name_2 , t0 . level AS level_3 , t0 . created_at AS created_at_4 , t0 . deleted_at AS deleted_at_5 , t0 . key AS key_6 , t0 . project_id AS project_id_7 , t0 . item_id AS item_id_8 , t0 . parent_id AS parent_id_9 FROM project_projects_items t0 WHERE t0 . project_item_id = 13 AND ((t0 . deleted_at IS NULL ));
Copy
12
0.36 ms
SELECT t0 . item_id AS item_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_items t0 WHERE t0 . item_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . item_id AS item_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_items t0 WHERE t0 . item_id = 6 AND ((t0 . deleted_at IS NULL ));
Copy
13
0.44 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
14
0.35 ms
SELECT t0 . value_id AS value_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_values t0 WHERE t0 . value_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . value_id AS value_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_values t0 WHERE t0 . value_id = 3 AND ((t0 . deleted_at IS NULL ));
Copy
15
0.47 ms
SELECT t0 . project_item_parameter_id AS project_item_parameter_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . project_item_id AS project_item_id_4 , t0 . parameter_id AS parameter_id_5 FROM project_projects_items_parameters t0 WHERE t0 . project_item_parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . project_item_parameter_id AS project_item_parameter_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . project_item_id AS project_item_id_4 , t0 . parameter_id AS parameter_id_5 FROM project_projects_items_parameters t0 WHERE t0 . project_item_parameter_id = 55 AND ((t0 . deleted_at IS NULL ));
Copy
16
0.50 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
17
0.38 ms
SELECT t0 . project_item_parameter_id AS project_item_parameter_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . project_item_id AS project_item_id_4 , t0 . parameter_id AS parameter_id_5 FROM project_projects_items_parameters t0 WHERE t0 . project_item_parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . project_item_parameter_id AS project_item_parameter_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . project_item_id AS project_item_id_4 , t0 . parameter_id AS parameter_id_5 FROM project_projects_items_parameters t0 WHERE t0 . project_item_parameter_id = 44 AND ((t0 . deleted_at IS NULL ));
Copy
18
0.38 ms
SELECT t0 . project_item_id AS project_item_id_1 , t0 . name AS name_2 , t0 . level AS level_3 , t0 . created_at AS created_at_4 , t0 . deleted_at AS deleted_at_5 , t0 . key AS key_6 , t0 . project_id AS project_id_7 , t0 . item_id AS item_id_8 , t0 . parent_id AS parent_id_9 FROM project_projects_items t0 WHERE t0 . project_item_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . project_item_id AS project_item_id_1 , t0 . name AS name_2 , t0 . level AS level_3 , t0 . created_at AS created_at_4 , t0 . deleted_at AS deleted_at_5 , t0 . key AS key_6 , t0 . project_id AS project_id_7 , t0 . item_id AS item_id_8 , t0 . parent_id AS parent_id_9 FROM project_projects_items t0 WHERE t0 . project_item_id = 9 AND ((t0 . deleted_at IS NULL ));
Copy
19
0.39 ms
SELECT t0 . item_id AS item_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_items t0 WHERE t0 . item_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . item_id AS item_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_items t0 WHERE t0 . item_id = 5 AND ((t0 . deleted_at IS NULL ));
Copy
20
0.40 ms
SELECT t0 . project_item_parameter_id AS project_item_parameter_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . project_item_id AS project_item_id_4 , t0 . parameter_id AS parameter_id_5 FROM project_projects_items_parameters t0 WHERE t0 . project_item_parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . project_item_parameter_id AS project_item_parameter_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . project_item_id AS project_item_id_4 , t0 . parameter_id AS parameter_id_5 FROM project_projects_items_parameters t0 WHERE t0 . project_item_parameter_id = 57 AND ((t0 . deleted_at IS NULL ));
Copy
21
0.36 ms
SELECT t0 . project_item_id AS project_item_id_1 , t0 . name AS name_2 , t0 . level AS level_3 , t0 . created_at AS created_at_4 , t0 . deleted_at AS deleted_at_5 , t0 . key AS key_6 , t0 . project_id AS project_id_7 , t0 . item_id AS item_id_8 , t0 . parent_id AS parent_id_9 FROM project_projects_items t0 WHERE t0 . project_item_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . project_item_id AS project_item_id_1 , t0 . name AS name_2 , t0 . level AS level_3 , t0 . created_at AS created_at_4 , t0 . deleted_at AS deleted_at_5 , t0 . key AS key_6 , t0 . project_id AS project_id_7 , t0 . item_id AS item_id_8 , t0 . parent_id AS parent_id_9 FROM project_projects_items t0 WHERE t0 . project_item_id = 15 AND ((t0 . deleted_at IS NULL ));
Copy
22
0.41 ms
SELECT t0 . item_id AS item_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_items t0 WHERE t0 . item_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . item_id AS item_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_items t0 WHERE t0 . item_id = 8 AND ((t0 . deleted_at IS NULL ));
Copy
23
0.35 ms
SELECT t0 . project_item_parameter_id AS project_item_parameter_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . project_item_id AS project_item_id_4 , t0 . parameter_id AS parameter_id_5 FROM project_projects_items_parameters t0 WHERE t0 . project_item_parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . project_item_parameter_id AS project_item_parameter_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . project_item_id AS project_item_id_4 , t0 . parameter_id AS parameter_id_5 FROM project_projects_items_parameters t0 WHERE t0 . project_item_parameter_id = 58 AND ((t0 . deleted_at IS NULL ));
Copy
24
0.36 ms
SELECT t0 . project_item_parameter_id AS project_item_parameter_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . project_item_id AS project_item_id_4 , t0 . parameter_id AS parameter_id_5 FROM project_projects_items_parameters t0 WHERE t0 . project_item_parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . project_item_parameter_id AS project_item_parameter_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . project_item_id AS project_item_id_4 , t0 . parameter_id AS parameter_id_5 FROM project_projects_items_parameters t0 WHERE t0 . project_item_parameter_id = 15 AND ((t0 . deleted_at IS NULL ));
Copy
25
0.36 ms
SELECT t0 . project_item_id AS project_item_id_1 , t0 . name AS name_2 , t0 . level AS level_3 , t0 . created_at AS created_at_4 , t0 . deleted_at AS deleted_at_5 , t0 . key AS key_6 , t0 . project_id AS project_id_7 , t0 . item_id AS item_id_8 , t0 . parent_id AS parent_id_9 FROM project_projects_items t0 WHERE t0 . project_item_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . project_item_id AS project_item_id_1 , t0 . name AS name_2 , t0 . level AS level_3 , t0 . created_at AS created_at_4 , t0 . deleted_at AS deleted_at_5 , t0 . key AS key_6 , t0 . project_id AS project_id_7 , t0 . item_id AS item_id_8 , t0 . parent_id AS parent_id_9 FROM project_projects_items t0 WHERE t0 . project_item_id = 2 AND ((t0 . deleted_at IS NULL ));
Copy
26
0.39 ms
SELECT t0 . item_id AS item_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_items t0 WHERE t0 . item_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . item_id AS item_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_items t0 WHERE t0 . item_id = 2 AND ((t0 . deleted_at IS NULL ));
Copy