TROPICA - Kid rug / Parrot (pink)

€199.90
Reference: H0587 Category: Tapis forme animaux

Rugs are an aesthetically attractive and very practical accessory.

It's an important decorative element that plays an essential role in the successful design of a child's room. Its forms help to define a room's space and create separate atmospheres while providing a cozy and comfortable feeling. Rugs also provide natural thermal isolation through the composition of their fibers and absorb sound, helping to reduce the volume of sound in the room.

Rugs are a valuable asset for decorating children's rooms!

Rugs
Dim. 120 cm x 160 cm / Special form : rond.
Exclusive LILIPINSO collection

Détails
Quantity
Add to wishlist
En stock - Expédition sous 48h00

Additional Items

People who viewed this item also viewed

ADDITIONAL INFORMATION

_

100% cotton tufted rug

When opening...

Rugs can release excess fibers: it is said that a rug "overflows", which is normal. It is preferable to remove the excess fibers by hand rather than vacuum them up to avoid damaging the rug.

Cleaning

Follow the instructions provided.

Does my rug have a guarantee?

Our products have a one-year guarantee on manufacturing defects.
This guarantee does not cover inappropriate use or cleaning.
Complaints will only be accepted with proof of purchase.

Important!

This product is not suitable for humid rooms! Do not expose to direct sunlight, as the sun can change the colour of the rug.

TROPICA - Kid rug / Parrot (pink)

En stock - Expédition sous 48h00 RÉFÉRENCE : H0587
H0587

Nouveau compte

S'inscrire

Already have an account?
Log in instead Or Reset password
Load Time7371 ms - You'd better run your shop on a toaster
Querying Time6113 ms
Queries272
Memory Peak Usage61.3 Mb
Included Files1120 files - 13.89 Mb
PrestaShop Cache- Mb
Global vars0.66 Mb
PrestaShop Version1.7.6.5
PHP Version7.2.34 (OK)
MySQL Version5.7.32-log (OK)
Memory Limit1280M
Max Execution Time60s
Smarty Cacheenabled
Smarty Compilationforce compile
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 178 ms 178 ms 23.13 Mb 23.43 Mb
__construct 0 ms 178 ms - Mb 23.43 Mb
init 6089 ms 6266 ms 12.25 Mb 35.85 Mb
checkAccess 0 ms 6266 ms - Mb 35.85 Mb
setMedia 29 ms 6295 ms 2.52 Mb 38.33 Mb
postProcess 0 ms 6295 ms - Mb 38.33 Mb
initHeader 0 ms 6295 ms - Mb 38.33 Mb
initContent 316 ms 6611 ms 14.94 Mb 52.90 Mb
initFooter 0 ms 6611 ms - Mb 52.90 Mb
display 760 ms 7371 ms 7.50 Mb 61.28 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb
  1. Stopwatch SQL
  2. Doubles
  3. Tables stress
  4. ObjectModel instances
  5. Included Files

Stopwatch SQL - 272 queries

Query Time (ms) Rows Filesort Group By Location 
SELECT SQL_NO_CACHE r.id_redirect FROM ps_redirect r, ps_redirect_shop rs WHERE rs.id_redirect = r.id_redirect AND rs.id_shop = 1 AND r.regex = 0 AND r.old LIKE "/%tropica%kid%rug"
 3150.4 942617 /modules/magicredirect/magicredirect.php:1241 
SELECT SQL_NO_CACHE * FROM ps_redirect r , ps_redirect_shop rs WHERE r.old = "/en/tapis-forme-animaux/18174-tropica-kid-rug-parrot-pink.html"  AND rs.id_redirect = r.id_redirect AND rs.id_shop = 1 AND r.active = 1 AND r.regex = 0 ORDER BY date_upd DESC LIMIT 1
 1462.3 942617 Yes /modules/magicredirect/magicredirect.php:1366 
SELECT SQL_NO_CACHE * FROM ps_redirect r , ps_redirect_shop rs WHERE 1=1  AND rs.id_redirect = r.id_redirect AND rs.id_shop = 1 AND r.active = 1 AND r.regex = 1 GROUP BY r.old ORDER BY date_upd DESC LIMIT 0, 20
 1325 942617 Yes Yes /modules/magicredirect/magicredirect.php:1376 
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`)
 8.6 5820 /classes/Configuration.php:160 
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`
 7.1 920 Yes Yes /classes/Hook.php:670 
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.5 720 /classes/Hook.php:407 
SELECT SQL_NO_CACHE p.*, pl.params, pl.id_lang
FROM ps_appagebuilder p
LEFT JOIN ps_appagebuilder_shop ps ON (ps.id_appagebuilder = p.id_appagebuilder AND id_shop=1)
LEFT JOIN ps_appagebuilder_lang pl ON (pl.id_appagebuilder = p.id_appagebuilder)
WHERE
pl.id_lang=5
AND ps.id_shop=1
AND p.id_appagebuilder_positions IN (1,2,3,4)
ORDER BY p.id_appagebuilder
 2.5 426 Yes /modules/appagebuilder/classes/ApPageBuilderModel.php:303 
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2023-09-29 00:00:00",
INTERVAL 180 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
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_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 5 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 5 AND cl.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` = 5)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
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  )
WHERE `id_product_1` = 18174 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
 2.3 2 Yes Yes /classes/Product.php:4031 
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
 2.1 0 /classes/Hook.php:194 
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
 2 292 /classes/SpecificPrice.php:291 
SELECT SQL_NO_CACHE sr.*, cl.`name` as `country_name`, s.`name` as `state_name`
FROM `ps_store_relocator` sr
LEFT JOIN `ps_country` c
ON c.`id_country` = sr.`country_id`
LEFT JOIN `ps_country_lang` cl
ON c.`id_country` = cl.`id_country`
LEFT JOIN `ps_state` s
ON sr.`state_id` = s.`id_state`
WHERE sr.`active` = 1 AND id_lang =5
 1.7 51 /modules/wkstorelocator/classes/StoreRelocator.php:147 
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
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)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 18174
AND al.`id_lang` = 5
AND agl.`id_lang` = 5
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
 1.5 1 Yes Yes /classes/Product.php:3942 
SELECT SQL_NO_CACHE * FROM `ps_ppb_block` AS a INNER JOIN `ps_ppb_block_lang` AS b ON a.id=b.id WHERE a.hook="header" AND active=1 AND b.id_lang=5 AND shop="1" GROUP BY a.id ORDER BY a.position
 1.5 3 Yes Yes /modules/popuppro/popuppro.php:628 
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
 1.5 292 /classes/SpecificPrice.php:283 
SELECT SQL_NO_CACHE DISTINCT `id_product_attribute` FROM `ps_specific_price` WHERE `id_product_attribute` != 0
 1.3 135 /classes/SpecificPrice.php:291 
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
 1.2 192 Yes /classes/Dispatcher.php:640 
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 5) WHERE cr.`id_customer` = 0  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1) UNION (SELECT * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 5) WHERE cr.`group_restriction` = 1  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
 1.2 1 /classes/CartRule.php:401 
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 5) WHERE cr.`id_customer` = 0  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 5) WHERE cr.`group_restriction` = 1  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
 1.2 1 /classes/CartRule.php:401 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 17086) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 345) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-09-29 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 1.1 27 Yes /classes/SpecificPrice.php:557 
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product_attribute`) FROM `ps_specific_price` WHERE `id_product_attribute` != 0 LIMIT 1
 1.1 135 /classes/SpecificPrice.php:283 
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 277) AND (a0.`nright` > 278) AND (a1.`id_lang` = 5)
ORDER BY a0.`nleft` asc
 1.1 3102 Yes /classes/PrestaShopCollection.php:381 
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 5) WHERE cr.`id_customer` = 0  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 5) WHERE cr.`group_restriction` = 1  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
 1.1 1 /classes/CartRule.php:401 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 17083 UNION SELECT 0 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` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 17083 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.1 0 /classes/Cart.php:1238 
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', 'en', '0')
 1.1 1 /classes/ObjectModel.php:559 
SELECT SQL_NO_CACHE 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` = 1
 1 111 /classes/module/Module.php:307 
