1

주제: 다중사용자 관련(Unknown column 'a.owner' in 'field list')

태터 1.0.6 -> 1.1.3 -> 1.7.6으로 업그레이드 진행했습니다.

메인이 되는 블로그는 어떻게든 돌아가고 있는 것 같습니다.
이전에 사용하던 다중 블로깅 기능이 안되네요.

메인 : http://dain2.net (O)
다중 : http://dain2.net/riss (X)

에러메시지는 아래와 같고
디버깅 모드 on 한 내용도 덧붙입니다.

도움 말씀 부탁드립니다.

(1) dain2.net/riss로 접속시 에러 메시지 : Unknown column 'a.owner' in 'field list'
(2) 디버깅 on :
Undefined variable: lightboxuser(8)
File: /home/hosting_users/miniz/www/plugins/lightbox/lightboxtt_setting.php:13

--------------------------------------------------------------------------------
Undefined offset: 6(8)
File: /home/hosting_users/miniz/www/plugins/CHAKANI_BRAINTAG/index.php:27

--------------------------------------------------------------------------------
Unknown column 'a.owner' in 'field list'count query string elapsed (ms) elapsed sum (ms)  rows error stack
1 [DEBUG : Basic functions loaded.]  6.7     /home/hosting_users/miniz/www/interface/index.php:46 include_once
/home/hosting_users/miniz/www/rewrite.php:90


2 [DEBUG : Default library loaded.]  18.0     /home/hosting_users/miniz/www/interface/index.php:46 include_once
/home/hosting_users/miniz/www/rewrite.php:90


3 [DEBUG : Models loaded.]  106.7     /home/hosting_users/miniz/www/interface/index.php:46 include_once
/home/hosting_users/miniz/www/rewrite.php:90


4 [DEBUG : Views loaded.]  121.3     /home/hosting_users/miniz/www/interface/index.php:46 include_once
/home/hosting_users/miniz/www/rewrite.php:90


5 SET CHARACTER SET utf8 0.2 127.3   0 Error no. 1115 : Unknown character set: 'utf8' /home/hosting_users/miniz/www/library/initialize.php:13 require
/home/hosting_users/miniz/www/library/include.php:87 require
/home/hosting_users/miniz/www/library/includeForBlog.php:58 require
/home/hosting_users/miniz/www/interface/index.php:46 include_once
/home/hosting_users/miniz/www/rewrite.php:90


6 SET SESSION collation_connection = 'utf8_general_ci' 0.2 127.7   0 Error no. 1064 : You have an error in your SQL syntax near 'collation_connection = 'utf8_general_ci'' at line 1 /home/hosting_users/miniz/www/library/initialize.php:13 require
/home/hosting_users/miniz/www/library/include.php:87 require
/home/hosting_users/miniz/www/library/includeForBlog.php:58 require
/home/hosting_users/miniz/www/interface/index.php:46 include_once
/home/hosting_users/miniz/www/rewrite.php:90


7 SELECT name, value FROM tt_ServiceSettings 0.5 129.8   6  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 pod::queryallwithcache
/home/hosting_users/miniz/www/library/model/common.setting.php:30 getservicesetting
/home/hosting_users/miniz/www/library/suri.php:8 require
/home/hosting_users/miniz/www/library/initialize.php:24 require
/home/hosting_users/miniz/www/library/include.php:87 require
/home/hosting_users/miniz/www/library/includeForBlog.php:58 require
/home/hosting_users/miniz/www/interface/index.php:46 include_once
/home/hosting_users/miniz/www/rewrite.php:90


8 SELECT blogid FROM tt_BlogSettings WHERE name='name' AND value='riss' LIMIT 1 0.4 130.7   1  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell
/home/hosting_users/miniz/www/library/components/Needlworks.Database.php:100 tablequery->getcell
/home/hosting_users/miniz/www/library/model/blog.service.php:14 getblogidbyname
/home/hosting_users/miniz/www/library/suri.php:41 require
/home/hosting_users/miniz/www/library/initialize.php:24 require
/home/hosting_users/miniz/www/library/include.php:87 require
/home/hosting_users/miniz/www/library/includeForBlog.php:58 require
/home/hosting_users/miniz/www/interface/index.php:46 include_once
/home/hosting_users/miniz/www/rewrite.php:90


