SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003997s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544253 LIMIT 1 [ RunTime:0.000644s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544253 [ RunTime:0.002756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (679305,665875,714780,180043,406157,972717,1000809,328945,580840,658028,164395,906182,17995,707489,187565,320991,40824,800529,584560,495862,24822,164814,826270,908576,66167,1002829,985300,742821,416376,249373,563610,54413,335884,614781,389314,999591,694979,920515,775694,980188,471448,442539,723583,989759,214116,56151,327435,208479,777659,489602,981524,1030554,565603,347266,833998,863373,41552,707100,713661,302206) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]