| 1 |
1.35 ms |
SELECT DISTINCT u0_.id AS id_0 FROM `user` u0_ LIMIT 20
SELECT DISTINCT u0_.id AS id_0 FROM `user` u0_ LIMIT 20;
|
| 2 |
1.28 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
3
35
38
37
23
13
24
6
22
25
10
4
1
31
28
34
29
]
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, 35, 38, 37, 23, 13, 24, 6, 22, 25, 10, 4, 1, 31, 28, 34, 29);
|
| 3 |
0.62 ms |
SELECT count(*) AS sclr_0 FROM `user` u0_
SELECT count(*) AS sclr_0 FROM `user` u0_;
|
| 4 |
0.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;
|
| 5 |
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 = 3;
|
| 6 |
0.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 = 4;
|
| 7 |
0.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 = 6;
|
| 8 |
0.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 = 10;
|
| 9 |
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 = 13;
|
| 10 |
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 = 22;
|
| 11 |
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 = 23;
|
| 12 |
0.48 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;
|
| 13 |
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 = 25;
|
| 14 |
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 = 28;
|
| 15 |
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 = 29;
|
| 16 |
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 = 31;
|
| 17 |
0.46 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;
|
| 18 |
0.55 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;
|
| 19 |
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 = 37;
|
| 20 |
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 = 38;
|