| 1 | SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`user_id` FROM `moosocial`.`cake_sessions` AS `Session` WHERE `Session`.`id` = '3kpnogkkkhh9ampeaqs7m5uooq' LIMIT 1 | | 1 | 1 | 1 |
| 2 | SELECT `Plugin`.`enabled` FROM `moosocial`.`plugins` AS `Plugin` WHERE `Plugin`.`key` = 'Storage' ORDER BY `Plugin`.`weight` asc LIMIT 1 | | 1 | 1 | 1 |
| 3 | SELECT `Plugin`.`enabled` FROM `moosocial`.`plugins` AS `Plugin` WHERE `Plugin`.`key` = 'Storage' ORDER BY `Plugin`.`weight` asc LIMIT 1 | | 1 | 1 | 1 |
| 4 | SELECT `Plugin`.`enabled` FROM `moosocial`.`plugins` AS `Plugin` WHERE `Plugin`.`key` = 'Storage' ORDER BY `Plugin`.`weight` asc LIMIT 1 | | 1 | 1 | 1 |
| 5 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `moosocial`.`roles` AS `Role` WHERE `Role`.`id` = 3 LIMIT 1 | | 1 | 1 | 1 |
| 6 | SELECT `Coremenu`.`id`, `Coremenu`.`name`, `Coremenu`.`style`, `Coremenu`.`alias`, `Coremenu`.`menuid` FROM `moosocial`.`core_menus` AS `Coremenu` WHERE `id` = 2 LIMIT 1 | | 1 | 1 | 1 |
| 7 | SELECT `CoreMenuItem`.`id`, `CoreMenuItem`.`parent_id`, `CoreMenuItem`.`lft`, `CoreMenuItem`.`rght`, `CoreMenuItem`.`name`, `CoreMenuItem`.`original_name`, `CoreMenuItem`.`url`, `CoreMenuItem`.`title_attribute`, `CoreMenuItem`.`font_class`, `CoreMenuItem`.`is_active`, `CoreMenuItem`.`new_blank`, `CoreMenuItem`.`role_access`, `CoreMenuItem`.`menu_id`, `CoreMenuItem`.`type`, `CoreMenuItem`.`menu_order`, `CoreMenuItem`.`plugin`, `CoreMenuItem`.`group`, `CoreMenuItem`.`url_app`, `CoreMenuItem`.`font_class_app`, `CoreMenuItem`.`show_web`, `CoreMenuItem`.`show_app` FROM `moosocial`.`core_menu_items` AS `CoreMenuItem` WHERE `CoreMenuItem`.`is_active` = '1' AND `CoreMenuItem`.`menu_id` = (2) ORDER BY `CoreMenuItem`.`menu_order` ASC | | 5 | 5 | 2 |
| 8 | SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `moosocial`.`i18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (10, 11, 12, 9, 27) ORDER BY `id` ASC | | 5 | 5 | 2 |
| 9 | SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `moosocial`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moosocial`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 10 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 2 |
| 10 | SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `moosocial`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moosocial`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 11 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 1 |
| 11 | SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `moosocial`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moosocial`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 12 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 2 |
| 12 | SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `moosocial`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moosocial`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 9 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 1 |
| 13 | SELECT COUNT(*) AS `count` FROM `moosocial`.`plugins` AS `Plugin` WHERE `key` = 'Credit' | | 1 | 1 | 1 |
| 14 | SELECT `CreditActiontypes`.`id`, `CreditActiontypes`.`action_type`, `CreditActiontypes`.`action_type_name`, `CreditActiontypes`.`action_module`, `CreditActiontypes`.`credit`, `CreditActiontypes`.`max_credit`, `CreditActiontypes`.`rollover_period`, `CreditActiontypes`.`type`, `CreditActiontypes`.`plugin`, `CreditActiontypes`.`show`, `CreditActiontypes`.`is_active` FROM `moosocial`.`credit_actiontypes` AS `CreditActiontypes` WHERE `CreditActiontypes`.`action_type` = 'friend_inviter' LIMIT 1 | | 1 | 1 | 1 |
| 15 | SELECT `Plugin`.`id`, `Plugin`.`name`, `Plugin`.`key`, `Plugin`.`permission`, `Plugin`.`enabled`, `Plugin`.`core`, `Plugin`.`version`, `Plugin`.`weight`, `Plugin`.`menu`, `Plugin`.`url`, `Plugin`.`icon_class`, `Plugin`.`bootstrap`, `Plugin`.`routes` FROM `moosocial`.`plugins` AS `Plugin` WHERE `Plugin`.`key` = 'UploadVideo' ORDER BY `Plugin`.`weight` asc LIMIT 1 | | 1 | 1 | 1 |
| 16 | SELECT `CoreMenuItem`.`id`, `CoreMenuItem`.`parent_id`, `CoreMenuItem`.`lft`, `CoreMenuItem`.`rght`, `CoreMenuItem`.`name`, `CoreMenuItem`.`original_name`, `CoreMenuItem`.`url`, `CoreMenuItem`.`title_attribute`, `CoreMenuItem`.`font_class`, `CoreMenuItem`.`is_active`, `CoreMenuItem`.`new_blank`, `CoreMenuItem`.`role_access`, `CoreMenuItem`.`menu_id`, `CoreMenuItem`.`type`, `CoreMenuItem`.`menu_order`, `CoreMenuItem`.`plugin`, `CoreMenuItem`.`group`, `CoreMenuItem`.`url_app`, `CoreMenuItem`.`font_class_app`, `CoreMenuItem`.`show_web`, `CoreMenuItem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `CoreMenuItem__i18n_nameMenuTranslation` FROM `moosocial`.`core_menu_items` AS `CoreMenuItem` INNER JOIN `moosocial`.`i18n` AS `I18n__nameMenuTranslation` ON (`CoreMenuItem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `CoreMenuItem`.`url` = '/usersmember_login' LIMIT 1 | | 0 | 0 | 25 |
| 17 | SELECT COUNT(DISTINCT(`OidcProvider`.`id`)) AS count FROM `moosocial`.`oidc_providers` AS `OidcProvider` INNER JOIN `moosocial`.`i18n` AS `I18nModel` ON (`OidcProvider`.`id` = `I18nModel`.`foreign_key` AND `I18nModel`.`model` = 'OidcProvider' AND `I18nModel`.`locale` = 'eng') WHERE `OidcProvider`.`status` = '1' | | 1 | 1 | 1 |
| 18 | SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `moosocial`.`themes` AS `Theme` WHERE `Theme`.`key` = 'playerforum' LIMIT 1 | | 1 | 1 | 1 |
| 19 | SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `moosocial`.`themes` AS `Theme` WHERE `Theme`.`key` = 'playerforum' LIMIT 1 | | 1 | 1 | 1 |
| 20 | SELECT `Setting`.`id`, `Setting`.`group_id`, `Setting`.`label`, `Setting`.`name`, `Setting`.`field`, `Setting`.`value`, `Setting`.`is_hidden`, `Setting`.`version_id`, `Setting`.`type_id`, `Setting`.`value_actual`, `Setting`.`value_default`, `Setting`.`description`, `Setting`.`ordering`, `Setting`.`is_boot`, `SettingGroup`.`id`, `SettingGroup`.`parent_id`, `SettingGroup`.`lft`, `SettingGroup`.`rght`, `SettingGroup`.`group_type`, `SettingGroup`.`module_id`, `SettingGroup`.`name` FROM `moosocial`.`settings` AS `Setting` LEFT JOIN `moosocial`.`setting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1 | | 1 | 1 | 1 |
| 21 | SELECT `Setting`.`id`, `Setting`.`group_id`, `Setting`.`label`, `Setting`.`name`, `Setting`.`field`, `Setting`.`value`, `Setting`.`is_hidden`, `Setting`.`version_id`, `Setting`.`type_id`, `Setting`.`value_actual`, `Setting`.`value_default`, `Setting`.`description`, `Setting`.`ordering`, `Setting`.`is_boot`, `SettingGroup`.`id`, `SettingGroup`.`parent_id`, `SettingGroup`.`lft`, `SettingGroup`.`rght`, `SettingGroup`.`group_type`, `SettingGroup`.`module_id`, `SettingGroup`.`name` FROM `moosocial`.`settings` AS `Setting` LEFT JOIN `moosocial`.`setting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1 | | 1 | 1 | 1 |
| 22 | SELECT `Coremenu`.`id`, `Coremenu`.`name`, `Coremenu`.`style`, `Coremenu`.`alias`, `Coremenu`.`menuid` FROM `moosocial`.`core_menus` AS `Coremenu` WHERE `alias` = 'landing-menu' LIMIT 1 | | 1 | 1 | 0 |
| 23 | SELECT `CoreMenuItem`.`id`, `CoreMenuItem`.`parent_id`, `CoreMenuItem`.`lft`, `CoreMenuItem`.`rght`, `CoreMenuItem`.`name`, `CoreMenuItem`.`original_name`, `CoreMenuItem`.`url`, `CoreMenuItem`.`title_attribute`, `CoreMenuItem`.`font_class`, `CoreMenuItem`.`is_active`, `CoreMenuItem`.`new_blank`, `CoreMenuItem`.`role_access`, `CoreMenuItem`.`menu_id`, `CoreMenuItem`.`type`, `CoreMenuItem`.`menu_order`, `CoreMenuItem`.`plugin`, `CoreMenuItem`.`group`, `CoreMenuItem`.`url_app`, `CoreMenuItem`.`font_class_app`, `CoreMenuItem`.`show_web`, `CoreMenuItem`.`show_app` FROM `moosocial`.`core_menu_items` AS `CoreMenuItem` WHERE `CoreMenuItem`.`is_active` = '1' AND `CoreMenuItem`.`menu_id` = (3) ORDER BY `CoreMenuItem`.`menu_order` ASC | | 3 | 3 | 1 |
| 24 | SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `moosocial`.`i18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (39, 37, 40) ORDER BY `id` ASC | | 3 | 3 | 1 |
| 25 | SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `moosocial`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moosocial`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 39 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 1 |
| 26 | SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `moosocial`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moosocial`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 37 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 2 |
| 27 | SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `moosocial`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moosocial`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 40 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 1 |
| 28 | SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `moosocial`.`themes` AS `Theme` WHERE `Theme`.`key` = 'playerforum' LIMIT 1 | | 1 | 1 | 1 |
| 29 | SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `moosocial`.`themes` AS `Theme` WHERE `Theme`.`key` = 'playerforum' LIMIT 1 | | 1 | 1 | 1 |
