Query time 0.00476
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "5.40"
},
"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.47",
"eval_cost": "0.10",
"prefix_cost": "0.57",
"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.63",
"eval_cost": "0.10",
"prefix_cost": "1.29",
"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.87",
"eval_cost": "0.10",
"prefix_cost": "2.26",
"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": "3.04",
"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.09",
"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.14",
"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.29",
"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.35",
"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.04",
"eval_cost": "0.02",
"prefix_cost": "5.40",
"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 |
| 132011 |
GI-132011-UMJ |
P |
A |
2384 |
17.50 |
2 |
0.188 |
0 |
0 |
0 |
0.00 |
0 |
1631126568 |
1680724919 |
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:9;s:9:"box_width";i:6;s:10:"box_height";i:1;} |
0.000 |
3.000 |
|
|
|
2147483647 |
en |
Colorful Crab Cards for Summer All Occasion Greeting Cards |
|
|
<p>These colorful note cards come in a set of 5 with accompanying white envelopes.</p>
<p>For the Beach Bum! A cute set of Sally Lightfoot crab stationery cards sporting an image from one of my original watercolors. I like to keep a set of these on hand for sending notes to family and friends. Great for Thank You cards or to use as beach party invitations too. Each card is blank inside so you can use them for many occasions, just add your own special message.</p>
<p>The cards have been professionally printed onto environmentally friendly (FSC certified), acid free card stock. They will arrive packaged in an archival, clear plastic that is resealable for protection.</p>
<p>The folded size for each note card is 5.5” x 4.25” (A2).</p>
<p>____________________________________________________</p>
<p>© 2023 Lisa Ann Kowalski. All rights reserved.<br>Copyright on the original painting is retained by the artist and may not be reproduced without permission.</p>
<p></p> |
|
|
crab cards, beach cards, summer cards, sally lightfoot crab, beach party invitations, thank you cards, summer thank you cards, summer invitations, sea life cards, crab bithday card, all occasion card |
|
|
<p>Ships from my shop within 1 - 3 business days via USPS.</p> |
|
|
|
16.00000000 |
6661M,92,9728 |
5889 |
Sycamore Wood Studio |
<p><strong>Welcome to Sycamore Wood Studio </strong>I want you to be happy with your order so if you have any questions about the items I sell please don't hesitate to contact me.</p>
<p><i><strong><br></strong></i></p>
<p><i><strong>Returns and </strong><em><strong>exchanges</strong></em><strong><br></strong></i></p>
<p>
</p>
<p><strong><em><i>I gladly accept returns and exchanges</i></em></strong></p>
<p>Contact me within: 7 days of delivery</p>
<p>Ship items back within: 14 days of delivery</p>
<p>(Please note - Buyer is responsible for the cost of return shipping)<br></p>
<p><em><strong>I don't accept cancellations</strong></em></p>
<p>But please contact me if you have any problems with your order.<strong><em><br></em></strong></p>
<p><strong><em>The following items can't be returned or exchanged<br></em></strong>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>Digital downloads<em><br></em></li><em><br></em></ul>
<p><strong><em>Return and Exchange Details<br></em></strong><i>I want you to be completely delighted with your order. <br></i></p>
<p><i>If for any reason you are not satisfied, just contact me within 7 days of receipt and I will refund your purchase price less shipping charges.</i></p>
<p>Buyers are responsible for return shipping costs. If the item is not returned in its original condition, the buyer is responsible for any loss in value. Refunds will be made after receiving the return.</p>
<p>Please note - Due to their nature, custom order sales and digital download sales are final and <br>nonrefundable.<i><br></i><i><br></i><i><strong><br></strong></i><i><strong>Shipping</strong></i><i>
</i><i><br></i></p>
<p>In stock items ship within 1-3 business days from receipt of payment.<br></p>
<p>Special Orders may take 2 to 4 weeks to complete</p>
<p><br></p>
<p>All items ship via USPS. The service used is based on size and weight restrictions for your order. Postal delivery should be within 3-10 business days.
</p>
<p>The USPS publishes the following delivery time estimates for the postal services I use: First Class Package 1-5 days, USPS Parcel Select Ground - 2-8 days, PLEASE BE AWARE - DUE TO THE CORONA VIRUS PANDEMIC USPS IS EXPERIENCING SOME DELAYS. While they are doing their best to deliver packages as quickly as possible they have posted the following Alert: "As a result of the ongoing COVID-19 emergency, certain packages may take longer than usual to arrive. " (see the USPS website for more details) Thank You in advance for your patience and understanding.</p>
<p>PLEASE BE AWARE - SHIPPING ESTIMATES ARE NOT GUARANTEES - PLAN ACCORDINGLY WHEN PLACING ORDERS FOR SPECIAL OCCASIONS, THE SOONER THE BETTER. </p>
<p>CDC guidelines are followed when packing orders. Please follow CDC guidelines when receiving packages - SycamoreWoodStudio is Not responsible for anyone being exposed to COVID-19.</p>
<p><i><br><i></i><br><i><i><br><br></i><i><br></i></i></i></p> |
crabcards |
5/24/6661 |
<p><strong>My Leap of Faith…</strong></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.">Welcome to my shop. Hello, my name is Lisa Ann Kowalski and I am the creative force behind Sycamore Wood Studio. I’ve dabbled in creative undertakings for a long time – as a hobby, as a way to relax after a grueling 9 to 5 job. My goimagine shop is a new opportunity for me to focus full time on being creative and sharing my creativity with you. <br></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.">I get inspired by everything that surrounds me. I take that inspiration and paint watercolors. I sell original paintings and I also repurpose some of my art into high quality greeting cards. This allows me to share my artwork with you in a useful and affordable way.<br></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.">I hope you enjoy my work. If you have any questions about any of the items I sell please don’t hesitate to ask. I would love to hear from you.
Thank you for visiting my studio.
-Lisa</span> </p> |
D |