| 0.0005 |
SELECT GET_LOCK('onk12kkmd9b3gh43ipmemtdns1rr418l', 300) AS ci_session_lock
|
| 0.0006 |
SELECT `data`
FROM `ci_sessions`
WHERE `id` = 'onk12kkmd9b3gh43ipmemtdns1rr418l'
|
| 0.0013 |
SELECT *
FROM `inu_settings`
|
| 0.0004 |
SELECT *
FROM `inu_file`
WHERE `file_category` = 'site_og'
ORDER BY `file_order` asc, `file_regdate` asc, `file_order` asc, `file_orig_name` asc
|
| 0.0005 |
SELECT *
FROM `inu_page`
WHERE `page_id` = 'faq'
AND `page_group` = 'ja'
|
| 0.0004 |
SELECT *
FROM `inu_page`
WHERE `page_idx` = '141'
|
| 0.0005 |
SELECT *
FROM `inu_board`
WHERE `bd_idx` = '4'
|
| 0.0004 |
SELECT COUNT(*) AS `numrows`
FROM `inu_board_category`
WHERE `bcat_bd_idx` = 4 AND `bcat_status` = 1
|
| 0.0008 |
SELECT *
FROM `inu_board_category`
WHERE `bcat_bd_idx` = 4 AND `bcat_status` = 1
ORDER BY `bcat_order` ASC
LIMIT 100, 10
|
| 0.0004 |
SELECT *
FROM `inu_board`
WHERE `bd_idx` = '4'
|
| 0.0009 |
SELECT COUNT(*) AS `numrows`
FROM `inu_board_content`
WHERE (`bc_bd_idx` = '4') AND (`bc_status` >0) AND (`bc_status` < 7)
|
| 0.0014 |
SELECT *
FROM `inu_board_content`
WHERE (`bc_bd_idx` = '4') AND (`bc_status` >0) AND (`bc_status` < 7)
ORDER BY `bc_order` ASC, `bc_regdate` DESC
LIMIT 100, 10
|
| 0.0009 |
SELECT *
FROM `inu_file`
WHERE `file_category` LIKE '%bc!_list%' ESCAPE '!'
AND `file_foreign_idx` IN('106', '105', '104', '81', '80', '79', '8', '7')
ORDER BY `file_order` asc, `file_regdate` asc
|
| 0.0006 |
SELECT *
FROM `inu_file`
WHERE `file_category` LIKE '%bc%' ESCAPE '!'
AND `file_foreign_idx` IN('106', '105', '104', '81', '80', '79', '8', '7')
ORDER BY `file_order` asc, `file_regdate` asc
|
| 0.0005 |
SELECT *
FROM `inu_board_selected_category`
LEFT JOIN `inu_board_category` ON `bcat_id`=`bscat_bcat_id` AND `bcat_bd_idx`=4
WHERE `bscat_bc_idx` IN('106', '105', '104', '81', '80', '79', '8', '7')
|
| 0.0010 |
SELECT COUNT(*) AS `numrows`
FROM `inu_board_content`
WHERE (`bc_bd_idx` = '4') AND (`bc_status` >0) AND (`bc_status` < 7) AND (`bc_type` = '3')
|
| 0.0010 |
SELECT *
FROM `inu_board_content`
WHERE (`bc_bd_idx` = '4') AND (`bc_status` >0) AND (`bc_status` < 7) AND (`bc_type` = '3')
ORDER BY `bc_order` ASC, `bc_regdate` DESC
LIMIT 30, 3
|
| 0.0004 |
SELECT *
FROM `inu_board`
WHERE `bd_idx` = '4'
|
| 0.0005 |
SELECT *
FROM `inu_popup`
WHERE `popup_page_idx` = '141'
AND `popup_status` = 1
AND (UNIX_TIMESTAMP(`popup_start_date`) =0 OR UNIX_TIMESTAMP(`popup_end_date`) =0 OR UNIX_TIMESTAMP(`popup_start_date`) IS NULL OR UNIX_TIMESTAMP(`popup_end_date`) IS NULL OR now() between `popup_start_date` and DATE_ADD(popup_end_date, INTERVAL 1 DAY) )
|
| 0.0004 |
SELECT *
FROM `inu_page`
WHERE `page_group` = 'ja'
AND `page_menu_status` = 1
ORDER BY `page_order`
|
| 0.0040 |
SELECT MAX(`gcat_depth`) AS `gcat_depth`
FROM `inu_goods_category`
|
| 0.0005 |
SELECT `t1`.`gcat_idx` as `t1_gcat_idx`, `t2`.`gcat_idx` as `t2_gcat_idx`, `t3`.`gcat_idx` as `t3_gcat_idx`, `t4`.`gcat_idx` as `t4_gcat_idx`, `t1`.`gcat_title` as `t1_gcat_title`, `t2`.`gcat_title` as `t2_gcat_title`, `t3`.`gcat_title` as `t3_gcat_title`, `t4`.`gcat_title` as `t4_gcat_title`, `t1`.`gcat_depth` as `t1_gcat_depth`, `t2`.`gcat_depth` as `t2_gcat_depth`, `t3`.`gcat_depth` as `t3_gcat_depth`, `t4`.`gcat_depth` as `t4_gcat_depth`
FROM `inu_goods_category` as `t1`
LEFT JOIN `inu_goods_category` as `t2` ON `t2`.`gcat_parent` = `t1`.`gcat_idx`
LEFT JOIN `inu_goods_category` as `t3` ON `t3`.`gcat_parent` = `t2`.`gcat_idx`
LEFT JOIN `inu_goods_category` as `t4` ON `t4`.`gcat_parent` = `t3`.`gcat_idx`
WHERE `t1`.`gcat_parent` =0
ORDER BY `t1`.`gcat_order` ASC, `t2`.`gcat_order` ASC, `t3`.`gcat_order` ASC, `t4`.`gcat_order` ASC
|