107.173.224.127

cloudflare; loops=1

https

{"scheme":"https"}

107.173.224.127

946c21fd2df72a9a-LAX

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

XSRF-TOKEN=eyJpdiI6ImhNY2dmMHk4WGZoZmVsR0NiRkhnYVE9PSIsInZhbHVlIjoiVjMvUWFucndsY2lBV0owOWQ5ekRkN0JmUWFIV0NPMnhXZWxVdTJ3akJaUWVTSFdRQ05jd1JYbDRRQW1pTTFpZE55NlA4b1BrQmxlMlRMNEdsbDljY2pNbzBlTlFmdk9FMEs5QmE2NmhuVStaa1ZFdXhVWm9RWFIrWU9zeEMrQjNKTFNmRjlzUjhRQlpqbzdiVFJ0d01hZHc5VkRhZDJ1OUwwb01DenJVNmp3dFZlUmFldmxYWWZHSllCQVdvbDZDUHFJWGI1SW1iZjAwNUtDOUV4ZTcrTTBiVFE2V0JNVW5jNXROb2Y2dEh3cG5uSXpieHFremFtSnRGTjJFOE5JN3B3cG10ZXg4OTlUN0F5REc5K2o5bHdXVjFiWWJtQkZPeUpOUkJWMXpPL2J0MmRKUGdVR0M1U2VFN3VFSTBPS2xwSEs1VVZxcWEvR0ZOYUJGMXZTZitOTGVWMHQxUDFEaGkwdlhXMnU5STc1VGo5cXJDd09WMDYzZ3BKMG1MbXF0SkpvcFJVdTZsbDZPbnpCU3NEdUc2ckk4aFJpUWltRHFyZkZUMHFVUXQyNmkvWXVYUHYxeVRFdjd5L0lpeTRtaGJwRWJWZ3VIUDc1RzJNaWFlL2VNMW9iVWxwL3haSmM2bklsbk15NUhBeVNmRC9CemhoK2c1R0ZHZUJhYnl6Z2giLCJtYWMiOiI3MzE0YzE0YmUwYmVhZDViOTRlYzVmYjc5MWI4NzE0Y2IwNDc1YTJjMDIxMWYxZTcyM2ExMTEwMWRiNzA0NmE1IiwidGFnIjoiIn0%3D; offlineToken_v2=t_5697215a72f00f31e5d081236a408ddd; the_loft_session=eyJpdiI6IlF4cHZhbEkrRkZGTDFCUUR5VmRmTkE9PSIsInZhbHVlIjoibjUvNjdLdldpclcyTVE2M1d6V2JyVTJidVZKRHEzZzVvLzR0SEQycGpxYmZSbnNCZ3JpUEd5RW01UFlEYWpTclZ5bTRlb2lZS1JOeTg4UCtWeHpXRkp5UzgvNDhBQkxRaERMNngvRXhidWp0Z1krTm53THZaT0lTTFZYcE9NdTMiLCJtYWMiOiIwN2I1OTEzNjUyMGM0NzEyOGU5ZTlkYmEzOGVhMzgzYzc5YmM2ZmYxY2MzYzY2OTIzMjNhNGY5NGMzYjU0NWY2IiwidGFnIjoiIn0%3D

Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.81 Safari/537.36

gzip, br

theloftfifthavenue.com

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

select * from `ecom_users_temporary` where `token` = 't_5697215a72f00f31e5d081236a408ddd' and `cancelled` = 0 limit 1

select * from `00_cms_cache` where `url` = '/ae/en/products/dandruff-dry-scalp' and `request_signature` = '0a4501b4f94658e7baedf109e98959dc' and `cancelled` = 0 order by `id` desc limit 1

select * from `00_cms_utilities_frontend_menus_links` where `cancelled` = 0 and `slug` = 'dandruff-dry-scalp' 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` = 'Main 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,'4v=' , version) AS image from `00_cms_utilities_frontend_menus_links` where `00_cms_utilities_frontend_menus_id` = 0 and `cancelled` = ?

select * from `00_cms_utilities_frontend_menus_links` where `cancelled` = 0 and `id` in (2, 38, 331) order by CASE id WHEN 2 THEN 0 WHEN 38 THEN 1 WHEN 331 THEN 2 END

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

select * from `ecom_products_brands` where `id` in (2, 3, 4, 5, 1, 6, 7, 9, 10, 11, 13, 17, NULL, 18)

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

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

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 `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 ('147', '150', '153', '160', '162', '193', '78', '55', '38', '41', '140', '149', '151', '152', '166', '169', '173', '182', '35', '53', '45', '58', '64', '72', '148', '164', '52', '56', '103', '163', '44', '168', '42', '176', '185', '191', '79', '67', '77', '181', '71', '87', '183', '73', '172', '63', '165', '76', '184', '74', '170', '61', '167', '80', '175', '145', '146', '83', '177', '68', '189', '51', '179', '69', '186', '75', '65', '174', '155', '50', '142', '180', '60', '70', '171', '62', '37', '81', '86', '158', '178', '157', '54', '187', '109', '124', '159', '161', '91', '107', '116', '117', '188', '190', '93', '108', '57', '95', '195', '118', '119', '36', '198') 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 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 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 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 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, gallery from `ecom_products` where `display` = 1 and `cancelled` = 0 and `price_ttc` > 0 and `ecom_stores_id` = 1 and `id` in (482, 503, 497, 561, 580, 562, 581, 576, 564, 568, 571, 560, 577, 578, 565, 570, 572, 579, 566, 483, 484, 485, 505, 492)

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 `id`, `extension_image`, `sku`, `price_ttc`, `price_shelf`, `version`, `stock_quantity`, `family_group_id`, `cms_attributes`, `ecom_products_tags_id`, `ecom_stores_id`, `ecom_subcategories_id`, `slug`, `digital_product`, `ecom_products_giftcards_id`, `keywords`, `preorder_available`, `ecom_vendors_id`, `ecom_products_brands_id`, `family_group_id`, COALESCE(discount,0) as discount, 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, gallery from `ecom_products` where `price_ttc` > 0 and `display` = 1 and `cancelled` = 0 and `family_group_id` in ('6601246dcb9c1', '6679467d64ea5', '6628f527465ce', '6834b468a423a', '6835dff8e011a', '6834bf4166de4', '6835e1c2d70ce', '6835d95c941c4', '6835b47926aa6', '6835bf2192ae3', '6835cb989cb48', '6834ae0b09cf8', '6835db274349c', '6835dc94b087c', '6835b86412033', '6835ca445fee9', '6835cd1bda6bc', '6835de506319b', '6835ba083a003', '6601277dc2c1a', '66012bf10eab2', '66012e2c2d8f9', '667948ce16b98', '6628a11118978') and `ecom_stores_id` = 1 order by `family_group_id` asc, `orders` asc

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

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