9 SELECT value FROM tt_PageCacheLog WHERE blogid = 2 AND name = 'globalCacheStorage' 0.4 133.7   0  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell
/home/hosting_users/miniz/www/library/components/Needlworks.Cache.PageCache.php:270 globalcachestorage->load
/home/hosting_users/miniz/www/library/components/Needlworks.Cache.PageCache.php:280 globalcachestorage->getcontent
/home/hosting_users/miniz/www/library/components/Textcube.Function.Setting.php:59 setting::getblogsettingsglobal
/home/hosting_users/miniz/www/library/model/blog.service.php:25 getblogsettings
/home/hosting_users/miniz/www/library/suri.php:58 require
/home/hosting_users/miniz/www/library/initialize.php:24 require
/home/hosting_users/miniz/www/library/include.php:87 require
/home/hosting_users/miniz/www/library/includeForBlog.php:58 require
/home/hosting_users/miniz/www/interface/index.php:46 include_once
/home/hosting_users/miniz/www/rewrite.php:90


10 SELECT * FROM tt_BlogSettings WHERE blogid=2 0.7 134.7   36  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:161 pod::queryall
/home/hosting_users/miniz/www/library/components/Needlworks.Database.php:112 tablequery->getall
/home/hosting_users/miniz/www/library/components/Textcube.Function.Setting.php:68 setting::getblogsettingsglobal
/home/hosting_users/miniz/www/library/model/blog.service.php:25 getblogsettings
/home/hosting_users/miniz/www/library/suri.php:58 require
/home/hosting_users/miniz/www/library/initialize.php:24 require
/home/hosting_users/miniz/www/library/include.php:87 require
/home/hosting_users/miniz/www/library/includeForBlog.php:58 require
/home/hosting_users/miniz/www/interface/index.php:46 include_once
/home/hosting_users/miniz/www/rewrite.php:90


11 SELECT * FROM tt_SkinSettings WHERE blogid = 2 0.5 136.1   1  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:120 pod::queryrow
/home/hosting_users/miniz/www/library/model/blog.service.php:47 getskinsetting
/home/hosting_users/miniz/www/library/suri.php:59 require
/home/hosting_users/miniz/www/library/initialize.php:24 require
/home/hosting_users/miniz/www/library/include.php:87 require
/home/hosting_users/miniz/www/library/includeForBlog.php:58 require
/home/hosting_users/miniz/www/interface/index.php:46 include_once
/home/hosting_users/miniz/www/rewrite.php:90


12 SELECT id FROM tt_Sessions WHERE id = '5639e8a955130847680ea8df4d186aa7' AND address = '211.180.195.57' AND (userid IS NOT NULL OR preexistence IS NOT NULL) 0.4 139.0   1  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell
/home/hosting_users/miniz/www/library/session.php:233 _sessionquery
/home/hosting_users/miniz/www/library/session.php:215 sessionquery
/home/hosting_users/miniz/www/library/session.php:144 issessionauthorized
/home/hosting_users/miniz/www/library/session.php:170 setsession
/home/hosting_users/miniz/www/library/session.php:244 require
/home/hosting_users/miniz/www/library/initialize.php:27 require
/home/hosting_users/miniz/www/library/include.php:87 require
/home/hosting_users/miniz/www/library/includeForBlog.php:58 require
/home/hosting_users/miniz/www/interface/index.php:46 include_once
/home/hosting_users/miniz/www/rewrite.php:90


