SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002078s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400523 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400523 [ RunTime:0.003081s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (558402,607830,179398,946261,157279,434178,288428,246392,678301,879159,865098,437532,822811,454863,54299,569257,61677,785038,803125,760084,455662,975767,165233,14313,785961,346255,466448,118609,49397,74216,672271,655476,874036,516144,814756,78301,585117,93821,699965,962106,1028647,49772,972134,492947,183406,120459,169035,569569,601340,763199,758261,506047,572834,21130,927697,450925,286811,704853,365494,982344) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]