SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51928 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51928 [ RunTime:0.002054s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (491265,947836,390057,610882,458543,305422,264103,957326,680393,100082,118644,784518,416004,303121,862083,949389,285357,233544,758183,978783,928572,901004,707056,955419,247385,624274,1033739,862718,297116,129288,151615,99881,831786,980325,111740,284368,594030,103645,212644,206196,195284,15741,205136,562016,982203,884144,678518,687449,88621,287114,401869,1027085,991619,905995,791133,584948,397405,1002948,747393,903137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]