1
1.61 ms
SELECT DISTINCT u0_ . id AS id_0 , u0_ . id AS id_1 FROM `user` u0_ ORDER BY u0_ . id DESC LIMIT 20
SELECT DISTINCT u0_ . id AS id_0 , u0_ . id AS id_1 FROM `user` u0_ ORDER BY u0_ . id DESC LIMIT 20 ;
Copy
2
0.94 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_ . id DESC
Parameters :
[
38
37
35
34
31
29
28
25
24
23
22
13
10
6
4
3
1
]
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 (38 , 37 , 35 , 34 , 31 , 29 , 28 , 25 , 24 , 23 , 22 , 13 , 10 , 6 , 4 , 3 , 1 ) ORDER BY u0_ . id DESC ;
Copy
3
0.66 ms
SELECT count (* ) AS sclr_0 FROM `user` u0_
SELECT count (* ) AS sclr_0 FROM `user` u0_ ;
Copy
4
1.05 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
5
0.88 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
1.04 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
7
1.03 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
8
0.74 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
9
0.75 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
10
0.68 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
0.72 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
12
0.53 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
13
0.65 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
14
0.53 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
15
0.52 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
16
0.53 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
17
0.50 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
18
0.52 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
19
0.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 = 3 ;
Copy
20
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