NGXIN---记一次接口504 Gateway Time-out原因及解决方法,

记一次接口504 Gateway Time-out原因及解决方法

    keepalive_timeout  300;
    fastcgi_buffers 8 128k;
    fastcgi_buffer_size  128k;
    fastcgi_busy_buffers_size 256k;
    fastcgi_temp_file_write_size 256k;

 

今天在刷新公司项目页面时发现有个板块一直刷新不出数据，最后发现接口报错（504 Gateway Time-out)

通过查看代码发现有个sql语句，如下，特别慢

select `vdc1`,

       `vdc2`,

       `vdc3`,

       `vdc4`,

       `vdc5`,

       `vdc6`,

       `vdc7`,

       `vdc8`,

       `idc1`,

       `idc2`,

       `idc3`,

       `idc4`,

       `idc5`,

       `idc6`,

       `idc7`,

       `idc8`,

  &nbs