디버그를 켜 놓으니 저 에러를 확인할 수 있었는데요. 

 

PREVIOUS POST : document.procDocumentVoteUp

General Information

Request: POST (JSON) - 122 bytes

Response: JSON - 77 bytes

Total Time: 0.0389 sec

Query Time: 0.0112 sec (count: 23)

Errors (1)

01. Query Error: This command is not supported in the prepared statement protocol yet (code 1295)

 

 

 

https://xetown.com/questions/1477793

 

게시글 추천 직후 발생하는 에러 입니다. 

에러라고는 하지만 동작에는 이상이 없이 추천 까지 잘 됩니다. 

 

 

db config 에서 prepared statement 사용을 N 로 해야 하는건지 궁금하네요.

prepared statement 가 뭔지 잘 모르니 이런 상황이 왜 발생하는지 저걸 그냥 두는게 좋은건지 잘 모르겠네요.

 

메시지 자체가 fail이 아니라 실제 동작이 안되는게 아닌 에러 메시지 같습니다.

 

 

추천 실행한 스크립트는 아래의 것을 사용했습니다.

 

onclick="do_doc_VoteSubmit('document','procDocumentVoteUp','{$oDocument->document_srl}');"

function do_doc_VoteSubmit(module, action, target_srl) {
var params = {'target_srl':target_srl,'cur_mid':current_mid};
jQuery.exec_json(module+'.'+action, params);
setTimeout(function() {
location.reload(true);
}, 300);
}

 

 

  • profile

    쿼리가 23개라고 하는데, 그 중 어떤 쿼리가 에러를 냈는지 확인하는 것이 우선입니다. 추천 시점에 끼어드는 서드파티 자료도 꽤 있으니까요. Prepared statement는 켜져 있는 것이 기본이고, XE도 마찬가지이니 그 상태에서 에러 나는 서드파티 자료가 있다면 그 자료의 잘못입니다.

  • profile profile
    디버그에서 쿼리를 기록하도록 하고 추천해보니 이번에는 90개가 넘는 쿼리가 잡히네요.


    01. SELECT * FROM `xe_module_admins` AS `module_admins` , `xe_member` AS `member` WHERE `module_srl` = ? AND `member`.`member_srl` = `module_admins`.`member_srl`
    Caller: modules/module/module.model.php:1812
    (moduleModel->getAdminId)
    Connection: master (127.0.0.1)
    Query ID: module.getAdminID
    Query Time: 0.0007 sec
    Result: success
    02. select count(*) as "count" FROM `xe_member_message` AS `message` LEFT JOIN `xe_member` AS `member` ON `member`.`member_srl` = `message`.`sender_srl` WHERE `message`.`receiver_srl` = ? AND `message`.`readed` = ? AND `message`.`message_type` = ?
    Caller: addons/check_message_read/check_message_read.addon.php:11
    (include)
    Connection: master (127.0.0.1)
    Query ID: communication.getNewMessage
    Query Time: 0.0005 sec
    Result: success
    03. SELECT * FROM `xe_member_message` AS `message` LEFT JOIN `xe_member` AS `member` ON `member`.`member_srl` = `message`.`sender_srl` WHERE ( `message`.`receiver_srl` = ? AND `message`.`readed` = ? AND `message`.`message_type` = ? ) AND `message`.`list_order` <= 2100000000 ORDER BY `message`.`list_order` DESC LIMIT 0, 1
    Caller: addons/check_message_read/check_message_read.addon.php:11
    (include)
    Connection: master (127.0.0.1)
    Query ID: communication.getNewMessage
    Query Time: 0.0007 sec
    Result: success
    04. START TRANSACTION
    Result: success
    05. UPDATE `xe_counter_status` AS `counter_status` SET `pageview` = `pageview` + ? WHERE `regdate` IN (?,?)
    Caller: modules/counter/counter.controller.php:129
    (counterController->insertPageView)
    Connection: master (127.0.0.1)
    Query ID: counter.updateCounterPageview
    Query Time: 0.0006 sec
    Result: success
    06. COMMIT
    Result: success
    07. SELECT * FROM `xe_documents` AS `documents` WHERE `document_srl` = ?
    Caller: modules/document/document.item.php:113
    (documentItem->_loadFromDB)
    Connection: master (127.0.0.1)
    Query ID: document.getDocument
    Query Time: 0.0006 sec
    Result: success
    08. SELECT * FROM `xe_document_extra_vars` AS `extra_vars` WHERE `extra_vars`.`module_srl` >= -1 AND `extra_vars`.`document_srl` IN (?) AND `extra_vars`.`var_idx` >= -2
    Caller: modules/document/document.model.php:42
    (documentModel->getDocumentExtraVarsFromDB)
    Connection: master (127.0.0.1)
    Query ID: document.getDocumentExtraVars
    Query Time: 0.0003 sec
    Result: success
    09. SELECT `modules`.* FROM `xe_modules` AS `modules` , `xe_documents` AS `documents` WHERE `documents`.`document_srl` = ? AND `modules`.`module_srl` = `documents`.`module_srl`
    Caller: modules/module/module.model.php:172
    (moduleModel->getModuleInfoByDocumentSrl)
    Connection: master (127.0.0.1)
    Query ID: module.getModuleInfoByDocument
    Query Time: 0.0005 sec
    Result: success
    10. SELECT `modules`.* FROM `xe_modules` AS `modules` , `xe_documents` AS `documents` WHERE `documents`.`document_srl` = ? AND `modules`.`module_srl` = `documents`.`module_srl`
    Caller: modules/module/module.model.php:172
    (moduleModel->getModuleInfoByDocumentSrl)
    Connection: master (127.0.0.1)
    Query ID: module.getModuleInfoByDocument
    Query Time: 0.0003 sec
    Result: success
    11. SHOW TABLES LIKE 'xe_pointhistory'
    Result: success
    12. select count(*) as "count" FROM `xe_member_message` AS `message` LEFT JOIN `xe_member` AS `member` ON `member`.`member_srl` = `message`.`sender_srl` WHERE `message`.`receiver_srl` = ? AND `message`.`readed` = ? AND `message`.`message_type` = ?
    Caller: addons/check_message_read/check_message_read.addon.php:11
    (include)
    Connection: master (127.0.0.1)
    Query ID: communication.getNewMessage
    Query Time: 0.0003 sec
    Result: success
    13. SELECT * FROM `xe_member_message` AS `message` LEFT JOIN `xe_member` AS `member` ON `member`.`member_srl` = `message`.`sender_srl` WHERE ( `message`.`receiver_srl` = ? AND `message`.`readed` = ? AND `message`.`message_type` = ? ) AND `message`.`list_order` <= 2100000000 ORDER BY `message`.`list_order` DESC LIMIT 0, 1
    Caller: addons/check_message_read/check_message_read.addon.php:11
    (include)
    Connection: master (127.0.0.1)
    Query ID: communication.getNewMessage
    Query Time: 0.0003 sec
    Result: success
    14. SELECT * FROM `xe_documents` AS `documents` WHERE ( `module_srl` IN (?) AND `is_notice` = 'Y' ) AND `list_order` <= 2100000000 ORDER BY `list_order` ASC
    Caller: modules/document/document.model.php:310
    (documentModel->getNoticeList)
    Connection: master (127.0.0.1)
    Query ID: document.getNoticeList
    Query Time: 0.0010 sec
    Result: success
    15. SELECT count(`document_srl`) AS `count` FROM `xe_documents` AS `documents` WHERE `module_srl` IN (?) AND `status` IN (?,?) AND ( `list_order` <= ? )
    Caller: modules/document/document.model.php:644
    (documentModel->getDocumentPage)
    Connection: master (127.0.0.1)
    Query ID: document.getDocumentListPage
    Query Time: 0.0006 sec
    Result: success
    16. select count(*) as "count" FROM `xe_documents` AS `documents` WHERE `module_srl` IN (?) AND `status` IN (?,?)
    Caller: modules/document/document.model.php:263
    (documentModel->getDocumentList)
    Connection: master (127.0.0.1)
    Query ID: document.getDocumentList
    Query Time: 0.0011 sec
    Result: success
    17. SELECT * FROM `xe_documents` AS `documents` WHERE ( `module_srl` IN (?) AND `status` IN (?,?) ) AND `documents`.`list_order` <= 2100000000 ORDER BY `documents`.`list_order` asc LIMIT 0, 30
    Caller: modules/document/document.model.php:263
    (documentModel->getDocumentList)
    Connection: master (127.0.0.1)
    Query ID: document.getDocumentList
    Query Time: 0.0008 sec
    Result: success
    18. SELECT * FROM `xe_document_extra_vars` AS `extra_vars` WHERE `extra_vars`.`module_srl` >= -1 AND `extra_vars`.`document_srl` IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND `extra_vars`.`var_idx` >= -2
    Caller: modules/document/document.model.php:42
    (documentModel->getDocumentExtraVarsFromDB)
    Connection: master (127.0.0.1)
    Query ID: document.getDocumentExtraVars
    Query Time: 0.0003 sec
    Result: success
    19. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0003 sec
    Result: success
    20. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0002 sec
    Result: success
    21. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0002 sec
    Result: success
    22. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0002 sec
    Result: success
    23. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0002 sec
    Result: success
    24. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0002 sec
    Result: success
    25. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0003 sec
    Result: success
    26. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0002 sec
    Result: success
    27. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0002 sec
    Result: success
    28. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0002 sec
    Result: success
    29. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0002 sec
    Result: success
    30. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0002 sec
    Result: success
    31. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0002 sec
    Result: success
    32. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0002 sec
    Result: success
    33. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0002 sec
    Result: success
    34. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0002 sec
    Result: success
    35. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0002 sec
    Result: success
    36. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0002 sec
    Result: success
    37. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0002 sec
    Result: success
    38. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0002 sec
    Result: success
    39. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0002 sec
    Result: success
    40. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0002 sec
    Result: success
    41. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0002 sec
    Result: success
    42. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0002 sec
    Result: success
    43. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0002 sec
    Result: success
    44. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0002 sec
    Result: success
    45. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0002 sec
    Result: success
    46. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0001 sec
    Result: success
    47. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0002 sec
    Result: success
    48. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0001 sec
    Result: success
    49. SELECT * FROM `xe_document_declared` AS `document_declared` WHERE `document_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: document.getDeclaredDocument
    Query Time: 0.0001 sec
    Result: success
    50. select count(*) as "count" FROM `xe_member_message` AS `message` LEFT JOIN `xe_member` AS `member` ON `member`.`member_srl` = `message`.`sender_srl` WHERE `message`.`receiver_srl` = ? AND `message`.`readed` = ? AND `message`.`message_type` = ?
    Caller: addons/check_message_read/check_message_read.addon.php:11
    (include)
    Connection: master (127.0.0.1)
    Query ID: communication.getNewMessage
    Query Time: 0.0002 sec
    Result: success
    51. SELECT * FROM `xe_member_message` AS `message` LEFT JOIN `xe_member` AS `member` ON `member`.`member_srl` = `message`.`sender_srl` WHERE ( `message`.`receiver_srl` = ? AND `message`.`readed` = ? AND `message`.`message_type` = ? ) AND `message`.`list_order` <= 2100000000 ORDER BY `message`.`list_order` DESC LIMIT 0, 1
    Caller: addons/check_message_read/check_message_read.addon.php:11
    (include)
    Connection: master (127.0.0.1)
    Query ID: communication.getNewMessage
    Query Time: 0.0003 sec
    Result: success
    52. SELECT * FROM `xe_point` AS `point` WHERE `member_srl` = ?
    Caller: modules/point/point.model.php:67
    (pointModel->getPoint)
    Connection: master (127.0.0.1)
    Query ID: point.getPoint
    Query Time: 0.0003 sec
    Result: success
    53. select count(*) as "count" FROM `xe_documents` AS `documents` WHERE `document_srl` IN (?,?) AND `status` IN (?,?)
    Caller: addons/gsejin7940_all_notice/gsejin7940_all_notice.addon.php:36
    (include)
    Connection: master (127.0.0.1)
    Query ID: addons.gsejin7940_all_notice.getNoticeList
    Query Time: 0.0003 sec
    Result: success
    54. SELECT * FROM `xe_documents` AS `documents` WHERE ( `document_srl` IN (?,?) AND `status` IN (?,?) ) AND `list_order` <= 2100000000 ORDER BY `list_order` asc LIMIT 0, 2000
    Caller: addons/gsejin7940_all_notice/gsejin7940_all_notice.addon.php:36
    (include)
    Connection: master (127.0.0.1)
    Query ID: addons.gsejin7940_all_notice.getNoticeList
    Query Time: 0.0005 sec
    Result: success
    55. SELECT * FROM `xe_documents` AS `documents` WHERE `document_srl` = ?
    Caller: modules/document/document.item.php:113
    (documentItem->_loadFromDB)
    Connection: master (127.0.0.1)
    Query ID: document.getDocument
    Query Time: 0.0004 sec
    Result: success
    56. SELECT * FROM `xe_document_extra_vars` AS `extra_vars` WHERE `extra_vars`.`module_srl` >= -1 AND `extra_vars`.`document_srl` IN (?) AND `extra_vars`.`var_idx` >= -2
    Caller: modules/document/document.model.php:42
    (documentModel->getDocumentExtraVarsFromDB)
    Connection: master (127.0.0.1)
    Query ID: document.getDocumentExtraVars
    Query Time: 0.0002 sec
    Result: success
    57. SELECT * FROM `xe_documents` AS `documents` WHERE `document_srl` = ?
    Caller: modules/document/document.item.php:113
    (documentItem->_loadFromDB)
    Connection: master (127.0.0.1)
    Query ID: document.getDocument
    Query Time: 0.0003 sec
    Result: success
    58. SELECT * FROM `xe_document_extra_vars` AS `extra_vars` WHERE `extra_vars`.`module_srl` >= -1 AND `extra_vars`.`document_srl` IN (?) AND `extra_vars`.`var_idx` >= -2
    Caller: modules/document/document.model.php:42
    (documentModel->getDocumentExtraVarsFromDB)
    Connection: master (127.0.0.1)
    Query ID: document.getDocumentExtraVars
    Query Time: 0.0002 sec
    Result: success
    59. SELECT * FROM `xe_blind` AS `blind` WHERE `member_srl` = ? ORDER BY `no` ASC LIMIT 20
    Caller: modules/blind/blind.class.php:65
    (blind->triggerModuleProc)
    Connection: master (127.0.0.1)
    Query ID: blind.getBlind
    Query Time: 0.0002 sec
    Result: success
    60. UPDATE `xe_ncenterlite_notify` AS `ncenterlite_notify` SET `readed` = 'Y' WHERE `member_srl` = ? AND `srl` = ?
    Caller: modules/ncenterlite/ncenterlite.controller.php:920
    (ncenterliteController->triggerAfterModuleHandlerProc)
    Connection: master (127.0.0.1)
    Query ID: ncenterlite.updateNotifyReadedBySrl
    Query Time: 0.0004 sec
    Result: success
    61. SELECT * FROM `xe_member` AS `member` WHERE `member_srl` = ?
    Caller: modules/member/member.model.php:345
    (memberModel->getMemberInfoByMemberSrl)
    Connection: master (127.0.0.1)
    Query ID: member.getMemberInfoByMemberSrl
    Query Time: 0.0004 sec
    Result: success
    62. SELECT `a`.`title` AS `title`, `a`.`group_srl` AS `group_srl` FROM `xe_member_group` AS `a` , `xe_member_group_member` AS `b` WHERE ( `b`.`member_srl` = ? AND `b`.`group_srl` = `a`.`group_srl` AND `a`.`site_srl` = ? ) AND `a`.`list_order` <= 2100000000 ORDER BY `a`.`list_order` ASC
    Caller: modules/member/member.model.php:526
    (memberModel->getMemberGroups)
    Connection: master (127.0.0.1)
    Query ID: member.getMemberGroups
    Query Time: 0.0002 sec
    Result: success
    63. SELECT count(*) AS `count` FROM `xe_documents` AS `documents` WHERE `member_srl` = ?
    Caller: modules/document/document.model.php:1491
    (documentModel->getDocumentCountByMemberSrl)
    Connection: master (127.0.0.1)
    Query ID: document.getDocumentCountByMemberSrl
    Query Time: 0.0006 sec
    Result: success
    64. SELECT count(*) AS `count` FROM `xe_comments` AS `comments` WHERE `member_srl` = ?
    Caller: modules/comment/comment.model.php:1180
    (commentModel->getCommentCountByMemberSrl)
    Connection: master (127.0.0.1)
    Query ID: comment.getCommentCountByMemberSrl
    Query Time: 0.0002 sec
    Result: success
    65. SELECT `login_check`.* FROM `xe_login_check` AS `login_check` , `xe_member` AS `member` WHERE `login_time` >= ? AND `login_check`.`member_srl` = `member`.`member_srl` ORDER BY `login_time` DESC
    Caller: modules/board/skins/comely_board/_read.html:32
    (include)
    Connection: master (127.0.0.1)
    Query ID: addons.login_check.getLoginCheck
    Query Time: 0.0004 sec
    Result: success
    66. select count(*) as "count" FROM `xe_sitemanagement_doc_read` AS `sitemanagement_doc_read` WHERE `document_srl` = ?
    Caller: modules/board/skins/comely_board/_read.html:65
    (include)
    Connection: master (127.0.0.1)
    Query ID: sitemanagement.docRead_get
    Query Time: 0.0002 sec
    Result: success
    67. SELECT * FROM `xe_sitemanagement_doc_read` AS `sitemanagement_doc_read` WHERE `document_srl` = ? ORDER BY `regdate` DESC LIMIT 0, 8
    Caller: modules/board/skins/comely_board/_read.html:65
    (include)
    Connection: master (127.0.0.1)
    Query ID: sitemanagement.docRead_get
    Query Time: 0.0002 sec
    Result: success
    68. SELECT count(*) AS `count` FROM `xe_affiliatelinkconvert` AS `affiliatelinkconvert` WHERE `document_srl` = ?
    Caller: modules/board/skins/comely_board/_read.html:81
    (include)
    Connection: master (127.0.0.1)
    Query ID: board/skins/comely_board/.getAffiliatelink
    Query Time: 0.0002 sec
    Result: success
    69. SELECT `member`.`member_srl` AS `member_srl`, `member`.`nick_name` AS `nick_name` FROM `xe_document_voted_log` AS `voted_log` , `xe_member` AS `member` WHERE `voted_log`.`document_srl` = ? AND `voted_log`.`member_srl` = `member`.`member_srl` AND `voted_log`.`point` >= ? ORDER BY `voted_log`.`regdate` DESC
    Caller: modules/board/skins/comely_board/_read.html:144
    (include)
    Connection: master (127.0.0.1)
    Query ID: document.getVotedMemberList
    Query Time: 0.0005 sec
    Result: success
    70. SELECT `member`.`member_srl` AS `member_srl`, `member`.`nick_name` AS `nick_name` FROM `xe_document_voted_log` AS `voted_log` , `xe_member` AS `member` WHERE `voted_log`.`document_srl` = ? AND `voted_log`.`member_srl` = `member`.`member_srl` AND `voted_log`.`point` >= ? AND `voted_log`.`point` < ? ORDER BY `voted_log`.`regdate` DESC
    Caller: modules/board/skins/comely_board/_read.html:153
    (include)
    Connection: master (127.0.0.1)
    Query ID: document.getVotedMemberList
    Query Time: 0.0004 sec
    Result: success
    71. SELECT count(*) AS `count`, sum(`voted_count`) AS `sum` FROM `xe_documents` AS `documents` WHERE `member_srl` = ? AND `voted_count` >= 1 AND `module_srl` NOT IN (?)
    Caller: modules/board/skins/comely_board/_read.html:451
    (include)
    Connection: master (127.0.0.1)
    Query ID: board/skins/comely_board/.getVotedCountForMemberSrlInDocument
    Query Time: 0.0031 sec
    Result: success
    72. SELECT count(*) AS `count`, sum(`voted_count`) AS `sum` FROM `xe_comments` AS `comments` WHERE `member_srl` = ? AND `voted_count` >= 1 AND `module_srl` NOT IN (?)
    Caller: modules/board/skins/comely_board/_read.html:454
    (include)
    Connection: master (127.0.0.1)
    Query ID: board/skins/comely_board/.getVotedCountForMemberSrlInComment
    Query Time: 0.0002 sec
    Result: success
    73. select count(*) as "count" FROM `xe_comments` AS `comments` , `xe_comments_list` AS `comments_list` WHERE `comments_list`.`document_srl` = ? AND `comments_list`.`comment_srl` = `comments`.`comment_srl` AND `comments_list`.`head` >= 0 AND `comments_list`.`arrange` >= 0
    Caller: modules/comment/comment.model.php:540
    (commentModel->getCommentList)
    Connection: master (127.0.0.1)
    Query ID: comment.getCommentPageList
    Query Time: 0.0003 sec
    Result: success
    74. SELECT `comments`.*, `comments_list`.`depth` AS `depth` FROM `xe_comments` AS `comments` , `xe_comments_list` AS `comments_list` WHERE `comments_list`.`document_srl` = ? AND `comments_list`.`comment_srl` = `comments`.`comment_srl` AND `comments_list`.`head` >= 0 AND `comments_list`.`arrange` >= 0 ORDER BY `comments_list`.`head` ASC, `comments_list`.`arrange` ASC LIMIT 0, 50
    Caller: modules/comment/comment.model.php:540
    (commentModel->getCommentList)
    Connection: master (127.0.0.1)
    Query ID: comment.getCommentPageList
    Query Time: 0.0003 sec
    Result: success
    75. SELECT * FROM `xe_editor_components` AS `editor_components` WHERE `component_name` = ?
    Caller: modules/editor/editor.model.php:591
    (editorModel->getComponent)
    Connection: master (127.0.0.1)
    Query ID: editor.getComponent
    Query Time: 0.0003 sec
    Result: success
    76. SELECT * FROM `xe_counter_status` AS `counter_status` WHERE `regdate` IN (?,?,?)
    Caller: modules/counter/counter.model.php:106
    (counterModel->getStatus)
    Connection: master (127.0.0.1)
    Query ID: counter.getCounterStatusDays
    Query Time: 0.0004 sec
    Result: success
    77. SELECT `gifconvert_mp4_files`.*, `files`.`uploaded_filename` AS `gif_uploaded_filename` FROM `xe_gifconvert_mp4_files` AS `gifconvert_mp4_files` LEFT JOIN `xe_files` AS `files` ON `gifconvert_mp4_files`.`file_srl` = `files`.`file_srl` WHERE `gifconvert_mp4_files`.`parent_srl` = ? AND `gifconvert_mp4_files`.`is_convert` = ? GROUP BY `gifconvert_mp4_files`.`file_srl`
    Caller: modules/z_gifconvert/z_gifconvert.model.php:217
    (z_gifconvertModel->mp4List)
    Connection: master (127.0.0.1)
    Query ID: z_gifconvert.getMp4ContentByParentSrl
    Query Time: 0.0003 sec
    Result: success
    78. SELECT `videoconvert_mp4_files`.*, `files`.`uploaded_filename` AS `ori_uploaded_filename`, `files`.`source_filename` AS `ori_source_filename`, `files`.`ipaddress` AS `ori_ipaddress` FROM `xe_videoconvert_mp4_files` AS `videoconvert_mp4_files` LEFT JOIN `xe_files` AS `files` ON `videoconvert_mp4_files`.`file_srl` = `files`.`file_srl` WHERE `videoconvert_mp4_files`.`parent_srl` = ? GROUP BY `videoconvert_mp4_files`.`file_srl` ORDER BY `videoconvert_mp4_files`.`file_srl` ASC
    Caller: modules/z_videoconvert/z_videoconvert.model.php:242
    (z_videoconvertModel->mp4List)
    Connection: master (127.0.0.1)
    Query ID: z_videoconvert.getMp4ContentByParentSrl
    Query Time: 0.0003 sec
    Result: success
    79. SELECT * FROM `xe_comments` AS `comments` WHERE `comment_srl` = ?
    Caller: modules/comment/comment.item.php:63
    (commentItem->_loadFromDB)
    Connection: master (127.0.0.1)
    Query ID: comment.getComment
    Query Time: 0.0002 sec
    Result: success
    80. SELECT * FROM `xe_comment_declared` AS `comment_declared` WHERE `comment_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: comment.getDeclaredComment
    Query Time: 0.0002 sec
    Result: success
    81. SELECT * FROM `xe_comments` AS `comments` WHERE `comment_srl` = ?
    Caller: modules/comment/comment.item.php:63
    (commentItem->_loadFromDB)
    Connection: master (127.0.0.1)
    Query ID: comment.getComment
    Query Time: 0.0002 sec
    Result: success
    82. SELECT * FROM `xe_comment_declared` AS `comment_declared` WHERE `comment_srl` = ?
    Caller: addons/block_document_ext/block_document_ext.func.php:14
    (isOver)
    Connection: master (127.0.0.1)
    Query ID: comment.getDeclaredComment
    Query Time: 0.0001 sec
    Result: success
    83. select count(*) as "count" FROM `xe_member_message` AS `message` LEFT JOIN `xe_member` AS `member` ON `member`.`member_srl` = `message`.`sender_srl` WHERE `message`.`receiver_srl` = ? AND `message`.`readed` = ? AND `message`.`message_type` = ?
    Caller: addons/check_message_read/check_message_read.addon.php:11
    (include)
    Connection: master (127.0.0.1)
    Query ID: communication.getNewMessage
    Query Time: 0.0002 sec
    Result: success
    84. SELECT * FROM `xe_member_message` AS `message` LEFT JOIN `xe_member` AS `member` ON `member`.`member_srl` = `message`.`sender_srl` WHERE ( `message`.`receiver_srl` = ? AND `message`.`readed` = ? AND `message`.`message_type` = ? ) AND `message`.`list_order` <= 2100000000 ORDER BY `message`.`list_order` DESC LIMIT 0, 1
    Caller: addons/check_message_read/check_message_read.addon.php:11
    (include)
    Connection: master (127.0.0.1)
    Query ID: communication.getNewMessage
    Query Time: 0.0003 sec
    Result: success
    85. SELECT * FROM `xe_files` AS `files` WHERE `upload_target_srl` = ? AND `isvalid` = ? ORDER BY `file_srl` ASC
    Caller: modules/file/file.model.php:385
    (fileModel->getFiles)
    Connection: master (127.0.0.1)
    Query ID: file.getFiles
    Query Time: 0.0003 sec
    Result: success
    86. SELECT `modules`.* FROM `xe_modules` AS `modules` , `xe_documents` AS `documents` WHERE `documents`.`document_srl` = ? AND `modules`.`module_srl` = `documents`.`module_srl`
    Caller: modules/module/module.model.php:172
    (moduleModel->getModuleInfoByDocumentSrl)
    Connection: master (127.0.0.1)
    Query ID: module.getModuleInfoByDocument
    Query Time: 0.0005 sec
    Result: success
    87. SELECT `modules`.* FROM `xe_modules` AS `modules` , `xe_documents` AS `documents` WHERE `documents`.`document_srl` = ? AND `modules`.`module_srl` = `documents`.`module_srl`
    Caller: modules/module/module.model.php:172
    (moduleModel->getModuleInfoByDocumentSrl)
    Connection: master (127.0.0.1)
    Query ID: module.getModuleInfoByDocument
    Query Time: 0.0004 sec
    Result: success
    88. SELECT `modules`.* FROM `xe_modules` AS `modules` , `xe_documents` AS `documents` WHERE `documents`.`document_srl` = ? AND `modules`.`module_srl` = `documents`.`module_srl`
    Caller: modules/module/module.model.php:172
    (moduleModel->getModuleInfoByDocumentSrl)
    Connection: master (127.0.0.1)
    Query ID: module.getModuleInfoByDocument
    Query Time: 0.0003 sec
    Result: success
    89. SELECT `modules`.* FROM `xe_modules` AS `modules` , `xe_documents` AS `documents` WHERE `documents`.`document_srl` = ? AND `modules`.`module_srl` = `documents`.`module_srl`
    Caller: modules/module/module.model.php:172
    (moduleModel->getModuleInfoByDocumentSrl)
    Connection: master (127.0.0.1)
    Query ID: module.getModuleInfoByDocument
    Query Time: 0.0003 sec
    Result: success
    90. SELECT `modules`.* FROM `xe_modules` AS `modules` , `xe_documents` AS `documents` WHERE `documents`.`document_srl` = ? AND `modules`.`module_srl` = `documents`.`module_srl`
    Caller: modules/module/module.model.php:172
    (moduleModel->getModuleInfoByDocumentSrl)
    Connection: master (127.0.0.1)
    Query ID: module.getModuleInfoByDocument
    Query Time: 0.0004 sec
    Result: success
  • profile profile
    애드온이 몇개 보이고 스킨에서 직접 호출하는 쿼리도 있고 하네요.

    이거 범인 못찾고 이대로 두면 어떻게 되나요?
  • profile profile
    특별히 에러나는 쿼리는 보이지 않네요. 나중에 라이믹스 2.0에서 다시 확인해 주시기 바랍니다.
  • profile profile
    네. 알겠습니다. 오류나 그런건 없이 지금 디버그 상에 저런 메시지가 떠서 저게 무언지 알아보고 있는 중이었는데 그냥 스킵해야 했습니다.