Query time 0.00827
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "6.77"
},
"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.31",
"eval_cost": "0.10",
"prefix_cost": "0.41",
"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.14",
"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.88",
"eval_cost": "0.10",
"prefix_cost": "2.13",
"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.91",
"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": 5,
"rows_produced_per_join": 5,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.25",
"eval_cost": "0.50",
"prefix_cost": "4.66",
"data_read_per_join": "80"
},
"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.25",
"eval_cost": "0.03",
"prefix_cost": "6.41",
"data_read_per_join": "670"
},
"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.21",
"eval_cost": "0.03",
"prefix_cost": "6.65",
"data_read_per_join": "434"
},
"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": "6.71",
"data_read_per_join": "444"
},
"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.03",
"prefix_cost": "6.77",
"data_read_per_join": "6"
},
"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 |
| 208198 |
GI-208198-DYY |
P |
A |
2885 |
0.00 |
1 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1650387695 |
1675803413 |
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 |
Original Painting Psalm 8:3-4 Moon & Stars with Acrylics 8 x 10 |
|
|
<p>Original Artwork 8" x 10" Canvas in acrylic paints. Watermarks are not be on original<br></p>
<p><br>We were asked to do a Maker's Challenge with theme: Moon & Stars. I was inspired by our Lord's magnificent hands, the Creator of all things. This painting is done using acrylic paints with some glow paint within the Aurora Borealis. <br></p>
<p>"When I consider your heavens,
the work of your fingers,
the moon and the stars,
which you have set in place,
what is mankind that you are mindful of them,
human beings that you care for them?" -Psalm 8:3-4
</p>
<p>
</p>
<p>
</p>
<p></p> |
Psalm 8:3-4 Moon & Stars Original Painting with Acrylics 8 x 10 |
Psalm 8:3-4 Moon & Stars Original Painting with Acrylics 8 x 10 |
Original Artwork, Painting, Acrylic, Stars, Moon, Aurora Borealis, Night Sky, Scenery, God, Jesus, Lord, Faith, Christian, Bible, Psalm, Trees, Horizon, One of a kind, cosmic, galaxy, purple, pink, blue, sky |
Psalm 8:3-4 Moon & Stars Original Painting with Acrylics 8 x 10 |
|
<p>Please Allow 2-3 Business Days to ship <br></p> |
|
<p>Hand painted with acrylic and a touch of glow paint.</p>
|
|
77.70000000 |
31M,23,9534,14300,14301 |
1626 |
Exzatic Designs |
<p><strong>Processing Time:</strong> Items Ship within 1-3 Days for ready to ship items and up to 10 days for custom orders.</p>
<p><strong>Return Policy:</strong> If there are any issues please let me know as soon as possible and we can see what I can do. Items can be <span class="d2edcug0 hpfvmrgz qv66sw1b c1et5uql lr9zc1uh a8c37x1j keod5gw0 nxhoafnm aigsh9s9 d3f4x2em fe6kdd0r mau55g9w c8b282yb iv3no6db jq4qci2q a3bd9o3v b1v8xokw oo9gr5id" dir="auto" lang="en">returned minus cost of shipping if there is an issue with the product. Earrings and masks must be unopend and unused to qualify for return. </span>Custom items are non-refundable.<br></p><br><p></p>
<p></p> |
psalm-8-3-4-moon-and-stars-original-painting-with-acrylics-8-x-10 |
23/31 |
<p><span style="color: rgb(75, 172, 198);"><em><strong></strong></em><strong>Aloha & Hello! My name is Cherie and I am originally from beautiful Hawaii, and now reside in the awesome Midwest. I once was an independent woman with her own office and full time student then my world was turned completely around. I am now a mother, homemaker and wife to a military veteran and police detective. I have homeschooled my kids for over 9 years now and my life has never been so hectic but, I tell you, I would not change a single thing. I feel God has created and molded me and my life to be exactly where I am today. I started doing art and crafts as an outlet but, found myself wanting to do more…
</strong></span></p>
<p><span style="color: rgb(75, 172, 198);"><strong><br></strong></span><br></p>
<p><span style="color: rgb(75, 172, 198);"><strong>One day, the Lord put into my heart to not only share my gifts but, to spread His Word and to use the proceeds to help others. I used to just make things for fun and as gifts. I donated some items once and people insisted I sell them instead. After my first few sales, it all started to make sense on what I should do. All my proceeds are used to bless others and spread joy to all (with the exception of needing to buy supplies). Never had I felt so motivated to use my talents for something other than making others smile. So, after a year, I finally decided to venture online and start to actually sell my products.
</strong></span></p>
<p><span style="color: rgb(75, 172, 198);"><strong><br></strong></span><br></p>
<p><span style="color: rgb(75, 172, 198);"><strong>Then, one day, I stumbled across Goimagine! Only after a couple weeks on Etsy, I found Goimagine. When I saw what this company was doing, and their purpose, again it was put into my heart to be a part of this company that helps children instead! I right away transferred from Etsy to GI. I couldn’t think of a better platform to work with as it so perfectly went with my own causes. God has a plan, and it was very clear when he showed me this path. </strong></span></p>
<p><span style="color: rgb(75, 172, 198);"><strong><br></strong></span><br></p>
<p><span style="color: rgb(75, 172, 198);"><strong>So, here I am and pray that every piece of my creations brings others God’s love, joy, and a smile to every face.
</strong></span></p>
<p><span style="color: rgb(75, 172, 198);"><strong><br></strong></span><br></p>
<p><span style="color: rgb(75, 172, 198);"><strong>Mahalo/Thank You,
</strong></span></p>
<p><span style="color: rgb(75, 172, 198);"><strong><br></strong></span><br></p>
<p><span style="color: rgb(75, 172, 198);"><strong>Cherie
</strong></span></p> |
D |