Plesk forwarders toevoegen en verwijderen op vooraf ingestelde datums

  •  

De zomervakantie staat voor de deur, collega's hebben hun vakanties gepland en jij krijgt als systeembeheerder de taak te zorgen dat e-mails gedurende hun afwezigheid niet meer worden doorgestuurd.

De Plesk Mail Utitlity

Via de Mail Utitlity van Plesk kun je via de command-line forwarding adressen toevoegen en verwijderen van een e-mailontvanger. In onderstaand voorbeeld verwijderen we jan@voorbeeldbedrijf.nl uit support@voorbeeldbedrijf.nl:

/usr/local/psa/bin/mail -u support@voorbeeldbedrijf.nl -forwarding true -forwarding-addresses del:jan@voorbeeldbedrijf.nl

Wanneer we Jan weer toe willen voegen aan de Support-box, voegen vervangen we de del-prefix voor een add-prefix:

/usr/local/psa/bin/mail -u support@voorbeeldbedrijf.nl -forwarding true -forwarding-addresses add:jan@voorbeeldbedrijf.nl

Hiermee wordt de gebruiker echter direct uit de lijst met forwarders verwijderd. Handig, maar hier wil je als systeembeheerder natuurlijk niet speciaal extra vroeg je bed uit hoeven komen.

Opdrachten inplannen via at

Om de opdrachten in te plannen maken we gebruik van het at command. Via dit programma kun je een taak eenmalig laten uitvoeren op een gegeven datum. Ondanks dat er een breed bereik van datum en tijd formats geaccepteerd wordt, maken we hier gebruik van een nauwkeurige datum en tijd format. Wanneer jan bijvoorbeeld op 1 juni voor 3 weken op vakantie zou zijn (dus t/m de 21e), kan dit als volgt worden ingepland:

echo "/usr/local/psa/bin/mail -u support@voorbeeldbedrijf.nl -forwarding true -forwarding-addresses del:jan@voorbeeldbedrijf.nl" | at 0:00 2017-06-01
echo "/usr/local/psa/bin/mail -u support@voorbeeldbedrijf.nl -forwarding true -forwarding-addresses add:jan@voorbeeldbedrijf.nl" | at 0:00 2016-06-21

De taken tussen de aanhalingstekens van echo worden nu aan het at-commando gevoerd en voor gegeven datum ingepland. De opdracht zal warning: commands will be executed using /bin/sh teruggeven, gevolgd door de ID van de job, inclusief exacte datum en tijd van uitvoeren als: job 1 at Tue Jun 1 00:00:00 2017. De waarschuwing is hierbij normaal.

Geplande opdrachten bekijken met atq

