Shorthand commands for SVN

  •  

SVN can be quite cumbersome to use. I just prefer using GIT, because of, erm… reasons. Sometimes however, you have to work with SVN because of collaborations or older projects just started that way. Therefore I've created some very simple shorthands, bash aliases to be precise, to speed things up a bit (and avoid typing the same stuff over and over again).

These aliases can be easily added to your bash_aliases file in one go:

echo "alias svndiff='svn diff | colordiff | less -r'" >> ~/.bash_aliases
echo "alias svnremove='svn status | grep ! | cut -c9- | while IFS= read -r FILE; do svn remove \"\$FILE\"; done;'" >> ~/.bash_aliases
echo "alias svnadd='svn status | grep ? | cut -c9- | while IFS= read -r FILE; do svn add \"\$FILE\"; done'" >> ~/.bash_aliases
. ~/.bashrc

Now you can use:

  • svndiff to show your working changes in a readable format (you might have to apt install colordiff to get this going);
  • svnremove to remove files that no longer exist from version control;
  • svnadd to add new files to version control.

Just type one of these commands whilst in your SVN directory and you're good to go.

PS: U using Wind00z and using SVN? U broken beyond repair…

0.11
626.85kb
681.56kb
0.046s
  • 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.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.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.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 <= 1776432596 AND publish_from > 0 AND (publish_until >= 1776432596 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/shorthand-commands-for-svn.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 = 2709
  • 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.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.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/systeembeheer/linux/shorthand-commands-for-svn.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( 2709 ) 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` = 2709 AND `setting` = 'show-breadcrumb'
  • 0.001s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_pages' AND `id` = 2709 AND `setting` = 'page-class'
  • 0.001s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_pages' AND `id` = 2709 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 >= 1776432596)
  • 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( 2709 ) 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` = 589 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 < 1776432596 AND (p.publish_until = 0 OR p.publish_until > 1776432596) 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 < 1776432596 AND (p.publish_until = 0 OR p.publish_until > 1776432596) ORDER BY p.publish_from DESC LIMIT 0, 6
  • 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 = 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 < 1776432596 AND (p.publish_until = 0 OR p.publish_until > 1776432596) ORDER BY p.depth ASC, p.order ASC
  • 0.000s: SELECT FOUND_ROWS();
  • 0.000s: SELECT SQL_CALC_FOUND_ROWS s.ID_SITE, s.ID_COMPANY, s.domainname, s.title, s.theme, s.is_primary, s.mode, s.created_time, s.created_by, s.deleted_time, s.deleted_by, c.name FROM `perfacilis_test`.`cms_sites` s INNER JOIN `perfacilis_test`.`contacts_companies` c ON c.ID_COMPANY = s.ID_COMPANY WHERE s.deleted_time = 0 AND s.domainname = 'perfacilis.com' ORDER BY s.domainname ASC
  • 0.000s: SELECT FOUND_ROWS();
  • 0.000s: SELECT SQL_CALC_FOUND_ROWS s.ID_SITE, s.ID_COMPANY, s.domainname, s.title, s.theme, s.is_primary, s.mode, s.created_time, s.created_by, s.deleted_time, s.deleted_by, c.name FROM `perfacilis_test`.`cms_sites` s INNER JOIN `perfacilis_test`.`contacts_companies` c ON c.ID_COMPANY = s.ID_COMPANY WHERE s.deleted_time = 0 ORDER BY s.domainname ASC
  • 0.000s: SELECT FOUND_ROWS();
  • 0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'ga-tracking-id'
  • 0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'g-ads-tag-id'
  • 0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'g-site-vertification'
  • 0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'banner-width'
  • 0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'banner-height'
  • 0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'fb-app-id'
  • 0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'fb-admins'
  • 0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'twitter-site'
  • 0.000s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_sites' AND `id` = 1 AND `setting` = 'twitter-creator'
  • 0.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.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 <= 1776432596 AND publish_from > 0 AND (publish_until >= 1776432596 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/shorthand-commands-for-svn.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 = 2709
  • 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.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.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/systeembeheer/linux/shorthand-commands-for-svn.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( 2709 ) 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` = 2709 AND `setting` = 'show-breadcrumb'
  • 0.001s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_pages' AND `id` = 2709 AND `setting` = 'page-class'
  • 0.001s: SELECT value, type FROM `perfacilis_test`.`core_settings` WHERE `table` = 'cms_pages' AND `id` = 2709 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 >= 1776432596)
  • 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( 2709 ) 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` = 589 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 < 1776432596 AND (p.publish_until = 0 OR p.publish_until > 1776432596) 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 < 1776432596 AND (p.publish_until = 0 OR p.publish_until > 1776432596) ORDER BY p.publish_from DESC LIMIT 0, 6
  • 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 = 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 < 1776432596 AND (p.publish_until = 0 OR p.publish_until > 1776432596) ORDER BY p.depth ASC, p.order ASC
  • 0.000s: SELECT FOUND_ROWS();
n/a