Query time 0.00098
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "2.88"
},
"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.76",
"eval_cost": "0.10",
"prefix_cost": "1.84",
"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.27",
"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.88",
"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 |
| 802 |
en |
<p>The anticipation of a baby is one of the most wonderful experiences of life and is a cause for celebration. Mom and Baby Boutique LLC was established in 2010 with the goal of offering high quality baby accessories to help you celebrate that little bundle of joy. Whether you are an expectant mother yourself, a grandmother to be, or a loving friend searching for the perfect baby shower gift, I am proud to offer you a variety of exceptional presents.<br><br>I was first inspired by my nephew when he was expecting his first child. He was excited, he was nervous, and he was more than a little overwhelmed. Baby showers, and gender reveal showers, are often a way to relax those nerves while reminding everyone just how amazing pregnancy and babyhood truly is. I started with a simple diaper cake for them. He loved it. His wife loved it. The guests were amazed and I was hooked. Over the years I expanded my offerings to include baby clothing, gift sets, bibs, pacifier clips, and, of course, my diaper cakes.<br><br>My signature product line is the personalized pacifier and it is my best-seller for good reason. I elevate traditional pacifiers with expertly engraved text. Not only do I offer names, but I also offer playful phrases, awareness identifications, and even include them in our gift sets. I know that all babies are unique, and these customized pacifiers are the perfect expressions of your little ones budding personality.<br><br>Thank you again for learning about Mom and Baby Boutique LLC. I’d like to invite you to explore my shop and follow us on our social media platforms.<br><br><a href="http://www.facebook.com/MomandBabyBoutique" target="_blank" rel="nofollow noopener">www.facebook.com/MomandBabyBoutique</a><br><a href="http://www.twitter.com/MomandBabyBtq" target="_blank" rel="nofollow noopener">www.twitter.com/MomandBabyBtq</a><br><a href="http://www.instagram.com/MomandBabyBoutique" target="_blank" rel="nofollow noopener">www.instagram.com/MomandBabyBoutique</a><br><a href="http://www.pinterest.com/MomandBabyBtq" target="_blank" rel="nofollow noopener">www.pinterest.com/MomandBabyBtq</a></p> |
|
{"default_colors":"N","link_color":"#007d89","label_color":"#00a0af","icon_color":"#00a0af","main_btn_color":"#6dd1d6","branded_text_color":"#00a0af","vbp_1_url":"https:\/\/mombaby.goimagine.com\/index.php?dispatch=products.search&search_performed=Y","vbp_2_url":"","vbp_3_url":"","vba_1_url":"https:\/\/mombaby.goimagine.com\/index.php?dispatch=products.search&search_performed=Y","vba_2_url":"","vba_3_url":""} |
Mom and Baby Boutique |
PO BOX 42703 |
INDIANAPOLIS |
A |
Mom and Baby Boutique |
PO BOX 42703 |
INDIANAPOLIS |
IN |
US |
46242 |
momandbabyboutique@yahoo.com |
|
|
|
|
none |
Y |
|
1593210557 |
|
|
0 |
|
a:4:{s:14:"company_fields";a:2:{i:37;s:5:"April";i:38;s:7:"Jenkins";}s:15:"admin_firstname";s:5:"April";s:14:"admin_lastname";s:7:"Jenkins";s:6:"fields";a:0:{}} |
4 |
acct_16SGzBCK2UFoY861 |
132894895583207 |
38169,38324,38186,38178,38264,38189 |
G-2M7X2X8PJT |
|
|
|
|
|
|
|
|
|
|
G-2M7X2X8PJT |
132894895583207 |
|
A |
|
|
|
N |
0 |
0 |
0 |
0 |
0 |
|
S |
|
All-Star Plan |
momandbabyboutique |
|
|
802_0 |