Les jus de fruits et sirops

Jus Multi-fruits - Bio & équitable - Ethiquable - 1 l

1 Litre - Brique - ETHIQUABLE - PEROU-EQUATEUR-BRESIL.

3,50 €TTC

Jus Multifruits

 

Cinq coopératives de producteurs d'Amérique latine sont sont réunies autour de ce multifruits : AGROMALPI (mangue) et CEPICAFE (passion) au Pérou, FAPECAFES (goyaves) et UROCAL ( banane) en Equateur et COAGROSOL (orange) au Brésil. Avec chacune d'elles, les produits éthiquables ont défini un prix équitable à partir d'une étude technique réalisée avec les producteurs. Ce prix ne se définit pas en partant du marché mais en partant de la réalité des coopératives. Sa stabilité dans le temps assure les conditions d'un développement économique dans la durée.

Aucun point de fidélité pour ce produit.


Livraison à domicile

La livraison à domicile disponible pour toutes commandes de plus de 29.00 €

> LA P'TITE SELECTION

Load time: 488 ms
Good boy! That's what I call a webserver!
ExecutionLoad time (ms)
config78
constructor0
init75
checkAccess0
setMedia10
postProcess0
initHeader0
initContent259
initFooter36
display31
Hook processing: 245 ms / 17.35 Mb
74 methods called in 43 modules
HookProcessing
displayHeader15.36 Mb in 177 ms
displayTop0.60 Mb in 31 ms
displayRightColumnProduct1.13 Mb in 21 ms
displayTopColumn0.00 Mb in 5 ms
displayProductButtons0.05 Mb in 3 ms
displayFooterProduct0.07 Mb in 3 ms
displayLeftColumnProduct0.09 Mb in 3 ms
displayNav0.03 Mb in 2 ms
displayFooter0.01 Mb in 0 ms
actionProductOutOfStock0.00 Mb in 0 ms
actionObjectAddAfter0.00 Mb in 0 ms
moduleRoutes0.00 Mb in 0 ms
actionObjectConnectionAddAfter0.00 Mb in 0 ms
DisplayOverrideTemplate0.00 Mb in 0 ms
actionDispatcher0.00 Mb in 0 ms
actionFrontControllerSetMedia0.00 Mb in 0 ms
actionObjectGuestAddBefore0.00 Mb in 0 ms
displayProductPriceBlock0.00 Mb in 0 ms
displayProductContent0.00 Mb in 0 ms
displayProductTab0.00 Mb in 0 ms
actionObjectAddBefore0.00 Mb in 0 ms
displayProductDeliveryTime0.00 Mb in 0 ms
actionObjectGuestAddAfter0.00 Mb in 0 ms
displayProductTabContent0.00 Mb in 0 ms
actionObjectConnectionAddBefore0.00 Mb in 0 ms
Memory peak usage: 38.4 Mb
ExecutionMemory (Mb)Total (Mb)
config9.099.2
constructor0.019.2
init7.7417.0
checkAccess0.0017.0
setMedia0.2517.2
postProcess0.0017.2
initHeader0.0017.2
initContent18.4636.3
initFooter0.9238.0
display1.5338.4
Total cache size (in Cache class): 0.00 Mb
DB type: DbPDO
SQL Queries: 108 queries
Time spent querying: 52 ms
Included files: 303
Size of included files: 5.15 Mb
Globals (> 1 Ko only): 1595 Ko
  • _MODULES ≈ 1245.6 Ko
  • _LANG ≈ 189.2 Ko
  • context ≈ 111.2 Ko
  • _SERVER ≈ 21.1 Ko
  • definima_ip_info ≈ 12.5 Ko
  • _MODULE ≈ 4.5 Ko
  • definima_bench_rustart ≈ 3 Ko
  • definima_geoip_reader ≈ 2.5 Ko
Stopwatch (with SQL_NO_CACHE) (total = 108)
Query Time (ms) Rows Filesort Group By Location
INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0')
7.3391in /home/web/lesptitscageots/dev/classes/ObjectModel.php:464

from /classes/ObjectModel.php:425
from /classes/Guest.php:189
from /modules/statsdata/statsdata.php:74
from /classes/Hook.php:509
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:811
from /tools/profiling/Controller.php:233
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active
FROM `ps_hook` h
INNER JOIN `ps_hook_module` hm ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
INNER JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
3.38289Yesin /home/web/lesptitscageots/dev/classes/Hook.php:228

from /classes/Hook.php:266
from /classes/tax/TaxManagerFactory.php:67
from /classes/tax/TaxManagerFactory.php:47
from /classes/Product.php:4570
from /classes/Product.php:475
from /override/classes/Product.php:10
from /controllers/front/ProductController.php:81
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
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`)
3.107765in /home/web/lesptitscageots/dev/classes/Configuration.php:134

from /config/config.inc.php:116
from /index.php:27
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
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 != "displayPayment") 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`
2.8382YesYesin /home/web/lesptitscageots/dev/classes/Hook.php:346

from /tools/profiling/Hook.php:50
from /classes/Dispatcher.php:413
from /classes/Dispatcher.php:230
from /classes/Dispatcher.php:193
from /index.php:28
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('16551', '108', '65760209', '', '1', '1', '2020-08-11 23:27:32')
2.3981in /home/web/lesptitscageots/dev/classes/ObjectModel.php:464

from /classes/Connection.php:154
from /classes/Connection.php:85
from /modules/statsdata/statsdata.php:104
from /classes/Hook.php:509
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:811
from /tools/profiling/Controller.php:233
from /classes/Dispatcher.php:373
from /index.php:28
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`,
MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default,
DATEDIFF(
p.`date_add`,
DATE_SUB(
NOW(),
INTERVAL 20 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_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
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` = 1567 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
1.4361Yesin /home/web/lesptitscageots/dev/classes/Product.php:3260

from /controllers/front/ProductController.php:258
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
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
1.4240in /home/web/lesptitscageots/dev/classes/Hook.php:131

from /classes/tax/TaxManagerFactory.php:67
from /classes/tax/TaxManagerFactory.php:47
from /classes/Product.php:4570
from /classes/Product.php:475
from /override/classes/Product.php:10
from /controllers/front/ProductController.php:81
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
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` = 1  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 27
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.8911YesYesin /home/web/lesptitscageots/dev/classes/Category.php:580

from /controllers/front/ProductController.php:591
from /controllers/front/ProductController.php:233
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
0.8189in /home/web/lesptitscageots/dev/classes/module/Module.php:217

from /modules/socialsharing/socialsharing.php:45
from /classes/module/Module.php:1031
from /classes/Hook.php:463
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:447
from /controllers/front/ProductController.php:176
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`, `description_short`
FROM `ps_product` p
LEFT JOIN `ps_product_lang` pl ON (pl.`id_product` = p.`id_product` AND pl.id_shop = 1 )
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE pl.id_lang = 1
AND pl.id_product = 1567
AND product_shop.active = 1 LIMIT 1
0.741in /home/web/lesptitscageots/dev/classes/Meta.php:250