Om vervolgens de geplande taken in te zien, kan er gebruik gemaakt worden van het atq-commando. Deze zal een lijst retourneren met de ID van de taak, gevolgd door een datum en tijd waarom dat deze taak is gepland. Om vervolgens de inhoud van een specifieke taak in te zien (m.a.w. om erachter te komen wat er nu precies gebeurt, gebruik je opnieuw het at-commando. Wanneer je de inhoud van de taak met ID 1 wilt zien kan dit als volgt:

at -c 1

Geplande opdrachten in een overzicht

Omdat bovenstaand proces geen simpel overzicht van de taken geeft, hebben we een simpel bash script gemaakt waarmee in een overzicht alle taken, chronologisch gesorteerd worden getoond. Kopieer de inhoud van onderstaand kader naar een nieuw bestand en sla dit bijvoorbeeld op als show-atq.sh.

#!/bin/bash
# Title: Print readable list of queued tasks
# Description: Get a simple and readable overview of queued tasks using the atq and
# at -c commands.
# Author: Roy Arisse <support@perfacilis.com>
# See: https://www.perfacilis.com/blog/systeembeheer/linux/forwarders-automatisch-aanpassen-in-plesk.html
# Version: 0.1
# Usage: bash show-atq.sh

LASTJOB=""
atq | sort -k 6n -k 3M -k 4n -k 5 -k 7 -k 1 | while IFS= read -r JOB; do
JOBID=$(echo $JOB | cut -d' ' -f1)
JOBDATE=$(echo $JOB | cut -d' ' -f2-)
JOBCMD=$(at -c $JOBID | tail -n2)

if [ "$JOBDATE" != "$LASTJOB" ]; then
echo
echo $JOBDATE
fi

echo " $JOBID. $JOBCMD"
LASTJOB="$JOBDATE"

done
echo

Vervolgens kun je met bash show-atq.sh jouw vakantieplanning bekijken.

0.1
633.73kb
688.44kb
0.080s
  • 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
  • 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.001s: SELECT FOUND_ROWS();
  • 0.001s: 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.001s: 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.001s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'g-ads-tag-id'
  • 0.001s: 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.001s: 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.001s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'fb-admins'
  • 0.001s: 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.001s: 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.002s: SELECT `name`, `parent`, `scss`, `modified_at`, `modified_by` FROM `perfacilis_test`.theme WHERE `name` = 'rocket' ORDER BY `name` ASC LIMIT 0, 10
  • 0.003s: SELECT ID_PAGE, ID_PARENT, type, url, menu_title, show_menu FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND publish_from <= 1776432606 AND publish_from > 0 AND (publish_until >= 1776432606 OR publish_until = 0) AND removed = 0 ORDER BY depth, `order` ASC
  • 0.002s: 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/forwarders-automatisch-aanpassen-in-plesk.html' AND p.removed = 0 ORDER BY p.depth ASC, p.order ASC LIMIT 0, 1
  • 0.001s: SELECT FOUND_ROWS();
  • 0.001s: SELECT ID_PARENT FROM `perfacilis_test`.`cms_pages` WHERE ID_PAGE = 2679
  • 0.001s: 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.001s: SELECT ID_PARENT FROM `perfacilis_test`.`cms_pages` WHERE ID_PAGE = 1389
  • 0.002s: 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.001s: 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.001s: 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.001s: 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.001s: 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.002s: 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.002s: SELECT ID_PAGE FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND url = 'blog/systeembeheer/linux/forwarders-automatisch-aanpassen-in-plesk.html' 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( 2679 ) ORDER BY p.depth ASC, p.order ASC LIMIT 0, 10
  • 0.001s: SELECT FOUND_ROWS();
  • 0.001s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_pages' AND `id` = 2679 AND `setting` = 'show-breadcrumb'
  • 0.001s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_pages' AND `id` = 2679 AND `setting` = 'page-class'
  • 0.001s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_pages' AND `id` = 2679 AND `setting` = 'header-scripts'
  • 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( 2547 ) AND p.type = 'blogcategory' AND p.removed = 0 ORDER BY p.depth ASC, p.order ASC LIMIT 0, 10
  • 0.001s: SELECT FOUND_ROWS();
  • 0.001s: SELECT u.ID_USER, p.ID_COMPANY, u.emailaddress as username, p.email, p.name, u.created, u.activation_key, u.deleted FROM `perfacilis_test`.`core_users` u INNER JOIN `perfacilis_test`.`contacts_persons` as p ON p.ID_PERSON = u.ID_USER WHERE u.ID_USER = 1 AND deleted = 0
  • 0.001s: SELECT ID_GROUP FROM `perfacilis_test`.`core_users_groups` WHERE ID_USER = 1 AND (time_until = -1 OR time_until >= 1776432606)
  • 0.001s: SELECT ID_GROUP, module, action FROM `perfacilis_test`.`core_groups_permissions` WHERE ID_GROUP IN( 1 )
  • 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( 2679 ) AND p.removed = 0 ORDER BY p.order ASC LIMIT 0, 10
  • 0.001s: 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` = 577 ORDER BY `id_media` ASC LIMIT 0, 10
  • 0.001s: SELECT `name`, `parent`, `scss`, `modified_at`, `modified_by` FROM `perfacilis_test`.theme WHERE `name` = 'rocket' ORDER BY `name` ASC LIMIT 0, 10
  • 0.001s: 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.001s: 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 < 1776432606 AND (p.publish_until = 0 OR p.publish_until > 1776432606) ORDER BY p.depth ASC, p.order ASC
  • 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 = 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 < 1776432606 AND (p.publish_until = 0 OR p.publish_until > 1776432606) ORDER BY p.publish_from DESC LIMIT 0, 6
  • 0.000s: SELECT FOUND_ROWS();
  • 0.001s: 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.001s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2534
  • 0.001s: 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.001s: 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.001s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2549
  • 0.001s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2657
  • 0.001s: 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.000s: 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.001s: 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.001s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2641
  • 0.001s: 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.001s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2661
  • 0.001s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2721
  • 0.001s: 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.001s: 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.001s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2758
  • 0.001s: 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 < 1776432606 AND (p.publish_until = 0 OR p.publish_until > 1776432606) ORDER BY p.depth ASC, p.order ASC
  • 0.001s: 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.001s: SELECT FOUND_ROWS();
  • 0.001s: 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.001s: 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.001s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'g-ads-tag-id'
  • 0.001s: 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.001s: 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.001s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'fb-admins'
  • 0.001s: 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.001s: 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.002s: SELECT `name`, `parent`, `scss`, `modified_at`, `modified_by` FROM `perfacilis_test`.theme WHERE `name` = 'rocket' ORDER BY `name` ASC LIMIT 0, 10
  • 0.003s: SELECT ID_PAGE, ID_PARENT, type, url, menu_title, show_menu FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND publish_from <= 1776432606 AND publish_from > 0 AND (publish_until >= 1776432606 OR publish_until = 0) AND removed = 0 ORDER BY depth, `order` ASC
  • 0.002s: 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/forwarders-automatisch-aanpassen-in-plesk.html' AND p.removed = 0 ORDER BY p.depth ASC, p.order ASC LIMIT 0, 1
  • 0.001s: SELECT FOUND_ROWS();
  • 0.001s: SELECT ID_PARENT FROM `perfacilis_test`.`cms_pages` WHERE ID_PAGE = 2679
  • 0.001s: 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.001s: SELECT ID_PARENT FROM `perfacilis_test`.`cms_pages` WHERE ID_PAGE = 1389
  • 0.002s: 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.001s: 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.001s: 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.001s: 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.001s: 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.002s: 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.002s: SELECT ID_PAGE FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND url = 'blog/systeembeheer/linux/forwarders-automatisch-aanpassen-in-plesk.html' 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( 2679 ) ORDER BY p.depth ASC, p.order ASC LIMIT 0, 10
  • 0.001s: SELECT FOUND_ROWS();
  • 0.001s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_pages' AND `id` = 2679 AND `setting` = 'show-breadcrumb'
  • 0.001s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_pages' AND `id` = 2679 AND `setting` = 'page-class'
  • 0.001s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_pages' AND `id` = 2679 AND `setting` = 'header-scripts'
  • 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( 2547 ) AND p.type = 'blogcategory' AND p.removed = 0 ORDER BY p.depth ASC, p.order ASC LIMIT 0, 10
  • 0.001s: SELECT FOUND_ROWS();
  • 0.001s: SELECT u.ID_USER, p.ID_COMPANY, u.emailaddress as username, p.email, p.name, u.created, u.activation_key, u.deleted FROM `perfacilis_test`.`core_users` u INNER JOIN `perfacilis_test`.`contacts_persons` as p ON p.ID_PERSON = u.ID_USER WHERE u.ID_USER = 1 AND deleted = 0
  • 0.001s: SELECT ID_GROUP FROM `perfacilis_test`.`core_users_groups` WHERE ID_USER = 1 AND (time_until = -1 OR time_until >= 1776432606)
  • 0.001s: SELECT ID_GROUP, module, action FROM `perfacilis_test`.`core_groups_permissions` WHERE ID_GROUP IN( 1 )
  • 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( 2679 ) AND p.removed = 0 ORDER BY p.order ASC LIMIT 0, 10
  • 0.001s: 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` = 577 ORDER BY `id_media` ASC LIMIT 0, 10
  • 0.001s: SELECT `name`, `parent`, `scss`, `modified_at`, `modified_by` FROM `perfacilis_test`.theme WHERE `name` = 'rocket' ORDER BY `name` ASC LIMIT 0, 10
  • 0.001s: 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.001s: 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 < 1776432606 AND (p.publish_until = 0 OR p.publish_until > 1776432606) ORDER BY p.depth ASC, p.order ASC
  • 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 = 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 < 1776432606 AND (p.publish_until = 0 OR p.publish_until > 1776432606) ORDER BY p.publish_from DESC LIMIT 0, 6
  • 0.000s: SELECT FOUND_ROWS();
  • 0.001s: 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.001s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2534
  • 0.001s: 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.001s: 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.001s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2549
  • 0.001s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2657
  • 0.001s: 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.000s: 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.001s: 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.001s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2641
  • 0.001s: 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.001s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2661
  • 0.001s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2721
  • 0.001s: 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.001s: 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.001s: SELECT ID_PAGE, type, has_children FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND ID_PARENT = 2758
  • 0.001s: 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 < 1776432606 AND (p.publish_until = 0 OR p.publish_until > 1776432606) ORDER BY p.depth ASC, p.order ASC
  • 0.001s: SELECT FOUND_ROWS();
n/a