SQL | ERROR | ROWS | TIME |
---|
|
SET NAMES utf8 ; | | | 0.00006 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE prodir_level = 2 ORDER BY orderby_no | | 16 | 0.00025 |
SELECT * FROM ac_block_info AS block_info WHERE block_info_id = 10 LIMIT 1 | | 1 | 0.00016 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '2' LIMIT 1 | | 1 | 0.00010 |
SELECT * FROM ac_block_info_change AS block_info_change WHERE dir_id = 2 AND change_flg = 1 AND change_day <= now() | | 1 | 0.00013 |
SELECT DISTINCT block_info.* , block_info_dir.block_info_dir_id , block_info_dir.opening as server_opening , block_info_dir.opening_pc as server_opening_pc , block_info_dir.select_orderby_no as server_select_orderby_no , block_info_dir.orderby_no as server_orderby_no FROM ac_block_info AS block_info LEFT JOIN ac_block_info_dir as block_info_dir ON block_info.block_info_id = block_info_dir.block_info_id WHERE block_info_dir.dir_id = 2 AND ( block_info.beginend_flg = 1 OR ( block_info.beginend_flg = 0 AND (( block_info.endconf_flg = 1 AND block_info.begin <= now() AND now() <= block_info.end ) OR (block_info.endconf_flg = 0 AND block_info.begin <= now() ) ) ) ) AND block_info_dir.opening = 1 AND block_info_dir.opening_menu = 1 AND block_info.status = 1 AND block_info.template_flg IN ( 0 ,2 ) ORDER BY block_info_dir.select_orderby_no DESC , block_info_dir.orderby_no DESC LIMIT 0 , 10000 | | 1 | 0.00082 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '2' LIMIT 1 | | 1 | 0.00010 |
SELECT * FROM ac_block_info AS block_info WHERE block_info_id = 11 LIMIT 1 | | 1 | 0.00010 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '3' LIMIT 1 | | 1 | 0.00008 |
SELECT * FROM ac_block_info_change AS block_info_change WHERE dir_id = 3 AND change_flg = 1 AND change_day <= now() | | 1 | 0.00010 |
SELECT DISTINCT block_info.* , block_info_dir.block_info_dir_id , block_info_dir.opening as server_opening , block_info_dir.opening_pc as server_opening_pc , block_info_dir.select_orderby_no as server_select_orderby_no , block_info_dir.orderby_no as server_orderby_no FROM ac_block_info AS block_info LEFT JOIN ac_block_info_dir as block_info_dir ON block_info.block_info_id = block_info_dir.block_info_id WHERE block_info_dir.dir_id = 3 AND ( block_info.beginend_flg = 1 OR ( block_info.beginend_flg = 0 AND (( block_info.endconf_flg = 1 AND block_info.begin <= now() AND now() <= block_info.end ) OR (block_info.endconf_flg = 0 AND block_info.begin <= now() ) ) ) ) AND block_info_dir.opening = 1 AND block_info_dir.opening_menu = 1 AND block_info.status = 1 AND block_info.template_flg IN ( 0 ,2 ) ORDER BY block_info_dir.select_orderby_no DESC , block_info_dir.orderby_no DESC LIMIT 0 , 10000 | | 11 | 0.00529 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '3' LIMIT 1 | | 1 | 0.00009 |
SELECT * FROM ac_block_info AS block_info WHERE block_info_id = 12 LIMIT 1 | | 1 | 0.00012 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '4' LIMIT 1 | | 1 | 0.00009 |
SELECT * FROM ac_block_info_change AS block_info_change WHERE dir_id = 4 AND change_flg = 1 AND change_day <= now() | | 1 | 0.00010 |
SELECT DISTINCT block_info.* , block_info_dir.block_info_dir_id , block_info_dir.opening as server_opening , block_info_dir.opening_pc as server_opening_pc , block_info_dir.select_orderby_no as server_select_orderby_no , block_info_dir.orderby_no as server_orderby_no FROM ac_block_info AS block_info LEFT JOIN ac_block_info_dir as block_info_dir ON block_info.block_info_id = block_info_dir.block_info_id WHERE block_info_dir.dir_id = 4 AND ( block_info.beginend_flg = 1 OR ( block_info.beginend_flg = 0 AND (( block_info.endconf_flg = 1 AND block_info.begin <= now() AND now() <= block_info.end ) OR (block_info.endconf_flg = 0 AND block_info.begin <= now() ) ) ) ) AND block_info_dir.opening = 1 AND block_info_dir.opening_menu = 1 AND block_info.status = 1 AND block_info.template_flg IN ( 0 ,2 ) ORDER BY block_info_dir.select_orderby_no DESC , block_info_dir.orderby_no DESC LIMIT 0 , 10000 | | 6 | 0.00139 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '4' LIMIT 1 | | 1 | 0.00009 |
SELECT * FROM ac_block_info AS block_info WHERE block_info_id = 13 LIMIT 1 | | 1 | 0.00010 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '5' LIMIT 1 | | 1 | 0.00009 |
SELECT * FROM ac_block_info_change AS block_info_change WHERE dir_id = 5 AND change_flg = 1 AND change_day <= now() | | 1 | 0.00010 |
SELECT DISTINCT block_info.* , block_info_dir.block_info_dir_id , block_info_dir.opening as server_opening , block_info_dir.opening_pc as server_opening_pc , block_info_dir.select_orderby_no as server_select_orderby_no , block_info_dir.orderby_no as server_orderby_no FROM ac_block_info AS block_info LEFT JOIN ac_block_info_dir as block_info_dir ON block_info.block_info_id = block_info_dir.block_info_id WHERE block_info_dir.dir_id = 5 AND ( block_info.beginend_flg = 1 OR ( block_info.beginend_flg = 0 AND (( block_info.endconf_flg = 1 AND block_info.begin <= now() AND now() <= block_info.end ) OR (block_info.endconf_flg = 0 AND block_info.begin <= now() ) ) ) ) AND block_info_dir.opening = 1 AND block_info_dir.opening_menu = 1 AND block_info.status = 1 AND block_info.template_flg IN ( 0 ,2 ) ORDER BY block_info_dir.select_orderby_no DESC , block_info_dir.orderby_no DESC LIMIT 0 , 10000 | | 1 | 0.00081 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '5' LIMIT 1 | | 1 | 0.00009 |
SELECT * FROM ac_block_info AS block_info WHERE block_info_id = 16 LIMIT 1 | | 1 | 0.00010 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '6' LIMIT 1 | | 1 | 0.00009 |
SELECT * FROM ac_block_info_change AS block_info_change WHERE dir_id = 6 AND change_flg = 1 AND change_day <= now() | | 1 | 0.00010 |
SELECT DISTINCT block_info.* , block_info_dir.block_info_dir_id , block_info_dir.opening as server_opening , block_info_dir.opening_pc as server_opening_pc , block_info_dir.select_orderby_no as server_select_orderby_no , block_info_dir.orderby_no as server_orderby_no FROM ac_block_info AS block_info LEFT JOIN ac_block_info_dir as block_info_dir ON block_info.block_info_id = block_info_dir.block_info_id WHERE block_info_dir.dir_id = 6 AND ( block_info.beginend_flg = 1 OR ( block_info.beginend_flg = 0 AND (( block_info.endconf_flg = 1 AND block_info.begin <= now() AND now() <= block_info.end ) OR (block_info.endconf_flg = 0 AND block_info.begin <= now() ) ) ) ) AND block_info_dir.opening = 1 AND block_info_dir.opening_menu = 1 AND block_info.status = 1 AND block_info.template_flg IN ( 0 ,2 ) ORDER BY block_info_dir.select_orderby_no DESC , block_info_dir.orderby_no DESC LIMIT 0 , 10000 | | 1 | 0.00077 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '6' LIMIT 1 | | 1 | 0.00009 |
SELECT * FROM ac_block_info AS block_info WHERE block_info_id = 17 LIMIT 1 | | 1 | 0.00010 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '7' LIMIT 1 | | 1 | 0.00009 |
SELECT * FROM ac_block_info_change AS block_info_change WHERE dir_id = 7 AND change_flg = 1 AND change_day <= now() | | 1 | 0.00010 |
SELECT DISTINCT block_info.* , block_info_dir.block_info_dir_id , block_info_dir.opening as server_opening , block_info_dir.opening_pc as server_opening_pc , block_info_dir.select_orderby_no as server_select_orderby_no , block_info_dir.orderby_no as server_orderby_no FROM ac_block_info AS block_info LEFT JOIN ac_block_info_dir as block_info_dir ON block_info.block_info_id = block_info_dir.block_info_id WHERE block_info_dir.dir_id = 7 AND ( block_info.beginend_flg = 1 OR ( block_info.beginend_flg = 0 AND (( block_info.endconf_flg = 1 AND block_info.begin <= now() AND now() <= block_info.end ) OR (block_info.endconf_flg = 0 AND block_info.begin <= now() ) ) ) ) AND block_info_dir.opening = 1 AND block_info_dir.opening_menu = 1 AND block_info.status = 1 AND block_info.template_flg IN ( 0 ,2 ) ORDER BY block_info_dir.select_orderby_no DESC , block_info_dir.orderby_no DESC LIMIT 0 , 10000 | | 1 | 0.00077 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '7' LIMIT 1 | | 1 | 0.00009 |
SELECT * FROM ac_block_info AS block_info WHERE block_info_id = 18 LIMIT 1 | | 1 | 0.00013 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '8' LIMIT 1 | | 1 | 0.00009 |
SELECT * FROM ac_block_info_change AS block_info_change WHERE dir_id = 8 AND change_flg = 1 AND change_day <= now() | | 1 | 0.00010 |
SELECT DISTINCT block_info.* , block_info_dir.block_info_dir_id , block_info_dir.opening as server_opening , block_info_dir.opening_pc as server_opening_pc , block_info_dir.select_orderby_no as server_select_orderby_no , block_info_dir.orderby_no as server_orderby_no FROM ac_block_info AS block_info LEFT JOIN ac_block_info_dir as block_info_dir ON block_info.block_info_id = block_info_dir.block_info_id WHERE block_info_dir.dir_id = 8 AND ( block_info.beginend_flg = 1 OR ( block_info.beginend_flg = 0 AND (( block_info.endconf_flg = 1 AND block_info.begin <= now() AND now() <= block_info.end ) OR (block_info.endconf_flg = 0 AND block_info.begin <= now() ) ) ) ) AND block_info_dir.opening = 1 AND block_info_dir.opening_menu = 1 AND block_info.status = 1 AND block_info.template_flg IN ( 0 ,2 ) ORDER BY block_info_dir.select_orderby_no DESC , block_info_dir.orderby_no DESC LIMIT 0 , 10000 | | 1 | 0.00087 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '8' LIMIT 1 | | 1 | 0.00009 |
SELECT * FROM ac_block_info AS block_info WHERE block_info_id = 19 LIMIT 1 | | 1 | 0.00013 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '9' LIMIT 1 | | 1 | 0.00009 |
SELECT * FROM ac_block_info_change AS block_info_change WHERE dir_id = 9 AND change_flg = 1 AND change_day <= now() | | 1 | 0.00010 |
SELECT DISTINCT block_info.* , block_info_dir.block_info_dir_id , block_info_dir.opening as server_opening , block_info_dir.opening_pc as server_opening_pc , block_info_dir.select_orderby_no as server_select_orderby_no , block_info_dir.orderby_no as server_orderby_no FROM ac_block_info AS block_info LEFT JOIN ac_block_info_dir as block_info_dir ON block_info.block_info_id = block_info_dir.block_info_id WHERE block_info_dir.dir_id = 9 AND ( block_info.beginend_flg = 1 OR ( block_info.beginend_flg = 0 AND (( block_info.endconf_flg = 1 AND block_info.begin <= now() AND now() <= block_info.end ) OR (block_info.endconf_flg = 0 AND block_info.begin <= now() ) ) ) ) AND block_info_dir.opening = 1 AND block_info_dir.opening_menu = 1 AND block_info.status = 1 AND block_info.template_flg IN ( 0 ,2 ) ORDER BY block_info_dir.select_orderby_no DESC , block_info_dir.orderby_no DESC LIMIT 0 , 10000 | | 2 | 0.00103 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '9' LIMIT 1 | | 1 | 0.00009 |
SELECT * FROM ac_block_info AS block_info WHERE block_info_id = 20 LIMIT 1 | | 1 | 0.00014 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '10' LIMIT 1 | | 1 | 0.00009 |
SELECT * FROM ac_block_info_change AS block_info_change WHERE dir_id = 10 AND change_flg = 1 AND change_day <= now() | | 1 | 0.00010 |
SELECT DISTINCT block_info.* , block_info_dir.block_info_dir_id , block_info_dir.opening as server_opening , block_info_dir.opening_pc as server_opening_pc , block_info_dir.select_orderby_no as server_select_orderby_no , block_info_dir.orderby_no as server_orderby_no FROM ac_block_info AS block_info LEFT JOIN ac_block_info_dir as block_info_dir ON block_info.block_info_id = block_info_dir.block_info_id WHERE block_info_dir.dir_id = 10 AND ( block_info.beginend_flg = 1 OR ( block_info.beginend_flg = 0 AND (( block_info.endconf_flg = 1 AND block_info.begin <= now() AND now() <= block_info.end ) OR (block_info.endconf_flg = 0 AND block_info.begin <= now() ) ) ) ) AND block_info_dir.opening = 1 AND block_info_dir.opening_menu = 1 AND block_info.status = 1 AND block_info.template_flg IN ( 0 ,2 ) ORDER BY block_info_dir.select_orderby_no DESC , block_info_dir.orderby_no DESC LIMIT 0 , 10000 | | 1 | 0.00077 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '10' LIMIT 1 | | 1 | 0.00009 |
SELECT * FROM ac_block_info AS block_info WHERE block_info_id = 21 LIMIT 1 | | 1 | 0.00011 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '11' LIMIT 1 | | 1 | 0.00008 |
SELECT * FROM ac_block_info_change AS block_info_change WHERE dir_id = 11 AND change_flg = 1 AND change_day <= now() | | 1 | 0.00010 |
SELECT DISTINCT block_info.* , block_info_dir.block_info_dir_id , block_info_dir.opening as server_opening , block_info_dir.opening_pc as server_opening_pc , block_info_dir.select_orderby_no as server_select_orderby_no , block_info_dir.orderby_no as server_orderby_no FROM ac_block_info AS block_info LEFT JOIN ac_block_info_dir as block_info_dir ON block_info.block_info_id = block_info_dir.block_info_id WHERE block_info_dir.dir_id = 11 AND ( block_info.beginend_flg = 1 OR ( block_info.beginend_flg = 0 AND (( block_info.endconf_flg = 1 AND block_info.begin <= now() AND now() <= block_info.end ) OR (block_info.endconf_flg = 0 AND block_info.begin <= now() ) ) ) ) AND block_info_dir.opening = 1 AND block_info_dir.opening_menu = 1 AND block_info.status = 1 AND block_info.template_flg IN ( 0 ,2 ) ORDER BY block_info_dir.select_orderby_no DESC , block_info_dir.orderby_no DESC LIMIT 0 , 10000 | | 1 | 0.00082 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '11' LIMIT 1 | | 1 | 0.00009 |
SELECT * FROM ac_block_info AS block_info WHERE block_info_id = 22 LIMIT 1 | | 1 | 0.00010 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '12' LIMIT 1 | | 1 | 0.00009 |
SELECT * FROM ac_block_info_change AS block_info_change WHERE dir_id = 12 AND change_flg = 1 AND change_day <= now() | | 1 | 0.00011 |
SELECT DISTINCT block_info.* , block_info_dir.block_info_dir_id , block_info_dir.opening as server_opening , block_info_dir.opening_pc as server_opening_pc , block_info_dir.select_orderby_no as server_select_orderby_no , block_info_dir.orderby_no as server_orderby_no FROM ac_block_info AS block_info LEFT JOIN ac_block_info_dir as block_info_dir ON block_info.block_info_id = block_info_dir.block_info_id WHERE block_info_dir.dir_id = 12 AND ( block_info.beginend_flg = 1 OR ( block_info.beginend_flg = 0 AND (( block_info.endconf_flg = 1 AND block_info.begin <= now() AND now() <= block_info.end ) OR (block_info.endconf_flg = 0 AND block_info.begin <= now() ) ) ) ) AND block_info_dir.opening = 1 AND block_info_dir.opening_menu = 1 AND block_info.status = 1 AND block_info.template_flg IN ( 0 ,2 ) ORDER BY block_info_dir.select_orderby_no DESC , block_info_dir.orderby_no DESC LIMIT 0 , 10000 | | 4 | 0.00107 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '12' LIMIT 1 | | 1 | 0.00009 |
SELECT * FROM ac_block_info AS block_info WHERE block_info_id = 23 LIMIT 1 | | 1 | 0.00010 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '13' LIMIT 1 | | 1 | 0.00008 |
SELECT * FROM ac_block_info_change AS block_info_change WHERE dir_id = 13 AND change_flg = 1 AND change_day <= now() | | 1 | 0.00010 |
SELECT DISTINCT block_info.* , block_info_dir.block_info_dir_id , block_info_dir.opening as server_opening , block_info_dir.opening_pc as server_opening_pc , block_info_dir.select_orderby_no as server_select_orderby_no , block_info_dir.orderby_no as server_orderby_no FROM ac_block_info AS block_info LEFT JOIN ac_block_info_dir as block_info_dir ON block_info.block_info_id = block_info_dir.block_info_id WHERE block_info_dir.dir_id = 13 AND ( block_info.beginend_flg = 1 OR ( block_info.beginend_flg = 0 AND (( block_info.endconf_flg = 1 AND block_info.begin <= now() AND now() <= block_info.end ) OR (block_info.endconf_flg = 0 AND block_info.begin <= now() ) ) ) ) AND block_info_dir.opening = 1 AND block_info_dir.opening_menu = 1 AND block_info.status = 1 AND block_info.template_flg IN ( 0 ,2 ) ORDER BY block_info_dir.select_orderby_no DESC , block_info_dir.orderby_no DESC LIMIT 0 , 10000 | | 6 | 0.00178 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '13' LIMIT 1 | | 1 | 0.00009 |
SELECT * FROM ac_block_info AS block_info WHERE block_info_id = 24 LIMIT 1 | | 1 | 0.00011 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '14' LIMIT 1 | | 1 | 0.00009 |
SELECT * FROM ac_block_info_change AS block_info_change WHERE dir_id = 14 AND change_flg = 1 AND change_day <= now() | | 1 | 0.00010 |
SELECT DISTINCT block_info.* , block_info_dir.block_info_dir_id , block_info_dir.opening as server_opening , block_info_dir.opening_pc as server_opening_pc , block_info_dir.select_orderby_no as server_select_orderby_no , block_info_dir.orderby_no as server_orderby_no FROM ac_block_info AS block_info LEFT JOIN ac_block_info_dir as block_info_dir ON block_info.block_info_id = block_info_dir.block_info_id WHERE block_info_dir.dir_id = 14 AND ( block_info.beginend_flg = 1 OR ( block_info.beginend_flg = 0 AND (( block_info.endconf_flg = 1 AND block_info.begin <= now() AND now() <= block_info.end ) OR (block_info.endconf_flg = 0 AND block_info.begin <= now() ) ) ) ) AND block_info_dir.opening = 1 AND block_info_dir.opening_menu = 1 AND block_info.status = 1 AND block_info.template_flg IN ( 0 ,2 ) ORDER BY block_info_dir.select_orderby_no DESC , block_info_dir.orderby_no DESC LIMIT 0 , 10000 | | 3 | 0.00124 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '14' LIMIT 1 | | 1 | 0.00009 |
SELECT * FROM ac_block_info AS block_info WHERE block_info_id = 25 LIMIT 1 | | 1 | 0.00012 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '15' LIMIT 1 | | 1 | 0.00009 |
SELECT * FROM ac_block_info_change AS block_info_change WHERE dir_id = 15 AND change_flg = 1 AND change_day <= now() | | 1 | 0.00010 |
SELECT DISTINCT block_info.* , block_info_dir.block_info_dir_id , block_info_dir.opening as server_opening , block_info_dir.opening_pc as server_opening_pc , block_info_dir.select_orderby_no as server_select_orderby_no , block_info_dir.orderby_no as server_orderby_no FROM ac_block_info AS block_info LEFT JOIN ac_block_info_dir as block_info_dir ON block_info.block_info_id = block_info_dir.block_info_id WHERE block_info_dir.dir_id = 15 AND ( block_info.beginend_flg = 1 OR ( block_info.beginend_flg = 0 AND (( block_info.endconf_flg = 1 AND block_info.begin <= now() AND now() <= block_info.end ) OR (block_info.endconf_flg = 0 AND block_info.begin <= now() ) ) ) ) AND block_info_dir.opening = 1 AND block_info_dir.opening_menu = 1 AND block_info.status = 1 AND block_info.template_flg IN ( 0 ,2 ) ORDER BY block_info_dir.select_orderby_no DESC , block_info_dir.orderby_no DESC LIMIT 0 , 10000 | | 2 | 0.00095 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '15' LIMIT 1 | | 1 | 0.00010 |
SELECT * FROM ac_block_info_change AS block_info_change WHERE dir_id = 999 AND change_flg = 1 AND change_day <= now() | | 1 | 0.00010 |
SELECT DISTINCT block_info.* , block_info_dir.block_info_dir_id , block_info_dir.opening as server_opening , block_info_dir.opening_pc as server_opening_pc , block_info_dir.select_orderby_no as server_select_orderby_no , block_info_dir.orderby_no as server_orderby_no FROM ac_block_info AS block_info LEFT JOIN ac_block_info_dir as block_info_dir ON block_info.block_info_id = block_info_dir.block_info_id WHERE block_info_dir.dir_id = 999 AND ( block_info.beginend_flg = 1 OR ( block_info.beginend_flg = 0 AND (( block_info.endconf_flg = 1 AND block_info.begin <= now() AND now() <= block_info.end ) OR (block_info.endconf_flg = 0 AND block_info.begin <= now() ) ) ) ) AND block_info_dir.opening = 1 AND block_info_dir.opening_menu = 1 AND block_info.status = 1 AND block_info.template_flg IN ( 0 ,2 ) ORDER BY block_info_dir.select_orderby_no DESC , block_info_dir.orderby_no DESC LIMIT 0 , 10000 | | 3 | 0.00081 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '999' LIMIT 1 | | 1 | 0.00009 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE prodir_level = 2 ORDER BY orderby_no | | 16 | 0.00022 |
SELECT * FROM ac_block_info_change AS block_info_change WHERE dir_id = 999 AND change_flg = 1 AND change_day <= now() | | 16 | 0.00010 |
SELECT DISTINCT block_info.* , block_info_dir.block_info_dir_id , block_info_dir.opening as server_opening , block_info_dir.opening_pc as server_opening_pc , block_info_dir.select_orderby_no as server_select_orderby_no , block_info_dir.orderby_no as server_orderby_no FROM ac_block_info AS block_info LEFT JOIN ac_block_info_dir as block_info_dir ON block_info.block_info_id = block_info_dir.block_info_id WHERE block_info_dir.dir_id = 999 AND ( block_info.beginend_flg = 1 OR ( block_info.beginend_flg = 0 AND (( block_info.endconf_flg = 1 AND block_info.begin <= now() AND now() <= block_info.end ) OR (block_info.endconf_flg = 0 AND block_info.begin <= now() ) ) ) ) AND block_info_dir.opening = 1 AND block_info_dir.opening_menu = 1 AND block_info.status = 1 AND block_info.template_flg IN ( 0 ,2 ) ORDER BY block_info_dir.select_orderby_no DESC , block_info_dir.orderby_no DESC LIMIT 0 , 10000 | | 3 | 0.00091 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '999' LIMIT 1 | | 1 | 0.00010 |