Query time 0.00101
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "2.72"
},
"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.83",
"eval_cost": "0.10",
"prefix_cost": "0.93",
"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.65",
"eval_cost": "0.10",
"prefix_cost": "1.68",
"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.10",
"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.72",
"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 |
| 198 |
en |
<p>Teresa Delosh of Couture Jewelry specializes in handmade artisan jewelry that is designed to become family heirlooms for generations to come. I love to make jewelry that you will be proud to pass on to your family. I feature beadweaving, free standing lace, vinyl and leather jewelry. Now offering fashion accessories along with our jewelry.</p> |
<p>PROCESSING TIME</p>
<p>Jewelry that is ready to ship will be available for shipping within 7 days. Orders may be shipped earlier, but are not guaranteed to be shipped prior to 7 days.</p>
<p><br></p>
<p>SELLING TO USA ONLY</p>
<p>Couture Jewelry doesn't offer shipping outside of the United States</p>
<p><br></p>
<p>CANCELLATIONS</p>
<p>Couture Jewelry does not offer cancellations. If there are any problems, please contact Couture Jewelry at info@couture-jewelry.com</p>
<p><br></p>
<p>GENERAL TERMS</p>
<p>Satisfaction is 100% guaranteed. If there should be any problems with an order, please contact me first before returning. </p>
<p>If after talking with you about your order you still wish to return the item please send back to Couture Jewelry in the original, unaltered condition and the original packaging within 14 days of purchase for a refund of the purchase price. If we have decided ahead of time you would like to exchange your purchased item for an equal value item, we can do this as well. </p>
<p>PLEASE DO NOT RETURN ANY ITEMS WITHOUT CONTACTING COUTURE JEWELRY FIRST. <strong>BUYER</strong> is responsible for shipping costs to send products back to Couture Jewelry. If the product is received not in original condition the <strong>BUYER</strong> is responsible for any loss in value.</p>
<p><strong>Returns or exchanges are not accepted on the following: </strong></p>
<p><strong></strong><br></p>
<ul><li><strong> Merchandise returned after 14 days from the original ship date </strong></li><li><strong> Personal items such as face masks</strong></li><li><strong> Custom Made Orders </strong></li><li><strong> Items that have been purchased on sale. </strong></li></ul>
<p>Refunds will be issued via Stripe once the merchandise has been received by Couture Jewelry. If you have any questions about your order, please do not hesitate to contact me by email at info@couture-jewelry.com</p>
<p><br></p>
<p><strong>NO RETURNS ON PERSONAL ITEMS SUCH AS FACE MASKS!</strong></p>
<p><b class="_2K_N3" aria-expanded="false" data-hook="collapse-info-button"><strong></strong><br></b></p>
<p><b class="_2K_N3" aria-expanded="false" data-hook="collapse-info-button"><br></b></p>
<p><b class="_2K_N3" aria-expanded="false" data-hook="collapse-info-button"><br></b><br></p>
<p><b class="_2K_N3" aria-expanded="false" data-hook="collapse-info-button"></b></p>
<p><b class="_2K_N3" aria-expanded="false" style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image: none; background-origin: padding-box; background-position-x: 0%; background-position-y: 0%; background-repeat: repeat; background-size: auto; border-bottom-color: currentColor; border-bottom-style: none; border-bottom-width: 0px; border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; border-left-color: currentColor; border-left-style: none; border-left-width: 0px; border-right-color: currentColor; border-right-style: none; border-right-width: 0px; border-top-color: currentColor; border-top-style: none; border-top-width: 0px; box-sizing: border-box; color: rgb(0, 0, 0); cursor: pointer; display: flex; font-family: wfont_890dd1_d811b5e3bc4b4d1fbcc513de8e39b099,wf_d811b5e3bc4b4d1fbcc513de8,orig_poppins_bold; font-size: 21px; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: 26px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: invert; outline-style: none; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; position: relative; text-align: inherit; text-decoration: inherit; vertical-align: baseline; width: 100%;" data-hook="collapse-info-button"><br></b></p> |
{"tmenu_style":"V","default_colors":"N","link_color":"#007d89","label_color":"#00a0af","icon_color":"#AF006C","main_btn_color":"#6dd1d6","branded_text_color":"#00a0af","vbp_1_url":"https://stageuat.goimagine.com/index.php?dispatch=companies.view&company_id=198","vbp_2_url":"","vbp_3_url":"","vba_1_url":"","vba_2_url":"","vba_3_url":""} |
Couture Jewelry with Heirloom Legacy |
7013 Marye Road |
Spotsylvania |
A |
Couture Jewelry with Heirloom Legacy |
7013 Marye Road |
Spotsylvania |
VA |
US |
22551 |
info@couture-jewelry.com |
|
|
|
|
none |
Y |
|
1585536224 |
|
|
0 |
|
a:4:{s:14:"company_fields";a:2:{i:37;s:6:"Teresa";i:38;s:6:"Delosh";}s:15:"admin_firstname";s:6:"Teresa";s:14:"admin_lastname";s:6:"Delosh";s:6:"fields";a:0:{}} |
3 |
acct_1GSDlGDFWuMfkbTq |
|
3061,3132,36088,15797,36153,47663 |
UA-46277369-2 |
|
|
|
|
|
|
|
|
|
|
UA-46277369-2 |
|
lloydjon |
A |
|
|
|
N |
1731463285 |
0 |
0 |
0 |
0 |
|
S |
|
Professional Plan |
couturejewelrywithheirloomlegacy |
|
5.0000 |
198_282 |