Food Cupboard

Grains, Nuts & Flour
Choose from our various range of raw grains; rice, etc.. // MORE DESCRIPTION TO FOLLOW //
PrePacked Meals
We offer a range of prepacked meals that you can snack on.... We have dried meat, fish & other African delicacies to --- your tastebuds...
Canned Food
Can Food ...
Easycook meals
Biscuits
Snacks & Confectionery
Cooking Aids
Match your favorites Oils, Spices, Sauces & Seasonings ...
such as Virgin Oil, Maggi Cube, Knorr, pepper soup seasoning, African ghost etc.....
this section will be known as cooking add-ons
Baby Food

Category: Food Cupboard

There are 30 products.

Sort by:

Showing 1-24 of 30 item(s)

Wishlist

Golden Tree Oranco Chocolate 100g

AED10.71

Oranco Orange flavoured Milk Chocolate.

Wishlist

On sale!
New

St Mary's Banana Chips Original 30g

AED9.00

St Mary's Banana Chips Original 30g

Wishlist

On sale!
New

St Mary's Ripe Plantain Strips 140g

AED9.00

St Mary's Ripe Plantain Strips 140g

Relish the authentic taste of the tropics with St Mary's Ripe Plantain Strips. This 140g pack offers perfectly sliced and lightly salted plantain chips, crafted from ripe plantains for a naturally sweet and satisfying crunch. Ideal for snacking on the go or adding a delicious twist to your favorite dips and salsas. Enjoy a gluten-free, vegan-friendly treat that brings a taste of the Caribbean straight to your pantry. Elevate your snack game with St Mary's – where quality meets flavor!

Wishlist

Kingsbite Milk Chocolate 50 g

AED5.54

100 % Premium Ghana Cocoa, No Cocoa Butter Substitutes.

Wishlist

Kingsbite Milk Chocolate 100 g

AED10.71

100 % Premium Ghana Cocoa, No Cocoa Butter Substitutes.

Wishlist

Tropical Heat Pilau Masala 70g

AED25.00

Tropical Heat Pilau Masala 70g

Elevate your culinary creations with Tropical Heat Pilau Masala! This aromatic blend of the finest spices is expertly crafted to bring authentic African flavor to your kitchen. Perfect for creating mouthwatering pilau rice, this 70g pack infuses your dishes with a rich and tantalizing taste. Whether you're a gourmet chef or a home cook, Tropical Heat Pilau Masala makes it easy to bring traditional flair to any meal. Enjoy the warmth of Africa in every bite!

Wishlist

On sale!

Tropical Heat Tea Masala 45g

AED25.00

Tropical Heat Tea Masala 45g

Delight in the exotic charm of Tropical Heat Tea Masala, a 45g blend of aromatic spices that elevates your tea into a flavorful masterpiece. This expertly crafted mix combines the finest ingredients, including cardamom, cinnamon, ginger, and cloves, to elevate your tea experience with a warm and invigorating taste. Perfect for cozy evenings or energizing mornings, Tropical Heat Tea Masala promises a delightful journey of authentic Indian spiced tea in every cup. Elevate your tea ritual and embrace the vibrant flavors of this timeless classic.

Wishlist

Ayoola Beans Flour 0.9kg

AED25.00

Ayoola Beans flour 0.9 kg

Wishlist

Ayoola Potato Flour 0.9kg

AED36.75

Ayoola Potato Flour 0.9kg

Wishlist

Mr Chef

AED21.00

Vitamin and mineral fortification (mainly Iron). It has a robust aromatic profile that includes savoury and meaty aromas. It contains a lot of sweetness, richness, and a lasting, mouth-coating flavour. Boiling meat and spice have a distinct fragrance and flavour.

Wishlist

On sale!

Tropical Heat Beef Masala 100g

AED30.00

Tropical Heat Beef Masala - 100g

Savor your culinary creations with Tropical Heat Beef Masala! This expertly crafted blend of premium spices is designed to bring rich, aromatic flavors to your beef dishes. Perfectly balanced and conveniently packaged in a 100g pack, it ensures your meals are always full of vibrant taste. Whether you're making classic stews, sizzling stir-fries, or hearty curries, Tropical Heat Beef Masala is your secret ingredient for delightful and memorable meals. Discover the magic of authentic spice combinations and transform your cooking today!

Wishlist

Tropical Heat Pilau Masala 100g

AED30.00

Tropical Heat Pilau Masala 100g

Wishlist

Very Lazy Jerk Paste 120G

AED21.00

Very Lazy Jerk Paste 120G by Very Lazy

Bring the vibrant taste of the Caribbean to your kitchen with Very Lazy Jerk Paste. This 120g jar is packed with fiery heat and rich flavor from Scotch bonnet chilli, allspice, and black pepper. Ideal for spicing up chicken wings, veggies, and rice. Enjoy maximum flavor with minimum fuss, perfect for any cooking enthusiast. Veggie and vegan friendly.

Wishlist

TENZING Pineapple & Passionfruit 330ml

AED12.60

TENZING Pineapple & Passionfruit

Boost your energy and recovery with TENZING Pineapple & Passionfruit. This vibrant 330ml beverage combines the tropical flavors of pineapple and passionfruit with Branched-Chain Amino Acids (BCAAs) to naturally enhance your performance. Perfect for pre- or post-workout, this refreshing drink is crafted from plant-based ingredients to fuel your body and refresh your mind. Stay hydrated, energized, and ready for your next adventure with TENZING.

Wishlist

On sale!

TENZING Natural Energy Raspberry & Yuzu 250ml

AED12.60

TENZING Natural Energy Raspberry & Yuzu 250ml

This invigorating 250ml drink is crafted from a blend of natural caffeine, vitamin C, and hydration-boosting electrolytes sourced from nature's finest ingredients. Experience the refreshing fusion of tart raspberry and zesty yuzu, designed to power your day without the crash. TENZING Natural Energy is vegan-friendly, gluten-free, and free from artificial additives, making it the perfect, guilt-free choice for a clean and sustainable energy boost. Get ready to conquer your day with nature’s vitality in every sip!

Wishlist

On sale!

Tropical Heat Ginger Spice 45g

AED25.00

Tropical Heat Ginger Spice 45g

Add a touch of exotic warmth to your dishes with Tropical Heat Ginger Spice. Sourced from the finest ginger roots, this 45g pack delivers robust flavor and aromatic freshness that enhances both sweet and savory dishes. Whether you're baking delectable gingerbread, crafting a zesty marinade, or adding a zing to your morning tea, this premium spice brings a touch of fiery sophistication to your kitchen. Enjoy the invigorating essence of ginger, expertly packaged to preserve its natural potency and aroma. Transform everyday meals into unforgettable experiences with Tropical Heat Ginger Spice.

Wishlist

TENZING Natural Energy Lime and Mint 250ml

AED12.60

TENZING Natural Energy Lime and Mint 250ml

TENZING Natural Energy Lime and Mint is a revitalizing beverage crafted to invigorate your day with a refreshing twist. Packed in a convenient 250ml can, this delightful drink combines the zesty tang of lime with the crisp coolness of mint. Inspired by the energizing blends used by Sherpas in the Himalayas, TENZING's natural recipe includes hydrating electrolytes, energizing caffeine from green coffee, and a blend of essential B vitamins. Vegan-friendly and made with sustainably sourced ingredients, this drink provides a clean, guilt-free energy boost whenever you need it. Elevate your energy naturally with TENZING!

Wishlist

Tropical Vibes Lemonade Ocean Blue 300ml

AED12.00

Tropical Vibes Lemonade Ocean Blue 300ml

Quench your thirst with the Tropical Vibes Lemonade Ocean Blue, a refreshing burst of oceanic delight in every sip. This 300ml bottle combines zesty lemon with a hint of tropical sweetness, delivering a vibrant flavor that’s perfect for any occasion. Whether you're lounging by the pool or dreaming of a beach getaway, this beautifully balanced lemonade is your ticket to paradise. Enjoy the taste of summer all year round with Tropical Vibes Ocean Blue!

Wishlist

Tropical Vibes Mango Carrot 1L

AED22.00

Tropical Vibes Mango Carrot 1L

Awaken your senses with the Tropical Vibes Mango Carrot 1L – a refreshing blend that bridges the tropics and the garden. Each sip of this vibrant juice delivers the luscious sweetness of ripe mangoes perfectly paired with the earthy richness of carrots, creating a delightful harmony that tantalizes your taste buds. Packed with natural flavors and essential nutrients, this 1-liter thirst-quencher is perfect for energizing your day or complementing your healthy lifestyle. Experience the ultimate fruity escape with every pour!

Wishlist

Tropical Vibes Fruit Punch 1L

AED22.00

Tropical Vibes Fruit Punch 1L

Quench your thirst with the vibrant taste of Tropical Vibes Fruit Punch. This refreshing 1L blend combines the exotic flavors of sun-ripened pineapple, succulent mango, and juicy passion fruit, creating a delightful medley that transports your senses straight to a tropical paradise. Perfect for picnics, parties, or a rejuvenating sip at home, each glass offers a burst of sunshine and a taste of summer all year round. Enjoy chilled for the ultimate fruity refreshment!

Wishlist

Tropical Vibes Sours Kawaii Kiwi 300ml

AED12.00

Tropical Vibes Sours Kawaii Kiwi 330ml

Treat yourself to a burst of exotic flavor with our Tropical Vibes Sours Kawaii Kiwi. This 300ml can packs a refreshing punch, balancing the tartness of kiwi with a tangy twist that’s perfect for any adventure. With vibrant packaging that complements its bold taste, this drink is the ultimate companion for those who crave a zesty escape. Whether you're relaxing on the beach or simply dreaming of paradise, let Kawaii Kiwi transport you to a tropical oasis with every sip. Cheers to bright flavors and endless vibes!

Wishlist

Tropical Vibes Lemonade Sassy Strawberry 300ml

AED12.00

Tropical Vibes Lemonade Sassy Strawberry 300ml

Enjoy the bold, fruity twist of Tropical Vibes Sassy Strawberry – a smooth, non-carbonated lemonade packed with sweet strawberry flavour and real fruit juice. This tantalizing 300ml beverage combines the classic tang of lemonade with the bold sweetness of ripe strawberries, creating a perfectly balanced and invigorating drink. Ideal for any occasion, from picnics to parties, its vibrant flavor and energizing taste are sure to leave you feeling revitalized and ready for fun. Indulge in a sip of paradise and embrace the tropical vibes, one delightful drop at a time!

Wishlist

Tropical Vibes Fruit Punch 300ml

AED12.00

Tropical Vibes Fruit Punch 300ml

Your perfect taste of paradise in a bottle - the Tropical Vibes Fruit Punch 300ml! Bursting with a vibrant blend of sun-ripened tropical fruits, this refreshing beverage is expertly crafted to deliver an invigorating splash of flavor with every sip. Whether you're lounging by the pool or need a midday getaway, the Tropical Vibes Fruit Punch is your ticket to an instant tropical escape. Free from artificial flavors and preservatives, it’s the natural choice for fruit lovers seeking a delicious and invigorating refreshment. Sip, savor, and let the tropical vibes carry you away!

Wishlist

Tropical Vibes Exotic Fruits 300ml

AED12.00

Tropical Vibes Exotic Fruits 300ml

Google's Reviews

4.7

Based on 110 reviews

Nde Horty

a month ago

Had a wonderful time shopping at Ojamea. The products are amazing at very affordable prices. The personal are super friendly and very customer focused. I definitely recommend 👌.

Buhari Munzali

4 weeks ago

Guys a one stop place for all your African foodstuff, Simon was helpful when I visited their branch in Al Quoz.

Nessa Nel

2 months ago

One stop shop with everything that you need. Great service (especially from Simon) and great value. Highly recommend.

Jimmy Ali

2 months ago

The best experience I’ve ever had

jude kwe

5 months ago

Was nice and swift with the parkaging of my items and every was perfect as I ordered. Is highly recommended for me best experience ❤️

A I

6 months ago

Popped into the store today because I forgot to place my order online sooner. Was welcomed as usual with my impromptu order fulfilled very quickly. Happy to continue shopping here

Esther Akanni (Essy)

6 months ago

I recently visited OjaMea African Food Store and had a fantastic experience. Simon, who assisted me during my visit, provided a great service. He was attentive, making sure I found everything I needed.If you’re looking for quality African ingredients with great customer service, OjaMea is where you need to be

Nnamdi Ejimofor

7 months ago

“This online marketplace has been a game-changer for me! The product selection is vast, covering everything from essentials to unique finds. The website is user-friendly, and the checkout process is smooth. Deliveries are always fast and reliable, with items arriving in excellent condition. Plus, their customer service team is super responsive and helpful. Overall, a top-notch service that I highly recommend.

Load Time	4821 ms - You'd better run your shop on a toaster
Querying Time	1307 ms
Queries	1348
Memory Peak Usage	38.0 Mb
Included Files	1351 files - 14.27 Mb
PrestaShop Cache	- Mb
Global vars	0.38 Mb
- global $smarty	193k
- global $_MODULES	141k
- global $context	16k
- global $__composer_autoload_files	14k
- global $_SERVER	8k
- global $_MODULE	6k
- global $exportPhpConfigFile	4k
- global $config	3k

