| SQL | ERROR | ROWS | TIME | 
|---|
|  | 
| SET NAMES utf8 ; |  |  | 0.00017 | 
| SELECT * FROM en_news_member_conf  WHERE news_member_conf_id =1 LIMIT 1 |  | 1 | 0.00096 | 
| SELECT * FROM en_c_server AS c_server   WHERE  c_server_id =  1 LIMIT 1 |  | 1 | 0.00095 | 
| SELECT * FROM en_news_layout_top_conf  WHERE news_layout_top_conf_id=1 LIMIT 1 |  | 1 | 0.00071 | 
| SELECT * FROM en_c_server AS c_server   WHERE  c_server_id =  1 LIMIT 1 |  | 1 | 0.00022 | 
| SELECT  news_info.news_info_id  , news_info_server.c_server_id , news_info_server.news_info_server_id     FROM  en_news_info AS news_info    LEFT JOIN en_news_info_server as news_info_server ON news_info.news_info_id = news_info_server.news_info_id  WHERE   news_info.begin  <= now()  AND  now() <=  news_info.end   AND news_info.open_flg = 1  AND  news_info.status = 1  AND  news_info.template_flg IN ( 0 ,2 )  ORDER BY   news_info_server.orderby_no    LIMIT 0 , 50 |  | 1 | 0.00107 | 
| SELECT  DISTINCT  news_info.*, news_info_server.news_info_server_id , news_info_server.opening as server_opening , news_info_server.opening_pc as server_opening_pc   , news_info_server.opening_m as server_opening_m , news_info_server.opening_suma as server_opening_sp  , news_info_server.select_orderby_no  as server_select_orderby_no  , news_info_server.orderby_no  as server_orderby_no    FROM  en_news_info  AS  news_info     LEFT JOIN en_news_info_server as news_info_server ON news_info.news_info_id = news_info_server.news_info_id  WHERE  news_info_server.c_server_id = 1  AND news_info.begin  <= now()  AND  now() <=  news_info.end  AND news_info_server.opening = 1   AND ( news_info_server.opening_top  = 1 AND news_info_server.opening_pc = 1  )   AND  news_info.status = 1   AND  news_info.template_flg IN ( 0 ,2 )   ORDER BY  news_info_server.select_orderby_no DESC , news_info_server.orderby_no  DESC  LIMIT 0 , 5 |  | 1 | 0.00086 | 
| SELECT * FROM en_c_server AS c_server   WHERE  c_server_id =  1 LIMIT 1 |  | 1 | 0.00025 | 
| SELECT * FROM en_news_layout_top_conf  WHERE news_layout_top_conf_id=1 LIMIT 1 |  | 1 | 0.00023 | 
| SELECT   image_ect.*      FROM   en_ps_image_ect AS image_ect        WHERE   type  = 'slide'  AND   dir_id  = '1'  AND opening =  1   AND ( ( image_ect.beginend_flg = 0  AND image_ect.begin  <= now()  AND  now() <=  image_ect.end )    OR image_ect.beginend_flg = 1 ) ORDER BY  orderby_no  DESC |  | 7 | 0.00102 | 
| SELECT   image_ect.*      FROM   en_ps_image_ect AS image_ect        WHERE   type  = 'banner'  AND   dir_id  = '1'  AND opening =  1   AND ( ( image_ect.beginend_flg = 0  AND image_ect.begin  <= now()  AND  now() <=  image_ect.end )    OR image_ect.beginend_flg = 1 ) ORDER BY  orderby_no  DESC |  | 6 | 0.00033 | 
| SELECT   image_ect.*      FROM   en_ps_image_ect AS image_ect        WHERE   type  = 'banner_a'  AND   dir_id  = '1'  AND opening =  1   AND ( ( image_ect.beginend_flg = 0  AND image_ect.begin  <= now()  AND  now() <=  image_ect.end )    OR image_ect.beginend_flg = 1 ) ORDER BY  orderby_no  DESC |  | 6 | 0.00030 | 
| SELECT   image_ect.*      FROM   en_ps_image_ect AS image_ect        WHERE   type  = 'banner_b'  AND   dir_id  = '1'  AND opening =  1   AND ( ( image_ect.beginend_flg = 0  AND image_ect.begin  <= now()  AND  now() <=  image_ect.end )    OR image_ect.beginend_flg = 1 ) ORDER BY  orderby_no  DESC |  | 6 | 0.00028 | 
| SELECT   image_ect.*      FROM   en_ps_image_ect AS image_ect        WHERE   type  = 'banner_c'  AND   dir_id  = '1'  AND opening =  1   AND ( ( image_ect.beginend_flg = 0  AND image_ect.begin  <= now()  AND  now() <=  image_ect.end )    OR image_ect.beginend_flg = 1 ) ORDER BY  orderby_no  DESC |  | 6 | 0.00028 | 
| SELECT   image_ect.*      FROM   en_ps_image_ect AS image_ect        WHERE   type  = 'banner_d'  AND   dir_id  = '1'  AND opening =  1   AND ( ( image_ect.beginend_flg = 0  AND image_ect.begin  <= now()  AND  now() <=  image_ect.end )    OR image_ect.beginend_flg = 1 ) ORDER BY  orderby_no  DESC |  | 6 | 0.00043 | 
| SELECT   image_ect.*      FROM   en_ps_image_ect AS image_ect        WHERE   type  = 'text'  AND   dir_id  = '1'  AND opening =  1   AND ( ( image_ect.beginend_flg = 0  AND image_ect.begin  <= now()  AND  now() <=  image_ect.end )    OR image_ect.beginend_flg = 1 ) ORDER BY  orderby_no  DESC |  | 6 | 0.00044 |