Local Groceries

Choose your local groceries for Sunday Oct 27 or 2019-10-28.


Best Sellers view more arrow

strawberries

3

$4.00

strawberries

Strawberry season is finally here & we're pleased to send you some of the sweetest strawberries around! Locally or regionally grown and freshly picked just for you! 

1 pint

Add to Cart

local Peaches

3

$7.00

local Peaches

These juicy peaches are from Watsonia Farm, and they are wonderful baked into pies & cobblers or just fresh!

~2 lbs

Add to Cart

Farm Box

3

$20.00

Farm Box

Get a selection of farm fresh fruits & veggies this week! Each box includes 6 different items. An example box for this time of year may include: peaches or strawberries, turnips, scallions, button mushrooms, greens or lettuce, radish (exact items subject to change based on farmer availability)

Add to Cart

Shrimp Egg Rolls

3

$4.50

Shrimp Egg Rolls

These egg rolls are packed with Georgia shrimp, purple cabbage & carrots. Served with JenChan Supper Club's homemade duck sauce, these make a great appetizer.

 

Contains wheat, shellfish, eggs & soy

2 per order, frozen fresh for delivery

Add to Cart

Cookout view more arrow

Jersey Girl cheese

3

$11.00

Jersey Girl cheese

We love this classic soft-ripened cow milk cheese made by The Woodsman and Wife! It has a lovely bloomy rind & a mild buttery center. We might eat a wedge for dessert every night, but this cheese is also perfect for entertaining!

 

6 oz wheel

Add to Cart

button mushrooms

3

$2.50

button mushrooms

We absolutely LOVE these button mushrooms grown by our friends at Orchard Valley! Delicious, healthy & versatile, these shrooms will go well with almost any recipe you can dream up!

 

1/2 lb

Add to Cart

$7.00

Caly Road Plain Goat Cheese

Caly Road Creamery's Chevre is the perfect appetizer or a beautiful cheese to incorporate into delicious recipes like salads, sandwiches or pastas. This creamy and mild goat cheese is sure to please.

Caly Road Creamery is based in Sandy Springs and partners with a goat dairy in North Carolina for a pasteurized, fresh curd that is hormone and pesticide free for their goat cheeses.

8 oz

Add to Cart

$11.00

Spotted Trotter Hot Dogs

Pick up a pack of The Spotted Trotter's all beef hot dogs & find out why they're our favorite dogs in town! Perfect for cookouts, put 'em between TGM's hot dog buns & top with Doux South's honey mustard.

 

4 per pack

pork casing

Weight: 1.00lbs.

Weight: 1.00lbs.

Add to Cart

Prepared view more arrow

Papa Chan's Wings

3

$15.00

Papa Chan's Wings

JenChan's Supper Club brings us this wholesome dish of organic chicken wings stewed with carrots & potatoes. We recommend serving over rice to soak up all that savory sauce!

 

1 quart (12 wings), frozen fresh for delivery.

Add to Cart

$12.00

Souper Jenny's turkey chili

One of our favorite soups! This turkey chili is made with hearty veggies from Atlanta’s favorite soup guru, Souper Jenny. Frozen fresh for delivery, this soup is perfect for an easy & healthy lunch!


1 qt

Add to Cart

Black Bean Spare Ribs

3

$22.00

Black Bean Spare Ribs

Pastured pork spare Ribs from Hunter Cattle Co. are steamed in a garlicky Chinese black bean sauce. This dish comes from our friends at JenChan's Supper Club and is wonderful served over rice.

 

Contains pork

1 quart, approx. 2 lb. Frozen fresh for delivery.

Add to Cart

$8.00

everything bagel hand pies (gf)

Like an everything bagel, but better--it's a handheld breakfast encased in a flaky crust! These gluten-free & paleo-friendly pies from Happy Camper are stuffed with local eggs, shiitake mushrooms, peppers & savory spices, then sprinkled with everything bagel seasoning.

 

2-pack, frozen fresh for delivery

Add to Cart

$8.00

Little Tart's cookie dough

When you get an itch for Little Tart's Chocolate Chip Cookie, look no further than your freezer! The Little Tart Bakeshop made this special frozen cookie dough just for Garnish & Gather so you can always satisfy your sweet tooth! Bake at 350 for 10-14 minutes.

 

4 cookies

Add to Cart

$11.00

blueberry streusel muffins

These muffins from Ratio Bakeshop are chock full of blueberries & topped with a sweet streusel.

 

4 pack

Add to Cart

Mini Pecan Pie (GF)

3

$5.00

Mini Pecan Pie (GF)

Our neighbors at Heavenly Cakes by Pharez have created these adorable & delicious mini pies just in time for the holidays! Enjoy this classic pecan filling in a tender crust made from Heavenly Cake's own blend of gluten free flours.

 

Contains dairy & eggs

