Query time 0.00099
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "0.37"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_pages",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"page_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": "2K"
},
"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",
"staff_notes",
"abt__ut2_microdata_schema_type"
]
}
},
{
"table": {
"table_name": "cscart_page_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"page_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": [
"page_id",
"lang_code",
"page",
"description",
"meta_keywords",
"meta_description",
"page_title",
"link",
"page_sitemap",
"ab__custom_page_h1",
"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",
"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 |
staff_notes |
abt__ut2_microdata_schema_type |
lang_code |
page |
description |
meta_keywords |
meta_description |
page_title |
link |
page_sitemap |
ab__custom_page_h1 |
custom_header |
ab__emd_alternative_name |
seo_name |
seo_path |
| 48 |
0 |
0 |
48 |
A |
T |
0 |
1566507600 |
0 |
|
0 |
N |
0 |
0 |
activity |
|
|
en |
100% Buyer protection |
<p><img src="https://www.stock2cart.com/images/Buyer%20Protection.jpg?1569933897697" alt="Buyer%20Protection.jpg?1569933897697" /></p><div class="policy_pages_align">
<h5 class="page_heading">MONEY
BACK GUARANTEE
</h5>
<p>We promise your money back if the item you
received is not as described, or if your item is not delivered within the Buyer
Protection period. You can get the refund in 15 days after the claim process
finishes.
</p>
<h5 class="page_heading">Terms & Conditions</h5>
<p>1. Contact Seller
</p>
<p>Go to your order history and select the item.
Discuss the issue with the seller and see possible solutions.
</p>
<p>2. Apply for Refund
</p>
<p>If you can't come to an agreement with the
seller, simply apply for a refund by opening a dispute in the order page. Be
sure to do this within 15 days of your order confirmation.
</p>
<p>3. Get Money Back in 15 Days
</p>
<p>Most sellers will return your money in 15
days, however; if it's not resolved, you can contact AliExpress from the order
detail page to escalate your dispute.
</p>
<h5 class="page_heading">Free Return
</h5>
<p>Sellers that offer 'Free Return' service will
have 'Free Return' icon on their item details page. With 'Free Return' service,
you get an extra 15 days (on top of the on-time delivery date) to decide if you
want to keep or return the item for any reason, as long as they are unused,
unwashed and in their original condition – complete with the original
packaging, tags, etc. It's easy and fast:
</p>
<h5 class="page_heading">Easy
</h5>
<ol><li>You could return items locally and easily:
Get the return code or the return label, Go to the designated logistics
company's service point to complete the return and wait for the local warehouse
to receive your returned parcel.
</li>
<li>Remember to select 'Return Goods"
while opening the dispute.
</li>
<li>Fast
</li>
<li>Refund will be made to you once we confirm
receipt of your returned parcel which meet the conditions for reimbursement.
</li>
<li>
Items will be processed at a local warehouse,
instead of being sent back to the seller’s country of origin (eg China).
</li>
</ol><h5 class="page_heading">Service Scope
</h5>
<ol><li>Not all countries on AliExpress include the
Free Return service. At present, supported countries include the mainland
territories of the United States, Canada, Australia, United Kingdom, France,
Spain, Germany and Russia.
</li>
<li>In addition, not all products on AliExpress.com include the Free Return</li>
<li>service. The seller can choose whether or not to offer this extra service.</li>
<li>Sellers that offer the Free Return service will have a label or icon on their</li>
<li>product details page confirming this service is available.</li>
</ol><h5 class="page_heading">Return Shipment Fee
</h5>
<p>It is free for you to return the parcel to the designated local return address.
Note: You can only enjoy one-time free local return for one order. If you
initiate multiple return requests under an order, you can only enjoy the free
local return service once, and other return requests can still enjoy local
return service but you will have to cover the return shipping costs to the
designated local return address. Therefore, please consider returning jointly
the products to avoid paying that additional shipping cost.
</p>
<h5 class="page_heading">Local Return</h5>
<p>You can enjoy our Free Return service within
30 days of receipt of delivery.
</p>
<h5 class="page_heading">Service Scope
</h5>
<ol><li>Sellers can choose to offer this extra
service, and will often do so if they are using a warehouse that is located in
your country.
</li>
<li>
At present, this service is limited to products from participating Italian
sellers only.
</li>
<li>Conditions for Submitting Refund Requests
</li>
<li>The item must belong to one of the
following categories: Electrical goods
</li>
<li>The products have not been used.
</li>
<li>The item is in perfect condition and in its
original packaging.
</li>
</ol><h5 class="page_heading">Return Shipment Fee
</h5>
<p>The shipping cost of your returned goods will
be paid by the seller.
</p>
<h5 class="page_heading">Local Return
</h5>
<p>Sellers that offer 'Local Return' service
will have the above 'Local Return' icon on their item details page. With 'Local
Return' service, you could get an extra 15 days (on top of the on-time delivery
date) to decide if you want to keep or return the item without any reason.
</p>
<p class="page_heading"><strong>Return Shipment Fee</strong>
</p>
<p>The return shipping costs to the designated local return
address are borne by the buyer.
</p>
<p class="page_heading"><strong>Local requirements</strong>
</p>
<p>The seller must comply with other relevant legal
requirements (warranty, return, etc.) that may be applicable depending on your
location as buyer. For instance, in most EU countries you will generally have a
2-year legal conformity warranty and a 14-day free right to return (please note
that in case of return, the buyer must bear the cost of returning the products
to the seller).
<br /></p>
</div> |
Buyer Protection |
Buyer Protection |
Buyer Protection |
|
|
|
|
|
100-purchase-protection |
|