| 1 | SHOW FULL COLUMNS FROM `cat4_sites` | | 19 | 19 | 2 |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 1 |
| 3 | SELECT `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_sites` AS `Site` WHERE `Site`.`domain` IS NOT NULL AND `Site`.`domain` <> "" ORDER BY `Site`.`sort` DESC | | 0 | 0 | 0 |
| 4 | SELECT `Site`.`id`, `Site`.`alias`, IF(Site.domain = "catalyst.visuallizard.net" OR Site.domain = "www.catalyst.visuallizard.net", 1, 0) AS domain_match FROM `cat4_sites` AS `Site` WHERE `Site`.`alias` IS NOT NULL AND `Site`.`alias` <> "" ORDER BY `Site`.`flag_admin` ASC, `domain_match` DESC, `Site`.`sort` DESC | | 5 | 5 | 0 |
| 5 | SHOW FULL COLUMNS FROM `cat4_pages` | | 21 | 21 | 1 |
| 6 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE (`Site`.`alias` = "main" OR `Site`.`id`="main") AND `Page`.`parent_id` <> 0 ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 2 |
| 7 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`id` = 31 LIMIT 1 | | 1 | 1 | 0 |
| 8 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `cat4_pages` AS `Page` WHERE `Page`.`lft` <= "42" AND `Page`.`rght` >= "45" AND `Page`.`site_id` = "4" ORDER BY `Page`.`lft` ASC | | 2 | 2 | 0 |
| 9 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`parent_id` <> 0 AND `Site`.`id` = "4" ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 |
| 10 | SELECT `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_sites` AS `Site` WHERE `Site`.`id` = 4 LIMIT 1 | | 1 | 1 | 0 |
| 11 | SELECT `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_sites` AS `Site` WHERE `Site`.`id` = 'main' LIMIT 1 | | 0 | 0 | 0 |
| 12 | SHOW FULL COLUMNS FROM `cat4_admins` | | 25 | 25 | 2 |
| 13 | SHOW FULL COLUMNS FROM `cat4_admins_sites` | | 22 | 22 | 1 |
| 14 | SHOW FULL COLUMNS FROM `cat4_updates` | | 12 | 12 | 1 |
| 15 | SHOW FULL COLUMNS FROM `cat4_modules` | | 21 | 21 | 1 |
| 16 | SHOW FULL COLUMNS FROM `cat4_modules_settings` | | 12 | 12 | 1 |
| 17 | SELECT `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_sites` AS `Site` WHERE (`Site`.`alias`="main" OR `Site`.`id`="main") LIMIT 1 | | 1 | 1 | 1 |
| 18 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`site_id`="4" AND (`Page`.`alias`="31" OR `Page`.`id`="31") LIMIT 1 | | 1 | 1 | 0 |
| 19 | SELECT `Module`.`id`, `Module`.`site_id`, `Module`.`page_id`, `Module`.`module_id`, `Module`.`data_id`, `Module`.`display_page_id`, `Module`.`display_module_id`, `Module`.`flag_xsite`, `Module`.`sort`, `Module`.`plugin`, `Module`.`controller`, `Module`.`action`, `Module`.`div`, `Module`.`alias`, `Module`.`title`, `Module`.`subtitle`, `Module`.`flag_hidden`, `Module`.`created`, `Module`.`created_by`, `Module`.`modified`, `Module`.`modified_by` FROM `cat4_modules` AS `Module` WHERE `Module`.`site_id`="0" AND `Module`.`page_id` = "31" AND `Module`.`div` IS NOT NULL AND `Module`.`div` != "" ORDER BY `Module`.`sort` DESC | | 1 | 1 | 0 |
| 20 | SELECT `Module`.`id`, `Module`.`site_id`, `Module`.`page_id`, `Module`.`module_id`, `Module`.`data_id`, `Module`.`display_page_id`, `Module`.`display_module_id`, `Module`.`flag_xsite`, `Module`.`sort`, `Module`.`plugin`, `Module`.`controller`, `Module`.`action`, `Module`.`div`, `Module`.`alias`, `Module`.`title`, `Module`.`subtitle`, `Module`.`flag_hidden`, `Module`.`created`, `Module`.`created_by`, `Module`.`modified`, `Module`.`modified_by` FROM `cat4_modules` AS `Module` WHERE `Module`.`id` = 242 LIMIT 1 | | 1 | 1 | 0 |
| 21 | SHOW FULL COLUMNS FROM `cat4_contents` | | 9 | 9 | 1 |
| 22 | SHOW FULL COLUMNS FROM `cat4_contents_revs` | | 11 | 11 | 1 |
| 23 | SELECT `ModulesSettings`.`id`, `ModulesSettings`.`module_id`, `ModulesSettings`.`key`, `ModulesSettings`.`value`, `ModulesSettings`.`description`, `ModulesSettings`.`type`, `ModulesSettings`.`class`, `ModulesSettings`.`options`, `ModulesSettings`.`created`, `ModulesSettings`.`created_by`, `ModulesSettings`.`modified`, `ModulesSettings`.`modified_by` FROM `cat4_modules_settings` AS `ModulesSettings` WHERE `ModulesSettings`.`module_id` = 241 | | 0 | 0 | 0 |
| 24 | SELECT `ModulesSettings`.`id`, `ModulesSettings`.`module_id`, `ModulesSettings`.`key`, `ModulesSettings`.`value`, `ModulesSettings`.`description`, `ModulesSettings`.`type`, `ModulesSettings`.`class`, `ModulesSettings`.`options`, `ModulesSettings`.`created`, `ModulesSettings`.`created_by`, `ModulesSettings`.`modified`, `ModulesSettings`.`modified_by` FROM `cat4_modules_settings` AS `ModulesSettings` WHERE `ModulesSettings`.`module_id` = 242 | | 0 | 0 | 0 |
| 25 | SELECT `Content`.`id`, `Content`.`data_id`, `Content`.`title`, `Content`.`body`, `Content`.`columns`, `Content`.`created`, `Content`.`created_by`, `Content`.`modified`, `Content`.`modified_by` FROM `cat4_contents` AS `Content` WHERE `Content`.`data_id` = 241 LIMIT 1 | | 1 | 1 | 0 |
| 26 | SELECT `Module`.`id`, `Module`.`site_id`, `Module`.`page_id`, `Module`.`module_id`, `Module`.`data_id`, `Module`.`display_page_id`, `Module`.`display_module_id`, `Module`.`flag_xsite`, `Module`.`sort`, `Module`.`plugin`, `Module`.`controller`, `Module`.`action`, `Module`.`div`, `Module`.`alias`, `Module`.`title`, `Module`.`subtitle`, `Module`.`flag_hidden`, `Module`.`created`, `Module`.`created_by`, `Module`.`modified`, `Module`.`modified_by` FROM `cat4_modules` AS `Module` WHERE `Module`.`page_id`="0" AND `Module`.`site_id`="4" AND `Module`.`div` IS NOT NULL AND `Module`.`div` != "" AND `Module`.`flag_xsite`="0" AND `Module`.`div` != "main" ORDER BY `Module`.`sort` DESC | | 3 | 3 | 1 |
| 27 | SELECT `Module`.`id`, `Module`.`site_id`, `Module`.`page_id`, `Module`.`module_id`, `Module`.`data_id`, `Module`.`display_page_id`, `Module`.`display_module_id`, `Module`.`flag_xsite`, `Module`.`sort`, `Module`.`plugin`, `Module`.`controller`, `Module`.`action`, `Module`.`div`, `Module`.`alias`, `Module`.`title`, `Module`.`subtitle`, `Module`.`flag_hidden`, `Module`.`created`, `Module`.`created_by`, `Module`.`modified`, `Module`.`modified_by` FROM `cat4_modules` AS `Module` WHERE `Module`.`id` = 338 LIMIT 1 | | 1 | 1 | 0 |
| 28 | SHOW FULL COLUMNS FROM `cat4_members` | | 23 | 23 | 2 |
| 29 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | | 1 | 1 | 1 |
| 30 | SHOW FULL COLUMNS FROM `cat4_member_types` | | 8 | 8 | 1 |
| 31 | SELECT `ModulesSettings`.`id`, `ModulesSettings`.`module_id`, `ModulesSettings`.`key`, `ModulesSettings`.`value`, `ModulesSettings`.`description`, `ModulesSettings`.`type`, `ModulesSettings`.`class`, `ModulesSettings`.`options`, `ModulesSettings`.`created`, `ModulesSettings`.`created_by`, `ModulesSettings`.`modified`, `ModulesSettings`.`modified_by` FROM `cat4_modules_settings` AS `ModulesSettings` WHERE `ModulesSettings`.`module_id` = 337 | | 0 | 0 | 0 |
| 32 | SELECT `ModulesSettings`.`id`, `ModulesSettings`.`module_id`, `ModulesSettings`.`key`, `ModulesSettings`.`value`, `ModulesSettings`.`description`, `ModulesSettings`.`type`, `ModulesSettings`.`class`, `ModulesSettings`.`options`, `ModulesSettings`.`created`, `ModulesSettings`.`created_by`, `ModulesSettings`.`modified`, `ModulesSettings`.`modified_by` FROM `cat4_modules_settings` AS `ModulesSettings` WHERE `ModulesSettings`.`module_id` = 338 | | 0 | 0 | 0 |
| 33 | SELECT `Module`.`id`, `Module`.`site_id`, `Module`.`page_id`, `Module`.`module_id`, `Module`.`data_id`, `Module`.`display_page_id`, `Module`.`display_module_id`, `Module`.`flag_xsite`, `Module`.`sort`, `Module`.`plugin`, `Module`.`controller`, `Module`.`action`, `Module`.`div`, `Module`.`alias`, `Module`.`title`, `Module`.`subtitle`, `Module`.`flag_hidden`, `Module`.`created`, `Module`.`created_by`, `Module`.`modified`, `Module`.`modified_by` FROM `cat4_modules` AS `Module` WHERE `Module`.`id` = 335 LIMIT 1 | | 1 | 1 | 0 |
| 34 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`id` = 145 LIMIT 1 | | 1 | 1 | 0 |
| 35 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`parent_id` <> 0 AND `Site`.`id` = "3" ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 1 |
| 36 | SELECT `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_sites` AS `Site` WHERE `Site`.`id` = 3 LIMIT 1 | | 1 | 1 | 0 |
| 37 | SELECT `Module`.`id`, `Module`.`site_id`, `Module`.`page_id`, `Module`.`module_id`, `Module`.`data_id`, `Module`.`display_page_id`, `Module`.`display_module_id`, `Module`.`flag_xsite`, `Module`.`sort`, `Module`.`plugin`, `Module`.`controller`, `Module`.`action`, `Module`.`div`, `Module`.`alias`, `Module`.`title`, `Module`.`subtitle`, `Module`.`flag_hidden`, `Module`.`created`, `Module`.`created_by`, `Module`.`modified`, `Module`.`modified_by` FROM `cat4_modules` AS `Module` WHERE `Module`.`id` = 0 LIMIT 1 | | 0 | 0 | 0 |
| 38 | SELECT `ModulesSettings`.`id`, `ModulesSettings`.`module_id`, `ModulesSettings`.`key`, `ModulesSettings`.`value`, `ModulesSettings`.`description`, `ModulesSettings`.`type`, `ModulesSettings`.`class`, `ModulesSettings`.`options`, `ModulesSettings`.`created`, `ModulesSettings`.`created_by`, `ModulesSettings`.`modified`, `ModulesSettings`.`modified_by` FROM `cat4_modules_settings` AS `ModulesSettings` WHERE `ModulesSettings`.`module_id` = 33 | | 5 | 5 | 0 |
| 39 | SELECT `ModulesSettings`.`id`, `ModulesSettings`.`module_id`, `ModulesSettings`.`key`, `ModulesSettings`.`value`, `ModulesSettings`.`description`, `ModulesSettings`.`type`, `ModulesSettings`.`class`, `ModulesSettings`.`options`, `ModulesSettings`.`created`, `ModulesSettings`.`created_by`, `ModulesSettings`.`modified`, `ModulesSettings`.`modified_by` FROM `cat4_modules_settings` AS `ModulesSettings` WHERE `ModulesSettings`.`module_id` = 0 | | 0 | 0 | 0 |
| 40 | SELECT `Page`.`id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`alias`, `Page`.`navigation`, `Page`.`lft`, `Page`.`rght`, `Page`.`site_id`, `Page`.`flag_hidden`, `Page`.`link`, `Page`.`type`, `Page`.`modified`, `Site`.`id`, `Site`.`data_id`, `Site`.`alias`, `EditPageModule`.`id`, `AssociatedPage`.`id`, `AssociatedPage`.`data_id`, `AssociatedPage`.`link`, `AssociatedPage`.`flag_hidden`, `AssociatedPage`.`type` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) LEFT JOIN `cat4_modules` AS `EditPageModule` ON (`EditPageModule`.`plugin` = "cat4_page" AND `EditPageModule`.`controller`="admin_pages" AND `EditPageModule`.`page_id` IS NOT NULL AND `EditPageModule`.`page_id` <> 0 AND `EditPageModule`.`page_id` = `Page`.`id` AND `EditPageModule`.`module_id` = 0 AND `EditPageModule`.`page_id` = `Page`.`id`) LEFT JOIN `cat4_pages` AS `AssociatedPage` ON (`AssociatedPage`.`data_id` = `Page`.`id`) WHERE `Page`.`site_id` = "4" AND `Page`.`flag_hidden` = 1 ORDER BY `Page`.`lft` ASC | | 3 | 3 | 1 |
| 41 | SELECT `Page`.`id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`alias`, `Page`.`navigation`, `Page`.`lft`, `Page`.`rght`, `Page`.`site_id`, `Page`.`flag_hidden`, `Page`.`link`, `Page`.`type`, `Page`.`modified`, `Site`.`id`, `Site`.`data_id`, `Site`.`alias`, `EditPageModule`.`id`, `AssociatedPage`.`id`, `AssociatedPage`.`data_id`, `AssociatedPage`.`link`, `AssociatedPage`.`flag_hidden`, `AssociatedPage`.`type` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) LEFT JOIN `cat4_modules` AS `EditPageModule` ON (`EditPageModule`.`plugin` = "cat4_page" AND `EditPageModule`.`controller`="admin_pages" AND `EditPageModule`.`page_id` IS NOT NULL AND `EditPageModule`.`page_id` <> 0 AND `EditPageModule`.`page_id` = `Page`.`id` AND `EditPageModule`.`module_id` = 0 AND `EditPageModule`.`page_id` = `Page`.`id`) LEFT JOIN `cat4_pages` AS `AssociatedPage` ON (`AssociatedPage`.`data_id` = `Page`.`id`) WHERE `Page`.`site_id` = "4" AND `Page`.`flag_hidden` <> 1 AND ( `Page`.`lft` <= 42 OR `Page`.`rght` >= 45) AND ( `Page`.`lft` <= 72 OR `Page`.`rght` >= 73) AND ( `Page`.`lft` <= 74 OR `Page`.`rght` >= 75) ORDER BY `Page`.`lft` ASC | | 9 | 9 | 1 |
| 42 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`id` = 129 LIMIT 1 | | 1 | 1 | 1 |
| 43 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `cat4_pages` AS `Page` WHERE `Page`.`lft` <= "46" AND `Page`.`rght` >= "47" AND `Page`.`site_id` = "4" ORDER BY `Page`.`lft` ASC | | 2 | 2 | 0 |
| 44 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`parent_id` <> 0 AND `Site`.`id` = "4" ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 |
| 45 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`id` = 131 LIMIT 1 | | 1 | 1 | 0 |
| 46 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `cat4_pages` AS `Page` WHERE `Page`.`lft` <= "48" AND `Page`.`rght` >= "49" AND `Page`.`site_id` = "4" ORDER BY `Page`.`lft` ASC | | 2 | 2 | 0 |
| 47 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`parent_id` <> 0 AND `Site`.`id` = "4" ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 |
| 48 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`id` = 133 LIMIT 1 | | 1 | 1 | 0 |
| 49 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `cat4_pages` AS `Page` WHERE `Page`.`lft` <= "50" AND `Page`.`rght` >= "51" AND `Page`.`site_id` = "4" ORDER BY `Page`.`lft` ASC | | 2 | 2 | 0 |
| 50 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`parent_id` <> 0 AND `Site`.`id` = "4" ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 |
| 51 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`id` = 135 LIMIT 1 | | 1 | 1 | 0 |
| 52 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `cat4_pages` AS `Page` WHERE `Page`.`lft` <= "52" AND `Page`.`rght` >= "53" AND `Page`.`site_id` = "4" ORDER BY `Page`.`lft` ASC | | 2 | 2 | 0 |
| 53 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`parent_id` <> 0 AND `Site`.`id` = "4" ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 |
| 54 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`id` = 137 LIMIT 1 | | 1 | 1 | 0 |
| 55 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `cat4_pages` AS `Page` WHERE `Page`.`lft` <= "54" AND `Page`.`rght` >= "55" AND `Page`.`site_id` = "4" ORDER BY `Page`.`lft` ASC | | 2 | 2 | 0 |
| 56 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`parent_id` <> 0 AND `Site`.`id` = "4" ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 |
| 57 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`id` = 151 LIMIT 1 | | 1 | 1 | 0 |
| 58 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `cat4_pages` AS `Page` WHERE `Page`.`lft` <= "64" AND `Page`.`rght` >= "71" AND `Page`.`site_id` = "4" ORDER BY `Page`.`lft` ASC | | 2 | 2 | 0 |
| 59 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`parent_id` <> 0 AND `Site`.`id` = "4" ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 |
| 60 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`id` = 159 LIMIT 1 | | 1 | 1 | 0 |
| 61 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `cat4_pages` AS `Page` WHERE `Page`.`lft` <= "67" AND `Page`.`rght` >= "68" AND `Page`.`site_id` = "4" ORDER BY `Page`.`lft` ASC | | 3 | 3 | 0 |
| 62 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`parent_id` <> 0 AND `Site`.`id` = "4" ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 |
| 63 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`id` = 161 LIMIT 1 | | 1 | 1 | 0 |
| 64 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `cat4_pages` AS `Page` WHERE `Page`.`lft` <= "69" AND `Page`.`rght` >= "70" AND `Page`.`site_id` = "4" ORDER BY `Page`.`lft` ASC | | 3 | 3 | 0 |
| 65 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`parent_id` <> 0 AND `Site`.`id` = "4" ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 |
| 66 | SELECT `Module`.`id`, `Module`.`site_id`, `Module`.`page_id`, `Module`.`module_id`, `Module`.`data_id`, `Module`.`display_page_id`, `Module`.`display_module_id`, `Module`.`flag_xsite`, `Module`.`sort`, `Module`.`plugin`, `Module`.`controller`, `Module`.`action`, `Module`.`div`, `Module`.`alias`, `Module`.`title`, `Module`.`subtitle`, `Module`.`flag_hidden`, `Module`.`created`, `Module`.`created_by`, `Module`.`modified`, `Module`.`modified_by` FROM `cat4_modules` AS `Module` WHERE `Module`.`id` = 340 LIMIT 1 | | 1 | 1 | 0 |
| 67 | SHOW FULL COLUMNS FROM `cat4_search_indices` | | 17 | 17 | 2 |
| 68 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci'; | | 1 | 1 | 1 |
| 69 | SELECT `ModulesSettings`.`id`, `ModulesSettings`.`module_id`, `ModulesSettings`.`key`, `ModulesSettings`.`value`, `ModulesSettings`.`description`, `ModulesSettings`.`type`, `ModulesSettings`.`class`, `ModulesSettings`.`options`, `ModulesSettings`.`created`, `ModulesSettings`.`created_by`, `ModulesSettings`.`modified`, `ModulesSettings`.`modified_by` FROM `cat4_modules_settings` AS `ModulesSettings` WHERE `ModulesSettings`.`module_id` = 339 | | 6 | 6 | 0 |
| 70 | SELECT `ModulesSettings`.`id`, `ModulesSettings`.`module_id`, `ModulesSettings`.`key`, `ModulesSettings`.`value`, `ModulesSettings`.`description`, `ModulesSettings`.`type`, `ModulesSettings`.`class`, `ModulesSettings`.`options`, `ModulesSettings`.`created`, `ModulesSettings`.`created_by`, `ModulesSettings`.`modified`, `ModulesSettings`.`modified_by` FROM `cat4_modules_settings` AS `ModulesSettings` WHERE `ModulesSettings`.`module_id` = 340 | | 0 | 0 | 0 |
| 71 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`id` = 149 LIMIT 1 | | 1 | 1 | 0 |
| 72 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `cat4_pages` AS `Page` WHERE `Page`.`lft` <= "72" AND `Page`.`rght` >= "73" AND `Page`.`site_id` = "4" ORDER BY `Page`.`lft` ASC | | 2 | 2 | 0 |
| 73 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`parent_id` <> 0 AND `Site`.`id` = "4" ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 |