Query time 0.00241
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.76"
},
"grouping_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "cscart_products",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"status"
],
"key": "PRIMARY",
"used_key_parts": [
"product_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.20",
"prefix_cost": "0.00",
"data_read_per_join": "7K"
},
"used_columns": [
"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",
"buy_now_url",
"master_product_id",
"master_product_status",
"master_product_offers_count",
"prestashop_product_id",
"prestashop_account_id",
"prestashop_is_parent",
"amz_condition",
"amz_condition_note",
"amz_product_id",
"amz_product_id_type",
"transfer_price",
"tax_value",
"ebay_template_id",
"product_hash",
"ebay_price",
"package_type",
"ebay_status",
"ebay_override_price",
"subscription_product",
"interval",
"interval_count",
"ec_rfq_product_type",
"ec_rfq_service_options"
]
}
},
{
"table": {
"table_name": "popularity",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"total"
],
"key": "PRIMARY",
"used_key_parts": [
"product_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.20",
"prefix_cost": "0.00",
"data_read_per_join": "32"
},
"used_columns": [
"product_id",
"total"
]
}
},
{
"table": {
"table_name": "cscart_product_sales",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"pa"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id",
"product_id"
],
"key_length": "6",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"unique_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "16"
},
"used_columns": [
"category_id",
"product_id",
"amount"
]
}
},
{
"table": {
"table_name": "cscart_products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "pt",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.00",
"eval_cost": "0.20",
"prefix_cost": "1.20",
"data_read_per_join": "16"
},
"used_columns": [
"product_id",
"category_id",
"link_type",
"category_position"
]
}
},
{
"table": {
"table_name": "cscart_categories",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"webmarco.cscart_products_categories.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "5.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.01",
"prefix_cost": "1.40",
"data_read_per_join": "303"
},
"used_columns": [
"category_id",
"usergroup_ids",
"status",
"storefront_id"
],
"attached_condition": "((`webmarco`.`cscart_categories`.`storefront_id` in (0,1)) and ((`webmarco`.`cscart_categories`.`usergroup_ids` = '') or find_in_set(0,`webmarco`.`cscart_categories`.`usergroup_ids`) or find_in_set(1,`webmarco`.`cscart_categories`.`usergroup_ids`)) and (`webmarco`.`cscart_categories`.`status` in ('A','H')))"
}
},
{
"table": {
"table_name": "cscart_product_prices",
"access_type": "range",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "usergroup",
"used_key_parts": [
"product_id",
"usergroup_id",
"lower_limit"
],
"key_length": "9",
"rows_examined_per_scan": 2,
"rows_produced_per_join": 0,
"filtered": "100.00",
"using_join_buffer": "Block Nested Loop",
"cost_info": {
"read_cost": "0.10",
"eval_cost": "0.02",
"prefix_cost": "1.52",
"data_read_per_join": "6"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
],
"attached_condition": "(<if>(found_match(cscart_product_prices), 1, true) and <if>(is_not_null_compl(cscart_product_prices), ((`webmarco`.`cscart_product_prices`.`lower_limit` = 1) and (`webmarco`.`cscart_product_prices`.`product_id` = 279396) and (`webmarco`.`cscart_product_prices`.`usergroup_id` in (0,0,1))), true))"
}
},
{
"table": {
"table_name": "cscart_product_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"lang_code"
],
"key_length": "9",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.02",
"prefix_cost": "1.54",
"data_read_per_join": "699"
},
"used_columns": [
"product_id",
"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",
"ebay_title",
"ebay_description",
"override",
"cls_stop_words",
"ec_rfq_request_btn_text"
]
}
},
{
"table": {
"table_name": "company_descr",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id",
"lang_code"
],
"key_length": "10",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.02",
"prefix_cost": "1.56",
"data_read_per_join": "406"
},
"used_columns": [
"company_id",
"lang_code",
"i18n_company"
]
}
},
{
"table": {
"table_name": "companies",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id"
],
"key_length": "4",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.02",
"prefix_cost": "1.58",
"data_read_per_join": "975"
},
"used_columns": [
"company_id",
"status",
"ec_rfq_whatsapp_number",
"ec_rfq_phone_number",
"ec_rfq_bhf",
"ec_rfq_bht"
],
"attached_condition": "<if>(found_match(companies), ((`webmarco`.`companies`.`status` = 'A') or 0), true)"
}
},
{
"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": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.10",
"eval_cost": "0.02",
"prefix_cost": "1.70",
"data_read_per_join": "173"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
},
{
"table": {
"table_name": "cscart_discussion",
"access_type": "const",
"possible_keys": [
"object_id"
],
"key": "object_id",
"used_key_parts": [
"object_id",
"object_type"
],
"key_length": "6",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.02",
"prefix_cost": "1.72",
"data_read_per_join": "2"
},
"used_columns": [
"object_id",
"object_type",
"type"
]
}
},
{
"table": {
"table_name": "cscart_product_review_prepared_data",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"storefront_id"
],
"key_length": "7",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.02",
"prefix_cost": "1.74",
"data_read_per_join": "1"
},
"used_columns": [
"product_id",
"storefront_id",
"average_rating",
"reviews_count"
]
}
},
{
"table": {
"table_name": "cscart_ec_table_booking_system",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "4",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.02",
"prefix_cost": "1.76",
"data_read_per_join": "17"
},
"used_columns": [
"product_id",
"booking_type",
"quantity_selector",
"show_price_date",
"blocked_date",
"from_date",
"to_date",
"slot_time",
"free_time",
"days_data",
"minimum_booking_time"
],
"attached_condition": "<if>(is_not_null_compl(cscart_ec_table_booking_system), <cache>((279396 = 279396)), true)"
}
}
]
}
}
}
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 |
buy_now_url |
master_product_id |
master_product_status |
master_product_offers_count |
prestashop_product_id |
prestashop_account_id |
prestashop_is_parent |
amz_condition |
amz_condition_note |
amz_product_id |
amz_product_id_type |
transfer_price |
tax_value |
ebay_template_id |
product_hash |
ebay_price |
package_type |
ebay_status |
ebay_override_price |
subscription_product |
interval |
interval_count |
ec_rfq_product_type |
ec_rfq_service_options |
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 |
ebay_title |
ebay_description |
override |
cls_stop_words |
ec_rfq_request_btn_text |
price |
category_ids |
popularity |
company_name |
ec_rfq_whatsapp_number |
ec_rfq_phone_number |
ec_rfq_bhf |
ec_rfq_bht |
sales_amount |
seo_name |
seo_path |
discussion_type |
average_rating |
product_reviews_count |
booking_type |
from_date |
to_date |
slot_time |
free_time |
days_data |
quantity_selector |
show_price_date |
blocked_date |
minimum_booking_time |
| 279396 |
WM1362HF_E13C |
P |
A |
539 |
0.00 |
1 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1655122734 |
1659202550 |
0 |
N |
N |
N |
D |
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;} |
product |
0 |
|
0 |
A |
0 |
0 |
0 |
Y |
|
|
|
|
0.00 |
0.00 |
0 |
633937547 |
|
Letter |
|
N |
N |
day |
|
P |
|
en |
CRYSTAL CENTRO RESORT KUNDU 5 * ANTALYA CITY |
|
|
|
<p> <strong> PACKAGE INCLUDES: </strong> <br /> </p>
<p> -Flight with Air Albania (Tirana - Antalya - Tirana) <br /> TIA - (Tirana) 08:30 - AYT - (Antalya) 11:20 <br /> AYT - (Antalya) 12:20 - TIA - (Tiranë) 13:25 </p>
<p> -Transport from Airport to Hotel. <br /> -Accommodation in Hotel for 7 nights and 8 days. <br /> - Double Room - Standard Room Land View - Ultimate All Inclusive (Depending on the package you choose food, drinks, activities and entertainment are included in the resort reservation price.) </p>
<p> <em> * The price of the package is for two people. <br /> * Accommodation in a hotel for 1 child is free. </em> </p>
<p> <br /> </p>
<p> This property is 5 minutes walk from the beach. Just a short drive from Antalya city center, opposite Lara beach, this beachfront hotel impresses you with its unique pool landscape, large garden and numerous facilities. Selective cuisine can be enjoyed in the hotel restaurants. Free WiFi access is provided. Spend a family vacation to remember at Crystal Centro Resort - Ultimate All Inclusive. While treating yourself to a professional massage at the wellness center, your children can have fun at the children's pool, which features a large water slide. Younger guests will also appreciate the all-day animation program and mini disco. Guests looking for a more active stay at * Crystal Centro Resort * can try a variety of water sports, including canoeing, scuba diving and sailing. Work out in the fitness room or enjoy a swim in the indoor pool. Tennis enthusiasts can use the court on the court. Every summer, * Crystal Centro Resort * is home to a number of dance groups, magicians and other artists. Listen to live music while having a drink at the piano bar, open 24 hours a day. Comprehensive offers also include drinks at the pool bar, beach bar and disco bar. Each of the guest rooms includes a balcony, some of which overlook the water. Enjoy a meal in the comfort of your modern and spacious room. Antalya International Airport is 15 km from Crystal Centro Resort - Ultimate All Inclusive. This is Lara's favorite part of our guests, according to independent estimates. </p>
<p> <br /> <strong> Crystal Centro Resort - Ultimate All Inclusive </strong> </p>
<p> Check available dates </p>
<p> <strong> Most popular places </strong> </p>
<p> 2 pools </p>
<p> Spa and Wellness Center </p>
<p> Non-smoking rooms </p>
<p> Fitness center </p>
<p> Facilities for guests with disabilities </p>
<p> Room service </p>
<p> Free WiFi </p>
<p> Bar </p>
<p> Private beach area </p>
<p> <strong> 2 POOLS </strong> </p>
<ul> <li> Pool 1 - Indoor Free! </li> <li> Pool 2 - Outdoor Free! </li> </ul>
<p> SPA </p>
<ul> <li> Fitness </li> <li> Massage chairs </li> <li> Spa / wellness package </li> <li> Spa lounge / relaxation area </li> <li> Spa facilities </li><li> Body cleansing </li> <li> Body treatments </li> <li> Hair styling </li> <li> Hair coloring </li> <li> Haircut </li><li> Pedicure </li> <li> Manicure </li> <li> Hair treatments </li> <li> Make up services </li> <li> Depilation services </li><li> Facial treatments </li> <li> Beauty services </li> <li> Sun umbrellas </li> <li> Water slides </li> <li> Public baths</li><li> Hammam</li><li> Massage for an additional fee </li> <li> Spa and Wellness center Additional fee </li> <li> Fitness center </li> <li> Sauna <br /></li> </ul><p> OTHERS </p>
<ul> <li> Private beach area </li> <li> Garden </li> </ul> <p> <br /> ACTIVITIES </p>
<ul> <li> Beach </li> <li> Water Park </li> <li> Evening Fun </li> <li> Kids Club </li> <li> Nightclub / DJ</li><li> Fun staff </li> <li> Darts </li> <li> Windsurfing Extra charge </li> <li> Table tennis </li> <li> Billiards </li> <li> Square children's playground </li> <li> Playroom </li> <li> Tennis court </li> </ul> <p> <br /> FOOD & DRINK </p>
<ul> <li> Fruits </li> <li> Baby food </li> <li> Snack bar </li> <li> Breakfast in the room </li> <li> Bar</li><li> Restaurant</li></ul> <p> <br /> INTERNET </p>
<p> WiFi is available in public areas and is free of charge. </p>
<p> PARKING </p>
<p> Free public parking is possible on site (reservation is not required). </p>
<ul> <li> Accessible parking </li> <li> Street parking </li> </ul> <p> <br /> TRANSPORT </p>
<p> Public transport tickets Additional payment </p> <p> <br /> RECEPTION SERVICES </p>
<ul> <li> Luggage storage </li> <li> Tour desk </li> <li> Currency exchange </li> <li> 24-hour front desk </li> </ul> <p><br /></p><p> CLEANING SERVICES </p>
<ul> <li> Daily housekeeping </li> <li> Ironing service Extra fee </li> <li> Dry cleaning Extra charge </li> <li> Laundry Extra fee</li></ul><p> <br /> BUSINESS OBJECTS </p>
<ul> <li> Fax / photocopy Additional charge </li> <li> Meeting / banquet facilities Additional charge </li> </ul> <p> <br /> SECURITY </p>
<ul> <li> Fire extinguishers </li> <li> CCTV outside the property </li> <li> CCTV in common areas </li> <li> Smoke alarms </li> <li> 24 hour security</li> <li> Safe </li> </ul> <p> <br /> GENERAL </p>
<ul> <li> Minimarket on site </li> <li> Shared lounge / TV area </li> <li> Designated smoking area </li> <li> Air conditioning </li> <li> No smoking at all </li> <li> Heating </li> <li> Car rental </li> <li> Removal </li> <li> Family room</li><li> Barber / beauty shop</li><li> Facilities for disabled guests </li> <li> Non-smoking room </li> <li> Room service </li> </ul> <p> <br /> SPOKEN LANGUAGES </p>
<ul> <li> German </li> <li> English </li> <li> French </li> <li> Dutch </li> <li> Russian </li> <li> Turkish </li> </ul> <p> <strong> HOTEL RULES: </strong> <br /> Entrance: 14:00 Departure: 12:00 </p> <p>
</p> |
Hotel, resort, vacation, antalya, turkey, lara, kundu, travel, family resort, marco travel, |
This property is 5 minutes walk from the beach. Only a short drive from Antalya city center, facing Lara Beach, this beach-front hotel impresses with its unique pool landscape, large garden and numerous facilities. |
Hotel, resort, vacation, antalya, turkey, lara, kundu, travel, family resort, marco travel, |
CRYSTAL CENTRO RESORT KUNDU 5 * ANTALYA CITY |
|
<p> <strong> * Price is for monthly payment. </strong> </p>
<p> 12-month financing is offered by Credins Bank with 0% interest. </p>
<p> </p> |
|
|
|
|
|
|
155.00000000 |
10057M |
82946 |
Marco Travel |
|
|
|
|
|
crystal-centro-resort-kundu-5-antalya-city |
9996/10051/10057 |
|
|
|
|
|
|
|
|
|
|
|
|
|