Query time 0.00285
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "33.80"
},
"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": "5K"
},
"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",
"buy_now_url",
"facebook_obj_type",
"package",
"price_rules_options",
"price_rule",
"package_form",
"cp_pp_number_of_columns",
"show_popularity",
"show_viewed",
"show_added",
"show_deleted",
"show_bought",
"show_total",
"popularity_view",
"show_popularity_header",
"show_orders",
"orders_view",
"show_orders_header",
"show_orders_items",
"show_only_total_popularity",
"show_only_total_orders",
"global_popularity",
"total_plus",
"global_total_plus",
"ab__stickers_manual_ids",
"ab__stickers_generated_ids"
]
}
},
{
"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_product_prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "product_id",
"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": "24"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
],
"attached_condition": "<if>(is_not_null_compl(cscart_product_prices), ((`eshopuga_upgr_4122`.`cscart_product_prices`.`lower_limit` = 1) and (`eshopuga_upgr_4122`.`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": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "1.40",
"data_read_per_join": "3K"
},
"used_columns": [
"product_id",
"lang_code",
"product",
"shortname",
"short_description",
"full_description",
"meta_keywords",
"meta_description",
"search_words",
"page_title",
"age_warning_message",
"promo_text",
"stop_words"
]
}
},
{
"table": {
"table_name": "shared_prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"company_id",
"lower_limit",
"usergroup_id"
],
"key": "product_id",
"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": "2.60",
"data_read_per_join": "32"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"company_id",
"usergroup_id"
],
"attached_condition": "<if>(is_not_null_compl(shared_prices), ((`eshopuga_upgr_4122`.`shared_prices`.`lower_limit` = 1) and (`eshopuga_upgr_4122`.`shared_prices`.`company_id` = 1) and (`eshopuga_upgr_4122`.`shared_prices`.`usergroup_id` in (0,0,1))), true)"
}
},
{
"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": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "2.80",
"data_read_per_join": "5K"
},
"used_columns": [
"company_id",
"status",
"company"
],
"attached_condition": "<if>(found_match(companies), ((`eshopuga_upgr_4122`.`companies`.`status` = 'A') or 0), true)"
}
},
{
"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": 20,
"rows_produced_per_join": 20,
"filtered": "100.00",
"cost_info": {
"read_cost": "20.00",
"eval_cost": "4.00",
"prefix_cost": "26.80",
"data_read_per_join": "320"
},
"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": [
"eshopuga_upgr_4122.cscart_products_categories.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "5.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "30.80",
"data_read_per_join": "2K"
},
"used_columns": [
"category_id",
"company_id",
"usergroup_ids",
"status"
],
"attached_condition": "((`eshopuga_upgr_4122`.`cscart_categories`.`company_id` = 1) and ((`eshopuga_upgr_4122`.`cscart_categories`.`usergroup_ids` = '') or find_in_set(0,`eshopuga_upgr_4122`.`cscart_categories`.`usergroup_ids`) or find_in_set(1,`eshopuga_upgr_4122`.`cscart_categories`.`usergroup_ids`)) and (`eshopuga_upgr_4122`.`cscart_categories`.`status` in ('A','H')))"
}
},
{
"table": {
"table_name": "cscart_seo_names",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code",
"company_id"
],
"key_length": "210",
"ref": [
"const",
"const",
"const",
"const",
"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": "31.00",
"data_read_per_join": "1K"
},
"used_columns": [
"name",
"object_id",
"company_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
},
{
"table": {
"table_name": "point_prices",
"access_type": "range",
"possible_keys": [
"unique_key",
"src_k"
],
"key": "src_k",
"used_key_parts": [
"product_id",
"lower_limit",
"usergroup_id"
],
"key_length": "8",
"rows_examined_per_scan": 2,
"rows_produced_per_join": 2,
"filtered": "100.00",
"using_join_buffer": "Block Nested Loop",
"cost_info": {
"read_cost": "2.00",
"eval_cost": "0.40",
"prefix_cost": "33.40",
"data_read_per_join": "48"
},
"used_columns": [
"product_id",
"point_price",
"lower_limit",
"usergroup_id"
],
"attached_condition": "(<if>(found_match(point_prices), 1, true) and <if>(is_not_null_compl(point_prices), ((`eshopuga_upgr_4122`.`point_prices`.`lower_limit` = 1) and (`eshopuga_upgr_4122`.`point_prices`.`product_id` = 1974) and (`eshopuga_upgr_4122`.`point_prices`.`usergroup_id` in (0,0,1))), true))"
}
},
{
"table": {
"table_name": "cscart_discussion",
"access_type": "const",
"possible_keys": [
"object_id",
"company_id"
],
"key": "object_id",
"used_key_parts": [
"object_id",
"object_type",
"company_id"
],
"key_length": "10",
"ref": [
"const",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 2,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.40",
"prefix_cost": "33.80",
"data_read_per_join": "48"
},
"used_columns": [
"object_id",
"object_type",
"type",
"company_id"
]
}
}
]
}
}
}
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 |
buy_now_url |
facebook_obj_type |
package |
price_rules_options |
price_rule |
package_form |
cp_pp_number_of_columns |
show_popularity |
show_viewed |
show_added |
show_deleted |
show_bought |
show_total |
popularity_view |
show_popularity_header |
show_orders |
orders_view |
show_orders_header |
show_orders_items |
show_only_total_popularity |
show_only_total_orders |
global_popularity |
total_plus |
global_total_plus |
ab__stickers_manual_ids |
ab__stickers_generated_ids |
lang_code |
product |
shortname |
short_description |
full_description |
meta_keywords |
meta_description |
search_words |
page_title |
age_warning_message |
promo_text |
stop_words |
price |
category_ids |
popularity |
company_name |
sales_amount |
seo_name |
seo_path |
point_price |
discussion_type |
| 1974 |
ESVS0018A |
P |
A |
1 |
0.00 |
1000 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1457086906 |
1626432458 |
0 |
N |
N |
N |
B |
N |
R |
Y |
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 |
N |
N |
F |
N |
0 |
N |
Y |
Y |
Y |
Y |
Y |
L |
Y |
N |
L |
Y |
|
Y |
Y |
N |
0 |
0 |
9 |
|
de |
Sweet Bouquet in Vase |
|
<p>DETAILS: You won't have to say a word - the elegant sophistication of these gorgeous roses will get your message across.</p>
<p>DELIVERY: Deliveries are normally made between 8am and 7pm - (Mon to Sun). However, during busy periods, these delivery times may differ slightly, and we reserve the right to deliver between 7am and 7pm East African Time (+3GMT). Our florist delivered flowers and arrangements are personally hand delivered by our local florists. Vase are for the purpose of photographs only but can be purchased separately where necessary</p>
<p>CONTENT: All of our flowers, bouquets and arrangements are individually crafted from the freshest blooms. While we always strive to ensure that products are accurately represented in our photographs, from season to season and subject to availability, our florists may be required to substitute one or more flowers for a variety of equal or greater quality, appearance and value. </p> |
<p>DETAILS: You won't have to say a word - the elegant sophistication of these gorgeous roses will get your message across.</p>
<p>DELIVERY: Deliveries are normally made between 8am and 7pm - (Mon to Sun). However, during busy periods, these delivery times may differ slightly, and we reserve the right to deliver between 7am and 7pm East African Time (+3GMT). Our florist delivered flowers and arrangements are personally hand delivered by our local florists. Vase are for the purpose of photographs only but can be purchased separately where necessary</p>
<p>CONTENT: All of our flowers, bouquets and arrangements are individually crafted from the freshest blooms. While we always strive to ensure that products are accurately represented in our photographs, from season to season and subject to availability, our florists may be required to substitute one or more flowers for a variety of equal or greater quality, appearance and value. </p> |
|
|
|
|
|
<p><b>WE OFFER NO-QUIBBLE GUARANTEE!</b></p>
<p>You can order with confidence thanks to our quality guarantees. We take great care and pride in packing all our flower and plant gifts and provide a 7 day freshness guarantee for your peace of mind. But we're human and understand that things don’t always work out as expected - our no quibble guarantee means that we will make things right for you without any hassle.</p> |
|
23.000000 |
361M,337,338,339,340,349,350,352,359,360,362,363,368,369,370,379,381 |
21954 |
eshopuganda |
|
sweet-bouquet-in-vase |
329/361 |
|
B |