Query time 0.00286
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.94"
},
"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": "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.51",
"eval_cost": "0.20",
"prefix_cost": "0.71",
"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": "1.41",
"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": "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": 2,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.06",
"eval_cost": "0.02",
"prefix_cost": "1.48",
"data_read_per_join": "4"
},
"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": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.03",
"eval_cost": "0.02",
"prefix_cost": "1.53",
"data_read_per_join": "1K"
},
"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": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.05",
"eval_cost": "0.02",
"prefix_cost": "1.60",
"data_read_per_join": "355"
},
"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": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.03",
"eval_cost": "0.02",
"prefix_cost": "1.65",
"data_read_per_join": "2K"
},
"used_columns": [
"company_id",
"status"
],
"attached_condition": "<if>(found_match(companies), ((`goimagine`.`companies`.`status` = 'A') or false), true)"
}
},
{
"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.15",
"eval_cost": "0.02",
"prefix_cost": "1.82",
"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": "1.89",
"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": "1.94",
"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 |
| 61025 |
|
P |
A |
75 |
0.00 |
5 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1611987851 |
1611989361 |
0 |
N |
N |
N |
B |
N |
R |
N |
N |
N |
Y |
10 |
0 |
B |
|
1 |
10 |
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 |
Personalized Color Changing Mug, Magic Mug, Ocean, Beach Coffee Mug |
|
|
<p>This magic mug appears black until hot liquid is added, then the ocean design magically appears! A super fun way to make a surprise announcement, or write a special hidden message. </p>
<p>11 ounces.<br>For the longest life, hand washing is recommended.</p>
<p>The artwork on this mug is from another talented resin artist. For more information on her, please send me a message. </p>
<p>The design on the mug is 90 - 95% hidden in the cold state.</p>
<p><br></p>
<p></p> |
Color changing mug, ocean mug, magic mug, surprise mug, personalized |
Personalized Color changing ocean mug, gift idea for ocean lovers, Ocean art. |
Color changing mug, magic mug, ocean mug, beach coffee mug, custom, personalized, name in the sand, name on a mug, gift for her, gift for him, gift for girlfriend, Valentine’s Day gift, gift for friend, teacher gift, unique gift, Moving away, |
Personalized Color changing ocean mug |
|
<p>Made to order, Ships in 2 -3 business days. </p> |
|
|
|
24.95000000 |
195M,78 |
3249 |
Joy in the Making |
<p>Thank you for stopping by my little corner of the Caring Community!</p>
<p>My products are handmade and/or upcycled. I have a studio detached from my home where I do most of my work. See my shop description for more about me. <br></p>
<p><strong>Shipping:</strong> </p>
<p>Please know I recycle as much as I can, including boxes, so you may see tale tale signs of that. Rest assured, I am quite skilled at rebuilding secure boxes to fit your item. <br></p>
<p>I will send you a tracking number.</p>
<p>I cannot control the delivery company once they have your package. If there is an issue with your package once it is shipped, please contact me and we will work to resolve the issue. </p>
<p>If you are unhappy with your item, please reach out to me and we can discuss how to make it right. <br></p>
<p><strong>Returns</strong>: I do not typically accept returns. If there is something you’re not happy with, please message me to discuss. <br></p>
<p>For custom orders, I send photos of items prior to shipping for final approval and to be sure it is what you’re expecting. I do not do this for listed items, as photos are included in the listing. If you have questions, please contact me prior to purchase. </p>
<p><strong>Please remember</strong> there are color differences on screens, and I am not responsible for those differences.<br></p>
<p>If you are ordering a custom item, I ask a lot of questions in order to be sure I match your idea the best I can. Therefore, it is very important that you keep tabs on your email or conversations through Goimagine so you can answer my questions in a timely manner. I will wait 24 hours, then make a decision based on what information I do have. </p>
<p><strong>Regarding mugs:</strong> I do not use vinyl on my mugs. They are dishwasher safe, but handwashing is recommended. If you use a water softener such as vinegar, your design might fade a bit, so handwashing is strongly encouraged. </p>
<p><b>Regarding RESIN work: </b><br>Resin work is incredibly fluid and no two pieces will look identical. For custom orders, if I send proofs during the process, or when an item is complete, and you approve it, there will be no revisions or return. </p>
<p>I have a professional studio, including a sealed curing cabinet and air extraction system. Sometimes a rogue piece of dust will settle into your resin. Please see this as a reminder that you supported a handmade business.If you're concerned about this, please contact me and for more detailed photos. <br><br>Please note, if you have asked me to replicate a previously made piece of mine, I will do the best I can, but it is impossible to have an exact replica. I mix colors for each project, so even those will vary.</p>
<p>I support other makers and will not copy their work. If you see a style you like, please submit three or four variations and we can use them as inspiration to design your own unique piece. </p><p>I look forward to working with you on a project you’ll enjoy for years to come!</p> |
personalized-color-changing-mug-magic-mug-ocean-beach-coffee-mug |
4/46/195 |
<figure><strong><img src="https://d1q8o8ch5u48ua.cloudfront.net/images/companies/75/Screenshot%20(29).png?1588142088132"></strong></figure>
<p>Hey there! I'm Shannon and I resin all the things! In 2020 I added sublimation equipment to my studio. I’ll be adding more products from that project soon! Come say hi on <a href="http://www.instagram.com/joyinthemaking.art" target="_blank">Instagram</a> or <a href="http://www.facebook.com/joyinthemaking.art" target="_blank">Facebook!</a></p>
<p><em>We are a family business and you are an extension of this family. We appreciate you and look forward to sharing some JOY with you!</em><br></p>
<p>When I'm not in my studio making pretty things for your home, I'm being a wife (30 years whoop whoop!) and a mom to five grown kids who still manage to keep me busy, and I love it! Our 22 year old was born with part of her brain missing, and I am also her full time caregiver. <br></p>
<p>In 2018 my husband beat cancer. That's the year I realized I needed an outlet. My kids were slowly leaving home to be independent, and as a caregiver, I rarely took time to enjoy something just for me. At the same time, cancer isn't cheap! Our savings shrunk and I wanted to help recoup some of that. As a result, Joy in the Making was born!</p>
<p>As retirement years grow closer, we are gearing up for traveling and taking our products on the road to shows around the country. We both love doing events and combining that with traveling sounds amazing to us! </p>
<p>Have a blessed day and feel free to message me if you have any questions about our products, or us. </p> |
D |