SQL | ERROR | ROWS | TIME |
---|
|
SET NAMES utf8 ; | | | 0.00037 |
SELECT block_info_id FROM ac_block_info AS block_info WHERE block_info_id = 1 | | 1 | 0.00093 |
SELECT * FROM ac_block_info_access AS block_info_access WHERE block_info_id= 1 AND access_date = '2024-04-28' AND dir_id = '0' LIMIT 1 | | 1 | 0.02944 |
UPDATE ac_block_info_access SET `block_info_id`='1',`dir_id`='0',`access_date`='2024-04-28',`ip`='ec2-13-59-61-119.us-east-2.compute.amazonaws.com',`cont`='3',`modified`='2024-04-28 05:36:19' WHERE block_info_id = '1' AND access_date = '2024-04-28' AND dir_id = '0' | | 1 | 0.00669 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE prodir_level = 2 AND dir_id != 5 ORDER BY orderby_no | | 4 | 0.00062 |
SELECT * FROM ac_block_info AS block_info WHERE block_info_id = 10 LIMIT 1 | | 1 | 0.00034 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '2' LIMIT 1 | | 1 | 0.00024 |
SELECT * FROM ac_block_info_change AS block_info_change WHERE dir_id = 2 AND change_flg = 1 AND change_day <= now() | | 1 | 0.00065 |
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 | | 5 | 0.00303 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '2' LIMIT 1 | | 1 | 0.00088 |
SELECT * FROM ac_block_info_change AS block_info_change WHERE dir_id = 2 AND change_flg = 1 AND change_day <= now() | | 1 | 0.00060 |
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 | | 5 | 0.00230 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '2' LIMIT 1 | | 1 | 0.00024 |
SELECT * FROM ac_block_info AS block_info WHERE block_info_id = 11 LIMIT 1 | | 1 | 0.00023 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '3' LIMIT 1 | | 1 | 0.00023 |
SELECT * FROM ac_block_info_change AS block_info_change WHERE dir_id = 3 AND change_flg = 1 AND change_day <= now() | | 1 | 0.00024 |
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 | | 4 | 0.00216 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '3' LIMIT 1 | | 1 | 0.00024 |
SELECT * FROM ac_block_info_change AS block_info_change WHERE dir_id = 3 AND change_flg = 1 AND change_day <= now() | | 1 | 0.00024 |
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 | | 4 | 0.07234 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '3' LIMIT 1 | | 1 | 0.00023 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE prodir_level = 2 AND dir_id != 5 ORDER BY orderby_no | | 4 | 0.00029 |
SELECT * FROM ac_block_info AS block_info WHERE block_info_id = 10 LIMIT 1 | | 1 | 0.00032 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '2' LIMIT 1 | | 1 | 0.00020 |
SELECT * FROM ac_block_info_change AS block_info_change WHERE dir_id = 2 AND change_flg = 1 AND change_day <= now() | | 1 | 0.00023 |
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 | | 5 | 0.00147 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '2' LIMIT 1 | | 1 | 0.00022 |
SELECT * FROM ac_block_info AS block_info WHERE block_info_id = 11 LIMIT 1 | | 1 | 0.00022 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '3' LIMIT 1 | | 1 | 0.00021 |
SELECT * FROM ac_block_info_change AS block_info_change WHERE dir_id = 3 AND change_flg = 1 AND change_day <= now() | | 1 | 0.00021 |
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 | | 4 | 0.00210 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '3' LIMIT 1 | | 1 | 0.00021 |
SELECT * FROM ac_block_info_change AS block_info_change WHERE dir_id = 999 AND change_flg = 1 AND change_day <= now() | | 1 | 0.00023 |
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.00146 |
SELECT * FROM ac_ps_dir AS ps_dir WHERE dir_id = '999' LIMIT 1 | | 1 | 0.00022 |
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 | | 1 | 0.00067 |
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.00026 |