Query time 0.00538
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "5.99"
},
"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.91",
"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.89",
"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": 4,
"rows_produced_per_join": 4,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.00",
"eval_cost": "0.40",
"prefix_cost": "4.29",
"data_read_per_join": "64"
},
"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.00",
"eval_cost": "0.02",
"prefix_cost": "5.69",
"data_read_per_join": "536"
},
"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.17",
"eval_cost": "0.02",
"prefix_cost": "5.87",
"data_read_per_join": "347"
},
"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.02",
"prefix_cost": "5.94",
"data_read_per_join": "355"
},
"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.99",
"data_read_per_join": "4"
},
"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 |
| 79185 |
|
P |
A |
2037 |
0.00 |
18 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1619117628 |
1675273777 |
0 |
N |
N |
N |
B |
Y |
R |
N |
N |
N |
Y |
10 |
0 |
B |
|
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 |
3”name puzzle Personalized puzzle style 2 |
|
|
<p></p>
<p>Personalized puzzle , baby name puzzle or word puzzle handmade to any length. </p>
<p>The capital letters are about 3” tall by about 2 1/2” wide and 3/4" thick. The lower case letters are about 2 1/4” tall. Each letter is made separately just like any other puzzle. </p>
<p>Cut from poplar hardwood, and sanded and then painted with an enamel paint.</p>
<p>Also cut from natural woods with a linseed oil</p>
<p>Choice of many colors or unfinished to paint at home. </p>
<p>Each letter can be a separate color. </p>
<p>Just think of the joy that you and or your family and friends will get from this personalized word puzzle.</p>
<p>Name will be cut with the first letter upper case and the remainder lower case unless specified ALL CAPITAL letters</p> |
Wood name, personalised gift, name puzzle, nursery decor, wooden letters, baby shower gift, |
Letters cut from poplar wood to form a puzzle per customers name request in light or dark wood or several color choices |
name puzzle, name puzzle baby , nursery gift, learning toy, personalized gift, wooden name sign, new born gift, baby shower gift, wood letters, personalized puzzle, baby name puzzle, painted |
Personalised wood name puzzle |
|
<p>Once the order is placed, the name puzzle will be shipped within 7 days. </p> |
|
|
|
31.99000000 |
76M,88,3605,11891 |
4885 |
Rich’s Wood Shop |
<p></p>
<p>I gladly accept returns and exchanges
</p>
<p>Contact me within 14 days of delivery
</p>
<p>Ship items back within 30 days of delivery<br></p>
<p>I do not accept cancellations
</p>
<p>But please contact me if you have any problems with your order.
</p>
<p>The following items cannot be returned or exchanged
</p>
<p>Because of the nature of these items, unless they arrive damaged or defective, I cannot accept returns for:
</p>
<ul> <li>Custom or personalized orders</li></ul>
<p>Conditions of return
</p>
<p>Buyers are responsible for return shipping costs. If the item is not returned in its original condition, the buyer is responsible for any loss in value.
</p>
<p> </p>
<p>Custom orders are always welcome from personalized ornaments to signs with that special message.
</p>
<p>Is everything really hand cut
</p>
<p>We cut everything on a scroll saw. At no time do we use a computer aided machine to cut anything we sell. Because of this, you are getting an heirloom, one of a kind item.
</p>
<p>How are your item finished?
</p>
<p>We finish everything with linseed oil. Linseed seed gives the wood a beautiful natural finish. Some of our pieces are stained first before the linseed oil finish is applied.
</p>
<p>Care instructions
</p>
<p>Because our pieces are finished with linseed oil, they require very little maintenance, and the finish will last several years.
If your piece needs to be freshened up. All is required is to reapply the linseed oil by pouring the linseed oil on the piece and placing on a paper towel to soak up the excess linseed oil. Then pat the price with paper towels to remove the remaining linseed oil. Let dry for a few hours on a paper towel. Now it should look as good as new. Please note that paper towel should always be used, and never should cloth towels should be used due to the reaction that oil and cloth have. Oil on a cloth cause a chemical reaction that makes them burst into flames.
</p>
<p><br></p> |
personalized-handmade-wood-letter-puzzle |
4/76 |
<p></p>
<p>It is funny how you start doing things and the next thing you know you are selling some. My shop journey started several years ago when I answered an ad for a planner I was looking to buy. The guy selling the planer had a old scroll saw for sale also. The price was good on both, so I bought both. I had never cut anything on a scroll saw, but I have made a great deal of things out of wood. I found a pattern book at thrift store and made a few things for a craft fair I was doing. Mostly plywood ornaments you put in house plant pots. I started to make some crosses and Christmas ornaments for my daughter and grand kids to sell a church craft fair. My interest was more in building outdoor wood furniture. I made a few sets and sold them, but was never able to really get it off the ground. Fast forward to now, I found that I was drawn back to the scroll saw and wanted to concentrate more on doing wood ornaments for all occasions , wood signs and layered wildlife wall decor. I love the artistry of the scroll saw. Taking a piece of wood and with about 10 to 100 cuts it is transformed into a beautiful piece of art a real heirloom. Each internal cut requires a very small hole. Just large enough to get the saw blade through. <br>Morning are my most productive time. I get up , do my devotions and then spend an hour to an hour and a half running my scroll saw. Once I finish a piece it is sanded smooth, the dust is vacuumed off and then finished with linseed oil.</p> |
D |