SELECT SQL_NO_CACHE * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'jz8b2_lilipinso_preprod'
AND TABLE_NAME='ps_btmegamenu_lang'
 1 0 /modules/leobootstrapmenu/leobootstrapmenu.php:1421 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 18174) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-09-29 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 1 26 Yes /classes/SpecificPrice.php:557 
UPDATE `ps_btmegamenu_group` SET `id_btmegamenu_group` = '4',`active` = '1',`hook` = '',`position` = '1',`id_shop` = '1',`params` = 'eyJncm91cF90eXBlIjoiaG9yaXpvbnRhbCIsInNob3dfY2F2YXMiOiIwIiwidHlwZV9zdWIiOiJhdXRvIiwiZ3JvdXBfY2xhc3MiOiIifQ==',`active_ap` = '1',`randkey` = 'a3cd33404b7873a62c4930db407ff39f',`form_id` = '5163761396083416' WHERE `id_btmegamenu_group` = 4
 1 1 /classes/ObjectModel.php:737 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 17083) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 343) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-09-29 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 1 27 Yes /classes/SpecificPrice.php:557 
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 17083
AND (fl.name NOT LIKE "carl_%" AND fl.name NOT LIKE "")
ORDER BY f.position ASC
 1 1 Yes /override/classes/Product.php:29 
SELECT SQL_NO_CACHE p.*, ps.*,pl.friendly_url
FROM ps_appagebuilder_profiles p
INNER JOIN ps_appagebuilder_profiles_lang pl ON (p.id_appagebuilder_profiles = pl.id_appagebuilder_profiles)
INNER JOIN ps_appagebuilder_profiles_shop ps ON (ps.id_appagebuilder_profiles = p.id_appagebuilder_profiles)
WHERE id_shop=1 AND id_lang=5
 1 24 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:137 
SELECT SQL_NO_CACHE * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'jz8b2_lilipinso_preprod'
AND TABLE_NAME='ps_btmegamenu_lang'
 1 0 /modules/leobootstrapmenu/leobootstrapmenu.php:1421 
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 18174) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-09-29 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.9 26 Yes /classes/SpecificPrice.php:620 
SELECT SQL_NO_CACHE * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'jz8b2_lilipinso_preprod'
AND TABLE_NAME='ps_btmegamenu_lang'
AND COLUMN_NAME ='url'
 0.9 0 /modules/leobootstrapmenu/leobootstrapmenu.php:1386 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 343
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 17083 UNION SELECT 0 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` = 343
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 17083 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.9 0 /classes/Cart.php:1238 
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
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)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 18174
 0.9 1 /classes/Product.php:6285 
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('2103361', '1008', '65871807', '', '1', '1', '2023-09-29 12:45:21')
 0.9 1 /classes/ObjectModel.php:559 
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` = 5)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (17083) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.9 2 Yes Yes /classes/Product.php:3887 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 18174 UNION SELECT 0 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` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 18174 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.9 0 /classes/Cart.php:1238 
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
 0.9 2 Yes /classes/shop/Shop.php:705 
SELECT SQL_NO_CACHE * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'jz8b2_lilipinso_preprod'
AND TABLE_NAME='ps_btmegamenu_lang'
AND COLUMN_NAME ='url'
 0.9 0 /modules/leobootstrapmenu/leobootstrapmenu.php:1386 
SELECT SQL_NO_CACHE pc.`id_product_review`,
(SELECT count(*) FROM `ps_leofeature_product_review_usefulness` pcu WHERE pcu.`id_product_review` = pc.`id_product_review` AND pcu.`usefulness` = 1) as total_useful,
(SELECT count(*) FROM `ps_leofeature_product_review_usefulness` pcu WHERE pcu.`id_product_review` = pc.`id_product_review`) as total_advice, 
if (c.id_customer, CONCAT(c.`firstname`, ' ',  c.`lastname`), pc.customer_name) customer_name, pc.`content`, pc.`grade`, pc.`date_add`, pc.title
FROM `ps_leofeature_product_review` pc
LEFT JOIN `ps_customer` c ON c.`id_customer` = pc.`id_customer`
WHERE pc.`id_product` = 18174 AND pc.`validate` = 1
ORDER BY pc.`date_add` DESC
 0.9 1 Yes /modules/leofeature/classes/ProductReview.php:107 
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 18174
AND (fl.name NOT LIKE "carl_%" AND fl.name NOT LIKE "")
ORDER BY f.position ASC
 0.8 3 Yes /override/classes/Product.php:29 
SELECT SQL_NO_CACHE 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` = 1
 0.8 111 /classes/module/Module.php:307 
SELECT SQL_NO_CACHE 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` = 1
 0.8 111 /classes/module/Module.php:307 
SELECT SQL_NO_CACHE 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` = 1
 0.8 111 /classes/module/Module.php:307 
SELECT SQL_NO_CACHE 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` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 82
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 0.8 1 Yes /classes/tax/TaxRulesTaxManager.php:108 
SELECT SQL_NO_CACHE 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 = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 5
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.8 25 Yes Yes /classes/Category.php:1144 
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 5  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 613
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 0.8 1 Yes Yes /classes/Category.php:909 
UPDATE `ps_btmegamenu_group_lang` SET `id_btmegamenu_group` = '4',`title` = 'Megamenu B2C',`title_fo` = 'Categories',`id_lang` = '1' WHERE id_btmegamenu_group = 4 AND id_lang = 1
 0.8 1 /classes/ObjectModel.php:805 
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` = 5
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 17083) AND (b.`id_shop` = 1) LIMIT 1
 0.8 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 5)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
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)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5)
WHERE pa.`id_product` = 17083
AND pac.`id_product_attribute` = 343
AND agl.`id_lang` = 5
 0.8 1 /classes/Product.php:6258 
SELECT SQL_NO_CACHE 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` = 1
 0.8 111 /classes/module/Module.php:307 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 18174) LIMIT 1
 0.8 1 /src/Adapter/EntityMapper.php:75 
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` = 5)
WHERE i.`id_product` = 17083
ORDER BY `position`
 0.8 5 Yes /classes/Product.php:3059 
UPDATE `ps_btmegamenu_group_lang` SET `id_btmegamenu_group` = '4',`title` = 'Dupliquer des Megamenu',`title_fo` = 'Categories',`id_lang` = '5' WHERE id_btmegamenu_group = 4 AND id_lang = 5
 0.8 1 /classes/ObjectModel.php:805 
SELECT SQL_NO_CACHE 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` = 1
 0.8 111 /classes/module/Module.php:307 
SELECT SQL_NO_CACHE 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` = 1
 0.7 111 /classes/module/Module.php:307 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 17086 UNION SELECT 0 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` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 17086 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.7 0 /classes/Cart.php:1238 
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` = 5
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 17086) AND (b.`id_shop` = 1) LIMIT 1
 0.7 1 /src/Adapter/EntityMapper.php:75 
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` = 5)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (17086) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.7 2 Yes Yes /classes/Product.php:3887 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 345
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 17086 UNION SELECT 0 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` = 345
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 17086 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.7 0 /classes/Cart.php:1238 
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` = 5)
WHERE i.`id_product` = 18174
ORDER BY `position`
 0.7 6 Yes /classes/Product.php:3059 
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 5)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
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)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5)
WHERE pa.`id_product` = 17086
AND pac.`id_product_attribute` = 345
AND agl.`id_lang` = 5
 0.7 1 /classes/Product.php:6258 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 5
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 613) AND (b.`id_shop` = 1) LIMIT 1
 0.7 1 /src/Adapter/EntityMapper.php:75 
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` = 18174) AND (b.`id_shop` = 1) LIMIT 1
 0.7 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
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)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 18174
 0.7 1 /classes/Product.php:6285 