PrestaShop Version	1.7.6.0
PHP Version	7.2.20 (OK)
MySQL Version	8.0.41 (OK)
Memory Limit	1024M
Max Execution Time	0s
Smarty Cache	enabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	44 ms	44 ms	5.40 Mb	5.43 Mb
__construct	0 ms	44 ms	- Mb	5.43 Mb
init	21 ms	65 ms	1.85 Mb	7.27 Mb
checkAccess	0 ms	65 ms	- Mb	7.27 Mb
setMedia	8 ms	73 ms	1.22 Mb	8.47 Mb
postProcess	0 ms	73 ms	- Mb	8.47 Mb
initHeader	0 ms	73 ms	- Mb	8.47 Mb
initContent	1221 ms	1293 ms	15.69 Mb	24.31 Mb
initFooter	0 ms	1293 ms	- Mb	24.31 Mb
display	3528 ms	4821 ms	12.22 Mb	38.03 Mb

196	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
71	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
71	SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = XX ) INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = XX) WHERE `id_lang` = XX AND c.`id_parent` = XX AND `active` = XX GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
59	SELECT COUNT(*) FROM `ps_pack` WHERE id_product_pack = XX LIMIT XX
59	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
59	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
58	SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX)
58	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
49	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, XX as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_customization` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = XX AND cp.`id_customization` = XX AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR ( pr.`pack_stock_type` = XX AND XX = XX ))) as q LIMIT XX
49	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
49	SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
49	SELECT name, value, pf.id_feature, f.position FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC
36	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
36	SELECT p., pl., sa.out_of_stock, IFNULL(sa.quantity, XX) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( 'XX-XX-XX XX:XX:XX', INTERVAL XX DAY ) ) > XX) as new FROM ps_product p LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = XX AND pl.id_lang = XX LEFT JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_shop = XX WHERE p.id_product = XX
36	SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = XX
35	SELECT c., cl. FROM `ps_dormegamenu` c LEFT JOIN `ps_dormegamenu_lang` cl ON c.`id_dormegamenu` = cl.`id_dormegamenu` WHERE `id_lang` = XX AND c.`id_parent` = XX AND `active` = XX ORDER BY `position` ASC
24	SELECT * FROM `ps_image` img where img.`rotator` =XX AND img.`id_product` =XX
24	SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, XX qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;
24	SELECT position FROM `ps_category_product` WHERE id_category = XX AND id_product = XX LIMIT XX
16	SELECT DISTINCT f.id_feature, f., fl. FROM `ps_feature` f INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = XX) ORDER BY f.`position` ASC
15	SELECT c., cl. FROM `ps_dorverticalmenu` c LEFT JOIN `ps_dorverticalmenu_lang` cl ON c.`id_dorverticalmenu` = cl.`id_dorverticalmenu` WHERE `id_lang` = XX AND c.`id_parent` = XX AND `active` = XX ORDER BY `position` ASC
14	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
10	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
9	SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, cl.`id_lang` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = XX ) INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = XX) WHERE cl.`id_lang` = XX AND c.`id_category` IN (XX)
9	SELECT image_shop.`id_image` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) WHERE i.`id_product` = XX AND image_shop.`cover` = XX LIMIT XX
9	SELECT * FROM `ps_image_shop` image_shop WHERE image_shop.`id_product` = XX AND image_shop.`cover`= XX LIMIT XX
9	SELECT c.* FROM `ps_currency` c WHERE (`deleted` = XX) AND (`id_currency` = XX) LIMIT XX
9	SELECT product_attribute_shop.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.id_product = XX LIMIT XX
9	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_product_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX AND pc.`validate` = XX LIMIT XX
8	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (XX, XX, XX, XX, XX, XX, XX, XX) AND c.nleft>=XX AND c.nright<=XX AND ps.id_shop='XX' GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=XX)) GROUP BY fp.id_feature_value
6	SELECT DISTINCT agl.`name`, ag., agl. FROM `ps_attribute_group` ag INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = XX) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND `id_lang` = XX) ORDER BY `name` ASC
6	SELECT pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (XX, XX, XX, XX, XX, XX, XX, XX) AND c.nleft>=XX AND c.nright<=XX AND ps.id_shop='XX' GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=XX)) GROUP BY pac.id_attribute
6	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
5	SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX LIMIT XX
4	SELECT * FROM `ps_cart_cart_rule` ccr LEFT JOIN ps_cart_rule cr ON cr.`id_cart_rule` = ccr.`id_cart_rule` WHERE ccr.`id_cart` = XX AND cr.`reduction_product` = XX
4	SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`=XX AND cache_id="XX-XX\|XX\|XX\|XX\|XX" AND compile_id="" LIMIT XX
3	SELECT * FROM `ps_state` ORDER BY `name` ASC
3	SELECT p., product_shop., pl.* , m.`name` AS manufacturer_name, s.`name` AS supplier_name FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.id_shop = XX ) LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `ps_supplier` s ON (s.`id_supplier` = p.`id_supplier`)LEFT JOIN `ps_category_product` c ON (c.`id_product` = p.`id_product`) WHERE pl.`id_lang` = XX AND c.`id_category` = XX AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = XX ORDER BY pl.`name` asc LIMIT XX,XX
3	SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2	SELECT * FROM `ps_country_lang` WHERE `id_country` = XX
2	SELECT * FROM `ps_country` a LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = XX WHERE (a.`id_country` = XX) LIMIT XX
2	SELECT * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = XX) WHERE `id_hook` = "hookDisplayNavXX" AND `id_shop` = XX AND `active` = XX ORDER BY position DESC;
2	SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`=XX AND cache_id="blocksearch-top\|XX\|XX\|XX\|XX" AND compile_id="" LIMIT XX
2	SELECT * FROM `ps_cart_cart_rule` ccr LEFT JOIN ps_cart_rule cr ON cr.`id_cart_rule` = ccr.`id_cart_rule` WHERE ccr.`id_cart` = XX AND cr.`reduction_product` = XX
2	(SELECT XX FROM `ps_cart_rule` WHERE date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX" AND `id_customer` IN (XX,XX) LIMIT XX)UNION ALL (SELECT XX FROM `ps_cart_rule` WHERE date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX" AND `id_customer` IN (XX,XX) LIMIT XX)UNION ALL (SELECT XX FROM `ps_cart_rule` WHERE date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX" AND `id_customer` IN (XX,XX) LIMIT XX) LIMIT XX
2	SELECT cl.,c., cl.`name` country, z.`name` zone FROM `ps_country` c INNER JOIN ps_country_shop country_shop ON (country_shop.id_country = c.id_country AND country_shop.id_shop = XX) LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = XX) LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`) WHERE XX ORDER BY cl.name ASC
2	SELECT m.*, ml.`description`, ml.`short_description` FROM `ps_manufacturer` m INNER JOIN ps_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = XX)INNER JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = XX)WHERE XX AND m.`active` = XX ORDER BY m.`name` ASC
2	SELECT ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = XX AND ctg.`id_group` = XX LIMIT XX
2	SELECT * FROM ps_product_carousel_item
2	SELECT * FROM `ps_currency` a LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
2	SELECT * FROM `ps_hook_alias`

Name	Instances	Source
Category	141	/controllers/front/listing/CategoryController.php [85] /controllers/front/listing/CategoryController.php [200] /controllers/front/listing/CategoryController.php [200] /controllers/front/listing/CategoryController.php [200] /controllers/front/listing/CategoryController.php [200] /controllers/front/listing/CategoryController.php [200] /controllers/front/listing/CategoryController.php [200] /controllers/front/listing/CategoryController.php [200] /controllers/front/listing/CategoryController.php [200] /classes/Meta.php [379] /classes/Link.php [386] /classes/PrestaShopCollection.php [383] /classes/PrestaShopCollection.php [383] /modules/ps_facetedsearch/src/Product/Search.php [107] /modules/ps_facetedsearch/src/Filters/Block.php [147] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/dor_searchcategories/dor_searchcategories.php [93] /modules/ps_categorytree/ps_categorytree.php [288] /modules/ps_categorytree/ps_categorytree.php [291] /modules/ps_categorytree/ps_categorytree.php [293] /modules/dor_ajaxtabsidebar_product/dor_ajaxtabsidebar_product.php [562] /modules/dor_ajaxtabsidebar_product/dor_ajaxtabsidebar_product.php [1366]
Product	94	/classes/Link.php [106] /modules/baproductscarousel/baproductscarousel.php [191] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /modules/baproductscarousel/baproductscarousel.php [191] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /modules/baproductscarousel/baproductscarousel.php [191] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /modules/baproductscarousel/baproductscarousel.php [191] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /modules/baproductscarousel/baproductscarousel.php [191] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /modules/baproductscarousel/baproductscarousel.php [191] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /modules/baproductscarousel/baproductscarousel.php [191] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /modules/baproductscarousel/baproductscarousel.php [191] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /modules/baproductscarousel/baproductscarousel.php [191] /classes/Link.php [106] /classes/Link.php [106] /modules/seoexpert/seoexpert.php [1388] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106]
Combination	49	/classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948]
Country	16	/config/config.inc.php [141] /override/classes/controller/FrontController.php [336] /classes/AddressFormat.php [357] /override/classes/controller/FrontController.php [1575] /modules/whatsappchat/classes/WhatsappChatBlock.php [157] /modules/whatsappchat/classes/WhatsappChatBlock.php [157] /modules/whatsappchat/classes/WhatsappChatBlock.php [157] /modules/whatsappchat/classes/WhatsappChatBlock.php [157] /modules/whatsappchat/classes/WhatsappChatBlock.php [157] /modules/whatsappchat/classes/WhatsappChatBlock.php [157] /modules/whatsappchat/classes/WhatsappChatBlock.php [157] /modules/whatsappchat/classes/WhatsappChatBlock.php [157] /modules/whatsappchat/classes/WhatsappChatBlock.php [157] /modules/whatsappchat/classes/WhatsappChatBlock.php [157] /modules/whatsappchat/classes/WhatsappChatBlock.php [157] /modules/whatsappchat/classes/WhatsappChatBlock.php [157]
Address	16	/classes/shop/Shop.php [467] /classes/Product.php [4970] /classes/Product.php [3201] /classes/Product.php [3310] /modules/whatsappchat/classes/WhatsappChatBlock.php [145] /modules/whatsappchat/classes/WhatsappChatBlock.php [145] /modules/whatsappchat/classes/WhatsappChatBlock.php [145] /modules/whatsappchat/classes/WhatsappChatBlock.php [145] /modules/whatsappchat/classes/WhatsappChatBlock.php [145] /modules/whatsappchat/classes/WhatsappChatBlock.php [145] /modules/whatsappchat/classes/WhatsappChatBlock.php [145] /modules/whatsappchat/classes/WhatsappChatBlock.php [145] /modules/whatsappchat/classes/WhatsappChatBlock.php [145] /modules/whatsappchat/classes/WhatsappChatBlock.php [145] /modules/whatsappchat/classes/WhatsappChatBlock.php [145] /modules/whatsappchat/classes/WhatsappChatBlock.php [145]
Customer	13	/config/config.inc.php [220] /modules/whatsappchat/classes/WhatsappChatBlock.php [155] /modules/whatsappchat/classes/WhatsappChatBlock.php [155] /modules/whatsappchat/classes/WhatsappChatBlock.php [155] /modules/whatsappchat/classes/WhatsappChatBlock.php [155] /modules/whatsappchat/classes/WhatsappChatBlock.php [155] /modules/whatsappchat/classes/WhatsappChatBlock.php [155] /modules/whatsappchat/classes/WhatsappChatBlock.php [155] /modules/whatsappchat/classes/WhatsappChatBlock.php [155] /modules/whatsappchat/classes/WhatsappChatBlock.php [155] /modules/whatsappchat/classes/WhatsappChatBlock.php [155] /modules/whatsappchat/classes/WhatsappChatBlock.php [155] /modules/whatsappchat/classes/WhatsappChatBlock.php [155]
WhatsappChatBlockAgent	13	/modules/whatsappchat/whatsappchat.php [287] /modules/whatsappchat/whatsappchat.php [532] /modules/whatsappchat/whatsappchat.php [532] /modules/whatsappchat/whatsappchat.php [532] /modules/whatsappchat/whatsappchat.php [532] /modules/whatsappchat/whatsappchat.php [532] /modules/whatsappchat/whatsappchat.php [532] /modules/whatsappchat/whatsappchat.php [532] /modules/whatsappchat/whatsappchat.php [532] /modules/whatsappchat/whatsappchat.php [532] /modules/whatsappchat/whatsappchat.php [532] /modules/whatsappchat/whatsappchat.php [532] /modules/whatsappchat/whatsappchat.php [532]
WhatsappChatBlock	12	/modules/whatsappchat/whatsappchat.php [531] /modules/whatsappchat/whatsappchat.php [531] /modules/whatsappchat/whatsappchat.php [531] /modules/whatsappchat/whatsappchat.php [531] /modules/whatsappchat/whatsappchat.php [531] /modules/whatsappchat/whatsappchat.php [531] /modules/whatsappchat/whatsappchat.php [531] /modules/whatsappchat/whatsappchat.php [531] /modules/whatsappchat/whatsappchat.php [531] /modules/whatsappchat/whatsappchat.php [531] /modules/whatsappchat/whatsappchat.php [531] /modules/whatsappchat/whatsappchat.php [531]
Currency	4	/src/Adapter/Currency/CurrencyDataProvider.php [101] /src/Adapter/Currency/CurrencyDataProvider.php [101] /override/classes/Tools.php [703] /modules/tvgoogletagmanager/tvgoogletagmanager.php [1205]
Language	3	/config/config.inc.php [194] /override/classes/Tools.php [579] /modules/baproductscarousel/baproductscarousel.php [255]
Gender	3	/override/classes/controller/FrontController.php [1537] /classes/PrestaShopCollection.php [383] /classes/PrestaShopCollection.php [383]
Shop	2	/config/config.inc.php [119] /modules/tvgooglebusinessreviews/tvgooglebusinessreviews.php [148]
PrestaEmployeeLiveFeedData	2	/modules/prestaemployeetimesheet/prestaemployeetimesheet.php [114] /modules/prestaemployeetimesheet/prestaemployeetimesheet.php [114]
State	2	/classes/AddressFormat.php [357] /override/classes/controller/FrontController.php [1574]
AddressFormat	1	/override/classes/controller/FrontController.php [1569]
ManagerBlock	1	/modules/dor_managerblocks/dor_managerblocks.php [31]
Tax	1	/classes/tax/TaxRulesTaxManager.php [115]
Risk	1	/override/classes/controller/FrontController.php [1540]
WkSmlCustomerLocation	1	/modules/wkdeliverylocation/wkdeliverylocation.php [403]
Group	1	/classes/Cart.php [245]
MdGiftRule	1	/modules/mdgiftproduct/mdgiftproduct.php [215]
Cart	1	/override/classes/controller/FrontController.php [405]
ObjectDorMegamenu	1	/modules/dor_megamenu/dor_megamenu.php [745]
DorMegamenuWidget	1	/modules/dor_megamenu/classes/DorMegamenu.php [584]
ObjectDorVerticalmenu	1	/modules/dorverticalmenu/dorverticalmenu.php [696]
DorVerticalmenuWidget	1	/modules/dorverticalmenu/classes/DorVerticalmenu.php [609]
Guest	1	/modules/statsdata/statsdata.php [77]
ShopGroup	1	/classes/shop/Shop.php [551]
Connection	1	/modules/statsdata/statsdata.php [111]

