SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001580s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548267 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548267 [ RunTime:0.002015s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104058,975953,638604,21846,291483,81405,1023263,828213,107398,317030,843402,519299,822625,473058,606198,838663,610243,893148,676406,116268,9316,685973,793393,231022,800645,570382,735882,145192,420583,743391,629505,615674,160306,384782,374216,570406,794092,327293,91753,762529,456182,1024772,725486,239029,860013,776737,692128,380653,617631,838666,919402,634243,568722,2460,1018992,626580,490013,696259,301601,829436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548267 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001672s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548267 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002365s ]