menu
menu
Menu
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`user_id` FROM `flokiicom_latest`.`cake_sessions` AS `Session` WHERE `Session`.`id` = '3f5d239d0d8039ea7eb68de89e93d44c' LIMIT 1 | 1 | 1 | 0 | |
| 2 | SELECT `Plugin`.`enabled` FROM `flokiicom_latest`.`plugins` AS `Plugin` WHERE `Plugin`.`key` = 'Storage' ORDER BY `Plugin`.`weight` asc LIMIT 1 | 1 | 1 | 0 | |
| 3 | SELECT `Plugin`.`enabled` FROM `flokiicom_latest`.`plugins` AS `Plugin` WHERE `Plugin`.`key` = 'Storage' ORDER BY `Plugin`.`weight` asc LIMIT 1 | 1 | 1 | 0 | |
| 4 | SELECT `CoreContentValue`.`id`, `CoreContentValue`.`content_id`, `CoreContentValue`.`field_name`, `CoreContentValue`.`value`, (`I18n__valueTranslation`.`content`) AS `CoreContentValue__i18n_valueTranslation`, `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 `flokiicom_latest`.`core_content_values` AS `CoreContentValue` LEFT JOIN `flokiicom_latest`.`core_contents` AS `CoreContent` ON (`CoreContentValue`.`content_id` = `CoreContent`.`id`) INNER JOIN `flokiicom_latest`.`i18n` AS `I18n__valueTranslation` ON (`CoreContentValue`.`id` = `I18n__valueTranslation`.`foreign_key` AND `I18n__valueTranslation`.`model` = 'CoreContentValue' AND `I18n__valueTranslation`.`field` = 'value' AND `I18n__valueTranslation`.`locale` = 'eng') WHERE `CoreContentValue`.`content_id` = 502 LIMIT 1 | 0 | 0 | 0 | |
| 5 | SELECT `BusinessLocation`.`id` FROM `flokiicom_latest`.`business_locations` AS `BusinessLocation` WHERE `BusinessLocation`.`parent_id` = 0 AND `BusinessLocation`.`enabled` = '1' ORDER BY `BusinessLocation`.`ordering` ASC | 137 | 137 | 6 | |
| 6 | 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 `flokiicom_latest`.`business_locations` AS `BusinessLocation` WHERE `BusinessLocation`.`is_default` = '1' AND `BusinessLocation`.`parent_id` IN (218, 230, 232, 234, 236, 240, 242, 245, 250, 252, 257, 259, 261, 263, 265, 267, 269, 294, 522, 609, 842, 1014, 1016, 1042, 1095, 1242, 1472, 1476, 1495, 1518, 1542, 1776, 1779, 1792, 2174, 2367, 2410, 2433, 2499, 2536, 2566, 2570, 2580, 2582, 2586, 2640, 2651, 2740, 3333, 3354, 3733, 4104, 4158, 4430, 4558, 5424, 5588, 5591, 5879, 5966, 6007, 6574, 6691, 6968, 7023, 7044, 7046, 7394, 7523, 7547, 8208, 8238, 8355, 8448, 8530, 8609, 8683, 8697, 8815, 8909, 8933, 9001, 9032, 9145, 9154, 9170, 9363, 9369, 9393, 9561, 9595, 9641, 9833, 9856, 9906, 9910, 9969, 10060, 10094, 10154, 10156, 10166, 10260, 10295, 10365, 10382, 10466, 10497, 10503, 10510, 10524, 10543, 10554, 10566, 10579, 10599, 10673, 10851, 10903, 10983, 11030, 11052, 11087, 11111, 11170, 11442, 11451, 11512, 11652, 11654, 11816, 11829, 11854, 11995, 12105, 12629, 254) ORDER BY `BusinessLocation`.`ordering` ASC LIMIT 1 | 0 | 0 | 8 | |
| 7 | SELECT COUNT(*) AS `count` FROM `flokiicom_latest`.`businesses` AS `Business` WHERE `Business`.`id` = 46838 | 1 | 1 | 0 | |
| 8 | SELECT COUNT(*) AS `count` FROM `flokiicom_latest`.`businesses` AS `Business` WHERE `Business`.`id` = 46838 AND `Business`.`user_id` = '' | 1 | 1 | 0 | |
| 9 | SELECT COUNT(*) AS `count` FROM `flokiicom_latest`.`businesses` AS `Business` WHERE `Business`.`id` = 46838 AND `Business`.`user_id` = '' | 1 | 1 | 0 | |
| 10 | SELECT COUNT(*) AS `count` FROM `flokiicom_latest`.`business_admins` AS `BusinessAdmin` WHERE `BusinessAdmin`.`business_id` = 46838 AND `BusinessAdmin`.`user_id` = '' | 1 | 1 | 0 | |
| 11 | SELECT COUNT(*) AS `count` FROM `flokiicom_latest`.`businesses` AS `Business` WHERE `Business`.`id` = 46838 AND `Business`.`status` = 'approved' | 1 | 1 | 0 | |
| 12 | SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`chat_count`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`chat_online_status`, `User`.`lock_delete`, `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`.`description`, `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 `flokiicom_latest`.`businesses` AS `Business` LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`Business`.`user_id` = `User`.`id`) LEFT JOIN `flokiicom_latest`.`business_locations` AS `BusinessLocation` ON (`Business`.`business_location_id` = `BusinessLocation`.`id`) LEFT JOIN `flokiicom_latest`.`business_packages` AS `BusinessPackage` ON (`Business`.`business_package_id` = `BusinessPackage`.`id`) LEFT JOIN `flokiicom_latest`.`business_types` AS `BusinessType` ON (`Business`.`business_type_id` = `BusinessType`.`id`) WHERE `Business`.`parent_id` = 0 AND `Business`.`id` = 46838 LIMIT 1 | 1 | 1 | 0 | |
| 13 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `flokiicom_latest`.`roles` AS `Role` WHERE `Role`.`id` = 2 | 1 | 1 | 0 | |
| 14 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `flokiicom_latest`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | 2 | 2 | 0 | |
| 15 | SELECT `BusinessTime`.`id`, `BusinessTime`.`business_id`, `BusinessTime`.`day`, `BusinessTime`.`time_open`, `BusinessTime`.`time_close`, `BusinessTime`.`next_day` FROM `flokiicom_latest`.`business_times` AS `BusinessTime` WHERE `BusinessTime`.`business_id` = (46838) | 1 | 1 | 206 | |
| 16 | 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 `flokiicom_latest`.`business_categories` AS `BusinessCategory` JOIN `flokiicom_latest`.`business_category_items` AS `BusinessCategoryItem` ON (`BusinessCategoryItem`.`business_id` = 46838 AND `BusinessCategoryItem`.`business_category_id` = `BusinessCategory`.`id`) | 1 | 1 | 0 | |
| 17 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `flokiicom_latest`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (45) ORDER BY `id` ASC | 2 | 2 | 1 | |
| 18 | SELECT `BusinessPayment`.`id`, `BusinessPayment`.`name`, `BusinessPayment`.`icon`, `BusinessPayment`.`enable`, `BusinessPayment`.`created`, `BusinessPayment`.`updated`, `BusinessPaymentType`.`id`, `BusinessPaymentType`.`business_payment_id`, `BusinessPaymentType`.`business_id` FROM `flokiicom_latest`.`business_payments` AS `BusinessPayment` JOIN `flokiicom_latest`.`business_payment_types` AS `BusinessPaymentType` ON (`BusinessPaymentType`.`business_id` = 46838 AND `BusinessPaymentType`.`business_payment_id` = `BusinessPayment`.`id`) | 0 | 0 | 24 | |
| 19 | SELECT `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, (`I18n__nameTranslation`.`content`) AS `ProfileType__i18n_nameTranslation` FROM `flokiicom_latest`.`profile_types` AS `ProfileType` INNER JOIN `flokiicom_latest`.`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 | 1 | |
| 20 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `flokiicom_latest`.`i18n` AS `nameTranslation` WHERE `model` = 'ProfileType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | 2 | 2 | 0 | |
| 21 | SELECT `BusinessCategory`.`lft`, `BusinessCategory`.`rght` FROM `flokiicom_latest`.`business_categories` AS `BusinessCategory` WHERE `BusinessCategory`.`id` = 45 LIMIT 1 | 1 | 1 | 0 | |
| 22 | 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 `flokiicom_latest`.`business_categories` AS `BusinessCategory` INNER JOIN `flokiicom_latest`.`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` <= 65 AND `BusinessCategory`.`rght` >= 66 ORDER BY `BusinessCategory`.`lft` asc | 1 | 1 | 19 | |
| 23 | SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`chat_count`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`chat_online_status`, `User`.`lock_delete`, `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`.`description`, `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 `flokiicom_latest`.`businesses` AS `Business` LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`Business`.`user_id` = `User`.`id`) LEFT JOIN `flokiicom_latest`.`business_locations` AS `BusinessLocation` ON (`Business`.`business_location_id` = `BusinessLocation`.`id`) LEFT JOIN `flokiicom_latest`.`business_packages` AS `BusinessPackage` ON (`Business`.`business_package_id` = `BusinessPackage`.`id`) LEFT JOIN `flokiicom_latest`.`business_types` AS `BusinessType` ON (`Business`.`business_type_id` = `BusinessType`.`id`) WHERE `Business`.`id` = 46838 LIMIT 1 | 1 | 1 | 1 | |
| 24 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `flokiicom_latest`.`roles` AS `Role` WHERE `Role`.`id` = 2 | 1 | 1 | 0 | |
| 25 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `flokiicom_latest`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | 2 | 2 | 0 | |
| 26 | SELECT `BusinessTime`.`id`, `BusinessTime`.`business_id`, `BusinessTime`.`day`, `BusinessTime`.`time_open`, `BusinessTime`.`time_close`, `BusinessTime`.`next_day` FROM `flokiicom_latest`.`business_times` AS `BusinessTime` WHERE `BusinessTime`.`business_id` = (46838) | 1 | 1 | 215 | |
| 27 | 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 `flokiicom_latest`.`business_categories` AS `BusinessCategory` JOIN `flokiicom_latest`.`business_category_items` AS `BusinessCategoryItem` ON (`BusinessCategoryItem`.`business_id` = 46838 AND `BusinessCategoryItem`.`business_category_id` = `BusinessCategory`.`id`) | 1 | 1 | 0 | |
| 28 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `flokiicom_latest`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (45) ORDER BY `id` ASC | 2 | 2 | 0 | |
| 29 | 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 `flokiicom_latest`.`business_locations` AS `BusinessLocation` WHERE `BusinessLocation`.`id` = 5488 ORDER BY `BusinessLocation`.`ordering` ASC LIMIT 1 | 1 | 1 | 0 | |
| 30 | SELECT COUNT(*) AS `count` FROM `flokiicom_latest`.`businesses` AS `Business` WHERE `Business`.`id` = 46838 AND `Business`.`user_id` = '' | 1 | 1 | 0 | |
| 31 | SELECT COUNT(*) AS `count` FROM `flokiicom_latest`.`business_admins` AS `BusinessAdmin` WHERE `BusinessAdmin`.`business_id` = 46838 AND `BusinessAdmin`.`user_id` = '' | 1 | 1 | 0 | |
| 32 | SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`chat_count`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`chat_online_status`, `User`.`lock_delete`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `flokiicom_latest`.`users` AS `User` LEFT JOIN `flokiicom_latest`.`roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `User`.`id` = '' LIMIT 1 | 0 | 0 | 0 | |
| 33 | SELECT COUNT(*) AS `count` FROM `flokiicom_latest`.`business_reviews` AS `BusinessReview` LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`BusinessReview`.`user_id` = `User`.`id`) WHERE `BusinessReview`.`business_id` = 46838 | 1 | 1 | 1 | |
| 34 | SELECT (FLOOR(`BusinessReview`.`rating`)) AS `BusinessReview__star`, (SUM(`BusinessReview`.`rating`)) AS `BusinessReview__total_rating`, (COUNT(`BusinessReview`.`rating`)) AS `BusinessReview__total_vote` FROM `flokiicom_latest`.`business_reviews` AS `BusinessReview` LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`BusinessReview`.`user_id` = `User`.`id`) WHERE `BusinessReview`.`business_id` = 46838 GROUP BY (FLOOR(`BusinessReview`.`rating`)) ORDER BY (FLOOR(`BusinessReview`.`rating`)) DESC | 0 | 0 | 2 | |
| 35 | SELECT COUNT(*) AS `count` FROM `flokiicom_latest`.`business_reviews` AS `BusinessReview` WHERE `business_id` = 46838 AND `parent_id` = 0 AND `BusinessReview`.`user_id` = '' | 1 | 1 | 2 | |
| 36 | SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`chat_count`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`chat_online_status`, `User`.`lock_delete`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `flokiicom_latest`.`users` AS `User` LEFT JOIN `flokiicom_latest`.`roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `User`.`id` = 3381 LIMIT 1 | 1 | 1 | 0 | |
| 37 | SELECT `BusinessFollow`.`id`, `BusinessFollow`.`user_id`, `BusinessFollow`.`business_id`, `BusinessFollow`.`is_banned`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`chat_count`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`chat_online_status`, `User`.`lock_delete`, `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated` FROM `flokiicom_latest`.`business_follows` AS `BusinessFollow` LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`BusinessFollow`.`user_id` = `User`.`id`) LEFT JOIN `flokiicom_latest`.`businesses` AS `Business` ON (`BusinessFollow`.`business_id` = `Business`.`id`) WHERE `BusinessFollow`.`business_id` = 46838 AND `BusinessFollow`.`is_banned` = '0' LIMIT 5 | 0 | 0 | 4 | |
| 38 | SELECT COUNT(*) AS `count` FROM `flokiicom_latest`.`business_follows` AS `BusinessFollow` WHERE `BusinessFollow`.`business_id` = 46838 AND `BusinessFollow`.`user_id` = '' | 1 | 1 | 3 | |
| 39 | SELECT COUNT(*) AS `count` FROM `flokiicom_latest`.`businesses` AS `Business` WHERE `Business`.`user_id` = '' | 1 | 1 | 123 | |
| 40 | SELECT COUNT(*) AS `count` FROM `flokiicom_latest`.`business_favourites` AS `BusinessFavourite` WHERE `BusinessFavourite`.`user_id` = '' AND `BusinessFavourite`.`business_id` = 46838 | 1 | 1 | 0 | |
| 41 | SELECT COUNT(*) AS `count` FROM `flokiicom_latest`.`business_follows` AS `BusinessFollow` WHERE `BusinessFollow`.`business_id` = 46838 AND `BusinessFollow`.`user_id` = '' AND `BusinessFollow`.`is_banned` = '1' | 1 | 1 | 3 | |
| 42 | SELECT COUNT(*) AS `count` FROM `flokiicom_latest`.`businesses` AS `Business` WHERE `Business`.`id` = 46838 AND `Business`.`user_id` = '' | 1 | 1 | 0 | |
| 43 | SELECT COUNT(*) AS `count` FROM `flokiicom_latest`.`business_admins` AS `BusinessAdmin` WHERE `BusinessAdmin`.`business_id` = 46838 AND `BusinessAdmin`.`user_id` = '' | 1 | 1 | 0 | |
| 44 | SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`chat_count`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`chat_online_status`, `User`.`lock_delete`, `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`.`description`, `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 `flokiicom_latest`.`businesses` AS `Business` LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`Business`.`user_id` = `User`.`id`) LEFT JOIN `flokiicom_latest`.`business_locations` AS `BusinessLocation` ON (`Business`.`business_location_id` = `BusinessLocation`.`id`) LEFT JOIN `flokiicom_latest`.`business_packages` AS `BusinessPackage` ON (`Business`.`business_package_id` = `BusinessPackage`.`id`) LEFT JOIN `flokiicom_latest`.`business_types` AS `BusinessType` ON (`Business`.`business_type_id` = `BusinessType`.`id`) WHERE `Business`.`id` = 46838 LIMIT 1 | 1 | 1 | 1 | |
| 45 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `flokiicom_latest`.`roles` AS `Role` WHERE `Role`.`id` = 2 | 1 | 1 | 0 | |
| 46 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `flokiicom_latest`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | 2 | 2 | 0 | |
| 47 | SELECT `BusinessTime`.`id`, `BusinessTime`.`business_id`, `BusinessTime`.`day`, `BusinessTime`.`time_open`, `BusinessTime`.`time_close`, `BusinessTime`.`next_day` FROM `flokiicom_latest`.`business_times` AS `BusinessTime` WHERE `BusinessTime`.`business_id` = (46838) | 1 | 1 | 228 | |
| 48 | 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 `flokiicom_latest`.`business_categories` AS `BusinessCategory` JOIN `flokiicom_latest`.`business_category_items` AS `BusinessCategoryItem` ON (`BusinessCategoryItem`.`business_id` = 46838 AND `BusinessCategoryItem`.`business_category_id` = `BusinessCategory`.`id`) | 1 | 1 | 0 | |
| 49 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `flokiicom_latest`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (45) ORDER BY `id` ASC | 2 | 2 | 0 | |
| 50 | SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`chat_count`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`chat_online_status`, `User`.`lock_delete`, `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`description`, `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 `flokiicom_latest`.`businesses` AS `Business` LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`Business`.`user_id` = `User`.`id`) LEFT JOIN `flokiicom_latest`.`business_packages` AS `BusinessPackage` ON (`Business`.`business_package_id` = `BusinessPackage`.`id`) WHERE `Business`.`id` = 46838 LIMIT 1 | 1 | 1 | 1 | |
| 51 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `flokiicom_latest`.`roles` AS `Role` WHERE `Role`.`id` = 2 | 1 | 1 | 0 | |
| 52 | SELECT count(`BusinessStatistic`.`country_code`) as total_sum,country FROM `flokiicom_latest`.`business_statistics` AS `BusinessStatistic` LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`BusinessStatistic`.`user_id` = `User`.`id`) WHERE `BusinessStatistic`.`created` BETWEEN '2024-05-21' AND '2024-05-31' AND `BusinessStatistic`.`business_id` = '46838' GROUP BY `BusinessStatistic`.`country_code` ORDER BY `total_sum` DESC LIMIT 5 | 0 | 0 | 0 | |
| 53 | SELECT `BusinessStatistic`.`id`, `BusinessStatistic`.`user_id`, `BusinessStatistic`.`business_id`, `BusinessStatistic`.`hits`, `BusinessStatistic`.`country`, `BusinessStatistic`.`country_code`, `BusinessStatistic`.`ip_address`, `BusinessStatistic`.`agent`, `BusinessStatistic`.`flatform`, `BusinessStatistic`.`agent_version`, `BusinessStatistic`.`created`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`chat_count`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`chat_online_status`, `User`.`lock_delete` FROM `flokiicom_latest`.`business_statistics` AS `BusinessStatistic` LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`BusinessStatistic`.`user_id` = `User`.`id`) WHERE `BusinessStatistic`.`created` BETWEEN '2024-05-21' AND '2024-05-31' AND `BusinessStatistic`.`business_id` = '46838' GROUP BY `BusinessStatistic`.`user_id` | 0 | 0 | 1 | |
| 54 | SELECT count(`BusinessStatistic`.`country_code`) as total_sum,country FROM `flokiicom_latest`.`business_statistics` AS `BusinessStatistic` LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`BusinessStatistic`.`user_id` = `User`.`id`) WHERE `BusinessStatistic`.`created` BETWEEN '2024-05-21' AND '2024-05-31' AND `BusinessStatistic`.`business_id` = '46838' GROUP BY `BusinessStatistic`.`country_code` ORDER BY `total_sum` DESC | 0 | 0 | 0 | |
| 55 | SELECT `BusinessStatistic`.`created`, (SUM(`BusinessStatistic`.`hits`)) AS `BusinessStatistic__total` FROM `flokiicom_latest`.`business_statistics` AS `BusinessStatistic` WHERE `BusinessStatistic`.`created` BETWEEN '2024-05-21' AND '2024-05-31' AND `BusinessStatistic`.`business_id` = '46838' GROUP BY `BusinessStatistic`.`created` | 0 | 0 | 0 | |
| 56 | SELECT `BusinessStatistic`.`id`, `BusinessStatistic`.`created` FROM `flokiicom_latest`.`business_statistics` AS `BusinessStatistic` WHERE `BusinessStatistic`.`created` BETWEEN '2024-05-21' AND '2024-05-31' AND `BusinessStatistic`.`business_id` = '46838' GROUP BY `BusinessStatistic`.`created`, `BusinessStatistic`.`user_id` | 0 | 0 | 0 | |
| 57 | SELECT `User`.`gender` FROM `flokiicom_latest`.`business_statistics` AS `BusinessStatistic` LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`BusinessStatistic`.`user_id` = `User`.`id`) WHERE `BusinessStatistic`.`created` BETWEEN '2024-05-21' AND '2024-05-31' AND `BusinessStatistic`.`business_id` = '46838' GROUP BY `User`.`gender` | 0 | 0 | 0 | |
| 58 | SELECT BusinessStatistic.user_id, User.birthday FROM `flokiicom_latest`.`business_statistics` AS `BusinessStatistic` LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`BusinessStatistic`.`user_id` = `User`.`id`) WHERE `BusinessStatistic`.`created` BETWEEN '2024-05-21' AND '2024-05-31' AND `BusinessStatistic`.`business_id` = '46838' AND `User`.`birthday` > '2006-05-31' GROUP BY `BusinessStatistic`.`user_id` | 0 | 0 | 0 | |
| 59 | SELECT BusinessStatistic.user_id, User.birthday FROM `flokiicom_latest`.`business_statistics` AS `BusinessStatistic` LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`BusinessStatistic`.`user_id` = `User`.`id`) WHERE (`BusinessStatistic`.`created` BETWEEN '2024-05-21' AND '2024-05-31') AND `BusinessStatistic`.`business_id` = '46838' AND (`User`.`birthday` <= '2006-05-31' AND `User`.`birthday` >='2000-05-31') GROUP BY `BusinessStatistic`.`user_id` | 0 | 0 | 0 | |
| 60 | SELECT BusinessStatistic.user_id, User.birthday FROM `flokiicom_latest`.`business_statistics` AS `BusinessStatistic` LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`BusinessStatistic`.`user_id` = `User`.`id`) WHERE (`BusinessStatistic`.`created` BETWEEN '2024-05-21' AND '2024-05-31') AND `BusinessStatistic`.`business_id` = '46838' AND (`User`.`birthday` < '2000-05-31' AND `User`.`birthday` >='1990-05-31') GROUP BY `BusinessStatistic`.`user_id` | 0 | 0 | 0 | |
| 61 | SELECT BusinessStatistic.user_id, User.birthday FROM `flokiicom_latest`.`business_statistics` AS `BusinessStatistic` LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`BusinessStatistic`.`user_id` = `User`.`id`) WHERE (`BusinessStatistic`.`created` BETWEEN '2024-05-21' AND '2024-05-31') AND `BusinessStatistic`.`business_id` = '46838' AND (`User`.`birthday` < '1990-05-31' AND `User`.`birthday` >='1980-05-31') GROUP BY `BusinessStatistic`.`user_id` | 0 | 0 | 0 | |
| 62 | SELECT BusinessStatistic.user_id, User.birthday FROM `flokiicom_latest`.`business_statistics` AS `BusinessStatistic` LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`BusinessStatistic`.`user_id` = `User`.`id`) WHERE (`BusinessStatistic`.`created` BETWEEN '2024-05-21' AND '2024-05-31') AND `BusinessStatistic`.`business_id` = '46838' AND (`User`.`birthday` < '1980-05-31' AND `User`.`birthday` >='1970-05-31') GROUP BY `BusinessStatistic`.`user_id` | 0 | 0 | 0 | |
| 63 | SELECT BusinessStatistic.user_id, User.birthday FROM `flokiicom_latest`.`business_statistics` AS `BusinessStatistic` LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`BusinessStatistic`.`user_id` = `User`.`id`) WHERE (`BusinessStatistic`.`created` BETWEEN '2024-05-21' AND '2024-05-31') AND `BusinessStatistic`.`business_id` = '46838' AND (`User`.`birthday` < '1970-05-31' AND `User`.`birthday` >='1960-05-31') GROUP BY `BusinessStatistic`.`user_id` | 0 | 0 | 0 | |
| 64 | SELECT BusinessStatistic.user_id, User.birthday FROM `flokiicom_latest`.`business_statistics` AS `BusinessStatistic` LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`BusinessStatistic`.`user_id` = `User`.`id`) WHERE `BusinessStatistic`.`created` BETWEEN '2024-05-21' AND '2024-05-31' AND `BusinessStatistic`.`business_id` = '46838' AND `User`.`birthday` <= '1960-05-31' GROUP BY `BusinessStatistic`.`user_id` | 0 | 0 | 0 | |
| 65 | SELECT SUM(`BusinessStatistic`.`hits`) as count_hits,BusinessStatistic.user_id,User.* FROM `flokiicom_latest`.`business_statistics` AS `BusinessStatistic` LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`BusinessStatistic`.`user_id` = `User`.`id`) WHERE `BusinessStatistic`.`created` BETWEEN '2024-05-21' AND '2024-05-31' AND `BusinessStatistic`.`business_id` = '46838' GROUP BY `BusinessStatistic`.`user_id` ORDER BY `count_hits` DESC LIMIT 5 | 0 | 0 | 0 | |
| 66 | SELECT COUNT(*) AS `count` FROM `flokiicom_latest`.`business_reviews` AS `BusinessReview` WHERE `business_id` = 46838 AND `parent_id` = 0 AND `BusinessReview`.`user_id` = '' | 1 | 1 | 1 | |
| 67 | SELECT COUNT(*) AS `count` FROM `flokiicom_latest`.`businesses` AS `Business` WHERE `Business`.`id` = 46838 AND `Business`.`user_id` = '' | 1 | 1 | 0 | |
| 68 | SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`chat_count`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`chat_online_status`, `User`.`lock_delete`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `flokiicom_latest`.`users` AS `User` LEFT JOIN `flokiicom_latest`.`roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `User`.`id` IS NULL LIMIT 1 | 0 | 0 | 0 | |
| 69 | SELECT `AdsPlacement`.`id`, `AdsPlacement`.`user_id`, `AdsPlacement`.`placement_type`, `AdsPlacement`.`ads_position_id`, `AdsPlacement`.`name`, `AdsPlacement`.`description`, `AdsPlacement`.`dimension_width`, `AdsPlacement`.`dimension_height`, `AdsPlacement`.`price`, `AdsPlacement`.`number_of_ads`, `AdsPlacement`.`total_ads`, `AdsPlacement`.`enable`, `AdsPlacement`.`created`, `AdsPlacement`.`updated`, `AdsPosition`.`id`, `AdsPosition`.`name`, `AdsPosition`.`image`, `AdsPosition`.`ordering` FROM `flokiicom_latest`.`ads_placements` AS `AdsPlacement` LEFT JOIN `flokiicom_latest`.`ads_positions` AS `AdsPosition` ON (`AdsPlacement`.`ads_position_id` = `AdsPosition`.`id`) WHERE `AdsPlacement`.`id` = 3 LIMIT 1 | 1 | 1 | 0 | |
| 70 | SELECT `AdsPlacementFeed`.`id`, `AdsPlacementFeed`.`ads_placement_id`, `AdsPlacementFeed`.`feed_position` FROM `flokiicom_latest`.`ads_placement_feeds` AS `AdsPlacementFeed` WHERE `AdsPlacementFeed`.`ads_placement_id` = (3) | 0 | 0 | 0 | |
| 71 | SELECT `UserCountry`.`id`, `UserCountry`.`user_id`, `UserCountry`.`country_id`, `UserCountry`.`state_id`, `UserCountry`.`address`, `UserCountry`.`zip`, `UserCountry`.`city_id`, `Country`.`id`, `Country`.`name`, `Country`.`country_iso`, `Country`.`state_count`, `Country`.`order`, `Country`.`enable`, `State`.`id`, `State`.`name`, `State`.`state_code`, `State`.`country_id`, `State`.`order`, `State`.`enable`, `State`.`city_count`, `City`.`id`, `City`.`name`, `City`.`city_code`, `City`.`country_id`, `City`.`order`, `City`.`enable`, `City`.`state_id` FROM `flokiicom_latest`.`user_countries` AS `UserCountry` LEFT JOIN `flokiicom_latest`.`countries` AS `Country` ON (`UserCountry`.`country_id` = `Country`.`id`) LEFT JOIN `flokiicom_latest`.`states` AS `State` ON (`UserCountry`.`state_id` = `State`.`id`) LEFT JOIN `flokiicom_latest`.`cities` AS `City` ON (`UserCountry`.`city_id` = `City`.`id`) WHERE `UserCountry`.`user_id` = '' LIMIT 1 | 0 | 0 | 0 | |
| 72 | SELECT `AdsCampaign`.`id`, `AdsCampaign`.`ads_placement_id`, `AdsCampaign`.`client_name`, `AdsCampaign`.`email`, `AdsCampaign`.`note`, `AdsCampaign`.`name`, `AdsCampaign`.`start_date`, `AdsCampaign`.`end_date`, `AdsCampaign`.`payment_status`, `AdsCampaign`.`ads_title`, `AdsCampaign`.`ads_image`, `AdsCampaign`.`link`, `AdsCampaign`.`description`, `AdsCampaign`.`role_id`, `AdsCampaign`.`age_from`, `AdsCampaign`.`age_to`, `AdsCampaign`.`gender`, `AdsCampaign`.`item_status`, `AdsCampaign`.`view_count`, `AdsCampaign`.`click_count`, `AdsCampaign`.`last_date_report`, `AdsCampaign`.`created`, `AdsCampaign`.`updated`, `AdsCampaign`.`is_hide`, `AdsCampaign`.`user_id`, `AdsCampaign`.`country_id`, `AdsCampaign`.`state_id`, `AdsCampaign`.`is_sent_reminder`, `AdsCampaign`.`like_count`, `AdsCampaign`.`comment_count`, `AdsCampaign`.`share_count`, `AdsCampaign`.`dislike_count`, `AdsCampaign`.`privacy`, `AdsPlacement`.`id`, `AdsPlacement`.`user_id`, `AdsPlacement`.`placement_type`, `AdsPlacement`.`ads_position_id`, `AdsPlacement`.`name`, `AdsPlacement`.`description`, `AdsPlacement`.`dimension_width`, `AdsPlacement`.`dimension_height`, `AdsPlacement`.`price`, `AdsPlacement`.`number_of_ads`, `AdsPlacement`.`total_ads`, `AdsPlacement`.`enable`, `AdsPlacement`.`created`, `AdsPlacement`.`updated`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`chat_count`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`chat_online_status`, `User`.`lock_delete` FROM `flokiicom_latest`.`ads_campaigns` AS `AdsCampaign` LEFT JOIN `flokiicom_latest`.`ads_placements` AS `AdsPlacement` ON (`AdsCampaign`.`ads_placement_id` = `AdsPlacement`.`id`) LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`AdsCampaign`.`user_id` = `User`.`id`) WHERE `AdsCampaign`.`ads_placement_id` = 3 AND `AdsCampaign`.`item_status` = 'active' AND `AdsCampaign`.`is_hide` = '0' AND (`AdsCampaign`.`country_id` = 0 AND `AdsCampaign`.`state_id` = 0) ORDER BY `AdsCampaign`.`view_count` ASC | 1 | 1 | 0 | |
| 73 | SELECT `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, (`I18n__nameTranslation`.`content`) AS `ProfileType__i18n_nameTranslation` FROM `flokiicom_latest`.`profile_types` AS `ProfileType` INNER JOIN `flokiicom_latest`.`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 (2, 'eng') AND `ProfileType`.`actived` = '1' ORDER BY `ProfileType`.`order` asc | 1 | 1 | 1 | |
| 74 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `flokiicom_latest`.`i18n` AS `nameTranslation` WHERE `model` = 'ProfileType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (2) ORDER BY `id` ASC | 2 | 2 | 0 | |
| 75 | SELECT `AdsPlacement`.`id`, `AdsPlacement`.`user_id`, `AdsPlacement`.`placement_type`, `AdsPlacement`.`ads_position_id`, `AdsPlacement`.`name`, `AdsPlacement`.`description`, `AdsPlacement`.`dimension_width`, `AdsPlacement`.`dimension_height`, `AdsPlacement`.`price`, `AdsPlacement`.`number_of_ads`, `AdsPlacement`.`total_ads`, `AdsPlacement`.`enable`, `AdsPlacement`.`created`, `AdsPlacement`.`updated`, `AdsPosition`.`id`, `AdsPosition`.`name`, `AdsPosition`.`image`, `AdsPosition`.`ordering` FROM `flokiicom_latest`.`ads_placements` AS `AdsPlacement` LEFT JOIN `flokiicom_latest`.`ads_positions` AS `AdsPosition` ON (`AdsPlacement`.`ads_position_id` = `AdsPosition`.`id`) WHERE `AdsPlacement`.`id` = 3 LIMIT 1 | 1 | 1 | 0 | |
| 76 | SELECT COUNT(*) AS `count` FROM `flokiicom_latest`.`ads_campaigns` AS `AdsCampaign` LEFT JOIN `flokiicom_latest`.`ads_placements` AS `AdsPlacement` ON (`AdsCampaign`.`ads_placement_id` = `AdsPlacement`.`id`) LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`AdsCampaign`.`user_id` = `User`.`id`) WHERE `AdsCampaign`.`ads_placement_id` = 3 AND `AdsCampaign`.`item_status` = 'active' | 1 | 1 | 0 | |
| 77 | SELECT COUNT(*) AS `count` FROM `flokiicom_latest`.`business_checkins` AS `BusinessCheckin` WHERE `BusinessCheckin`.`business_id` = 46838 | 1 | 1 | 0 | |
| 78 | UPDATE `flokiicom_latest`.`businesses` AS `Business` LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`Business`.`user_id` = `User`.`id`) SET `Business`.`checkin_count` = 0 WHERE `Business`.`id` = 46838 | 0 | 0 | 0 | |
| 79 | SELECT `BusinessCheckin`.`id`, `BusinessCheckin`.`business_id`, `BusinessCheckin`.`user_id`, `BusinessCheckin`.`content`, `BusinessCheckin`.`created`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`chat_count`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`chat_online_status`, `User`.`lock_delete`, `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated` FROM `flokiicom_latest`.`business_checkins` AS `BusinessCheckin` LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`BusinessCheckin`.`user_id` = `User`.`id`) LEFT JOIN `flokiicom_latest`.`businesses` AS `Business` ON (`BusinessCheckin`.`business_id` = `Business`.`id`) WHERE `BusinessCheckin`.`business_id` = 46838 ORDER BY `BusinessCheckin`.`id` DESC LIMIT 8 | 0 | 0 | 0 | |
| 80 | SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`chat_count`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`chat_online_status`, `User`.`lock_delete`, `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`.`description`, `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 `flokiicom_latest`.`businesses` AS `Business` LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`Business`.`user_id` = `User`.`id`) LEFT JOIN `flokiicom_latest`.`business_locations` AS `BusinessLocation` ON (`Business`.`business_location_id` = `BusinessLocation`.`id`) LEFT JOIN `flokiicom_latest`.`business_packages` AS `BusinessPackage` ON (`Business`.`business_package_id` = `BusinessPackage`.`id`) LEFT JOIN `flokiicom_latest`.`business_types` AS `BusinessType` ON (`Business`.`business_type_id` = `BusinessType`.`id`) WHERE `Business`.`id` = 46838 LIMIT 1 | 1 | 1 | 0 | |
| 81 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `flokiicom_latest`.`roles` AS `Role` WHERE `Role`.`id` = 2 | 1 | 1 | 0 | |
| 82 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `flokiicom_latest`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | 2 | 2 | 0 | |
| 83 | SELECT `BusinessTime`.`id`, `BusinessTime`.`business_id`, `BusinessTime`.`day`, `BusinessTime`.`time_open`, `BusinessTime`.`time_close`, `BusinessTime`.`next_day` FROM `flokiicom_latest`.`business_times` AS `BusinessTime` WHERE `BusinessTime`.`business_id` = (46838) | 1 | 1 | 212 | |
| 84 | 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 `flokiicom_latest`.`business_categories` AS `BusinessCategory` JOIN `flokiicom_latest`.`business_category_items` AS `BusinessCategoryItem` ON (`BusinessCategoryItem`.`business_id` = 46838 AND `BusinessCategoryItem`.`business_category_id` = `BusinessCategory`.`id`) | 1 | 1 | 1 | |
| 85 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `flokiicom_latest`.`i18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (45) ORDER BY `id` ASC | 2 | 2 | 0 | |
| 86 | SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_category_id` FROM `flokiicom_latest`.`business_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 46838 | 1 | 1 | 0 | |
| 87 | SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`chat_count`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`chat_online_status`, `User`.`lock_delete` FROM `flokiicom_latest`.`businesses` AS `Business` LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`Business`.`user_id` = `User`.`id`) WHERE `Business`.`status` = 'approved' AND `Business`.`claim_id` = 0 AND `Business`.`id` != 46838 AND `Business`.`id` IN(SELECT business_id FROM business_category_items WHERE business_category_id IN(45)) ORDER BY `Business`.`total_score` DESC LIMIT 5 | 5 | 5 | 80 | |
| 88 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `flokiicom_latest`.`roles` AS `Role` WHERE `Role`.`id` = 2 | 1 | 1 | 0 | |
| 89 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `flokiicom_latest`.`roles` AS `Role` WHERE `Role`.`id` = 2 | 1 | 1 | 0 | |
| 90 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `flokiicom_latest`.`roles` AS `Role` WHERE `Role`.`id` = 2 | 1 | 1 | 0 | |
| 91 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `flokiicom_latest`.`roles` AS `Role` WHERE `Role`.`id` = 2 | 1 | 1 | 0 | |
| 92 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `flokiicom_latest`.`roles` AS `Role` WHERE `Role`.`id` = 2 | 1 | 1 | 0 | |
| 93 | SELECT `AdsPlacement`.`id`, `AdsPlacement`.`user_id`, `AdsPlacement`.`placement_type`, `AdsPlacement`.`ads_position_id`, `AdsPlacement`.`name`, `AdsPlacement`.`description`, `AdsPlacement`.`dimension_width`, `AdsPlacement`.`dimension_height`, `AdsPlacement`.`price`, `AdsPlacement`.`number_of_ads`, `AdsPlacement`.`total_ads`, `AdsPlacement`.`enable`, `AdsPlacement`.`created`, `AdsPlacement`.`updated`, `AdsPosition`.`id`, `AdsPosition`.`name`, `AdsPosition`.`image`, `AdsPosition`.`ordering` FROM `flokiicom_latest`.`ads_placements` AS `AdsPlacement` LEFT JOIN `flokiicom_latest`.`ads_positions` AS `AdsPosition` ON (`AdsPlacement`.`ads_position_id` = `AdsPosition`.`id`) WHERE `AdsPlacement`.`id` = 15 LIMIT 1 | 1 | 1 | 0 | |
| 94 | SELECT `AdsPlacementFeed`.`id`, `AdsPlacementFeed`.`ads_placement_id`, `AdsPlacementFeed`.`feed_position` FROM `flokiicom_latest`.`ads_placement_feeds` AS `AdsPlacementFeed` WHERE `AdsPlacementFeed`.`ads_placement_id` = (15) | 0 | 0 | 0 | |
| 95 | SELECT `UserCountry`.`id`, `UserCountry`.`user_id`, `UserCountry`.`country_id`, `UserCountry`.`state_id`, `UserCountry`.`address`, `UserCountry`.`zip`, `UserCountry`.`city_id`, `Country`.`id`, `Country`.`name`, `Country`.`country_iso`, `Country`.`state_count`, `Country`.`order`, `Country`.`enable`, `State`.`id`, `State`.`name`, `State`.`state_code`, `State`.`country_id`, `State`.`order`, `State`.`enable`, `State`.`city_count`, `City`.`id`, `City`.`name`, `City`.`city_code`, `City`.`country_id`, `City`.`order`, `City`.`enable`, `City`.`state_id` FROM `flokiicom_latest`.`user_countries` AS `UserCountry` LEFT JOIN `flokiicom_latest`.`countries` AS `Country` ON (`UserCountry`.`country_id` = `Country`.`id`) LEFT JOIN `flokiicom_latest`.`states` AS `State` ON (`UserCountry`.`state_id` = `State`.`id`) LEFT JOIN `flokiicom_latest`.`cities` AS `City` ON (`UserCountry`.`city_id` = `City`.`id`) WHERE `UserCountry`.`user_id` = '' LIMIT 1 | 0 | 0 | 0 | |
| 96 | SELECT `AdsCampaign`.`id`, `AdsCampaign`.`ads_placement_id`, `AdsCampaign`.`client_name`, `AdsCampaign`.`email`, `AdsCampaign`.`note`, `AdsCampaign`.`name`, `AdsCampaign`.`start_date`, `AdsCampaign`.`end_date`, `AdsCampaign`.`payment_status`, `AdsCampaign`.`ads_title`, `AdsCampaign`.`ads_image`, `AdsCampaign`.`link`, `AdsCampaign`.`description`, `AdsCampaign`.`role_id`, `AdsCampaign`.`age_from`, `AdsCampaign`.`age_to`, `AdsCampaign`.`gender`, `AdsCampaign`.`item_status`, `AdsCampaign`.`view_count`, `AdsCampaign`.`click_count`, `AdsCampaign`.`last_date_report`, `AdsCampaign`.`created`, `AdsCampaign`.`updated`, `AdsCampaign`.`is_hide`, `AdsCampaign`.`user_id`, `AdsCampaign`.`country_id`, `AdsCampaign`.`state_id`, `AdsCampaign`.`is_sent_reminder`, `AdsCampaign`.`like_count`, `AdsCampaign`.`comment_count`, `AdsCampaign`.`share_count`, `AdsCampaign`.`dislike_count`, `AdsCampaign`.`privacy`, `AdsPlacement`.`id`, `AdsPlacement`.`user_id`, `AdsPlacement`.`placement_type`, `AdsPlacement`.`ads_position_id`, `AdsPlacement`.`name`, `AdsPlacement`.`description`, `AdsPlacement`.`dimension_width`, `AdsPlacement`.`dimension_height`, `AdsPlacement`.`price`, `AdsPlacement`.`number_of_ads`, `AdsPlacement`.`total_ads`, `AdsPlacement`.`enable`, `AdsPlacement`.`created`, `AdsPlacement`.`updated`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`chat_count`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`chat_online_status`, `User`.`lock_delete` FROM `flokiicom_latest`.`ads_campaigns` AS `AdsCampaign` LEFT JOIN `flokiicom_latest`.`ads_placements` AS `AdsPlacement` ON (`AdsCampaign`.`ads_placement_id` = `AdsPlacement`.`id`) LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`AdsCampaign`.`user_id` = `User`.`id`) WHERE `AdsCampaign`.`ads_placement_id` = 15 AND `AdsCampaign`.`item_status` = 'active' AND `AdsCampaign`.`is_hide` = '0' AND (`AdsCampaign`.`country_id` = 0 AND `AdsCampaign`.`state_id` = 0) ORDER BY `AdsCampaign`.`view_count` ASC | 2 | 2 | 0 | |
| 97 | SELECT `AdsPlacement`.`id`, `AdsPlacement`.`user_id`, `AdsPlacement`.`placement_type`, `AdsPlacement`.`ads_position_id`, `AdsPlacement`.`name`, `AdsPlacement`.`description`, `AdsPlacement`.`dimension_width`, `AdsPlacement`.`dimension_height`, `AdsPlacement`.`price`, `AdsPlacement`.`number_of_ads`, `AdsPlacement`.`total_ads`, `AdsPlacement`.`enable`, `AdsPlacement`.`created`, `AdsPlacement`.`updated`, `AdsPosition`.`id`, `AdsPosition`.`name`, `AdsPosition`.`image`, `AdsPosition`.`ordering` FROM `flokiicom_latest`.`ads_placements` AS `AdsPlacement` LEFT JOIN `flokiicom_latest`.`ads_positions` AS `AdsPosition` ON (`AdsPlacement`.`ads_position_id` = `AdsPosition`.`id`) WHERE `AdsPlacement`.`id` = 15 LIMIT 1 | 1 | 1 | 0 | |
| 98 | SELECT COUNT(*) AS `count` FROM `flokiicom_latest`.`ads_campaigns` AS `AdsCampaign` LEFT JOIN `flokiicom_latest`.`ads_placements` AS `AdsPlacement` ON (`AdsCampaign`.`ads_placement_id` = `AdsPlacement`.`id`) LEFT JOIN `flokiicom_latest`.`users` AS `User` ON (`AdsCampaign`.`user_id` = `User`.`id`) WHERE `AdsCampaign`.`ads_placement_id` = 15 AND `AdsCampaign`.`item_status` = 'active' | 1 | 1 | 0 | |
| 99 | SELECT `CoreMenuItem`.`id`, `CoreMenuItem`.`parent_id`, `CoreMenuItem`.`lft`, `CoreMenuItem`.`rght`, `CoreMenuItem`.`name`, `CoreMenuItem`.`original_name`, `CoreMenuItem`.`url`, `CoreMenuItem`.`title_attribute`, `CoreMenuItem`.`font_class`, `CoreMenuItem`.`is_active`, `CoreMenuItem`.`new_blank`, `CoreMenuItem`.`role_access`, `CoreMenuItem`.`menu_id`, `CoreMenuItem`.`type`, `CoreMenuItem`.`menu_order`, `CoreMenuItem`.`plugin`, `CoreMenuItem`.`group`, `CoreMenuItem`.`font_class_app`, `CoreMenuItem`.`show_web`, `CoreMenuItem`.`show_app`, `CoreMenuItem`.`url_app`, (`I18n__nameMenuTranslation`.`content`) AS `CoreMenuItem__i18n_nameMenuTranslation` FROM `flokiicom_latest`.`core_menu_items` AS `CoreMenuItem` INNER JOIN `flokiicom_latest`.`i18n` AS `I18n__nameMenuTranslation` ON (`CoreMenuItem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `CoreMenuItem`.`url` = '/businessesview46838kane-wm-t-dds-mba-pc' LIMIT 1 | 0 | 0 | 1 | |
| 100 | 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 `flokiicom_latest`.`plugins` AS `Plugin` WHERE `Plugin`.`key` = 'UploadVideo' ORDER BY `Plugin`.`weight` asc LIMIT 1 | 1 | 1 | 0 | |
| 101 | SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `flokiicom_latest`.`themes` AS `Theme` WHERE `Theme`.`key` = 'default' LIMIT 1 | 1 | 1 | 0 | |
| 102 | SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `flokiicom_latest`.`themes` AS `Theme` WHERE `Theme`.`key` = 'default' LIMIT 1 | 1 | 1 | 0 | |
| 103 | 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 `flokiicom_latest`.`settings` AS `Setting` LEFT JOIN `flokiicom_latest`.`setting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1 | 1 | 1 | 0 | |
| 104 | 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 `flokiicom_latest`.`settings` AS `Setting` LEFT JOIN `flokiicom_latest`.`setting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1 | 1 | 1 | 0 | |
| 105 | SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `flokiicom_latest`.`themes` AS `Theme` WHERE `Theme`.`key` = 'default' LIMIT 1 | 1 | 1 | 0 | |
| 106 | SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `flokiicom_latest`.`themes` AS `Theme` WHERE `Theme`.`key` = 'default' LIMIT 1 | 1 | 1 | 0 |
