Berichten testen 2

Dordrecht-helpdesk 2103 dagen geleden

intro

Summary

Door Dordrecht-helpdesk

Laatst geplaatst

It's sushi lunch time

Scheduled story 14:00

Memory usage: 1,272.07kb
Memory peak: 1,335.80kb
Server load: 3,82
Execution time: 0.098s

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.twitter'
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'socielmediabuttons.instagram'
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'socielmediabuttons.linkedin'
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/berichten-testen-2' 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 ( 3260 ) AND a.for_web = 1 AND (a.public_datetime IS NULL OR a.public_datetime <= 1762648572) 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 (3260) 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( 3260 ) 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( 3260 ) 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( 3260 ) 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( 3260 ) 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( 3260 ) 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( 3260 )
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3260
INSERT INTO `article_hits` (article_id, last_read, hits) VALUES(3260, 1762648572, 0) ON DUPLICATE KEY UPDATE last_read = 1762648572
SELECT category_id FROM article_category WHERE article_id = 3260
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 = 3260 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( 3260 ) 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 = '3260' 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 (274040) OR media.parent_id IN (274040) 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 = 3260 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 (274040) OR media.parent_id IN (274040) 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( 3260 ) AND redirects.domain_id IN( 0, 1 )
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3260
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 value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'categories.plista-enabled-655'
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( 3260 ) 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( 3260 ) AND a.for_web = 1 AND (a.public_datetime IS NULL OR a.public_datetime <= 1762648572) 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 (3265, 3264, 3261, 3262, 3263, 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( 3265, 3264, 3261, 3262, 3263, 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( 3265, 3264, 3261, 3262, 3263, 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( 3265, 3264, 3261, 3262, 3263, 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( 3265, 3264, 3261, 3262, 3263, 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( 3265, 3264, 3261, 3262, 3263, 3259 ) AND redirects.domain_id IN( 0, 1 )
SELECT article_id, media_id FROM article_media WHERE article_id IN( 3265, 3264, 3261, 3262, 3263, 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 (274337, 274054, 274061, 274330, 274351) OR media.parent_id IN (274337, 274054, 274061, 274330, 274351) 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( 3265, 3264, 3261, 3262, 3263, 3259 )
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3265
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 = 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 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_domains domain ON a.id = domain.article_id WHERE a.for_web = 1 AND (a.public_datetime IS NULL OR a.public_datetime <= 1762648572) AND ( a.public_datetime >= 863913600 ) AND domain.domain_id = 1 ORDER BY a.public_datetime DESC LIMIT 0, 3
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 (3407, 3403, 3402) 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( 3407, 3403, 3402 ) 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( 3407, 3403, 3402 ) 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( 3407, 3403, 3402 ) WHERE c.type = 1 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 = 'article' AND redirects.id IN( 3407, 3403, 3402 ) AND redirects.domain_id IN( 0, 1 )
SELECT article_id, media_id FROM article_media WHERE article_id IN( 3407, 3403, 3402 ) 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 (581541, 581542, 583634) OR media.parent_id IN (581541, 581542, 583634) 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( 3407, 3403, 3402 )
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3407
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3403
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 3402
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'category.show_date'
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 <= '1762648572' AND (a.publish_until >= '1762648572' 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 <= '1762648572' AND (a.publish_until >= '1762648572' 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 <= '1762648572' AND (a.publish_until >= '1762648572' 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
config-1

OmroepMeierij

Berichten testen 2

Tags

Door Dordrecht-helpdesk

Laatst geplaatst