SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025681 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025681 [ RunTime:0.002053s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (127296,477021,82870,64903,941664,530378,409255,638178,447395,939758,738652,23255,161437,180986,628894,356820,716284,332957,605600,345099,528024,997274,434844,116783,148752,29463,890871,407071,610987,254353,360039,370597,712313,389959,736075,569749,1044480,520161,94998,555006,121684,540519,36212,514532,141137,235100,350460,579484,939572,227481,497808,1009333,955424,298437,359135,925072,884403,759787,755821,273369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]