Query time 0.00467
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "5.23"
},
"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.65",
"eval_cost": "0.10",
"prefix_cost": "1.10",
"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.91",
"eval_cost": "0.10",
"prefix_cost": "2.10",
"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.88",
"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": 3,
"rows_produced_per_join": 3,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.75",
"eval_cost": "0.30",
"prefix_cost": "3.93",
"data_read_per_join": "48"
},
"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.75",
"eval_cost": "0.02",
"prefix_cost": "4.98",
"data_read_per_join": "402"
},
"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.13",
"eval_cost": "0.02",
"prefix_cost": "5.12",
"data_read_per_join": "260"
},
"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": "5.18",
"data_read_per_join": "266"
},
"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": "5.23",
"data_read_per_join": "3"
},
"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 |
| 179318 |
GI-179318-IUJ |
P |
A |
5378 |
0.00 |
1 |
11.438 |
0 |
0 |
0 |
0.00 |
0 |
1645113762 |
1645113902 |
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:2;s:10:"box_length";i:16;s:9:"box_width";i:12;s:10:"box_height";i:10;} |
11.000 |
7.000 |
|
|
|
2147483647 |
en |
Peacock Afghan with Free Tropical Rain Soy Candle |
|
|
<p></p>
<p>The Peacock is a double stitched Crochet style blanket. The overall size is 65" x 65" The fiber in the yarn is acrylic. The border of the blanket has a bit of sparkle woven in with the acrylic. Also, the border is a wavy shell stitch that has a beautiful draping drip on each corner. The piece has been safely laundered. The care instructions say to machine was gentle (cold). Tumble dry warm (not hot). Made with love in a smoke free home.<br>The Peacock is sooo fluffy and cozy.. It feels like it's snuggling you back. It's similar to how a weighted blanket feels~ Blankets this size takes approximately 2 months to complete.</p>
<p>In an effort to create more joy and coziness in your home, I want to offer one of my huge soy candles for FREE with the purchase of Peacock; ($37.00 value). This soy candle is in a beautiful glazed pot that matches your Afghan beautifully! The fragrance I use in the wax is called Tropical Rain. The scent description is as follows... "A crisp and clean complex blend with notes of floral, juniper, citrus, a hint of ozone." Overall, it smells like a tropical rainy day; but not too intrusive. I believe it will add to the chill in your zone while you snuggle under Peacock :)</p>
<p>Tropical Rain is 6 1/2" across by 5" tall. It is holding 2 pounds and 12 ounces of premium soy wax. The burn time is well over 250 hours.</p>
<p>Enjoy~~</p> |
|
|
handmade, crochet blanket, peacock blue, peacock green, shell border, weighted blanket, one of a kind, crochet throw, bedroom decor, sofa throw, Free Candle BOGO |
|
|
<p>Ready to Ship</p> |
|
|
|
217.00000000 |
270M,218,11937 |
1887 |
gelDlights Candles and Crochet |
<p><br>I believe in providing the very best customer service that I possibly can. I live by the Golden Rule...treat others as you would like to be treated. So feel comfortable shopping with me!<br><br></p><p>My crochet offerings will have all the info needed about fiber content and stitch pattern inside the listing itself. They are all lovingly created by me and me alone~<br></p><p><span style="color: rgb(34, 34, 34); font-weight: 700;">About Returns and Exchanges</span><br></p>
<p>If at any time you're unhappy with your item, just contact me and I will work with you to make sure we resolve the issue. Whether it's a return or an exchange or a replacement that's needed, we will work together to determine the best course of action for us both.</p><p>Contact me within: 7 days of delivery<br>Ship items back within: 14 days of delivery<br>Request a cancellation within: 2 days of purchase</p><p>**Custom or personalized orders cannot be returned**</p><p><br></p><p><b>About Shipping</b></p><p>I use the most cost effective shipping I can muster. I'm not boxed into any particular carrier, as well. Whichever carrier needs to be used, I use. The timeframe for delivery is mandadted my your order communication and I will comply. If you need your order to be expedited, I can comply. Just communicate on your order or send me an email and we'll get it done. Separate payment for extra postage for expedition will be collected at the time of communication if it hasn't been collected within the order itself.</p><p>If there is a wide overage in postage charged, I will refund it back. </p><p><br></p><p><b>About Payment</b></p><p><br></p><p>I take all forms of electronic payment rendered through Paypal or Stripe.</p><p>I will also accept a check or money order. Please give time for it to be recieved, deposited and cleared by my bank. After that, I will ship the order out. <br></p><p><br></p><p><b>All The Other Bits...</b></p><p>Custom Order Plan..<br>Custom order work can be requested. I require 50% down and the balance plus the postage upon completion. Items that are Custom in nature MUST be purchased in a timely manner, preferably within 3 days of completion.<br><br>Holding Items for Future Purchase Plan...<br>Is not an option. If you plan on purchasing the item, please feel free to do so.<br>Also, if the item is a OOAK or Clearance, it likely won't be able to be remade or replenished. Grab it while you can. Have any questions on the remake-ability of the item you are watching, please contact me.<br><br>Thank you for understanding :)<br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p> |
peacock-afghan-with-free-tropical-rain-soy-candle |
4/125/270 |
<p>I am a Wife, Mother, dogmom, fishmom, plantmom and all around Creative person~ I've been making candles since 2008 and doing crochet since a young girl. I acheive balance in life with my spiritual connection to Christ and I always seek to make the world better today for tomorrow..one lovely candle or cozy crochet at a time :)</p> |
D |