Query time 0.00111
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "5.06"
},
"nested_loop": [
{
"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": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "9K"
},
"used_columns": [
"company_id",
"status",
"company",
"lang_code",
"address",
"city",
"state",
"country",
"zipcode",
"email",
"phone",
"url",
"storefront",
"secure_storefront",
"entry_page",
"redirect_customer",
"countries_list",
"timestamp",
"shippings",
"logos",
"request_user_id",
"request_account_name",
"request_account_data",
"pre_moderation",
"pre_moderation_edit",
"pre_moderation_edit_vendors",
"plan_id",
"sd_vendor_helper",
"identifier_facebook_pixel",
"stripe_connect_account_id",
"tax_number",
"facebook_pixel_id",
"facebook_api_token",
"handling_time_us",
"handling_time_uk",
"handling_time_it",
"handling_time_in",
"handling_time_mx",
"handling_time_es",
"handling_time_de",
"handling_time_fr",
"handling_time_cn",
"handling_time_ca",
"handling_time_jp",
"handling_time",
"blocked_date",
"booking_data",
"stripe_connect_account_type",
"registered_from_storefront_id",
"ec_rfq_whatsapp_number",
"ec_rfq_phone_number",
"ec_rfq_bhf",
"ec_rfq_bht",
"sd_ga_tracking_code",
"sd_ga_api_secret"
]
}
},
{
"table": {
"table_name": "company_descriptions",
"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": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "3K"
},
"used_columns": [
"company_id",
"lang_code",
"company_description",
"terms",
"meta_keywords",
"meta_description",
"page_title",
"i18n_company",
"i18n_address",
"i18n_city"
]
}
},
{
"table": {
"table_name": "cscart_vendor_plan_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"plan_id",
"lang_code"
],
"key_length": "10",
"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.20",
"prefix_cost": "0.00",
"data_read_per_join": "792"
},
"used_columns": [
"plan_id",
"lang_code",
"plan"
]
}
},
{
"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": "1.00",
"eval_cost": "0.20",
"prefix_cost": "1.20",
"data_read_per_join": "1K"
},
"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": 1,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "1.00",
"eval_cost": "0.20",
"prefix_cost": "2.40",
"data_read_per_join": "24"
},
"used_columns": [
"thread_id",
"object_id",
"object_type"
]
}
},
{
"table": {
"table_name": "cscart_discussion_posts",
"access_type": "ref",
"possible_keys": [
"thread_id",
"thread_id_2"
],
"key": "thread_id_2",
"used_key_parts": [
"thread_id",
"status"
],
"key_length": "6",
"ref": [
"webmarco.cscart_discussion.thread_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "1.00",
"eval_cost": "0.24",
"prefix_cost": "3.64",
"data_read_per_join": "532"
},
"used_columns": [
"post_id",
"thread_id",
"status"
]
}
},
{
"table": {
"table_name": "cscart_discussion_rating",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"thread_id"
],
"key": "PRIMARY",
"used_key_parts": [
"post_id"
],
"key_length": "3",
"ref": [
"webmarco.cscart_discussion_posts.post_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.19",
"eval_cost": "0.24",
"prefix_cost": "5.06",
"data_read_per_join": "19"
},
"used_columns": [
"rating_value",
"post_id",
"thread_id"
],
"attached_condition": "<if>(is_not_null_compl(cscart_discussion_rating), (`webmarco`.`cscart_discussion_rating`.`thread_id` = `webmarco`.`cscart_discussion`.`thread_id`), true)"
}
}
]
}
}
Result
| company_id |
lang_code |
company_description |
terms |
meta_keywords |
meta_description |
page_title |
i18n_company |
i18n_address |
i18n_city |
status |
company |
address |
city |
state |
country |
zipcode |
email |
phone |
url |
storefront |
secure_storefront |
entry_page |
redirect_customer |
countries_list |
timestamp |
shippings |
logos |
request_user_id |
request_account_name |
request_account_data |
pre_moderation |
pre_moderation_edit |
pre_moderation_edit_vendors |
plan_id |
sd_vendor_helper |
identifier_facebook_pixel |
stripe_connect_account_id |
tax_number |
facebook_pixel_id |
facebook_api_token |
handling_time_us |
handling_time_uk |
handling_time_it |
handling_time_in |
handling_time_mx |
handling_time_es |
handling_time_de |
handling_time_fr |
handling_time_cn |
handling_time_ca |
handling_time_jp |
handling_time |
blocked_date |
booking_data |
stripe_connect_account_type |
registered_from_storefront_id |
ec_rfq_whatsapp_number |
ec_rfq_phone_number |
ec_rfq_bhf |
ec_rfq_bht |
sd_ga_tracking_code |
sd_ga_api_secret |
plan |
seo_name |
seo_path |
average_rating |
company_thread_ids |
| 462 |
en |
<p style="text-align:center;font-size:40px;font-weight:bold;color:#b47b4f;"><strong>Zerja Resort & SPA </strong></p>
<p style="text-align:center;font-size:25px;font-weight: bold;">
- You are not leaving a dream , You are leaving Zerja Resort!<br></p>
<p><br> </p>
<p><video class="vid" controls="" width="100%" height="100%"><br>
<source src="https://webmarco.com/images/All%20vendors/Zerja%20resort/ezgif.com-gif-maker.mp4?1639473767073"><br>
</video></p>
<div class="span7">
<p style="font-size:22px;margin-top:10px;font-weight: bold;">Our Cousine</p>
<p style="font-size:18px;margin-top:10px;">Peshkopia already has something to be proud of. We offer the best conditions with the best prices in the Peshkopi area.Our resort already offers a variety of services such as:
Restaurant - combined with German and Italian cuisine.The best and most delicious pizzas prepared in the wood oven with the characteristic aroma of the wood oven.
We are considered the best in Hospitality, our hotel has 5 stars certified by the Ministry of Tourism.
Professional staff and with a fantastic care for every client who visits our hotel.</p>
</div>
<br>
<div class="span7">
<img src="https://webmarco.com/images/icons_wa_flags_contact/studio%20jovial/fotooo.jpg?1642090622174">
</div>
</div>
<br>
<br>
<br>
<br>
<div class="row-fluid" bis_skin_checked="1">
<div class="span7" bis_skin_checked="1">
<video controls="" width="70%" height="50%">
<source src="https://webmarco.com/images/All%20vendors/Zerja%20resort/124009958_977004719377285_1656584945943761450_n.mp4?1639478425878">
</video>
</div>
<br>
<br>
<br>
<div class="span7 cimi" bis_skin_checked="1">
<p class="par4"><b style="font-size: 18px;">
The newest innovation in the city of Peshkopi is that Resort Zerja already offers SPA services:</p>
<br>
<br>
<div class="span7">
<p style="font-size:18px;">
Sauna
<br>
SHamam Turk
<br>
Solar
<br>
Jacuzzi (soon)
<br>
Massage Room (soon)
<br>
Indoor Pool (soon)
</p>
<br>
<p><br></p>
<p style="font-size:18px;">
</p>
</div>
</div>
<p><br></p>
<br>
<br>
<div class="row-fluid">
<p style="text-align:center;font-size:16px;"> In Summer we offer canoe trips, a fantastic ride along <b>"Drin i Zi River"</b> to remain in your mind as an unforgettable experience.
</p>
<p style="text-align:center;font-weight:bold;font-size:16px;">
As for all tourists at home and abroad Our Tourist Guide, so that everyone who comes here can see how beautiful the City of Peshkopi is.
</p>
<br>
<ul style="font-size:18px;text-align:center;font-weight: bold;">Our Guide Includes:
<li style="text-align:center;font-size:18px;">-Climbing Mount Korab (the highest mountain in the Balkans)</li>
<li style="text-align:center;font-size:18px;">-Visit Beautiful "Lura" with it's 7 lakes</li>
<li style="text-align:center;font-size:18px;">-Pucesti Waterfall</li>
<li style="text-align:center;font-size:18px;">-Radomira</li>
<li style="text-align:center;font-size:18px;">-Grama</li>
</ul>
<br>
<p style="font-size:18px;"> Some features of <b>"Zerja Resort & SPA" </b>are the organization of holidays and parties offering you an extraordinary family environment in order to spend your joys in the best possible way.</p>
</div>
<br>
<p style="font-size:18px;text-align: center;"> Come visit us, you will not be disappointed .</p>
</div>
<p style="font-size:25px;text-align: center;font-weight: bold;color:#b47b4f"> We Love You To The Moon and Back!</p>
</div> |
|
Zerja Resort & SPA, zerja resort, spa, hotel, hotel peshkop, hoteli më i mirë, hoteli me 5 yje, prenotim hoteli, sauna, xhakuzi, restorant zerja, pushime, dhoma, rezervime, K87018701L, web marco, webmarco |
Le të mos flasim më, por të veprojmë! Ne jemi më të mirët në Hoteleri, hoteli ynë ka 5 yje të certifikuar nga Ministria e Turizmit dhe ofron kushtet më të mira me çmimet më të mira në zonë. |
Zerja Resort & SPA - Nuk po jeton një ëndërr, po jeton Resort Zerja! |
Zerja Resort & SPA |
Rruga Peshkopi-Tirane Km1 |
Peshkopi |
A |
Zerja Resort & SPA |
Rruga Peshkopi-Tirane Km1 |
Peshkopi |
AL-09 |
AL |
8301 |
zerja2021@gmail.com |
+355675431510 |
https://zerja.al/? |
|
|
none |
Y |
|
1638546069 |
|
|
0 |
|
|
N |
N |
N |
13 |
257395583 |
|
|
|
|
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
Vat Excluded 12.20 |
zerja-resort-and-spa-sq-en |
|
|
462_0 |