Query time 0.00134
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "2.63"
},
"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.81",
"eval_cost": "0.10",
"prefix_cost": "0.91",
"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.59",
"eval_cost": "0.10",
"prefix_cost": "1.59",
"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.02",
"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.64",
"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 |
| 456 |
en |
<p><strong></strong><strong>Thank you for stopping by! My name is Terri. I love to make jewelry, and I will make jewelry out of most anything! I have been crocheting since I was six and love combining yarns for a unique texture and look. If you have been to my shop before, be sure to sort by newly listed so you can see my new additions. Let me know if you have any questions on my items. </strong><br></p>
<p><strong>And...yes, in the pic my readers do have the sticker showing the strength. I have them in different strengths throughout the house. I leave them on the readers so that if I pic up an older pair with a lower strength, I can look at the sticker and not think I am going blind!</strong></p>
<p><strong>In this picture I am making dainty little necklaces and hair bows for my granddaughter. I make my jewelry in the formal dining room. My husband said we should not have bought a house with a formal living and dining room, because we do not use them. Well, I am using them now!!! I have foil down on my table to protect it...and it forms to the table so it worked well, and rubber gloves on so I do not burn my fingers while making the bows! Just in case you were wondering...and, my mouth is open cuz I am talking.</strong></p><p><strong>And...When I mention in my listings that colors can vary by monitors...I spelled it very! Too many to change! </strong></p> |
<h6>I gladly accept returns and exchanges
</h6>
<p> Contact me within: <span class="text-gray-darker">14 days of delivery</span> Ship items back within: <span class="text-gray-darker">30 days of delivery</span> <br></p>
<h6> I don't accept cancellations </h6>
<p> But please contact me if you have any problems with your order. <br></p>
<h6>The following items can't be returned or exchanged Because of the nature of these items, unless they arrive damaged or defective, I can't accept returns for: </h6>
<ul><li>Custom or personalized orders</li><li>Perishable products (like food or flowers)</li><li>Digital downloads</li><li>Intimate items (for health/hygiene reasons)</li></ul>
<p> <strong>Conditions of return 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. I would suggest using the original packaging to mail it back.<br></strong></p>
<p><strong><br></strong>If you are not happy, I am not happy! Please contact me if you have an issue.<strong></strong></p>
<p><strong></strong></p> |
{"tmenu_style":"H","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":""} |
Jewels2at |
2401 Boardwalk Dr |
Mesquite |
A |
Jewels2at |
2401 Boardwalk Dr |
Mesquite |
TX |
US |
75181 |
Jewels2at@ymail.com |
|
|
|
|
none |
Y |
|
1587602598 |
|
|
283 |
|
a:4:{s:14:"company_fields";a:2:{i:37;s:5:"Terri";i:38;s:7:"Tarlton";}s:15:"admin_firstname";s:5:"Terri";s:14:"admin_lastname";s:7:"Tarlton";s:6:"fields";a:0:{}} |
4 |
acct_1EKSEEEJr57f8d5X |
|
17213,17375,17508,18864,17429,15086 |
|
|
|
|
|
|
pinterest.com/jewels2at |
|
|
|
|
UA-42437559-2 |
|
jewels2at.com |
A |
|
|
|
N |
0 |
0 |
0 |
0 |
0 |
|
S |
|
All-Star Plan |
jewels2at |
|
5.0000 |
456_2729 |