Query time 0.00182
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "5.33"
},
"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.36",
"eval_cost": "0.10",
"prefix_cost": "0.46",
"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.64",
"eval_cost": "0.10",
"prefix_cost": "1.20",
"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.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.98",
"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.03",
"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.08",
"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.22",
"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.28",
"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.33",
"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 |
| 135084 |
GI-135084-FAA |
P |
A |
1738 |
9.99 |
1 |
0.563 |
0 |
0 |
0 |
0.00 |
0 |
1632198223 |
1679102999 |
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:1;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} |
0.000 |
9.000 |
|
|
|
2147483647 |
en |
"If You Need Me Call Me On My Shell" Mouse Pad |
|
|
<p class="text-center">This stylish and practical mouse pad is the ultimate office tool! Crafted from durable polyester and neoprene fabric, it features brilliant sublimation printing with the fun ‘If You Need Me Call Me On My Shell’ design. Whether you’re at home, school, or work, it’s perfect for any computer or laptop. It also makes a great gift for any occasion! Get your hands on the ‘If You Need Me Call Me On My Shell’ Mouse Pad today.</p>
<p class="text-center">Made of premium soft polyester and it also has an anti-slip rubber back that firmly grips to your desktop and prevents slipping. </p>
<p class="text-center">It’s easy to clean when liquid splashes on the pad, it will form into water drops and slide down for easy clean up. </p>
<p class="text-center">The image is sublimated onto the mouse pad and will not peel. </p>
<p class="text-center">Measures 9.4" x 7.9" x 0.12"
</p>
<p class="text-center">*Please note: This is a handmade item and unique so the colors/pattern may vary slightly from the item pictured due to lighting when the photograph was taken.
</p> |
Mouse Pad, Office, Sarcastic, Home, Computer, Laptop, School, Shell |
If You Need Me Call Me On My Shell Sublimated Polyester Mouse Pad will brighten up any desk and works perfectly with your wired or wireless mouse. It makes a perfect gift for any occasion or for your own personal use. |
Mouse Pad, Office, Home, Computer, Laptop, School, Shell, Gift, Sublimation, Polyester, Neoprene |
If You Need Me Call Me On My Shell Mouse Pad |
|
<p class="text-center">Ships out within 1-3 business days once payment post.</p> |
|
|
|
9.99000000 |
250M,4,7795 |
2208 |
Stormie Gale Creates |
<p></p>
<p><b><span style="color: rgb(0, 0, 0);">WELCOME TO STORMIE GALE CREATES!</span></b></p>
<hr>
<p><b>I GLADLY ACCEPT RETURNS AND CANCELLATIONS</b></p>
<p>Contact me within: 3 days after delivery.</p>
<p>Ship items back within: 7 days after delivery.
</p>
<p>Request a cancellation within: 1 hour after purchase.
</p>
<hr>
<p><b>I'M SORRY I DON'T ACCEPT EXCHANGES</b></p>
<p>Please contact me if you have any problems with your order.</p>
<hr>
<p><b>THE FOLLOWING ITEMS CAN'T BE RETURNED</b></p>
<p>Because of the nature of these items, unless they arrive damaged or defective, I can't accept returns for:
</p>
<ul><li>Custom or personalized orders
</li><li>Perishable products (like food or flowers)
</li><li>Digital downloads
</li><li>Intimate items (for health/hygiene reasons)
</li><li>Items on sale
</li><li>Small imperfections in items which is due to each item being handcrafted</li></ul>
<hr>
<p><b>RETURN DETAILS</b> <br></p>
<p> All returns are at your expense and must be shipped within 7 days of receipt. Once I receive the item in original condition, I will send you a prompt refund to the account you used to purchase the item. I will cancel the transaction and no feedback will be left on either side.</p>
<hr>
<p><b>PAYMENT DETAILS</b></p>
<p>I'm pleased to accept Visa, MasterCard, Maestro, American Express, JBC, Discover, Diners Club, Union Pay, Google Pay, Apple Pay, Pay Pal. Sales tax is collected. Payment is due upon placing your order. If payment is not received within 24 hours, I will contact you via email as a reminder. However, if payment has not been received within 24 hours of email, the order will be canceled.</p>
<p>Orders are processed within 1 business day after payment is received.
</p>
<hr>
<p><b>SHIPPING DETAILS</b></p>
<p>I only offer Priority Mail shipping through the USPS which protects me and you. Priority Mail shipping includes tracking information and up to $50 insurance.<br></p>
<p>I can’t be held responsible for orders lost in the mail and will not issue refunds for lost packages. If your package gets lost, you will need to contact the USPS and file a claim with them. I ship all items with tracking info to protect me and you. I would suggest that you add additional insurance to packages for your own protection. Most orders will ship out within 1-3 business days once payment post. If you absolutely need something right away, please let me know and I will try to accommodate.</p>
<hr>
<p><b>PLEASE DOUBLE CHECK YOUR ADDRESS WHILE CHECKING OUT TO MAKE SURE IT'S UP TO DATE. </b></p> |
leaves-multicolor-mouse-pad-clone |
4/51/250 |
<p>My Story</p>
<p><span class="mt-xs-1" data-inplace-editable-text="story" data-endpoint="AboutPost" data-key="story" data-placeholder="How did you get started? What inspires you? We know each seller’s story is unique—tell yours here.">I spent my entire life watching my mom create beautiful things, from paintings, jewelry, glass beads, photographs, paper crafts, and the list goes on and on. She would always try to get me interested in creating things but I would always say "Mom I'm not crafty like you".</span></p>
<p><span class="mt-xs-1" data-inplace-editable-text="story" data-endpoint="AboutPost" data-key="story" data-placeholder="How did you get started? What inspires you? We know each seller’s story is unique—tell yours here.">Well that changed in 2015 when I sustained a thumb and hand injury to my dominant hand. I underwent seven surgeries in order to regain full use of my thumb. Unfortunately I was unable to regain full use of my thumb which sent me into a depression. I had to find an escape from the depression and I ended up finding small things that I could create with minimal use of my thumb. Creating things ended up becoming therapeutic for me. It allowed me to work on using my thumb in ways that I hadn't had to do previously. Fine motor skills were extremely hard for me but with repetition they started getting better but will never be 100% again. The injury forced me to find new ways of doing things and I'm honestly very thankful because if it hadn't of been for the injury I would of never begun creating and I can't imagine my life without that outlet now. </span></p>
<p>I've never been into a craft store that I didn't love and I've never seen a craft that I didn't want to try and recreate or make my own. I know quite ironic since my entire life was spent going to the dreaded craft stores with my mom. I can now say that I'm definitely my mother's daughter. </p>
<p>My mom is my biggest inspiration I'm always in pure amazement of everything she creates. She's taught me to never give up and always have faith in myself and my creations. My husband is my biggest supporter. If it hadn't of been for him always encouraging and supporting me I don't know where I would be right now. </p>
<p>I'm a perfectionist by fault and never think anything I create is good enough to show or sell to others. It's taken me a long time to get up the nerve to show others my creations.</p>
<p>I truly hope everything you purchase from my store brings you as much happiness as it brought me when I created it.</p>
<p>In crafting there are no mistakes. It's your own unique creation.</p>
<p>- Stormie Gale Creates</p>
<p><span class="mt-xs-1" data-inplace-editable-text="story" data-endpoint="AboutPost" data-key="story" data-placeholder="How did you get started? What inspires you? We know each seller’s story is unique—tell yours here."><br></span></p> |
D |