Internal Server Error
ErrorException
Undefined array key "value"
vendor/twa/ecom-components/src/resources/views/products/details/accordion.blade.php :11
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/livewire/product-details.blade.php :199
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 :6
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 /ae/en/product/premiere-huile-gloss-reparatice-hair-oil-30ml
Headers
cf-visitor
{"scheme":"https"}
cf-ipcountry
LV
cf-connecting-ip
83.99.151.65
cdn-loop
cloudflare; loops=1
host
theloftfifthavenue.com
x-forwarded-proto
https
user-agent
Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko; GeedoProductSearch; +https://geedo.com/product-search.html) Chrome/134.0.0.0 Safari/537.36
accept-encoding
gzip, br
accept
text/html, application/xhtml+xml; q=0.9
cf-ray
947409099f17e4d7-RIX
x-forwarded-for
83.99.151.65
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": "ae",
    "language_prefix": "en",
    "slug": "premiere-huile-gloss-reparatice-hair-oil-30ml"
}
Database Queries only the first 100 queries are displayed
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` = 'ae' 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 ('1', '2', '3')
mysql
select * from `settings_v2` where `cancelled` = 0
mysql
insert into `ecom_users_temporary` (`token`, `cart`, `ip`, `updated_at`, `created_at`) values ('t_057fa6fd4bb3bb8487e7c90223639083', '"[]"', '83.99.151.65', '2025-05-29 06:46:33', '2025-05-29 06:46:33')
mysql
select * from `00_cms_cache` where `url` = '/ae/en/product/premiere-huile-gloss-reparatice-hair-oil-30ml' and `request_signature` = '0a4501b4f94658e7baedf109e98959dc' 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 = 'theloftfifthaven_67daaf86e1938_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 = 'theloftfifthaven_67daaf86e1938_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 = 'theloftfifthaven_67daaf86e1938_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 = 'theloftfifthaven_67daaf86e1938_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("/ae/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` = 'premiere-huile-gloss-reparatice-hair-oil-30ml'
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("/ae/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` = 'premiere-huile-gloss-reparatice-hair-oil-30ml'
mysql
select * from `ecom_products_brands` where `id` in (1)
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` = 'premiere-huile-gloss-reparatice-hair-oil-30ml'
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` = 'premiere-huile-gloss-reparatice-hair-oil-30ml'
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` = 'premiere-huile-gloss-reparatice-hair-oil-30ml' 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 ('153', '166', '167', '169', '50', '80', '58') 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` = 'premiere-huile-gloss-reparatice-hair-oil-30ml' 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` = 'premiere-huile-gloss-reparatice-hair-oil-30ml' 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("/ae/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` = 'premiere-huile-gloss-reparatice-hair-oil-30ml' 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("/ae/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` = 'premiere-huile-gloss-reparatice-hair-oil-30ml' group by COALESCE(family_group_id,id) order by `orders` asc limit 24 offset 0
mysql
select *, CONCAT("/ae/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 (487)
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 = 'theloftfifthaven_67daaf86e1938_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 = 'theloftfifthaven_67daaf86e1938_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` = 'Footer Menu' and `ecom_stores_id` LIKE '%"1"%' and `cancelled` = 0 limit 1
mysql
select *, label_en AS label, link_en AS link, CONCAT('https://theloft.fra1.cdn.digitaloceanspaces.com/theloftfifthavenue.com/public/data/front_end_menus/', id , '.', extension_image,'2v=' , version) AS image from `00_cms_utilities_frontend_menus_links` where `00_cms_utilities_frontend_menus_id` = 0 and `cancelled` = ?
mysql
select * from `ecom_users_reviews` where `cancelled` = 0 and `approved` = 1
mysql
select * from `ecom_products` where `id` = 487 and `cancelled` = 0 limit 1
mysql
select `id`, `stock_quantity`, `variations` from `ecom_products` where `family_group_id` = '6601311aa3b61' and `no_listing` = 0 and `price_ttc` > 0 and `cancelled` = 0
mysql
select `variations`, `id` from `ecom_products` where `family_group_id` = '6601311aa3b61' and `no_listing` = 0 and `price_ttc` > 0 and `cancelled` = 0
mysql
select `id`, `variations`, `stock_quantity` from `ecom_products` where `family_group_id` = '6601311aa3b61' and `no_listing` = 0 and (`stock_quantity` = 0 or `stock_quantity` is null) and `cancelled` = 0
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 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 '%"3"%' or `keywords` LIKE '%"43"%' or `keywords` LIKE '%"48"%' or `keywords` LIKE '%"78"%' or `keywords` LIKE '%"98"%' or `keywords` LIKE '%"112"%' or `keywords` LIKE '%"171"%' or `keywords` LIKE '%"173"%')
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 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 '%"487"%' or `ecom_keywords_id` LIKE '%"3"%' or `ecom_keywords_id` LIKE '%"43"%' or `ecom_keywords_id` LIKE '%"48"%' or `ecom_keywords_id` LIKE '%"78"%' or `ecom_keywords_id` LIKE '%"98"%' or `ecom_keywords_id` LIKE '%"112"%' or `ecom_keywords_id` LIKE '%"171"%' or `ecom_keywords_id` LIKE '%"173"%' or `ecom_subcategories_id` LIKE '%""%') and `cancelled` = 0
mysql
select exists (select 1 from information_schema.tables where table_schema = 'theloftfifthaven_67daaf86e1938_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 = 'theloftfifthaven_67daaf86e1938_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` = 487) and `ecom_products_id` != 487 order by `created_at` desc limit 100
mysql
select * from `ecom_products_recommendations` where (`ecom_keywords_id` LIKE '%"3"%' or `ecom_keywords_id` LIKE '%"43"%' or `ecom_keywords_id` LIKE '%"48"%' or `ecom_keywords_id` LIKE '%"78"%' or `ecom_keywords_id` LIKE '%"98"%' or `ecom_keywords_id` LIKE '%"112"%' or `ecom_keywords_id` LIKE '%"171"%' or `ecom_keywords_id` LIKE '%"173"%' or `ecom_subcategories_id` LIKE '%""%' or `ecom_products_id` LIKE '%"487"%') and `ecom_stores_id` LIKE '%"1"%' and `cancelled` = 0
mysql
select `id` from `ecom_products` where (`keywords` LIKE '%"36"%' 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 = 'theloftfifthaven_67daaf86e1938_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 = 'theloftfifthaven_67daaf86e1938_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 = 'theloftfifthaven_67daaf86e1938_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 = 'theloftfifthaven_67daaf86e1938_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 ('438', '498', '229', '560', '216', '269', '322', '197', '312', '275', '579', '212', '492', '562', '308', '300', '491', '246', '143', '344') 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 ('438', '498', '229', '560', '216', '269', '322', '197', '312', '275', '579', '212', '492', '562', '308', '300', '491', '246', '143', '344') 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("/ae/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 ('438', '498', '229', '560', '216', '269', '322', '197', '312', '275', '579', '212', '492', '562', '308', '300', '491', '246', '143', '344') 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("/ae/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 ('438', '498', '229', '560', '216', '269', '322', '197', '312', '275', '579', '212', '492', '562', '308', '300', '491', '246', '143', '344') 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 = 'theloftfifthaven_67daaf86e1938_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 = 'theloftfifthaven_67daaf86e1938_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("/ae/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 (562, 560, 579, 492, 300, 498, 491, 216, 438, 143, 197, 212, 229, 246, 269, 275, 308, 312, 322, 344)
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 = 'theloftfifthaven_67daaf86e1938_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 = 'theloftfifthaven_67daaf86e1938_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` = 'Footer Menu' and `ecom_stores_id` LIKE '%"1"%' and `cancelled` = 0 limit 1
mysql
select *, label_en AS label, link_en AS link, CONCAT('https://theloft.fra1.cdn.digitaloceanspaces.com/theloftfifthavenue.com/public/data/front_end_menus/', id , '.', extension_image,'2v=' , version) AS image from `00_cms_utilities_frontend_menus_links` where `00_cms_utilities_frontend_menus_id` = 0 and `cancelled` = ?
mysql
select * from `ecom_users_reviews` where `cancelled` = 0 and `approved` = 1
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 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 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 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 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 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 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 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
cache ref: 964