1
5.87 ms
SELECT DISTINCT u0_ . id AS id_0 , u0_ . name AS name_1 FROM `user` u0_ ORDER BY u0_ . name ASC LIMIT 20
SELECT DISTINCT u0_ . id AS id_0 , u0_ . name AS name_1 FROM `user` u0_ ORDER BY u0_ . name ASC LIMIT 20 ;
Copy
2
6.08 ms
SELECT u0_ . id AS id_0 , u0_ . username AS username_1 , u0_ . roles AS roles_2 , u0_ . password AS password_3 , u0_ . name AS name_4 , u0_ . grade AS grade_5 , u0_ . company AS company_6 , u0_ . grade_level AS grade_level_7 FROM `user` u0_ WHERE u0_ . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ORDER BY u0_ . name ASC
Parameters :
[
25
37
29
3
35
10
28
6
1
4
24
38
34
22
23
13
31
]
SELECT u0_ . id AS id_0 , u0_ . username AS username_1 , u0_ . roles AS roles_2 , u0_ . password AS password_3 , u0_ . name AS name_4 , u0_ . grade AS grade_5 , u0_ . company AS company_6 , u0_ . grade_level AS grade_level_7 FROM `user` u0_ WHERE u0_ . id IN (25 , 37 , 29 , 3 , 35 , 10 , 28 , 6 , 1 , 4 , 24 , 38 , 34 , 22 , 23 , 13 , 31 ) ORDER BY u0_ . name ASC ;
Copy
3
2.23 ms
SELECT count (* ) AS sclr_0 FROM `user` u0_
SELECT count (* ) AS sclr_0 FROM `user` u0_ ;
Copy
4
8.94 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = 25 ;
Copy
5
5.67 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = 37 ;
Copy
6
2.92 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = 29 ;
Copy
7
6.61 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = 3 ;
Copy
8
2.47 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = 35 ;
Copy
9
6.51 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = 10 ;
Copy
10
4.31 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = 28 ;
Copy
11
4.02 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = 6 ;
Copy
12
0.73 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = 1 ;
Copy
13
6.69 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = 4 ;
Copy
14
3.87 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = 24 ;
Copy
15
2.43 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = 38 ;
Copy
16
6.34 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = 34 ;
Copy
17
4.99 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = 22 ;
Copy
18
2.27 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = 23 ;
Copy
19
8.71 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = 13 ;
Copy
20
0.66 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . title AS title_3 , t0 . region AS region_4 , t0 . comment AS comment_5 , t0 . image AS image_6 , t0 . pos_x AS pos_x_7 , t0 . pos_y AS pos_y_8 , t0 . display AS display_9 , t0 . creator_id AS creator_id_10 FROM marker t0 WHERE t0 . creator_id = 31 ;
Copy