SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460210 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460210 [ RunTime:0.002164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42954,265437,838988,46326,285911,268493,669596,11396,850705,755650,297475,485910,222513,233990,894532,946668,151857,484449,499852,123413,236722,1021635,227525,695616,975260,489164,157364,97225,435097,609494,864287,663538,505187,289791,299562,774279,716175,853218,299934,433980,633397,451509,817134,536263,23595,393142,215035,303822,288847,1032579,690176,153357,821224,869715,989699,1015210,719100,431512,708316,482907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]