13 SELECT data FROM tt_Sessions WHERE id = '5639e8a955130847680ea8df4d186aa7' AND address = '211.180.195.57' AND updated >= (UNIX_TIMESTAMP() - 3600) 0.4 139.7   1  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell
/home/hosting_users/miniz/www/library/session.php:233 _sessionquery
/home/hosting_users/miniz/www/library/session.php:215 sessionquery
/home/hosting_users/miniz/www/library/session.php:39 readsession
/home/hosting_users/miniz/www/library/session.php:248 require
/home/hosting_users/miniz/www/library/initialize.php:27 require
/home/hosting_users/miniz/www/library/include.php:87 require
/home/hosting_users/miniz/www/library/includeForBlog.php:58 require
/home/hosting_users/miniz/www/interface/index.php:46 include_once
/home/hosting_users/miniz/www/rewrite.php:90


14 SELECT name FROM tt_Users WHERE userid = 1 0.3 140.3   1  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell
/home/hosting_users/miniz/www/library/components/Textcube.Core.php:24 user::getname
/home/hosting_users/miniz/www/library/initialize.php:33 require
/home/hosting_users/miniz/www/library/include.php:87 require
/home/hosting_users/miniz/www/library/includeForBlog.php:58 require
/home/hosting_users/miniz/www/interface/index.php:46 include_once
/home/hosting_users/miniz/www/rewrite.php:90


15 SELECT name, value FROM tt_UserSettings WHERE userid = 1 0.3 140.8   0  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:161 pod::queryall
/home/hosting_users/miniz/www/library/components/Textcube.Function.Setting.php:231 setting::getusersettingglobal
/home/hosting_users/miniz/www/library/components/Textcube.Core.php:126 user::gethomepage
/home/hosting_users/miniz/www/library/initialize.php:34 require
/home/hosting_users/miniz/www/library/include.php:87 require
/home/hosting_users/miniz/www/library/includeForBlog.php:58 require
/home/hosting_users/miniz/www/interface/index.php:46 include_once
/home/hosting_users/miniz/www/rewrite.php:90


16 SET time_zone = '0+9:00' 0.2 141.3   0 Error no. 1064 : You have an error in your SQL syntax near 'time_zone = '0+9:00'' at line 1 /home/hosting_users/miniz/www/library/include.php:87 require
/home/hosting_users/miniz/www/library/includeForBlog.php:58 require
/home/hosting_users/miniz/www/interface/index.php:46 include_once
/home/hosting_users/miniz/www/rewrite.php:90


17 [DEBUG : Initialization finished.]  143.2     /home/hosting_users/miniz/www/interface/index.php:46 include_once
/home/hosting_users/miniz/www/rewrite.php:90


18 SELECT name FROM tt_Plugins WHERE blogid = 2 0.6 147.2   11  /home/hosting_users/miniz/www/library/plugins.php:29 require
/home/hosting_users/miniz/www/library/include.php:87 require
/home/hosting_users/miniz/www/library/includeForBlog.php:58 require
/home/hosting_users/miniz/www/interface/index.php:46 include_once
/home/hosting_users/miniz/www/rewrite.php:90


19 [DEBUG : Plugin module loaded.]  175.7     /home/hosting_users/miniz/www/interface/index.php:46 include_once
/home/hosting_users/miniz/www/rewrite.php:90


20 SELECT CN.*, CNQ.id AS queueId, CNQ.commentId AS commentId, CNQ.sendStatus AS sendStatus, CNQ.checkDate AS checkDate, CNQ.written AS queueWritten FROM tt_CommentsNotifiedQueue AS CNQ LEFT JOIN tt_Comments AS CN ON CNQ.commentId = CN.id WHERE CNQ.sendStatus = '0' and CN.parent is not null ORDER BY CNQ.id ASC LIMIT 0, 1 0.5 176.5   0  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:120 pod::queryrow
/home/hosting_users/miniz/www/library/model/blog.comment.php:857 notifycomment
/home/hosting_users/miniz/www/interface/index.php:64 include_once
/home/hosting_users/miniz/www/rewrite.php:90


