{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.00"
},
"ordering_operation": {
"using_filesort": false,
"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": "p",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"plan_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": "112"
},
"used_columns": [
"plan_id",
"price",
"periodicity",
"commission",
"products_limit",
"revenue_limit",
"vendor_store",
"categories",
"storefronts"
]
}
}
]
}
}
}| company_id | lang_code | company_description | terms | subdomain_colors | i18n_company | i18n_address | i18n_city | status | company | address | city | state | country | zipcode | 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 | price | periodicity | commission | products_limit | revenue_limit | vendor_store | categories | storefronts | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3255 | en | <p>I am a stay at home mom of two beautiful kids, a boy and a girl, I used to work in the medical field as a CNA but since becoming a mom I decided to change my career. I first began by making stuff for just family and friends but they soon encouraged me to expand and make more for others to sell, I look forward to helping you with your special gifts for loved ones or yourself!</p> | {"tmenu_style":"V","default_colors":"N","link_color":"#007d89","label_color":"#007377","icon_color":"#007377","main_btn_color":"#6dd1d6","branded_text_color":"#007377","vbp_1_url":"","vbp_2_url":"","vbp_3_url":"","vba_1_url":"","vba_2_url":"","vba_3_url":""} | Homespun Hacks Creations LLC | 10939 64th Ave | Allendale | A | Homespun Hacks Creations LLC | 10939 64th Ave | Allendale | MI | US | 49401 | homespunhacksllc20@gmail.com | none | Y | 1628704420 | 0 | 4 | acct_1K4VrHErYPRwPwML | 300985,300983,282152,282134,282145,282143,256095,259028,199081,252914,244364,263397,263395,259029,261622,256096,258660,256091,244377,243969,244361,242892,239326,239318,230481,239315,229884,229883,221939,221935,221936,199091,199075,180811,181507,179197,179185,173553,175198,171897,171884,171867,165033,171372,170924,120837,160909,129613,131290,128217,155489,128326,133742,128329,122410,128887,134766,128888,134810,122746,125670,126888,128220,128885,129612 | www.instagram.com/homespunhackscreationsllc | <p>Customizable shirts, hoodies, stickers, decals and more. We would look forward to helping you create something you will love for awhile! If there is a specific color or style you are looking for please reach out! Thank you so much for supporting my small business and dream!</p> <p>-Andrea</p> | UA-218251731-1 | A | N | 0 | 0 | 0 | 0 | 0 | S | 10.00 | onetime | 3.50 | 1000 | 0.00 | 1 |