SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507245 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507245 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (742462,141417,192388,657085,64027,743813,1033350,131936,16984,46108,865512,437149,626075,1030326,494525,83823,1037808,317674,969746,560006,880001,86,355238,397366,300318,859894,445029,923614,431945,236685,364099,376398,494537,735598,267577,479973,369284,485163,355089,957934,125827,479314,181101,570689,272139,41833,558059,117861,471719,567475,648806,68275,680572,70012,539558,871633,94630,294417,175838,937826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002786s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507245 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507245 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]