SQL | ERROR | ROWS | TIME |
---|
|
SET NAMES utf8 ; | | | 0.00022 |
SET SESSION sql_mode = ''; | | | 0.00021 |
SELECT * FROM ac_news_member_conf WHERE news_member_conf_id =1 LIMIT 1 | | 1 | 0.00070 |
SELECT * FROM ac_c_server AS c_server WHERE c_server_id = 1 LIMIT 1 | | 1 | 0.00032 |
SELECT * FROM ac_news_layout_top_conf WHERE news_layout_top_conf_id=1 LIMIT 1 | | 1 | 0.00040 |
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.00156 |
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 | | 23 | 0.01223 |
SELECT * FROM ac_c_server AS c_server WHERE c_server_id = 1 LIMIT 1 | | 1 | 0.00046 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '246' ORDER BY news_info_cate_id DESC | | 3 | 0.00052 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 30,34,45) ORDER BY orderby_no DESC | | 3 | 0.00052 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 246 AND orderby_no = 1 LIMIT 1 | | 3 | 0.00037 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '245' ORDER BY news_info_cate_id DESC | | 3 | 0.00054 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 30,34,45) ORDER BY orderby_no DESC | | 3 | 0.00052 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 245 AND orderby_no = 1 LIMIT 1 | | 3 | 0.00035 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '244' ORDER BY news_info_cate_id DESC | | 1 | 0.00042 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 36) ORDER BY orderby_no DESC | | 1 | 0.00037 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 244 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00039 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '243' ORDER BY news_info_cate_id DESC | | 1 | 0.00043 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 32) ORDER BY orderby_no DESC | | 1 | 0.00038 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 243 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00037 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '242' ORDER BY news_info_cate_id DESC | | 1 | 0.00042 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 44) ORDER BY orderby_no DESC | | 1 | 0.00037 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 242 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00034 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '238' ORDER BY news_info_cate_id DESC | | 1 | 0.00048 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 38) ORDER BY orderby_no DESC | | 1 | 0.00037 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 238 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00034 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '241' ORDER BY news_info_cate_id DESC | | 2 | 0.00047 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 38,44) ORDER BY orderby_no DESC | | 2 | 0.00046 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 241 AND orderby_no = 1 LIMIT 1 | | 2 | 0.00043 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '240' ORDER BY news_info_cate_id DESC | | 3 | 0.00043 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 30,34,45) ORDER BY orderby_no DESC | | 3 | 0.00048 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 240 AND orderby_no = 1 LIMIT 1 | | 3 | 0.00029 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '239' ORDER BY news_info_cate_id DESC | | 1 | 0.00033 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 32) ORDER BY orderby_no DESC | | 1 | 0.00029 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 239 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00024 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '236' 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= 236 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00025 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '233' ORDER BY news_info_cate_id DESC | | 1 | 0.00026 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 32) ORDER BY orderby_no DESC | | 1 | 0.00024 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 233 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00022 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '232' ORDER BY news_info_cate_id DESC | | 1 | 0.00028 |
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= 232 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00021 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '235' ORDER BY news_info_cate_id DESC | | 2 | 0.00027 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 35,34) ORDER BY orderby_no DESC | | 2 | 0.00032 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 235 AND orderby_no = 1 LIMIT 1 | | 2 | 0.00022 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '234' ORDER BY news_info_cate_id DESC | | 3 | 0.00028 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 32,34,43) ORDER BY orderby_no DESC | | 3 | 0.00032 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 234 AND orderby_no = 1 LIMIT 1 | | 3 | 0.00023 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '230' ORDER BY news_info_cate_id DESC | | 1 | 0.00026 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 37) ORDER BY orderby_no DESC | | 1 | 0.00023 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 230 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00021 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '228' ORDER BY news_info_cate_id DESC | | 2 | 0.00026 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 27,42) ORDER BY orderby_no DESC | | 2 | 0.00030 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 228 AND orderby_no = 1 LIMIT 1 | | 2 | 0.00022 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '227' ORDER BY news_info_cate_id DESC | | 3 | 0.00027 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 27,34,42) ORDER BY orderby_no DESC | | 3 | 0.00033 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 227 AND orderby_no = 1 LIMIT 1 | | 3 | 0.00022 |
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.00023 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 215 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00021 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '196' ORDER BY news_info_cate_id DESC | | 1 | 0.00026 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 37) ORDER BY orderby_no DESC | | 1 | 0.00024 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 196 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00021 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '195' ORDER BY news_info_cate_id DESC | | 1 | 0.00027 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 37) ORDER BY orderby_no DESC | | 1 | 0.00023 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 195 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00021 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '186' ORDER BY news_info_cate_id DESC | | 2 | 0.00026 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 32,43) ORDER BY orderby_no DESC | | 2 | 0.00028 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 186 AND orderby_no = 1 LIMIT 1 | | 2 | 0.00022 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '105' 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.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.00025 |
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= 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 | | 5 | 0.00063 |
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.00070 |
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.00070 |
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.00060 |
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.00071 |
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.00054 |
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.00048 |
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 | | 6 | 0.00658 |
SELECT * FROM ac_c_server AS c_server WHERE c_server_id = 1 LIMIT 1 | | 1 | 0.00022 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '246' ORDER BY news_info_cate_id DESC | | 3 | 0.00049 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 30,34,45) ORDER BY orderby_no DESC | | 3 | 0.00043 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 246 AND orderby_no = 1 LIMIT 1 | | 3 | 0.00025 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '245' ORDER BY news_info_cate_id DESC | | 3 | 0.00031 |
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= 245 AND orderby_no = 1 LIMIT 1 | | 3 | 0.00024 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '240' ORDER BY news_info_cate_id DESC | | 3 | 0.00042 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 30,34,45) ORDER BY orderby_no DESC | | 3 | 0.00038 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 240 AND orderby_no = 1 LIMIT 1 | | 3 | 0.00024 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '235' 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.00031 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 235 AND orderby_no = 1 LIMIT 1 | | 2 | 0.00025 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '234' ORDER BY news_info_cate_id DESC | | 3 | 0.00043 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 32,34,43) ORDER BY orderby_no DESC | | 3 | 0.00047 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 234 AND orderby_no = 1 LIMIT 1 | | 3 | 0.00035 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '227' ORDER BY news_info_cate_id DESC | | 3 | 0.00043 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 27,34,42) ORDER BY orderby_no DESC | | 3 | 0.00039 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 227 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 | | 5 | 0.00329 |
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 = '243' ORDER BY news_info_cate_id DESC | | 1 | 0.00031 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 32) ORDER BY orderby_no DESC | | 1 | 0.00027 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 243 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00023 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '239' ORDER BY news_info_cate_id DESC | | 1 | 0.00046 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 32) ORDER BY orderby_no DESC | | 1 | 0.00039 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 239 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00034 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '233' ORDER BY news_info_cate_id DESC | | 1 | 0.00036 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 32) ORDER BY orderby_no DESC | | 1 | 0.00025 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 233 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00022 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '234' ORDER BY news_info_cate_id DESC | | 3 | 0.00043 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 32,34,43) ORDER BY orderby_no DESC | | 3 | 0.00047 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 234 AND orderby_no = 1 LIMIT 1 | | 3 | 0.00035 |
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.00044 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 186 AND orderby_no = 1 LIMIT 1 | | 2 | 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 (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.00270 |
SELECT * FROM ac_c_server AS c_server WHERE c_server_id = 1 LIMIT 1 | | 1 | 0.00037 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '235' ORDER BY news_info_cate_id DESC | | 2 | 0.00034 |
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= 235 AND orderby_no = 1 LIMIT 1 | | 2 | 0.00025 |
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 | | 2 | 0.00286 |
SELECT * FROM ac_c_server AS c_server WHERE c_server_id = 1 LIMIT 1 | | 1 | 0.00030 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '228' ORDER BY news_info_cate_id DESC | | 2 | 0.00030 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 27,42) ORDER BY orderby_no DESC | | 2 | 0.00035 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 228 AND orderby_no = 1 LIMIT 1 | | 2 | 0.00023 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '227' ORDER BY news_info_cate_id DESC | | 3 | 0.00030 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 27,34,42) ORDER BY orderby_no DESC | | 3 | 0.00034 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 227 AND orderby_no = 1 LIMIT 1 | | 3 | 0.00025 |
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.00648 |
SELECT * FROM ac_c_server AS c_server WHERE c_server_id = 1 LIMIT 1 | | 1 | 0.00030 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '246' ORDER BY news_info_cate_id DESC | | 3 | 0.00032 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 30,34,45) ORDER BY orderby_no DESC | | 3 | 0.00037 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 246 AND orderby_no = 1 LIMIT 1 | | 3 | 0.00023 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '245' ORDER BY news_info_cate_id DESC | | 3 | 0.00043 |
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= 245 AND orderby_no = 1 LIMIT 1 | | 3 | 0.00025 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '240' ORDER BY news_info_cate_id DESC | | 3 | 0.00034 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 30,34,45) ORDER BY orderby_no DESC | | 3 | 0.00033 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 240 AND orderby_no = 1 LIMIT 1 | | 3 | 0.00027 |
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.00037 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '244' ORDER BY news_info_cate_id DESC | | 1 | 0.00035 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 36) ORDER BY orderby_no DESC | | 1 | 0.00025 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 244 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00023 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '236' ORDER BY news_info_cate_id DESC | | 1 | 0.00028 |
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= 236 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00022 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '215' ORDER BY news_info_cate_id DESC | | 1 | 0.00028 |
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= 215 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.00305 |
SELECT * FROM ac_c_server AS c_server WHERE c_server_id = 1 LIMIT 1 | | 1 | 0.00037 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '230' 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= 230 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00023 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '196' ORDER BY news_info_cate_id DESC | | 1 | 0.00042 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 37) ORDER BY orderby_no DESC | | 1 | 0.00028 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 196 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00023 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '195' ORDER BY news_info_cate_id DESC | | 1 | 0.00042 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 37) ORDER BY orderby_no DESC | | 1 | 0.00029 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 195 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00034 |
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 | | 2 | 0.00281 |
SELECT * FROM ac_c_server AS c_server WHERE c_server_id = 1 LIMIT 1 | | 1 | 0.00028 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '238' ORDER BY news_info_cate_id DESC | | 1 | 0.00032 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 38) ORDER BY orderby_no DESC | | 1 | 0.00026 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 238 AND orderby_no = 1 LIMIT 1 | | 1 | 0.00023 |
SELECT * FROM ac_news_info_cate WHERE news_info_id = '241' ORDER BY news_info_cate_id DESC | | 2 | 0.00042 |
SELECT * FROM ac_news_cate WHERE news_cate_id in( 38,44) ORDER BY orderby_no DESC | | 2 | 0.00037 |
SELECT * FROM ac_news_image AS news_image WHERE news_info_id= 241 AND orderby_no = 1 LIMIT 1 | | 2 | 0.00023 |
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 | | 2 | 0.00234 |
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 | | 2 | 0.00229 |