1
0.98 ms
SELECT p0_ . project_id AS project_id_0 , p0_ . name AS name_1 FROM project_projects p0_ WHERE (p0_ . deleted_at IS NULL )
SELECT p0_ . project_id AS project_id_0 , p0_ . name AS name_1 FROM project_projects p0_ WHERE (p0_ . deleted_at IS NULL );
Copy
2
1.50 ms
SELECT p0_ . project_item_id AS project_item_id_0 , p0_ . name AS name_1 , p0_ . level AS level_2 , p0_ . created_at AS created_at_3 , p0_ . deleted_at AS deleted_at_4 , p0_ . key AS key_5 , p0_ . project_id AS project_id_6 , p0_ . item_id AS item_id_7 , p0_ . parent_id AS parent_id_8 FROM project_projects_items p0_ WHERE (p0_ . project_item_id IN (? )) AND (p0_ . deleted_at IS NULL )
SELECT p0_ . project_item_id AS project_item_id_0 , p0_ . name AS name_1 , p0_ . level AS level_2 , p0_ . created_at AS created_at_3 , p0_ . deleted_at AS deleted_at_4 , p0_ . key AS key_5 , p0_ . project_id AS project_id_6 , p0_ . item_id AS item_id_7 , p0_ . parent_id AS parent_id_8 FROM project_projects_items p0_ WHERE (p0_ . project_item_id IN ('6' )) AND (p0_ . deleted_at IS NULL );
Copy
3
1.66 ms
SELECT DISTINCT p0_ . project_item_parameter_id AS project_item_parameter_id_0 FROM project_projects_items_parameters p0_ WHERE (p0_ . project_item_id = (? )) AND (p0_ . deleted_at IS NULL ) LIMIT 20
SELECT DISTINCT p0_ . project_item_parameter_id AS project_item_parameter_id_0 FROM project_projects_items_parameters p0_ WHERE (p0_ . project_item_id = (6 )) AND (p0_ . deleted_at IS NULL ) LIMIT 20 ;
Copy
4
0.40 ms
SELECT p0_ . project_item_parameter_id AS project_item_parameter_id_0 , p0_ . created_at AS created_at_1 , p0_ . deleted_at AS deleted_at_2 , p0_ . project_item_id AS project_item_id_3 , p0_ . parameter_id AS parameter_id_4 FROM project_projects_items_parameters p0_ WHERE (p0_ . project_item_id = (? ) AND p0_ . project_item_parameter_id IN (? , ? , ? , ? , ? )) AND (p0_ . deleted_at IS NULL )
Parameters :
[
6
27
31
29
28
30
]
SELECT p0_ . project_item_parameter_id AS project_item_parameter_id_0 , p0_ . created_at AS created_at_1 , p0_ . deleted_at AS deleted_at_2 , p0_ . project_item_id AS project_item_id_3 , p0_ . parameter_id AS parameter_id_4 FROM project_projects_items_parameters p0_ WHERE (p0_ . project_item_id = (6 ) AND p0_ . project_item_parameter_id IN (27 , 31 , 29 , 28 , 30 )) AND (p0_ . deleted_at IS NULL );
Copy
5
0.29 ms
SELECT count (* ) AS sclr_0 FROM project_projects_items_parameters p0_ WHERE (p0_ . project_item_id = (? )) AND (p0_ . deleted_at IS NULL )
SELECT count (* ) AS sclr_0 FROM project_projects_items_parameters p0_ WHERE (p0_ . project_item_id = (6 )) AND (p0_ . deleted_at IS NULL );
Copy
6
0.23 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.44 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 = 9 AND ((t0 . deleted_at IS NULL ));
Copy
8
0.76 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
9
0.88 ms
SELECT t0 . project_item_parameter_value_id AS project_item_parameter_value_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . string AS string_4 , t0 . integer AS integer_5 , t0 . float AS float_6 , t0 . boolean AS boolean_7 , t0 . project_item_parameter_id AS project_item_parameter_id_8 , t0 . value_id AS value_id_9 , t0 . enum_value_id AS enum_value_id_10 FROM project_items_parameters_values t0 WHERE t0 . project_item_parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . project_item_parameter_value_id AS project_item_parameter_value_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . string AS string_4 , t0 . integer AS integer_5 , t0 . float AS float_6 , t0 . boolean AS boolean_7 , t0 . project_item_parameter_id AS project_item_parameter_id_8 , t0 . value_id AS value_id_9 , t0 . enum_value_id AS enum_value_id_10 FROM project_items_parameters_values t0 WHERE t0 . project_item_parameter_id = 27 AND ((t0 . deleted_at IS NULL ));
Copy
10
0.21 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 = 4 AND ((t0 . deleted_at IS NULL ));
Copy
11
0.24 ms
SELECT t0 . project_item_parameter_value_id AS project_item_parameter_value_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . string AS string_4 , t0 . integer AS integer_5 , t0 . float AS float_6 , t0 . boolean AS boolean_7 , t0 . project_item_parameter_id AS project_item_parameter_id_8 , t0 . value_id AS value_id_9 , t0 . enum_value_id AS enum_value_id_10 FROM project_items_parameters_values t0 WHERE t0 . project_item_parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . project_item_parameter_value_id AS project_item_parameter_value_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . string AS string_4 , t0 . integer AS integer_5 , t0 . float AS float_6 , t0 . boolean AS boolean_7 , t0 . project_item_parameter_id AS project_item_parameter_id_8 , t0 . value_id AS value_id_9 , t0 . enum_value_id AS enum_value_id_10 FROM project_items_parameters_values t0 WHERE t0 . project_item_parameter_id = 28 AND ((t0 . deleted_at IS NULL ));
Copy
12
0.35 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 = 5 AND ((t0 . deleted_at IS NULL ));
Copy
13
0.33 ms
SELECT t0 . project_item_parameter_value_id AS project_item_parameter_value_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . string AS string_4 , t0 . integer AS integer_5 , t0 . float AS float_6 , t0 . boolean AS boolean_7 , t0 . project_item_parameter_id AS project_item_parameter_id_8 , t0 . value_id AS value_id_9 , t0 . enum_value_id AS enum_value_id_10 FROM project_items_parameters_values t0 WHERE t0 . project_item_parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . project_item_parameter_value_id AS project_item_parameter_value_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . string AS string_4 , t0 . integer AS integer_5 , t0 . float AS float_6 , t0 . boolean AS boolean_7 , t0 . project_item_parameter_id AS project_item_parameter_id_8 , t0 . value_id AS value_id_9 , t0 . enum_value_id AS enum_value_id_10 FROM project_items_parameters_values t0 WHERE t0 . project_item_parameter_id = 29 AND ((t0 . deleted_at IS NULL ));
Copy
14
0.28 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 = 20 AND ((t0 . deleted_at IS NULL ));
Copy
15
0.30 ms
SELECT t0 . project_item_parameter_value_id AS project_item_parameter_value_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . string AS string_4 , t0 . integer AS integer_5 , t0 . float AS float_6 , t0 . boolean AS boolean_7 , t0 . project_item_parameter_id AS project_item_parameter_id_8 , t0 . value_id AS value_id_9 , t0 . enum_value_id AS enum_value_id_10 FROM project_items_parameters_values t0 WHERE t0 . project_item_parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . project_item_parameter_value_id AS project_item_parameter_value_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . string AS string_4 , t0 . integer AS integer_5 , t0 . float AS float_6 , t0 . boolean AS boolean_7 , t0 . project_item_parameter_id AS project_item_parameter_id_8 , t0 . value_id AS value_id_9 , t0 . enum_value_id AS enum_value_id_10 FROM project_items_parameters_values t0 WHERE t0 . project_item_parameter_id = 30 AND ((t0 . deleted_at IS NULL ));
Copy
16
0.27 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 = 21 AND ((t0 . deleted_at IS NULL ));
Copy
17
0.27 ms
SELECT t0 . project_item_parameter_value_id AS project_item_parameter_value_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . string AS string_4 , t0 . integer AS integer_5 , t0 . float AS float_6 , t0 . boolean AS boolean_7 , t0 . project_item_parameter_id AS project_item_parameter_id_8 , t0 . value_id AS value_id_9 , t0 . enum_value_id AS enum_value_id_10 FROM project_items_parameters_values t0 WHERE t0 . project_item_parameter_id = ? AND ((t0 . deleted_at IS NULL ))
SELECT t0 . project_item_parameter_value_id AS project_item_parameter_value_id_1 , t0 . created_at AS created_at_2 , t0 . deleted_at AS deleted_at_3 , t0 . string AS string_4 , t0 . integer AS integer_5 , t0 . float AS float_6 , t0 . boolean AS boolean_7 , t0 . project_item_parameter_id AS project_item_parameter_id_8 , t0 . value_id AS value_id_9 , t0 . enum_value_id AS enum_value_id_10 FROM project_items_parameters_values t0 WHERE t0 . project_item_parameter_id = 31 AND ((t0 . deleted_at IS NULL ));
Copy