1 per order

Add to Cart

banana walnut muffins

3

$10.00

banana walnut muffins

For an easy breakfast, grab one of these deliciously nutty banana muffins topped with crisp banana chips from Ratio Bakeshop. 

 

4 pack

Add to Cart

strawberries

3

$4.00

strawberries

Strawberry season is finally here & we're pleased to send you some of the sweetest strawberries around! Locally or regionally grown and freshly picked just for you! 

1 pint

Add to Cart

Organic Avocados

3

$5.00

Organic Avocados

Don't forget to pick up your organic avocados for the week! Rich, creamy & heart healthy, avocados are perfect on toast & in guacamole!

 

2 per order

Add to Cart

local Peaches

3

$7.00

local Peaches

These juicy peaches are from Watsonia Farm, and they are wonderful baked into pies & cobblers or just fresh!

~2 lbs

Add to Cart

Farm Box

3

$20.00

Farm Box

Get a selection of farm fresh fruits & veggies this week! Each box includes 6 different items. An example box for this time of year may include: peaches or strawberries, turnips, scallions, button mushrooms, greens or lettuce, radish (exact items subject to change based on farmer availability)

Add to Cart

Pita Bread

3

$5.75

Pita Bread

This pita bread is made by Classic Pita & it's perfect for a sandwich or enjoyed with one of our spreads or dips (we love to fill them with meatballs made from ground lamb!).

5 pitas

Enjoy within 1-2 days unless refrigerated or frozen.

Add to Cart

$7.00

TGM 8-pack Hawaiian rolls

We can't get enough of these soft, perfect Hawaiian rolls from our friend's at The General Muir Bread! Perfect for mini slider sandwiches or served alongside a mouthwatering meal.

 

8 pack

Add to Cart

$3.00

4-pack sesame seed buns

Don't forget to add these sesame seed buns made by The General Muir Bread to your order! Try topping them with juicy burgers made with Carlton Farms' grass-fed beef for an easy supper!

 

4 pack

Add to Cart

TGM multigrain loaf

3

$7.50

TGM multigrain loaf

This wholesome multigrain loaf is begging to be toasted & topped with creamy Banner Butter or avocado! It's also perfect for healthy, whole grain sandwiches!

Add to Cart

Local GA Farms Eggs

3

$7.00

Local GA Farms Eggs

From local farms whose chickens are pasture raised where they can eat grass and bugs.

1 dozen

 

Add to Cart

$12.00

Pine street market meatloaf

This artisanal grass-fed beef meatloaf from Pine Street Market is perfect for an easy & comforting dinner anytime. Bacon & sage take this ready-to-cook meatloaf to the next level! Mashed potatoes not included, but highly recommended.

 

Bake at 350 for 45-60 minutes until cooked through

1 lb

Contains: onion, pork

Add to Cart

chicken bone broth

3

$17.00

chicken bone broth

You will love this healthy & delicious chicken bone broth made locally by Bone & Co! They simmer pasture-raised chicken bones for 24 hours, and add organic onions, carrots, celery, thyme, parsley, and kombu seaweed to provide a robust well rounded flavor. It contains no added salt, additives, flavorings, or preservatives, so that you can feel great about what you're drinking! 

 

Many broth enthusiasts prefer to sip their bone broth, heated to preference. This broth is also great for cooking soups, stews, casseroles - you name it! Use it in place of “stock in a box” wherever called for in recipes.

24 oz pouch, use within 7 days if thawed

Add to Cart

$8.50

springer mountain chicken breasts

Love the chicken in our recipes? Now you can get the same tender, delicious chicken breasts in our local market! Pick up a pack this week and use them to make one of your favorite G&G recipes or try something new!

 

3 pack, .75 lb

Add to Cart

Gluten Free view more arrow

$12.00

Souper Jenny's turkey chili

One of our favorite soups! This turkey chili is made with hearty veggies from Atlanta’s favorite soup guru, Souper Jenny. Frozen fresh for delivery, this soup is perfect for an easy & healthy lunch!


1 qt

Add to Cart

$8.00

everything bagel hand pies (gf)

Like an everything bagel, but better--it's a handheld breakfast encased in a flaky crust! These gluten-free & paleo-friendly pies from Happy Camper are stuffed with local eggs, shiitake mushrooms, peppers & savory spices, then sprinkled with everything bagel seasoning.

 

2-pack, frozen fresh for delivery

Add to Cart

$8.00

southwestern hand pies (gf)

These Southwestern-spiced hand pies from Happy Camper are stuffed with black beans, sweet corn, peppers & cilantro. They make the perfect gluten-free & vegan handheld lunch!

 

2 pack, frozen fresh for delivery

Add to Cart

$5.50

Paleo 'Reeze' Pie (gf)

Our friends at 2B Whole Gluten Free Bakery have created these decadent mini pies layered with almond butter & chocolate ganache. They're also vegan & paleo-friendly!

 

