Query time 0.00036
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 |
510 |
sq |
<p><strong>Këpuca Hirushes</strong></p>
<p>Këpuca Hirushes have been operating in the market since 2000, launching</p>
<p>the latest fashion of shoes with super quality and prices competitive.</p>
<p></p> |
|
Shoes, sneakers, Këpuca Hirushes, modern, fashion, sneakers, beautiful, comfortable, with stones, with belts, ankles, class, fine, events, colors, green, black, white, red, beige, with rubber, comfortable, high, with heels, small, webmarco, website, site, |
Këpuca Hirushes has been operating in the market since 2000, launching the latest fashion of shoes with super quality and prices competitive. |
Këpuca Hirushes - Give a woman the right shoes & she can conquer the world |
Këpuca e Hirushes |
Rruga Petronini Luarasi, 101 |
Tirana |
A |
Këpuca e Hirushes |
Rruga Petronini Luarasi, 101 |
Tirana |
AL-11 |
AL |
1001 |
eriselda_capuni@yahoo.com |
|
https://hirushe.al/? |
|
|
none |
Y |
|
1643635091 |
49 |
|
0 |
|
|
N |
N |
N |
13 |
261128077 |
|
|
|
|
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
0.00 |
month |
12.20 |
0 |
0.00 |
1 |
|
|