from /classes/Meta.php:199
from /classes/controller/FrontController.php:290
from /override/classes/controller/FrontController.php:24
from /controllers/front/ProductController.php:78
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
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` = 1567
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.6741YesYesin /home/web/lesptitscageots/dev/classes/Product.php:3171

from /controllers/front/ProductController.php:418
from /controllers/front/ProductController.php:240
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
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 = 1567)
LIMIT 1
0.6111in /home/web/lesptitscageots/dev/classes/ObjectModel.php:217

from /tools/profiling/ObjectModel.php:37
from /classes/Product.php:461
from /override/classes/Product.php:10
from /modules/blockviewed/blockviewed.php:172
from /classes/Hook.php:509
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:447
from /controllers/front/ProductController.php:176
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
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
0.59338Yesin /home/web/lesptitscageots/dev/classes/Dispatcher.php:461

from /classes/Dispatcher.php:230
from /classes/Dispatcher.php:193
from /index.php:28
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.5781in /home/web/lesptitscageots/dev/classes/Language.php:819

from /classes/Language.php:918
from /classes/Dispatcher.php:397
from /classes/Dispatcher.php:221
from /classes/Dispatcher.php:193
from /index.php:28
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.5191Yesin /home/web/lesptitscageots/dev/classes/shop/Shop.php:639

from /classes/shop/Shop.php:789
from /classes/shop/Shop.php:936
from /classes/Connection.php:133
from /classes/Connection.php:85
from /modules/statsdata/statsdata.php:104
from /classes/Hook.php:509
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:811
from /tools/profiling/Controller.php:233
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE pa.`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` = 1567
ORDER BY product_attribute_shop.`price` DESC LIMIT 1
0.5161Yesin /home/web/lesptitscageots/dev/classes/Product.php:2880

from /modules/loyalty/loyalty.php:286
from /classes/Hook.php:509
from /tools/profiling/Hook.php:60
from /controllers/front/ProductController.php:268
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM ps_theme t
LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =2 AND m.page = "product" LIMIT 1
0.511in /home/web/lesptitscageots/dev/classes/Theme.php:181

from /classes/controller/FrontController.php:78
from /classes/controller/Controller.php:135
from /classes/Dispatcher.php:366
from /index.php:28
SELECT SQL_NO_CACHE *
FROM `ps_carrier` a
LEFT JOIN `ps_carrier_shop` `c` ON a.id_carrier = c.id_carrier AND c.id_shop = 1
WHERE (a.id_carrier = 22)
LIMIT 1
0.5031in /home/web/lesptitscageots/dev/classes/ObjectModel.php:217

from /tools/profiling/ObjectModel.php:37
from /classes/Carrier.php:167
from /modules/lncwfreedeliverytease/lncwfreedeliverytease.php:200
from /modules/lncwfreedeliverytease/lncwfreedeliverytease.php:134
from /classes/Hook.php:507
from /tools/profiling/Hook.php:60
from /controllers/front/ProductController.php:268
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
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.4971in /home/web/lesptitscageots/dev/classes/ObjectModel.php:217

from /tools/profiling/ObjectModel.php:37
from /classes/Currency.php:103
from /classes/Currency.php:430
from /classes/Tools.php:433
from /classes/controller/FrontController.php:182
from /override/classes/controller/FrontController.php:24
from /controllers/front/ProductController.php:78
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
0.49386in /home/web/lesptitscageots/dev/classes/Hook.php:183

from /classes/Hook.php:202
from /classes/Hook.php:373
from /tools/profiling/Hook.php:50
from /classes/Dispatcher.php:413
from /classes/Dispatcher.php:230
from /classes/Dispatcher.php:193
from /index.php:28
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 `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC
0.4891Yesin /home/web/lesptitscageots/dev/classes/Currency.php:220

from /classes/controller/FrontController.php:342
from /override/classes/controller/FrontController.php:24
from /controllers/front/ProductController.php:78
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 1
LEFT JOIN `ps_cms_shop` `c` ON a.id_cms = c.id_cms AND c.id_shop = 1
WHERE (a.id_cms = 29)
LIMIT 1
0.4871in /home/web/lesptitscageots/dev/classes/ObjectModel.php:217

from /tools/profiling/ObjectModel.php:37
from /classes/Link.php:242
from /modules/defcookieslaw/defcookieslaw.php:507
from /classes/Hook.php:509
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:448
from /controllers/front/ProductController.php:176
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE *
FROM `ps_tax_rule`
WHERE `id_country` = 8
AND `id_tax_rules_group` = 3
AND `id_state` IN (0, 0)
AND ('0' BETWEEN `zipcode_from` AND `zipcode_to` OR (`zipcode_to` = 0 AND `zipcode_from` IN(0, '0')))
ORDER BY `zipcode_from` DESC, `zipcode_to` DESC, `id_state` DESC, `id_country` DESC
0.4831Yesin /home/web/lesptitscageots/dev/classes/tax/TaxRulesTaxManager.php:90

from /classes/Product.php:4571
from /classes/Product.php:475
from /override/classes/Product.php:10
from /controllers/front/ProductController.php:81
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
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.4721in /home/web/lesptitscageots/dev/classes/Language.php:712

from /config/config.inc.php:122
from /index.php:27
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.4721in /home/web/lesptitscageots/dev/classes/shop/ShopUrl.php:163

from /classes/shop/ShopUrl.php:177
from /classes/Tools.php:200
from /classes/Link.php:52
from /config/config.inc.php:214
from /index.php:27
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 = 'lesptitscageots.definima.net' OR su.domain_ssl = 'lesptitscageots.definima.net')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.4591Yesin /home/web/lesptitscageots/dev/classes/shop/Shop.php:329

from /config/config.inc.php:97
from /index.php:27
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` = 1
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.45512YesYesin /home/web/lesptitscageots/dev/classes/Category.php:769

from /classes/Category.php:721
from /controllers/front/ProductController.php:601
from /controllers/front/ProductController.php:233
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE *, ( IF ('2020-08-11 23:27:32' >= `from` AND '2020-08-11 23:27:32' <= `to`, 1, 0) +  IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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_product` IN (0, 1567)
AND `id_product_attribute` IN (0, 0)
AND `id_shop` IN (0, 1)
AND `id_currency` IN (0, 1)
AND `id_country` IN (0, 8)
AND `id_group` IN (0, 1)
AND `id_customer` IN (0, 0)
AND
(
(`from` = '0000-00-00 00:00:00' OR '2020-08-11 23:27:32' >= `from`)
AND
(`to` = '0000-00-00 00:00:00' OR '2020-08-11 23:27:32' <= `to`)
)
AND id_cart IN (0, 0) 
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1
0.43149Yesin /home/web/lesptitscageots/dev/classes/SpecificPrice.php:237

from /classes/Product.php:2680
from /classes/Product.php:2619
from /classes/Product.php:482
from /override/classes/Product.php:10
from /controllers/front/ProductController.php:81
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "myowndeliveries" LIMIT 1
0.431in /home/web/lesptitscageots/dev/classes/module/Module.php:2229

from /classes/module/Module.php:1929
from /modules/myowndeliveries/controllers/controller.php:84
from /modules/myowndeliveries/myowndeliveries.php:70
from /classes/module/Module.php:1031
from /classes/Hook.php:463
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:447
from /controllers/front/ProductController.php:176
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE *
FROM `ps_tax_rule`
WHERE `id_country` = 8
AND `id_tax_rules_group` = 0
AND `id_state` IN (0, 0)
AND ('0' BETWEEN `zipcode_from` AND `zipcode_to` OR (`zipcode_to` = 0 AND `zipcode_from` IN(0, '0')))
ORDER BY `zipcode_from` DESC, `zipcode_to` DESC, `id_state` DESC, `id_country` DESC
0.411Yesin /home/web/lesptitscageots/dev/classes/tax/TaxRulesTaxManager.php:90

from /classes/Product.php:2804
from /classes/Product.php:2619
from /controllers/front/ProductController.php:313
from /controllers/front/ProductController.php:235
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE *
FROM `ps_zone`
WHERE active = 1
ORDER BY `name` ASC
0.4078Yesin /home/web/lesptitscageots/dev/classes/Zone.php:65

from /modules/lncwfreedeliverytease/lncwfreedeliverytease.php:184
from /modules/lncwfreedeliverytease/lncwfreedeliverytease.php:134
from /classes/Hook.php:507
from /tools/profiling/Hook.php:60
from /controllers/front/ProductController.php:268
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1567
ORDER BY f.position ASC
0.4041Yesin /home/web/lesptitscageots/dev/classes/Product.php:4037

