ErrorException
ErrorException
Undefined array key "value"
GET theloftfifthavenue.com
PHP 8.3.14 — Laravel 11.44.7
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-serum-filler-fondamental-hair-serum-90ml
Headers
cf-visitor
{"scheme":"https"}
cf-ipcountry
LV
cf-connecting-ip
83.99.151.70
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
9473a03f4bffe4cf-RIX
x-forwarded-for
83.99.151.70
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-serum-filler-fondamental-hair-serum-90ml"
}
Database Queries
only the first 100 queries are displayed
mysql
(13.46 ms)
select * from `00_cms_seo_settings` where `cancelled` = 0 order by `orders` asc limit 1
mysql
(4.68 ms)
select * from `00_cms_seo_by_route` where `cancelled` = 0 order by CHAR_LENGTH(`route`) DESC
mysql
(1.63 ms)
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
(1.48 ms)
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
(1.34 ms)
select * from `ecom_currencies` where `id` in ('1', '2', '3')
mysql
(1.18 ms)
select * from `settings_v2` where `cancelled` = 0
mysql
(5.04 ms)
insert into `ecom_users_temporary` (`token`, `cart`, `ip`, `updated_at`, `created_at`) values ('t_97f2dd62b960fc701731891cfded216f', '"[]"', '83.99.151.70', '2025-05-29 05:35:01', '2025-05-29 05:35:01')
mysql
(3.17 ms)
select * from `00_cms_cache` where `url` = '/ae/en/product/premiere-serum-filler-fondamental-hair-serum-90ml' and `request_signature` = '0a4501b4f94658e7baedf109e98959dc' and `cancelled` = 0 order by `id` desc limit 1
mysql
(2.44 ms)
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
(2.17 ms)
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
(2.02 ms)
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
(2.84 ms)
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
(1.21 ms)
select * from `ecom_products_variation_types` where 0 = 1 and `cancelled` = 0
mysql
(1.23 ms)
select * from `ecom_products_variations` where 0 = 1 and `cancelled` = 0
mysql
(1.84 ms)
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-serum-filler-fondamental-hair-serum-90ml'
mysql
(1.79 ms)
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-serum-filler-fondamental-hair-serum-90ml'
mysql
(1.29 ms)
select * from `ecom_products_brands` where `id` in (1)
mysql
(1.6 ms)
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-serum-filler-fondamental-hair-serum-90ml'
mysql
(1.51 ms)
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-serum-filler-fondamental-hair-serum-90ml'
mysql
(1.01 ms)
SET SESSION group_concat_max_len = 99999999999
mysql
(3.32 ms)
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-serum-filler-fondamental-hair-serum-90ml' and `ecom_products_filters_id` is not null group by 'all' limit 1
mysql
(1.34 ms)
select `id`, `version`, `cms_attributes`, label_en AS label, group_en AS `group` from `ecom_products_filters` where `cancelled` = 0 and `id` in ('152', '153', '155', '167', '50', '80', '58', '140') order by `orders` asc
mysql
(1.72 ms)
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-serum-filler-fondamental-hair-serum-90ml' group by COALESCE(family_group_id,id) order by `orders` asc
mysql
(1.69 ms)
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-serum-filler-fondamental-hair-serum-90ml' group by COALESCE(family_group_id,id) order by `orders` asc
mysql
(3.55 ms)
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-serum-filler-fondamental-hair-serum-90ml' group by COALESCE(family_group_id,id)) as `aggregate_table`
mysql
(2.16 ms)
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-serum-filler-fondamental-hair-serum-90ml' group by COALESCE(family_group_id,id) order by `orders` asc limit 24 offset 0
mysql
(1.94 ms)
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 (486)
mysql
(2.38 ms)
select * from `00_cms_utilities_frontend_menus` where `ecom_stores_id` LIKE '%"1"%' order by `orders` asc limit 1
mysql
(2.68 ms)
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
(1.61 ms)
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
(1.35 ms)
select * from `00_cms_utilities_frontend_menus` where `label` = 'Footer Menu' and `ecom_stores_id` LIKE '%"1"%' and `cancelled` = 0 limit 1
mysql
(1.96 ms)
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
(1.11 ms)
select * from `ecom_users_reviews` where `cancelled` = 0 and `approved` = 1
mysql
(1.46 ms)
select * from `ecom_products` where `id` = 486 and `cancelled` = 0 limit 1
mysql
(1.55 ms)
select `id`, `stock_quantity`, `variations` from `ecom_products` where `family_group_id` = '66012fbb1fad0' and `no_listing` = 0 and `price_ttc` > 0 and `cancelled` = 0
mysql
(1.68 ms)
select `variations`, `id` from `ecom_products` where `family_group_id` = '66012fbb1fad0' and `no_listing` = 0 and `price_ttc` > 0 and `cancelled` = 0
mysql
(1.62 ms)
select `id`, `variations`, `stock_quantity` from `ecom_products` where `family_group_id` = '66012fbb1fad0' and `no_listing` = 0 and (`stock_quantity` = 0 or `stock_quantity` is null) and `cancelled` = 0
mysql
(1.36 ms)
select * from `ecom_products_variation_types` where 0 = 1 and `cancelled` = 0
mysql
(1.25 ms)
select * from `ecom_products_variations` where 0 = 1 and `cancelled` = 0 order by `orders` asc
mysql
(1.24 ms)
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 '%"48"%' or `keywords` LIKE '%"52"%' or `keywords` LIKE '%"114"%' or `keywords` LIKE '%"171"%' or `keywords` LIKE '%"173"%')
mysql
(1.14 ms)
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
(1.54 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.53 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.43 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.49 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.44 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.31 ms)
select * from `ecom_products_load_adjusters` where `ecom_stores_id` = '1' and (`ecom_products_id` LIKE '%"486"%' or `ecom_keywords_id` LIKE '%"3"%' or `ecom_keywords_id` LIKE '%"48"%' or `ecom_keywords_id` LIKE '%"52"%' or `ecom_keywords_id` LIKE '%"114"%' or `ecom_keywords_id` LIKE '%"171"%' or `ecom_keywords_id` LIKE '%"173"%' or `ecom_subcategories_id` LIKE '%""%') and `cancelled` = 0
mysql
(1.31 ms)
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
(1.16 ms)
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
(1.8 ms)
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` = 486) and `ecom_products_id` != 486 order by `created_at` desc limit 100
mysql
(1.32 ms)
select * from `ecom_products_recommendations` where (`ecom_keywords_id` LIKE '%"3"%' or `ecom_keywords_id` LIKE '%"48"%' or `ecom_keywords_id` LIKE '%"52"%' or `ecom_keywords_id` LIKE '%"114"%' or `ecom_keywords_id` LIKE '%"171"%' or `ecom_keywords_id` LIKE '%"173"%' or `ecom_subcategories_id` LIKE '%""%' or `ecom_products_id` LIKE '%"486"%') and `ecom_stores_id` LIKE '%"1"%' and `cancelled` = 0
mysql
(1.78 ms)
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
(2.17 ms)
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
(1.96 ms)
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
(2.06 ms)
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
(2.5 ms)
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
(1.41 ms)
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 ('289', '560', '375', '199', '281', '339', '352', '581', '269', '334', '351', '489', '176', '284', '348', '313', '292', '491', '529', '492') group by COALESCE(family_group_id,id) order by `orders` asc
mysql
(1.4 ms)
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 ('289', '560', '375', '199', '281', '339', '352', '581', '269', '334', '351', '489', '176', '284', '348', '313', '292', '491', '529', '492') group by COALESCE(family_group_id,id) order by `orders` asc
mysql
(2.21 ms)
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 ('289', '560', '375', '199', '281', '339', '352', '581', '269', '334', '351', '489', '176', '284', '348', '313', '292', '491', '529', '492') group by COALESCE(family_group_id,id)) as `aggregate_table`
mysql
(1.84 ms)
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 ('289', '560', '375', '199', '281', '339', '352', '581', '269', '334', '351', '489', '176', '284', '348', '313', '292', '491', '529', '492') group by COALESCE(family_group_id,id) order by `orders` asc limit 24 offset 0
mysql
(2.12 ms)
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
(2.03 ms)
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
(1.65 ms)
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 (581, 560, 492, 489, 529, 284, 491, 351, 176, 199, 269, 281, 289, 292, 313, 334, 339, 348, 352, 375)
mysql
(1.17 ms)
select * from `00_cms_utilities_frontend_menus` where `ecom_stores_id` LIKE '%"1"%' order by `orders` asc limit 1
mysql
(1.65 ms)
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
(1.57 ms)
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
(1.17 ms)
select * from `00_cms_utilities_frontend_menus` where `label` = 'Footer Menu' and `ecom_stores_id` LIKE '%"1"%' and `cancelled` = 0 limit 1
mysql
(2.02 ms)
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
(1.18 ms)
select * from `ecom_users_reviews` where `cancelled` = 0 and `approved` = 1
mysql
(1.55 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.47 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.61 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.46 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.45 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(2.41 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.46 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.46 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.55 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.41 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.41 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.45 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.5 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.46 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.44 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.51 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.45 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.45 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.61 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.44 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.45 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.49 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(2.32 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.47 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.41 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.58 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.39 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.53 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.49 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.43 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0
mysql
(1.5 ms)
select count(*) as aggregate from `00_cms_files` where `cancelled` = 0