SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479599 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479599 [ RunTime:0.004520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (354531,65691,133454,361874,294786,88201,488132,300896,947578,238913,6457,732182,443306,513761,489294,864925,332012,856695,1032560,256553,323199,720132,718066,872998,483618,997133,719349,486178,706796,114428,72751,668606,801711,657794,911986,209827,230729,561287,472349,678203,268092,503180,77391,972480,233557,473823,605023,267567,923056,744539,253623,250258,715908,392215,63628,530297,521335,615314,717540,473511) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000684s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001419s ]