Linux

Handleiding Iptables firewall en ipset blacklist

Stel een firewall script op met blacklist op basis van iptables en ipset. Inclusief direct te downloaden script!

26 september 2016

Key-based SSH login met PuTTY

19 april 2016

Veilig inloggen als Root met één klik op de knop door gebruik te maken van een met PuTTYgen gegenereerd SSH key-pair.

0.09

636.47kb

719.53kb

0.051s

Deprecated 'Page::addTemplateLayer(index, , {base}/themes/{module})'; Use 'Page::setSubtemplate' instead. (/var/www/test-perfacilis-com/httpdocs/core/page.php:66) on /var/www/test-perfacilis-com/httpdocs/src/Perfacilis/helpers.php:208
Deprecated 'sites.lib.php'; Use 'Perfacilis\Cms\Site' instead. (/var/www/test-perfacilis-com/httpdocs/core/load.php:246) on /var/www/test-perfacilis-com/httpdocs/src/Perfacilis/helpers.php:208
Deprecated 'sites.lib.php'; Use 'Perfacilis\Cms\Site' instead. (/var/www/test-perfacilis-com/httpdocs/core/load.php:246) on /var/www/test-perfacilis-com/httpdocs/src/Perfacilis/helpers.php:208
Constant FILTER_SANITIZE_STRING is deprecated on /var/www/test-perfacilis-com/httpdocs/modules/www/actions/blogcategory.php:22
Undefined array key "show_title" on /var/www/test-perfacilis-com/httpdocs/modules/www/actions/page.php:95
Deprecated 'Page::addTemplateLayer(title, www, {base}/modules/{module}/templates)'; Use 'Page::setSubtemplate' instead. (/var/www/test-perfacilis-com/httpdocs/modules/www/actions/page.php:115) on /var/www/test-perfacilis-com/httpdocs/src/Perfacilis/helpers.php:208
Constant FILTER_SANITIZE_STRING is deprecated on /var/www/test-perfacilis-com/httpdocs/modules/www/actions/page.php:268
Constant FILTER_SANITIZE_STRING is deprecated on /var/www/test-perfacilis-com/httpdocs/modules/www/actions/page.php:268
Constant FILTER_SANITIZE_STRING is deprecated on /var/www/test-perfacilis-com/httpdocs/modules/www/actions/page.php:268

