SQL | ERROR | ROWS | TIME |
---|
|
SET NAMES utf8 ; | | | 0.00007 |
SELECT * FROM ac_news_member_conf WHERE news_member_conf_id =1 LIMIT 1 | | 1 | 0.00032 |
SELECT * FROM ac_c_server AS c_server WHERE c_server_id = 1 LIMIT 1 | | 1 | 0.00013 |
SELECT * FROM ac_news_layout_top_conf WHERE news_layout_top_conf_id=1 LIMIT 1 | | 1 | 0.00009 |
SELECT * FROM ac_c_server AS c_server WHERE c_server_id = 1 LIMIT 1 | | 1 | 0.00007 |
SELECT news_info.news_info_id , news_info_server.c_server_id , news_info_server.news_info_server_id FROM ac_news_info AS news_info LEFT JOIN ac_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.00027 |
SELECT * FROM ac_c_server AS c_server WHERE c_server_id = 1 LIMIT 1 | | 1 | 0.00009 |
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 ac_news_info AS news_info LEFT JOIN ac_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 , 10 | | 10 | 0.00176 |
SELECT * FROM ac_c_server AS c_server WHERE c_server_id = 1 LIMIT 1 | | 1 | 0.00013 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '51' ORDER BY news_info_cate_id DESC | | 1 | 0.00013 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 73) ORDER BY orderby_no DESC | | 1 | 0.00010 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 51 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00008 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '50' ORDER BY news_info_cate_id DESC | | 1 | 0.00012 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 73) ORDER BY orderby_no DESC | | 1 | 0.00010 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 50 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00007 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '49' ORDER BY news_info_cate_id DESC | | 1 | 0.00010 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 74) ORDER BY orderby_no DESC | | 1 | 0.00010 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 49 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00007 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '48' ORDER BY news_info_cate_id DESC | | 1 | 0.00010 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 1) ORDER BY orderby_no DESC | | 1 | 0.00008 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 48 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00007 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '52' ORDER BY news_info_cate_id DESC | | 1 | 0.00010 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 1) ORDER BY orderby_no DESC | | 1 | 0.00011 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 52 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00007 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '55' ORDER BY news_info_cate_id DESC | | 1 | 0.00011 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 74) ORDER BY orderby_no DESC | | 1 | 0.00009 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 55 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00007 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '33' ORDER BY news_info_cate_id DESC | | 1 | 0.00010 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 1) ORDER BY orderby_no DESC | | 1 | 0.00008 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 33 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00007 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '39' ORDER BY news_info_cate_id DESC | | 1 | 0.00010 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 1) ORDER BY orderby_no DESC | | 1 | 0.00012 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 39 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00007 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '53' ORDER BY news_info_cate_id DESC | | 1 | 0.00009 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 77) ORDER BY orderby_no DESC | | 1 | 0.00007 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 53 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00006 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '32' ORDER BY news_info_cate_id DESC | | 1 | 0.00009 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 1) ORDER BY orderby_no DESC | | 1 | 0.00007 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 32 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00006 |
SELECT image_ect.* FROM ac_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 | | 1 | 0.00023 |
SELECT image_ect.* FROM ac_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 | | 2 | 0.00017 |
SELECT image_ect.* FROM ac_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 | | 1 | 0.00014 |
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 ( ac_news_info AS news_info inner join ac_news_info_cate as news_info_cate on news_info.news_info_id = news_info_cate.news_info_id AND news_info_cate.news_cate_id in (1 ) ) LEFT JOIN ac_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 , 10 | | 10 | 0.00113 |
SELECT * FROM ac_c_server AS c_server WHERE c_server_id = 1 LIMIT 1 | | 1 | 0.00013 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '48' ORDER BY news_info_cate_id DESC | | 1 | 0.00016 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 1) ORDER BY orderby_no DESC | | 1 | 0.00012 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 48 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00008 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '52' ORDER BY news_info_cate_id DESC | | 1 | 0.00012 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 1) ORDER BY orderby_no DESC | | 1 | 0.00009 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 52 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00008 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '33' ORDER BY news_info_cate_id DESC | | 1 | 0.00011 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 1) ORDER BY orderby_no DESC | | 1 | 0.00009 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 33 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00009 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '39' ORDER BY news_info_cate_id DESC | | 1 | 0.00011 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 1) ORDER BY orderby_no DESC | | 1 | 0.00009 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 39 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00008 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '32' ORDER BY news_info_cate_id DESC | | 1 | 0.00011 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 1) ORDER BY orderby_no DESC | | 1 | 0.00009 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 32 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00007 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '43' ORDER BY news_info_cate_id DESC | | 1 | 0.00011 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 1) ORDER BY orderby_no DESC | | 1 | 0.00011 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 43 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00008 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '31' ORDER BY news_info_cate_id DESC | | 1 | 0.00011 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 1) ORDER BY orderby_no DESC | | 1 | 0.00008 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 31 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00007 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '38' ORDER BY news_info_cate_id DESC | | 1 | 0.00010 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 1) ORDER BY orderby_no DESC | | 1 | 0.00008 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 38 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00007 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '47' ORDER BY news_info_cate_id DESC | | 1 | 0.00010 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 1) ORDER BY orderby_no DESC | | 1 | 0.00010 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 47 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00007 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '42' ORDER BY news_info_cate_id DESC | | 1 | 0.00010 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 1) ORDER BY orderby_no DESC | | 1 | 0.00010 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 42 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00007 |
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 ( ac_news_info AS news_info inner join ac_news_info_cate as news_info_cate on news_info.news_info_id = news_info_cate.news_info_id AND news_info_cate.news_cate_id in (74 ) ) LEFT JOIN ac_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 , 10 | | 10 | 0.00111 |
SELECT * FROM ac_c_server AS c_server WHERE c_server_id = 1 LIMIT 1 | | 1 | 0.00011 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '49' ORDER BY news_info_cate_id DESC | | 1 | 0.00010 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 74) ORDER BY orderby_no DESC | | 1 | 0.00008 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 49 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00010 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '55' ORDER BY news_info_cate_id DESC | | 1 | 0.00010 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 74) ORDER BY orderby_no DESC | | 1 | 0.00008 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 55 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00006 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '80' ORDER BY news_info_cate_id DESC | | 1 | 0.00008 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 74) ORDER BY orderby_no DESC | | 1 | 0.00007 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 80 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00006 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '16' ORDER BY news_info_cate_id DESC | | 1 | 0.00009 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 74) ORDER BY orderby_no DESC | | 1 | 0.00008 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 16 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00006 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '56' ORDER BY news_info_cate_id DESC | | 1 | 0.00011 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 74) ORDER BY orderby_no DESC | | 1 | 0.00008 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 56 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00006 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '57' ORDER BY news_info_cate_id DESC | | 1 | 0.00009 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 74) ORDER BY orderby_no DESC | | 1 | 0.00007 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 57 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00010 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '58' ORDER BY news_info_cate_id DESC | | 1 | 0.00014 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 74) ORDER BY orderby_no DESC | | 1 | 0.00009 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 58 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00011 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '63' ORDER BY news_info_cate_id DESC | | 1 | 0.00011 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 74) ORDER BY orderby_no DESC | | 1 | 0.00008 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 63 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00007 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '61' ORDER BY news_info_cate_id DESC | | 1 | 0.00010 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 74) ORDER BY orderby_no DESC | | 1 | 0.00009 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 61 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00007 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '60' ORDER BY news_info_cate_id DESC | | 1 | 0.00011 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 74) ORDER BY orderby_no DESC | | 1 | 0.00007 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 60 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00008 |
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 ( ac_news_info AS news_info inner join ac_news_info_cate as news_info_cate on news_info.news_info_id = news_info_cate.news_info_id AND news_info_cate.news_cate_id in (73 ) ) LEFT JOIN ac_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 , 10 | | 2 | 0.00086 |
SELECT * FROM ac_c_server AS c_server WHERE c_server_id = 1 LIMIT 1 | | 1 | 0.00016 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '51' ORDER BY news_info_cate_id DESC | | 1 | 0.00012 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 73) ORDER BY orderby_no DESC | | 1 | 0.00009 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 51 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00008 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '50' ORDER BY news_info_cate_id DESC | | 1 | 0.00011 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 73) ORDER BY orderby_no DESC | | 1 | 0.00009 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 50 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00007 |