Mamzar FT 16+
Dubai
Dubai
PAY MONTHLY
Powered by
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 x Application (95.82%) | 2.11s |
1 x Booting (4.18%) | 92.02ms |
# Query soft limit for Debugbar is reached after 100 queries, additional 203 queries only show the query. Limit can be raised in the config. Limits can be raised in the config (debugbar.options.db.soft_limit)
Backtrace |
|
select * from `gym` where (`id` = 'mamzar-16-ft' or `slug` = 'mamzar-16-ft' or `exerp_center_id` = 'mamzar-16-ft') and `gym`.`deleted_at` is null and `live` = 1 limit 1
Bindings |
|
Backtrace |
|
insert into `api_logs` (`member_id`, `api_user_id`, `endpoint`, `request`, `response`, `ip_address`, `code`, `delete_log_at`, `updated_at`, `created_at`) values ('', '', 'https://leejam-test.exerp.com/api/v6/subscriptions/getAvailableSubscriptionsAnonymous', '{\"body\":{\"centerId\":111001,\"personType\":\"PRIVATE\",\"campaignCode\":null,\"onlyAvailableOnWeb\":false,\"includeFreeze\":true}}', '[{\"productId\":{\"center\":111001,\"id\":36002},\"name\":\"12 MONTH | (FT Home & XPress)\",\"creationPrice\":\"0.00\",\"creationSponseredAmount\":\"0.00\",\"periodLength\":1,\"periodUnit\":\"MONTH\",\"periodPrice\":\"150.00\",\"periodSponseredAmount\":\"0.00\",\"bindingPeriodLength\":12,\"product\":{\"globalId\":\"12_MONTH_RECURRING\",\"name\":\"12 MONTH | (FT Home & XPress)\",\"type\":\"EFT\",\"periodUnit\":\"MONTH\",\"periodLength\":1,\"mostPopular\":false},\"proRataPrice\":\"150.00\",\"proRataSponsoredAmount\":\"0.00\",\"creationNormalPrice\":\"0.00\",\"periodNormalPrice\":\"150.00\",\"productGroups\":[{\"productGroupKey\":1604,\"name\":\"All Subscriptions\",\"showInSubscriptionSales\":true,\"showInShop\":false,\"rank\":100,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":7602,\"name\":\"12 MONTHS PACKAGE\",\"showInSubscriptionSales\":false,\"showInShop\":false,\"rank\":0,\"primary\":true,\"externalId\":\"\",\"showOnWeb\":false}]},{\"productId\":{\"center\":111001,\"id\":36401},\"name\":\"200 DAYS | 200 يوم\",\"creationPrice\":\"0.00\",\"creationSponseredAmount\":\"0.00\",\"periodLength\":200,\"periodUnit\":\"DAY\",\"periodPrice\":\"1826.09\",\"periodSponseredAmount\":\"0.00\",\"product\":{\"globalId\":\"200_DAYS\",\"name\":\"200 DAYS | 200 يوم\",\"type\":\"CASH\",\"periodUnit\":\"DAY\",\"periodLength\":200,\"mostPopular\":false},\"creationNormalPrice\":\"0.00\",\"periodNormalPrice\":\"3268.70\",\"periodPriceSource\":\"200 Club Celebration Bundle\",\"periodPriceSourceType\":\"TARGET_GROUP\",\"productGroups\":[{\"productGroupKey\":2801,\"name\":\"FT90\",\"showInSubscriptionSales\":false,\"showInShop\":false,\"rank\":0,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":1604,\"name\":\"All Subscriptions\",\"showInSubscriptionSales\":true,\"showInShop\":false,\"rank\":100,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":601,\"name\":\"Passport\",\"showInSubscriptionSales\":true,\"showInShop\":false,\"rank\":1,\"primary\":true,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":7402,\"name\":\"BUNDLE\",\"showInSubscriptionSales\":true,\"showInShop\":false,\"rank\":0,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":8201,\"name\":\"BUNDLE ONLY\",\"showInSubscriptionSales\":false,\"showInShop\":false,\"rank\":0,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":9201,\"name\":\"ShowOnZoho\",\"showInSubscriptionSales\":false,\"showInShop\":false,\"rank\":0,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false}]},{\"productId\":{\"center\":111001,\"id\":26607},\"name\":\"BUNDLE - 3 MONTHS | باكيج - 3 أشهر\",\"externalId\":\"BUNDLE_FT_3_MONTHS\",\"creationPrice\":\"0.00\",\"creationSponseredAmount\":\"0.00\",\"periodLength\":3,\"periodUnit\":\"MONTH\",\"periodPrice\":\"904.76\",\"periodSponseredAmount\":\"0.00\",\"product\":{\"globalId\":\"BUNDLE_FT_3_MONTHS\",\"name\":\"BUNDLE - 3 MONTHS | باكيج - 3 أشهر\",\"type\":\"CASH\",\"externalId\":\"BUNDLE_FT_3_MONTHS\",\"periodUnit\":\"MONTH\",\"periodLength\":3,\"mostPopular\":false},\"creationNormalPrice\":\"0.00\",\"periodNormalPrice\":\"1810.00\",\"periodPriceSource\":\"Power Bundle uae\",\"availableFreeze\":{\"freezeStartProduct\":{\"productId\":{\"center\":111001,\"id\":215},\"name\":\"FREEZING FEE FOR 3 MONTHS MEMBERSHIP | رسوم ايقاف لعضوية 3 أشهر\",\"price\":\"40.00\",\"type\":\"SERVICE\"},\"freezeMinimumDuration\":1,\"freezeMaximumDuration\":20,\"freezePeriodUnit\":\"months\",\"freezePeriodPrice\":\"0.00\",\"freezePeriodNumberOfUnits\":3,\"freezeMaximumDurationUnit\":\"days\",\"freezeMinimumDurationUnit\":\"days\",\"allowedFreezeWithinPeriod\":2},\"periodPriceSourceType\":\"TARGET_GROUP\",\"productGroups\":[{\"productGroupKey\":2801,\"name\":\"FT90\",\"showInSubscriptionSales\":false,\"showInShop\":false,\"rank\":0,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":1604,\"name\":\"All Subscriptions\",\"showInSubscriptionSales\":true,\"showInShop\":false,\"rank\":100,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":601,\"name\":\"Passport\",\"showInSubscriptionSales\":true,\"showInShop\":false,\"rank\":1,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":7402,\"name\":\"BUNDLE\",\"showInSubscriptionSales\":true,\"showInShop\":false,\"rank\":0,\"primary\":true,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":7601,\"name\":\"3 MONTHS PACKAGE\",\"showInSubscriptionSales\":false,\"showInShop\":false,\"rank\":0,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":8201,\"name\":\"BUNDLE ONLY\",\"showInSubscriptionSales\":false,\"showInShop\":false,\"rank\":0,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false}]},{\"productId\":{\"center\":111001,\"id\":406},\"name\":\"FT - 1 DAY PASS | فتنس - دخول 1 يوم\",\"creationPrice\":\"0.00\",\"creationSponseredAmount\":\"0.00\",\"periodLength\":1,\"periodUnit\":\"DAY\",\"periodPrice\":\"142.86\",\"periodSponseredAmount\":\"0.00\",\"product\":{\"globalId\":\"1_DAY\",\"name\":\"FT - 1 DAY PASS | فتنس - دخول 1 يوم\",\"type\":\"CASH\",\"periodUnit\":\"DAY\",\"periodLength\":1,\"webname\":\"1 DAY PASS\",\"description\":\"One day allowing usage of all facilities available in the club. Can be used once only (not valid to be used twice \\day or to go to anyother club after usage).\",\"rank\":1,\"mostPopular\":false,\"sellingPoints\":[\"Certified Instructor\",\"Advanced equipment\",\"Fitness consultation\",\"Usage of all available facilities\",\"Only available in Xpress & UAE clubs\"]},\"creationNormalPrice\":\"0.00\",\"periodNormalPrice\":\"142.86\",\"productGroups\":[{\"productGroupKey\":801,\"name\":\"Home Rate\",\"showInSubscriptionSales\":true,\"showInShop\":false,\"rank\":0,\"primary\":true,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":1604,\"name\":\"All Subscriptions\",\"showInSubscriptionSales\":true,\"showInShop\":false,\"rank\":100,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false}]},{\"productId\":{\"center\":111001,\"id\":1},\"name\":\"FT - 1 MONTH | فتنس - 1 شهر\",\"creationPrice\":\"0.00\",\"creationSponseredAmount\":\"0.00\",\"periodLength\":1,\"periodUnit\":\"MONTH\",\"periodPrice\":\"760.95\",\"periodSponseredAmount\":\"0.00\",\"product\":{\"globalId\":\"1_MONTH\",\"name\":\"FT - 1 MONTH | فتنس - 1 شهر\",\"type\":\"CASH\",\"periodUnit\":\"MONTH\",\"periodLength\":1,\"webname\":\"1 MONTH\",\"description\":\"Standard one month subscription\",\"rank\":3,\"mostPopular\":false,\"sellingPoints\":[\"Certified Instructor\",\"Advanced equipment\",\"Fitness consultation\",\"Usage of all available facilities\",\"Not available in Plus brand\"]},\"creationNormalPrice\":\"0.00\",\"periodNormalPrice\":\"760.95\",\"productGroups\":[{\"productGroupKey\":1604,\"name\":\"All Subscriptions\",\"showInSubscriptionSales\":true,\"showInShop\":false,\"rank\":100,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":601,\"name\":\"Passport\",\"showInSubscriptionSales\":true,\"showInShop\":false,\"rank\":1,\"primary\":true,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":9201,\"name\":\"ShowOnZoho\",\"showInSubscriptionSales\":false,\"showInShop\":false,\"rank\":0,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false}]},{\"productId\":{\"center\":111001,\"id\":3},\"name\":\"FT - 12 MONTHS | فتنس - 12 شهر\",\"creationPrice\":\"0.00\",\"creationSponseredAmount\":\"0.00\",\"periodLength\":12,\"periodUnit\":\"MONTH\",\"periodPrice\":\"4990.00\",\"periodSponseredAmount\":\"0.00\",\"product\":{\"globalId\":\"12_MONTHS\",\"name\":\"FT - 12 MONTHS | فتنس - 12 شهر\",\"type\":\"CASH\",\"periodUnit\":\"MONTH\",\"periodLength\":12,\"mostPopular\":false},\"creationNormalPrice\":\"0.00\",\"periodNormalPrice\":\"4990.00\",\"availableFreeze\":{\"freezeStartProduct\":{\"productId\":{\"center\":111001,\"id\":217},\"name\":\"FREEZING FEE FOR 12 MONTHS MEMBERSHIP | رسوم ايقاف لعضوية 12 شهر\",\"price\":\"60.00\",\"type\":\"SERVICE\"},\"freezeMinimumDuration\":1,\"freezeMaximumDuration\":60,\"freezePeriodUnit\":\"months\",\"freezePeriodPrice\":\"0.00\",\"freezePeriodNumberOfUnits\":12,\"freezeMaximumDurationUnit\":\"days\",\"freezeMinimumDurationUnit\":\"days\",\"allowedFreezeWithinPeriod\":4},\"productGroups\":[{\"productGroupKey\":2801,\"name\":\"FT90\",\"showInSubscriptionSales\":false,\"showInShop\":false,\"rank\":0,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":1604,\"name\":\"All Subscriptions\",\"showInSubscriptionSales\":true,\"showInShop\":false,\"rank\":100,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":601,\"name\":\"Passport\",\"showInSubscriptionSales\":true,\"showInShop\":false,\"rank\":1,\"primary\":true,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":7602,\"name\":\"12 MONTHS PACKAGE\",\"showInSubscriptionSales\":false,\"showInShop\":false,\"rank\":0,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":9201,\"name\":\"ShowOnZoho\",\"showInSubscriptionSales\":false,\"showInShop\":false,\"rank\":0,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false}]},{\"productId\":{\"center\":111001,\"id\":201},\"name\":\"FT - 3 MONTHS | فتنس - 3 أشهر\",\"creationPrice\":\"0.00\",\"creationSponseredAmount\":\"0.00\",\"periodLength\":3,\"periodUnit\":\"MONTH\",\"periodPrice\":\"1810.00\",\"periodSponseredAmount\":\"0.00\",\"product\":{\"globalId\":\"3_MONTHS\",\"name\":\"FT - 3 MONTHS | فتنس - 3 أشهر\",\"type\":\"CASH\",\"periodUnit\":\"MONTH\",\"periodLength\":3,\"mostPopular\":false},\"creationNormalPrice\":\"0.00\",\"periodNormalPrice\":\"1810.00\",\"availableFreeze\":{\"freezeStartProduct\":{\"productId\":{\"center\":111001,\"id\":215},\"name\":\"FREEZING FEE FOR 3 MONTHS MEMBERSHIP | رسوم ايقاف لعضوية 3 أشهر\",\"price\":\"40.00\",\"type\":\"SERVICE\"},\"freezeMinimumDuration\":1,\"freezeMaximumDuration\":20,\"freezePeriodUnit\":\"months\",\"freezePeriodPrice\":\"0.00\",\"freezePeriodNumberOfUnits\":3,\"freezeMaximumDurationUnit\":\"days\",\"freezeMinimumDurationUnit\":\"days\",\"allowedFreezeWithinPeriod\":2},\"productGroups\":[{\"productGroupKey\":2801,\"name\":\"FT90\",\"showInSubscriptionSales\":false,\"showInShop\":false,\"rank\":0,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":1604,\"name\":\"All Subscriptions\",\"showInSubscriptionSales\":true,\"showInShop\":false,\"rank\":100,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":601,\"name\":\"Passport\",\"showInSubscriptionSales\":true,\"showInShop\":false,\"rank\":1,\"primary\":true,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":7402,\"name\":\"BUNDLE\",\"showInSubscriptionSales\":true,\"showInShop\":false,\"rank\":0,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":7601,\"name\":\"3 MONTHS PACKAGE\",\"showInSubscriptionSales\":false,\"showInShop\":false,\"rank\":0,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":9201,\"name\":\"ShowOnZoho\",\"showInSubscriptionSales\":false,\"showInShop\":false,\"rank\":0,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false}]},{\"productId\":{\"center\":111001,\"id\":203},\"name\":\"FT - 6 MONTHS | فتنس - 6 أشهر\",\"creationPrice\":\"0.00\",\"creationSponseredAmount\":\"0.00\",\"periodLength\":6,\"periodUnit\":\"MONTH\",\"periodPrice\":\"2970.00\",\"periodSponseredAmount\":\"0.00\",\"product\":{\"globalId\":\"6_MONTHS\",\"name\":\"FT - 6 MONTHS | فتنس - 6 أشهر\",\"type\":\"CASH\",\"periodUnit\":\"MONTH\",\"periodLength\":6,\"mostPopular\":false},\"creationNormalPrice\":\"0.00\",\"periodNormalPrice\":\"2970.00\",\"availableFreeze\":{\"freezeStartProduct\":{\"productId\":{\"center\":111001,\"id\":216},\"name\":\"FREEZING FEE FOR 6 MONTHS MEMBERSHIP | رسوم ايقاف لعضوية 6 أشهر\",\"price\":\"50.00\",\"type\":\"SERVICE\"},\"freezeMinimumDuration\":1,\"freezeMaximumDuration\":40,\"freezePeriodUnit\":\"months\",\"freezePeriodPrice\":\"0.00\",\"freezePeriodNumberOfUnits\":6,\"freezeMaximumDurationUnit\":\"days\",\"freezeMinimumDurationUnit\":\"days\",\"allowedFreezeWithinPeriod\":3},\"productGroups\":[{\"productGroupKey\":2801,\"name\":\"FT90\",\"showInSubscriptionSales\":false,\"showInShop\":false,\"rank\":0,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":1604,\"name\":\"All Subscriptions\",\"showInSubscriptionSales\":true,\"showInShop\":false,\"rank\":100,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":601,\"name\":\"Passport\",\"showInSubscriptionSales\":true,\"showInShop\":false,\"rank\":1,\"primary\":true,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":7403,\"name\":\"6 MONTHS PACKAGE\",\"showInSubscriptionSales\":false,\"showInShop\":false,\"rank\":0,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":9201,\"name\":\"ShowOnZoho\",\"showInSubscriptionSales\":false,\"showInShop\":false,\"rank\":0,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false}]},{\"productId\":{\"center\":111001,\"id\":207},\"name\":\"FT - HOME RATE - 3 MONTHS | فتنس - مركز محدد - 3 أشهر\",\"creationPrice\":\"0.00\",\"creationSponseredAmount\":\"0.00\",\"periodLength\":3,\"periodUnit\":\"MONTH\",\"periodPrice\":\"1810.00\",\"periodSponseredAmount\":\"0.00\",\"product\":{\"globalId\":\"HOMERATE__3_MONTHS\",\"name\":\"FT - HOME RATE - 3 MONTHS | فتنس - مركز محدد - 3 أشهر\",\"type\":\"CASH\",\"periodUnit\":\"MONTH\",\"periodLength\":3,\"webname\":\"HOME RATE - 3 MONTHS\",\"description\":\"90 days with access only to one club with lower price compared to the standard 90 days subsription\",\"rank\":8,\"mostPopular\":false,\"sellingPoints\":[\"Certified Instructor\",\"Advanced equipment\",\"Fitness consultation\",\"Usage of all available facilities\",\"Not available in Plus brand\"]},\"creationNormalPrice\":\"0.00\",\"periodNormalPrice\":\"1810.00\",\"availableFreeze\":{\"freezeStartProduct\":{\"productId\":{\"center\":111001,\"id\":215},\"name\":\"FREEZING FEE FOR 3 MONTHS MEMBERSHIP | رسوم ايقاف لعضوية 3 أشهر\",\"price\":\"40.00\",\"type\":\"SERVICE\"},\"freezeMinimumDuration\":1,\"freezeMaximumDuration\":20,\"freezePeriodUnit\":\"months\",\"freezePeriodPrice\":\"0.00\",\"freezePeriodNumberOfUnits\":3,\"freezeMaximumDurationUnit\":\"days\",\"freezeMinimumDurationUnit\":\"days\",\"allowedFreezeWithinPeriod\":2},\"productGroups\":[{\"productGroupKey\":2801,\"name\":\"FT90\",\"showInSubscriptionSales\":false,\"showInShop\":false,\"rank\":0,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":801,\"name\":\"Home Rate\",\"showInSubscriptionSales\":true,\"showInShop\":false,\"rank\":0,\"primary\":true,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":1604,\"name\":\"All Subscriptions\",\"showInSubscriptionSales\":true,\"showInShop\":false,\"rank\":100,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false}]},{\"productId\":{\"center\":111001,\"id\":5},\"name\":\"FT - HOME RATE - 6 MONTHS | فتنس - مركز محدد - 6 أشهر\",\"creationPrice\":\"0.00\",\"creationSponseredAmount\":\"0.00\",\"periodLength\":6,\"periodUnit\":\"MONTH\",\"periodPrice\":\"2970.00\",\"periodSponseredAmount\":\"0.00\",\"product\":{\"globalId\":\"HOMERATE__6_MONTHS\",\"name\":\"FT - HOME RATE - 6 MONTHS | فتنس - مركز محدد - 6 أشهر\",\"type\":\"CASH\",\"periodUnit\":\"MONTH\",\"periodLength\":6,\"webname\":\"HOME RATE - 6 MONTHS\",\"description\":\"180 days with access only to one club with lower price compared to the standard 180 days subsription\",\"rank\":9,\"mostPopular\":false,\"sellingPoints\":[\"Certified Instructor\",\"Advanced equipment\",\"Fitness consultation\",\"Usage of all available facilities\"]},\"creationNormalPrice\":\"0.00\",\"periodNormalPrice\":\"2970.00\",\"availableFreeze\":{\"freezeStartProduct\":{\"productId\":{\"center\":111001,\"id\":216},\"name\":\"FREEZING FEE FOR 6 MONTHS MEMBERSHIP | رسوم ايقاف لعضوية 6 أشهر\",\"price\":\"50.00\",\"type\":\"SERVICE\"},\"freezeMinimumDuration\":1,\"freezeMaximumDuration\":40,\"freezePeriodUnit\":\"months\",\"freezePeriodPrice\":\"0.00\",\"freezePeriodNumberOfUnits\":6,\"freezeMaximumDurationUnit\":\"days\",\"freezeMinimumDurationUnit\":\"days\",\"allowedFreezeWithinPeriod\":3},\"productGroups\":[{\"productGroupKey\":2801,\"name\":\"FT90\",\"showInSubscriptionSales\":false,\"showInShop\":false,\"rank\":0,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":801,\"name\":\"Home Rate\",\"showInSubscriptionSales\":true,\"showInShop\":false,\"rank\":0,\"primary\":true,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":1604,\"name\":\"All Subscriptions\",\"showInSubscriptionSales\":true,\"showInShop\":false,\"rank\":100,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false}]},{\"productId\":{\"center\":111001,\"id\":31205},\"name\":\"12 MONTHS ONLINE | 12 شهر\",\"creationPrice\":\"0.00\",\"creationSponseredAmount\":\"0.00\",\"periodLength\":12,\"periodUnit\":\"MONTH\",\"periodPrice\":\"4990.00\",\"periodSponseredAmount\":\"0.00\",\"product\":{\"globalId\":\"12_MONTHS_ONLINE\",\"name\":\"12 MONTHS ONLINE | 12 شهر\",\"type\":\"CASH\",\"periodUnit\":\"MONTH\",\"periodLength\":12,\"webname\":\"12 MONTHS\",\"description\":\"Standard 365 days subscription\",\"rank\":5,\"mostPopular\":false,\"sellingPoints\":[\"Certified Instructor\",\"Advanced equipment\",\"Fitness consultation\",\"Usage of all available facilities\"]},\"creationNormalPrice\":\"0.00\",\"periodNormalPrice\":\"4990.00\",\"availableFreeze\":{\"freezeStartProduct\":{\"productId\":{\"center\":111001,\"id\":217},\"name\":\"FREEZING FEE FOR 12 MONTHS MEMBERSHIP | رسوم ايقاف لعضوية 12 شهر\",\"price\":\"60.00\",\"type\":\"SERVICE\"},\"freezeMinimumDuration\":1,\"freezeMaximumDuration\":60,\"freezePeriodUnit\":\"months\",\"freezePeriodPrice\":\"0.00\",\"freezePeriodNumberOfUnits\":12,\"freezeMaximumDurationUnit\":\"days\",\"freezeMinimumDurationUnit\":\"days\",\"allowedFreezeWithinPeriod\":4},\"productGroups\":[{\"productGroupKey\":2801,\"name\":\"FT90\",\"showInSubscriptionSales\":false,\"showInShop\":false,\"rank\":0,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":1604,\"name\":\"All Subscriptions\",\"showInSubscriptionSales\":true,\"showInShop\":false,\"rank\":100,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":601,\"name\":\"Passport\",\"showInSubscriptionSales\":true,\"showInShop\":false,\"rank\":1,\"primary\":true,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":7602,\"name\":\"12 MONTHS PACKAGE\",\"showInSubscriptionSales\":false,\"showInShop\":false,\"rank\":0,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":4005,\"name\":\"Ramadan free freeze\",\"showInSubscriptionSales\":false,\"showInShop\":false,\"rank\":0,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false}]},{\"productId\":{\"center\":111001,\"id\":31001},\"name\":\"3 MONTHS ONLINE | 3 أشهر\",\"creationPrice\":\"0.00\",\"creationSponseredAmount\":\"0.00\",\"periodLength\":3,\"periodUnit\":\"MONTH\",\"periodPrice\":\"1810.00\",\"periodSponseredAmount\":\"0.00\",\"product\":{\"globalId\":\"3_MONTHS_ONLINE\",\"name\":\"3 MONTHS ONLINE | 3 أشهر\",\"type\":\"CASH\",\"periodUnit\":\"MONTH\",\"periodLength\":3,\"webname\":\"3 MONTHS\",\"description\":\"Standard 90 days subscription\",\"rank\":1,\"mostPopular\":false,\"sellingPoints\":[\"Certified Instructor\",\"Advanced equipment\",\"Fitness consultation\",\"Usage of all available facilities\",\"Not available in Plus brand\"]},\"creationNormalPrice\":\"0.00\",\"periodNormalPrice\":\"1810.00\",\"campaignPrice\":\"1629.00\",\"campaignSource\":\"Default Offer for all\",\"campaignText\":\"Default Offer for all\",\"campaignStartDate\":\"2025-04-28\",\"campaignEndDate\":\"2027-04-27\",\"availableFreeze\":{\"freezeStartProduct\":{\"productId\":{\"center\":111001,\"id\":215},\"name\":\"FREEZING FEE FOR 3 MONTHS MEMBERSHIP | رسوم ايقاف لعضوية 3 أشهر\",\"price\":\"40.00\",\"type\":\"SERVICE\"},\"freezeMinimumDuration\":1,\"freezeMaximumDuration\":20,\"freezePeriodUnit\":\"months\",\"freezePeriodPrice\":\"0.00\",\"freezePeriodNumberOfUnits\":3,\"freezeMaximumDurationUnit\":\"days\",\"freezeMinimumDurationUnit\":\"days\",\"allowedFreezeWithinPeriod\":2},\"productGroups\":[{\"productGroupKey\":2801,\"name\":\"FT90\",\"showInSubscriptionSales\":false,\"showInShop\":false,\"rank\":0,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":1604,\"name\":\"All Subscriptions\",\"showInSubscriptionSales\":true,\"showInShop\":false,\"rank\":100,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":601,\"name\":\"Passport\",\"showInSubscriptionSales\":true,\"showInShop\":false,\"rank\":1,\"primary\":true,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":7601,\"name\":\"3 MONTHS PACKAGE\",\"showInSubscriptionSales\":false,\"showInShop\":false,\"rank\":0,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false},{\"productGroupKey\":4005,\"name\":\"Ramadan free freeze\",\"showInSubscriptionSales\":false,\"showInShop\":false,\"rank\":0,\"primary\":false,\"externalId\":\"\",\"showOnWeb\":false}]},{\"productId\":{\"center\":111001,\"id\":31201},\"name\":\"4 MONTHS ONLINE | 4 أشهر\",\"creationPrice\":\"0.00\",\"creationSponseredAmount\":\"0.00\",\"periodLength\":4,\"periodUnit\":\"MONTH\",\"periodPrice\":\"2293.00\",\"periodSponseredAmount\":\"0.00\",\"product\":{\"globalId\":\"4_MONTHS_ONLINE\",\"name\":\"4 MONTHS ONLINE | 4 أشهر\",\"type\":\"CASH\",\"periodUnit\":\"MONTH\",\"periodLength\":4,\"webname\":\"4 MONTHS\",\"description\":\"Standard 120 days subscription\",\"rank\":2,\"mostPopular\":false,\"sellingPoints\":[\"Certified Instructor\",\"Advanced equipment\",\"Fitness consultation\",\"Usage of all available facilities\",\"Not available in Plus brand\"]},\"creationNormalPrice\":\"0.00\",\"periodNormalPrice\":\"2293.00\",\"available... Was truncated to 20000 characters', '169.254.131.1', 200, '2025-04-30 07:53:30', '2025-04-28 07:53:30', '2025-04-28 07:53:30')
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '1_DAY' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '1_DAY' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '12_MONTH_RECURRING' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '12_MONTH_RECURRING' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '1_MONTH' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '1_MONTH' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = 'BUNDLE_FT_3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = 'BUNDLE_FT_3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '3_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '200_DAYS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '200_DAYS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE_4_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE_4_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '4_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '4_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '6_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '6_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__6_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__6_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '6_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '6_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '9_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '9_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '12_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '12_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '12_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '12_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `city` where `city`.`id` = 11 limit 1
Bindings |
|
Backtrace |
|
select * from `country` where `country`.`id` = 2 and `country`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `bundles` where FIND_IN_SET(183, gyms) and `start_date_time` <= '2025-04-28 11:53:30' and `end_date_time` >= '2025-04-28 11:53:30' and `live` = 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '1_DAY' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '12_MONTH_RECURRING' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '1_MONTH' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = 'BUNDLE_FT_3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '200_DAYS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE_4_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '4_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '6_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__6_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '6_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '9_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '12_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '12_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `gym_brand` where `gym_brand`.`id` = 2 limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '1_DAY' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `gym` where `exerp_center_id` = 111001 and `gym`.`deleted_at` is null and `live` = 1 limit 1
Bindings |
|
Backtrace |
|
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:30') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:30') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '1_DAY' and `bank_promos`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `gym_brand` where `gym_brand`.`id` = 2 limit 1
Bindings |
|
Backtrace |
|
select * from `city` where `city`.`id` = 11 limit 1
Bindings |
|
Backtrace |
|
select * from `country` where `country`.`id` = 2 and `country`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '1_DAY' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:30') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:30') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '1_DAY' and `bank_promos`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '1_DAY' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '1_DAY' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '1_DAY' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '1_MONTH' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `gym` where `exerp_center_id` = 111001 and `gym`.`deleted_at` is null and `live` = 1 limit 1
Bindings |
|
Backtrace |
|
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:30') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:30') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '1_MONTH' and `bank_promos`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `gym_brand` where `gym_brand`.`id` = 2 limit 1
Bindings |
|
Backtrace |
|
select * from `city` where `city`.`id` = 11 limit 1
Bindings |
|
Backtrace |
|
select * from `country` where `country`.`id` = 2 and `country`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '1_MONTH' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:30') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:30') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '1_MONTH' and `bank_promos`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '1_MONTH' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '1_MONTH' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = '1_MONTH' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = 'BUNDLE_FT_3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = 'BUNDLE_FT_3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `clipcard_groups` where `group_id` = 1003 limit 1
Bindings |
|
Backtrace |
|
select * from `portal_clipcards` where `product_id` = 36801 and `group_id` = 6 limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = 'BUNDLE_FT_3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = 'BUNDLE_FT_3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `clipcard_groups` where `group_id` = 1003 limit 1
Bindings |
|
Backtrace |
|
select * from `portal_clipcards` where `product_id` = 36801 and `group_id` = 6 limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `gym` where `exerp_center_id` = 111001 and `gym`.`deleted_at` is null and `live` = 1 limit 1
Bindings |
|
Backtrace |
|
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:30') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:30') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = 'HOMERATE__3_MONTHS' and `bank_promos`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `gym_brand` where `gym_brand`.`id` = 2 limit 1
Bindings |
|
Backtrace |
|
select * from `city` where `city`.`id` = 11 limit 1
Bindings |
|
Backtrace |
|
select * from `country` where `country`.`id` = 2 and `country`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:30') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:30') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = 'HOMERATE__3_MONTHS' and `bank_promos`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `gym` where `exerp_center_id` = 111001 and `gym`.`deleted_at` is null and `live` = 1 limit 1
Bindings |
|
Backtrace |
|
select * from `city` where `city`.`id` = 11 limit 1
Bindings |
|
Backtrace |
|
select * from `country` where `country`.`id` = 2 and `country`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:30') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:30') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '3_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `gym_brand` where `gym_brand`.`id` = 2 limit 1
Bindings |
|
Backtrace |
|
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:30') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:30') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '3_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
Bindings |
|
Backtrace |
|
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE_4_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
Bindings |
|
Backtrace |
|
select * from `gym` where `exerp_center_id` = 111001 and `gym`.`deleted_at` is null and `live` = 1 limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:30') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:30') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = 'HOMERATE_4_MONTHS' and `bank_promos`.`deleted_at` is null limit 1
select * from `gym_brand` where `gym_brand`.`id` = 2 limit 1
select * from `city` where `city`.`id` = 11 limit 1
select * from `country` where `country`.`id` = 2 and `country`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE_4_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:30') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:30') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = 'HOMERATE_4_MONTHS' and `bank_promos`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE_4_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE_4_MONTHS' and ((`live_from` <= '2025-04-28 10:53:30' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:30' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE_4_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '4_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `gym` where `exerp_center_id` = 111001 and `gym`.`deleted_at` is null and `live` = 1 limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '4_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `gym_brand` where `gym_brand`.`id` = 2 limit 1
select * from `city` where `city`.`id` = 11 limit 1
select * from `country` where `country`.`id` = 2 and `country`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = '4_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '4_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = '4_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '4_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '4_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__6_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `gym` where `exerp_center_id` = 111001 and `gym`.`deleted_at` is null and `live` = 1 limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = 'HOMERATE__6_MONTHS' and `bank_promos`.`deleted_at` is null limit 1
select * from `gym_brand` where `gym_brand`.`id` = 2 limit 1
select * from `city` where `city`.`id` = 11 limit 1
select * from `country` where `country`.`id` = 2 and `country`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__6_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = 'HOMERATE__6_MONTHS' and `bank_promos`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__6_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__6_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__6_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '6_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `gym` where `exerp_center_id` = 111001 and `gym`.`deleted_at` is null and `live` = 1 limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '6_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `gym_brand` where `gym_brand`.`id` = 2 limit 1
select * from `city` where `city`.`id` = 11 limit 1
select * from `country` where `country`.`id` = 2 and `country`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = '6_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '6_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = '6_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '6_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '6_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '9_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `gym` where `exerp_center_id` = 111001 and `gym`.`deleted_at` is null and `live` = 1 limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '9_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `gym_brand` where `gym_brand`.`id` = 2 limit 1
select * from `city` where `city`.`id` = 11 limit 1
select * from `country` where `country`.`id` = 2 and `country`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = '9_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '9_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = '9_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '9_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '9_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '12_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `gym` where `exerp_center_id` = 111001 and `gym`.`deleted_at` is null and `live` = 1 limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '12_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `gym_brand` where `gym_brand`.`id` = 2 limit 1
select * from `city` where `city`.`id` = 11 limit 1
select * from `country` where `country`.`id` = 2 and `country`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = '12_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '12_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = '12_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '12_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '12_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '1_DAY' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '1_DAY' and `bank_promos`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = '1_DAY' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '1_DAY' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '1_DAY' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '1_DAY' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '1_DAY' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '1_DAY' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '1_DAY' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '1_DAY' and `bank_promos`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = '1_DAY' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '1_DAY' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '1_DAY' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '1_MONTH' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '1_MONTH' and `bank_promos`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = '1_MONTH' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '1_MONTH' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '1_MONTH' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '1_MONTH' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '1_MONTH' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '1_MONTH' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '1_MONTH' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '1_MONTH' and `bank_promos`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = '1_MONTH' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '1_MONTH' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '1_MONTH' and `bank_promos`.`deleted_at` is null limit 1
select * from `clipcard_groups` where `group_id` = 1003 limit 1
select * from `portal_clipcards` where `product_id` = 36801 and `group_id` = 6 limit 1
select * from `subscription_extras` where `subscription_global_id` = 'BUNDLE_FT_3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = 'BUNDLE_FT_3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `clipcard_groups` where `group_id` = 1003 limit 1
select * from `portal_clipcards` where `product_id` = 36801 and `group_id` = 6 limit 1
select * from `subscription_extras` where `subscription_global_id` = 'BUNDLE_FT_3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = 'BUNDLE_FT_3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = 'HOMERATE__3_MONTHS' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = 'HOMERATE__3_MONTHS' and `bank_promos`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = 'HOMERATE__3_MONTHS' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = 'HOMERATE__3_MONTHS' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = 'HOMERATE__3_MONTHS' and `bank_promos`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__3_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = 'HOMERATE__3_MONTHS' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '3_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '3_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '3_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '3_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '3_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '3_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = 'HOMERATE_4_MONTHS' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = 'HOMERATE_4_MONTHS' and `bank_promos`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE_4_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE_4_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE_4_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE_4_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE_4_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = 'HOMERATE_4_MONTHS' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = 'HOMERATE_4_MONTHS' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = 'HOMERATE_4_MONTHS' and `bank_promos`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE_4_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE_4_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = 'HOMERATE_4_MONTHS' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '4_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '4_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = '4_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '4_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '4_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '4_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '4_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '4_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '4_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '4_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = '4_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '4_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '4_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = 'HOMERATE__6_MONTHS' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = 'HOMERATE__6_MONTHS' and `bank_promos`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__6_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__6_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__6_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__6_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__6_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = 'HOMERATE__6_MONTHS' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = 'HOMERATE__6_MONTHS' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = 'HOMERATE__6_MONTHS' and `bank_promos`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__6_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = 'HOMERATE__6_MONTHS' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = 'HOMERATE__6_MONTHS' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '6_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '6_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = '6_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '6_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '6_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '6_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '6_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '6_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '6_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '6_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = '6_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '6_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '6_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '9_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '9_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = '9_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '9_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '9_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '9_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '9_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '9_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '9_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '9_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = '9_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '9_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '9_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '12_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '12_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = '12_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '12_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '12_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '12_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '12_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '12_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '12_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '12_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `subscription_extras` where `subscription_global_id` = '12_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `subscription_extras` where `subscription_global_id` = '12_MONTHS_ONLINE' and ((`live_from` <= '2025-04-28 10:53:31' or `live_from` is null) and (`live_to` >= '2025-04-28 10:53:31' or `live_to` is null)) limit 1
select * from `bank_promos` where `live` = 1 and (`starts_at` is null or `starts_at` <= '2025-04-28 10:53:31') and (`ends_at` is null or `ends_at` >= '2025-04-28 10:53:31') and exists (select * from `gym` inner join `bank_promo_gyms` on `gym`.`id` = `bank_promo_gyms`.`gym_id` where `bank_promos`.`id` = `bank_promo_gyms`.`bank_promo_id` and `gym`.`id` = 183 and `gym`.`deleted_at` is null and `live` = 1) and `global_id` = '12_MONTHS_ONLINE' and `bank_promos`.`deleted_at` is null limit 1
select * from `gym` where exists (select * from `gym_brand` where `gym`.`gym_brand_id` = `gym_brand`.`id`) and exists (select * from `city` where `gym`.`city_id` = `city`.`id`) and `city_id` is not null and `gym`.`deleted_at` is null and `live` = 1
select * from `gym_brand` where `gym_brand`.`id` in (1, 2, 3, 4, 5, 6, 7, 9)
select * from `city` where `city`.`id` in (1, 2, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 20, 21, 22, 23, 24, 25, 26, 27, 28, 30, 31, 32)
select * from `country` where `country`.`id` in (1, 2) and `country`.`deleted_at` is null
select * from `country` where `country`.`deleted_at` is null
select * from `city`
select * from `gym_brand`
200
[]
[]
0 of 0array:34 [▼ "x-client-port" => array:1 [▶ 0 => "44492" ] "x-client-ip" => array:1 [▶ 0 => "172.70.126.9" ] "x-waws-unencoded-url" => array:1 [▶ 0 => "/en-us/mamzar-16-ft" ] "x-original-url" => array:1 [▶ 0 => "/en-us/mamzar-16-ft" ] "x-forwarded-tlsversion" => array:1 [▶ 0 => "1.3" ] "x-arr-ssl" => array:1 [▶ 0 => "2048|256|CN=Microsoft Azure RSA TLS Issuing CA 03, O=Microsoft Corporation, C=US|CN=*.fitnesstime-staging.p.azurewebsites.net, O=Microsoft Corporation, L=Redmond, S=WA, C=US ◀2048|256|CN=Microsoft Azure RSA TLS Issuing CA 03, O=Microsoft Corporation, C=US|CN=*.fitnesstime-staging.p.azurewebsites.net, O=Microsoft Corporation, L=Redmon ▶" ] "x-appservice-proto" => array:1 [▶ 0 => "https" ] "was-default-hostname" => array:1 [▶ 0 => "ft-join-staging.fitnesstime-staging.p.azurewebsites.net" ] "x-site-deployment-id" => array:1 [▶ 0 => "ft-join-staging" ] "disguised-host" => array:1 [▶ 0 => "join.leejft.com" ] "client-ip" => array:1 [▶ 0 => "172.70.126.9:44492" ] "x-arr-log-id" => array:1 [▶ 0 => "c5459b38-65a2-479c-af06-3c3fb964130b" ] "cf-visitor" => array:1 [▶ 0 => "{"scheme":"https"}" ] "cf-ipcountry" => array:1 [▶ 0 => "US" ] "cf-connecting-ip" => array:1 [▶ 0 => "3.136.106.107" ] "cdn-loop" => array:1 [▶ 0 => "cloudflare; loops=1" ] "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "cf-ray" => array:1 [▶ 0 => "9374fc716eec0007-ORD" ] "priority" => array:1 [▶ 0 => "u=0, i" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "x-forwarded-for" => array:1 [▶ 0 => "3.136.106.107, 172.70.126.9:44492" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "max-forwards" => array:1 [▶ 0 => "10" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "accept-encoding" => array:1 [▶ 0 => "gzip, br" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "host" => array:1 [▶ 0 => "join.leejft.com" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] ]
[]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Mon, 28 Apr 2025 07:53:30 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImtuS0hDRW80VzBGVitUQkJlT1FEb0E9PSIsInZhbHVlIjoiRWluQjhSTy9lcCtySzN4UnV5NjZQRTBPSnhIMDkxLzZSRzd3WU0rdUhJOTZFTW0wMXI5Sll4OHpvZjJlL21BWm4xUlJzSXVmV0RkMXZEUFVtVFFZR0NFNXp4KzZ1SmFOL04xeThxZWdmQVF0WDdRWEdTbmhYdzNFcktJejh5NGUiLCJtYWMiOiI2ZTFhMWQzYTBhMWQ5YzhjZjZiZWM3ZmZkN2UxNTljZGFhYmFkMTcwZjZjYTNjZjE2NWVjMTA3MDFlNThlNDFlIiwidGFnIjoiIn0%3D; expires=Mon, 28 Apr 2025 13:53:31 GMT; Max-Age=21600; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImtuS0hDRW80VzBGVitUQkJlT1FEb0E9PSIsInZhbHVlIjoiRWluQjhSTy9lcCtySzN4UnV5NjZQRTBPSnhIMDkxLzZSRzd3WU0rdUhJOTZFTW0wMXI5Sll4OHpvZjJlL21BWm4xUlJzS ▶" 1 => "fitness_time_join_online_session=eyJpdiI6IlFMUlZLSlEvdHZ1TU9YY3psdE5KSUE9PSIsInZhbHVlIjoid01rQ2hsRC92THdpN0pOWlRkd1ZDODBZYWZSL3V6YWI3UzQya3JxTGhVTjd1OUFkNXhYcEhuS05oRUZ2WUx4V2FjN0c0Nnc2aVFlNnFDUHhIZXZwWTk2aVNLWnpCamlMN1E0VEJORi90aldyaFQ0aTNIWWlrNGV1ZDg1ZnBrbWgiLCJtYWMiOiI4YTY5NTJjNzk5YTMxYjRiNWRlZjA5M2I1ODM3NWUwZGQwYjQ2ZjIwMWU0MjRhZDIwYjkzM2U3NDQ4MGRjNDgxIiwidGFnIjoiIn0%3D; expires=Mon, 28 Apr 2025 13:53:31 GMT; Max-Age=21600; path=/; secure; httponly; samesite=lax ◀fitness_time_join_online_session=eyJpdiI6IlFMUlZLSlEvdHZ1TU9YY3psdE5KSUE9PSIsInZhbHVlIjoid01rQ2hsRC92THdpN0pOWlRkd1ZDODBZYWZSL3V6YWI3UzQya3JxTGhVTjd1OUFkNXhYcEh ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImtuS0hDRW80VzBGVitUQkJlT1FEb0E9PSIsInZhbHVlIjoiRWluQjhSTy9lcCtySzN4UnV5NjZQRTBPSnhIMDkxLzZSRzd3WU0rdUhJOTZFTW0wMXI5Sll4OHpvZjJlL21BWm4xUlJzSXVmV0RkMXZEUFVtVFFZR0NFNXp4KzZ1SmFOL04xeThxZWdmQVF0WDdRWEdTbmhYdzNFcktJejh5NGUiLCJtYWMiOiI2ZTFhMWQzYTBhMWQ5YzhjZjZiZWM3ZmZkN2UxNTljZGFhYmFkMTcwZjZjYTNjZjE2NWVjMTA3MDFlNThlNDFlIiwidGFnIjoiIn0%3D; expires=Mon, 28-Apr-2025 13:53:31 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImtuS0hDRW80VzBGVitUQkJlT1FEb0E9PSIsInZhbHVlIjoiRWluQjhSTy9lcCtySzN4UnV5NjZQRTBPSnhIMDkxLzZSRzd3WU0rdUhJOTZFTW0wMXI5Sll4OHpvZjJlL21BWm4xUlJzS ▶" 1 => "fitness_time_join_online_session=eyJpdiI6IlFMUlZLSlEvdHZ1TU9YY3psdE5KSUE9PSIsInZhbHVlIjoid01rQ2hsRC92THdpN0pOWlRkd1ZDODBZYWZSL3V6YWI3UzQya3JxTGhVTjd1OUFkNXhYcEhuS05oRUZ2WUx4V2FjN0c0Nnc2aVFlNnFDUHhIZXZwWTk2aVNLWnpCamlMN1E0VEJORi90aldyaFQ0aTNIWWlrNGV1ZDg1ZnBrbWgiLCJtYWMiOiI4YTY5NTJjNzk5YTMxYjRiNWRlZjA5M2I1ODM3NWUwZGQwYjQ2ZjIwMWU0MjRhZDIwYjkzM2U3NDQ4MGRjNDgxIiwidGFnIjoiIn0%3D; expires=Mon, 28-Apr-2025 13:53:31 GMT; path=/; secure; httponly ◀fitness_time_join_online_session=eyJpdiI6IlFMUlZLSlEvdHZ1TU9YY3psdE5KSUE9PSIsInZhbHVlIjoid01rQ2hsRC92THdpN0pOWlRkd1ZDODBZYWZSL3V6YWI3UzQya3JxTGhVTjd1OUFkNXhYcEh ▶" ] ]
0 of 0array:5 [▼ "_token" => "xllXdAvwagO1a0AWii3lMHbOkLV5lURAGomWc0Ge" "locale" => "en-us" "_previous" => array:1 [▶ "url" => "http://join.leejft.com/en-us/mamzar-16-ft" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]