0.000s: SELECT SQL_CALC_FOUND_ROWS s.ID_SITE, s.ID_COMPANY, s.domainname, s.title, s.theme, s.is_primary, s.mode, s.created_time, s.created_by, s.deleted_time, s.deleted_by, c.name FROM `perfacilis_test`.`cms_sites` s INNER JOIN `perfacilis_test`.`contacts_companies` c ON c.ID_COMPANY = s.ID_COMPANY WHERE s.deleted_time = 0 AND s.domainname = 'perfacilis.com' ORDER BY s.domainname ASC
0.000s: SELECT FOUND_ROWS();
0.000s: SELECT SQL_CALC_FOUND_ROWS s.ID_SITE, s.ID_COMPANY, s.domainname, s.title, s.theme, s.is_primary, s.mode, s.created_time, s.created_by, s.deleted_time, s.deleted_by, c.name FROM `perfacilis_test`.`cms_sites` s INNER JOIN `perfacilis_test`.`contacts_companies` c ON c.ID_COMPANY = s.ID_COMPANY WHERE s.deleted_time = 0 ORDER BY s.domainname ASC
0.000s: SELECT FOUND_ROWS();
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'ga-tracking-id'
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'g-ads-tag-id'
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'g-site-vertification'
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'banner-width'
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'banner-height'
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'fb-app-id'
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'fb-admins'
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'twitter-site'
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'twitter-creator'
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'pinterest-verify'
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'header-scripts'
0.000s: SELECT `name`, `parent`, `scss`, `modified_at`, `modified_by` FROM `perfacilis_test`.theme WHERE `name` = 'rocket' ORDER BY `name` ASC LIMIT 0, 10
0.002s: SELECT ID_PAGE, ID_PARENT, type, url, menu_title, show_menu FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND publish_from <= 1776427351 AND publish_from > 0 AND (publish_until >= 1776427351 OR publish_until = 0) AND removed = 0 ORDER BY depth, `order` ASC
0.001s: SELECT SQL_CALC_FOUND_ROWS p.ID_PAGE, p.ID_SITE, p.ID_USER, p.ID_PARENT, p.show_menu, p.order, p.depth, p.has_children, p.type, p.url, p.menu_title, p.page_title, p.meta_keywords, p.meta_description, p.publish_from, p.publish_until, p.last_modified, p.removed FROM `perfacilis_test`.`cms_pages` p WHERE p.ID_SITE = 1 AND p.url = 'blog/systeembeheer/linux/' AND p.removed = 0 ORDER BY p.depth ASC, p.order ASC LIMIT 0, 1
0.000s: SELECT FOUND_ROWS();
0.000s: SELECT ID_PARENT FROM `perfacilis_test`.`cms_pages` WHERE ID_PAGE = 2547
0.000s: SELECT ID_PARENT FROM `perfacilis_test`.`cms_pages` WHERE ID_PAGE = 2546
0.000s: SELECT ID_PARENT FROM `perfacilis_test`.`cms_pages` WHERE ID_PAGE = 1389
0.000s: SELECT l.ID_PAGE_FROM, l.ID_PAGE_TO, IF(l.ID_PAGE_TO, p.url, l.url) as url_to, IF(l.url = '', 1, 0) as intern, l.type FROM `perfacilis_test`.`cms_links` l LEFT JOIN `perfacilis_test`.`cms_pages` p ON p.ID_PAGE = l.ID_PAGE_TO WHERE l.ID_PAGE_FROM = 1403
0.000s: SELECT l.ID_PAGE_FROM, l.ID_PAGE_TO, IF(l.ID_PAGE_TO, p.url, l.url) as url_to, IF(l.url = '', 1, 0) as intern, l.type FROM `perfacilis_test`.`cms_links` l LEFT JOIN `perfacilis_test`.`cms_pages` p ON p.ID_PAGE = l.ID_PAGE_TO WHERE l.ID_PAGE_FROM = 2760
0.000s: SELECT l.ID_PAGE_FROM, l.ID_PAGE_TO, IF(l.ID_PAGE_TO, p.url, l.url) as url_to, IF(l.url = '', 1, 0) as intern, l.type FROM `perfacilis_test`.`cms_links` l LEFT JOIN `perfacilis_test`.`cms_pages` p ON p.ID_PAGE = l.ID_PAGE_TO WHERE l.ID_PAGE_FROM = 2759
0.000s: SELECT l.ID_PAGE_FROM, l.ID_PAGE_TO, IF(l.ID_PAGE_TO, p.url, l.url) as url_to, IF(l.url = '', 1, 0) as intern, l.type FROM `perfacilis_test`.`cms_links` l LEFT JOIN `perfacilis_test`.`cms_pages` p ON p.ID_PAGE = l.ID_PAGE_TO WHERE l.ID_PAGE_FROM = 2761
0.000s: SELECT l.ID_PAGE_FROM, l.ID_PAGE_TO, IF(l.ID_PAGE_TO, p.url, l.url) as url_to, IF(l.url = '', 1, 0) as intern, l.type FROM `perfacilis_test`.`cms_links` l LEFT JOIN `perfacilis_test`.`cms_pages` p ON p.ID_PAGE = l.ID_PAGE_TO WHERE l.ID_PAGE_FROM = 2762
0.000s: SELECT l.ID_PAGE_FROM, l.ID_PAGE_TO, IF(l.ID_PAGE_TO, p.url, l.url) as url_to, IF(l.url = '', 1, 0) as intern, l.type FROM `perfacilis_test`.`cms_links` l LEFT JOIN `perfacilis_test`.`cms_pages` p ON p.ID_PAGE = l.ID_PAGE_TO WHERE l.ID_PAGE_FROM = 2768
0.000s: SELECT l.ID_PAGE_FROM, l.ID_PAGE_TO, IF(l.ID_PAGE_TO, p.url, l.url) as url_to, IF(l.url = '', 1, 0) as intern, l.type FROM `perfacilis_test`.`cms_links` l LEFT JOIN `perfacilis_test`.`cms_pages` p ON p.ID_PAGE = l.ID_PAGE_TO WHERE l.ID_PAGE_FROM = 2769
0.000s: SELECT l.ID_PAGE_FROM, l.ID_PAGE_TO, IF(l.ID_PAGE_TO, p.url, l.url) as url_to, IF(l.url = '', 1, 0) as intern, l.type FROM `perfacilis_test`.`cms_links` l LEFT JOIN `perfacilis_test`.`cms_pages` p ON p.ID_PAGE = l.ID_PAGE_TO WHERE l.ID_PAGE_FROM = 2770
0.000s: SELECT l.ID_PAGE_FROM, l.ID_PAGE_TO, IF(l.ID_PAGE_TO, p.url, l.url) as url_to, IF(l.url = '', 1, 0) as intern, l.type FROM `perfacilis_test`.`cms_links` l LEFT JOIN `perfacilis_test`.`cms_pages` p ON p.ID_PAGE = l.ID_PAGE_TO WHERE l.ID_PAGE_FROM = 2771
0.000s: SELECT l.ID_PAGE_FROM, l.ID_PAGE_TO, IF(l.ID_PAGE_TO, p.url, l.url) as url_to, IF(l.url = '', 1, 0) as intern, l.type FROM `perfacilis_test`.`cms_links` l LEFT JOIN `perfacilis_test`.`cms_pages` p ON p.ID_PAGE = l.ID_PAGE_TO WHERE l.ID_PAGE_FROM = 2764
0.001s: SELECT ID_PAGE FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND url = 'blog/systeembeheer/linux/' AND removed = 0
0.001s: SELECT SQL_CALC_FOUND_ROWS p.ID_PAGE, p.ID_SITE, p.ID_USER, p.ID_PARENT, p.show_menu, p.order, p.depth, p.has_children, p.type, p.url, p.menu_title, p.page_title, p.meta_keywords, p.meta_description, p.publish_from, p.publish_until, p.last_modified, p.removed, p.page_content FROM `perfacilis_test`.`cms_pages` p WHERE p.ID_PAGE IN( 2547 ) ORDER BY p.depth ASC, p.order ASC LIMIT 0, 10
0.000s: SELECT FOUND_ROWS();
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_pages' AND `id` = 2547 AND `setting` = 'show-breadcrumb'
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_pages' AND `id` = 2547 AND `setting` = 'page-class'
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_pages' AND `id` = 2547 AND `setting` = 'header-scripts'
0.001s: SELECT s.ID_SITE, s.ID_COMPANY, s.domainname, s.title, s.theme FROM `perfacilis_test`.`cms_sites` s INNER JOIN `perfacilis_test`.`cms_pages` p ON p.ID_SITE = s.ID_SITE WHERE p.ID_PAGE = 2547
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2547
0.001s: SELECT SQL_CALC_FOUND_ROWS n.ID_PAGE, n.ID_MEDIA_THUMBNAIL, n.introduction, p.ID_PARENT, p.url, p.menu_title FROM `perfacilis_test`.`cms_blogposts` n INNER JOIN `perfacilis_test`.`cms_pages` p ON p.ID_PAGE = n.ID_PAGE WHERE n.ID_PAGE IN( 2548, 2563, 2582, 2588, 2598, 2600, 2602, 2625, 2626, 2629, 2630, 2631, 2638, 2636, 2646, 2650, 2660, 2659, 2664, 2668, 2672, 2673, 2674, 2678, 2679, 2709, 2712, 2723, 2726, 2730, 2735, 2755, 2743, 2745, 2747, 2754, 2772 ) AND p.publish_from <= 1776427351 AND (p.publish_until = 0 OR p.publish_until > 1776427351) AND p.removed = 0 ORDER BY p.publish_from DESC LIMIT 20, 10
0.000s: SELECT FOUND_ROWS();
0.001s: SELECT `id_media`, `id_dir`, `id_company`, `id_user`, `name`, `path`, `size`, `mime`, `created`, `removed` FROM `perfacilis_test`.cms_media WHERE `id_media` = 467 ORDER BY `id_media` ASC LIMIT 0, 10
0.001s: SELECT `id_page`, `id_site`, `id_user`, `id_parent`, `show_menu`, `order`, `depth`, `has_children`, `type`, `url`, `menu_title`, `page_title`, `page_content`, `meta_keywords`, `meta_description`, `publish_from`, `publish_until`, `last_modified`, `removed` FROM `perfacilis_test`.cms_pages WHERE `id_page` = 2602 ORDER BY `id_page` ASC LIMIT 0, 1
0.001s: SELECT COUNT( 1 ) FROM `perfacilis_test`.cms_pages WHERE `id_page` = 2602
0.000s: SELECT `id_media`, `id_dir`, `id_company`, `id_user`, `name`, `path`, `size`, `mime`, `created`, `removed` FROM `perfacilis_test`.cms_media WHERE `id_media` = 453 ORDER BY `id_media` ASC LIMIT 0, 10
0.000s: SELECT `id_page`, `id_site`, `id_user`, `id_parent`, `show_menu`, `order`, `depth`, `has_children`, `type`, `url`, `menu_title`, `page_title`, `page_content`, `meta_keywords`, `meta_description`, `publish_from`, `publish_until`, `last_modified`, `removed` FROM `perfacilis_test`.cms_pages WHERE `id_page` = 2563 ORDER BY `id_page` ASC LIMIT 0, 1
0.000s: SELECT COUNT( 1 ) FROM `perfacilis_test`.cms_pages WHERE `id_page` = 2563
0.000s: SELECT `name`, `parent`, `scss`, `modified_at`, `modified_by` FROM `perfacilis_test`.theme WHERE `name` = 'rocket' ORDER BY `name` ASC LIMIT 0, 10
0.000s: SELECT ID_BLOCK FROM `perfacilis_test`.`cms_blocks` WHERE ID_SITE = 1 AND identifier = 'footer'
0.000s: SELECT ID_BLOCK, ID_SITE, identifier, name, content FROM `perfacilis_test`.`cms_blocks` WHERE ID_BLOCK = 9
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2704
0.001s: SELECT SQL_CALC_FOUND_ROWS p.ID_PAGE, p.ID_SITE, p.ID_USER, p.ID_PARENT, p.show_menu, p.order, p.depth, p.has_children, p.type, p.url, p.menu_title, p.page_title, p.meta_keywords, p.meta_description, p.publish_from, p.publish_until, p.last_modified, p.removed FROM `perfacilis_test`.`cms_pages` p WHERE p.ID_PAGE IN( 2705, 2706, 2713, 2714, 2716, 2753 ) AND p.removed = 0 AND p.publish_from < 1776427351 AND (p.publish_until = 0 OR p.publish_until > 1776427351) ORDER BY p.depth ASC, p.order ASC
0.000s: SELECT FOUND_ROWS();
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 1376
0.001s: SELECT SQL_CALC_FOUND_ROWS p.ID_PAGE, p.ID_SITE, p.ID_USER, p.ID_PARENT, p.show_menu, p.order, p.depth, p.has_children, p.type, p.url, p.menu_title, p.page_title, p.meta_keywords, p.meta_description, p.publish_from, p.publish_until, p.last_modified, p.removed FROM `perfacilis_test`.`cms_pages` p WHERE p.ID_PAGE IN( 2539, 2541, 2543, 2553, 2557, 2589, 2592, 2601, 2653, 2654, 2684, 2696, 2742 ) AND p.removed = 0 AND p.publish_from < 1776427351 AND (p.publish_until = 0 OR p.publish_until > 1776427351) ORDER BY p.publish_from DESC LIMIT 0, 6
0.001s: SELECT FOUND_ROWS();
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 0
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2515
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 1389
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2516
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2534
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2535
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2536
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2537
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2518
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2519
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2549
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2657
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2521
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2517
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2520
0.001s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2538
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2540
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2577
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2546
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2547
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2554
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2641
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2681
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2715
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2661
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2721
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 1404
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 1376
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2604
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2746
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2704
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2736
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2758
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2760
0.001s: SELECT SQL_CALC_FOUND_ROWS p.ID_PAGE, p.ID_SITE, p.ID_USER, p.ID_PARENT, p.show_menu, p.order, p.depth, p.has_children, p.type, p.url, p.menu_title, p.page_title, p.meta_keywords, p.meta_description, p.publish_from, p.publish_until, p.last_modified, p.removed FROM `perfacilis_test`.`cms_pages` p WHERE p.ID_PAGE IN( 2516, 2534, 2535, 2536, 2537, 2518, 2519, 2549, 2550, 2647, 2657, 2521, 2517, 2520, 2538, 2540, 2577, 2546, 2547, 2554, 2641, 2681, 2715, 2661, 2721, 2689 ) AND p.removed = 0 AND p.publish_from < 1776427351 AND (p.publish_until = 0 OR p.publish_until > 1776427351) ORDER BY p.depth ASC, p.order ASC
0.000s: SELECT FOUND_ROWS();
0.000s: SELECT SQL_CALC_FOUND_ROWS s.ID_SITE, s.ID_COMPANY, s.domainname, s.title, s.theme, s.is_primary, s.mode, s.created_time, s.created_by, s.deleted_time, s.deleted_by, c.name FROM `perfacilis_test`.`cms_sites` s INNER JOIN `perfacilis_test`.`contacts_companies` c ON c.ID_COMPANY = s.ID_COMPANY WHERE s.deleted_time = 0 AND s.domainname = 'perfacilis.com' ORDER BY s.domainname ASC
0.000s: SELECT FOUND_ROWS();
0.000s: SELECT SQL_CALC_FOUND_ROWS s.ID_SITE, s.ID_COMPANY, s.domainname, s.title, s.theme, s.is_primary, s.mode, s.created_time, s.created_by, s.deleted_time, s.deleted_by, c.name FROM `perfacilis_test`.`cms_sites` s INNER JOIN `perfacilis_test`.`contacts_companies` c ON c.ID_COMPANY = s.ID_COMPANY WHERE s.deleted_time = 0 ORDER BY s.domainname ASC
0.000s: SELECT FOUND_ROWS();
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'ga-tracking-id'
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'g-ads-tag-id'
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'g-site-vertification'
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'banner-width'
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'banner-height'
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'fb-app-id'
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'fb-admins'
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'twitter-site'
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'twitter-creator'
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'pinterest-verify'
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'header-scripts'
0.000s: SELECT `name`, `parent`, `scss`, `modified_at`, `modified_by` FROM `perfacilis_test`.theme WHERE `name` = 'rocket' ORDER BY `name` ASC LIMIT 0, 10
0.002s: SELECT ID_PAGE, ID_PARENT, type, url, menu_title, show_menu FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND publish_from <= 1776427351 AND publish_from > 0 AND (publish_until >= 1776427351 OR publish_until = 0) AND removed = 0 ORDER BY depth, `order` ASC
0.001s: SELECT SQL_CALC_FOUND_ROWS p.ID_PAGE, p.ID_SITE, p.ID_USER, p.ID_PARENT, p.show_menu, p.order, p.depth, p.has_children, p.type, p.url, p.menu_title, p.page_title, p.meta_keywords, p.meta_description, p.publish_from, p.publish_until, p.last_modified, p.removed FROM `perfacilis_test`.`cms_pages` p WHERE p.ID_SITE = 1 AND p.url = 'blog/systeembeheer/linux/' AND p.removed = 0 ORDER BY p.depth ASC, p.order ASC LIMIT 0, 1
0.000s: SELECT FOUND_ROWS();
0.000s: SELECT ID_PARENT FROM `perfacilis_test`.`cms_pages` WHERE ID_PAGE = 2547
0.000s: SELECT ID_PARENT FROM `perfacilis_test`.`cms_pages` WHERE ID_PAGE = 2546
0.000s: SELECT ID_PARENT FROM `perfacilis_test`.`cms_pages` WHERE ID_PAGE = 1389
0.000s: SELECT l.ID_PAGE_FROM, l.ID_PAGE_TO, IF(l.ID_PAGE_TO, p.url, l.url) as url_to, IF(l.url = '', 1, 0) as intern, l.type FROM `perfacilis_test`.`cms_links` l LEFT JOIN `perfacilis_test`.`cms_pages` p ON p.ID_PAGE = l.ID_PAGE_TO WHERE l.ID_PAGE_FROM = 1403
0.000s: SELECT l.ID_PAGE_FROM, l.ID_PAGE_TO, IF(l.ID_PAGE_TO, p.url, l.url) as url_to, IF(l.url = '', 1, 0) as intern, l.type FROM `perfacilis_test`.`cms_links` l LEFT JOIN `perfacilis_test`.`cms_pages` p ON p.ID_PAGE = l.ID_PAGE_TO WHERE l.ID_PAGE_FROM = 2760
0.000s: SELECT l.ID_PAGE_FROM, l.ID_PAGE_TO, IF(l.ID_PAGE_TO, p.url, l.url) as url_to, IF(l.url = '', 1, 0) as intern, l.type FROM `perfacilis_test`.`cms_links` l LEFT JOIN `perfacilis_test`.`cms_pages` p ON p.ID_PAGE = l.ID_PAGE_TO WHERE l.ID_PAGE_FROM = 2759
0.000s: SELECT l.ID_PAGE_FROM, l.ID_PAGE_TO, IF(l.ID_PAGE_TO, p.url, l.url) as url_to, IF(l.url = '', 1, 0) as intern, l.type FROM `perfacilis_test`.`cms_links` l LEFT JOIN `perfacilis_test`.`cms_pages` p ON p.ID_PAGE = l.ID_PAGE_TO WHERE l.ID_PAGE_FROM = 2761
0.000s: SELECT l.ID_PAGE_FROM, l.ID_PAGE_TO, IF(l.ID_PAGE_TO, p.url, l.url) as url_to, IF(l.url = '', 1, 0) as intern, l.type FROM `perfacilis_test`.`cms_links` l LEFT JOIN `perfacilis_test`.`cms_pages` p ON p.ID_PAGE = l.ID_PAGE_TO WHERE l.ID_PAGE_FROM = 2762
0.000s: SELECT l.ID_PAGE_FROM, l.ID_PAGE_TO, IF(l.ID_PAGE_TO, p.url, l.url) as url_to, IF(l.url = '', 1, 0) as intern, l.type FROM `perfacilis_test`.`cms_links` l LEFT JOIN `perfacilis_test`.`cms_pages` p ON p.ID_PAGE = l.ID_PAGE_TO WHERE l.ID_PAGE_FROM = 2768
0.000s: SELECT l.ID_PAGE_FROM, l.ID_PAGE_TO, IF(l.ID_PAGE_TO, p.url, l.url) as url_to, IF(l.url = '', 1, 0) as intern, l.type FROM `perfacilis_test`.`cms_links` l LEFT JOIN `perfacilis_test`.`cms_pages` p ON p.ID_PAGE = l.ID_PAGE_TO WHERE l.ID_PAGE_FROM = 2769
0.000s: SELECT l.ID_PAGE_FROM, l.ID_PAGE_TO, IF(l.ID_PAGE_TO, p.url, l.url) as url_to, IF(l.url = '', 1, 0) as intern, l.type FROM `perfacilis_test`.`cms_links` l LEFT JOIN `perfacilis_test`.`cms_pages` p ON p.ID_PAGE = l.ID_PAGE_TO WHERE l.ID_PAGE_FROM = 2770
0.000s: SELECT l.ID_PAGE_FROM, l.ID_PAGE_TO, IF(l.ID_PAGE_TO, p.url, l.url) as url_to, IF(l.url = '', 1, 0) as intern, l.type FROM `perfacilis_test`.`cms_links` l LEFT JOIN `perfacilis_test`.`cms_pages` p ON p.ID_PAGE = l.ID_PAGE_TO WHERE l.ID_PAGE_FROM = 2771
0.000s: SELECT l.ID_PAGE_FROM, l.ID_PAGE_TO, IF(l.ID_PAGE_TO, p.url, l.url) as url_to, IF(l.url = '', 1, 0) as intern, l.type FROM `perfacilis_test`.`cms_links` l LEFT JOIN `perfacilis_test`.`cms_pages` p ON p.ID_PAGE = l.ID_PAGE_TO WHERE l.ID_PAGE_FROM = 2764
0.001s: SELECT ID_PAGE FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND url = 'blog/systeembeheer/linux/' AND removed = 0
0.001s: SELECT SQL_CALC_FOUND_ROWS p.ID_PAGE, p.ID_SITE, p.ID_USER, p.ID_PARENT, p.show_menu, p.order, p.depth, p.has_children, p.type, p.url, p.menu_title, p.page_title, p.meta_keywords, p.meta_description, p.publish_from, p.publish_until, p.last_modified, p.removed, p.page_content FROM `perfacilis_test`.`cms_pages` p WHERE p.ID_PAGE IN( 2547 ) ORDER BY p.depth ASC, p.order ASC LIMIT 0, 10
0.000s: SELECT FOUND_ROWS();
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_pages' AND `id` = 2547 AND `setting` = 'show-breadcrumb'
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_pages' AND `id` = 2547 AND `setting` = 'page-class'
0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_pages' AND `id` = 2547 AND `setting` = 'header-scripts'
0.001s: SELECT s.ID_SITE, s.ID_COMPANY, s.domainname, s.title, s.theme FROM `perfacilis_test`.`cms_sites` s INNER JOIN `perfacilis_test`.`cms_pages` p ON p.ID_SITE = s.ID_SITE WHERE p.ID_PAGE = 2547
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2547
0.001s: SELECT SQL_CALC_FOUND_ROWS n.ID_PAGE, n.ID_MEDIA_THUMBNAIL, n.introduction, p.ID_PARENT, p.url, p.menu_title FROM `perfacilis_test`.`cms_blogposts` n INNER JOIN `perfacilis_test`.`cms_pages` p ON p.ID_PAGE = n.ID_PAGE WHERE n.ID_PAGE IN( 2548, 2563, 2582, 2588, 2598, 2600, 2602, 2625, 2626, 2629, 2630, 2631, 2638, 2636, 2646, 2650, 2660, 2659, 2664, 2668, 2672, 2673, 2674, 2678, 2679, 2709, 2712, 2723, 2726, 2730, 2735, 2755, 2743, 2745, 2747, 2754, 2772 ) AND p.publish_from <= 1776427351 AND (p.publish_until = 0 OR p.publish_until > 1776427351) AND p.removed = 0 ORDER BY p.publish_from DESC LIMIT 20, 10
0.000s: SELECT FOUND_ROWS();
0.001s: SELECT `id_media`, `id_dir`, `id_company`, `id_user`, `name`, `path`, `size`, `mime`, `created`, `removed` FROM `perfacilis_test`.cms_media WHERE `id_media` = 467 ORDER BY `id_media` ASC LIMIT 0, 10
0.001s: SELECT `id_page`, `id_site`, `id_user`, `id_parent`, `show_menu`, `order`, `depth`, `has_children`, `type`, `url`, `menu_title`, `page_title`, `page_content`, `meta_keywords`, `meta_description`, `publish_from`, `publish_until`, `last_modified`, `removed` FROM `perfacilis_test`.cms_pages WHERE `id_page` = 2602 ORDER BY `id_page` ASC LIMIT 0, 1
0.001s: SELECT COUNT( 1 ) FROM `perfacilis_test`.cms_pages WHERE `id_page` = 2602
0.000s: SELECT `id_media`, `id_dir`, `id_company`, `id_user`, `name`, `path`, `size`, `mime`, `created`, `removed` FROM `perfacilis_test`.cms_media WHERE `id_media` = 453 ORDER BY `id_media` ASC LIMIT 0, 10
0.000s: SELECT `id_page`, `id_site`, `id_user`, `id_parent`, `show_menu`, `order`, `depth`, `has_children`, `type`, `url`, `menu_title`, `page_title`, `page_content`, `meta_keywords`, `meta_description`, `publish_from`, `publish_until`, `last_modified`, `removed` FROM `perfacilis_test`.cms_pages WHERE `id_page` = 2563 ORDER BY `id_page` ASC LIMIT 0, 1
0.000s: SELECT COUNT( 1 ) FROM `perfacilis_test`.cms_pages WHERE `id_page` = 2563
0.000s: SELECT `name`, `parent`, `scss`, `modified_at`, `modified_by` FROM `perfacilis_test`.theme WHERE `name` = 'rocket' ORDER BY `name` ASC LIMIT 0, 10
0.000s: SELECT ID_BLOCK FROM `perfacilis_test`.`cms_blocks` WHERE ID_SITE = 1 AND identifier = 'footer'
0.000s: SELECT ID_BLOCK, ID_SITE, identifier, name, content FROM `perfacilis_test`.`cms_blocks` WHERE ID_BLOCK = 9
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2704
0.001s: SELECT SQL_CALC_FOUND_ROWS p.ID_PAGE, p.ID_SITE, p.ID_USER, p.ID_PARENT, p.show_menu, p.order, p.depth, p.has_children, p.type, p.url, p.menu_title, p.page_title, p.meta_keywords, p.meta_description, p.publish_from, p.publish_until, p.last_modified, p.removed FROM `perfacilis_test`.`cms_pages` p WHERE p.ID_PAGE IN( 2705, 2706, 2713, 2714, 2716, 2753 ) AND p.removed = 0 AND p.publish_from < 1776427351 AND (p.publish_until = 0 OR p.publish_until > 1776427351) ORDER BY p.depth ASC, p.order ASC
0.000s: SELECT FOUND_ROWS();
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 1376
0.001s: SELECT SQL_CALC_FOUND_ROWS p.ID_PAGE, p.ID_SITE, p.ID_USER, p.ID_PARENT, p.show_menu, p.order, p.depth, p.has_children, p.type, p.url, p.menu_title, p.page_title, p.meta_keywords, p.meta_description, p.publish_from, p.publish_until, p.last_modified, p.removed FROM `perfacilis_test`.`cms_pages` p WHERE p.ID_PAGE IN( 2539, 2541, 2543, 2553, 2557, 2589, 2592, 2601, 2653, 2654, 2684, 2696, 2742 ) AND p.removed = 0 AND p.publish_from < 1776427351 AND (p.publish_until = 0 OR p.publish_until > 1776427351) ORDER BY p.publish_from DESC LIMIT 0, 6
0.001s: SELECT FOUND_ROWS();
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 0
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2515
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 1389
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2516
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2534
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2535
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2536
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2537
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2518
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2519
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2549
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2657
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2521
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2517
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2520
0.001s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2538
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2540
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2577
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2546
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2547
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2554
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2641
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2681
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2715
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2661
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2721
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 1404
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 1376
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2604
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2746
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2704
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2736
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2758
0.000s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2760
0.001s: SELECT SQL_CALC_FOUND_ROWS p.ID_PAGE, p.ID_SITE, p.ID_USER, p.ID_PARENT, p.show_menu, p.order, p.depth, p.has_children, p.type, p.url, p.menu_title, p.page_title, p.meta_keywords, p.meta_description, p.publish_from, p.publish_until, p.last_modified, p.removed FROM `perfacilis_test`.`cms_pages` p WHERE p.ID_PAGE IN( 2516, 2534, 2535, 2536, 2537, 2518, 2519, 2549, 2550, 2647, 2657, 2521, 2517, 2520, 2538, 2540, 2577, 2546, 2547, 2554, 2641, 2681, 2715, 2661, 2721, 2689 ) AND p.removed = 0 AND p.publish_from < 1776427351 AND (p.publish_until = 0 OR p.publish_until > 1776427351) ORDER BY p.depth ASC, p.order ASC
0.000s: SELECT FOUND_ROWS();

n/a