SELECT SQL_NO_CACHE `cf`.* , `l`.*
FROM `ps_advanced_custom_fields` as `cf`
LEFT JOIN `ps_advanced_custom_fields_lang` as `l` ON `l`.`id_custom_field` = `cf`.`id_custom_field`
WHERE `cf`.`technical_name` = "caracteristiques" AND `l`.`id_lang` = "5"  LIMIT 1
 0.7 56 /modules/advancedcustomfields/models/AdvancedCustomFields.php:259 
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'lilipinso.pixodeo.net' OR su.domain_ssl = 'lilipinso.pixodeo.net')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
 0.7 2 Yes /classes/shop/Shop.php:345 
SELECT SQL_NO_CACHE * FROM ps_appagebuilder_products p
INNER JOIN ps_appagebuilder_products_shop ps on(p.id_appagebuilder_products = ps.id_appagebuilder_products) WHERE  ps.active=1 and ps.id_shop=1 LIMIT 1
 0.7 16 /modules/appagebuilder/classes/ApPageBuilderProductsModel.php:147 
(SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2023-09-29 00:00:00" AND date_to <= "2023-09-29 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2023-09-29 00:00:00" AND date_from <= "2023-09-29 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from < "2023-09-29 00:00:00" AND date_to > "2023-09-29 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
 0.7 1 /classes/CartRule.php:342 
SELECT SQL_NO_CACHE pa.`available_date` FROM `ps_product` p LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) 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) WHERE p.`id_product` = 17083 AND pa.`id_product` = 17083 AND pa.`id_product_attribute` = 343 LIMIT 1
 0.7 1 /classes/Product.php:940 
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` = 5
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 18174) AND (b.`id_shop` = 1) LIMIT 1
 0.7 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
WHERE `table_name` = "ps_advanced_custom_fields" AND `table_schema` = "jz8b2_lilipinso_preprod" AND `column_name` = "display_dashboard" LIMIT 1
 0.7 0 /override/modules/advancedcustomfields/advancedcustomfields.php:2072 
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
 0.7 6 /classes/Language.php:911 
SELECT SQL_NO_CACHE *
FROM `ps_product_attribute` a
LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 343) LIMIT 1
 0.7 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 5
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
 0.7 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1)
WHERE c.`deleted` = 0 AND c.`active` = 1 ORDER BY `iso_code` ASC
 0.7 2 Yes /classes/Currency.php:492 
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
 0.7 1 /src/Adapter/EntityMapper.php:75 
(SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2023-09-29 00:00:00" AND date_to <= "2023-09-29 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2023-09-29 00:00:00" AND date_from <= "2023-09-29 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from < "2023-09-29 00:00:00" AND date_to > "2023-09-29 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
 0.6 1 /classes/CartRule.php:342 
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 5
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 37) LIMIT 1
 0.6 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 18174 AND ctg.`id_group` = 1 LIMIT 1
 0.6 18 /classes/Product.php:5576 
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
 0.6 241 /classes/Tab.php:320 
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 17086
AND (fl.name NOT LIKE "carl_%" AND fl.name NOT LIKE "")
ORDER BY f.position ASC
 0.6 1 Yes /override/classes/Product.php:29 
UPDATE `ps_btmegamenu_group_lang` SET `id_btmegamenu_group` = '4',`title` = 'Dupliquer des Megamenu',`title_fo` = 'Categories',`id_lang` = '4' WHERE id_btmegamenu_group = 4 AND id_lang = 4
 0.6 1 /classes/ObjectModel.php:805 
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (343, 344) AND il.`id_lang` = 5 ORDER by i.`position`
 0.6 5 Yes /classes/Product.php:2492 
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 2) LIMIT 1
 0.6 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE ads.`id_search`, ads.`id_hook`, ads.`unique_search`
FROM `ps_pm_advancedsearch` ads
JOIN `ps_pm_advancedsearch_shop` adss ON (ads.`id_search`=adss.`id_search` AND adss.`id_shop`=1)  WHERE 1  AND ads.`active`=1  ORDER BY ads.`position`
 0.6 3 Yes /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 
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` = 5)
WHERE i.`id_product` = 17086
ORDER BY `position`
 0.6 7 Yes /classes/Product.php:3059 
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 2103361
AND `date_add` > '2023-09-29 12:15:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
 0.6 1 Yes /classes/Connection.php:163 
SELECT SQL_NO_CACHE COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
WHERE `table_name` = "ps_advanced_custom_fields" AND `table_schema` = "jz8b2_lilipinso_preprod" AND `column_name` = "display_at_shop" LIMIT 1
 0.6 0 /override/modules/advancedcustomfields/advancedcustomfields.php:2092 
SELECT SQL_NO_CACHE page from `ps_appagebuilder_page` where id_product = '18174' AND id_shop = '1' LIMIT 1
 0.6 1 /modules/appagebuilder/appagebuilder.php:3773 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_hook_module` hm
LEFT JOIN `ps_hook` h ON (h.`id_hook` = hm.`id_hook`)
WHERE h.`name` = 'actionObjectAddressDeleteAfter' AND hm.`id_module` = 94 LIMIT 1
 0.6 2 /classes/module/Module.php:2333 
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (345, 346) AND il.`id_lang` = 5 ORDER by i.`position`
 0.6 7 Yes /classes/Product.php:2492 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 18174 AND `id_shop` = 1
 0.6 3 /src/Adapter/EntityMapper.php:82 
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` = 17086)
 0.6 2 /classes/Product.php:3364 
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` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 18174) AND (b.`id_shop` = 1) LIMIT 1
 0.6 1 /src/Adapter/EntityMapper.php:75 
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` = 18174)
 0.6 1 /classes/Product.php:3364 
SELECT SQL_NO_CACHE `cf`.* , `l`.*
FROM `ps_advanced_custom_fields` as `cf`
LEFT JOIN `ps_advanced_custom_fields_lang` as `l` ON `l`.`id_custom_field` = `cf`.`id_custom_field`
WHERE `cf`.`technical_name` = "caracteristiques" AND `l`.`id_lang` = "5"  LIMIT 1
 0.6 56 /modules/advancedcustomfields/models/AdvancedCustomFields.php:259 
SELECT SQL_NO_CACHE a.`plist_key` FROM `ps_appagebuilder_details` AS a INNER JOIN `ps_appagebuilder_details_shop` AS b ON a.`id_appagebuilder_details` = b.`id_appagebuilder_details` WHERE b.`id_shop` = "1" AND b.`active` = 1 LIMIT 1
 0.6 17 /modules/appagebuilder/appagebuilder.php:3799 
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `locale` = 'en-us' LIMIT 1
 0.6 3 /classes/Language.php:744 
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 3 AND `id_object` = 18174 LIMIT 1
 0.6 1 /classes/Page.php:83 
SELECT SQL_NO_CACHE *
FROM `ps_leofeature_product_review` pc
WHERE pc.`id_product` = 18174
AND pc.`id_customer` = 0
ORDER BY pc.`date_add` DESC LIMIT 1
 0.5 1 Yes /modules/leofeature/classes/ProductReview.php:127 
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
 0.5 9 Yes /classes/ImageType.php:109 
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
 0.5 3 /classes/Language.php:1058 
