LV

83.99.151.68

cloudflare; loops=1

shopwithabc.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

94f1ff765c16b80a-RIX

83.99.151.68

web, twa\ecomgeneral\middleware\EcomLanguageMiddleware, 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` = 'lb' 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')

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

insert into `ecom_users_temporary` (`token`, `cart`, `ip`, `updated_at`, `created_at`) values ('t_d8b4612ab42bd7bc1fd1a3617dcfe10d', '"[]"', '83.99.151.68', '2025-06-13 13:40:06', '2025-06-13 13:40:06')

select * from `00_cms_cache` where `url` = '/lb/en/product/barbie-mysteries-the-great-horse-chase-interactive-toy-horse-with-sounds' and `request_signature` = '71432c69dbbcaf4675adf00161b40a68' 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 = 'shopwithabccom_67f68d6bb1758_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 = 'shopwithabccom_67f68d6bb1758_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 = 'shopwithabccom_67f68d6bb1758_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 = 'shopwithabccom_67f68d6bb1758_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("/lb/en/product/",slug) AS link from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `slug` = 'barbie-mysteries-the-great-horse-chase-interactive-toy-horse-with-sounds'

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 `slug` = 'barbie-mysteries-the-great-horse-chase-interactive-toy-horse-with-sounds' 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 ('274') and (`cms_attributes` is null or `cms_attributes` NOT LIKE '%"frontend_menus_filter":true%') order by `orders` asc

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 `slug` = 'barbie-mysteries-the-great-horse-chase-interactive-toy-horse-with-sounds'

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 `slug` = 'barbie-mysteries-the-great-horse-chase-interactive-toy-horse-with-sounds'

select `ecom_products_brands_id` from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `slug` = 'barbie-mysteries-the-great-horse-chase-interactive-toy-horse-with-sounds'

select `ecom_products_categories_id` from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `slug` = 'barbie-mysteries-the-great-horse-chase-interactive-toy-horse-with-sounds' group by COALESCE(family_group_id,id) order by CASE WHEN stock_quantity > 0 THEN 0 ELSE 1 END, `id` desc

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("/lb/en/product/",slug) AS link from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `slug` = 'barbie-mysteries-the-great-horse-chase-interactive-toy-horse-with-sounds' 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("/lb/en/product/",slug) AS link from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `slug` = 'barbie-mysteries-the-great-horse-chase-interactive-toy-horse-with-sounds' group by COALESCE(family_group_id,id) order by CASE WHEN stock_quantity > 0 THEN 0 ELSE 1 END, `id` desc limit 48 offset 0

select *, CONCAT("/lb/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 (13947)

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 = 'shopwithabccom_67f68d6bb1758_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 = 'shopwithabccom_67f68d6bb1758_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` = 'left top menu' and `ecom_stores_id` LIKE '%"1"%' and `cancelled` = 0 limit 1

select *, label_en AS label, link_en AS link, CONCAT('https://abc.heyacdn.com/abc.com.lb/public/data/front_end_menus/', id , '.', extension_image,'34v=' , 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 * from `ecom_products` where `id` = 13947 and `cancelled` = 0 limit 1

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 '%"45"%' or `keywords` LIKE '%"46"%')

select * from `ecom_products_load_adjusters` where `ecom_stores_id` = 1 and (`ecom_products_id` LIKE '%"13947"%' or `ecom_keywords_id` LIKE '%"45"%' or `ecom_keywords_id` LIKE '%"46"%' or `ecom_subcategories_id` LIKE '%""%') and `cancelled` = 0

