SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001525s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 368512 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 368512 [ RunTime:0.001530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108999,628092,19477,823537,584306,389015,309253,459900,131936,710505,546693,578658,828112,869340,665042,348803,316262,647732,261880,931020,927478,157412,369808,81828,637918,684893,158006,112627,956471,219346,1130,865013,393722,323036,341628,371507,1047676,1045985,410404,999756,375370,231921,944617,439262,1045108,713304,872964,742721,518727,934910,427409,341908,114959,105931,913767,451113,617661,860207,6082,510578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 368512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 368512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]