Query time 0.00286
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "4.46"
},
"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.27",
"eval_cost": "0.10",
"prefix_cost": "0.37",
"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.63",
"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.88",
"eval_cost": "0.10",
"prefix_cost": "2.08",
"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.86",
"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": 2,
"rows_produced_per_join": 2,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.50",
"eval_cost": "0.20",
"prefix_cost": "3.56",
"data_read_per_join": "32"
},
"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.50",
"eval_cost": "0.01",
"prefix_cost": "4.26",
"data_read_per_join": "268"
},
"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.09",
"eval_cost": "0.01",
"prefix_cost": "4.36",
"data_read_per_join": "173"
},
"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.01",
"prefix_cost": "4.41",
"data_read_per_join": "177"
},
"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.04",
"eval_cost": "0.01",
"prefix_cost": "4.46",
"data_read_per_join": "2"
},
"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 |
| 2602 |
N-0148 |
P |
A |
198 |
219.00 |
1 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1585546362 |
1598559834 |
0 |
N |
N |
N |
B |
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: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 |
Blue Fringe Beadweaving Necklace |
|
<p>The Blue Fringe Necklace features silver lined milky montanta beads, galvanized metallic nebula seed beads, blue bugle beads, and gold plated clasp</p> |
<p>The Blue Fringe Beadweaving Necklace features the following:</p>
<p> </p>
<ul> <li>11o silver lined milky montanta beads</li> <li>11o galvanized metallic nebula seed beads</li> <li>2mm x 6mm montanta blue bugle beads</li> <li>gold plated clasp</li></ul>
<p> </p>
<p>This gorgeous Blue Fringe Beadweaving Necklace will become a favorite accessory for all of your outfits. This necklace is for the woman who loves to make a statement with their fashion accessories. You will be sure to attract many admirers with this statement necklace. Necklace length is 17".</p>
<p> </p>
<p>You will feel like a queen wearing this beautiful classic blue fringe piece of art.</p>
<p> </p>
<p>This necklace is made with beadweaving techniques. The base which is made of of montanna blue bugle beads sets the mood with this necklace. The coralling or fringing technique is used to give this necklace the flowing effect on your neckline. This weave provides a natural curved necklace which curves around the neckline with ease and speaks of pure "elegance".</p>
<p> </p>
<p>This artisan necklace would make a wonderful heirloom piece to hand down from generation to generation.</p>
<p> </p>
<p><strong>Your one of a kind piece of jewelry was created with much time and love. In addition this piece of art has been created especially for you.</strong></p>
<p> </p>
<p><strong>THIS PRODUCT INCLUDES USPS FIRST CLASS SHIPPING!!!!</strong></p>
<p>Visit me on social media</p>
<p><a href="https://www.instagram.com/CoutureJewelryHeirloomLegacy/" target="_blank">Instagram</a></p>
<p><a href="https://www.facebook.com/CoutureJewelrywithHeirloomLegacy" target="_blank">Facebook</a></p>
<p><a href="http://www.pinterest.com/couturejewelryheirloomlegacy" target="_blank">Pinterest</a></p>
<p><br></p>
<p>NOTE: Please
use care when wearing this necklace. The necklace is sturdy, but can be broken
if there is sudden pulling on the piece. Do not wear when swimming or
around water. Treat necklace as you would any other heirloom piece of
jewelry!</p>
<p> </p>
<p>Blessings and Grace with Beads and Lace</p> |
couture jewelry, handmadebeadedjewelry, love couture jewelry, heirloom jewelry, luxury jewelry, high end jewelry, fringe beadweaving necklace, go imagine seller, caring economy, handmade for good, goimagine seller |
The Blue Fringe Necklace features silver lined milky montanta beads, galvanized metallic nebula seed beads, blue bugle beads, and gold plated clasp |
couture jewelry, handmadebeadedjewelry, love couture jewelry, fringe beadweaving necklace, go imagine seller, caring economy, handmade for good, handmade artisan necklace, heirloom jewelry necklace, luxury jewelry necklace, high end jewelry necklace, gifts for her necklace, gifts for women necklace, beadweaving necklace, special occasions jewelry, handmade bridal jewelry, handmade bridesmaid jewelry, handmade wedding jewelry, go imagine seller, caring economy, made for good, goimagine seller
|
Blue Fringe Beadweaving Necklace |
|
|
|
<p>This necklace is made with the fringe or coraling beadweaving techniques. The coralling or fringing technique is used to give this necklace the flowing effect on your neckline. This weave provides a natural curved necklace which curves around the neckline with ease and speaks of pure "elegance".</p>
<p><br></p>
<p>This technique doesn't use a loom. The necklace is made with a needle and thread and the beads are added one bead at a time.</p>
|
|
175.00000000 |
137M,131 |
7984 |
Couture Jewelry with Heirloom Legacy |
<p>PROCESSING TIME</p>
<p>Jewelry that is ready to ship will be available for shipping within 7 days. Orders may be shipped earlier, but are not guaranteed to be shipped prior to 7 days.</p>
<p><br></p>
<p>SELLING TO USA ONLY</p>
<p>Couture Jewelry doesn't offer shipping outside of the United States</p>
<p><br></p>
<p>CANCELLATIONS</p>
<p>Couture Jewelry does not offer cancellations. If there are any problems, please contact Couture Jewelry at info@couture-jewelry.com</p>
<p><br></p>
<p>GENERAL TERMS</p>
<p>Satisfaction is 100% guaranteed. If there should be any problems with an order, please contact me first before returning. </p>
<p>If after talking with you about your order you still wish to return the item please send back to Couture Jewelry in the original, unaltered condition and the original packaging within 14 days of purchase for a refund of the purchase price. If we have decided ahead of time you would like to exchange your purchased item for an equal value item, we can do this as well. </p>
<p>PLEASE DO NOT RETURN ANY ITEMS WITHOUT CONTACTING COUTURE JEWELRY FIRST. <strong>BUYER</strong> is responsible for shipping costs to send products back to Couture Jewelry. If the product is received not in original condition the <strong>BUYER</strong> is responsible for any loss in value.</p>
<p><strong>Returns or exchanges are not accepted on the following: </strong></p>
<p><strong></strong><br></p>
<ul><li><strong> Merchandise returned after 14 days from the original ship date </strong></li><li><strong> Personal items such as face masks</strong></li><li><strong> Custom Made Orders </strong></li><li><strong> Items that have been purchased on sale. </strong></li></ul>
<p>Refunds will be issued via Stripe once the merchandise has been received by Couture Jewelry. If you have any questions about your order, please do not hesitate to contact me by email at info@couture-jewelry.com</p>
<p><br></p>
<p><strong>NO RETURNS ON PERSONAL ITEMS SUCH AS FACE MASKS!</strong></p>
<p><b class="_2K_N3" aria-expanded="false" data-hook="collapse-info-button"><strong></strong><br></b></p>
<p><b class="_2K_N3" aria-expanded="false" data-hook="collapse-info-button"><br></b></p>
<p><b class="_2K_N3" aria-expanded="false" data-hook="collapse-info-button"><br></b><br></p>
<p><b class="_2K_N3" aria-expanded="false" data-hook="collapse-info-button"></b></p>
<p><b class="_2K_N3" aria-expanded="false" style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image: none; background-origin: padding-box; background-position-x: 0%; background-position-y: 0%; background-repeat: repeat; background-size: auto; border-bottom-color: currentColor; border-bottom-style: none; border-bottom-width: 0px; border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; border-left-color: currentColor; border-left-style: none; border-left-width: 0px; border-right-color: currentColor; border-right-style: none; border-right-width: 0px; border-top-color: currentColor; border-top-style: none; border-top-width: 0px; box-sizing: border-box; color: rgb(0, 0, 0); cursor: pointer; display: flex; font-family: wfont_890dd1_d811b5e3bc4b4d1fbcc513de8e39b099,wf_d811b5e3bc4b4d1fbcc513de8,orig_poppins_bold; font-size: 21px; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: 26px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: invert; outline-style: none; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; position: relative; text-align: inherit; text-decoration: inherit; vertical-align: baseline; width: 100%;" data-hook="collapse-info-button"><br></b></p> |
blue-fringe-beadweaving-necklace |
2/13/137 |
<p>Teresa Delosh of Couture Jewelry specializes in handmade artisan jewelry that is designed to become family heirlooms for generations to come. I love to make jewelry that you will be proud to pass on to your family. I feature beadweaving, free standing lace, vinyl and leather jewelry. Now offering fashion accessories along with our jewelry.</p> |
|