SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003383s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109951 LIMIT 1 [ RunTime:0.002736s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109951 [ RunTime:0.002049s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (796692,705552,27830,12868,466751,919404,589246,727158,914251,442359,632277,489758,397846,235867,644571,991727,438092,943801,514195,794796,238454,799189,367034,416253,205279,1021219,112945,909645,92403,498931,312717,1003719,651986,476334,195555,379193,775532,833190,812349,271397,50047,1037783,911641,153731,627790,297160,474574,542808,704465,431391,143959,879090,765867,229353,455700,911544,152739,811264,777165,989264) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000837s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002045s ]