21 SELECT value FROM tt_PageCacheLog WHERE blogid = 2 AND name = 'skinCache' 0.4 177.5   1  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell
/home/hosting_users/miniz/www/library/components/Needlworks.Cache.PageCache.php:144 pagecache->getpagecachelog
/home/hosting_users/miniz/www/library/components/Needlworks.Cache.PageCache.php:137 pagecache->getdbcontents
/home/hosting_users/miniz/www/library/components/Needlworks.Cache.PageCache.php:73 pagecache->load
/home/hosting_users/miniz/www/library/blog.skin.php:361 skin->loadcache
/home/hosting_users/miniz/www/library/blog.skin.php:93 skin->skin
/home/hosting_users/miniz/www/interface/index.php:71 include_once
/home/hosting_users/miniz/www/rewrite.php:90


22 SELECT COUNT(*) FROM tt_Entries e LEFT JOIN tt_Categories c ON e.blogid = c.blogid AND e.category = c.id WHERE e.blogid = 2 AND e.draft = 0 AND e.visibility > 0 AND (c.visibility > 1 OR e.category = 0) AND e.category >= 0 1.0 181.5   1  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell
/home/hosting_users/miniz/www/library/components/Textcube.Model.Paging.php:117 paging::fetchwithpaging
/home/hosting_users/miniz/www/library/model/common.legacysupport.php:76 fetchwithpaging
/home/hosting_users/miniz/www/library/model/blog.entry.php:208 getentrieswithpaging
/home/hosting_users/miniz/www/interface/index.php:79 include_once
/home/hosting_users/miniz/www/rewrite.php:90


23 SELECT e.*, c.label categoryLabel FROM tt_Entries e LEFT JOIN tt_Categories c ON e.blogid = c.blogid AND e.category = c.id WHERE e.blogid = 2 AND e.draft = 0 AND e.visibility > 0 AND (c.visibility > 1 OR e.category = 0) AND e.category >= 0 ORDER BY e.published DESC LIMIT 0, 1 0.9 182.6   1  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:161 pod::queryall
/home/hosting_users/miniz/www/library/components/Textcube.Model.Paging.php:136 paging::fetchwithpaging
/home/hosting_users/miniz/www/library/model/common.legacysupport.php:76 fetchwithpaging
/home/hosting_users/miniz/www/library/model/blog.entry.php:208 getentrieswithpaging
/home/hosting_users/miniz/www/interface/index.php:79 include_once
/home/hosting_users/miniz/www/rewrite.php:90


24 SELECT blogid FROM tt_SessionVisits WHERE id = '5639e8a955130847680ea8df4d186aa7' AND address = '211.180.195.57' AND blogid = 2 0.4 185.3   1  /home/hosting_users/miniz/www/library/components/Textcube.Model.Statistics.php:83 statistics::updatevisitorstatistics
/home/hosting_users/miniz/www/library/piece/blog/begin.php:8 require
/home/hosting_users/miniz/www/interface/index.php:80 include_once
/home/hosting_users/miniz/www/rewrite.php:90


25 SELECT visits FROM tt_BlogStatistics WHERE blogid = 2 0.3 185.8   1  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell
/home/hosting_users/miniz/www/library/components/Textcube.Model.Statistics.php:12 statistics::getstatistics
/home/hosting_users/miniz/www/library/piece/blog/begin.php:9 require
/home/hosting_users/miniz/www/interface/index.php:80 include_once
/home/hosting_users/miniz/www/rewrite.php:90


26 SELECT date, visits FROM tt_DailyStatistics WHERE blogid = 2 AND `date` in ('20081126','20081125') 0.4 186.3   2  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:161 pod::queryall
/home/hosting_users/miniz/www/library/components/Textcube.Model.Statistics.php:15 statistics::getstatistics
/home/hosting_users/miniz/www/library/piece/blog/begin.php:9 require
/home/hosting_users/miniz/www/interface/index.php:80 include_once
/home/hosting_users/miniz/www/rewrite.php:90


