1 | SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`user_id` FROM `druzi`.`cake_sessions` AS `Session` WHERE `Session`.`id` = 'a8g8qlavi7t8co7gnpj9mbt5op' LIMIT 1 | | 0 | 0 | 0 |
2 | SELECT `Plugin`.`enabled` FROM `druzi`.`plugins` AS `Plugin` WHERE `Plugin`.`key` = 'Storage' ORDER BY `Plugin`.`weight` asc LIMIT 1 | | 1 | 1 | 0 |
3 | SELECT `Plugin`.`enabled` FROM `druzi`.`plugins` AS `Plugin` WHERE `Plugin`.`key` = 'Storage' ORDER BY `Plugin`.`weight` asc LIMIT 1 | | 1 | 1 | 0 |
4 | SELECT `Plugin`.`enabled` FROM `druzi`.`plugins` AS `Plugin` WHERE `Plugin`.`key` = 'Storage' ORDER BY `Plugin`.`weight` asc LIMIT 1 | | 1 | 1 | 0 |
5 | SELECT `GroupUserBlock`.`id`, `GroupUserBlock`.`group_id`, `GroupUserBlock`.`user_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`, `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`.`group_count`, `User`.`event_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`.`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`.`viewer_invisible`, `User`.`chat_online_status`, `User`.`lock_delete`, `User`.`hide_profile_complete`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`fake_auto_friend`, `User`.`fake_total_run`, `User`.`fake_current_run`, `User`.`fake_time_updated`, `User`.`fake_next_run_time`, `User`.`signature`, `User`.`show_signature`, `User`.`poked_email` FROM `druzi`.`group_user_blocks` AS `GroupUserBlock` LEFT JOIN `druzi`.`groups` AS `Group` ON (`GroupUserBlock`.`group_id` = `Group`.`id`) LEFT JOIN `druzi`.`users` AS `User` ON (`GroupUserBlock`.`user_id` = `User`.`id`) WHERE `GroupUserBlock`.`user_id` IS NULL AND `GroupUserBlock`.`group_id` = 18 LIMIT 1 | | 0 | 0 | 0 |
6 | SELECT `Group`.`id`, `Group`.`category_id`, `Group`.`name`, `Group`.`user_id`, `Group`.`description`, `Group`.`type`, `Group`.`photo`, `Group`.`group_user_count`, `Group`.`created`, `Group`.`photo_count`, `Group`.`topic_count`, `Group`.`video_count`, `Group`.`event_count`, `Group`.`featured`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_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`.`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`.`viewer_invisible`, `User`.`chat_online_status`, `User`.`lock_delete`, `User`.`hide_profile_complete`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`fake_auto_friend`, `User`.`fake_total_run`, `User`.`fake_current_run`, `User`.`fake_time_updated`, `User`.`fake_next_run_time`, `User`.`signature`, `User`.`show_signature`, `User`.`poked_email`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission` FROM `druzi`.`groups` AS `Group` LEFT JOIN `druzi`.`users` AS `User` ON (`Group`.`user_id` = `User`.`id`) LEFT JOIN `druzi`.`categories` AS `Category` ON (`Group`.`category_id` = `Category`.`id`) WHERE `Group`.`id` = 18 LIMIT 1 | | 1 | 1 | 1 |
7 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `druzi`.`roles` AS `Role` WHERE `Role`.`id` = 2 | | 1 | 1 | 0 |
8 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `druzi`.`i18n` AS `nameTranslation` WHERE `model` = 'Category' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (2) ORDER BY `id` ASC | | 4 | 4 | 0 |
9 | SELECT `GroupUser`.`id`, `GroupUser`.`group_id`, `GroupUser`.`user_id`, `GroupUser`.`status`, `GroupUser`.`created` FROM `druzi`.`group_users` AS `GroupUser` WHERE `GroupUser`.`group_id` = (18) | | 1 | 1 | 0 |
10 | SELECT `Group`.`id`, `Group`.`category_id`, `Group`.`name`, `Group`.`user_id`, `Group`.`description`, `Group`.`type`, `Group`.`photo`, `Group`.`group_user_count`, `Group`.`created`, `Group`.`photo_count`, `Group`.`topic_count`, `Group`.`video_count`, `Group`.`event_count`, `Group`.`featured` FROM `druzi`.`groups` AS `Group` WHERE `Group`.`id` = 18 | | 1 | 1 | 0 |
11 | 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`.`group_count`, `User`.`event_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`.`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`.`viewer_invisible`, `User`.`chat_online_status`, `User`.`lock_delete`, `User`.`hide_profile_complete`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`fake_auto_friend`, `User`.`fake_total_run`, `User`.`fake_current_run`, `User`.`fake_time_updated`, `User`.`fake_next_run_time`, `User`.`signature`, `User`.`show_signature`, `User`.`poked_email` FROM `druzi`.`users` AS `User` WHERE `User`.`id` = 4594 | | 1 | 1 | 0 |
12 | SELECT `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, (`I18n__nameTranslation`.`content`) AS `ProfileType__i18n_nameTranslation` FROM `druzi`.`profile_types` AS `ProfileType` INNER JOIN `druzi`.`i18n` AS `I18n__nameTranslation` ON (`ProfileType`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ProfileType' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'ukr') WHERE `ProfileType`.`id` IN (1, 'ukr') AND `ProfileType`.`actived` = '1' ORDER BY `ProfileType`.`order` asc | | 1 | 1 | 1 |
13 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `druzi`.`i18n` AS `nameTranslation` WHERE `model` = 'ProfileType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | | 4 | 4 | 0 |
14 | SELECT COUNT(*) AS `count` FROM `druzi`.`group_users` AS `GroupUser` LEFT JOIN `druzi`.`groups` AS `Group` ON (`GroupUser`.`group_id` = `Group`.`id`) LEFT JOIN `druzi`.`users` AS `User` ON (`GroupUser`.`user_id` = `User`.`id`) WHERE `GroupUser`.`group_id` = 18 AND (`GroupUser`.`status` = 1 OR `GroupUser`.`status` = 3) | | 1 | 1 | 0 |
15 | SELECT COUNT(*) AS `count` FROM `druzi`.`group_user_blocks` AS `GroupUserBlock` LEFT JOIN `druzi`.`groups` AS `Group` ON (`GroupUserBlock`.`group_id` = `Group`.`id`) LEFT JOIN `druzi`.`users` AS `User` ON (`GroupUserBlock`.`user_id` = `User`.`id`) WHERE `GroupUserBlock`.`group_id` = 18 | | 1 | 1 | 0 |
16 | SELECT `GroupUser`.`id`, `GroupUser`.`group_id`, `GroupUser`.`user_id`, `GroupUser`.`status`, `GroupUser`.`created`, `Group`.`id`, `Group`.`category_id`, `Group`.`name`, `Group`.`user_id`, `Group`.`description`, `Group`.`type`, `Group`.`photo`, `Group`.`group_user_count`, `Group`.`created`, `Group`.`photo_count`, `Group`.`topic_count`, `Group`.`video_count`, `Group`.`event_count`, `Group`.`featured`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_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`.`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`.`viewer_invisible`, `User`.`chat_online_status`, `User`.`lock_delete`, `User`.`hide_profile_complete`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`fake_auto_friend`, `User`.`fake_total_run`, `User`.`fake_current_run`, `User`.`fake_time_updated`, `User`.`fake_next_run_time`, `User`.`signature`, `User`.`show_signature`, `User`.`poked_email` FROM `druzi`.`group_users` AS `GroupUser` LEFT JOIN `druzi`.`groups` AS `Group` ON (`GroupUser`.`group_id` = `Group`.`id`) LEFT JOIN `druzi`.`users` AS `User` ON (`GroupUser`.`user_id` = `User`.`id`) WHERE `group_id` = 18 AND `User`.`active` = '1' AND `status` = 3 ORDER BY `GroupUser`.`id` desc LIMIT 5 | | 1 | 1 | 1 |
17 | SELECT `GroupUser`.`id`, `GroupUser`.`group_id`, `GroupUser`.`user_id`, `GroupUser`.`status`, `GroupUser`.`created`, `Group`.`id`, `Group`.`category_id`, `Group`.`name`, `Group`.`user_id`, `Group`.`description`, `Group`.`type`, `Group`.`photo`, `Group`.`group_user_count`, `Group`.`created`, `Group`.`photo_count`, `Group`.`topic_count`, `Group`.`video_count`, `Group`.`event_count`, `Group`.`featured`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_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`.`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`.`viewer_invisible`, `User`.`chat_online_status`, `User`.`lock_delete`, `User`.`hide_profile_complete`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`fake_auto_friend`, `User`.`fake_total_run`, `User`.`fake_current_run`, `User`.`fake_time_updated`, `User`.`fake_next_run_time`, `User`.`signature`, `User`.`show_signature`, `User`.`poked_email` FROM `druzi`.`group_users` AS `GroupUser` LEFT JOIN `druzi`.`groups` AS `Group` ON (`GroupUser`.`group_id` = `Group`.`id`) LEFT JOIN `druzi`.`users` AS `User` ON (`GroupUser`.`user_id` = `User`.`id`) WHERE `group_id` = 18 AND `User`.`active` = '1' AND `status` = 1 ORDER BY `GroupUser`.`id` desc LIMIT 10 | | 0 | 0 | 0 |
18 | SELECT `GroupUser`.`id`, `GroupUser`.`group_id`, `GroupUser`.`user_id`, `GroupUser`.`status`, `GroupUser`.`created`, `Group`.`id`, `Group`.`category_id`, `Group`.`name`, `Group`.`user_id`, `Group`.`description`, `Group`.`type`, `Group`.`photo`, `Group`.`group_user_count`, `Group`.`created`, `Group`.`photo_count`, `Group`.`topic_count`, `Group`.`video_count`, `Group`.`event_count`, `Group`.`featured`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_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`.`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`.`viewer_invisible`, `User`.`chat_online_status`, `User`.`lock_delete`, `User`.`hide_profile_complete`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`fake_auto_friend`, `User`.`fake_total_run`, `User`.`fake_current_run`, `User`.`fake_time_updated`, `User`.`fake_next_run_time`, `User`.`signature`, `User`.`show_signature`, `User`.`poked_email` FROM `druzi`.`group_users` AS `GroupUser` LEFT JOIN `druzi`.`groups` AS `Group` ON (`GroupUser`.`group_id` = `Group`.`id`) LEFT JOIN `druzi`.`users` AS `User` ON (`GroupUser`.`user_id` = `User`.`id`) WHERE `group_id` = 18 AND `User`.`active` = '1' AND `status` IN (3, 1) ORDER BY `GroupUser`.`id` desc LIMIT 5 | | 1 | 1 | 1 |
19 | SELECT COUNT(*) AS `count` FROM `druzi`.`group_users` AS `GroupUser` LEFT JOIN `druzi`.`groups` AS `Group` ON (`GroupUser`.`group_id` = `Group`.`id`) LEFT JOIN `druzi`.`users` AS `User` ON (`GroupUser`.`user_id` = `User`.`id`) WHERE `GroupUser`.`group_id` = 18 AND `GroupUser`.`status` = 3 | | 1 | 1 | 0 |
20 | SELECT `Photo`.`id`, `Photo`.`target_id`, `Photo`.`type`, `Photo`.`user_id`, `Photo`.`caption`, `Photo`.`path`, `Photo`.`thumbnail`, `Photo`.`original`, `Photo`.`created`, `Photo`.`like_count`, `Photo`.`dislike_count`, `Photo`.`comment_count`, `Photo`.`year_folder`, `Photo`.`album_type`, `Photo`.`album_type_id`, `Photo`.`privacy`, `Photo`.`size`, `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`.`comment_count`, `Album`.`privacy`, `Album`.`type`, `Group`.`id`, `Group`.`category_id`, `Group`.`name`, `Group`.`user_id`, `Group`.`description`, `Group`.`type`, `Group`.`photo`, `Group`.`group_user_count`, `Group`.`created`, `Group`.`photo_count`, `Group`.`topic_count`, `Group`.`video_count`, `Group`.`event_count`, `Group`.`featured`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_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`.`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`.`viewer_invisible`, `User`.`chat_online_status`, `User`.`lock_delete`, `User`.`hide_profile_complete`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`fake_auto_friend`, `User`.`fake_total_run`, `User`.`fake_current_run`, `User`.`fake_time_updated`, `User`.`fake_next_run_time`, `User`.`signature`, `User`.`show_signature`, `User`.`poked_email` FROM `druzi`.`photos` AS `Photo` LEFT JOIN `druzi`.`albums` AS `Album` ON (`Photo`.`type` = "Photo_Album" AND `Photo`.`target_id` = `Album`.`id`) LEFT JOIN `druzi`.`groups` AS `Group` ON (`Photo`.`type` = "Group_Group" AND `Photo`.`target_id` = `Group`.`id`) LEFT JOIN `druzi`.`users` AS `User` ON (`Photo`.`user_id` = `User`.`id`) WHERE `Photo`.`type` = 'Group_Group' AND `target_id` = 18 AND `User`.`active` = '1' ORDER BY `Photo`.`id` desc LIMIT 10 | | 0 | 0 | 1 |
21 | SELECT `GroupUser`.`id`, `GroupUser`.`user_id` FROM `druzi`.`group_users` AS `GroupUser` WHERE `group_id` = 18 AND `status` = 3 | | 1 | 1 | 0 |
22 | SELECT COUNT(*) AS `count` FROM `druzi`.`photos` AS `Photo` LEFT JOIN `druzi`.`albums` AS `Album` ON (`Photo`.`type` = "Photo_Album" AND `Photo`.`target_id` = `Album`.`id`) LEFT JOIN `druzi`.`groups` AS `Group` ON (`Photo`.`type` = "Group_Group" AND `Photo`.`target_id` = `Group`.`id`) LEFT JOIN `druzi`.`users` AS `User` ON (`Photo`.`user_id` = `User`.`id`) WHERE `Photo`.`type` = 'Group_Group' AND `target_id` = 18 AND `User`.`active` = '1' | | 1 | 1 | 0 |
23 | SELECT `UserSettingFeed`.`id`, `UserSettingFeed`.`type`, `UserSettingFeed`.`active`, `UserSettingFeed`.`text`, `UserSettingFeed`.`plugin` FROM `druzi`.`user_setting_feeds` AS `UserSettingFeed` WHERE `active` = '0' | | 0 | 0 | 0 |
24 | SELECT `Activity`.`id` FROM `druzi`.`activities` AS `Activity` WHERE ((((`Activity`.`type` = 'Group_Group') AND (`Activity`.`action` = 'group_join') AND (CONCAT(",",`Activity`.`items`,",") LIKE "%,18,%"))) OR (((`Activity`.`type` = 'Group_Group') AND (`Activity`.`target_id` = 18)))) AND `Activity`.`Plugin` IN ('Activitylog', 'Ads', 'Announcement', 'Api', 'Avatar', 'Backup', 'Billing', 'Bookmark', 'Business', 'Chat', 'Checkin', 'Classified', 'Credit', 'Cron', 'Document', 'DotPay', 'DownloadCopyData', 'Elearning', 'Event', 'FakeInteraction', 'Fakeuser', 'Forum', 'FriendInviter', 'Fundraising', 'GifComment', 'Gift', 'Group', 'Homeblock', 'Indeed', 'Job', 'LandingManager', 'Livenews', 'MagicPage', 'Mail', 'Matchmaking', 'Meetme', 'Menu', 'Message', 'Minify', 'MooApp', 'MooUpload', 'Music', 'OpenIdConnect', 'Page', 'PaymentGateway', 'PaypalAdaptive', 'PaypalExpress', 'Photo', 'Poke', 'Poll', 'Popup', 'ProfileCompletion', 'Property', 'Przelewy24', 'Queue', 'Reaction', 'Reminder', 'Scheduledpost', 'Scrolltotop', 'SocialIntegration', 'SocialPublisher', 'Spotlight', 'Statistic', 'StickySidebar', 'Storage', 'Store', 'Subscription', 'Tawkto', 'Tools', 'Topic', 'Tourguide', 'TranslationTool', 'UploadVideo', 'Usernotes', 'Video', 'VisualNotification', 'Whonearme', 'Whoviewme', '') AND `Activity`.`status` = 'ok' AND `Activity`.`is_scheduled` = '0' ORDER BY `Activity`.`pin` DESC, `Activity`.`pin_date` DESC, `Activity`.`modified` desc LIMIT 12 | | 1 | 1 | 3 |
25 | 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` FROM `druzi`.`activity_comments` AS `ActivityComment` WHERE `ActivityComment`.`activity_id` = (5758) ORDER BY `ActivityComment`.`id` desc LIMIT 1 | | 0 | 0 | 0 |
26 | SELECT *, `Activity`.`id` FROM `druzi`.`activities` AS `Activity` LEFT JOIN `druzi`.`users` AS `User` ON (`Activity`.`user_id` = `User`.`id`) LEFT JOIN `druzi`.`user_taggings` AS `UserTagging` ON (`Activity`.`id` = `UserTagging`.`item_id` AND `UserTagging`.`item_table` = 'activities') WHERE ((((`Activity`.`type` = 'Group_Group') AND (`Activity`.`action` = 'group_join') AND (CONCAT(",",`Activity`.`items`,",") LIKE "%,18,%"))) OR (((`Activity`.`type` = 'Group_Group') AND (`Activity`.`target_id` = 18)))) AND `Activity`.`Plugin` IN ('Activitylog', 'Ads', 'Announcement', 'Api', 'Avatar', 'Backup', 'Billing', 'Bookmark', 'Business', 'Chat', 'Checkin', 'Classified', 'Credit', 'Cron', 'Document', 'DotPay', 'DownloadCopyData', 'Elearning', 'Event', 'FakeInteraction', 'Fakeuser', 'Forum', 'FriendInviter', 'Fundraising', 'GifComment', 'Gift', 'Group', 'Homeblock', 'Indeed', 'Job', 'LandingManager', 'Livenews', 'MagicPage', 'Mail', 'Matchmaking', 'Meetme', 'Menu', 'Message', 'Minify', 'MooApp', 'MooUpload', 'Music', 'OpenIdConnect', 'Page', 'PaymentGateway', 'PaypalAdaptive', 'PaypalExpress', 'Photo', 'Poke', 'Poll', 'Popup', 'ProfileCompletion', 'Property', 'Przelewy24', 'Queue', 'Reaction', 'Reminder', 'Scheduledpost', 'Scrolltotop', 'SocialIntegration', 'SocialPublisher', 'Spotlight', 'Statistic', 'StickySidebar', 'Storage', 'Store', 'Subscription', 'Tawkto', 'Tools', 'Topic', 'Tourguide', 'TranslationTool', 'UploadVideo', 'Usernotes', 'Video', 'VisualNotification', 'Whonearme', 'Whoviewme', '') AND `Activity`.`status` = 'ok' AND `Activity`.`is_scheduled` = '0' AND `Activity`.`id` = 5758 ORDER BY `Activity`.`modified` desc LIMIT 1 | | 1 | 1 | 1 |
27 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `druzi`.`roles` AS `Role` WHERE `Role`.`id` = 2 | | 1 | 1 | 0 |
28 | SELECT `Like`.`id`, `Like`.`user_id`, `Like`.`target_id`, `Like`.`type`, `Like`.`thumb_up`, `Like`.`reaction` FROM `druzi`.`likes` AS `Like` WHERE `Like`.`type` = 'activity' AND `Like`.`target_id` = (5758) | | 0 | 0 | 0 |
29 | SELECT COUNT(*) AS `count` FROM `druzi`.`comments` AS `Comment` LEFT JOIN `druzi`.`users` AS `User` ON (`Comment`.`user_id` = `User`.`id`) WHERE `Comment`.`target_id` = 3639 AND `Comment`.`type` = 'Photo_Photo' | | 1 | 1 | 0 |
30 | 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`, `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`.`group_count`, `User`.`event_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`.`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`.`viewer_invisible`, `User`.`chat_online_status`, `User`.`lock_delete`, `User`.`hide_profile_complete`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`fake_auto_friend`, `User`.`fake_total_run`, `User`.`fake_current_run`, `User`.`fake_time_updated`, `User`.`fake_next_run_time`, `User`.`signature`, `User`.`show_signature`, `User`.`poked_email` FROM `druzi`.`comments` AS `Comment` LEFT JOIN `druzi`.`users` AS `User` ON (`Comment`.`user_id` = `User`.`id`) WHERE `Comment`.`target_id` = 3639 AND `Comment`.`type` = 'Photo_Photo' ORDER BY `Comment`.`id` desc LIMIT 1 | | 0 | 0 | 0 |
31 | SELECT `Like`.`user_id`, `Like`.`thumb_up` FROM `druzi`.`likes` AS `Like` WHERE `Like`.`target_id` = 3639 AND `Like`.`type` = 'Photo_Photo' ORDER BY `Like`.`id` desc | | 0 | 0 | 0 |
32 | SELECT `UserSettingFeed`.`id`, `UserSettingFeed`.`type`, `UserSettingFeed`.`active`, `UserSettingFeed`.`text`, `UserSettingFeed`.`plugin` FROM `druzi`.`user_setting_feeds` AS `UserSettingFeed` WHERE `active` = '0' | | 0 | 0 | 0 |
33 | SELECT COUNT(*) AS `count` FROM `druzi`.`activities` AS `Activity` WHERE ((((`Activity`.`type` = 'Group_Group') AND (`Activity`.`action` = 'group_join') AND (CONCAT(",",`Activity`.`items`,",") LIKE "%,18,%"))) OR (((`Activity`.`type` = 'Group_Group') AND (`Activity`.`target_id` = 18)))) AND `Activity`.`Plugin` IN ('Activitylog', 'Ads', 'Announcement', 'Api', 'Avatar', 'Backup', 'Billing', 'Bookmark', 'Business', 'Chat', 'Checkin', 'Classified', 'Credit', 'Cron', 'Document', 'DotPay', 'DownloadCopyData', 'Elearning', 'Event', 'FakeInteraction', 'Fakeuser', 'Forum', 'FriendInviter', 'Fundraising', 'GifComment', 'Gift', 'Group', 'Homeblock', 'Indeed', 'Job', 'LandingManager', 'Livenews', 'MagicPage', 'Mail', 'Matchmaking', 'Meetme', 'Menu', 'Message', 'Minify', 'MooApp', 'MooUpload', 'Music', 'OpenIdConnect', 'Page', 'PaymentGateway', 'PaypalAdaptive', 'PaypalExpress', 'Photo', 'Poke', 'Poll', 'Popup', 'ProfileCompletion', 'Property', 'Przelewy24', 'Queue', 'Reaction', 'Reminder', 'Scheduledpost', 'Scrolltotop', 'SocialIntegration', 'SocialPublisher', 'Spotlight', 'Statistic', 'StickySidebar', 'Storage', 'Store', 'Subscription', 'Tawkto', 'Tools', 'Topic', 'Tourguide', 'TranslationTool', 'UploadVideo', 'Usernotes', 'Video', 'VisualNotification', 'Whonearme', 'Whoviewme', '') AND `Activity`.`status` = 'ok' AND `Activity`.`is_scheduled` = '0' | | 1 | 1 | 4 |
34 | SELECT `GroupUser`.`id`, `GroupUser`.`group_id`, `GroupUser`.`user_id`, `GroupUser`.`status`, `GroupUser`.`created`, `Group`.`id`, `Group`.`category_id`, `Group`.`name`, `Group`.`user_id`, `Group`.`description`, `Group`.`type`, `Group`.`photo`, `Group`.`group_user_count`, `Group`.`created`, `Group`.`photo_count`, `Group`.`topic_count`, `Group`.`video_count`, `Group`.`event_count`, `Group`.`featured`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_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`.`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`.`viewer_invisible`, `User`.`chat_online_status`, `User`.`lock_delete`, `User`.`hide_profile_complete`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`fake_auto_friend`, `User`.`fake_total_run`, `User`.`fake_current_run`, `User`.`fake_time_updated`, `User`.`fake_next_run_time`, `User`.`signature`, `User`.`show_signature`, `User`.`poked_email` FROM `druzi`.`group_users` AS `GroupUser` LEFT JOIN `druzi`.`groups` AS `Group` ON (`GroupUser`.`group_id` = `Group`.`id`) LEFT JOIN `druzi`.`users` AS `User` ON (`GroupUser`.`user_id` = `User`.`id`) WHERE `GroupUser`.`group_id` = 18 AND `GroupUser`.`user_id` = '' LIMIT 1 | | 0 | 0 | 1 |
35 | SELECT `GroupUser`.`id`, `GroupUser`.`user_id` FROM `druzi`.`group_users` AS `GroupUser` WHERE `group_id` = 18 AND `status` = 3 | | 1 | 1 | 0 |
36 | 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 `druzi`.`categories` AS `Category` INNER JOIN `druzi`.`i18n` AS `I18n__nameTranslation` ON (`Category`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Category' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'ukr') WHERE `Category`.`type` = 'Video' AND `Category`.`active` = '1' ORDER BY `Category`.`weight` asc | | 1 | 1 | 1 |
37 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `druzi`.`i18n` AS `nameTranslation` WHERE `model` = 'Category' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (25) ORDER BY `id` ASC | | 4 | 4 | 0 |
38 | SELECT `GroupUser`.`id`, `GroupUser`.`group_id`, `GroupUser`.`user_id`, `GroupUser`.`status`, `GroupUser`.`created`, `Group`.`id`, `Group`.`category_id`, `Group`.`name`, `Group`.`user_id`, `Group`.`description`, `Group`.`type`, `Group`.`photo`, `Group`.`group_user_count`, `Group`.`created`, `Group`.`photo_count`, `Group`.`topic_count`, `Group`.`video_count`, `Group`.`event_count`, `Group`.`featured`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_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`.`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`.`viewer_invisible`, `User`.`chat_online_status`, `User`.`lock_delete`, `User`.`hide_profile_complete`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`fake_auto_friend`, `User`.`fake_total_run`, `User`.`fake_current_run`, `User`.`fake_time_updated`, `User`.`fake_next_run_time`, `User`.`signature`, `User`.`show_signature`, `User`.`poked_email` FROM `druzi`.`group_users` AS `GroupUser` LEFT JOIN `druzi`.`groups` AS `Group` ON (`GroupUser`.`group_id` = `Group`.`id`) LEFT JOIN `druzi`.`users` AS `User` ON (`GroupUser`.`user_id` = `User`.`id`) WHERE `group_id` = 18 AND `User`.`active` = '1' AND `status` = 3 ORDER BY `GroupUser`.`id` desc LIMIT 10 | | 1 | 1 | 1 |
39 | SELECT `GroupUser`.`id`, `GroupUser`.`group_id`, `GroupUser`.`user_id`, `GroupUser`.`status`, `GroupUser`.`created`, `Group`.`id`, `Group`.`category_id`, `Group`.`name`, `Group`.`user_id`, `Group`.`description`, `Group`.`type`, `Group`.`photo`, `Group`.`group_user_count`, `Group`.`created`, `Group`.`photo_count`, `Group`.`topic_count`, `Group`.`video_count`, `Group`.`event_count`, `Group`.`featured`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_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`.`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`.`viewer_invisible`, `User`.`chat_online_status`, `User`.`lock_delete`, `User`.`hide_profile_complete`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`fake_auto_friend`, `User`.`fake_total_run`, `User`.`fake_current_run`, `User`.`fake_time_updated`, `User`.`fake_next_run_time`, `User`.`signature`, `User`.`show_signature`, `User`.`poked_email` FROM `druzi`.`group_users` AS `GroupUser` LEFT JOIN `druzi`.`groups` AS `Group` ON (`GroupUser`.`group_id` = `Group`.`id`) LEFT JOIN `druzi`.`users` AS `User` ON (`GroupUser`.`user_id` = `User`.`id`) WHERE `group_id` = 18 AND `User`.`active` = '1' AND `status` = 1 ORDER BY `GroupUser`.`id` desc LIMIT 10 | | 0 | 0 | 0 |
40 | SELECT `Group`.`id`, `Group`.`category_id`, `Group`.`name`, `Group`.`user_id`, `Group`.`description`, `Group`.`type`, `Group`.`photo`, `Group`.`group_user_count`, `Group`.`created`, `Group`.`photo_count`, `Group`.`topic_count`, `Group`.`video_count`, `Group`.`event_count`, `Group`.`featured`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_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`.`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`.`viewer_invisible`, `User`.`chat_online_status`, `User`.`lock_delete`, `User`.`hide_profile_complete`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`fake_auto_friend`, `User`.`fake_total_run`, `User`.`fake_current_run`, `User`.`fake_time_updated`, `User`.`fake_next_run_time`, `User`.`signature`, `User`.`show_signature`, `User`.`poked_email`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission` FROM `druzi`.`groups` AS `Group` LEFT JOIN `druzi`.`users` AS `User` ON (`Group`.`user_id` = `User`.`id`) LEFT JOIN `druzi`.`categories` AS `Category` ON (`Group`.`category_id` = `Category`.`id`) WHERE `Group`.`type` <> 2 AND DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= Group.created AND `User`.`active` = '1' ORDER BY `Group`.`group_user_count` desc LIMIT 5 | | 0 | 0 | 1 |
41 | SELECT `Coremenu`.`id`, `Coremenu`.`name`, `Coremenu`.`style`, `Coremenu`.`alias`, `Coremenu`.`menuid` FROM `druzi`.`core_menus` AS `Coremenu` WHERE `id` = 2 LIMIT 1 | | 1 | 1 | 0 |
42 | 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 `druzi`.`core_menu_items` AS `CoreMenuItem` WHERE `CoreMenuItem`.`is_active` = '1' AND `CoreMenuItem`.`menu_id` = (2) ORDER BY `CoreMenuItem`.`menu_order` ASC | | 5 | 5 | 0 |
43 | SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `druzi`.`i18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (10, 11, 12, 9, 13) ORDER BY `id` ASC | | 20 | 20 | 1 |
44 | 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 `druzi`.`core_menu_items` AS `Coremenuitem` INNER JOIN `druzi`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'ukr') WHERE `parent_id` = 10 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 2 |
45 | 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 `druzi`.`core_menu_items` AS `Coremenuitem` INNER JOIN `druzi`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'ukr') WHERE `parent_id` = 11 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 2 |
46 | 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 `druzi`.`core_menu_items` AS `Coremenuitem` INNER JOIN `druzi`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'ukr') WHERE `parent_id` = 12 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 2 |
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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `druzi`.`core_menu_items` AS `Coremenuitem` INNER JOIN `druzi`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'ukr') WHERE `parent_id` = 9 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 2 |
48 | 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 `druzi`.`core_menu_items` AS `Coremenuitem` INNER JOIN `druzi`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'ukr') WHERE `parent_id` = 13 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 2 |
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 `druzi`.`core_menu_items` AS `CoreMenuItem` INNER JOIN `druzi`.`i18n` AS `I18n__nameMenuTranslation` ON (`CoreMenuItem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'ukr') WHERE `CoreMenuItem`.`url` = '/groupsview18tab:topics' LIMIT 1 | | 0 | 0 | 2 |
50 | 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 `druzi`.`plugins` AS `Plugin` WHERE `Plugin`.`key` = 'UploadVideo' ORDER BY `Plugin`.`weight` asc LIMIT 1 | | 1 | 1 | 0 |
51 | SELECT `Tawkto`.`id`, `Tawkto`.`PageId`, `Tawkto`.`WidgetId` FROM `druzi`.`tawktos` AS `Tawkto` WHERE 1 = 1 LIMIT 1 | | 1 | 1 | 0 |
52 | SELECT `Page`.`id` FROM `druzi`.`pages` AS `Page` LEFT JOIN `druzi`.`themes` AS `MyCoreTheme` ON (`Page`.`theme_id` = `MyCoreTheme`.`id`) WHERE `Page`.`uri` = 'groups.view' ORDER BY `Page`.`weight` asc LIMIT 1 | | 1 | 1 | 0 |
53 | SELECT `CoreContent`.`id`, `CoreContent`.`page_id`, `CoreContent`.`type`, `CoreContent`.`name`, `CoreContent`.`component`, `CoreContent`.`parent_id`, `CoreContent`.`order`, `CoreContent`.`params`, `CoreContent`.`attribs`, `CoreContent`.`lft`, `CoreContent`.`rght`, `CoreContent`.`column`, `CoreContent`.`core_block_id`, `CoreContent`.`core_content_count`, `CoreContent`.`invisible`, `CoreContent`.`core_block_title`, `CoreContent`.`plugin`, `CoreContent`.`role_access` FROM `druzi`.`core_contents` AS `CoreContent` WHERE `CoreContent`.`page_id` = (18) | | 9 | 9 | 0 |
54 | SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count`, `MyCorePage`.`plugin`, `MyCorePage`.`show_layout` FROM `druzi`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 18 | | 1 | 1 | 0 |
55 | SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count`, `MyCorePage`.`plugin`, `MyCorePage`.`show_layout` FROM `druzi`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 18 | | 1 | 1 | 0 |
56 | SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count`, `MyCorePage`.`plugin`, `MyCorePage`.`show_layout` FROM `druzi`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 18 | | 1 | 1 | 0 |
57 | SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count`, `MyCorePage`.`plugin`, `MyCorePage`.`show_layout` FROM `druzi`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 18 | | 1 | 1 | 0 |
58 | SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count`, `MyCorePage`.`plugin`, `MyCorePage`.`show_layout` FROM `druzi`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 18 | | 1 | 1 | 0 |
59 | SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count`, `MyCorePage`.`plugin`, `MyCorePage`.`show_layout` FROM `druzi`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 18 | | 1 | 1 | 0 |
60 | SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count`, `MyCorePage`.`plugin`, `MyCorePage`.`show_layout` FROM `druzi`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 18 | | 1 | 1 | 0 |
61 | SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count`, `MyCorePage`.`plugin`, `MyCorePage`.`show_layout` FROM `druzi`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 18 | | 1 | 1 | 0 |
62 | SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count`, `MyCorePage`.`plugin`, `MyCorePage`.`show_layout` FROM `druzi`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 18 | | 1 | 1 | 0 |
63 | SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin`, `Parent`.`role_access` FROM `druzi`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 86 | | 1 | 1 | 0 |
64 | SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin`, `Parent`.`role_access` FROM `druzi`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 90 | | 1 | 1 | 0 |
65 | SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin`, `Parent`.`role_access` FROM `druzi`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 88 | | 1 | 1 | 0 |
66 | SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin`, `Parent`.`role_access` FROM `druzi`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 88 | | 1 | 1 | 0 |
67 | SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin`, `Parent`.`role_access` FROM `druzi`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 88 | | 1 | 1 | 0 |
68 | SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin`, `Parent`.`role_access` FROM `druzi`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 88 | | 1 | 1 | 0 |
69 | SELECT `Children`.`id`, `Children`.`page_id`, `Children`.`type`, `Children`.`name`, `Children`.`component`, `Children`.`parent_id`, `Children`.`order`, `Children`.`params`, `Children`.`attribs`, `Children`.`lft`, `Children`.`rght`, `Children`.`column`, `Children`.`core_block_id`, `Children`.`core_content_count`, `Children`.`invisible`, `Children`.`core_block_title`, `Children`.`plugin`, `Children`.`role_access` FROM `druzi`.`core_contents` AS `Children` WHERE `Children`.`parent_id` IN (86, 87, 88, 90, 91, 171, 172, 173, 89) | | 6 | 6 | 1 |
70 | SELECT `CoreContentValue`.`id`, `CoreContentValue`.`content_id`, `CoreContentValue`.`field_name`, `CoreContentValue`.`value` FROM `druzi`.`core_content_values` AS `CoreContentValue` WHERE `CoreContentValue`.`content_id` IN (86, 87, 88, 90, 91, 171, 172, 173, 89) | | 0 | 0 | 0 |
71 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `druzi`.`i18n` AS `nameTranslation` WHERE `model` = 'CoreContent' AND `field` = 'core_block_title' AND `nameTranslation`.`foreign_key` IN (86, 87, 88, 90, 91, 171, 172, 173, 89) ORDER BY `id` ASC | | 36 | 36 | 1 |
72 | SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `druzi`.`i18n` AS `titleTranslation` WHERE `model` = 'Page' AND `field` = 'title' AND `titleTranslation`.`foreign_key` = (18) ORDER BY `id` ASC | | 4 | 4 | 1 |
73 | SELECT `contentTranslation`.`id`, `contentTranslation`.`locale`, `contentTranslation`.`model`, `contentTranslation`.`foreign_key`, `contentTranslation`.`field`, `contentTranslation`.`content` FROM `druzi`.`i18n` AS `contentTranslation` WHERE `model` = 'Page' AND `field` = 'content' AND `contentTranslation`.`foreign_key` = (18) ORDER BY `id` ASC | | 4 | 4 | 1 |
74 | SELECT `Tourguide`.`id`, `Tourguide`.`title`, `Tourguide`.`page_id`, `Tourguide`.`role_access_id`, `Tourguide`.`created`, `Tourguide`.`user_id`, `Tourguide`.`enable`, (`I18n__titleTranslation`.`content`) AS `Tourguide__i18n_titleTranslation` FROM `druzi`.`tourguides` AS `Tourguide` INNER JOIN `druzi`.`i18n` AS `I18n__titleTranslation` ON (`Tourguide`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Tourguide' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'ukr') WHERE `Tourguide`.`page_id` LIKE '%\"0\"%' AND `enable` = '1' LIMIT 1 | | 0 | 0 | 0 |
75 | SELECT `Tourguide`.`id`, `Tourguide`.`title`, `Tourguide`.`page_id`, `Tourguide`.`role_access_id`, `Tourguide`.`created`, `Tourguide`.`user_id`, `Tourguide`.`enable`, (`I18n__titleTranslation`.`content`) AS `Tourguide__i18n_titleTranslation` FROM `druzi`.`tourguides` AS `Tourguide` INNER JOIN `druzi`.`i18n` AS `I18n__titleTranslation` ON (`Tourguide`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Tourguide' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'ukr') WHERE `Tourguide`.`page_id` LIKE '%\"18\"%' AND `enable` = '1' LIMIT 1 | | 0 | 0 | 0 |
76 | SELECT `Bookmark`.`id`, `Bookmark`.`user_id`, `Bookmark`.`object_type`, `Bookmark`.`object_id`, `Bookmark`.`created` FROM `druzi`.`bookmarks` AS `Bookmark` WHERE `Bookmark`.`user_id` = '' AND `Bookmark`.`object_type` = 'Group_Group' AND `Bookmark`.`object_id` = 18 LIMIT 1 | | 0 | 0 | 0 |
77 | 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 `druzi`.`themes` AS `Theme` WHERE `Theme`.`key` = 'default' LIMIT 1 | | 1 | 1 | 0 |
78 | 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 `druzi`.`settings` AS `Setting` LEFT JOIN `druzi`.`setting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1 | | 1 | 1 | 0 |
79 | 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 `druzi`.`settings` AS `Setting` LEFT JOIN `druzi`.`setting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1 | | 1 | 1 | 0 |
80 | SELECT COUNT(*) AS `count` FROM `druzi`.`gateways` AS `Gateway` WHERE `enabled` = '1' | | 1 | 1 | 0 |
81 | SELECT COUNT(DISTINCT(`SubscriptionPackagePlan`.`id`)) AS count FROM `druzi`.`subscription_package_plans` AS `SubscriptionPackagePlan` INNER JOIN `druzi`.`i18n` AS `I18nModel` ON (`SubscriptionPackagePlan`.`id` = `I18nModel`.`foreign_key` AND `I18nModel`.`model` = 'SubscriptionPackagePlan' AND `I18nModel`.`locale` = 'ukr') WHERE `deleted` = 0 AND `enable_plan` = '1' | | 1 | 1 | 1 |
82 | 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 `druzi`.`themes` AS `Theme` WHERE `Theme`.`key` = 'default' LIMIT 1 | | 1 | 1 | 0 |