SELECT SQL_NO_CACHE id_btmegamenu_group FROM `ps_btmegamenu_group`  WHERE randkey IN ('a3cd33404b7873a62c4930db407ff39f') AND id_shop = 1
 0.5 4 /modules/appagebuilder/classes/shortcodes/ApMegamenu.php:149 
SELECT SQL_NO_CACHE `cfc`.`id_custom_field_content`
FROM `ps_advanced_custom_fields_content` as `cfc`
WHERE `cfc`.`id_custom_field` = "23" AND `cfc`.`resource_id` = "18174" AND `cfc`.`id_store` = "1" LIMIT 1
 0.5 2 /modules/advancedcustomfields/models/AdvancedCustomFieldsContent.php:163 
SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC
 0.5 2 Yes /classes/Currency.php:507 
SELECT SQL_NO_CACHE p.id_product
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)
WHERE p.id_product = 18174
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2023-09-29 00:00:00",
INTERVAL 180 DAY
)
) > 0
 0.5 0 /classes/Product.php:1403 
SELECT SQL_NO_CACHE *
FROM `ps_btmegamenu_group` a
WHERE (a.`id_btmegamenu_group` = 4) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:75 
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` = 17083)
 0.5 2 /classes/Product.php:3364 
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 5
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE sp.`id_store`
FROM `ps_store_products` AS sp
LEFT JOIN `ps_store_relocator` AS sl ON (sp.`id_store` = sl.`id`)
WHERE sp.`id_product` = 18174 AND sl.`active` = 1
 0.5 1 /modules/wkstorelocator/classes/StoreProduct.php:55 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 0 LIMIT 1
 0.5 23 /classes/SpecificPrice.php:407 
SELECT SQL_NO_CACHE *
FROM `ps_btmegamenu_group_lang`
WHERE `id_btmegamenu_group` = 4
 0.5 3 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE 1 FROM ps_cart_product cp INNER JOIN ps_product p
ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
 0.5 1 /classes/Cart.php:4055 
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 5
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 5
AND cl.id_shop = 1 
AND cl.`id_category` = 530 LIMIT 1
 0.5 1 /classes/Category.php:1369 
SELECT SQL_NO_CACHE 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 = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 17086 LIMIT 1
 0.5 2 /classes/Product.php:861 
SELECT SQL_NO_CACHE *
FROM `ps_currency_lang`
WHERE `id_currency` = 2
 0.5 3 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `ps_tax_lang`
WHERE `id_tax` = 354
 0.5 3 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE *
FROM `ps_product_attribute` a
LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 345) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE 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 = 1)
WHERE pa.id_product = 18174 LIMIT 1
 0.5 1 /classes/Product.php:847 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "leobootstrapmenu" LIMIT 1
 0.5 1 /classes/module/Module.php:2786 
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 17083 AND ctg.`id_group` = 1 LIMIT 1
 0.5 15 /classes/Product.php:5576 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_hook_module` hm
LEFT JOIN `ps_hook` h ON (h.`id_hook` = hm.`id_hook`)
WHERE h.`name` = 'additionalCustomerAddressFields' AND hm.`id_module` = 94 LIMIT 1
 0.5 2 /classes/module/Module.php:2333 
SELECT SQL_NO_CACHE sp.`id_store`
FROM `ps_store_products` AS sp
LEFT JOIN `ps_store_relocator` AS sl ON (sp.`id_store` = sl.`id`)
WHERE sp.`id_product` = 18174 AND sl.`active` = 1
 0.5 1 /modules/wkstorelocator/classes/StoreProduct.php:55 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_languageselector" LIMIT 1
 0.5 1 /classes/module/Module.php:2786 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 18174
 0.5 1 /classes/Product.php:2473 
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'product' LIMIT 1
 0.5 1 /classes/Page.php:104 
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
 0.5 83 /classes/Hook.php:238 
SELECT SQL_NO_CACHE count(distinct id_address_delivery)
FROM `ps_cart_product` cp
WHERE (id_cart = 0) LIMIT 1
 0.5 1 /classes/Cart.php:3070 
SELECT SQL_NO_CACHE `cfc`.`id_custom_field_content`
FROM `ps_advanced_custom_fields_content` as `cfc`
WHERE `cfc`.`id_custom_field` = "23" AND `cfc`.`resource_id` = "18174" AND `cfc`.`id_store` = "1" LIMIT 1
 0.5 2 /modules/advancedcustomfields/models/AdvancedCustomFieldsContent.php:163 
SELECT SQL_NO_CACHE n.key, n.value, n.id_shop, n.id_shop_group
FROM `ps_bx_notices` n
WHERE (n.id_shop_group IS NULL) AND (n.id_shop IS NULL) AND (n.key="environmentWarning")
 0.5 1 /modules/boxtalconnect/controllers/misc/NoticeController.php:273 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 18174 AND `id_group` = 1 LIMIT 1
 0.5 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18174) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.5 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 60 AND `id_shop` = 1 LIMIT 1
 0.5 1 /classes/module/Module.php:2311 
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 5) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE 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 = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 17083 LIMIT 1
 0.5 2 /classes/Product.php:861 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 13 AND `id_shop` = 1 LIMIT 1
 0.5 1 /classes/module/Module.php:2311 
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
 0.5 2 /classes/Currency.php:858 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_hook_module` hm
LEFT JOIN `ps_hook` h ON (h.`id_hook` = hm.`id_hook`)
WHERE h.`name` = 'actionObjectAddressUpdateAfter' AND hm.`id_module` = 94 LIMIT 1
 0.5 2 /classes/module/Module.php:2333 
SELECT SQL_NO_CACHE *
FROM `ps_advanced_custom_fields_content_lang`
WHERE `id_custom_field_content` = 1703903
 0.5 3 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_hook_module` hm
LEFT JOIN `ps_hook` h ON (h.`id_hook` = hm.`id_hook`)
WHERE h.`name` = 'actionAdminAddressesFormModifier' AND hm.`id_module` = 94 LIMIT 1
 0.5 2 /classes/module/Module.php:2333 
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field
 0.5 1 /classes/ObjectModel.php:1473 
SELECT SQL_NO_CACHE p.id_product
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)
WHERE p.id_product = 18174
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2023-09-29 00:00:00",
INTERVAL 180 DAY
)
) > 0
 0.5 0 /classes/Product.php:1403 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 17083) AND (id_product_attribute = 343) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.5 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
 0.5 83 /classes/Hook.php:264 
SELECT SQL_NO_CACHE *
FROM `ps_tax` a
WHERE (a.`id_tax` = 354) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE sp.`id_store`
FROM `ps_store_products` AS sp
LEFT JOIN `ps_store_relocator` AS sl ON (sp.`id_store` = sl.`id`)
WHERE sp.`id_product` = 18174 AND sl.`active` = 1
 0.5 1 /modules/wkstorelocator/classes/StoreProduct.php:55 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_hook_module` hm
LEFT JOIN `ps_hook` h ON (h.`id_hook` = hm.`id_hook`)
WHERE h.`name` = 'displayAdditionalCustomerAddressFields' AND hm.`id_module` = 94 LIMIT 1
 0.5 2 /classes/module/Module.php:2333 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 18174
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.5 1 /classes/SpecificPrice.php:246 
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 5
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 2) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 17083 AND id_shop=1 LIMIT 1
 0.5 1 /classes/Product.php:5694 
SELECT SQL_NO_CACHE 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 = 1)
WHERE pa.id_product = 17086 LIMIT 1
 0.4 2 /classes/Product.php:847 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 17083 LIMIT 1
 0.4 1 /classes/Pack.php:85 
SELECT SQL_NO_CACHE 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` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 0.4 0 /classes/tax/TaxRulesTaxManager.php:108 
SELECT SQL_NO_CACHE pa.`available_date` FROM `ps_product` p LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) 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) WHERE p.`id_product` = 17086 AND pa.`id_product` = 17086 AND pa.`id_product_attribute` = 345 LIMIT 1
 0.4 1 /classes/Product.php:940 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 5
