Query time 0.00270
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "7.61"
},
"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.38",
"eval_cost": "0.10",
"prefix_cost": "0.48",
"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.21",
"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.89",
"eval_cost": "0.10",
"prefix_cost": "2.20",
"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.98",
"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": 6,
"rows_produced_per_join": 6,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.50",
"eval_cost": "0.60",
"prefix_cost": "5.08",
"data_read_per_join": "96"
},
"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.50",
"eval_cost": "0.03",
"prefix_cost": "7.18",
"data_read_per_join": "804"
},
"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.26",
"eval_cost": "0.03",
"prefix_cost": "7.47",
"data_read_per_join": "520"
},
"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.03",
"prefix_cost": "7.54",
"data_read_per_join": "532"
},
"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.03",
"prefix_cost": "7.61",
"data_read_per_join": "7"
},
"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 |
| 144429 |
GI-144429-DWW |
P |
A |
2948 |
0.00 |
2 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1634573189 |
1663870886 |
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 |
0.000 |
|
|
|
2147483647 |
en |
3D Large Square Holder |
|
|
<p>Make a set with the matching soap dish! You family and friends will be asking you where you got this stylish and unique holder. Add some pretty flowers in any room. Or maybe your makeup brushes. Better yet your toothbrushes in the bathroom! An inscription or sentiment can be added on the front and/or back!</p>
<p><b>ITEM DIMENSIONS:</b></p>
<p>3.8 in W x 4 in. L</p> |
|
|
kitchen, bedroom, bathroom, night stand, holder, flowers, makeup, toothbrushes |
|
|
<p><br></p>
<p><b>LOCAL PICKUP & SHIPPING WITHIN THE US ONLY (FEES MAY APPLY).</b></p> |
|
<p class="text-center"><b></b><span style="color: rgb(34, 34, 34); font-size: 24px; font-weight: 700;">WHAT IS EPOXY RESIN?</span></p><p class="text-center"><a href="https://acrylgiessen.com/en/best-epoxy-resin/">Epoxy resins</a> are a two-component system consisting of resin and hardener. By mixing the two components, a chemical reaction takes place so that the liquid resin gradually hardens to a solid plastic within hours.</p>
<p class="text-center">The result is a high-gloss, clear surface. Resin is mixed and poured into the mold, then whichever customization is selected it will be applied. After 24 hrs. the item is fully cured.</p>
<h3 class="text-center">WHAT IS RESIN ART?</h3>
<p class="text-center">With resin art, you can create works of art that enchant with their clarity, luminosity, brilliance, and depth. Color pigments or other additives are added to the epoxy resin and you can create resin paintings or do resin castings – there are endless possibilities!</p>
<p class="text-center">Different effects can be created by choosing the painting ground, the type of casting, the colors and the additives. Even experienced resin artists have never finished learning. <strong>Depending on the type of pigments used, you will get different results.</strong></p>
<p class="text-center"><span style="color: rgb(34, 34, 34); font-size: 24px; font-weight: 700;">RESIN PROCESSING TIME:</span><br></p><p class="text-center">The drying time depends on the room temperature and the <a href="https://acrylgiessen.com/en/types-of-resin/" target="_blank"><strong>type of resin</strong></a> used. When using PuDuo the temperature should also be roughly in the 70F (21C) to 80F (27C) range, but 65F (18.3C), minimum for the resin to cure properly.</p>
<p class="text-center"><span class="2phjq">Your finished casting can be removed from the mold after 10 hours, and full cure is after 24-48 hours depending on the temperature and mold sizes. PS: Our resin will be thicker or higher density when it is colder weather. So we suggest to warm the resin before you start your project in order to get best results. Just put the bottle into warm water, roughly 176F (80C), for about 2-3 minutes.</span></p>
<p class="text-center"><span class="2phjq">PuDuo resin will not cure within 8-10 hours for smaller crafts like earrings, pendants, or thinner castings (such as rulers), and it will most likely need to be left for 24-48 hours to properly cure. The more resin put in a mold, the more heat is produced which will speed up the curing time.</span></p><p class="text-center"><b></b></p>
|
|
20.00000000 |
4M,46,5843,6817,7695,8443 |
1503 |
Fire Fly Lanez |
<p class="text-center"><b><span style="color: rgb(0, 0, 0);"><em>DELIVERY OPTIONS:</em></span></b></p>
<p class="text-center"><span style="color: rgb(0, 0, 0);">Local Pickup/Drop off & shipping within the US Only (fees may apply). Processing/shipping times may vary depending on the size of the order.<br><strong style="color: rgb(51, 51, 51);"><span style="color: rgb(0, 0, 0);"><em><br>CUSTOM & PERSONALIZED ORDERS:</em></span></strong><br></span></p>
<p class="text-center"><span style="color: rgb(0, 0, 0);">Please make sure you include all important information when placing your order. You can enter notes / comments when checking out to make sure your order is correct. If I have to contact you, it may result in a delay of your order.<br><em><strong><br>WHAT IF YOU NEED TO RETURN AN ITEM?</strong></em><br></span></p>
<p class="text-center"><span style="color: rgb(0, 0, 0);">Since all orders are custom made and personalized to your specifications, I don't accept returns. If there is a problem with the order, please reach out to me and we can discuss the next steps.<br><strong style="color: rgb(51, 51, 51);"><span style="color: rgb(0, 0, 0);"><em><br>SHIPPING INFORMATION:</em></span></strong><br></span></p>
<p class="text-center"><span style="color: rgb(0, 0, 0);">I don't insure mailed packages. I do not take responsibility if packages are lost and or stolen or misplaced due to incomplete/incorrect information provided upon check out. If an error was made please contact me and I will cancel the order so you can correct the issue.<br><br></span></p>
<p class="text-center"><span style="color: rgb(0, 0, 0);"><em><strong></strong><strong>CARE INSTRUCTIONS:</strong></em></span></p>
<p class="text-center"><span style="color: rgb(0, 0, 0);"><em><i><b>RESIN:</b></i></em></span></p>
<p class="text-center"><span style="color: rgb(0, 0, 0);">Please handle with care. Dropping your Resin art piece can result in damage. Please keep away from sunlight. Clean with a damp cloth, only if necessary.</span></p>
<hr>
<p class="text-center"><strong><em>DIAMOND ART:</em></strong><br></p>
<p>Keeping your diamond art painting flat is the best way to store them as it will help avoid the diamonds from falling off its canvas. Store flat until you are ready to place it in a frame, or other permanent option.</p>
<hr>
<p class="text-center"><strong><em>DRINKWARE / CERAMIC MUGS</em><span style="color: rgb(0, 0, 0);"><i><b><em>:</em></b></i></span></strong></p>
<p class="text-center"><span style="color: rgb(0, 0, 0);">Please do not place in dishwasher. Please handle your drinkware with care and hand wash with a soft non abrasive cloth. While the ceramic mug(s) can be put in the dishwasher, to preserve the beauty and longevity of the design, it is recommended (optional) they be hand washed.<br><span style="color: rgb(51, 51, 51);"><br>**</span>Please keep in mind that you have received an authentic, one of a kind, homemade art piece. Variations in texture and other imperfections may be visible. <span></span>I hope you love your piece as much as I loved making it for you!!**<em><br></em></span></p> |
3d-large-seashell-square-holder-clone |
4 |
<p>Welcome to Fire Fly Lanez! I started making Resin crafts almost one year ago and Diamond Art about two years ago and I LOVE IT! I also have fallen in love with making Resin Tumblers and Snowglobe Tumblers... It's not work if you love what you do... I would LOVE to share my joy with everyone else! </p>
<p>All Resin you see is handmade by me. Pieces are sold as is, BUT... can be customized to match your requests and/or your imagination... I use mica powder, opaque pigment, alcohol ink, glitter, shells… Items can be made into magnets, keychains and even pendants, ask and I'll see what I can do for you! Creations can be made for favors, christenings, baby showers/gender reveals, birthdays, house warming gifts, etc... <em>(If you are interested in buying items in bulk please contact me for separate pricing.)</em><br></p>
<p>The Diamond Art is sold as is.</p>
<p>Let’s have some fun, come see what I have to offer, and we can work on getting you your own creation(s).<br></p> |
D |