Query time 0.00320
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "5.30"
},
"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.32",
"eval_cost": "0.10",
"prefix_cost": "0.42",
"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.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.15",
"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.93",
"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.98",
"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.03",
"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.13",
"eval_cost": "0.02",
"prefix_cost": "5.18",
"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.24",
"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.04",
"eval_cost": "0.02",
"prefix_cost": "5.30",
"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 |
| 45913 |
117-2 |
P |
A |
429 |
30.00 |
10 |
1.500 |
0 |
0 |
0 |
0.00 |
0 |
1600789491 |
1666625942 |
0 |
N |
N |
N |
D |
N |
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:6;s:10:"box_length";i:12;s:9:"box_width";i:8;s:10:"box_height";i:3;} |
1.000 |
8.000 |
|
|
|
2147483647 |
en |
Wall Mounted Bottle Opener Carved Wood Custom Personalized Military Patriotic 4" x 12" Oak or Cherry Personalized |
|
<p>Made of choice of oak or cherry approximately 4" x 12" x .7" and includes choice of keyhole slot or pre-drilled mounting holes.</p> |
<p>Measures approximately 4" x 12". Choice of oak or cherry.</p>
<p>Fully customizable, made to order. </p>
<p>Includes: (Be sure to enter details in checkout notes)</p>
<ul><li>Choice of oak or cherry, measuring approximately 4" x 12"</li><li>Keyhole slot or pre-drilled holes at top and bottom</li><li>Bottle Opener mounted to board</li><li>Choice of protective finish: matte, satin, gloss</li><li>Custom Text (the more text, the smaller it'll be)</li></ul>
<p>Additional Options Available:</p>
<ul><li>Graphic is extra (see options). I'm currently licensed with the Air Force, Space Force, Navy, and Marines.</li><li>Edging upgrade available.</li></ul>
<p> Each piece of wood is unique. Variations including grain and knots are to be expected and are not considered flaws. Sizing is approximate and may vary +/- 10%, if you need an exact size, please let me know.</p> |
|
|
custom bottle opener, beer opener, custom beer opener |
|
|
<p>Allow 2-3 weeks for delivery after approval of mockup.</p> |
|
|
|
30.00000000 |
206M,208,18454 |
4357 |
CraftedCarvings |
<p><strong><span style="color: rgb(149, 55, 52);">Please review before purchasing!</span></strong></p>
<p><strong>Sizing details</strong><br>The materials I use are reclaimed, refurbished, or at least rebought and may be one of a kind. To maximize usage, sizing may vary in all dimensions plus or minus about 10%. For custom signs, you'll be sent a mock up based on your custom text along with approximate dimensions planned for your project. Let us know at the time of your order if exact specific sizing is required.</p>
<p><strong>Custom and personalized orders</strong><br>The max number of characters for personalization may be limited based on the size of the item. If you need more, please contact me for a customized quote. The font(s) shown in the first photo is generally standard for that sign. If you'd like another font, just let me know! I will send a mockup of your personalized sign within 2-3 business days for your approval before beginning work.</p>
<p><strong>Care instructions</strong><br>Some items include indoor/outdoor urethane, some include just inside urethane, and some are left unfinished. Cedar and redwood weathers nicely outside whether finished or not, but other wood types should be sealed for protection and that protection should be renewed by the customer regularly to ensure continued protection. Corian is a man-made acrylic that is weather proof and uv resistant, however the paint (though suitable for outdoor use) will need touch ups if used outside just as house paint would. </p>
<p><strong>Packaging</strong><br>Packaging and protective materials are mostly recycled, but still clean and sturdy, this is to save you money as well as help keep perfectly usable material out of the landfill.<br></p>
<p><strong>Cancellations</strong><br>I get to work on your mockup as soon as possible after your order is received to get it to you within the promised time frame, so cancellations are not accepted after 24 hours. Please respond promptly with your input for the mockup as work will not begin until you approve it.</p>
<p><strong>Returns/Refunds<br></strong>As all work is done to order specifically for you, returns and refunds are not possible. If your order arrives damaged or is lost in the mail, let me know and I'll make it right. Be sure the mockup I send is how you want the final design to look. </p>
<p><strong>Processing time</strong><br>Processing time is an estimate. For most custom products, that will be within 2 weeks. If you absolutely must have your order by a certain date, please contact me before order. While I can promise the date I will ship. I cannot guarantee delivery times as sometimes things just happen. If you are local to Rosamond, CA, you are welcomed to pickup.</p>
<p><strong>Shipping and Insurance<br></strong>Shipping times are estimates. Once accepted by the post office, priority usually takes 1-3 days, and ground UPS/FEDEX takes 1-6 days. However, occasionally things are delayed or misdirected. Shipping arrival is not guaranteed except for Priority EXPRESS. </p>
<p>All items are shipped insured. Lost items cannot be claimed until 15 days have passed for domestic and 30 days for international. Damaged items will need to have photos taken and the packing material kept. Please contact me for details.</p>
<p></p>
<p><br></p> |
bottle-opener |
4/46/206 |
<p>Hello! My name is Jennifer. I am an Army veteran, mom to an Army reservist/social worker, wife, and Christian. Blessed with working for a sign maker in high school and gifted a routed for Christmas, I made crafting my full-time job in 2015. I truly enjoy creating products you'll enjoy receiving and giving. If you'd like to customize anything you see in my shop to make it yours alone, just let me know. I love working with you to make unique pieces. If you are not quite ready to buy, please favorite my shop so you can find me easily when you are ready. Thanks for looking! </p>
<p> I also operate EnkoreSign.net, PACKAwards.net and MilitaryPatriot.net on Etsy so be sure to check them out, too... but just to see what I can do. If you want something you see there and not on GoImagine, please contact me so I can recreate the listing here. I'm a bit behind but working to increase my selection here where profits support children in need! </p>
<p>As a former foster parent and a parent of a daughter who chose to go into social work to help keep children from having to go into foster care, I am passionate about the GoImagine cause and look forward to the day I have all my inventory for sale here. </p>
<p> </p> |
D |