Lock screen after switching from GDM to LightDM

  •  

When switching from GDM to LightDM, the screen locking no longer works. Even putting it into hibernate / suspend, the session isn't locked. The cause lies in the fact that GDM has screen locking built in, where LightDM doesn't.

This means another 'helping' package is required to get screen locking to work with LightDM again. Below you'll find examples getting it to work with three different methods:

Lock screen in LightDM using gnome-screensaver

Earlier versions of GDM used this gnome-screensaver package to provide the locking feature, but recent versions have it removed because GDM3 has the locking built in. Nonetheless, LightDM has working support for gnome-screensaver.

1. Installing gnome-screensaver

apt install gnome-screensaver

The deamon won't be started until the computer has been started (because the package generate an autostart item). Optionally it can by manually invoked for testing:

# Remove the "&" at the end if you want to be able to kill the process using CTRL+C, othwewise it runs as a background process
gnome-screensaver &

2. Invoking light-locker when hybernate / sleep

This works right out of the box, no configuration needed. However it must be enabled under Settings → Power.

3. Setting up Super + L shortcut

This also works right out of the box, taking into account you set up the keyboard shortcut correctly. See Settings → Devices → Keyboard and check the Lock Screen shortcut.


Lock screen in LightDM using i3lock

The i3lock package is a utra lightweight and minimal screen locker, therefore it's very much in line with LightDM's philosophy of being… Erm, lightweight.

1. Installing i3lock

apt install i3lock

2. Invoking i3lock when hibernate / suspend

Before your system goed into sleep mode, a script will call i3lock, as described, create a a file /etc/systemd/system/lockbeforesleep@user.service, replacing user with your username. And fill it with the following content:

[Unit]
Description=Turning i3lock on before sleep
Before=sleep.target

[Service]
User=%I
Type=forking
Environment=DISPLAY=:0
ExecStart=/usr/bin/i3lock -i /home/user/Pictures/your_wallpaper.png
ExecStartPost=/usr/bin/sleep 1

[Install]
WantedBy=sleep.target

Then, the service needs to be enabled, and optionally tested:

sudo systemctl enable lockbeforesleep@user.service
sudo systemctl daemon-reload

# Optionally test the service
systemctl suspend

3. Setting up Super + L shortcut

Either use the Settings-app and navigate to Devices → Keyboard to create a new shortcut calling the following command: /usr/bin/i3lock -i /home/user/Pictures/your_wallpaper.png or use the commands below to automate the process:

# Clear current screensave command, to free up Super + L
dconf write /org/gnome/settings-daemon/plugins/media-keys/screensaver "''"

# Create new entry
dconf write /org/gnome/settings-daemon/plugins/media-keys/custom-keybindings/custom1/binding "'<Super>l'"
dconf write /org/gnome/settings-daemon/plugins/media-keys/custom-keybindings/custom1/name "'LightDM i3lock'"
dconf write /org/gnome/settings-daemon/plugins/media-keys/custom-keybindings/custom1/command "'/usr/bin/i3lock -i /home/user/Pictures/your_wallpaper.png'"
dconf write /org/gnome/settings-daemon/plugins/media-keys/custom-keybindings "['/org/gnome/settings-daemon/plugins/media-keys/custom-keybindings/custom0/']"

Lock screen in LightDM using light-locker

1. Installing light-locker

apt install light-locker

2. Invoking light-locker when hibernate / suspend

Before your system goed into sleep mode, a script will call i3lock, as described, create a a file /etc/systemd/system/lockbeforesleep@user.service, replacing user with your username. And fill it with the following content:

[Unit]
Description=Turning light-locker on before sleep
Before=sleep.target

[Service]
User=%I
Type=forking
Environment=XDG_SEAT_PATH="/org/freedesktop/DisplayManager/Seat0"
ExecStart=/usr/bin/dm-tool lock
ExecStartPost=/usr/bin/sleep 1

[Install]
WantedBy=sleep.target

Then, the service needs to be enabled, and optionally tested:

sudo systemctl enable lockbeforesleep@user.service
sudo systemctl daemon-reload

# Optionally test the service
systemctl suspend

