SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34176 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34176 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536651,754102,843854,577999,488861,11045,274400,849927,348553,559498,818883,212337,267147,498263,277511,176141,485454,1042989,228252,296384,656031,100870,261465,677916,129603,890465,767298,301118,169372,153242,495481,79203,83102,957055,1028041,472612,1041387,256227,322491,524492,180222,991533,781776,115161,823176,687874,733319,805404,830304,1012893,908552,31008,289406,437126,749335,711008,922039,120170,628105,54833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]