1
7.79 ms
SELECT DISTINCT u0_ . id AS id_0 , u0_ . grade AS grade_1 FROM `user` u0_ ORDER BY u0_ . grade ASC LIMIT 20
SELECT DISTINCT u0_ . id AS id_0 , u0_ . grade AS grade_1 FROM `user` u0_ ORDER BY u0_ . grade ASC LIMIT 20 ;
Copy
2
1.07 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_ . grade ASC
Parameters :
[
13
6
3
4
1
37
35
38
29
25
28
24
31
34
23
22
10
]
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 (13 , 6 , 3 , 4 , 1 , 37 , 35 , 38 , 29 , 25 , 28 , 24 , 31 , 34 , 23 , 22 , 10 ) ORDER BY u0_ . grade ASC ;
Copy
3
1.51 ms
SELECT count (* ) AS sclr_0 FROM `user` u0_
SELECT count (* ) AS sclr_0 FROM `user` u0_ ;
Copy
4
3.32 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
5
10.16 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
6
10.23 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
7
5.76 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
8
6.80 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
9
22.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 = 37 ;
Copy
10
11.76 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
11
8.45 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
12
2.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 = 29 ;
Copy
13
3.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 = 25 ;
Copy
14
6.29 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
15
12.30 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
16
4.37 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
17
10.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 = 34 ;
Copy
18
5.58 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
15.49 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
20
11.36 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