SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311207 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311207 [ RunTime:0.002118s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10718,240988,444707,474955,125768,485036,344160,330592,63278,989189,732122,23162,1042409,538494,75947,468765,775260,452748,257193,994631,803983,844234,381003,522831,214721,288694,192660,578930,598035,652192,871599,452226,789122,748248,40886,65080,126822,662279,586151,426924,738357,998143,537338,682721,546456,297760,461644,737662,529724,851673,104796,339160,745793,623438,40167,80772,940599,288900,67772,811803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]