SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428584 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428584 [ RunTime:0.003248s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (106235,39203,759239,259072,297492,336868,512322,296406,305836,714130,94742,1042963,385786,500830,305297,284692,799990,175656,287981,30052,309196,447911,654884,238663,69869,313095,581447,615709,422375,10830,927011,1043484,339649,1040888,73858,553801,786407,723758,700184,44291,925377,1036691,50314,171151,366153,573280,43856,209191,162430,1004334,501871,29000,97703,987299,137910,441395,1002620,839213,866221,896117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000371s ]