Query time 0.00137
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "2.40"
},
"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",
"status",
"company_id",
"amount",
"weight",
"shipping_freight",
"updated_timestamp",
"usergroup_ids",
"is_edp",
"edp_shipping",
"tracking",
"free_shipping",
"zero_price_action",
"out_of_stock_actions",
"min_qty",
"max_qty",
"qty_step",
"list_qty_count",
"tax_ids",
"shipping_params"
]
}
},
{
"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": "0.00",
"data_read_per_join": "6K"
},
"used_columns": [
"product_id",
"lang_code",
"product",
"short_description"
]
}
},
{
"table": {
"table_name": "cscart_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": "0.00",
"data_read_per_join": "9K"
},
"used_columns": [
"company_id",
"status"
]
}
},
{
"table": {
"table_name": "cscart_company_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id",
"lang_code"
],
"key_length": "10",
"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": "0.00",
"data_read_per_join": "3K"
},
"used_columns": [
"company_id",
"lang_code",
"i18n_company"
]
}
},
{
"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",
"using_index": true,
"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"
]
}
},
{
"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": "1.00",
"eval_cost": "0.01",
"prefix_cost": "2.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')))"
}
}
]
}
}
}
Result
| product_id |
company_id |
category_ids |
product_code |
weight |
tracking |
product |
short_description |
is_edp |
edp_shipping |
shipping_freight |
free_shipping |
zero_price_action |
tax_ids |
qty_step |
list_qty_count |
max_qty |
min_qty |
in_stock |
shipping_params |
company_status |
out_of_stock_actions |
updated_timestamp |
company_name |
| 282471 |
575 |
4254M |
WM3191CF |
0.000 |
B |
Colostrum Liquid 125ml |
<p><em>The most frequently asked questions<br />What is pasture?<br />Pasture, also called first milk, is particularly valuable for the cow's calf because of its unique nutritional values. For Colostrum LR products we use only cow pasture from Germany and Austria and only from quality farms in milk production.<br />What happens to the calves?<br />The cow produces more pasture than the calf needs. Only the extra amount is used for the production of Colostrum products.<br />How is Colostrum produced by LR?<br />LR uses only the pasture of the first hours after the birth of the calf. In these hours the quality and density are at the highest levels.<br />Pasture for the production of Colostrum Liquid is raised immediately after harvesting. For further processing, the fat is delicately removed from the pasture and sterilized. Delicate ingredients are very sensitive to heat. For this reason, LR prefers the cold processing method, through which the ingredients are optimally preserved.</em></p>
<p><em>Why does Colostrum Liquid sometimes show differences in color and clarity?<br />It is important to know that blurring is not indicative of any deficiency in quality. Since pasture is a natural product, individual variability is normal.<br />Our tips for storing Colostrum Liquid:<br />• Store in a dark and cool place<br />• Keep refrigerated after opening<br />• Shake before consuming if cloudy</em></p>
<p><em>What characterizes LR's Colostrum products?<br />Colostrum products from LR are the first pasture products on the market with the SGS INSTITUT FRESENIUS seal of quality. Currently the strongest quality seal confirms the very high level of quality through independent, secret and regular inspections. The high above-average costs especially guarantee the quality and safety of a product with many values.<br />LR uses only cow pasture from Europe for its Colostrum products. This means: high quality standard even in its extraction and short transport routes.<br />For this purpose, LR uses only the surplus milk of the first hours, because it is the richest in nutrients. In order for Colostrum Liquid to preserve the highest values of the ingredients and be enjoyed by people, LR uses a delicate cold processing method.</em></p>
<p><em>Cow pasture (pasture milk) that has been fat removed and pasteurized. </em></p>
<p><br /></p> |
N |
N |
0.00 |
N |
P |
|
0 |
0 |
0 |
0 |
10 |
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;} |
A |
N |
1695789069 |
BE HEALTHY |