Query time 0.00399
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "4.73"
},
"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.54",
"eval_cost": "0.10",
"prefix_cost": "0.64",
"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.37",
"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.34",
"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": "3.13",
"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.83",
"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.53",
"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.63",
"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.68",
"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.73",
"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 |
| 73052 |
159 |
P |
A |
521 |
0.00 |
2 |
0.125 |
0 |
0 |
0 |
0.00 |
0 |
1615996287 |
1654946908 |
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 |
2.000 |
|
|
|
2147483647 |
en |
Flamingo Diamond Painting Pen |
|
These Flamingo Diamond Painting Pens are lightweight and very comfortable. You can use them for hours even if you have hand/wrist problems, arthritis, or carpal tunel.
***About my Pens***
If you have joined the ranks of crafters who enjoy Diamond Painting as your favorite pastime, you are familiar with the plastic "Pink Pens" that come with your Diamond Painting kit. You probably have noticed they are not the most comfortable to use hour upon hour, placing thousands and thousands of tiny sparkly diamond drills on your canvas.
After so much pain in my hand and wishing there was some alternative, I decided to figure out a way to customize something else to use as a more comfortable diamond painting pen. At the same time, it would be inexpensive and affordable. After making a few for myself, I began getting request from friends to make them one and they would buy them. Hence, The Dancin' Daisy.
All of my items are handmade and/or customized by me, come to you carefully packaged, and shipped quickly. My modified pens have had all of the ink removed from them, and drill tips are secured with high quality epoxy adhesive and reinforced inside the pen with a wooden dowel, whenever possible. You won't be disappointed, and your crafting friends will soon be asking you where you got your new accessories! Please feel free to share my listing in any Diamond Painting or Crafting groups you belong to, and/or direct interested crafters to my shop here on Etsy!
Please feel free to ask any questions, a special color request, or any clarifications about the items listed. I'm happy to answer you as quickly as possible.
Thank you for visiting The Dancing Daisy!!! |
<p>These Flamingo Diamond Painting Pens are lightweight and very comfortable. You can use them for hours even if you have hand/wrist problems, arthritis, carpal tunel, etc.</p>
<p><br>***About my Pens***</p>
<p>All of my items are handmade and/or customized by me, come to you carefully packaged, and shipped quickly. My modified pens have had all of the ink removed from them, and drill tips are secured with high quality epoxy adhesive and reinforced inside the pen with a wooden dowel, whenever possible. You won't be disappointed, and your crafting friends will soon be asking you where you got your new accessories! </p>
<p>Please feel free to ask any questions, a special color request, or any clarifications about the items listed. I'm happy to answer you as quickly as possible.</p>
<p>Thank you for visiting The Dancing Daisy!!!</p> |
Flamingo Diamond Painting Pen, Diamond Dotz Pen, DIamond Art Pen, Arthritis, Carpal Tunnel, Hand Fatigue, Wrist Fatigue, Comfortable, Lightweight |
These Flamingo Diamond Painting Pens are lightweight and very comfortable. You can use them for hours even if you have hand/wrist problems, arthritis, carpal tunel, etc. |
Diamond_Painting_Pen,Tools,Accessories,5D,Arthritis,Carpal_Tunnel,Hand_and_Wrist,Unique,Comfortable, Diamond Dots Pen, Diamond Art Pen, Diamond Painting Tools Supplies, DIamond Painting Accessories |
Flamingo DIamond Painting Pen |
|
<p>This item will ship in 1-3 business days.</p> |
|
|
|
9.99000000 |
75M,6018 |
1751 |
The Dancin Daisy |
<p>Processing times vary per item. Each item will list the processing time.</p>
<p><br></p>
<p>Due to COVID, I do not accept returns or exchanges, but contact me if there is a problem with your order. I stand behind my products and pride my shop on 100% customer satisfaction so we will definitely work it out!</p>
<p><br></p>
<p>I accept cancellations within 3 hours of purchase for Custom/Personalized items and within 24 hours for all other orders. I cannot accept a cancellation after custom order has begun being made or is shipped. </p>
<p><br></p>
<p>I do not accept cancellations or issue refunds on pdf download files, as you receive them immediately upon purchase.</p>
<p><br></p>
<p>All orders will be shipped First Class unless Priority Shipping is purchased separately. USPS normally takes 3-5 days to deliver First Class packages, however, with COVID and employee shortages, they seem to still be experiencing delays in some areas and may take a little longer, even for Priority packages.</p>
<p><br></p>
<p>If your order arrives damaged, please contact me immediately. I will need for you to keep and take photos of the package, all packaging materials, and the damaged item/items. The post office will need this information for the "Damaged Package" insurance claim. </p>
<p><br><br></p>
<p><br></p>
<p> </p> |
flamingo-diamond-painting-pen |
71/75 |
<p>Hey Y'all. I'm Lisa and the creator of The Dancin Daisy. Helping people has always been my passion. I was a paramedic/firefighter for 30 plus years, until I retired in 2016. I have been crafting as stress relief all of my life, and now am able to spend lots of time creating things.</p>
<p> Now that I don't work on an ambulance or firetruck, I have found a new passion...I love creating new items for you to enjoy! </p>
<p>I love the rivers, lakes, and beaches here in, and around, South Louisiana, so I have started creating items with oyster shells and fish scales. It makes me happy to create items that will make others smile and fulfills my need of "helping" by making you happy! :)<br></p>
<p>Also, whether its Diamond Painting or any kind of Needle Work - I like to create new items, embellish items, or re-purpose items for your crafting enjoyment. A lot of people tend to wear my pieces as a magnetic brooch, so they do not put holes in their expensive clothing.<br></p>
<p>I treat each piece that I create with love and care. I am able to customize most anything so don't hesitate to reach out and ask!<br></p>
<p>What an honor it is to be affiliated with goimagine.com. I can TRULY help people now! And there is nothing more rewarding to me, than helping a child in need!<br></p>
<p>So, Thank You. Thank you all for shopping small businesses and THANK YOU for being a part of the #caringeconomy and shopping on #goimagine. YOU are helping children, too! And, last but definitely not least, Thank You for visiting The Dancin' Daisy!</p> |
D |