SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017993 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017993 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183834,348928,235046,149545,306399,777460,195145,574250,1032001,728627,972000,675288,85615,684413,899402,480140,991805,1154,603981,342750,255994,405977,127800,1026070,704054,109180,54244,270430,525372,472540,273711,445873,136164,565629,117809,400140,515137,279757,1039131,555471,992233,456701,432598,704701,735055,581146,128564,769688,473386,865897,334604,580632,342059,273518,793242,99536,69496,432468,114960,565095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]