SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10334 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10334 [ RunTime:0.003552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124629,408139,979223,897796,484652,807738,87421,780028,41510,751866,64451,930519,374196,102789,476104,1015136,751788,251414,77752,817175,396615,531593,614872,367660,1002624,1016486,252772,686430,357711,641862,511193,347323,294645,366586,586408,137212,741385,120246,1023517,630558,105177,967767,87404,630716,574814,168847,861568,14935,558010,81941,654630,95950,934070,339668,664833,30615,297718,533535,901749,597446) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10334 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10334 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]