SQL | ERROR | ROWS | TIME |
---|
|
SET NAMES utf8 ; | | | 0.00015 |
SET SESSION sql_mode = ''; | | | 0.00010 |
SELECT * FROM ac_news_member_conf WHERE news_member_conf_id =1 LIMIT 1 | | 1 | 0.00060 |
SELECT * FROM ac_c_server AS c_server WHERE c_server_id = 1 LIMIT 1 | | 1 | 0.00042 |
SELECT * FROM ac_news_layout_top_conf WHERE news_layout_top_conf_id=1 LIMIT 1 | | 1 | 0.00036 |
SELECT * FROM ac_c_server AS c_server WHERE c_server_id = 1 LIMIT 1 | | 1 | 0.00035 |
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.00160 |
SELECT * FROM ac_news_info_cate WHERE news_cate_id = '40' ORDER BY news_info_cate_id DESC | | 18 | 0.00058 |
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.warr_flg = 0 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 ) AND news_info.news_info_id Not in ( 222,197,178,142,140,136,134,73,72,71,70,69,68,67,65,66,63,64 ) ORDER BY news_info_server.select_orderby_no DESC , news_info_server.orderby_no DESC LIMIT 0 , 30 | | 15 | 0.01065 |
SELECT * FROM ac_c_server AS c_server WHERE c_server_id = 1 LIMIT 1 | | 1 | 0.00049 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '220' ORDER BY news_info_cate_id DESC | | 1 | 0.00040 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 36) ORDER BY orderby_no DESC | | 1 | 0.00046 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 220 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00036 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '219' ORDER BY news_info_cate_id DESC | | 3 | 0.00040 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 32,34,43) ORDER BY orderby_no DESC | | 3 | 0.00038 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 219 AND orderby_no = 1 LIMIT 1 | | 3 | 0.00026 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '218' ORDER BY news_info_cate_id DESC | | 2 | 0.00029 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 35,34) ORDER BY orderby_no DESC | | 2 | 0.00045 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 218 AND orderby_no = 1 LIMIT 1 | | 2 | 0.00025 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '215' ORDER BY news_info_cate_id DESC | | 1 | 0.00043 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 36) ORDER BY orderby_no DESC | | 1 | 0.00028 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 215 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00025 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '214' ORDER BY news_info_cate_id DESC | | 1 | 0.00030 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 37) ORDER BY orderby_no DESC | | 1 | 0.00025 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 214 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00025 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '213' ORDER BY news_info_cate_id DESC | | 2 | 0.00028 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 30,45) ORDER BY orderby_no DESC | | 2 | 0.00032 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 213 AND orderby_no = 1 LIMIT 1 | | 2 | 0.00023 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '216' ORDER BY news_info_cate_id DESC | | 1 | 0.00027 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 36) ORDER BY orderby_no DESC | | 1 | 0.00024 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 216 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00022 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '212' ORDER BY news_info_cate_id DESC | | 3 | 0.00028 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 30,34,45) ORDER BY orderby_no DESC | | 3 | 0.00034 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 212 AND orderby_no = 1 LIMIT 1 | | 3 | 0.00022 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '211' ORDER BY news_info_cate_id DESC | | 3 | 0.00028 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 30,34,45) ORDER BY orderby_no DESC | | 3 | 0.00035 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 211 AND orderby_no = 1 LIMIT 1 | | 3 | 0.00030 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '196' ORDER BY news_info_cate_id DESC | | 1 | 0.00036 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 37) ORDER BY orderby_no DESC | | 1 | 0.00033 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 196 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00031 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '195' ORDER BY news_info_cate_id DESC | | 1 | 0.00039 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 37) ORDER BY orderby_no DESC | | 1 | 0.00033 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 195 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00030 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '186' ORDER BY news_info_cate_id DESC | | 2 | 0.00040 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 32,43) ORDER BY orderby_no DESC | | 2 | 0.00038 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 186 AND orderby_no = 1 LIMIT 1 | | 2 | 0.00031 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '182' ORDER BY news_info_cate_id DESC | | 2 | 0.00036 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 27,42) ORDER BY orderby_no DESC | | 2 | 0.00040 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 182 AND orderby_no = 1 LIMIT 1 | | 2 | 0.00026 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '105' ORDER BY news_info_cate_id DESC | | 1 | 0.00030 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 44) ORDER BY orderby_no DESC | | 1 | 0.00024 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 105 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00021 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '106' ORDER BY news_info_cate_id DESC | | 1 | 0.00026 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 44) ORDER BY orderby_no DESC | | 1 | 0.00027 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 106 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00021 |
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 | | 3 | 0.00076 |
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 | | 6 | 0.00078 |
SELECT image_ect.* FROM ac_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 | | 5 | 0.00074 |
SELECT image_ect.* FROM ac_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 | | 5 | 0.00061 |
SELECT image_ect.* FROM ac_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 | | 5 | 0.00064 |
SELECT image_ect.* FROM ac_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 | | 5 | 0.00064 |
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 | | 5 | 0.00066 |
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 (34 ) ) 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.warr_flg = 0 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 , 30 | | 4 | 0.00509 |
SELECT * FROM ac_c_server AS c_server WHERE c_server_id = 1 LIMIT 1 | | 1 | 0.00024 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '219' ORDER BY news_info_cate_id DESC | | 3 | 0.00024 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 32,34,43) ORDER BY orderby_no DESC | | 3 | 0.00028 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 219 AND orderby_no = 1 LIMIT 1 | | 3 | 0.00037 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '218' ORDER BY news_info_cate_id DESC | | 2 | 0.00039 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 35,34) ORDER BY orderby_no DESC | | 2 | 0.00034 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 218 AND orderby_no = 1 LIMIT 1 | | 2 | 0.00027 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '212' ORDER BY news_info_cate_id DESC | | 3 | 0.00030 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 30,34,45) ORDER BY orderby_no DESC | | 3 | 0.00049 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 212 AND orderby_no = 1 LIMIT 1 | | 3 | 0.00036 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '211' ORDER BY news_info_cate_id DESC | | 3 | 0.00044 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 30,34,45) ORDER BY orderby_no DESC | | 3 | 0.00039 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 211 AND orderby_no = 1 LIMIT 1 | | 3 | 0.00026 |
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 (32 ) ) 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.warr_flg = 0 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 , 30 | | 2 | 0.00283 |
SELECT * FROM ac_c_server AS c_server WHERE c_server_id = 1 LIMIT 1 | | 1 | 0.00045 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '219' ORDER BY news_info_cate_id DESC | | 3 | 0.00045 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 32,34,43) ORDER BY orderby_no DESC | | 3 | 0.00044 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 219 AND orderby_no = 1 LIMIT 1 | | 3 | 0.00032 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '186' ORDER BY news_info_cate_id DESC | | 2 | 0.00043 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 32,43) ORDER BY orderby_no DESC | | 2 | 0.00035 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 186 AND orderby_no = 1 LIMIT 1 | | 2 | 0.00024 |
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 (35 ) ) 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.warr_flg = 0 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 , 30 | | 1 | 0.00269 |
SELECT * FROM ac_c_server AS c_server WHERE c_server_id = 1 LIMIT 1 | | 1 | 0.00045 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '218' ORDER BY news_info_cate_id DESC | | 2 | 0.00050 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 35,34) ORDER BY orderby_no DESC | | 2 | 0.00045 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 218 AND orderby_no = 1 LIMIT 1 | | 2 | 0.00032 |
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 (27 ) ) 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.warr_flg = 0 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 , 30 | | 1 | 0.00275 |
SELECT * FROM ac_c_server AS c_server WHERE c_server_id = 1 LIMIT 1 | | 1 | 0.00036 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '182' ORDER BY news_info_cate_id DESC | | 2 | 0.00051 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 27,42) ORDER BY orderby_no DESC | | 2 | 0.00043 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 182 AND orderby_no = 1 LIMIT 1 | | 2 | 0.00037 |
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 (30 ) ) 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.warr_flg = 0 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 , 30 | | 3 | 0.00556 |
SELECT * FROM ac_c_server AS c_server WHERE c_server_id = 1 LIMIT 1 | | 1 | 0.00039 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '213' ORDER BY news_info_cate_id DESC | | 2 | 0.00039 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 30,45) ORDER BY orderby_no DESC | | 2 | 0.00046 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 213 AND orderby_no = 1 LIMIT 1 | | 2 | 0.00036 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '212' ORDER BY news_info_cate_id DESC | | 3 | 0.00051 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 30,34,45) ORDER BY orderby_no DESC | | 3 | 0.00045 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 212 AND orderby_no = 1 LIMIT 1 | | 3 | 0.00035 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '211' ORDER BY news_info_cate_id DESC | | 3 | 0.00050 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 30,34,45) ORDER BY orderby_no DESC | | 3 | 0.00051 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 211 AND orderby_no = 1 LIMIT 1 | | 3 | 0.00036 |
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 (36 ) ) 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.warr_flg = 0 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 , 30 | | 3 | 0.00285 |
SELECT * FROM ac_c_server AS c_server WHERE c_server_id = 1 LIMIT 1 | | 1 | 0.00031 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '220' ORDER BY news_info_cate_id DESC | | 1 | 0.00032 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 36) ORDER BY orderby_no DESC | | 1 | 0.00027 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 220 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00023 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '215' ORDER BY news_info_cate_id DESC | | 1 | 0.00029 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 36) ORDER BY orderby_no DESC | | 1 | 0.00027 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 215 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00024 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '216' ORDER BY news_info_cate_id DESC | | 1 | 0.00027 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 36) ORDER BY orderby_no DESC | | 1 | 0.00026 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 216 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00022 |
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 (37 ) ) 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.warr_flg = 0 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 , 30 | | 3 | 0.00296 |
SELECT * FROM ac_c_server AS c_server WHERE c_server_id = 1 LIMIT 1 | | 1 | 0.00029 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '214' ORDER BY news_info_cate_id DESC | | 1 | 0.00030 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 37) ORDER BY orderby_no DESC | | 1 | 0.00026 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 214 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00035 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '196' ORDER BY news_info_cate_id DESC | | 1 | 0.00036 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 37) ORDER BY orderby_no DESC | | 1 | 0.00026 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 196 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00022 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '195' ORDER BY news_info_cate_id DESC | | 1 | 0.00028 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 37) ORDER BY orderby_no DESC | | 1 | 0.00026 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 195 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00022 |
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 (38 ) ) 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.warr_flg = 0 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 , 30 | | 1 | 0.00232 |
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 (39 ) ) 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.warr_flg = 0 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 , 30 | | 1 | 0.00206 |
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 (41 ) ) 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.warr_flg = 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 , 30 | | 1 | 0.00223 |