Query time 0.00202
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "5.31"
},
"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.34",
"eval_cost": "0.10",
"prefix_cost": "0.44",
"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.18",
"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.17",
"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.95",
"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.76",
"eval_cost": "0.30",
"prefix_cost": "4.01",
"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": "5.06",
"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.20",
"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.04",
"eval_cost": "0.02",
"prefix_cost": "5.26",
"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.31",
"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 |
| 219161 |
GI-219161-MFG |
P |
A |
5378 |
0.00 |
1 |
5.375 |
0 |
0 |
0 |
0.00 |
0 |
1652217093 |
1654272325 |
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:12;s:9:"box_width";i:12;s:10:"box_height";i:10;} |
5.000 |
6.000 |
|
|
|
2147483647 |
en |
Digital Sea Crochet Cuddle Wrap with Free Cool Ocean Breeze Mosaic Candle |
|
|
<p>The beautiful Digital Sea Cuddle Wrap is crocheted using a soft and supple acrylic yarn that has a slight sheen to it. I designed it with a color block pattern in mind, using greens and blues to create a seaside sort of look. As I was working, my husband walked by and said .."digital green..!" I'd never heard of that color name before. I liked it, so I incorporated it into the life of this beautiful piece :) In addition to the digital green, there is a dark blue-green, a medium blue-green and a color blend containing all of the colors plus dark green.</p>
<p>The stitch I used here is a double V which lends itself well to the drape of the garment. The overall size of the piece is 25" long by 82" wide. There are four chunky tassels that are affixed to each corner for a little more pizzazz~ You can use this as a lovely, dramatic wrap or as a couch cuddler for those chilly nights. Or make it a gift to your fashion forward loved one! </p>
<p>Your free candle with purchase is a mosasic glass beauty filled with a gel wax blend. The wax is fragranced with a custom blend fragance I call Cool Ocean Breeze. The color of the tiles on the container and the wax inside work together to make this candle and crochet combo a doubly pleasurable prospect :) Your candle is 5" across by 4" tall and will yield a burn time of approximately 200 hours.</p>
<p>Enjoy~~</p>
<p><br></p>
<p><br></p> |
|
|
hand crochet, shawl, shoulder wrap, wrap, boho wrap, coastal fashion, ocean colors digital green, blue green, green multi, blue multi FREE Candle |
|
|
<p><strong>Ready to Ship</strong></p> |
|
|
|
97.00000000 |
381M,178,15084 |
2031 |
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> |
digital-sea-crochet-cuddle-wrap |
3/84/381 |
<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 |