Query time 0.00261
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "3.73"
},
"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.62",
"eval_cost": "0.10",
"prefix_cost": "1.13",
"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.11",
"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.89",
"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": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.25",
"eval_cost": "0.10",
"prefix_cost": "3.24",
"data_read_per_join": "16"
},
"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.25",
"eval_cost": "0.01",
"prefix_cost": "3.59",
"data_read_per_join": "134"
},
"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.04",
"eval_cost": "0.01",
"prefix_cost": "3.64",
"data_read_per_join": "86"
},
"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.01",
"prefix_cost": "3.69",
"data_read_per_join": "88"
},
"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.01",
"prefix_cost": "3.73",
"data_read_per_join": "1"
},
"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 |
| 39857 |
7 |
P |
A |
1072 |
19.99 |
4 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1597586005 |
1620490480 |
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 |
SUPERHERO CAPE - Kids cape - Personalized Cape - Superhero Cape -Superhero Mask - Cape for Kids - Superhero Party Favor - Super Hero Cape |
|
SINGLE LAYER CAPES
Calling all Superheroes!
No more towels or sheets needed for pretend play!
Each cape is designed, cut, and sewn start to finish by hand. Made in the USA, one cape at a time.
The perfect party favors!
Find the bulk listing here: https://www.etsy.com/listing/531500962/superhero-capes-bulk-bulk-superhero?ref=shop_home_active_4
These single layer superhero capes can be personalized with your superhero's initial, add a name, shape, or create something unique to fit your theme.
Choose your colors. Choose your designs.
For example, you would like a star and a name.... Choose: 2 designs
or you would like a Circle/bolt and initial ...Choose: 3 designs
Just a spider? .... Choose 1 design
The cape is created using vibrant colors of high-quality poly satin with a serged edge.
They have a sewn on Velcro closure at the neck for durability and is easy for little fingers to get on and off.
The designs are made from satin and heat fused to the cape.
Capes are available in 3 sizes:
* measured from center neck to bottom edge of cape. *
Infant capes: 12 " fits ages 1 - 2 years
Toddler capes: 18" and fit 2 - 3 years best
Kid Capes: 25” long which fits ages 3 - 7 years best
The best way to measure your superhero is from the collar of a crew neck T, down their back to where you would like the cape to fall. If you need a custom length other than what is listed, please contact me.
While there are many designs to choose from if you do not see what you are looking for I can design something just for you! My customers are my best inspiration!
If you are ordering a special gift for your superhero, I am happy to wrap and include your note. Just leave that info in the notes at checkout for me.
For superheroes that have a special need date be sure to leave the date in the notes so I can pay extra special attention to make sure it arrives on time!
The capes are machine washable and should be hung to dry. They can be pressed with a dry iron on a medium heat setting. Pay careful attention around the applique.
These superhero capes will be shipped using U.S. first class mail. This normally takes 2 to 5 days to most U.S. locations. Tracking is included and will be sent by automated message when your order is ready to ship.
You may choose to upgrade your shipping at checkout.
With Rush turnaround your item will be created in 1 to 2 days and shipped priority mail. |
<p></p>
<p>Calling all Superheroes!<br>No more towels or sheets needed for pretend play!<br>Each cape is designed, cut, and sewn from start to finish by hand. Made in the USA, one cape at a time.<br><br>The perfect party favors!<br><br>These single-layer superhero capes can be personalized with your superhero's initial, add a name, shape, or create something unique to fit your theme.</p>
<p><br></p>
<p>Choose your colors. Choose your design.</p>
<p>For example, you would like a star and a name...<br>or you would like a Circle/bolt and initial ...<br>Just a spider? ....<br>The cape is created using vibrant colors of high-quality poly satin with a serged edge.<br>They have a sewn-on Velcro closure at the neck for durability and are easy for little fingers to get on and off.<br>The designs are made from satin and heat fused to the cape using a commercial-grade heat press.<br><br>Capes are available in 4 sizes:<br>* measured from center neck to bottom edge of the cape. *<br><br>Infant capes: 12 " fits ages 1 - 2 years<br>Toddler capes: 18" and fit 2 - 3 years best<br>Kid Capes: 25” long which fits ages 3 - 7 years best<br>Adult Capes: 36" long<br><br>The best way to measure your superhero is from the collar of a crew neck T, down their back to where you would like the cape to fall. If you need a custom length other than what is listed, please contact me.<br><br>While there are many designs to choose from if you do not see what you are looking for I can design something just for you! My customers are my best inspiration!<br><br>If you are ordering a special gift for your superhero, I am happy to wrap and include your note. Just leave that info in the notes at checkout for me.<br><br>For superheroes that have a special need date, be sure to leave the date in the notes so I can pay extra special attention to make sure it arrives on time!<br>The capes are machine washable and should be hung to dry. They can be pressed with a dry iron on a medium heat setting. Pay careful attention around the applique.<br><br>These superhero capes will be shipped using U.S. first-class mail. This normally takes 2 to 5 days to most U.S. locations (although not guaranteed). Tracking is included and will be sent by automated message when your order is ready to ship.</p>
<p></p> |
|
|
Personalized_Cape,SUPERHERO_CAPE,Superhero_Mask,Cape_and_Mask_Set,Party_Favor,Mask,superhero_party,cape_for_kids,toddler_cape,kids_gift,custom_cape,Kids_cape |
|
|
<p>Ready to ship in 3-5 business days.</p> |
|
|
|
19.99000000 |
126M |
1635 |
Little Shepsters LLC |
|
superhero-cape-kids-cape-personalized-cape-superhero-cape-superhero-mask-cape-for-kids-superhero-party-favor-super-hero-cape |
71/126 |
<p>What is a Little Shepster you ask?</p>
<p></p>
<p>My name is Jacki Shepstone and my finest creations (well mine and my husband's), are our 4 children. I called them my Little Shepsters and there you have it!<br> <br>It all began with creating costumes for my 2 girls. I started my ETSY shop LITTLE SHEPSTERS in 2009 once my daughters had their closets full. When their baby brother came along I began making capes! We since have completed our family with 4. My days are filled with a lot of craziness and lots of laughter! My oldest girls are now 19 and 17 so I get lots of help, and it has quickly become a family business.</p>
<p></p> |
D |