Query time 0.00492
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "5.32"
},
"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.33",
"eval_cost": "0.10",
"prefix_cost": "0.43",
"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.17",
"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.92",
"eval_cost": "0.10",
"prefix_cost": "2.19",
"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.97",
"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": "4.02",
"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.07",
"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.21",
"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.27",
"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.32",
"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 |
| 154939 |
GI-154939-AGT |
P |
A |
108 |
49.95 |
1 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1637790897 |
1675287801 |
0 |
N |
N |
N |
B |
Y |
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 |
BFFS Organic Baby Blanket |
|
<p>Baby blanket 32" x 36" features woodland animal faces including foxes and mice. Back is a soft natural flannel. All fabrics are 100% GOTS certified organic cotton. This pink woodland baby blanket is perfect for a little girl. <br></p> |
<p>This fabric is just so adorable!!!! The main print features colorful kittens holding hands and flowers. It is bordered by a solid pink stripe and a pink floral print. Check out the close-up shot with the little hearts and "BFFS". The blanket back is a soft pink flannel. <br></p>
<p> All of the fabrics are 100% organic GOTS certified cotton.</p>
<p> We have one ready to ship to you! <br></p>
<p>The blanket is 32" x 36"; the perfect size for receiving, swaddling, strolling or cuddling! <strong><br></strong></p>
<p>Find more unique, organic, and handmade items in our <a href="https://goimagine.com/delanodesigns/" target="_blank">shop.</a><a href="https://goimagine.com/delano-designs/" target="_blank"></a>
</p>
<p> Machine wash in cold water, gentle cycle and line or dry low. Warm or steam iron.
</p>
<p><em>We proudly meet CPSC guidelines for children's clothing and bedding items.
</em></p>
<p></p> |
|
|
organic baby blanket, organic, receiving blanket, stroller blanket,girl, baby girl, pink, new baby gift, gift for baby girl, pink blanket, flannel baby blanket, Delano Designs, kitties, cat blanket, kittens |
|
|
<p><em><span style="color: rgb(192, 80, 77);">Blanket will ship in 1-2 days.</span></em><span style="color: rgb(192, 80, 77);"></span></p> |
|
<p><strong>All of our items are hand crafted in our bright and airy sewing room. Our process is environmentally friendly from the materials to our packaging.
</strong></p>
<ul><li>Our fabric is generally sourced from small women owned businesses.
</li><li>Our patterns are either made by us or are from small women owned businesses.</li><li>Our items are made primarily from GOTS certified organic cotton.</li><li>Our tags are made from organic cotton.</li><li>Our threads are organic cotton or cotton.</li><li>We use biodegradable cellophane bags for packaging. </li><li>Our ironing board is covered with organic cotton and wool batting.</li></ul>
<p><strong>Our hand crafted process includes a number of steps.</strong></p>
<ul><li>Fabric is prewashed in a non-toxic, fragrance free detergent or vinegar and baking soda. This preshrinks the fabric.</li><li>Fabric is ironed.</li><li>Fabric is cut.</li><li>Fabric is sewn using a standard sewing machine and/or serger and/or cover stitch machine.</li><li>Item is ironed.</li><li>Item is packaged in a clear cellophane bag, and then placed in a mailer.</li><li>Item is sent off to you!</li></ul>
<p></p>
|
|
49.95000000 |
221M,125,1118 |
1650 |
Delano Designs |
<h4><span style="color: rgb(79, 97, 40);">Shipping</span></h4>
<ul><li>Shipping is free. </li><li>Please note shipping times stated in the listing.</li><li>All in stock items ship within 1-3 business days. </li><li>Items that are not currently in stock generally ship in 7-14 business days unless otherwise stated. </li><li>Shipping estimates for custom items will be given at the time of order. </li><li> The majority of items ship via USPS, either First Class or Priority mail. Larger orders may ship with other carriers.</li><li>We will do our best to meet the shipping estimates, but cannot guarantee them. Actual delivery time will depend on the shipping method. </li><li>We are not responsible for lost or damaged items. Shipping insurance is available upon request.</li><li>For shipping concerns or questions please contact us.</li></ul>
<p></p>
<h4><span style="color: rgb(79, 97, 40);">Refunds and Exchanges</span></h4>
<p>Your satisfaction is important to us. Please let us know as soon as possible if there is a problem with your order or products, and we will work with you to resolve the issue. Exchanges, returns, etc. will be determined on an individual basis. Items must not be washed or used prior to return. Custom items are not available to return. <br></p>
<h4><span style="color: rgb(79, 97, 40);">Cancellations</span></h4>
<p>We do not allow cancellations. Please contact us if you have any problems with your order.</p>
<h4><span style="color: rgb(79, 97, 40);">Additional Policies and Information</span></h4>
<p>All of our products have been made in a smoke-free environment.</p>
<p>All of our fabrics have been prewashed to prevent shrinkage, in a hypoallergenic, fragrance-free detergent.</p>
<p>We do our best to provide our customers with the most accurate photographs and descriptions of fabrics and products, however, please allow for some variations due to the color displays of different monitors.</p>
<p>The exact placement of the fabric may differ from the pictured item.<br></p>
<p>If you have specific concerns about a fabric, please contact us to be sure we can provide you with what you need. <br></p>
<p><br></p>
<p><br></p>
<p></p> |
bffs-organic-baby-blanket |
4/76/221 |
<p><span class="display-block">Delano Designs is an environmentally friendly line of organic cotton home decor, bedding, and clothing items. Our items are unique, organic, and handmade. We are a</span> mother/daughter team based in Oregon, who are bringing their design dreams to life by helping you create a healthy and beautiful life you'll love.<br></p>
<p><span class="display-block"><em>And we proudly meet CPSC safety requirements for children's bedding and clothing.</em><br></span></p>
<p></p>
<p><br></p>
<p><span class="display-block"><br></span><br></p> |
D |