| 1 | SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`user_id` FROM `travel_moosocial`.`qccake_sessions` AS `Session` WHERE `Session`.`id` = '8559bed149d4d06d7df5d07b4e942fc9' LIMIT 1 | | 1 | 1 | 2 |
| 2 | SELECT `Page`.`id`, `Page`.`title`, `Page`.`alias`, `Page`.`content`, `Page`.`permission`, `Page`.`params`, `Page`.`created`, `Page`.`modified`, `Page`.`menu`, `Page`.`icon_class`, `Page`.`weight`, `Page`.`url`, `Page`.`uri`, `Page`.`description`, `Page`.`keywords`, `Page`.`custom`, `Page`.`fragment`, `Page`.`layout`, `Page`.`levels`, `Page`.`provides`, `Page`.`view_count`, `Page`.`type`, `Page`.`search`, `Page`.`theme_id`, `Page`.`core_content_count`, `Page`.`plugin`, `Page`.`show_layout`, (`I18n__titleTranslation`.`content`) AS `Page__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Page__i18n_contentTranslation`, `MyCoreTheme`.`id`, `MyCoreTheme`.`key`, `MyCoreTheme`.`name`, `MyCoreTheme`.`core`, `MyCoreTheme`.`custom_css_enable`, `MyCoreTheme`.`custom_css_landing`, `MyCoreTheme`.`custom_css`, `MyCoreTheme`.`custom_css_dark` FROM `travel_moosocial`.`qcpages` AS `Page` LEFT JOIN `travel_moosocial`.`qcthemes` AS `MyCoreTheme` ON (`Page`.`theme_id` = `MyCoreTheme`.`id`) INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__titleTranslation` ON (`Page`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Page' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__contentTranslation` ON (`Page`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Page' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Page`.`uri` = 'search.hashtags' ORDER BY `Page`.`weight` asc LIMIT 1 | | 0 | 0 | 8 |
| 3 | SELECT `Hashtag`.`id`, `Hashtag`.`item_id`, `Hashtag`.`item_table`, `Hashtag`.`hashtags`, `Hashtag`.`created`, `Hashtag`.`modified` FROM `travel_moosocial`.`qchashtags` AS `Hashtag` WHERE `hashtags` LIKE '%one%' | | 7 | 7 | 1 |
| 4 | SELECT `HashTag`.`item_id` FROM `travel_moosocial`.`qchashtags` AS `HashTag` WHERE `HashTag`.`item_table` = 'businesses' AND FIND_IN_SET("one", REPLACE(`HashTag`.`hashtags`, " ", "")) | | 0 | 0 | 3 |
| 5 | SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated`, `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`.`qcbusinesses` AS `Business` LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`Business`.`user_id` = `User`.`id`) WHERE `Business`.`id` IS NULL LIMIT 12 | | 0 | 0 | 1 |
| 6 | SELECT `Tag`.`id`, `Tag`.`target_id`, `Tag`.`type`, `Tag`.`tag`, `Tag`.`created` FROM `travel_moosocial`.`qctags` AS `Tag` WHERE `Tag`.`type` = 'Classified_Classified' AND `Tag`.`tag` = 'one' | | 1 | 1 | 3 |
| 7 | SELECT Classified.*, User.*,ClassifiedCategory.*,( 3959 * acos( cos( radians(0) ) * cos( radians( Classified.lat ) )
* cos( radians(Classified.lng) - radians(0)) + sin(radians(0))
* sin( radians(Classified.lat)))) AS distance, `Classified`.`id` FROM `travel_moosocial`.`qcclassifieds` AS `Classified` LEFT JOIN `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` ON (`Classified`.`classified_category_id` = `ClassifiedCategory`.`id`) LEFT JOIN `travel_moosocial`.`qcclassified_brands` AS `ClassifiedBrand` ON (`Classified`.`classified_brand_id` = `ClassifiedBrand`.`id`) LEFT JOIN `travel_moosocial`.`qcclassified_packages` AS `ClassifiedPackage` ON (`Classified`.`classified_package_id` = `ClassifiedPackage`.`id`) LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`Classified`.`user_id` = `User`.`id`) WHERE `Classified`.`status` = 1 AND `Classified`.`privacy` = 1 AND `Classified`.`id` = (1) ORDER BY `Classified`.`id` DESC LIMIT 12 | | 1 | 1 | 2 |
| 8 | 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 |
| 9 | 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 | 1 |
| 10 | SELECT COUNT(*) AS `count` FROM `travel_moosocial`.`qcclassifieds` AS `Classified` LEFT JOIN `travel_moosocial`.`qcclassified_categories` AS `ClassifiedCategory` ON (`Classified`.`classified_category_id` = `ClassifiedCategory`.`id`) LEFT JOIN `travel_moosocial`.`qcclassified_brands` AS `ClassifiedBrand` ON (`Classified`.`classified_brand_id` = `ClassifiedBrand`.`id`) LEFT JOIN `travel_moosocial`.`qcclassified_packages` AS `ClassifiedPackage` ON (`Classified`.`classified_package_id` = `ClassifiedPackage`.`id`) LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`Classified`.`user_id` = `User`.`id`) WHERE `Classified`.`status` = 1 AND `Classified`.`privacy` = 1 AND `Classified`.`id` = (1) | | 1 | 1 | 0 |
| 11 | SELECT `Tag`.`id`, `Tag`.`target_id`, `Tag`.`type`, `Tag`.`tag`, `Tag`.`created` FROM `travel_moosocial`.`qctags` AS `Tag` WHERE `Tag`.`type` = 'Forum_Forum_Topic' AND `Tag`.`tag` = 'one' | | 0 | 0 | 1 |
| 12 | 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` IS NULL ORDER BY `ForumTopic`.`ping` desc, `ForumTopic`.`sort_date` desc, `ForumTopic`.`id` desc LIMIT 12 | | 0 | 0 | 3 |
| 13 | SELECT `Tag`.`id`, `Tag`.`target_id`, `Tag`.`type`, `Tag`.`tag`, `Tag`.`created` FROM `travel_moosocial`.`qctags` AS `Tag` WHERE `Tag`.`type` = 'Poll_Poll' AND `Tag`.`tag` = 'one' | | 1 | 1 | 0 |
| 14 | SELECT `Poll`.`id`, `Poll`.`title`, `Poll`.`created`, `Poll`.`user_id`, `Poll`.`modified`, `Poll`.`like_count`, `Poll`.`comment_count`, `Poll`.`dislike_count`, `Poll`.`privacy`, `Poll`.`create_new_answer`, `Poll`.`visiable`, `Poll`.`category_id`, `Poll`.`thumbnail`, `Poll`.`type`, `Poll`.`answer_count`, `Poll`.`share_count`, `Poll`.`feature`, `Poll`.`close`, `Poll`.`date_close`, `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`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission` FROM `travel_moosocial`.`qcpolls` AS `Poll` LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`Poll`.`user_id` = `User`.`id`) LEFT JOIN `travel_moosocial`.`qccategories` AS `Category` ON (`Poll`.`category_id` = `Category`.`id`) WHERE `visiable` = '1' AND `Poll`.`privacy` = 1 AND `Poll`.`id` = (7) ORDER BY `Poll`.`id` desc LIMIT 10 | | 1 | 1 | 1 |
| 15 | SELECT `Tag`.`id`, `Tag`.`target_id`, `Tag`.`type`, `Tag`.`tag`, `Tag`.`created` FROM `travel_moosocial`.`qctags` AS `Tag` WHERE `Tag`.`type` = 'Blog_Blog' AND `Tag`.`tag` = 'one' | | 0 | 0 | 0 |
| 16 | SELECT `Blog`.`id`, `Blog`.`user_id`, `Blog`.`title`, `Blog`.`body`, `Blog`.`thumbnail`, `Blog`.`created`, `Blog`.`like_count`, `Blog`.`privacy`, `Blog`.`comment_count`, `Blog`.`dislike_count`, `Blog`.`share_count`, `Blog`.`category_id`, `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`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission` FROM `travel_moosocial`.`qcblogs` AS `Blog` LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`Blog`.`user_id` = `User`.`id`) LEFT JOIN `travel_moosocial`.`qccategories` AS `Category` ON (`Blog`.`category_id` = `Category`.`id`) WHERE `Blog`.`id` IS NULL ORDER BY `Blog`.`id` desc LIMIT 12 | | 0 | 0 | 1 |
| 17 | SELECT `Tag`.`id`, `Tag`.`target_id`, `Tag`.`type`, `Tag`.`tag`, `Tag`.`created` FROM `travel_moosocial`.`qctags` AS `Tag` WHERE `Tag`.`type` = 'Photo_Album' AND `Tag`.`tag` = 'one' | | 0 | 0 | 0 |
| 18 | SELECT `Album`.`id`, `Album`.`user_id`, `Album`.`category_id`, `Album`.`title`, `Album`.`description`, `Album`.`created`, `Album`.`photo_count`, `Album`.`cover`, `Album`.`modified`, `Album`.`like_count`, `Album`.`dislike_count`, `Album`.`privacy`, `Album`.`type`, `Album`.`comment_count`, `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`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission` FROM `travel_moosocial`.`qcalbums` AS `Album` LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`Album`.`user_id` = `User`.`id`) LEFT JOIN `travel_moosocial`.`qccategories` AS `Category` ON (`Album`.`category_id` = `Category`.`id`) WHERE `Album`.`id` IS NULL AND `Album`.`photo_count` > 0 ORDER BY `Album`.`id` desc LIMIT 12 | | 0 | 0 | 1 |
| 19 | SELECT `Tag`.`id`, `Tag`.`target_id`, `Tag`.`type`, `Tag`.`tag`, `Tag`.`created` FROM `travel_moosocial`.`qctags` AS `Tag` WHERE `Tag`.`type` = 'Video_Video' AND `Tag`.`tag` = 'one' | | 0 | 0 | 0 |
| 20 | SELECT `Video`.`id`, `Video`.`user_id`, `Video`.`category_id`, `Video`.`title`, `Video`.`description`, `Video`.`thumb`, `Video`.`in_process`, `Video`.`destination`, `Video`.`pc_upload`, `Video`.`source`, `Video`.`source_id`, `Video`.`like_count`, `Video`.`dislike_count`, `Video`.`created`, `Video`.`privacy`, `Video`.`group_id`, `Video`.`comment_count`, `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`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission`, `Group`.`id`, `Group`.`category_id`, `Group`.`name`, `Group`.`user_id`, `Group`.`description`, `Group`.`type`, `Group`.`photo`, `Group`.`group_user_count`, `Group`.`created`, `Group`.`photo_count`, `Group`.`topic_count`, `Group`.`video_count`, `Group`.`event_count`, `Group`.`featured` FROM `travel_moosocial`.`qcvideos` AS `Video` LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`Video`.`user_id` = `User`.`id`) LEFT JOIN `travel_moosocial`.`qccategories` AS `Category` ON (`Video`.`category_id` = `Category`.`id`) LEFT JOIN `travel_moosocial`.`qcgroups` AS `Group` ON (`Video`.`group_id` = `Group`.`id`) WHERE `Video`.`id` IS NULL ORDER BY `Video`.`id` desc LIMIT 12 | | 0 | 0 | 83 |
| 21 | SELECT `Tag`.`id`, `Tag`.`target_id`, `Tag`.`type`, `Tag`.`tag`, `Tag`.`created` FROM `travel_moosocial`.`qctags` AS `Tag` WHERE `Tag`.`type` = 'Event_Event' AND `Tag`.`tag` = 'one' | | 0 | 0 | 0 |
| 22 | SELECT `Event`.`id`, `Event`.`category_id`, `Event`.`title`, `Event`.`description`, `Event`.`user_id`, `Event`.`location`, `Event`.`from`, `Event`.`from_time`, `Event`.`from_datetime`, `Event`.`to`, `Event`.`to_time`, `Event`.`to_datetime`, `Event`.`created`, `Event`.`type`, `Event`.`photo`, `Event`.`event_rsvp_count`, `Event`.`address`, `Event`.`timezone`, `Event`.`reminder`, `Event`.`reminder_status`, `Event`.`group_id`, `Event`.`country_id`, `Event`.`state_id`, `Event`.`city_id`, `Event`.`zip`, `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`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission`, `Country`.`id`, `Country`.`name`, `Country`.`country_iso`, `Country`.`state_count`, `Country`.`order`, `Country`.`enable`, `State`.`id`, `State`.`name`, `State`.`state_code`, `State`.`country_id`, `State`.`order`, `State`.`enable`, `State`.`city_count`, `City`.`id`, `City`.`name`, `City`.`city_code`, `City`.`country_id`, `City`.`order`, `City`.`enable`, `City`.`state_id`, `Group`.`id`, `Group`.`category_id`, `Group`.`name`, `Group`.`user_id`, `Group`.`description`, `Group`.`type`, `Group`.`photo`, `Group`.`group_user_count`, `Group`.`created`, `Group`.`photo_count`, `Group`.`topic_count`, `Group`.`video_count`, `Group`.`event_count`, `Group`.`featured` FROM `travel_moosocial`.`qcevents` AS `Event` LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`Event`.`user_id` = `User`.`id`) LEFT JOIN `travel_moosocial`.`qccategories` AS `Category` ON (`Event`.`category_id` = `Category`.`id`) LEFT JOIN `travel_moosocial`.`qccountries` AS `Country` ON (`Event`.`country_id` = `Country`.`id`) LEFT JOIN `travel_moosocial`.`qcstates` AS `State` ON (`Event`.`state_id` = `State`.`id`) LEFT JOIN `travel_moosocial`.`qccities` AS `City` ON (`Event`.`city_id` = `City`.`id`) LEFT JOIN `travel_moosocial`.`qcgroups` AS `Group` ON (`Event`.`group_id` = `Group`.`id`) WHERE `Event`.`id` IS NULL ORDER BY `Event`.`from` asc LIMIT 12 | | 0 | 0 | 2 |
| 23 | SELECT `Tag`.`id`, `Tag`.`target_id`, `Tag`.`type`, `Tag`.`tag`, `Tag`.`created` FROM `travel_moosocial`.`qctags` AS `Tag` WHERE `Tag`.`type` = 'Topic_Topic' AND `Tag`.`tag` = 'one' | | 0 | 0 | 0 |
| 24 | SELECT `Topic`.`id`, `Topic`.`category_id`, `Topic`.`user_id`, `Topic`.`title`, `Topic`.`body`, `Topic`.`thumbnail`, `Topic`.`created`, `Topic`.`last_post`, `Topic`.`comment_count`, `Topic`.`lastposter_id`, `Topic`.`like_count`, `Topic`.`group_id`, `Topic`.`pinned`, `Topic`.`attachment`, `Topic`.`dislike_count`, `Topic`.`locked`, `Topic`.`share_count`, `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`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission`, `LastPoster`.`id`, `LastPoster`.`name`, `LastPoster`.`email`, `LastPoster`.`password`, `LastPoster`.`salt`, `LastPoster`.`role_id`, `LastPoster`.`avatar`, `LastPoster`.`photo`, `LastPoster`.`created`, `LastPoster`.`last_login`, `LastPoster`.`photo_count`, `LastPoster`.`friend_count`, `LastPoster`.`notification_count`, `LastPoster`.`friend_request_count`, `LastPoster`.`blog_count`, `LastPoster`.`topic_count`, `LastPoster`.`conversation_user_count`, `LastPoster`.`video_count`, `LastPoster`.`gender`, `LastPoster`.`birthday`, `LastPoster`.`active`, `LastPoster`.`confirmed`, `LastPoster`.`code`, `LastPoster`.`expired_time_code`, `LastPoster`.`notification_email`, `LastPoster`.`timezone`, `LastPoster`.`ip_address`, `LastPoster`.`privacy`, `LastPoster`.`username`, `LastPoster`.`about`, `LastPoster`.`featured`, `LastPoster`.`lang`, `LastPoster`.`hide_online`, `LastPoster`.`cover`, `LastPoster`.`approved`, `LastPoster`.`is_social`, `LastPoster`.`has_active_subscription`, `LastPoster`.`group_count`, `LastPoster`.`event_count`, `LastPoster`.`receive_message_from_non_friend`, `LastPoster`.`send_email_when_send_message`, `LastPoster`.`request_friend_email`, `LastPoster`.`notification_setting`, `LastPoster`.`profile_type_id`, `LastPoster`.`package_select`, `LastPoster`.`who_can_see_gender`, `LastPoster`.`darkmode`, `LastPoster`.`signature`, `LastPoster`.`show_signature`, `LastPoster`.`chat_count`, `LastPoster`.`chat_privacy`, `LastPoster`.`lock_delete`, `Group`.`id`, `Group`.`category_id`, `Group`.`name`, `Group`.`user_id`, `Group`.`description`, `Group`.`type`, `Group`.`photo`, `Group`.`group_user_count`, `Group`.`created`, `Group`.`photo_count`, `Group`.`topic_count`, `Group`.`video_count`, `Group`.`event_count`, `Group`.`featured` FROM `travel_moosocial`.`qctopics` AS `Topic` LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`Topic`.`user_id` = `User`.`id`) LEFT JOIN `travel_moosocial`.`qccategories` AS `Category` ON (`Topic`.`category_id` = `Category`.`id`) LEFT JOIN `travel_moosocial`.`qcusers` AS `LastPoster` ON (`Topic`.`lastposter_id` = `LastPoster`.`id`) LEFT JOIN `travel_moosocial`.`qcgroups` AS `Group` ON (`Topic`.`group_id` = `Group`.`id`) WHERE `Topic`.`id` IS NULL ORDER BY `Topic`.`last_post` desc LIMIT 12 | | 0 | 0 | 1 |
| 25 | SELECT `Tag`.`id`, `Tag`.`target_id`, `Tag`.`type`, `Tag`.`tag`, `Tag`.`created` FROM `travel_moosocial`.`qctags` AS `Tag` WHERE `Tag`.`type` = 'Group_Group' AND `Tag`.`tag` = 'one' | | 0 | 0 | 0 |
| 26 | SELECT `Group`.`id`, `Group`.`category_id`, `Group`.`name`, `Group`.`user_id`, `Group`.`description`, `Group`.`type`, `Group`.`photo`, `Group`.`group_user_count`, `Group`.`created`, `Group`.`photo_count`, `Group`.`topic_count`, `Group`.`video_count`, `Group`.`event_count`, `Group`.`featured`, `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`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission` FROM `travel_moosocial`.`qcgroups` AS `Group` LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`Group`.`user_id` = `User`.`id`) LEFT JOIN `travel_moosocial`.`qccategories` AS `Category` ON (`Group`.`category_id` = `Category`.`id`) WHERE `Group`.`id` IS NULL LIMIT 12 | | 0 | 0 | 1 |
| 27 | SELECT `Friend`.`id`, `Friend`.`friend_id` FROM `travel_moosocial`.`qcfriends` AS `Friend` WHERE `Friend`.`user_id` = '' | | 0 | 0 | 0 |
| 28 | SELECT `EventRsvp`.`id`, `EventRsvp`.`event_id` FROM `travel_moosocial`.`qcevent_rsvps` AS `EventRsvp` LEFT JOIN `travel_moosocial`.`qcevents` AS `Event` ON (`EventRsvp`.`event_id` = `Event`.`id`) LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`EventRsvp`.`user_id` = `User`.`id`) WHERE `EventRsvp`.`user_id` = '' AND `EventRsvp`.`rsvp` IN (1, 3) ORDER BY `EventRsvp`.`id` desc | | 0 | 0 | 1 |
| 29 | SELECT `GroupUser`.`id`, `GroupUser`.`group_id` FROM `travel_moosocial`.`qcgroup_users` AS `GroupUser` WHERE `GroupUser`.`user_id` = '' AND (`GroupUser`.`status` = 1 OR `GroupUser`.`status` = 3) | | 0 | 0 | 2 |
| 30 | SELECT `UserSettingFeed`.`id`, `UserSettingFeed`.`type`, `UserSettingFeed`.`active`, `UserSettingFeed`.`text`, `UserSettingFeed`.`plugin` FROM `travel_moosocial`.`qcuser_setting_feeds` AS `UserSettingFeed` WHERE `active` = '0' | | 0 | 0 | 0 |
| 31 | SELECT *, `Activity`.`id` FROM `travel_moosocial`.`qcactivities` AS `Activity` LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`Activity`.`user_id` = `User`.`id`) LEFT JOIN `travel_moosocial`.`qcuser_taggings` AS `UserTagging` ON (`Activity`.`id` = `UserTagging`.`item_id` AND `UserTagging`.`item_table` = 'activities') WHERE ((((`Activity`.`type` = 'user') AND (`Activity`.`privacy` = 1))) OR (((`Activity`.`type` = 'user') AND (`Activity`.`user_id` IS NULL) AND (`Activity`.`privacy` <> 3))) OR (`Activity`.`type` = 'Business_Business') OR (((`Activity`.`type` = 'Event_Event') AND (`Activity`.`target_id` = (0)))) OR (((`Activity`.`type` = 'Group_Group') AND (`Activity`.`action` = 'group_join'))) OR (((`Activity`.`type` = 'Group_Group') AND (`Activity`.`target_id` = (0))))) AND `Activity`.`Plugin` IN ('AiChatbot', 'AiProvider', 'Api', 'Billing', 'Blog', 'Bookmark', 'Business', 'Classified', 'Credit', 'Cron', 'Event', 'Forum', 'GifComment', 'Group', 'Mail', 'Menu', 'Message', 'Minify', 'MooApp', 'MooUpload', 'OpenIdConnect', 'Page', 'PaymentGateway', 'PaypalAdaptive', 'PaypalExpress', 'PaypalSdk', 'Photo', 'Poll', 'Pwa', 'Queue', 'Reaction', 'Shoutbox', 'SocialIntegration', 'StatusBackground', 'Sticker', 'Storage', 'Subscription', 'Tools', 'Topic', 'Video', '') AND `Activity`.`status` = 'ok' AND `User`.`active` = '1' AND `Activity`.`id` IS NULL AND `Activity`.`privacy` = 1 ORDER BY `Activity`.`modified` desc LIMIT 12 | | 0 | 0 | 1 |
| 32 | SELECT `Comment`.`id`, `Comment`.`user_id`, `Comment`.`target_id`, `Comment`.`message`, `Comment`.`created`, `Comment`.`type`, `Comment`.`like_count`, `Comment`.`dislike_count`, `Comment`.`thumbnail`, `Comment`.`edited`, `Comment`.`count_reply`, `Comment`.`params`, `Comment`.`sticker_image_id`, `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`.`qccomments` AS `Comment` LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`Comment`.`user_id` = `User`.`id`) WHERE `Comment`.`id` IS NULL AND `Comment`.`type` != 'conversation' ORDER BY `Comment`.`id` desc LIMIT 12 | | 0 | 0 | 1 |
| 33 | SELECT `ActivityComment`.`id`, `ActivityComment`.`user_id`, `ActivityComment`.`activity_id`, `ActivityComment`.`comment`, `ActivityComment`.`like_count`, `ActivityComment`.`dislike_count`, `ActivityComment`.`created`, `ActivityComment`.`thumbnail`, `ActivityComment`.`edited`, `ActivityComment`.`count_reply`, `ActivityComment`.`params`, `ActivityComment`.`sticker_image_id`, `Activity`.`id`, `Activity`.`type`, `Activity`.`target_id`, `Activity`.`user_id`, `Activity`.`action`, `Activity`.`text`, `Activity`.`content`, `Activity`.`items`, `Activity`.`item_type`, `Activity`.`item_id`, `Activity`.`created`, `Activity`.`activity_comment_count`, `Activity`.`query`, `Activity`.`privacy`, `Activity`.`modified`, `Activity`.`params`, `Activity`.`like_count`, `Activity`.`dislike_count`, `Activity`.`plugin`, `Activity`.`edited`, `Activity`.`share`, `Activity`.`parent_id`, `Activity`.`status`, `Activity`.`source_url`, `Activity`.`activity_pin_date`, `Activity`.`activity_pin`, `Activity`.`activity_pin_user_id`, `Activity`.`pin_date`, `Activity`.`pin`, `Activity`.`pin_user_id`, `Activity`.`close_comment`, `Activity`.`close_comment_user`, `Activity`.`business_post_as`, `Activity`.`status_background_id`, `Activity`.`sticker_image_id`, `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`.`qcactivity_comments` AS `ActivityComment` LEFT JOIN `travel_moosocial`.`qcactivities` AS `Activity` ON (`ActivityComment`.`activity_id` = `Activity`.`id`) LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`ActivityComment`.`user_id` = `User`.`id`) WHERE `ActivityComment`.`id` IS NULL ORDER BY `ActivityComment`.`id` asc LIMIT 12 | | 0 | 0 | 1 |
| 34 | 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 |
| 35 | 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 |
| 36 | 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 | 82 |
| 37 | 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 |
| 38 | 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 | 0 |
| 39 | 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 | 1 |
| 40 | 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 |
| 41 | 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 | 1 |
| 42 | 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 | 1 |
| 43 | 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 | 0 |
| 44 | 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 | 3 |
| 45 | 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 | 4 |
