SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801941 LIMIT 1 [ RunTime:0.001142s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801941 [ RunTime:0.002709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318921,542326,168259,772537,120652,714199,162413,187793,579093,213909,239021,934274,387688,35804,906783,87012,224751,488311,744554,34529,841528,7838,387768,144331,830192,628166,234946,800165,554349,402503,1036451,115733,688178,876945,340901,262766,378385,427310,869709,714449,366824,1012410,833401,699901,1011630,440089,871161,448257,305933,551074,56080,475541,519065,323292,252285,818931,469250,171158,157788,494923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001684s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001920s ]