SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48493 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48493 [ RunTime:0.002475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379254,20887,178881,411990,325021,962124,1025905,159014,389970,934928,206483,806291,469044,857723,934080,946208,950645,217876,2733,28245,957188,850147,301394,700738,580013,158018,800295,341212,143115,738923,989691,36318,1047063,810546,609531,472535,273920,634343,416101,128669,689614,877866,261288,322354,918806,104548,674436,264017,160387,234345,474325,759070,504138,734625,141263,707958,278745,383461,204132,114942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]