SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 224481 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 224481 [ RunTime:0.002342s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (472083,891464,163729,722680,665571,652011,655889,801892,818043,767042,405450,42548,350429,796376,668842,46795,389087,17347,208895,661419,78362,332577,939622,1006837,655304,408149,276846,61858,1001235,906046,726583,338132,110435,28911,885430,9874,602321,392429,812034,825191,625002,504973,986933,302609,379955,430892,738565,197101,267594,534314,688716,527263,308334,25097,750345,46492,854645,291971,857610,419640) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 224481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 224481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]