OjaMEA.COM

Shop by Category

Featured

Golden Tree Oranco Chocolate 100g

St Mary's Banana Chips Original 30g

St Mary's Ripe Plantain Strips 140g

Kingsbite Milk Chocolate 50 g

Kingsbite Milk Chocolate 100 g

Tropical Heat Pilau Masala 70g

Tropical Heat Tea Masala 45g

Ayoola Beans Flour 0.9kg

Ayoola Potato Flour 0.9kg

Mr Chef

Tropical Heat Beef Masala 100g

Tropical Heat Pilau Masala 100g

Very Lazy Jerk Paste 120G

TENZING Pineapple & Passionfruit 330ml

TENZING Natural Energy Raspberry & Yuzu 250ml

Tropical Heat Ginger Spice 45g

TENZING Natural Energy Lime and Mint 250ml

Tropical Vibes Lemonade Ocean Blue 300ml

Tropical Vibes Mango Carrot 1L

Tropical Vibes Fruit Punch 1L

Tropical Vibes Sours Kawaii Kiwi 300ml

Tropical Vibes Lemonade Sassy Strawberry 300ml

Tropical Vibes Fruit Punch 300ml

Tropical Vibes Exotic Fruits 300ml

Recently viewed products

Google's Reviews

Shop Aisle

Information

Your Account

Stopwatch SQL - 1348 queries

Doubles

Tables stress

ObjectModel instances

Included Files