from /classes/Product.php:4044
from /controllers/front/ProductController.php:263
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
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 = 1
LEFT JOIN `ps_manufacturer_shop` `c` ON a.id_manufacturer = c.id_manufacturer AND c.id_shop = 1
WHERE (a.id_manufacturer = 40)
LIMIT 1
0.3951in /home/web/lesptitscageots/dev/classes/ObjectModel.php:217

from /tools/profiling/ObjectModel.php:37
from /classes/Manufacturer.php:103
from /controllers/front/ProductController.php:261
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
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 = 1567) AND (b.id_shop = 1)
LIMIT 1
0.3871in /home/web/lesptitscageots/dev/classes/ObjectModel.php:217

from /tools/profiling/ObjectModel.php:37
from /classes/Product.php:461
from /override/classes/Product.php:10
from /classes/Link.php:102
from /classes/Link.php:547
from /classes/controller/FrontController.php:358
from /override/classes/controller/FrontController.php:24
from /controllers/front/ProductController.php:78
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE *,
( IF ('2020-08-11 23:27:32' >= `from` AND '2020-08-11 23:27:32' <= `to`, 1, 0) +  IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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_product` IN(0, 1567) AND
`id_shop` IN(0, 1) AND
`id_currency` IN(0, 1) AND
`id_country` IN(0, 8) AND
`id_group` IN(0, 1) AND
`id_customer` IN(0, 0)
AND
(
(`from` = '0000-00-00 00:00:00' OR '2020-08-11 23:27:32' >= `from`)
AND
(`to` = '0000-00-00 00:00:00' OR '2020-08-11 23:27:32' <= `to`)
)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC
0.38649Yesin /home/web/lesptitscageots/dev/classes/SpecificPrice.php:300

from /controllers/front/ProductController.php:327
from /controllers/front/ProductController.php:235
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
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.3841in /home/web/lesptitscageots/dev/classes/ObjectModel.php:217

from /tools/profiling/ObjectModel.php:37
from /config/config.inc.php:125
from /index.php:27
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.3831in /home/web/lesptitscageots/dev/classes/ObjectModel.php:217

from /tools/profiling/ObjectModel.php:37
from /classes/Group.php:75
from /classes/Group.php:312
from /classes/Cart.php:173
from /classes/controller/FrontController.php:243
from /override/classes/controller/FrontController.php:24
from /controllers/front/ProductController.php:78
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1567
ORDER BY `position`
0.3752Yesin /home/web/lesptitscageots/dev/classes/Product.php:2461

from /controllers/front/ProductController.php:363
from /controllers/front/ProductController.php:238
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE c.id_category, cl.name, cl.link_rewrite
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.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 c.nleft <= 96
AND c.nright >= 97
AND c.nleft >= 2
AND c.nright <= 133
AND cl.id_lang = 1
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC
0.36867Yesin /home/web/lesptitscageots/dev/classes/Tools.php:1053

from /controllers/front/ProductController.php:578
from /controllers/front/ProductController.php:233
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 1567
ORDER BY `id_specific_price_priority` DESC
LIMIT 1
0.3671in /home/web/lesptitscageots/dev/classes/SpecificPrice.php:190

from /classes/SpecificPrice.php:170
from /classes/SpecificPrice.php:216
from /classes/Product.php:2680
from /classes/Product.php:2619
from /classes/Product.php:482
from /override/classes/Product.php:10
from /controllers/front/ProductController.php:81
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field
0.3491in /home/web/lesptitscageots/dev/classes/ObjectModel.php:1202

from /classes/ObjectModel.php:1209
from /classes/ObjectModel.php:907
from /classes/ObjectModel.php:842
from /classes/ObjectModel.php:260
from /classes/ObjectModel.php:464
from /classes/ObjectModel.php:425
from /classes/Guest.php:189
from /modules/statsdata/statsdata.php:74
from /classes/Hook.php:509
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:811
from /tools/profiling/Controller.php:233
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockcategories" LIMIT 1
0.3381in /home/web/lesptitscageots/dev/classes/module/Module.php:2229

from /classes/module/Module.php:1929
from /controllers/front/ProductController.php:164
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE DISTINCT la.`id_attribute`, la.`url_name` as `attribute`
FROM `ps_attribute` a
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)
LEFT JOIN `ps_layered_indexable_attribute_lang_value` la
ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 1)
WHERE la.`url_name` IS NOT NULL AND la.`url_name` != ''
AND pa.`id_product` = 1567
0.3311in /home/web/lesptitscageots/dev/classes/Product.php:5159

from /controllers/front/ProductController.php:557
from /controllers/front/ProductController.php:243
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
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.331in /home/web/lesptitscageots/dev/classes/Currency.php:444

from /classes/Currency.php:450
from /classes/module/Module.php:2008
from /modules/socialsharing/socialsharing.php:163
from /classes/Hook.php:507
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:447
from /controllers/front/ProductController.php:176
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
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` = 1567
0.311in /home/web/lesptitscageots/dev/classes/Product.php:5221

from /controllers/front/ProductController.php:557
from /controllers/front/ProductController.php:243
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE COUNT(*) FROM ps_pack WHERE id_product_pack = 1567 LIMIT 1
0.3051in /home/web/lesptitscageots/dev/classes/Pack.php:50

from /controllers/front/ProductController.php:180
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
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 = 1567
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
NOW(),
INTERVAL 20 DAY
)
) > 0
0.2990in /home/web/lesptitscageots/dev/classes/Product.php:1148

from /classes/Product.php:477
from /override/classes/Product.php:10
from /controllers/front/ProductController.php:81
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
product_attribute_shop.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` `pa` ON pa.`id_product` = p.`id_product`
LEFT 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` = 1567)
0.2991in /home/web/lesptitscageots/dev/classes/Product.php:2702

from /classes/Product.php:2619
from /classes/Product.php:482
from /override/classes/Product.php:10
from /controllers/front/ProductController.php:81
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE * FROM `ps_product_lang`
WHERE `id_product` = 1567 AND `id_shop` = 1
0.291in /home/web/lesptitscageots/dev/classes/ObjectModel.php:224

from /tools/profiling/ObjectModel.php:37
from /classes/Product.php:461
from /override/classes/Product.php:10
from /modules/blockviewed/blockviewed.php:172
from /classes/Hook.php:509
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:447
from /controllers/front/ProductController.php:176
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1567) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0)
LIMIT 1
0.2811in /home/web/lesptitscageots/dev/classes/stock/StockAvailable.php:360

from /classes/Product.php:5408
from /classes/Product.php:487
from /override/classes/Product.php:10
from /controllers/front/ProductController.php:81
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
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` = 27 LIMIT 1
0.281in /home/web/lesptitscageots/dev/classes/Category.php:899

from /classes/Product.php:491
from /override/classes/Product.php:10
from /classes/Link.php:102
from /classes/Link.php:547
from /classes/controller/FrontController.php:358
from /override/classes/controller/FrontController.php:24
from /controllers/front/ProductController.php:78
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_carrier_tax_rules_group_shop`
WHERE `id_carrier` = 22 AND id_shop=1 LIMIT 1
0.2761in /home/web/lesptitscageots/dev/classes/Carrier.php:983

