Update 1.1: Extra velden in E-mailmarketing systeem

  •  
  •  

Op 12 oktober 2016 is versie 1.1 van het Perfacilis Framework gereleased. Deze update omvatte een aantal kleine wijzigingen aan het CMS en aan het DNS-beheer, maar had als voornaamste wijziging een langverwachtte update aan het E-mailmarketing systeem: Extra velden:

Extra velden

Door deze update kan er bij elk contact in een mailinglijst extra informatie worden toegevoegd. Momenteel worden de volgende extra velden ondersteund:

  • Geslacht;
  • Geboortedatum;
  • Adres;
  • Bedrijfsnaam;
  • Telefoonnummer;
  • Mobiel-nummer.

Wanneer deze gegevens, bijvoorbeeld via de import functie, in het systeem aanwezig zijn kan er op deze gegevens worden gezocht en kan deze informatie toegevoegd worden aan nieuwsbrieven. Elk veld kan afzonderlijk geactiveerd of worden en per veld kan bepaald worden of de gebruiker verplicht is de velden te vullen tijdens het inschrijvingsproces.

Velden ontvanger

Een mini-CRM?

Deze informatie kan snel geraadpleegd worden en eventueel gebruikt worden om bijvoorbeeld de contacten die bij een bepaald bedrijf horen op te zoeken, zoals ook bij een CRM mogelijk is. Het e-mailmarketing systeem is echter geen vervanging voor een volledig CRM, zie het meer als een referentie database. Het is nog onbekend of het e-mailmarketingsysteem in de toekomst wel deze functionaliteit zal gaan vervullen. Dit hangt vooral af van de vraag van de gebruikers en of dit niet conflicteert met andere systemen in het Framework.

Verbeteringen

Momenteel staan de volgende verbeteringen op de planning:

  1. De mogelijkheid om aangepaste velden toe te voegen:
    Hiermee kun je zelf bepalen watvoor veld je toevoegt (tekstveld, datumveld, dropdown, etc) - hierdoor kun je nog meer informatie van de betreffende gebruiker verzamelen;
  2. De mogelijkheid om e-mails te versturen op basis van de informatie:
    Een mooi voorbeeld is het geboortedatum veld. Er wordt een trigger "verjaardag" toegevoegd, waardoor je een e-mail of campagne kunt starten als iemand jarig of wordt.

Deze verbeteringen staat gepland voor de eerstvolgende grote update aan het e-mailmarketing systeem, welke medio december zal worden gereleased.

Probeer het nu gratis!

Start vandaag nog met het bouwen van jouw lijst - want elke dag dat je niet bouwt aan je lijst is een verloren dag. Probeer het nu de eerste 30 dagen gratis!

Nu proberen »