1 per order, serves 2

Add to Cart

Jersey Girl cheese

3

$11.00

Jersey Girl cheese

We love this classic soft-ripened cow milk cheese made by The Woodsman and Wife! It has a lovely bloomy rind & a mild buttery center. We might eat a wedge for dessert every night, but this cheese is also perfect for entertaining!

 

6 oz wheel

Add to Cart

out of the ashes cheese

3

$11.00

out of the ashes cheese

This soft-ripened cow's milk cheese dusted with pine salt & ash is handcrafted by our friends at The Woodsman and Wife. Though similar in texture to the Jersey Girl cheese, this one's a little stronger & will add a little funky pizzazz to any cheese board or soiree.

 

6 oz wheel

Add to Cart

$7.00

Red Pepper Mash Banner Butter

This seasonal flavor is made with fresh roasted red peppers, and is perfect for the grill!

Banner Butter, based in Atlanta, strives to create butters that taste great by doing it the right way by starting with high-quality cream from humanely-treated, hormone-free cows that graze in green pastures and sourcing the freshest ingredients, from as close to home as possible.

5 oz

Add to Cart

$20.00

Seka Hills Arbequina Extra Virgin Olive Oil

Strippaggio is a local purveyor of extra virgin olive oils, balsamic vinegars and other specialty food items.  They are unique in that they only source their olive oils from U.S. producers. Their Arbequina EVOO hails from the Yocha Dehe Wintun Nation in Northern California’s Capay Valley, using estate grown Arbequina olives from the Tribe’s ancestral homelands, this extra virgin olive oil is fruity with a hint of pepper and the aroma of fresh cut grass.

375 mil

Add to Cart

$6.00

8-pack lemon-honeysuckle sparkling water

The water in this refreshing drink comes from a deep, quartzite spring that's nestled along the Pine Mountain Ridge. 5,000 acres of old growth forest give sanctuary to the spring watershed. Try Montane's Lemon-Honeysuckle sparkling water this week!

 

8-pack

Add to Cart

$6.00

8-pack original sparkling water

The water in this refreshing drink comes from a deep, quartzite spring that's nestled along the Pine Mountain Ridge.  5,000 acres of old growth forest give sanctuary to the spring watershed. Try the Original Montane sparkling water this week!

 

8-pack

Add to Cart

$6.00

8-pack cucumber-lime sparkling water

The water in this refreshing drink comes from a deep, quartzite spring that's nestled along the Pine Mountain Ridge.  5,000 acres of old growth forest give sanctuary to the spring watershed. Try Montane's Cucumber-Lime sparkling water this week!

 

8-pack

Add to Cart

$6.00

8-pack grapefruit-peach sparkling water

The water in this refreshing drink comes from a deep, quartzite spring that's nestled along the Pine Mountain Ridge. 5,000 acres of old growth forest give sanctuary to the spring watershed. Try Montane's brand new Grapefruit Peach sparkling water this week!

8-pack

Add to Cart

items have been added to your cart

close icon
View Cart Check out
Session
        
General Bag
User Bag
Cart Bag
Cookie
    POST data
        Array
(
)
    
Profiler

