Query time 0.00053
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "0.35"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_categories",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"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": "10K"
},
"used_columns": [
"category_id",
"parent_id",
"id_path",
"level",
"company_id",
"storefront_id",
"usergroup_ids",
"guarantee_id",
"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",
"yml2_market_category",
"yml2_offer_type",
"yml2_type_prefix_select",
"yml2_model_select",
"yml2_type_prefix",
"yml2_model",
"ab__fn_category_status",
"ab__fn_label_color",
"ab__fn_label_background",
"ab__fn_use_origin_image",
"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",
"external_id",
"services",
"block_title",
"block_subtitle",
"block_utp_percent",
"block_utp_line1",
"block_utp_line2",
"guarantee_type",
"guarantees_crm",
"content",
"relink",
"relink_name",
"relink_blog",
"amo",
"individual_meta_data",
"level_main",
"level_list",
"level_item",
"pos"
]
}
},
{
"table": {
"table_name": "cscart_category_descriptions",
"access_type": "ref",
"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.35",
"data_read_per_join": "4K"
},
"used_columns": [
"category_id",
"lang_code",
"category",
"description",
"meta_keywords",
"meta_description",
"page_title",
"age_warning_message",
"ab__fn_label_text",
"ab__fn_label_show",
"breadcrumbs",
"robots",
"products_count",
"icon",
"counts"
]
}
}
]
}
}
Result
category_id |
parent_id |
id_path |
level |
company_id |
storefront_id |
usergroup_ids |
guarantee_id |
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 |
yml2_market_category |
yml2_offer_type |
yml2_type_prefix_select |
yml2_model_select |
yml2_type_prefix |
yml2_model |
ab__fn_category_status |
ab__fn_label_color |
ab__fn_label_background |
ab__fn_use_origin_image |
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 |
external_id |
services |
block_title |
block_subtitle |
block_utp_percent |
block_utp_line1 |
block_utp_line2 |
guarantee_type |
guarantees_crm |
content |
relink |
relink_name |
relink_blog |
amo |
individual_meta_data |
level_main |
level_list |
level_item |
pos |
lang_code |
category |
description |
meta_keywords |
meta_description |
page_title |
age_warning_message |
ab__fn_label_text |
ab__fn_label_show |
breadcrumbs |
robots |
products_count |
icon |
counts |
659 |
568 |
506/568/659 |
3 |
0 |
0 |
0 |
3 |
A |
237 |
70 |
1681074000 |
N |
|
N |
0 |
N |
0 |
|
|
default |
0 |
N |
N |
|
|
|
|
|
|
N |
#ffffff |
#222222 |
N |
none |
N |
0 |
0 |
N |
N |
|
2 |
|
|
0 |
|
0 |
7,32,158 |
3/4/26 |
a:6:{s:3:"utp";a:1:{i:0;a:4:{s:18:"text_before_number";s:0:"";s:6:"number";s:0:"";s:17:"text_after_number";s:0:"";s:4:"text";s:0:"";}}s:4:"tabs";a:1:{i:0;a:2:{s:5:"title";s:0:"";s:11:"description";s:0:"";}}s:7:"buttons";a:3:{i:0;a:1:{s:11:"button_name";s:0:"";}i:1;a:1:{s:11:"button_name";s:0:"";}i:2;a:1:{s:11:"button_name";s:0:"";}}s:5:"video";s:0:"";s:5:"phone";s:0:"";s:3:"faq";a:1:{i:0;a:2:{s:8:"question";s:0:"";s:6:"answer";s:0:"";}}} |
a:4:{i:0;a:4:{s:6:"status";s:1:"A";s:4:"name";s:34:"Грузовики и тягачи";s:12:"default_name";s:0:"";s:4:"link";a:3:{i:0;a:4:{s:6:"status";s:1:"A";s:4:"href";s:67:"https://finleo.ru/spectehnika/gruzovoy-transport/sedelnyy-tyagachi/";s:4:"name";s:31:"Седельные тягачи";s:5:"sf_id";s:0:"";}i:1;a:4:{s:6:"status";s:1:"A";s:4:"href";s:59:"https://finleo.ru/spectehnika/gruzovoy-transport/samosvaly/";s:4:"name";s:18:"Самосвалы";s:5:"sf_id";s:0:"";}i:2;a:4:{s:6:"status";s:1:"A";s:4:"href";s:58:"https://finleo.ru/spectehnika/gruzovoy-transport/lesovozy/";s:4:"name";s:16:"Лесовозы";s:5:"sf_id";s:0:"";}}}i:1;a:4:{s:6:"status";s:1:"A";s:4:"name";s:35:"Машины спецтехника";s:12:"default_name";s:0:"";s:4:"link";a:3:{i:0;a:4:{s:6:"status";s:1:"A";s:4:"href";s:71:"https://finleo.ru/spectehnika/stroitelnaya-tehnika/svaeboynaya-tehnika/";s:4:"name";s:35:"Сваебойная техника";s:5:"sf_id";s:0:"";}i:1;a:4:{s:6:"status";s:1:"A";s:4:"href";s:61:"https://finleo.ru/spectehnika/stroitelnaya-tehnika/avtokrany/";s:4:"name";s:18:"Автокраны";s:5:"sf_id";s:0:"";}i:2;a:4:{s:6:"status";s:1:"A";s:4:"href";s:71:"https://finleo.ru/spectehnika/stroitelnaya-tehnika/avtobetonosmesiteli/";s:4:"name";s:38:"Автобетоносмесители";s:5:"sf_id";s:0:"";}}}i:2;a:4:{s:6:"status";s:1:"A";s:4:"name";s:42:"С краном манипулятором";s:12:"default_name";s:0:"";s:4:"link";a:3:{i:0;a:4:{s:6:"status";s:1:"A";s:4:"href";s:58:"https://finleo.ru/spectehnika/gruzovoy-transport/lesovozy/";s:4:"name";s:16:"Лесовозы";s:5:"sf_id";s:0:"";}i:1;a:4:{s:6:"status";s:1:"A";s:4:"href";s:60:"https://finleo.ru/spectehnika/gruzovoy-transport/multilifty/";s:4:"name";s:22:"Мультилифты";s:5:"sf_id";s:0:"";}i:2;a:4:{s:6:"status";s:1:"A";s:4:"href";s:58:"https://finleo.ru/spectehnika/gruzovoy-transport/lomovozy/";s:4:"name";s:16:"Ломовозы";s:5:"sf_id";s:0:"";}}}i:3;a:4:{s:6:"status";s:1:"A";s:4:"name";s:25:"Тип установки";s:12:"default_name";s:0:"";s:4:"link";a:2:{i:0;a:4:{s:6:"status";s:1:"A";s:4:"href";s:92:"https://finleo.ru/spectehnika/kommunalnaya-tehnika/musorovozy/musorovoz-s-bokovoj-zagruzkoj/";s:4:"name";s:36:"С боковой загрузкой";s:5:"sf_id";s:0:"";}i:1;a:4:{s:6:"status";s:1:"A";s:4:"href";s:91:"https://finleo.ru/spectehnika/kommunalnaya-tehnika/musorovozy/musorovoz-s-zadnej-zagruzkoj/";s:4:"name";s:34:"С задней загрузкой";s:5:"sf_id";s:0:"";}}}} |
|
a:2:{s:4:"type";s:3:"tag";s:4:"tags";s:0:"";} |
1 |
Y |
|
|
|
0 |
ru |
Бортовые автомобили с КМУ |
|
Бортовые автомобили с КМУ |
Бортовые автомобили с КМУ - большой ассортимент грузовой техники, купить по доступной цене в Москве. Каталог бортовых автомобилей с КМУ на сайте Finleo. ✅ Выгодные условия. ✅ Гарантия. Вы можете оформить заказ на сайте или по телефону. |
Бортовые автомобили с КМУ - купить бортовой автомобиль с КМУ по выгодной цене в Москве на сайте Finleo |
|
|
N |
Бортовые автомобили с КМУ |
none |
163 |
|
0 |