SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002929s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103504 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103504 [ RunTime:0.001832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (904597,10950,92623,155822,818438,761171,211030,605189,396949,913779,258460,650905,184338,896273,744071,624601,28393,538225,270447,27960,416945,671712,442692,541676,1017732,807779,646475,255075,630052,275879,617002,827160,773584,38416,909037,727096,320102,853711,689869,1043281,316055,429688,777643,1000778,618291,404578,466872,1025453,926776,469,518209,520136,716473,35279,964964,503967,256414,263427,51625,256931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]