1 |
1.43 ms |
SELECT DISTINCT b0_.id AS id_0 FROM building b0_ LIMIT 20
SELECT
DISTINCT b0_.id AS id_0
FROM
building b0_
LIMIT
20
SELECT DISTINCT b0_.id AS id_0 FROM building b0_ LIMIT 20;
|
2 |
0.43 ms |
SELECT b0_.id AS id_0, b0_.name AS name_1 FROM building b0_ WHERE b0_.id IN (?, ?, ?)
SELECT
b0_.id AS id_0,
b0_.name AS name_1
FROM
building b0_
WHERE
b0_.id IN (?, ?, ?)
SELECT b0_.id AS id_0, b0_.name AS name_1 FROM building b0_ WHERE b0_.id IN (4, 5, 6);
|
3 |
0.43 ms |
SELECT count(b0_.id) AS sclr_0 FROM building b0_
SELECT
count(b0_.id) AS sclr_0
FROM
building b0_
SELECT count(b0_.id) AS sclr_0 FROM building b0_;
|
4 |
1.60 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.capacity AS capacity_3, t0.floor AS floor_4, t0.name AS name_5, t0.building_id AS building_id_6, t7.id AS id_8, t7.duration_in_minutes AS duration_in_minutes_9, t7.length AS length_10, t7.tmp_count AS tmp_count_11, t7.start_time AS start_time_12, t7.end_time AS end_time_13, t7.group_ids AS group_ids_14, t7.sub_group_ids AS sub_group_ids_15, t7.phase_group_ids AS phase_group_ids_16, t7.ref_id AS ref_id_17, t7.phase_part AS phase_part_18, t7.group_id AS group_id_19, t7.sub_group_id AS sub_group_id_20, t7.lesson_id AS lesson_id_21, t7.department_id AS department_id_22, t7.teacher_id AS teacher_id_23, t7.phase_group_id AS phase_group_id_24, t7.room_id AS room_id_25, t7.selecting_class_time_id AS selecting_class_time_id_26 FROM room t0 LEFT JOIN class_time t7 ON t7.room_id = t0.id WHERE t0.building_id = ?
SELECT
t0.id AS id_1,
t0.number AS number_2,
t0.capacity AS capacity_3,
t0.floor AS floor_4,
t0.name AS name_5,
t0.building_id AS building_id_6,
t7.id AS id_8,
t7.duration_in_minutes AS duration_in_minutes_9,
t7.length AS length_10,
t7.tmp_count AS tmp_count_11,
t7.start_time AS start_time_12,
t7.end_time AS end_time_13,
t7.group_ids AS group_ids_14,
t7.sub_group_ids AS sub_group_ids_15,
t7.phase_group_ids AS phase_group_ids_16,
t7.ref_id AS ref_id_17,
t7.phase_part AS phase_part_18,
t7.group_id AS group_id_19,
t7.sub_group_id AS sub_group_id_20,
t7.lesson_id AS lesson_id_21,
t7.department_id AS department_id_22,
t7.teacher_id AS teacher_id_23,
t7.phase_group_id AS phase_group_id_24,
t7.room_id AS room_id_25,
t7.selecting_class_time_id AS selecting_class_time_id_26
FROM
room t0
LEFT JOIN class_time t7 ON t7.room_id = t0.id
WHERE
t0.building_id = ?
SELECT t0.id AS id_1, t0.number AS number_2, t0.capacity AS capacity_3, t0.floor AS floor_4, t0.name AS name_5, t0.building_id AS building_id_6, t7.id AS id_8, t7.duration_in_minutes AS duration_in_minutes_9, t7.length AS length_10, t7.tmp_count AS tmp_count_11, t7.start_time AS start_time_12, t7.end_time AS end_time_13, t7.group_ids AS group_ids_14, t7.sub_group_ids AS sub_group_ids_15, t7.phase_group_ids AS phase_group_ids_16, t7.ref_id AS ref_id_17, t7.phase_part AS phase_part_18, t7.group_id AS group_id_19, t7.sub_group_id AS sub_group_id_20, t7.lesson_id AS lesson_id_21, t7.department_id AS department_id_22, t7.teacher_id AS teacher_id_23, t7.phase_group_id AS phase_group_id_24, t7.room_id AS room_id_25, t7.selecting_class_time_id AS selecting_class_time_id_26 FROM room t0 LEFT JOIN class_time t7 ON t7.room_id = t0.id WHERE t0.building_id = 4;
|
5 |
0.51 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.capacity AS capacity_3, t0.floor AS floor_4, t0.name AS name_5, t0.building_id AS building_id_6, t7.id AS id_8, t7.duration_in_minutes AS duration_in_minutes_9, t7.length AS length_10, t7.tmp_count AS tmp_count_11, t7.start_time AS start_time_12, t7.end_time AS end_time_13, t7.group_ids AS group_ids_14, t7.sub_group_ids AS sub_group_ids_15, t7.phase_group_ids AS phase_group_ids_16, t7.ref_id AS ref_id_17, t7.phase_part AS phase_part_18, t7.group_id AS group_id_19, t7.sub_group_id AS sub_group_id_20, t7.lesson_id AS lesson_id_21, t7.department_id AS department_id_22, t7.teacher_id AS teacher_id_23, t7.phase_group_id AS phase_group_id_24, t7.room_id AS room_id_25, t7.selecting_class_time_id AS selecting_class_time_id_26 FROM room t0 LEFT JOIN class_time t7 ON t7.room_id = t0.id WHERE t0.building_id = ?
SELECT
t0.id AS id_1,
t0.number AS number_2,
t0.capacity AS capacity_3,
t0.floor AS floor_4,
t0.name AS name_5,
t0.building_id AS building_id_6,
t7.id AS id_8,
t7.duration_in_minutes AS duration_in_minutes_9,
t7.length AS length_10,
t7.tmp_count AS tmp_count_11,
t7.start_time AS start_time_12,
t7.end_time AS end_time_13,
t7.group_ids AS group_ids_14,
t7.sub_group_ids AS sub_group_ids_15,
t7.phase_group_ids AS phase_group_ids_16,
t7.ref_id AS ref_id_17,
t7.phase_part AS phase_part_18,
t7.group_id AS group_id_19,
t7.sub_group_id AS sub_group_id_20,
t7.lesson_id AS lesson_id_21,
t7.department_id AS department_id_22,
t7.teacher_id AS teacher_id_23,
t7.phase_group_id AS phase_group_id_24,
t7.room_id AS room_id_25,
t7.selecting_class_time_id AS selecting_class_time_id_26
FROM
room t0
LEFT JOIN class_time t7 ON t7.room_id = t0.id
WHERE
t0.building_id = ?
SELECT t0.id AS id_1, t0.number AS number_2, t0.capacity AS capacity_3, t0.floor AS floor_4, t0.name AS name_5, t0.building_id AS building_id_6, t7.id AS id_8, t7.duration_in_minutes AS duration_in_minutes_9, t7.length AS length_10, t7.tmp_count AS tmp_count_11, t7.start_time AS start_time_12, t7.end_time AS end_time_13, t7.group_ids AS group_ids_14, t7.sub_group_ids AS sub_group_ids_15, t7.phase_group_ids AS phase_group_ids_16, t7.ref_id AS ref_id_17, t7.phase_part AS phase_part_18, t7.group_id AS group_id_19, t7.sub_group_id AS sub_group_id_20, t7.lesson_id AS lesson_id_21, t7.department_id AS department_id_22, t7.teacher_id AS teacher_id_23, t7.phase_group_id AS phase_group_id_24, t7.room_id AS room_id_25, t7.selecting_class_time_id AS selecting_class_time_id_26 FROM room t0 LEFT JOIN class_time t7 ON t7.room_id = t0.id WHERE t0.building_id = 5;
|
6 |
0.48 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.capacity AS capacity_3, t0.floor AS floor_4, t0.name AS name_5, t0.building_id AS building_id_6, t7.id AS id_8, t7.duration_in_minutes AS duration_in_minutes_9, t7.length AS length_10, t7.tmp_count AS tmp_count_11, t7.start_time AS start_time_12, t7.end_time AS end_time_13, t7.group_ids AS group_ids_14, t7.sub_group_ids AS sub_group_ids_15, t7.phase_group_ids AS phase_group_ids_16, t7.ref_id AS ref_id_17, t7.phase_part AS phase_part_18, t7.group_id AS group_id_19, t7.sub_group_id AS sub_group_id_20, t7.lesson_id AS lesson_id_21, t7.department_id AS department_id_22, t7.teacher_id AS teacher_id_23, t7.phase_group_id AS phase_group_id_24, t7.room_id AS room_id_25, t7.selecting_class_time_id AS selecting_class_time_id_26 FROM room t0 LEFT JOIN class_time t7 ON t7.room_id = t0.id WHERE t0.building_id = ?
SELECT
t0.id AS id_1,
t0.number AS number_2,
t0.capacity AS capacity_3,
t0.floor AS floor_4,
t0.name AS name_5,
t0.building_id AS building_id_6,
t7.id AS id_8,
t7.duration_in_minutes AS duration_in_minutes_9,
t7.length AS length_10,
t7.tmp_count AS tmp_count_11,
t7.start_time AS start_time_12,
t7.end_time AS end_time_13,
t7.group_ids AS group_ids_14,
t7.sub_group_ids AS sub_group_ids_15,
t7.phase_group_ids AS phase_group_ids_16,
t7.ref_id AS ref_id_17,
t7.phase_part AS phase_part_18,
t7.group_id AS group_id_19,
t7.sub_group_id AS sub_group_id_20,
t7.lesson_id AS lesson_id_21,
t7.department_id AS department_id_22,
t7.teacher_id AS teacher_id_23,
t7.phase_group_id AS phase_group_id_24,
t7.room_id AS room_id_25,
t7.selecting_class_time_id AS selecting_class_time_id_26
FROM
room t0
LEFT JOIN class_time t7 ON t7.room_id = t0.id
WHERE
t0.building_id = ?
SELECT t0.id AS id_1, t0.number AS number_2, t0.capacity AS capacity_3, t0.floor AS floor_4, t0.name AS name_5, t0.building_id AS building_id_6, t7.id AS id_8, t7.duration_in_minutes AS duration_in_minutes_9, t7.length AS length_10, t7.tmp_count AS tmp_count_11, t7.start_time AS start_time_12, t7.end_time AS end_time_13, t7.group_ids AS group_ids_14, t7.sub_group_ids AS sub_group_ids_15, t7.phase_group_ids AS phase_group_ids_16, t7.ref_id AS ref_id_17, t7.phase_part AS phase_part_18, t7.group_id AS group_id_19, t7.sub_group_id AS sub_group_id_20, t7.lesson_id AS lesson_id_21, t7.department_id AS department_id_22, t7.teacher_id AS teacher_id_23, t7.phase_group_id AS phase_group_id_24, t7.room_id AS room_id_25, t7.selecting_class_time_id AS selecting_class_time_id_26 FROM room t0 LEFT JOIN class_time t7 ON t7.room_id = t0.id WHERE t0.building_id = 6;
|