SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459628 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459628 [ RunTime:0.004246s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (995211,469901,880927,179296,313517,4422,32518,809426,743138,728312,629838,80178,404916,181118,439216,517038,486819,195286,600773,865601,89986,54056,675453,357871,725758,939297,181490,442854,436379,574959,458500,587402,683283,558778,1030900,75475,496865,971367,475097,242367,1002646,876534,140502,395995,118289,804635,1009085,873466,436046,1012873,250819,386269,550925,892885,1038223,448190,302873,481743,843450,738231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]