SQL Statement:
SELECT `data` FROM `session_data` WHERE `session_id` = ? AND COALESCE(`modified_at`, `created_at`) + 1440 >= ?
SQL Variables:
Array ( [0] => s7ja1uueqftms4m6dla72ulu6f [1] => 1571864268 )
Total Elapsed Time:
1.18 ms
SQL Statement:
SELECT IF(COUNT(*) > 0, 1, 0) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_NAME`= 'taxons' AND `TABLE_SCHEMA` = 'garnishDev'
SQL Variables:
Total Elapsed Time:
1.19 ms
SQL Statement:
DESCRIBE `garnishDev`.`taxons`
SQL Variables:
Total Elapsed Time:
1.36 ms
SQL Statement:
SELECT `taxons`.`id` AS `id`, `taxons`.`name` AS `name`, `taxons`.`permalink` AS `permalink`, `taxons`.`lft` AS `lft`, `taxons`.`rgt` AS `rgt` FROM `garnishDev`.`taxons` WHERE `taxons`.`name` = :name LIMIT :APL0
SQL Variables:
Array ( [name] => extras [APL0] => 1 )
Total Elapsed Time:
0.98 ms
SQL Statement:
SELECT `taxons`.`id` AS `id`, `taxons`.`name` AS `name`, `taxons`.`permalink` AS `permalink`, `taxons`.`lft` AS `lft`, `taxons`.`rgt` AS `rgt` FROM `garnishDev`.`taxons` WHERE `taxons`.`parent_id` = :parent_id AND `taxons`.`active` = TRUE AND `taxons`.`id` NOT IN (101, 77, 96, 101, 72, 55, 45, 87) ORDER BY `taxons`.`sort`
SQL Variables:
Array ( [parent_id] => 5 )
Total Elapsed Time:
1.21 ms
SQL Statement:
SELECT `taxons`.`id`, `taxons`.`store_id`, `taxons`.`name`, `taxons`.`permalink`, `taxons`.`active`, `taxons`.`description`, `taxons`.`sort`, `taxons`.`parent_id`, `taxons`.`image_url`, `taxons`.`level`, `taxons`.`lft`, `taxons`.`rgt` FROM `garnishDev`.`taxons` WHERE `taxons`.`lft` > :lft AND `taxons`.`rgt` < :rgt AND `taxons`.`active` = TRUE AND `taxons`.`id` NOT IN (101, 77, 96, 101, 72, 55, 45, 87) ORDER BY `taxons`.`sort`
SQL Variables:
Array ( [lft] => 50 [rgt] => 53 )
Total Elapsed Time:
1.12 ms
SQL Statement:
SELECT `taxons`.`id`, `taxons`.`store_id`, `taxons`.`name`, `taxons`.`permalink`, `taxons`.`active`, `taxons`.`description`, `taxons`.`sort`, `taxons`.`parent_id`, `taxons`.`image_url`, `taxons`.`level`, `taxons`.`lft`, `taxons`.`rgt` FROM `garnishDev`.`taxons` WHERE `taxons`.`lft` > :lft AND `taxons`.`rgt` < :rgt AND `taxons`.`active` = TRUE AND `taxons`.`id` NOT IN (101, 77, 96, 101, 72, 55, 45, 87) ORDER BY `taxons`.`sort`
SQL Variables:
Array ( [lft] => 142 [rgt] => 145 )
Total Elapsed Time:
1.12 ms
SQL Statement:
SELECT `taxons`.`id`, `taxons`.`store_id`, `taxons`.`name`, `taxons`.`permalink`, `taxons`.`active`, `taxons`.`description`, `taxons`.`sort`, `taxons`.`parent_id`, `taxons`.`image_url`, `taxons`.`level`, `taxons`.`lft`, `taxons`.`rgt` FROM `garnishDev`.`taxons` WHERE `taxons`.`lft` > :lft AND `taxons`.`rgt` < :rgt AND `taxons`.`active` = TRUE AND `taxons`.`id` NOT IN (101, 77, 96, 101, 72, 55, 45, 87) ORDER BY `taxons`.`sort`
SQL Variables:
Array ( [lft] => 80 [rgt] => 101 )
Total Elapsed Time:
1.27 ms
SQL Statement:
SELECT `taxons`.`id`, `taxons`.`store_id`, `taxons`.`name`, `taxons`.`permalink`, `taxons`.`active`, `taxons`.`description`, `taxons`.`sort`, `taxons`.`parent_id`, `taxons`.`image_url`, `taxons`.`level`, `taxons`.`lft`, `taxons`.`rgt` FROM `garnishDev`.`taxons` WHERE `taxons`.`lft` > :lft AND `taxons`.`rgt` < :rgt AND `taxons`.`active` = TRUE AND `taxons`.`id` NOT IN (101, 77, 96, 101, 72, 55, 45, 87) ORDER BY `taxons`.`sort`
SQL Variables:
Array ( [lft] => 10 [rgt] => 17 )
Total Elapsed Time:
1.10 ms
SQL Statement:
SELECT `taxons`.`id`, `taxons`.`store_id`, `taxons`.`name`, `taxons`.`permalink`, `taxons`.`active`, `taxons`.`description`, `taxons`.`sort`, `taxons`.`parent_id`, `taxons`.`image_url`, `taxons`.`level`, `taxons`.`lft`, `taxons`.`rgt` FROM `garnishDev`.`taxons` WHERE `taxons`.`lft` > :lft AND `taxons`.`rgt` < :rgt AND `taxons`.`active` = TRUE AND `taxons`.`id` NOT IN (101, 77, 96, 101, 72, 55, 45, 87) ORDER BY `taxons`.`sort`
SQL Variables:
Array ( [lft] => 74 [rgt] => 79 )
Total Elapsed Time:
1.04 ms
SQL Statement:
SELECT `taxons`.`id`, `taxons`.`store_id`, `taxons`.`name`, `taxons`.`permalink`, `taxons`.`active`, `taxons`.`description`, `taxons`.`sort`, `taxons`.`parent_id`, `taxons`.`image_url`, `taxons`.`level`, `taxons`.`lft`, `taxons`.`rgt` FROM `garnishDev`.`taxons` WHERE `taxons`.`lft` > :lft AND `taxons`.`rgt` < :rgt AND `taxons`.`active` = TRUE AND `taxons`.`id` NOT IN (101, 77, 96, 101, 72, 55, 45, 87) ORDER BY `taxons`.`sort`
SQL Variables:
Array ( [lft] => 18 [rgt] => 25 )
Total Elapsed Time:
1.08 ms
SQL Statement:
SELECT `taxons`.`id`, `taxons`.`store_id`, `taxons`.`name`, `taxons`.`permalink`, `taxons`.`active`, `taxons`.`description`, `taxons`.`sort`, `taxons`.`parent_id`, `taxons`.`image_url`, `taxons`.`level`, `taxons`.`lft`, `taxons`.`rgt` FROM `garnishDev`.`taxons` WHERE `taxons`.`lft` > :lft AND `taxons`.`rgt` < :rgt AND `taxons`.`active` = TRUE AND `taxons`.`id` NOT IN (101, 77, 96, 101, 72, 55, 45, 87) ORDER BY `taxons`.`sort`
SQL Variables:
Array ( [lft] => 62 [rgt] => 73 )
Total Elapsed Time:
1.16 ms
SQL Statement:
SELECT `taxons`.`id`, `taxons`.`store_id`, `taxons`.`name`, `taxons`.`permalink`, `taxons`.`active`, `taxons`.`description`, `taxons`.`sort`, `taxons`.`parent_id`, `taxons`.`image_url`, `taxons`.`level`, `taxons`.`lft`, `taxons`.`rgt` FROM `garnishDev`.`taxons` WHERE `taxons`.`lft` > :lft AND `taxons`.`rgt` < :rgt AND `taxons`.`active` = TRUE AND `taxons`.`id` NOT IN (101, 77, 96, 101, 72, 55, 45, 87) ORDER BY `taxons`.`sort`
SQL Variables:
Array ( [lft] => 146 [rgt] => 149 )
Total Elapsed Time:
1.09 ms
SQL Statement:
SELECT `taxons`.`id`, `taxons`.`store_id`, `taxons`.`name`, `taxons`.`permalink`, `taxons`.`active`, `taxons`.`description`, `taxons`.`sort`, `taxons`.`parent_id`, `taxons`.`image_url`, `taxons`.`level`, `taxons`.`lft`, `taxons`.`rgt` FROM `garnishDev`.`taxons` WHERE `taxons`.`lft` > :lft AND `taxons`.`rgt` < :rgt AND `taxons`.`active` = TRUE AND `taxons`.`id` NOT IN (101, 77, 96, 101, 72, 55, 45, 87) ORDER BY `taxons`.`sort`
SQL Variables:
Array ( [lft] => 30 [rgt] => 49 )
Total Elapsed Time:
1.12 ms
SQL Statement:
SELECT `taxons`.`id`, `taxons`.`store_id`, `taxons`.`name`, `taxons`.`permalink`, `taxons`.`active`, `taxons`.`description`, `taxons`.`sort`, `taxons`.`parent_id`, `taxons`.`image_url`, `taxons`.`level`, `taxons`.`lft`, `taxons`.`rgt` FROM `garnishDev`.`taxons` WHERE `taxons`.`lft` > :lft AND `taxons`.`rgt` < :rgt AND `taxons`.`active` = TRUE AND `taxons`.`id` NOT IN (101, 77, 96, 101, 72, 55, 45, 87) ORDER BY `taxons`.`sort`
SQL Variables:
Array ( [lft] => 110 [rgt] => 117 )
Total Elapsed Time:
1.16 ms
SQL Statement:
SELECT DISTINCT `p`.`id` AS `product_id` FROM `garnishDev`.`products` AS `p` INNER JOIN `garnishDev`.`product_taxons` AS `pt` ON `p`.`id` = `pt`.`product_id` WHERE `pt`.`taxon_id` IN (:taxon_list) AND `p`.`active` = TRUE GROUP BY `p`.`id` ORDER BY `p`.`sort_order` ASC LIMIT 4
SQL Variables:
Array ( [taxon_list] => 27 )
Total Elapsed Time:
3.23 ms
SQL Statement:
SELECT IF(COUNT(*) > 0, 1, 0) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_NAME`= 'products' AND `TABLE_SCHEMA` = 'garnishDev'
SQL Variables:
Total Elapsed Time:
1.18 ms
SQL Statement:
DESCRIBE `garnishDev`.`products`
SQL Variables:
Total Elapsed Time:
1.54 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 250 [APL0] => 1 )
Total Elapsed Time:
1.31 ms
SQL Statement:
SELECT IF(COUNT(*) > 0, 1, 0) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_NAME`= 'product_attributes' AND `TABLE_SCHEMA` = 'garnishDev'
SQL Variables:
Total Elapsed Time:
1.31 ms
SQL Statement:
DESCRIBE `garnishDev`.`product_attributes`
SQL Variables:
Total Elapsed Time:
1.42 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 250 )
Total Elapsed Time:
4.63 ms
SQL Statement:
SELECT IF(COUNT(*) > 0, 1, 0) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_NAME`= 'product_taxons' AND `TABLE_SCHEMA` = 'garnishDev'
SQL Variables:
Total Elapsed Time:
1.07 ms
SQL Statement:
DESCRIBE `garnishDev`.`product_taxons`
SQL Variables:
Total Elapsed Time:
1.28 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 250 )
Total Elapsed Time:
1.07 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 278 [APL0] => 1 )
Total Elapsed Time:
1.14 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 278 )
Total Elapsed Time:
4.62 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 278 )
Total Elapsed Time:
1.04 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1633 [APL0] => 1 )
Total Elapsed Time:
1.14 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1633 )
Total Elapsed Time:
4.57 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1633 )
Total Elapsed Time:
1.03 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1909 [APL0] => 1 )
Total Elapsed Time:
1.15 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1909 )
Total Elapsed Time:
4.52 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1909 )
Total Elapsed Time:
1.03 ms
SQL Statement:
SELECT DISTINCT `p`.`id` AS `product_id` FROM `garnishDev`.`products` AS `p` INNER JOIN `garnishDev`.`product_taxons` AS `pt` ON `p`.`id` = `pt`.`product_id` WHERE `pt`.`taxon_id` IN (:taxon_list) AND `p`.`active` = TRUE GROUP BY `p`.`id` ORDER BY `p`.`sort_order` ASC LIMIT 4
SQL Variables:
Array ( [taxon_list] => 100 )
Total Elapsed Time:
3.10 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1588 [APL0] => 1 )
Total Elapsed Time:
1.15 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1588 )
Total Elapsed Time:
4.61 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1588 )
Total Elapsed Time:
1.09 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1628 [APL0] => 1 )
Total Elapsed Time:
1.35 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1628 )
Total Elapsed Time:
4.73 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1628 )
Total Elapsed Time:
1.20 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 118 [APL0] => 1 )
Total Elapsed Time:
1.19 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 118 )
Total Elapsed Time:
4.84 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 118 )
Total Elapsed Time:
1.05 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 331 [APL0] => 1 )
Total Elapsed Time:
1.19 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 331 )
Total Elapsed Time:
4.62 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 331 )
Total Elapsed Time:
1.03 ms
SQL Statement:
SELECT DISTINCT `p`.`id` AS `product_id` FROM `garnishDev`.`products` AS `p` INNER JOIN `garnishDev`.`product_taxons` AS `pt` ON `p`.`id` = `pt`.`product_id` WHERE `pt`.`taxon_id` IN (:taxon_list) AND `p`.`active` = TRUE GROUP BY `p`.`id` ORDER BY `p`.`sort_order` ASC LIMIT 4
SQL Variables:
Array ( [taxon_list] => 57,73,102,42 )
Total Elapsed Time:
3.07 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1907 [APL0] => 1 )
Total Elapsed Time:
1.26 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1907 )
Total Elapsed Time:
4.58 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1907 )
Total Elapsed Time:
1.08 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 618 [APL0] => 1 )
Total Elapsed Time:
1.14 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 618 )
Total Elapsed Time:
4.55 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 618 )
Total Elapsed Time:
1.21 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1906 [APL0] => 1 )
Total Elapsed Time:
1.21 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1906 )
Total Elapsed Time:
4.60 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1906 )
Total Elapsed Time:
1.00 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1914 [APL0] => 1 )
Total Elapsed Time:
1.15 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1914 )
Total Elapsed Time:
4.57 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1914 )
Total Elapsed Time:
1.26 ms
SQL Statement:
SELECT DISTINCT `p`.`id` AS `product_id` FROM `garnishDev`.`products` AS `p` INNER JOIN `garnishDev`.`product_taxons` AS `pt` ON `p`.`id` = `pt`.`product_id` WHERE `pt`.`taxon_id` IN (:taxon_list) AND `p`.`active` = TRUE GROUP BY `p`.`id` ORDER BY `p`.`sort_order` ASC LIMIT 4
SQL Variables:
Array ( [taxon_list] => 11,37,38 )
Total Elapsed Time:
3.13 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 162 [APL0] => 1 )
Total Elapsed Time:
1.18 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 162 )
Total Elapsed Time:
4.54 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 162 )
Total Elapsed Time:
1.02 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1889 [APL0] => 1 )
Total Elapsed Time:
1.13 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1889 )
Total Elapsed Time:
4.37 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1889 )
Total Elapsed Time:
1.20 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1750 [APL0] => 1 )
Total Elapsed Time:
1.24 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1750 )
Total Elapsed Time:
4.78 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1750 )
Total Elapsed Time:
0.95 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1890 [APL0] => 1 )
Total Elapsed Time:
1.18 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1890 )
Total Elapsed Time:
4.49 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1890 )
Total Elapsed Time:
0.93 ms
SQL Statement:
SELECT DISTINCT `p`.`id` AS `product_id` FROM `garnishDev`.`products` AS `p` INNER JOIN `garnishDev`.`product_taxons` AS `pt` ON `p`.`id` = `pt`.`product_id` WHERE `pt`.`taxon_id` IN (:taxon_list) AND `p`.`active` = TRUE GROUP BY `p`.`id` ORDER BY `p`.`sort_order` ASC LIMIT 4
SQL Variables:
Array ( [taxon_list] => 53 )
Total Elapsed Time:
2.94 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 250 [APL0] => 1 )
Total Elapsed Time:
1.38 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 250 )
Total Elapsed Time:
4.53 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 250 )
Total Elapsed Time:
0.97 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1529 [APL0] => 1 )
Total Elapsed Time:
1.18 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1529 )
Total Elapsed Time:
4.62 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1529 )
Total Elapsed Time:
1.08 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 278 [APL0] => 1 )
Total Elapsed Time:
1.24 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 278 )
Total Elapsed Time:
4.56 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 278 )
Total Elapsed Time:
1.02 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1633 [APL0] => 1 )
Total Elapsed Time:
1.18 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1633 )
Total Elapsed Time:
4.81 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1633 )
Total Elapsed Time:
1.00 ms
SQL Statement:
SELECT DISTINCT `p`.`id` AS `product_id` FROM `garnishDev`.`products` AS `p` INNER JOIN `garnishDev`.`product_taxons` AS `pt` ON `p`.`id` = `pt`.`product_id` WHERE `pt`.`taxon_id` IN (:taxon_list) AND `p`.`active` = TRUE GROUP BY `p`.`id` ORDER BY `p`.`sort_order` ASC LIMIT 4
SQL Variables:
Array ( [taxon_list] => 19 )
Total Elapsed Time:
3.03 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 259 [APL0] => 1 )
Total Elapsed Time:
1.19 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 259 )
Total Elapsed Time:
4.47 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 259 )
Total Elapsed Time:
0.95 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1212 [APL0] => 1 )
Total Elapsed Time:
1.10 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1212 )
Total Elapsed Time:
4.52 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1212 )
Total Elapsed Time:
0.99 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1213 [APL0] => 1 )
Total Elapsed Time:
1.13 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1213 )
Total Elapsed Time:
4.48 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1213 )
Total Elapsed Time:
1.02 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1215 [APL0] => 1 )
Total Elapsed Time:
1.21 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1215 )
Total Elapsed Time:
4.58 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1215 )
Total Elapsed Time:
0.99 ms
SQL Statement:
SELECT DISTINCT `p`.`id` AS `product_id` FROM `garnishDev`.`products` AS `p` INNER JOIN `garnishDev`.`product_taxons` AS `pt` ON `p`.`id` = `pt`.`product_id` WHERE `pt`.`taxon_id` IN (:taxon_list) AND `p`.`active` = TRUE GROUP BY `p`.`id` ORDER BY `p`.`sort_order` ASC LIMIT 4
SQL Variables:
Array ( [taxon_list] => 48,49,50,51,52,62 )
Total Elapsed Time:
3.05 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 24 [APL0] => 1 )
Total Elapsed Time:
1.33 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 24 )
Total Elapsed Time:
4.69 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 24 )
Total Elapsed Time:
0.98 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 926 [APL0] => 1 )
Total Elapsed Time:
1.23 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 926 )
Total Elapsed Time:
4.70 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 926 )
Total Elapsed Time:
1.01 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1248 [APL0] => 1 )
Total Elapsed Time:
1.13 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1248 )
Total Elapsed Time:
4.71 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1248 )
Total Elapsed Time:
1.01 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1249 [APL0] => 1 )
Total Elapsed Time:
1.15 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1249 )
Total Elapsed Time:
4.51 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1249 )
Total Elapsed Time:
0.97 ms
SQL Statement:
SELECT DISTINCT `p`.`id` AS `product_id` FROM `garnishDev`.`products` AS `p` INNER JOIN `garnishDev`.`product_taxons` AS `pt` ON `p`.`id` = `pt`.`product_id` WHERE `pt`.`taxon_id` IN (:taxon_list) AND `p`.`active` = TRUE GROUP BY `p`.`id` ORDER BY `p`.`sort_order` ASC LIMIT 4
SQL Variables:
Array ( [taxon_list] => 104 )
Total Elapsed Time:
3.01 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 618 [APL0] => 1 )
Total Elapsed Time:
1.19 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 618 )
Total Elapsed Time:
4.76 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 618 )
Total Elapsed Time:
1.05 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1914 [APL0] => 1 )
Total Elapsed Time:
1.14 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1914 )
Total Elapsed Time:
4.77 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1914 )
Total Elapsed Time:
1.22 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1915 [APL0] => 1 )
Total Elapsed Time:
1.41 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1915 )
Total Elapsed Time:
4.63 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1915 )
Total Elapsed Time:
1.12 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1709 [APL0] => 1 )
Total Elapsed Time:
1.20 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1709 )
Total Elapsed Time:
4.73 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1709 )
Total Elapsed Time:
1.00 ms
SQL Statement:
SELECT DISTINCT `p`.`id` AS `product_id` FROM `garnishDev`.`products` AS `p` INNER JOIN `garnishDev`.`product_taxons` AS `pt` ON `p`.`id` = `pt`.`product_id` WHERE `pt`.`taxon_id` IN (:taxon_list) AND `p`.`active` = TRUE GROUP BY `p`.`id` ORDER BY `p`.`sort_order` ASC LIMIT 4
SQL Variables:
Array ( [taxon_list] => 25,40,41,43,105,106,28 )
Total Elapsed Time:
3.18 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1588 [APL0] => 1 )
Total Elapsed Time:
1.38 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1588 )
Total Elapsed Time:
4.55 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1588 )
Total Elapsed Time:
1.09 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1589 [APL0] => 1 )
Total Elapsed Time:
1.22 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1589 )
Total Elapsed Time:
4.53 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1589 )
Total Elapsed Time:
1.02 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1618 [APL0] => 1 )
Total Elapsed Time:
1.35 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1618 )
Total Elapsed Time:
4.53 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1618 )
Total Elapsed Time:
0.98 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 83 [APL0] => 1 )
Total Elapsed Time:
1.28 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 83 )
Total Elapsed Time:
4.72 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 83 )
Total Elapsed Time:
1.04 ms
SQL Statement:
SELECT DISTINCT `p`.`id` AS `product_id` FROM `garnishDev`.`products` AS `p` INNER JOIN `garnishDev`.`product_taxons` AS `pt` ON `p`.`id` = `pt`.`product_id` WHERE `pt`.`taxon_id` IN (:taxon_list) AND `p`.`active` = TRUE GROUP BY `p`.`id` ORDER BY `p`.`sort_order` ASC LIMIT 4
SQL Variables:
Array ( [taxon_list] => 68,70,71 )
Total Elapsed Time:
3.22 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1575 [APL0] => 1 )
Total Elapsed Time:
1.28 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1575 )
Total Elapsed Time:
4.65 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1575 )
Total Elapsed Time:
1.04 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1573 [APL0] => 1 )
Total Elapsed Time:
1.26 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1573 )
Total Elapsed Time:
4.55 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1573 )
Total Elapsed Time:
1.00 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1574 [APL0] => 1 )
Total Elapsed Time:
1.22 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1574 )
Total Elapsed Time:
4.72 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1574 )
Total Elapsed Time:
1.04 ms
SQL Statement:
SELECT `products`.`id`, `products`.`store_id`, `products`.`vendor_id`, `products`.`manufacturer_id`, `products`.`name`, `products`.`price`, `products`.`cost`, `products`.`description`, `products`.`permalink`, `products`.`image_url`, `products`.`sku`, `products`.`upc`, `products`.`weight`, `products`.`dropship`, `products`.`active`, `products`.`taxable`, `products`.`product_type`, `products`.`short_description`, `products`.`qty_stock`, `products`.`created`, `products`.`custom_out_of_stock_message`, `products`.`pos_id`, `products`.`price_b`, `products`.`price_c`, `products`.`price_d`, `products`.`price_e`, `products`.`delivery_available`, `products`.`pickup_available`, `products`.`subscription_available`, `products`.`bill_frequency`, `products`.`trial_amount`, `products`.`trial_length`, `products`.`package_choose`, `products`.`sort_order`, `products`.`track_inventory`, `products`.`fixed_taxes`, `products`.`schedule_activate`, `products`.`schedule_deactivate`, `products`.`recipe_url`, `products`.`sunday_delivery_available`, `products`.`restrict_delivery`, `products`.`available_days`, `products`.`mailchimp_synced` FROM `garnishDev`.`products` WHERE `products`.`id` = :id LIMIT :APL0
SQL Variables:
Array ( [id] => 1608 [APL0] => 1 )
Total Elapsed Time:
1.20 ms
SQL Statement:
SELECT `product_attributes`.`id`, `product_attributes`.`product_id`, `product_attributes`.`name`, `product_attributes`.`value` FROM `garnishDev`.`product_attributes` WHERE `product_attributes`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1608 )
Total Elapsed Time:
4.66 ms
SQL Statement:
SELECT `product_taxons`.`product_id`, `product_taxons`.`taxon_id` FROM `garnishDev`.`product_taxons` WHERE `product_taxons`.`product_id` = :product_id
SQL Variables:
Array ( [product_id] => 1608 )
Total Elapsed Time:
1.04 ms