Query time 0.00378
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "4.48"
},
"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.65",
"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.90",
"eval_cost": "0.10",
"prefix_cost": "2.10",
"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.88",
"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.58",
"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.28",
"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.08",
"eval_cost": "0.01",
"prefix_cost": "4.38",
"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.05",
"eval_cost": "0.01",
"prefix_cost": "4.43",
"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.48",
"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 |
| 15797 |
E-0374 |
P |
A |
198 |
0.00 |
10 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1587939358 |
1598034798 |
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 |
Handmade Tear Drop Soccer Ball Vinyl Machine Embroidery Earrings |
|
<p>The Handmade Tear Drop Soccer Ball Vinyl Machine Embroidery Earrings features Machine Embroidery Vinyl Soccer Ball Made with White Vinyl and Rayon Thread, Black Bicone Beads, and Silver Plated Ear Wires</p>
<p></p> |
<p>Handmade Tear Drop Soccer Ball Vinyl Machine Embroidery Earrings</p>
<p><br></p>
<p>The Handmade Tear Drop Soccer Ball Vinyl Machine Embroidery Earrings features the following:</p>
<p> </p>
<ul> <li> <p>Machine Embroidery Vinyl Soccer Ball Made with White Vinyl and Rayon Thread. </p> </li> <li> <p>Black Bicone Beads</p> </li> <li> <p>Silver Plated Ear Wires</p> </li></ul>
<p> </p>
<p>These whimsical Handmade Tear Drop Soccer Ball Vinyl Machine Embroidery Earrings are great for all your sporting outfits or just to show your support for your favorite sport.</p>
<p> </p>
<p>Don’t you love these soccer ball earrings?</p>
<p> </p>
<p>These artisan earrings would make a wonderful sports related 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 SHIPPING!!!!</strong></p>
<p>Visit me on social media</p>
<p><a href="http://www.instagram.com/couturejewelryheirloomlegacy" target="_blank">Instagram</a></p>
<p><a href="http://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 these earrings. The earrings are sturdy, but can be broken if there is sudden pulling on the piece. Do not wear when swimming or around water. Treat earrings as you would any other heirloom piece of jewelry!</p>
<p> </p>
<p>Blessings and Grace with Beads and Lace</p>
<p><br></p>
<p></p> |
couture jewelry, handmade vinyl jewelry, go imagine seller, caring economy, made for good, whimsical earrings, handmade soccer earrings, sports earrings, soccer ball earrings |
The Handmade Tear Drop Soccer Ball Vinyl Machine Embroidery Earrings features Machine Embroidery Vinyl Soccer Ball Made with White Vinyl and Rayon Thread, Black Bicone Beads, and Silver Plated Ear Wires |
couture jewelry, handmade vinyl jewelry, love couture jewelry, handmade artisan earrings, heirloom jewelry earrings, luxury jewelry earrings, high end jewelry earrings, gifts for her earrings, gifts for women earrings, special occasions jewelry, go imagine seller, caring economy, made for good, whimsical earrings, soccer ball earrings, sports earrings |
Handmade Tear Drop Soccer Ball Vinyl Machine Embroidery Earrings |
|
|
|
<p>These earrings are
handmade using a machine embroidery/sewing machine. The earrings are appliqued using vinyl. After the earrings have
been sewn they are cut out and assembled.</p>
|
|
19.00000000 |
17M,147 |
3162 |
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> |
handmade-tear-drop-soccer-ball-vinyl-machine-embroidery-earrings |
2/17 |
<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> |
|