Query time 0.00183
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "2.66"
},
"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": "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.10",
"prefix_cost": "0.00",
"data_read_per_join": "1K"
},
"used_columns": [
"plan_id",
"lang_code",
"plan"
]
}
},
{
"table": {
"table_name": "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": "0.82",
"eval_cost": "0.10",
"prefix_cost": "0.92",
"data_read_per_join": "1K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
},
{
"table": {
"table_name": "discussionA",
"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": "0.61",
"eval_cost": "0.10",
"prefix_cost": "1.62",
"data_read_per_join": "24"
},
"used_columns": [
"thread_id",
"object_id",
"object_type"
]
}
},
{
"table": {
"table_name": "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": [
"goimagine.discussionA.thread_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "0.25",
"eval_cost": "0.18",
"prefix_cost": "2.05",
"data_read_per_join": "787"
},
"used_columns": [
"post_id",
"thread_id",
"status"
]
}
},
{
"table": {
"table_name": "discussion_rating",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"thread_id"
],
"key": "PRIMARY",
"used_key_parts": [
"post_id"
],
"key_length": "3",
"ref": [
"goimagine.discussion_posts.post_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.44",
"eval_cost": "0.18",
"prefix_cost": "2.66",
"data_read_per_join": "28"
},
"used_columns": [
"rating_value",
"post_id",
"thread_id"
],
"attached_condition": "<if>(is_not_null_compl(discussion_rating), (`goimagine`.`discussion_rating`.`thread_id` = `goimagine`.`discussionA`.`thread_id`), true)"
}
}
]
}
}
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 |
plan |
seo_name |
seo_path |
average_rating |
company_thread_ids |
| 2233 |
en |
<p>Hello,</p>
<p>I hope you enjoy the detail of these whimsical and colorful fairy ornaments that celebrate family love, life-long friendships, and milestone moments. </p>
<p>I started Runaway Pixies not only to share my fondness for art and all things handmade but to fill our world with kindness and love for each other. Diversity, inclusion, and positivity are ongoing themes you will find in my shop.</p>
<p>Enjoy, and I hope you find a Runaway to take home with you.</p>
<p>Cathy</p>
<p><b><br></b></p>
<p><b>FOLLOW US:</b><br></p>
<ul><li>Click here to <a href="https://www.instagram.com/runawaypixies" target="_blank"><span style="color: rgb(192, 80, 77);">Peek inside our Studio on Instagram</span></a></li><li>Click here to <a href="https://www.facebook.com/Runaway-Pixies" target="_blank"><span style="color: rgb(192, 80, 77);">Like our Facebook Page</span></a></li></ul>
<p><br></p>
<p><br></p> |
<p><strong></strong></p>
<hr>
<p><strong></strong><strong>RETURNS & EXCHANGES</strong></p>
<p>All sales are final. Buyers are responsible for any customs and import taxes that may apply. Returns may be made if you contact us within 3 days of delivery and ship the item in its original packaging within 7 days. Buyers are responsible for return shipping costs. If the item is not returned in its original condition, the buyer is responsible for any loss in value.</p>
<p>We are not responsible for delays due to customs or delays with the shipping carrier after the item leaves our studio.<br></p>
<p>Due to the nature of our products, the following items cannot be returned or exchanged UNLESS they arrive damaged or defective. We cannot accept returns for <br></p>
<ul><li>Custom or Personalized Orders</li><li>Digital Downloads</li></ul>
<p>If you have any questions or concerns, feel free to send a message to us.</p>
<p><br></p>
<p><strong>FREE SHIPPING</strong></p>
<p>All USA orders totaling $35 or more will receive free shipping from the order subtotal. Items must ship to ONE address and will arrive by USPS First Class mail with a tracking number. If an upgrade in shipping services is needed, please contact the seller to arrange payment The buyer is responsible for these additional shipping fees.</p> |
{"tmenu_style":"V","default_colors":"N","link_color":"#007d89","label_color":"#00a0af","icon_color":"#00a0af","main_btn_color":"#6dd1d6","branded_text_color":"#00a0af","vbp_1_url":"","vbp_2_url":"","vbp_3_url":"","vba_1_url":"","vba_2_url":"","vba_3_url":""} |
Runaway Pixies |
3470 Mcclure Bridge Rd # 435 |
Duluth |
A |
Runaway Pixies |
3470 Mcclure Bridge Rd # 435 |
Duluth |
GA |
US |
30096 |
runawaypixies@gmail.com |
|
|
|
|
none |
Y |
|
1621818827 |
|
|
0 |
|
|
2 |
acct_1Iv2eYAfdd1dojDr |
499770621334879 |
248958,129265,126793,248857,199158,196367,84591 |
UA-140229936-1 |
6J2HBFYQK726Y |
Kindness ornaments, handmade and personalized just for you. |
https://www.facebook.com/runawaypixies/ |
https://www.instagram.com/runawaypixies/?hl=en |
|
https://www.pinterest.com/RunwayPixies |
<p>FREE USA SHIPPING on orders $35+, no coupon needed.</p> |
|
|
|
UA-223988428-1 |
499770621334879 |
|
A |
|
|
|
N |
0 |
0 |
0 |
0 |
0 |
|
S |
|
Growth Plan |
runaway-pixies |
|
5.0000 |
2233_527691 |