Query time 0.00223
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "9.78"
},
"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.64",
"eval_cost": "0.10",
"prefix_cost": "1.09",
"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.08",
"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.87",
"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": 9,
"rows_produced_per_join": 9,
"filtered": "100.00",
"cost_info": {
"read_cost": "2.25",
"eval_cost": "0.90",
"prefix_cost": "6.02",
"data_read_per_join": "144"
},
"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": "2.25",
"eval_cost": "0.05",
"prefix_cost": "9.17",
"data_read_per_join": "1K"
},
"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.40",
"eval_cost": "0.05",
"prefix_cost": "9.61",
"data_read_per_join": "781"
},
"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.05",
"prefix_cost": "9.70",
"data_read_per_join": "799"
},
"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.05",
"prefix_cost": "9.78",
"data_read_per_join": "10"
},
"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 |
| 199005 |
GI-199005-CQU |
P |
A |
653 |
0.00 |
50 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1648139814 |
1648140435 |
0 |
N |
N |
N |
D |
N |
R |
N |
N |
N |
Y |
10 |
0 |
S |
|
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 |
Initial cow tag hand towel |
|
<p>Decorate your kitchen or use to towel dry your dishes with these fun cows with flowers, waffle weave kitchen towels.</p> |
<p></p>
<p></p>
<p>These soft and luxurious towels makes the perfect keepsake gift for that special couple in your life. Our personalized cow tags are a beautiful accent to any kitchen decor and can be used to towel dry your dishes. The design includes a beautiful cow tag customized with an initial or a take a number cow tag. Give a unique gift that will remind them of their special day. </p>
<p>• Towel measures 16" x 24"<br>• High absorption — up to 25x its weight!<br>• Binded edges for nice and clean look<br>• 80% polyester / 20% polyamide<br>• Looped microfiber, waffle pattern<br>• Lint free and no shedding</p>
<p><br><br></p>
<p></p> |
Cow tag towel, hand towel, dish towel, bathroom towel, country wedding gift, decorative towels, cow kitchen, hostess gift ideas, new home, housewarming gift, eco friendly gifts, paperless towels |
These soft and luxurious towels makes the perfect keepsake gift for that special couple in your life. |
Cow tag towel, hand towel, dish towel, bathroom towel, country wedding gift, decorative towels, cow kitchen, hostess gift ideas, new home, housewarming gift, eco friendly gifts, paperless towels |
Initial cow tag hand towel |
|
<p></p>
<p></p>
<p><br></p>
<p>Processing time is currently 1-5 business days</p>
<p>Estimated shipping time is United States: 3-5 business days<span class="display-block"></span>
</p>
<p><br></p>
<p></p>
<p>
</p>
<p></p> |
|
<p></p>
<p>HOW TO CARE FOR ME<br>Wash with like colors and throw in me in the dryer, if you like!</p>
<p></p><p>Thank you for stopping by my shop. If you have any questions, please reach out. I'm here and happy to help.
If you would like to browse our other wedding keepsake gifts click here: <a href="https://capablebydesign.goimagine.com/">https://capablebydesign.goimag...</a><br></p>
<p>- Kimberly, Capable by Design</p>
<p></p><p><br></p>
<p></p>
<p> </p>
<p><br></p>
|
|
14.95000000 |
203M,26,3283,4071,4034,4073,4051,11842,3279 |
2278 |
Capable By Design |
<p><b><u>SHIPPING:</u></b>
</p>
<p>Processing time is currently 1-5 business days, please allow for additional processing times during holidays. Processing time is the time I need to prepare an order for shipping and doesn't include shipping.
</p>
<p>Estimated shipping times United States: 5-7 business days, I'll do my best to meet these shipping estimates, but cannot guarantee them.
</p>
<p><b><u>RETURNS AND EXCHANGES:</u></b>
</p>
<p>Contact me within 5 days of delivery. Ship items back within 14 days of delivery </p>
<p><b><u>I DON’T ACCEPT CANCELLATIONS: </u></b>
</p>
<p>But please contact me if you have any problems with your order. </p>
<p><b><u>THE FOLLOWING ITEMS CANNOT BE RETURNED OR EXCHANGED:</u></b>
</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: 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. <br></p>
<p>
</p>
<p><br></p>
<p></p>
<p><b>FREQUENTLY ASKED QUESTIONS:</b>
</p>
<p><b>Returns and Exchange Details</b>
</p>
<p>I offer refunds or exchanges for defective products. I do not offer refunds or exchanges on any custom-made personalized products unless it is defective. Please message me if you have a question regarding your order and I will be happy to look over your situation!
</p>
<p><b>What if I am shipping multiple gifts?</b>
</p>
<p>If you are purchasing more than one gift to be shipped to different addresses, each item must be its own separate order. Thank you.
</p>
<p><b>Care instructions</b>
</p>
<p>Care instructions are listed in each product description, if you have any questions, please don't hesitate to message me.
</p>
<p>
</p>
<p></p>
<p><strong><br></strong></p>
<p><br></p> |
initial-cow-tag-hand-towel |
4/46/202/22751/203 |
<p><span class="mt-xs-1" data-inplace-editable-text="story" data-endpoint="AboutPost" data-key="story" data-placeholder="How did you get started? What inspires you? We know each seller’s story is unique—tell yours here."></span></p>
<p>MAKING YOUR FAVORITE THINGS IS OUR FAVORITE THING</p>
<p>For designer and founder, Kimberly Cap, creating gifts that speak to you is the ultimate goal — even more so when that gift is for you. From the softest graphic tees and personalized towels to special tote bags, pillows and sassy gifts, this is where personality shines and hearts become full. <br></p>
<p>Capable by Design is a brand built around thoughtfulness. Vibrant and spirited. Inclusive and happy. This is where bad days don’t exist, because Kimberly — wife, mom, gramma and dog momma — is focused on delivering what you’ll love; the custom pieces you wish for; and the gifts you need to spoil those you love. Because when you shop here, every day is made. <br></p>
<p><span class="mt-xs-1" data-inplace-editable-text="story" data-endpoint="AboutPost" data-key="story" data-placeholder="How did you get started? What inspires you? We know each seller’s story is unique—tell yours here."><em>choose to stand out </em></span><em></em><br></p>
<p></p>
<p></p> |
D |