Query time 0.00106
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "2.86"
},
"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.88",
"eval_cost": "0.10",
"prefix_cost": "0.98",
"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.74",
"eval_cost": "0.10",
"prefix_cost": "1.82",
"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.25",
"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.86",
"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 |
| 2607 |
en |
<p></p>
<p>I was raised in the Military and lived in several countries and several states. I've loved experiencing all the "sights and sounds" of every place I have lived and visited. I feel this appreciation of other cultures has contributed to my love of art, color and music.<br>I've always been fascinated by the Ribbons of Rainbows that dance around a room when the sun catches a crystal. <br>I use primarily Swarovski and Swarovski Strass crystals. <br>Opening my shop, has given me the opportunity to share, with you, the pleasure I get from my Dancing Rainbows.</p>
<p></p> |
<p></p><p>Shipping will be via U.S.P.S. (United States Postal Service), within 48 hours of receipt of cleared payment, excluding Saturday, Sunday and Holidays. <br>I ship Priority Mail (unless different Shipping Options are given in the Item Description), within the US and that includes Tracking. <br>Shipping for International customers will be First Class U.S.P.S. Shipping charges are noted with each listing. Transit time varies and is estimated by the U.S.P.S. to be generally between 10-14 days. If you would like to ship using any other method, please let me know so that I can calculate that cost for you. <br>**Please note, that International buyers are responsible for any customs or duties charges that may apply. You may upgrade your shipping and add insurance for an additional charge. <br>If you prefer to ship USPS First Class instead of Priority Mail, please contact me so that I can gladly adjust your invoice. </p>
<p>Insurance is optional but once the package has left my hands, I am no longer responsible for any uninsured items.</p>
<p>Arizona residents will be charged 7.850% State Sales Tax. </p>
<p>I take great care in wrapping the Sun Catchers and Jewelry in bubble wrap to protect them.</p>
<p>You will receive an email confirming your order and tracking information. <br>Please note *** I will use the address provided by PayPal unless you contact me prior to shipping and let me know otherwise. Please make sure that your shipping address and email address are correct.</p><p><br></p><p></p><p>I want you to be completely satisfied with your purchase. If you are unhappy with your purchase, you may return any item in the original, unaltered condition and original packaging within 14 days of purchase for a refund, minus shipping charges. I will also exchange for an equal value item. Please contact me first before returning your item.<br>Any refund payments will be issued via PayPal only and upon receipt of merchandise.</p><p><br></p><p></p><p>All my Sun Catchers and Jewelry items are designed and assembled by me. All items used in the creating of the Sun Catchers and Jewelry items will be stated in the Item Description. <br>My creations come from a smoke free, pet free home.</p><br><p></p> <br><p></p><p></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":""} |
Dancing Rainbows |
2650 Patio Simpatico |
Lake Havasu City |
A |
Dancing Rainbows |
2650 Patio Simpatico |
Lake Havasu City |
AZ |
US |
86406 |
wilsonsteeup@frontiernet.net |
|
|
|
|
none |
Y |
|
1625332651 |
|
|
0 |
|
|
3 |
acct_1J9EpRGvMp8dazx3 |
|
96192,97015,97017,97022,96968,96943,97013,96233,96926,96195,96217,96244 |
280208003 |
NAN6GRH7EJ36Q |
I create Sparkling Sun Catchers and Jewelry |
https://www.facebook.com/dancingrainbows/settings/?tab=page_info |
|
https://twitter.com/DanceRainbows |
https://www.pinterest.com/wilsonsteeup/_created/ |
<p></p>
<p>At Dancing Rainbows, my desire is to decorate the World... one Sparkle at a time.
I create Sparkling Sun Catchers and Jewelry. Would you like something Special? Together, let's create something just for you...Uniquely You.<br></p> |
|
|
|
280208003 |
|
|
A |
|
|
|
N |
0 |
0 |
0 |
0 |
0 |
|
S |
|
Professional Plan |
dancing-rainbows |
|
5.0000 |
2607_701811 |