×

Pokusná článek č. 1

  • Autor: Hlavní administrátořiAdministrátor
  • Vydáno: 13.3.2023 20:15
  • Přečteno: 12x
  • Komentářů: 0
8.0.0 GIT
166ms
3.0MB
9
SQL log
# Time Trace SQL
1 1ms show SELECT var,val FROM sl8_setting WHERE preload=1 AND web=1 
#0 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/plugins/extend/devkit/DevkitPlugin.php(66): SunlightExtend\Devkit\Component\SqlLogger->log()
#1 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/vendor/kuria/event/src/EventEmitter.php(143): SunlightExtend\Devkit\DevkitPlugin->onDbQueryPost()
#2 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Extend.php(62): Kuria\Event\EventEmitter->emit()
#3 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Database/Database.php(109): Sunlight\Extend::call()
#4 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Settings.php(24): Sunlight\Database\Database::query()
#5 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Core.php(334): Sunlight\Settings::init()
#6 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Core.php(141): Sunlight\Core::initSettings()
#7 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/index.php(20): Sunlight\Core::init()
#8 {main}
2 1ms show SELECT * FROM sl8_user_group WHERE id=2 
#0 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/plugins/extend/devkit/DevkitPlugin.php(66): SunlightExtend\Devkit\Component\SqlLogger->log()
#1 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/vendor/kuria/event/src/EventEmitter.php(143): SunlightExtend\Devkit\DevkitPlugin->onDbQueryPost()
#2 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Extend.php(62): Kuria\Event\EventEmitter->emit()
#3 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Database/Database.php(109): Sunlight\Extend::call()
#4 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Database/Database.php(122): Sunlight\Database\Database::query()
#5 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/User.php(279): Sunlight\Database\Database::queryRow()
#6 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/User.php(119): Sunlight\User::authenticate()
#7 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Core.php(481): Sunlight\User::init()
#8 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Core.php(147): Sunlight\Core::initSession()
#9 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/index.php(20): Sunlight\Core::init()
#10 {main}
3 1ms show SELECT page.* FROM sl8_page AS page WHERE page.type!=4 AND page.slug IN('clanky') ORDER BY LENGTH(page.slug) DESC LIMIT 1 
#0 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/plugins/extend/devkit/DevkitPlugin.php(66): SunlightExtend\Devkit\Component\SqlLogger->log()
#1 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/vendor/kuria/event/src/EventEmitter.php(143): SunlightExtend\Devkit\DevkitPlugin->onDbQueryPost()
#2 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Extend.php(62): Kuria\Event\EventEmitter->emit()
#3 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Database/Database.php(109): Sunlight\Extend::call()
#4 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Database/Database.php(122): Sunlight\Database\Database::query()
#5 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Page/Page.php(175): Sunlight\Database\Database::queryRow()
#6 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/action/page.php(14): Sunlight\Page\Page::find()
#7 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/index.php(117): require('...')
#8 {main}
4 90ms show SELECT COUNT(art.id) FROM sl8_article art LEFT JOIN sl8_page cat1 ON(art.home1!=-1 AND cat1.id=art.home1) LEFT JOIN sl8_page cat2 ON(art.home2!=-1 AND cat2.id=art.home2) LEFT JOIN sl8_page cat3 ON(art.home3!=-1 AND cat3.id=art.home3) WHERE (home1 IN(3) OR home2 IN(3) OR home3 IN(3)) AND art.time<=1765948944 AND art.confirmed=1 AND art.visible=1 AND art.public=1 AND (cat1.public=1 OR cat2.public=1 OR cat3.public=1) AND (cat1.level<=0 OR cat2.level<=0 OR cat3.level<=0) 
#0 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/plugins/extend/devkit/DevkitPlugin.php(66): SunlightExtend\Devkit\Component\SqlLogger->log()
#1 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/vendor/kuria/event/src/EventEmitter.php(143): SunlightExtend\Devkit\DevkitPlugin->onDbQueryPost()
#2 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Extend.php(62): Kuria\Event\EventEmitter->emit()
#3 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Database/Database.php(109): Sunlight\Extend::call()
#4 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Article.php(163): Sunlight\Database\Database::query()
#5 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/action/pages/category.php(56): Sunlight\Article::createFilter()
#6 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/action/page.php(137): require('...')
#7 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/index.php(117): require('...')
#8 {main}
5 2ms show SELECT art.id,art.title,art.slug,art.perex,u.id user_id,u.username user_username,u.publicname user_publicname,u.group_id user_group_id,u.avatar user_avatar,ug.title user_group_title,ug.icon user_group_icon,ug.level user_group_level,ug.color user_group_color,art.picture_uid,art.time,art.comments,art.readnum,cat1.slug AS cat_slug,(SELECT COUNT(*) FROM sl8_post AS post WHERE home=art.id AND post.type=2) AS comment_count FROM sl8_article AS art LEFT JOIN sl8_page cat1 ON(art.home1!=-1 AND cat1.id=art.home1) LEFT JOIN sl8_page cat2 ON(art.home2!=-1 AND cat2.id=art.home2) LEFT JOIN sl8_page cat3 ON(art.home3!=-1 AND cat3.id=art.home3) LEFT JOIN sl8_user u ON(art.author!=-1 AND art.author=u.id) LEFT JOIN sl8_user_group ug ON(ug.id=u.group_id) WHERE (home1 IN(3) OR home2 IN(3) OR home3 IN(3)) AND art.time<=1765948944 AND art.confirmed=1 AND art.visible=1 AND art.public=1 AND (cat1.public=1 OR cat2.public=1 OR cat3.public=1) AND (cat1.level<=0 OR cat2.level<=0 OR cat3.level<=0) ORDER BY time DESC LIMIT 0, 15 
#0 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/plugins/extend/devkit/DevkitPlugin.php(66): SunlightExtend\Devkit\Component\SqlLogger->log()
#1 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/vendor/kuria/event/src/EventEmitter.php(143): SunlightExtend\Devkit\DevkitPlugin->onDbQueryPost()
#2 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Extend.php(62): Kuria\Event\EventEmitter->emit()
#3 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Database/Database.php(109): Sunlight\Extend::call()
#4 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/action/pages/category.php(59): Sunlight\Database\Database::query()
#5 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/action/page.php(137): require('...')
#6 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/index.php(117): require('...')
#7 {main}
6 1ms show SELECT id,title,content,slot,page_ids,page_children,class FROM sl8_box WHERE template='chameleon' AND layout='default' AND visible=1 AND public=1 AND level <= 0 ORDER BY ord 
#0 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/plugins/extend/devkit/DevkitPlugin.php(66): SunlightExtend\Devkit\Component\SqlLogger->log()
#1 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/vendor/kuria/event/src/EventEmitter.php(143): SunlightExtend\Devkit\DevkitPlugin->onDbQueryPost()
#2 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Extend.php(62): Kuria\Event\EventEmitter->emit()
#3 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Database/Database.php(109): Sunlight\Extend::call()
#4 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Plugin/TemplatePlugin.php(151): Sunlight\Database\Database::query()
#5 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/index.php(143): Sunlight\Plugin\TemplatePlugin->getBoxes()
#6 {main}
7 0ms show SELECT r.id,r.node_parent,r.node_level,r.node_depth,r.title,r.slug,r.type,r.type_idt,r.ord,r.visible,r.public,r.level,r.link_url,r.link_new_window FROM sl8_page r WHERE r.node_level=0 AND (r.`node_depth`>0 OR (r.visible=1 AND r.type!=4 AND r.level<=0 AND (r.node_level!=0 OR r.ord>=0 AND r.ord<=5))) 
#0 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/plugins/extend/devkit/DevkitPlugin.php(66): SunlightExtend\Devkit\Component\SqlLogger->log()
#1 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/vendor/kuria/event/src/EventEmitter.php(143): SunlightExtend\Devkit\DevkitPlugin->onDbQueryPost()
#2 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Extend.php(62): Kuria\Event\EventEmitter->emit()
#3 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Database/Database.php(109): Sunlight\Extend::call()
#4 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Database/TreeReader.php(299): Sunlight\Database\Database::query()
#5 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Database/TreeReader.php(58): Sunlight\Database\TreeReader->loadTree()
#6 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Page/Page.php(437): Sunlight\Database\TreeReader->getTree()
#7 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Template.php(287): Sunlight\Page\Page::getRootPages()
#8 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/plugins/templates/chameleon/template.php(26): Sunlight\Template::menu()
#9 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/index.php(154): require('...')
#10 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/functions.php(13): {closure}()
#11 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/index.php(148): _buffer()
#12 {main}
8 1ms show SELECT r.id,r.node_parent,r.node_level,r.node_depth,r.title,r.slug,r.type,r.type_idt,r.ord,r.visible,r.public,r.level,r.link_url,r.link_new_window FROM sl8_page r WHERE r.node_level=0 AND (r.`node_depth`>0 OR (r.visible=1 AND r.type!=4 AND r.level<=0 AND (r.node_level!=0 OR r.ord>=0 AND r.ord<=5))) 
#0 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/plugins/extend/devkit/DevkitPlugin.php(66): SunlightExtend\Devkit\Component\SqlLogger->log()
#1 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/vendor/kuria/event/src/EventEmitter.php(143): SunlightExtend\Devkit\DevkitPlugin->onDbQueryPost()
#2 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Extend.php(62): Kuria\Event\EventEmitter->emit()
#3 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Database/Database.php(109): Sunlight\Extend::call()
#4 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Database/TreeReader.php(299): Sunlight\Database\Database::query()
#5 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Database/TreeReader.php(58): Sunlight\Database\TreeReader->loadTree()
#6 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Page/Page.php(437): Sunlight\Database\TreeReader->getTree()
#7 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Template.php(287): Sunlight\Page\Page::getRootPages()
#8 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/plugins/templates/chameleon/template.php(59): Sunlight\Template::menu()
#9 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/index.php(154): require('...')
#10 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/functions.php(13): {closure}()
#11 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/index.php(148): _buffer()
#12 {main}
9 0ms show SELECT n0.id,n0.node_parent,n0.node_level,n0.node_depth,n0.title,n0.slug,n0.type,n0.type_idt,n0.ord,n0.visible,n0.public,n0.level FROM sl8_page n0 WHERE n0.id=3 
#0 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/plugins/extend/devkit/DevkitPlugin.php(66): SunlightExtend\Devkit\Component\SqlLogger->log()
#1 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/vendor/kuria/event/src/EventEmitter.php(143): SunlightExtend\Devkit\DevkitPlugin->onDbQueryPost()
#2 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Extend.php(62): Kuria\Event\EventEmitter->emit()
#3 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Database/Database.php(109): Sunlight\Extend::call()
#4 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Database/TreeReader.php(507): Sunlight\Database\Database::query()
#5 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Database/TreeReader.php(49): Sunlight\Database\TreeReader->loadPath()
#6 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Page/Page.php(455): Sunlight\Database\TreeReader->getPath()
#7 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/class/Template.php(412): Sunlight\Page\Page::getPath()
#8 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/plugins/templates/chameleon/template.php(62): Sunlight\Template::breadcrumbs()
#9 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/index.php(154): require('...')
#10 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/system/functions.php(13): {closure}()
#11 /home/webaccounts/www.nasedlovice.cz/subdomains/muzeum.nasedlovice.cz/web/index.php(148): _buffer()
#12 {main}
46
Extend event log
Event Count Args
plugins.ready 1 -
db.table 15 (string) name, (NULL) value
db.query 9 (string) sql
db.query.after 9 (string) sql
settings.init 1 -
user.privileges 1 (array) privileges
user.auth.failure 1 (integer) error_code
core.ready 1 -
index.init 1 (Sunlight\WebState) index
page.init 1 (Sunlight\WebState) index, (array) segments
router.generate 27 (Kuria\Url\Url) url
page.all.before 1 (array) page, (string) script, (string) output
page.category.before 1 (array) page, (string) script, (string) output
page.category.content.before 1 (array) page, (string) output
page.category.content.after 1 (array) page, (string) output
paging.render 1 (string) url, (array) options, (integer) count, (integer) offset, (integer) limit, (integer) current, (integer) total, (integer) begin, (integer) end, (NULL) paging
user.query 1 (array) columns, (array) joins, (integer) empty_value, (string) prefix, (string) alias
page.category.item.before 1 (array) page, (array) item_query, (string) output
article.preview 1 (array) art, (array) user_query, (boolean) info, (boolean) perex, (string) output
user.link 1 (array) user, (array) options, (string) output
time.format 1 (integer) timestamp, (string) type, (string) output
article.preview.infos 1 (array) art, (array) user_query, (boolean) perex, (array) infos
page.category.item.after 1 (array) page, (array) item_query, (string) output
page.category.after 1 (array) page, (string) output
page.all.after 1 (array) page, (string) output
index.handle 1 (Sunlight\WebState) index
tpl.start 1 (Sunlight\WebState) index
tpl.ready 1 (Sunlight\WebState) index
tpl.title 1 (boolean) head, (string) output
core.javascript 1 (array) variables
tpl.head.meta 1 (string) output
tpl.head 1 (string) meta, (array) css, (array) js, (string) css_before, (string) css_after, (string) js_before, (string) js_after
tpl.body.tag 1 (string) output
tpl.body.start 1 (string) output
tpl.usermenu 2 (array) items, (string) output
tpl.usermenu.start 2 (string) output
tpl.usermenu.end 2 (string) output
page.menu_columns 2 (array) extra_columns
page.tree_columns 3 (array) extra_columns
tpl.menu.item 6 (string) type, (array) page, (array) classes, (NULL) url, (string) attrs, (string) output
hcm.run.search 1 (string) name, (array) arg_list, (NULL) output
tpl.breadcrumbs 1 (array) breadcrumbs, (boolean) only_when_multiple, (string) output
tpl.content 1 (string) content
tpl.links.before 1 (array) options, (string) output
tpl.links.after 1 (string) output
tpl.body.end 1 (string) output
Event listeners
Event Callback Priority
* SunlightExtend\Devkit\Component\EventLogger::log 10000
captcha.check.after SunlightExtend\Devkit\DevkitPlugin::onCaptchaCheckAfter 0
cron.maintenance Sunlight\Core::doMaintenance 0
db.query SunlightExtend\Devkit\DevkitPlugin::onDbQuery 0
db.query.after SunlightExtend\Devkit\DevkitPlugin::onDbQueryPost 0
error_screen.end SunlightExtend\Devkit\DevkitPlugin::onErrorScreenEnd 0
error_screen.head SunlightExtend\Devkit\DevkitPlugin::onErrorScreenHead 0
image.lightbox SunlightExtend\Lightbox\LightboxPlugin::onLightbox 0
iplog.check SunlightExtend\Devkit\DevkitPlugin::onIpLogCheck 0
localization.missing SunlightExtend\Devkit\DevkitPlugin::onMissingLocalization 0
mail.send SunlightExtend\Devkit\DevkitPlugin::onMail 0
mod.editpost.backlink SunlightExtend\Gallerycomments\GalleryCommentsPlugin::onCommentsEditBacklink 0
mod.editpost.edit SunlightExtend\PostEditinfo\PostEditInfoPlugin::onPostEdit 0
page.gallery.after SunlightExtend\Gallerycomments\GalleryCommentsPlugin::onCommentsShow 0
posts.1000.link SunlightExtend\Gallerycomments\GalleryCommentsPlugin::onCommentsLink 0
posts.1000.validate SunlightExtend\Gallerycomments\GalleryCommentsPlugin::onCommentsValidate 0
posts.columns SunlightExtend\PostEditinfo\PostEditInfoPlugin::onPostsColumns 0
posts.post SunlightExtend\PostEditinfo\PostEditInfoPlugin::onPostsPost 0
tpl.body.end SunlightExtend\Devkit\DevkitPlugin::onEnd 0
tpl.body.end SunlightExtend\Lightbox\LightboxPlugin::onEnd 0
tpl.head SunlightExtend\Devkit\DevkitPlugin::onHead 0
tpl.head SunlightExtend\Lightbox\LightboxPlugin::onHead 0
tpl.head SunlightExtend\PostEditinfo\PostEditInfoPlugin::onHead 0
0
Dumped values
Location Value
None
GET
×
+