SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354398 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354398 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384442,458375,501882,878068,110964,25173,1011764,213140,128103,125273,10016,718230,707627,91816,930046,853891,970544,612871,590256,569824,4103,993582,223683,678998,819788,639584,488594,570154,83450,123258,278869,823056,835809,750720,732062,691003,8814,134969,560386,682660,124395,247669,843744,689939,742253,1035314,764197,55965,347632,806157,124821,1004490,994089,420291,986528,1046159,857980,190612,924406,653258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]