1
6.75 ms
SELECT DISTINCT u0_ . id AS id_0 , u0_ . grade_level AS grade_level_1 FROM `user` u0_ ORDER BY u0_ . grade_level ASC LIMIT 20
SELECT DISTINCT u0_ . id AS id_0 , u0_ . grade_level AS grade_level_1 FROM `user` u0_ ORDER BY u0_ . grade_level ASC LIMIT 20 ;
Copy
2
13.42 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 ASC
Parameters :
[
3
4
13
6
1
37
35
24
34
31
28
25
23
22
10
29
38
]
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 (3 , 4 , 13 , 6 , 1 , 37 , 35 , 24 , 34 , 31 , 28 , 25 , 23 , 22 , 10 , 29 , 38 ) ORDER BY u0_ . grade_level ASC ;
Copy
3
2.73 ms
SELECT count (* ) AS sclr_0 FROM `user` u0_
SELECT count (* ) AS sclr_0 FROM `user` u0_ ;
Copy
4
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 = 3 ;
Copy
5
12.59 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
6
0.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 = 13 ;
Copy
7
7.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
8
9.83 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
1.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
10
10.59 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
6.19 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
12
6.25 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
13
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 = 31 ;
Copy
14
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 = 28 ;
Copy
15
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 = 25 ;
Copy
16
10.10 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
17
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 = 22 ;
Copy
18
11.98 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
19
0.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 = 29 ;
Copy
20
14.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 = 38 ;
Copy