Query time 0.00061
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "3.43"
},
"ordering_operation": {
"using_filesort": true,
"nested_loop": [
{
"table": {
"table_name": "cscart_pages",
"access_type": "ref",
"possible_keys": [
"parent_id"
],
"key": "parent_id",
"used_key_parts": [
"parent_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 3,
"rows_produced_per_join": 0,
"filtered": "5.00",
"index_condition": "(`cscart`.`cscart_pages`.`parent_id` <=> 7)",
"cost_info": {
"read_cost": "2.00",
"eval_cost": "0.03",
"prefix_cost": "2.60",
"data_read_per_join": "394"
},
"used_columns": [
"page_id",
"company_id",
"parent_id",
"id_path",
"status",
"page_type",
"position",
"timestamp",
"usergroup_ids",
"localization",
"new_window",
"use_avail_period",
"avail_from_timestamp",
"avail_till_timestamp",
"facebook_obj_type",
"abt__ut2_microdata_schema_type"
],
"attached_condition": "((`cscart`.`cscart_pages`.`status` = 'A') and (`cscart`.`cscart_pages`.`page_type` = 'B') and ((`cscart`.`cscart_pages`.`usergroup_ids` = '') or find_in_set(0,`cscart`.`cscart_pages`.`usergroup_ids`) or find_in_set(1,`cscart`.`cscart_pages`.`usergroup_ids`)) and ((`cscart`.`cscart_pages`.`use_avail_period` = 'N') or ((`cscart`.`cscart_pages`.`use_avail_period` = 'Y') and (`cscart`.`cscart_pages`.`avail_from_timestamp` <= 1781690847) and ((`cscart`.`cscart_pages`.`avail_till_timestamp` >= 1781690847) or (`cscart`.`cscart_pages`.`avail_till_timestamp` = 0)))))"
}
},
{
"table": {
"table_name": "cscart_page_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"page_id",
"lang_code"
],
"key_length": "9",
"ref": [
"cscart.cscart_pages.page_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.15",
"eval_cost": "0.03",
"prefix_cost": "2.78",
"data_read_per_join": "579"
},
"used_columns": [
"page_id",
"lang_code",
"page",
"description",
"meta_keywords",
"meta_description",
"page_title",
"link"
]
}
},
{
"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": [
"cscart.cscart_pages.page_id",
"const",
"const",
"const"
],
"rows_examined_per_scan": 3,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.56",
"eval_cost": "0.09",
"prefix_cost": "3.43",
"data_read_per_join": "781"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
]
}
}
}
Result
| page_id |
company_id |
parent_id |
id_path |
status |
page_type |
position |
timestamp |
usergroup_ids |
localization |
new_window |
use_avail_period |
avail_from_timestamp |
avail_till_timestamp |
facebook_obj_type |
abt__ut2_microdata_schema_type |
lang_code |
page |
description |
meta_keywords |
meta_description |
page_title |
link |
seo_name |
seo_path |
| 10 |
0 |
7 |
7/10 |
A |
B |
0 |
1415736000 |
0 |
|
0 |
N |
0 |
0 |
|
|
en |
How to Distribute Money between Vendors |
<p>PayPal Commerce platform is a solution that allows marketplaces to accept payments and split them between the vendors involved, while the marketplace takes its cut.</p><!--CUT--><p>To use PayPal Commerce Platform, you must first contact PayPal and become approved for the use of this solution.</p><p>After that, you’ll be able to <a href="https://docs.cs-cart.com/latest/user_guide/payment_methods/paypal_commerce_platform.html" target="_blank">set up a payment method that uses PayPal Commerce Platform</a>. It’s important that vendors connect their accounts to your marketplace. If all of the vendors whose products are being bought connect their accounts, then customers will be offered that PayPal payment method at checkout.</p><p>In this case, everyone benefits:<ul><li>Customers benefit from having to pay only once.</li><li>You benefit from not having to split the money between vendors.</li><li>Vendors benefit from getting the money from their sold products.</li></ul></p> |
|
|
|
|
kak-raspredelyat-dengi-mezhdu-prodavcami |
7 |
| 9 |
0 |
7 |
7/9 |
A |
B |
0 |
1415526000 |
0 |
|
0 |
N |
0 |
0 |
|
|
en |
Why You Need a Subscription Model for Your Vendors |
<p>When you run a multi-vendor marketplace, you offer other entrepreneurs a service by allowing them to sell their products on your territory. To help you earn money for that service, Multi-Vendor comes with the built-in “Vendor plans” functionality.</p><!--CUT--><p>The vendor plans allow you to:<ul><li>Take a one-time or periodic (monthly / yearly) fee from your vendors.</li><li>Take commission from each transaction (percentage, fixed, or both).</li><li>Impose restrictions on the number of products and maximum revenue.</li><li>Give more privileges to vendors with higher-tier plans.</li><li>Decide which storefronts and categories will be available to vendors with this or that plan.</li><li>Offer certain vendors a microstore—it is a section of the site available by a direct link, where only the products of a specific vendor appear.</li></ul></p><p>Follow us on <a href="https://www.facebook.com/cscart.official" target="_blank">Facebook</a> and <a href="https://twitter.com/cscart" target="_blank">Twitter</a> to stay in the loop. To learn about other useful CS-Cart functionality, check out our <a href="https://www.youtube.com/user/cscartvideos" target="_blank">YouTube channel</a>.</p> |
|
|
|
|
zachem-nuzhny-podpisnye-biznes-modeli-dlya-prodavcov |
7 |