SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016211 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016211 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447361,513275,761457,1009752,420426,10182,681065,742333,219764,728527,1048287,807716,249633,435261,416336,810897,684675,961079,196914,201897,368224,263680,766278,458974,284687,464638,341213,357656,694094,727346,135981,963043,1028837,356338,498585,626800,220503,723236,1012017,522902,152226,611376,864801,509470,910498,332904,238617,795098,308503,879487,284066,649046,783518,779858,888233,969202,70387,519115,146146,987819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]