Query time 0.00172
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 |
487 |
sq |
<p class="text-center"><strong>Hotel Akademia Voskopojë</strong><br></p>
<p class="text-center">Hotel Akademia, built in the 50s is located at a distance of about 1000m<br>northwest of the village of Voskopoja, between the evergreen greenery and the fresh air.<br>After the restoration in the years 2000-2004, Hotel Akademia offers hotel service with 16 rooms 13 villas, a restaurant where you can enjoy traditional Korça cuisine as well as the stunning beauty of nature.<br>Among other things, do not forget to visit the village with 24 former Churches where the history of civilization and development of Voskopoja. Just 400 meters from the hotel is the Monastery of St. Prodhrom, the oldest existing building in the village, built-in 1932.</p> |
|
Akademia Hotel Voskopoja, k338100341, Voskopoja, restaurant, hotel service, Korca, private villas, quiet nature, relaxation, mountain activity, camping, mountain tourism, wooden villas |
Hotel Akademia, built in the 50s is located at a distance of about 1000m northwest of the village Voskopoja, between the permanent greenery and fresh air. After the restoration in the years 2000-2004, Hotel Akademia offers hotel service with 16 rooms 13 v |
Hotel Akademia Voskopojë - Greenery and Fresh Air |
Hotel Akademia Voskopojë |
Rruga Grigor Heba Tiranë. |
Voskopojë |
A |
Hotel Akademia Voskopojë |
Rruga Grigor Heba Tiranë. |
Voskopojë |
AL-06 |
AL |
1002 |
eri.lico@yahoo.com |
+355 69 202 3047 |
https://test.dev-webmarco.com/ |
|
|
none |
Y |
|
1641995306 |
|
|
0 |
|
|
N |
N |
N |
13 |
259887274 |
|
|
|
|
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
a:32:{s:12:"booking_type";s:1:"N";s:9:"from_date";i:1710975600;s:7:"to_date";i:1710975600;s:9:"slot_time";s:1:"0";s:9:"free_time";s:1:"0";s:9:"days_data";s:738:"a:21:{s:13:"sunday_status";i:0;s:24:"sunday_timing_start_time";s:0:"";s:22:"sunday_timing_end_time";s:0:"";s:13:"monday_status";i:0;s:24:"monday_timing_start_time";s:0:"";s:22:"monday_timing_end_time";s:0:"";s:14:"tuesday_status";i:0;s:25:"tuesday_timing_start_time";s:0:"";s:23:"tuesday_timing_end_time";s:0:"";s:16:"wednesday_status";i:0;s:27:"wednesday_timing_start_time";s:0:"";s:25:"wednesday_timing_end_time";s:0:"";s:15:"thursday_status";i:0;s:26:"thursday_timing_start_time";s:0:"";s:24:"thursday_timing_end_time";s:0:"";s:13:"friday_status";i:0;s:24:"friday_timing_start_time";s:0:"";s:22:"friday_timing_end_time";s:0:"";s:15:"saturday_status";i:0;s:26:"saturday_timing_start_time";s:0:"";s:24:"saturday_timing_end_time";s:0:"";}";s:17:"quantity_selector";s:1:"N";s:24:"sunday_timing_start_time";s:0:"";s:22:"sunday_timing_end_time";s:0:"";s:24:"monday_timing_start_time";s:0:"";s:22:"monday_timing_end_time";s:0:"";s:25:"tuesday_timing_start_time";s:0:"";s:23:"tuesday_timing_end_time";s:0:"";s:27:"wednesday_timing_start_time";s:0:"";s:25:"wednesday_timing_end_time";s:0:"";s:26:"thursday_timing_start_time";s:0:"";s:24:"thursday_timing_end_time";s:0:"";s:24:"friday_timing_start_time";s:0:"";s:22:"friday_timing_end_time";s:0:"";s:26:"saturday_timing_start_time";s:0:"";s:24:"saturday_timing_end_time";s:0:"";s:1:"R";a:4:{s:9:"from_date";s:10:"21/03/2024";s:7:"to_date";s:10:"21/03/2024";s:20:"minimum_booking_time";s:1:"0";s:10:"price_wise";a:0:{}}s:15:"show_price_date";s:1:"N";s:12:"blocked_date";s:0:"";s:13:"sunday_status";i:0;s:13:"monday_status";i:0;s:14:"tuesday_status";i:0;s:16:"wednesday_status";i:0;s:15:"thursday_status";i:0;s:13:"friday_status";i:0;s:15:"saturday_status";i:0;s:10:"price_wise";a:0:{}} |
|
|
|
|
|
|
|
|
Vat Excluded 12.20 |
hotel-akademia-voskopoje |
|
|
487_0 |