SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002432s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 33661 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 33661 [ RunTime:0.006831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381887,613357,515052,901417,290399,245152,89850,788710,55277,10622,112526,774727,86015,103714,734908,80473,1043120,783203,735106,216779,280112,440124,930593,4278,256466,355090,532059,347055,550059,237549,729941,726261,1010154,639063,543430,969721,494821,919008,595009,256647,260137,940726,286558,71090,153647,803043,932257,923530,627335,1012776,1014650,398294,594590,915874,400097,853694,199536,563373,350095,210034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 33661 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 33661 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003015s ]