SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105800 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105800 [ RunTime:0.002283s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383615,65085,439723,364322,871205,492210,901543,924086,951263,844326,1008083,283973,618504,544572,748481,574915,184373,281282,551458,1033518,323951,462342,102497,572062,827565,487659,695911,144511,320855,789220,153204,508393,191273,602511,23332,436834,93840,250691,848754,352938,449627,269169,453943,97610,784533,4963,850891,773066,949785,1020529,394963,546665,95225,640573,41059,930722,629000,1016348,147971,520861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]