디버그 정보 패널에서 느린쿼리와 에러가 너무 많이 뜨는데 무시해도 되는 것인지요?
| CMS/프레임워크 | Rhymix 2.0 |
|---|---|
| 개발 언어 | PHP 7.4 |
에러가 50개 이상
느린쿼리가 50개 이상 뜹니다.
01. Warning: Creating default object from empty value
modules/board/skins/ink_board/_read.html:44
classes/template/TemplateHandler.class.php:367
classes/template/TemplateHandler.class.php:156
modules/board/skins/ink_board/list.html:79
classes/template/TemplateHandler.class.php:367
classes/template/TemplateHandler.class.php:156
classes/display/HTMLDisplayHandler.php:97
classes/display/DisplayHandler.class.php:82
classes/module/ModuleHandler.class.php:1154
index.php:52
에러는 위에 꺼를 제외하면 주로 php 다음 버전에서 오류를 일으킬거라는 것이라는 경고이고요..
느린쿼리는 적게는 40개 많게는 52개까지도 나와요
아래 내용같은 것들입니다..
그냥 둬도 되는 것인지 모르겠네요..
01. SELECT `modules`.*, `documents`.`is_notice`, `documents`.`status` FROM `rx_modules` AS `modules`, `rx_documents` AS `documents` WHERE `documents`.`document_srl` = ? AND `modules`.`module_srl` = `documents`.`module_srl`
Result: success
02. SELECT `readed_count`, `voted_count`, `blamed_count`, `comment_count`, `trackback_count` FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
Result: success
03. 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` >= ?
Result: success
04. SHOW TABLES LIKE 'rx_pointhistory'
Result: success
05. SELECT * FROM `rx_modules` AS `modules` WHERE `module` = ?
Result: success
06. SELECT * FROM `rx_itemshop_transaction` AS `itemshop_transaction` WHERE `member_srl` = ?
Result: success
07. SELECT `documents`.`voted_count`, `documents`.`title`, `documents`.`last_update`, `documents`.`readed_count`, `documents`.`last_updater`, `documents`.`document_srl`, `documents`.`module_srl`, `documents`.`category_srl`, `documents`.`lang_code`, `documents`.`member_srl`, `documents`.`comment_count`, `documents`.`trackback_count`, `documents`.`uploaded_count`, `documents`.`status`, `documents`.`regdate`, `documents`.`title_bold`, `documents`.`title_color` FROM `rx_documents` AS `documents` WHERE (`module_srl` IN (?) AND `is_notice` = ?) OR `is_notice` = ? ORDER BY `list_order` ASC
Result: success
08. SELECT COUNT(*) AS `count` FROM `rx_documents` AS `documents` WHERE `module_srl` IN (?) AND `status` IN (?, ?)
Result: success
09. SELECT `documents`.`voted_count`, `documents`.`title`, `documents`.`last_update`, `documents`.`readed_count`, `documents`.`last_updater`, `documents`.`document_srl`, `documents`.`module_srl`, `documents`.`category_srl`, `documents`.`lang_code`, `documents`.`member_srl`, `documents`.`comment_count`, `documents`.`trackback_count`, `documents`.`uploaded_count`, `documents`.`status`, `documents`.`regdate`, `documents`.`title_bold`, `documents`.`title_color` FROM `rx_documents` AS `documents` WHERE `module_srl` IN (?) AND `status` IN (?, ?) ORDER BY `documents`.`list_order` ASC LIMIT 20
Result: success
10. 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` >= ?
Result: success
11. UPDATE `rx_ncenterlite_notify` SET `readed` = ? WHERE `member_srl` = ? AND `srl` = ?
Result: success
12. SELECT * FROM `rx_document_voted_log` AS `document_voted_log` WHERE `document_srl` = ? AND (`member_srl` = ?)
Result: success
13. SELECT `member`.`member_srl` AS `member_srl`, `member`.`nick_name` AS `nick_name` FROM `rx_document_voted_log` AS `voted_log`, `rx_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
Result: success
14. SELECT `member`.`member_srl` AS `member_srl`, `member`.`nick_name` AS `nick_name` FROM `rx_document_voted_log` AS `voted_log`, `rx_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
Result: success
15. SELECT * FROM `rx_files` AS `files` WHERE `upload_target_srl` = ? AND `isvalid` = ? ORDER BY `file_srl` ASC
Result: success
16. SELECT COUNT(*) AS `count` FROM `rx_documents` AS `documents` WHERE `member_srl` IN (?) AND `status` IN (?)
Result: success
17. SELECT * FROM `rx_documents` AS `documents` WHERE `member_srl` IN (?) AND `status` IN (?) ORDER BY `documents`.`list_order` ASC LIMIT 5
Result: success
18. 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` >= ?
Result: success
19. SELECT COUNT(*) AS `count` FROM `rx_comments` AS `comments` USE INDEX (`idx_member_srl`) WHERE `member_srl` = ?
Result: success
20. SELECT `comment_srl`, `parent_srl`, `regdate` FROM `rx_comments` AS `comments` USE INDEX (`idx_member_srl`) WHERE `member_srl` = ? ORDER BY `list_order` ASC LIMIT 5
Result: success
21. SELECT * FROM `rx_comments` AS `comments` WHERE `comment_srl` = ?
Result: success
22. SELECT * FROM `rx_comments` AS `comments` WHERE `comment_srl` = ?
Result: success
23. SELECT * FROM `rx_document_declared` AS `document_declared` WHERE `document_srl` = ?
Result: success
24. SELECT * FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
Result: success
25. SELECT * FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
Result: success
26. SELECT * FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
Result: success
27. SELECT * FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
Result: success
28. SELECT * FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
Result: success
29. SELECT * FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
Result: success
30. SELECT * FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
Result: success
31. SELECT * FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
Result: success
32. SELECT * FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
Result: success
33. SELECT * FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
Result: success
34. SELECT * FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
Result: success
35. SELECT * FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
Result: success
36. SELECT * FROM `rx_editor_components` AS `editor_components` WHERE `component_name` = ?
Result: success
37. SELECT * FROM `rx_modules` AS `modules` WHERE `module` = ?
Result: success
38. SELECT * FROM `rx_itemshop_transaction` AS `itemshop_transaction` WHERE `member_srl` = ?
Result: success
39. SELECT `document_srl`, `module_srl`, count(*) AS `count` FROM `rx_tags` AS `tags` WHERE `module_srl` >= ? AND `tag` IN (?, ?, ?, ?, ?, ?) GROUP BY `document_srl`
Result: success
40. SELECT COUNT(*) AS `count` FROM `rx_documents` AS `documents` WHERE `document_srl` IN (?, ?)
Result: success
41. SELECT `document_srl`, `module_srl`, `title`, `nick_name`, `user_name`, `user_id`, `regdate`, `readed_count`, `voted_count`, `comment_count` FROM `rx_documents` AS `documents` WHERE `document_srl` IN (?, ?) ORDER BY `list_order` ASC LIMIT 2
Result: success
Result: success
02. SELECT `readed_count`, `voted_count`, `blamed_count`, `comment_count`, `trackback_count` FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
Result: success
03. 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` >= ?
Result: success
04. SHOW TABLES LIKE 'rx_pointhistory'
Result: success
05. SELECT * FROM `rx_modules` AS `modules` WHERE `module` = ?
Result: success
06. SELECT * FROM `rx_itemshop_transaction` AS `itemshop_transaction` WHERE `member_srl` = ?
Result: success
07. SELECT `documents`.`voted_count`, `documents`.`title`, `documents`.`last_update`, `documents`.`readed_count`, `documents`.`last_updater`, `documents`.`document_srl`, `documents`.`module_srl`, `documents`.`category_srl`, `documents`.`lang_code`, `documents`.`member_srl`, `documents`.`comment_count`, `documents`.`trackback_count`, `documents`.`uploaded_count`, `documents`.`status`, `documents`.`regdate`, `documents`.`title_bold`, `documents`.`title_color` FROM `rx_documents` AS `documents` WHERE (`module_srl` IN (?) AND `is_notice` = ?) OR `is_notice` = ? ORDER BY `list_order` ASC
Result: success
08. SELECT COUNT(*) AS `count` FROM `rx_documents` AS `documents` WHERE `module_srl` IN (?) AND `status` IN (?, ?)
Result: success
09. SELECT `documents`.`voted_count`, `documents`.`title`, `documents`.`last_update`, `documents`.`readed_count`, `documents`.`last_updater`, `documents`.`document_srl`, `documents`.`module_srl`, `documents`.`category_srl`, `documents`.`lang_code`, `documents`.`member_srl`, `documents`.`comment_count`, `documents`.`trackback_count`, `documents`.`uploaded_count`, `documents`.`status`, `documents`.`regdate`, `documents`.`title_bold`, `documents`.`title_color` FROM `rx_documents` AS `documents` WHERE `module_srl` IN (?) AND `status` IN (?, ?) ORDER BY `documents`.`list_order` ASC LIMIT 20
Result: success
10. 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` >= ?
Result: success
11. UPDATE `rx_ncenterlite_notify` SET `readed` = ? WHERE `member_srl` = ? AND `srl` = ?
Result: success
12. SELECT * FROM `rx_document_voted_log` AS `document_voted_log` WHERE `document_srl` = ? AND (`member_srl` = ?)
Result: success
13. SELECT `member`.`member_srl` AS `member_srl`, `member`.`nick_name` AS `nick_name` FROM `rx_document_voted_log` AS `voted_log`, `rx_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
Result: success
14. SELECT `member`.`member_srl` AS `member_srl`, `member`.`nick_name` AS `nick_name` FROM `rx_document_voted_log` AS `voted_log`, `rx_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
Result: success
15. SELECT * FROM `rx_files` AS `files` WHERE `upload_target_srl` = ? AND `isvalid` = ? ORDER BY `file_srl` ASC
Result: success
16. SELECT COUNT(*) AS `count` FROM `rx_documents` AS `documents` WHERE `member_srl` IN (?) AND `status` IN (?)
Result: success
17. SELECT * FROM `rx_documents` AS `documents` WHERE `member_srl` IN (?) AND `status` IN (?) ORDER BY `documents`.`list_order` ASC LIMIT 5
Result: success
18. 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` >= ?
Result: success
19. SELECT COUNT(*) AS `count` FROM `rx_comments` AS `comments` USE INDEX (`idx_member_srl`) WHERE `member_srl` = ?
Result: success
20. SELECT `comment_srl`, `parent_srl`, `regdate` FROM `rx_comments` AS `comments` USE INDEX (`idx_member_srl`) WHERE `member_srl` = ? ORDER BY `list_order` ASC LIMIT 5
Result: success
21. SELECT * FROM `rx_comments` AS `comments` WHERE `comment_srl` = ?
Result: success
22. SELECT * FROM `rx_comments` AS `comments` WHERE `comment_srl` = ?
Result: success
23. SELECT * FROM `rx_document_declared` AS `document_declared` WHERE `document_srl` = ?
Result: success
24. SELECT * FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
Result: success
25. SELECT * FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
Result: success
26. SELECT * FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
Result: success
27. SELECT * FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
Result: success
28. SELECT * FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
Result: success
29. SELECT * FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
Result: success
30. SELECT * FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
Result: success
31. SELECT * FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
Result: success
32. SELECT * FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
Result: success
33. SELECT * FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
Result: success
34. SELECT * FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
Result: success
35. SELECT * FROM `rx_documents` AS `documents` WHERE `document_srl` = ?
Result: success
36. SELECT * FROM `rx_editor_components` AS `editor_components` WHERE `component_name` = ?
Result: success
37. SELECT * FROM `rx_modules` AS `modules` WHERE `module` = ?
Result: success
38. SELECT * FROM `rx_itemshop_transaction` AS `itemshop_transaction` WHERE `member_srl` = ?
Result: success
39. SELECT `document_srl`, `module_srl`, count(*) AS `count` FROM `rx_tags` AS `tags` WHERE `module_srl` >= ? AND `tag` IN (?, ?, ?, ?, ?, ?) GROUP BY `document_srl`
Result: success
40. SELECT COUNT(*) AS `count` FROM `rx_documents` AS `documents` WHERE `document_srl` IN (?, ?)
Result: success
41. SELECT `document_srl`, `module_srl`, `title`, `nick_name`, `user_name`, `user_id`, `regdate`, `readed_count`, `voted_count`, `comment_count` FROM `rx_documents` AS `documents` WHERE `document_srl` IN (?, ?) ORDER BY `list_order` ASC LIMIT 2
Result: success
내강아지
Lv. 5
댓글 11
패널에서 느린쿼리를 따로 출력해주는 부분이 맞는지 봐보세요.
그리고 에러랑 그런거 뜨더라도 실행에는 지장을 주지 않는 경우라면 무시하시되, 나중에 PHP버전을 업데이트 할 경우 작동이 어려운 상태가 초래할 수 있습니다.
해당 버전에서 유지하는경우라면 그냥 무시하셔도 큰 문제는 없어요.
느린쿼리 부분은 이 부분을 복사한 내용입니다. 그대로 둬도 괜찮은가요..
에러는 php를 아직 업데이트 할 계획이 없기때문에 말씀대로 유지하면 당분간 문제가 되지 않겠지만 느린 쿼리는 어찌해야되나요?
짧게 설정해두면 모든 쿼리가 다나올수 있어요.
너무 짧게 잡으면 다 뜨겠죠?
적당한 기준으로 해 놓으셨는데 뜬다면 분석해 볼필요가 있겠죠.
진단은 전문가분들께서 ~~