Query time 0.00184
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.74"
},
"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` = 308648) 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": "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.56",
"data_read_per_join": "975"
},
"used_columns": [
"company_id",
"status",
"company",
"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.68",
"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.70",
"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.72",
"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.74",
"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>((308648 = 308648)), 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 |
| 308648 |
WM4358RH |
P |
A |
602 |
0.00 |
1 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1661870735 |
1697736754 |
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;} |
activity |
0 |
|
0 |
A |
0 |
0 |
0 |
Y |
|
|
|
|
0.00 |
0.00 |
0 |
1904880990 |
|
Letter |
|
N |
N |
day |
|
P |
|
en |
Spring in Dubai & Abu Dhabi |
|
|
|
<h2><span style="color:rgb(31,73,125);"></span></h2>
<h2><span style="color:rgb(31,73,125);"></span></h2>
<h2><span style="color:rgb(31,73,125);">€399, 5 ditë</span></h2>
<h4>Datat e udhetimit: <span style="color:rgb(51,51,51);"><span style="color:rgb(192,80,77);"><img src="https://webmarco.com/images/All%20vendors/grs%20construzioni/plane-icon.jpg?1661870613962" alt="plane-icon.jpg?1661870613962" /></span></span></h4>
<p>Tetor : 2, 9, 16, 23, 30</p><p>Nentor : 6, 13, 20, 27</p><p>Dhjetor : 4, 1</p>
<p><br /></p>
<p> Udhetimi Tirane – Abu Dhabi (Fluturimi direkt me Wizz Air)</p>
<p>Nisja nga Tirana ne 18:30 dhe mberritja ne Abu Dhabi ne 01:40. Numri i Fluturimit : SW7092 Transferta dhe akomodimi ne hotel me 4* ne Abu Dhabi me mengjes te perfshire.</p>
<p>Dita 02: Abu Dhabi City Tour (Turi i qytetit te Abu Dhabit)</p>
<p>Abu Dhabi – Njihet ndryshe si ”Manhatani i Arabise” per shkak te gradacelave ultra moderne. Kryeqyteti i Emirateve te Bashkuara Arabe, shtrihet ne nje ishull ne forme T-je, prane gjirit te Persise. Aty do te kemi mundesi per te vizituar vendet e mrekullueshme si Xhamine “Sheikh Zayed”, nje kryeveper e arkitektures neo-islamike si edhe nje nga xhamite me te bukura ne te gjithe boten. Xhamia ka mbi 1.000 shtylla ne zonat e saj e jashtme te cilat jane te veshura me me shume se 20.000 panele mermeri me gure gjysme te çmuar, duke perfshire guaskat, perlat etj. Vizita e kesaj xhamie eshte nje pervoje vertete e paharrueshme.</p>
<p>Vizita vazhdon duke pare “Pallatin e Emirateve” shume luksoz, i cili ndodhet ne vendin e tij mbreselenes. Me pas do te vizitojme Heritage Village, Marina Mall si edhe ishullin “Saadyat” i cili ofron nje pasqyre te vertete ne zhvillimin e qytetitme te pasur te botes. Ne vazhdim vizitojme edhe ishullin "Yas" ne te cilin ndodhet kompleksi "Ferrari World" dhe pista e garave te "Formula 1" - Pas perfundimit te programit, kthimi ne Dubai.</p>
<p>Sistemimi dhe fjetje ne Delta Hotels by Marriot 4* me mengjes.</p>
<p>Dita 03: Dubai City tour (Turi i qytetit te Dubait)</p>
<p>Fillimisht do t'i drejtohemi Xhamise Jumeriah (e cila eshte nje nga xhamite me te bukura ne Dubai). Me pas vazhdojme ne rrugen e famshme Sheikh Zayed (cilesuar edhe si arteria kryesore e qytetit). Gjate kesaj rruge do te kalojme ne Zonen e Biznesit (e mbushur me godina vertete unike) si psh Emirates Tower dhe Qendra e Tregetise Boterore. Gjithcka duket ne harmoni te plote dhe ky program do te vazhdoje te na tregoje mrekulli te tilla si: Burj Kalifa e cila eshte ndertesa me e larte ne bote 818 m, dhe prane saj ndodhet Dubai Mall, qe eshte Qendra Tregtare me e madhe ne bote. Vazhdojme viziten tone ne brendesi te Palmes Jumeirah, e cila eshte nje arkitekture shume e vecante e ndertuar totalisht mbi uje. Aty do kemi mundesi te shohim Hotelin luksoz Atlantis The Palm dhe mundesi per foto panoramike. Me pas do te vizitojme hotelin Burj Al Arab, i cili eshte hoteli i vetem ne bote me 7*. Mundesi per kohe te lire ne Pazarin e Erzave dhe Frutave te thata duke perfundur programin tone ne zonen e famshme Dubai Gold Souk, e cila per nga vete emri eshte zona me e njohur e Argjendarise ne Lindjen e Mesme. Vazhdojme me Dubai Marina qe eshte edhe shetitorja me e njohur ne Dubai ku mund te shohim edhe Klubin e Jahteve . Kohe e lire per dreken dheme pas akomodimi ne hotel.</p>
<p>Optional:</p>
<p>Burj Khalifa - 65 EUR per person. Dubai Fountain Show - 59 EUR per person</p>
<p>Dita 04: Free day (Dite e lire)</p>
<p>Opsionale: Safari ne shkretetire - 50 Euro</p>
<p>Largohuni per pak nga jeta e ngarkuar e qytetit dhe shijoni shkelqimin e shkretetires se Dubait me turneun tone te safarit ne shkretetire ne mbremje. Zgjedhim mbasditen pasi eshte koha me e mire per te vizituar shkretetirat qe gjate mbremjes ftohen per te mirepritur driten e henes dhe vizitoret nga e gjithe bota.</p>
<p>Dita 05: Check-out nga hoteli dhe transferim per ne Aeroportin Internacional te Abu Dhabi</p>
<p>Udhetimi Abu Dhabi - Tirane (Fluturimi direkt me Wizz Air) Nisja nga Abu Dhabi ne 14:05 dhe mberritja ne Tirane ne 16:55. Numri i Fluturimit: SW7091</p>
<p>Fundi i sherbimit tone.</p>
<p>-------------------------------------------------------------------------</p>
<p>GENERAL Te Perfshira:</p>
<p>Fluturimin direkt dhe taksat aeroportuale. Akomodimi 1 nate ne Abu Dhabi dhe 3 nete ne Dubai. Akomodimi ne hotele me mengjes te perfshire. Te gjitha transfertat sipas programit. City tour Dubai + Abu Dhabi me guide lokale. Guide profesionale shoqeruese Shqiptar.</p>
<p>Te Paperfshira:</p>
<p>Vaktet e papermendura ne program Bagazhet ekstra.</p>
<p>KUJDES: Cdo klient duhet te kete se paku 6 muaj validitet ne pasaportat e tyre. Pasaporta me me pak se 6 muaj validitet nga dita e nisjes nga Tirana, do te ndalet ne check-in te aeroportit dhe do te ndalohet kalimi nga policia kufitare. VAS TOUR OPERATOR nuk merr asnje pergjegjesi mbi kostot shtese qe mund te rezultojne pas kesaj ndalese, nje gje e tille eshte pergjegjesi e pasagjerit.</p>
<h4><span style="color:rgb(51,51,51);"><span style="color:rgb(192,80,77);"></span></span></h4>
<p></p>
<p></p> |
travel, nature, travelphotography, photography, toptours, webmarcolove, photooftheday, instagood, travelgram, picoftheday, instagram, beautiful, photo, wanderlust, naturephotography, adventure, art, travelblogger, |
Travel agency offering services: Organizing tour packages, travel service, plane and ferry tickets, professional guide inside and outside the country. |
travel, nature, travelphotography, photography, toptours, webmarcolove, photooftheday, instagood, travelgram, picoftheday, instagram, beautiful, photo, wanderlust, naturephotography, adventure, art, travelblogger, |
Spring in Dubai & Abu Dhabi - Top Tours |
|
|
|
|
|
|
|
|
469.00000000 |
10247M |
98719 |
Top Tours |
|
|
|
|
|
spring-in-dubai-and-abu-dhabi |
266/2577/10247 |
B |
|
|
N |
04/05/2023 |
04/05/2023 |
0 |
0 |
|
N |
N |
|
|