Actief Media

Memory usage: 1,237.98kb
Memory peak: 1,301.72kb
Server load: 0.08
Execution time: 0.094s

SELECT id FROM domains WHERE `host` = '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, 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 (217192) OR media.parent_id IN (217192) 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 (217194) OR media.parent_id IN (217194) 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 (217190) OR media.parent_id IN (217190) ORDER BY media.parent_id, media.id
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'socielmediabuttons.facebook'
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.google'
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 (217190) OR media.parent_id IN (217190) 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 = '/actief-media' 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 c.id, c.parent_id, c.name, c.description, c.uri, c.public, c.dossier, 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 = 521
SELECT parent_id, name, description, uri, public, dossier, associated, articles, `order`, depth, approve_comments, comments_login_accounts, comments_login_twitter, comments_login_facebook FROM categories WHERE id = 521
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'category.show_image_items'
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'category.interval'
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'category.article_age'
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'category.show_chapeau'
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'category.pagination'
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'category.show_date'
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'category.show_time'
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'category.show_date_subitems'
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'category.show_title'
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'category.title_clickeable'
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'category.lazyload'
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( 521 ) AND redirects.domain_id IN( 0, 1 )
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'category.view'
SELECT SQL_CALC_FOUND_ROWS a.id, a.approve_comments, a.display_comments, a.accept_comments, a.auto_close_comments, a.is_sticky, a.published_datetime, a.created, version.show_introduction, version.uri, version.title, version.chapeau, version.introduction, version.text, version.plain_title, version.plain_text, version.plain_intro, version.has_photo, version.has_video, version.has_poll, version.has_attachment, version.has_audio, version.has_dossier, version.sticky_until FROM articles a INNER JOIN article_version version ON a.id = version.article_id 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( 521 ) AND a.for_web = 1 AND (a.public_datetime IS NULL OR a.public_datetime < 1545168198) AND ( a.public_datetime > 162691200 ) AND version.version = 'final' AND domain.domain_id = 1 ORDER BY a.is_sticky DESC, a.public_datetime DESC LIMIT 0, 15
SELECT FOUND_ROWS()
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( 31579, 31536, 31371, 31372, 31351, 30531, 30471, 30424, 30425, 30426, 30417, 30418, 30319, 30320, 30321 ) AND redirects.domain_id IN( 0, 1 )
SELECT article_id, media_id FROM article_media WHERE article_id IN( 31579, 31536, 31371, 31372, 31351, 30531, 30471, 30424, 30425, 30426, 30417, 30418, 30319, 30320, 30321 ) AND `order` = 0 GROUP BY article_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 (198515, 198521, 198527, 198635, 198641, 198647, 198653, 198749, 198899) OR media.parent_id IN (198515, 198521, 198527, 198635, 198641, 198647, 198653, 198749, 198899) 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( 31579, 31536, 31371, 31372, 31351, 30531, 30471, 30424, 30425, 30426, 30417, 30418, 30319, 30320, 30321 )
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 31579
SELECT f.title, f.author_id, f.url, f.status, f.social_media, f.prefix_title, f.show_author, f.show_company, f.show_logo, f.show_button, f.import_images, f.import_images_number, f.import_char, f.last_import, f.number_of_items, f.created, ym.media_id FROM article_feeds f LEFT JOIN account_yellowpages ay ON ay.ID_ACCOUNT = f.author_id AND ay.is_primary = 1 LEFT JOIN yellowpages_media ym ON (ym.ID_COMPANY = ay.ID_COMPANY AND disposition = 'thumbnail') WHERE f.id_feed = 68
SELECT id, categories, name, address, zipcode, country, created, created_ip, last_modified, last_modified_ip, disabled, is_payed FROM yellowpages WHERE id = 1737
SELECT `key`, `value` FROM yellowpages_fields_values WHERE ID_COMPANY = 1737
SELECT item.media_id id, media.path, item.caption, item.description, item.disposition, media.mime, media.filename FROM yellowpages_media item INNER JOIN media ON ( media.parent_id = item.media_id AND media.size = item.disposition ) WHERE ID_COMPANY = 1737
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 31536
SELECT f.title, f.author_id, f.url, f.status, f.social_media, f.prefix_title, f.show_author, f.show_company, f.show_logo, f.show_button, f.import_images, f.import_images_number, f.import_char, f.last_import, f.number_of_items, f.created, ym.media_id FROM article_feeds f LEFT JOIN account_yellowpages ay ON ay.ID_ACCOUNT = f.author_id AND ay.is_primary = 1 LEFT JOIN yellowpages_media ym ON (ym.ID_COMPANY = ay.ID_COMPANY AND disposition = 'thumbnail') WHERE f.id_feed = 68
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 31371
SELECT f.title, f.author_id, f.url, f.status, f.social_media, f.prefix_title, f.show_author, f.show_company, f.show_logo, f.show_button, f.import_images, f.import_images_number, f.import_char, f.last_import, f.number_of_items, f.created, ym.media_id FROM article_feeds f LEFT JOIN account_yellowpages ay ON ay.ID_ACCOUNT = f.author_id AND ay.is_primary = 1 LEFT JOIN yellowpages_media ym ON (ym.ID_COMPANY = ay.ID_COMPANY AND disposition = 'thumbnail') WHERE f.id_feed = 68
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 31372
SELECT f.title, f.author_id, f.url, f.status, f.social_media, f.prefix_title, f.show_author, f.show_company, f.show_logo, f.show_button, f.import_images, f.import_images_number, f.import_char, f.last_import, f.number_of_items, f.created, ym.media_id FROM article_feeds f LEFT JOIN account_yellowpages ay ON ay.ID_ACCOUNT = f.author_id AND ay.is_primary = 1 LEFT JOIN yellowpages_media ym ON (ym.ID_COMPANY = ay.ID_COMPANY AND disposition = 'thumbnail') WHERE f.id_feed = 68
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 31351
SELECT f.title, f.author_id, f.url, f.status, f.social_media, f.prefix_title, f.show_author, f.show_company, f.show_logo, f.show_button, f.import_images, f.import_images_number, f.import_char, f.last_import, f.number_of_items, f.created, ym.media_id FROM article_feeds f LEFT JOIN account_yellowpages ay ON ay.ID_ACCOUNT = f.author_id AND ay.is_primary = 1 LEFT JOIN yellowpages_media ym ON (ym.ID_COMPANY = ay.ID_COMPANY AND disposition = 'thumbnail') WHERE f.id_feed = 68
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 30531
SELECT f.title, f.author_id, f.url, f.status, f.social_media, f.prefix_title, f.show_author, f.show_company, f.show_logo, f.show_button, f.import_images, f.import_images_number, f.import_char, f.last_import, f.number_of_items, f.created, ym.media_id FROM article_feeds f LEFT JOIN account_yellowpages ay ON ay.ID_ACCOUNT = f.author_id AND ay.is_primary = 1 LEFT JOIN yellowpages_media ym ON (ym.ID_COMPANY = ay.ID_COMPANY AND disposition = 'thumbnail') WHERE f.id_feed = 66
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 30471
SELECT f.title, f.author_id, f.url, f.status, f.social_media, f.prefix_title, f.show_author, f.show_company, f.show_logo, f.show_button, f.import_images, f.import_images_number, f.import_char, f.last_import, f.number_of_items, f.created, ym.media_id FROM article_feeds f LEFT JOIN account_yellowpages ay ON ay.ID_ACCOUNT = f.author_id AND ay.is_primary = 1 LEFT JOIN yellowpages_media ym ON (ym.ID_COMPANY = ay.ID_COMPANY AND disposition = 'thumbnail') WHERE f.id_feed = 67
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 30424
SELECT f.title, f.author_id, f.url, f.status, f.social_media, f.prefix_title, f.show_author, f.show_company, f.show_logo, f.show_button, f.import_images, f.import_images_number, f.import_char, f.last_import, f.number_of_items, f.created, ym.media_id FROM article_feeds f LEFT JOIN account_yellowpages ay ON ay.ID_ACCOUNT = f.author_id AND ay.is_primary = 1 LEFT JOIN yellowpages_media ym ON (ym.ID_COMPANY = ay.ID_COMPANY AND disposition = 'thumbnail') WHERE f.id_feed = 67
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 30425
SELECT f.title, f.author_id, f.url, f.status, f.social_media, f.prefix_title, f.show_author, f.show_company, f.show_logo, f.show_button, f.import_images, f.import_images_number, f.import_char, f.last_import, f.number_of_items, f.created, ym.media_id FROM article_feeds f LEFT JOIN account_yellowpages ay ON ay.ID_ACCOUNT = f.author_id AND ay.is_primary = 1 LEFT JOIN yellowpages_media ym ON (ym.ID_COMPANY = ay.ID_COMPANY AND disposition = 'thumbnail') WHERE f.id_feed = 67
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 30426
SELECT f.title, f.author_id, f.url, f.status, f.social_media, f.prefix_title, f.show_author, f.show_company, f.show_logo, f.show_button, f.import_images, f.import_images_number, f.import_char, f.last_import, f.number_of_items, f.created, ym.media_id FROM article_feeds f LEFT JOIN account_yellowpages ay ON ay.ID_ACCOUNT = f.author_id AND ay.is_primary = 1 LEFT JOIN yellowpages_media ym ON (ym.ID_COMPANY = ay.ID_COMPANY AND disposition = 'thumbnail') WHERE f.id_feed = 67
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 30417
SELECT f.title, f.author_id, f.url, f.status, f.social_media, f.prefix_title, f.show_author, f.show_company, f.show_logo, f.show_button, f.import_images, f.import_images_number, f.import_char, f.last_import, f.number_of_items, f.created, ym.media_id FROM article_feeds f LEFT JOIN account_yellowpages ay ON ay.ID_ACCOUNT = f.author_id AND ay.is_primary = 1 LEFT JOIN yellowpages_media ym ON (ym.ID_COMPANY = ay.ID_COMPANY AND disposition = 'thumbnail') WHERE f.id_feed = 67
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 30418
SELECT f.title, f.author_id, f.url, f.status, f.social_media, f.prefix_title, f.show_author, f.show_company, f.show_logo, f.show_button, f.import_images, f.import_images_number, f.import_char, f.last_import, f.number_of_items, f.created, ym.media_id FROM article_feeds f LEFT JOIN account_yellowpages ay ON ay.ID_ACCOUNT = f.author_id AND ay.is_primary = 1 LEFT JOIN yellowpages_media ym ON (ym.ID_COMPANY = ay.ID_COMPANY AND disposition = 'thumbnail') WHERE f.id_feed = 67
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 30319
SELECT f.title, f.author_id, f.url, f.status, f.social_media, f.prefix_title, f.show_author, f.show_company, f.show_logo, f.show_button, f.import_images, f.import_images_number, f.import_char, f.last_import, f.number_of_items, f.created, ym.media_id FROM article_feeds f LEFT JOIN account_yellowpages ay ON ay.ID_ACCOUNT = f.author_id AND ay.is_primary = 1 LEFT JOIN yellowpages_media ym ON (ym.ID_COMPANY = ay.ID_COMPANY AND disposition = 'thumbnail') WHERE f.id_feed = 66
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 30320
SELECT f.title, f.author_id, f.url, f.status, f.social_media, f.prefix_title, f.show_author, f.show_company, f.show_logo, f.show_button, f.import_images, f.import_images_number, f.import_char, f.last_import, f.number_of_items, f.created, ym.media_id FROM article_feeds f LEFT JOIN account_yellowpages ay ON ay.ID_ACCOUNT = f.author_id AND ay.is_primary = 1 LEFT JOIN yellowpages_media ym ON (ym.ID_COMPANY = ay.ID_COMPANY AND disposition = 'thumbnail') WHERE f.id_feed = 66
SELECT ID_FEED, link FROM article_feeds_imported WHERE ID_ARTICLE = 30321
SELECT f.title, f.author_id, f.url, f.status, f.social_media, f.prefix_title, f.show_author, f.show_company, f.show_logo, f.show_button, f.import_images, f.import_images_number, f.import_char, f.last_import, f.number_of_items, f.created, ym.media_id FROM article_feeds f LEFT JOIN account_yellowpages ay ON ay.ID_ACCOUNT = f.author_id AND ay.is_primary = 1 LEFT JOIN yellowpages_media ym ON (ym.ID_COMPANY = ay.ID_COMPANY AND disposition = 'thumbnail') WHERE f.id_feed = 66
SELECT id FROM menus WHERE domain_id = 1 AND name = 'top'
SELECT id FROM menus WHERE domain_id = 1 AND name = 'top-persistent'
SELECT id FROM menus WHERE domain_id = 1 AND name = 'top'
SELECT * FROM `ad_type` ORDER BY `name`
SELECT * FROM `ad_type` ORDER BY `name`
SELECT display FROM ad_type WHERE id = 61
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 = 61 WHERE a.type = 1 AND a.publish_from <= '1545168198' AND (a.publish_until >= '1545168198' OR a.publish_until = '0') AND LOCATE('d', view) > 0 ORDER BY RAND() LIMIT 1
SELECT * FROM `ad_type` ORDER BY `name`
SELECT * FROM `ad_type` ORDER BY `name`
SELECT display FROM ad_type WHERE id = 62
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 = 62 WHERE a.type = 1 AND a.publish_from <= '1545168198' AND (a.publish_until >= '1545168198' OR a.publish_until = '0') AND LOCATE('d', view) > 0 ORDER BY RAND() LIMIT 1
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 = 60
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 = 60 WHERE a.type = 1 AND a.publish_from <= '1545168198' AND (a.publish_until >= '1545168198' OR a.publish_until = '0') AND LOCATE('d', view) > 0 ORDER BY RAND() LIMIT 1
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'ads.carrousels_interval'
SELECT frontpage_id FROM frontpages WHERE domain_id = 1 AND name = '[/articles/category]' LIMIT 1
SELECT parent_id FROM categories WHERE id = 521
SELECT c.frontpage_id FROM frontpage_categories c WHERE c.category_id IN( 521 ) AND c.domain_id = 1 ORDER BY c.frontpage_id DESC LIMIT 1
SELECT frontpage_id FROM frontpages WHERE domain_id = 1 AND is_homepage = 1
SELECT domain_id, name, class, is_homepage, templatedata FROM frontpages WHERE frontpage_id = 1
SELECT value, settype, unserialize FROM config WHERE domain_id = 1 AND field = 'cookie.activate_cookie'

