authors test

mc fullname 1461 dagen geleden

intro

Summary publishing test 1

Bold and into the future

nr 1

bullets

bull2 and more

source

Door mc fullname

Laatst geplaatst

It's sushi lunch time

Scheduled story 14:00

Memory usage: 1,258.48kb
Memory peak: 1,322.21kb
Server load: 4,59
Execution time: 0.047s

SELECT id FROM domains WHERE `host` = 'omroepmeierij.test.lokaalnieuwsnet.nl'
SELECT * FROM domains JOIN template ON domains.template = template.name WHERE id = 1
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'accounts.session.duration'
SELECT `id_domain`, `default` FROM `account_domain` WHERE `id_account` = 0
SELECT id, parent_id, account_id, size, path, filename, mime, width, height, title, description, tags, media.year_month, created, created_ip, last_modified, last_modified_ip FROM media WHERE media.id IN (607150) OR media.parent_id IN (607150) ORDER BY media.parent_id, media.id
SELECT id, parent_id, account_id, size, path, filename, mime, width, height, title, description, tags, media.year_month, created, created_ip, last_modified, last_modified_ip FROM media WHERE media.id IN (607148) OR media.parent_id IN (607148) ORDER BY media.parent_id, media.id
SELECT id, parent_id, account_id, size, path, filename, mime, width, height, title, description, tags, media.year_month, created, created_ip, last_modified, last_modified_ip FROM media WHERE media.id IN (607146) OR media.parent_id IN (607146) ORDER BY media.parent_id, media.id
SELECT id FROM domains ORDER BY id ASC LIMIT 1
SELECT * FROM domains JOIN template ON domains.template = template.name WHERE id = 1
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'facebook.app_domain'
SELECT id, parent_id, account_id, size, path, filename, mime, width, height, title, description, tags, media.year_month, created, created_ip, last_modified, last_modified_ip FROM media WHERE media.id IN (607146) OR media.parent_id IN (607146) ORDER BY media.parent_id, media.id
SELECT * FROM domains JOIN template ON domains.template = template.name WHERE id = 1
SELECT component, action, id, redirect FROM redirects WHERE uri = '/omroepmeierij/authors-test' AND domain_id IN( 0, 1 ) ORDER BY domain_id DESC
SELECT 1 FROM components WHERE domain_id = 1 AND component = 'widgets'
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'widgets'
SELECT widget.position, widget.value FROM widgets widget WHERE widget.domain_id = 1 AND widget.position IN ('analytics', 'top_menu', 'submenu', 'footer_block', 'banner_top', 'banner_footer', 'banner_pushtop')
SELECT 1 FROM components WHERE domain_id = 1 AND component = 'articles'
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'category.article_age'
SELECT a.id, a.approve_comments, a.display_comments, a.accept_comments, a.auto_close_comments, a.is_sticky, a.published_datetime, a.created, a.last_modified FROM articles a WHERE a.id IN ( 3347 ) AND a.for_web = 1 AND (a.public_datetime IS NULL OR a.public_datetime <= 1762637654) ORDER BY a.public_datetime DESC LIMIT 0, 10
SELECT FOUND_ROWS()
SELECT v.article_id, v.show_introduction, v.uri, v.title, v.chapeau, v.introduction, v.text, v.plain_title, v.plain_text, v.plain_intro, v.has_photo, v.has_video, v.has_poll, v.has_attachment, v.has_audio, v.has_dossier, v.sticky_until FROM article_version v WHERE v.article_id IN (3347) AND v.version = 'final'
SELECT ac.article_id, c.class FROM categories c INNER JOIN article_category ac ON ac.category_id = c.id AND ac.article_id IN( 3347 ) WHERE LENGTH(c.class);
SELECT ac.article_id, c.id, c.name FROM categories c INNER JOIN article_category ac ON ac.category_id = c.id AND ac.article_id IN( 3347 ) WHERE c.type = 3 AND c.public ORDER BY c.depth DESC, c.id DESC
SELECT ac.article_id, c.id, c.name FROM categories c INNER JOIN article_category ac ON ac.category_id = c.id AND ac.article_id IN( 3347 ) WHERE c.type = 1 AND c.public ORDER BY c.depth DESC, c.id DESC
SELECT comment.table_id, COUNT(comment.id) FROM comments comment WHERE comment.table_name = 'articles' AND comment.table_id IN( 3347 ) AND ( comment.state IN (1) OR comment.ip = '216.73.216.107' ) GROUP BY comment.table_id
SELECT redirects.id, redirects.uri, domains.host FROM redirects LEFT JOIN domains ON redirects.domain_id = domains.id WHERE redirects.component = 'articles' AND redirects.action = 'article' AND redirects.id IN( 3347 ) AND redirects.domain_id IN( 0, 1 )
SELECT aa.id, aa.author_id, aa.company_id, aa.show_author, aa.show_company, author.screen_name as author_name FROM article_author aa LEFT JOIN accounts author ON author.id = aa.author_id WHERE aa.id IN( 3347 )
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3347
INSERT INTO `article_hits` (article_id, last_read, hits) VALUES(3347, 1762637654, 0) ON DUPLICATE KEY UPDATE last_read = 1762637654
SELECT category_id FROM article_category WHERE article_id = 3347
SELECT c.id, c.parent_id, c.name, c.description, c.uri, c.public, c.type, c.associated, c.articles, c.order, c.depth, c.approve_comments, c.comments_login_accounts, c.comments_login_twitter, c.comments_login_facebook FROM categories c WHERE c.id = 645
SELECT redirects.id, redirects.uri, domains.host FROM redirects LEFT JOIN domains ON redirects.domain_id = domains.id WHERE redirects.component = 'articles' AND redirects.action = 'category' AND redirects.id IN( 645 ) AND redirects.domain_id IN( 0, 1 )
SELECT c.id, c.parent_id, c.name, c.description, c.uri, c.public, c.type, c.associated, c.articles, c.order, c.depth, c.approve_comments, c.comments_login_accounts, c.comments_login_twitter, c.comments_login_facebook FROM categories c WHERE c.id = 655
SELECT redirects.id, redirects.uri, domains.host FROM redirects LEFT JOIN domains ON redirects.domain_id = domains.id WHERE redirects.component = 'articles' AND redirects.action = 'category' AND redirects.id IN( 655 ) AND redirects.domain_id IN( 0, 1 )
SELECT c.id, c.parent_id, c.name, c.description, c.uri, c.public, c.type, c.associated, c.articles, c.order, c.depth, c.approve_comments, c.comments_login_accounts, c.comments_login_twitter, c.comments_login_facebook FROM categories c WHERE c.id = 659
SELECT redirects.id, redirects.uri, domains.host FROM redirects LEFT JOIN domains ON redirects.domain_id = domains.id WHERE redirects.component = 'articles' AND redirects.action = 'category' AND redirects.id IN( 659 ) AND redirects.domain_id IN( 0, 1 )
SELECT c.id, c.parent_id, c.name, c.description, c.uri, c.public, c.type, c.associated, c.articles, c.order, c.depth, c.approve_comments, c.comments_login_accounts, c.comments_login_twitter, c.comments_login_facebook FROM categories c WHERE c.id = 3810
SELECT redirects.id, redirects.uri, domains.host FROM redirects LEFT JOIN domains ON redirects.domain_id = domains.id WHERE redirects.component = 'articles' AND redirects.action = 'category' AND redirects.id IN( 3810 ) AND redirects.domain_id IN( 0, 1 )
SELECT c.id, c.parent_id, c.name, c.description, c.uri, c.public, c.type, c.associated, c.articles, c.order, c.depth, c.approve_comments, c.comments_login_accounts, c.comments_login_twitter, c.comments_login_facebook FROM categories c WHERE c.id = 3824
SELECT redirects.id, redirects.uri, domains.host FROM redirects LEFT JOIN domains ON redirects.domain_id = domains.id WHERE redirects.component = 'articles' AND redirects.action = 'tag' AND redirects.id IN( 3824 ) AND redirects.domain_id IN( 0, 1 )
SELECT c.id, c.parent_id, c.name, c.description, c.uri, c.public, c.type, c.associated, c.articles, c.order, c.depth, c.approve_comments, c.comments_login_accounts, c.comments_login_twitter, c.comments_login_facebook FROM categories c WHERE c.id = 3825
SELECT redirects.id, redirects.uri, domains.host FROM redirects LEFT JOIN domains ON redirects.domain_id = domains.id WHERE redirects.component = 'articles' AND redirects.action = 'tag' AND redirects.id IN( 3825 ) AND redirects.domain_id IN( 0, 1 )
SELECT id FROM menu_items WHERE (uri = '/omroepmeierij' OR uri = '/articles/category/645') AND menu_id IN( SELECT id FROM menus WHERE domain_id = 1 )
SELECT id FROM menu_items WHERE (uri = '/omroepmeierij/nieuws' OR uri = '/articles/category/655') AND menu_id IN( SELECT id FROM menus WHERE domain_id = 1 )
SELECT id FROM menu_items WHERE (uri = '/omroepmeierij/uitgelicht' OR uri = '/articles/category/659') AND menu_id IN( SELECT id FROM menus WHERE domain_id = 1 )
SELECT ay.ID_COMPANY, first_name, last_name, screen_name, username, email, created, created_ip, validation_hash, last_modified, last_modified_ip, last_login, last_login_ip, password, password_hash FROM accounts as a LEFT JOIN account_yellowpages as ay ON ay.ID_ACCOUNT = a.id AND is_primary = 1 WHERE id = 663
SELECT m.key, m.value FROM account_meta m WHERE m.account_id = 663
SELECT a.component, a.action, a.max_amount FROM account_auth a WHERE a.account_id = 663
SELECT geodata.latitude, geodata.longitude, geodata.address, geodata.caption, geodata.description FROM article_geodata geodata WHERE geodata.article_id = 3347 AND geodata.published = 1 ORDER BY geodata.order
SELECT redirects.id, redirects.uri, domains.host FROM redirects LEFT JOIN domains ON redirects.domain_id = domains.id WHERE redirects.component = 'articles' AND redirects.action = 'article' AND redirects.id IN( 3347 ) AND redirects.domain_id IN( 0, 1 )
SELECT media.media_id id, media.disposition, media.caption, media.description FROM article_media media WHERE media.article_id = '3347' ORDER BY media.order ASC
SELECT id, parent_id, account_id, size, path, filename, mime, width, height, title, description, tags, media.year_month, created, created_ip, last_modified, last_modified_ip FROM media WHERE media.id IN (548246) OR media.parent_id IN (548246) ORDER BY media.parent_id, media.id
SELECT m.path, m.width, m.height FROM media m INNER JOIN article_media am ON am.media_id = m.parent_id AND am.article_id = 3347 WHERE m.width >= 200 AND m.height >= 200 ORDER BY am.order ASC LIMIT 1
SELECT id, parent_id, account_id, size, path, filename, mime, width, height, title, description, tags, media.year_month, created, created_ip, last_modified, last_modified_ip FROM media WHERE media.id IN (548246) OR media.parent_id IN (548246) ORDER BY media.parent_id, media.id
SELECT redirects.id, redirects.uri, domains.host FROM redirects LEFT JOIN domains ON redirects.domain_id = domains.id WHERE redirects.component = 'articles' AND redirects.action = 'article' AND redirects.id IN( 3347 ) AND redirects.domain_id IN( 0, 1 )
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3347
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'plista.feed_category'
SELECT ac.article_id, c.id, c.name FROM categories c INNER JOIN article_category ac ON ac.category_id = c.id AND ac.article_id IN( 3347 ) WHERE c.type = 3 AND c.public ORDER BY c.depth DESC, c.id DESC
SELECT redirects.id, redirects.uri, domains.host FROM redirects LEFT JOIN domains ON redirects.domain_id = domains.id WHERE redirects.component = 'articles' AND redirects.action = 'tag' AND redirects.id IN( 3825 ) AND redirects.domain_id IN( 0, 1 )
SELECT a.id, a.approve_comments, a.display_comments, a.accept_comments, a.auto_close_comments, a.is_sticky, a.published_datetime, a.created, a.last_modified FROM articles a INNER JOIN article_category category ON category.article_id = a.id INNER JOIN article_domains domain ON a.id = domain.article_id WHERE category.category_id IN( 3825 ) AND a.id NOT IN( 3347 ) AND a.for_web = 1 AND (a.public_datetime IS NULL OR a.public_datetime <= 1762637654) AND ( a.public_datetime >= 863913600 ) AND domain.domain_id = 1 ORDER BY a.public_datetime DESC LIMIT 0, 10
SELECT FOUND_ROWS()
SELECT v.article_id, v.show_introduction, v.uri, v.title, v.chapeau, v.introduction, v.text, v.plain_title, v.plain_text, v.plain_intro, v.has_photo, v.has_video, v.has_poll, v.has_attachment, v.has_audio, v.has_dossier, v.sticky_until FROM article_version v WHERE v.article_id IN (3381, 3349, 3373) AND v.version = 'final'
SELECT ac.article_id, c.class FROM categories c INNER JOIN article_category ac ON ac.category_id = c.id AND ac.article_id IN( 3381, 3349, 3373 ) WHERE LENGTH(c.class);
SELECT ac.article_id, c.id, c.name FROM categories c INNER JOIN article_category ac ON ac.category_id = c.id AND ac.article_id IN( 3381, 3349, 3373 ) WHERE c.type = 3 AND c.public ORDER BY c.depth DESC, c.id DESC
SELECT ac.article_id, c.id, c.name FROM categories c INNER JOIN article_category ac ON ac.category_id = c.id AND ac.article_id IN( 3381, 3349, 3373 ) WHERE c.type = 1 AND c.public ORDER BY c.depth DESC, c.id DESC
SELECT comment.table_id, COUNT(comment.id) FROM comments comment WHERE comment.table_name = 'articles' AND comment.table_id IN( 3381, 3349, 3373 ) AND ( comment.state IN (1) OR comment.ip = '216.73.216.107' ) GROUP BY comment.table_id
SELECT redirects.id, redirects.uri, domains.host FROM redirects LEFT JOIN domains ON redirects.domain_id = domains.id WHERE redirects.component = 'articles' AND redirects.action = 'article' AND redirects.id IN( 3381, 3349, 3373 ) AND redirects.domain_id IN( 0, 1 )
SELECT article_id, media_id FROM article_media WHERE article_id IN( 3381, 3349, 3373 ) ORDER BY `order` ASC
SELECT id, parent_id, account_id, size, path, filename, mime, width, height, title, description, tags, media.year_month, created, created_ip, last_modified, last_modified_ip FROM media WHERE media.id IN (572569, 560234, 580916) OR media.parent_id IN (572569, 560234, 580916) ORDER BY media.parent_id, media.id
SELECT aa.id, aa.author_id, aa.company_id, aa.show_author, aa.show_company, author.screen_name as author_name FROM article_author aa LEFT JOIN accounts author ON author.id = aa.author_id WHERE aa.id IN( 3381, 3349, 3373 )
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3381
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3349
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3373
SELECT id FROM menus WHERE domain_id = 1 AND name = 'top'
SELECT id FROM menus WHERE domain_id = 1 AND name = 'top'
SELECT frontpage_id FROM frontpages WHERE domain_id = 1 AND name = '[/articles/article]' LIMIT 1
SELECT domain_id, name, class, is_homepage, templatedata FROM frontpages WHERE frontpage_id = 5
SELECT * FROM `ad_type` ORDER BY `name`
SELECT * FROM `ad_type` ORDER BY `name`
SELECT display FROM ad_type WHERE id = 73
SELECT a.id, a.target, a.media_id, a.name, t.type, a.javascript, a.has_custom_javascript, a.link FROM ads a INNER JOIN ad_type t ON t.id = a.ad_type_id AND t.id = 73 WHERE a.type = 1 AND a.publish_from <= '1762637654' AND (a.publish_until >= '1762637654' OR a.publish_until = '0') AND LOCATE('d', view) > 0 ORDER BY RAND() LIMIT 9999
SELECT * FROM `ad_type` ORDER BY `name`
SELECT * FROM `ad_type` ORDER BY `name`
SELECT display FROM ad_type WHERE id = 74
SELECT a.id, a.target, a.media_id, a.name, t.type, a.javascript, a.has_custom_javascript, a.link FROM ads a INNER JOIN ad_type t ON t.id = a.ad_type_id AND t.id = 74 WHERE a.type = 1 AND a.publish_from <= '1762637654' AND (a.publish_until >= '1762637654' OR a.publish_until = '0') AND LOCATE('d', view) > 0 ORDER BY RAND() LIMIT 9999
SELECT m.id, m.path FROM media m WHERE m.id IN( 258472, 258471, 258475 )
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'ads.carrousels_interval'
SELECT * FROM `ad_type` ORDER BY `name`
SELECT * FROM `ad_type` ORDER BY `name`
SELECT display FROM ad_type WHERE id = 75
SELECT a.id, a.target, a.media_id, a.name, t.type, a.javascript, a.has_custom_javascript, a.link FROM ads a INNER JOIN ad_type t ON t.id = a.ad_type_id AND t.id = 75 WHERE a.type = 1 AND a.publish_from <= '1762637654' AND (a.publish_until >= '1762637654' OR a.publish_until = '0') AND LOCATE('d', view) > 0 ORDER BY RAND() LIMIT 9999
SELECT m.id, m.path FROM media m WHERE m.id IN( 258465, 258204, 258464 )
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'ads.carrousels_interval'
SELECT * FROM `ad_type` ORDER BY `name`
SELECT * FROM `ad_type` ORDER BY `name`
SELECT * FROM `ad_type` ORDER BY `name`
SELECT * FROM `ad_type` ORDER BY `name`
SELECT * FROM `ad_type` ORDER BY `name`
SELECT * FROM `ad_type` ORDER BY `name`

config-1
config-1
config-1
config-1
config-1
config-1
config-1
config-1
config-1
widgets_1
config-1
config-1
config-1
config-1
config-1
menu_items_8
menu_items_8
frontpage_template_5_bot
{"0":"[articles limit=\"3\" sort=\"published\" view=\"default\"]","1":null,"limit":"3","sort":"published","view":"default"}
config-1
config-1
config-1

OmroepMeierij

authors test

Tags

Door mc fullname

Laatst geplaatst