Query time 0.00256
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "6.02"
},
"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.30",
"eval_cost": "0.10",
"prefix_cost": "0.40",
"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.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.89",
"eval_cost": "0.10",
"prefix_cost": "2.14",
"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.92",
"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.32",
"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.72",
"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.91",
"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.04",
"eval_cost": "0.02",
"prefix_cost": "5.97",
"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": "6.02",
"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 |
| 120709 |
a139 |
P |
A |
264 |
44.95 |
1 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1629057153 |
1672753852 |
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 |
Acrylic painting titled "Rainbow Chaos" |
|
|
<p></p>
<p>Original acrylic painting on stretched frame canvas. This abstract colorful wall art is a one of a kind piece of home decor, great to brighten up any space. This piece is titled "Rainbow Chaos". These are actually incredibly hard to photograph due to the fact that the lighting affects the appearance of color so much and monitor colors may vary. I have tried to photograph from slightly different angles so that you can see the finish and the texture. </p>
<p>This canvas is 10" inches high by 10" inches wide and 5/8" inch thick.<br>This is a one of a kind original artwork, not a print or reproduction.<br><br>Each canvas has a "signature", number, and year written on the back. This is #139 2021<br>Paintings listed for sale are complete works ready to frame or hang.</p> |
one of a kind art, acrylic on canvas, original painting, colorful artwork, original artwork, acrylic rainbow, bright home decor, colorful wall art, RainbowMaille, contemporary art, modern art, abstract rainbow art, unique art gift, mothers day gift |
Acrylic on canvas one of a kind original painting titled Rainbow Chaos" by RainbowMaille |
one of a kind art gift, acrylic on canvas, original painting, colorful artwork, original artwork, acrylic rainbow, bright home decor, colorful wall art, contemporary modern art, abstract art, unique art |
Acrylic painting titled Rainbow Chaos |
|
|
|
<p></p>
<p class="text-center"><b>A glimpse into RainbowMaille's studio</b></p>
<p></p>
<hr>
<p>My art starts with pre-made medium-weight cotton duck canvases that come pre-stretched, kiln dried, and pre-primed, it saves a lot of time.</p>
<p>By sticking with the smaller size canvases like 8" x 8", 8" x 10", 10" x 10" 11" x 14" it helps to keep shipping easier and reasonably priced.</p>
<p>Currently using mostly acrylic paints these days, although I do have some older watercolor works for sale.</p>
<p>Made with Liquitex brand quality products including paints, mix-ins and varnish, although I do also sometimes use Krylon spray sealants.</p>
<p>I use a variety of brushes, pallet knives, putty knives, my hands and some other more non-traditional tools as well.</p>
|
|
44.95000000 |
31M,45,4151,11984 |
2691 |
RainbowMaille |
<p>Welcome to RainbowMaille, I try to use only nickel-free and hypoallergenic materials in my jewelry, if I ever use anything that is not nickel-free the listing will specify that. The wall art is not made with nickel- free materials because it is not meant to be worn.</p>
<p><br></p>
<ul><li><strong><span style="color: rgb(149, 55, 52);">Returns and Cancellations</span></strong></li></ul>
<p>Returns are accepted within 14 days of delivery, money will be refunded after the product is returned. Return shipping costs are the responsibility of the buyer.<br><br>If an item is broken or damaged in shipping I will repair or replace it at no charge, please message me to make arrangements. 4rainbowmaille@gmail.com<br><br>Cancellations are accepted before orders ship but be warned I ship quickly often same day on completed items.<br>Cancellations requested after the 24-hour period will be decided on a case by case basis and may not be eligible for full refund if the order has already shipped.</p>
<p><br></p>
<ul><li><strong><span style="color: rgb(155, 187, 89);"><span style="color: rgb(149, 55, 52);">Shipping</span></span><span style="color: rgb(149, 55, 52);"></span></strong></li></ul>
<p>Once payment has been received/processed I will ship the order, most orders will ship within 1-3 days.<br>*You have a choice of shipping via USPS Priority mail or First-class package on most items, tracking is included.<br><br>Custom orders may take longer to ship depending on the size of the item.<br><br>*Please make sure to provide a correct/current address. I am not responsible for misdirected packages due to incorrect address information provided by the buyer.</p>
<p><br></p>
<ul><li><strong><span style="color: rgb(149, 55, 52);">Custom orders and wholesale</span></strong></li></ul>
<p>I will happily do custom orders for chainmaille jewelry or wire tree art, just contact me and tell me what you want. There is no design fee for custom work. However, if it requires the purchase of special materials there may be a variance from standard pricing.<br><br>I will not do wholesale due to the number of hours I put into each piece, although, I may offer some discounts on larger/multiple piece orders, email for details. 4rainbowmaille@gmail.com</p>
<p><br></p> |
acrylic-painting-a139 |
23/31 |
<p>Hello, my name is Amanda, I am a housewife, a cat lover and Maker of many things. It seems like I have always been crafting something. I learned to sew, crochet, and embroider from my grandmothers when I was young and that was just the beginning of my love of making things. I have gone through phases in my life where I have crafted many things, it seems like almost everything. I love embroidery, cross-stitch, and floral arranging but I have also made Christmas wreaths, scrapbooks, and leather crafts.<br></p>
<p><br>I started making chainmaille jewelry around 2012. It didn't take long for "playing with rings" to become an addiction. As I learned more chain patterns, I also learned to use better quality rings and materials. I still love light-weight, small silver- and gold-plated rings, but I also use a variety of anodized aluminum of various gauges and sizes. I am careful to make sure that all my rings are made with nickel-free materials, but occasionally some clasps and charms are not guaranteed nickel-free. I know lots of people have metal sensitives and allergies and I promise to clearly mark all of my products, so that you will always know what you are getting.<br><br>Part of why my chainmaille is priced higher than some others is because of the number of hours I spend on each piece. I probably could make things faster, but they would not be the quality I expect of myself. I am a bit O.C.D. so I tend to obsess over my ring closures. I know it's not possible to close every single ring perfectly, but I try. I aim for tight fits with good alignment not only side to side but top to bottom. In general, if I can see space/light then it's not right and I will do it again. I believe that gaps and misalignment lead to snagging and snagging leads to damage and breakage, so I work very hard to avoid that. </p>
<p>In recent years I have also started to make art in various other forms and mediums, from wire tree sculptures to paintings on canvas and the occasional combination. </p> |
D |