Query time 0.00324
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "6.77"
},
"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.25",
"eval_cost": "0.10",
"prefix_cost": "0.35",
"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.67",
"eval_cost": "0.10",
"prefix_cost": "1.12",
"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.92",
"eval_cost": "0.10",
"prefix_cost": "2.13",
"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.92",
"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": 5,
"rows_produced_per_join": 5,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.25",
"eval_cost": "0.50",
"prefix_cost": "4.67",
"data_read_per_join": "80"
},
"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": "1.25",
"eval_cost": "0.03",
"prefix_cost": "6.42",
"data_read_per_join": "670"
},
"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.21",
"eval_cost": "0.03",
"prefix_cost": "6.65",
"data_read_per_join": "434"
},
"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.05",
"eval_cost": "0.03",
"prefix_cost": "6.72",
"data_read_per_join": "444"
},
"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.03",
"prefix_cost": "6.78",
"data_read_per_join": "6"
},
"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 |
| 26915 |
|
P |
A |
63 |
24.95 |
1 |
0.020 |
0 |
0 |
0 |
0.00 |
0 |
1592344333 |
1664050146 |
0 |
N |
N |
N |
D |
N |
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:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} |
0.000 |
0.000 |
|
|
|
2147483647 |
en |
White Pearl Anklet with Sterling Silver Clasp, White Pearl Bracelet |
|
<p>High quality pearl ankle bracelet that's well made to last. I call it Purely Pearl and it can be ordered as a bracelet or anklet. Pure Classic.<br><br></p> |
<p></p>
<p>Bracelet or Ankle Bracelet</p>
<p>Beautiful Genuine gem grade White Freshwater Pearl bracelet or ankle bracelet</p>
<p>Solid .925 stamped genuine sterling silver clasp and ring</p>
<p>This is a high quality pearl ankle bracelet that's well made to last. I call it Purely Pearl and it can be ordered as a bracelet or anklet. <br>Determine your ankle size by measuring around your ankle where you want your anklet to fit. Some like their anklets high on the ankle, some like it to ride lower and looser. Order from the sizes listed that is closest to your ankle (or wrist measurement). If your measurement is in between the measurements listed, go to next larger size. You can also put your exact measurement in the notes to seller at checkout for as close to perfect fit as possible.</p>
<p>Please feel free to ask me any questions you may have about this item while deciding on your purchase and thank you for shopping with McKean Creations.<br>Marcia</p>
<p></p> |
|
High quality pearl ankle bracelet that's well made to last. I call it Purely Pearl and it can be ordered as a bracelet or anklet. Pure Classic.
|
White Pearl Anklet, White Pearl Bracelet, Ankle Bracelet, Pearl Bracelet, Pearl Anklet, Plus Size Anklet, Small Size Anklet, Bridesmaid Gift, Beach Anklet, Wedding Jewelry, Wedding Anklet, Bridesmaid Jewelry, Beach Wedding, McKean Creations, Classic Jewelry, Trending Jewelry |
White Pearl Anklet with Sterling Silver clasp, White Pearl Bracelet |
|
|
|
|
|
24.95000000 |
157M,27,1331,839,838 |
1947 |
McKean Creations |
<p><strong>Returns and Exchanges<br></strong></p>
<p>At McKean Creations, your satisfaction with your purchase is very important. If for some reason you need to return your item, please contact me within 5 days of receipt to make return/refund arrangement. Items can be returned within 10 days of receipt. Items must be in original condition, not altered or worn. Items must be packaged securely to ensure safe return. Full price of item less shipping fees will be refunded. Return shipping fee afforded by buyer. Returned item must be shipped with tracking.<br></p>
<p><strong>I gladly accept returns, exchanges and cancellations<br></strong></p>
<p>Contact me within: 5 days of delivery</p>
<p>Ship items back within: 10 days of delivery</p>
<p>Request a cancellation within: 1 hour of purchase if item has not already been mailed.<br></p>
<p><strong>The following items cannot be returned or exchanged<br></strong></p>
<p>Because of the nature of these items, unless they arrive defective, I can't accept returns for:</p>
<ul><li>Custom or personalized orders</li><li>Intimate items (for health/hygiene reasons) such as pierced earrings</li></ul>
<p><strong>Questions about your purchase?</strong><br></p>
<p>Please contact me if you have any problems with your purchase.</p>
<p><br></p>
<p><strong>Payment<br></strong></p>
<p>We accept credit card payments through Stripe. Goimagine nor McKean Creations have access to your credit card information.</p>
<p><br></p>
<p><strong>Shipping<br></strong></p>
<p><strong>Important Announcement - Though we still mail your purchase within our normal time frame, mail is taking longer than the Post Office estimated times listed below to arrive at their destination. Some packages are taking 2-3 weeks and some are arriving within scheduled times, depending on which sorting facility the package is routed through. </strong><br></p>
<p>Currently we are shipping in the United States only. We use the United States Postal System's (USPS) Priority Flat rate and USPS First class Mail with tracking. We ship to the address listed on your Goimagine account, so please make sure it is updated and correct (if checking out as a guest, we will use the address provided with the order). Your purchase will be shipped in 3-5 business days of cleared payment. If additional time is needed, you will be contacted. Once mailed, Priority Flat Rate packages normally will take 2-3 days to reach their destination and USPS First Class Mail 4-7 days, but this time line cannot be guaranteed once the package has been received by the post office. So far, packages have arrived and been pretty much on time. There's the occasional package that decides to take the more scenic route.<br><br></p>
<p><br></p>
<p><strong>Additional Policies and FAQS<br></strong></p>
<p>Notice - The items in this shop are not intended for use by children under the age of 10. If children are wearing jewelry, it should be under strict supervision.</p>
<p><br></p>
<p><strong>Privacy Faqs<br></strong></p>
<p>I will only use your shipping, billing and contact information to communicate with you about your order, to fulfill your order, and if necessary, for legal reasons (like paying taxes).<strong><br></strong></p>
<p><strong><br></strong><br></p>
<p><br></p>
<p><br></p>
<ul><br><br><br><br></ul> |
white-pearl-anklet-with-sterling-silver-clasp |
2/19/157 |
<p class="text-center"><b>Who knew an ankle bracelet would bring about the birth of McKean Creations?</b>
</p>
<p class="text-center"><b>My love for stones, beads, jewelry and accessories started as a child and never went away. I was quite the fashion statement in my pop beads of many colors and my friendship bracelets made of string in my early years. Later, in my teenage years, it was anklets, barefoot sandals and flowers in the hair. As an adult, I worked in a department store in the jewelry and accessories department and my jewelry stash grew. In 2006, while in Santa Cruz I decided to buy an ankle bracelet. Maybe I was trying to recapture my youth, I don’t know, but I couldn’t find one I liked, and more importantly, one that would fit. As soon as I returned home, I relearned how to make my own, and soon my coworkers and friends were all wanting to buy one for themselves. This led to creating earrings and bracelets which led to an invitation to sell at a large local season long craft fair. McKean Creations was born. Over a decade later I am still designing and growing in my knowledge of a variety of jewelry styles, learning more ways to create beautiful, comfortable and durable jewelry that become special keepsakes for my customers. It’s such a pleasure to see the happiness each piece brings them.</b>
</p>
<p class="text-center"><b>I feel from casual to elegant, jewelry should be a reflection of your style, so at McKean Creations I offer an eclectic array of custom designed jewelry handmade by artisan Marcia McKean (that’s me). You will find unique handcrafted jewelry that is great for any occasion, either for yourself or as a gift. Browse through my Goimagine store, pick out your favorites, then treat yourself or a loved one to that beaded indulgence you so deserve. I hope you enjoy wearing it as much as I enjoy the creation.</b>
</p>
<p class="text-center"><b>Many Blessings,</b>
</p>
<p class="text-center"><b>Marcia</b>
</p> |
D |