Query time 0.00101
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "2.81"
},
"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.87",
"eval_cost": "0.10",
"prefix_cost": "0.97",
"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.71",
"eval_cost": "0.10",
"prefix_cost": "1.77",
"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.20",
"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.82",
"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 |
| 52 |
en |
<p><span class="mt-xs-1" data-inplace-editable-text="story" data-endpoint="AboutPost" data-key="story" data-placeholder="How did you get started? What inspires you? We know each seller’s story is unique—tell yours here.">Flowers are a magical and beautiful gift from nature.<br><br>The colors and styles they come in are innumerable. I have managed to create a small number of styles using ecofriendly papers. Not all copy nature, some are styles and colors that just seem to want to be created.<br><br>With the help of my amazing Mother and beautiful daughters, we are able to create designs in our California shop to provide flowers that don't have to be cut down, watered, they never die and won't make you sneeze.<br><br>We have the most amazing customers that also give us their design dreams so we can create beautiful bouquets and centerpieces for their weddings and custom decor for their homes, nursery or office.<br><br>The girls and I have been having the best time creating beautiful gifts for our customers to give to their family and friends. They are curated with gorgeous jewelry, delicious candy, decadent truffles, our signature essential oil lotions, soaps, bath salts and of course paper flowers.</span></p>
<p><span class="mt-xs-1" data-inplace-editable-text="story" data-endpoint="AboutPost" data-key="story" data-placeholder="How did you get started? What inspires you? We know each seller’s story is unique—tell yours here."><br></span></p>
<p></p> |
<h6><strong>I gladly accept returns, exchanges, and cancellations</strong></h6>
<p>Contact me within: <span class="text-gray-darker">3 days of delivery</span><br>Ship items back within: <span class="text-gray-darker">7 days of delivery</span><br>Request a cancellation within: <span class="text-gray-darker">6 hours of purchase</span></p>
<h6>The following items can't be returned or exchanged</h6>
<p>Because of the nature of these items, unless they arrive damaged or defective, I can't accept returns for:</p>
<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><li>Items on sale</li></ul>
<p>Conditions of return<br>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>Questions about your order?<br>Please <b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; -webkit-appearance: none; background-color: transparent; color: rgb(34, 34, 34);">contact me if you have any problems with your order</b><br></p>
<p></p>
<p><strong>Privacy policy</strong></p>
<p>At Centertwine we care about your privacy and under the new GDPR Law introduced in the EU on the 25th of May. We've taken steps to make sure your personal data is safe and secure. In line with the new law, we'd like to remind all EU members that we only keep your personal data for the length of time as is necessary for processing of orders and for our own tax records. You also have a right to any data we keep and that your inclusion in our group/page is voluntary and you can unsubscribe at any time. Your information is only shared with the immediate companies we need to in order to process your orders. We care about you and your personal data<br>and thank you for your continued support.</p>
<p><br></p>
<p><strong>Shipping</strong><br></p>
<p>Processing time<br>The time I need to prepare an order for shipping varies. For details, see individual items.</p>
<p><br>Customs and import taxes<br>Buyers are responsible for any customs and import taxes that may apply. I'm not responsible for delays due to customs.</p>
<p><br></p>
<p></p> |
{"tmenu_style":"V","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":""} |
Knotted Leaf Weddings |
12047 E Sun Canyon St. |
Riverside |
A |
Knotted Leaf Weddings |
12047 E Sun Canyon St. |
Riverside |
CA |
US |
92503 |
Diana@Makeistry.com |
|
|
|
|
none |
Y |
|
1584462138 |
|
|
0 |
|
a:4:{s:14:"company_fields";a:2:{i:37;s:5:"Diana";i:38;s:7:"Roberts";}s:15:"admin_firstname";s:5:"Diana";s:14:"admin_lastname";s:7:"Roberts";s:6:"fields";a:0:{}} |
3 |
acct_1ApU3UFLYuWVnGWC |
|
186221,47491,46872,3309,2795,6309,25097,153195,154347,86223 |
|
YAS9S2L85XCHJ |
Bridal Bouquets, Gifts, Paper Flowers |
https://www.facebook.com/Makeistry |
https://www.instagram.com/Knottedleafweddings |
|
https://www.pinterest.com/Knottedleafweddings |
<p>Wedding bouquets, boutonnieres, and corsages made from handcrafted paper flowers using book pages, coffee filters, sheet music, and crepe paper. </p> |
oauth.Fz6gktllEcEDj4gmmIBfUglg4mPjEYH8rwoacoSo.B9o5dQ7kkKstfWADOXMSxw02mNqHOiNy-n5t6GDGW8g |
|
|
|
|
|
A |
|
|
{"items_per_file":"2500","time_from":"","time_to":""} |
N |
0 |
0 |
0 |
0 |
0 |
|
S |
|
Professional Plan |
knottedleafweddings |
|
5.0000 |
52_512 |