SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403008 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403008 [ RunTime:0.002259s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302644,236059,900572,411692,1037579,230521,487908,682583,378053,962085,992214,436692,564289,409866,13180,868415,278520,381414,490432,396057,443649,756449,473938,996464,767336,235403,353413,834443,241566,780461,101197,322479,295293,631907,783654,504677,531891,181237,317228,83236,958447,870813,711666,58183,230799,897378,919018,56700,202549,344567,530643,155807,924440,13566,586844,379861,783359,837349,350388,293894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001462s ]