SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502144 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502144 [ RunTime:0.002152s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124395,838644,538492,495786,320449,183073,1019218,153952,1048366,653027,289733,649980,314465,391018,201350,780868,310550,347125,735018,1033010,1028749,794332,797815,123509,1020541,138082,175763,212505,678319,765393,299776,976630,738264,486790,521560,8525,654955,527540,931388,676876,407926,21947,274641,137681,660365,662852,593842,345978,921421,473350,1030194,405113,725070,380272,119370,98738,342679,613205,851156,558331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]