Test LNN republish 5

mediachoice 1881 dagen geleden

intrro

Summary

Door mediachoice

Laatst geplaatst

It's sushi lunch time

Scheduled story 14:00

Memory usage: 1,285.22kb
Memory peak: 1,348.95kb
Server load: 5,57
Execution time: 0.036s

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 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/test-lnn-republish' 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 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 ( 3295 ) AND a.for_web = 1 AND (a.public_datetime IS NULL OR a.public_datetime <= 1762638659) 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 (3295) 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( 3295 ) 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( 3295 ) 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( 3295 ) 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( 3295 ) 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( 3295 ) 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( 3295 )
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3295
INSERT INTO `article_hits` (article_id, last_read, hits) VALUES(3295, 1762638659, 0) ON DUPLICATE KEY UPDATE last_read = 1762638659
SELECT category_id FROM article_category WHERE article_id = 3295
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 = 692
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( 692 ) 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 = 3816
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( 3816 ) 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 = 3817
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( 3817 ) 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 = 3818
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( 3818 ) 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/boxtel' OR uri = '/articles/category/692') AND menu_id IN( SELECT id FROM menus WHERE domain_id = 1 )
SELECT id FROM menu_items WHERE (uri = '/tags/disappear' OR uri = '/articles/category/3817') AND menu_id IN( SELECT id FROM menus WHERE domain_id = 1 )
SELECT id FROM menu_items WHERE (uri = '/tags/spoor' OR uri = '/articles/category/3818') 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 = 642
SELECT m.key, m.value FROM account_meta m WHERE m.account_id = 642
SELECT a.component, a.action, a.max_amount FROM account_auth a WHERE a.account_id = 642
SELECT geodata.latitude, geodata.longitude, geodata.address, geodata.caption, geodata.description FROM article_geodata geodata WHERE geodata.article_id = 3295 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( 3295 ) 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 = '3295' 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 (353785) OR media.parent_id IN (353785) 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 = 3295 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 (353785) OR media.parent_id IN (353785) 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( 3295 ) AND redirects.domain_id IN( 0, 1 )
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3295
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( 3295 ) 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( 3818 ) AND redirects.domain_id IN( 0, 1 )
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( 3817 ) AND redirects.domain_id IN( 0, 1 )
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( 692 ) 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( 3818, 3817, 692 ) AND a.id NOT IN( 3295 ) AND a.for_web = 1 AND (a.public_datetime IS NULL OR a.public_datetime <= 1762638659) 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 (3363, 3341, 3314, 3315, 3308, 3293, 1768) 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( 3363, 3341, 3314, 3315, 3308, 3293, 1768 ) 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( 3363, 3341, 3314, 3315, 3308, 3293, 1768 ) 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( 3363, 3341, 3314, 3315, 3308, 3293, 1768 ) 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( 3363, 3341, 3314, 3315, 3308, 3293, 1768 ) 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( 3363, 3341, 3314, 3315, 3308, 3293, 1768 ) AND redirects.domain_id IN( 0, 1 )
SELECT article_id, media_id FROM article_media WHERE article_id IN( 3363, 3341, 3314, 3315, 3308, 3293, 1768 ) 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 (132871, 333372, 429037, 506179, 543400) OR media.parent_id IN (132871, 333372, 429037, 506179, 543400) 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( 3363, 3341, 3314, 3315, 3308, 3293, 1768 )
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3363
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3341
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3314
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3315
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3308
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3293
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 1768
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 <= '1762638659' AND (a.publish_until >= '1762638659' 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 <= '1762638659' AND (a.publish_until >= '1762638659' 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 <= '1762638659' AND (a.publish_until >= '1762638659' 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( 258464, 258465, 258204 )
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

Test LNN republish 5

Tags

Door mediachoice

Laatst geplaatst