6th Feb test nr 2

Er moeten een aantal nieuwe berichten worden aangemaakt voor het testen van de stories

Er zullen een aantal nieuwe berichten verschijnen voor de stories die moeten worden uitgetest. Dit zul waarschijnlijk een aantal keren worden uitgetest.

Door Dordrecht-helpdesk

Laatst geplaatst

It's sushi lunch time

Scheduled story 14:00

Memory usage: 1,265.08kb
Memory peak: 1,328.81kb
Server load: 4,16
Execution time: 0.048s

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 value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'socielmediabuttons.youtube'
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 = 'accounts.session.duration'
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 value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'accounts.session.duration'
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'facebook.app_id'
SELECT component, action, id, redirect FROM redirects WHERE uri = '/omroepmeierij/6th-feb-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 ( 3265 ) AND a.for_web = 1 AND (a.public_datetime IS NULL OR a.public_datetime <= 1762647780) 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 (3265) 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( 3265 ) 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( 3265 ) 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( 3265 ) 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( 3265 ) 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( 3265 ) 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( 3265 )
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3265
INSERT INTO `article_hits` (article_id, last_read, hits) VALUES(3265, 1762647780, 0) ON DUPLICATE KEY UPDATE last_read = 1762647780
SELECT category_id FROM article_category WHERE article_id = 3265
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 = 0
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 = 629
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( 629 ) 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 = 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 = 694
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( 694 ) AND redirects.domain_id IN( 0, 1 )
SELECT id FROM menu_items WHERE (uri = '/tags' OR uri = '/articles/category/629') AND menu_id IN( SELECT id FROM menus WHERE domain_id = 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 = '/tags/nieuws-1' OR uri = '/articles/category/694') 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 = 658
SELECT m.key, m.value FROM account_meta m WHERE m.account_id = 658
SELECT a.component, a.action, a.max_amount FROM account_auth a WHERE a.account_id = 658
SELECT geodata.latitude, geodata.longitude, geodata.address, geodata.caption, geodata.description FROM article_geodata geodata WHERE geodata.article_id = 3265 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( 3265 ) 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 = '3265' 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 (274351) OR media.parent_id IN (274351) 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 = 3265 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 (274351) OR media.parent_id IN (274351) 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( 3265 ) AND redirects.domain_id IN( 0, 1 )
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3265
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'plista.feed_category'
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'categories.plista-publickey'
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( 3265 ) 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( 694 ) 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( 694 ) AND a.id NOT IN( 3265 ) AND a.for_web = 1 AND (a.public_datetime IS NULL OR a.public_datetime <= 1762647780) 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 (3264, 3261, 3262, 3263, 3260, 3259) 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( 3264, 3261, 3262, 3263, 3260, 3259 ) 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( 3264, 3261, 3262, 3263, 3260, 3259 ) 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( 3264, 3261, 3262, 3263, 3260, 3259 ) 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( 3264, 3261, 3262, 3263, 3260, 3259 ) 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( 3264, 3261, 3262, 3263, 3260, 3259 ) AND redirects.domain_id IN( 0, 1 )
SELECT article_id, media_id FROM article_media WHERE article_id IN( 3264, 3261, 3262, 3263, 3260, 3259 ) 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 (274040, 274337, 274054, 274061, 274330) OR media.parent_id IN (274040, 274337, 274054, 274061, 274330) 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( 3264, 3261, 3262, 3263, 3260, 3259 )
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3264
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3261
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3262
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3263
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3260
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3259
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 <= '1762647780' AND (a.publish_until >= '1762647780' 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 <= '1762647780' AND (a.publish_until >= '1762647780' 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, 258475, 258471 )
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 <= '1762647780' AND (a.publish_until >= '1762647780' 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

6th Feb test nr 2

Tags

Door Dordrecht-helpdesk

Laatst geplaatst