AND cl.id_shop = 1 
AND cl.`id_category` = 613 LIMIT 1
 0.4 1 /classes/Category.php:1369 
SELECT SQL_NO_CACHE format
FROM `ps_address_format`
WHERE `id_country` = 0 LIMIT 1
 0.4 0 /classes/AddressFormat.php:629 
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=18174
 0.4 1 /classes/Tag.php:229 
SELECT SQL_NO_CACHE *
FROM `ps_stock_available` a
WHERE (a.`id_stock_available` = 3052) LIMIT 1
 0.4 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=18174
 0.4 1 /classes/Tag.php:229 
SELECT SQL_NO_CACHE * FROM `ps_appagebuilder_positions` WHERE id_appagebuilder_positions IN(1,2,3,4)
 0.4 4 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:405 
SELECT SQL_NO_CACHE 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 = 1)
WHERE pa.id_product = 17083 LIMIT 1
 0.4 2 /classes/Product.php:847 
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
 0.4 1 /classes/shop/Shop.php:201 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2023-09-29 00:00:00' AND '2023-09-29 23:59:59' LIMIT 1
 0.4 1 /classes/SpecificPrice.php:358 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 22 AND `id_shop` = 1 LIMIT 1
 0.4 1 /classes/module/Module.php:2311 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_hook_module` hm
LEFT JOIN `ps_hook` h ON (h.`id_hook` = hm.`id_hook`)
WHERE h.`name` = 'actionObjectCustomerAddressAddAfter' AND hm.`id_module` = 94 LIMIT 1
 0.4 2 /classes/module/Module.php:2333 
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
 0.4 1 /classes/Country.php:193 
SELECT SQL_NO_CACHE format
FROM `ps_address_format`
WHERE `id_country` = 8 LIMIT 1
 0.4 1 /classes/AddressFormat.php:629 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 18174 LIMIT 1
 0.4 1 /classes/Pack.php:85 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `to` BETWEEN '2023-09-29 00:00:00' AND '2023-09-29 23:59:59' LIMIT 1
 0.4 1 /classes/SpecificPrice.php:362 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 5 AND id_category = 613 LIMIT 1
 0.4 1 /classes/Product.php:4762 
SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "ps_categorytree"
AND ms.`id_shop` IN (1) LIMIT 1
 0.4 1 /src/Adapter/Module/ModuleDataProvider.php:174 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 17083
 0.4 2 /classes/Product.php:2473 
SELECT SQL_NO_CACHE product_attribute_shop.`price`
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)
WHERE pa.`id_product_attribute` = 345 LIMIT 1
 0.4 1 /classes/Combination.php:456 
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg,
MIN(pc.`grade`) AS min,
MAX(pc.`grade`) AS max
FROM `ps_leofeature_product_review` pc
WHERE pc.`id_product` = 18174
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
 0.4 1 /modules/leofeature/classes/ProductReview.php:172 
SELECT SQL_NO_CACHE `name` FROM `ps_supplier` WHERE `id_supplier` = 0 LIMIT 1
 0.4 0 /classes/Supplier.php:244 
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'en' LIMIT 1
 0.4 3 /classes/Language.php:722 
SELECT SQL_NO_CACHE location
FROM `ps_stock_available`
WHERE (id_product = 18174) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.4 1 /classes/stock/StockAvailable.php:788 
SELECT SQL_NO_CACHE product_attribute_shop.`price`
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)
WHERE pa.`id_product_attribute` = 343 LIMIT 1
 0.4 1 /classes/Combination.php:456 
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 18174) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.4 1 /classes/stock/StockAvailable.php:735 
SELECT SQL_NO_CACHE * FROM `ps_blocknavtop_files` where `id_store`=1 and `id_lang`=5 LIMIT 1
 0.4 0 /modules/blocknavtop/blocknavtop.php:796 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_hook_module` hm
LEFT JOIN `ps_hook` h ON (h.`id_hook` = hm.`id_hook`)
WHERE h.`name` = 'actionObjectAddressAddAfter' AND hm.`id_module` = 94 LIMIT 1
 0.4 2 /classes/module/Module.php:2333 
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_leofeature_product_review` pc
WHERE pc.`id_product` = 18174
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
 0.4 1 /modules/leofeature/classes/ProductReview.php:184 
SELECT SQL_NO_CACHE c.id_currency
FROM `ps_currency` c
WHERE (deleted = 0) AND (iso_code = 'EUR') LIMIT 1
 0.4 1 /classes/Currency.php:677 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_currencyselector" LIMIT 1
 0.4 1 /classes/module/Module.php:2786 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_hook_module` hm
LEFT JOIN `ps_hook` h ON (h.`id_hook` = hm.`id_hook`)
WHERE h.`name` = 'actionObjectCustomerAddressUpdateAfter' AND hm.`id_module` = 94 LIMIT 1
 0.4 2 /classes/module/Module.php:2333 
SELECT SQL_NO_CACHE * FROM ps_lgseoredirect WHERE (CONCAT("", url_old) = "/en/tapis-forme-animaux/18174-tropica-kid-rug-parrot-pink.html" OR CONCAT("", url_old) LIKE "/en/tapis-forme-animaux/18174-tropica-kid-rug-parrot-pink.html#%") AND id_shop = "1" ORDER BY id DESC LIMIT 1
 0.4 1 /modules/lgseoredirect/lgseoredirect.php:858 
SELECT SQL_NO_CACHE GROUP_CONCAT(a.`id_product_pack`)
FROM `ps_pack` a
WHERE a.`id_product_item` = 18174 LIMIT 1
 0.4 1 /classes/Pack.php:401 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 17086 AND ctg.`id_group` = 1 LIMIT 1
 0.4 15 /classes/Product.php:5576 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 17086 AND `id_group` = 1 LIMIT 1
 0.4 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
 0.4 1 /classes/ObjectModel.php:1610 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_shoppingcart" LIMIT 1
 0.4 1 /classes/module/Module.php:2786 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 17083) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.4 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE id_stock_available
