SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401802 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401802 [ RunTime:0.002376s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (842759,105230,349328,771294,1046783,690504,1048676,624349,803889,320285,292501,972945,461199,714194,524176,330967,539912,510392,91054,6866,52854,345409,828629,878757,177855,20190,31143,129973,214565,498915,265689,514166,832450,876312,263267,474470,896609,793412,75484,1044183,595016,481995,831047,455837,970939,254491,1027429,702240,502243,526419,154377,629794,423416,231379,492715,877571,223427,750811,915499,827348) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401802 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401802 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]