Query time 0.00311
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "5.99"
},
"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.88",
"eval_cost": "0.10",
"prefix_cost": "2.09",
"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.87",
"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.27",
"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.67",
"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.18",
"eval_cost": "0.02",
"prefix_cost": "5.87",
"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.93",
"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.04",
"eval_cost": "0.02",
"prefix_cost": "5.99",
"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 |
| 38215 |
47 |
P |
A |
802 |
0.00 |
4 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1597264484 |
1645459062 |
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 |
Pappaws Girl Baby Pacifier - Baby Girl Announcement to Grandpa Pregnancy Reveal Gift - Pink Baby Girl Pacifier - Purple Soother - I love my Grandpa |
|
<p>You have never seen baby girl announcements to grandpa like this before! </p>
<p>Putting a spin on pink baby girl pacifiers, MomAndBabyBoutique is proud to present our Pappaw's Girl binky! Your baby girl may be little, but she's got a big personality that is all her own! Help her express it with our glitter purple soothers! With our wide variety of unique, funny, and adorable expressions, you are sure to find just the right expression soothie to suit your little one! </p>
<p>Each custom binkie is lead and phthalate free, and complies with the US Consumer Product Safety Commission Title 16 CFR Part 1511 requirements for pacifiers. We want your baby to be stylish and safe at all times! Each neon pink binky is made with non-toxic, hygienically formed, bite resistant materials specifically designed to be form fitting in babies’ mouth. This means not only are your binkies safe and stylish, they are also extremely comforting to babies that need suction for comfort while providing mom and dad with peace of mind.</p>
<p><br></p> |
<p>You have never seen baby girl announcements to grandpa like this before! </p>
<p><br>Putting a spin on pink baby girl pacifiers, MomAndBabyBoutique is proud to present our Pappaw's Girl binky! Your baby girl may be little, but she's got a big personality that is all her own! Help her express it with our glitter purple soothers! With our wide variety of unique, funny, and adorable expressions, you are sure to find just the right expression soothie to suit your little one! </p>
<p><br></p>
<p>Each custom binkie is lead and phthalate free, and complies with the US Consumer Product Safety Commission Title 16 CFR Part 1511 requirements for pacifiers. We want your baby to be stylish and safe at all times! Each neon pink binky is made with non-toxic, hygienically formed, bite resistant materials specifically designed to be form fitting in babies’ mouth. This means not only are your binkies safe and stylish, they are also extremely comforting to babies that need suction for comfort while providing mom and dad with peace of mind.</p>
<p><br></p>
<p>If you would like to continue shopping, you may return to my shop home by clicking this link:
<a href="https://goimagine.com/mom-and-baby-boutique/" data-ol-has-click-handler="">https://goimagine.com/mom-and-baby-boutique/</a>
</p>
<p><br></p> |
|
|
Baby_girl,Girl_announcement,Annoucement_to,Grandpa,Pregnancy_reveal,Reveal_gift,Pappaws_girl,Binky,Pink_baby,Baby_girl_pacifier,Purple,Soother,I_love_my_grandpa, 0-6 months, 6-18 months, pacifier, binky, binkie, dummy, soother, soothie, orthodontic pacifier, similar to NUK pacifier, CPSIA Compliant, CPSC Compliant, Meets CPSC Safety Requirements, Safety lab tested, NIP pacifier, NIP brand pacifier, baby shower gift
|
Pappaws Girl Baby Pacifier |
|
<p class="text-center"><span style="color: rgb(192, 80, 77);"><strong>Our baby pacifiers ship out in 3-5 business days as they are Made to Order just for you!</strong></span></p>
<p><span style="color: rgb(192, 80, 77);"></span></p>
<p class="text-center"><span style="color: rgb(192, 80, 77);"><strong>Need this pacifier sooner? Please contact me before ordering!</strong></span></p> |
|
|
|
12.99000000 |
76M,56,3131,3132 |
2187 |
Mom and Baby Boutique |
|
pappaws-girl-baby-pacifier |
4/76 |
<p>The anticipation of a baby is one of the most wonderful experiences of life and is a cause for celebration. Mom and Baby Boutique LLC was established in 2010 with the goal of offering high quality baby accessories to help you celebrate that little bundle of joy. Whether you are an expectant mother yourself, a grandmother to be, or a loving friend searching for the perfect baby shower gift, I am proud to offer you a variety of exceptional presents.<br><br>I was first inspired by my nephew when he was expecting his first child. He was excited, he was nervous, and he was more than a little overwhelmed. Baby showers, and gender reveal showers, are often a way to relax those nerves while reminding everyone just how amazing pregnancy and babyhood truly is. I started with a simple diaper cake for them. He loved it. His wife loved it. The guests were amazed and I was hooked. Over the years I expanded my offerings to include baby clothing, gift sets, bibs, pacifier clips, and, of course, my diaper cakes.<br><br>My signature product line is the personalized pacifier and it is my best-seller for good reason. I elevate traditional pacifiers with expertly engraved text. Not only do I offer names, but I also offer playful phrases, awareness identifications, and even include them in our gift sets. I know that all babies are unique, and these customized pacifiers are the perfect expressions of your little ones budding personality.<br><br>Thank you again for learning about Mom and Baby Boutique LLC. I’d like to invite you to explore my shop and follow us on our social media platforms.<br><br><a href="http://www.facebook.com/MomandBabyBoutique" target="_blank" rel="nofollow noopener">www.facebook.com/MomandBabyBoutique</a><br><a href="http://www.twitter.com/MomandBabyBtq" target="_blank" rel="nofollow noopener">www.twitter.com/MomandBabyBtq</a><br><a href="http://www.instagram.com/MomandBabyBoutique" target="_blank" rel="nofollow noopener">www.instagram.com/MomandBabyBoutique</a><br><a href="http://www.pinterest.com/MomandBabyBtq" target="_blank" rel="nofollow noopener">www.pinterest.com/MomandBabyBtq</a></p> |
D |