FROM `ps_stock_available`
WHERE (id_product = 18174) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.4 1 /classes/stock/StockAvailable.php:131 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_group`
WHERE `id_group` = 1 LIMIT 1
 0.4 1 /classes/Group.php:151 
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 18174) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.4 1 /classes/stock/StockAvailable.php:760 
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
 0.4 1 /classes/shop/ShopUrl.php:182 
SELECT SQL_NO_CACHE *
FROM `ps_currency_lang`
WHERE `id_currency` = 1
 0.4 3 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 37
AND `active` = 1 LIMIT 1
 0.4 1 /classes/Manufacturer.php:312 
SELECT SQL_NO_CACHE id_shop
FROM `ps_product_shop`
WHERE `id_product` = 18174
AND id_shop = 1 LIMIT 1
 0.4 1 /classes/ObjectModel.php:1610 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 17086
 0.4 2 /classes/Product.php:2473 
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 18174) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.4 1 /classes/stock/StockAvailable.php:735 
SELECT SQL_NO_CACHE c.id_currency
FROM `ps_currency` c
WHERE (deleted = 0) AND (iso_code = 'USD') LIMIT 1
 0.4 1 /classes/Currency.php:677 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 64 AND `id_shop` = 1 LIMIT 1
 0.4 1 /classes/module/Module.php:2311 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 4
AND cl.id_shop = 1 
AND cl.`id_category` = 613 LIMIT 1
 0.4 1 /classes/Category.php:1369 
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 18174) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.4 1 /classes/stock/StockAvailable.php:760 
SELECT SQL_NO_CACHE COUNT(*) FROM ps_btmegamenu_group_lang WHERE id_btmegamenu_group = 4 AND id_lang = 5 LIMIT 1
 0.4 1 /classes/ObjectModel.php:804 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "Ps_Emailsubscription" LIMIT 1
 0.4 1 /classes/module/Module.php:2786 
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
 0.4 2 /classes/shop/Shop.php:1164 
SELECT SQL_NO_CACHE n.key, n.value, n.id_shop, n.id_shop_group
FROM `ps_bx_notices` n
WHERE (n.id_shop_group=1) AND (n.id_shop=1) AND (n.key="configurationFailure")
 0.4 0 /modules/boxtalconnect/controllers/misc/NoticeController.php:273 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 17086
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.4 1 /classes/SpecificPrice.php:246 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 18174 AND id_shop=1 LIMIT 1
 0.4 1 /classes/Product.php:5694 
SELECT SQL_NO_CACHE n.key, n.value, n.id_shop, n.id_shop_group
FROM `ps_bx_notices` n
WHERE (n.id_shop_group=1) AND (n.id_shop=1) AND (n.key="setupWizard")
 0.4 0 /modules/boxtalconnect/controllers/misc/NoticeController.php:273 
SELECT SQL_NO_CACHE COUNT(*) FROM ps_btmegamenu_group_lang WHERE id_btmegamenu_group = 4 AND id_lang = 1 LIMIT 1
 0.4 1 /classes/ObjectModel.php:804 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 17 AND `id_shop` = 1 LIMIT 1
 0.4 1 /classes/module/Module.php:2311 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`, c.`level_depth`
FROM `ps_category` c
WHERE (c.`id_category` = 2) LIMIT 1
 0.4 1 /classes/Category.php:1916 
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
 0.4 1 /classes/Country.php:193 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 5 AND id_category = 530 LIMIT 1
 0.4 1 /classes/Product.php:4762 
SELECT SQL_NO_CACHE COUNT(*) FROM ps_btmegamenu_group_lang WHERE id_btmegamenu_group = 4 AND id_lang = 4 LIMIT 1
 0.4 1 /classes/ObjectModel.php:804 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_categorytree" LIMIT 1
 0.4 1 /src/Adapter/Module/ModuleDataProvider.php:198 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 17083
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.4 1 /classes/SpecificPrice.php:246 
SELECT SQL_NO_CACHE *
FROM `ps_advanced_custom_fields_content` a
WHERE (a.`id_custom_field_content` = 1703903) LIMIT 1
 0.4 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
 0.4 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 8
 0.4 3 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 17086) AND (id_product_attribute = 345) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.4 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_searchbar" LIMIT 1
 0.4 1 /classes/module/Module.php:2786 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 17086 LIMIT 1
 0.4 1 /classes/Pack.php:85 
SELECT SQL_NO_CACHE `iso_code`
FROM `ps_country`
WHERE `id_country` = 8 LIMIT 1
 0.4 1 /classes/Country.php:274 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 613 LIMIT 1
 0.4 0 /classes/Category.php:1369 
SELECT SQL_NO_CACHE s.id_shop, s.id_shop_group
FROM `ps_shop` s
WHERE (s.active=1 AND s.deleted=0)
 0.4 2 /modules/boxtalconnect/util/ShopUtil.php:106 
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
 0.4 3 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
 0.4 1 /classes/module/Module.php:2221 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 17086 AND id_shop=1 LIMIT 1
 0.4 1 /classes/Product.php:5694 
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps_country`
WHERE `id_country` = 8 LIMIT 1
 0.4 1 /classes/Country.php:401 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
 0.4 0 /classes/module/Module.php:2786 
SELECT SQL_NO_CACHE COUNT(`id_product_review`) AS "nbr"
FROM `ps_leofeature_product_review` pc
WHERE `id_product` = 18174 AND `validate` = 1 LIMIT 1
 0.4 1 /modules/leofeature/classes/ProductReview.php:231 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "braintreeofficial" LIMIT 1
 0.4 0 /classes/module/Module.php:2786 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.4 0 /classes/module/Module.php:2311 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 27 AND `id_shop` = 1 LIMIT 1
 0.3 1 /classes/module/Module.php:2311 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.3 0 /classes/module/Module.php:2311 
SELECT SQL_NO_CACHE id_product_item, id_product_attribute_item, quantity FROM `ps_pack` where id_product_pack = 18174
 0.3 1 /classes/Pack.php:160 
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps_country`
WHERE `id_country` = 0 LIMIT 1
 0.3 0 /classes/Country.php:401 
SELECT SQL_NO_CACHE n.key, n.value, n.id_shop, n.id_shop_group
FROM `ps_bx_notices` n
WHERE (n.id_shop_group=1) AND (n.id_shop=2) AND (n.key="configurationFailure")
 0.3 0 /modules/boxtalconnect/controllers/misc/NoticeController.php:273 
SELECT SQL_NO_CACHE id_shop
FROM `ps_category_shop`
WHERE `id_category` = 613
AND id_shop = 1 LIMIT 1
 0.3 1 /classes/ObjectModel.php:1610 
SELECT SQL_NO_CACHE `price_display_method`
FROM `ps_group`
WHERE `id_group` = 3 LIMIT 1
 0.3 1 /classes/Group.php:171 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 67 AND `id_shop` = 1 LIMIT 1
 0.3 1 /classes/module/Module.php:2311 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 17083 AND `id_group` = 1 LIMIT 1
 0.3 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps_country`
WHERE `id_country` = 0 LIMIT 1
 0.3 0 /classes/Country.php:401 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 17086) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.3 1 /classes/stock/StockAvailable.php:444 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 5 AND id_category = 530 LIMIT 1
 0.3 1 /classes/Product.php:4762 
SELECT SQL_NO_CACHE * FROM `ps_image_type`
 0.3 9 /classes/ImageType.php:147 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "leoquicklogin" LIMIT 1
 0.3 1 /classes/module/Module.php:2786 
SELECT SQL_NO_CACHE location
FROM `ps_stock_available`
WHERE (id_product = 18174) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.3 1 /classes/stock/StockAvailable.php:788 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 613 LIMIT 1
 0.3 1 /classes/Category.php:1369 
SELECT SQL_NO_CACHE `minimal_quantity`
FROM `ps_product_attribute_shop` pas
WHERE `id_shop` = 1
AND `id_product_attribute` = 343 LIMIT 1
 0.3 1 /classes/Attribute.php:289 
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 5
AND id_shop = 1 LIMIT 1
 0.3 1 /classes/ObjectModel.php:1610 
SELECT SQL_NO_CACHE `minimal_quantity`
FROM `ps_product_attribute_shop` pas
WHERE `id_shop` = 1
AND `id_product_attribute` = 345 LIMIT 1
 0.3 1 /classes/Attribute.php:289 
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'home_default' LIMIT 1
 0.3 1 /classes/Image.php:504 
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'medium_default' LIMIT 1
 0.3 1 /classes/Image.php:504 
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
 0.3 1 /classes/ObjectModel.php:1610 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 31 AND `id_shop` = 1 LIMIT 1
 0.3 1 /classes/module/Module.php:2311 
SELECT SQL_NO_CACHE COUNT(*) FROM ps_shop LIMIT 1
 0.3 2 /classes/shop/Shop.php:1165 
SELECT SQL_NO_CACHE n.key, n.value, n.id_shop, n.id_shop_group
FROM `ps_bx_notices` n
WHERE (n.id_shop_group=1) AND (n.id_shop=2) AND (n.key="setupWizard")
 0.3 0 /modules/boxtalconnect/controllers/misc/NoticeController.php:273 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "pagesnotfound" LIMIT 1
 0.3 1 /classes/module/Module.php:2786

Doubles

10
SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
7
                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
5
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
5
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
5
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
5
			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
3
                SELECT name, value, pf.id_feature
				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
				AND (fl.name NOT LIKE "carl_%" AND fl.name NOT LIKE "")
				ORDER BY f.position ASC
3
            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`