Query	Time (ms)	Rows	Filesort	Group By	Location
SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2025-06-05 00:00:00", INTERVAL 50 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 2 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND cp.`id_product` IN (1, 9, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 75, 501, 502, 504, 505, 506, 507, 509, 511, 512, 513, 514, 515, 516, 517, 519, 520, 522, 523, 524, 525, 528, 529, 530, 531, 532, 533, 534, 535, 536, 538, 539, 540, 541, 542, 543, 545, 547, 548, 549, 554, 555, 556, 558, 559, 561, 562, 563, 564, 565, 566, 567, 568, 569, 570, 571, 572, 573, 574, 578, 582, 583, 584, 585, 586, 587, 588, 589, 590, 591, 592, 593, 594, 595, 596, 597, 598, 599, 600, 601, 602, 603, 604, 605, 606, 607, 608, 609, 611, 613, 614, 615, 617, 618, 619, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 633, 634, 635, 637, 638, 639, 640, 641, 642, 643, 644, 653, 750, 751, 752, 753, 754, 755, 756, 757, 758, 759, 760, 761, 762, 763, 764, 765, 766, 767, 768, 769, 770, 771, 772, 773, 774, 776, 777, 778, 779, 780, 781, 783, 784, 785, 786, 787, 788, 789, 790, 791, 792, 793, 794, 795, 796, 1461, 1464, 1473, 1478, 1480, 1492, 1495, 1503, 1504, 1511, 1513, 1517, 1518, 1519, 1520, 1521, 1523, 1526, 1528, 1539, 1542, 1546, 1551, 1561, 1567, 1568, 1579, 1583, 1585, 1587, 1590, 1595, 1598, 1603, 1612, 1618, 1639, 1642, 1643, 1648, 1655, 1666, 1953, 1954, 1955, 1959, 1960, 1961, 1962, 1963, 1964, 5599, 5724, 5725, 5726, 5727, 5728, 5729, 5730, 5731, 5732, 5733, 5734, 5735, 5736, 5737, 5738, 5739, 5740, 5741, 5742, 5743, 5744, 5745, 5746, 5748, 5749, 5750, 5751, 5752, 5753, 5754, 5755, 5756, 5757, 5758, 5759, 5760, 5761, 5762, 5763, 5764, 5765, 5766, 5767, 5768, 5769, 5770, 5771, 5773, 5774, 5775, 5776, 5777, 5778, 5779, 5780, 5781, 5782, 5783, 5784, 5785, 5786, 5787, 5788, 5789, 5790, 5791, 5792, 5793, 5794, 5795, 5798, 5799, 5800, 5801, 5802, 5803, 5804, 5805, 5806, 5809, 5810, 5811, 5812, 5813, 5814, 5815, 5816, 5817, 5818, 5819, 5820, 5821, 5822, 5823, 5824, 5825, 5826, 5827, 5828, 5829, 5830, 5831, 5832, 5833, 5834, 5835, 5836, 5837, 5838, 5839, 5840, 5841, 5842, 5843, 5844, 5845, 5846, 5847, 5848, 5849, 5851, 5852, 5853, 5854, 5856, 5857, 5858, 5859, 5860, 5861, 5862, 5863, 5864, 5865, 5866, 5867, 5869, 5870, 5871, 5872, 5873, 5874, 5875, 5876, 5877, 5878, 5883, 5885, 5886, 5887, 5888, 5889, 5890, 5891, 5892, 5893, 5894, 5895, 5896, 5899, 5900, 5901, 5902, 5903, 5904, 5905, 5906, 5907, 5908, 5909, 5910, 5911, 5912, 5913, 5914, 5915, 5916, 5917, 5918, 5919, 5920, 5921, 5923, 5924, 5926, 5927, 5928, 5929, 5930, 5931, 5932, 5933, 5934, 5935, 5936, 5937, 5938, 5939, 5940, 5941, 5942, 5943, 5944, 5945, 5946, 5947, 5948, 5949, 5950, 5951, 5952, 5953, 5954, 5955, 5956, 5957, 5958, 5959, 5960, 5961, 5962, 5963, 5964, 5965, 5966, 5967, 5968, 5969, 5970, 5971, 5972, 5973, 5974, 5975, 5976, 5977, 5978, 5979, 5980, 5981, 5982, 5983, 5984, 5985, 5986, 5987, 5988, 5989, 5993, 5994, 5995, 5996, 5997, 5998, 5999, 6000, 6001, 6002, 6003, 6005, 6006, 6007, 6008, 6009, 6010, 6011, 6012, 6013, 6014, 6015, 6016, 6017, 6018, 6019, 6020, 6021, 6022, 6023, 6024, 6025, 6026, 6027, 6028, 6029, 6030, 6031, 6032, 6033, 6034, 6035, 6036, 6038, 6039, 6041, 6042, 6043, 6044, 6045, 6046, 6047, 6048, 6049, 6050, 6051, 6052, 6053, 6054, 6055, 6056, 6057, 6058, 6059, 6060, 6061, 6062, 6063, 6064, 6065, 6066, 6067, 6068, 6069, 6070, 6071, 6072, 6073, 6074, 6075, 6076, 6077, 6078, 6079, 6080, 6083, 6084, 6085, 6088, 6090, 6091, 6092, 6093, 6094, 6095, 6096, 6097, 6098, 6100, 6101, 6102, 6103, 6104, 6105, 6106, 6107, 6108, 6109, 6110, 6111, 6112, 6113, 6114, 6115, 6116, 6117, 6118, 6119, 6120, 6121, 6122, 6123, 6124, 6125, 6126, 6127, 6128, 6129, 6130, 6131, 6132, 6133, 6134, 6135, 6136, 6137, 6138, 6139, 6140, 6141, 6142, 6143, 6144, 6145, 6146, 6147, 6148, 6149, 6150, 6151, 6152, 6153, 6154, 6155, 6156, 6157, 6158, 6159, 6160, 6161, 6162, 6163, 6164, 6165, 6166, 6167, 6168, 6169, 6170, 6171, 6172, 6173, 6174, 6175, 6176, 6177, 6178, 6179, 6180, 6181, 6182, 6183, 6184, 6185, 6186, 6187, 6188, 6189, 6190, 6191, 6192, 6193, 6194, 6195, 6196, 6197, 6198, 6199, 6200, 6201, 6202, 6203, 6204, 6205, 6206, 6207, 6208, 6209, 6210, 6211, 6212, 6213, 6214, 6215, 6216, 6217, 6218, 6219, 6220, 6221, 6222, 6223, 6224, 6226, 6227, 6228, 6229, 6230, 6231, 6232, 6233, 6236, 6237, 6238, 6239, 6240, 6241, 6242, 6243, 6244, 6245, 6246, 6247, 6248, 6249, 6250, 6251, 6252, 6253, 6254, 6255, 6256, 6257, 6258, 6259, 6260, 6261, 6262, 6263, 6264, 6265, 6266, 6267, 6269, 6270, 6271, 6272, 6273, 6274, 6275, 6277, 6278, 6279, 6280, 6281, 6282, 6284, 6285, 6286, 6287, 6288, 6289, 6290, 6291, 6292, 6293, 6294, 6295, 6296, 6297, 6298, 6299, 6300, 6301, 6302, 6303, 6304, 6305, 6306, 6307, 6308, 6309, 6310, 6311, 6315, 6316, 6317, 6318, 6319, 6320, 6321, 6322, 6325, 6326, 6327, 6328, 6329, 6330, 6331, 6332, 6334, 6335, 6336, 6337, 6338, 6339, 6340, 6341, 6342, 6343, 6344, 6345, 6346, 6347, 6348, 6349, 6350, 6351, 6352, 6353, 6354, 6355, 6356, 6357, 6358, 6359, 6360, 6361, 6362, 6363, 6364, 6365, 6366, 6367, 6368, 6369, 6370, 6371, 6372, 6373, 6374, 6375, 6376, 6377, 6378, 6379, 6380, 6381, 6382, 6383, 6384, 6385, 6386, 6387, 6388, 6389, 6390, 6391, 6392, 6393, 6394, 6395, 6396, 6397, 6398, 6399, 6400, 6401, 6402, 6403, 6404, 6405, 6406, 6407, 6408, 6409, 6410, 6411, 6412, 6413, 6414, 6415, 6416, 6417, 6418, 6419, 6420, 6422, 6423, 6424, 6425, 6426, 6427, 6428, 6429, 6430, 6431, 6432, 6433, 6435, 6436, 6437, 6438, 6439, 6440, 6441, 6442, 6443, 6444, 6445, 6446, 6447, 6448, 6449, 6450, 6451, 6452, 6453, 6454, 6455, 6456, 6457, 6458, 6462, 6463, 6464, 6465, 6466, 6467, 6468, 6469, 6470, 6471, 6472, 6473, 6474, 6475, 6476, 6477, 6478, 6479, 6480, 6481, 6483, 6484, 6486, 6487, 6488, 6489, 6490, 6491, 6492, 6493, 6494, 6495, 6498, 6499, 6500, 6501, 6502, 6503, 6505, 6506, 6507, 6508, 6509, 6510, 6511, 6512, 6513, 6514, 6515, 6516, 6517, 6519, 6520, 6521, 6523, 6531, 6532, 6533, 6534, 6535, 6536, 6537, 6538, 6539, 6540, 6541, 6542, 6544, 6545, 6546, 6547, 6548, 6552, 6557, 6558, 6559, 6560, 6561, 6562, 6563, 6564, 6565, 6566, 6567, 6568, 6569, 6570, 6571, 6572, 6573, 6574, 6575, 6578, 6579, 6582, 6583, 6584, 6585, 6586, 6587, 6588, 6589, 6590, 6591, 6592, 6593, 6594, 6595, 6596, 6600, 6601, 6602, 6603, 6605, 6606, 6611, 6612, 6613, 6614, 6616, 6617, 6618, 6619, 6620, 6621, 6622, 6623, 6624, 6625, 6628, 6629, 6633, 6634, 6635, 6636, 6637, 6638, 6641, 6642, 6643, 6644, 6645, 6647, 6648, 6649, 6650, 6651, 6652, 6653, 6654, 6655, 6656, 6657, 6659, 6660, 6661, 6662, 6663, 6664, 6665, 6666, 6667, 6668, 6673, 6674, 6675, 6676, 6682, 6683, 6684, 6685, 6686, 6687, 6688, 6689, 6690, 6691, 6692, 6693, 6694, 6695, 6696, 6697, 6698, 6699, 6700, 6701, 6702, 6703, 6704, 6705, 6706, 6707, 6708, 6709, 6710, 6711, 6712, 6713, 6714, 6716, 6718, 6719, 6720, 6721, 6722, 6723, 6724, 6725, 6726, 6727, 6728, 6729, 6730, 6731, 6732, 6733, 6734, 6735, 6736, 6737, 6738, 6739, 6740, 6741, 6742, 6743, 6744, 6745, 6746, 6747, 6748, 6749, 6750, 6751, 6752, 6753, 6754, 6755, 6756, 6757, 6758, 6759, 6760, 6761, 6762, 6763, 6764, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6774, 6775, 6776, 6777, 6778, 6779, 6780, 6782, 6783, 6784, 6785, 6786, 6788, 6789, 6790, 6791, 6792, 6793, 6794, 6795, 6796, 6797, 6798, 6799, 6800, 6801, 6802, 6803, 6804, 6805, 6806, 6807, 6808, 6809, 6810, 6811, 6812, 6813, 6814, 6815, 6816, 6817, 6818, 6819, 6820, 6821, 6822, 6823, 6824, 6825, 6826, 6827, 6828, 6829, 6830, 6831, 6832, 6833, 6834, 6835, 6836, 6837, 6838, 6839, 6840, 6841, 6842, 6843, 6844, 6845, 6847, 6848, 6849, 6850, 6851, 6852, 6853, 6854, 6855, 6856, 6857, 6858, 6859, 6860, 6861, 6862, 6863, 6864, 6865, 6866, 6867, 6868, 6869, 6870, 6871, 6872, 6873, 6874, 6875, 6876, 6877, 6878, 6879, 6880, 6881, 6882, 6883, 6884, 6885, 6886, 6887, 6888, 6889, 6890, 6891, 6892, 6893, 6894, 6895, 6896, 6897, 6898, 6899, 6900, 6901, 6902, 6903, 6904, 6905, 6906, 6907, 6908, 6909, 6910, 6911, 6912, 6913, 6914, 6915, 6916, 6917, 6918, 6919, 6920, 6921, 6922, 6923, 6924, 6925, 6926, 6927, 6928, 6930, 6931, 6932, 6933, 6934, 6935, 6937, 6938, 6939, 6957, 6959, 6961, 6963, 6966, 6970, 6971, 6972, 7018, 7020, 7021, 7043, 7044, 7045, 7046, 7047, 7048, 7049, 7050, 7051, 7052, 7053, 7054, 7057, 7059, 7062, 7064, 7068, 7071, 7073, 7076, 7077, 7078, 7079, 7080, 7084, 7087, 7090, 7095, 7097, 7098, 7099, 7100, 7101, 7103, 7104, 7107, 7109, 7110, 7111, 7112, 7113, 7116, 7117, 7119, 7173, 7178, 7182, 7183, 7201, 7203, 7213, 7215, 7216, 7217, 7218, 7220, 7221, 7222, 7224, 7226, 7228, 7230, 7237, 7278, 7279, 7280, 7292, 7328, 7329, 7330, 7331, 7332, 7333, 7334, 7348, 7350, 7351, 7352, 7353, 7354, 7355, 7375, 7379, 7380, 7381, 7382, 7389, 7440, 7444, 7480, 7481, 7482, 7483, 7484, 7485, 7486, 7487, 7518, 7519, 7524, 7525, 7526, 7594, 7643, 7644, 7645, 7646, 7647, 7648, 7649, 7650, 7651, 7652, 7653, 7654, 7655, 7656, 7657, 7667, 7668, 7669, 7674, 7678, 7681, 7692, 7693, 7694, 7695, 7696, 7697, 7698, 7701, 7706, 7717, 7718, 7722, 7723, 7724, 7726, 7727, 7728, 7732, 7745, 7746, 7747, 7753, 7754, 7755, 7756, 7757, 7758, 7759, 7760, 7761, 7762, 7763, 7764, 7766, 7771, 7772, 7774, 7776, 7777, 7778, 7779, 7780, 7785, 7787, 7793, 7794, 7796, 7797, 7804, 7811, 7818, 7819, 7820, 7821, 7822, 7823, 7824, 7825, 7826, 7827, 7828, 7829, 7833, 7834, 7836, 7838, 7840, 7845, 7846, 7848, 7849, 7850, 7851, 7852, 7856, 7858, 7878, 7879, 7880, 7882, 7883, 7909, 7910, 7914, 7917, 7918, 7920, 7921, 7932, 7937, 7960, 7969, 7970, 7971, 7972, 7973, 7974, 7975, 7976, 7977, 7978, 7984, 7986, 7987, 7988, 7989, 7990, 7998, 8016, 8017, 8021, 8024, 8025, 8033, 8040, 8041, 8042, 8043, 8044, 8050, 8051, 8053, 8054, 8055, 8056, 8057, 8063, 8064, 8067, 8068, 8069, 8070, 8071, 8073, 8075, 8077, 8078, 8079, 8080, 8082, 8095, 8096, 8099, 8100, 8105, 8106, 8140, 8153, 8154, 8155, 8156, 8158, 8159, 8160, 8161, 8166, 8167, 8168, 8169, 8170, 8171, 8173, 8174, 8175, 8179, 8182, 8183, 8184, 8185, 8186, 8187, 8188, 8189, 8190, 8192, 8193, 8194, 8195, 8196, 8197, 8198, 8199, 8200, 8201, 8241, 8246, 8262, 8263, 8265, 8266, 8267, 8268, 8269, 8274, 8275, 8277, 8280, 8285, 8286, 8287, 8297, 8300, 8301, 8303, 8314, 8315, 8317, 8322, 8323, 8328, 8329, 8330, 8334, 8338, 8339, 8340, 8341, 8357, 8364, 8365, 8371, 8372, 8373, 8382, 8384, 8385, 8388, 8389, 8390, 8392, 8394, 8395, 8399, 8537, 8538, 8540, 8545, 8546, 8555, 8608, 8609, 8610, 8611, 8614, 8615, 8616, 8617, 8618, 8619, 8620, 8621, 8622, 8623, 8640, 8641, 8662, 8663, 8664, 8665, 8666, 8667, 8671, 8674, 8675, 8676, 8677, 8678, 8681, 8686, 8699, 8701, 8702, 8703, 8704, 8705, 8708, 8720, 8721, 8722, 8723, 8724, 8726, 8730, 8732, 8733, 8734, 8735, 8747, 8748, 8757, 8758, 8761, 8763, 8764, 8767, 8768, 8771, 8772, 8773, 8774, 8775, 8776, 8777, 8778, 8779, 8780, 8790, 8791, 8792, 8793, 8795, 8796, 8797, 8798, 8800, 8804, 8805, 8808, 8809, 8810, 8811, 8812, 8813, 8816, 8817, 8821, 8822, 8823, 8826, 8827, 8829, 8831, 8832, 8833, 8840, 8841, 8842, 8845, 8849, 8851, 8852, 8856, 8857, 8859, 8860, 8861, 8862, 8864, 8869, 8870, 8871, 8872, 8873, 8875, 8877, 8879, 8881, 8882, 8884, 8887, 8889, 8890, 8891, 8892, 8893, 8894, 8897, 8900, 8901, 8902, 8903, 8907, 8908, 8909, 8910, 8911, 8913, 8914, 8916, 8921, 8926, 8929, 8930, 8931, 8932, 8933, 8934, 8935, 8936, 8937, 8938, 8939, 8940, 8944, 8955, 8958, 8959, 8967, 8968, 8972, 8983, 8984, 9001, 9002, 9003, 9004, 9005, 9006, 9007, 9008, 9009, 9010, 9014, 9015, 9016, 9017, 9018, 9019, 9020, 9021, 9022, 9023, 9024, 9025, 9026, 9029, 9037, 9038, 9039, 9040, 9042, 9044, 9047, 9048, 9049, 9050, 9051, 9052, 9053, 9059, 9060, 9061, 9064, 9066, 9067, 9068, 9069, 9070, 9071, 9072, 9073, 9074, 9075, 9079, 9080, 9081, 9082, 9085, 9092, 9095, 9106, 9108, 9110, 9112, 9114, 9116, 9117, 9118, 9119, 9120, 9125, 9126, 9127, 9130, 9131, 9132, 9133, 9135, 9136, 9137, 9138, 9139, 9140, 9142, 9144, 9145, 9148, 9151, 9152, 9153, 9154, 9155, 9156, 9157, 9158, 9159, 9161, 9162, 9163, 9164, 9166, 9168, 9169, 9170, 9171, 9174, 9175, 9177, 9179, 9180, 9181, 9182, 9184, 9185, 9186, 9187, 9188, 9189, 9190, 9191, 9192, 9193, 9194, 9195, 9196, 9197, 9198, 9199, 9200, 9202, 9204, 9205, 9208, 9209, 9210, 9211, 9213, 9215, 9216, 9220, 9221, 9222, 9223, 9224, 9225, 9227, 9228, 9229, 9230, 9231, 9232, 9233, 9234, 9235, 9236, 9237, 9240, 9241, 9242, 9243, 9244, 9245, 9247, 9248, 9249, 9250, 9251, 9252, 9254, 9256, 9257, 9262, 9263, 9280, 9281, 9282, 9283, 9284, 9285, 9286, 9287, 9288, 9289, 9290, 9292, 9293, 9294, 9295, 9296, 9297, 9298, 9299, 9300, 9301, 9302, 9303, 9304, 9305, 9306, 9307, 9308, 9309, 9310, 9311, 9312, 9313, 9314, 9315, 9316, 9317, 9319, 9320, 9324, 9325, 9326, 9329, 9330, 9332, 9336, 9337, 9338, 9339, 9355, 9356, 9358, 9362, 9363, 9364, 9365, 9368, 9369, 9370, 9371, 9374, 9375, 9376, 9378, 9380, 9381, 9385, 9387, 9388, 9389, 9390, 9391, 9392, 9393, 9396, 9397, 9398, 9399, 9401, 9402, 9403, 9404, 9405, 9406, 9407, 9408, 9409, 9414, 9415, 9416, 9417, 9418, 9419, 9420, 9421, 9422, 9423, 9424, 9425, 9426, 9427, 9428, 9430, 9431, 9434, 9435, 9436, 9440, 9441, 9442, 9443, 9444, 9445, 9446, 9447, 9448, 9449, 9450, 9453, 9454, 9456, 9458, 9460, 9461, 9462, 9463, 9464, 9465, 9466, 9467, 9468, 9469, 9470, 9471, 9472, 9473, 9474, 9475, 9476, 9477, 9479, 9481, 9482, 9483, 9484, 9485, 9486, 9487, 9491, 9492, 9493, 9494, 9495, 9496, 9497, 9498, 9499, 9500, 9501, 9502, 9503, 9504, 9505, 9506, 9507, 9508, 9509, 9510, 9511, 9512, 9513, 9514, 9515, 9516, 9517, 9518, 9519, 9520, 9521, 9522, 9523, 9527, 9528, 9529, 9530, 9531, 9532, 9533, 9534, 9539, 9540, 9541, 9542, 9543, 9544, 9545, 9546, 9547, 9548, 9549) ORDER BY cp.`position` ASC LIMIT 0,12	82	2255	Yes		/modules/dor_ajaxtabsidebar_product/dor_ajaxtabsidebar_product.php:1457 /modules/dor_ajaxtabsidebar_product/dor_ajaxtabsidebar_product.php:563 /modules/dor_ajaxtabsidebar_product/dor_ajaxtabsidebar_product.php:504 /classes/Hook.php:970 /classes/Hook.php:359 /classes/Hook.php:907 /config/smarty.config.inc.php:167 /classes/Smarty/SmartyLazyRegister.php:83 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/b8/45/7d/b8457d270ba845a9ccff880ea6d9f3a4151e9f05_2.file.layout-left-column.tpl.php:71 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/ea/5f/90/ea5f9034bac408e1bac1037316608a6292d8e039_2.file.layout-both-columns.tpl.php:292 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/b8/45/7d/b8457d270ba845a9ccff880ea6d9f3a4151e9f05_2.file.layout-left-column.tpl.php:41 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/9b/c8/72/9bc8728c0a5902851634235b864a81e41f9d0f36_2.file.product-list.tpl.php:37 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/33/91/42/33914229c2bb97d561b8f33aede65b4642d4707d_2.file.category.tpl.php:30 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 /classes/Smarty/SmartyCustom.php:112 /override/classes/controller/FrontController.php:664 /override/classes/controller/FrontController.php:649 /tools/profiling/Controller.php:716 /tools/profiling/Controller.php:255 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND c.nleft>=111 AND c.nright<=150 AND ps.id_shop='1' GROUP BY p.id_product) p GROUP BY p.id_manufacturer	79.2	575744	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:92 /modules/ps_facetedsearch/src/Adapter/MySQL.php:727 /modules/ps_facetedsearch/src/Filters/Block.php:558 /modules/ps_facetedsearch/src/Filters/Block.php:136 /modules/ps_facetedsearch/src/Product/SearchProvider.php:168 /classes/controller/ProductListingFrontController.php:308 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2025-06-05 00:00:00", INTERVAL 50 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 3 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC LIMIT 0,24	57.8	8996	Yes		/classes/Category.php:1047 /modules/tvgoogletagmanager/tvgoogletagmanager.php:837 /modules/tvgoogletagmanager/tvgoogletagmanager.php:772 /modules/tvgoogletagmanager/tvgoogletagmanager.php:688 /modules/tvgoogletagmanager/tvgoogletagmanager.php:1297 /classes/Hook.php:970 /classes/Hook.php:355 /classes/Hook.php:907 /override/classes/controller/FrontController.php:547 /controllers/front/listing/CategoryController.php:130 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE p., product_shop., pl.* , m.`name` AS manufacturer_name, s.`name` AS supplier_name FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.id_shop = 1 ) LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `ps_supplier` s ON (s.`id_supplier` = p.`id_supplier`)LEFT JOIN `ps_category_product` c ON (c.`id_product` = p.`id_product`) WHERE pl.`id_lang` = 1 AND c.`id_category` = 37 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 ORDER BY pl.`name` asc LIMIT 0,100	38.2	8996	Yes		/classes/Product.php:1355 /modules/baproductscarousel/baproductscarousel.php:539 /modules/baproductscarousel/baproductscarousel.php:249 /classes/Hook.php:970 /classes/Hook.php:355 /classes/Hook.php:907 /override/classes/controller/FrontController.php:547 /controllers/front/listing/CategoryController.php:130 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 8704) AND (b.`id_shop` = 1) LIMIT 1	31.7	1			/src/Adapter/EntityMapper.php:75 /classes/ObjectModel.php:264 /tools/profiling/ObjectModel.php:33 /classes/Product.php:551 /classes/Link.php:106 /classes/Link.php:174 /override/classes/Link.php:110 /classes/Product.php:4763 /classes/ProductAssembler.php:112 /classes/controller/ProductListingFrontController.php:54 :undefined /classes/controller/ProductListingFrontController.php:76 /classes/controller/ProductListingFrontController.php:324 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE id_cache_page FROM `ps_ets_superspeed_cache_page` WHERE page="category" AND id_lang="1" AND id_country = "24" AND id_currency = "3" AND id_shop="1" AND date_add > "2025-06-05 20:26:33"AND id_object="3" AND has_customer=0 AND has_cart=0 LIMIT 1	19.9	10			/modules/ets_superspeed/classes/cache.php:280 /modules/ets_superspeed/ets_superspeed.php:1812 /modules/ets_superspeed/ets_superspeed.php:914 /classes/Hook.php:970 /classes/Hook.php:355 /classes/Hook.php:907 /override/classes/controller/FrontController.php:667 /override/classes/controller/FrontController.php:649 /tools/profiling/Controller.php:716 /tools/profiling/Controller.php:255 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE MIN(p.weight) as min, MAX(p.weight) as max FROM ps_product p INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (96, 66, 115, 208, 131, 130, 189, 126) AND c.nleft>=111 AND c.nright<=150 AND ps.id_shop='1'	10	70			/modules/ps_facetedsearch/src/Adapter/MySQL.php:92 /modules/ps_facetedsearch/src/Adapter/MySQL.php:692 /modules/ps_facetedsearch/src/Filters/Block.php:362 /modules/ps_facetedsearch/src/Filters/Block.php:127 /modules/ps_facetedsearch/src/Product/SearchProvider.php:168 /classes/controller/ProductListingFrontController.php:308 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 519)	10	1			/classes/Product.php:3364 /classes/Product.php:3242 /override/classes/Product.php:73 /classes/Product.php:4787 /classes/Product.php:4990 /classes/Category.php:1058 /modules/tvgoogletagmanager/tvgoogletagmanager.php:837 /modules/tvgoogletagmanager/tvgoogletagmanager.php:772 /modules/tvgoogletagmanager/tvgoogletagmanager.php:688 /modules/tvgoogletagmanager/tvgoogletagmanager.php:1297 /classes/Hook.php:970 /classes/Hook.php:355 /classes/Hook.php:907 /override/classes/controller/FrontController.php:547 /controllers/front/listing/CategoryController.php:130 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (96, 66, 115, 208, 131, 130, 189, 126) AND c.nleft>=111 AND c.nright<=150 AND ps.id_shop='1' GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity>=0 AND sa_1.out_of_stock=1) OR (sa.quantity>0))	9.8	3360			/modules/ps_facetedsearch/src/Adapter/MySQL.php:92 /modules/ps_facetedsearch/src/Adapter/MySQL.php:727 /modules/ps_facetedsearch/src/Adapter/MySQL.php:705 /modules/ps_facetedsearch/src/Filters/Block.php:509 /modules/ps_facetedsearch/src/Filters/Block.php:133 /modules/ps_facetedsearch/src/Product/SearchProvider.php:168 /classes/controller/ProductListingFrontController.php:308 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 519) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1	9.8	1			/classes/stock/StockAvailable.php:444 /classes/Product.php:3701 /classes/Product.php:4887 /classes/Product.php:4990 /classes/Category.php:1058 /modules/tvgoogletagmanager/tvgoogletagmanager.php:837 /modules/tvgoogletagmanager/tvgoogletagmanager.php:772 /modules/tvgoogletagmanager/tvgoogletagmanager.php:688 /modules/tvgoogletagmanager/tvgoogletagmanager.php:1297 /classes/Hook.php:970 /classes/Hook.php:355 /classes/Hook.php:907 /override/classes/controller/FrontController.php:547 /controllers/front/listing/CategoryController.php:130 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 519 LIMIT 1	9.8	1			/classes/SpecificPrice.php:416 /classes/SpecificPrice.php:504 /classes/Product.php:3342 /classes/Product.php:3242 /override/classes/Product.php:73 /classes/Product.php:4787 /classes/Product.php:4990 /classes/Category.php:1058 /modules/tvgoogletagmanager/tvgoogletagmanager.php:837 /modules/tvgoogletagmanager/tvgoogletagmanager.php:772 /modules/tvgoogletagmanager/tvgoogletagmanager.php:688 /modules/tvgoogletagmanager/tvgoogletagmanager.php:1297 /classes/Hook.php:970 /classes/Hook.php:355 /classes/Hook.php:907 /override/classes/controller/FrontController.php:547 /controllers/front/listing/CategoryController.php:130 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 7 LIMIT 1	9.6	1			/classes/Product.php:4762 /classes/Product.php:4990 /classes/Category.php:1058 /modules/tvgoogletagmanager/tvgoogletagmanager.php:837 /modules/tvgoogletagmanager/tvgoogletagmanager.php:772 /modules/tvgoogletagmanager/tvgoogletagmanager.php:688 /modules/tvgoogletagmanager/tvgoogletagmanager.php:1297 /classes/Hook.php:970 /classes/Hook.php:355 /classes/Hook.php:907 /override/classes/controller/FrontController.php:547 /controllers/front/listing/CategoryController.php:130 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM ps_product p INNER JOIN ps_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 3 AND psi.id_country = 24) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (96, 66, 115, 208, 131, 130, 189, 126) AND c.nleft>=111 AND c.nright<=150 AND ps.id_shop='1'	9.6	70			/modules/ps_facetedsearch/src/Adapter/MySQL.php:92 /modules/ps_facetedsearch/src/Adapter/MySQL.php:64 /modules/ps_facetedsearch/src/Filters/Block.php:271 /modules/ps_facetedsearch/src/Filters/Block.php:124 /modules/ps_facetedsearch/src/Product/SearchProvider.php:168 /classes/controller/ProductListingFrontController.php:308 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 519 LIMIT 1	8.9	1			/classes/Pack.php:85 /classes/Product.php:3698 /classes/Product.php:4887 /classes/Product.php:4990 /classes/Category.php:1058 /modules/tvgoogletagmanager/tvgoogletagmanager.php:837 /modules/tvgoogletagmanager/tvgoogletagmanager.php:772 /modules/tvgoogletagmanager/tvgoogletagmanager.php:688 /modules/tvgoogletagmanager/tvgoogletagmanager.php:1297 /classes/Hook.php:970 /classes/Hook.php:355 /classes/Hook.php:907 /override/classes/controller/FrontController.php:547 /controllers/front/listing/CategoryController.php:130 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (96, 66, 115, 208, 131, 130, 189, 126) AND c.nleft>=111 AND c.nright<=150 AND ps.id_shop='1' GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)))	8.3	3360			/modules/ps_facetedsearch/src/Adapter/MySQL.php:92 /modules/ps_facetedsearch/src/Adapter/MySQL.php:727 /modules/ps_facetedsearch/src/Adapter/MySQL.php:705 /modules/ps_facetedsearch/src/Filters/Block.php:493 /modules/ps_facetedsearch/src/Filters/Block.php:133 /modules/ps_facetedsearch/src/Product/SearchProvider.php:168 /classes/controller/ProductListingFrontController.php:308 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 9 LIMIT 1	8	1			/classes/SpecificPrice.php:416 /classes/SpecificPrice.php:504 /classes/Product.php:3342 /classes/Product.php:3242 /override/classes/Product.php:73 /classes/Product.php:4787 /classes/Product.php:4990 /modules/dor_ajaxtabsidebar_product/dor_ajaxtabsidebar_product.php:1468 /modules/dor_ajaxtabsidebar_product/dor_ajaxtabsidebar_product.php:563 /modules/dor_ajaxtabsidebar_product/dor_ajaxtabsidebar_product.php:504 /classes/Hook.php:970 /classes/Hook.php:359 /classes/Hook.php:907 /config/smarty.config.inc.php:167 /classes/Smarty/SmartyLazyRegister.php:83 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/b8/45/7d/b8457d270ba845a9ccff880ea6d9f3a4151e9f05_2.file.layout-left-column.tpl.php:71 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/ea/5f/90/ea5f9034bac408e1bac1037316608a6292d8e039_2.file.layout-both-columns.tpl.php:292 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/b8/45/7d/b8457d270ba845a9ccff880ea6d9f3a4151e9f05_2.file.layout-left-column.tpl.php:41 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/9b/c8/72/9bc8728c0a5902851634235b864a81e41f9d0f36_2.file.product-list.tpl.php:37 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/33/91/42/33914229c2bb97d561b8f33aede65b4642d4707d_2.file.category.tpl.php:30 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 /classes/Smarty/SmartyCustom.php:112 /override/classes/controller/FrontController.php:664 /override/classes/controller/FrontController.php:649 /tools/profiling/Controller.php:716 /tools/profiling/Controller.php:255 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 9414) AND (b.`id_shop` = 1) LIMIT 1	7.5	1			/src/Adapter/EntityMapper.php:75 /classes/ObjectModel.php:264 /tools/profiling/ObjectModel.php:33 /classes/Product.php:551 /src/Adapter/Image/ImageRetriever.php:63 /src/Adapter/Presenter/Product/ProductLazyArray.php:590 /src/Adapter/Presenter/Product/ProductLazyArray.php:109 /src/Adapter/Presenter/Product/ProductListingPresenter.php:56 /classes/controller/ProductListingFrontController.php:62 :undefined /classes/controller/ProductListingFrontController.php:76 /classes/controller/ProductListingFrontController.php:324 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE p., pl., sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2025-06-05 00:00:00', INTERVAL 50 DAY ) ) > 0) as new FROM ps_product p LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_shop = 1 WHERE p.id_product = 39	7.5	1			/classes/ProductAssembler.php:90 /classes/ProductAssembler.php:107 /modules/dor_ajaxtabsidebar_product/dor_ajaxtabsidebar_product.php:596 /modules/dor_ajaxtabsidebar_product/dor_ajaxtabsidebar_product.php:504 /classes/Hook.php:970 /classes/Hook.php:359 /classes/Hook.php:907 /config/smarty.config.inc.php:167 /classes/Smarty/SmartyLazyRegister.php:83 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/b8/45/7d/b8457d270ba845a9ccff880ea6d9f3a4151e9f05_2.file.layout-left-column.tpl.php:71 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/ea/5f/90/ea5f9034bac408e1bac1037316608a6292d8e039_2.file.layout-both-columns.tpl.php:292 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/b8/45/7d/b8457d270ba845a9ccff880ea6d9f3a4151e9f05_2.file.layout-left-column.tpl.php:41 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/9b/c8/72/9bc8728c0a5902851634235b864a81e41f9d0f36_2.file.product-list.tpl.php:37 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/33/91/42/33914229c2bb97d561b8f33aede65b4642d4707d_2.file.category.tpl.php:30 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 /classes/Smarty/SmartyCustom.php:112 /override/classes/controller/FrontController.php:664 /override/classes/controller/FrontController.php:649 /tools/profiling/Controller.php:716 /tools/profiling/Controller.php:255 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 9368 ORDER BY `position`	7.2	3	Yes		/classes/Product.php:3059 /src/Adapter/Image/ImageRetriever.php:66 /src/Adapter/Presenter/Product/ProductLazyArray.php:590 /src/Adapter/Presenter/Product/ProductLazyArray.php:109 /src/Adapter/Presenter/Product/ProductListingPresenter.php:56 /classes/controller/ProductListingFrontController.php:62 :undefined /classes/controller/ProductListingFrontController.php:76 /classes/controller/ProductListingFrontController.php:324 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	7.2	2235			/classes/Configuration.php:160 /classes/Configuration.php:209 /classes/Configuration.php:289 /classes/shop/Shop.php:382 /config/config.inc.php:119 /index.php:26
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 519 ORDER BY f.position ASC	6.9	1	Yes		/classes/Product.php:5020 /classes/Product.php:4907 /classes/Product.php:4990 /classes/Category.php:1058 /modules/tvgoogletagmanager/tvgoogletagmanager.php:837 /modules/tvgoogletagmanager/tvgoogletagmanager.php:772 /modules/tvgoogletagmanager/tvgoogletagmanager.php:688 /modules/tvgoogletagmanager/tvgoogletagmanager.php:1297 /classes/Hook.php:970 /classes/Hook.php:355 /classes/Hook.php:907 /override/classes/controller/FrontController.php:547 /controllers/front/listing/CategoryController.php:130 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 0 LIMIT 1	6.6	1			/classes/SpecificPrice.php:407 /classes/SpecificPrice.php:504 /classes/Product.php:3342 /classes/Product.php:3242 /override/classes/Product.php:73 /var/cache/prod/smarty/compile/a2/24/46/a22446b31ef5f661e0a87a2cedcbb6a84a287f68_2.file.slide17.tpl.php:108 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 /classes/Smarty/SmartyCustomTemplate.php:44 /classes/module/Module.php:2409 /modules/baproductscarousel/baproductscarousel.php:1124 /modules/baproductscarousel/baproductscarousel.php:249 /classes/Hook.php:970 /classes/Hook.php:355 /classes/Hook.php:907 /override/classes/controller/FrontController.php:547 /controllers/front/listing/CategoryController.php:130 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 3 LIMIT 1	6.3	1			/classes/Product.php:4762 /classes/ProductAssembler.php:112 /classes/controller/ProductListingFrontController.php:54 :undefined /classes/controller/ProductListingFrontController.php:76 /classes/controller/ProductListingFrontController.php:324 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 520) AND (b.`id_shop` = 1) LIMIT 1	5.8	1			/src/Adapter/EntityMapper.php:75 /classes/ObjectModel.php:264 /tools/profiling/ObjectModel.php:33 /classes/Product.php:551 /src/Adapter/Image/ImageRetriever.php:63 /src/Adapter/Presenter/Product/ProductLazyArray.php:590 /src/Adapter/Presenter/Product/ProductLazyArray.php:109 /src/Adapter/Presenter/Product/ProductListingPresenter.php:56 /modules/dor_ajaxtabsidebar_product/dor_ajaxtabsidebar_product.php:597 /modules/dor_ajaxtabsidebar_product/dor_ajaxtabsidebar_product.php:504 /classes/Hook.php:970 /classes/Hook.php:359 /classes/Hook.php:907 /config/smarty.config.inc.php:167 /classes/Smarty/SmartyLazyRegister.php:83 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/b8/45/7d/b8457d270ba845a9ccff880ea6d9f3a4151e9f05_2.file.layout-left-column.tpl.php:71 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/ea/5f/90/ea5f9034bac408e1bac1037316608a6292d8e039_2.file.layout-both-columns.tpl.php:292 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/b8/45/7d/b8457d270ba845a9ccff880ea6d9f3a4151e9f05_2.file.layout-left-column.tpl.php:41 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/9b/c8/72/9bc8728c0a5902851634235b864a81e41f9d0f36_2.file.product-list.tpl.php:37 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/33/91/42/33914229c2bb97d561b8f33aede65b4642d4707d_2.file.category.tpl.php:30 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 /classes/Smarty/SmartyCustom.php:112 /override/classes/controller/FrontController.php:664 /override/classes/controller/FrontController.php:649 /tools/profiling/Controller.php:716 /tools/profiling/Controller.php:255 /classes/Dispatcher.php:515 /index.php:27
REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("e971767c7134e1d87ceff07bea3e60c5", "a:1:{s:7:\"filters\";a:6:{i:0;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Categories\";s:6:\"values\";a:3:{i:4;a:2:{s:4:\"name\";s:20:\"Grains, Nuts & Flour\";s:3:\"nbr\";s:1:\"2\";}i:7;a:2:{s:4:\"name\";s:12:\"Cooking Aids\";s:3:\"nbr\";s:1:\"6\";}i:74;a:2:{s:4:\"name\";s:22:\"Snacks & Confectionery\";s:3:\"nbr\";s:1:\"5\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:1;a:12:{s:9:\"type_lite\";s:6:\"weight\";s:4:\"type\";s:6:\"weight\";s:6:\"id_key\";i:0;s:4:\"name\";s:6:\"Weight\";s:3:\"max\";d:0.26;s:3:\"min\";d:0;s:4:\"unit\";s:2:\"kg\";s:14:\"specifications\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:5:\"value\";N;s:3:\"nbr\";i:30;}i:2;a:12:{s:9:\"type_lite\";s:5:\"price\";s:4:\"type\";s:5:\"price\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Price\";s:3:\"max\";d:37;s:3:\"min\";d:9;s:4:\"unit\";s:3:\"AED\";s:14:\"specifications\";a:10:{s:6:\"symbol\";a:11:{i:0;s:1:\".\";i:1;s:1:\",\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"AED\";s:14:\"currencySymbol\";s:3:\"AED\";s:15:\"positivePattern\";s:10:\"¤#,##0.00\";s:15:\"negativePattern\";s:11:\"-¤#,##0.00\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:30;s:5:\"value\";N;}i:3;a:7:{s:9:\"type_lite\";s:8:\"quantity\";s:4:\"type\";s:8:\"quantity\";s:6:\"id_key\";i:0;s:4:\"name\";s:12:\"Availability\";s:6:\"values\";a:2:{i:0;a:2:{s:4:\"name\";s:13:\"Not available\";s:3:\"nbr\";i:5;}i:1;a:2:{s:4:\"name\";s:8:\"In stock\";s:3:\"nbr\";i:25;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:4;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Brand\";s:6:\"values\";a:109:{i:7;a:2:{s:4:\"name\";s:15:\"Indomie Nigeria\";s:3:\"nbr\";s:1:\"1\";}i:12;a:2:{s:4:\"name\";s:15:\"Pride Of Africa\";s:3:\"nbr\";s:1:\"4\";}i:13;a:2:{s:4:\"name\";s:5:\"Royco\";s:3:\"nbr\";s:2:\"10\";}i:14;a:2:{s:4:\"name\";s:27:\"Robertsons The Spice People\";s:3:\"nbr\";s:2:\"33\";}i:15;a:2:{s:4:\"name\";s:7:\"Nescafe\";s:3:\"nbr\";s:1:\"3\";}i:16;a:2:{s:4:\"name\";s:6:\"Rhodes\";s:3:\"nbr\";s:1:\"5\";}i:17;a:2:{s:4:\"name\";s:21:\"Hermes Cone and Snack\";s:3:\"nbr\";s:1:\"1\";}i:18;a:2:{s:4:\"name\";s:13:\"Mister sweets\";s:3:\"nbr\";s:1:\"1\";}i:19;a:2:{s:4:\"name\";s:5:\"Iwisa\";s:3:\"nbr\";s:1:\"8\";}i:20;a:2:{s:4:\"name\";s:6:\"Bokomo\";s:3:\"nbr\";s:1:\"8\";}i:22;a:2:{s:4:\"name\";s:12:\"Brookes Oros\";s:3:\"nbr\";s:1:\"1\";}i:24;a:2:{s:4:\"name\";s:6:\"Nestle\";s:3:\"nbr\";s:1:\"8\";}i:25;a:2:{s:4:\"name\";s:8:\"Barbican\";s:3:\"nbr\";s:1:\"2\";}i:26;a:2:{s:4:\"name\";s:10:\"Five roses\";s:3:\"nbr\";s:1:\"1\";}i:27;a:2:{s:4:\"name\";s:8:\"All Gold\";s:3:\"nbr\";s:2:\"11\";}i:28;a:2:{s:4:\"name\";s:7:\"Ola Ola\";s:3:\"nbr\";s:1:\"2\";}i:29;a:2:{s:4:\"name\";s:15:\"Olu Olu Gourmet\";s:3:\"nbr\";s:2:\"11\";}i:30;a:2:{s:4:\"name\";s:5:\"Knorr\";s:3:\"nbr\";s:1:\"6\";}i:31;a:2:{s:4:\"name\";s:5:\"Maggi\";s:3:\"nbr\";s:1:\"9\";}i:45;a:2:{s:4:\"name\";s:3:\"Koo\";s:3:\"nbr\";s:1:\"6\";}i:46;a:2:{s:4:\"name\";s:5:\"Cappy\";s:3:\"nbr\";s:1:\"5\";}i:48;a:2:{s:4:\"name\";s:4:\"Nola\";s:3:\"nbr\";s:1:\"1\";}i:51;a:2:{s:4:\"name\";s:12:\"Golden Penny\";s:3:\"nbr\";s:1:\"1\";}i:52;a:2:{s:4:\"name\";s:5:\"Zesta\";s:3:\"nbr\";s:1:\"6\";}i:53;a:2:{s:4:\"name\";s:6:\"Bakers\";s:3:\"nbr\";s:2:\"10\";}i:54;a:2:{s:4:\"name\";s:21:\"Virginia Green Garden\";s:3:\"nbr\";s:2:\"27\";}i:55;a:2:{s:4:\"name\";s:10:\"Carb smart\";s:3:\"nbr\";s:1:\"8\";}i:57;a:2:{s:4:\"name\";s:11:\"Wool worths\";s:3:\"nbr\";s:1:\"1\";}i:58;a:2:{s:4:\"name\";s:6:\"Purity\";s:3:\"nbr\";s:1:\"8\";}i:60;a:2:{s:4:\"name\";s:11:\"Awfod Foods\";s:3:\"nbr\";s:1:\"1\";}i:63;a:2:{s:4:\"name\";s:8:\"Lucozade\";s:3:\"nbr\";s:1:\"5\";}i:64;a:2:{s:4:\"name\";s:7:\"Minimie\";s:3:\"nbr\";s:1:\"1\";}i:65;a:2:{s:4:\"name\";s:7:\"Walkers\";s:3:\"nbr\";s:1:\"5\";}i:66;a:3:{s:4:\"name\";s:11:\"Golden Tree\";s:3:\"nbr\";s:1:\"3\";s:7:\"checked\";b:1;}i:70;a:2:{s:4:\"name\";s:6:\"Fynbos\";s:3:\"nbr\";s:1:\"8\";}i:71;a:2:{s:4:\"name\";s:10:\"Levi Roots\";s:3:\"nbr\";s:1:\"8\";}i:72;a:2:{s:4:\"name\";s:21:\"Bushmans\'s Chilli Co.\";s:3:\"nbr\";s:1:\"2\";}i:74;a:2:{s:4:\"name\";s:9:\"Blue band\";s:3:\"nbr\";s:1:\"4\";}i:75;a:2:{s:4:\"name\";s:15:\"Fitro by Khabib\";s:3:\"nbr\";s:2:\"12\";}i:76;a:2:{s:4:\"name\";s:9:\"Calisto\'s\";s:3:\"nbr\";s:1:\"3\";}i:77;a:2:{s:4:\"name\";s:9:\"Nkulenu\'s\";s:3:\"nbr\";s:1:\"3\";}i:88;a:2:{s:4:\"name\";s:11:\"Simba Mbili\";s:3:\"nbr\";s:1:\"2\";}i:91;a:2:{s:4:\"name\";s:20:\"Little hearts Muesli\";s:3:\"nbr\";s:1:\"6\";}i:93;a:2:{s:4:\"name\";s:17:\"AH! O’dun Foods\";s:3:\"nbr\";s:1:\"4\";}i:96;a:3:{s:4:\"name\";s:6:\"Ayoola\";s:3:\"nbr\";s:1:\"2\";s:7:\"checked\";b:1;}i:99;a:2:{s:4:\"name\";s:18:\"AFG FARM & GARDENS\";s:3:\"nbr\";s:2:\"73\";}i:101;a:2:{s:4:\"name\";s:6:\"Monati\";s:3:\"nbr\";s:1:\"1\";}i:102;a:2:{s:4:\"name\";s:9:\"Supermalt\";s:3:\"nbr\";s:1:\"1\";}i:105;a:2:{s:4:\"name\";s:6:\"Nootri\";s:3:\"nbr\";s:1:\"1\";}i:108;a:2:{s:4:\"name\";s:23:\"Schweppes International\";s:3:\"nbr\";s:1:\"1\";}i:115;a:3:{s:4:\"name\";s:7:\"Mr Chef\";s:3:\"nbr\";s:1:\"1\";s:7:\"checked\";b:1;}i:119;a:2:{s:4:\"name\";s:12:\"TROPICAL SUN\";s:3:\"nbr\";s:2:\"68\";}i:122;a:2:{s:4:\"name\";s:12:\"Dunn\'s River\";s:3:\"nbr\";s:2:\"25\";}i:123;a:2:{s:4:\"name\";s:7:\"Chumbys\";s:3:\"nbr\";s:1:\"2\";}i:124;a:2:{s:4:\"name\";s:8:\"Sun mark\";s:3:\"nbr\";s:1:\"1\";}i:126;a:3:{s:4:\"name\";s:9:\"Very Lazy\";s:3:\"nbr\";s:1:\"1\";s:7:\"checked\";b:1;}i:127;a:2:{s:4:\"name\";s:17:\"Schweppes Nigeria\";s:3:\"nbr\";s:1:\"1\";}i:128;a:2:{s:4:\"name\";s:5:\"Grace\";s:3:\"nbr\";s:2:\"17\";}i:129;a:2:{s:4:\"name\";s:11:\"Walkerswood\";s:3:\"nbr\";s:1:\"9\";}i:130;a:3:{s:4:\"name\";s:13:\"Tropical Heat\";s:3:\"nbr\";s:1:\"5\";s:7:\"checked\";b:1;}i:131;a:3:{s:4:\"name\";s:7:\"Tenzing\";s:3:\"nbr\";s:1:\"3\";s:7:\"checked\";b:1;}i:135;a:2:{s:4:\"name\";s:9:\"Vita Malt\";s:3:\"nbr\";s:1:\"1\";}i:138;a:2:{s:4:\"name\";s:15:\"Africa\'s Finest\";s:3:\"nbr\";s:1:\"1\";}i:144;a:2:{s:4:\"name\";s:7:\"Peptang\";s:3:\"nbr\";s:1:\"3\";}i:148;a:2:{s:4:\"name\";s:13:\"SINA AKABANGA\";s:3:\"nbr\";s:1:\"2\";}i:149;a:2:{s:4:\"name\";s:4:\"ONGA\";s:3:\"nbr\";s:1:\"2\";}i:151;a:2:{s:4:\"name\";s:4:\"VARO\";s:3:\"nbr\";s:1:\"2\";}i:152;a:2:{s:4:\"name\";s:13:\"Spice Supreme\";s:3:\"nbr\";s:1:\"1\";}i:154;a:2:{s:4:\"name\";s:23:\"The Cake Isle Chin Chin\";s:3:\"nbr\";s:2:\"14\";}i:155;a:2:{s:4:\"name\";s:11:\"Kelly Loves\";s:3:\"nbr\";s:1:\"1\";}i:157;a:2:{s:4:\"name\";s:10:\"Island Sun\";s:3:\"nbr\";s:1:\"1\";}i:158;a:2:{s:4:\"name\";s:9:\"Reelfruit\";s:3:\"nbr\";s:1:\"8\";}i:165;a:2:{s:4:\"name\";s:14:\"FONTI DI CRODO\";s:3:\"nbr\";s:1:\"2\";}i:166;a:2:{s:4:\"name\";s:9:\"Tasty Tom\";s:3:\"nbr\";s:1:\"2\";}i:167;a:2:{s:4:\"name\";s:19:\"Maganjo Maize Flour\";s:3:\"nbr\";s:1:\"1\";}i:168;a:2:{s:4:\"name\";s:13:\"JACK DANIEL\'S\";s:3:\"nbr\";s:1:\"1\";}i:171;a:2:{s:4:\"name\";s:5:\"Tangy\";s:3:\"nbr\";s:1:\"1\";}i:177;a:2:{s:4:\"name\";s:5:\"Maaza\";s:3:\"nbr\";s:1:\"1\";}i:182;a:2:{s:4:\"name\";s:11:\"Chupa Chups\";s:3:\"nbr\";s:1:\"1\";}i:184;a:2:{s:4:\"name\";s:15:\"Ainsley Harriot\";s:3:\"nbr\";s:1:\"1\";}i:185;a:2:{s:4:\"name\";s:7:\"BetaPac\";s:3:\"nbr\";s:1:\"2\";}i:186;a:2:{s:4:\"name\";s:10:\"PainIsGood\";s:3:\"nbr\";s:1:\"1\";}i:187;a:2:{s:4:\"name\";s:14:\"Dave\'s Gourmet\";s:3:\"nbr\";s:1:\"1\";}i:188;a:2:{s:4:\"name\";s:18:\"Hellfire Hot Sauce\";s:3:\"nbr\";s:1:\"1\";}i:189;a:3:{s:4:\"name\";s:14:\"Tropical Vibes\";s:3:\"nbr\";s:2:\"13\";s:7:\"checked\";b:1;}i:191;a:2:{s:4:\"name\";s:8:\"Pringles\";s:3:\"nbr\";s:1:\"2\";}i:194;a:2:{s:4:\"name\";s:5:\"Bigga\";s:3:\"nbr\";s:1:\"3\";}i:195;a:2:{s:4:\"name\";s:4:\"Ting\";s:3:\"nbr\";s:1:\"4\";}i:196;a:2:{s:4:\"name\";s:5:\"Baron\";s:3:\"nbr\";s:1:\"2\";}i:197;a:2:{s:4:\"name\";s:6:\"Ogaoga\";s:3:\"nbr\";s:1:\"2\";}i:198;a:2:{s:4:\"name\";s:14:\"Jamaica Valley\";s:3:\"nbr\";s:2:\"16\";}i:199;a:2:{s:4:\"name\";s:13:\"Papa\'s Choice\";s:3:\"nbr\";s:1:\"1\";}i:200;a:2:{s:4:\"name\";s:12:\"Oma\'s Crisps\";s:3:\"nbr\";s:1:\"2\";}i:201;a:2:{s:4:\"name\";s:11:\"Nyama Choma\";s:3:\"nbr\";s:1:\"1\";}i:202;a:2:{s:4:\"name\";s:11:\"Jafro Foods\";s:3:\"nbr\";s:1:\"2\";}i:204;a:2:{s:4:\"name\";s:21:\"Grace Tropical Rhythm\";s:3:\"nbr\";s:1:\"6\";}i:205;a:2:{s:4:\"name\";s:8:\"Schwartz\";s:3:\"nbr\";s:1:\"2\";}i:206;a:2:{s:4:\"name\";s:11:\"Home Choice\";s:3:\"nbr\";s:1:\"2\";}i:208;a:3:{s:4:\"name\";s:9:\"St Mary\'s\";s:3:\"nbr\";s:1:\"2\";s:7:\"checked\";b:1;}i:210;a:2:{s:4:\"name\";s:7:\"Sarsons\";s:3:\"nbr\";s:1:\"1\";}i:211;a:2:{s:4:\"name\";s:6:\"Encona\";s:3:\"nbr\";s:1:\"5\";}i:212;a:2:{s:4:\"name\";s:10:\"Jack Links\";s:3:\"nbr\";s:1:\"3\";}i:213;a:2:{s:4:\"name\";s:4:\"Ades\";s:3:\"nbr\";s:1:\"2\";}i:217;a:2:{s:4:\"name\";s:5:\"Lasco\";s:3:\"nbr\";s:1:\"2\";}i:218;a:2:{s:4:\"name\";s:8:\"Spurtree\";s:3:\"nbr\";s:1:\"4\";}i:219;a:2:{s:4:\"name\";s:9:\"Aunt Mays\";s:3:\"nbr\";s:1:\"1\";}i:222;a:2:{s:4:\"name\";s:19:\"Karibbeans Flavours\";s:3:\"nbr\";s:1:\"2\";}i:223;a:2:{s:4:\"name\";s:16:\"Spicy Hill Farms\";s:3:\"nbr\";s:1:\"2\";}i:225;a:2:{s:4:\"name\";s:8:\"Twinings\";s:3:\"nbr\";s:1:\"1\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:5;a:7:{s:9:\"type_lite\";s:9:\"condition\";s:4:\"type\";s:9:\"condition\";s:6:\"id_key\";i:0;s:4:\"name\";s:9:\"Condition\";s:6:\"values\";a:3:{s:3:\"new\";a:2:{s:4:\"name\";s:3:\"New\";s:3:\"nbr\";s:2:\"30\";}s:4:\"used\";a:2:{s:4:\"name\";s:4:\"Used\";s:3:\"nbr\";i:0;}s:11:\"refurbished\";a:2:{s:4:\"name\";s:11:\"Refurbished\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}}}")	5.7	1			/modules/ps_facetedsearch/src/Filters/Block.php:193 /modules/ps_facetedsearch/src/Product/SearchProvider.php:169 /classes/controller/ProductListingFrontController.php:308 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 9368 LIMIT 1	5.7	1			/classes/SpecificPrice.php:416 /classes/SpecificPrice.php:504 /classes/Product.php:3342 /classes/Product.php:3242 /override/classes/Product.php:73 /classes/Product.php:4787 /classes/ProductAssembler.php:112 /classes/controller/ProductListingFrontController.php:54 :undefined /classes/controller/ProductListingFrontController.php:76 /classes/controller/ProductListingFrontController.php:324 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 9 ORDER BY `position`	5.4	3	Yes		/classes/Product.php:3059 /src/Adapter/Image/ImageRetriever.php:66 /src/Adapter/Presenter/Product/ProductLazyArray.php:590 /src/Adapter/Presenter/Product/ProductLazyArray.php:109 /src/Adapter/Presenter/Product/ProductListingPresenter.php:56 /modules/dor_ajaxtabsidebar_product/dor_ajaxtabsidebar_product.php:597 /modules/dor_ajaxtabsidebar_product/dor_ajaxtabsidebar_product.php:504 /classes/Hook.php:970 /classes/Hook.php:359 /classes/Hook.php:907 /config/smarty.config.inc.php:167 /classes/Smarty/SmartyLazyRegister.php:83 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/b8/45/7d/b8457d270ba845a9ccff880ea6d9f3a4151e9f05_2.file.layout-left-column.tpl.php:71 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/ea/5f/90/ea5f9034bac408e1bac1037316608a6292d8e039_2.file.layout-both-columns.tpl.php:292 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/b8/45/7d/b8457d270ba845a9ccff880ea6d9f3a4151e9f05_2.file.layout-left-column.tpl.php:41 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/9b/c8/72/9bc8728c0a5902851634235b864a81e41f9d0f36_2.file.product-list.tpl.php:37 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/33/91/42/33914229c2bb97d561b8f33aede65b4642d4707d_2.file.category.tpl.php:30 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 /classes/Smarty/SmartyCustom.php:112 /override/classes/controller/FrontController.php:664 /override/classes/controller/FrontController.php:649 /tools/profiling/Controller.php:716 /tools/profiling/Controller.php:255 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (96, 66, 115, 208, 131, 130, 189, 126) AND c.nleft>=111 AND c.nright<=150 AND ps.id_shop='1' GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=5)) GROUP BY pac.id_attribute	5.3	3360	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:92 /modules/ps_facetedsearch/src/Adapter/MySQL.php:727 /modules/ps_facetedsearch/src/Filters/Block.php:736 /modules/ps_facetedsearch/src/Filters/Block.php:140 /modules/ps_facetedsearch/src/Product/SearchProvider.php:168 /classes/controller/ProductListingFrontController.php:308 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (9421) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	5.1	1	Yes	Yes	/classes/Product.php:3887 /src/Adapter/Product/ProductColorsRetriever.php:43 /src/Adapter/Presenter/Product/ProductLazyArray.php:496 /src/Adapter/Presenter/AbstractLazyArray.php:241 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/a4/87/bf/a487bfa93332aa05e4ab337edabec356af7c15f5_2.file.product.tpl.php:313 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/a4/87/bf/a487bfa93332aa05e4ab337edabec356af7c15f5_2.file.product.tpl.php:27 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:383 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/0f/f2/cd/0ff2cd00caf6745cfa668da770f02629db11f6fc_2.file.products.tpl.php:72 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/0f/f2/cd/0ff2cd00caf6745cfa668da770f02629db11f6fc_2.file.products.tpl.php:37 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/9b/c8/72/9bc8728c0a5902851634235b864a81e41f9d0f36_2.file.product-list.tpl.php:83 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/9b/c8/72/9bc8728c0a5902851634235b864a81e41f9d0f36_2.file.product-list.tpl.php:209 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/b8/45/7d/b8457d270ba845a9ccff880ea6d9f3a4151e9f05_2.file.layout-left-column.tpl.php:109 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/ea/5f/90/ea5f9034bac408e1bac1037316608a6292d8e039_2.file.layout-both-columns.tpl.php:297 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/b8/45/7d/b8457d270ba845a9ccff880ea6d9f3a4151e9f05_2.file.layout-left-column.tpl.php:41 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/9b/c8/72/9bc8728c0a5902851634235b864a81e41f9d0f36_2.file.product-list.tpl.php:37 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/33/91/42/33914229c2bb97d561b8f33aede65b4642d4707d_2.file.category.tpl.php:30 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 /classes/Smarty/SmartyCustom.php:112 /override/classes/controller/FrontController.php:664 /override/classes/controller/FrontController.php:649 /tools/profiling/Controller.php:716 /tools/profiling/Controller.php:255 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	5.1	10070	Yes	Yes	/classes/Hook.php:670 /classes/Hook.php:775 /classes/Dispatcher.php:593 /classes/Dispatcher.php:249 /classes/Dispatcher.php:207 /index.php:27
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 651 AND id_shop=1 LIMIT 1	4.7	1			/classes/Product.php:5694 /classes/Product.php:4977 /classes/Product.php:1361 /modules/baproductscarousel/baproductscarousel.php:539 /modules/baproductscarousel/baproductscarousel.php:249 /classes/Hook.php:970 /classes/Hook.php:355 /classes/Hook.php:907 /override/classes/controller/FrontController.php:547 /controllers/front/listing/CategoryController.php:130 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1	4.7	1			/classes/Product.php:4762 /classes/Product.php:4990 /modules/dor_ajaxtabsidebar_product/dor_ajaxtabsidebar_product.php:1468 /modules/dor_ajaxtabsidebar_product/dor_ajaxtabsidebar_product.php:563 /modules/dor_ajaxtabsidebar_product/dor_ajaxtabsidebar_product.php:504 /classes/Hook.php:970 /classes/Hook.php:359 /classes/Hook.php:907 /config/smarty.config.inc.php:167 /classes/Smarty/SmartyLazyRegister.php:83 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/b8/45/7d/b8457d270ba845a9ccff880ea6d9f3a4151e9f05_2.file.layout-left-column.tpl.php:71 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/ea/5f/90/ea5f9034bac408e1bac1037316608a6292d8e039_2.file.layout-both-columns.tpl.php:292 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/b8/45/7d/b8457d270ba845a9ccff880ea6d9f3a4151e9f05_2.file.layout-left-column.tpl.php:41 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/9b/c8/72/9bc8728c0a5902851634235b864a81e41f9d0f36_2.file.product-list.tpl.php:37 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/33/91/42/33914229c2bb97d561b8f33aede65b4642d4707d_2.file.category.tpl.php:30 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 /classes/Smarty/SmartyCustom.php:112 /override/classes/controller/FrontController.php:664 /override/classes/controller/FrontController.php:649 /tools/profiling/Controller.php:716 /tools/profiling/Controller.php:255 /classes/Dispatcher.php:515 /index.php:27
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('41538650', '6', '3628718121', '', '1', '1', '2025-06-05 20:41:33')	4.3	1			/classes/ObjectModel.php:561 /classes/Connection.php:183 /classes/Connection.php:97 /modules/statsdata/statsdata.php:111 /modules/statsdata/statsdata.php:69 /classes/Hook.php:970 /classes/Hook.php:355 /classes/Hook.php:907 /config/smarty.config.inc.php:167 /classes/Smarty/SmartyLazyRegister.php:83 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/ea/5f/90/ea5f9034bac408e1bac1037316608a6292d8e039_2.file.layout-both-columns.tpl.php:621 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/ea/5f/90/ea5f9034bac408e1bac1037316608a6292d8e039_2.file.layout-both-columns.tpl.php:348 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/b8/45/7d/b8457d270ba845a9ccff880ea6d9f3a4151e9f05_2.file.layout-left-column.tpl.php:41 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/9b/c8/72/9bc8728c0a5902851634235b864a81e41f9d0f36_2.file.product-list.tpl.php:37 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/33/91/42/33914229c2bb97d561b8f33aede65b4642d4707d_2.file.category.tpl.php:30 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 /classes/Smarty/SmartyCustom.php:112 /override/classes/controller/FrontController.php:664 /override/classes/controller/FrontController.php:649 /tools/profiling/Controller.php:716 /tools/profiling/Controller.php:255 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 3 LIMIT 1	4.3	1			/classes/Product.php:4762 /classes/ProductAssembler.php:112 /classes/controller/ProductListingFrontController.php:54 :undefined /classes/controller/ProductListingFrontController.php:76 /classes/controller/ProductListingFrontController.php:324 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 509 ORDER BY `position`	4.2	1	Yes		/classes/Product.php:3059 /src/Adapter/Image/ImageRetriever.php:66 /src/Adapter/Presenter/Product/ProductLazyArray.php:590 /src/Adapter/Presenter/Product/ProductLazyArray.php:109 /src/Adapter/Presenter/Product/ProductListingPresenter.php:56 /modules/dor_ajaxtabsidebar_product/dor_ajaxtabsidebar_product.php:597 /modules/dor_ajaxtabsidebar_product/dor_ajaxtabsidebar_product.php:504 /classes/Hook.php:970 /classes/Hook.php:359 /classes/Hook.php:907 /config/smarty.config.inc.php:167 /classes/Smarty/SmartyLazyRegister.php:83 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/b8/45/7d/b8457d270ba845a9ccff880ea6d9f3a4151e9f05_2.file.layout-left-column.tpl.php:71 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/ea/5f/90/ea5f9034bac408e1bac1037316608a6292d8e039_2.file.layout-both-columns.tpl.php:292 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/b8/45/7d/b8457d270ba845a9ccff880ea6d9f3a4151e9f05_2.file.layout-left-column.tpl.php:41 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/9b/c8/72/9bc8728c0a5902851634235b864a81e41f9d0f36_2.file.product-list.tpl.php:37 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/33/91/42/33914229c2bb97d561b8f33aede65b4642d4707d_2.file.category.tpl.php:30 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 /classes/Smarty/SmartyCustom.php:112 /override/classes/controller/FrontController.php:664 /override/classes/controller/FrontController.php:649 /tools/profiling/Controller.php:716 /tools/profiling/Controller.php:255 /classes/Dispatcher.php:515 /index.php:27
UPDATE `ps_page_viewed` SET `counter` = `counter` + 1 WHERE `id_date_range` = 1683 AND `id_page` = 6 AND `id_shop` = 1	4.2	1			/classes/Page.php:131 /modules/statsdata/statsdata.php:114 /modules/statsdata/statsdata.php:69 /classes/Hook.php:970 /classes/Hook.php:355 /classes/Hook.php:907 /config/smarty.config.inc.php:167 /classes/Smarty/SmartyLazyRegister.php:83 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/ea/5f/90/ea5f9034bac408e1bac1037316608a6292d8e039_2.file.layout-both-columns.tpl.php:621 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/ea/5f/90/ea5f9034bac408e1bac1037316608a6292d8e039_2.file.layout-both-columns.tpl.php:348 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/b8/45/7d/b8457d270ba845a9ccff880ea6d9f3a4151e9f05_2.file.layout-left-column.tpl.php:41 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/9b/c8/72/9bc8728c0a5902851634235b864a81e41f9d0f36_2.file.product-list.tpl.php:37 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/33/91/42/33914229c2bb97d561b8f33aede65b4642d4707d_2.file.category.tpl.php:30 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 /classes/Smarty/SmartyCustom.php:112 /override/classes/controller/FrontController.php:664 /override/classes/controller/FrontController.php:649 /tools/profiling/Controller.php:716 /tools/profiling/Controller.php:255 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE cl., lm. FROM `ps_wk_sml_customer_location` cl JOIN `ps_wk_sml_location_mapping` lm ON (cl.`id_location` = lm.`id_location`) WHERE lm.`id_element` = 0 AND lm.`element_type` = "order"	4.1	6309			/modules/wkdeliverylocation/classes/WkSmlCustomerLocation.php:137 /modules/wkdeliverylocation/wkdeliverylocation.php:404 /classes/Hook.php:970 /classes/Hook.php:355 /classes/Hook.php:907 /override/classes/controller/FrontController.php:902 /tools/profiling/Controller.php:221 /classes/Dispatcher.php:515 /index.php:27
INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0')	4.1	1			/classes/ObjectModel.php:561 /classes/ObjectModel.php:516 /classes/Guest.php:239 /modules/statsdata/statsdata.php:77 /modules/statsdata/statsdata.php:68 /classes/Hook.php:970 /classes/Hook.php:355 /classes/Hook.php:907 /config/smarty.config.inc.php:167 /classes/Smarty/SmartyLazyRegister.php:83 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/ea/5f/90/ea5f9034bac408e1bac1037316608a6292d8e039_2.file.layout-both-columns.tpl.php:621 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/ea/5f/90/ea5f9034bac408e1bac1037316608a6292d8e039_2.file.layout-both-columns.tpl.php:348 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/b8/45/7d/b8457d270ba845a9ccff880ea6d9f3a4151e9f05_2.file.layout-left-column.tpl.php:41 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/9b/c8/72/9bc8728c0a5902851634235b864a81e41f9d0f36_2.file.product-list.tpl.php:37 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:125 /var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/33/91/42/33914229c2bb97d561b8f33aede65b4642d4707d_2.file.category.tpl.php:30 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 /classes/Smarty/SmartyCustom.php:112 /override/classes/controller/FrontController.php:664 /override/classes/controller/FrontController.php:649 /tools/profiling/Controller.php:716 /tools/profiling/Controller.php:255 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 8704 LIMIT 1	4	1			/classes/SpecificPrice.php:416 /classes/SpecificPrice.php:504 /classes/Product.php:3342 /classes/Product.php:3242 /override/classes/Product.php:73 /classes/Product.php:4787 /classes/ProductAssembler.php:112 /classes/controller/ProductListingFrontController.php:54 :undefined /classes/controller/ProductListingFrontController.php:76 /classes/controller/ProductListingFrontController.php:324 /classes/controller/ProductListingFrontController.php:580 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:27
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, active FROM `ps_hook_module` hm STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	4	1086			/classes/Hook.php:407 /classes/Hook.php:449 /classes/tax/TaxManagerFactory.php:67 /classes/tax/TaxManagerFactory.php:46 /classes/Product.php:4977 /classes/Product.php:1361 /modules/baproductscarousel/baproductscarousel.php:539 /modules/baproductscarousel/baproductscarousel.php:249 /classes/Hook.php:970 /classes/Hook.php:355 /classes/Hook.php:907 /override/classes/controller/FrontController.php:547 /controllers/front/listing/CategoryController.php:130 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:27