27 SELECT * FROM tt_Trackbacks WHERE blogid = 2 AND entry = 33 AND isFiltered = 0 ORDER BY written 0.6 191.0   0  /home/hosting_users/miniz/www/library/view/view.php:172 gettrackbacksview
/home/hosting_users/miniz/www/library/piece/blog/entries.php:73 require
/home/hosting_users/miniz/www/interface/index.php:81 include_once
/home/hosting_users/miniz/www/rewrite.php:90


28 SELECT * FROM tt_Comments WHERE blogid = 2 AND entry = 33 AND parent IS NULL AND isFiltered = 0 ORDER BY id ASC 0.7 192.4   0  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:161 pod::queryall
/home/hosting_users/miniz/www/library/model/blog.comment.php:254 getcomments
/home/hosting_users/miniz/www/library/view/view.php:256 getcommentview
/home/hosting_users/miniz/www/library/piece/blog/entries.php:79 require
/home/hosting_users/miniz/www/interface/index.php:81 include_once
/home/hosting_users/miniz/www/rewrite.php:90


29 SELECT `acceptComment` FROM `tt_Entries` WHERE `blogid` = 2 AND `id` = 33 0.4 193.2   1  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell
/home/hosting_users/miniz/www/library/view/view.php:362 getcommentview
/home/hosting_users/miniz/www/library/piece/blog/entries.php:79 require
/home/hosting_users/miniz/www/interface/index.php:81 include_once
/home/hosting_users/miniz/www/rewrite.php:90


30 SELECT t.* FROM `tt_Tags` t INNER JOIN `tt_TagRelations` r ON r.blogid = 2 AND r.entry = 33 AND r.tag = t.id INNER JOIN `tt_Entries` e ON e.id = r.entry AND e.visibility > 0 GROUP BY r.tag ORDER BY t.name 0.7 194.5   0  /home/hosting_users/miniz/www/library/piece/blog/entries.php:81 require
/home/hosting_users/miniz/www/interface/index.php:81 include_once
/home/hosting_users/miniz/www/rewrite.php:90


31 SELECT name FROM tt_Users WHERE userid = 2 0.3 195.1   1  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell
/home/hosting_users/miniz/www/library/components/Textcube.Core.php:24 user::getname
/home/hosting_users/miniz/www/library/piece/blog/entries.php:113 require
/home/hosting_users/miniz/www/interface/index.php:81 include_once
/home/hosting_users/miniz/www/rewrite.php:90


32 SELECT * FROM tt_Categories WHERE blogid = 2 AND id >= 0 ORDER BY parent, priority 0.5 196.0   4  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 pod::queryallwithcache
/home/hosting_users/miniz/www/library/model/blog.category.php:118 getcategories
/home/hosting_users/miniz/www/library/model/blog.category.php:59 getcategorybodyidbyid
/home/hosting_users/miniz/www/library/piece/blog/entries.php:123 require
/home/hosting_users/miniz/www/interface/index.php:81 include_once
/home/hosting_users/miniz/www/rewrite.php:90


33 SELECT title FROM tt_Entries WHERE blogid = 2 AND draft = 0 AND visibility > 0 AND category = -1 ORDER BY char_length(title) DESC 0.5 197.0   0  /home/hosting_users/miniz/www/library/model/blog.keyword.php:16 getkeywordnames
/home/hosting_users/miniz/www/library/piece/blog/entries.php:126 require
/home/hosting_users/miniz/www/interface/index.php:81 include_once
/home/hosting_users/miniz/www/rewrite.php:90


34 SELECT * FROM tt_Attachments WHERE blogid = 2 AND parent = 33 0.7 204.7   0  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:161 pod::queryall
/home/hosting_users/miniz/www/library/model/blog.attachment.php:19 getattachments
/home/hosting_users/miniz/www/plugins/FM_TTML/ttml.php:118 fm_ttml_bindattachments
/home/hosting_users/miniz/www/plugins/FM_TTML/index.php:11 fm_ttml_format
/home/hosting_users/miniz/www/library/model/common.module.php:71 formatcontent
/home/hosting_users/miniz/www/library/view/view.php:1127 getentrycontentview
/home/hosting_users/miniz/www/library/piece/blog/entries.php:126 require
/home/hosting_users/miniz/www/interface/index.php:81 include_once
/home/hosting_users/miniz/www/rewrite.php:90