3. Setting up Super + L shortcut

Either navigate to Settings → Devices → Keyboard to create a new shortcut calling the following command: dm-tools lock or use the commands below to automate the process:

# Clear current screensave command, to free up Super + L
dconf write /org/gnome/settings-daemon/plugins/media-keys/screensaver "''"

# Create new entry
dconf write /org/gnome/settings-daemon/plugins/media-keys/custom-keybindings/custom1/binding "'<Super>l'"
dconf write /org/gnome/settings-daemon/plugins/media-keys/custom-keybindings/custom1/name "'LightDM light-locker'"
dconf write /org/gnome/settings-daemon/plugins/media-keys/custom-keybindings/custom1/command "'dm-tools lock'"
dconf write /org/gnome/settings-daemon/plugins/media-keys/custom-keybindings "['/org/gnome/settings-daemon/plugins/media-keys/custom-keybindings/custom0/']"

That's it, hit Super + L and see if it works!

References

  1. https://unix.stackexchange.com/questions/86221/how-can-i-lock-my-screen-in-gnome-3-without-gdm
  2. https://www.reddit.com/r/gnome/comments/9klvej/is_there_a_way_to_get_the_screen_to_lock_with/
  3. https://forum.manjaro.org/t/how-to-fix-lock-screen-after-changing-gdm-to-lightdm/62751
  4. https://askubuntu.com/questions/632384/lock-screen-from-root-shell
0.02
640.15kb
694.89kb
0.047s
  • 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.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.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.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.000s: SELECT ID_PAGE, ID_PARENT, type, url, menu_title, show_menu FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND publish_from <= 1776427433 AND publish_from > 0 AND (publish_until >= 1776427433 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/lock-screen-after-switching-from-gdm-to-lightdm.html' 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 = 2743
  • 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.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 = 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/lock-screen-after-switching-from-gdm-to-lightdm.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( 2743 ) 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` = 2743 AND `setting` = 'show-breadcrumb'
  • 0.001s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_pages' AND `id` = 2743 AND `setting` = 'page-class'
  • 0.001s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_pages' AND `id` = 2743 AND `setting` = 'header-scripts'
  • 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( 2547 ) 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.001s: SELECT ID_GROUP FROM `perfacilis_test`.`core_users_groups` WHERE ID_USER = 1 AND (time_until = -1 OR time_until >= 1776427433)
  • 0.000s: 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( 2743 ) 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` = 626 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 < 1776427433 AND (p.publish_until = 0 OR p.publish_until > 1776427433) 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 < 1776427433 AND (p.publish_until = 0 OR p.publish_until > 1776427433) 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.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 < 1776427433 AND (p.publish_until = 0 OR p.publish_until > 1776427433) 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.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.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.000s: SELECT ID_PAGE, ID_PARENT, type, url, menu_title, show_menu FROM `perfacilis_test`.`cms_pages` WHERE ID_SITE = 1 AND publish_from <= 1776427433 AND publish_from > 0 AND (publish_until >= 1776427433 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/lock-screen-after-switching-from-gdm-to-lightdm.html' 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 = 2743
  • 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.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 = 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/lock-screen-after-switching-from-gdm-to-lightdm.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( 2743 ) 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` = 2743 AND `setting` = 'show-breadcrumb'
  • 0.001s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_pages' AND `id` = 2743 AND `setting` = 'page-class'
  • 0.001s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_pages' AND `id` = 2743 AND `setting` = 'header-scripts'
  • 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( 2547 ) 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.001s: SELECT ID_GROUP FROM `perfacilis_test`.`core_users_groups` WHERE ID_USER = 1 AND (time_until = -1 OR time_until >= 1776427433)
  • 0.000s: 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( 2743 ) 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` = 626 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 < 1776427433 AND (p.publish_until = 0 OR p.publish_until > 1776427433) 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 < 1776427433 AND (p.publish_until = 0 OR p.publish_until > 1776427433) 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.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 < 1776427433 AND (p.publish_until = 0 OR p.publish_until > 1776427433) ORDER BY p.depth ASC, p.order ASC
  • 0.000s: SELECT FOUND_ROWS();
n/a