Query time 0.00196
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.74"
},
"grouping_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "cscart_products",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"status"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "7K"
},
"used_columns": [
"product_id",
"product_code",
"product_type",
"status",
"company_id",
"list_price",
"amount",
"weight",
"length",
"width",
"height",
"shipping_freight",
"low_avail_limit",
"timestamp",
"updated_timestamp",
"usergroup_ids",
"is_edp",
"edp_shipping",
"unlimited_download",
"tracking",
"free_shipping",
"zero_price_action",
"is_pbp",
"is_op",
"is_oper",
"is_returnable",
"return_period",
"avail_since",
"out_of_stock_actions",
"localization",
"min_qty",
"max_qty",
"qty_step",
"list_qty_count",
"tax_ids",
"age_verification",
"age_limit",
"options_type",
"exceptions_type",
"details_layout",
"shipping_params",
"facebook_obj_type",
"parent_product_id",
"buy_now_url",
"master_product_id",
"master_product_status",
"master_product_offers_count",
"prestashop_product_id",
"prestashop_account_id",
"prestashop_is_parent",
"amz_condition",
"amz_condition_note",
"amz_product_id",
"amz_product_id_type",
"transfer_price",
"tax_value",
"ebay_template_id",
"product_hash",
"ebay_price",
"package_type",
"ebay_status",
"ebay_override_price",
"subscription_product",
"interval",
"interval_count",
"ec_rfq_product_type",
"ec_rfq_service_options"
]
}
},
{
"table": {
"table_name": "popularity",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"total"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "32"
},
"used_columns": [
"product_id",
"total"
]
}
},
{
"table": {
"table_name": "cscart_product_sales",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"pa"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id",
"product_id"
],
"key_length": "6",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"unique_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "16"
},
"used_columns": [
"category_id",
"product_id",
"amount"
]
}
},
{
"table": {
"table_name": "cscart_products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "pt",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.00",
"eval_cost": "0.20",
"prefix_cost": "1.20",
"data_read_per_join": "16"
},
"used_columns": [
"product_id",
"category_id",
"link_type",
"category_position"
]
}
},
{
"table": {
"table_name": "cscart_categories",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"webmarco.cscart_products_categories.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "5.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.01",
"prefix_cost": "1.40",
"data_read_per_join": "303"
},
"used_columns": [
"category_id",
"usergroup_ids",
"status",
"storefront_id"
],
"attached_condition": "((`webmarco`.`cscart_categories`.`storefront_id` in (0,1)) and ((`webmarco`.`cscart_categories`.`usergroup_ids` = '') or find_in_set(0,`webmarco`.`cscart_categories`.`usergroup_ids`) or find_in_set(1,`webmarco`.`cscart_categories`.`usergroup_ids`)) and (`webmarco`.`cscart_categories`.`status` in ('A','H')))"
}
},
{
"table": {
"table_name": "cscart_product_prices",
"access_type": "range",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "usergroup",
"used_key_parts": [
"product_id",
"usergroup_id",
"lower_limit"
],
"key_length": "9",
"rows_examined_per_scan": 2,
"rows_produced_per_join": 0,
"filtered": "100.00",
"using_join_buffer": "Block Nested Loop",
"cost_info": {
"read_cost": "0.10",
"eval_cost": "0.02",
"prefix_cost": "1.52",
"data_read_per_join": "6"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
],
"attached_condition": "(<if>(found_match(cscart_product_prices), 1, true) and <if>(is_not_null_compl(cscart_product_prices), ((`webmarco`.`cscart_product_prices`.`lower_limit` = 1) and (`webmarco`.`cscart_product_prices`.`product_id` = 285791) and (`webmarco`.`cscart_product_prices`.`usergroup_id` in (0,0,1))), true))"
}
},
{
"table": {
"table_name": "cscart_product_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"lang_code"
],
"key_length": "9",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.02",
"prefix_cost": "1.54",
"data_read_per_join": "699"
},
"used_columns": [
"product_id",
"lang_code",
"product",
"shortname",
"ab__spt_short_name",
"short_description",
"full_description",
"meta_keywords",
"meta_description",
"search_words",
"page_title",
"age_warning_message",
"promo_text",
"ab__custom_product_h1",
"ebay_title",
"ebay_description",
"override",
"cls_stop_words",
"ec_rfq_request_btn_text"
]
}
},
{
"table": {
"table_name": "companies",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id"
],
"key_length": "4",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.02",
"prefix_cost": "1.56",
"data_read_per_join": "975"
},
"used_columns": [
"company_id",
"status",
"company",
"ec_rfq_whatsapp_number",
"ec_rfq_phone_number",
"ec_rfq_bhf",
"ec_rfq_bht"
],
"attached_condition": "<if>(found_match(companies), ((`webmarco`.`companies`.`status` = 'A') or 0), true)"
}
},
{
"table": {
"table_name": "cscart_seo_names",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code"
],
"key_length": "206",
"ref": [
"const",
"const",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.10",
"eval_cost": "0.02",
"prefix_cost": "1.68",
"data_read_per_join": "173"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
},
{
"table": {
"table_name": "cscart_discussion",
"access_type": "const",
"possible_keys": [
"object_id"
],
"key": "object_id",
"used_key_parts": [
"object_id",
"object_type"
],
"key_length": "6",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.02",
"prefix_cost": "1.70",
"data_read_per_join": "2"
},
"used_columns": [
"object_id",
"object_type",
"type"
]
}
},
{
"table": {
"table_name": "cscart_product_review_prepared_data",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"storefront_id"
],
"key_length": "7",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.02",
"prefix_cost": "1.72",
"data_read_per_join": "1"
},
"used_columns": [
"product_id",
"storefront_id",
"average_rating",
"reviews_count"
]
}
},
{
"table": {
"table_name": "cscart_ec_table_booking_system",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "4",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.02",
"prefix_cost": "1.74",
"data_read_per_join": "17"
},
"used_columns": [
"product_id",
"booking_type",
"quantity_selector",
"show_price_date",
"blocked_date",
"from_date",
"to_date",
"slot_time",
"free_time",
"days_data",
"minimum_booking_time"
],
"attached_condition": "<if>(is_not_null_compl(cscart_ec_table_booking_system), <cache>((285791 = 285791)), true)"
}
}
]
}
}
}
Result
| product_id |
product_code |
product_type |
status |
company_id |
list_price |
amount |
weight |
length |
width |
height |
shipping_freight |
low_avail_limit |
timestamp |
updated_timestamp |
usergroup_ids |
is_edp |
edp_shipping |
unlimited_download |
tracking |
free_shipping |
zero_price_action |
is_pbp |
is_op |
is_oper |
is_returnable |
return_period |
avail_since |
out_of_stock_actions |
localization |
min_qty |
max_qty |
qty_step |
list_qty_count |
tax_ids |
age_verification |
age_limit |
options_type |
exceptions_type |
details_layout |
shipping_params |
facebook_obj_type |
parent_product_id |
buy_now_url |
master_product_id |
master_product_status |
master_product_offers_count |
prestashop_product_id |
prestashop_account_id |
prestashop_is_parent |
amz_condition |
amz_condition_note |
amz_product_id |
amz_product_id_type |
transfer_price |
tax_value |
ebay_template_id |
product_hash |
ebay_price |
package_type |
ebay_status |
ebay_override_price |
subscription_product |
interval |
interval_count |
ec_rfq_product_type |
ec_rfq_service_options |
lang_code |
product |
shortname |
ab__spt_short_name |
short_description |
full_description |
meta_keywords |
meta_description |
search_words |
page_title |
age_warning_message |
promo_text |
ab__custom_product_h1 |
ebay_title |
ebay_description |
override |
cls_stop_words |
ec_rfq_request_btn_text |
price |
category_ids |
popularity |
company_name |
ec_rfq_whatsapp_number |
ec_rfq_phone_number |
ec_rfq_bhf |
ec_rfq_bht |
sales_amount |
seo_name |
seo_path |
discussion_type |
average_rating |
product_reviews_count |
booking_type |
from_date |
to_date |
slot_time |
free_time |
days_data |
quantity_selector |
show_price_date |
blocked_date |
minimum_booking_time |
| 285791 |
5212007104338 |
P |
A |
379 |
0.00 |
1 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1656668091 |
1698088902 |
0 |
N |
N |
N |
B |
N |
R |
N |
N |
N |
Y |
10 |
0 |
N |
|
0 |
0 |
0 |
0 |
|
N |
0 |
P |
F |
default |
a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} |
activity |
0 |
|
0 |
A |
0 |
0 |
0 |
Y |
|
|
|
|
0.00 |
0.00 |
0 |
3186029198 |
|
Letter |
|
N |
N |
day |
|
P |
|
en |
To Filema Tis Lelas Peach Balsamic Vinegar Dressing 250gr |
|
|
<p>Balsamic Vinegar Dressing with peach flavour.<br />It has sweet and sour flavour, rich creamy texture and wonderful aroma based on balsamic vinegar, concentrated must and natural fruit juice.<br />This extremely tasty dressing contains 28% natural peach juice.<br />Handmade sweet and sour dressing.<br />100% from Greek fresh raw materials.<br />100% Natural product, suitable for vegetarians and vegans.<br />Gluten free, no preservatives, no dyes, no artificial flavors.</p> |
<p style="color:#000000;font-size:18px;"><strong>DESCRIPTION</strong></p>
<p style="color:#000000;font-size:16px;">Balsamic Vinegar Dressing with peach flavour. <br /> It has sweet and sour flavour, rich creamy texture and wonderful aroma based on balsamic vinegar, concentrated must and natural fruit juice. <br /> This extremely tasty dressing contains 28% natural peach juice. <br /> Handmade sweet and sour dressing.<br /> 100% from Greek fresh raw materials.<br /> 100% Natural product, suitable for vegetarians and vegans.<br /> Gluten free, no preservatives, no dyes, no artificial flavors.</p>
<p> </p>
<p style="color:#000000;font-size:16px;"><strong>SERVING SUGGESTIONS:</strong> Served on top of ice cream , yogurt, panna cotta, cheesecake are just some of the options that will balance the sweetness, while for the more daring try it in summer coctails. It is an ideal choice also to enhance the taste of food and salads.</p>
<p> </p>
<p style="color:#000000;font-size:16px;"><strong>INGREDIENTS: </strong> White Balsamic vinegar (white wine vinegar 33%, concentrated grape must), peach vinegar, natural peach juice 28%, sugar, modified starch, natural peach flavoring. <br />
May contain supphites. </p>
<p> </p>
<p style="color:#000000;font-size:16px;"> Keep in a cool and shady place. <br />
After opening, keep in the refrigerator. </p> |
wine, risertrade, webmarco, handmade, balsamic, vinegar cream, greek, natural product, vegetarians, vegans, sweet, sour, creamy, aroma, natural fruit, juice, gluten, preservatives, dyes, artificial fragrances, shady, refrigerator |
Handmade balsamic vinegar cream with 28% natural peach juice .
100% from Greek raw materials.
Natural product, suitable for vegetarians and vegans.
With sweet and sour taste. Rich creamy texture and wonderful aroma based on balsamic vinegar, concentrat |
wine, risertrade, webmarco, handmade, balsamic, vinegar cream, greek, natural product, vegetarians, vegans, sweet, sour, creamy, aroma, natural fruit, juice, gluten, preservatives, dyes, artificial fragrances, shady, refrigerator |
To Filema Tis Lelas Dressing Βαλσάμικο Ροδάκινο 250ml |
|
|
|
|
|
N |
|
|
3.20000000 |
3535M |
7454 |
Riser Trade Co Ltd |
|
|
|
|
|
to-filema-tis-lelas-dressing-balsamiko-rodakino-250ml |
3532/3535 |
B |
|
|
|
|
|
|
|
|
|
|
|
|