#	Filename
1	/index.php
2	/config/config.inc.php
3	/config/defines.inc.php
4	/config/autoload.php
5	/vendor/autoload.php
6	/vendor/composer/autoload_real.php
7	/vendor/composer/ClassLoader.php
8	/vendor/composer/include_paths.php
9	/vendor/composer/autoload_static.php
10	/vendor/symfony/polyfill-ctype/bootstrap.php
11	/vendor/react/promise/src/functions_include.php
12	/vendor/react/promise/src/functions.php
13	/vendor/swiftmailer/swiftmailer/lib/swift_required.php
14	/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
15	/vendor/paragonie/random_compat/lib/random.php
16	/vendor/symfony/polyfill-php70/bootstrap.php
17	/vendor/symfony/polyfill-php56/bootstrap.php
18	/vendor/symfony/polyfill-mbstring/bootstrap.php
19	/vendor/symfony/polyfill-intl-icu/bootstrap.php
20	/vendor/symfony/polyfill-apcu/bootstrap.php
21	/vendor/markbaker/matrix/classes/src/functions/adjoint.php
22	/vendor/markbaker/matrix/classes/src/functions/antidiagonal.php
23	/vendor/markbaker/matrix/classes/src/functions/cofactors.php
24	/vendor/markbaker/matrix/classes/src/functions/determinant.php
25	/vendor/markbaker/matrix/classes/src/functions/diagonal.php
26	/vendor/markbaker/matrix/classes/src/functions/identity.php
27	/vendor/markbaker/matrix/classes/src/functions/inverse.php
28	/vendor/markbaker/matrix/classes/src/functions/minors.php
29	/vendor/markbaker/matrix/classes/src/functions/trace.php
30	/vendor/markbaker/matrix/classes/src/functions/transpose.php
31	/vendor/markbaker/matrix/classes/src/operations/add.php
32	/vendor/markbaker/matrix/classes/src/operations/directsum.php
33	/vendor/markbaker/matrix/classes/src/operations/subtract.php
34	/vendor/markbaker/matrix/classes/src/operations/multiply.php
35	/vendor/markbaker/matrix/classes/src/operations/divideby.php
36	/vendor/markbaker/matrix/classes/src/operations/divideinto.php
37	/vendor/markbaker/complex/classes/src/functions/abs.php
38	/vendor/markbaker/complex/classes/src/functions/acos.php
39	/vendor/markbaker/complex/classes/src/functions/acosh.php
40	/vendor/markbaker/complex/classes/src/functions/acot.php

OjaMEA.COM

Shop by Category

Purchase a gift voucher

Category: Food Cupboard

Recently viewed products

Google's Reviews

Contact Us

Follow us on

Shop Aisle

Information

Your Account