107.173.224.127

cloudflare; loops=1

https

{"scheme":"https"}

107.173.224.127

946c22f7ae912f1a-LAX

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

XSRF-TOKEN=eyJpdiI6ImdwRDFJVUlWRVJQNnE2THc1QU5BaXc9PSIsInZhbHVlIjoiRnF2T1FzVDhKL1NzOGkxQ1E5QWIremtRYjJxU1B5bnlxeWxDaU81UzBhdHlvbDlSVFFMdHQ5Snc0UXFQNzNwNDZxTnJabU1xaUsxZmJlajh5cU4vYnBxZE5uQ3pJMGUwL25sODdhMnJVT05NMjJNb2sreDdQeTJQMmVsZVBaRnRha2dJcWpralZSZk1QZ0N6dmQ3K2kzY245UGIrVy9uY0lacm80Y0NOMmJ2ajQzYmUzdTgxV05PR3Z3U09MaFdiRjZZS1cyUnl0dm9IV0JvbVBKTUQxR1BHbmU0Q2N2dlFuK01VSDFDUjFDZi91bGp5a2xRNlRFSHlwN3lsZ0pUZkhoVkRoemUvV0dJS2tNbVhKZFRMaWtsTmFFWEZTTEVDZTlxbHNHSnJKU1M5d0hqRGdLY2p3a1RKWnVyMlEvR1Y1QnpJZk5hZCtpNDZQakdsdU5vaUlkOTJBSFB4UklRYUtPeTNsRFE5ZkhRcFpUbUl4RTRsemIzYk9sVjd4U3Z3aWRmQmZkTTFoenRqUGk3d2QrNTNmNE11c2g1bVJiVnFudXd4NjZoZFM3WEV3Z2h2UDl2U2k0TUI1TG9Fb3Zub0NpdXlBVU9GMXliK3IybVQxVmN2YVBIYS91TXVZa3UwVk1NaWo5ZTdzcGJoNzdOZTE5NHhJSU5RbFFsTFVlUUQiLCJtYWMiOiI3YThlNjZlOGI2YWM5NDgyNTI2ZDQ5ZjQ3OWNmNjc2NDAwNjdjMzJmZTdlMTgyYzllZWJjY2M3OGEzYmJmNGQ4IiwidGFnIjoiIn0%3D; offlineToken_v2=t_5697215a72f00f31e5d081236a408ddd; the_loft_session=eyJpdiI6ImlEb2JWRHJTUkZyWGVpbFBUSnhjbkE9PSIsInZhbHVlIjoiaEpvQkZPN1R4MDJkb25SVnNWN1hlamVQQ1M4TDREMVFiMDV4eTYvT05kN0J4bFNMSkdaOGxqVXRDK2o4S20vUjBjU25HcmxyYUFxL05vZTBFdWN0Sm1GV003SEJ3WnVTN1F0TGhJcE91N2dMNENKZFZDMFJNK3dxVjJKdDE3QUoiLCJtYWMiOiIyMTE1M2JiZmVkNWI0NzMxMDc2YjhiZTc4N2YzOTE5YmRhOTM5ZTIzMTJhYzA4MmFkMzFlNmU4ZjI3ODRiOGMyIiwidGFnIjoiIn0%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/shampoo' 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` = 'shampoo' 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, 37, 66) order by CASE id WHEN 2 THEN 0 WHEN 37 THEN 1 WHEN 66 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