General Information
Queries (10)
01. SELECT `readed_count`, `voted_count`, `blamed_count`, `comment_count`, `trackback_count` FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
- Caller: modules/document/document.item.php:118
(documentItem->_loadFromDB) - Connection: master
- Query ID: document.getDocument
- Query Time: 0.0004 sec
- Result: success
02. SELECT * FROM `rx_document_extra_vars` AS `extra_vars` WHERE `extra_vars`.`module_srl` >= ? AND `extra_vars`.`document_srl` IN (?) AND `extra_vars`.`var_idx` >= ?
- Caller: modules/document/document.model.php:42
(documentModel::getDocumentExtraVarsFromDB) - Connection: master
- Query ID: document.getDocumentExtraVars
- Query Time: 0.0001 sec
- Result: success
03. SELECT `documents`.`document_srl`, `documents`.`module_srl`, `documents`.`category_srl`, `documents`.`lang_code`, `documents`.`is_notice`, `documents`.`title`, `documents`.`title_bold`, `documents`.`title_color`, `documents`.`member_srl`, `documents`.`nick_name`, `documents`.`tags`, `documents`.`extra_vars`, `documents`.`comment_count`, `documents`.`trackback_count`, `documents`.`uploaded_count`, `documents`.`status`, `documents`.`regdate`, `documents`.`last_update`, `documents`.`readed_count` FROM `rx_documents` AS `documents` WHERE (`module_srl` IN (?) AND `is_notice` = ?) OR `is_notice` = ? ORDER BY `list_order` ASC
- Caller: modules/document/document.model.php:324
(documentModel::getNoticeList) - Connection: master
- Query ID: document.getNoticeList
- Query Time: 0.0001 sec
- Result: success
04. SELECT count(document_srl) AS `count` FROM `rx_documents` AS `documents` WHERE `module_srl` IN (?) AND `is_notice` = ? AND `status` IN (?, ?) AND (`list_order` <= ?)
- Caller: modules/document/document.model.php:703
(documentModel::getDocumentPage) - Connection: master
- Query ID: document.getDocumentListPage
- Query Time: 0.0004 sec
- Result: success
05. SELECT COUNT(*) AS `count` FROM `rx_documents` AS `documents` WHERE `module_srl` IN (?) AND `is_notice` = ? AND `status` IN (?, ?)
- Caller: modules/document/document.model.php:265
(documentModel::getDocumentList) - Connection: master
- Query ID: document.getDocumentList (count)
- Query Time: 0.0018 sec
- Result: success
06. SELECT `documents`.`document_srl`, `documents`.`module_srl`, `documents`.`category_srl`, `documents`.`lang_code`, `documents`.`is_notice`, `documents`.`title`, `documents`.`title_bold`, `documents`.`title_color`, `documents`.`member_srl`, `documents`.`nick_name`, `documents`.`tags`, `documents`.`extra_vars`, `documents`.`comment_count`, `documents`.`trackback_count`, `documents`.`uploaded_count`, `documents`.`status`, `documents`.`regdate`, `documents`.`last_update`, `documents`.`readed_count` FROM `rx_documents` AS `documents` WHERE `module_srl` IN (?) AND `is_notice` = ? AND `status` IN (?, ?) ORDER BY `documents`.`list_order` ASC LIMIT 20
- Caller: modules/document/document.model.php:265
(documentModel::getDocumentList) - Connection: master
- Query ID: document.getDocumentList
- Query Time: 0.0001 sec
- Result: success
07. SELECT * FROM `rx_document_extra_vars` AS `extra_vars` WHERE `extra_vars`.`module_srl` >= ? AND `extra_vars`.`document_srl` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND `extra_vars`.`var_idx` >= ?
- Caller: modules/document/document.model.php:42
(documentModel::getDocumentExtraVarsFromDB) - Connection: master
- Query ID: document.getDocumentExtraVars
- Query Time: 0.0001 sec
- Result: success
08. SELECT COUNT(*) AS `count` FROM `rx_comments` AS `comments`, `rx_comments_list` AS `comments_list` WHERE `comments_list`.`document_srl` = ? AND `comments_list`.`comment_srl` = `comments`.`comment_srl` AND `comments_list`.`head` >= ? AND `comments_list`.`arrange` >= ?
- Caller: modules/comment/comment.model.php:532
(commentModel::getCommentList) - Connection: master
- Query ID: comment.getCommentPageList (count)
- Query Time: 0.0001 sec
- Result: success
09. SELECT `comments`.*, `comments_list`.`depth` AS `depth` FROM `rx_comments` AS `comments`, `rx_comments_list` AS `comments_list` WHERE `comments_list`.`document_srl` = ? AND `comments_list`.`comment_srl` = `comments`.`comment_srl` AND `comments_list`.`head` >= ? AND `comments_list`.`arrange` >= ? ORDER BY `comments_list`.`head` ASC, `comments_list`.`arrange` ASC LIMIT 50
- Caller: modules/comment/comment.model.php:532
(commentModel::getCommentList) - Connection: master
- Query ID: comment.getCommentPageList
- Query Time: 0.0001 sec
- Result: success
10. SELECT `modules`.`site_srl`, `modules`.`module_srl`, `modules`.`mid`, `modules`.`browser_title`, `sites`.`domain` FROM `rx_modules` AS `modules` LEFT JOIN `rx_sites` AS `sites` ON `sites`.`site_srl` = `modules`.`site_srl` WHERE `modules`.`module_srl` IN (?)
- Caller: widgets/content/content.class.php:91
(content->proc) - Connection: master
- Query ID: widgets.content.getMids
- Query Time: 0.0001 sec
- Result: success
asdfasdf