Query time 0.00157
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.00"
},
"ordering_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "cscart_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": "cscart_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": "p",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"plan_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": "80"
},
"used_columns": [
"plan_id",
"price",
"periodicity",
"commission",
"products_limit",
"revenue_limit",
"vendor_store",
"categories",
"storefronts"
]
}
}
]
}
}
}
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 |
price |
periodicity |
commission |
products_limit |
revenue_limit |
vendor_store |
categories |
storefronts |
632 |
sq |
<p></p>
<h4>Produktet me te mira per shtepine, aktivitetin, biznesin, qendra tregetare, komplekse pallatesh banimi, hotele, shkolla, cerdhe etj. Pllaka hidrosanitare nga fabrikat me prestigjoze europiane. cilesi maksimale dhe cmimet me te, mira ne tregun shqiptar.</h4> |
|
kotarja, pllaka, shtepi, arredim, aktivitet, biznes, kompani, qender tregtare, pallat, kompleks, banim, banese, hotel, dhome, shkolla, cerdhe, kopshte, hidrosanitare, fabrika, prestigjioze, europiane, cilesi, maksimale, cmime, lire, treg, shqiptar, shqipe |
Produktet me te mira per shtepine, aktivitetin, biznesin, qendra tregetare, komplekse pallatesh banimi, hotele, shkolla, cerdhe etj. Pllaka hidrosanitare nga fabrikat me prestigjoze europiane. cilesi maksimale dhe cmimet me te, mira ne tregun shqiptar. |
Pllaka Kotarja |
Pllaka Kotarja |
Autostrade Tirane-Durres ,Rruga Industriale , Km. 8, km 8 Tirane, Tirane, 1001 Albania |
Autostrade Tirane-Durres |
A |
Pllaka Kotarja |
Autostrade Tirane-Durres ,Rruga Industriale , Km. 8, km 8 Tirane, Tirane, 1001 Albania |
Autostrade Tirane-Durres |
AL-11 |
AL |
1001 |
info@pllakakotarja.al |
+355686413857 |
https://www.pllakakotarja.al/? |
|
|
none |
Y |
|
1667810827 |
|
|
0 |
|
|
N |
N |
N |
14 |
280679199 |
|
|
|
|
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
0.00 |
month |
20.00 |
0 |
0.00 |
1 |
|
|