Query time 0.00133
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "2.80"
},
"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.86",
"eval_cost": "0.10",
"prefix_cost": "0.96",
"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.70",
"eval_cost": "0.10",
"prefix_cost": "1.76",
"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.19",
"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.80",
"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 |
| 5378 |
en |
<p>I am a Wife, Mother, dogmom, fishmom, plantmom and all around Creative person~ I've been making candles since 2008 and doing crochet since a young girl. I acheive balance in life with my spiritual connection to Christ and I always seek to make the world better today for tomorrow..one lovely candle or cozy crochet at a time :)</p> |
<p><br>I believe in providing the very best customer service that I possibly can. I live by the Golden Rule...treat others as you would like to be treated. So feel comfortable shopping with me!<br><br></p><p>My crochet offerings will have all the info needed about fiber content and stitch pattern inside the listing itself. They are all lovingly created by me and me alone~<br></p><p><span style="color: rgb(34, 34, 34); font-weight: 700;">About Returns and Exchanges</span><br></p>
<p>If at any time you're unhappy with your item, just contact me and I will work with you to make sure we resolve the issue. Whether it's a return or an exchange or a replacement that's needed, we will work together to determine the best course of action for us both.</p><p>Contact me within: 7 days of delivery<br>Ship items back within: 14 days of delivery<br>Request a cancellation within: 2 days of purchase</p><p>**Custom or personalized orders cannot be returned**</p><p><br></p><p><b>About Shipping</b></p><p>I use the most cost effective shipping I can muster. I'm not boxed into any particular carrier, as well. Whichever carrier needs to be used, I use. The timeframe for delivery is mandadted my your order communication and I will comply. If you need your order to be expedited, I can comply. Just communicate on your order or send me an email and we'll get it done. Separate payment for extra postage for expedition will be collected at the time of communication if it hasn't been collected within the order itself.</p><p>If there is a wide overage in postage charged, I will refund it back. </p><p><br></p><p><b>About Payment</b></p><p><br></p><p>I take all forms of electronic payment rendered through Paypal or Stripe.</p><p>I will also accept a check or money order. Please give time for it to be recieved, deposited and cleared by my bank. After that, I will ship the order out. <br></p><p><br></p><p><b>All The Other Bits...</b></p><p>Custom Order Plan..<br>Custom order work can be requested. I require 50% down and the balance plus the postage upon completion. Items that are Custom in nature MUST be purchased in a timely manner, preferably within 3 days of completion.<br><br>Holding Items for Future Purchase Plan...<br>Is not an option. If you plan on purchasing the item, please feel free to do so.<br>Also, if the item is a OOAK or Clearance, it likely won't be able to be remade or replenished. Grab it while you can. Have any questions on the remake-ability of the item you are watching, please contact me.<br><br>Thank you for understanding :)<br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></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":""} |
gelDlights Candles and Crochet |
P. O. Box 67 |
Kings Mills |
A |
gelDlights Candles and Crochet |
P. O. Box 67 |
Kings Mills |
OH |
US |
45034 |
5zookeeper5@gmail.com |
+15138504443 |
|
|
|
none |
Y |
|
1644514334 |
|
|
0 |
|
|
1 |
acct_1KTVqHLWNDQ3a9Ek |
|
|
|
NLEZ6GQ3Y8PZQ |
Comfy Cool Decor and More! |
|
|
|
https://www.pinterest.com/geldlights/my-geldlights |
<p>Welcome to my little shop! I'm glad You're here! My goal is to offer you beautiful and cozy Items for your home decor needs as well as unique gifts. I look forward to serving you with excellence :)</p> |
oauth.dVmKyYynZFbDtJllSCiZ-WPB8YLl8MP2nYlTTkHI.As9i8t6XvlhW1pnTqsegpAZoXzpUCTg9iYpB_tL252k |
|
|
|
|
|
A |
|
|
|
N |
0 |
0 |
0 |
0 |
0 |
|
S |
|
Starter Plan |
geldlightscandlesandcrochet |
|
|
5378_0 |