SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 679292 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 679292 [ RunTime:0.002147s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (57545,109028,336741,441108,904104,801487,540814,499108,565601,339708,63619,532289,884840,836872,752189,300424,620160,478520,353301,285419,296430,387877,599217,545469,153666,952703,322012,872657,206591,279720,96023,610324,457488,489991,1002595,755050,862945,7182,449558,286850,469756,212146,61098,120855,676723,92155,877748,388033,87634,434181,969935,231385,221942,868000,23114,302037,23706,1042487,481833,352587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 679292 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 679292 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]