1 | SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`user_id` FROM `ekonty_moo`.`cake_sessions` AS `Session` WHERE `Session`.`id` = '86e84d47564af202b661a15f2b15c429' LIMIT 1 | | 0 | 0 | 0 |
2 | SELECT `RateCurrency`.`id`, `RateCurrency`.`alpha3`, `RateCurrency`.`currency_id`, `RateCurrency`.`name`, `RateCurrency`.`currency_name`, `RateCurrency`.`currency_symbol`, `RateCurrency`.`created`, `RateCurrency`.`modified` FROM `ekonty_moo`.`rate_currencies` AS `RateCurrency` WHERE `id` = 'USD' LIMIT 1 | | 0 | 0 | 0 |
3 | SELECT `Plugin`.`enabled` FROM `ekonty_moo`.`plugins` AS `Plugin` WHERE `Plugin`.`key` = 'Storage' ORDER BY `Plugin`.`id` asc LIMIT 1 | | 1 | 1 | 0 |
4 | SELECT `Plugin`.`enabled` FROM `ekonty_moo`.`plugins` AS `Plugin` WHERE `Plugin`.`key` = 'Storage' ORDER BY `Plugin`.`id` asc LIMIT 1 | | 1 | 1 | 0 |
5 | SELECT `Plugin`.`enabled` FROM `ekonty_moo`.`plugins` AS `Plugin` WHERE `Plugin`.`key` = 'Storage' ORDER BY `Plugin`.`id` asc LIMIT 1 | | 1 | 1 | 0 |
6 | SELECT `Plugin`.`enabled` FROM `ekonty_moo`.`plugins` AS `Plugin` WHERE `Plugin`.`key` = 'Storage' ORDER BY `Plugin`.`id` asc LIMIT 1 | | 1 | 1 | 0 |
7 | SELECT `Plugin`.`enabled` FROM `ekonty_moo`.`plugins` AS `Plugin` WHERE `Plugin`.`key` = 'Storage' ORDER BY `Plugin`.`id` asc LIMIT 1 | | 1 | 1 | 0 |
8 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `ekonty_moo`.`roles` AS `Role` WHERE `Role`.`id` = 3 LIMIT 1 | | 1 | 1 | 0 |
9 | SELECT `BusinessLocation`.`id` FROM `ekonty_moo`.`business_locations` AS `BusinessLocation` WHERE `BusinessLocation`.`parent_id` = 0 AND `BusinessLocation`.`enabled` = '1' ORDER BY `BusinessLocation`.`ordering` ASC | | 39 | 39 | 1 |
10 | SELECT `BusinessLocation`.`id`, `BusinessLocation`.`parent_id`, `BusinessLocation`.`lft`, `BusinessLocation`.`rght`, `BusinessLocation`.`name`, `BusinessLocation`.`business_count`, `BusinessLocation`.`is_default`, `BusinessLocation`.`on_popup`, `BusinessLocation`.`enabled`, `BusinessLocation`.`ordering`, `BusinessLocation`.`created`, `BusinessLocation`.`updated`, `BusinessLocation`.`city` FROM `ekonty_moo`.`business_locations` AS `BusinessLocation` WHERE `BusinessLocation`.`is_default` = '1' AND `BusinessLocation`.`parent_id` IN (311, 135, 142, 173, 179, 202, 208, 234, 246, 307, 106, 389, 403, 457, 463, 471, 560, 597, 609, 617, 93, 8, 10, 12, 15, 21, 23, 26, 37, 42, 46, 49, 1, 2, 3, 4, 5, 6, 7) ORDER BY `BusinessLocation`.`ordering` ASC LIMIT 1 | | 0 | 0 | 1 |
11 | SELECT COUNT(*) AS `count` FROM `ekonty_moo`.`businesses` AS `Business` WHERE `Business`.`id` = 69 | | 1 | 1 | 0 |
12 | SELECT COUNT(*) AS `count` FROM `ekonty_moo`.`businesses` AS `Business` WHERE `Business`.`id` = 69 AND `Business`.`user_id` = '' | | 1 | 1 | 0 |
13 | SELECT COUNT(*) AS `count` FROM `ekonty_moo`.`businesses` AS `Business` WHERE `Business`.`id` = 69 AND `Business`.`user_id` = '' | | 1 | 1 | 0 |
14 | SELECT COUNT(*) AS `count` FROM `ekonty_moo`.`business_admins` AS `BusinessAdmin` WHERE `BusinessAdmin`.`business_id` = 69 AND `BusinessAdmin`.`user_id` = '' | | 1 | 1 | 0 |
15 | SELECT COUNT(*) AS `count` FROM `ekonty_moo`.`businesses` AS `Business` WHERE `Business`.`id` = 69 AND `Business`.`status` = 'approved' | | 1 | 1 | 0 |
16 | SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`whatsapp`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated`, `User`.`id`, `User`.`is_old`, `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`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `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`.`lock_delete`, `User`.`darkmode`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`phone`, `User`.`phone_verified`, `User`.`poked_email`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_online_status`, `User`.`hide_profile_complete`, `User`.`sendinblue_id`, `User`.`mobile_csv`, `User`.`qualification_csv`, `User`.`is_csv`, `User`.`subscriber_uid`, `User`.`list_uid`, `User`.`viewer_invisible`, `User`.`showlastseen`, `User`.`lastseen`, `User`.`first_name`, `User`.`last_name`, `User`.`online`, `User`.`interest_values`, `BusinessLocation`.`id`, `BusinessLocation`.`parent_id`, `BusinessLocation`.`lft`, `BusinessLocation`.`rght`, `BusinessLocation`.`name`, `BusinessLocation`.`business_count`, `BusinessLocation`.`is_default`, `BusinessLocation`.`on_popup`, `BusinessLocation`.`enabled`, `BusinessLocation`.`ordering`, `BusinessLocation`.`created`, `BusinessLocation`.`updated`, `BusinessLocation`.`city`, `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial`, `BusinessType`.`id`, `BusinessType`.`name`, `BusinessType`.`enable`, `BusinessType`.`ordering`, `BusinessType`.`created`, `BusinessType`.`updated` FROM `ekonty_moo`.`businesses` AS `Business` LEFT JOIN `ekonty_moo`.`users` AS `User` ON (`Business`.`user_id` = `User`.`id`) LEFT JOIN `ekonty_moo`.`business_locations` AS `BusinessLocation` ON (`Business`.`business_location_id` = `BusinessLocation`.`id`) LEFT JOIN `ekonty_moo`.`business_packages` AS `BusinessPackage` ON (`Business`.`business_package_id` = `BusinessPackage`.`id`) LEFT JOIN `ekonty_moo`.`business_types` AS `BusinessType` ON (`Business`.`business_type_id` = `BusinessType`.`id`) WHERE `Business`.`parent_id` = 0 AND `Business`.`id` = 69 LIMIT 1 | | 1 | 1 | 1 |
17 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `ekonty_moo`.`roles` AS `Role` WHERE `Role`.`id` = 2 | | 1 | 1 | 0 |
18 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | | 5 | 5 | 0 |
19 | SELECT `BusinessTime`.`id`, `BusinessTime`.`business_id`, `BusinessTime`.`day`, `BusinessTime`.`time_open`, `BusinessTime`.`time_close`, `BusinessTime`.`next_day` FROM `ekonty_moo`.`business_times` AS `BusinessTime` WHERE `BusinessTime`.`business_id` = (69) | | 1 | 1 | 3 |
20 | SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `ekonty_moo`.`business_categories` AS `BusinessCategory` JOIN `ekonty_moo`.`business_category_items` AS `BusinessCategoryItem` ON (`BusinessCategoryItem`.`business_id` = 69 AND `BusinessCategoryItem`.`business_category_id` = `BusinessCategory`.`id`) | | 1 | 1 | 0 |
21 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (15) ORDER BY `id` ASC | | 5 | 5 | 0 |
22 | SELECT `BusinessPayment`.`id`, `BusinessPayment`.`name`, `BusinessPayment`.`icon`, `BusinessPayment`.`enable`, `BusinessPayment`.`created`, `BusinessPayment`.`updated`, `BusinessPaymentType`.`id`, `BusinessPaymentType`.`business_payment_id`, `BusinessPaymentType`.`business_id` FROM `ekonty_moo`.`business_payments` AS `BusinessPayment` JOIN `ekonty_moo`.`business_payment_types` AS `BusinessPaymentType` ON (`BusinessPaymentType`.`business_id` = 69 AND `BusinessPaymentType`.`business_payment_id` = `BusinessPayment`.`id`) | | 0 | 0 | 2 |
23 | SELECT `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, (`I18n__nameTranslation`.`content`) AS `ProfileType__i18n_nameTranslation` FROM `ekonty_moo`.`profile_types` AS `ProfileType` INNER JOIN `ekonty_moo`.`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` = 'eng') WHERE `ProfileType`.`id` IN (1, 'eng') AND `ProfileType`.`actived` = '1' ORDER BY `ProfileType`.`order` asc | | 1 | 1 | 0 |
24 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'ProfileType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | | 5 | 5 | 0 |
25 | SELECT `BusinessCategory`.`lft`, `BusinessCategory`.`rght` FROM `ekonty_moo`.`business_categories` AS `BusinessCategory` WHERE `BusinessCategory`.`id` = 15 LIMIT 1 | | 1 | 1 | 0 |
26 | SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `ekonty_moo`.`business_categories` AS `BusinessCategory` INNER JOIN `ekonty_moo`.`i18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE 1 = 1 AND `BusinessCategory`.`lft` <= 29 AND `BusinessCategory`.`rght` >= 30 ORDER BY `BusinessCategory`.`lft` asc | | 1 | 1 | 0 |
27 | SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`whatsapp`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated`, `User`.`id`, `User`.`is_old`, `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`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `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`.`lock_delete`, `User`.`darkmode`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`phone`, `User`.`phone_verified`, `User`.`poked_email`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_online_status`, `User`.`hide_profile_complete`, `User`.`sendinblue_id`, `User`.`mobile_csv`, `User`.`qualification_csv`, `User`.`is_csv`, `User`.`subscriber_uid`, `User`.`list_uid`, `User`.`viewer_invisible`, `User`.`showlastseen`, `User`.`lastseen`, `User`.`first_name`, `User`.`last_name`, `User`.`online`, `User`.`interest_values`, `BusinessLocation`.`id`, `BusinessLocation`.`parent_id`, `BusinessLocation`.`lft`, `BusinessLocation`.`rght`, `BusinessLocation`.`name`, `BusinessLocation`.`business_count`, `BusinessLocation`.`is_default`, `BusinessLocation`.`on_popup`, `BusinessLocation`.`enabled`, `BusinessLocation`.`ordering`, `BusinessLocation`.`created`, `BusinessLocation`.`updated`, `BusinessLocation`.`city`, `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial`, `BusinessType`.`id`, `BusinessType`.`name`, `BusinessType`.`enable`, `BusinessType`.`ordering`, `BusinessType`.`created`, `BusinessType`.`updated` FROM `ekonty_moo`.`businesses` AS `Business` LEFT JOIN `ekonty_moo`.`users` AS `User` ON (`Business`.`user_id` = `User`.`id`) LEFT JOIN `ekonty_moo`.`business_locations` AS `BusinessLocation` ON (`Business`.`business_location_id` = `BusinessLocation`.`id`) LEFT JOIN `ekonty_moo`.`business_packages` AS `BusinessPackage` ON (`Business`.`business_package_id` = `BusinessPackage`.`id`) LEFT JOIN `ekonty_moo`.`business_types` AS `BusinessType` ON (`Business`.`business_type_id` = `BusinessType`.`id`) WHERE `Business`.`id` = 69 LIMIT 1 | | 1 | 1 | 1 |
28 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `ekonty_moo`.`roles` AS `Role` WHERE `Role`.`id` = 2 | | 1 | 1 | 0 |
29 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | | 5 | 5 | 0 |
30 | SELECT `BusinessTime`.`id`, `BusinessTime`.`business_id`, `BusinessTime`.`day`, `BusinessTime`.`time_open`, `BusinessTime`.`time_close`, `BusinessTime`.`next_day` FROM `ekonty_moo`.`business_times` AS `BusinessTime` WHERE `BusinessTime`.`business_id` = (69) | | 1 | 1 | 1 |
31 | SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `ekonty_moo`.`business_categories` AS `BusinessCategory` JOIN `ekonty_moo`.`business_category_items` AS `BusinessCategoryItem` ON (`BusinessCategoryItem`.`business_id` = 69 AND `BusinessCategoryItem`.`business_category_id` = `BusinessCategory`.`id`) | | 1 | 1 | 0 |
32 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (15) ORDER BY `id` ASC | | 5 | 5 | 0 |
33 | SELECT `Store`.`id`, `Store`.`user_id`, `Store`.`business_id`, `Store`.`name`, `Store`.`image`, `Store`.`email`, `Store`.`address`, `Store`.`country_id`, `Store`.`phone`, `Store`.`like_count`, `Store`.`dislike_count`, `Store`.`comment_count`, `Store`.`share_count`, `Store`.`created`, `Store`.`updated`, `Store`.`privacy`, `Store`.`enable`, `Store`.`store_price`, `Store`.`store_transaction_currency`, `Store`.`store_transaction_id`, `Store`.`payments`, `Store`.`featured`, `Store`.`unlimited_feature`, `Store`.`feature_expiration_date`, `Store`.`sent_expiration_email`, `Store`.`policy`, `Store`.`warranty_policy`, `Store`.`balance`, `Store`.`pending_balance`, `User`.`id`, `User`.`is_old`, `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`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `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`.`lock_delete`, `User`.`darkmode`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`phone`, `User`.`phone_verified`, `User`.`poked_email`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_online_status`, `User`.`hide_profile_complete`, `User`.`sendinblue_id`, `User`.`mobile_csv`, `User`.`qualification_csv`, `User`.`is_csv`, `User`.`subscriber_uid`, `User`.`list_uid`, `User`.`viewer_invisible`, `User`.`showlastseen`, `User`.`lastseen`, `User`.`first_name`, `User`.`last_name`, `User`.`online`, `User`.`interest_values` FROM `ekonty_moo`.`stores` AS `Store` LEFT JOIN `ekonty_moo`.`users` AS `User` ON (`Store`.`user_id` = `User`.`id`) WHERE `Store`.`business_id` = 69 LIMIT 1 | | 0 | 0 | 2 |
34 | SELECT `BusinessLocation`.`id`, `BusinessLocation`.`parent_id`, `BusinessLocation`.`lft`, `BusinessLocation`.`rght`, `BusinessLocation`.`name`, `BusinessLocation`.`business_count`, `BusinessLocation`.`is_default`, `BusinessLocation`.`on_popup`, `BusinessLocation`.`enabled`, `BusinessLocation`.`ordering`, `BusinessLocation`.`created`, `BusinessLocation`.`updated`, `BusinessLocation`.`city` FROM `ekonty_moo`.`business_locations` AS `BusinessLocation` WHERE `BusinessLocation`.`id` = 68 ORDER BY `BusinessLocation`.`ordering` ASC LIMIT 1 | | 1 | 1 | 0 |
35 | SELECT COUNT(*) AS `count` FROM `ekonty_moo`.`businesses` AS `Business` WHERE `Business`.`id` = 69 AND `Business`.`user_id` = '' | | 1 | 1 | 0 |
36 | SELECT COUNT(*) AS `count` FROM `ekonty_moo`.`business_admins` AS `BusinessAdmin` WHERE `BusinessAdmin`.`business_id` = 69 AND `BusinessAdmin`.`user_id` = '' | | 1 | 1 | 0 |
37 | SELECT `User`.`id`, `User`.`is_old`, `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`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `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`.`lock_delete`, `User`.`darkmode`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`phone`, `User`.`phone_verified`, `User`.`poked_email`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_online_status`, `User`.`hide_profile_complete`, `User`.`sendinblue_id`, `User`.`mobile_csv`, `User`.`qualification_csv`, `User`.`is_csv`, `User`.`subscriber_uid`, `User`.`list_uid`, `User`.`viewer_invisible`, `User`.`showlastseen`, `User`.`lastseen`, `User`.`first_name`, `User`.`last_name`, `User`.`online`, `User`.`interest_values`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `ekonty_moo`.`users` AS `User` LEFT JOIN `ekonty_moo`.`roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `User`.`id` = '' LIMIT 1 | | 0 | 0 | 0 |
38 | SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`whatsapp`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated`, `User`.`id`, `User`.`is_old`, `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`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `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`.`lock_delete`, `User`.`darkmode`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`phone`, `User`.`phone_verified`, `User`.`poked_email`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_online_status`, `User`.`hide_profile_complete`, `User`.`sendinblue_id`, `User`.`mobile_csv`, `User`.`qualification_csv`, `User`.`is_csv`, `User`.`subscriber_uid`, `User`.`list_uid`, `User`.`viewer_invisible`, `User`.`showlastseen`, `User`.`lastseen`, `User`.`first_name`, `User`.`last_name`, `User`.`online`, `User`.`interest_values`, `BusinessLocation`.`id`, `BusinessLocation`.`parent_id`, `BusinessLocation`.`lft`, `BusinessLocation`.`rght`, `BusinessLocation`.`name`, `BusinessLocation`.`business_count`, `BusinessLocation`.`is_default`, `BusinessLocation`.`on_popup`, `BusinessLocation`.`enabled`, `BusinessLocation`.`ordering`, `BusinessLocation`.`created`, `BusinessLocation`.`updated`, `BusinessLocation`.`city`, `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial`, `BusinessType`.`id`, `BusinessType`.`name`, `BusinessType`.`enable`, `BusinessType`.`ordering`, `BusinessType`.`created`, `BusinessType`.`updated` FROM `ekonty_moo`.`businesses` AS `Business` LEFT JOIN `ekonty_moo`.`users` AS `User` ON (`Business`.`user_id` = `User`.`id`) LEFT JOIN `ekonty_moo`.`business_locations` AS `BusinessLocation` ON (`Business`.`business_location_id` = `BusinessLocation`.`id`) LEFT JOIN `ekonty_moo`.`business_packages` AS `BusinessPackage` ON (`Business`.`business_package_id` = `BusinessPackage`.`id`) LEFT JOIN `ekonty_moo`.`business_types` AS `BusinessType` ON (`Business`.`business_type_id` = `BusinessType`.`id`) WHERE `Business`.`id` = 69 LIMIT 1 | | 1 | 1 | 1 |
39 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `ekonty_moo`.`roles` AS `Role` WHERE `Role`.`id` = 2 | | 1 | 1 | 0 |
40 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | | 5 | 5 | 0 |
41 | SELECT `BusinessTime`.`id`, `BusinessTime`.`business_id`, `BusinessTime`.`day`, `BusinessTime`.`time_open`, `BusinessTime`.`time_close`, `BusinessTime`.`next_day` FROM `ekonty_moo`.`business_times` AS `BusinessTime` WHERE `BusinessTime`.`business_id` = (69) | | 1 | 1 | 1 |
42 | SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `ekonty_moo`.`business_categories` AS `BusinessCategory` JOIN `ekonty_moo`.`business_category_items` AS `BusinessCategoryItem` ON (`BusinessCategoryItem`.`business_id` = 69 AND `BusinessCategoryItem`.`business_category_id` = `BusinessCategory`.`id`) | | 1 | 1 | 0 |
43 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (15) ORDER BY `id` ASC | | 5 | 5 | 0 |
44 | SELECT COUNT(*) AS `count` FROM `ekonty_moo`.`business_reviews` AS `BusinessReview` LEFT JOIN `ekonty_moo`.`users` AS `User` ON (`BusinessReview`.`user_id` = `User`.`id`) WHERE `BusinessReview`.`business_id` = 69 | | 1 | 1 | 0 |
45 | SELECT (FLOOR(`BusinessReview`.`rating`)) AS `BusinessReview__star`, (SUM(`BusinessReview`.`rating`)) AS `BusinessReview__total_rating`, (COUNT(`BusinessReview`.`rating`)) AS `BusinessReview__total_vote` FROM `ekonty_moo`.`business_reviews` AS `BusinessReview` LEFT JOIN `ekonty_moo`.`users` AS `User` ON (`BusinessReview`.`user_id` = `User`.`id`) WHERE `BusinessReview`.`business_id` = 69 GROUP BY (FLOOR(`BusinessReview`.`rating`)) ORDER BY (FLOOR(`BusinessReview`.`rating`)) DESC | | 0 | 0 | 0 |
46 | SELECT COUNT(*) AS `count` FROM `ekonty_moo`.`business_reviews` AS `BusinessReview` WHERE `business_id` = 69 AND `parent_id` = 0 AND `BusinessReview`.`user_id` = '' | | 1 | 1 | 0 |
47 | SELECT `User`.`id`, `User`.`is_old`, `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`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `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`.`lock_delete`, `User`.`darkmode`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`phone`, `User`.`phone_verified`, `User`.`poked_email`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_online_status`, `User`.`hide_profile_complete`, `User`.`sendinblue_id`, `User`.`mobile_csv`, `User`.`qualification_csv`, `User`.`is_csv`, `User`.`subscriber_uid`, `User`.`list_uid`, `User`.`viewer_invisible`, `User`.`showlastseen`, `User`.`lastseen`, `User`.`first_name`, `User`.`last_name`, `User`.`online`, `User`.`interest_values`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `ekonty_moo`.`users` AS `User` LEFT JOIN `ekonty_moo`.`roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `User`.`id` = 88194 LIMIT 1 | | 1 | 1 | 0 |
48 | SELECT COUNT(*) AS `count` FROM `ekonty_moo`.`business_follows` AS `BusinessFollow` WHERE `BusinessFollow`.`business_id` = 69 AND `BusinessFollow`.`user_id` = '' | | 1 | 1 | 0 |
49 | SELECT COUNT(*) AS `count` FROM `ekonty_moo`.`businesses` AS `Business` WHERE `Business`.`user_id` = '' | | 1 | 1 | 2 |
50 | SELECT COUNT(*) AS `count` FROM `ekonty_moo`.`business_favourites` AS `BusinessFavourite` WHERE `BusinessFavourite`.`user_id` = '' AND `BusinessFavourite`.`business_id` = 69 | | 1 | 1 | 0 |
51 | SELECT COUNT(*) AS `count` FROM `ekonty_moo`.`business_follows` AS `BusinessFollow` WHERE `BusinessFollow`.`business_id` = 69 AND `BusinessFollow`.`user_id` = '' AND `BusinessFollow`.`is_banned` = '1' | | 1 | 1 | 0 |
52 | SELECT COUNT(*) AS `count` FROM `ekonty_moo`.`businesses` AS `Business` WHERE `Business`.`id` = 69 AND `Business`.`user_id` = '' | | 1 | 1 | 0 |
53 | SELECT COUNT(*) AS `count` FROM `ekonty_moo`.`business_admins` AS `BusinessAdmin` WHERE `BusinessAdmin`.`business_id` = 69 AND `BusinessAdmin`.`user_id` = '' | | 1 | 1 | 0 |
54 | SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`whatsapp`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated`, `User`.`id`, `User`.`is_old`, `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`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `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`.`lock_delete`, `User`.`darkmode`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`phone`, `User`.`phone_verified`, `User`.`poked_email`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_online_status`, `User`.`hide_profile_complete`, `User`.`sendinblue_id`, `User`.`mobile_csv`, `User`.`qualification_csv`, `User`.`is_csv`, `User`.`subscriber_uid`, `User`.`list_uid`, `User`.`viewer_invisible`, `User`.`showlastseen`, `User`.`lastseen`, `User`.`first_name`, `User`.`last_name`, `User`.`online`, `User`.`interest_values`, `BusinessLocation`.`id`, `BusinessLocation`.`parent_id`, `BusinessLocation`.`lft`, `BusinessLocation`.`rght`, `BusinessLocation`.`name`, `BusinessLocation`.`business_count`, `BusinessLocation`.`is_default`, `BusinessLocation`.`on_popup`, `BusinessLocation`.`enabled`, `BusinessLocation`.`ordering`, `BusinessLocation`.`created`, `BusinessLocation`.`updated`, `BusinessLocation`.`city`, `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial`, `BusinessType`.`id`, `BusinessType`.`name`, `BusinessType`.`enable`, `BusinessType`.`ordering`, `BusinessType`.`created`, `BusinessType`.`updated` FROM `ekonty_moo`.`businesses` AS `Business` LEFT JOIN `ekonty_moo`.`users` AS `User` ON (`Business`.`user_id` = `User`.`id`) LEFT JOIN `ekonty_moo`.`business_locations` AS `BusinessLocation` ON (`Business`.`business_location_id` = `BusinessLocation`.`id`) LEFT JOIN `ekonty_moo`.`business_packages` AS `BusinessPackage` ON (`Business`.`business_package_id` = `BusinessPackage`.`id`) LEFT JOIN `ekonty_moo`.`business_types` AS `BusinessType` ON (`Business`.`business_type_id` = `BusinessType`.`id`) WHERE `Business`.`id` = 69 LIMIT 1 | | 1 | 1 | 1 |
55 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `ekonty_moo`.`roles` AS `Role` WHERE `Role`.`id` = 2 | | 1 | 1 | 0 |
56 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | | 5 | 5 | 0 |
57 | SELECT `BusinessTime`.`id`, `BusinessTime`.`business_id`, `BusinessTime`.`day`, `BusinessTime`.`time_open`, `BusinessTime`.`time_close`, `BusinessTime`.`next_day` FROM `ekonty_moo`.`business_times` AS `BusinessTime` WHERE `BusinessTime`.`business_id` = (69) | | 1 | 1 | 1 |
58 | SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `ekonty_moo`.`business_categories` AS `BusinessCategory` JOIN `ekonty_moo`.`business_category_items` AS `BusinessCategoryItem` ON (`BusinessCategoryItem`.`business_id` = 69 AND `BusinessCategoryItem`.`business_category_id` = `BusinessCategory`.`id`) | | 1 | 1 | 0 |
59 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (15) ORDER BY `id` ASC | | 5 | 5 | 0 |
60 | SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`whatsapp`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated`, `User`.`id`, `User`.`is_old`, `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`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `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`.`lock_delete`, `User`.`darkmode`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`phone`, `User`.`phone_verified`, `User`.`poked_email`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_online_status`, `User`.`hide_profile_complete`, `User`.`sendinblue_id`, `User`.`mobile_csv`, `User`.`qualification_csv`, `User`.`is_csv`, `User`.`subscriber_uid`, `User`.`list_uid`, `User`.`viewer_invisible`, `User`.`showlastseen`, `User`.`lastseen`, `User`.`first_name`, `User`.`last_name`, `User`.`online`, `User`.`interest_values`, `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial` FROM `ekonty_moo`.`businesses` AS `Business` LEFT JOIN `ekonty_moo`.`users` AS `User` ON (`Business`.`user_id` = `User`.`id`) LEFT JOIN `ekonty_moo`.`business_packages` AS `BusinessPackage` ON (`Business`.`business_package_id` = `BusinessPackage`.`id`) WHERE `Business`.`id` = 69 LIMIT 1 | | 1 | 1 | 1 |
61 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `ekonty_moo`.`roles` AS `Role` WHERE `Role`.`id` = 2 | | 1 | 1 | 0 |
62 | SELECT COUNT(*) AS `count` FROM `ekonty_moo`.`business_reviews` AS `BusinessReview` WHERE `business_id` = 69 AND `parent_id` = 0 AND `BusinessReview`.`user_id` = '' | | 1 | 1 | 0 |
63 | SELECT COUNT(*) AS `count` FROM `ekonty_moo`.`businesses` AS `Business` WHERE `Business`.`id` = 69 AND `Business`.`user_id` = '' | | 1 | 1 | 0 |
64 | SELECT `Activity`.`id`, `Activity`.`type`, `Activity`.`target_id`, `Activity`.`user_id`, `Activity`.`parent_id`, `Activity`.`action`, `Activity`.`text`, `Activity`.`content`, `Activity`.`items`, `Activity`.`item_type`, `Activity`.`item_id`, `Activity`.`created`, `Activity`.`activity_comment_count`, `Activity`.`query`, `Activity`.`privacy`, `Activity`.`modified`, `Activity`.`params`, `Activity`.`like_count`, `Activity`.`dislike_count`, `Activity`.`plugin`, `Activity`.`edited`, `Activity`.`share`, `Activity`.`status`, `Activity`.`source_url`, `Activity`.`close_comment`, `Activity`.`close_comment_user`, `Activity`.`pin_date`, `Activity`.`pin`, `Activity`.`pin_user_id`, `Activity`.`activity_pin_date`, `Activity`.`activity_pin`, `Activity`.`activity_pin_user_id`, `Activity`.`business_post_as`, `Activity`.`checkin_name`, `Activity`.`checkin_address`, `Activity`.`checkin_lat`, `Activity`.`checkin_lng`, `Activity`.`sticker_image_id`, `Activity`.`status_background_id`, `Activity`.`is_boost`, `Activity`.`is_scheduled`, `Activity`.`time_scheduled`, `Activity`.`timezone_scheduled`, `Activity`.`timezone_scheduled_default`, `User`.`id`, `User`.`is_old`, `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`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `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`.`lock_delete`, `User`.`darkmode`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`phone`, `User`.`phone_verified`, `User`.`poked_email`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_online_status`, `User`.`hide_profile_complete`, `User`.`sendinblue_id`, `User`.`mobile_csv`, `User`.`qualification_csv`, `User`.`is_csv`, `User`.`subscriber_uid`, `User`.`list_uid`, `User`.`viewer_invisible`, `User`.`showlastseen`, `User`.`lastseen`, `User`.`first_name`, `User`.`last_name`, `User`.`online`, `User`.`interest_values` FROM `ekonty_moo`.`activities` AS `Activity` LEFT JOIN `ekonty_moo`.`users` AS `User` ON (`Activity`.`user_id` = `User`.`id`) WHERE `Activity`.`action` = 'business_create' AND `Activity`.`item_id` = 69 AND `Activity`.`plugin` = 'Business' ORDER BY `Activity`.`modified` desc LIMIT 1 | | 1 | 1 | 1 |
65 | SELECT `User`.`id`, `User`.`is_old`, `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`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `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`.`lock_delete`, `User`.`darkmode`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`phone`, `User`.`phone_verified`, `User`.`poked_email`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_online_status`, `User`.`hide_profile_complete`, `User`.`sendinblue_id`, `User`.`mobile_csv`, `User`.`qualification_csv`, `User`.`is_csv`, `User`.`subscriber_uid`, `User`.`list_uid`, `User`.`viewer_invisible`, `User`.`showlastseen`, `User`.`lastseen`, `User`.`first_name`, `User`.`last_name`, `User`.`online`, `User`.`interest_values`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `ekonty_moo`.`users` AS `User` LEFT JOIN `ekonty_moo`.`roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `User`.`id` IS NULL LIMIT 1 | | 0 | 0 | 0 |
66 | SELECT COUNT(*) AS `count` FROM `ekonty_moo`.`business_checkins` AS `BusinessCheckin` WHERE `BusinessCheckin`.`business_id` = 69 | | 1 | 1 | 0 |
67 | UPDATE `ekonty_moo`.`businesses` AS `Business` LEFT JOIN `ekonty_moo`.`users` AS `User` ON (`Business`.`user_id` = `User`.`id`) SET `Business`.`checkin_count` = 0 WHERE `Business`.`id` = 69 | | 0 | 0 | 0 |
68 | SELECT `BusinessCheckin`.`id`, `BusinessCheckin`.`business_id`, `BusinessCheckin`.`user_id`, `BusinessCheckin`.`content`, `BusinessCheckin`.`created`, `User`.`id`, `User`.`is_old`, `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`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `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`.`lock_delete`, `User`.`darkmode`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`phone`, `User`.`phone_verified`, `User`.`poked_email`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_online_status`, `User`.`hide_profile_complete`, `User`.`sendinblue_id`, `User`.`mobile_csv`, `User`.`qualification_csv`, `User`.`is_csv`, `User`.`subscriber_uid`, `User`.`list_uid`, `User`.`viewer_invisible`, `User`.`showlastseen`, `User`.`lastseen`, `User`.`first_name`, `User`.`last_name`, `User`.`online`, `User`.`interest_values`, `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`whatsapp`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated` FROM `ekonty_moo`.`business_checkins` AS `BusinessCheckin` LEFT JOIN `ekonty_moo`.`users` AS `User` ON (`BusinessCheckin`.`user_id` = `User`.`id`) LEFT JOIN `ekonty_moo`.`businesses` AS `Business` ON (`BusinessCheckin`.`business_id` = `Business`.`id`) WHERE `BusinessCheckin`.`business_id` = 69 ORDER BY `BusinessCheckin`.`id` DESC LIMIT 8 | | 0 | 0 | 0 |
69 | SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`whatsapp`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated`, `User`.`id`, `User`.`is_old`, `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`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `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`.`lock_delete`, `User`.`darkmode`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`phone`, `User`.`phone_verified`, `User`.`poked_email`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_online_status`, `User`.`hide_profile_complete`, `User`.`sendinblue_id`, `User`.`mobile_csv`, `User`.`qualification_csv`, `User`.`is_csv`, `User`.`subscriber_uid`, `User`.`list_uid`, `User`.`viewer_invisible`, `User`.`showlastseen`, `User`.`lastseen`, `User`.`first_name`, `User`.`last_name`, `User`.`online`, `User`.`interest_values`, `BusinessLocation`.`id`, `BusinessLocation`.`parent_id`, `BusinessLocation`.`lft`, `BusinessLocation`.`rght`, `BusinessLocation`.`name`, `BusinessLocation`.`business_count`, `BusinessLocation`.`is_default`, `BusinessLocation`.`on_popup`, `BusinessLocation`.`enabled`, `BusinessLocation`.`ordering`, `BusinessLocation`.`created`, `BusinessLocation`.`updated`, `BusinessLocation`.`city`, `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial`, `BusinessType`.`id`, `BusinessType`.`name`, `BusinessType`.`enable`, `BusinessType`.`ordering`, `BusinessType`.`created`, `BusinessType`.`updated` FROM `ekonty_moo`.`businesses` AS `Business` LEFT JOIN `ekonty_moo`.`users` AS `User` ON (`Business`.`user_id` = `User`.`id`) LEFT JOIN `ekonty_moo`.`business_locations` AS `BusinessLocation` ON (`Business`.`business_location_id` = `BusinessLocation`.`id`) LEFT JOIN `ekonty_moo`.`business_packages` AS `BusinessPackage` ON (`Business`.`business_package_id` = `BusinessPackage`.`id`) LEFT JOIN `ekonty_moo`.`business_types` AS `BusinessType` ON (`Business`.`business_type_id` = `BusinessType`.`id`) WHERE `Business`.`id` = 69 LIMIT 1 | | 1 | 1 | 1 |
70 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `ekonty_moo`.`roles` AS `Role` WHERE `Role`.`id` = 2 | | 1 | 1 | 0 |
71 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | | 5 | 5 | 0 |
72 | SELECT `BusinessTime`.`id`, `BusinessTime`.`business_id`, `BusinessTime`.`day`, `BusinessTime`.`time_open`, `BusinessTime`.`time_close`, `BusinessTime`.`next_day` FROM `ekonty_moo`.`business_times` AS `BusinessTime` WHERE `BusinessTime`.`business_id` = (69) | | 1 | 1 | 1 |
73 | SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `ekonty_moo`.`business_categories` AS `BusinessCategory` JOIN `ekonty_moo`.`business_category_items` AS `BusinessCategoryItem` ON (`BusinessCategoryItem`.`business_id` = 69 AND `BusinessCategoryItem`.`business_category_id` = `BusinessCategory`.`id`) | | 1 | 1 | 0 |
74 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (15) ORDER BY `id` ASC | | 5 | 5 | 0 |
75 | SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_category_id` FROM `ekonty_moo`.`business_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 69 | | 1 | 1 | 0 |
76 | SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`whatsapp`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated`, `User`.`id`, `User`.`is_old`, `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`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `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`.`lock_delete`, `User`.`darkmode`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`phone`, `User`.`phone_verified`, `User`.`poked_email`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_online_status`, `User`.`hide_profile_complete`, `User`.`sendinblue_id`, `User`.`mobile_csv`, `User`.`qualification_csv`, `User`.`is_csv`, `User`.`subscriber_uid`, `User`.`list_uid`, `User`.`viewer_invisible`, `User`.`showlastseen`, `User`.`lastseen`, `User`.`first_name`, `User`.`last_name`, `User`.`online`, `User`.`interest_values` FROM `ekonty_moo`.`businesses` AS `Business` LEFT JOIN `ekonty_moo`.`users` AS `User` ON (`Business`.`user_id` = `User`.`id`) WHERE `Business`.`status` = 'approved' AND `Business`.`claim_id` = 0 AND `Business`.`id` != 69 AND `Business`.`id` IN(SELECT business_id FROM business_category_items WHERE business_category_id IN(15)) ORDER BY `Business`.`total_score` DESC LIMIT 5 | | 5 | 5 | 30 |
77 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `ekonty_moo`.`roles` AS `Role` WHERE `Role`.`id` = 2 | | 1 | 1 | 0 |
78 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `ekonty_moo`.`roles` AS `Role` WHERE `Role`.`id` = 2 | | 1 | 1 | 0 |
79 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `ekonty_moo`.`roles` AS `Role` WHERE `Role`.`id` = 2 | | 1 | 1 | 0 |
80 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `ekonty_moo`.`roles` AS `Role` WHERE `Role`.`id` = 2 | | 1 | 1 | 0 |
81 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `ekonty_moo`.`roles` AS `Role` WHERE `Role`.`id` = 2 | | 1 | 1 | 0 |
82 | SELECT `Page`.`id` FROM `ekonty_moo`.`pages` AS `Page` LEFT JOIN `ekonty_moo`.`themes` AS `MyCoreTheme` ON (`Page`.`theme_id` = `MyCoreTheme`.`id`) WHERE `Page`.`uri` = 'business.view' ORDER BY `Page`.`weight` asc LIMIT 1 | | 1 | 1 | 0 |
83 | 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 `ekonty_moo`.`core_contents` AS `CoreContent` WHERE `CoreContent`.`page_id` = (109) | | 15 | 15 | 0 |
84 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
85 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
86 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
87 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
88 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
89 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
90 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
91 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
92 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
93 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
94 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
95 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
96 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
97 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
98 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
99 | 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 `ekonty_moo`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 203 | | 1 | 1 | 0 |
100 | 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 `ekonty_moo`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 202 | | 1 | 1 | 0 |
101 | 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 `ekonty_moo`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 204 | | 1 | 1 | 0 |
102 | 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 `ekonty_moo`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 205 | | 1 | 1 | 0 |
103 | 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 `ekonty_moo`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 203 | | 1 | 1 | 0 |
104 | 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 `ekonty_moo`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 202 | | 1 | 1 | 0 |
105 | 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 `ekonty_moo`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 205 | | 1 | 1 | 0 |
106 | 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 `ekonty_moo`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 203 | | 1 | 1 | 0 |
107 | 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 `ekonty_moo`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 202 | | 1 | 1 | 0 |
108 | 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 `ekonty_moo`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 203 | | 1 | 1 | 0 |
109 | 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 `ekonty_moo`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 202 | | 1 | 1 | 0 |
110 | 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 `ekonty_moo`.`core_contents` AS `Children` WHERE `Children`.`parent_id` IN (202, 203, 204, 205, 237, 241, 245, 246, 238, 242, 247, 239, 243, 240, 244) | | 11 | 11 | 1 |
111 | SELECT `CoreContentValue`.`id`, `CoreContentValue`.`content_id`, `CoreContentValue`.`field_name`, `CoreContentValue`.`value` FROM `ekonty_moo`.`core_content_values` AS `CoreContentValue` WHERE `CoreContentValue`.`content_id` IN (202, 203, 204, 205, 237, 241, 245, 246, 238, 242, 247, 239, 243, 240, 244) | | 0 | 0 | 0 |
112 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'CoreContent' AND `field` = 'core_block_title' AND `nameTranslation`.`foreign_key` IN (202, 203, 204, 205, 237, 241, 245, 246, 238, 242, 247, 239, 243, 240, 244) ORDER BY `id` ASC | | 75 | 75 | 1 |
113 | SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `titleTranslation` WHERE `model` = 'Page' AND `field` = 'title' AND `titleTranslation`.`foreign_key` = (109) ORDER BY `id` ASC | | 5 | 5 | 0 |
114 | SELECT `contentTranslation`.`id`, `contentTranslation`.`locale`, `contentTranslation`.`model`, `contentTranslation`.`foreign_key`, `contentTranslation`.`field`, `contentTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `contentTranslation` WHERE `model` = 'Page' AND `field` = 'content' AND `contentTranslation`.`foreign_key` = (109) ORDER BY `id` ASC | | 5 | 5 | 0 |
115 | 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 `ekonty_moo`.`tourguides` AS `Tourguide` INNER JOIN `ekonty_moo`.`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` = 'eng') WHERE `Tourguide`.`page_id` LIKE '%\"0\"%' AND `enable` = '1' LIMIT 1 | | 0 | 0 | 0 |
116 | 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 `ekonty_moo`.`tourguides` AS `Tourguide` INNER JOIN `ekonty_moo`.`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` = 'eng') WHERE `Tourguide`.`page_id` LIKE '%\"109\"%' AND `enable` = '1' LIMIT 1 | | 1 | 1 | 0 |
117 | SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `titleTranslation` WHERE `model` = 'Tourguide' AND `field` = 'title' AND `titleTranslation`.`foreign_key` = (4) ORDER BY `id` ASC | | 5 | 5 | 0 |
118 | SELECT `TourguideStep`.`id`, `TourguideStep`.`tourguide_id`, `TourguideStep`.`user_id`, `TourguideStep`.`step_title`, `TourguideStep`.`step_body`, `TourguideStep`.`step_position`, `TourguideStep`.`step_css_custom`, `TourguideStep`.`step_order`, (`I18n__step_titleTranslation`.`content`) AS `TourguideStep__i18n_step_titleTranslation`, (`I18n__step_bodyTranslation`.`content`) AS `TourguideStep__i18n_step_bodyTranslation`, (`I18n__step_positionTranslation`.`content`) AS `TourguideStep__i18n_step_positionTranslation`, (`I18n__step_css_customTranslation`.`content`) AS `TourguideStep__i18n_step_css_customTranslation` FROM `ekonty_moo`.`tourguide_steps` AS `TourguideStep` INNER JOIN `ekonty_moo`.`i18n` AS `I18n__step_titleTranslation` ON (`TourguideStep`.`id` = `I18n__step_titleTranslation`.`foreign_key` AND `I18n__step_titleTranslation`.`model` = 'TourguideStep' AND `I18n__step_titleTranslation`.`field` = 'step_title' AND `I18n__step_titleTranslation`.`locale` = 'eng') INNER JOIN `ekonty_moo`.`i18n` AS `I18n__step_bodyTranslation` ON (`TourguideStep`.`id` = `I18n__step_bodyTranslation`.`foreign_key` AND `I18n__step_bodyTranslation`.`model` = 'TourguideStep' AND `I18n__step_bodyTranslation`.`field` = 'step_body' AND `I18n__step_bodyTranslation`.`locale` = 'eng') INNER JOIN `ekonty_moo`.`i18n` AS `I18n__step_positionTranslation` ON (`TourguideStep`.`id` = `I18n__step_positionTranslation`.`foreign_key` AND `I18n__step_positionTranslation`.`model` = 'TourguideStep' AND `I18n__step_positionTranslation`.`field` = 'step_position' AND `I18n__step_positionTranslation`.`locale` = 'eng') INNER JOIN `ekonty_moo`.`i18n` AS `I18n__step_css_customTranslation` ON (`TourguideStep`.`id` = `I18n__step_css_customTranslation`.`foreign_key` AND `I18n__step_css_customTranslation`.`model` = 'TourguideStep' AND `I18n__step_css_customTranslation`.`field` = 'step_css_custom' AND `I18n__step_css_customTranslation`.`locale` = 'eng') WHERE `TourguideStep`.`tourguide_id` = 4 ORDER BY `TourguideStep`.`step_order` asc | | 1 | 1 | 1 |
119 | SELECT `step_titleTranslation`.`id`, `step_titleTranslation`.`locale`, `step_titleTranslation`.`model`, `step_titleTranslation`.`foreign_key`, `step_titleTranslation`.`field`, `step_titleTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `step_titleTranslation` WHERE `model` = 'TourguideStep' AND `field` = 'step_title' AND `step_titleTranslation`.`foreign_key` = (4) ORDER BY `id` ASC | | 5 | 5 | 0 |
120 | SELECT `step_bodyTranslation`.`id`, `step_bodyTranslation`.`locale`, `step_bodyTranslation`.`model`, `step_bodyTranslation`.`foreign_key`, `step_bodyTranslation`.`field`, `step_bodyTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `step_bodyTranslation` WHERE `model` = 'TourguideStep' AND `field` = 'step_body' AND `step_bodyTranslation`.`foreign_key` = (4) ORDER BY `id` ASC | | 5 | 5 | 0 |
121 | SELECT `step_positionTranslation`.`id`, `step_positionTranslation`.`locale`, `step_positionTranslation`.`model`, `step_positionTranslation`.`foreign_key`, `step_positionTranslation`.`field`, `step_positionTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `step_positionTranslation` WHERE `model` = 'TourguideStep' AND `field` = 'step_position' AND `step_positionTranslation`.`foreign_key` = (4) ORDER BY `id` ASC | | 5 | 5 | 0 |
122 | SELECT `step_css_customTranslation`.`id`, `step_css_customTranslation`.`locale`, `step_css_customTranslation`.`model`, `step_css_customTranslation`.`foreign_key`, `step_css_customTranslation`.`field`, `step_css_customTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `step_css_customTranslation` WHERE `model` = 'TourguideStep' AND `field` = 'step_css_custom' AND `step_css_customTranslation`.`foreign_key` = (4) ORDER BY `id` ASC | | 5 | 5 | 0 |
123 | 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 `ekonty_moo`.`plugins` AS `Plugin` WHERE `Plugin`.`key` = 'UploadVideo' ORDER BY `Plugin`.`id` asc LIMIT 1 | | 1 | 1 | 0 |
124 | SELECT `Page`.`id` FROM `ekonty_moo`.`pages` AS `Page` LEFT JOIN `ekonty_moo`.`themes` AS `MyCoreTheme` ON (`Page`.`theme_id` = `MyCoreTheme`.`id`) WHERE `Page`.`uri` = 'business.view' ORDER BY `Page`.`weight` asc LIMIT 1 | | 1 | 1 | 0 |
125 | 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 `ekonty_moo`.`core_contents` AS `CoreContent` WHERE `CoreContent`.`page_id` = (109) | | 15 | 15 | 0 |
126 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
127 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
128 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
129 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
130 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
131 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
132 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
133 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
134 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
135 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
136 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
137 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
138 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
139 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
140 | 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 `ekonty_moo`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 109 | | 1 | 1 | 0 |
141 | 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 `ekonty_moo`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 203 | | 1 | 1 | 0 |
142 | 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 `ekonty_moo`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 202 | | 1 | 1 | 0 |
143 | 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 `ekonty_moo`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 204 | | 1 | 1 | 0 |
144 | 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 `ekonty_moo`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 205 | | 1 | 1 | 0 |
145 | 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 `ekonty_moo`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 203 | | 1 | 1 | 0 |
146 | 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 `ekonty_moo`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 202 | | 1 | 1 | 0 |
147 | 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 `ekonty_moo`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 205 | | 1 | 1 | 0 |
148 | 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 `ekonty_moo`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 203 | | 1 | 1 | 0 |
149 | 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 `ekonty_moo`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 202 | | 1 | 1 | 0 |
150 | 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 `ekonty_moo`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 203 | | 1 | 1 | 0 |
151 | 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 `ekonty_moo`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 202 | | 1 | 1 | 0 |
152 | 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 `ekonty_moo`.`core_contents` AS `Children` WHERE `Children`.`parent_id` IN (202, 203, 204, 205, 237, 241, 245, 246, 238, 242, 247, 239, 243, 240, 244) | | 11 | 11 | 1 |
153 | SELECT `CoreContentValue`.`id`, `CoreContentValue`.`content_id`, `CoreContentValue`.`field_name`, `CoreContentValue`.`value` FROM `ekonty_moo`.`core_content_values` AS `CoreContentValue` WHERE `CoreContentValue`.`content_id` IN (202, 203, 204, 205, 237, 241, 245, 246, 238, 242, 247, 239, 243, 240, 244) | | 0 | 0 | 0 |
154 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'CoreContent' AND `field` = 'core_block_title' AND `nameTranslation`.`foreign_key` IN (202, 203, 204, 205, 237, 241, 245, 246, 238, 242, 247, 239, 243, 240, 244) ORDER BY `id` ASC | | 75 | 75 | 1 |
155 | SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `titleTranslation` WHERE `model` = 'Page' AND `field` = 'title' AND `titleTranslation`.`foreign_key` = (109) ORDER BY `id` ASC | | 5 | 5 | 0 |
156 | SELECT `contentTranslation`.`id`, `contentTranslation`.`locale`, `contentTranslation`.`model`, `contentTranslation`.`foreign_key`, `contentTranslation`.`field`, `contentTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `contentTranslation` WHERE `model` = 'Page' AND `field` = 'content' AND `contentTranslation`.`foreign_key` = (109) ORDER BY `id` ASC | | 5 | 5 | 0 |
157 | SELECT `Popup`.`id`, `Popup`.`page_id`, `Popup`.`title`, `Popup`.`body`, `Popup`.`onetime`, `Popup`.`popup_option`, `Popup`.`permission`, `Popup`.`enable`, (`I18n__titleTranslation`.`content`) AS `Popup__i18n_titleTranslation`, (`I18n__bodyTranslation`.`content`) AS `Popup__i18n_bodyTranslation`, `Page`.`id`, `Page`.`title`, `Page`.`alias`, `Page`.`content`, `Page`.`permission`, `Page`.`params`, `Page`.`created`, `Page`.`modified`, `Page`.`menu`, `Page`.`icon_class`, `Page`.`weight`, `Page`.`url`, `Page`.`uri`, `Page`.`description`, `Page`.`keywords`, `Page`.`custom`, `Page`.`fragment`, `Page`.`layout`, `Page`.`levels`, `Page`.`provides`, `Page`.`view_count`, `Page`.`type`, `Page`.`search`, `Page`.`theme_id`, `Page`.`core_content_count`, `Page`.`plugin`, `Page`.`show_layout` FROM `ekonty_moo`.`popups` AS `Popup` LEFT JOIN `ekonty_moo`.`pages` AS `Page` ON (`Popup`.`page_id` = `Page`.`id`) INNER JOIN `ekonty_moo`.`i18n` AS `I18n__titleTranslation` ON (`Popup`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Popup' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `ekonty_moo`.`i18n` AS `I18n__bodyTranslation` ON (`Popup`.`id` = `I18n__bodyTranslation`.`foreign_key` AND `I18n__bodyTranslation`.`model` = 'Popup' AND `I18n__bodyTranslation`.`field` = 'body' AND `I18n__bodyTranslation`.`locale` = 'eng') WHERE `Popup`.`page_id` = 0 AND `enable` = '1' LIMIT 1 | | 0 | 0 | 0 |
158 | SELECT `Popup`.`id`, `Popup`.`page_id`, `Popup`.`title`, `Popup`.`body`, `Popup`.`onetime`, `Popup`.`popup_option`, `Popup`.`permission`, `Popup`.`enable`, (`I18n__titleTranslation`.`content`) AS `Popup__i18n_titleTranslation`, (`I18n__bodyTranslation`.`content`) AS `Popup__i18n_bodyTranslation`, `Page`.`id`, `Page`.`title`, `Page`.`alias`, `Page`.`content`, `Page`.`permission`, `Page`.`params`, `Page`.`created`, `Page`.`modified`, `Page`.`menu`, `Page`.`icon_class`, `Page`.`weight`, `Page`.`url`, `Page`.`uri`, `Page`.`description`, `Page`.`keywords`, `Page`.`custom`, `Page`.`fragment`, `Page`.`layout`, `Page`.`levels`, `Page`.`provides`, `Page`.`view_count`, `Page`.`type`, `Page`.`search`, `Page`.`theme_id`, `Page`.`core_content_count`, `Page`.`plugin`, `Page`.`show_layout` FROM `ekonty_moo`.`popups` AS `Popup` LEFT JOIN `ekonty_moo`.`pages` AS `Page` ON (`Popup`.`page_id` = `Page`.`id`) INNER JOIN `ekonty_moo`.`i18n` AS `I18n__titleTranslation` ON (`Popup`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Popup' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `ekonty_moo`.`i18n` AS `I18n__bodyTranslation` ON (`Popup`.`id` = `I18n__bodyTranslation`.`foreign_key` AND `I18n__bodyTranslation`.`model` = 'Popup' AND `I18n__bodyTranslation`.`field` = 'body' AND `I18n__bodyTranslation`.`locale` = 'eng') WHERE `Popup`.`page_id` = 109 AND `enable` = '1' LIMIT 1 | | 0 | 0 | 0 |
159 | SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`whatsapp`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated`, `User`.`id`, `User`.`is_old`, `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`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `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`.`lock_delete`, `User`.`darkmode`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`phone`, `User`.`phone_verified`, `User`.`poked_email`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_online_status`, `User`.`hide_profile_complete`, `User`.`sendinblue_id`, `User`.`mobile_csv`, `User`.`qualification_csv`, `User`.`is_csv`, `User`.`subscriber_uid`, `User`.`list_uid`, `User`.`viewer_invisible`, `User`.`showlastseen`, `User`.`lastseen`, `User`.`first_name`, `User`.`last_name`, `User`.`online`, `User`.`interest_values`, `BusinessLocation`.`id`, `BusinessLocation`.`parent_id`, `BusinessLocation`.`lft`, `BusinessLocation`.`rght`, `BusinessLocation`.`name`, `BusinessLocation`.`business_count`, `BusinessLocation`.`is_default`, `BusinessLocation`.`on_popup`, `BusinessLocation`.`enabled`, `BusinessLocation`.`ordering`, `BusinessLocation`.`created`, `BusinessLocation`.`updated`, `BusinessLocation`.`city`, `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial`, `BusinessType`.`id`, `BusinessType`.`name`, `BusinessType`.`enable`, `BusinessType`.`ordering`, `BusinessType`.`created`, `BusinessType`.`updated` FROM `ekonty_moo`.`businesses` AS `Business` LEFT JOIN `ekonty_moo`.`users` AS `User` ON (`Business`.`user_id` = `User`.`id`) LEFT JOIN `ekonty_moo`.`business_locations` AS `BusinessLocation` ON (`Business`.`business_location_id` = `BusinessLocation`.`id`) LEFT JOIN `ekonty_moo`.`business_packages` AS `BusinessPackage` ON (`Business`.`business_package_id` = `BusinessPackage`.`id`) LEFT JOIN `ekonty_moo`.`business_types` AS `BusinessType` ON (`Business`.`business_type_id` = `BusinessType`.`id`) WHERE `Business`.`id` = 69 LIMIT 1 | | 1 | 1 | 1 |
160 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `ekonty_moo`.`roles` AS `Role` WHERE `Role`.`id` = 2 | | 1 | 1 | 0 |
161 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | | 5 | 5 | 0 |
162 | SELECT `BusinessTime`.`id`, `BusinessTime`.`business_id`, `BusinessTime`.`day`, `BusinessTime`.`time_open`, `BusinessTime`.`time_close`, `BusinessTime`.`next_day` FROM `ekonty_moo`.`business_times` AS `BusinessTime` WHERE `BusinessTime`.`business_id` = (69) | | 1 | 1 | 1 |
163 | SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `ekonty_moo`.`business_categories` AS `BusinessCategory` JOIN `ekonty_moo`.`business_category_items` AS `BusinessCategoryItem` ON (`BusinessCategoryItem`.`business_id` = 69 AND `BusinessCategoryItem`.`business_category_id` = `BusinessCategory`.`id`) | | 1 | 1 | 0 |
164 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (15) ORDER BY `id` ASC | | 5 | 5 | 0 |
165 | SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`whatsapp`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated`, `User`.`id`, `User`.`is_old`, `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`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `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`.`lock_delete`, `User`.`darkmode`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`phone`, `User`.`phone_verified`, `User`.`poked_email`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_online_status`, `User`.`hide_profile_complete`, `User`.`sendinblue_id`, `User`.`mobile_csv`, `User`.`qualification_csv`, `User`.`is_csv`, `User`.`subscriber_uid`, `User`.`list_uid`, `User`.`viewer_invisible`, `User`.`showlastseen`, `User`.`lastseen`, `User`.`first_name`, `User`.`last_name`, `User`.`online`, `User`.`interest_values`, `BusinessLocation`.`id`, `BusinessLocation`.`parent_id`, `BusinessLocation`.`lft`, `BusinessLocation`.`rght`, `BusinessLocation`.`name`, `BusinessLocation`.`business_count`, `BusinessLocation`.`is_default`, `BusinessLocation`.`on_popup`, `BusinessLocation`.`enabled`, `BusinessLocation`.`ordering`, `BusinessLocation`.`created`, `BusinessLocation`.`updated`, `BusinessLocation`.`city`, `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial`, `BusinessType`.`id`, `BusinessType`.`name`, `BusinessType`.`enable`, `BusinessType`.`ordering`, `BusinessType`.`created`, `BusinessType`.`updated` FROM `ekonty_moo`.`businesses` AS `Business` LEFT JOIN `ekonty_moo`.`users` AS `User` ON (`Business`.`user_id` = `User`.`id`) LEFT JOIN `ekonty_moo`.`business_locations` AS `BusinessLocation` ON (`Business`.`business_location_id` = `BusinessLocation`.`id`) LEFT JOIN `ekonty_moo`.`business_packages` AS `BusinessPackage` ON (`Business`.`business_package_id` = `BusinessPackage`.`id`) LEFT JOIN `ekonty_moo`.`business_types` AS `BusinessType` ON (`Business`.`business_type_id` = `BusinessType`.`id`) WHERE `Business`.`id` = 1757 LIMIT 1 | | 1 | 1 | 1 |
166 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `ekonty_moo`.`roles` AS `Role` WHERE `Role`.`id` = 2 | | 1 | 1 | 0 |
167 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (6) ORDER BY `id` ASC | | 5 | 5 | 0 |
168 | SELECT `BusinessTime`.`id`, `BusinessTime`.`business_id`, `BusinessTime`.`day`, `BusinessTime`.`time_open`, `BusinessTime`.`time_close`, `BusinessTime`.`next_day` FROM `ekonty_moo`.`business_times` AS `BusinessTime` WHERE `BusinessTime`.`business_id` = (1757) | | 7 | 7 | 1 |
169 | SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `ekonty_moo`.`business_categories` AS `BusinessCategory` JOIN `ekonty_moo`.`business_category_items` AS `BusinessCategoryItem` ON (`BusinessCategoryItem`.`business_id` = 1757 AND `BusinessCategoryItem`.`business_category_id` = `BusinessCategory`.`id`) | | 1 | 1 | 0 |
170 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (15) ORDER BY `id` ASC | | 5 | 5 | 0 |
171 | SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`whatsapp`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated`, `User`.`id`, `User`.`is_old`, `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`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `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`.`lock_delete`, `User`.`darkmode`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`phone`, `User`.`phone_verified`, `User`.`poked_email`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_online_status`, `User`.`hide_profile_complete`, `User`.`sendinblue_id`, `User`.`mobile_csv`, `User`.`qualification_csv`, `User`.`is_csv`, `User`.`subscriber_uid`, `User`.`list_uid`, `User`.`viewer_invisible`, `User`.`showlastseen`, `User`.`lastseen`, `User`.`first_name`, `User`.`last_name`, `User`.`online`, `User`.`interest_values`, `BusinessLocation`.`id`, `BusinessLocation`.`parent_id`, `BusinessLocation`.`lft`, `BusinessLocation`.`rght`, `BusinessLocation`.`name`, `BusinessLocation`.`business_count`, `BusinessLocation`.`is_default`, `BusinessLocation`.`on_popup`, `BusinessLocation`.`enabled`, `BusinessLocation`.`ordering`, `BusinessLocation`.`created`, `BusinessLocation`.`updated`, `BusinessLocation`.`city`, `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial`, `BusinessType`.`id`, `BusinessType`.`name`, `BusinessType`.`enable`, `BusinessType`.`ordering`, `BusinessType`.`created`, `BusinessType`.`updated` FROM `ekonty_moo`.`businesses` AS `Business` LEFT JOIN `ekonty_moo`.`users` AS `User` ON (`Business`.`user_id` = `User`.`id`) LEFT JOIN `ekonty_moo`.`business_locations` AS `BusinessLocation` ON (`Business`.`business_location_id` = `BusinessLocation`.`id`) LEFT JOIN `ekonty_moo`.`business_packages` AS `BusinessPackage` ON (`Business`.`business_package_id` = `BusinessPackage`.`id`) LEFT JOIN `ekonty_moo`.`business_types` AS `BusinessType` ON (`Business`.`business_type_id` = `BusinessType`.`id`) WHERE `Business`.`id` = 62 LIMIT 1 | | 1 | 1 | 1 |
172 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `ekonty_moo`.`roles` AS `Role` WHERE `Role`.`id` = 2 | | 1 | 1 | 0 |
173 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | | 5 | 5 | 0 |
174 | SELECT `BusinessTime`.`id`, `BusinessTime`.`business_id`, `BusinessTime`.`day`, `BusinessTime`.`time_open`, `BusinessTime`.`time_close`, `BusinessTime`.`next_day` FROM `ekonty_moo`.`business_times` AS `BusinessTime` WHERE `BusinessTime`.`business_id` = (62) | | 0 | 0 | 1 |
175 | SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `ekonty_moo`.`business_categories` AS `BusinessCategory` JOIN `ekonty_moo`.`business_category_items` AS `BusinessCategoryItem` ON (`BusinessCategoryItem`.`business_id` = 62 AND `BusinessCategoryItem`.`business_category_id` = `BusinessCategory`.`id`) | | 1 | 1 | 0 |
176 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (15) ORDER BY `id` ASC | | 5 | 5 | 0 |
177 | SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`whatsapp`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated`, `User`.`id`, `User`.`is_old`, `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`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `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`.`lock_delete`, `User`.`darkmode`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`phone`, `User`.`phone_verified`, `User`.`poked_email`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_online_status`, `User`.`hide_profile_complete`, `User`.`sendinblue_id`, `User`.`mobile_csv`, `User`.`qualification_csv`, `User`.`is_csv`, `User`.`subscriber_uid`, `User`.`list_uid`, `User`.`viewer_invisible`, `User`.`showlastseen`, `User`.`lastseen`, `User`.`first_name`, `User`.`last_name`, `User`.`online`, `User`.`interest_values`, `BusinessLocation`.`id`, `BusinessLocation`.`parent_id`, `BusinessLocation`.`lft`, `BusinessLocation`.`rght`, `BusinessLocation`.`name`, `BusinessLocation`.`business_count`, `BusinessLocation`.`is_default`, `BusinessLocation`.`on_popup`, `BusinessLocation`.`enabled`, `BusinessLocation`.`ordering`, `BusinessLocation`.`created`, `BusinessLocation`.`updated`, `BusinessLocation`.`city`, `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial`, `BusinessType`.`id`, `BusinessType`.`name`, `BusinessType`.`enable`, `BusinessType`.`ordering`, `BusinessType`.`created`, `BusinessType`.`updated` FROM `ekonty_moo`.`businesses` AS `Business` LEFT JOIN `ekonty_moo`.`users` AS `User` ON (`Business`.`user_id` = `User`.`id`) LEFT JOIN `ekonty_moo`.`business_locations` AS `BusinessLocation` ON (`Business`.`business_location_id` = `BusinessLocation`.`id`) LEFT JOIN `ekonty_moo`.`business_packages` AS `BusinessPackage` ON (`Business`.`business_package_id` = `BusinessPackage`.`id`) LEFT JOIN `ekonty_moo`.`business_types` AS `BusinessType` ON (`Business`.`business_type_id` = `BusinessType`.`id`) WHERE `Business`.`id` = 100 LIMIT 1 | | 1 | 1 | 1 |
178 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `ekonty_moo`.`roles` AS `Role` WHERE `Role`.`id` = 2 | | 1 | 1 | 0 |
179 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (5) ORDER BY `id` ASC | | 5 | 5 | 0 |
180 | SELECT `BusinessTime`.`id`, `BusinessTime`.`business_id`, `BusinessTime`.`day`, `BusinessTime`.`time_open`, `BusinessTime`.`time_close`, `BusinessTime`.`next_day` FROM `ekonty_moo`.`business_times` AS `BusinessTime` WHERE `BusinessTime`.`business_id` = (100) | | 1 | 1 | 1 |
181 | SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `ekonty_moo`.`business_categories` AS `BusinessCategory` JOIN `ekonty_moo`.`business_category_items` AS `BusinessCategoryItem` ON (`BusinessCategoryItem`.`business_id` = 100 AND `BusinessCategoryItem`.`business_category_id` = `BusinessCategory`.`id`) | | 1 | 1 | 0 |
182 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (15) ORDER BY `id` ASC | | 5 | 5 | 0 |
183 | SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`whatsapp`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated`, `User`.`id`, `User`.`is_old`, `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`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `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`.`lock_delete`, `User`.`darkmode`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`phone`, `User`.`phone_verified`, `User`.`poked_email`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_online_status`, `User`.`hide_profile_complete`, `User`.`sendinblue_id`, `User`.`mobile_csv`, `User`.`qualification_csv`, `User`.`is_csv`, `User`.`subscriber_uid`, `User`.`list_uid`, `User`.`viewer_invisible`, `User`.`showlastseen`, `User`.`lastseen`, `User`.`first_name`, `User`.`last_name`, `User`.`online`, `User`.`interest_values`, `BusinessLocation`.`id`, `BusinessLocation`.`parent_id`, `BusinessLocation`.`lft`, `BusinessLocation`.`rght`, `BusinessLocation`.`name`, `BusinessLocation`.`business_count`, `BusinessLocation`.`is_default`, `BusinessLocation`.`on_popup`, `BusinessLocation`.`enabled`, `BusinessLocation`.`ordering`, `BusinessLocation`.`created`, `BusinessLocation`.`updated`, `BusinessLocation`.`city`, `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial`, `BusinessType`.`id`, `BusinessType`.`name`, `BusinessType`.`enable`, `BusinessType`.`ordering`, `BusinessType`.`created`, `BusinessType`.`updated` FROM `ekonty_moo`.`businesses` AS `Business` LEFT JOIN `ekonty_moo`.`users` AS `User` ON (`Business`.`user_id` = `User`.`id`) LEFT JOIN `ekonty_moo`.`business_locations` AS `BusinessLocation` ON (`Business`.`business_location_id` = `BusinessLocation`.`id`) LEFT JOIN `ekonty_moo`.`business_packages` AS `BusinessPackage` ON (`Business`.`business_package_id` = `BusinessPackage`.`id`) LEFT JOIN `ekonty_moo`.`business_types` AS `BusinessType` ON (`Business`.`business_type_id` = `BusinessType`.`id`) WHERE `Business`.`id` = 122 LIMIT 1 | | 1 | 1 | 1 |
184 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `ekonty_moo`.`roles` AS `Role` WHERE `Role`.`id` = 2 | | 1 | 1 | 0 |
185 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (3) ORDER BY `id` ASC | | 5 | 5 | 0 |
186 | SELECT `BusinessTime`.`id`, `BusinessTime`.`business_id`, `BusinessTime`.`day`, `BusinessTime`.`time_open`, `BusinessTime`.`time_close`, `BusinessTime`.`next_day` FROM `ekonty_moo`.`business_times` AS `BusinessTime` WHERE `BusinessTime`.`business_id` = (122) | | 5 | 5 | 1 |
187 | SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `ekonty_moo`.`business_categories` AS `BusinessCategory` JOIN `ekonty_moo`.`business_category_items` AS `BusinessCategoryItem` ON (`BusinessCategoryItem`.`business_id` = 122 AND `BusinessCategoryItem`.`business_category_id` = `BusinessCategory`.`id`) | | 1 | 1 | 0 |
188 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (15) ORDER BY `id` ASC | | 5 | 5 | 0 |
189 | SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`whatsapp`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated`, `User`.`id`, `User`.`is_old`, `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`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `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`.`lock_delete`, `User`.`darkmode`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`phone`, `User`.`phone_verified`, `User`.`poked_email`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_online_status`, `User`.`hide_profile_complete`, `User`.`sendinblue_id`, `User`.`mobile_csv`, `User`.`qualification_csv`, `User`.`is_csv`, `User`.`subscriber_uid`, `User`.`list_uid`, `User`.`viewer_invisible`, `User`.`showlastseen`, `User`.`lastseen`, `User`.`first_name`, `User`.`last_name`, `User`.`online`, `User`.`interest_values`, `BusinessLocation`.`id`, `BusinessLocation`.`parent_id`, `BusinessLocation`.`lft`, `BusinessLocation`.`rght`, `BusinessLocation`.`name`, `BusinessLocation`.`business_count`, `BusinessLocation`.`is_default`, `BusinessLocation`.`on_popup`, `BusinessLocation`.`enabled`, `BusinessLocation`.`ordering`, `BusinessLocation`.`created`, `BusinessLocation`.`updated`, `BusinessLocation`.`city`, `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial`, `BusinessType`.`id`, `BusinessType`.`name`, `BusinessType`.`enable`, `BusinessType`.`ordering`, `BusinessType`.`created`, `BusinessType`.`updated` FROM `ekonty_moo`.`businesses` AS `Business` LEFT JOIN `ekonty_moo`.`users` AS `User` ON (`Business`.`user_id` = `User`.`id`) LEFT JOIN `ekonty_moo`.`business_locations` AS `BusinessLocation` ON (`Business`.`business_location_id` = `BusinessLocation`.`id`) LEFT JOIN `ekonty_moo`.`business_packages` AS `BusinessPackage` ON (`Business`.`business_package_id` = `BusinessPackage`.`id`) LEFT JOIN `ekonty_moo`.`business_types` AS `BusinessType` ON (`Business`.`business_type_id` = `BusinessType`.`id`) WHERE `Business`.`id` = 229 LIMIT 1 | | 1 | 1 | 1 |
190 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `ekonty_moo`.`roles` AS `Role` WHERE `Role`.`id` = 2 | | 1 | 1 | 0 |
191 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | | 5 | 5 | 0 |
192 | SELECT `BusinessTime`.`id`, `BusinessTime`.`business_id`, `BusinessTime`.`day`, `BusinessTime`.`time_open`, `BusinessTime`.`time_close`, `BusinessTime`.`next_day` FROM `ekonty_moo`.`business_times` AS `BusinessTime` WHERE `BusinessTime`.`business_id` = (229) | | 1 | 1 | 1 |
193 | SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `ekonty_moo`.`business_categories` AS `BusinessCategory` JOIN `ekonty_moo`.`business_category_items` AS `BusinessCategoryItem` ON (`BusinessCategoryItem`.`business_id` = 229 AND `BusinessCategoryItem`.`business_category_id` = `BusinessCategory`.`id`) | | 2 | 2 | 0 |
194 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (15, 17) ORDER BY `id` ASC | | 10 | 10 | 0 |
195 | SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`whatsapp`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated`, `User`.`id`, `User`.`is_old`, `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`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `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`.`lock_delete`, `User`.`darkmode`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`phone`, `User`.`phone_verified`, `User`.`poked_email`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_online_status`, `User`.`hide_profile_complete`, `User`.`sendinblue_id`, `User`.`mobile_csv`, `User`.`qualification_csv`, `User`.`is_csv`, `User`.`subscriber_uid`, `User`.`list_uid`, `User`.`viewer_invisible`, `User`.`showlastseen`, `User`.`lastseen`, `User`.`first_name`, `User`.`last_name`, `User`.`online`, `User`.`interest_values`, `BusinessLocation`.`id`, `BusinessLocation`.`parent_id`, `BusinessLocation`.`lft`, `BusinessLocation`.`rght`, `BusinessLocation`.`name`, `BusinessLocation`.`business_count`, `BusinessLocation`.`is_default`, `BusinessLocation`.`on_popup`, `BusinessLocation`.`enabled`, `BusinessLocation`.`ordering`, `BusinessLocation`.`created`, `BusinessLocation`.`updated`, `BusinessLocation`.`city`, `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial`, `BusinessType`.`id`, `BusinessType`.`name`, `BusinessType`.`enable`, `BusinessType`.`ordering`, `BusinessType`.`created`, `BusinessType`.`updated` FROM `ekonty_moo`.`businesses` AS `Business` LEFT JOIN `ekonty_moo`.`users` AS `User` ON (`Business`.`user_id` = `User`.`id`) LEFT JOIN `ekonty_moo`.`business_locations` AS `BusinessLocation` ON (`Business`.`business_location_id` = `BusinessLocation`.`id`) LEFT JOIN `ekonty_moo`.`business_packages` AS `BusinessPackage` ON (`Business`.`business_package_id` = `BusinessPackage`.`id`) LEFT JOIN `ekonty_moo`.`business_types` AS `BusinessType` ON (`Business`.`business_type_id` = `BusinessType`.`id`) WHERE `Business`.`id` = 69 LIMIT 1 | | 1 | 1 | 1 |
196 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `ekonty_moo`.`roles` AS `Role` WHERE `Role`.`id` = 2 | | 1 | 1 | 0 |
197 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | | 5 | 5 | 0 |
198 | SELECT `BusinessTime`.`id`, `BusinessTime`.`business_id`, `BusinessTime`.`day`, `BusinessTime`.`time_open`, `BusinessTime`.`time_close`, `BusinessTime`.`next_day` FROM `ekonty_moo`.`business_times` AS `BusinessTime` WHERE `BusinessTime`.`business_id` = (69) | | 1 | 1 | 1 |
199 | SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `ekonty_moo`.`business_categories` AS `BusinessCategory` JOIN `ekonty_moo`.`business_category_items` AS `BusinessCategoryItem` ON (`BusinessCategoryItem`.`business_id` = 69 AND `BusinessCategoryItem`.`business_category_id` = `BusinessCategory`.`id`) | | 1 | 1 | 0 |
200 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (15) ORDER BY `id` ASC | | 5 | 5 | 0 |
201 | SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`whatsapp`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated`, `User`.`id`, `User`.`is_old`, `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`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `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`.`lock_delete`, `User`.`darkmode`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`phone`, `User`.`phone_verified`, `User`.`poked_email`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_online_status`, `User`.`hide_profile_complete`, `User`.`sendinblue_id`, `User`.`mobile_csv`, `User`.`qualification_csv`, `User`.`is_csv`, `User`.`subscriber_uid`, `User`.`list_uid`, `User`.`viewer_invisible`, `User`.`showlastseen`, `User`.`lastseen`, `User`.`first_name`, `User`.`last_name`, `User`.`online`, `User`.`interest_values`, `BusinessLocation`.`id`, `BusinessLocation`.`parent_id`, `BusinessLocation`.`lft`, `BusinessLocation`.`rght`, `BusinessLocation`.`name`, `BusinessLocation`.`business_count`, `BusinessLocation`.`is_default`, `BusinessLocation`.`on_popup`, `BusinessLocation`.`enabled`, `BusinessLocation`.`ordering`, `BusinessLocation`.`created`, `BusinessLocation`.`updated`, `BusinessLocation`.`city`, `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial`, `BusinessType`.`id`, `BusinessType`.`name`, `BusinessType`.`enable`, `BusinessType`.`ordering`, `BusinessType`.`created`, `BusinessType`.`updated` FROM `ekonty_moo`.`businesses` AS `Business` LEFT JOIN `ekonty_moo`.`users` AS `User` ON (`Business`.`user_id` = `User`.`id`) LEFT JOIN `ekonty_moo`.`business_locations` AS `BusinessLocation` ON (`Business`.`business_location_id` = `BusinessLocation`.`id`) LEFT JOIN `ekonty_moo`.`business_packages` AS `BusinessPackage` ON (`Business`.`business_package_id` = `BusinessPackage`.`id`) LEFT JOIN `ekonty_moo`.`business_types` AS `BusinessType` ON (`Business`.`business_type_id` = `BusinessType`.`id`) WHERE `Business`.`id` = 69 LIMIT 1 | | 1 | 1 | 1 |
202 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `ekonty_moo`.`roles` AS `Role` WHERE `Role`.`id` = 2 | | 1 | 1 | 0 |
203 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | | 5 | 5 | 0 |
204 | SELECT `BusinessTime`.`id`, `BusinessTime`.`business_id`, `BusinessTime`.`day`, `BusinessTime`.`time_open`, `BusinessTime`.`time_close`, `BusinessTime`.`next_day` FROM `ekonty_moo`.`business_times` AS `BusinessTime` WHERE `BusinessTime`.`business_id` = (69) | | 1 | 1 | 1 |
205 | SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `ekonty_moo`.`business_categories` AS `BusinessCategory` JOIN `ekonty_moo`.`business_category_items` AS `BusinessCategoryItem` ON (`BusinessCategoryItem`.`business_id` = 69 AND `BusinessCategoryItem`.`business_category_id` = `BusinessCategory`.`id`) | | 1 | 1 | 0 |
206 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (15) ORDER BY `id` ASC | | 5 | 5 | 0 |
207 | SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`whatsapp`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated`, `User`.`id`, `User`.`is_old`, `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`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `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`.`lock_delete`, `User`.`darkmode`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`phone`, `User`.`phone_verified`, `User`.`poked_email`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_online_status`, `User`.`hide_profile_complete`, `User`.`sendinblue_id`, `User`.`mobile_csv`, `User`.`qualification_csv`, `User`.`is_csv`, `User`.`subscriber_uid`, `User`.`list_uid`, `User`.`viewer_invisible`, `User`.`showlastseen`, `User`.`lastseen`, `User`.`first_name`, `User`.`last_name`, `User`.`online`, `User`.`interest_values`, `BusinessLocation`.`id`, `BusinessLocation`.`parent_id`, `BusinessLocation`.`lft`, `BusinessLocation`.`rght`, `BusinessLocation`.`name`, `BusinessLocation`.`business_count`, `BusinessLocation`.`is_default`, `BusinessLocation`.`on_popup`, `BusinessLocation`.`enabled`, `BusinessLocation`.`ordering`, `BusinessLocation`.`created`, `BusinessLocation`.`updated`, `BusinessLocation`.`city`, `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial`, `BusinessType`.`id`, `BusinessType`.`name`, `BusinessType`.`enable`, `BusinessType`.`ordering`, `BusinessType`.`created`, `BusinessType`.`updated` FROM `ekonty_moo`.`businesses` AS `Business` LEFT JOIN `ekonty_moo`.`users` AS `User` ON (`Business`.`user_id` = `User`.`id`) LEFT JOIN `ekonty_moo`.`business_locations` AS `BusinessLocation` ON (`Business`.`business_location_id` = `BusinessLocation`.`id`) LEFT JOIN `ekonty_moo`.`business_packages` AS `BusinessPackage` ON (`Business`.`business_package_id` = `BusinessPackage`.`id`) LEFT JOIN `ekonty_moo`.`business_types` AS `BusinessType` ON (`Business`.`business_type_id` = `BusinessType`.`id`) WHERE `Business`.`id` = 69 LIMIT 1 | | 1 | 1 | 1 |
208 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `ekonty_moo`.`roles` AS `Role` WHERE `Role`.`id` = 2 | | 1 | 1 | 0 |
209 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | | 5 | 5 | 0 |
210 | SELECT `BusinessTime`.`id`, `BusinessTime`.`business_id`, `BusinessTime`.`day`, `BusinessTime`.`time_open`, `BusinessTime`.`time_close`, `BusinessTime`.`next_day` FROM `ekonty_moo`.`business_times` AS `BusinessTime` WHERE `BusinessTime`.`business_id` = (69) | | 1 | 1 | 1 |
211 | SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `ekonty_moo`.`business_categories` AS `BusinessCategory` JOIN `ekonty_moo`.`business_category_items` AS `BusinessCategoryItem` ON (`BusinessCategoryItem`.`business_id` = 69 AND `BusinessCategoryItem`.`business_category_id` = `BusinessCategory`.`id`) | | 1 | 1 | 0 |
212 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (15) ORDER BY `id` ASC | | 5 | 5 | 0 |
213 | SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`whatsapp`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated`, `User`.`id`, `User`.`is_old`, `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`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `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`.`lock_delete`, `User`.`darkmode`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`phone`, `User`.`phone_verified`, `User`.`poked_email`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_online_status`, `User`.`hide_profile_complete`, `User`.`sendinblue_id`, `User`.`mobile_csv`, `User`.`qualification_csv`, `User`.`is_csv`, `User`.`subscriber_uid`, `User`.`list_uid`, `User`.`viewer_invisible`, `User`.`showlastseen`, `User`.`lastseen`, `User`.`first_name`, `User`.`last_name`, `User`.`online`, `User`.`interest_values`, `BusinessLocation`.`id`, `BusinessLocation`.`parent_id`, `BusinessLocation`.`lft`, `BusinessLocation`.`rght`, `BusinessLocation`.`name`, `BusinessLocation`.`business_count`, `BusinessLocation`.`is_default`, `BusinessLocation`.`on_popup`, `BusinessLocation`.`enabled`, `BusinessLocation`.`ordering`, `BusinessLocation`.`created`, `BusinessLocation`.`updated`, `BusinessLocation`.`city`, `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial`, `BusinessType`.`id`, `BusinessType`.`name`, `BusinessType`.`enable`, `BusinessType`.`ordering`, `BusinessType`.`created`, `BusinessType`.`updated` FROM `ekonty_moo`.`businesses` AS `Business` LEFT JOIN `ekonty_moo`.`users` AS `User` ON (`Business`.`user_id` = `User`.`id`) LEFT JOIN `ekonty_moo`.`business_locations` AS `BusinessLocation` ON (`Business`.`business_location_id` = `BusinessLocation`.`id`) LEFT JOIN `ekonty_moo`.`business_packages` AS `BusinessPackage` ON (`Business`.`business_package_id` = `BusinessPackage`.`id`) LEFT JOIN `ekonty_moo`.`business_types` AS `BusinessType` ON (`Business`.`business_type_id` = `BusinessType`.`id`) WHERE `Business`.`id` = 69 LIMIT 1 | | 1 | 1 | 1 |
214 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `ekonty_moo`.`roles` AS `Role` WHERE `Role`.`id` = 2 | | 1 | 1 | 0 |
215 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | | 5 | 5 | 0 |
216 | SELECT `BusinessTime`.`id`, `BusinessTime`.`business_id`, `BusinessTime`.`day`, `BusinessTime`.`time_open`, `BusinessTime`.`time_close`, `BusinessTime`.`next_day` FROM `ekonty_moo`.`business_times` AS `BusinessTime` WHERE `BusinessTime`.`business_id` = (69) | | 1 | 1 | 1 |
217 | SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `ekonty_moo`.`business_categories` AS `BusinessCategory` JOIN `ekonty_moo`.`business_category_items` AS `BusinessCategoryItem` ON (`BusinessCategoryItem`.`business_id` = 69 AND `BusinessCategoryItem`.`business_category_id` = `BusinessCategory`.`id`) | | 1 | 1 | 0 |
218 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `ekonty_moo`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (15) ORDER BY `id` ASC | | 5 | 5 | 0 |
219 | SELECT COUNT(*) AS `count` FROM `ekonty_moo`.`stores` AS `Store` WHERE `Store`.`business_id` = 69 | | 1 | 1 | 1 |
220 | 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 `ekonty_moo`.`settings` AS `Setting` LEFT JOIN `ekonty_moo`.`setting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1 | | 1 | 1 | 0 |
221 | 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 `ekonty_moo`.`settings` AS `Setting` LEFT JOIN `ekonty_moo`.`setting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1 | | 1 | 1 | 0 |