Query time 0.00173
JSON explain
{
"query_block": {
"select_id": 1,
"nested_loop": [
{
"table": {
"table_name": "shared_prices",
"access_type": "system",
"possible_keys": [
"usergroup",
"product_id",
"company_id",
"lower_limit",
"usergroup_id"
],
"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": "companies",
"access_type": "system",
"possible_keys": ["PRIMARY"],
"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": 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 = 'en')"
}
},
{
"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": ["lillyshop_lillyshop.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": "const",
"possible_keys": ["PRIMARY", "dispatch"],
"key": "PRIMARY",
"key_length": "210",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code",
"company_id"
],
"ref": ["const", "const", "const", "const", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en')"
}
},
{
"table": {
"table_name": "cscart_discussion",
"access_type": "const",
"possible_keys": ["object_id", "idx_company_id"],
"key": "object_id",
"key_length": "10",
"used_key_parts": ["object_id", "object_type", "company_id"],
"ref": ["const", "const", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_discussion.object_type = 'P')"
}
}
]
}
}
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 |
ab__stickers_manual_ids |
ab__stickers_generated_ids |
image_extension |
fiscal_data_1212 |
mark_code_type |
lang_code |
product |
shortname |
ab__spt_short_name |
short_description |
full_description |
meta_keywords |
meta_description |
search_words |
page_title |
age_warning_message |
promo_text |
ab__custom_product_h1 |
amp_description |
ab__emd_alternative_name |
stop_words |
price |
category_ids |
popularity |
company_name |
sales_amount |
seo_name |
seo_path |
discussion_type |
| 12936 |
8649 |
P |
A |
1 |
0.00 |
4 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1617300338 |
1748530792 |
0 |
N |
N |
N |
B |
N |
R |
N |
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;} |
|
0 |
|
|
|
|
|
N |
a:0:{} |
0 |
|
|
|
|
|
|
|
0 |
|
Y |
|
|
|
jpg |
1 |
|
en |
Gel for repairing nails FOX Carbon gel, 5 ml |
|
|
|
Gel for nail repair FOX Carbon gel 5 ml
FOX Carbon Gel Masha Create nail plate repair gel is a special material that allows you to repair nail plates. It contains natural silk fibers. It is thanks to these additives that a strong reinforcing mesh is formed during the polymerization process. Thus, the voids between the cracks are filled, the surface of the nail again becomes monolithic and durable. The gel makes it possible not only to repair the damage, but also to build up the corners. Forms a sticky layer after drying.
Volume 15 ml.
How to apply:
1. Decorate the nail plate, degrease with Nail Prep.
2. Apply a little Ultrabond non-acid, wait for it to dry.
3. Apply a thin primer layer of the base for gel polish with rubbing movements. Dry in a lamp (2 min. in UV 36 W, 1 min. in LED/UV lamp 36/48 W).
4. Apply FOX Carbon Gel Masha Create to the area of the crack, evenly distributing the silk fibers and not creating excess volume. Dry in a lamp (2 min. in UV 36 W, 1 min. in LED/UV lamp 36/48 W).
5. Apply a dense FOX base over the entire nail, then, placing a drop in the apex area, level the surface, overlapping the repair area. Dry in a lamp (2 min. in UV 36 W, 1 min. in LED/UV lamp 36/48 W).
6. Sand the nail surface, if necessary.
7. The nail is repaired and ready for a gel polish manicure. |
|
|
|
|
|
|
|
|
|
|
175.00000000 |
481M |
12486 |
LILLYSHOP |
42 |
gel-dlya-remona-nogtey-fox-carbon-gel-5-ml |
387/479/481 |
B |