1
0.76 ms
SELECT DISTINCT u0_ . id AS id_0 , u0_ . grade_level AS grade_level_1 FROM `user` u0_ ORDER BY u0_ . grade_level DESC LIMIT 20
SELECT DISTINCT u0_ . id AS id_0 , u0_ . grade_level AS grade_level_1 FROM `user` u0_ ORDER BY u0_ . grade_level DESC LIMIT 20 ;
Copy
2
1.01 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_level DESC
Parameters :
[
38
29
24
34
31
28
25
23
22
10
35
37
1
6
13
4
3
]
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 , 29 , 24 , 34 , 31 , 28 , 25 , 23 , 22 , 10 , 35 , 37 , 1 , 6 , 13 , 4 , 3 ) ORDER BY u0_ . grade_level DESC ;
Copy
3
1.95 ms
SELECT count (* ) AS sclr_0 FROM `user` u0_
SELECT count (* ) AS sclr_0 FROM `user` u0_ ;
Copy
4
3.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 = 38 ;
Copy
5
0.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 = 29 ;
Copy
6
1.91 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
7
7.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 = 34 ;
Copy
8
1.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 = 31 ;
Copy
9
0.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 = 28 ;
Copy
10
6.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 = 25 ;
Copy
11
2.97 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
12
6.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 = 22 ;
Copy
13
3.08 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
14
3.01 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
15
2.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 = 37 ;
Copy
16
3.63 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
17
9.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 = 6 ;
Copy
18
1.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 = 13 ;
Copy
19
8.70 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
20
2.89 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