Query time 0.00168
JSON explain
{
"query_block": {
"select_id": 1,
"table": {
"table_name": "cscart_master_products_storefront_min_price",
"access_type": "system",
"possible_keys": ["PRIMARY"],
"rows": 0,
"filtered": 0,
"const_row_not_found": true
},
"table": {
"table_name": "point_prices",
"access_type": "system",
"possible_keys": ["unique_key", "src_k"],
"rows": 0,
"filtered": 0,
"const_row_not_found": true
},
"table": {
"table_name": "cscart_products",
"access_type": "const",
"possible_keys": ["PRIMARY", "status"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["const"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "popularity",
"access_type": "const",
"possible_keys": ["PRIMARY", "total"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["const"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "cscart_product_sales",
"access_type": "const",
"possible_keys": ["PRIMARY", "pa"],
"key": "PRIMARY",
"key_length": "6",
"used_key_parts": ["category_id", "product_id"],
"ref": ["const", "const"],
"rows": 0,
"filtered": 0,
"unique_row_not_found": true
},
"table": {
"table_name": "cscart_discussion",
"access_type": "const",
"possible_keys": ["object_id"],
"key": "object_id",
"key_length": "6",
"used_key_parts": ["object_id", "object_type"],
"ref": ["const", "const"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "cscart_product_review_prepared_data",
"access_type": "system",
"possible_keys": ["PRIMARY"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "cscart_product_prices",
"access_type": "ref",
"possible_keys": ["usergroup", "product_id", "lower_limit", "usergroup_id"],
"key": "product_id",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_product_prices.lower_limit = 1 and cscart_product_prices.usergroup_id in (0,0,1))"
},
"table": {
"table_name": "cscart_product_descriptions",
"access_type": "const",
"possible_keys": ["PRIMARY", "product_id"],
"key": "PRIMARY",
"key_length": "9",
"used_key_parts": ["product_id", "lang_code"],
"ref": ["const", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_product_descriptions.lang_code = 'ru')"
},
"table": {
"table_name": "company_descr",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "10",
"used_key_parts": ["company_id", "lang_code"],
"ref": ["const", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(company_descr.lang_code = 'ru')"
},
"table": {
"table_name": "companies",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "4",
"used_key_parts": ["company_id"],
"ref": ["const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(companies.`status` = 'A')"
},
"table": {
"table_name": "cscart_products_categories",
"access_type": "ref",
"possible_keys": ["PRIMARY", "pt"],
"key": "pt",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["const"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "cscart_categories",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY", "c_status", "p_category_id"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["category_id"],
"ref": ["admin_test.cscart_products_categories.category_id"],
"rows": 1,
"filtered": 100,
"attached_condition": "cscart_categories.storefront_id in (0,1) and (cscart_categories.usergroup_ids = '' or find_in_set(0,cscart_categories.usergroup_ids) or find_in_set(1,cscart_categories.usergroup_ids)) and cscart_categories.`status` in ('A','H')"
},
"table": {
"table_name": "cscart_seo_names",
"access_type": "ref",
"possible_keys": ["PRIMARY", "dispatch"],
"key": "PRIMARY",
"key_length": "206",
"used_key_parts": ["object_id", "type", "dispatch", "lang_code"],
"ref": ["const", "const", "const", "const"],
"rows": 2,
"filtered": 100,
"attached_condition": "trigcond(cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'ru')"
}
}
}
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 |
yml2_brand |
yml2_origin_country |
yml2_store |
yml2_pickup |
yml2_delivery |
yml2_adult |
yml2_delivery_options |
yml2_bid |
yml2_model |
yml2_sales_notes |
yml2_type_prefix |
yml2_offer_type |
yml2_market_category |
yml2_manufacturer_warranty |
yml2_expiry |
yml2_purchase_price |
yml2_description |
yml2_cpa |
buy_now_url |
units_in_product |
show_price_per_x_units |
ab__stickers_manual_ids |
ab__stickers_generated_ids |
master_product_id |
master_product_status |
master_product_offers_count |
is_stock_split_by_warehouses |
source_import_key |
fiscal_data_1212 |
mark_code_type |
lang_code |
product |
shortname |
short_description |
full_description |
meta_keywords |
meta_description |
search_words |
page_title |
age_warning_message |
promo_text |
unit_name |
price |
category_ids |
popularity |
company_name |
sales_amount |
seo_name |
seo_path |
point_price |
discussion_type |
average_rating |
product_reviews_count |
19526 |
ШО-00001938 |
P |
A |
9 |
0.00 |
4 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1725580856 |
1726245484 |
0 |
N |
N |
N |
|
N |
|
N |
N |
N |
Y |
10 |
0 |
N |
|
|
|
|
|
|
N |
0 |
|
|
|
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;} |
|
0 |
|
|
|
|
|
N |
|
0 |
|
|
|
|
|
|
|
0 |
|
Y |
|
0.000 |
1.000 |
|
|
0 |
A |
0 |
Y |
44694f32945b0648a6c6bb2ca42a4690 |
1 |
|
ru |
Адаптер Hoco UA22 USB LAN (100Mbps) White |
|
Адаптер USB 2.0 - Ethernet позволяет вашим устройствам USB, таким как ноутбук, планшет, смартфон, ТВ-приставка подключаться к маршрутизатору, модему или сетевому коммутатору для сетевого подключения. Это отличное решение для тех новых компьютеров, которые не имеют проводного порта Ethernet или имеют поврежденный порт Ethernet, либо, где использование беспроводной сети WiFi не желательно. Скорость до 100 Мбит/ сек. Примечание: для корректной работы переходника необходимо установить драйвера на диске. Диск идет в комплекте с устройством. По вопросам, связанным с драйверами обращайтесь в чат с продавцом. Преимущества: Высокое качество подключения Скорость передачи данных 100 Мбит/ сек Компактный размер |
|
|
|
|
|
|
|
|
990.00000000 |
709M |
6 |
Точка Связи |
|
adapter-hoco-ua22-usb-lan-100mbps-white |
702/705/709 |
|
D |
|
|