에러가 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
패널에서 느린쿼리를 따로 출력해주는 부분이 맞는지 봐보세요.
그리고 에러랑 그런거 뜨더라도 실행에는 지장을 주지 않는 경우라면 무시하시되, 나중에 PHP버전을 업데이트 할 경우 작동이 어려운 상태가 초래할 수 있습니다.
해당 버전에서 유지하는경우라면 그냥 무시하셔도 큰 문제는 없어요.