Allowed memory size of 134217728 bytes exhausted (tried to allocate 11984896 bytes)
select * from `00_cms_seo_settings` where `cancelled` = 0 order by `orders` asc limit 1select * from `00_cms_seo_by_route` where `cancelled` = 0 order by CHAR_LENGTH(`route`) DESCselect *, header_message_en AS header_message, label_en AS label from `ecom_stores` where `web_prefix` = 'lb' and `cancelled` = 0 and `published` = 1 limit 1select *, 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 1select * from `ecom_currencies` where `id` in ('1', '149')select * from `ecom_products_collections` where `slug` = 'shop-square-size' and `ecom_stores_id` LIKE '%"1"%' and `display` = 1 and `cancelled` = 0 limit 1select * from `ecom_products_collections` where `id` = 23 limit 1select 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 = schema() and table_name = 'ecom_products' order by ordinal_position ascselect 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 = schema() and table_name = 'ecom_products' order by ordinal_position ascselect 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 = schema() and table_name = 'ecom_products' order by ordinal_position ascselect 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 = schema() and table_name = 'ecom_products' order by ordinal_position ascSET SESSION group_concat_max_len = 99999999999select `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 (`keywords` LIKE '%"16"%') and `ecom_products_filters_id` is not null group by 'all' limit 1select `label_en`, `id` from `ecom_products_filters` where 0 = 1select `id`, `version`, `cms_attributes`, label_en AS label, group_en AS `group` from `ecom_products_filters` where `cancelled` = 0 and `id` in (1, 3, 4, 69, 5, 6, 7, 8, 13) and (`cms_attributes` is null or `cms_attributes` NOT LIKE '%"frontend_menus_filter":true%') order by `orders` ascSET SESSION group_concat_max_len = 99999999999select `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 (`keywords` LIKE '%"16"%') and `ecom_products_filters_id` is not null group by 'all' limit 1select `label_en`, `id` from `ecom_products_filters` where 0 = 1select `id`, `version`, `cms_attributes`, label_en AS label, group_en AS `group` from `ecom_products_filters` where `cancelled` = 0 and `id` in (1, 3, 4, 69, 5, 6, 7, 8, 13) and `cms_attributes` LIKE '%"frontend_menus_filter":true%' order by `orders` ascselect `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`, (price_ttc - price_ttc * (COALESCE(discount,0) + 0) / 100) AS price, CONCAT("/lb/en/product/",slug) AS link, CONCAT(family_group_id,'%_%',JSON_EXTRACT(variations,'$."1"')) AS family_group_id from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0 and (`keywords` LIKE '%"16"%')select * from `ecom_products_brands` where `id` in (1)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`, (price_ttc - price_ttc * (COALESCE(discount,0) + 0) / 100) AS price, CONCAT("/lb/en/product/",slug) AS link, CONCAT(family_group_id,'%_%',JSON_EXTRACT(variations,'$."1"')) AS family_group_id, MIN(price_ttc) AS min_price, MAX(price_ttc) AS max_price from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0 and (`keywords` LIKE '%"16"%') limit 1select `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` = 0select `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 (`keywords` LIKE '%"16"%') group by CONCAT(family_group_id,'%_%',JSON_EXTRACT(variations,'$."1"'))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`, (price_ttc - price_ttc * (COALESCE(discount,0) + 0) / 100) AS price, CONCAT("/lb/en/product/",slug) AS link, CONCAT(family_group_id,'%_%',JSON_EXTRACT(variations,'$."1"')) AS family_group_id from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0 and (`keywords` LIKE '%"16"%') group by CONCAT(family_group_id,'%_%',JSON_EXTRACT(variations,'$."1"'))) 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`, (price_ttc - price_ttc * (COALESCE(discount,0) + 0) / 100) AS price, CONCAT("/lb/en/product/",slug) AS link, CONCAT(family_group_id,'%_%',JSON_EXTRACT(variations,'$."1"')) AS family_group_id from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0 and (`keywords` LIKE '%"16"%') group by CONCAT(family_group_id,'%_%',JSON_EXTRACT(variations,'$."1"')) order by `orders` asc limit 24 offset 0select * from `ecom_keywords` where `cancelled` = 0{
"store_prefix": "lb",
"language_prefix": "en",
"slug": "shop-square-size"
}