1
3.37 ms
SELECT DISTINCT p0_ . project_item_id AS project_item_id_0 FROM project_projects_items p0_ WHERE (p0_ . deleted_at IS NULL ) LIMIT 20
SELECT DISTINCT p0_ . project_item_id AS project_item_id_0 FROM project_projects_items p0_ WHERE (p0_ . deleted_at IS NULL ) LIMIT 20 ;
Copy
2
0.54 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 )
Parameters :
[
1
2
3
4
5
6
7
8
9
10
11
12
13
15
]
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 (1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10 , 11 , 12 , 13 , 15 )) AND (p0_ . deleted_at IS NULL );
Copy
3
0.42 ms
SELECT count (* ) AS sclr_0 FROM project_projects_items p0_ WHERE (p0_ . deleted_at IS NULL )
SELECT count (* ) AS sclr_0 FROM project_projects_items p0_ WHERE (p0_ . deleted_at IS NULL );
Copy
4
0.93 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
5
0.69 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
6
1.48 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_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_id = 1 AND ((t0 . deleted_at IS NULL ));
Copy
7
0.49 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
8
0.45 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_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_id = 2 AND ((t0 . deleted_at IS NULL ));
Copy
9
0.48 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 = 14 AND ((t0 . deleted_at IS NULL ));
Copy
10
0.44 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_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_id = 3 AND ((t0 . deleted_at IS NULL ));
Copy
11
0.43 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_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_id = 4 AND ((t0 . deleted_at IS NULL ));
Copy
12
0.50 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 = 10 AND ((t0 . deleted_at IS NULL ));
Copy
13
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_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_id = 5 AND ((t0 . deleted_at IS NULL ));
Copy
14
0.43 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
15
0.39 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_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_id = 6 AND ((t0 . deleted_at IS NULL ));
Copy
16
0.43 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 = 15 AND ((t0 . deleted_at IS NULL ));
Copy
17
0.46 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_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_id = 7 AND ((t0 . deleted_at IS NULL ));
Copy
18
0.46 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 = 16 AND ((t0 . deleted_at IS NULL ));
Copy
19
0.44 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_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_id = 8 AND ((t0 . deleted_at IS NULL ));
Copy
20
0.47 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
21
0.46 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_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_id = 9 AND ((t0 . deleted_at IS NULL ));
Copy
22
0.43 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_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_id = 10 AND ((t0 . deleted_at IS NULL ));
Copy
23
0.48 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 = 13 AND ((t0 . deleted_at IS NULL ));
Copy
24
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_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_id = 11 AND ((t0 . deleted_at IS NULL ));
Copy
25
0.47 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 = 18 AND ((t0 . deleted_at IS NULL ));
Copy
26
0.44 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_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_id = 12 AND ((t0 . deleted_at IS NULL ));
Copy
27
0.51 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
28
0.39 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_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_id = 13 AND ((t0 . deleted_at IS NULL ));
Copy
29
0.48 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
30
0.44 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_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_id = 15 AND ((t0 . deleted_at IS NULL ));
Copy