3
SELECT `id_product_attribute`
            FROM `ps_product_attribute`
            WHERE `id_product` = XX
3
SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
3
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
3
SELECT COUNT(*) FROM `ps_pack` WHERE id_product_pack = XX LIMIT XX
3
SELECT sp.`id_store`
            FROM `ps_store_products` AS sp
            LEFT JOIN `ps_store_relocator` AS sl ON (sp.`id_store` = sl.`id`)
            WHERE sp.`id_product` = XX AND sl.`active` = XX
3
                SELECT ctg.`id_group`
                FROM `ps_category_product` cp
                INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
                WHERE cp.`id_product` = XX AND ctg.`id_group` = XX LIMIT XX
3
				SELECT `priority`, `id_specific_price_priority`
				FROM `ps_specific_price_priority`
				WHERE `id_product` = XX
				ORDER BY `id_specific_price_priority` DESC LIMIT XX
3
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)
3
                            SELECT `id_tax_rules_group`
                            FROM `ps_product_shop`
                            WHERE `id_product` = XX AND id_shop=XX LIMIT XX
3
			SELECT `reduction`
			FROM `ps_product_group_reduction_cache`
			WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
3
SELECT *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = XX
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
3
			SELECT `need_identification_number`
			FROM `ps_country`
			WHERE `id_country` = XX LIMIT XX
3
SELECT COUNT(*) FROM ps_btmegamenu_group_lang WHERE id_btmegamenu_group = XX AND id_lang = XX LIMIT XX
2
SELECT *
							FROM `ps_currency_lang`
							WHERE `id_currency` = XX
2
SELECT *
FROM `ps_currency` a
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 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 product_attribute_shop.default_on = XX  AND pa.id_product = XX LIMIT XX
2
SELECT n.key, n.value, n.id_shop, n.id_shop_group
FROM `ps_bx_notices` n
WHERE (n.id_shop_group=XX) AND (n.id_shop=XX) AND (n.key="setupWizard")
2
			SELECT `id_country`
			FROM `ps_country`
			WHERE `iso_code` = 'US' AND active = XX LIMIT 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 n.key, n.value, n.id_shop, n.id_shop_group
FROM `ps_bx_notices` n
WHERE (n.id_shop_group=XX) AND (n.id_shop=XX) AND (n.key="configurationFailure")
2
				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 SQL_NO_CACHE * FROM `ps_cart_rule` cr
				LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = XX) WHERE cr.`id_customer` = XX  AND NOW() BETWEEN cr.date_from AND cr.date_to
				AND cr.`active` = XX
				AND cr.`quantity` > XX AND highlight = XX AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * FROM `ps_cart_rule` cr
				LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = XX) WHERE cr.`group_restriction` = XX  AND NOW() BETWEEN cr.date_from AND cr.date_to
				AND cr.`active` = XX
				AND cr.`quantity` > XX AND highlight = XX AND code NOT LIKE "BO_ORDER_%")
2
        SELECT t.`id_lang`, t.`name`
        FROM ps_tag t
        LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
        WHERE pt.`id_product`=XX
2
SELECT out_of_stock
FROM `ps_stock_available`
WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
2
SELECT depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
2
SELECT location
FROM `ps_stock_available`
WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
2
            SELECT p.id_product
            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)
            WHERE p.id_product = XX
            AND DATEDIFF(
                product_shop.`date_add`,
                DATE_SUB(
                    "XX-XX-XX XX:XX:XX",
                    INTERVAL XX DAY
                )
            ) > XX
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 product_attribute_shop.`price`
			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_attribute` = XX LIMIT XX
2
SELECT *
FROM `ps_product_attribute` a
LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = XX
WHERE (a.`id_product_attribute` = XX) LIMIT XX
2
			SELECT format
			FROM `ps_address_format`
			WHERE `id_country` = XX LIMIT XX
2
SELECT *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = XX
WHERE (a.`id_lang` = XX) LIMIT XX
2
SELECT `cfc`.`id_custom_field_content`
                FROM `ps_advanced_custom_fields_content` as `cfc`
                WHERE `cfc`.`id_custom_field` = "XX" AND `cfc`.`resource_id` = "XX" AND `cfc`.`id_store` = "XX" LIMIT XX
2
SELECT `cf`.* , `l`.*
                FROM `ps_advanced_custom_fields` as `cf`
                LEFT JOIN `ps_advanced_custom_fields_lang` as `l` ON `l`.`id_custom_field` = `cf`.`id_custom_field`
                WHERE `cf`.`technical_name` = "caracteristiques" AND `l`.`id_lang` = "XX"  LIMIT XX
2
			SELECT `minimal_quantity`
			FROM `ps_product_attribute_shop` pas
			WHERE `id_shop` = XX
			AND `id_product_attribute` = XX LIMIT XX
2
                        SELECT * FROM INFORMATION_SCHEMA.COLUMNS
                            WHERE TABLE_SCHEMA = 'jzXXbXX_lilipinso_preprod'
                                AND TABLE_NAME='ps_btmegamenu_lang'
                                AND COLUMN_NAME ='url'
2
SELECT * FROM `ps_hook_alias`
2
            SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend`
            FROM `ps_product_attribute_image` pai
            LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
            LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
            WHERE pai.`id_product_attribute` IN (XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
2
            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;
2
        SELECT DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`eanXX`, pa.`isbn`,pa.`upc`
        FROM `ps_attribute` a
        LEFT JOIN `ps_attribute_lang` al
            ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX)
        LEFT JOIN `ps_attribute_group_lang` agl
            ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX)
        LEFT JOIN `ps_product_attribute_combination` pac
            ON (a.`id_attribute` = pac.`id_attribute`)
        LEFT JOIN `ps_product_attribute` pa
            ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
         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)
         INNER JOIN ps_attribute_shop attribute_shop
        ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = XX)
        WHERE pa.`id_product` = XX
