SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40182 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40182 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489875,1036595,803916,60822,983562,806086,817330,235194,15072,274885,923404,1028475,539688,403521,271422,790119,10577,865393,521676,788437,1042991,913359,976446,264478,40210,963753,864349,984931,333233,772793,405032,1035007,529906,739385,483157,890776,796630,666156,527927,217812,456025,219033,972652,742300,288067,755333,710279,660148,613971,14163,596642,484944,202760,480464,230900,369232,552024,92568,843309,782844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40182 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40182 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]