Query time 0.00134
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 |
| 681 |
sq |
<p>Metal Nesimi company is a company with 12 years of experience in the field of metal constructions. This experience was gained by working in Europe, mainly in Greece, where he participated in the construction of the Athens 2004 Olympic stadiums.</p>
<p>We are committed to meeting the highest ethical and professional standards, in harmony with the principles of social, economic and environmental sustainability.</p> |
|
construction, engineering, engineer, builder, architecture, building materials, experience, metal construction, mesi, metal, ltd, company, experience, quality, leader, truck, crane, welder, lathe, building, stadium, security, metal, Safety |
Metal Nesimi company is a company with 12 years of experience in the field of metal constructions.We are committed to meeting the highest ethical and professional standards, in harmony with the principles of social, economic and environmental sustainabili |
Metal Nesimi shpk |
Metal Nesimi shpk |
Rruga Egnatia, nr.pasurie 1156\45 dhe nr 1156\40, zona kadastrale 2105, Kashar, Tirane, Nr.pasurie 1156\45 dhe nr 1156\40 |
Tirana |
A |
Metal Nesimi shpk |
Rruga Egnatia, nr.pasurie 1156\45 dhe nr 1156\40, zona kadastrale 2105, Kashar, Tirane, Nr.pasurie 1156\45 dhe nr 1156\40 |
Tirana |
AL-11 |
AL |
1051 |
metalnesimi@gmail.com |
+355686031910 |
https://metalnesimi.com/? |
|
|
none |
Y |
|
1676541691 |
|
|
0 |
|
|
N |
N |
N |
14 |
|
|
|
|
|
|
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:1683151200;s:7:"to_date";i:1683151200;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:"04/05/2023";s:7:"to_date";s:10:"04/05/2023";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:{}} |
|
|
|
|
|
|
|
|
Marco Travel |
metal-nesimi-shpk |
|
|
681_0 |