menu
menu
Menu
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | 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 `moo_travel`.`qcsettings` AS `Setting` LEFT JOIN `moo_travel`.`qcsetting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `is_boot` = 0 | 267 | 267 | 1 | |
2 | SELECT `Currency`.`id`, `Currency`.`currency_code`, `Currency`.`symbol`, `Currency`.`name`, `Currency`.`description`, `Currency`.`ordering`, `Currency`.`is_default`, `Currency`.`is_active` FROM `moo_travel`.`qccurrencies` AS `Currency` WHERE `Currency`.`is_default` = '1' LIMIT 1 | 1 | 1 | 0 | |
3 | SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`user_id` FROM `moo_travel`.`qccake_sessions` AS `Session` WHERE `Session`.`id` = 'a9c418fkbihmpkub8lri79e44h' LIMIT 1 | 0 | 0 | 0 | |
4 | SELECT `Language`.`key`, `Language`.`name` FROM `moo_travel`.`qclanguages` AS `Language` WHERE 1 = 1 ORDER BY `Language`.`name` asc | 3 | 3 | 0 | |
5 | SELECT `Language`.`id`, `Language`.`key`, `Language`.`name`, `Language`.`rtl` FROM `moo_travel`.`qclanguages` AS `Language` WHERE 1 = 1 ORDER BY `Language`.`name` asc | 3 | 3 | 0 | |
6 | SELECT `Theme`.`key`, `Theme`.`name` FROM `moo_travel`.`qcthemes` AS `Theme` WHERE 1 = 1 | 1 | 1 | 0 | |
7 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `moo_travel`.`qcroles` AS `Role` WHERE `Role`.`id` = 3 LIMIT 1 | 1 | 1 | 0 | |
8 | 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`.`chat_count`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `moo_travel`.`qcusers` AS `User` LEFT JOIN `moo_travel`.`qcroles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `User`.`id` = 10 LIMIT 1 | 1 | 1 | 1 | |
9 | SELECT `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, (`I18n__nameTranslation`.`content`) AS `ProfileType__i18n_nameTranslation` FROM `moo_travel`.`qcprofile_types` AS `ProfileType` INNER JOIN `moo_travel`.`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 | |
10 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `moo_travel`.`qci18n` AS `nameTranslation` WHERE `model` = 'ProfileType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | 3 | 3 | 1 | |
11 | SELECT `Friend`.`id`, `Friend`.`user_id`, `Friend`.`friend_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`.`chat_count`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature` FROM `moo_travel`.`qcfriends` AS `Friend` LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`Friend`.`friend_id` = `User`.`id`) WHERE `Friend`.`user_id` = 10 AND `User`.`active` = 1 AND NOT (`Friend`.`friend_id` IS NULL) ORDER BY `User`.`name` asc LIMIT 10 | 2 | 2 | 1 | |
12 | SELECT COUNT(*) AS `count` FROM `moo_travel`.`qcalbums` AS `Album` LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`Album`.`user_id` = `User`.`id`) LEFT JOIN `moo_travel`.`qccategories` AS `Category` ON (`Album`.`category_id` = `Category`.`id`) WHERE `Album`.`photo_count` > 0 AND `Album`.`type` = '' AND `Album`.`user_id` = 10 | 1 | 1 | 1 | |
13 | 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`.`chat_count`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission` FROM `moo_travel`.`qcalbums` AS `Album` LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`Album`.`user_id` = `User`.`id`) LEFT JOIN `moo_travel`.`qccategories` AS `Category` ON (`Album`.`category_id` = `Category`.`id`) WHERE `Album`.`user_id` = 10 AND `Album`.`type` = 'profile' ORDER BY `Album`.`id` desc LIMIT 1 | 0 | 0 | 1 | |
14 | 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`.`chat_count`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission` FROM `moo_travel`.`qcalbums` AS `Album` LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`Album`.`user_id` = `User`.`id`) LEFT JOIN `moo_travel`.`qccategories` AS `Category` ON (`Album`.`category_id` = `Category`.`id`) WHERE `Album`.`user_id` = 10 AND `Album`.`type` = 'cover' ORDER BY `Album`.`id` desc LIMIT 1 | 0 | 0 | 1 | |
15 | SELECT DISTINCT user_id FROM qccake_sessions WHERE expires > 1710821804 | 303 | 303 | 1 | |
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`.`chat_count`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `moo_travel`.`qcusers` AS `User` LEFT JOIN `moo_travel`.`qcroles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `User`.`id` = (8) AND `User`.`hide_online` = 0 LIMIT 12 | 1 | 1 | 0 | |
17 | 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`.`chat_count`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission` FROM `moo_travel`.`qcblogs` AS `Blog` LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`Blog`.`user_id` = `User`.`id`) LEFT JOIN `moo_travel`.`qccategories` AS `Category` ON (`Blog`.`category_id` = `Category`.`id`) WHERE `Blog`.`user_id` = 10 AND `Blog`.`privacy` = 1 AND `User`.`active` = 1 ORDER BY `Blog`.`id` desc LIMIT 10 | 0 | 0 | 1 | |
18 | SELECT DISTINCT `Group`.`id`, `Group`.`name`, `Group`.`description`, `Group`.`group_user_count`, `Group`.`photo`, `Group`.`type`, `Group`.`category_id`, `Group`.`user_id` FROM `moo_travel`.`qcgroup_users` AS `GroupUser` LEFT JOIN `moo_travel`.`qcgroups` AS `Group` ON (`GroupUser`.`group_id` = `Group`.`id`) LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`GroupUser`.`user_id` = `User`.`id`) WHERE `GroupUser`.`user_id` = 10 AND (`GroupUser`.`status` = 1 OR `GroupUser`.`status` = 3) AND `Group`.`type` <> 2 ORDER BY `GroupUser`.`id` desc LIMIT 10 | 0 | 0 | 1 | |
19 | 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`.`chat_count`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission` FROM `moo_travel`.`qcvideos` AS `Video` LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`Video`.`user_id` = `User`.`id`) LEFT JOIN `moo_travel`.`qccategories` AS `Category` ON (`Video`.`category_id` = `Category`.`id`) WHERE `Video`.`user_id` = 10 AND `Video`.`group_id` = 0 AND `Video`.`privacy` = 1 AND `Video`.`in_process` = '0' AND `User`.`active` = 1 ORDER BY `Video`.`id` desc LIMIT 10 | 2 | 2 | 39 | |
20 | SELECT `ProfileFieldValue`.`id`, `ProfileFieldValue`.`user_id`, `ProfileFieldValue`.`profile_field_id`, `ProfileFieldValue`.`value`, (`I18n`.`content`) AS `ProfileFieldValue__name`, `ProfileField`.`id`, `ProfileField`.`name`, `ProfileField`.`description`, `ProfileField`.`type`, `ProfileField`.`values`, `ProfileField`.`required`, `ProfileField`.`registration`, `ProfileField`.`searchable`, `ProfileField`.`active`, `ProfileField`.`weight`, `ProfileField`.`profile`, `ProfileField`.`plugin`, `ProfileField`.`profile_type_id`, `ProfileField`.`extra`, `ProfileField`.`hide_from_info_tab`, `ProfileField`.`show_info_tab`, `ProfileField`.`show_in_popup` FROM `moo_travel`.`qcprofile_field_values` AS `ProfileFieldValue` LEFT JOIN `moo_travel`.`qcprofile_fields` AS `ProfileField` ON (`ProfileFieldValue`.`profile_field_id` = `ProfileField`.`id`) INNER JOIN `moo_travel`.`qci18n` AS `I18n` ON (`ProfileFieldValue`.`profile_field_id` = `I18n`.`foreign_key` AND `I18n`.`locale` = 'eng' AND `I18n`.`model` = 'ProfileField') WHERE `ProfileField`.`active` = 1 AND `ProfileFieldValue`.`user_id` = 10 ORDER BY `ProfileField`.`weight` ASC | 0 | 0 | 1 | |
21 | SELECT COUNT(*) AS `count` FROM `moo_travel`.`qcfriends` AS `Friend` WHERE `user_id` = 10 | 1 | 1 | 0 | |
22 | SELECT `UserTagging`.`id`, `UserTagging`.`item_id`, `UserTagging`.`item_table`, `UserTagging`.`users_taggings`, `UserTagging`.`created`, `UserTagging`.`modified` FROM `moo_travel`.`qcuser_taggings` AS `UserTagging` WHERE `UserTagging`.`users_taggings` LIKE "%10%" | 0 | 0 | 1 | |
23 | SELECT COUNT(*) AS `count` FROM `moo_travel`.`qcfriends` AS `Friend` LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`Friend`.`user_id` = `User`.`id`) WHERE `Friend`.`user_id` = 10 AND `Friend`.`friend_id` = '' | 1 | 1 | 0 | |
24 | SELECT `UserSettingFeed`.`id`, `UserSettingFeed`.`type`, `UserSettingFeed`.`active`, `UserSettingFeed`.`text`, `UserSettingFeed`.`plugin` FROM `moo_travel`.`qcuser_setting_feeds` AS `UserSettingFeed` WHERE `active` = '0' | 0 | 0 | 1 | |
25 | SELECT `Activity`.`id` FROM `moo_travel`.`qcactivities` AS `Activity` WHERE ((((`Activity`.`user_id` = 10) AND (`Activity`.`type` = "user") AND (`Activity`.`privacy` = 1))) OR (((`Activity`.`target_id` = 10) AND (`Activity`.`type` = 'user') AND (NOT (`Activity`.`user_id` IS NULL))))) AND `Activity`.`Plugin` IN ('Api', 'Billing', 'Blog', 'Bookmark', 'Business', 'Chat', 'Classified', 'Cron', 'Event', 'Forum', 'GifComment', 'Group', 'Mail', 'Menu', 'Minify', 'MooApp', 'MooUpload', 'OpenIdConnect', 'Page', 'PaymentGateway', 'PaypalAdaptive', 'PaypalExpress', 'Photo', 'Poll', 'Reaction', 'Shoutbox', 'SocialIntegration', 'StatusBackground', 'Sticker', 'Storage', 'Subscription', 'Topic', 'Video', '') AND `Activity`.`status` = 'ok' ORDER BY `Activity`.`modified` desc LIMIT 12 | 2 | 2 | 1 | |
26 | 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` FROM `moo_travel`.`qcactivity_comments` AS `ActivityComment` WHERE `ActivityComment`.`activity_id` = (265) ORDER BY `ActivityComment`.`id` desc LIMIT 1 | 0 | 0 | 1 | |
27 | 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` FROM `moo_travel`.`qcactivity_comments` AS `ActivityComment` WHERE `ActivityComment`.`activity_id` = (264) ORDER BY `ActivityComment`.`id` desc LIMIT 1 | 0 | 0 | 0 | |
28 | SELECT *, `Activity`.`id` FROM `moo_travel`.`qcactivities` AS `Activity` LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`Activity`.`user_id` = `User`.`id`) LEFT JOIN `moo_travel`.`qcuser_taggings` AS `UserTagging` ON (`Activity`.`id` = `UserTagging`.`item_id` AND `UserTagging`.`item_table` = 'activities') WHERE ((((`Activity`.`user_id` = 10) AND (`Activity`.`type` = "user") AND (`Activity`.`privacy` = 1))) OR (((`Activity`.`target_id` = 10) AND (`Activity`.`type` = 'user') AND (NOT (`Activity`.`user_id` IS NULL))))) AND `Activity`.`Plugin` IN ('Api', 'Billing', 'Blog', 'Bookmark', 'Business', 'Chat', 'Classified', 'Cron', 'Event', 'Forum', 'GifComment', 'Group', 'Mail', 'Menu', 'Minify', 'MooApp', 'MooUpload', 'OpenIdConnect', 'Page', 'PaymentGateway', 'PaypalAdaptive', 'PaypalExpress', 'Photo', 'Poll', 'Reaction', 'Shoutbox', 'SocialIntegration', 'StatusBackground', 'Sticker', 'Storage', 'Subscription', 'Topic', 'Video', '') AND `Activity`.`status` = 'ok' AND `Activity`.`id` = 265 ORDER BY `Activity`.`modified` desc LIMIT 1 | 1 | 1 | 1 | |
29 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `moo_travel`.`qcroles` AS `Role` WHERE `Role`.`id` = 2 | 1 | 1 | 0 | |
30 | SELECT `Like`.`id`, `Like`.`user_id`, `Like`.`target_id`, `Like`.`type`, `Like`.`thumb_up`, `Like`.`reaction` FROM `moo_travel`.`qclikes` AS `Like` WHERE `Like`.`type` = 'activity' AND `Like`.`target_id` = (265) | 0 | 0 | 0 | |
31 | SELECT *, `Activity`.`id` FROM `moo_travel`.`qcactivities` AS `Activity` LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`Activity`.`user_id` = `User`.`id`) LEFT JOIN `moo_travel`.`qcuser_taggings` AS `UserTagging` ON (`Activity`.`id` = `UserTagging`.`item_id` AND `UserTagging`.`item_table` = 'activities') WHERE ((((`Activity`.`user_id` = 10) AND (`Activity`.`type` = "user") AND (`Activity`.`privacy` = 1))) OR (((`Activity`.`target_id` = 10) AND (`Activity`.`type` = 'user') AND (NOT (`Activity`.`user_id` IS NULL))))) AND `Activity`.`Plugin` IN ('Api', 'Billing', 'Blog', 'Bookmark', 'Business', 'Chat', 'Classified', 'Cron', 'Event', 'Forum', 'GifComment', 'Group', 'Mail', 'Menu', 'Minify', 'MooApp', 'MooUpload', 'OpenIdConnect', 'Page', 'PaymentGateway', 'PaypalAdaptive', 'PaypalExpress', 'Photo', 'Poll', 'Reaction', 'Shoutbox', 'SocialIntegration', 'StatusBackground', 'Sticker', 'Storage', 'Subscription', 'Topic', 'Video', '') AND `Activity`.`status` = 'ok' AND `Activity`.`id` = 264 ORDER BY `Activity`.`modified` desc LIMIT 1 | 1 | 1 | 1 | |
32 | SELECT `Like`.`id`, `Like`.`user_id`, `Like`.`target_id`, `Like`.`type`, `Like`.`thumb_up`, `Like`.`reaction` FROM `moo_travel`.`qclikes` AS `Like` WHERE `Like`.`type` = 'activity' AND `Like`.`target_id` = (264) | 0 | 0 | 0 | |
33 | 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`.`chat_count`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature`, `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 `moo_travel`.`qcvideos` AS `Video` LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`Video`.`user_id` = `User`.`id`) LEFT JOIN `moo_travel`.`qccategories` AS `Category` ON (`Video`.`category_id` = `Category`.`id`) LEFT JOIN `moo_travel`.`qcgroups` AS `Group` ON (`Video`.`group_id` = `Group`.`id`) WHERE `Video`.`id` = 52 ORDER BY `Video`.`id` desc LIMIT 1 | 1 | 1 | 1 | |
34 | SELECT COUNT(*) AS `count` FROM `moo_travel`.`qccomments` AS `Comment` LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`Comment`.`user_id` = `User`.`id`) WHERE `Comment`.`target_id` = 52 AND `Comment`.`type` = 'Video_Video' | 1 | 1 | 1 | |
35 | 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`.`chat_count`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature` FROM `moo_travel`.`qccomments` AS `Comment` LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`Comment`.`user_id` = `User`.`id`) WHERE `Comment`.`target_id` = 52 AND `Comment`.`type` = 'Video_Video' ORDER BY `Comment`.`id` desc LIMIT 1 | 0 | 0 | 1 | |
36 | SELECT `Like`.`user_id`, `Like`.`thumb_up` FROM `moo_travel`.`qclikes` AS `Like` WHERE `Like`.`target_id` = 52 AND `Like`.`type` = 'Video_Video' ORDER BY `Like`.`id` desc | 0 | 0 | 0 | |
37 | 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`.`chat_count`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature`, `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 `moo_travel`.`qcvideos` AS `Video` LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`Video`.`user_id` = `User`.`id`) LEFT JOIN `moo_travel`.`qccategories` AS `Category` ON (`Video`.`category_id` = `Category`.`id`) LEFT JOIN `moo_travel`.`qcgroups` AS `Group` ON (`Video`.`group_id` = `Group`.`id`) WHERE `Video`.`id` = 51 ORDER BY `Video`.`id` desc LIMIT 1 | 1 | 1 | 1 | |
38 | SELECT COUNT(*) AS `count` FROM `moo_travel`.`qccomments` AS `Comment` LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`Comment`.`user_id` = `User`.`id`) WHERE `Comment`.`target_id` = 51 AND `Comment`.`type` = 'Video_Video' | 1 | 1 | 0 | |
39 | 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`.`chat_count`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature` FROM `moo_travel`.`qccomments` AS `Comment` LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`Comment`.`user_id` = `User`.`id`) WHERE `Comment`.`target_id` = 51 AND `Comment`.`type` = 'Video_Video' ORDER BY `Comment`.`id` desc LIMIT 1 | 0 | 0 | 0 | |
40 | SELECT `Like`.`user_id`, `Like`.`thumb_up` FROM `moo_travel`.`qclikes` AS `Like` WHERE `Like`.`target_id` = 51 AND `Like`.`type` = 'Video_Video' ORDER BY `Like`.`id` desc | 0 | 0 | 0 | |
41 | SELECT `UserTagging`.`id`, `UserTagging`.`item_id`, `UserTagging`.`item_table`, `UserTagging`.`users_taggings`, `UserTagging`.`created`, `UserTagging`.`modified` FROM `moo_travel`.`qcuser_taggings` AS `UserTagging` WHERE `UserTagging`.`users_taggings` LIKE "%10%" | 0 | 0 | 0 | |
42 | SELECT `UserSettingFeed`.`id`, `UserSettingFeed`.`type`, `UserSettingFeed`.`active`, `UserSettingFeed`.`text`, `UserSettingFeed`.`plugin` FROM `moo_travel`.`qcuser_setting_feeds` AS `UserSettingFeed` WHERE `active` = '0' | 0 | 0 | 0 | |
43 | SELECT COUNT(*) AS `count` FROM `moo_travel`.`qcactivities` AS `Activity` WHERE ((((`Activity`.`user_id` = 10) AND (`Activity`.`type` = "user") AND (`Activity`.`privacy` = 1))) OR (((`Activity`.`target_id` = 10) AND (`Activity`.`type` = 'user') AND (NOT (`Activity`.`user_id` IS NULL))))) AND `Activity`.`Plugin` IN ('Api', 'Billing', 'Blog', 'Bookmark', 'Business', 'Chat', 'Classified', 'Cron', 'Event', 'Forum', 'GifComment', 'Group', 'Mail', 'Menu', 'Minify', 'MooApp', 'MooUpload', 'OpenIdConnect', 'Page', 'PaymentGateway', 'PaypalAdaptive', 'PaypalExpress', 'Photo', 'Poll', 'Reaction', 'Shoutbox', 'SocialIntegration', 'StatusBackground', 'Sticker', 'Storage', 'Subscription', 'Topic', 'Video', '') AND `Activity`.`status` = 'ok' | 1 | 1 | 1 | |
44 | SELECT `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission`, (`I18n__nameTranslation`.`content`) AS `Category__i18n_nameTranslation` FROM `moo_travel`.`qccategories` AS `Category` INNER JOIN `moo_travel`.`qci18n` AS `I18n__nameTranslation` ON (`Category`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Category' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `Category`.`type` = 'Video' AND `Category`.`active` = 1 ORDER BY `Category`.`weight` asc | 8 | 8 | 1 | |
45 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `moo_travel`.`qci18n` AS `nameTranslation` WHERE `model` = 'Category' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (4, 6, 7, 8, 9, 10, 31, 32) ORDER BY `id` ASC | 24 | 24 | 1 | |
46 | SELECT `Coremenu`.`id`, `Coremenu`.`name`, `Coremenu`.`style`, `Coremenu`.`alias`, `Coremenu`.`menuid` FROM `moo_travel`.`qccore_menus` AS `Coremenu` WHERE `id` = 2 LIMIT 1 | 1 | 1 | 0 | |
47 | 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 `moo_travel`.`qccore_menu_items` AS `CoreMenuItem` WHERE `CoreMenuItem`.`is_active` = '1' AND `CoreMenuItem`.`menu_id` = (2) ORDER BY `CoreMenuItem`.`menu_order` ASC | 4 | 4 | 0 | |
48 | SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `moo_travel`.`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 | |
49 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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 | |
50 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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 | |
51 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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 | |
52 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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 | 1 | |
53 | 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`.`chat_count`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature`, `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 `moo_travel`.`qcvideos` AS `Video` LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`Video`.`user_id` = `User`.`id`) LEFT JOIN `moo_travel`.`qccategories` AS `Category` ON (`Video`.`category_id` = `Category`.`id`) LEFT JOIN `moo_travel`.`qcgroups` AS `Group` ON (`Video`.`group_id` = `Group`.`id`) WHERE `Video`.`id` = 52 ORDER BY `Video`.`id` desc LIMIT 1 | 1 | 1 | 1 | |
54 | SELECT `CloseComment`.`id`, `CloseComment`.`user_id`, `CloseComment`.`item_type`, `CloseComment`.`item_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`.`chat_count`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature` FROM `moo_travel`.`qcclose_comments` AS `CloseComment` LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`CloseComment`.`user_id` = `User`.`id`) WHERE `item_type` = 'Video_Video' AND `item_id` = 52 LIMIT 1 | 0 | 0 | 1 | |
55 | 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`.`chat_count`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `moo_travel`.`qcusers` AS `User` LEFT JOIN `moo_travel`.`qcroles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `User`.`id` = 0 LIMIT 1 | 0 | 0 | 0 | |
56 | SELECT `CommentHistory`.`id`, `CommentHistory`.`user_id`, `CommentHistory`.`content`, `CommentHistory`.`created`, `CommentHistory`.`photo`, `CommentHistory`.`link`, `CommentHistory`.`type`, `CommentHistory`.`target_id`, `CommentHistory`.`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`.`chat_count`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature` FROM `moo_travel`.`qccomment_histories` AS `CommentHistory` LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`CommentHistory`.`user_id` = `User`.`id`) WHERE `type` = 'activity' AND `target_id` = 265 ORDER BY `CommentHistory`.`id` desc LIMIT 1 | 0 | 0 | 1 | |
57 | SELECT `Reaction`.`id`, `Reaction`.`target_id`, `Reaction`.`type`, `Reaction`.`total_count`, `Reaction`.`dislike_count`, `Reaction`.`like_count`, `Reaction`.`love_count`, `Reaction`.`haha_count`, `Reaction`.`wow_count`, `Reaction`.`sad_count`, `Reaction`.`angry_count`, `Reaction`.`cool_count`, `Reaction`.`confused_count`, `Reaction`.`is_update` FROM `moo_travel`.`qcreactions` AS `Reaction` WHERE `target_id` = 52 AND `type` = 'Video_Video' LIMIT 1 | 1 | 1 | 1 | |
58 | SELECT `Like`.`id`, `Like`.`user_id`, `Like`.`target_id`, `Like`.`type`, `Like`.`thumb_up`, `Like`.`reaction`, `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`.`chat_count`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature` FROM `moo_travel`.`qclikes` AS `Like` LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`Like`.`user_id` = `User`.`id`) WHERE `user_id` IS NULL AND `type` = 'Video_Video' AND `target_id` = 52 ORDER BY `Like`.`id` desc LIMIT 1 | 0 | 0 | 1 | |
59 | 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`.`chat_count`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature`, `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 `moo_travel`.`qcvideos` AS `Video` LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`Video`.`user_id` = `User`.`id`) LEFT JOIN `moo_travel`.`qccategories` AS `Category` ON (`Video`.`category_id` = `Category`.`id`) LEFT JOIN `moo_travel`.`qcgroups` AS `Group` ON (`Video`.`group_id` = `Group`.`id`) WHERE `Video`.`id` = 51 ORDER BY `Video`.`id` desc LIMIT 1 | 1 | 1 | 1 | |
60 | SELECT `CloseComment`.`id`, `CloseComment`.`user_id`, `CloseComment`.`item_type`, `CloseComment`.`item_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`.`chat_count`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature` FROM `moo_travel`.`qcclose_comments` AS `CloseComment` LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`CloseComment`.`user_id` = `User`.`id`) WHERE `item_type` = 'Video_Video' AND `item_id` = 51 LIMIT 1 | 0 | 0 | 0 | |
61 | SELECT `CommentHistory`.`id`, `CommentHistory`.`user_id`, `CommentHistory`.`content`, `CommentHistory`.`created`, `CommentHistory`.`photo`, `CommentHistory`.`link`, `CommentHistory`.`type`, `CommentHistory`.`target_id`, `CommentHistory`.`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`.`chat_count`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature` FROM `moo_travel`.`qccomment_histories` AS `CommentHistory` LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`CommentHistory`.`user_id` = `User`.`id`) WHERE `type` = 'activity' AND `target_id` = 264 ORDER BY `CommentHistory`.`id` desc LIMIT 1 | 0 | 0 | 1 | |
62 | SELECT `Reaction`.`id`, `Reaction`.`target_id`, `Reaction`.`type`, `Reaction`.`total_count`, `Reaction`.`dislike_count`, `Reaction`.`like_count`, `Reaction`.`love_count`, `Reaction`.`haha_count`, `Reaction`.`wow_count`, `Reaction`.`sad_count`, `Reaction`.`angry_count`, `Reaction`.`cool_count`, `Reaction`.`confused_count`, `Reaction`.`is_update` FROM `moo_travel`.`qcreactions` AS `Reaction` WHERE `target_id` = 51 AND `type` = 'Video_Video' LIMIT 1 | 1 | 1 | 0 | |
63 | SELECT `Like`.`id`, `Like`.`user_id`, `Like`.`target_id`, `Like`.`type`, `Like`.`thumb_up`, `Like`.`reaction`, `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`.`chat_count`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature` FROM `moo_travel`.`qclikes` AS `Like` LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`Like`.`user_id` = `User`.`id`) WHERE `user_id` IS NULL AND `type` = 'Video_Video' AND `target_id` = 51 ORDER BY `Like`.`id` desc LIMIT 1 | 0 | 0 | 0 | |
64 | SELECT `Friend`.`id`, `Friend`.`user_id`, `Friend`.`friend_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`.`chat_count`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature` FROM `moo_travel`.`qcfriends` AS `Friend` LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`Friend`.`friend_id` = `User`.`id`) WHERE `Friend`.`user_id` IS NULL AND `User`.`active` = 1 AND NOT (`Friend`.`friend_id` IS NULL) ORDER BY `User`.`name` asc LIMIT 10 | 0 | 0 | 1 | |
65 | SELECT `ProfileMenu`.`id`, `ProfileMenu`.`name`, `ProfileMenu`.`plugin`, `ProfileMenu`.`order`, `ProfileMenu`.`enable` FROM `moo_travel`.`qcprofile_menus` AS `ProfileMenu` WHERE 1 = 1 | 16 | 16 | 1 | |
66 | SELECT COUNT(*) AS `count` FROM `moo_travel`.`qcuser_follows` AS `UserFollow` LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`UserFollow`.`user_follow_id` = `User`.`id`) WHERE `UserFollow`.`user_follow_id` = 10 | 1 | 1 | 1 | |
67 | SELECT COUNT(*) AS `count` FROM `moo_travel`.`qcevent_rsvps` AS `EventRsvp` LEFT JOIN `moo_travel`.`qcevents` AS `Event` ON (`EventRsvp`.`event_id` = `Event`.`id`) WHERE ((((`EventRsvp`.`user_id` = 10) AND ((rsvp = 1 OR rsvp = 3)))) OR (`Event`.`user_id` = 10)) AND `Event`.`group_id` = 0 GROUP BY `Event`.`id` | 0 | 0 | 1 | |
68 | SELECT COUNT(*) AS `count` FROM `moo_travel`.`qcclassifieds` AS `Classified` LEFT JOIN `moo_travel`.`qcclassified_categories` AS `ClassifiedCategory` ON (`Classified`.`classified_category_id` = `ClassifiedCategory`.`id`) LEFT JOIN `moo_travel`.`qcclassified_brands` AS `ClassifiedBrand` ON (`Classified`.`classified_brand_id` = `ClassifiedBrand`.`id`) LEFT JOIN `moo_travel`.`qcclassified_packages` AS `ClassifiedPackage` ON (`Classified`.`classified_package_id` = `ClassifiedPackage`.`id`) LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`Classified`.`user_id` = `User`.`id`) WHERE `Classified`.`status` = 1 AND `Classified`.`privacy` = 1 AND `Classified`.`user_id` = 10 | 1 | 1 | 3 | |
69 | SELECT COUNT(*) AS `count` FROM `moo_travel`.`qcforum_topics` AS `ForumTopic` LEFT JOIN `moo_travel`.`qcforum_topics` AS `LastPost` ON (`ForumTopic`.`last_reply_id` = `LastPost`.`id`) LEFT JOIN `moo_travel`.`qcforums` AS `Forum` ON (`ForumTopic`.`forum_id` = `Forum`.`id`) LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`ForumTopic`.`user_id` = `User`.`id`) WHERE `ForumTopic`.`user_id` = 10 AND `ForumTopic`.`parent_id` = 0 | 1 | 1 | 2 | |
70 | SELECT COUNT(*) AS `count` FROM `moo_travel`.`qcpolls` AS `Poll` LEFT JOIN `moo_travel`.`qcusers` AS `User` ON (`Poll`.`user_id` = `User`.`id`) LEFT JOIN `moo_travel`.`qccategories` AS `Category` ON (`Poll`.`category_id` = `Category`.`id`) WHERE `visiable` = '1' AND `Poll`.`privacy` = 1 AND `Poll`.`user_id` = 10 | 1 | 1 | 1 | |
71 | 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 `moo_travel`.`qcthemes` AS `Theme` WHERE `Theme`.`key` = 'default' LIMIT 1 | 1 | 1 | 0 | |
72 | 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 `moo_travel`.`qcthemes` AS `Theme` WHERE `Theme`.`key` = 'default' LIMIT 1 | 1 | 1 | 0 | |
73 | 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 `moo_travel`.`qcsettings` AS `Setting` LEFT JOIN `moo_travel`.`qcsetting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1 | 1 | 1 | 1 | |
74 | SELECT `Coremenu`.`id`, `Coremenu`.`name`, `Coremenu`.`style`, `Coremenu`.`alias`, `Coremenu`.`menuid` FROM `moo_travel`.`qccore_menus` AS `Coremenu` WHERE `alias` = 'main-menu' LIMIT 1 | 1 | 1 | 0 | |
75 | 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 `moo_travel`.`qccore_menu_items` AS `CoreMenuItem` WHERE `CoreMenuItem`.`is_active` = '1' AND `CoreMenuItem`.`menu_id` = (1) ORDER BY `CoreMenuItem`.`menu_order` ASC | 19 | 19 | 0 | |
76 | SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `moo_travel`.`qci18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (1, 2, 3, 4, 7, 6, 5, 8, 24, 31, 32, 33, 34, 30, 27, 25, 23, 26, 28) ORDER BY `id` ASC | 57 | 57 | 1 | |
77 | 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 `moo_travel`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1 | 1 | 1 | 1 | |
78 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 1 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 1 | |
79 | 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 `moo_travel`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1 | 1 | 1 | 0 | |
80 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 2 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
81 | 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 `moo_travel`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1 | 1 | 1 | 0 | |
82 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 3 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
83 | 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 `moo_travel`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1 | 1 | 1 | 0 | |
84 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 4 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
85 | 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 `moo_travel`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1 | 1 | 1 | 0 | |
86 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 7 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
87 | 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 `moo_travel`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1 | 1 | 1 | 0 | |
88 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 6 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
89 | 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 `moo_travel`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1 | 1 | 1 | 0 | |
90 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 5 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
91 | 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 `moo_travel`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1 | 1 | 1 | 0 | |
92 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 8 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 1 | |
93 | 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 `moo_travel`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1 | 1 | 1 | 0 | |
94 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 24 AND `is_active` = '1' ORDER BY `menu_order` ASC | 10 | 10 | 1 | |
95 | SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `moo_travel`.`qci18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (31, 32, 33, 34, 30, 27, 25, 23, 26, 28) ORDER BY `id` ASC | 30 | 30 | 1 | |
96 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 31 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
97 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 31 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
98 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 32 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
99 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 32 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
100 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 33 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 1 | |
101 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 33 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 1 | |
102 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 34 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 1 | |
103 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 34 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 1 | |
104 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 30 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 1 | |
105 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 30 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 1 | |
106 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 27 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
107 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 27 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
108 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 25 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
109 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 25 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
110 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 23 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 1 | |
111 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 23 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
112 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 26 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
113 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 26 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
114 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 28 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 1 | |
115 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 28 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 1 | |
116 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 24 AND `is_active` = '1' ORDER BY `menu_order` ASC | 10 | 10 | 1 | |
117 | SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `moo_travel`.`qci18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (31, 32, 33, 34, 30, 27, 25, 23, 26, 28) ORDER BY `id` ASC | 30 | 30 | 1 | |
118 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 31 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
119 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 32 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 1 | |
120 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 33 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 1 | |
121 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 34 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
122 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 30 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
123 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 27 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
124 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 25 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 1 | |
125 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 23 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
126 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 26 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
127 | 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 `moo_travel`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `moo_travel`.`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` = 28 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
128 | 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 `moo_travel`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1 | 1 | 1 | 0 | |
129 | 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 `moo_travel`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1 | 1 | 1 | 0 | |
130 | 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 `moo_travel`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1 | 1 | 1 | 0 | |
131 | 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 `moo_travel`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1 | 1 | 1 | 0 | |
132 | 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 `moo_travel`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1 | 1 | 1 | 0 | |
133 | 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 `moo_travel`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1 | 1 | 1 | 3 | |
134 | 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 `moo_travel`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1 | 1 | 1 | 0 | |
135 | 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 `moo_travel`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1 | 1 | 1 | 0 | |
136 | 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 `moo_travel`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1 | 1 | 1 | 7 | |
137 | 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 `moo_travel`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1 | 1 | 1 | 0 | |
138 | 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 `moo_travel`.`qcsettings` AS `Setting` LEFT JOIN `moo_travel`.`qcsetting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1 | 1 | 1 | 0 | |
139 | 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 `moo_travel`.`qcthemes` AS `Theme` WHERE `Theme`.`key` = 'default' LIMIT 1 | 1 | 1 | 0 | |
140 | 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 `moo_travel`.`qcthemes` AS `Theme` WHERE `Theme`.`key` = 'default' LIMIT 1 | 1 | 1 | 0 |