Query time 0.00105
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "2.91"
},
"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.89",
"eval_cost": "0.10",
"prefix_cost": "0.99",
"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.78",
"eval_cost": "0.10",
"prefix_cost": "1.87",
"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.30",
"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.91",
"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 |
| 429 |
en |
<p>Hello! My name is Jennifer. I am an Army veteran, mom to an Army reservist/social worker, wife, and Christian. Blessed with working for a sign maker in high school and gifted a routed for Christmas, I made crafting my full-time job in 2015. I truly enjoy creating products you'll enjoy receiving and giving. If you'd like to customize anything you see in my shop to make it yours alone, just let me know. I love working with you to make unique pieces. If you are not quite ready to buy, please favorite my shop so you can find me easily when you are ready. Thanks for looking! </p>
<p> I also operate EnkoreSign.net, PACKAwards.net and MilitaryPatriot.net on Etsy so be sure to check them out, too... but just to see what I can do. If you want something you see there and not on GoImagine, please contact me so I can recreate the listing here. I'm a bit behind but working to increase my selection here where profits support children in need! </p>
<p>As a former foster parent and a parent of a daughter who chose to go into social work to help keep children from having to go into foster care, I am passionate about the GoImagine cause and look forward to the day I have all my inventory for sale here. </p>
<p> </p> |
<p><strong><span style="color: rgb(149, 55, 52);">Please review before purchasing!</span></strong></p>
<p><strong>Sizing details</strong><br>The materials I use are reclaimed, refurbished, or at least rebought and may be one of a kind. To maximize usage, sizing may vary in all dimensions plus or minus about 10%. For custom signs, you'll be sent a mock up based on your custom text along with approximate dimensions planned for your project. Let us know at the time of your order if exact specific sizing is required.</p>
<p><strong>Custom and personalized orders</strong><br>The max number of characters for personalization may be limited based on the size of the item. If you need more, please contact me for a customized quote. The font(s) shown in the first photo is generally standard for that sign. If you'd like another font, just let me know! I will send a mockup of your personalized sign within 2-3 business days for your approval before beginning work.</p>
<p><strong>Care instructions</strong><br>Some items include indoor/outdoor urethane, some include just inside urethane, and some are left unfinished. Cedar and redwood weathers nicely outside whether finished or not, but other wood types should be sealed for protection and that protection should be renewed by the customer regularly to ensure continued protection. Corian is a man-made acrylic that is weather proof and uv resistant, however the paint (though suitable for outdoor use) will need touch ups if used outside just as house paint would. </p>
<p><strong>Packaging</strong><br>Packaging and protective materials are mostly recycled, but still clean and sturdy, this is to save you money as well as help keep perfectly usable material out of the landfill.<br></p>
<p><strong>Cancellations</strong><br>I get to work on your mockup as soon as possible after your order is received to get it to you within the promised time frame, so cancellations are not accepted after 24 hours. Please respond promptly with your input for the mockup as work will not begin until you approve it.</p>
<p><strong>Returns/Refunds<br></strong>As all work is done to order specifically for you, returns and refunds are not possible. If your order arrives damaged or is lost in the mail, let me know and I'll make it right. Be sure the mockup I send is how you want the final design to look. </p>
<p><strong>Processing time</strong><br>Processing time is an estimate. For most custom products, that will be within 2 weeks. If you absolutely must have your order by a certain date, please contact me before order. While I can promise the date I will ship. I cannot guarantee delivery times as sometimes things just happen. If you are local to Rosamond, CA, you are welcomed to pickup.</p>
<p><strong>Shipping and Insurance<br></strong>Shipping times are estimates. Once accepted by the post office, priority usually takes 1-3 days, and ground UPS/FEDEX takes 1-6 days. However, occasionally things are delayed or misdirected. Shipping arrival is not guaranteed except for Priority EXPRESS. </p>
<p>All items are shipped insured. Lost items cannot be claimed until 15 days have passed for domestic and 30 days for international. Damaged items will need to have photos taken and the packing material kept. Please contact me for details.</p>
<p></p>
<p><br></p> |
{"tmenu_style":"H","default_colors":"N","link_color":"#7f6000","label_color":"#7f6000","icon_color":"#bf9000","main_btn_color":"#bf9000","branded_text_color":"#7f6000","vbp_1_url":"https:\/\/craftedcarvings.goimagine.com\/craftedcarvings\/?subcats=Y&pcode_from_q=Y&status=A&pshort=Y&pfull=Y&pname=Y&pkeywords=Y&search_performed=Y&q=+&security_hash=839680c36143ecd37af24821e32d1481","vbp_2_url":"","vbp_3_url":"","vba_1_url":"http:\/\/pinterest.com\/craftedcarvings","vba_2_url":"","vba_3_url":""} |
CraftedCarvings |
4652 Sweetser Rd |
Rosamond |
A |
CraftedCarvings |
4652 Sweetser Rd |
Rosamond |
CA |
US |
93560 |
craftedcarvings.net@gmail.com |
|
|
|
|
none |
Y |
|
1587496364 |
|
|
0 |
|
a:4:{s:14:"company_fields";a:2:{i:37;s:8:"Jennifer";i:38;s:8:"Guenther";}s:15:"admin_firstname";s:8:"Jennifer";s:14:"admin_lastname";s:8:"Guenther";s:6:"fields";a:0:{}} |
3 |
acct_1GaRnqK3zKrbsksH |
769080623524570 |
45892,46684,44624,45329,46019,45872 |
UA-177553416-1 |
G2JFMSTFX7QWL |
For every craft is built by someone, but GOD is the builder of everything. - Inspired by Hebrews 3:4 |
https://www.facebook.com/craftedcarvings |
https://www.instagram.com/craftedcarvings/ |
|
https://pinterest.com/craftedcarvings |
<p>If you don't see something here that I have listed elsewhere, just ask. I'll be happy to recreate the listing here to ensure profits go to support children in need!</p> |
|
|
|
UA-177553416-1 |
769080623524570 |
|
A |
|
|
|
N |
0 |
0 |
0 |
0 |
0 |
|
S |
|
Professional Plan |
craftedcarvings |
|
|
429_0 |