Query time 0.00551
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "6.02"
},
"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.29",
"eval_cost": "0.10",
"prefix_cost": "0.39",
"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.14",
"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.90",
"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.17",
"eval_cost": "0.02",
"prefix_cost": "5.91",
"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.05",
"eval_cost": "0.02",
"prefix_cost": "5.97",
"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.03",
"eval_cost": "0.02",
"prefix_cost": "6.03",
"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 |
| 60936 |
CPL-0005 |
P |
A |
1680 |
36.00 |
1 |
2.000 |
0 |
0 |
0 |
0.00 |
0 |
1611926488 |
1672679096 |
0 |
N |
N |
N |
B |
N |
R |
N |
N |
N |
Y |
10 |
0 |
S |
|
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 |
Split Letter Vine Monogram Engraved Cake Pan |
|
<p>A Cake Pan with an Engrave Lid makes a great gift or addition to any baker's baking stash. The pan is made from lightweight aluminum with an easy snap lid. It measures 9 x 13 inches and 2 1/2 inches deep. </p> |
<p class="text-center"><span style="color: rgb(31, 73, 125);"><strong>Split Letter Vine Monogram Engraved Cake Pan</strong></span></p>
<p><span style="color: rgb(31, 73, 125);"></span></p>
<p><span style="color: rgb(31, 73, 125);"></span></p>
<p></p>
<p>A Cake Pan with an Engrave Lid makes a great gift or addition to any baker's baking stash. </p>
<p>An engraved Cake Pan is a thoughtful gift to give for so many occasions! Christmas Gift, housewarming gift, bridal shower, birthday, or any gift-giving occasion. You can even sweeten the gift of an engraved cake pan by adding in the ingredients and instructions to your favorite yummy recipe. </p>
<p> <br>Ever take a delicious pan of brownies to a get-together and have your favorite pan go home with someone else? With a unique pan like this, everyone is sure to know who the yummy dessert belongs to. </p>
<p><br></p>
<p><strong>CAKE PAN DETAILS:</strong><br>- 9 in x 13 in <br>- 2 ½ in deep<br>- Lightweight aluminum<br>- Easy snap and secure lid<br>- Pans do not have a nonstick coating</p>
<p><strong>Comes in 5 Different Colors:</strong><br>- Teal<br>- Blue<br>- Red<br>- Black<br>- Copper</p>
<p><br></p>
<p><strong>HOW PERSONALIZATION WORKS:</strong><br>*Place your personalized Name(s)/Information in the "Add Your Personalization" section. Please place the name and Information exactly how you would like to have it printed. <br>*You will be sent a proof of the design via EMAIL. (Check policy page for current turnaround time)<br>*Once the design is approved, your sign will then be produced and shipped</p>
<p><br></p>
<p>Thanks for visiting my shop!! Please contact me if you have any questions. Check back for new items!!<br></p>
<p><br></p>
<p>Sign up for my VIP list and receive a 20% OFF COUPON and exclusive specials!<br>bit.ly/JSD_VIPSubscribe</p>
<p><br></p> |
|
A Cake Pan with an Engrave Lid makes a great gift or addition to any baker's baking stash. The pan is made from lightweight aluminum with an easy snap lid. It measures 9 x 13 inches and 2 1/2 inches deep. |
housewarming gift, wedding gift, bridal shower gift, engraved cake pan, custom cake pan, personalized pan, custom baking pan, 9 x13 cake pan, cake pan gift, engraved baking pan, metal cake |
Split Letter Vine Monogram Engraved Cake Pan |
|
|
|
|
|
36.00000000 |
208M,46,716,1704 |
2365 |
Juls Sweet Designs |
<p><span style="color: rgb(34, 34, 34); font-size: 24px; font-weight: 700;">Returns & exchanges</span></p>
<h6>I gladly accept cancellations</h6>
<p>Request a cancellation within: 2 hours of purchase</p>
<h6>I don't accept returns or exchanges</h6>
<p>But please contact me if you have any problems with your order.</p>
<h4></h4>
<h5>Frequently asked questions</h5>
<h6>Return and Exchange Details - Shop policies</h6>
<p>All items are sold as-is, no refunds or returns. If there is any problem with your order, I will be happy to work with each individual buyer.<br><br>Custom Orders: Once purchased all sales are FINAL. Custom order items may not be canceled.</p>
<h6>Where's my Personalization Proof? - Shop policies</h6>
<p>A proof will be sent to you via email for the personalized products you've purchased. Proofs will be sent within 48 BUSINESS hours after payment is cleared.<br><br>Only once you approve the design(s) will the order be printed. Because the products are approved, by you, and are personalized for you, no refunds will be granted AFTER the first proof is sent.</p>
<h6>What happens to unapproved proofs? - Shop policies</h6>
<p>Unapproved Proofs:<br><br>After I have sent the 1st proof and if you do not reply back, I will send several reminder messages to check in on you.<br><br>After 1 month, and if you have not responded back, I will automatically COMPLETE your order. Your order will be marked as shipped. You will receive a shipping notice that will have a note saying you need to approve your design if you would like to have your item finished and shipped. I will not send any more reminders after this.<br><br>Once you approve your design, I will ship your item posted in my turn around time.</p>
<h6>What are your Business Hours?</h6>
<p>BUSINESS HOURS:<br>Monday – Friday (working hours vary due to life with 3 kids, and homeschooling)<br><br>*I will be closed on holidays<br><br>If you don't reply to the message or email right away, please don't think I'm ignoring you! I'm problem away from my computer at the moment taking care of my family.<br><br>Don't worry, I will get back to you as soon as I can!</p>
<h6>Do you offer a discount?</h6>
<p>Yes, I do!<br><br>Please take a look at my welcome message in my shop! I post my most up to date coupon codes there!<br><br>Here's a taste of what you can find in the welcome message!<br><br>Sign up for mailing list and receive a 20% Off Coupon and exclusive specials!<br><a href="http://eepurl.com/grKzn9">http://eepurl.com/grKzn9</a><br><br><br><br>Happy Shopping!!</p>
<h6>What is the turnaround time?</h6>
<p>CURRENT PROOF TURNAROUND TIME: (starts once payment clears)<br>Proofs: up to 48 Business Hours<br>Extra proofs: less than 24 Business Hours<br><br><br>LASER CUT/ENGRAVED Items:<br>All items will be shipped within 3-5 BUSINESS days of order and payment. (If the item is a PERSONALIZED ITEM – Production will start AFTER Proof has been approved.)</p>
<h6>Can I use a coupon on a Custom-Designed Item?</h6>
<p>Unfortunately, due to the extra time, attention to detail, and dedicated conversation on the design for a custom-designed item, custom-designed items are not eligible for any discounts or coupons.</p> |
split-letter-vine-monogram-engraved-cake-pan |
4/46/208 |
<p></p>
<p><b>I love my job of being a Wife and a Mommy!</b></p>
<p>I have been blessed with a wonderful husband and two handsome boys and a cute little girl. I am learning that the longer I’m married, the more I fall in love with my husband. He truly is a blessing in my life.</p>
<p>I enjoy cooking, crocheting, sewing, knitting, reading and even some digital designing.</p>
<p><i>I keep busy being a wife, mommy, homeschooling, and operating JulsSweetDesigns & JulsSweetCuts, but I’m thankful for every minute.</i></p>
<p><i>God has blessed me with a great family and the passion and enjoyment to make/sew/design items not only for my family but also for others.</i></p> |
D |