SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502805 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502805 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105817,637314,733197,711734,344522,514274,100450,978450,850620,711457,485589,589618,716957,548567,469031,594545,188515,520394,62560,730456,701399,316932,241534,70170,877043,998169,56687,235227,858270,385795,208687,403116,361789,349794,757674,561233,953501,163798,698586,148554,271654,742117,688471,693225,734617,748011,990846,1026805,35029,177219,934035,752294,814597,270860,209856,82768,372136,619753,23373,867337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]