Query time 0.00107
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 |
| 3651 |
en |
<p><br></p>
<p> We are Brianna and Maliah, and we make stuff. Bass Creations is a two-woman show, powered by unwavering family support. We are a mother-daughter team that has been sewing as a hobby for years. But, we have finally decided to venture out and turn our passion into a creative small business. </p>
<p> Our obsession with finding and collecting the most interesting, colorful and dynamic fabrics we can find is what inspires us to keep coming up with creative designs and one of a kind pieces. Being from a more confined corporate background, we appreciate the creativity and freedom of working in our studio and letting the creative juices flow. </p>
<p> We are having a blast being able to explore our imagination and creativity together in this new venture. We truly appreciate you taking the time to meet us and hang out on our site. As we are adding new inventory constantly, please check back frequently to see our updated listings. Feel free to contact us with any questions you may have!</p>
<p><br></p> |
<p><b><u>Returns & Exchanges</u></b><br></p>
<p><b>We Gladly accept returns</b></p>
<p>Contact us within: 3 Days of Delivery</p>
<p>Ship items back within: 7 Days of Delivery</p>
<p><b>We do not accept exchanges or cancellations,</b> but please contact us if you have any problems with your order. </p>
<p><b>We do not accept returns for custom, personalized, or sale items</b>. Because of the nature of these items we do not accept returns, unless they arrive damaged or defective. </p>
<p><b>Condition of return: </b>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.</p>
<p></p> |
{"tmenu_style":"H","default_colors":"N","link_color":"#0c6980","label_color":"#00a8a8","icon_color":"#00a0af","main_btn_color":"#6bc8bd","branded_text_color":"#00a0af","vbp_1_url":"https:\/\/basscreations.co\/collections-en\/passion-leaf-floral\/","vbp_2_url":"https:\/\/basscreations.goimagine.com\/black-and-white-collection-en\/","vbp_3_url":"https:\/\/basscreations.co\/collections-en\/african-print-collection\/","vba_1_url":"https:\/\/subscribepage.io\/basscreationsexclusiveoffers","vba_2_url":"","vba_3_url":""} |
Bass Creations |
1004 Chestnut St |
Columbus |
A |
Bass Creations |
1004 Chestnut St |
Columbus |
IN |
US |
47201 |
BassCreationsInfo@gmail.com |
|
|
|
|
none |
Y |
|
1630690903 |
|
|
0 |
|
|
3 |
acct_1JYDBQKyH1DmULgT |
|
271019,271018,271021,271022,271023,271025,256116,256118,230662,256676,256677,256679,256680 |
|
|
Carry a dope bag and live well and happy! |
www.facebook.com/basscreationshandmade |
www.instagram.com/basscreationshandmade |
|
www.pinterest.com/basscreationshandmade |
<p class="text-center">Welcome to our shop!</p>
<p class="text-center">Free shipping on all orders over $75.</p> |
oauth.2H6UyaZmXFxFk3snm0e_Nl2-_MRJYfMIjp1tPeoE.zOlrZUosqVXkC3-Bn5NgHq0EUL4EP_7iyZ0NB1HaWSY |
|
|
UA-217243952-1 |
1282864158882348 |
basscreations.co |
A |
|
|
{"items_per_file":"2500","time_from":"","time_to":""} |
N |
0 |
0 |
0 |
0 |
0 |
|
S |
|
Professional Plan |
basscreations |
|
5.0000 |
3651_797433 |