SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001522s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331816 LIMIT 1 [ RunTime:0.000716s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331816 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155749,11090,407777,952442,216100,865728,610045,507838,504231,881979,859003,684158,245049,344630,349669,53412,616524,937023,254679,415248,924665,561537,314974,360772,232758,829145,536968,488083,57729,676030,854115,493160,141790,1043902,613505,678547,67984,601205,529675,592861,59685,385156,565936,254201,399416,640440,326661,625656,807608,934715,532577,816110,750810,8240,593922,868485,623326,7773,556078,433803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]