from /classes/Carrier.php:970
from /classes/Carrier.php:181
from /modules/lncwfreedeliverytease/lncwfreedeliverytease.php:200
from /modules/lncwfreedeliverytease/lncwfreedeliverytease.php:134
from /classes/Hook.php:507
from /tools/profiling/Hook.php:60
from /controllers/front/ProductController.php:268
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` 
FROM `ps_image_type` 
WHERE 
`name` LIKE 'large_Les P\'tits Cageots' LIMIT 1
0.2721in /home/web/lesptitscageots/dev/classes/ImageType.php:141

from /classes/ImageType.php:154
from /controllers/front/ProductController.php:395
from /controllers/front/ProductController.php:238
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.26910in /home/web/lesptitscageots/dev/classes/module/Module.php:1889

from /classes/Hook.php:469
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:447
from /controllers/front/ProductController.php:176
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.id_shop = 1)
LIMIT 1
0.2641in /home/web/lesptitscageots/dev/classes/ObjectModel.php:217

from /tools/profiling/ObjectModel.php:37
from /classes/shop/Shop.php:131
from /classes/shop/Shop.php:392
from /config/config.inc.php:97
from /index.php:27
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 = 1567 LIMIT 1
0.2591in /home/web/lesptitscageots/dev/classes/Product.php:661

from /classes/Product.php:2662
from /classes/Product.php:2619
from /classes/Product.php:482
from /override/classes/Product.php:10
from /controllers/front/ProductController.php:81
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
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 = 1
LEFT JOIN `ps_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1
WHERE (a.id_category = 27) AND (b.id_shop = 1)
LIMIT 1
0.2511in /home/web/lesptitscageots/dev/classes/ObjectModel.php:217

from /tools/profiling/ObjectModel.php:37
from /classes/Category.php:137
from /controllers/front/ProductController.php:163
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE *
FROM `ps_themeconfigurator`
WHERE id_shop = 1 AND id_lang = 1
AND hook = 'footer' AND active = 1
ORDER BY item_order ASC
0.2517Yesin /home/web/lesptitscageots/dev/modules/themeconfigurator/themeconfigurator.php:376

from /modules/themeconfigurator/themeconfigurator.php:359
from /classes/Hook.php:507
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:811
from /tools/profiling/Controller.php:233
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
0.2451in /home/web/lesptitscageots/dev/classes/shop/Shop.php:199

from /classes/shop/Shop.php:133
from /classes/shop/Shop.php:392
from /config/config.inc.php:97
from /index.php:27
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 16551
AND `date_add` > '2020-08-11 22:57:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
0.2391Yesin /home/web/lesptitscageots/dev/classes/Connection.php:135

from /classes/Connection.php:85
from /modules/statsdata/statsdata.php:104
from /classes/Hook.php:509
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:811
from /tools/profiling/Controller.php:233
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 1567
AND image_shop.`cover` = 1 LIMIT 1
0.2362in /home/web/lesptitscageots/dev/classes/Product.php:2481

from /modules/sendtoafriend/sendtoafriend.php:69
from /classes/Hook.php:509
from /tools/profiling/Hook.php:60
from /controllers/front/ProductController.php:267
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
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`=1567
0.2291in /home/web/lesptitscageots/dev/classes/Tag.php:166

from /classes/Product.php:485
from /override/classes/Product.php:10
from /controllers/front/ProductController.php:81
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
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` = 1567 AND ctg.`id_group` = 1 LIMIT 1
0.2282in /home/web/lesptitscageots/dev/classes/Product.php:4447

from /controllers/front/ProductController.php:132
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE * FROM `ps_carrier_lang`
WHERE `id_carrier` = 22 AND `id_shop` = 1
0.22729in /home/web/lesptitscageots/dev/classes/ObjectModel.php:224

from /tools/profiling/ObjectModel.php:37
from /classes/Carrier.php:167
from /modules/lncwfreedeliverytease/lncwfreedeliverytease.php:200
from /modules/lncwfreedeliverytease/lncwfreedeliverytease.php:134
from /classes/Hook.php:507
from /tools/profiling/Hook.php:60
from /controllers/front/ProductController.php:268
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `id_lang`, IF(language_code = 'en-us', 0, LENGTH(language_code)) as found
FROM `ps_lang` 
WHERE LEFT(`language_code`,2) = 'en'
ORDER BY found ASC LIMIT 1
0.2251Yesin /home/web/lesptitscageots/dev/classes/Language.php:656