select exists (select 1 from information_schema.tables where table_schema = 'shopwithabccom_67f68d6bb1758_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 = 'shopwithabccom_67f68d6bb1758_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` = 13947) and `ecom_products_id` != 13947 order by `created_at` desc limit 100

select * from `ecom_products_recommendations` where (`ecom_keywords_id` LIKE '%"45"%' or `ecom_keywords_id` LIKE '%"46"%' or `ecom_subcategories_id` LIKE '%""%' or `ecom_subcategories_id` LIKE '%"309"%' or `ecom_subcategories_id` LIKE '%"307"%' or `ecom_subcategories_id` LIKE '%"251"%' or `ecom_products_id` LIKE '%"13947"%') and `ecom_stores_id` LIKE '%"1"%' and `cancelled` = 0

select * from `ecom_products_info` where ((`product_family_group_id` is null and `product_sku` = 'TE52352') or (`product_family_group_id` = 'TE52352' and `product_sku` is null)) and `display` = 1 and `cancelled` = 0 order by `product_family_group_id` desc, `sort_index` asc

select * from `ecom_products_out_of_stock_behavior` where (`ecom_keywords_id` LIKE '%"45"%' or `ecom_keywords_id` LIKE '%"46"%' or `ecom_subcategories_id` LIKE '%""%' or `ecom_products_id` LIKE '%"13947"%') and `ecom_stores_id` = 1 and `cancelled` = 0 order by type = "preorder" DESC limit 1

select * from `00_cms_structure_entities` where `main_table` = 'ecom_products_box_ingredients' and `cancelled` = 0 limit 1

select * from `00_cms_structure_entities` where `id` = 376 and `cancelled` = 0 limit 1

select * from `00_cms_structure_entities_fields` where `cms_structure_entities_id` = 'd3b79d02-feba-11ec-a4a5-42010a960004' and `cancelled` = 0

select * from `ecom_products_box_ingredients` where `cancelled` = 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 = 'shopwithabccom_67f68d6bb1758_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 = 'shopwithabccom_67f68d6bb1758_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 = 'shopwithabccom_67f68d6bb1758_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 = 'shopwithabccom_67f68d6bb1758_db_live' and table_name = 'ecom_products' order by ordinal_position 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

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 CASE WHEN stock_quantity > 0 THEN 0 ELSE 1 END, `id` desc

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("/lb/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("/lb/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 CASE WHEN stock_quantity > 0 THEN 0 ELSE 1 END, `id` desc limit 48 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 = 'shopwithabccom_67f68d6bb1758_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 = 'shopwithabccom_67f68d6bb1758_db_live' and table_name = 'ecom_products' order by ordinal_position asc

select `id`, `ecom_products_categories_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("/lb/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 (37053, 37052, 37051, 37050, 37049, 37048, 37047, 37045, 37044, 37043, 37042, 37041, 37040, 37039, 37038, 37037, 37036, 36984, 36983, 36981, 36966, 36941, 36931, 36921, 36906, 36886, 36876, 36866, 36861, 36856, 36836, 36821, 36806, 36796, 36776, 36771, 36766, 36751, 36741, 36672, 36671, 36670, 36669, 36668, 36667, 36666, 36665, 36663)

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 = 'shopwithabccom_67f68d6bb1758_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 = 'shopwithabccom_67f68d6bb1758_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` = 'left top menu' and `ecom_stores_id` LIKE '%"1"%' and `cancelled` = 0 limit 1

select *, label_en AS label, link_en AS link, CONCAT('https://abc.heyacdn.com/abc.com.lb/public/data/front_end_menus/', id , '.', extension_image,'34v=' , version) AS image from `00_cms_utilities_frontend_menus_links` where `00_cms_utilities_frontend_menus_id` = 0 and `cancelled` = ?

select `id`, `ecom_products_categories_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("/lb/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 from `ecom_products` where `price_ttc` > 0 and `display` = 1 and `cancelled` = 0 and `family_group_id` in ('MT0046/720', 'MT0031/720', 'MT0039/720', 'MT3838/860', 'MT0046/860', 'MT0039/860', 'BLACK4600', 'EH717642', 'EH478853', 'EH476353', 'EH476253', 'EH476153', 'PELLE7514', 'EH028853', 'EH026353', 'EH026253', 'EH026153', 'AAAC', 'AAAB', 'ZZZ', 'PS25MTS09', 'PS25MTS08', 'PS25MTS05', 'PS25MTS03', 'PS25MTS02', 'PS25MTS01', 'PS25MPL03', 'PS25MPL02', 'PS25MBM09', 'PS25MBM08', 'PS25MBM05', 'PS25MBM04', 'PS25MBM03', 'PS25MBM02', 'PS25MBM01', 'PS25MBL04', 'PS25MBL03', 'PS25MBL02', 'PS25MBL01', '9354181', '9354149', '9354148', '9354147', '9359559', '9352096', '9313287', '9313286', '9354415') 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 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