LV

83.99.151.70

cloudflare; loops=1

theloftfifthavenue.com

https

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

gzip, br

text/html, application/xhtml+xml; q=0.9

9473a03f4bffe4cf-RIX

83.99.151.70

product

web, twa\htmlhelpers\middleware\TWASEOMiddleware, twa\ecomgeneral\middleware\storeRoutesMiddleware, twa\ecomgeneral\middleware\storeDefaultDataMiddleware, twa\ecomauth\middleware\AuthCheckProfileComplete, twa\cache\middleware\CacheMiddleware

select * from `00_cms_seo_by_route` where `cancelled` = 0 order by CHAR_LENGTH(`route`) DESC

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

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

select * from `ecom_currencies` where `id` in ('1', '2', '3')

select * from `settings_v2` where `cancelled` = 0

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')

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

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

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

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

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

select * from `ecom_products_variation_types` where 0 = 1 and `cancelled` = 0

select * from `ecom_products_variations` where 0 = 1 and `cancelled` = 0

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'

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'

select * from `ecom_products_brands` where `id` in (1)

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'

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'

SET SESSION group_concat_max_len = 99999999999

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

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

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

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

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`

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

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)

select * from `00_cms_utilities_frontend_menus` where `ecom_stores_id` LIKE '%"1"%' order by `orders` asc limit 1

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

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

select * from `00_cms_utilities_frontend_menus` where `label` = 'Footer Menu' and `ecom_stores_id` LIKE '%"1"%' and `cancelled` = 0 limit 1

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` = ?

select * from `ecom_users_reviews` where `cancelled` = 0 and `approved` = 1

select * from `ecom_products` where `id` = 486 and `cancelled` = 0 limit 1

select `id`, `stock_quantity`, `variations` from `ecom_products` where `family_group_id` = '66012fbb1fad0' and `no_listing` = 0 and `price_ttc` > 0 and `cancelled` = 0

select `variations`, `id` from `ecom_products` where `family_group_id` = '66012fbb1fad0' and `no_listing` = 0 and `price_ttc` > 0 and `cancelled` = 0

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

select * from `ecom_products_variation_types` where 0 = 1 and `cancelled` = 0

select * from `ecom_products_variations` where 0 = 1 and `cancelled` = 0 order by `orders` asc

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"%')

select `id`, label_en AS label, group_en AS `group` from `ecom_products_filters` where `id` in ('') and `cancelled` = 0 order by `orders` asc

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

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

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`

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`

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

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

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

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

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

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

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

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

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

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`

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

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

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

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)

select * from `00_cms_utilities_frontend_menus` where `ecom_stores_id` LIKE '%"1"%' order by `orders` asc limit 1

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

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

select * from `00_cms_utilities_frontend_menus` where `label` = 'Footer Menu' and `ecom_stores_id` LIKE '%"1"%' and `cancelled` = 0 limit 1

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` = ?

select * from `ecom_users_reviews` where `cancelled` = 0 and `approved` = 1

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0