from /classes/Tools.php:358
from /classes/controller/FrontController.php:160
from /override/classes/controller/FrontController.php:24
from /controllers/front/ProductController.php:78
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
-- --------------------------------------------------------
--
-- Structure de la table `ps_MyOwnDeliveriesCarrier`
--
CREATE TABLE IF NOT EXISTS `ps_myowndeliveries_carrier` (
`id_carrier` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
`email` varchar(64) NOT NULL,
`pscarrier` int(11) NOT NULL,
`priority` int(2) NOT NULL,
`subareas` varchar(256) NOT NULL,
`timeslots` text NOT NULL,
`options` varchar(64) NOT NULL,
`ids_users` varchar(64) NOT NULL,
`reservationStartType` tinyint(1) NOT NULL,
`reservationStartParams` varchar(32) NOT NULL,
`reservationPeriod` int(3) NOT NULL,
PRIMARY KEY (`id_carrier`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
0.2241in /home/web/lesptitscageots/dev/modules/myowndeliveries/controllers/controller.php:102

from /modules/myowndeliveries/controllers/controller.php:84
from /modules/myowndeliveries/myowndeliveries.php:70
from /classes/module/Module.php:1031
from /classes/Hook.php:463
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:447
from /controllers/front/ProductController.php:176
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
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 = 1
LEFT JOIN `ps_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1
WHERE (a.id_category = 93) AND (b.id_shop = 1)
LIMIT 1
0.2071in /home/web/lesptitscageots/dev/classes/ObjectModel.php:217

from /tools/profiling/ObjectModel.php:37
from /classes/Category.php:137
from /classes/Link.php:165
from /classes/Tools.php:1060
from /controllers/front/ProductController.php:578
from /controllers/front/ProductController.php:233
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 40
AND `active` = 1 LIMIT 1
0.2031in /home/web/lesptitscageots/dev/classes/Manufacturer.php:231

from /classes/Product.php:469
from /override/classes/Product.php:10
from /controllers/front/ProductController.php:81
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE *
FROM `ps_theme` a
WHERE (a.id_theme = 2)
LIMIT 1
0.2011in /home/web/lesptitscageots/dev/classes/ObjectModel.php:217

from /tools/profiling/ObjectModel.php:37
from /config/config.inc.php:98
from /index.php:27
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
0.1981in /home/web/lesptitscageots/dev/classes/ObjectModel.php:1259

from /classes/Tools.php:346
from /classes/controller/FrontController.php:160
from /override/classes/controller/FrontController.php:24
from /controllers/front/ProductController.php:78
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE * FROM `ps_tax_lang`
WHERE `id_tax` = 3
0.1911in /home/web/lesptitscageots/dev/classes/ObjectModel.php:224

from /tools/profiling/ObjectModel.php:37
from /classes/tax/TaxRulesTaxManager.php:97
from /classes/Product.php:4571
from /classes/Product.php:475
from /override/classes/Product.php:10
from /controllers/front/ProductController.php:81
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
0.1841in /home/web/lesptitscageots/dev/classes/ObjectModel.php:1259

from /classes/Tools.php:436
from /classes/controller/FrontController.php:182
from /override/classes/controller/FrontController.php:24
from /controllers/front/ProductController.php:78
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE *
FROM `ps_tax` a
WHERE (a.id_tax = 3)
LIMIT 1
0.1841in /home/web/lesptitscageots/dev/classes/ObjectModel.php:217

from /tools/profiling/ObjectModel.php:37
from /classes/tax/TaxRulesTaxManager.php:97
from /classes/Product.php:4571
from /classes/Product.php:475
from /override/classes/Product.php:10
from /controllers/front/ProductController.php:81
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
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.1831in /home/web/lesptitscageots/dev/classes/ObjectModel.php:217

from /tools/profiling/ObjectModel.php:37
from /classes/Language.php:90
from /config/config.inc.php:177
from /index.php:27
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'product' LIMIT 1
0.1761in /home/web/lesptitscageots/dev/classes/Page.php:96

from /classes/Page.php:52
from /classes/Connection.php:147
from /classes/Connection.php:85
from /modules/statsdata/statsdata.php:104
from /classes/Hook.php:509
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:811
from /tools/profiling/Controller.php:233
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `name` FROM `ps_supplier` WHERE `id_supplier` = 0 LIMIT 1
0.1720in /home/web/lesptitscageots/dev/classes/Supplier.php:177

from /classes/Product.php:470
from /override/classes/Product.php:10
from /controllers/front/ProductController.php:81
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE GROUP_CONCAT(a.`id_product_pack`)
FROM `ps_pack` a
WHERE a.`id_product_item` = 1567 LIMIT 1
0.176in /home/web/lesptitscageots/dev/classes/Pack.php:166

from /controllers/front/ProductController.php:248
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.id_shop_group = 1)
LIMIT 1
0.1691in /home/web/lesptitscageots/dev/classes/ObjectModel.php:217

from /tools/profiling/ObjectModel.php:37
from /classes/shop/Shop.php:500
from /config/config.inc.php:148
from /index.php:27
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 = 1567 LIMIT 1
0.1661in /home/web/lesptitscageots/dev/classes/Product.php:672

from /classes/Product.php:2662
from /classes/Product.php:2619
from /classes/Product.php:482
from /override/classes/Product.php:10
from /controllers/front/ProductController.php:81
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` 
FROM `ps_image_type` 
WHERE 
`name` LIKE 'medium_Les P\'tits Cageots' LIMIT 1
0.1651in /home/web/lesptitscageots/dev/classes/ImageType.php:141

from /classes/ImageType.php:154
from /controllers/front/ProductController.php:400
from /controllers/front/ProductController.php:238
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE id_shop
FROM `ps_product_shop`
WHERE `id_product` = 1567
AND id_shop = 1 LIMIT 1
0.1641in /home/web/lesptitscageots/dev/classes/ObjectModel.php:1259

from /controllers/front/ProductController.php:98
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 7 AND `id_shop` = 1 LIMIT 1
0.1621in /home/web/lesptitscageots/dev/classes/module/Module.php:1952

from /controllers/front/ProductController.php:164
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 8 AND `id_object` = 1567 LIMIT 1
0.1591in /home/web/lesptitscageots/dev/classes/Page.php:78

from /classes/Connection.php:147
from /classes/Connection.php:85
from /modules/statsdata/statsdata.php:104
from /classes/Hook.php:509
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:811
from /tools/profiling/Controller.php:233
from /classes/Dispatcher.php:373
from /index.php:28
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 = 1567 LIMIT 1
0.1581in /home/web/lesptitscageots/dev/classes/Product.php:683

from /classes/Product.php:2662
from /classes/Product.php:2619
from /classes/Product.php:482
from /override/classes/Product.php:10
from /controllers/front/ProductController.php:81
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 2 LIMIT 1
0.1571in /home/web/lesptitscageots/dev/classes/Category.php:1276

from /classes/Category.php:1294
from /controllers/front/ProductController.php:577
from /controllers/front/ProductController.php:233
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE id_shop
FROM `ps_category_shop`
WHERE `id_category` = 27
AND id_shop = 1 LIMIT 1
0.1571in /home/web/lesptitscageots/dev/classes/ObjectModel.php:1259

from /controllers/front/ProductController.php:577
from /controllers/front/ProductController.php:233
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` 
FROM `ps_image_type` 
WHERE 
`name` LIKE 'Les P\'tits Cageots_large' LIMIT 1
0.1561in /home/web/lesptitscageots/dev/classes/ImageType.php:141

from /classes/ImageType.php:156
from /controllers/front/ProductController.php:395
from /controllers/front/ProductController.php:238
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
0.1551in /home/web/lesptitscageots/dev/classes/ObjectModel.php:1259

from /classes/Group.php:314
from /classes/Cart.php:173
from /classes/controller/FrontController.php:243
from /override/classes/controller/FrontController.php:24
from /controllers/front/ProductController.php:78
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
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 = 1567 LIMIT 1
0.1551in /home/web/lesptitscageots/dev/classes/Product.php:693

from /classes/Product.php:2662
from /classes/Product.php:2619
from /classes/Product.php:482
from /override/classes/Product.php:10
from /controllers/front/ProductController.php:81
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE * FROM `ps_group_lang`
WHERE `id_group` = 1
0.1541in /home/web/lesptitscageots/dev/classes/ObjectModel.php:224

from /tools/profiling/ObjectModel.php:37
from /classes/Group.php:75
from /classes/Group.php:312
from /classes/Cart.php:173
from /classes/controller/FrontController.php:243
from /override/classes/controller/FrontController.php:24
from /controllers/front/ProductController.php:78
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` 
FROM `ps_image_type` 
WHERE 
`name` LIKE 'Les P\'tits Cageots_cart' LIMIT 1
0.1471in /home/web/lesptitscageots/dev/classes/ImageType.php:141

from /classes/ImageType.php:156
from /controllers/front/ProductController.php:403
from /controllers/front/ProductController.php:238
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
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` = 27 LIMIT 1
0.1460in /home/web/lesptitscageots/dev/classes/Category.php:899

from /classes/Product.php:491
from /override/classes/Product.php:10
from /modules/blockviewed/blockviewed.php:172
from /classes/Hook.php:509
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:447
from /controllers/front/ProductController.php:176
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'large_default'
LIMIT 1
0.1461in /home/web/lesptitscageots/dev/classes/Image.php:377

from /controllers/front/ProductController.php:395
from /controllers/front/ProductController.php:238
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` 
FROM `ps_image_type` 
WHERE 
`name` LIKE 'Les P\'tits Cageots_medium' LIMIT 1
0.1451in /home/web/lesptitscageots/dev/classes/ImageType.php:141

from /classes/ImageType.php:156
from /controllers/front/ProductController.php:400
from /controllers/front/ProductController.php:238
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` 
FROM `ps_image_type` 
WHERE 
`name` LIKE 'cart_Les P\'tits Cageots' LIMIT 1
0.1431in /home/web/lesptitscageots/dev/classes/ImageType.php:141

from /classes/ImageType.php:154
from /controllers/front/ProductController.php:403
from /controllers/front/ProductController.php:238
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blocklayered" LIMIT 1
0.1421in /home/web/lesptitscageots/dev/classes/module/Module.php:2229

from /classes/module/Module.php:1929
from /classes/Product.php:5146
from /controllers/front/ProductController.php:557
from /controllers/front/ProductController.php:243
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 1567 AND `id_group` = 1 LIMIT 1
0.1410in /home/web/lesptitscageots/dev/classes/GroupReduction.php:142

from /classes/Product.php:2773
from /classes/Product.php:2619
from /classes/Product.php:482
from /override/classes/Product.php:10
from /controllers/front/ProductController.php:81
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` 
FROM `ps_image_type` 
WHERE 
`name` LIKE 'home_Les P\'tits Cageots' LIMIT 1
0.1381in /home/web/lesptitscageots/dev/classes/ImageType.php:141

from /classes/ImageType.php:154
from /controllers/front/ProductController.php:402
from /controllers/front/ProductController.php:238
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'cart_default'
LIMIT 1
0.1371in /home/web/lesptitscageots/dev/classes/Image.php:377

from /controllers/front/ProductController.php:403
from /controllers/front/ProductController.php:238
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` 
FROM `ps_image_type` 
WHERE 
`name` LIKE 'Les P\'tits Cageots_home' LIMIT 1
0.1341in /home/web/lesptitscageots/dev/classes/ImageType.php:141

from /classes/ImageType.php:156
from /controllers/front/ProductController.php:402
from /controllers/front/ProductController.php:238
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 1567) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0)
LIMIT 1
0.1331in /home/web/lesptitscageots/dev/classes/stock/StockAvailable.php:665

from /classes/Product.php:5410
from /classes/Product.php:487
from /override/classes/Product.php:10
from /controllers/front/ProductController.php:81
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1
0.1311in /home/web/lesptitscageots/dev/classes/module/Module.php:1952

from /classes/Product.php:5146
from /controllers/front/ProductController.php:557
from /controllers/front/ProductController.php:243
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1567) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0)
LIMIT 1
0.1291in /home/web/lesptitscageots/dev/classes/stock/StockAvailable.php:688

from /classes/Product.php:5409
from /classes/Product.php:487
from /override/classes/Product.php:10
from /controllers/front/ProductController.php:81
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'medium_default'
LIMIT 1
0.1271in /home/web/lesptitscageots/dev/classes/Image.php:377

from /controllers/front/ProductController.php:400
from /controllers/front/ProductController.php:238
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'home_default'
LIMIT 1
0.1241in /home/web/lesptitscageots/dev/classes/Image.php:377

from /controllers/front/ProductController.php:402
from /controllers/front/ProductController.php:238
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 1567 AND id_shop=1 LIMIT 1
0.1191in /home/web/lesptitscageots/dev/classes/Product.php:4557

from /classes/Product.php:2744
from /classes/Product.php:2619
from /classes/Product.php:482
from /override/classes/Product.php:10
from /controllers/front/ProductController.php:81
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE `reduction`
FROM `ps_group`
WHERE `id_group` = 1 LIMIT 1
0.1181in /home/web/lesptitscageots/dev/classes/Group.php:132

from /classes/Product.php:2777
from /classes/Product.php:2619
from /classes/Product.php:482
from /override/classes/Product.php:10
from /controllers/front/ProductController.php:81
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 27 LIMIT 1
0.1111in /home/web/lesptitscageots/dev/classes/Category.php:1276

from /classes/Tools.php:1036
from /controllers/front/ProductController.php:578
from /controllers/front/ProductController.php:233
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
Doubles (IDs replaced by "XX") (total = 5)
2 SELECT nleft, nright, level_depth FROM ps_category WHERE id_category = XX LIMIT XX
2 SELECT * FROM `ps_tax_rule` WHERE `id_country` = XX AND `id_tax_rules_group` = XX AND `id_state` IN (XX, XX) AND ('XX' BETWEEN `zipcode_from` AND `zipcode_to` OR (`zipcode_to` = XX AND `zipcode_from` IN(XX, 'XX'))) ORDER BY `zipcode_from` DESC, `zipcode_to` DESC, `id_state` DESC, `id_country` DESC
2 SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = XX LEFT JOIN `ps_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = XX WHERE (a.id_category = XX) AND (b.id_shop = XX) LIMIT XX
2 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
2 SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
Tables stress
12 image_type
9 product_attribute
9 product_attribute_shop
8 product_shop
8 category_lang
7 category
6 category_shop
6 module
6 product
5 module_shop
5 stock_available
4 currency_shop
4 lang
4 product_lang
4 lang_shop
4 shop_url
4 shop
4 hook
3 currency
3 image_shop
3 attribute
3 theme
3 product_attribute_combination
3 manufacturer
3 image
2 specific_price
2 pack
2 attribute_group_lang
2 image_lang
2 attribute_shop
2 category_group
2 tax_rule
2 meta
2 hook_alias
2 hook_module
2 shop_group
2 group_shop
2 group
2 attribute_lang
1 themeconfigurator
1 carrier_tax_rules_group_shop
1 zone
1 feature_value_lang
1 feature
1 page_type
1 connections
1 required_field
1 carrier_lang
1 accessory
1 carrier
1 feature_product
1 page
1 manufacturer_shop
1 feature_shop
1 feature_lang
1 manufacturer_lang
1 carrier_shop
1 layered_indexable_attribute_lang_value
1 tag
1 module_group
1 meta_lang
1 theme_meta
1 group_lang
1 country_shop
1 country_lang
1 configuration
1 configuration_lang
1 country
1 supplier
1 tax
1 hook_module_exceptions
1 cms
1 cms_lang
1 cms_shop
1 category_product
1 product_tag
1 tax_lang
1 specific_price_priority
1 product_group_reduction_cache
1 attribute_group
ObjectModel instances
NameInstanceSource
Address8
classes/Product.php [475]
classes/Product.php [4568]
classes/Product.php [2650]
controllers/front/ProductController.php [310]
classes/Product.php [4568]
classes/tax/Tax.php [200]
controllers/front/ProductController.php [343]
classes/Product.php [4568]
Product5
classes/Link.php [102]
controllers/front/ProductController.php [81]
modules/blockviewed/blockviewed.php [172]
modules/sendtoafriend/sendtoafriend.php [68]
modules/loyalty/loyalty.php [266]
Category4
controllers/front/ProductController.php [163]
classes/Link.php [165]
classes/Link.php [165]
classes/Link.php [165]
Currency2
classes/Tools.php [433]
modules/lncwfreedeliverytease/lncwfreedeliverytease.php [178]
Language2
config/config.inc.php [177]
classes/Tools.php [345]
CMS1
classes/Link.php [242]
Manufacturer1
controllers/front/ProductController.php [261]
Connection1
modules/statsdata/statsdata.php [104]
Guest1
modules/statsdata/statsdata.php [74]
Carrier1
modules/lncwfreedeliverytease/lncwfreedeliverytease.php [200]
Tax1
classes/tax/TaxRulesTaxManager.php [97]
Group1
classes/Cart.php [173]
Country1
config/config.inc.php [125]
Theme1
config/config.inc.php [98]
ShopGroup1
classes/shop/Shop.php [500]
Customer1
config/config.inc.php [202]
Cart1
classes/controller/FrontController.php [243]
Shop1
config/config.inc.php [97]
Included files
#Filename
1home/definima/php/monitoring/google-analytics.php
2home/definima/php/monitoring/geolite/Db/Reader.php
3home/definima/php/monitoring/geolite/Db/MaxMindReader/Decoder.php
4home/definima/php/monitoring/geolite/Db/MaxMindReader/InvalidDatabaseException.php
5home/definima/php/monitoring/geolite/Db/MaxMindReader/Metadata.php
6home/definima/php/monitoring/geolite/Db/MaxMindReader/Util.php
7./index.php
8config/config.inc.php
9config/defines.inc.php
10config/settings.inc.php
11config/autoload.php
12config/alias.php
13classes/PrestaShopAutoload.php
14cache/class_index.php
15tools/profiling/Controller.php
16classes/controller/Controller.php
17tools/profiling/ObjectModel.php
18classes/ObjectModel.php
19tools/profiling/Hook.php
20classes/Hook.php
21tools/profiling/Db.php
22classes/db/Db.php
23tools/profiling/Tools.php
24classes/Tools.php
25classes/Context.php
26classes/shop/Shop.php
27config/db_slave_server.inc.php
28classes/db/DbPDO.php
29classes/cache/Cache.php
30classes/Validate.php
31override/classes/Validate.php
32classes/db/DbQuery.php
33classes/Theme.php
34config/defines_uri.inc.php
35classes/Configuration.php
36tools/htmlpurifier/HTMLPurifier.standalone.php
37classes/Language.php
38classes/Country.php
39classes/PrestaShopCollection.php
40classes/shop/ShopGroup.php
41classes/Cookie.php
42classes/Rijndael.php
43classes/Customer.php
44classes/Group.php
45classes/Link.php
46override/classes/Link.php
47override/classes/PhpThumb/ThumbLib.inc.php
48override/classes/PhpThumb/PhpThumb.inc.php
49override/classes/PhpThumb/ThumbBase.inc.php
50override/classes/PhpThumb/GdThumb.inc.php
51classes/shop/ShopUrl.php
52config/smarty.config.inc.php
53tools/smarty/Smarty.class.php
54tools/smarty/sysplugins/smarty_internal_data.php
55tools/smarty/sysplugins/smarty_internal_templatebase.php
56tools/smarty/sysplugins/smarty_internal_template.php
57tools/smarty/sysplugins/smarty_resource.php
58tools/smarty/sysplugins/smarty_internal_resource_file.php
59tools/smarty/sysplugins/smarty_cacheresource.php
60tools/smarty/sysplugins/smarty_internal_cacheresource_file.php
61config/smartyfront.config.inc.php
62classes/Dispatcher.php
63tools/mobile_Detect/Mobile_Detect.php
64controllers/front/ProductController.php
65classes/controller/FrontController.php
66override/classes/controller/FrontController.php
67override/controllers/front/ProductController.php
68themes/lesptitscageots/lang/fr.php
69classes/Currency.php
70classes/Cart.php
71override/classes/Cart.php
72classes/CartRule.php
73classes/Meta.php
74classes/Product.php
75override/classes/Product.php
76classes/webservice/WebserviceRequest.php
77classes/Category.php
78classes/Manufacturer.php
79classes/Supplier.php
80classes/Address.php
81classes/tax/TaxManagerFactory.php
82classes/tax/TaxRulesTaxManager.php
83classes/tax/TaxManagerInterface.php
84classes/tax/Tax.php
85classes/tax/TaxCalculator.php
86classes/Combination.php
87classes/SpecificPrice.php
88classes/GroupReduction.php
89classes/Tag.php
90classes/stock/StockAvailable.php
91classes/module/Module.php
92override/classes/module/Module.php
93classes/Media.php
94modules/socialsharing/socialsharing.php
95classes/Translate.php
96themes/lesptitscageots/modules/socialsharing/translations/fr.php
97modules/socialsharing/translations/fr.php
98cache/smarty/cache/socialsharing_header/1567/1/8/de/90/4e/de904e47fc9bd13615972e79d891642fddf1409b.socialsharing_header.tpl.php
99modules/blockbanner/blockbanner.php
100themes/lesptitscageots/modules/blockbanner/translations/fr.php
101modules/blockbanner/translations/fr.php
102modules/blockbestsellers/blockbestsellers.php
103themes/lesptitscageots/modules/blockbestsellers/translations/fr.php
104modules/blockbestsellers/translations/fr.php
105modules/blockcart/blockcart.php
106themes/lesptitscageots/modules/blockcart/translations/fr.php
107modules/blockcart/translations/fr.php
108modules/blockcategories/blockcategories.php
109themes/lesptitscageots/modules/blockcategories/translations/fr.php
110modules/blockcategories/translations/fr.php
111modules/blockcurrencies/blockcurrencies.php
112themes/lesptitscageots/modules/blockcurrencies/translations/fr.php
113modules/blockcurrencies/translations/fr.php
114modules/blockfacebook/blockfacebook.php
115themes/lesptitscageots/modules/blockfacebook/translations/fr.php
116modules/blockfacebook/translations/fr.php
117modules/blocklanguages/blocklanguages.php
118themes/lesptitscageots/modules/blocklanguages/translations/fr.php
119modules/blocklanguages/translations/fr.php
120modules/blocklayered/blocklayered.php
121themes/lesptitscageots/modules/blocklayered/translations/fr.php
122modules/blocklayered/translations/fr.php
123modules/blockcontact/blockcontact.php
124themes/lesptitscageots/modules/blockcontact/translations/fr.php
125modules/blockcontact/translations/fr.php
126modules/blockmanufacturer/blockmanufacturer.php
127themes/lesptitscageots/modules/blockmanufacturer/translations/fr.php
128modules/blockmanufacturer/translations/fr.php
129modules/blockmyaccount/blockmyaccount.php
130themes/lesptitscageots/modules/blockmyaccount/translations/fr.php
131modules/blockmyaccount/translations/fr.php
132modules/blockmyaccountfooter/blockmyaccountfooter.php
133themes/lesptitscageots/modules/blockmyaccountfooter/translations/fr.php
134modules/blockmyaccountfooter/translations/fr.php
135modules/blocknewsletter/blocknewsletter.php
136themes/lesptitscageots/modules/blocknewsletter/translations/fr.php
137modules/blocknewsletter/translations/fr.php
138modules/blockpaymentlogo/blockpaymentlogo.php
139themes/lesptitscageots/modules/blockpaymentlogo/translations/fr.php
140modules/blockpaymentlogo/translations/fr.php
141modules/blocksearch/blocksearch.php
142themes/lesptitscageots/modules/blocksearch/translations/fr.php
143modules/blocksearch/translations/fr.php
144modules/blockspecials/blockspecials.php
145themes/lesptitscageots/modules/blockspecials/translations/fr.php
146modules/blockspecials/translations/fr.php
147modules/blockstore/blockstore.php
148themes/lesptitscageots/modules/blockstore/translations/fr.php
149modules/blockstore/translations/fr.php
150modules/blocksupplier/blocksupplier.php
151themes/lesptitscageots/modules/blocksupplier/translations/fr.php
152modules/blocksupplier/translations/fr.php
153modules/blocktags/blocktags.php
154themes/lesptitscageots/modules/blocktags/translations/fr.php
155modules/blocktags/translations/fr.php
156modules/blockuserinfo/blockuserinfo.php
157themes/lesptitscageots/modules/blockuserinfo/translations/fr.php
158modules/blockuserinfo/translations/fr.php
159modules/blockviewed/blockviewed.php
160themes/lesptitscageots/modules/blockviewed/translations/fr.php
161modules/blockviewed/translations/fr.php
162modules/homefeatured/homefeatured.php
163themes/lesptitscageots/modules/homefeatured/translations/fr.php
164modules/homefeatured/translations/fr.php
165modules/productpaymentlogos/productpaymentlogos.php
166themes/lesptitscageots/modules/productpaymentlogos/translations/fr.php
167modules/productpaymentlogos/translations/fr.php
168modules/themeconfigurator/themeconfigurator.php
169themes/lesptitscageots/modules/themeconfigurator/translations/fr.php
170modules/themeconfigurator/translations/fr.php
171modules/blockwishlist/blockwishlist.php
172modules/blockwishlist/WishList.php
173themes/lesptitscageots/modules/blockwishlist/translations/fr.php
174modules/blockwishlist/translations/fr.php
175modules/sendtoafriend/sendtoafriend.php
176themes/lesptitscageots/modules/sendtoafriend/translations/fr.php
177modules/sendtoafriend/translations/fr.php
178modules/blocksocial/blocksocial.php
179themes/lesptitscageots/modules/blocksocial/translations/fr.php
180modules/blocksocial/translations/fr.php
181modules/homeslider/homeslider.php
182modules/homeslider/HomeSlide.php
183themes/lesptitscageots/modules/homeslider/translations/fr.php
184modules/homeslider/translations/fr.php
185modules/def_categories/def_categories.php
186themes/lesptitscageots/modules/def_categories/translations/fr.php
187modules/productscategory/productscategory.php
188themes/lesptitscageots/modules/productscategory/translations/fr.php
189modules/productscategory/translations/fr.php
190modules/myowndeliveries/myowndeliveries.php
191modules/myowndeliveries/controllers/controller.php
192modules/myowndeliveries/controllers/availabilities.php
193modules/myowndeliveries/controllers/carriers.php
194modules/myowndeliveries/controllers/deliveries.php
195modules/myowndeliveries/controllers/hooks.php
196modules/myowndeliveries/controllers/settings.php
197modules/myowndeliveries/controllers/admin.php
198modules/myowndeliveries/pro/admin.php
199modules/myowndeliveries/controllers/subareas.php
200modules/myowndeliveries/controllers/timeslots.php
201modules/myowndeliveries/classes/availabilities.php
202modules/myowndeliveries/classes/availability.php
203modules/myowndeliveries/classes/calendar.php
204modules/myowndeliveries/pro/carrier.php
205modules/myowndeliveries/pro/carriers.php
206modules/myowndeliveries/classes/deliveries.php
207modules/myowndeliveries/classes/help.php
208modules/myowndeliveries/classes/ical.php
209modules/myowndeliveries/classes/myownutils.php
210modules/myowndeliveries/classes/phpqrcode.php
211modules/myowndeliveries/classes/subarea.php
212modules/myowndeliveries/classes/subareas.php
213modules/myowndeliveries/classes/timeslot.php
214modules/myowndeliveries/classes/timeslots.php
215modules/myowndeliveries/classes/utils.php
216classes/module/CarrierModule.php
217themes/lesptitscageots/modules/myowndeliveries/translations/fr.php
218modules/myowndeliveries/translations/fr.php
219modules/blocktopmenu/blocktopmenu.php
220modules/blocktopmenu/menutoplinks.class.php
221themes/lesptitscageots/modules/blocktopmenu/translations/fr.php
222modules/blocktopmenu/translations/fr.php
223modules/mailalerts/mailalerts.php
224modules/mailalerts/MailAlert.php
225themes/lesptitscageots/modules/mailalerts/translations/fr.php
226modules/mailalerts/translations/fr.php
227modules/paybox/paybox.php
228override/classes/PaymentModule.php
229themes/lesptitscageots/modules/paybox/translations/fr.php
230modules/paybox/fr.php
231modules/mailchimpsync/mailchimpsync.php
232modules/mailchimpsync/MailChimpClient.php
233modules/mailchimpsync/vendor/autoload.php
234modules/mailchimpsync/vendor/composer/autoload_real.php
235modules/mailchimpsync/vendor/composer/ClassLoader.php
236modules/mailchimpsync/vendor/composer/autoload_static.php
237modules/mailchimpsync/translations/fr.php
238modules/recaptcha/recaptcha.php
239modules/recaptcha/translations/fr.php
240modules/recaptcha/fr.php
241modules/lncwfreedeliverytease/lncwfreedeliverytease.php
242modules/lncwfreedeliverytease/translations/fr.php
243cache/smarty/cache/blocktopmenu/1/8/product/1567/bc/cf/f8/bccff837c9f9dea9bf5d47d0cb51df7a860b085f.blocktopmenu.tpl.php
244modules/defcookieslaw/defcookieslaw.php
245themes/lesptitscageots/modules/defcookieslaw/translations/fr.php
246modules/defcookieslaw/translations/fr.php
247classes/CMS.php
248cache/smarty/compile/d5/a9/f3/d5a9f3b517b813a8d620b8cde8f6921e40e286ed.file.cookieslaw.tpl.php
249tools/smarty/plugins/modifier.escape.php
250classes/Pack.php
251classes/ProductDownload.php
252cache/smarty/cache/productscategory/1567/27/1/8/c6/57/c6/c657c6e94487de845a20ccc5a2a7c1ebd97d12d1.productscategory.tpl.php
253classes/Image.php
254classes/ImageType.php
255classes/Feature.php
256cache/smarty/compile/7c/32/d5/7c32d520cf10f1dcc3ac06d28cd993da04573dc8.file.sendtoafriend-extra.tpl.php
257cache/smarty/cache/socialsharing/1567/1/8/52/41/84/524184bd49062f811b7d6f395c194ae91ceeeb94.socialsharing.tpl.php
258modules/loyalty/loyalty.php
259themes/lesptitscageots/modules/loyalty/translations/fr.php
260modules/loyalty/translations/fr.php
261modules/loyalty/LoyaltyModule.php
262cache/smarty/compile/5d/e0/d7/5de0d702b5145350b19304064f673632b3a6217b.file.product.tpl.php
263classes/Zone.php
264classes/Carrier.php
265cache/smarty/compile/93/59/4d/93594d38bfa558a8d0489a29f4d5460652b2cbfd.file.LNCDeliveryPrices.tpl.php
266cache/smarty/compile/b0/21/ac/b021acb2ae99d7e2a748d61a0be005c7041208b3.file.blockwishlist-extra.tpl.php
267cache/smarty/cache/productpaymentlogos/1/8/96/c4/1a/96c41a122c26b607672ea5e6a8f16aa1d759c5d0.productpaymentlogos.tpl.php
268cache/smarty/compile/01/c0/0b/01c00befc303789f4fc0952293dc3f483ab75909.file.blocknewsletter.tpl.php
269modules/statsdata/statsdata.php
270themes/lesptitscageots/modules/statsdata/translations/fr.php
271modules/statsdata/translations/fr.php
272classes/Guest.php
273classes/Connection.php
274classes/Page.php
275classes/ConnectionsSource.php
276cache/smarty/compile/30/0c/72/300c72f9b909f3ef2239a03864f5194e4a0f08dc.file.hook.tpl.php
277modules/iadvize/iadvize.php
278themes/lesptitscageots/modules/iadvize/translations/fr.php
279modules/iadvize/fr.php
280modules/blockzopim/blockzopim.php
281themes/lesptitscageots/modules/blockzopim/translations/fr.php
282modules/blockzopim/translations/fr.php
283modules/blockzopim/fr.php
284cache/smarty/compile/23/c7/14/23c714c0a772da2ba5c001d3ce88153b83e1c83e.file.blockzopim.tpl.php
285cache/smarty/compile/92/29/61/9229613557fa1c81949e5cfe8bf25378eec8c130.file.product.tpl.php
286tools/smarty/plugins/function.math.php
287tools/smarty/plugins/modifier.date_format.php
288tools/smarty/plugins/function.cycle.php
289tools/smarty/plugins/function.counter.php
290cache/smarty/compile/df/76/f9/df76f972fb46da000271c3dc056c71b45b238c66.file.errors.tpl.php
291tools/smarty/plugins/shared.make_timestamp.php
292cache/smarty/compile/86/3c/34/863c34847a63f19640658cbb18cd2055ff350a20.file.layout.tpl.php
293cache/smarty/compile/82/86/73/828673ba2f2ee9220acd5b3c9c7650cb0e65fcd5.file.header.tpl.php
294tools/smarty/plugins/function.implode.php
295cache/smarty/compile/a8/61/2c/a8612ca0908877bc21a6db26a162d19d7321d354.file.nav.tpl.php
296cache/smarty/cache/blocksocial/1/8/02/59/c1/0259c1e035d5e9326d53a0dee8ae9fc8cf822742.blocksocial.tpl.php
297cache/smarty/cache/blocksearch_top/1/8/82/83/f9/8283f91aa690103b3cb1f2739ce3ad107b58ad7d.blocksearch-top.tpl.php
298cache/smarty/compile/76/a3/0a/76a30afccb299da5e1462eef59ba2db749695a8c.file.breadcrumb.tpl.php
299cache/smarty/compile/a6/45/4a/a6454a39580ec8382bfcc366b2c23d6c947ecf0c.file.footer.tpl.php
300cache/smarty/compile/5d/73/5f/5d735fda2fff5ac037c77e29c0755aa3f0e2d5e9.file.global.tpl.php
301cache/smarty/compile/70/54/02/705402131291e1a115a2c9c34aaaaffe80be0777.file.javascript.tpl.php
302tools/smarty/plugins/modifier.replace.php
303tools/smarty/plugins/shared.mb_str_replace.php