Internal Server Error
ErrorException
Undefined array key "is_out_of_stock"
vendor/twa/ecom-products/src/views/pages/variations/default.blade.php :137
vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php :37
vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php :38
vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php :75
vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php :16
vendor/laravel/framework/src/Illuminate/View/View.php :209
vendor/laravel/framework/src/Illuminate/View/View.php :192
vendor/laravel/framework/src/Illuminate/View/View.php :161
vendor/laravel/framework/src/Illuminate/View/View.php :494
vendor/laravel/framework/src/Illuminate/Support/helpers.php :134
resources/views/livewire/product-details.blade.php :64
vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php :37
vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php :38
vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php :75
vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php :16
vendor/laravel/framework/src/Illuminate/View/View.php :209
vendor/laravel/framework/src/Illuminate/View/View.php :192
vendor/laravel/framework/src/Illuminate/View/View.php :161
vendor/livewire/livewire/src/Mechanisms/HandleComponents/HandleComponents.php :241
vendor/livewire/livewire/src/Mechanisms/HandleComponents/HandleComponents.php :285
vendor/livewire/livewire/src/Mechanisms/HandleComponents/HandleComponents.php :233
vendor/livewire/livewire/src/Mechanisms/HandleComponents/HandleComponents.php :54
vendor/livewire/livewire/src/LivewireManager.php :73
resources/views/pages/products/details.blade.php :33
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php :123
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php :124
vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php :58
vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php :22
vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php :75
vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php :10
vendor/laravel/framework/src/Illuminate/View/View.php :209
vendor/laravel/framework/src/Illuminate/View/View.php :192
vendor/laravel/framework/src/Illuminate/View/View.php :161
vendor/laravel/framework/src/Illuminate/Http/Response.php :79
vendor/laravel/framework/src/Illuminate/Http/Response.php :35
vendor/laravel/framework/src/Illuminate/Routing/Router.php :920
vendor/laravel/framework/src/Illuminate/Routing/Router.php :887
vendor/laravel/framework/src/Illuminate/Routing/Router.php :807
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :170
vendor/twa/cache/src/middleware/CacheMiddleware.php :121
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/twa/ecom-auth/src/middleware/AuthCheckProfileComplete.php :42
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/twa/ecom-general/src/middleware/storeDefaultDataMiddleware.php :80
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/twa/ecom-general/src/middleware/storeRoutesMiddleware.php :59
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/twa/htmlhelpers/src/middleware/TWASEOMiddleware.php :44
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php :51
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php :88
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php :49
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php :121
vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php :64
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php :37
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php :75
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :127
vendor/laravel/framework/src/Illuminate/Routing/Router.php :807
vendor/laravel/framework/src/Illuminate/Routing/Router.php :786
vendor/laravel/framework/src/Illuminate/Routing/Router.php :750
vendor/laravel/framework/src/Illuminate/Routing/Router.php :739
vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php :201
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :170
vendor/livewire/livewire/src/Features/SupportDisablingBackButtonCache/DisableBackButtonCacheMiddleware.php :19
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php :49
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php :121
vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php :64
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php :37
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php :75
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php :21
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php :31
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php :21
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php :51
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php :27
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php :110
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php :49
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php :58
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php :22
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :209
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :127
vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php :176
vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php :145
vendor/laravel/framework/src/Illuminate/Foundation/Application.php :1220
public/index.php :17
Request
GET /ua/en/product/christies-hanging-earrings
Headers
host
simonaconstantine.com
connection
Keep-Alive
x-forwarded-proto
https
cf-visitor
{"scheme":"https"}
cf-ipcountry
LB
cf-connecting-ip
178.135.0.77
cdn-loop
cloudflare; loops=1
sec-fetch-mode
cors
accept-language
en-US,en;q=0.9
accept-encoding
gzip, br
priority
u=3, i
sec-fetch-site
same-origin
accept
*/*
referer
https://simonaconstantine.com/ua/en/products/christies?utm_medium=paid&utm_source=ig&utm_id=120233326557520291&utm_content=120233326559050291&utm_term=120233326558170291&utm_campaign=120233326557520291&fbclid=PAZXh0bgNhZW0BMABhZGlkAasnktII8mMBp-D_dmAF_Ktt_rwtrCYQ3kgrLQJv833Yd8ReORRY1b3dQsorarnkRXpR0jNZ_aem_CjMzfbfG5mleb1YtIveiIA
cf-ray
98cc255cb99f13d3-MRS
sec-fetch-dest
empty
cookie
XSRF-TOKEN=eyJpdiI6InhUMlA1bmJONnhqaTVwZ1VFdlYwVlE9PSIsInZhbHVlIjoiRVV3eitEUzNBd1VrRWM1dUhJazZiK25JblhpN2lzR1Q5cVZETlQ3VFl0U3JVYjhLRkVJbmFpTE90M09mZFFQendidkxndXNKYmU3TlMyY05YOEdhNzVFU3Bna0VhNngrRlVPeGF1SFhjTkU4NjhkMWdTS2F2OFY0dnNZdlBzWGVaUUF1YlpLZEhhRmcySXI2dzlmaE1lNzQ5Q1BjYVBwREY1Mld0OW5BUkJkQTc3eVFQb2tEMERqck9xMktYSjhUeElHRlBIazVPTXdXbkNDYnVLUTY1OU9GY2NCQmF0NmpnZDV5b3lNdFZreUFNYm5GNUp5Q3QyNWFER3ljSzdjeThGT2pZdG9EUVljdGNxcTA5ODAwVVl4bHZCTjNYZjVyZXB3bTVoY1lHT0FhRmdwNEtIM2F5bDlPSWQ4em9QRHhnanRCRTZMaGR2eDRuc0prZ1EveW1uSTRza1dpQXZVdEh4djZYbEdEa3ozbXgrNXFZK1NsN28xRnVOM2NkN1hQWmExeEk3MWhXUytUQ3FIVFp2K1Rndkp0WHovNTYydjFMSjVRT1VSRXVOVitTQ1BMRlVVTnJFVVhvdmRMNFFkcWp5cE1ZbVBnYytKSVl6MmhyMDUxbEhVaTdzWmRwOWRSL0J3VUV6aTdDV2FFUmpGazAyaEc2MHUyZitFeTl1eFciLCJtYWMiOiJjZTk4NTIxYmZiMWNmM2U5MzU2NjM2NTEyNjAyYWM4ODQ5NTkyMWUwMzM4OGJlZTkxNWU0ZGMwNmIwNTdmMjg0IiwidGFnIjoiIn0%3D; offlineToken_v2=t_bd2100d1303133a631d179ecc35ef6ef; simona_costantine_session=eyJpdiI6IkdLQ3o5aFBscTdIYUFGR253SEF1L1E9PSIsInZhbHVlIjoic28rNWYvWnZkZndhaVVMeTliRlFodUx5RWs3T0htS2xnZjdzSDFkWjQzOVZXdkxDc24vYlROMVNBRW5Kb1ZpdEQzYSs1eVBXcklxVFNTUkYyNzdMQllkSUZJWW9QVlV1aVR3UW1JUU56aE5IVUI3RVpJTHlFVUFmNVVqKzB2SlUiLCJtYWMiOiJjM2VkZjExNDgzZDE5M2UxYTEwZjIwYWVjNjRiZjdmMWQwMzhkYjg4MTBiMDAzZWE0MzhjMjNmNjlmMzBkMzE0IiwidGFnIjoiIn0%3D; twaecom_bfp_v2=760c36cc666d64a0093f24ff9d23aec6
user-agent
Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/22G100 Instagram 400.1.0.29.75 (iPhone17,4; iOS 18_6_2; en_US; en; scale=3.00; 1290x2796; IABMV/1; 799622199)
x-livewire-navigate
x-forwarded-for
178.135.0.77
Body
No body data
Application
Routing
controller
App\Http\Controllers\ProductController@ProductDetails
route name
product
middleware
web, twa\htmlhelpers\middleware\TWASEOMiddleware, twa\ecomgeneral\middleware\storeRoutesMiddleware, twa\ecomgeneral\middleware\storeDefaultDataMiddleware, twa\ecomauth\middleware\AuthCheckProfileComplete, twa\cache\middleware\CacheMiddleware
Routing Parameters
{
    "store_prefix": "ua",
    "language_prefix": "en",
    "slug": "christies-hanging-earrings"
}
Database Queries only the first 100 queries are displayed
mysql
select * from `cache` where `key` in ('twa_cms_ecom_apps_subscriptions')
mysql
select * from `cache` where `key` in ('twa_cms_ecom_apps_subscriptions')
mysql
select * from `cache` where `key` in ('twa_cms_ecom_apps_subscriptions')
mysql
select * from `cache` where `key` in ('twa_cms_ecom_apps_subscriptions')
mysql
select * from `cache` where `key` in ('twa_cms_theme-builder_components')
mysql
insert into `cache` (`expiration`, `key`, `value`) values (2075522518, 'twa_cms_theme-builder-components', 'O:29:"Illuminate\Support\Collection":2:{s:8:"*items";a:0:{}s:28:"*escapeWhenCastingToString";b:0;}') on duplicate key update `expiration` = values(`expiration`), `key` = values(`key`), `value` = values(`value`)
mysql
select * from `00_cms_seo_settings` where `cancelled` = 0 order by `orders` asc limit 1
mysql
select * from `00_cms_seo_by_route` where `cancelled` = 0 order by CHAR_LENGTH(`route`) DESC
mysql
select *, header_message_en AS header_message, label_en AS label  from `ecom_stores` where `web_prefix` = 'ua' and `cancelled` = 0 and `published` = 1 limit 1
mysql
select *, header_message_en AS header_message, label_en AS label, group_en AS `group` , contact_us_store_information_en AS contact_us_store_information from `ecom_stores` where `id` = 1 and `cancelled` = 0 limit 1
mysql
select * from `ecom_currencies` where `id` in ('16')
mysql
select * from `settings_v2` where `cancelled` = 0
mysql
select * from `cache` where `key` in ('ecom_menus')
mysql
select * from `ecom_users_temporary` where `token` = 't_bd2100d1303133a631d179ecc35ef6ef' and `cancelled` = 0 limit 1
mysql
select * from `cache` where `key` in ('twa_cms_ecom_apps_subscriptions')
mysql
select * from `00_cms_cache` where `url` = '/ua/en/product/christies-hanging-earrings' and `request_signature` = '80627ae4c2384f7d09f2aa50d6fb8e2a' and `cancelled` = 0 order by `id` desc limit 1
mysql
select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'simonaconstantin_6798b1d5b8d50_db_live' and table_name = 'ecom_products' order by ordinal_position asc
mysql
select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'simonaconstantin_6798b1d5b8d50_db_live' and table_name = 'ecom_products' order by ordinal_position asc
mysql
select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'simonaconstantin_6798b1d5b8d50_db_live' and table_name = 'ecom_products' order by ordinal_position asc
mysql
select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'simonaconstantin_6798b1d5b8d50_db_live' and table_name = 'ecom_products' order by ordinal_position asc
mysql
select * from `ecom_products_variation_types` where 0 = 1 and `cancelled` = 0
mysql
select * from `ecom_products_variations` where 0 = 1 and `cancelled` = 0
mysql
select `id`, `ecom_products_bulk_pricing_id`, `price_ttc`, `keywords`, `digital_product`, `ecom_products_giftcards_id`, `ecom_vendors_id`, `ecom_products_brands_id`, `ecom_subcategories_id`, `00_cms_files_image`, `hscode`, `barcode`, `ecom_products_categories_id`, `family_group_id`, (price_ttc - price_ttc * (COALESCE(discount,0) + 0) / 100) AS price, CONCAT("/ua/en/product/",slug) AS link from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0 and `slug` = 'christies-hanging-earrings'
mysql
select min(`price_ttc`) as aggregate from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0 and `slug` = 'christies-hanging-earrings'
mysql
select max(`price_ttc`) as aggregate from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0 and `slug` = 'christies-hanging-earrings'
mysql
SET SESSION group_concat_max_len = 99999999999
mysql
select `id`, GROUP_CONCAT(ecom_products_filters_id SEPARATOR ',') AS col from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0 and `slug` = 'christies-hanging-earrings' and `ecom_products_filters_id` is not null group by 'all' limit 1
mysql
select `id`, `version`, `cms_attributes`, label_en AS label, group_en AS `group` from `ecom_products_filters` where `cancelled` = 0 and `id` in ('230', '166', '234') order by `orders` asc
mysql
select `ecom_products_categories_id` from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0 and `slug` = 'christies-hanging-earrings' group by COALESCE(family_group_id,id) order by `orders` asc
mysql
select `ecom_products_brands_id` from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0 and `slug` = 'christies-hanging-earrings' group by COALESCE(family_group_id,id) order by `orders` asc
mysql
select count(*) as aggregate from (select `id`, `ecom_products_bulk_pricing_id`, `price_ttc`, `keywords`, `digital_product`, `ecom_products_giftcards_id`, `ecom_vendors_id`, `ecom_products_brands_id`, `ecom_subcategories_id`, `00_cms_files_image`, `hscode`, `barcode`, `ecom_products_categories_id`, `family_group_id`, (price_ttc - price_ttc * (COALESCE(discount,0) + 0) / 100) AS price, CONCAT("/ua/en/product/",slug) AS link from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0 and `slug` = 'christies-hanging-earrings' group by COALESCE(family_group_id,id)) as `aggregate_table`
mysql
select `id`, `ecom_products_bulk_pricing_id`, `price_ttc`, `keywords`, `digital_product`, `ecom_products_giftcards_id`, `ecom_vendors_id`, `ecom_products_brands_id`, `ecom_subcategories_id`, `00_cms_files_image`, `hscode`, `barcode`, `ecom_products_categories_id`, `family_group_id`, (price_ttc - price_ttc * (COALESCE(discount,0) + 0) / 100) AS price, CONCAT("/ua/en/product/",slug) AS link from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0 and `slug` = 'christies-hanging-earrings' group by COALESCE(family_group_id,id) order by `orders` asc limit 24 offset 0
mysql
select *, CONCAT("/ua/en/product/",slug) AS link, (price_ttc - price_ttc * (LEAST(COALESCE(discount,0) + 0,100) / 100)) AS price, LEAST(COALESCE(discount,0) + 0,100) AS discount, label_en AS label, small_description_en AS small_description, label_en AS label,small_description_en AS small_description, label_en AS label,small_description_en AS small_description from `ecom_products` where `cancelled` = 0 and `display` = 1 and `id` in (1047)
mysql
select * from `cache` where `key` in ('twa_cms_ecom_apps_subscriptions')
mysql
select * from `cache` where `key` in ('ecom_tags')
mysql
select *, label_en AS label from `ecom_products_tags` where `cancelled` = 0 and `show_card` = 1
mysql
select * from `cache` where `key` in ('ecom_tags')
mysql
select * from `00_cms_utilities_frontend_menus` where `ecom_stores_id` LIKE '%"1"%' order by `orders` asc limit 1
mysql
select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'simonaconstantin_6798b1d5b8d50_db_live' and table_name = '00_cms_utilities_frontend_menus_links' order by ordinal_position asc
mysql
select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'simonaconstantin_6798b1d5b8d50_db_live' and table_name = '00_cms_utilities_frontend_menus_links' order by ordinal_position asc
mysql
select * from `00_cms_utilities_frontend_menus` where `label` = 'main menu' and `ecom_stores_id` LIKE '%"1"%' and `cancelled` = 0 limit 1
mysql
select *, label_en AS label, link_en AS link, CONCAT('https://cdn.simona-constantine.twalab.live/simona-constantine.twalab.com/public/data/front_end_menus/', id , '.', extension_image,'1v=' , version) AS image from `00_cms_utilities_frontend_menus_links` where `00_cms_utilities_frontend_menus_id` = 0 and `cancelled` = ?
mysql
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
select * from `ecom_products` where `id` = 1047 and `cancelled` = 0 limit 1
mysql
select `id`, `stock_quantity`, `variations` from `ecom_products` where `family_group_id` = '67aca188eeee5' and `no_listing` = 0 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `cancelled` = 0
mysql
select * from `ecom_products_variations` where `id` in ('2093', '2101')
mysql
select * from `ecom_products_variation_types` where `id` in (4, 5) order by `orders` asc
mysql
select *, label_en AS label, note_available_title_en AS note_available_title from `ecom_products_modifiers` where `cancelled` = 0 and `display` = 1 and (`keywords` LIKE '%"183"%' or `keywords` LIKE '%"206"%')
mysql
select `id`, label_en AS label, group_en AS `group` from `ecom_products_filters` where `id` in ('') and `cancelled` = 0 order by `orders` asc
mysql
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
select * from `ecom_products_load_adjusters` where `ecom_stores_id` = '1' and (`ecom_products_id` LIKE '%"1047"%' or `ecom_keywords_id` LIKE '%"183"%' or `ecom_keywords_id` LIKE '%"206"%' or `ecom_subcategories_id` LIKE '%""%') and `cancelled` = 0
mysql
select exists (select 1 from information_schema.tables where table_schema = 'simonaconstantin_6798b1d5b8d50_db_live' and table_name = 'ecom_products_complementaries' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql
select exists (select 1 from information_schema.tables where table_schema = 'simonaconstantin_6798b1d5b8d50_db_live' and table_name = 'complementary_single_product' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql
select `ecom_products_id` from `ecom_users_purchases_statistics_product` where `ecom_users_purchases_id` in (select `ecom_users_purchases_id` from `ecom_users_purchases_statistics_product` where `ecom_stores_id` = '1' and `cancelled` = 0 and `ecom_products_id` = 1047) and `ecom_products_id` != 1047 order by `created_at` desc limit 100
mysql
select * from `cache` where `key` in ('ecom::categories:data')
mysql
select * from `ecom_products_recommendations` where (`ecom_keywords_id` LIKE '%"183"%' or `ecom_keywords_id` LIKE '%"206"%' or `ecom_subcategories_id` LIKE '%""%' or `ecom_products_id` LIKE '%"1047"%') and `ecom_stores_id` LIKE '%"1"%' and `cancelled` = 0
mysql
select `id` from `ecom_products` where (`keywords` LIKE '%"206"%' or 0 = 1 or 0 = 1 or 0 = 1) and `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = '1' and `no_listing` = 0 order by RAND() limit 20
mysql
select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'simonaconstantin_6798b1d5b8d50_db_live' and table_name = 'ecom_products' order by ordinal_position asc
mysql
select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'simonaconstantin_6798b1d5b8d50_db_live' and table_name = 'ecom_products' order by ordinal_position asc
mysql
select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'simonaconstantin_6798b1d5b8d50_db_live' and table_name = 'ecom_products' order by ordinal_position asc
mysql
select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'simonaconstantin_6798b1d5b8d50_db_live' and table_name = 'ecom_products' order by ordinal_position asc
mysql
select `ecom_products_categories_id` from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = '1' and `price_ttc` > 0 and `no_listing` = 0 and `id` in ('1069', '1065', '786', '788', '590', '1123', '1067', '600', '784', '782', '1121') group by COALESCE(family_group_id,id) order by `orders` asc
mysql
select `ecom_products_brands_id` from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = '1' and `price_ttc` > 0 and `no_listing` = 0 and `id` in ('1069', '1065', '786', '788', '590', '1123', '1067', '600', '784', '782', '1121') group by COALESCE(family_group_id,id) order by `orders` asc
mysql
select count(*) as aggregate from (select `id`, `ecom_products_bulk_pricing_id`, `price_ttc`, `keywords`, `digital_product`, `ecom_products_giftcards_id`, `ecom_vendors_id`, `ecom_products_brands_id`, `ecom_subcategories_id`, `00_cms_files_image`, `hscode`, `barcode`, `ecom_products_categories_id`, `family_group_id`, (price_ttc - price_ttc * (COALESCE(discount,0) + 0) / 100) AS price, CONCAT("/ua/en/product/",slug) AS link from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = '1' and `price_ttc` > 0 and `no_listing` = 0 and `id` in ('1069', '1065', '786', '788', '590', '1123', '1067', '600', '784', '782', '1121') group by COALESCE(family_group_id,id)) as `aggregate_table`
mysql
select `id`, `ecom_products_bulk_pricing_id`, `price_ttc`, `keywords`, `digital_product`, `ecom_products_giftcards_id`, `ecom_vendors_id`, `ecom_products_brands_id`, `ecom_subcategories_id`, `00_cms_files_image`, `hscode`, `barcode`, `ecom_products_categories_id`, `family_group_id`, (price_ttc - price_ttc * (COALESCE(discount,0) + 0) / 100) AS price, CONCAT("/ua/en/product/",slug) AS link from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = '1' and `price_ttc` > 0 and `no_listing` = 0 and `id` in ('1069', '1065', '786', '788', '590', '1123', '1067', '600', '784', '782', '1121') group by COALESCE(family_group_id,id) order by `orders` asc limit 24 offset 0
mysql
select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'simonaconstantin_6798b1d5b8d50_db_live' and table_name = 'ecom_products' order by ordinal_position asc
mysql
select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'simonaconstantin_6798b1d5b8d50_db_live' and table_name = 'ecom_products' order by ordinal_position asc
mysql
select `id`, `ecom_products_bulk_pricing_id`, `weight`, `width`, `length`, `hscode`, `barcode`, `extension_image`, `sku`, `price_ttc`, `price_shelf`, `version`, `stock_quantity`, `family_group_id`, `keywords`, `gallery`, `cms_attributes`, `ecom_products_tags_id`, `ecom_stores_id`, `ecom_subcategories_id`, `slug`, `digital_product`, `ecom_products_giftcards_id`, `preorder_available`, `ecom_vendors_id`, `ecom_products_brands_id`, `00_cms_files_image`, `created_at`, CONCAT("/ua/en/product/",slug) AS link, COALESCE(discount,0) AS discount, (price_ttc - price_ttc * (LEAST(COALESCE(discount,0) + 0,100) / 100)) AS price, LEAST(COALESCE(discount,0) + 0,100) AS discount, label_en AS label, small_description_en AS small_description from `ecom_products` where `display` = 1 and `cancelled` = 0 and `price_ttc` > 0 and `ecom_stores_id` = '1' and `id` in (590, 600, 782, 784, 786, 788, 1065, 1067, 1069, 1121, 1123)
mysql
select * from `cache` where `key` in ('twa_cms_ecom_apps_subscriptions')
mysql
select * from `cache` where `key` in ('ecom_tags')
mysql
select *, label_en AS label from `ecom_products_tags` where `cancelled` = 0 and `show_card` = 1
mysql
select * from `cache` where `key` in ('ecom_tags')
mysql
select * from `00_cms_utilities_frontend_menus` where `ecom_stores_id` LIKE '%"1"%' order by `orders` asc limit 1
mysql
select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'simonaconstantin_6798b1d5b8d50_db_live' and table_name = '00_cms_utilities_frontend_menus_links' order by ordinal_position asc
mysql
select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'simonaconstantin_6798b1d5b8d50_db_live' and table_name = '00_cms_utilities_frontend_menus_links' order by ordinal_position asc
mysql
select * from `00_cms_utilities_frontend_menus` where `label` = 'main menu' and `ecom_stores_id` LIKE '%"1"%' and `cancelled` = 0 limit 1
mysql
select *, label_en AS label, link_en AS link, CONCAT('https://cdn.simona-constantine.twalab.live/simona-constantine.twalab.com/public/data/front_end_menus/', id , '.', extension_image,'1v=' , version) AS image from `00_cms_utilities_frontend_menus_links` where `00_cms_utilities_frontend_menus_id` = 0 and `cancelled` = ?
mysql
select * from `cache` where `key` in ('ecom_tags')
mysql
select *, label_en AS label from `ecom_products_tags` where `cancelled` = 0 and `show_card` = 1
mysql
select * from `cache` where `key` in ('ecom_tags')
mysql
select * from `cache` where `key` in ('ecom_tags')
mysql
select *, label_en AS label from `ecom_products_tags` where `cancelled` = 0 and `show_card` = 1
mysql
select * from `cache` where `key` in ('ecom_tags')
mysql
select * from `cache` where `key` in ('ecom_tags')
mysql
select *, label_en AS label from `ecom_products_tags` where `cancelled` = 0 and `show_card` = 1
mysql
select * from `cache` where `key` in ('ecom_tags')
mysql
select * from `cache` where `key` in ('ecom_tags')
mysql
select *, label_en AS label from `ecom_products_tags` where `cancelled` = 0 and `show_card` = 1
mysql
select * from `cache` where `key` in ('ecom_tags')
mysql
select * from `cache` where `key` in ('ecom_tags')
mysql
select *, label_en AS label from `ecom_products_tags` where `cancelled` = 0 and `show_card` = 1
mysql
select * from `cache` where `key` in ('ecom_tags')
mysql
select * from `cache` where `key` in ('ecom_tags')
mysql
select *, label_en AS label from `ecom_products_tags` where `cancelled` = 0 and `show_card` = 1
mysql
select * from `cache` where `key` in ('ecom_tags')
mysql
select * from `cache` where `key` in ('ecom_tags')
mysql
select *, label_en AS label from `ecom_products_tags` where `cancelled` = 0 and `show_card` = 1
cache ref: 2765