SHOW FULL COLUMNS FROM `mtr_bus_route` [ RunTime:0.000503s ]
SELECT `id`,`no`,`co`,`name`,`orig`,`fare`,`freq`,`bound`,`dest`,`service_type`,`stop_list` FROM `mtr_bus_route` `r` WHERE `r`.`id` = 'MTR-ISL-UP--16228184' LIMIT 1 [ RunTime:0.000263s ]
SELECT `id`,`no`,`co`,`name`,`orig`,`fare`,`freq`,`bound`,`dest`,`service_type`,`stop_list` FROM `mtr_bus_route` `r` WHERE `r`.`id` = 'MTR-ISL-DOWN--16228184' LIMIT 1 [ RunTime:0.000218s ]
SHOW FULL COLUMNS FROM `mtr_bus_stop` [ RunTime:0.000353s ]
SELECT `id`,`name`,`lat`,`lng` FROM `mtr_bus_stop` WHERE `id` IN ('KET','HKU','SYP','SHW','CEN','ADM','WAC','CAB','TIH','FOH','NOP','QUB','TAK','SWH','SKW','HFC','CHW') [ RunTime:0.000351s ]
SELECT `stop_list`,`id`,`no`,`co`,`name`,`orig`,`dest` FROM `mtr_bus_route` `r` WHERE `r`.`bound` = 'O' AND ( JSON_CONTAINS(stop_list, '"KET"') ) LIMIT 10 [ RunTime:0.052721s ]