Query time 0.00709
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "6.04"
},
"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.32",
"eval_cost": "0.10",
"prefix_cost": "0.42",
"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.15",
"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.14",
"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.92",
"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.32",
"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.72",
"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.92",
"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.99",
"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": "6.05",
"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 |
| 289288 |
GI-289288-MLN |
P |
A |
8552 |
34.95 |
1 |
0.875 |
0 |
0 |
0 |
0.00 |
0 |
1678396471 |
1678397738 |
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:1;s:16:"max_items_in_box";i:1;s:10:"box_length";i:12;s:9:"box_width";i:10;s:10:"box_height";i:3;} |
0.000 |
14.000 |
|
|
|
2147483647 |
en |
Boho Rainbow Yarn Tassel Birthday Banner |
|
|
<p><strong>Boho Themed Yarn Tassel Birthday Banner</strong> - Great party decor, hang on a table, wall or on your little ones high chair for an adorable smash cake photo! Also a great banner to use for the Birthday Party and Photos!!! Adorable bedroom decor for your little one!<br><br>This listing is for <strong>1 handmade boho themed birthday banner</strong>, made with coral, white, tan and gray yarn, wood beads and also includes 1 white cotton pennant that is adorned with a precious boho style rainbow and "one" as shown in listing photos. Each banner is designed, created and assembled by me personally in my home studio.</p>
<p>BANNER CAN BE MADE FOR ANY AGE! <br><br>Banner measures approximately 22" x 8" - twine the banner hangs on is 7' long, giving you plenty to work with when hanging. Banner comes completely assembled and ready to display.(Please note: NO hanging hardware is included) Hangs easily with your choice of tape, command strips or velcro hangers.<br><br>If this banner is not exactly what you are looking for please contact me and lets get busy designing a banner that will be perfect for your special event!<br><br>Please allow 3-5 days for production.<br>Orders will be shipped via USPS.</p>
<p>Please note: my unicorn model is not for sale. ;-) <br><br>Banner is not a toy, please do not leave child unattended with banner.</p>
<p>Handcrafted in Alabama by Diann Hayes</p> |
|
Boho Yarn Tassel Birthday Banner - hang it on your little ones high chair for an adorable smash cake photo! A great banner for the First Birthday Party. |
Tassel Birthday Banner, high chair party banner, 1st birthday banner, boho rainbow party, yarn tassel garland, high chair banner, highchair banner, rainbow girl banner, smash cake, photo prop |
Boho Yarn Tassel Birthday Banner |
|
<p>This product is handmade to order and takes 3-5 days to create before shipping. Please take this additional time into consideration when purchasing.<br></p> |
|
|
|
34.95000000 |
6655M,6656,20059,20065 |
963 |
Dizzy Grape Celebrations |
<p>I am happy to answer any questions before or after your order! Please message me via the goimagine message center or email me at thedizzygrape@gmail.com</p>
<p>Your satisfaction is important to me!</p>
<p>Each of my items are handmade to order in my home studio in Glencoe, AL.</p>
<p><strong>Processing Times:</strong> </p>
<ul><li>Please see individual listing for processing times.</li><li>If you order multiple items with different processing times all items will ship according to the longest processing time.</li><li>If you need your item sooner, please contact me before you place your order and I will be happy to discuss the options for expedited processing. </li></ul>
<p><strong>Shipping:</strong></p>
<ul><li>Shipping is via USPS. </li><li>Delivery time is dependent upon current USPS conditions. </li><li>Please carefully provide the correct mailing address. Items returned due to incorrect address will not be refunded and customer is responsible for the shipping charge to resend. </li><li>If the package shows damage when delivered please photograph the damage before opening. Also photograph any damage to the product. Please email photos to thedizzygrape@gmail.com.</li><li>If an item is broken or damaged in shipping I will repair or replace it at no charge, please message me to make arrangements.</li></ul>
<p><strong>Returns/Refunds/Exchanges:<br></strong></p>
<ul><li>Not all items are eligible for returns, refunds or exchanges. Please read carefully.</li><li>I do not offer returns, refunds or exchanges on custom orders unless there has been an in-house error. Custom orders would be considered a product that you have requested a specific blend of colors, embellishments, names, phrases, logo, etc that is outside of what is shown on the listing purchased. </li><li>Returns are accepted on non custom orders under the following conditions: </li><li>Non custom orders are considered a product made with no modifications or personalization and are just as shown on the listing purchased.</li><li>Customer must email thedizzygrape@gmail.com within 3 days of delivery.</li><li>Customer is responsible for return shipping, item needs to be returned within 7 days. </li><li>A refund will be processed once the item is received back in the same condition it was sent.</li><li>If an in-house error is made I will work diligently to correct the error.</li></ul>
<p><strong>Cancellations: </strong></p>
<ul><li>You may cancel your order within 4 hours of purchase, for any reason, for a full refund.</li></ul>
<p><strong>Custom Orders:</strong></p>
<ul><li>I absolutely LOVE doing custom orders and would be happy to help you create that one of a kind unique item for your celebration! Please email me or message me and let me know what you have in mind. I will then contact you with some ideas and suggestions.</li><li>Please note — custom orders are to be paid in full before any work begins on your item(s). </li><li>No refunds are given on custom orders. Once you receive the item if there is a problem please contact me directly within 3 days of delivery. </li></ul>
<p><strong>Please Note: </strong>Actual colors may vary from colors shown based on your device settings. </p>
<p>Thank you so much for supporting me and my small business!</p>
<p>-Diann</p>
<p></p> |
boho-birthday-banner |
5/62/6655 |
<p>Hello and thank you for visiting, my name is Diann and I am the crafty hands behind Dizzy Grape Celebrations! I have been married for 15 years and have 2 sons, 2 stepdaughters, 1 stepson along with 2 beautiful grandchildren. I grew up learning how to do a wide variety of crafts from my mother and grandmother. I have always enjoyed designing and creating beautiful gifts, clothing, decor and such. I started my first online marketplace in Oct of 2013 and decided in Dec of 2022 to expand my online marketplace presence with a goimagine shop. Over the years I have continued exploring and learning about new crafting materials and techniques. I love what I do and especially enjoy interacting with customers to create that very special custom item(s) to make their special celebration just perfect! I am honored to be a part of goimagine and especially blessed to have the full love and support from my husband and family.</p> |
D |