| 0.0006 |
SELECT GET_LOCK('jch8no4jp7hr5ftpau1cqkcrbfitv702', 300) AS ci_session_lock
|
| 0.0007 |
SELECT `data`
FROM `ci_sessions`
WHERE `id` = 'jch8no4jp7hr5ftpau1cqkcrbfitv702'
|
| 0.0015 |
SELECT *
FROM `inu_settings`
|
| 0.0005 |
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` = 'project'
AND `page_group` = 'ko'
|
| 0.0005 |
SELECT *
FROM `inu_page`
WHERE `page_idx` = '70'
|
| 0.0008 |
SELECT *
FROM `inu_board_content`
WHERE `bc_idx` = '343'
|
| 0.0004 |
SELECT *
FROM `inu_board`
WHERE `bd_idx` = '7'
|
| 0.0004 |
SELECT COUNT(*) AS `numrows`
FROM `inu_board_category`
WHERE `bcat_bd_idx` = 7 AND `bcat_status` = 1
|
| 0.0004 |
SELECT *
FROM `inu_board_category`
WHERE `bcat_bd_idx` = 7 AND `bcat_status` = 1
ORDER BY `bcat_order` desc
LIMIT 10
|
| 0.0006 |
SELECT *
FROM `inu_board_selected_category`
WHERE `bscat_bc_idx` = '343'
|
| 0.0009 |
SHOW COLUMNS FROM `inu_board_content`
|
| 0.0009 |
SELECT *
FROM `inu_board_content`
LEFT JOIN `inu_board` ON `bc_bd_idx`=`bd_idx`
LEFT JOIN `inu_tag` ON `tag_category` = 'bc' AND `tag_foreign_idx`=`bc_idx`
WHERE `bc_idx` = 343
|
| 0.0007 |
SELECT *
FROM `inu_file`
WHERE `file_category` LIKE '%bc%' ESCAPE '!'
AND `file_foreign_idx` = '343'
ORDER BY `file_order` asc, `file_regdate` asc
|
| 0.0006 |
SELECT *
FROM `inu_file`
WHERE `file_foreign_idx` = '343'
AND `file_category` LIKE '%bc!_list%' ESCAPE '!'
ORDER BY `file_order` asc, `file_regdate` asc
|
| 0.0007 |
SELECT *
FROM `inu_comment`
LEFT JOIN `inu_member` ON `cmnt_mem_idx`=`mem_idx`
WHERE `cmnt_category` = 'bc'
AND `cmnt_foreign_idx` = '343'
AND `cmnt_status` >0
ORDER BY `cmnt_regdate` DESC, `cmnt_idx` DESC
|
| 0.0007 |
SHOW COLUMNS FROM `inu_board_content`
|
| 0.0027 |
UPDATE `inu_board_content` SET bc_count = bc_count+1
WHERE `bc_idx` = '343'
|
| 0.0021 |
SELECT *
FROM `inu_board_content`
LEFT JOIN `inu_board_selected_category` ON `bc_idx` = `bscat_bc_idx`
WHERE `bc_bd_idx` = '7'
AND `bc_idx` != '343'
AND `bc_status` >0
AND `bc_status` < 7
AND `bc_order` <= '10'
AND `bc_regdate` <= '2024-12-24 00:00:00'
ORDER BY `bc_order` DESC, `bc_regdate` DESC
|
| 0.0015 |
SELECT *
FROM `inu_board_content`
LEFT JOIN `inu_board_selected_category` ON `bc_idx` = `bscat_bc_idx`
WHERE `bc_bd_idx` = '7'
AND `bc_idx` != '343'
AND `bc_status` >0
AND `bc_status` < 7
AND `bc_order` >= '10'
AND `bc_regdate` >= '2024-12-24 00:00:00'
ORDER BY `bc_order` ASC, `bc_regdate` ASC
|
| 0.0004 |
SELECT *
FROM `inu_board`
WHERE `bd_idx` = '7'
|
| 0.0006 |
SELECT *
FROM `inu_popup`
WHERE `popup_page_idx` = '70'
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.0005 |
SELECT *
FROM `inu_page`
WHERE `page_group` = 'ko'
AND `page_menu_status` = 1
ORDER BY `page_order`
|
| 0.0005 |
SELECT *
FROM `inu_file`
WHERE `file_category` = 'site_favicon'
ORDER BY `file_order` asc, `file_regdate` asc, `file_order` asc, `file_orig_name` asc
|
| 0.0004 |
SELECT *
FROM `inu_board`
WHERE `bd_idx` = '7'
|
