SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455806 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455806 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470857,1015636,690210,274377,73937,782655,1023374,51787,347898,260389,199230,50543,928958,376261,552304,306029,471880,122112,129965,436817,960444,271743,183982,708943,494831,443859,780972,1018984,643075,125182,404278,112798,553050,260415,192889,530123,820491,646864,474452,627103,739510,545457,746050,464549,821405,782343,1023305,985998,208593,55700,1045559,57073,417848,375684,653574,742637,468967,804565,346977,875789) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]