Query time 0.00378
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "5.21"
},
"grouping_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "products",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"status",
"idx_company_id",
"idx_usergroup_ids"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"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": "4K"
},
"used_columns": [
"product_id",
"product_code",
"product_type",
"status",
"company_id",
"list_price",
"amount",
"weight",
"length",
"width",
"height",
"shipping_freight",
"low_avail_limit",
"timestamp",
"updated_timestamp",
"usergroup_ids",
"is_edp",
"edp_shipping",
"unlimited_download",
"tracking",
"free_shipping",
"zero_price_action",
"is_pbp",
"is_op",
"is_oper",
"is_returnable",
"return_period",
"avail_since",
"out_of_stock_actions",
"localization",
"min_qty",
"max_qty",
"qty_step",
"list_qty_count",
"tax_ids",
"age_verification",
"age_limit",
"options_type",
"exceptions_type",
"details_layout",
"shipping_params",
"weight_lbs",
"weight_oz",
"product_tax_code",
"deleted_at",
"archived_at",
"position"
]
}
},
{
"table": {
"table_name": "popularity",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"total"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"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": "32"
},
"used_columns": [
"product_id",
"total"
]
}
},
{
"table": {
"table_name": "cd",
"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",
"terms"
]
}
},
{
"table": {
"table_name": "product_prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "product_id",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.26",
"eval_cost": "0.10",
"prefix_cost": "0.36",
"data_read_per_join": "24"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
],
"attached_condition": "<if>(is_not_null_compl(product_prices), ((`goimagine`.`product_prices`.`lower_limit` = 1) and (`goimagine`.`product_prices`.`usergroup_id` in (0,0,1))), true)"
}
},
{
"table": {
"table_name": "product_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"lang_code"
],
"key_length": "11",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.64",
"eval_cost": "0.10",
"prefix_cost": "1.10",
"data_read_per_join": "5K"
},
"used_columns": [
"product_id",
"lang_code",
"product",
"shortname",
"short_description",
"full_description",
"meta_keywords",
"meta_description",
"search_words",
"page_title",
"age_warning_message",
"promo_text",
"cls_stop_words",
"how_its_made",
"custom_header"
]
}
},
{
"table": {
"table_name": "company_descr",
"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.89",
"eval_cost": "0.10",
"prefix_cost": "2.09",
"data_read_per_join": "1K"
},
"used_columns": [
"company_id",
"lang_code",
"i18n_company"
]
}
},
{
"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.68",
"eval_cost": "0.10",
"prefix_cost": "2.87",
"data_read_per_join": "14K"
},
"used_columns": [
"company_id",
"status"
],
"attached_condition": "<if>(found_match(companies), ((`goimagine`.`companies`.`status` = 'A') or false), true)"
}
},
{
"table": {
"table_name": "products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "pt",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 3,
"rows_produced_per_join": 3,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.75",
"eval_cost": "0.30",
"prefix_cost": "3.92",
"data_read_per_join": "48"
},
"used_columns": [
"product_id",
"category_id",
"link_type",
"category_position"
]
}
},
{
"table": {
"table_name": "categories",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"goimagine.products_categories.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "5.00",
"cost_info": {
"read_cost": "0.75",
"eval_cost": "0.02",
"prefix_cost": "4.97",
"data_read_per_join": "402"
},
"used_columns": [
"category_id",
"usergroup_ids",
"status",
"storefront_id"
],
"attached_condition": "((`goimagine`.`categories`.`storefront_id` in (0,1)) and ((`goimagine`.`categories`.`usergroup_ids` = '') or (0 <> find_in_set(0,`goimagine`.`categories`.`usergroup_ids`)) or (0 <> find_in_set(1,`goimagine`.`categories`.`usergroup_ids`))) and (`goimagine`.`categories`.`status` in ('A','H')))"
}
},
{
"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": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.12",
"eval_cost": "0.02",
"prefix_cost": "5.10",
"data_read_per_join": "260"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
},
{
"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": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.04",
"eval_cost": "0.02",
"prefix_cost": "5.16",
"data_read_per_join": "266"
},
"used_columns": [
"company_id",
"lang_code",
"company_description"
]
}
},
{
"table": {
"table_name": "discussion",
"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": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.03",
"eval_cost": "0.02",
"prefix_cost": "5.21",
"data_read_per_join": "3"
},
"used_columns": [
"object_id",
"object_type",
"type"
]
}
}
]
}
}
}
Result
| product_id |
product_code |
product_type |
status |
company_id |
list_price |
amount |
weight |
length |
width |
height |
shipping_freight |
low_avail_limit |
timestamp |
updated_timestamp |
usergroup_ids |
is_edp |
edp_shipping |
unlimited_download |
tracking |
free_shipping |
zero_price_action |
is_pbp |
is_op |
is_oper |
is_returnable |
return_period |
avail_since |
out_of_stock_actions |
localization |
min_qty |
max_qty |
qty_step |
list_qty_count |
tax_ids |
age_verification |
age_limit |
options_type |
exceptions_type |
details_layout |
shipping_params |
weight_lbs |
weight_oz |
product_tax_code |
deleted_at |
archived_at |
position |
lang_code |
product |
shortname |
short_description |
full_description |
meta_keywords |
meta_description |
search_words |
page_title |
age_warning_message |
promo_text |
cls_stop_words |
how_its_made |
custom_header |
price |
category_ids |
popularity |
company_name |
terms |
seo_name |
seo_path |
company_description |
discussion_type |
| 236631 |
22454 |
P |
A |
7090 |
24.99 |
41 |
0.500 |
0 |
0 |
0 |
0.00 |
0 |
1657413598 |
1679023668 |
0 |
N |
N |
N |
D |
Y |
R |
N |
N |
N |
Y |
10 |
0 |
N |
|
0 |
0 |
0 |
0 |
|
N |
0 |
P |
F |
|
a:5:{s:16:"min_items_in_box";i:1;s:16:"max_items_in_box";i:1;s:10:"box_length";i:11;s:9:"box_width";i:5;s:10:"box_height";i:4;} |
0.000 |
8.000 |
|
|
|
2147483647 |
en |
Personalized Doily for Wedding or Anniversary Gift |
|
|
<p>This handmade filet crochet doily will make a very special birthday gift, anniversary gift, wedding gift or Valentine's gift for someone you love. If you had it framed, it would make a beautiful wall hanging that would be treasured forever. Customize this with your name instead of the word "LOVE". </p>
<p>The pictured doily (LOVE) measures 19 inches long and 6 1/2 inches wide and is lightly stiffened and ready for framing. Length of doily will vary with number of letters requested. </p>
<p>To order with a frame, <a href="https://beeshandmadegifts.goimagine.com/framed-personalized-doily-for-wedding-or-anniversary-gift-en/" target="_blank">click here.</a></p> |
|
|
Personalized Doily, 13th Wedding Anniversary, Wedding Gift |
|
|
<p>Allow 2 weeks for the creation of your doily.</p> |
|
|
|
24.99000000 |
26M,107,16300 |
1452 |
Bee's Handmade Gifts |
<p>Returns and Exchanges:</p>
<p>I accept returns/exchanges if contacted within 14 days of delivery. The item being returned/exchanged must be returned within 30 days of delivery.</p>
<p>Items that cannot be returned (unless they are damaged or defective):</p>
<p>-Customized/Personalized items</p>
<p>-Digital Downloads</p>
<p>-Items on Sale</p>
<p>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>Cancellations:</p>
<p>I do not accept cancellations except in the event the item has not been started. Contact me to find out if I've started your item before requesting cancellation.<br></p>
<p><br></p>
<p>Privacy Policy:</p>
<p>This Privacy Policy describes how and when I collect, use, and share information when you purchase an item from me, contact me, or otherwise use my services through GoImagine.com or its related sites and services.</p>
<p>This Privacy Policy does not apply to the practices of third parties that I do not own or control, including GoImagine or any third party services you access through GoImagine. You can reference the GoImagine Privacy Policy to learn more about its privacy practices. </p>
<p>Information I Collect:<br>To fulfill your order, you must provide me with certain information (which you authorized GoImagine to provide to me), such as your name, email address, mailing address, payment information, and the details of the product that you’re ordering. You may also choose to provide me with additional personal information (for a custom order, for example), if you contact me through an GoImagine conversation or directly through email.</p>
<p>Why I Need Your Information and How I Use It:<br>I rely on a number of legal bases to collect, use, and share your information, including:<br>- As needed to provide my services, such as when I use your information to fulfill your order, to settle disputes, or to provide customer support.<br>- When you have provided your affirmative consent, which you may revoke at any time, such as by signing up for my mailing list.<br>- If necessary to comply with a legal obligation or court order or in connection with a legal claim, such as retaining information about your purchases if required by tax law.<br>- As necessary for the purpose of my legitimate interests, if those legitimate interests are not overridden by your rights or interests, such as 1) providing and improving my services. I use your information to provide the services you requested and in my legitimate interest to improve my services; and 2) Compliance with the GoImagine Seller Policy and Terms of Use. I use your information as necessary to comply with my obligations under the GoImagine Seller Policy and Terms of Use.</p>
<p>Information Sharing and Disclosure:<br>Information about my customers is important to my business. I share your personal information for very limited reasons and in limited circumstances, as follows:</p>
<p>GoImagine:<br>I share information with GoImagine as necessary to provide you my services and comply with my obligations under both the GoImagine Seller Policy and GoImagine Terms of Use.</p>
<p>Service providers:<br>I engage certain trusted third parties to perform functions and provide services to my shop, such as shipping companies such as USPS. I will share your personal information with these third parties, but only to the extent necessary to perform these services.</p>
<p>Business transfers:<br>If I sell or merge my business, I may disclose your information as part of that transaction, only to the extent permitted by law.</p>
<p>Compliance with laws: <br>I may collect, use, retain, and share your information if I have a good faith belief that it is reasonably necessary to: (a) respond to legal process or to government requests; (b) enforce my agreements, terms and policies; (c) prevent, investigate, and address fraud and other illegal activity, security, or technical issues; or (d) protect the rights, property, and safety of my customers, or others.</p>
<p>Data Retention:<br>I retain your personal information only for as long as necessary to provide you with my services and as described in my Privacy Policy. However, I may also be required to retain this information to comply with my legal and regulatory obligations, to resolve disputes, and to enforce my agreements. I generally keep your data for the following time period: 4 years.</p>
<p>Transfers of Personal Information Outside the EU:<br>I may store and process your information through third-party hosting services in the US and other jurisdictions. As a result, I may transfer your personal information to a jurisdiction with different data protection and government surveillance laws than your jurisdiction. If I am deemed to transfer information about you outside of the EU, I rely on Privacy Shield as the legal basis for the transfer, as PayPal is Privacy Shield certified.</p>
<p>Your Rights:<br>If you reside in certain territories, including the EU, you have a number of rights in relation to your personal information. While some of these rights apply generally, certain rights apply only in certain limited cases. I describe these rights below:</p>
<p>Access:<br>You may have the right to access and receive a copy of the personal information I hold about you by contacting me using the contact information below.<br>Change, restrict, delete. You may also have rights to change, restrict my use of, or delete your personal information. Absent exceptional circumstances (like where I am required to store data for legal reasons) I will generally delete your personal information upon request.<br>Object. You can object to (i) my processing of some of your information based on my legitimate interests and (ii) receiving marketing messages from me after providing your express consent to receive them. In such cases, I will delete your personal information unless I have compelling and legitimate grounds to continue using that information or if it is needed for legal reasons.<br>Complain. If you reside in the EU and wish to raise a concern about my use of your information (and without prejudice to any other rights you may have), you have the right to do so with your local data protection authority.</p>
<p>How to Contact Me:<br>For purposes of EU data protection law, I, Brenda Massad, am the data controller of your personal information. If you have any questions or concerns, you may contact me at brenda@beeshandmadegifts.com.</p>
<p><br></p> |
custom-name-doily-for-bridal-gift-wedding-gift-or-anniversary-gifts |
5/26 |
<p>Hello and welcome to my shop! I am so glad you've taken the time to visit.<br></p>
<p>Crafts have always been a passion of mine, ever since my grandmother first taught me how to quilt a potholder. I remember that moment so vividly, and I wish I had kept that potholder as a memento. Unfortunately, I was only four or five years old at the time and wanted to use it, so it didn't last long. My grandmother passed away a short time later, but my family has always had many stories about all of the crafts she did in her life and how skilled she was at them. This is just one of the many reasons I fell in love with crafts.</p>
<p>My family has always had a love of handmade items, and my parents were both very creative and skilled with their hands. I can't remember a time when I didn't see them working on some project or another, whether it was woodworking, knitting, or any number of other things. My mother in particular encouraged me to be creative and always encouraged me to try new things.</p>
<p>In my shop, you'll find a variety of handmade crafts that reflect my love of creating. I offer personalized doilies, stuffed animals, frames, and rustic wildlife decor. Each item is made with care and attention to detail, and I take great pride in my work.</p>
<p>Photography is a newer outlet for me, and I've really enjoyed exploring it over the past few years. I love capturing the beauty of the wildlife, flowers, and landscapes I encounter on my travels, particularly in Cloudcroft and Ruidoso, New Mexico. The wild horses there are a particular favorite of mine, and I love driving around looking for them.</p>
<p>I'm constantly creating new things and adding them to my shop, so be sure to check back often to see what's new. I hope you enjoy browsing my shop and finding something special for yourself or as a gift. Thank you for visiting!</p>
<p>Bee's Handmade Gifts is located in Cloudcroft, NM.</p>
<p><br></p> |
D |