| 1 | SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`user_id` FROM `travel_moosocial`.`qccake_sessions` AS `Session` WHERE `Session`.`id` = '5b202e024910c3434fd2e39ede2edbd9' LIMIT 1 | | 1 | 1 | 0 |
| 2 | SELECT `EventRsvp`.`event_id` FROM `travel_moosocial`.`qcevent_rsvps` AS `EventRsvp` LEFT JOIN `travel_moosocial`.`qcevents` AS `Event` ON (`EventRsvp`.`event_id` = `Event`.`id`) LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`EventRsvp`.`user_id` = `User`.`id`) WHERE `EventRsvp`.`user_id` IS NULL ORDER BY `EventRsvp`.`id` desc | | 0 | 0 | 3 |
| 3 | SELECT `Event`.`id`, `Event`.`category_id`, `Event`.`title`, `Event`.`description`, `Event`.`user_id`, `Event`.`location`, `Event`.`from`, `Event`.`from_time`, `Event`.`from_datetime`, `Event`.`to`, `Event`.`to_time`, `Event`.`to_datetime`, `Event`.`created`, `Event`.`type`, `Event`.`photo`, `Event`.`event_rsvp_count`, `Event`.`address`, `Event`.`timezone`, `Event`.`reminder`, `Event`.`reminder_status`, `Event`.`group_id`, `Event`.`country_id`, `Event`.`state_id`, `Event`.`city_id`, `Event`.`zip`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`group_count`, `User`.`event_count`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`lock_delete`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission`, `Country`.`id`, `Country`.`name`, `Country`.`country_iso`, `Country`.`state_count`, `Country`.`order`, `Country`.`enable`, `State`.`id`, `State`.`name`, `State`.`state_code`, `State`.`country_id`, `State`.`order`, `State`.`enable`, `State`.`city_count`, `City`.`id`, `City`.`name`, `City`.`city_code`, `City`.`country_id`, `City`.`order`, `City`.`enable`, `City`.`state_id`, `Group`.`id`, `Group`.`category_id`, `Group`.`name`, `Group`.`user_id`, `Group`.`description`, `Group`.`type`, `Group`.`photo`, `Group`.`group_user_count`, `Group`.`created`, `Group`.`photo_count`, `Group`.`topic_count`, `Group`.`video_count`, `Group`.`event_count`, `Group`.`featured` FROM `travel_moosocial`.`qcevents` AS `Event` LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`Event`.`user_id` = `User`.`id`) LEFT JOIN `travel_moosocial`.`qccategories` AS `Category` ON (`Event`.`category_id` = `Category`.`id`) LEFT JOIN `travel_moosocial`.`qccountries` AS `Country` ON (`Event`.`country_id` = `Country`.`id`) LEFT JOIN `travel_moosocial`.`qcstates` AS `State` ON (`Event`.`state_id` = `State`.`id`) LEFT JOIN `travel_moosocial`.`qccities` AS `City` ON (`Event`.`city_id` = `City`.`id`) LEFT JOIN `travel_moosocial`.`qcgroups` AS `Group` ON (`Event`.`group_id` = `Group`.`id`) WHERE `Event`.`category_id` = 28 AND `Event`.`type` = 1 AND `User`.`active` = 1 AND `Event`.`group_id` = 0 ORDER BY `Event`.`from` asc LIMIT 10 | | 3 | 3 | 2 |
| 4 | SELECT `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, (`I18n__nameTranslation`.`content`) AS `ProfileType__i18n_nameTranslation` FROM `travel_moosocial`.`qcprofile_types` AS `ProfileType` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ProfileType`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ProfileType' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ProfileType`.`id` IN (1, 'eng') AND `ProfileType`.`actived` = '1' ORDER BY `ProfileType`.`order` asc | | 1 | 1 | 12 |
| 5 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ProfileType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | | 3 | 3 | 3 |
| 6 | SELECT `Event`.`id`, `Event`.`category_id`, `Event`.`title`, `Event`.`description`, `Event`.`user_id`, `Event`.`location`, `Event`.`from`, `Event`.`from_time`, `Event`.`from_datetime`, `Event`.`to`, `Event`.`to_time`, `Event`.`to_datetime`, `Event`.`created`, `Event`.`type`, `Event`.`photo`, `Event`.`event_rsvp_count`, `Event`.`address`, `Event`.`timezone`, `Event`.`reminder`, `Event`.`reminder_status`, `Event`.`group_id`, `Event`.`country_id`, `Event`.`state_id`, `Event`.`city_id`, `Event`.`zip`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`group_count`, `User`.`event_count`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`lock_delete`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission`, `Country`.`id`, `Country`.`name`, `Country`.`country_iso`, `Country`.`state_count`, `Country`.`order`, `Country`.`enable`, `State`.`id`, `State`.`name`, `State`.`state_code`, `State`.`country_id`, `State`.`order`, `State`.`enable`, `State`.`city_count`, `City`.`id`, `City`.`name`, `City`.`city_code`, `City`.`country_id`, `City`.`order`, `City`.`enable`, `City`.`state_id`, `Group`.`id`, `Group`.`category_id`, `Group`.`name`, `Group`.`user_id`, `Group`.`description`, `Group`.`type`, `Group`.`photo`, `Group`.`group_user_count`, `Group`.`created`, `Group`.`photo_count`, `Group`.`topic_count`, `Group`.`video_count`, `Group`.`event_count`, `Group`.`featured` FROM `travel_moosocial`.`qcevents` AS `Event` LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`Event`.`user_id` = `User`.`id`) LEFT JOIN `travel_moosocial`.`qccategories` AS `Category` ON (`Event`.`category_id` = `Category`.`id`) LEFT JOIN `travel_moosocial`.`qccountries` AS `Country` ON (`Event`.`country_id` = `Country`.`id`) LEFT JOIN `travel_moosocial`.`qcstates` AS `State` ON (`Event`.`state_id` = `State`.`id`) LEFT JOIN `travel_moosocial`.`qccities` AS `City` ON (`Event`.`city_id` = `City`.`id`) LEFT JOIN `travel_moosocial`.`qcgroups` AS `Group` ON (`Event`.`group_id` = `Group`.`id`) WHERE `Event`.`category_id` = 28 AND `Event`.`type` = 1 AND `User`.`active` = 1 AND `Event`.`group_id` = 0 ORDER BY `Event`.`from` asc LIMIT 10, 10 | | 0 | 0 | 2 |
| 7 | 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 `travel_moosocial`.`qccategories` AS `Category` INNER JOIN `travel_moosocial`.`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` = 'Event' AND `Category`.`active` = 1 ORDER BY `Category`.`weight` asc | | 8 | 8 | 1 |
| 8 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'Category' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (5, 23, 29, 27, 28, 24, 25, 26) ORDER BY `id` ASC | | 24 | 24 | 75 |
| 9 | SELECT `Country`.`id`, `Country`.`name`, `Country`.`country_iso`, `Country`.`state_count`, `Country`.`order`, `Country`.`enable`, (`I18n__nameTranslation`.`content`) AS `Country__i18n_nameTranslation` FROM `travel_moosocial`.`qccountries` AS `Country` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`Country`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Country' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `enable` = '1' ORDER BY `Country`.`order` ASC, `Country`.`name` ASC | | 244 | 244 | 16 |
| 10 | SELECT `State`.`id`, `State`.`name`, `State`.`state_code`, `State`.`country_id`, `State`.`order`, `State`.`enable`, `State`.`city_count` FROM `travel_moosocial`.`qcstates` AS `State` WHERE `State`.`country_id` IN (3, 16, 6, 61, 12, 228, 9, 5, 10, 4, 11, 7, 15, 14, 13, 17, 32, 24, 20, 19, 36, 21, 37, 26, 28, 33, 30, 18, 35, 34, 31, 105, 29, 23, 22, 25, 115, 47, 38, 52, 122, 41, 210, 46, 48, 53, 39, 49, 117, 42, 40, 45, 50, 44, 97, 51, 54, 55, 58, 57, 59, 60, 62, 64, 206, 87, 66, 63, 68, 71, 73, 70, 69, 74, 79, 172, 211, 75, 84, 78, 56, 81, 82, 88, 83, 77, 86, 91, 90, 80, 85, 92, 93, 98, 95, 231, 96, 94, 99, 108, 104, 100, 107, 106, 101, 103, 102, 109, 110, 112, 111, 123, 113, 116, 119, 120, 121, 114, 124, 133, 125, 130, 129, 134, 127, 131, 132, 145, 141, 139, 153, 155, 152, 142, 150, 140, 147, 148, 151, 241, 154, 72, 137, 136, 144, 138, 149, 135, 156, 143, 157, 166, 165, 163, 8, 158, 168, 162, 159, 161, 167, 160, 146, 164, 169, 175, 182, 180, 170, 173, 183, 171, 174, 178, 176, 181, 179, 184, 185, 186, 188, 189, 27, 196, 118, 126, 177, 232, 239, 201, 205, 190, 202, 187, 192, 200, 195, 199, 197, 191, 203, 242, 89, 67, 128, 193, 204, 198, 208, 194, 43, 207, 223, 214, 224, 213, 216, 212, 215, 219, 221, 218, 220, 217, 209, 222, 226, 225, 2, 76, 1, 227, 229, 230, 237, 233, 236, 234, 235, 238, 65, 240, 243, 244) | | 51 | 51 | 1 |
| 11 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'Country' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (3, 16, 6, 61, 12, 228, 9, 5, 10, 4, 11, 7, 15, 14, 13, 17, 32, 24, 20, 19, 36, 21, 37, 26, 28, 33, 30, 18, 35, 34, 31, 105, 29, 23, 22, 25, 115, 47, 38, 52, 122, 41, 210, 46, 48, 53, 39, 49, 117, 42, 40, 45, 50, 44, 97, 51, 54, 55, 58, 57, 59, 60, 62, 64, 206, 87, 66, 63, 68, 71, 73, 70, 69, 74, 79, 172, 211, 75, 84, 78, 56, 81, 82, 88, 83, 77, 86, 91, 90, 80, 85, 92, 93, 98, 95, 231, 96, 94, 99, 108, 104, 100, 107, 106, 101, 103, 102, 109, 110, 112, 111, 123, 113, 116, 119, 120, 121, 114, 124, 133, 125, 130, 129, 134, 127, 131, 132, 145, 141, 139, 153, 155, 152, 142, 150, 140, 147, 148, 151, 241, 154, 72, 137, 136, 144, 138, 149, 135, 156, 143, 157, 166, 165, 163, 8, 158, 168, 162, 159, 161, 167, 160, 146, 164, 169, 175, 182, 180, 170, 173, 183, 171, 174, 178, 176, 181, 179, 184, 185, 186, 188, 189, 27, 196, 118, 126, 177, 232, 239, 201, 205, 190, 202, 187, 192, 200, 195, 199, 197, 191, 203, 242, 89, 67, 128, 193, 204, 198, 208, 194, 43, 207, 223, 214, 224, 213, 216, 212, 215, 219, 221, 218, 220, 217, 209, 222, 226, 225, 2, 76, 1, 227, 229, 230, 237, 233, 236, 234, 235, 238, 65, 240, 243, 244) ORDER BY `id` ASC | | 732 | 732 | 4 |
| 12 | 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 `travel_moosocial`.`qccategories` AS `Category` INNER JOIN `travel_moosocial`.`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`.`id` = 28 ORDER BY `Category`.`weight` asc LIMIT 1 | | 1 | 1 | 1 |
| 13 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'Category' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (28) ORDER BY `id` ASC | | 3 | 3 | 72 |
| 14 | SELECT `Event`.`id`, `Event`.`category_id`, `Event`.`title`, `Event`.`description`, `Event`.`user_id`, `Event`.`location`, `Event`.`from`, `Event`.`from_time`, `Event`.`from_datetime`, `Event`.`to`, `Event`.`to_time`, `Event`.`to_datetime`, `Event`.`created`, `Event`.`type`, `Event`.`photo`, `Event`.`event_rsvp_count`, `Event`.`address`, `Event`.`timezone`, `Event`.`reminder`, `Event`.`reminder_status`, `Event`.`group_id`, `Event`.`country_id`, `Event`.`state_id`, `Event`.`city_id`, `Event`.`zip`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`group_count`, `User`.`event_count`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`lock_delete`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission`, `Country`.`id`, `Country`.`name`, `Country`.`country_iso`, `Country`.`state_count`, `Country`.`order`, `Country`.`enable`, `State`.`id`, `State`.`name`, `State`.`state_code`, `State`.`country_id`, `State`.`order`, `State`.`enable`, `State`.`city_count`, `City`.`id`, `City`.`name`, `City`.`city_code`, `City`.`country_id`, `City`.`order`, `City`.`enable`, `City`.`state_id`, `Group`.`id`, `Group`.`category_id`, `Group`.`name`, `Group`.`user_id`, `Group`.`description`, `Group`.`type`, `Group`.`photo`, `Group`.`group_user_count`, `Group`.`created`, `Group`.`photo_count`, `Group`.`topic_count`, `Group`.`video_count`, `Group`.`event_count`, `Group`.`featured` FROM `travel_moosocial`.`qcevents` AS `Event` LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`Event`.`user_id` = `User`.`id`) LEFT JOIN `travel_moosocial`.`qccategories` AS `Category` ON (`Event`.`category_id` = `Category`.`id`) LEFT JOIN `travel_moosocial`.`qccountries` AS `Country` ON (`Event`.`country_id` = `Country`.`id`) LEFT JOIN `travel_moosocial`.`qcstates` AS `State` ON (`Event`.`state_id` = `State`.`id`) LEFT JOIN `travel_moosocial`.`qccities` AS `City` ON (`Event`.`city_id` = `City`.`id`) LEFT JOIN `travel_moosocial`.`qcgroups` AS `Group` ON (`Event`.`group_id` = `Group`.`id`) WHERE `Event`.`to_datetime` >= '2026-04-21 19:12:58' AND `Event`.`type` = 1 AND `User`.`active` = 1 AND `Event`.`group_id` = 0 ORDER BY `Event`.`from` asc LIMIT 10 | | 0 | 0 | 1 |
| 15 | SELECT `Coremenu`.`id`, `Coremenu`.`name`, `Coremenu`.`style`, `Coremenu`.`alias`, `Coremenu`.`menuid` FROM `travel_moosocial`.`qccore_menus` AS `Coremenu` WHERE `id` = 2 LIMIT 1 | | 1 | 1 | 0 |
| 16 | SELECT `CoreMenuItem`.`id`, `CoreMenuItem`.`parent_id`, `CoreMenuItem`.`lft`, `CoreMenuItem`.`rght`, `CoreMenuItem`.`name`, `CoreMenuItem`.`original_name`, `CoreMenuItem`.`url`, `CoreMenuItem`.`title_attribute`, `CoreMenuItem`.`font_class`, `CoreMenuItem`.`is_active`, `CoreMenuItem`.`new_blank`, `CoreMenuItem`.`role_access`, `CoreMenuItem`.`menu_id`, `CoreMenuItem`.`type`, `CoreMenuItem`.`menu_order`, `CoreMenuItem`.`plugin`, `CoreMenuItem`.`group`, `CoreMenuItem`.`url_app`, `CoreMenuItem`.`font_class_app`, `CoreMenuItem`.`show_web`, `CoreMenuItem`.`show_app` FROM `travel_moosocial`.`qccore_menu_items` AS `CoreMenuItem` WHERE `CoreMenuItem`.`is_active` = '1' AND `CoreMenuItem`.`menu_id` = (2) ORDER BY `CoreMenuItem`.`menu_order` ASC | | 4 | 4 | 0 |
| 17 | SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (9, 11, 12, 17) ORDER BY `id` ASC | | 12 | 12 | 1 |
| 18 | SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 9 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
| 19 | SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 11 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 1 |
| 20 | SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 12 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 1 |
| 21 | SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 17 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 75 |
| 22 | 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 `travel_moosocial`.`qccategories` AS `Category` INNER JOIN `travel_moosocial`.`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` = 'Event' AND `Category`.`active` = 1 ORDER BY `Category`.`weight` asc | | 8 | 8 | 76 |
| 23 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'Category' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (5, 23, 29, 27, 28, 24, 25, 26) ORDER BY `id` ASC | | 24 | 24 | 1 |
| 24 | SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `travel_moosocial`.`qcthemes` AS `Theme` WHERE `Theme`.`key` = 'classic' LIMIT 1 | | 1 | 1 | 0 |
| 25 | SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `travel_moosocial`.`qcthemes` AS `Theme` WHERE `Theme`.`key` = 'classic' LIMIT 1 | | 1 | 1 | 0 |
| 26 | SELECT `Setting`.`id`, `Setting`.`group_id`, `Setting`.`label`, `Setting`.`name`, `Setting`.`field`, `Setting`.`value`, `Setting`.`is_hidden`, `Setting`.`version_id`, `Setting`.`type_id`, `Setting`.`value_actual`, `Setting`.`value_default`, `Setting`.`description`, `Setting`.`ordering`, `Setting`.`is_boot`, `SettingGroup`.`id`, `SettingGroup`.`parent_id`, `SettingGroup`.`lft`, `SettingGroup`.`rght`, `SettingGroup`.`group_type`, `SettingGroup`.`module_id`, `SettingGroup`.`name` FROM `travel_moosocial`.`qcsettings` AS `Setting` LEFT JOIN `travel_moosocial`.`qcsetting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1 | | 1 | 1 | 1 |
| 27 | SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `travel_moosocial`.`qcthemes` AS `Theme` WHERE `Theme`.`key` = 'classic' LIMIT 1 | | 1 | 1 | 1 |
| 28 | SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `travel_moosocial`.`qcthemes` AS `Theme` WHERE `Theme`.`key` = 'classic' LIMIT 1 | | 1 | 1 | 0 |
