Query time 0.00272
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "5.27"
},
"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.30",
"eval_cost": "0.10",
"prefix_cost": "0.40",
"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.15",
"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.14",
"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": 3,
"rows_produced_per_join": 3,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.75",
"eval_cost": "0.30",
"prefix_cost": "3.97",
"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": "5.02",
"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.16",
"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.22",
"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.27",
"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 |
| 215042 |
GI-215042-MLP |
P |
A |
2862 |
9.95 |
1 |
0.313 |
0 |
0 |
0 |
0.00 |
0 |
1651248750 |
1677795122 |
0 |
N |
N |
N |
B |
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 |
5.000 |
|
|
|
2147483647 |
en |
Victorian Themed Coin Purse |
|
|
<p>Tired of searching the bottom of you purse for your make up or change? With this little bag the search is over. It will fit easily in your jacket pockets. <br></p>
<ul><li>What you get: One small Victorian-themed coin pouch made by machine embroidery, just for Mom.</li><li>Fabric colors: A Victorian theme of white doves, wedding rings and gloves with a hint of silver threads around each. The colors of the pouch are in shades of soft pinks, blues, and green on a white background.</li><li>Fabric used: 100% cotton fabric, polyester batting, a light pink nylon zipper, stabilizer. MOM is embroider in a darker pink polyester thread. Inside is lined with the same fabric as the outside. </li></ul>
<ul><li>Size: 4 1/2 x 6 1/2 inches.</li><li> Care: machine wash in cold water with like colors Do not bleach. Dry in dryer on a low temperature or lay flat to dry. </li></ul>
<p><br></p>
<p><br></p> |
small zipper coin, jewelry, change, dollar bills, make up, cosmetics, medications, feminine items, bag, pouch, purse, Mother's day gift, gift for mom, grandma gift, victorian fabric, stain resistant, handmade, machine embroidery |
Victorian theme coin purse, machine embroidered with the word MOM. 100% cotton fabric,polyester batting. Size 4 1/4 x 6 1/2 inches. |
small, zipper, coin, change, dollar bills, make up, cosmetic, jewelry, medication, feminine items, toiletry, essentials, bag, pouch, purse, wallet, mom, grandma gift, Victorian, fabric, stain resistant, machine embroidery |
Victorian Themed Coin Purse |
|
|
|
<p>I begin with choosing my fabric, zipper and threads that I will need. <br></p>
<p>My next step is to cut each individual pieces of fabric, batting and stabilizer need.</p>
<p>After hooping the stabilizer and threading the embroidery machine, I load my embroidery hoop into the machine and pull up the design. I then begin to do the embroidery.</p>
<p>The first step in the design is the outline for the bag, then I place the batting and fabric for the bottom of the bag. The next step is to stitch down the top portion of the bag, then attach the zipper. The final step is to attach the back, do the final embroidery stitching.</p>
<p>I then remove the bag from the hoop, trim the seam allowance and turn the bag inside out, which creates the unexposed seams. I hand sew the small turning opening closed by hand, and the bag is finished.</p>
<p>This is a completely handmade items.<br></p>
<p><br></p>
<p><br></p>
<p><br></p>
<p><br></p>
|
|
9.95000000 |
368M,10891,14699 |
2031 |
SewFancybyJulie |
<p>I charge a bit higher price for custom orders. Contact me and we will discuss what you want on the order. I do send pictures for your approval. Once approved, I will set of a custom listing and the order must be paid in full before I start your order. Please understand customization takes a little long to work with and get your order the way you want it. </p><p><br></p><p>SHIPPING: My shipping time is 3-4 business days, excluding weekends and holidays. This gives me time to get your order ready for shipping. I do my best to meet this schedule, and most times ship earlier. I ship USPS first class with tracking unless specified differently or you choose to use USPS Priority Mail. I have no control over packages once they are in the possession of shipping carrier. At this time, I only ship to the United States.<br></p>
<p>All sales are final. I do not accept return, exchanges, or cancellations. If there is a problem with your order, please contact me, so we can discuss the problem and come to an amicable solution. Please do not just return an item without contacting me, as there will not be any kind of refund. This also applies to packages marked "Return to Sender." If a refund is necessary, buyer will pay return shipping. Pictures will be required if there is damage and original packaging returned. I take a video of items as they go into the package before I ship. Not responsible for lost packages, you can add insurance to your order.</p>
<p>Due to different light setting the actual color may vary a bit from the pictures. I try to take accurate pictures, but some colors do not photograph well. I will note that in the descriptions, where necessary. You may always ask questions. <br></p>
<p><strong>MESSAGES: </strong>I try to answer my messages withing a few hours. Depending on your time zone, it may not be until the next morning. Usually very early, I'm an early riser.<br></p>
<p><br></p>
<p><br></p> |
victorian-themed-coin-purse |
3/14/368 |
<p>Welcome to SewFancybyJulie. I live in a small town in South Dakota, and have lived, with my husband for 25 years. After his discharge from the Air Force in 1975, we returned to our home state of Michigan. How did I get to South Dakota, he took a job transfer and here I am and loving it.</p>
<p>I have always sewn my own clothing, as well as, for my children and grandchildren. After retiring, I discovered machine embroidery. I love every minute of what I do. I do it to offer prospective buyers options they can't find in the big box stores.<br></p>
<p>I do items for the kitchen, pot holders, table runners, embroidered kitchen towels, and so much more. I am a one woman show. I do all the product making, product listing and mailing myself. It's a lot of work, but you never work a day in your life if you love what you do. I love what I do.</p>
<p>Please come by and take a look around, my shop is small for now and I plan on expanding my shop as time goes by.</p>
<p>If you have any questions or requests, please feel free to contact me and I'll see if I can help you. <br></p>
<p>Thank you, <br></p>
<p>Julie<br></p>
<p><br><br><br><br></p> |
D |