2
			SELECT *, ( IF (`id_group` = XX, XX, XX) +  IF (`id_country` = XX, XX, XX) +  IF (`id_currency` = XX, XX, XX) +  IF (`id_shop` = XX, XX, XX) +  IF (`id_customer` = XX, XX, XX)) AS `score`
				FROM `ps_specific_price`
				WHERE
                `id_shop` IN (XX, XX) AND
                `id_currency` IN (XX, XX) AND
                `id_country` IN (XX, XX) AND
                `id_group` IN (XX, XX) AND `id_product` IN (XX, XX) AND `id_customer` = XX AND `id_product_attribute` IN (XX, XX) AND `id_cart` = XX  AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`)
				AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
2
                        SELECT * FROM INFORMATION_SCHEMA.COLUMNS
                        WHERE TABLE_SCHEMA = 'jzXXbXX_lilipinso_preprod'
                        AND TABLE_NAME='ps_btmegamenu_lang'
2
            SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`eanXX`, pa.`isbn`,pa.`upc`
            FROM `ps_attribute` a
            LEFT JOIN `ps_attribute_lang` al
                ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX)
            LEFT JOIN `ps_product_attribute_combination` pac
                ON (pac.`id_attribute` = a.`id_attribute`)
            LEFT JOIN `ps_product_attribute` pa
                ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
             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)
            LEFT JOIN `ps_attribute_group_lang` agl
                ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX)
            WHERE pa.`id_product` = XX
                AND pac.`id_product_attribute` = XX
                AND agl.`id_lang` = XX
2
SELECT pa.`available_date` FROM `ps_product` p LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN ps_product_shop product_shop
        ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) 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 p.`id_product` = XX AND pa.`id_product` = XX AND pa.`id_product_attribute` = XX LIMIT XX
2
UPDATE `ps_btmegamenu_group_lang` SET `id_btmegamenu_group` = 'XX',`title` = 'Dupliquer des Megamenu',`title_fo` = 'Categories',`id_lang` = 'XX' WHERE id_btmegamenu_group = XX AND id_lang = XX

Tables stress

24 product_attribute_shop
21 module
21 product_attribute
20 module_shop
20 product
19 product_shop
15 stock_available
13 category_lang
12 hook
12 cart_product
12 cart_rule
11 specific_price
11 country
10 pack
10 hook_module
9 currency
7 product_attribute_combination
7 attribute
7 currency_shop
7 product_lang
7 attribute_lang
6 lang
6 shop
6 cart_rule_lang
6 image_lang
5 leofeature_product_review
5 attribute_group_lang
5 image
5 lang_shop
5 bx_notices
5 country_lang
5 category
4 shop_url
4 category_shop
4 btmegamenu_group_lang
4 category_group
4 country_shop
4 store_relocator
4 image_shop
4 currency_lang
4 image_type
3 store_products
3 feature_value_lang
3 feature_product
3 attribute_group
3 attribute_shop
3 feature_shop
3 feature_lang
3 advanced_custom_fields_content
3 feature
3 category_product
3 group
3 product_group_reduction_cache
3 specific_price_priority
3 hook_alias
3 manufacturer
3 redirect
2 product_tag
2 address_format
2 tag
2 btmegamenu_group
2 product_attribute_image
2 configuration
2 advanced_custom_fields_lang
2 advanced_custom_fields
2 group_shop
2 leofeature_product_review_usefulness
2 tax_rule
2 tax_rules_group
2 shop_group
1 appagebuilder_products_shop
1 ppb_block_lang
1 appagebuilder_products
1 page_type
1 connections
1 customer
1 appagebuilder_lang
1 appagebuilder
1 appagebuilder_shop
1 appagebuilder_positions
1 state
1 configuration_lang
1 pm_advancedsearch_shop
1 advanced_custom_fields_content_lang
1 ppb_block
1 appagebuilder_profiles
1 pm_advancedsearch
1 meta
1 tab
1 tax_lang
1 tax
1 supplier
1 accessory
1 group_lang
1 hook_module_exceptions
1 meta_lang
1 lgseoredirect
1 blocknavtop_files
1 appagebuilder_profiles_shop
1 appagebuilder_page
1 appagebuilder_details
1 appagebuilder_details_shop
1 manufacturer_lang
1 manufacturer_shop
1 appagebuilder_profiles_lang
1 required_field
1 module_group
1 page

ObjectModel instances

NameInstancesSource
Product 21 /modules/magicredirect/magicredirect.php [944]
/controllers/front/ProductController.php [98]
/src/Adapter/Image/ImageRetriever.php [63]
/src/Adapter/Image/ImageRetriever.php [63]
/src/Adapter/Image/ImageRetriever.php [63]
/classes/Meta.php [349]
/classes/Link.php [106]
/classes/Link.php [106]
/classes/Link.php [106]
/modules/popuppro/popuppro.php [631]
/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]
/classes/Link.php [106]
/classes/Link.php [106]
/modules/boostmyshopagent/bmsmya.php [222]
Address 11 /classes/Product.php [566]
/classes/Product.php [5713]
/modules/everpsvatnumber/models/EverPsVatNumberTaxManager.php [64]
/classes/Product.php [3310]
/modules/everpsvatnumber/models/EverPsVatNumberTaxManager.php [64]
/controllers/front/ProductController.php [495]
/classes/Product.php [4970]
/classes/shop/Shop.php [467]
/classes/Cart.php [3768]
/classes/Cart.php [3769]
/classes/Product.php [566]
Country 8 /config/config.inc.php [141]
/classes/controller/FrontController.php [341]
/classes/AddressFormat.php [357]
/classes/controller/FrontController.php [1623]
/classes/AddressFormat.php [357]
/classes/AddressFormat.php [357]
/modules/paypal/paypal.php [397]
/modules/paypal/classes/AbstractMethodPaypal.php [71]
Category 6 /controllers/front/ProductController.php [209]
/controllers/front/ProductController.php [1199]
/classes/PrestaShopCollection.php [383]
/classes/PrestaShopCollection.php [383]
/classes/PrestaShopCollection.php [383]
/classes/PrestaShopCollection.php [383]
Currency 5 /src/Adapter/Currency/CurrencyDataProvider.php [101]
/src/Adapter/Currency/CurrencyDataProvider.php [101]
/classes/controller/FrontController.php [345]
/classes/Cart.php [3786]
/modules/ps_currencyselector/ps_currencyselector.php [112]
State 4 /classes/AddressFormat.php [357]
/classes/controller/FrontController.php [1622]
/classes/AddressFormat.php [357]
/classes/AddressFormat.php [357]
Language 3 /config/config.inc.php [194]
/classes/Tools.php [656]
/classes/Tools.php [579]
Combination 3 /classes/Product.php [4948]
/classes/Product.php [4948]
/classes/Product.php [4948]
AddressFormat 3 /classes/controller/FrontController.php [1617]
/classes/Cart.php [3773]
/classes/Cart.php [3774]
ApPageBuilderProfilesModel 2 /modules/appagebuilder/appagebuilder.php [3173]
/modules/appagebuilder/appagebuilder.php [2709]
AdvancedCustomFieldsContentModel 2 /modules/advancedcustomfields/advancedcustomfields.php [233]
/modules/advancedcustomfields/advancedcustomfields.php [233]
LeoWidget 2 /modules/leobootstrapmenu/leobootstrapmenu.php [94]
/modules/leobootstrapmenu/leobootstrapmenu.php [94]
ApPageBuilderModel 2 /modules/appagebuilder/appagebuilder.php [1905]
/modules/appagebuilder/appagebuilder.php [2431]
Manufacturer 2 /controllers/front/ProductController.php [365]
/classes/Link.php [638]
BtmegamenuGroup 1 /modules/leobootstrapmenu/leobootstrapmenu.php [1672]
Configuration 1 /modules/appagebuilder/appagebuilder.php [2127]
Guest 1 /modules/statsdata/statsdata.php [77]
Order 1 /modules/sogecommerce/sogecommerce.php [58]
Carrier 1 /classes/Cart.php [3905]
Shop 1 /config/config.inc.php [119]
StockAvailable 1 /controllers/front/ProductController.php [1084]
Risk 1 /classes/controller/FrontController.php [1587]
Gender 1 /classes/controller/FrontController.php [1584]
Tax 1 /classes/tax/TaxRulesTaxManager.php [115]
Group 1 /classes/Cart.php [245]
Cart 1 /classes/controller/FrontController.php [410]
Customer 1 /config/config.inc.php [220]
ShopGroup 1 /classes/shop/Shop.php [551]
Connection 1 /modules/statsdata/statsdata.php [111]

Included Files

<
#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