Query time 0.00112
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "0.72"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_categories",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_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.10",
"prefix_cost": "0.00",
"data_read_per_join": "3K"
},
"used_columns": [
"category_id",
"parent_id",
"id_path",
"level",
"company_id",
"usergroup_ids",
"status",
"product_count",
"position",
"timestamp",
"is_op",
"localization",
"age_verification",
"age_limit",
"parent_age_verification",
"parent_age_limit",
"selected_views",
"default_view",
"product_details_view",
"product_columns",
"is_trash",
"is_default",
"category_type",
"ab__lc_catalog_image_control",
"ab__lc_landing",
"ab__lc_subsubcategories",
"ab__lc_menu_id",
"ab__lc_how_to_use_menu",
"ab__lc_inherit_control",
"ebay_category",
"ab__fn_category_status",
"ab__fn_label_color",
"ab__fn_label_background",
"ab__fn_use_origin_image",
"staff_notes",
"category_code",
"storefront_id"
]
}
},
{
"table": {
"table_name": "cscart_category_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"category_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.10",
"prefix_cost": "0.00",
"data_read_per_join": "6K"
},
"used_columns": [
"category_id",
"lang_code",
"category",
"description",
"meta_keywords",
"meta_description",
"page_title",
"age_warning_message",
"mega_m_category_banner_url",
"mega_m_category_svg_icon",
"ab__custom_category_h1",
"ab__fn_label_text",
"ab__fn_label_show",
"custom_header",
"ab__emd_alternative_name"
]
}
},
{
"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": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.27",
"eval_cost": "0.10",
"prefix_cost": "0.37",
"data_read_per_join": "1K"
},
"used_columns": [
"name",
"object_id",
"company_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
},
{
"table": {
"table_name": "ab__emd_cp",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.25",
"eval_cost": "0.10",
"prefix_cost": "0.72",
"data_read_per_join": "16"
},
"used_columns": [
"category_id",
"category_pattern_id",
"products_pattern_id"
]
}
}
]
}
}
Result
| category_id |
parent_id |
id_path |
level |
company_id |
usergroup_ids |
status |
product_count |
position |
timestamp |
is_op |
localization |
age_verification |
age_limit |
parent_age_verification |
parent_age_limit |
selected_views |
default_view |
product_details_view |
product_columns |
is_trash |
is_default |
category_type |
ab__lc_catalog_image_control |
ab__lc_landing |
ab__lc_subsubcategories |
ab__lc_menu_id |
ab__lc_how_to_use_menu |
ab__lc_inherit_control |
ebay_category |
ab__fn_category_status |
ab__fn_label_color |
ab__fn_label_background |
ab__fn_use_origin_image |
staff_notes |
category_code |
storefront_id |
lang_code |
category |
description |
meta_keywords |
meta_description |
page_title |
age_warning_message |
mega_m_category_banner_url |
mega_m_category_svg_icon |
ab__custom_category_h1 |
ab__fn_label_text |
ab__fn_label_show |
custom_header |
ab__emd_alternative_name |
name |
object_id |
type |
dispatch |
path |
category_pattern_id |
products_pattern_id |
seo_name |
seo_path |
ab__emd__category_pattern_id |
ab__emd__products_pattern_id |
|
887 |
3471/887/3474 |
3 |
0 |
0 |
A |
0 |
30 |
1586546372 |
N |
|
N |
0 |
N |
0 |
|
|
default |
0 |
N |
N |
C |
none |
N |
0 |
0 |
N |
N |
|
Y |
#ffffff |
#333333 |
N |
|
MZX1-HHWT-5 |
0 |
en |
Isolation Transformer |
Find here Power Transformers, Danke Power Transformers manufacturers, suppliers & exporters in India. Get contact details & address of companies manufacturing and supplying Power Transformers, Danke Power Transformers across India. GEESYS is the leading manufacturer of Power Transformers, Electrical Transformer, ranging 2500 kVA to 100000 kVA, up to 220 kV |
Power Transformers, Danke Power Transformers, manufacturers, suppliers, exporters, traders, dealers, manufacturing companies, retailers, producers, Transformers & Transformer Parts India, List of Power Transformer Manufacturers in India, Buy Transformers, |
Find best transformer manufacturing company in Hyderabad. Get isolation transformer with lowest leakage current from power & electrical transformer manufacturers. power transformer manufacturers in india,electrical power transformers,power line transf |
Power Transformers, Isolation Transformer, Control Transformer, Electrical Transformer, GEESYS Technologies |
|
|
|
|
|
N |
|
|
isolation-transformer |
3474 |
c |
|
3471/887 |
|
|
isolation-transformer |
3471/887 |
0 |
0 |