2020.11.08 02:40

576

CMS/프레임워크	Rhymix 1.9
개발 언어	PHP 7.2

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

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);
}

기진곰

2020.11.08 06:56 #1478629

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

추천 0
웹지기

2020.11.08 07:06 #1478642

디버그에서 쿼리를 기록하도록 하고 추천해보니 이번에는 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

추천 0
웹지기

2020.11.08 07:15 #1478646

애드온이 몇개 보이고 스킨에서 직접 호출하는 쿼리도 있고 하네요.

이거 범인 못찾고 이대로 두면 어떻게 되나요?

추천 0
기진곰

2020.11.08 07:30 #1478651

특별히 에러나는 쿼리는 보이지 않네요. 나중에 라이믹스 2.0에서 다시 확인해 주시기 바랍니다.

추천 0
웹지기

2020.11.08 07:32 #1478655

네. 알겠습니다. 오류나 그런건 없이 지금 디버그 상에 저런 메시지가 떠서 저게 무언지 알아보고 있는 중이었는데 그냥 스킵해야 했습니다.

추천 0