35 SELECT COUNT(*) FROM tt_Entries e WHERE e.blogid = 2 AND e.draft = 0 AND e.visibility > 0 AND e.category >= 0 0.8 213.0   1  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell
/home/hosting_users/miniz/www/library/model/blog.entry.php:12 getentriestotalcount
/home/hosting_users/miniz/www/library/piece/blog/end.php:35 require
/home/hosting_users/miniz/www/interface/index.php:84 include_once
/home/hosting_users/miniz/www/rewrite.php:90


36 SELECT * FROM tt_Categories WHERE blogid = 2 AND id >= 0 ORDER BY parent, priority 0.0 213.3   0 (cached) /home/hosting_users/miniz/www/library/piece/blog/end.php:36 require
/home/hosting_users/miniz/www/interface/index.php:84 include_once
/home/hosting_users/miniz/www/rewrite.php:90


37 SELECT value FROM tt_PageCacheLog WHERE blogid = 2 AND name = 'entry_queryCache_1482161100' 0.4 216.2   1  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell
/home/hosting_users/miniz/www/library/components/Needlworks.Cache.PageCache.php:226 querycache->getpagecachelog
/home/hosting_users/miniz/www/library/components/Needlworks.Cache.PageCache.php:204 querycache->load
/home/hosting_users/miniz/www/library/components/POD.Core.Legacy.php:64 pod::queryallwithdbcache
/home/hosting_users/miniz/www/library/model/blog.archive.php:17 getarchives
/home/hosting_users/miniz/www/library/piece/blog/end.php:46 require
/home/hosting_users/miniz/www/interface/index.php:84 include_once
/home/hosting_users/miniz/www/rewrite.php:90


38 SELECT value FROM tt_PageCacheLog WHERE blogid = 2 AND name = 'entry_queryCache_2054490487' 0.4 217.6   1  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell
/home/hosting_users/miniz/www/library/components/Needlworks.Cache.PageCache.php:226 querycache->getpagecachelog
/home/hosting_users/miniz/www/library/components/Needlworks.Cache.PageCache.php:204 querycache->load
/home/hosting_users/miniz/www/library/components/POD.Core.Legacy.php:64 pod::queryallwithdbcache
/home/hosting_users/miniz/www/library/model/blog.archive.php:36 getcalendar
/home/hosting_users/miniz/www/library/piece/blog/end.php:48 require
/home/hosting_users/miniz/www/interface/index.php:84 include_once
/home/hosting_users/miniz/www/rewrite.php:90


39 SELECT name, count(*) cnt, t.id FROM `tt_Tags` t, `tt_TagRelations` r, `tt_Entries` e WHERE r.entry = e.id AND e.visibility > 0 AND t.id = r.tag AND r.blogid = 2 AND e.blogid = 2 GROUP BY r.tag ORDER BY RAND() limit 30 1.3 220.1   15  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:161 pod::queryall
/home/hosting_users/miniz/www/library/model/blog.tag.php:81 getrandomtags
/home/hosting_users/miniz/www/library/piece/blog/end.php:50 require
/home/hosting_users/miniz/www/interface/index.php:84 include_once
/home/hosting_users/miniz/www/rewrite.php:90


40 SELECT count(r.entry) `cnt` FROM `tt_TagRelations` r INNER JOIN `tt_Entries` e ON r.blogid = e.blogid AND e.visibility > 0 AND r.entry = e.id WHERE r.blogid = 2 GROUP BY r.tag ORDER BY `cnt` DESC LIMIT 1 1.0 221.6   1  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell
/home/hosting_users/miniz/www/library/model/blog.tag.php:124 gettagfrequencyrange
/home/hosting_users/miniz/www/library/view/view.php:1105 getrandomtagsview
/home/hosting_users/miniz/www/library/piece/blog/end.php:50 require
/home/hosting_users/miniz/www/interface/index.php:84 include_once
/home/hosting_users/miniz/www/rewrite.php:90


