Query time 0.00084
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.00"
},
"ordering_operation": {
"using_filesort": false,
"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.10",
"prefix_cost": "0.00",
"data_read_per_join": "14K"
},
"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",
"plan_id",
"stripe_connect_account_id",
"identifier_facebook_pixel",
"featured_products",
"sd_ga_tracking_code",
"paypal_commerce_platform_account_id",
"tagline",
"url_facebook",
"url_instagram",
"url_twitter",
"url_pinterest",
"announcement",
"shippo_api_token",
"shippo_carrier",
"shippo_service_type",
"vendor_ga_tracking_code",
"vendor_fb_tracking_code",
"custom_domain",
"custom_domain_status",
"taxjar_key",
"taxjar_export_statuses",
"taxjar_export_csv_data",
"ag_hide_city",
"updated_timestamp",
"suspend_date",
"grace_period_start",
"last_time_suspended",
"last_debt_notification_time",
"tax_number",
"stripe_connect_account_type",
"registered_from_storefront_id"
]
}
},
{
"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.10",
"prefix_cost": "0.00",
"data_read_per_join": "1K"
},
"used_columns": [
"company_id",
"lang_code",
"company_description",
"terms",
"subdomain_colors",
"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.10",
"prefix_cost": "0.00",
"data_read_per_join": "112"
},
"used_columns": [
"plan_id",
"price",
"periodicity",
"commission",
"products_limit",
"revenue_limit",
"vendor_store",
"categories",
"storefronts"
]
}
}
]
}
}
}
Result
| company_id |
lang_code |
company_description |
terms |
subdomain_colors |
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 |
plan_id |
stripe_connect_account_id |
identifier_facebook_pixel |
featured_products |
sd_ga_tracking_code |
paypal_commerce_platform_account_id |
tagline |
url_facebook |
url_instagram |
url_twitter |
url_pinterest |
announcement |
shippo_api_token |
shippo_carrier |
shippo_service_type |
vendor_ga_tracking_code |
vendor_fb_tracking_code |
custom_domain |
custom_domain_status |
taxjar_key |
taxjar_export_statuses |
taxjar_export_csv_data |
ag_hide_city |
updated_timestamp |
suspend_date |
grace_period_start |
last_time_suspended |
last_debt_notification_time |
tax_number |
stripe_connect_account_type |
registered_from_storefront_id |
price |
periodicity |
commission |
products_limit |
revenue_limit |
vendor_store |
categories |
storefronts |
| 5782 |
en |
<p class="text-center">Hello! My name is Angela Gabbard and I have been making dolls....Well, for a long time. 25+ years! Time flies! My favorite time of year is Halloween, so my favorite dolls to make are Halloween/Horror related. If you love Halloween and all of the darker delights as I do I am sure you will find something, you like. I am always open to new doll ideas...so if you have something in mind just pm me on facebook...the link is on this page somewhere. Just look up Spooky4u2 and you will find me.</p> |
<p>All dolls are non refundable. Please read description of each doll. If you have ANY questions please feel free to message me. </p> |
{"tmenu_style":"V","default_colors":"N","link_color":"#e52e07","label_color":"#af4d00","icon_color":"#af2e00","main_btn_color":"#c34e24","branded_text_color":"#9900ff","vbp_1_url":"","vbp_2_url":"","vbp_3_url":"","vba_1_url":"","vba_2_url":"","vba_3_url":""} |
Spooky4u2 Dolls |
115 crawford ave |
winchester |
A |
Spooky4u2 Dolls |
115 crawford ave |
winchester |
KY |
US |
40391 |
spooky4u2@gmail.com |
+18594043855 |
|
|
|
none |
Y |
|
1646445237 |
|
|
0 |
|
|
4 |
acct_1HjB3lAt3hHcc2ML |
|
|
|
6CSH5YUZ5NL8L |
Spooky4u2 |
www.facebook.com/spooky4u2 |
www.instagram.com/spooky4u2dollsanddecor |
|
|
<p>So happy to be apart of this marketplace! If you have any questions, feel free to email me.</p> |
oauth.WbvDoSgzQGX15XDDflBhgsQPdt6QItxE8C3YOEx_.9pEp77kYNxh-60iIgh97VJp3M99T3o_Om8p7gtJBVOc |
|
|
|
|
spooky4u2.com |
A |
|
|
|
N |
0 |
0 |
0 |
0 |
0 |
|
S |
|
10.00 |
onetime |
3.50 |
1000 |
0.00 |
1 |
|
|