| 1 | SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`user_id` FROM `travel_moosocial`.`qccake_sessions` AS `Session` WHERE `Session`.`id` = '500233b27495be17950238a8235aa1aa' LIMIT 1 | | 1 | 1 | 0 |
| 2 | SELECT `Forum`.`id`, `Forum`.`name`, `Forum`.`description`, `Forum`.`count_view`, `Forum`.`count_topic`, `Forum`.`count_reply`, `Forum`.`parent_id`, `Forum`.`created`, `Forum`.`modified`, `Forum`.`thumb`, `Forum`.`permission`, `Forum`.`moderator`, `Forum`.`status`, `Forum`.`last_topic_id`, `Forum`.`category_id`, `Forum`.`order`, `ForumCategory`.`id`, `ForumCategory`.`name`, `ForumCategory`.`thumb`, `ForumCategory`.`order` FROM `travel_moosocial`.`qcforums` AS `Forum` LEFT JOIN `travel_moosocial`.`qcforum_categories` AS `ForumCategory` ON (`Forum`.`category_id` = `ForumCategory`.`id`) WHERE `Forum`.`id` = 12 LIMIT 1 | | 1 | 1 | 1 |
| 3 | SELECT `ForumTopic`.`id`, `ForumTopic`.`title`, `ForumTopic`.`description`, `ForumTopic`.`search_desc`, `ForumTopic`.`count_view`, `ForumTopic`.`count_reply`, `ForumTopic`.`count_user`, `ForumTopic`.`count_thank`, `ForumTopic`.`parent_id`, `ForumTopic`.`forum_id`, `ForumTopic`.`user_id`, `ForumTopic`.`thumb`, `ForumTopic`.`status`, `ForumTopic`.`last_reply_id`, `ForumTopic`.`created`, `ForumTopic`.`modified`, `ForumTopic`.`ping`, `ForumTopic`.`ping_expire`, `ForumTopic`.`sort_date`, `ForumTopic`.`user_edited`, `LastPost`.`id`, `LastPost`.`title`, `LastPost`.`description`, `LastPost`.`search_desc`, `LastPost`.`count_view`, `LastPost`.`count_reply`, `LastPost`.`count_user`, `LastPost`.`count_thank`, `LastPost`.`parent_id`, `LastPost`.`forum_id`, `LastPost`.`user_id`, `LastPost`.`thumb`, `LastPost`.`status`, `LastPost`.`last_reply_id`, `LastPost`.`created`, `LastPost`.`modified`, `LastPost`.`ping`, `LastPost`.`ping_expire`, `LastPost`.`sort_date`, `LastPost`.`user_edited`, `Forum`.`id`, `Forum`.`name`, `Forum`.`description`, `Forum`.`count_view`, `Forum`.`count_topic`, `Forum`.`count_reply`, `Forum`.`parent_id`, `Forum`.`created`, `Forum`.`modified`, `Forum`.`thumb`, `Forum`.`permission`, `Forum`.`moderator`, `Forum`.`status`, `Forum`.`last_topic_id`, `Forum`.`category_id`, `Forum`.`order`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`group_count`, `User`.`event_count`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`lock_delete` FROM `travel_moosocial`.`qcforum_topics` AS `ForumTopic` LEFT JOIN `travel_moosocial`.`qcforum_topics` AS `LastPost` ON (`ForumTopic`.`last_reply_id` = `LastPost`.`id`) LEFT JOIN `travel_moosocial`.`qcforums` AS `Forum` ON (`ForumTopic`.`forum_id` = `Forum`.`id`) LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`ForumTopic`.`user_id` = `User`.`id`) WHERE `ForumTopic`.`parent_id` = 0 AND `ForumTopic`.`forum_id` = 12 ORDER BY `ForumTopic`.`ping` desc, `ForumTopic`.`sort_date` desc, `ForumTopic`.`id` desc LIMIT 20 | | 1 | 1 | 1 |
| 4 | SELECT `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, (`I18n__nameTranslation`.`content`) AS `ProfileType__i18n_nameTranslation` FROM `travel_moosocial`.`qcprofile_types` AS `ProfileType` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ProfileType`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ProfileType' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ProfileType`.`id` IN (1, 'eng') AND `ProfileType`.`actived` = '1' ORDER BY `ProfileType`.`order` asc | | 1 | 1 | 1 |
| 5 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ProfileType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | | 3 | 3 | 0 |
| 6 | SELECT `Forum`.`id`, `Forum`.`name`, `Forum`.`description`, `Forum`.`count_view`, `Forum`.`count_topic`, `Forum`.`count_reply`, `Forum`.`parent_id`, `Forum`.`created`, `Forum`.`modified`, `Forum`.`thumb`, `Forum`.`permission`, `Forum`.`moderator`, `Forum`.`status`, `Forum`.`last_topic_id`, `Forum`.`category_id`, `Forum`.`order`, `ForumCategory`.`id`, `ForumCategory`.`name`, `ForumCategory`.`thumb`, `ForumCategory`.`order` FROM `travel_moosocial`.`qcforums` AS `Forum` LEFT JOIN `travel_moosocial`.`qcforum_categories` AS `ForumCategory` ON (`Forum`.`category_id` = `ForumCategory`.`id`) WHERE `parent_id` = 12 ORDER BY `Forum`.`order` asc | | 0 | 0 | 0 |
| 7 | SELECT `ForumTopic`.`id`, `ForumTopic`.`title`, `ForumTopic`.`description`, `ForumTopic`.`search_desc`, `ForumTopic`.`count_view`, `ForumTopic`.`count_reply`, `ForumTopic`.`count_user`, `ForumTopic`.`count_thank`, `ForumTopic`.`parent_id`, `ForumTopic`.`forum_id`, `ForumTopic`.`user_id`, `ForumTopic`.`thumb`, `ForumTopic`.`status`, `ForumTopic`.`last_reply_id`, `ForumTopic`.`created`, `ForumTopic`.`modified`, `ForumTopic`.`ping`, `ForumTopic`.`ping_expire`, `ForumTopic`.`sort_date`, `ForumTopic`.`user_edited`, `LastPost`.`id`, `LastPost`.`title`, `LastPost`.`description`, `LastPost`.`search_desc`, `LastPost`.`count_view`, `LastPost`.`count_reply`, `LastPost`.`count_user`, `LastPost`.`count_thank`, `LastPost`.`parent_id`, `LastPost`.`forum_id`, `LastPost`.`user_id`, `LastPost`.`thumb`, `LastPost`.`status`, `LastPost`.`last_reply_id`, `LastPost`.`created`, `LastPost`.`modified`, `LastPost`.`ping`, `LastPost`.`ping_expire`, `LastPost`.`sort_date`, `LastPost`.`user_edited`, `Forum`.`id`, `Forum`.`name`, `Forum`.`description`, `Forum`.`count_view`, `Forum`.`count_topic`, `Forum`.`count_reply`, `Forum`.`parent_id`, `Forum`.`created`, `Forum`.`modified`, `Forum`.`thumb`, `Forum`.`permission`, `Forum`.`moderator`, `Forum`.`status`, `Forum`.`last_topic_id`, `Forum`.`category_id`, `Forum`.`order`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`group_count`, `User`.`event_count`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`lock_delete` FROM `travel_moosocial`.`qcforum_topics` AS `ForumTopic` LEFT JOIN `travel_moosocial`.`qcforum_topics` AS `LastPost` ON (`ForumTopic`.`last_reply_id` = `LastPost`.`id`) LEFT JOIN `travel_moosocial`.`qcforums` AS `Forum` ON (`ForumTopic`.`forum_id` = `Forum`.`id`) LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`ForumTopic`.`user_id` = `User`.`id`) WHERE `ForumTopic`.`id` = 5 ORDER BY `ForumTopic`.`ping` desc, `ForumTopic`.`sort_date` desc, `ForumTopic`.`id` desc LIMIT 1 | | 1 | 1 | 1 |
| 8 | SELECT `ForumSubscribe`.`id`, `ForumSubscribe`.`target_id`, `ForumSubscribe`.`user_id`, `ForumSubscribe`.`type` FROM `travel_moosocial`.`qcforum_subscribes` AS `ForumSubscribe` WHERE `ForumSubscribe`.`user_id` IS NULL AND `ForumSubscribe`.`target_id` = 12 AND `ForumSubscribe`.`type` = 'Forum' LIMIT 1 | | 0 | 0 | 0 |
| 9 | SELECT `Coremenu`.`id`, `Coremenu`.`name`, `Coremenu`.`style`, `Coremenu`.`alias`, `Coremenu`.`menuid` FROM `travel_moosocial`.`qccore_menus` AS `Coremenu` WHERE `id` = 2 LIMIT 1 | | 1 | 1 | 0 |
| 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` FROM `travel_moosocial`.`qccore_menu_items` AS `CoreMenuItem` WHERE `CoreMenuItem`.`is_active` = '1' AND `CoreMenuItem`.`menu_id` = (2) ORDER BY `CoreMenuItem`.`menu_order` ASC | | 4 | 4 | 0 |
| 11 | SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (9, 11, 12, 17) ORDER BY `id` ASC | | 12 | 12 | 1 |
| 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 `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` 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 `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 `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` 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 |
| 14 | 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 `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` 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 | 0 |
| 15 | 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 `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` 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` = 17 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
| 16 | SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`group_count`, `User`.`event_count`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`lock_delete`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `travel_moosocial`.`qcusers` AS `User` LEFT JOIN `travel_moosocial`.`qcroles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `User`.`id` = 1 LIMIT 1 | | 1 | 1 | 1 |
| 17 | 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 `travel_moosocial`.`qcthemes` AS `Theme` WHERE `Theme`.`key` = 'classic' LIMIT 1 | | 1 | 1 | 0 |
| 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 `travel_moosocial`.`qcthemes` AS `Theme` WHERE `Theme`.`key` = 'classic' LIMIT 1 | | 1 | 1 | 0 |
| 19 | 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 `travel_moosocial`.`qcsettings` AS `Setting` LEFT JOIN `travel_moosocial`.`qcsetting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1 | | 1 | 1 | 1 |
| 20 | 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 `travel_moosocial`.`qcthemes` AS `Theme` WHERE `Theme`.`key` = 'classic' LIMIT 1 | | 1 | 1 | 0 |
| 21 | 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 `travel_moosocial`.`qcthemes` AS `Theme` WHERE `Theme`.`key` = 'classic' LIMIT 1 | | 1 | 1 | 0 |
admin