0.02
630.34kb
689.21kb
0.054s
  • 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.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 <= 1776427438 AND publish_from > 0 AND (publish_until >= 1776427438 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/internet-marketing/e-mail-marketing/update-1.1.1-extra-velden-in-e-mailmarketing-systeem.html' AND p.removed = 0 ORDER BY p.depth ASC, p.order ASC LIMIT 0, 1
  • 0.000s: SELECT FOUND_ROWS();
  • 0.001s: SELECT ID_PARENT FROM `perfacilis_test`.`cms_pages` WHERE ID_PAGE = 2637
  • 0.000s: SELECT ID_PARENT FROM `perfacilis_test`.`cms_pages` WHERE ID_PAGE = 2577
  • 0.000s: SELECT ID_PARENT FROM `perfacilis_test`.`cms_pages` WHERE ID_PAGE = 2521
  • 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.002s: SELECT ID_PAGE FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND url = 'blog/internet-marketing/e-mail-marketing/update-1.1.1-extra-velden-in-e-mailmarketing-systeem.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( 2637 ) ORDER BY p.depth ASC, p.order ASC LIMIT 0, 10
  • 0.000s: SELECT FOUND_ROWS();
  • 0.001s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_pages' AND `id` = 2637 AND `setting` = 'show-breadcrumb'
  • 0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_pages' AND `id` = 2637 AND `setting` = 'page-class'
  • 0.001s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_pages' AND `id` = 2637 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( 2601, 1407, 1407 ) AND p.removed = 0 ORDER BY p.depth ASC, p.order ASC LIMIT 0, 3
  • 0.000s: SELECT FOUND_ROWS();
  • 0.000s: 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( 2577 ) AND p.type = 'blogcategory' AND p.removed = 0 ORDER BY p.depth ASC, p.order ASC LIMIT 0, 10
  • 0.000s: SELECT FOUND_ROWS();
  • 0.000s: 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.000s: SELECT ID_GROUP FROM `perfacilis_test`.`core_users_groups` WHERE ID_USER = 1 AND (time_until = -1 OR time_until >= 1776427438)
  • 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( 2637 ) AND p.removed = 0 ORDER BY p.order ASC LIMIT 0, 10
  • 0.000s: SELECT FOUND_ROWS();
  • 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` = 507 ORDER BY `id_media` ASC LIMIT 0, 10
  • 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 < 1776427438 AND (p.publish_until = 0 OR p.publish_until > 1776427438) 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 < 1776427438 AND (p.publish_until = 0 OR p.publish_until > 1776427438) 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.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.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.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 < 1776427438 AND (p.publish_until = 0 OR p.publish_until > 1776427438) 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.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 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 <= 1776427438 AND publish_from > 0 AND (publish_until >= 1776427438 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/internet-marketing/e-mail-marketing/update-1.1.1-extra-velden-in-e-mailmarketing-systeem.html' AND p.removed = 0 ORDER BY p.depth ASC, p.order ASC LIMIT 0, 1
  • 0.000s: SELECT FOUND_ROWS();
  • 0.001s: SELECT ID_PARENT FROM `perfacilis_test`.`cms_pages` WHERE ID_PAGE = 2637
  • 0.000s: SELECT ID_PARENT FROM `perfacilis_test`.`cms_pages` WHERE ID_PAGE = 2577
  • 0.000s: SELECT ID_PARENT FROM `perfacilis_test`.`cms_pages` WHERE ID_PAGE = 2521
  • 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.002s: SELECT ID_PAGE FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND url = 'blog/internet-marketing/e-mail-marketing/update-1.1.1-extra-velden-in-e-mailmarketing-systeem.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( 2637 ) ORDER BY p.depth ASC, p.order ASC LIMIT 0, 10
  • 0.000s: SELECT FOUND_ROWS();
  • 0.001s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_pages' AND `id` = 2637 AND `setting` = 'show-breadcrumb'
  • 0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_pages' AND `id` = 2637 AND `setting` = 'page-class'
  • 0.001s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_pages' AND `id` = 2637 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( 2601, 1407, 1407 ) AND p.removed = 0 ORDER BY p.depth ASC, p.order ASC LIMIT 0, 3
  • 0.000s: SELECT FOUND_ROWS();
  • 0.000s: 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( 2577 ) AND p.type = 'blogcategory' AND p.removed = 0 ORDER BY p.depth ASC, p.order ASC LIMIT 0, 10
  • 0.000s: SELECT FOUND_ROWS();
  • 0.000s: 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.000s: SELECT ID_GROUP FROM `perfacilis_test`.`core_users_groups` WHERE ID_USER = 1 AND (time_until = -1 OR time_until >= 1776427438)
  • 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( 2637 ) AND p.removed = 0 ORDER BY p.order ASC LIMIT 0, 10
  • 0.000s: SELECT FOUND_ROWS();
  • 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` = 507 ORDER BY `id_media` ASC LIMIT 0, 10
  • 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 < 1776427438 AND (p.publish_until = 0 OR p.publish_until > 1776427438) 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 < 1776427438 AND (p.publish_until = 0 OR p.publish_until > 1776427438) 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.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.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.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 < 1776427438 AND (p.publish_until = 0 OR p.publish_until > 1776427438) ORDER BY p.depth ASC, p.order ASC
  • 0.000s: SELECT FOUND_ROWS();
n/a