widgets_1
parent_categories_521_0
menu_items_2
menu_items_3
menu_items_2
parent_category_ids_521_0
frontpage_template_1
{"0":"[articles title=\"Laatste nieuws\" sort=\"published\" limit=\"20\" exclude_category=\"\" max_char=\"150\"]","1":null,"title":"Laatste nieuws","sort":"published","limit":"20","exclude_category":"\"\"","max_char":"150"}

19/04	Hartthijs de Vries strijdlustigste in Wielerronde Ureterp
19/04	Stap binnen bij Energie Service Friesland
19/04	Presentatie uniek kerkorgel in Burgum
19/04	Camp-let weekend bij Vouwwagencentrum Noardburgum
19/04	Kalkhoff Roadtruck bij Profile Egberts
19/04	De tuin weer klaar voor de zomer met IJzerhandel Raadsma
19/04	Jumbo Burgum op zondag langer open
18/04	Sportief wandelen bij Impala
18/04	De Heideruters in de prijzen
18/04	SC Kootstertille kortwiekt titelkansen GSVV

Drachten - Woninginbreker op heterdaad aangehouden

Opeinde - Politie moet ingrijpen bij feest na voetbalwedstrijd

Groningen/Morra - Automobilist na lange achtervolging aangehouden

Leeuwarden - Man met nepvuurwapens op station aangehouden

Heerhugowaard - Zakkenroller met een luchtje aangehouden

Laatste nieuws