41 SELECT id, title, slogan, published FROM tt_Entries WHERE blogid = 2 AND draft = 0 AND visibility > 1 AND category = -2 ORDER BY published DESC 0.6 224.2   1  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:161 pod::queryall
/home/hosting_users/miniz/www/library/model/blog.notice.php:27 getnotices
/home/hosting_users/miniz/www/library/piece/blog/end.php:53 require
/home/hosting_users/miniz/www/interface/index.php:84 include_once
/home/hosting_users/miniz/www/rewrite.php:90


42 SELECT e.id, e.userid, e.title, e.slogan, e.comments FROM tt_Entries e WHERE e.blogid = 2 AND e.draft = 0 AND e.visibility > 0 AND e.category >= 0 ORDER BY published DESC LIMIT 10 0.9 225.8   10  /home/hosting_users/miniz/www/library/piece/blog/end.php:63 require
/home/hosting_users/miniz/www/interface/index.php:84 include_once
/home/hosting_users/miniz/www/rewrite.php:90


43 SELECT value FROM tt_PageCacheLog WHERE blogid = 2 AND name = 'comment_queryCache_1362052157' 0.4 228.5   1  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell
/home/hosting_users/miniz/www/library/components/Needlworks.Cache.PageCache.php:226 querycache->getpagecachelog
/home/hosting_users/miniz/www/library/components/Needlworks.Cache.PageCache.php:204 querycache->load
/home/hosting_users/miniz/www/library/components/POD.Core.Legacy.php:64 pod::queryallwithdbcache
/home/hosting_users/miniz/www/library/model/blog.comment.php:709 getrecentcomments
/home/hosting_users/miniz/www/library/piece/blog/end.php:65 require
/home/hosting_users/miniz/www/interface/index.php:84 include_once
/home/hosting_users/miniz/www/rewrite.php:90


44 SELECT value FROM tt_PageCacheLog WHERE blogid = 2 AND name = 'trackback_queryCache_1866093342' 0.4 231.2   1  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell
/home/hosting_users/miniz/www/library/components/Needlworks.Cache.PageCache.php:226 querycache->getpagecachelog
/home/hosting_users/miniz/www/library/components/Needlworks.Cache.PageCache.php:204 querycache->load
/home/hosting_users/miniz/www/library/components/POD.Core.Legacy.php:64 pod::queryallwithdbcache
/home/hosting_users/miniz/www/library/model/blog.trackback.php:128 getrecenttrackbacks
/home/hosting_users/miniz/www/library/piece/blog/end.php:67 require
/home/hosting_users/miniz/www/interface/index.php:84 include_once
/home/hosting_users/miniz/www/rewrite.php:90


45 SELECT l.*, lc.name AS categoryName FROM tt_Links l LEFT JOIN tt_LinkCategories lc ON lc.blogid = l.blogid AND lc.id = l.category WHERE l.blogid = 2 ORDER BY lc.name, l.name 0.6 232.2   4  /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache
/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:161 pod::queryall
/home/hosting_users/miniz/www/library/model/blog.link.php:16 getlinks
/home/hosting_users/miniz/www/library/piece/blog/end.php:69 require
/home/hosting_users/miniz/www/interface/index.php:84 include_once
/home/hosting_users/miniz/www/rewrite.php:90


Shutdown  242.9     

46 (45+1 cache) Queries
20.2 ms elapsed in db query, overall 242.9 ms elapsed 

path parser result :
Array
(
    [host] => dain2.net
    [fullpath] => /riss/
    [position] => /rewrite.php
    [root] => /
    [input] => riss/
    [URLfragment] => Array
        (
            [0] =>
        )

)
Array
(
    [url]=> /riss/
    [value] =>
    [directive] => /
    [page] => 1
)