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` = 440985 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440985 [ RunTime:0.002365s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336289,378200,596838,55024,338789,636330,456016,47695,870749,819634,994882,117457,735061,377509,1044702,923815,987118,809347,24369,318519,578929,548603,302262,341203,195117,48040,748320,286760,655031,876693,365238,841619,933746,494787,676283,221626,454410,875686,42916,155722,107896,748506,681134,422506,246165,646293,204419,9389,699456,625383,389870,519275,509246,350981,135612,967069,597719,269493,659711,311062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]