Smile

Yes, please see attached....

1.0.8

Also for example I found AdminOrdersController.php apparently it has to do with the Myparcel module. But an old version? Well i don't find this file in the module on github: https://github.com/myparcelnl/prestashop Can I assume that it is obsolete? <?php class AdminOrdersController extends AdminOrdersControllerCore { public function sendChangedNotification(Order $order = null) { return false; } /* * module: myparcel * date: 2017-09-05 09:54:47 * version: 2.0.7 */ public function __construct() { parent::__construct(); $myParcelFlag = Configuration::get('MYPARCEL_ACTIVE'); $this->context->smarty->assign( array( 'myParcel' => $myParcelFlag, 'prestaShopVersion' => substr(_PS_VERSION_, 0, 3), ) ); if (true == $myParcelFlag) { if ('' == session_id()) { session_start(); } $_SESSION['MYPARCEL_VISIBLE_CONSIGNMENTS'] = ''; } } }

So what would be the way going forward: Go along every override file: - Determine what module is using it, if possible. - Disabling it by renaming, if not in use see if you can remove it - Test test the CPU use of the website BO - Go to next file....

When you want to change the short description field in multistore you set the top bar on yes. This does not make it possible to edit the product title. But when ticking the checkbox before the title off and on again it becomes totally impossible as youn cant put the cursor there anymore. The field blinks and then becomes in active.

Yes, softaculous gives only a warning that there is an update and you can use it to make an update if you like. But I never used it only the update email I like. I am personally not so interested about that...

It might not needed with the new core updater tool right? I think every one knows that updating by softaculous is dangerous 😉

@wakabayashi We recognized that we have a lot of overrides which might not be needed anymore... But how to get rid of them? This might be the current direction to look into.... Any advice? @Gotabor Thanks for explaining, we did have (already) a look there and could not find anything out of the ordinary. But very much appreciated!

Just got a reply the will add clone and staging soon: https://www.softaculous.com/board/index.php?tid=14894&amp;tpg=1#p44895 Maybe it's worth asking them as well @cptplastic ?

That sounds very interesting!

When you want to change the title of a product in multistore you set the top bar on yes. This does not make it possible to edit the product title. But when ticking the checkbox before the title off and on again it becomes possible... In short: only the tickbox works not the slider....

Thanks for the explanation. So as I understand right full page cache can not be used... Any chance to manually fix those issues in current version? I mean next version can be expected in summer? I used Redis and it gave cached shopping carts... I was hoping to solve it by tweaking full page cache... Our root problem was that Express Cache had some issues with mobile menu and the menu shown in the browser. It did show also mobile on desktop browser.... when cached for mobile....

I am testing the Full page cache, there is a button for debugging. But whether I have it on or off no changes, also not when emptying the cache... What am I supposed to see?

I found it also happens with other pages like products. Removed 2 languages from the 5 but server loads stays the same when stress testing. But with product pages can stress the server also when just on store not multistore. Something in the BO is using a lot of resources.

Probably it slowly became worse and worse we recieved more and more orders from the other store...

Almost sure I found the issue.... Maybe someone can confirm: When working in the BO which is a multistore and I select all shops.... then generate the order page (try 5 taps at the same time) it uses loads and loads of CPU. When using/selecting just one shop the issue is not there.... Maybe some error in a query.

See, below. It's insane tried to test it with some other pages in the BO no issue but going to BO-order (just 50 on one page) 💣 Weergeven 50 / 28698 resulta(a)t(en) 1 2 3 … Load time 1564 ms - OK... for a shared hosting Querying time 826 ms Queries 137 Memory peak usage 13.5 Mb Included files 264 files - 4.96 Mb thirty bees cache 1.70 Mb Global vars 2.15 Mb thirty bees version 1.0.8 PrestaShop (emulated) version 1.6.1.999 PHP version 7.1.26 (OK) MySQL version 10.2.21-MariaDB (OK) Memory limit 2048M Max execution time 30s Smarty cache enabled Smarty Compilation auto Time Cumulated Time Memory Usage Memory Peak Usage config 430 ms 430 ms 4.16 Mb 6.47 Mb __construct 0 ms 430 ms - Mb 6.47 Mb init 204 ms 635 ms 2.08 Mb 7.90 Mb checkAccess 0 ms 635 ms - Mb 7.90 Mb setMedia 10 ms 644 ms 0.09 Mb 7.90 Mb postProcess 0 ms 645 ms - Mb 7.90 Mb initHeader 34 ms 679 ms 0.73 Mb 7.90 Mb initContent 864 ms 1542 ms 5.19 Mb 12.59 Mb initFooter 0 ms 1542 ms - Mb 12.59 Mb display 22 ms 1564 ms 0.49 Mb 13.54 Mb Hook Time Memory Usage __construct 202 ms 4.00 Mb hookdisplayBackOfficeHeader 30 ms - Mb hookactionAdminOrdersListingFieldsModifier 6 ms - Mb hookmoduleRoutes 0 ms - Mb hookactionAdminControllerSetMedia 0 ms - Mb hookbackofficeheader - ms - Mb 6 hooks 239 ms 4.00 Mb Module Time Memory Usage myparcel 62 ms - Mb paypal 46 ms - Mb smartblog 37 ms 2.00 Mb mollie 34 ms - Mb gsnippetsreviews 13 ms 2.00 Mb phgoogletagmanager 9 ms - Mb themeconfigurator 7 ms - Mb ampmenu 6 ms - Mb pdgooglehreflangtagpro 5 ms - Mb sthoverimage 3 ms - Mb dashactivity 3 ms - Mb dashtrends 3 ms - Mb notarobot 3 ms - Mb ninjacustomer 2 ms - Mb wkmpseditor 2 ms - Mb pstoyuki 1 ms - Mb tawkto 1 ms - Mb exportproducts 0 ms - Mb 18 modules 239 ms 4.00 Mb Stopwatch SQL Doubles Tables stress ObjectModel instances Included Files Stopwatch SQL - 137 queries Query Time (ms) Rows Filesort Group By Location SELECT SQL_NO_CACHE SQL_CALC_FOUND_ROWS a.`id_order`, `reference`, `total_paid_tax_incl`, `payment`, a.`date_add` AS `date_add` , a.id_currency, a.id_order AS id_pdf, CONCAT(LEFT(c.`firstname`, 1), '. ', c.`lastname`) AS `customer`, osl.`name` AS `osname`, os.`color`, IF((SELECT so.id_order FROM `ps_orders` so WHERE so.id_customer = a.id_customer AND so.id_order < a.id_order LIMIT 1) > 0, 0, 1) as new, country_lang.name as cname, IF(a.valid, 1, 0) badge_success, mpdo.`myparcel_delivery_option`, IFNULL(mpdo.`date_delivery`, '1970-01-01 00:00:00') as `myparcel_date_delivery`, mpdo.`pickup` AS `myparcel_pickup`, UPPER(country.`iso_code`) AS `myparcel_country_iso`, 1 as `myparcel_void_1`, 1 as `myparcel_void_2`, shop.name as shop_name FROM `ps_orders` a LEFT JOIN `ps_customer` c ON (c.`id_customer` = a.`id_customer`) LEFT JOIN `ps_address` address ON address.id_address = a.id_address_delivery LEFT JOIN `ps_country` country ON address.id_country = country.id_country LEFT JOIN `ps_country_lang` country_lang ON (country.`id_country` = country_lang.`id_country` AND country_lang.`id_lang` = 6) LEFT JOIN `ps_order_state` os ON (os.`id_order_state` = a.`current_state`) LEFT JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 6) LEFT JOIN `ps_myparcel_delivery_option` mpdo ON (mpdo.`id_cart` = a.`id_cart`) LEFT JOIN ps_shop shop ON a.id_shop = shop.id_shop WHERE 1 AND a.id_shop IN (2, 1) ORDER BY a.`id_order` DESC LIMIT 0, 50 643.7 57396 Yes /classes/controller/AdminController.php:1160 SELECT SQL_NO_CACHE DISTINCT c.id_country, cl.`name` FROM `ps_orders` o INNER JOIN `ps_address` a ON a.id_address = o.id_address_delivery INNER JOIN `ps_country` c ON a.id_country = c.id_country INNER JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 6) ORDER BY cl.name ASC 90.7 43076 Yes /controllers/admin/AdminOrdersController.php:172 SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IFNULL(cl.`value`, c.`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` 15.6 4246 /classes/Configuration.php:423 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_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` 4.6 505 Yes Yes /override/classes/Hook.php:129 SELECT SQL_NO_CACHE cl.*, c.*, cl.`name` AS `country`, z.`name` AS `zone` FROM `ps_country` c INNER JOIN ps_country_shop country_shop ON (country_shop.id_country = c.id_country AND country_shop.id_shop IN (2, 1)) LEFT JOIN `ps_country_lang` `cl` ON c.`id_country` = cl.`id_country` AND cl.`id_lang` = 6 LEFT JOIN `ps_zone` `z` ON z.`id_zone` = c.`id_zone` ORDER BY cl.`name` ASC 4.5 976 Yes /classes/Country.php:582 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` WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` 4.4 1224 Yes Yes /override/classes/Hook.php:129 SELECT SQL_NO_CACHE h.id_hook, h.name AS h_name, h.title, h.description, h.position, h.live_edit, hm.position AS hm_position, m.id_module, m.name, m.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.2 505 /classes/Hook.php:207 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.4 0 /classes/Hook.php:738 SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IFNULL(cl.`value`, c.`value`) AS `value`, c.`id_shop_group`, c.`id_shop` FROM `ps_configuration_kpi` c LEFT JOIN `ps_configuration_kpi_lang` `cl` ON c.`id_configuration_kpi` = cl.`id_configuration_kpi` 1.4 288 /classes/Configuration.php:423 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.3 86 Yes /classes/Dispatcher.php:595 SELECT SQL_NO_CACHE t.*, tl.`name` FROM `ps_tab` t LEFT JOIN `ps_tab_lang` `tl` ON t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 6 ORDER BY t.`position` ASC 1.1 116 Yes /classes/Tab.php:220 SELECT SQL_NO_CACHE * FROM `ps_order_state` os LEFT JOIN `ps_order_state_lang` `osl` ON os.`id_order_state` = osl.`id_order_state` WHERE (osl.`id_lang` = 6) AND (`deleted` = 0) ORDER BY `name` ASC 1.1 42 Yes /classes/order/OrderState.php:137 SHOW COLUMNS FROM ps_orders LIKE "payment_fee" 1 1 /modules/paypal/paypal.php:3618 SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC 0.8 232 Yes /classes/Country.php:593 SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions` WHERE (`id_shop` IN (2, 1)) 0.8 238 /classes/module/Module.php:2929 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 ms.`id_module` = m.`id_module` AND ms.`id_shop` = 1 0.8 112 /classes/module/Module.php:214 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 ms.`id_module` = m.`id_module` AND ms.`id_shop` = 1 0.8 112 /classes/module/Module.php:214 SELECT SQL_NO_CACHE `id_configuration` FROM `ps_configuration` WHERE name = 'PAYPAL_HOME' AND (id_shop_group IS NULL OR id_shop_group = 0) AND (id_shop IS NULL OR id_shop = 0) LIMIT 1 0.7 3 /classes/Configuration.php:753 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29495) LIMIT 1 0.7 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29494) LIMIT 1 0.6 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29505) LIMIT 1 0.6 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29493) LIMIT 1 0.6 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 0.6 1 /classes/shop/Shop.php:1273 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29516) LIMIT 1 0.6 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE COUNT(DISTINCT l.`id_lang`) FROM `ps_lang` l INNER JOIN `ps_lang_shop` ls ON ls.`id_lang` = l.`id_lang` WHERE (ls.`id_shop` = 1) AND (l.`active` = 1) LIMIT 1 0.6 7 /classes/Language.php:382 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29524) LIMIT 1 0.6 1 /Adapter/Adapter_EntityMapper.php:80 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.6 5 /classes/Language.php:166 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29528) LIMIT 1 0.6 1 /Adapter/Adapter_EntityMapper.php:80 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.6 2 Yes /classes/shop/Shop.php:745 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29523) LIMIT 1 0.6 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_hook_alias` 0.6 86 /classes/Hook.php:692 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29496) LIMIT 1 0.6 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29502) LIMIT 1 0.6 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_employee` a LEFT JOIN `ps_employee_shop` `c` ON a.`id_employee` = c.`id_employee` AND c.`id_shop` = 1 WHERE (a.`id_employee` = 1) LIMIT 1 0.6 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29517) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29498) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29518) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29503) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE `domain`, `domain_ssl` FROM `ps_shop_url` WHERE (`main` = 1) AND (`id_shop` = 1) LIMIT 1 0.5 1 /classes/shop/ShopUrl.php:246 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29485) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29520) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29527) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29522) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29482) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29483) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 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` = 6 LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 13) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29504) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29497) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29521) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29486) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29501) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29519) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29514) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 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 = 'website.nl' OR su.domain_ssl = 'website.nl') AND (s.`active` = 1) AND (s.`deleted` = 0) 0.5 2 /classes/shop/Shop.php:345 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29509) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29487) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29481) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29480) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29513) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29511) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29499) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29512) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29484) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29510) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29479) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29508) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29515) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29491) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29488) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_order_state` a WHERE (a.`id_order_state` = 1008) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29489) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 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 IN (2, 1)) WHERE (`deleted` = 0) ORDER BY `name` ASC 0.4 18 Yes /classes/Currency.php:349 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29490) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_quick_access` qa LEFT JOIN `ps_quick_access_lang` `qal` ON qa.`id_quick_access` = qal.`id_quick_access` WHERE (qal.`id_lang` = 6) ORDER BY `name` ASC 0.4 7 Yes /classes/QuickAccess.php:83 SELECT SQL_NO_CACHE `id_tab`, `class_name` FROM `ps_tab` 0.4 116 /classes/Tab.php:129 SELECT SQL_NO_CACHE * FROM `ps_theme` a WHERE (a.`id_theme` = 5) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE `id_country` FROM `ps_country` WHERE (`active` = 1) LIMIT 1 0.4 244 /classes/ObjectModel.php:1938 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29492) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29526) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE COUNT(*) n FROM `ps_module_shop` WHERE (`id_module` = 254) AND (`id_shop` IN (2,1)) GROUP BY `id_module` HAVING (n = 2) LIMIT 1 0.4 2 /classes/module/Module.php:2988 SELECT SQL_NO_CACHE * FROM `ps_order_state` a WHERE (a.`id_order_state` = 2) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29506) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE (`name` = 'lgcookieslaw') LIMIT 1 0.4 1 /classes/module/Module.php:1670 SELECT SQL_NO_CACHE * FROM `ps_order_state` a WHERE (a.`id_order_state` = 9) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 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.4 1 /classes/shop/Shop.php:172 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29525) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29500) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_order_state` a WHERE (a.`id_order_state` = 1006) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_image_type` 0.4 36 /classes/ImageType.php:199 SELECT SQL_NO_CACHE * FROM `ps_order_state` a WHERE (a.`id_order_state` = 4) LIMIT 1 0.3 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE t.`class_name`, t.`module` FROM `ps_tab` t WHERE (t.`module` IS NOT NULL) AND (t.`module` != "") 0.3 116 /classes/Tab.php:185 SELECT SQL_NO_CACHE `class_name` FROM `ps_tab` WHERE (`id_tab` = 3) LIMIT 1 0.3 1 /classes/Tab.php:578 SELECT SQL_NO_CACHE * FROM `ps_orders` a WHERE (a.`id_order` = 29507) LIMIT 1 0.3 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE COUNT(*) n FROM `ps_module_shop` WHERE (`id_module` = 273) AND (`id_shop` IN (2,1)) GROUP BY `id_module` HAVING (n = 2) LIMIT 1 0.3 2 /classes/module/Module.php:2988 SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE (`name` = 'ph_simpleblog') LIMIT 1 0.3 0 /classes/module/Module.php:1670 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.3 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_tab` a LEFT JOIN `ps_tab_lang` `b` ON a.`id_tab` = b.`id_tab` AND b.`id_lang` = 6 WHERE (a.`id_tab` = 3) LIMIT 1 0.3 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE `id_employee` FROM `ps_employee` WHERE (`id_employee` = 1) AND (`active` = 1) AND (`passwd` = '$2y$10$Z.wLGHr6E4hna97j89IXH.W/qmKuQ6sNX9tM8Y9wFwo1De.gG33Ti') LIMIT 1 0.3 1 /classes/Employee.php:622 SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE (`name` = 'paypal') LIMIT 1 0.3 1 /classes/module/Module.php:1670 SELECT SQL_NO_CACHE * FROM `ps_tab` t LEFT JOIN `ps_tab_lang` `tl` ON t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 6 WHERE (t.`id_tab` = 3) LIMIT 1 0.3 1 /classes/Tab.php:426 SELECT SQL_NO_CACHE COUNT(*) n FROM `ps_module_shop` WHERE (`id_module` = 277) AND (`id_shop` IN (2,1)) GROUP BY `id_module` HAVING (n = 2) LIMIT 1 0.3 2 /classes/module/Module.php:2988 SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE (`name` = 'myparcel') LIMIT 1 0.3 1 /classes/module/Module.php:1670 SELECT SQL_NO_CACHE * FROM `ps_order_state_lang` WHERE (`id_order_state` = 1008) 0.3 5 /Adapter/Adapter_EntityMapper.php:88 SELECT SQL_NO_CACHE * FROM `ps_order_state_lang` WHERE (`id_order_state` = 4) 0.3 5 /Adapter/Adapter_EntityMapper.php:88 SELECT SQL_NO_CACHE * FROM `ps_order_state_lang` WHERE (`id_order_state` = 9) 0.3 5 /Adapter/Adapter_EntityMapper.php:88 SELECT SQL_NO_CACHE COUNT(*) n FROM `ps_module_shop` WHERE (`id_module` = 352) AND (`id_shop` IN (2,1)) GROUP BY `id_module` HAVING (n = 2) LIMIT 1 0.3 2 /classes/module/Module.php:2988 SELECT SQL_NO_CACHE * FROM `ps_order_state_lang` WHERE (`id_order_state` = 1006) 0.3 5 /Adapter/Adapter_EntityMapper.php:88 SELECT SQL_NO_CACHE * FROM `ps_order_state_lang` WHERE (`id_order_state` = 10) 0.2 4 /Adapter/Adapter_EntityMapper.php:88 SELECT SQL_NO_CACHE * FROM `ps_order_state` a WHERE (a.`id_order_state` = 10) LIMIT 1 0.2 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE FOUND_ROWS() AS `ps_order` LIMIT 1 0.2 0 /classes/controller/AdminController.php:1167 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) AS last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1 0.2 1 /classes/SmartyCustom.php:192 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` = 13) LIMIT 1 0.2 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE COUNT(*) n FROM `ps_module_shop` WHERE (`id_module` = 187) AND (`id_shop` IN (2,1)) GROUP BY `id_module` HAVING (n = 2) LIMIT 1 0.2 2 /classes/module/Module.php:2988 SELECT SQL_NO_CACHE * FROM `ps_tab` t LEFT JOIN `ps_tab_lang` `tl` ON t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 6 WHERE (t.`id_tab` = 116) LIMIT 1 0.2 1 /classes/Tab.php:426 SELECT SQL_NO_CACHE * FROM `ps_configuration` a WHERE (a.`id_configuration` = 1190) LIMIT 1 0.2 1 /Adapter/Adapter_EntityMapper.php:80 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` = 6) LIMIT 1 0.2 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE (`id_module` = 266) AND (`id_shop` = 1) LIMIT 1 0.2 1 /classes/module/Module.php:1439 UPDATE `ps_employee` SET `last_connection_date` = CURRENT_DATE() WHERE `id_employee` = 1 AND `last_connection_date` < CURRENT_DATE() 0.2 1 /classes/Employee.php:257 SELECT SQL_NO_CACHE `id_parent` FROM `ps_tab` WHERE (LOWER(`class_name`) = 'adminorders') LIMIT 1 0.2 116 /classes/Tab.php:156 SELECT SQL_NO_CACHE COUNT(*) n FROM `ps_module_shop` WHERE (`id_module` = 348) AND (`id_shop` IN (2,1)) GROUP BY `id_module` HAVING (n = 2) LIMIT 1 0.2 2 /classes/module/Module.php:2988 SELECT SQL_NO_CACHE * FROM `ps_order_state_lang` WHERE (`id_order_state` = 2) 0.2 5 /Adapter/Adapter_EntityMapper.php:88 SELECT SQL_NO_CACHE id_module FROM ps_lgcookieslaw; 0.2 2 /override/classes/Hook.php:60 SELECT SQL_NO_CACHE COUNT(*) n FROM `ps_module_shop` WHERE (`id_module` = 187) AND (`id_shop` IN (2,1)) GROUP BY `id_module` HAVING (n = 2) LIMIT 1 0.2 2 /classes/module/Module.php:2988 SELECT SQL_NO_CACHE * FROM `ps_country_lang` WHERE (`id_country` = 13) 0.2 5 /Adapter/Adapter_EntityMapper.php:88 SELECT SQL_NO_CACHE id_shop FROM `ps_employee_shop` WHERE `id_employee` = 1 0.2 2 /classes/ObjectModel.php:1695 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.2 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE COUNT(*) n FROM `ps_module_shop` WHERE (`id_module` = 187) AND (`id_shop` IN (2,1)) GROUP BY `id_module` HAVING (n = 2) LIMIT 1 0.2 2 /classes/module/Module.php:2988 SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE (`id_module` = 344) AND (`id_shop` = 1) LIMIT 1 0.2 1 /classes/module/Module.php:1439 SELECT SQL_NO_CACHE version FROM `ps_module` WHERE name = 'paypal' LIMIT 1 0.2 1 /modules/paypal/paypal.php:369 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` = 3) LIMIT 1 0.2 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE `price_display_method` FROM `ps_group` WHERE (`id_group` = 1) LIMIT 1 0.2 1 /classes/Group.php:244 SELECT SQL_NO_CACHE id_module FROM ps_lgcookieslaw; 0.2 2 /override/classes/Hook.php:60 SELECT SQL_NO_CACHE COUNT(*) FROM ps_shop LIMIT 1 0.2 0 /classes/shop/Shop.php:1274 SELECT SQL_NO_CACHE COUNT(*) n FROM `ps_module_shop` WHERE (`id_module` = 187) AND (`id_shop` IN (2,1)) GROUP BY `id_module` HAVING (n = 2) LIMIT 1 0.2 2 /classes/module/Module.php:2988 SELECT SQL_NO_CACHE COUNT(*) n FROM `ps_module_shop` WHERE (`id_module` = 187) AND (`id_shop` IN (2,1)) GROUP BY `id_module` HAVING (n = 2) LIMIT 1 0.2 2 /classes/module/Module.php:2988 SELECT SQL_NO_CACHE * FROM `ps_configuration_lang` WHERE (`id_configuration` = 1190) 0.2 1 /Adapter/Adapter_EntityMapper.php:88 Doubles 50 SELECT * FROM `ps_orders` a WHERE (a.`id_order` = XX) LIMIT XX 10 SELECT COUNT(*) n FROM `ps_module_shop` WHERE (`id_module` = XX) AND (`id_shop` IN (XX,XX)) GROUP BY `id_module` HAVING (n = XX) LIMIT XX 6 SELECT * FROM `ps_order_state_lang` WHERE (`id_order_state` = XX) 6 SELECT * FROM `ps_order_state` a WHERE (a.`id_order_state` = XX) LIMIT XX 3 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 m.`id_module`, m.`name`, ms.`id_module` AS `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = XX 2 SELECT * FROM `ps_tab` t LEFT JOIN `ps_tab_lang` `tl` ON t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = XX WHERE (t.`id_tab` = XX) LIMIT XX 2 SELECT `id_module` FROM `ps_module_shop` WHERE (`id_module` = XX) AND (`id_shop` = XX) LIMIT XX 2 SELECT id_module FROM ps_lgcookieslaw; Tables stress 54 orders 16 module_shop 10 module 8 order_state_lang 8 order_state 8 tab 6 shop 6 country 5 hook 5 country_lang 4 configuration 4 shop_url 4 currency_shop 4 currency 4 tab_lang 3 hook_module 3 lang_shop 3 country_shop 3 lang 2 lgcookieslaw 2 hook_alias 2 configuration_lang 2 employee_shop 2 employee 2 address 2 theme 1 quick_access_lang 1 customer 1 myparcel_delivery_option 1 configuration_kpi_lang 1 configuration_kpi 1 image_type 1 meta_lang 1 quick_access 1 state 1 zone 1 smarty_last_flush 1 hook_module_exceptions 1 meta 1 shop_group 1 group ObjectModel instances Name Instances Source Order 100 /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] /controllers/admin/AdminOrdersController.php [223] /controllers/admin/AdminOrdersController.php [421] OrderState 6 /classes/order/Order.php [2746] /classes/order/Order.php [2746] /classes/order/Order.php [2746] /classes/order/Order.php [2746] /classes/order/Order.php [2746] /classes/order/Order.php [2746] Currency 4 /classes/controller/AdminController.php [423] /classes/controller/AdminController.php [3826] /classes/controller/AdminController.php [3826] /classes/controller/AdminController.php [3826] Shop 3 /config/config.inc.php [123] /classes/controller/AdminController.php [541] /classes/controller/AdminController.php [2344] Country 3 /config/config.inc.php [148] /classes/controller/AdminController.php [551] /modules/paypal/paypal.php [2272] Theme 1 /config/config.inc.php [124] Employee 1 /config/config.inc.php [188] Language 1 /config/config.inc.php [201] Tab 1 /classes/Dispatcher.php [776] Configuration 1 /modules/paypal/paypalCore.php [2] ShopGroup 1 /classes/controller/AdminController.php [2331] Included Files # Filename 1 /iadmin2/index.php 2 /config/config.inc.php 3 /config/defines.inc.php 4 /config/settings.inc.php 5 /config/autoload.php 6 /config/alias.php 7 /classes/PrestaShopAutoload.php 8 /vendor/autoload.php 9 /vendor/composer/autoload_real.php 10 /vendor/composer/ClassLoader.php 11 /vendor/composer/include_paths.php 12 /vendor/composer/autoload_static.php 13 /vendor/ralouphie/getallheaders/src/getallheaders.php 14 /vendor/guzzlehttp/promises/src/functions_include.php 15 /vendor/guzzlehttp/promises/src/functions.php 16 /vendor/guzzlehttp/psr7/src/functions_include.php 17 /vendor/guzzlehttp/psr7/src/functions.php 18 /vendor/paragonie/random_compat/lib/random.php 19 /vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php 20 /vendor/guzzlehttp/guzzle/src/functions_include.php 21 /vendor/guzzlehttp/guzzle/src/functions.php 22 /vendor/jakeasmith/http_build_url/src/http_build_url.php 23 /vendor/swiftmailer/swiftmailer/lib/swift_required.php 24 /vendor/swiftmailer/swiftmailer/lib/classes/Swift.php 25 /vendor/symfony/polyfill-mbstring/bootstrap.php 26 /vendor/thirtybees/geoip/src/geoip.inc 27 /vendor/thirtybees/geoip/src/geoipcity.inc 28 /vendor/thirtybees/geoip/src/geoipregionvars.php 29 /vendor/thirtybees/geoip/src/timezone.php 30 /cache/class_index.php 31 /config/bootstrap.php 32 /Core/Business/Core_Business_ContainerBuilder.php 33 /Core/Foundation/IoC/Core_Foundation_IoC_Container.php 34 /Adapter/Adapter_ServiceLocator.php 35 /classes/controller/Controller.php 36 /classes/ObjectModel.php 37 /Core/Foundation/Database/Core_Foundation_Database_EntityInterface.php 38 /classes/db/Db.php 39 /classes/Tools.php 40 /classes/Context.php 41 /classes/shop/Shop.php 42 /config/db_slave_server.inc.php 43 /classes/db/DbPDO.php 44 /classes/Configuration.php 45 /override/classes/Configuration.php 46 /classes/db/DbQuery.php 47 /classes/Validate.php 48 /classes/cache/Cache.php 49 /Adapter/Adapter_EntityMapper.php 50 /classes/Theme.php 51 /config/defines_uri.inc.php 52 /classes/Language.php 53 /override/classes/Language.php 54 /classes/Country.php 55 /classes/PrestaShopCollection.php 56 /classes/Cookie.php 57 /override/classes/Cookie.php 58 /classes/Blowfish.php 59 /classes/CryptBlowfish.php 60 /classes/Encryptor.php 61 /classes/Employee.php 62 /config/smarty.config.inc.php 63 /classes/SmartyCustom.php 64 /vendor/smarty/smarty/libs/Smarty.class.php 65 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_data.php 66 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php 67 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 68 /vendor/smarty/smarty/libs/sysplugins/smarty_resource.php 69 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_resource_file.php 70 /vendor/smarty/smarty/libs/sysplugins/smarty_cacheresource.php 71 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_cacheresource_file.php 72 /config/smartyadmin.config.inc.php 73 /classes/Link.php 74 /classes/shop/ShopUrl.php 75 /classes/Hook.php 76 /override/classes/Hook.php 77 /classes/PageCache.php 78 /classes/Group.php 79 /classes/module/Module.php 80 /vendor/mobiledetect/mobiledetectlib/Mobile_Detect.php 81 /iadmin2/functions.php 82 /images.inc.php 83 /classes/Dispatcher.php 84 /modules/smartblog/smartblog.php 85 /modules/smartblog/classes/BlogCategory.php 86 /modules/smartblog/classes/Blogcomment.php 87 /modules/smartblog/classes/BlogPostCategory.php 88 /modules/smartblog/classes/BlogTag.php 89 /modules/smartblog/classes/SmartBlogPost.php 90 /modules/smartblog/classes/BlogImageType.php 91 /modules/smartblog/controllers/admin/AdminAboutUsController.php 92 /classes/controller/ModuleAdminController.php 93 /classes/controller/AdminController.php 94 /classes/Translate.php 95 /themes/panda/modules/smartblog/translations/nl.php 96 /modules/smartblog/translations/nl.php 97 /classes/Tab.php 98 /controllers/admin/AdminOrdersController.php 99 /override/controllers/admin/AdminOrdersController.php 100 /classes/order/OrderState.php 101 /translations/nl/admin.php 102 /classes/Profile.php 103 /classes/Currency.php 104 /modules/themeconfigurator/themeconfigurator.php 105 /themes/panda/modules/themeconfigurator/translations/nl.php 106 /modules/themeconfigurator/translations/nl.php 107 /cache/smarty/compile/ee/3d/66/ee3d6602255332a22279a5648b389847384957da.file.addjs.tpl.php 108 /modules/ampmenu/ampmenu.php 109 /modules/ampmenu/menutoplinks.class.php 110 /themes/panda/modules/ampmenu/translations/nl.php 111 /modules/ampmenu/translations/nl.php 112 /modules/phgoogletagmanager/phgoogletagmanager.php 113 /themes/panda/modules/phgoogletagmanager/translations/nl.php 114 /modules/phgoogletagmanager/translations/nl.php 115 /cache/smarty/compile/4f/72/a0/4f72a047ddeb71fc9914a367b4d97d465802bb42.file.order_refund.tpl.php 116 /modules/myparcel/myparcel.php 117 /modules/myparcel/vendor/autoload.php 118 /modules/myparcel/vendor/composer/autoload_real.php 119 /modules/myparcel/vendor/composer/autoload_static.php 120 /modules/myparcel/vendor/ircmaxell/password-compat/lib/password.php 121 /modules/myparcel/vendor/firstred/php-dot-notation/src/helpers.php 122 /modules/myparcel/vendor/symfony/polyfill-php54/bootstrap.php 123 /modules/myparcel/vendor/symfony/polyfill-php55/bootstrap.php 124 /modules/myparcel/classes/helpers.php 125 /themes/panda/modules/myparcel/translations/nl.php 126 /modules/myparcel/translations/nl.php 127 /classes/Media.php 128 /modules/myparcel/classes/MyParcelTools.php 129 /vendor/smarty/smarty/libs/plugins/modifier.escape.php 130 /cache/smarty/compile/7d/44/2a/7d442a605e38b5e7e5d6815e59ed3866085b9e42.file.adminvars.tpl.php 131 /cache/smarty/compile/5e/12/e7/5e12e7c1a1ec006dfa34d38616cbafcd577f322d.file.translations.tpl.php 132 /modules/pstoyuki/pstoyuki.php 133 /themes/panda/modules/pstoyuki/translations/nl.php 134 /modules/pstoyuki/translations/nl.php 135 /modules/mollie/mollie.php 136 /modules/mollie/lib/vendor/autoload.php 137 /modules/mollie/lib/vendor/composer/autoload_real.php 138 /modules/mollie/lib/vendor/composer/autoload_static.php 139 /modules/mollie/lib/vendor/ehough/psr7/src/functions_include.php 140 /modules/mollie/lib/vendor/ehough/psr7/src/functions.php 141 /modules/mollie/lib/helpers.php 142 /classes/module/PaymentModule.php 143 /themes/panda/modules/mollie/translations/nl.php 144 /modules/mollie/translations/nl.php 145 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/MollieApiClient.php 146 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Http/Client.php 147 /modules/mollie/lib/vendor/php-curl-class/php-curl-class/src/Curl/Curl.php 148 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Http/ClientInterface.php 149 /modules/mollie/lib/vendor/php-curl-class/php-curl-class/src/Curl/CaseInsensitiveArray.php 150 /modules/mollie/lib/vendor/php-curl-class/php-curl-class/src/Curl/Url.php 151 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/CompatibilityChecker.php 152 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Endpoints/PaymentEndpoint.php 153 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Endpoints/EndpointAbstract.php 154 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Endpoints/MethodEndpoint.php 155 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Endpoints/CustomerEndpoint.php 156 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Endpoints/SettlementsEndpoint.php 157 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Endpoints/SubscriptionEndpoint.php 158 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Endpoints/CustomerPaymentsEndpoint.php 159 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Endpoints/MandateEndpoint.php 160 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Endpoints/ProfileEndpoint.php 161 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Endpoints/InvoiceEndpoint.php 162 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Endpoints/RefundEndpoint.php 163 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Types/PaymentStatus.php 164 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Types/RefundStatus.php 165 /modules/sthoverimage/sthoverimage.php 166 /themes/panda/modules/sthoverimage/translations/nl.php 167 /modules/sthoverimage/translations/nl.php 168 /modules/paypal/paypal.php 169 /modules/paypal/api/paypal_lib.php 170 /modules/paypal/api/paypal_connect.php 171 /modules/paypal/api/CallApiPaypalPlus.php 172 /modules/paypal/api/ApiPaypalPlus.php 173 /modules/paypal/paypal_logos.php 174 /modules/paypal/paypal_orders.php 175 /modules/paypal/paypal_tools.php 176 /modules/paypal/paypal_login/paypal_login.php 177 /modules/paypal/paypal_login/PayPalLoginUser.php 178 /modules/paypal/classes/PaypalCapture.php 179 /modules/paypal/classes/AuthenticatePaymentMethods.php 180 /modules/paypal/classes/TLSVerificator.php 181 /modules/paypal/paypalCore.php 182 /themes/panda/modules/paypal/translations/nl.php 183 /modules/paypal/nl.php 184 /modules/ninjacustomer/ninjacustomer.php 185 /themes/panda/modules/ninjacustomer/translations/nl.php 186 /modules/ninjacustomer/translations/nl.php 187 /modules/notarobot/notarobot.php 188 /themes/panda/modules/notarobot/translations/nl.php 189 /modules/wkmpseditor/wkmpseditor.php 190 /themes/panda/modules/wkmpseditor/translations/nl.php 191 /modules/dashactivity/dashactivity.php 192 /themes/panda/modules/dashactivity/translations/nl.php 193 /modules/dashactivity/translations/nl.php 194 /modules/dashtrends/dashtrends.php 195 /themes/panda/modules/dashtrends/translations/nl.php 196 /modules/dashtrends/translations/nl.php 197 /classes/QuickAccess.php 198 /modules/gsnippetsreviews/gsnippetsreviews.php 199 /modules/gsnippetsreviews/conf/common.conf.php 200 /classes/ImageType.php 201 /modules/gsnippetsreviews/lib/module-tools_class.php 202 /themes/panda/modules/gsnippetsreviews/translations/nl.php 203 /modules/gsnippetsreviews/translations/nl.php 204 /modules/pdgooglehreflangtagpro/pdgooglehreflangtagpro.php 205 /modules/pdgooglehreflangtagpro/models/HrefLangModel.php 206 /themes/panda/modules/pdgooglehreflangtagpro/translations/nl.php 207 /modules/pdgooglehreflangtagpro/translations/nl.php 208 /modules/exportproducts/exportproducts.php 209 /modules/tawkto/tawkto.php 210 /themes/panda/modules/tawkto/translations/nl.php 211 /modules/tawkto/translations/nl.php 212 /classes/helper/HelperShop.php 213 /classes/helper/Helper.php 214 /cache/smarty/compile/6d/58/3a/6d583a0c8ba23cd2777ab101093047d315035663.file.list.tpl.php 215 /classes/shop/ShopGroup.php 216 /classes/helper/HelperKpi.php 217 /classes/ConfigurationKPI.php 218 /cache/smarty/compile/d8/f0/e9/d8f0e9f95dab506b9db88b7c475770d841d51b22.file.kpi.tpl.php 219 /vendor/smarty/smarty/libs/plugins/modifier.replace.php 220 /vendor/smarty/smarty/libs/plugins/shared.mb_str_replace.php 221 /classes/helper/HelperKpiRow.php 222 /cache/smarty/compile/e6/8a/c3/e68ac3b739fae2dd8dc814c1030b4d11ffd6d85c.file.row.tpl.php 223 /modules/myparcel/classes/MyParcelDeliveryOption.php 224 /modules/myparcel/classes/MyParcelObjectModel.php 225 /classes/helper/HelperList.php 226 /cache/smarty/compile/46/ae/0b/46ae0b2366a19dde1ff742d8ac676f970de64937.file.list_header.tpl.php 227 /vendor/smarty/smarty/libs/plugins/function.math.php 228 /cache/smarty/compile/91/64/05/916405c2b76c062b21ad8d8950a08a808f62efab.file.list_action_view.tpl.php 229 /classes/order/Order.php 230 /override/classes/order/Order.php 231 /vendor/commerceguys/intl/src/Currency/CurrencyRepository.php 232 /vendor/commerceguys/intl/src/LocaleResolverTrait.php 233 /vendor/commerceguys/intl/src/Currency/CurrencyRepositoryInterface.php 234 /vendor/commerceguys/intl/src/NumberFormat/NumberFormatRepository.php 235 /vendor/commerceguys/intl/src/NumberFormat/NumberFormatRepositoryInterface.php 236 /vendor/commerceguys/intl/src/Currency/Currency.php 237 /vendor/commerceguys/intl/src/Currency/CurrencyEntityInterface.php 238 /vendor/commerceguys/intl/src/Currency/CurrencyInterface.php 239 /vendor/commerceguys/intl/src/NumberFormat/NumberFormat.php 240 /vendor/commerceguys/intl/src/NumberFormat/NumberFormatEntityInterface.php 241 /vendor/commerceguys/intl/src/NumberFormat/NumberFormatInterface.php 242 /vendor/commerceguys/intl/src/Formatter/NumberFormatter.php 243 /vendor/commerceguys/intl/src/Formatter/NumberFormatterInterface.php 244 /cache/smarty/compile/85/40/86/854086d20c33242f4bce014773194cc50501d619.file._print_pdf_icon.tpl.php 245 /cache/smarty/compile/9b/fe/89/9bfe891b4a158579e7b22ab9dbd5c8cc19a311e1.file.icon-delivery-date.tpl.php 246 /cache/smarty/compile/30/a4/33/30a4338543e9e66e1bb22b384417b056ca13f14f.file.icon-tracktrace.tpl.php 247 /cache/smarty/compile/8f/3e/e4/8f3ee4bf4aa7f28093cbf0348c56c1c681e1a5bb.file.icon-concept.tpl.php 248 /cache/smarty/compile/f4/fa/62/f4fa628899ec561286c4a117d726eb037c1f282e.file.list_content.tpl.php 249 /vendor/smarty/smarty/libs/plugins/function.counter.php 250 /cache/smarty/compile/1f/9c/5d/1f9c5dc6abcb72d970fa8208c2a6cf467f03a7e0.file.list_footer.tpl.php 251 /cache/smarty/compile/7f/2c/28/7f2c28e91c1c80749f05808514828b255406423b.file.list.tpl.php 252 /cache/smarty/compile/05/40/2c/05402c1069633540365dc1d4e9031e59dfb793c5.file.content.tpl.php 253 /cache/smarty/compile/7e/02/68/7e0268668d49f7a97c0fed3ea8dfa7b89f22b2d4.file.page_header_toolbar.tpl.php 254 /cache/smarty/compile/75/dc/91/75dc91b1f102dfa7b06fa15a209c89aab3cab896.file.modal.tpl.php 255 /cache/smarty/compile/ef/bb/68/efbb68054966a94a18bc7b585a6601008073a546.file.header.tpl.php 256 /cache/smarty/compile/8a/d4/b8/8ad4b8f0bbfaaf0706e0db81d18533c2665fd848.file.javascript.tpl.php 257 /cache/smarty/compile/20/9c/e6/209ce601fe9b45d4a09b4de58507b5192fbe0f71.file.nav.tpl.php 258 /cache/smarty/compile/3d/aa/6a/3daa6aba3ed814b5655364ca1fa8724f8f52c61c.file.search_form.tpl.php 259 /cache/smarty/compile/4c/6e/ee/4c6eeed1eb4b1423148d0046cbcaa0b41072a364.file.footer.tpl.php 260 /cache/smarty/compile/79/b6/d6/79b6d6445ec20a10c2404a77001d18b86753ca1e.file.layout.tpl.php

Seems I have tracked the issue...., no solution jet... I have done this with and without the Myparcel module but that seems not to make any difference.... As we are in europe, no visitors at the moment and no employees in the office. What I did a load test and openend 20 page of the FO, this does not make any impact on the speed. But when I open 4-6 order overviews in the BO the server uses lots and lots of CPU. So when me and my colleagues are working during the day.... You can imagine what happens as this page is the most used page... The whole website goes down.... See attached when the BO order page is loaded... an when just normal pages are loaded...

The settings from this profiling + debug....

There we go: Load time 3629 ms - You'd better run your shop on a toaster Querying time 340 ms Queries 258 Memory peak usage 13.6 Mb Included files 471 files - 8.42 Mb thirty bees cache 1.49 Mb Global vars 1.64 Mb thirty bees version 1.0.8 PrestaShop (emulated) version 1.6.1.999 PHP version 7.1.26 (OK) MySQL version 10.2.21-MariaDB (OK) Memory limit 2048M Max execution time 30s Smarty cache enabled Smarty Compilation auto Time Cumulated Time Memory Usage Memory Peak Usage config 460 ms 460 ms 3.72 Mb 5.54 Mb __construct 0 ms 460 ms - Mb 5.54 Mb init 174 ms 634 ms 0.50 Mb 6.69 Mb checkAccess 0 ms 634 ms - Mb 6.69 Mb setMedia 18 ms 652 ms 0.03 Mb 6.69 Mb postProcess 0 ms 652 ms - Mb 6.69 Mb initHeader 0 ms 652 ms - Mb 6.69 Mb initContent 2871 ms 3523 ms 8.04 Mb 12.33 Mb initFooter 28 ms 3551 ms 0.20 Mb 12.67 Mb display 78 ms 3629 ms 0.58 Mb 13.58 Mb Hook Time Memory Usage __construct 1661 ms 6.00 Mb hookleftcolumn 666 ms 2.00 Mb hookdisplayHeader 180 ms - Mb hookheader 77 ms - Mb hookdisplayMainMenuWidget 24 ms - Mb hookdisplaySideBarRight 23 ms - Mb hookdisplayFooter 13 ms - Mb hookdisplayMobileMenu 9 ms - Mb hookdisplayTop 9 ms - Mb hookdisplayHome 8 ms - Mb hookdisplayAfterBodyOpeningTag 8 ms - Mb hookdisplayHomeBottom 7 ms - Mb hookdisplayLeftColumn 6 ms - Mb hookdisplayFullWidthTop 6 ms - Mb hookfooter 6 ms 2.00 Mb hookdisplayBanner 5 ms - Mb hookdisplayBottomColumn 5 ms - Mb hookdisplayRightBar 5 ms - Mb hookdisplayHomeTop 5 ms - Mb hookdisplayTopColumn 5 ms - Mb hookdisplayFullWidthBottom 4 ms - Mb hookdisplayHomeTabContent 4 ms - Mb hookdisplayFooterTertiary 4 ms - Mb hooktop 4 ms - Mb hookdisplayHomeTab 3 ms - Mb hookdisplayHomeSecondaryLeft 3 ms - Mb hookdisplayMainMenu 3 ms - Mb hookhome 2 ms - Mb hookdisplayNav 2 ms - Mb hookdisplayFooterPrimary 2 ms - Mb hookdisplayFooterBottomRight 2 ms - Mb hookdisplayFooterBottomLeft 2 ms - Mb hookdisplayNavLeft 2 ms - Mb hookdisplayMobileBar 1 ms - Mb hookdisplayMobileBarLeft 1 ms - Mb hookmoduleRoutes 0 ms - Mb 36 hooks 2767 ms 10.00 Mb Module Time Memory Usage htmlboxpro 641 ms 2.00 Mb stthemeeditor 358 ms 2.00 Mb gsnippetsreviews 213 ms - Mb stmultilink 90 ms - Mb paypal 88 ms - Mb mailalerts 84 ms - Mb stparallax 83 ms 2.00 Mb blocknewsletter 71 ms - Mb blockcms 64 ms - Mb smartblog 58 ms 2.00 Mb blockcart_mod 57 ms - Mb blockviewed_mod 56 ms - Mb stiosslider 54 ms - Mb stpagebanner 54 ms - Mb myparcel 53 ms - Mb stmegamenu 53 ms - Mb blockwishlist 49 ms - Mb mollie 48 ms - Mb stbanner 46 ms - Mb phgoogletagmanager 45 ms - Mb blockfacebook 43 ms - Mb steasycontent 41 ms - Mb lgcookieslaw 34 ms - Mb themeconfigurator 34 ms - Mb blocksocial 27 ms - Mb blockcontactinfos 26 ms - Mb ninjacustomer 25 ms - Mb homefeatured 23 ms - Mb pdgooglehreflangtagpro 21 ms - Mb feeder 21 ms - Mb whatsappbutton 19 ms - Mb blockmyaccountfooter 18 ms - Mb htmlbox 17 ms - Mb editorial 16 ms - Mb blocksearch_mod 14 ms - Mb stcompare 11 ms - Mb blockcontact 11 ms - Mb faktiva_seotk 11 ms - Mb blockpermanentlinks 10 ms - Mb socialsharing 9 ms - Mb sthoverimage 9 ms - Mb crossselling 9 ms - Mb notarobot 9 ms - Mb blockuserinfo_mod 8 ms - Mb statsdata 7 ms 2.00 Mb blocknewproducts 6 ms - Mb blockcmsinfo 6 ms - Mb tawkto 4 ms - Mb vatnumber 3 ms - Mb blockcurrencies_mod 3 ms - Mb blockuserinfo 3 ms - Mb stproductlinknav 2 ms - Mb blockmyaccount 2 ms - Mb 53 modules 2767 ms 10.00 Mb Stopwatch SQL Doubles Tables stress ObjectModel instances Included Files Stopwatch SQL - 258 queries Query Time (ms) Rows Filesort Group By Location SELECT SQL_NO_CACHE cr.*, crl.`id_lang`, crl.`name`, cd.`id_cart` FROM `ps_cart_cart_rule` cd LEFT JOIN `ps_cart_rule` `cr` ON cd.`id_cart_rule` = cr.`id_cart_rule` LEFT JOIN `ps_cart_rule_lang` `crl` ON cd.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 6 WHERE (`id_cart` = 72761) ORDER BY cr.`priority` ASC 28.5 1 Yes /classes/Cart.php:2352 SELECT SQL_NO_CACHE cl.*, c.*, cl.`name` AS `country`, z.`name` AS `zone` FROM `ps_country` c INNER JOIN ps_country_shop country_shop ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1) LEFT JOIN `ps_country_lang` `cl` ON c.`id_country` = cl.`id_country` AND cl.`id_lang` = 6 LEFT JOIN `ps_zone` `z` ON z.`id_zone` = c.`id_zone` ORDER BY cl.`name` ASC 27.3 233 Yes /classes/Country.php:582 SELECT SQL_NO_CACHE * FROM `ps_carrier_lang` WHERE (`id_carrier` = 285) AND (`id_shop` = 1) 26.3 4 /Adapter/Adapter_EntityMapper.php:88 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 ms.`id_module` = m.`id_module` AND ms.`id_shop` = 1 19.3 112 /classes/module/Module.php:214 SELECT SQL_NO_CACHE count(distinct id_address_delivery) FROM `ps_cart_product` cp WHERE (id_cart = 72761) LIMIT 1 15.8 1 /classes/Cart.php:2072 SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IFNULL(cl.`value`, c.`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` 13.2 4246 /classes/Configuration.php:423 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 (3)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` 12.4 1224 Yes Yes /override/classes/Hook.php:129 SELECT SQL_NO_CACHE fp.id_feature, fp.id_product, fp.id_feature_value, custom FROM `ps_feature_product` fp LEFT JOIN `ps_feature_value` fv ON (fp.id_feature_value = fv.id_feature_value) WHERE `id_product` = 579 8.9 1 /classes/Product.php:6880 SELECT SQL_NO_CACHE SUM(`quantity`) FROM `ps_cart_product` WHERE `id_product` = 579 AND `id_cart` = 72761 LIMIT 1 8.2 1 /classes/Product.php:630 SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions` WHERE (`id_shop` IN (1)) 7.5 238 /classes/module/Module.php:2929 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` = 6 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 976) AND (b.`id_shop` = 1) LIMIT 1 6.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE h.id_hook, h.name AS h_name, h.title, h.description, h.position, h.live_edit, hm.position AS hm_position, m.id_module, m.name, m.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 6.4 504 /classes/Hook.php:207 SELECT SQL_NO_CACHE id_shop FROM `ps_lang_shop` WHERE `id_lang` = 6 AND id_shop = 1 LIMIT 1 4.7 1 /classes/ObjectModel.php:1623 SELECT SQL_NO_CACHE *, ( IF (`id_group` = 3, 2, 0) + IF (`id_country` = 13, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0)) AS `score` FROM `ps_specific_price` WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 13)) AND (`id_group` IN (0, 3) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2019-02-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-02-03 00:00:00' <= `to`)) 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, `to` DESC, `from` DESC LIMIT 1 4.6 1 Yes /classes/SpecificPrice.php:236 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` = 6 LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 13) LIMIT 1 3.8 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_carrier_tax_rules_group_shop` WHERE (`id_carrier` = 268) AND (`id_shop` = 1) LIMIT 1 3.4 4 /classes/Carrier.php:307 SHOW COLUMNS FROM ps_orders LIKE "payment_fee" 3.2 1 /modules/paypal/paypal.php:3618 SELECT SQL_NO_CACHE cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS `cart_quantity`, cp.`id_shop`, pl.`name`, p.`is_virtual`, pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`, p.`id_manufacturer`, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`, product_shop.`available_for_order`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price_ratio`, stock.`quantity` AS `quantity_available`, p.`width`, p.`height`, p.`depth`, p.`weight`, stock.`out_of_stock`, p.`date_add`, p.`date_upd`, IFNULL(stock.`quantity`, 0) AS `quantity`, pl.`link_rewrite`, cl.`link_rewrite` AS `category`, CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0)) AS unique_id, cp.`id_address_delivery`, product_shop.`advanced_stock_management`, ps.`product_supplier_reference` AS `supplier_reference`, NULL AS customization_quantity, NULL AS id_customization, product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr, IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference, (p.`weight`+ pa.`weight`) weight_attribute, IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13, IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc, IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity, IF(product_attribute_shop.wholesale_price > 0, product_attribute_shop.wholesale_price, product_shop.`wholesale_price`) wholesale_price, image_shop.`id_image` id_image, il.`legend` FROM `ps_cart_product` cp LEFT JOIN `ps_product` `p` ON p.`id_product` = cp.`id_product` INNER JOIN `ps_product_shop` product_shop ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`) LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 6 AND pl.id_shop = cp.id_shop LEFT JOIN `ps_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 6 AND cl.id_shop = cp.id_shop LEFT JOIN `ps_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier` LEFT JOIN ps_stock_available stock ON (stock.id_product = cp.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, 0) AND stock.id_shop_group = 1 AND stock.id_shop = 0 ) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute` LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`) 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 il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 6 WHERE (cp.`id_cart` = 72761) AND (p.`id_product` IS NOT NULL) ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC 2.9 1 /classes/Cart.php:382 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.6 0 /classes/Hook.php:738 SELECT SQL_NO_CACHE * FROM `ps_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 2.5 1 /Adapter/Adapter_EntityMapper.php:80 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` = 579) 2.2 1 /classes/Product.php:825 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 2 86 Yes /classes/Dispatcher.php:595 SELECT SQL_NO_CACHE cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS `cart_quantity`, cp.`id_shop`, pl.`name`, p.`is_virtual`, pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`, p.`id_manufacturer`, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`, product_shop.`available_for_order`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price_ratio`, stock.`quantity` AS `quantity_available`, p.`width`, p.`height`, p.`depth`, p.`weight`, stock.`out_of_stock`, p.`date_add`, p.`date_upd`, IFNULL(stock.`quantity`, 0) AS `quantity`, pl.`link_rewrite`, cl.`link_rewrite` AS `category`, CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0)) AS unique_id, cp.`id_address_delivery`, product_shop.`advanced_stock_management`, ps.`product_supplier_reference` AS `supplier_reference`, NULL AS customization_quantity, NULL AS id_customization, product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr, IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference, (p.`weight`+ pa.`weight`) weight_attribute, IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13, IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc, IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity, IF(product_attribute_shop.wholesale_price > 0, product_attribute_shop.wholesale_price, product_shop.`wholesale_price`) wholesale_price, image_shop.`id_image` id_image, il.`legend` FROM `ps_cart_product` cp LEFT JOIN `ps_product` `p` ON p.`id_product` = cp.`id_product` INNER JOIN `ps_product_shop` product_shop ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`) LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 6 AND pl.id_shop = cp.id_shop LEFT JOIN `ps_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 6 AND cl.id_shop = cp.id_shop LEFT JOIN `ps_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier` LEFT JOIN ps_stock_available stock ON (stock.id_product = cp.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, 0) AND stock.id_shop_group = 1 AND stock.id_shop = 0 ) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute` LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`) 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 il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 6 WHERE (cp.`id_cart` = 72761) AND (p.`id_product` IS NOT NULL) ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC 1.8 1 /classes/Cart.php:382 SELECT SQL_NO_CACHE cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS `cart_quantity`, cp.`id_shop`, pl.`name`, p.`is_virtual`, pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`, p.`id_manufacturer`, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`, product_shop.`available_for_order`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price_ratio`, stock.`quantity` AS `quantity_available`, p.`width`, p.`height`, p.`depth`, p.`weight`, stock.`out_of_stock`, p.`date_add`, p.`date_upd`, IFNULL(stock.`quantity`, 0) AS `quantity`, pl.`link_rewrite`, cl.`link_rewrite` AS `category`, CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0)) AS unique_id, cp.`id_address_delivery`, product_shop.`advanced_stock_management`, ps.`product_supplier_reference` AS `supplier_reference`, NULL AS customization_quantity, NULL AS id_customization, product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr, IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference, (p.`weight`+ pa.`weight`) weight_attribute, IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13, IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc, IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity, IF(product_attribute_shop.wholesale_price > 0, product_attribute_shop.wholesale_price, product_shop.`wholesale_price`) wholesale_price, image_shop.`id_image` id_image, il.`legend` FROM `ps_cart_product` cp LEFT JOIN `ps_product` `p` ON p.`id_product` = cp.`id_product` INNER JOIN `ps_product_shop` product_shop ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`) LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 6 AND pl.id_shop = cp.id_shop LEFT JOIN `ps_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 6 AND cl.id_shop = cp.id_shop LEFT JOIN `ps_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier` LEFT JOIN ps_stock_available stock ON (stock.id_product = cp.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, 0) AND stock.id_shop_group = 1 AND stock.id_shop = 0 ) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute` LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`) 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 il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 6 WHERE (cp.`id_cart` = 72761) AND (p.`id_product` IS NOT NULL) ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC 1.7 1 /classes/Cart.php:382 SELECT SQL_NO_CACHE domain FROM `ps_shop_url` WHERE (main = 1) AND (active = 1) AND id_shop IN (2, 1) 1.6 2 /classes/shop/Shop.php:853 SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC 1.6 232 Yes /classes/Country.php:593 SELECT SQL_NO_CACHE MAX(image_shop.id_image) id_image, p.id_product, p.on_sale, p.show_price, il.legend, product_shop.active, pl.name, pl.description_short, pl.link_rewrite, cl.link_rewrite AS category_rewrite, DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(), INTERVAL 90 DAY)) > 0 AS new FROM ps_product p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN ps_product_lang pl ON (pl.id_product = p.id_product AND pl.id_lang = 6 AND pl.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 (il.id_image = image_shop.id_image AND il.id_lang = 6) LEFT JOIN ps_category_lang cl ON (cl.id_category = product_shop.id_category_default AND cl.id_lang = 6 AND cl.id_shop = 1 ) WHERE p.id_product IN (900,1155,1139,976) GROUP BY product_shop.id_product 1.5 4 /modules/blockviewed_mod/blockviewed_mod.php:315 SELECT SQL_NO_CACHE cr.*, crl.`id_lang`, crl.`name`, cd.`id_cart` FROM `ps_cart_cart_rule` cd LEFT JOIN `ps_cart_rule` `cr` ON cd.`id_cart_rule` = cr.`id_cart_rule` LEFT JOIN `ps_cart_rule_lang` `crl` ON cd.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 6 WHERE (`id_cart` = 72761) AND (`reduction_percent` != 0 OR `reduction_amount` != 0) ORDER BY cr.`priority` ASC 1.5 1 Yes /classes/Cart.php:2352 SELECT SQL_NO_CACHE sec.*, secl.`title`, secl.`url`, secl.`text`, st_easy_content_shop.`id_shop` FROM `ps_st_easy_content` sec INNER JOIN ps_st_easy_content_shop st_easy_content_shop ON (st_easy_content_shop.id_st_easy_content = sec.id_st_easy_content AND st_easy_content_shop.id_shop = 1) LEFT JOIN `ps_st_easy_content_lang` secl ON (sec.`id_st_easy_content` = secl.`id_st_easy_content`) WHERE secl.`id_lang` = 6 AND sec.`location` IN (34) AND sec.`active`=1 ORDER BY sec.`position`, sec.`location` 1.5 22 Yes /modules/steasycontent/StEasyContentClass.php:173 SELECT SQL_NO_CACHE sec.*, secl.`title`, secl.`url`, secl.`text`, st_easy_content_shop.`id_shop` FROM `ps_st_easy_content` sec INNER JOIN ps_st_easy_content_shop st_easy_content_shop ON (st_easy_content_shop.id_st_easy_content = sec.id_st_easy_content AND st_easy_content_shop.id_shop = 1) LEFT JOIN `ps_st_easy_content_lang` secl ON (sec.`id_st_easy_content` = secl.`id_st_easy_content`) WHERE secl.`id_lang` = 6 AND sec.`location` IN (12,48,49,50,51,91,92,93,94,52,57) AND sec.`active`=1 ORDER BY sec.`position`, sec.`location` 1.4 22 Yes /modules/steasycontent/StEasyContentClass.php:173 SELECT SQL_NO_CACHE * FROM `ps_hbp_block` AS a INNER JOIN `ps_hbp_block_lang` AS b ON a.id=b.id WHERE a.hook="leftColumn" AND active=1 AND b.id_lang=6 AND shop="1" ORDER BY a.position 1.4 88 Yes /modules/htmlboxpro/htmlboxpro.php:484 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` = 2) AND (s.`active` = 1) AND (s.`deleted` = 0) AND (su.`main` = 1) LIMIT 1 1.3 1 /classes/shop/Shop.php:172 SELECT SQL_NO_CACHE d.`price` FROM `ps_delivery` d LEFT JOIN `ps_range_weight` `w` ON d.`id_range_weight` = w.`id_range_weight` WHERE (d.`id_zone` = 9) AND (10 >= w.`delimiter1`) AND (10 < w.`delimiter2`) AND (d.`id_carrier` = 288 AND d.id_delivery = ( SELECT d2.id_delivery FROM ps_delivery d2 WHERE d2.id_carrier = `d`.id_carrier AND d2.id_zone = `d`.id_zone AND d2.`id_range_weight` = `d`.`id_range_weight` AND (d2.id_shop = 1 OR (d2.id_shop_group = 1 AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL)) ORDER BY d2.id_shop DESC, d2.id_shop_group DESC LIMIT 1 )) ORDER BY w.`delimiter1` ASC LIMIT 1 1.3 144 Yes /classes/Carrier.php:1340 SELECT SQL_NO_CACHE sec.*, secl.`title`, secl.`url`, secl.`text`, st_easy_content_shop.`id_shop` FROM `ps_st_easy_content` sec INNER JOIN ps_st_easy_content_shop st_easy_content_shop ON (st_easy_content_shop.id_st_easy_content = sec.id_st_easy_content AND st_easy_content_shop.id_shop = 1) LEFT JOIN `ps_st_easy_content_lang` secl ON (sec.`id_st_easy_content` = secl.`id_st_easy_content`) WHERE secl.`id_lang` = 6 AND sec.`location` IN (14) AND sec.`active`=1 ORDER BY sec.`position`, sec.`location` 1.2 22 Yes /modules/steasycontent/StEasyContentClass.php:173 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` WHERE (cs.`id_shop` = 1) AND (c.`active` = 1) LIMIT 1 1.2 6 /classes/Currency.php:477 SELECT SQL_NO_CACHE sec.*, secl.`title`, secl.`url`, secl.`text`, st_easy_content_shop.`id_shop` FROM `ps_st_easy_content` sec INNER JOIN ps_st_easy_content_shop st_easy_content_shop ON (st_easy_content_shop.id_st_easy_content = sec.id_st_easy_content AND st_easy_content_shop.id_shop = 1) LEFT JOIN `ps_st_easy_content_lang` secl ON (sec.`id_st_easy_content` = secl.`id_st_easy_content`) WHERE secl.`id_lang` = 6 AND sec.`location` IN (36,98) AND sec.`active`=1 ORDER BY sec.`position`, sec.`location` 1.2 22 Yes /modules/steasycontent/StEasyContentClass.php:173 SELECT SQL_NO_CACHE c.*, cl.`delay` FROM `ps_carrier` c LEFT JOIN `ps_carrier_lang` `cl` ON c.`id_carrier` = cl.`id_carrier` AND cl.`id_lang` = 6 AND cl.id_shop = 1 LEFT JOIN `ps_carrier_zone` `cz` ON cz.`id_carrier` = c.`id_carrier` INNER JOIN ps_carrier_shop carrier_shop ON (carrier_shop.id_carrier = c.id_carrier AND carrier_shop.id_shop = 1) LEFT JOIN `ps_zone` `z` ON z.`id_zone` = 9 WHERE (c.`deleted` = 0) AND (cz.`id_zone` = 9) AND (z.`active` = 1) AND (c.`active` = 1) AND (EXISTS (SELECT 1 FROM ps_carrier_group WHERE ps_carrier_group.id_carrier = c.id_carrier AND id_group IN (3))) AND (c.`is_module` = 0 OR c.`need_range` = 1) GROUP BY c.`id_carrier` ORDER BY c.`position` ASC 1.2 4 Yes Yes /classes/Carrier.php:910 SELECT SQL_NO_CACHE cr.*, crl.`id_lang`, crl.`name`, cd.`id_cart` FROM `ps_cart_cart_rule` cd LEFT JOIN `ps_cart_rule` `cr` ON cd.`id_cart_rule` = cr.`id_cart_rule` LEFT JOIN `ps_cart_rule_lang` `crl` ON cd.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 6 WHERE (`id_cart` = 72761) AND (`gift_product` = 0) ORDER BY cr.`priority` ASC 1.2 1 Yes /classes/Cart.php:2352 SELECT SQL_NO_CACHE d.`price` FROM `ps_delivery` d INNER JOIN `ps_range_weight` w ON d.`id_range_weight` = w.`id_range_weight` WHERE (d.`id_zone` = 9) AND (d.`id_carrier` = 268 AND d.id_delivery = ( SELECT d2.id_delivery FROM ps_delivery d2 WHERE d2.id_carrier = `d`.id_carrier AND d2.id_zone = `d`.id_zone AND d2.`id_range_weight` = `d`.`id_range_weight` AND (d2.id_shop = 1 OR (d2.id_shop_group = 1 AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL)) ORDER BY d2.id_shop DESC, d2.id_shop_group DESC LIMIT 1 )) ORDER BY w.`delimiter2` DESC LIMIT 1 1.1 36 Yes /classes/Carrier.php:972 SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE (`name` = 'ph_simpleblog') LIMIT 1 1.1 0 /classes/module/Module.php:1670 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 ms.`id_module` = m.`id_module` AND ms.`id_shop` = 1 1.1 112 /classes/module/Module.php:214 SELECT SQL_NO_CACHE d.`price` FROM `ps_delivery` d LEFT JOIN `ps_range_price` `r` ON d.`id_range_price` = r.`id_range_price` WHERE (d.`id_zone` = 9) AND (31.95 >= r.`delimiter1`) AND (31.95 < r.`delimiter2`) AND (d.`id_carrier` = 288 AND d.id_delivery = ( SELECT d2.id_delivery FROM ps_delivery d2 WHERE d2.id_carrier = `d`.id_carrier AND d2.id_zone = `d`.id_zone AND d2.`id_range_price` = `d`.`id_range_price` AND (d2.id_shop = 1 OR (d2.id_shop_group = 1 AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL)) ORDER BY d2.id_shop DESC, d2.id_shop_group DESC LIMIT 1 )) ORDER BY r.`delimiter1` ASC LIMIT 1 1.1 2 Yes /classes/Carrier.php:1089 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` = 6 WHERE (cr.`date_from` < '2019-02-03 00:26:50') AND (cr.`date_to` > '2019-02-03 00:26:50') AND (cr.`active` = 1) AND (`free_shipping` = 1) AND (`carrier_restriction` = 1) AND (cr.`id_customer` = 0 OR cr.`group_restriction` = 1) 1.1 90 /classes/CartRule.php:357 SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE (`name` = 'myparcel') LIMIT 1 1 1 /classes/module/Module.php:1670 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` = 6 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 900) AND (b.`id_shop` = 1) LIMIT 1 1 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1 1 110 /classes/SpecificPrice.php:370 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` = 6 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 1155) AND (b.`id_shop` = 1) LIMIT 1 1 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE spg.*, spgl.`title` FROM `ps_st_parallax_group` spg INNER JOIN ps_st_parallax_group_shop st_parallax_group_shop ON (st_parallax_group_shop.id_st_parallax_group = spg.id_st_parallax_group AND st_parallax_group_shop.id_shop = 1) LEFT JOIN `ps_st_parallax_group_lang` spgl ON (spg.`id_st_parallax_group` = spgl.`id_st_parallax_group`) WHERE spg.`active`=1 AND spgl.`id_lang` = 6 AND spg.`location` IN (3) ORDER BY spg.`position` 0.9 1 Yes /modules/stparallax/StParallaxGroup.php:263 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` = 6 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 579) AND (b.`id_shop` = 1) LIMIT 1 0.9 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE spg.*, spgl.`title` FROM `ps_st_parallax_group` spg INNER JOIN ps_st_parallax_group_shop st_parallax_group_shop ON (st_parallax_group_shop.id_st_parallax_group = spg.id_st_parallax_group AND st_parallax_group_shop.id_shop = 1) LEFT JOIN `ps_st_parallax_group_lang` spgl ON (spg.`id_st_parallax_group` = spgl.`id_st_parallax_group`) WHERE spg.`active`=1 AND spgl.`id_lang` = 6 AND spg.`location` IN (28) ORDER BY spg.`position` 0.9 1 Yes /modules/stparallax/StParallaxGroup.php:263 SELECT SQL_NO_CACHE d.`price` FROM `ps_delivery` d LEFT JOIN `ps_range_weight` `w` ON d.`id_range_weight` = w.`id_range_weight` WHERE (d.`id_zone` = 9) AND (10 >= w.`delimiter1`) AND (10 < w.`delimiter2`) AND (d.`id_carrier` = 268 AND d.id_delivery = ( SELECT d2.id_delivery FROM ps_delivery d2 WHERE d2.id_carrier = `d`.id_carrier AND d2.id_zone = `d`.id_zone AND d2.`id_range_weight` = `d`.`id_range_weight` AND (d2.id_shop = 1 OR (d2.id_shop_group = 1 AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL)) ORDER BY d2.id_shop DESC, d2.id_shop_group DESC LIMIT 1 )) ORDER BY w.`delimiter1` ASC LIMIT 1 0.9 36 Yes /classes/Carrier.php:1038 SELECT SQL_NO_CACHE COUNT(DISTINCT l.`id_lang`) FROM `ps_lang` l INNER JOIN `ps_lang_shop` ls ON ls.`id_lang` = l.`id_lang` WHERE (ls.`id_shop` = 1) AND (l.`active` = 1) LIMIT 1 0.9 7 /classes/Language.php:382 SELECT SQL_NO_CACHE spg.*, spgl.`title` FROM `ps_st_parallax_group` spg INNER JOIN ps_st_parallax_group_shop st_parallax_group_shop ON (st_parallax_group_shop.id_st_parallax_group = spg.id_st_parallax_group AND st_parallax_group_shop.id_shop = 1) LEFT JOIN `ps_st_parallax_group_lang` spgl ON (spg.`id_st_parallax_group` = spgl.`id_st_parallax_group`) WHERE spg.`active`=1 AND spgl.`id_lang` = 6 AND spg.`location` IN (4) ORDER BY spg.`position` 0.9 1 Yes /modules/stparallax/StParallaxGroup.php:263 SELECT SQL_NO_CACHE smlg.*,smlgl.`name`,smlgl.`url` FROM `ps_st_multi_link_group` smlg INNER JOIN ps_st_multi_link_group_shop st_multi_link_group_shop ON (st_multi_link_group_shop.id_st_multi_link_group = smlg.id_st_multi_link_group AND st_multi_link_group_shop.id_shop = 1) LEFT JOIN `ps_st_multi_link_group_lang` smlgl ON (smlg.`id_st_multi_link_group` = smlgl.`id_st_multi_link_group`) WHERE smlg.`active`=1 AND smlg.`location` IN (6,10,11,12,13,26) AND smlgl.`id_lang` = 6 ORDER BY smlg.`position` 0.9 10 Yes /modules/stmultilink/StMultiLinkGroup.php:145 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 = 'website.nl' OR su.domain_ssl = 'website.nl') AND (s.`active` = 1) AND (s.`deleted` = 0) 0.9 2 /classes/shop/Shop.php:345 SELECT SQL_NO_CACHE smsg.* FROM `ps_st_iosslider_group` smsg INNER JOIN ps_st_iosslider_group_shop st_iosslider_group_shop ON (st_iosslider_group_shop.id_st_iosslider_group = smsg.id_st_iosslider_group AND st_iosslider_group_shop.id_shop = 1) WHERE smsg.`active`=1 AND smsg.`location` IN (20) ORDER BY smsg.`position` 0.8 1 Yes /modules/stiosslider/StIosSliderGroup.php:267 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` = 579) LIMIT 1 0.8 1 /Adapter/Adapter_EntityMapper.php:80 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) ORDER BY `name` ASC 0.8 2 Yes /classes/Currency.php:349 SELECT SQL_NO_CACHE * FROM `ps_employee` a LEFT JOIN `ps_employee_shop` `c` ON a.`id_employee` = c.`id_employee` AND c.`id_shop` = 1 WHERE (a.`id_employee` = 1) LIMIT 1 0.8 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE smlg.*,smlgl.`name`,smlgl.`url` FROM `ps_st_multi_link_group` smlg INNER JOIN ps_st_multi_link_group_shop st_multi_link_group_shop ON (st_multi_link_group_shop.id_st_multi_link_group = smlg.id_st_multi_link_group AND st_multi_link_group_shop.id_shop = 1) LEFT JOIN `ps_st_multi_link_group_lang` smlgl ON (smlg.`id_st_multi_link_group` = smlgl.`id_st_multi_link_group`) WHERE smlg.`active`=1 AND smlg.`location` IN (2) AND smlgl.`id_lang` = 6 ORDER BY smlg.`position` 0.8 10 Yes /modules/stmultilink/StMultiLinkGroup.php:145 SELECT SQL_NO_CACHE `id_configuration` FROM `ps_configuration` WHERE name = 'PAYPAL_HOME' AND id_shop = 1 LIMIT 1 0.8 3 /classes/Configuration.php:753 SELECT SQL_NO_CACHE d.`price` FROM `ps_delivery` d LEFT JOIN `ps_range_weight` `w` ON d.`id_range_weight` = w.`id_range_weight` WHERE (d.`id_zone` = 9) AND (10 >= w.`delimiter1`) AND (10 < w.`delimiter2`) AND (d.`id_carrier` = 288 AND d.id_delivery = ( SELECT d2.id_delivery FROM ps_delivery d2 WHERE d2.id_carrier = `d`.id_carrier AND d2.id_zone = `d`.id_zone AND d2.`id_range_weight` = `d`.`id_range_weight` AND (d2.id_shop = 1 OR (d2.id_shop_group = 1 AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL)) ORDER BY d2.id_shop DESC, d2.id_shop_group DESC LIMIT 1 )) ORDER BY w.`delimiter1` ASC LIMIT 1 0.8 144 Yes /classes/Carrier.php:1038 SELECT SQL_NO_CACHE d.`price` FROM `ps_delivery` d INNER JOIN `ps_range_weight` w ON d.`id_range_weight` = w.`id_range_weight` WHERE (d.`id_zone` = 9) AND (d.`id_carrier` = 288 AND d.id_delivery = ( SELECT d2.id_delivery FROM ps_delivery d2 WHERE d2.id_carrier = `d`.id_carrier AND d2.id_zone = `d`.id_zone AND d2.`id_range_weight` = `d`.`id_range_weight` AND (d2.id_shop = 1 OR (d2.id_shop_group = 1 AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL)) ORDER BY d2.id_shop DESC, d2.id_shop_group DESC LIMIT 1 )) ORDER BY w.`delimiter2` DESC LIMIT 1 0.8 144 Yes /classes/Carrier.php:972 SELECT SQL_NO_CACHE * FROM `ps_carrier` a LEFT JOIN `ps_carrier_lang` `b` ON a.`id_carrier` = b.`id_carrier` AND b.`id_lang` = 6 LEFT JOIN `ps_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = 1 WHERE (a.`id_carrier` = 285) AND (b.`id_shop` = 1) LIMIT 1 0.8 1 /Adapter/Adapter_EntityMapper.php:80 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` = 6 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 1139) AND (b.`id_shop` = 1) LIMIT 1 0.7 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE smsg.* FROM `ps_st_iosslider_group` smsg INNER JOIN ps_st_iosslider_group_shop st_iosslider_group_shop ON (st_iosslider_group_shop.id_st_iosslider_group = smsg.id_st_iosslider_group AND st_iosslider_group_shop.id_shop = 1) WHERE smsg.`active`=1 AND smsg.`location` IN (4) ORDER BY smsg.`position` 0.7 1 Yes /modules/stiosslider/StIosSliderGroup.php:267 SELECT SQL_NO_CACHE d.`price` FROM `ps_delivery` d INNER JOIN `ps_range_weight` w ON d.`id_range_weight` = w.`id_range_weight` WHERE (d.`id_zone` = 9) AND (d.`id_carrier` = 280 AND d.id_delivery = ( SELECT d2.id_delivery FROM ps_delivery d2 WHERE d2.id_carrier = `d`.id_carrier AND d2.id_zone = `d`.id_zone AND d2.`id_range_weight` = `d`.`id_range_weight` AND (d2.id_shop = 1 OR (d2.id_shop_group = 1 AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL)) ORDER BY d2.id_shop DESC, d2.id_shop_group DESC LIMIT 1 )) ORDER BY w.`delimiter2` DESC LIMIT 1 0.7 16 Yes /classes/Carrier.php:972 SELECT SQL_NO_CACHE SUM(`quantity`) FROM `ps_cart_product` WHERE (`id_cart` = 72761) LIMIT 1 0.7 1 /classes/Cart.php:2970 SELECT SQL_NO_CACHE spg.*, spgl.`title` FROM `ps_st_parallax_group` spg INNER JOIN ps_st_parallax_group_shop st_parallax_group_shop ON (st_parallax_group_shop.id_st_parallax_group = spg.id_st_parallax_group AND st_parallax_group_shop.id_shop = 1) LEFT JOIN `ps_st_parallax_group_lang` spgl ON (spg.`id_st_parallax_group` = spgl.`id_st_parallax_group`) WHERE spg.`active`=1 AND spgl.`id_lang` = 6 AND spg.`location` IN (35) ORDER BY spg.`position` 0.7 1 Yes /modules/stparallax/StParallaxGroup.php:263 SELECT SQL_NO_CACHE smlg.*,smlgl.`name`,smlgl.`url` FROM `ps_st_multi_link_group` smlg INNER JOIN ps_st_multi_link_group_shop st_multi_link_group_shop ON (st_multi_link_group_shop.id_st_multi_link_group = smlg.id_st_multi_link_group AND st_multi_link_group_shop.id_shop = 1) LEFT JOIN `ps_st_multi_link_group_lang` smlgl ON (smlg.`id_st_multi_link_group` = smlgl.`id_st_multi_link_group`) WHERE smlg.`active`=1 AND smlg.`location` IN (1) AND smlgl.`id_lang` = 6 ORDER BY smlg.`position` 0.7 10 Yes /modules/stmultilink/StMultiLinkGroup.php:145 SELECT SQL_NO_CACHE * FROM `ps_myparcel_carrier_delivery_setting` pcds WHERE (pcds.`id_reference` = 215) LIMIT 1 0.7 10 /modules/myparcel/classes/MyParcelCarrierDeliverySetting.php:488 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` = 6 LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1 WHERE (a.`id_cms` = 45) AND (b.`id_shop` = 1) LIMIT 1 0.7 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE smlg.*,smlgl.`name`,smlgl.`url` FROM `ps_st_multi_link_group` smlg INNER JOIN ps_st_multi_link_group_shop st_multi_link_group_shop ON (st_multi_link_group_shop.id_st_multi_link_group = smlg.id_st_multi_link_group AND st_multi_link_group_shop.id_shop = 1) LEFT JOIN `ps_st_multi_link_group_lang` smlgl ON (smlg.`id_st_multi_link_group` = smlgl.`id_st_multi_link_group`) WHERE smlg.`active`=1 AND smlg.`location` IN (22) AND smlgl.`id_lang` = 6 ORDER BY smlg.`position` 0.7 10 Yes /modules/stmultilink/StMultiLinkGroup.php:145 SELECT SQL_NO_CACHE spg.*, spgl.`title` FROM `ps_st_parallax_group` spg INNER JOIN ps_st_parallax_group_shop st_parallax_group_shop ON (st_parallax_group_shop.id_st_parallax_group = spg.id_st_parallax_group AND st_parallax_group_shop.id_shop = 1) LEFT JOIN `ps_st_parallax_group_lang` spgl ON (spg.`id_st_parallax_group` = spgl.`id_st_parallax_group`) WHERE spg.`active`=1 AND spgl.`id_lang` = 6 AND spg.`location` IN (37) ORDER BY spg.`position` 0.7 1 Yes /modules/stparallax/StParallaxGroup.php:263 SELECT SQL_NO_CACHE spg.*, spgl.`title` FROM `ps_st_parallax_group` spg INNER JOIN ps_st_parallax_group_shop st_parallax_group_shop ON (st_parallax_group_shop.id_st_parallax_group = spg.id_st_parallax_group AND st_parallax_group_shop.id_shop = 1) LEFT JOIN `ps_st_parallax_group_lang` spgl ON (spg.`id_st_parallax_group` = spgl.`id_st_parallax_group`) WHERE spg.`active`=1 AND spgl.`id_lang` = 6 AND spg.`location` IN (17) ORDER BY spg.`position` 0.7 1 Yes /modules/stparallax/StParallaxGroup.php:263 SELECT SQL_NO_CACHE * FROM `ps_myparcel_carrier_delivery_setting` pcds WHERE (pcds.`id_reference` = 215) LIMIT 1 0.7 10 /modules/myparcel/classes/MyParcelCarrierDeliverySetting.php:488 SELECT SQL_NO_CACHE smsg.* FROM `ps_st_banner_group` smsg INNER JOIN ps_st_banner_group_shop st_banner_group_shop ON (st_banner_group_shop.id_st_banner_group = smsg.id_st_banner_group AND st_banner_group_shop.id_shop = 1) WHERE smsg.`active`=1 AND smsg.`id_parent`=0 AND smsg.`location` IN (21) ORDER BY smsg.`position` 0.7 8 Yes /modules/stbanner/StBannerGroup.php:262 SELECT SQL_NO_CACHE d.`price` FROM `ps_delivery` d LEFT JOIN `ps_range_weight` `w` ON d.`id_range_weight` = w.`id_range_weight` WHERE (d.`id_zone` = 9) AND (10 >= w.`delimiter1`) AND (10 < w.`delimiter2`) AND (d.`id_carrier` = 280 AND d.id_delivery = ( SELECT d2.id_delivery FROM ps_delivery d2 WHERE d2.id_carrier = `d`.id_carrier AND d2.id_zone = `d`.id_zone AND d2.`id_range_weight` = `d`.`id_range_weight` AND (d2.id_shop = 1 OR (d2.id_shop_group = 1 AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL)) ORDER BY d2.id_shop DESC, d2.id_shop_group DESC LIMIT 1 )) ORDER BY w.`delimiter1` ASC LIMIT 1 0.7 16 Yes /classes/Carrier.php:1038 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` = 5) AND (m.`page` = 'index') LIMIT 1 0.7 1 /classes/Theme.php:372 SELECT SQL_NO_CACHE * FROM `ps_image_type` 0.7 36 /classes/ImageType.php:199 SELECT SQL_NO_CACHE smlg.*,smlgl.`name`,smlgl.`url` FROM `ps_st_multi_link_group` smlg INNER JOIN ps_st_multi_link_group_shop st_multi_link_group_shop ON (st_multi_link_group_shop.id_st_multi_link_group = smlg.id_st_multi_link_group AND st_multi_link_group_shop.id_shop = 1) LEFT JOIN `ps_st_multi_link_group_lang` smlgl ON (smlg.`id_st_multi_link_group` = smlgl.`id_st_multi_link_group`) WHERE smlg.`active`=1 AND smlg.`location` IN (23) AND smlgl.`id_lang` = 6 ORDER BY smlg.`position` 0.7 10 Yes /modules/stmultilink/StMultiLinkGroup.php:145 SELECT SQL_NO_CACHE smlg.*,smlgl.`name`,smlgl.`url` FROM `ps_st_multi_link_group` smlg INNER JOIN ps_st_multi_link_group_shop st_multi_link_group_shop ON (st_multi_link_group_shop.id_st_multi_link_group = smlg.id_st_multi_link_group AND st_multi_link_group_shop.id_shop = 1) LEFT JOIN `ps_st_multi_link_group_lang` smlgl ON (smlg.`id_st_multi_link_group` = smlgl.`id_st_multi_link_group`) WHERE smlg.`active`=1 AND smlg.`location` IN (1,9,31,32,33) AND smlgl.`id_lang` = 6 ORDER BY smlg.`position` 0.7 10 Yes /modules/stmultilink/StMultiLinkGroup.php:145 SELECT SQL_NO_CACHE * FROM `ps_meta` m LEFT JOIN `ps_meta_lang` `ml` ON m.`id_meta` = ml.`id_meta` WHERE (m.`page` = 'index' OR m.`page` = 'index') AND (ml.`id_lang` = 6 AND ml.id_shop = 1 ) LIMIT 1 0.7 1 /classes/Meta.php:368 SELECT SQL_NO_CACHE spg.*, spgl.`title` FROM `ps_st_parallax_group` spg INNER JOIN ps_st_parallax_group_shop st_parallax_group_shop ON (st_parallax_group_shop.id_st_parallax_group = spg.id_st_parallax_group AND st_parallax_group_shop.id_shop = 1) LEFT JOIN `ps_st_parallax_group_lang` spgl ON (spg.`id_st_parallax_group` = spgl.`id_st_parallax_group`) WHERE spg.`active`=1 AND spgl.`id_lang` = 6 AND spg.`location` IN (36) ORDER BY spg.`position` 0.7 1 Yes /modules/stparallax/StParallaxGroup.php:263 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` = 13 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.7 0 /classes/tax/TaxRulesTaxManager.php:130 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='a49c2cfcd1d7feecfb8f4397f29ae86c' AND cache_id="stparallax|1|1|3|3|13" AND compile_id="" LIMIT 1 0.6 1 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE d.`price` FROM `ps_delivery` d LEFT JOIN `ps_range_weight` `w` ON d.`id_range_weight` = w.`id_range_weight` WHERE (d.`id_zone` = 9) AND (10 >= w.`delimiter1`) AND (10 < w.`delimiter2`) AND (d.`id_carrier` = 228 AND d.id_delivery = ( SELECT d2.id_delivery FROM ps_delivery d2 WHERE d2.id_carrier = `d`.id_carrier AND d2.id_zone = `d`.id_zone AND d2.`id_range_weight` = `d`.`id_range_weight` AND (d2.id_shop = 1 OR (d2.id_shop_group = 1 AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL)) ORDER BY d2.id_shop DESC, d2.id_shop_group DESC LIMIT 1 )) ORDER BY w.`delimiter1` ASC LIMIT 1 0.6 8 Yes /classes/Carrier.php:1038 SELECT SQL_NO_CACHE smsg.* FROM `ps_st_iosslider_group` smsg INNER JOIN ps_st_iosslider_group_shop st_iosslider_group_shop ON (st_iosslider_group_shop.id_st_iosslider_group = smsg.id_st_iosslider_group AND st_iosslider_group_shop.id_shop = 1) WHERE smsg.`active`=1 AND smsg.`location` IN (19) ORDER BY smsg.`position` 0.6 1 Yes /modules/stiosslider/StIosSliderGroup.php:267 SELECT SQL_NO_CACHE d.`price` FROM `ps_delivery` d INNER JOIN `ps_range_weight` w ON d.`id_range_weight` = w.`id_range_weight` WHERE (d.`id_zone` = 9) AND (d.`id_carrier` = 228 AND d.id_delivery = ( SELECT d2.id_delivery FROM ps_delivery d2 WHERE d2.id_carrier = `d`.id_carrier AND d2.id_zone = `d`.id_zone AND d2.`id_range_weight` = `d`.`id_range_weight` AND (d2.id_shop = 1 OR (d2.id_shop_group = 1 AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL)) ORDER BY d2.id_shop DESC, d2.id_shop_group DESC LIMIT 1 )) ORDER BY w.`delimiter2` DESC LIMIT 1 0.6 8 Yes /classes/Carrier.php:972 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.6 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8c0d61a44bbf200fbb22ded0497e16b0' AND cache_id="stmegamenu|1|1|3|3|13" AND compile_id="" LIMIT 1 0.6 1 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE * FROM `ps_hook_alias` 0.6 86 /classes/Hook.php:692 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.6 1 /classes/shop/Shop.php:172 SELECT SQL_NO_CACHE smsg.* FROM `ps_st_iosslider_group` smsg INNER JOIN ps_st_iosslider_group_shop st_iosslider_group_shop ON (st_iosslider_group_shop.id_st_iosslider_group = smsg.id_st_iosslider_group AND st_iosslider_group_shop.id_shop = 1) WHERE smsg.`active`=1 AND smsg.`location` IN (3) ORDER BY smsg.`position` 0.6 1 Yes /modules/stiosslider/StIosSliderGroup.php:267 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` = 6) LIMIT 1 0.6 1 /Adapter/Adapter_EntityMapper.php:80 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.6 5 /classes/Language.php:166 SELECT SQL_NO_CACHE smsg.* FROM `ps_st_iosslider_group` smsg INNER JOIN ps_st_iosslider_group_shop st_iosslider_group_shop ON (st_iosslider_group_shop.id_st_iosslider_group = smsg.id_st_iosslider_group AND st_iosslider_group_shop.id_shop = 1) WHERE smsg.`active`=1 AND smsg.`location` IN (18) ORDER BY smsg.`position` 0.6 1 Yes /modules/stiosslider/StIosSliderGroup.php:267 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` = 109 LIMIT 1 0.6 0 /classes/Category.php:751 SELECT SQL_NO_CACHE smsg.* FROM `ps_st_banner_group` smsg INNER JOIN ps_st_banner_group_shop st_banner_group_shop ON (st_banner_group_shop.id_st_banner_group = smsg.id_st_banner_group AND st_banner_group_shop.id_shop = 1) WHERE smsg.`active`=1 AND smsg.`id_parent`=0 AND smsg.`location` IN (3) ORDER BY smsg.`position` 0.6 8 Yes /modules/stbanner/StBannerGroup.php:262 SELECT SQL_NO_CACHE smsg.* FROM `ps_st_iosslider_group` smsg INNER JOIN ps_st_iosslider_group_shop st_iosslider_group_shop ON (st_iosslider_group_shop.id_st_iosslider_group = smsg.id_st_iosslider_group AND st_iosslider_group_shop.id_shop = 1) WHERE smsg.`active`=1 AND smsg.`location` IN (17) ORDER BY smsg.`position` 0.6 1 Yes /modules/stiosslider/StIosSliderGroup.php:267 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9185c878935e8759fdd770e83c8685cd' AND cache_id LIKE "stiosslider|1|1|3|3|13_19_location%" 0.6 1 /classes/SmartyCustom.php:128 SELECT SQL_NO_CACHE smlg.*,smlgl.`name`,smlgl.`url` FROM `ps_st_multi_link_group` smlg INNER JOIN ps_st_multi_link_group_shop st_multi_link_group_shop ON (st_multi_link_group_shop.id_st_multi_link_group = smlg.id_st_multi_link_group AND st_multi_link_group_shop.id_shop = 1) LEFT JOIN `ps_st_multi_link_group_lang` smlgl ON (smlg.`id_st_multi_link_group` = smlgl.`id_st_multi_link_group`) WHERE smlg.`active`=1 AND smlg.`location` IN (5,18,19,20,21,28) AND smlgl.`id_lang` = 6 ORDER BY smlg.`position` 0.6 10 Yes /modules/stmultilink/StMultiLinkGroup.php:145 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='a35a71afbe01c3d7e292e8edc3b7e311' AND cache_id="blocksearch_mod|1|1|3|3|13_blocksearch-top" AND compile_id="" LIMIT 1 0.6 1 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 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` = 0) AND (`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2019-02-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-02-03 00:00:00' <= `to`)) 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, `to` DESC, `from` DESC LIMIT 1 0.6 1 Yes /classes/SpecificPrice.php:236 SELECT SQL_NO_CACHE smsg.* FROM `ps_st_iosslider_group` smsg INNER JOIN ps_st_iosslider_group_shop st_iosslider_group_shop ON (st_iosslider_group_shop.id_st_iosslider_group = smsg.id_st_iosslider_group AND st_iosslider_group_shop.id_shop = 1) WHERE smsg.`active`=1 AND smsg.`location` IN (21) ORDER BY smsg.`position` 0.6 1 Yes /modules/stiosslider/StIosSliderGroup.php:267 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.6 2 Yes /classes/shop/Shop.php:745 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` = 13 AND tr.`id_tax_rules_group` = 5 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.6 1 /classes/tax/TaxRulesTaxManager.php:130 SELECT SQL_NO_CACHE `width`, `height` FROM `ps_image_type` WHERE (`name` = 'cart_default') LIMIT 1 0.6 1 /classes/Image.php:587 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.6 2 Yes /classes/Currency.php:349 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 579) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1 0.6 1 /classes/stock/StockAvailable.php:414 SELECT SQL_NO_CACHE * FROM `ps_cart` a WHERE (a.`id_cart` = 72761) LIMIT 1 0.6 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE smlg.*,smlgl.`name`,smlgl.`url` FROM `ps_st_multi_link_group` smlg INNER JOIN ps_st_multi_link_group_shop st_multi_link_group_shop ON (st_multi_link_group_shop.id_st_multi_link_group = smlg.id_st_multi_link_group AND st_multi_link_group_shop.id_shop = 1) LEFT JOIN `ps_st_multi_link_group_lang` smlgl ON (smlg.`id_st_multi_link_group` = smlgl.`id_st_multi_link_group`) WHERE smlg.`active`=1 AND smlg.`location` IN (9) AND smlgl.`id_lang` = 6 ORDER BY smlg.`position` 0.6 10 Yes /modules/stmultilink/StMultiLinkGroup.php:145 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` = 285) LIMIT 1 0.6 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE (`name` = 'paypal') LIMIT 1 0.6 1 /classes/module/Module.php:1670 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='304d53bf0eba28e71117437bc0971f84' AND cache_id="stpagebanner|1|1|3|3|13" AND compile_id="" LIMIT 1 0.5 1 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='b1883f06a4c71c9451c8d11799f04cfd' AND cache_id="stmultilink|1|1|3|3|13_2_location" AND compile_id="" LIMIT 1 0.5 0 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) AS last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1 0.5 1 /classes/SmartyCustom.php:192 SELECT SQL_NO_CACHE id_shop FROM `ps_employee_shop` WHERE `id_employee` = 1 0.5 2 /classes/ObjectModel.php:1695 SELECT SQL_NO_CACHE `domain`, `domain_ssl` FROM `ps_shop_url` WHERE (`main` = 1) AND (`id_shop` = 1) LIMIT 1 0.5 1 /classes/shop/ShopUrl.php:246 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='932813e5e4f7143165a72622fc36f90b' AND cache_id="stmegamenu|1|1|3|3|13_column" AND compile_id="" LIMIT 1 0.5 1 /classes/SmartyCustom.php:300 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='8416421650a135f3c429ded30bf2dc2f' AND cache_id LIKE "stparallax|1|1|3|3|13_28_location%" 0.5 1 /classes/SmartyCustom.php:128 SELECT SQL_NO_CACHE `width`, `height` FROM `ps_image_type` WHERE (`name` = 'small_default') LIMIT 1 0.5 1 /classes/Image.php:587 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` = 228) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE COUNT(*) FROM `ps_orders` WHERE (`id_cart` = 72761) LIMIT 1 0.5 1 /classes/Cart.php:2803 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8cdd914c5d6fe7edeb2e80e52311bac8' AND cache_id="blockcart_mod|1|1|3|3|13" AND compile_id="" LIMIT 1 0.5 1 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE (`name` = 'lgcookieslaw') LIMIT 1 0.5 1 /classes/module/Module.php:1670 SELECT SQL_NO_CACHE * FROM `ps_cms_category_lang` WHERE (`id_cms_category` = 6) AND (`id_shop` = 1) 0.5 5 /Adapter/Adapter_EntityMapper.php:88 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='8416421650a135f3c429ded30bf2dc2f' AND cache_id LIKE "stparallax|1|1|3|3|13_17_location%" 0.5 1 /classes/SmartyCustom.php:128 SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0 0.5 217 /classes/SpecificPrice.php:380 SELECT SQL_NO_CACHE * FROM `ps_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_carrier` a LEFT JOIN `ps_carrier_lang` `b` ON a.`id_carrier` = b.`id_carrier` AND b.`id_lang` = 6 LEFT JOIN `ps_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = 1 WHERE (a.`id_carrier` = 288) AND (b.`id_shop` = 1) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE SUM((p.`weight` + pa.`weight`) * cp.`quantity`) AS `nb` FROM `ps_cart_product` cp LEFT JOIN `ps_product` `p` ON cp.`id_product` = p.`id_product` LEFT JOIN `ps_product_attribute` `pa` ON cp.`id_product_attribute` = pa.`id_product_attribute` WHERE (cp.`id_product_attribute` IS NOT NULL) AND (cp.`id_product_attribute` != 0) AND (cp.`id_cart` = 72761) LIMIT 1 0.5 1 /classes/Cart.php:2168 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='6376e4a8fc7de233fa8a290ae64b21f9' AND cache_id="steasycontent|1|1|3|3|13" AND compile_id="" LIMIT 1 0.5 1 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE id_shop, id_lang, lang_iso, country_iso FROM `ps_pdgooglehreflangtagpro` WHERE `active` = 1 0.5 3 /modules/pdgooglehreflangtagpro/pdgooglehreflangtagpro.php:165 SELECT SQL_NO_CACHE `myparcel_delivery_option` FROM `ps_myparcel_delivery_option` WHERE (`id_cart` = 72761) LIMIT 1 0.5 0 /modules/myparcel/classes/MyParcelDeliveryOption.php:161 SELECT SQL_NO_CACHE * FROM `ps_configuration` WHERE (name = "TAWKTO_WIDGET_OPTS_1") 0.5 1 /modules/tawkto/tawkto.php:93 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='574c3264bb0c97037ffe6182b1383a70' AND cache_id="stmegamenu|1|1|3|3|13_stmegamenu" AND compile_id="" LIMIT 1 0.5 1 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE `id_cms_category` FROM `ps_cms` WHERE (`id_cms` = 45) LIMIT 1 0.5 1 /classes/Link.php:644 SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE (`name` = 'stblog') LIMIT 1 0.5 0 /classes/module/Module.php:1670 SELECT SQL_NO_CACHE `myparcel_delivery_option` FROM `ps_myparcel_delivery_option` WHERE (`id_cart` = 72761) LIMIT 1 0.5 0 /modules/myparcel/classes/MyParcelDeliveryOption.php:161 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='c07ab85e66988a1cbb07684b55097fc4' AND cache_id="homefeatured|1|1|3|3|13" AND compile_id="" LIMIT 1 0.5 1 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 0.4 1 /classes/shop/Shop.php:1273 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='ff7c7d459d1299d134fd1358c932872d' AND cache_id="stbanner|1|1|3|3|13_21_location" AND compile_id="" LIMIT 1 0.4 1 /classes/SmartyCustom.php:300 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='85a6fc45e84c28c0fe4b358862388bb5' AND cache_id LIKE "steasycontent|1|1|3|3|13_14_location%" 0.4 1 /classes/SmartyCustom.php:128 SELECT SQL_NO_CACHE id_carrier FROM `ps_product_carrier` pc INNER JOIN `ps_carrier` c ON c.`id_reference` = pc.`id_carrier_reference` AND c.`deleted` = 0 AND c.`active` = 1 WHERE (pc.`id_product` = 579) AND (pc.`id_shop` = 1) 0.4 1 /classes/Carrier.php:607 SELECT SQL_NO_CACHE `myparcel_delivery_option` FROM `ps_myparcel_delivery_option` WHERE (`id_cart` = 72761) LIMIT 1 0.4 0 /modules/myparcel/classes/MyParcelDeliveryOption.php:161 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9185c878935e8759fdd770e83c8685cd' AND cache_id="stiosslider|1|1|3|3|13_21_location" AND compile_id="" LIMIT 1 0.4 0 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='7b8a0a205f6a7f86caf15a6e2380ffbe' AND cache_id="stbanner|1|1|3|3|13" AND compile_id="" LIMIT 1 0.4 1 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='1ae0d81eccb840ae86654c324d03246e' AND cache_id="stmegamenu|1|1|3|3|13" AND compile_id="" LIMIT 1 0.4 1 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE (`id_product` = 579) AND (`id_shop` = 1) 0.4 5 /Adapter/Adapter_EntityMapper.php:88 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='b1883f06a4c71c9451c8d11799f04cfd' AND cache_id LIKE "stmultilink|1|1|3|3|13_2_location%" 0.4 1 /classes/SmartyCustom.php:128 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='588752dce70eeb5b5b5da4cda36a25ab' AND cache_id="blockcmsinfo|1|1|3|3|13" AND compile_id="" LIMIT 1 0.4 1 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE * FROM `ps_cms_category` a LEFT JOIN `ps_cms_category_shop` `c` ON a.`id_cms_category` = c.`id_cms_category` AND c.`id_shop` = 1 WHERE (a.`id_cms_category` = 6) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `ps_myparcel_carrier_delivery_setting` pcds WHERE (pcds.`id_reference` = 215) LIMIT 1 0.4 10 /modules/myparcel/classes/MyParcelCarrierDeliverySetting.php:488 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_carrier_tax_rules_group_shop` WHERE (`id_carrier` = 285) AND (`id_shop` = 1) LIMIT 1 0.4 3 /classes/Carrier.php:307 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9fcf5c0373b76723181ff3c9c5cc75fc' AND cache_id="steasycontent|1|1|3|3|13_3_location" AND compile_id="" LIMIT 1 0.4 1 /classes/SmartyCustom.php:300 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='8416421650a135f3c429ded30bf2dc2f' AND cache_id LIKE "stparallax|1|1|3|3|13_3_location%" 0.4 1 /classes/SmartyCustom.php:128 SELECT SQL_NO_CACHE * FROM `ps_theme` a WHERE (a.`id_theme` = 5) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='f8b7ae9bcefbb7c9e32c7909ed283299' AND cache_id="blocknewproducts-home|20190203|1|1|3|3|13" AND compile_id="" LIMIT 1 0.4 1 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 6 AND cl.id_shop = 1 AND cl.`id_category` = 113 LIMIT 1 0.4 1 /classes/Category.php:751 SELECT SQL_NO_CACHE id_feature, id_product, id_feature_value FROM `ps_feature_product` WHERE `id_product` IN (579) 0.4 1 /classes/Product.php:2633 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='fbdfb094997364e000714ff85f806e02' AND cache_id="stmultilink|1|1|3|3|13_6_location" AND compile_id="" LIMIT 1 0.4 1 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8416421650a135f3c429ded30bf2dc2f' AND cache_id="stparallax|1|1|3|3|13_28_location" AND compile_id="" LIMIT 1 0.4 0 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE * FROM `ps_myparcel_carrier_delivery_setting` pcds WHERE (pcds.`id_reference` = 215) LIMIT 1 0.4 10 /modules/myparcel/classes/MyParcelCarrierDeliverySetting.php:488 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` = 288) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE (`id_product` = 579) AND (`id_group` = 3) LIMIT 1 0.4 0 /classes/GroupReduction.php:105 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='8416421650a135f3c429ded30bf2dc2f' AND cache_id LIKE "stparallax|1|1|3|3|13_36_location%" 0.4 1 /classes/SmartyCustom.php:128 SELECT SQL_NO_CACHE a.`id_address` FROM `ps_address` a WHERE (a.`id_address` = 0) LIMIT 1 0.4 0 /classes/Address.php:470 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` = 13) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='8416421650a135f3c429ded30bf2dc2f' AND cache_id LIKE "stparallax|1|1|3|3|13_35_location%" 0.4 1 /classes/SmartyCustom.php:128 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='2cdc9bf7057bd1143e678c2c906cc243' AND cache_id="stmultilink|1|1|3|3|13_23_location" AND compile_id="" LIMIT 1 0.4 1 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE (`name` = 'vatnumber') LIMIT 1 0.4 1 /classes/module/Module.php:1670 SELECT SQL_NO_CACHE SUM(p.`weight` * cp.`quantity`) AS `nb` FROM `ps_cart_product` cp LEFT JOIN `ps_product` `p` ON cp.`id_product` = p.`id_product` WHERE (cp.`id_product_attribute` IS NULL OR cp.`id_product_attribute` = 0) AND (cp.`id_cart` = 72761) LIMIT 1 0.4 1 /classes/Cart.php:2180 SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE (`id_module` = 266) AND (`id_shop` = 1) LIMIT 1 0.4 1 /classes/module/Module.php:1439 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8416421650a135f3c429ded30bf2dc2f' AND cache_id="stparallax|1|1|3|3|13_3_location" AND compile_id="" LIMIT 1 0.4 0 /classes/SmartyCustom.php:300 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9185c878935e8759fdd770e83c8685cd' AND cache_id LIKE "stiosslider|1|1|3|3|13_20_location%" 0.4 1 /classes/SmartyCustom.php:128 SELECT SQL_NO_CACHE `myparcel_delivery_option` FROM `ps_myparcel_delivery_option` WHERE (`id_cart` = 72761) LIMIT 1 0.4 0 /modules/myparcel/classes/MyParcelDeliveryOption.php:161 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='8416421650a135f3c429ded30bf2dc2f' AND cache_id LIKE "stparallax|1|1|3|3|13_37_location%" 0.4 1 /classes/SmartyCustom.php:128 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9185c878935e8759fdd770e83c8685cd' AND cache_id LIKE "stiosslider|1|1|3|3|13_3_location%" 0.4 1 /classes/SmartyCustom.php:128 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='ff7c7d459d1299d134fd1358c932872d' AND cache_id="stbanner|1|1|3|3|13_3_location" AND compile_id="" LIMIT 1 0.4 0 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='2fe4673e4a86f48588052cf02e57a3bf' AND cache_id="blockfacebook|1|1|3|3|13" AND compile_id="" LIMIT 1 0.4 1 /classes/SmartyCustom.php:300 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='8416421650a135f3c429ded30bf2dc2f' AND cache_id LIKE "stparallax|1|1|3|3|13_4_location%" 0.4 1 /classes/SmartyCustom.php:128 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9185c878935e8759fdd770e83c8685cd' AND cache_id LIKE "stiosslider|1|1|3|3|13_4_location%" 0.4 1 /classes/SmartyCustom.php:128 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='f001d2be15c215df6d7d9e4d6bf1809a' AND cache_id="homefeatured-tab|1|1|3|3|13" AND compile_id="" LIMIT 1 0.4 1 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='7187e79e8e121b0ea6af31830d6c2cb5' AND cache_id="stmultilink|1|1|3|3|13_0_location" AND compile_id="" LIMIT 1 0.4 1 /classes/SmartyCustom.php:300 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.3 1 /Adapter/Adapter_EntityMapper.php:80 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9185c878935e8759fdd770e83c8685cd' AND cache_id LIKE "stiosslider|1|1|3|3|13_21_location%" 0.3 1 /classes/SmartyCustom.php:128 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='85a6fc45e84c28c0fe4b358862388bb5' AND cache_id="steasycontent|1|1|3|3|13_14_location" AND compile_id="" LIMIT 1 0.3 0 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE (`id_module` = 170) AND (`id_shop` = 1) LIMIT 1 0.3 1 /classes/module/Module.php:1439 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8416421650a135f3c429ded30bf2dc2f' AND cache_id="stparallax|1|1|3|3|13_4_location" AND compile_id="" LIMIT 1 0.3 0 /classes/SmartyCustom.php:300 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` = 268) LIMIT 1 0.3 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9d1b65ad94326479fe0d7457de9d0f90' AND cache_id="blocknewproducts-tab|20190203|1|1|3|3|13" AND compile_id="" LIMIT 1 0.3 1 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE * FROM `ps_configuration` a WHERE (a.`id_configuration` = 1383) LIMIT 1 0.3 1 /Adapter/Adapter_EntityMapper.php:80 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9185c878935e8759fdd770e83c8685cd' AND cache_id LIKE "stiosslider|1|1|3|3|13_17_location%" 0.3 1 /classes/SmartyCustom.php:128 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='ff7c7d459d1299d134fd1358c932872d' AND cache_id LIKE "stbanner|1|1|3|3|13_3_location%" 0.3 1 /classes/SmartyCustom.php:128 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9185c878935e8759fdd770e83c8685cd' AND cache_id LIKE "stiosslider|1|1|3|3|13_18_location%" 0.3 1 /classes/SmartyCustom.php:128 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9185c878935e8759fdd770e83c8685cd' AND cache_id="stiosslider|1|1|3|3|13_3_location" AND compile_id="" LIMIT 1 0.3 0 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='2cdc9bf7057bd1143e678c2c906cc243' AND cache_id="stmultilink|1|1|3|3|13_22_location" AND compile_id="" LIMIT 1 0.3 1 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE * FROM `ps_cart_cart_rule` WHERE (`id_cart` = 72761) 0.3 1 /classes/Cart.php:1353 SELECT SQL_NO_CACHE content FROM ps_lgcookieslaw_lang WHERE id_lang = 6 LIMIT 1 0.3 1 /modules/lgcookieslaw/lgcookieslaw.php:224 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) AS last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1 0.3 1 /classes/SmartyCustom.php:246 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='fbdfb094997364e000714ff85f806e02' AND cache_id="stmultilink|1|1|3|3|13_5_location" AND compile_id="" LIMIT 1 0.3 1 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8416421650a135f3c429ded30bf2dc2f' AND cache_id="stparallax|1|1|3|3|13_35_location" AND compile_id="" LIMIT 1 0.3 0 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 6 AND cl.id_shop = 1 AND cl.`id_category` = 155 LIMIT 1 0.3 1 /classes/Category.php:751 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9185c878935e8759fdd770e83c8685cd' AND cache_id="stiosslider|1|1|3|3|13_18_location" AND compile_id="" LIMIT 1 0.3 0 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8416421650a135f3c429ded30bf2dc2f' AND cache_id="stparallax|1|1|3|3|13_36_location" AND compile_id="" LIMIT 1 0.3 0 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9a4e32f7a4d86bc7af812d9423ef15b8' AND cache_id="https://imkershop.nl|1|1|3|3|13" AND compile_id="" LIMIT 1 0.3 1 /classes/SmartyCustom.php:300 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` = 280) LIMIT 1 0.3 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8416421650a135f3c429ded30bf2dc2f' AND cache_id="stparallax|1|1|3|3|13_37_location" AND compile_id="" LIMIT 1 0.3 0 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9185c878935e8759fdd770e83c8685cd' AND cache_id="stiosslider|1|1|3|3|13_20_location" AND compile_id="" LIMIT 1 0.3 0 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE `iso_code` FROM `ps_country` WHERE (`id_country` = 0) LIMIT 1 0.3 0 /classes/Country.php:244 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9185c878935e8759fdd770e83c8685cd' AND cache_id="stiosslider|1|1|3|3|13_17_location" AND compile_id="" LIMIT 1 0.3 0 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE * FROM `ps_shop` a WHERE (a.`id_shop` = 2) LIMIT 1 0.3 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE `myparcel_delivery_option` FROM `ps_myparcel_delivery_option` WHERE (`id_cart` = 72761) LIMIT 1 0.3 0 /modules/myparcel/classes/MyParcelDeliveryOption.php:161 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9185c878935e8759fdd770e83c8685cd' AND cache_id="stiosslider|1|1|3|3|13_4_location" AND compile_id="" LIMIT 1 0.3 0 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8416421650a135f3c429ded30bf2dc2f' AND cache_id="stparallax|1|1|3|3|13_17_location" AND compile_id="" LIMIT 1 0.3 0 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE content FROM ps_lgcookieslaw_lang WHERE id_lang = 6 LIMIT 1 0.3 1 /modules/lgcookieslaw/lgcookieslaw.php:224 SELECT SQL_NO_CACHE * FROM `ps_country_lang` WHERE (`id_country` = 13) 0.3 5 /Adapter/Adapter_EntityMapper.php:88 SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE (`name` = 'blockwishlist') LIMIT 1 0.3 1 /classes/module/Module.php:1670 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 579 AND id_shop=1 LIMIT 1 0.3 1 /classes/Product.php:1112 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9185c878935e8759fdd770e83c8685cd' AND cache_id="stiosslider|1|1|3|3|13_19_location" AND compile_id="" LIMIT 1 0.3 0 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='2f7819a7ad2d05b86902a3d88b604282' AND cache_id="stmultilink|1|1|3|3|13_1_location" AND compile_id="" LIMIT 1 0.3 1 /classes/SmartyCustom.php:300 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` = 3) LIMIT 1 0.3 1 /Adapter/Adapter_EntityMapper.php:80 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` = 3) LIMIT 1 0.3 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE id_shop FROM `ps_employee_shop` WHERE `id_employee` = 1 0.3 2 /classes/ObjectModel.php:1695 SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 6 AND cl.id_shop = 1 AND cl.`id_category` = 109 LIMIT 1 0.3 1 /classes/Category.php:751 SELECT SQL_NO_CACHE `reduction` FROM `ps_group` WHERE (`id_group` = 3) LIMIT 1 0.3 1 /classes/Group.php:207 SELECT SQL_NO_CACHE id_shop FROM `ps_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1 0.3 1 /classes/ObjectModel.php:1623 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9fcf5c0373b76723181ff3c9c5cc75fc' AND cache_id="steasycontent|1|1|3|3|13_12_location" AND compile_id="" LIMIT 1 0.3 1 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='2f7819a7ad2d05b86902a3d88b604282' AND cache_id="stmultilink|1|1|3|3|13_9_location" AND compile_id="" LIMIT 1 0.3 1 /classes/SmartyCustom.php:300 SELECT SQL_NO_CACHE * FROM `ps_carrier_lang` WHERE (`id_carrier` = 228) AND (`id_shop` = 1) 0.3 4 /Adapter/Adapter_EntityMapper.php:88 SELECT SQL_NO_CACHE * FROM `ps_carrier_lang` WHERE (`id_carrier` = 268) AND (`id_shop` = 1) 0.3 5 /Adapter/Adapter_EntityMapper.php:88 SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 6 AND cl.id_shop = 1 AND cl.`id_category` = 151 LIMIT 1 0.2 1 /classes/Category.php:751 SELECT SQL_NO_CACHE * FROM `ps_carrier_lang` WHERE (`id_carrier` = 288) AND (`id_shop` = 1) 0.2 4 /Adapter/Adapter_EntityMapper.php:88 SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE (`id_module` = 208) AND (`id_shop` = 1) LIMIT 1 0.2 1 /classes/module/Module.php:1439 SELECT SQL_NO_CACHE * FROM `ps_configuration_lang` WHERE (`id_configuration` = 1383) 0.2 1 /Adapter/Adapter_EntityMapper.php:88 SELECT SQL_NO_CACHE COUNT(DISTINCT `id_cart`) FROM `ps_specific_price` WHERE `id_cart` != 0 LIMIT 1 0.2 1 /classes/SpecificPrice.php:370 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_carrier_tax_rules_group_shop` WHERE (`id_carrier` = 228) AND (`id_shop` = 1) LIMIT 1 0.2 1 /classes/Carrier.php:307 SELECT SQL_NO_CACHE version FROM `ps_module` WHERE name = 'paypal' LIMIT 1 0.2 1 /modules/paypal/paypal.php:369 SELECT SQL_NO_CACHE COUNT(*) FROM ps_shop LIMIT 1 0.2 0 /classes/shop/Shop.php:1274 SELECT SQL_NO_CACHE * FROM `ps_group_lang` WHERE (`id_group` = 3) 0.2 5 /Adapter/Adapter_EntityMapper.php:88 SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 6 AND cl.id_shop = 1 AND cl.`id_category` = 73 LIMIT 1 0.2 1 /classes/Category.php:751 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_carrier_tax_rules_group_shop` WHERE (`id_carrier` = 288) AND (`id_shop` = 1) LIMIT 1 0.2 2 /classes/Carrier.php:307 SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE (`id_module` = 344) AND (`id_shop` = 1) LIMIT 1 0.2 1 /classes/module/Module.php:1439 SELECT SQL_NO_CACHE * FROM `ps_carrier_lang` WHERE (`id_carrier` = 280) AND (`id_shop` = 1) 0.2 4 /Adapter/Adapter_EntityMapper.php:88 SELECT SQL_NO_CACHE * FROM `ps_tax` a WHERE (a.`id_tax` = 4) LIMIT 1 0.2 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE id_module FROM ps_lgcookieslaw; 0.2 2 /override/classes/Hook.php:60 SELECT SQL_NO_CACHE * FROM `ps_tax_lang` WHERE (`id_tax` = 4) 0.2 5 /Adapter/Adapter_EntityMapper.php:88 SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE (`from` BETWEEN '2019-02-03 00:00:00' AND '2019-02-03 23:59:59') LIMIT 1 0.2 1 /classes/SpecificPrice.php:318 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE (`id_product` = 579) ORDER BY `id_specific_price_priority` DESC LIMIT 1 0.2 1 /classes/SpecificPrice.php:462 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_carrier_tax_rules_group_shop` WHERE (`id_carrier` = 280) AND (`id_shop` = 1) LIMIT 1 0.2 3 /classes/Carrier.php:307 SELECT SQL_NO_CACHE `id_cms_category` FROM `ps_cms` WHERE (`id_cms` = 45) LIMIT 1 0.1 1 /classes/Link.php:644 SELECT SQL_NO_CACHE button1 FROM ps_lgcookieslaw_lang WHERE id_lang = 6 LIMIT 1 0.1 1 /modules/lgcookieslaw/lgcookieslaw.php:224 SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE (`to` BETWEEN '2019-02-03 00:00:00' AND '2019-02-03 23:59:59') LIMIT 1 0.1 1 /classes/SpecificPrice.php:324 SELECT SQL_NO_CACHE id_shop FROM `ps_group_shop` WHERE `id_group` = 3 AND id_shop = 1 LIMIT 1 0.1 1 /classes/ObjectModel.php:1623 SELECT SQL_NO_CACHE button1 FROM ps_lgcookieslaw_lang WHERE id_lang = 6 LIMIT 1 0.1 1 /modules/lgcookieslaw/lgcookieslaw.php:224 SELECT SQL_NO_CACHE button2 FROM ps_lgcookieslaw_lang WHERE id_lang = 6 LIMIT 1 0.1 1 /modules/lgcookieslaw/lgcookieslaw.php:224 SELECT SQL_NO_CACHE button2 FROM ps_lgcookieslaw_lang WHERE id_lang = 6 LIMIT 1 0.1 1 /modules/lgcookieslaw/lgcookieslaw.php:224 Doubles 8 SELECT UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`=XX AND cache_id="stmultilink|XX|XX|XX|XX|XX_XX_location" AND compile_id="" LIMIT XX 7 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash=XX AND cache_id LIKE "stiosslider|XX|XX|XX|XX|XX_XX_location%" 7 SELECT UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`=XX AND cache_id="stiosslider|XX|XX|XX|XX|XX_XX_location" AND compile_id="" LIMIT XX 7 SELECT spg.*, spgl.`title` FROM `ps_st_parallax_group` spg INNER JOIN ps_st_parallax_group_shop st_parallax_group_shop ON (st_parallax_group_shop.id_st_parallax_group = spg.id_st_parallax_group AND st_parallax_group_shop.id_shop = XX) LEFT JOIN `ps_st_parallax_group_lang` spgl ON (spg.`id_st_parallax_group` = spgl.`id_st_parallax_group`) WHERE spg.`active`=XX AND spgl.`id_lang` = XX AND spg.`location` IN (XX) ORDER BY spg.`position` 7 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash=XX AND cache_id LIKE "stparallax|XX|XX|XX|XX|XX_XX_location%" 7 SELECT UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`=XX AND cache_id="stparallax|XX|XX|XX|XX|XX_XX_location" AND compile_id="" LIMIT XX 7 SELECT smsg.* FROM `ps_st_iosslider_group` smsg INNER JOIN ps_st_iosslider_group_shop st_iosslider_group_shop ON (st_iosslider_group_shop.id_st_iosslider_group = smsg.id_st_iosslider_group AND st_iosslider_group_shop.id_shop = XX) WHERE smsg.`active`=XX AND smsg.`location` IN (XX) ORDER BY smsg.`position` 6 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 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 d.`price` FROM `ps_delivery` d LEFT JOIN `ps_range_weight` `w` ON d.`id_range_weight` = w.`id_range_weight` WHERE (d.`id_zone` = XX) AND (XX >= w.`delimiterXX`) AND (XX < w.`delimiterXX`) AND (d.`id_carrier` = XX AND d.id_delivery = ( SELECT dXX.id_delivery FROM ps_delivery dXX WHERE dXX.id_carrier = `d`.id_carrier AND dXX.id_zone = `d`.id_zone AND dXX.`id_range_weight` = `d`.`id_range_weight` AND (dXX.id_shop = XX OR (dXX.id_shop_group = XX AND dXX.id_shop IS NULL) OR (dXX.id_shop_group IS NULL AND dXX.id_shop IS NULL)) ORDER BY dXX.id_shop DESC, dXX.id_shop_group DESC LIMIT XX )) ORDER BY w.`delimiterXX` ASC LIMIT XX 5 SELECT * FROM `ps_carrier` a LEFT JOIN `ps_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = XX WHERE (a.`id_carrier` = XX) LIMIT XX 5 SELECT * FROM `ps_carrier_lang` WHERE (`id_carrier` = XX) AND (`id_shop` = XX) 5 SELECT `id_tax_rules_group` FROM `ps_carrier_tax_rules_group_shop` WHERE (`id_carrier` = XX) AND (`id_shop` = XX) LIMIT XX 5 SELECT `myparcel_delivery_option` FROM `ps_myparcel_delivery_option` WHERE (`id_cart` = XX) LIMIT XX 5 SELECT smlg.*,smlgl.`name`,smlgl.`url` FROM `ps_st_multi_link_group` smlg INNER JOIN ps_st_multi_link_group_shop st_multi_link_group_shop ON (st_multi_link_group_shop.id_st_multi_link_group = smlg.id_st_multi_link_group AND st_multi_link_group_shop.id_shop = XX) LEFT JOIN `ps_st_multi_link_group_lang` smlgl ON (smlg.`id_st_multi_link_group` = smlgl.`id_st_multi_link_group`) WHERE smlg.`active`=XX AND smlg.`location` IN (XX) AND smlgl.`id_lang` = XX ORDER BY smlg.`position` 4 SELECT buttonXX FROM ps_lgcookieslaw_lang WHERE id_lang = XX LIMIT XX 4 SELECT `id_module` FROM `ps_module_shop` WHERE (`id_module` = XX) AND (`id_shop` = XX) LIMIT XX 4 SELECT d.`price` FROM `ps_delivery` d INNER JOIN `ps_range_weight` w ON d.`id_range_weight` = w.`id_range_weight` WHERE (d.`id_zone` = XX) AND (d.`id_carrier` = XX AND d.id_delivery = ( SELECT dXX.id_delivery FROM ps_delivery dXX WHERE dXX.id_carrier = `d`.id_carrier AND dXX.id_zone = `d`.id_zone AND dXX.`id_range_weight` = `d`.`id_range_weight` AND (dXX.id_shop = XX OR (dXX.id_shop_group = XX AND dXX.id_shop IS NULL) OR (dXX.id_shop_group IS NULL AND dXX.id_shop IS NULL)) ORDER BY dXX.id_shop DESC, dXX.id_shop_group DESC LIMIT XX )) ORDER BY w.`delimiterXX` DESC LIMIT XX 4 SELECT * FROM `ps_myparcel_carrier_delivery_setting` pcds WHERE (pcds.`id_reference` = XX) LIMIT XX 3 SELECT UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`=XX AND cache_id="steasycontent|XX|XX|XX|XX|XX_XX_location" AND compile_id="" LIMIT XX 3 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 3 SELECT cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS `cart_quantity`, cp.`id_shop`, pl.`name`, p.`is_virtual`, pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`, p.`id_manufacturer`, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`, product_shop.`available_for_order`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price_ratio`, stock.`quantity` AS `quantity_available`, p.`width`, p.`height`, p.`depth`, p.`weight`, stock.`out_of_stock`, p.`date_add`, p.`date_upd`, IFNULL(stock.`quantity`, XX) AS `quantity`, pl.`link_rewrite`, cl.`link_rewrite` AS `category`, CONCAT(LPAD(cp.`id_product`, XX, XX), LPAD(IFNULL(cp.`id_product_attribute`, XX), XX, XX), IFNULL(cp.`id_address_delivery`, XX)) AS unique_id, cp.`id_address_delivery`, product_shop.`advanced_stock_management`, ps.`product_supplier_reference` AS `supplier_reference`, NULL AS customization_quantity, NULL AS id_customization, product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr, IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference, (p.`weight`+ pa.`weight`) weight_attribute, IF (IFNULL(pa.`eanXX`, '') = '', p.`eanXX`, pa.`eanXX`) AS eanXX, IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc, IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity, IF(product_attribute_shop.wholesale_price > XX, product_attribute_shop.wholesale_price, product_shop.`wholesale_price`) wholesale_price, image_shop.`id_image` id_image, il.`legend` FROM `ps_cart_product` cp LEFT JOIN `ps_product` `p` ON p.`id_product` = cp.`id_product` INNER JOIN `ps_product_shop` product_shop ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`) LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX AND pl.id_shop = cp.id_shop LEFT JOIN `ps_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = XX AND cl.id_shop = cp.id_shop LEFT JOIN `ps_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier` LEFT JOIN ps_stock_available stock ON (stock.id_product = cp.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, XX) AND stock.id_shop_group = XX AND stock.id_shop = XX ) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute` LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`) LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=XX AND image_shop.id_shop=XX LEFT JOIN `ps_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = XX WHERE (cp.`id_cart` = XX) AND (p.`id_product` IS NOT NULL) ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC 2 SELECT m.`id_module`, m.`name`, ms.`id_module` AS `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = XX 2 SELECT content FROM ps_lgcookieslaw_lang WHERE id_lang = XX LIMIT XX 2 SELECT smsg.* FROM `ps_st_banner_group` smsg INNER JOIN ps_st_banner_group_shop st_banner_group_shop ON (st_banner_group_shop.id_st_banner_group = smsg.id_st_banner_group AND st_banner_group_shop.id_shop = XX) WHERE smsg.`active`=XX AND smsg.`id_parent`=XX AND smsg.`location` IN (XX) ORDER BY smsg.`position` 2 SELECT UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`=XX AND cache_id="stmegamenu|XX|XX|XX|XX|XX" AND compile_id="" LIMIT XX 2 SELECT UNIX_TIMESTAMP(last_update) AS last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`=XX AND cache_id="stbanner|XX|XX|XX|XX|XX_XX_location" AND compile_id="" LIMIT XX 2 SELECT * FROM `ps_shop` a WHERE (a.`id_shop` = XX) LIMIT XX 2 SELECT 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` = XX) AND (s.`active` = XX) AND (s.`deleted` = XX) AND (su.`main` = XX) LIMIT XX 2 SELECT sec.*, secl.`title`, secl.`url`, secl.`text`, st_easy_content_shop.`id_shop` FROM `ps_st_easy_content` sec INNER JOIN ps_st_easy_content_shop st_easy_content_shop ON (st_easy_content_shop.id_st_easy_content = sec.id_st_easy_content AND st_easy_content_shop.id_shop = XX) LEFT JOIN `ps_st_easy_content_lang` secl ON (sec.`id_st_easy_content` = secl.`id_st_easy_content`) WHERE secl.`id_lang` = XX AND sec.`location` IN (XX) AND sec.`active`=XX ORDER BY sec.`position`, sec.`location` 2 SELECT id_shop FROM `ps_employee_shop` WHERE `id_employee` = XX 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 `id_cms_category` FROM `ps_cms` WHERE (`id_cms` = XX) LIMIT XX 2 SELECT * FROM `ps_carrier` a LEFT JOIN `ps_carrier_lang` `b` ON a.`id_carrier` = b.`id_carrier` AND b.`id_lang` = XX LEFT JOIN `ps_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = XX WHERE (a.`id_carrier` = XX) AND (b.`id_shop` = XX) LIMIT XX 2 SELECT smlg.*,smlgl.`name`,smlgl.`url` FROM `ps_st_multi_link_group` smlg INNER JOIN ps_st_multi_link_group_shop st_multi_link_group_shop ON (st_multi_link_group_shop.id_st_multi_link_group = smlg.id_st_multi_link_group AND st_multi_link_group_shop.id_shop = XX) LEFT JOIN `ps_st_multi_link_group_lang` smlgl ON (smlg.`id_st_multi_link_group` = smlgl.`id_st_multi_link_group`) WHERE smlg.`active`=XX AND smlg.`location` IN (XX,XX,XX,XX,XX,XX) AND smlgl.`id_lang` = XX ORDER BY smlg.`position` Tables stress 61 smarty_lazy_cache 20 delivery 13 product 12 product_shop 12 module 10 product_lang 10 category_lang 9 carrier 9 range_weight 8 st_multi_link_group 8 carrier_lang 8 carrier_shop 8 cart_product 8 module_shop 8 st_multi_link_group_shop 8 st_multi_link_group_lang 7 st_parallax_group 7 st_parallax_group_shop 7 st_parallax_group_lang 7 st_iosslider_group 7 currency_shop 7 specific_price 7 st_iosslider_group_shop 7 shop 6 currency 6 shop_url 6 lgcookieslaw_lang 5 carrier_tax_rules_group_shop 5 myparcel_delivery_option 5 configuration 4 product_attribute_shop 4 image_shop 4 product_attribute 4 stock_available 4 cart_cart_rule 4 cart_rule 4 cart_rule_lang 4 image_lang 4 myparcel_carrier_delivery_setting 4 hook 4 st_easy_content 4 st_easy_content_shop 4 st_easy_content_lang 4 country 4 lang_shop 4 theme 3 country_lang 3 cms 3 employee_shop 3 lang 3 product_supplier 3 image_type 3 meta 3 country_shop 2 hook_alias 2 smarty_last_flush 2 hook_module 2 zone 2 shop_group 2 st_banner_group 2 meta_lang 2 st_banner_group_shop 2 feature_product 2 tax_rules_group 2 configuration_lang 2 group_shop 2 group 2 orders 2 tax_rule 1 cms_category 1 image 1 cms_category_shop 1 address 1 cms_shop 1 hbp_block 1 cms_lang 1 employee 1 pdgooglehreflangtagpro 1 hook_module_exceptions 1 state 1 cms_category_lang 1 group_lang 1 lgcookieslaw 1 range_price 1 hbp_block_lang 1 cart 1 module_group 1 specific_price_priority 1 carrier_group 1 carrier_zone 1 theme_meta 1 product_carrier 1 feature_value 1 product_group_reduction_cache 1 tax_lang 1 tax ObjectModel instances Name Instances Source Carrier 29 /classes/Cart.php [1555] /classes/Cart.php [1555] /classes/Cart.php [1555] /classes/Cart.php [1555] /classes/Cart.php [2096] /classes/Cart.php [1883] /modules/myparcel/myparcel.php [4909] /classes/Cart.php [2096] /modules/myparcel/myparcel.php [5210] /classes/Cart.php [2096] /modules/myparcel/myparcel.php [4909] /classes/Cart.php [1555] /classes/Cart.php [1555] /classes/Cart.php [1555] /classes/Cart.php [1217] /classes/Cart.php [2096] /modules/myparcel/myparcel.php [4909] /classes/Cart.php [2096] /modules/myparcel/myparcel.php [4909] /classes/Cart.php [1217] /classes/Cart.php [2096] /classes/Cart.php [1883] /classes/Cart.php [2096] /classes/Cart.php [1412] /classes/Cart.php [1412] /classes/Cart.php [4056] /classes/Cart.php [4056] /classes/Cart.php [4056] /classes/Cart.php [4056] Product 11 /classes/Cart.php [1555] /classes/Link.php [159] /classes/Link.php [159] /classes/Link.php [159] /classes/Link.php [159] /classes/Link.php [159] /classes/Link.php [157] /classes/Cart.php [4056] /classes/Link.php [159] /classes/Link.php [157] /classes/Cart.php [4056] Shop 7 /config/config.inc.php [123] /modules/pdgooglehreflangtagpro/pdgooglehreflangtagpro.php [634] /modules/pdgooglehreflangtagpro/pdgooglehreflangtagpro.php [634] /classes/Link.php [237] /classes/Link.php [237] /classes/Link.php [237] /classes/Link.php [237] Address 7 /classes/tax/Tax.php [276] /classes/Product.php [763] /classes/Product.php [1379] /modules/myparcel/myparcel.php [4916] /modules/myparcel/myparcel.php [4916] /modules/myparcel/myparcel.php [4916] /modules/myparcel/myparcel.php [4916] Country 5 /config/config.inc.php [148] /modules/paypal/paypal.php [2272] /classes/Carrier.php [589] /classes/Carrier.php [589] /classes/Carrier.php [589] Currency 5 /classes/Tools.php [698] /classes/controller/FrontController.php [1075] /classes/controller/FrontController.php [1075] /modules/htmlboxpro/htmlboxpro.php [315] /modules/myparcel/myparcel.php [4971] MyParcelCarrierDeliverySetting 4 /modules/myparcel/myparcel.php [4911] /modules/myparcel/myparcel.php [4911] /modules/myparcel/myparcel.php [4911] /modules/myparcel/myparcel.php [4911] Language 2 /config/config.inc.php [201] /classes/Tools.php [536] Customer 2 /config/config.inc.php [227] /classes/Carrier.php [636] Employee 2 /modules/ninjacustomer/ninjacustomer.php [100] /modules/ninjacustomer/ninjacustomer.php [100] CMS 2 /classes/Link.php [611] /classes/Link.php [611] CMSCategory 2 /classes/Link.php [666] /classes/Link.php [666] Tax 1 /classes/tax/TaxRulesTaxManager.php [138] Configuration 1 /modules/paypal/paypalCore.php [2] Theme 1 /config/config.inc.php [124] Group 1 /classes/Cart.php [190] Cart 1 /classes/controller/FrontController.php [1600] ShopGroup 1 /classes/shop/Shop.php [549] ConnectionsSource 1 /modules/statsdata/statsdata.php [143] Included Files # Filename 1 /index.php 2 /config/config.inc.php 3 /config/defines.inc.php 4 /config/settings.inc.php 5 /config/autoload.php 6 /config/alias.php 7 /classes/PrestaShopAutoload.php 8 /vendor/autoload.php 9 /vendor/composer/autoload_real.php 10 /vendor/composer/ClassLoader.php 11 /vendor/composer/include_paths.php 12 /vendor/composer/autoload_static.php 13 /vendor/ralouphie/getallheaders/src/getallheaders.php 14 /vendor/guzzlehttp/promises/src/functions_include.php 15 /vendor/guzzlehttp/promises/src/functions.php 16 /vendor/guzzlehttp/psr7/src/functions_include.php 17 /vendor/guzzlehttp/psr7/src/functions.php 18 /vendor/paragonie/random_compat/lib/random.php 19 /vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php 20 /vendor/guzzlehttp/guzzle/src/functions_include.php 21 /vendor/guzzlehttp/guzzle/src/functions.php 22 /vendor/jakeasmith/http_build_url/src/http_build_url.php 23 /vendor/swiftmailer/swiftmailer/lib/swift_required.php 24 /vendor/swiftmailer/swiftmailer/lib/classes/Swift.php 25 /vendor/symfony/polyfill-mbstring/bootstrap.php 26 /vendor/thirtybees/geoip/src/geoip.inc 27 /vendor/thirtybees/geoip/src/geoipcity.inc 28 /vendor/thirtybees/geoip/src/geoipregionvars.php 29 /vendor/thirtybees/geoip/src/timezone.php 30 /cache/class_index.php 31 /config/bootstrap.php 32 /Core/Business/Core_Business_ContainerBuilder.php 33 /Core/Foundation/IoC/Core_Foundation_IoC_Container.php 34 /Adapter/Adapter_ServiceLocator.php 35 /classes/controller/Controller.php 36 /classes/ObjectModel.php 37 /Core/Foundation/Database/Core_Foundation_Database_EntityInterface.php 38 /classes/db/Db.php 39 /classes/Tools.php 40 /classes/Context.php 41 /classes/shop/Shop.php 42 /config/db_slave_server.inc.php 43 /classes/db/DbPDO.php 44 /classes/Configuration.php 45 /override/classes/Configuration.php 46 /classes/db/DbQuery.php 47 /classes/Validate.php 48 /classes/cache/Cache.php 49 /Adapter/Adapter_EntityMapper.php 50 /classes/Theme.php 51 /config/defines_uri.inc.php 52 /classes/Language.php 53 /override/classes/Language.php 54 /classes/Country.php 55 /classes/PrestaShopCollection.php 56 /classes/shop/ShopGroup.php 57 /classes/Cookie.php 58 /override/classes/Cookie.php 59 /classes/Blowfish.php 60 /classes/CryptBlowfish.php 61 /classes/Encryptor.php 62 /config/smarty.config.inc.php 63 /classes/SmartyCustom.php 64 /vendor/smarty/smarty/libs/Smarty.class.php 65 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_data.php 66 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php 67 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 68 /vendor/smarty/smarty/libs/sysplugins/smarty_resource.php 69 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_resource_file.php 70 /vendor/smarty/smarty/libs/sysplugins/smarty_cacheresource.php 71 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_cacheresource_file.php 72 /config/smartyfront.config.inc.php 73 /classes/Customer.php 74 /classes/Group.php 75 /classes/Link.php 76 /classes/shop/ShopUrl.php 77 /classes/Hook.php 78 /override/classes/Hook.php 79 /classes/PageCache.php 80 /classes/module/Module.php 81 /vendor/mobiledetect/mobiledetectlib/Mobile_Detect.php 82 /classes/Dispatcher.php 83 /modules/smartblog/smartblog.php 84 /modules/smartblog/classes/BlogCategory.php 85 /modules/smartblog/classes/Blogcomment.php 86 /modules/smartblog/classes/BlogPostCategory.php 87 /modules/smartblog/classes/BlogTag.php 88 /modules/smartblog/classes/SmartBlogPost.php 89 /modules/smartblog/classes/BlogImageType.php 90 /modules/smartblog/controllers/admin/AdminAboutUsController.php 91 /classes/controller/ModuleAdminController.php 92 /classes/controller/AdminController.php 93 /classes/Translate.php 94 /themes/panda/modules/smartblog/translations/nl.php 95 /modules/smartblog/translations/nl.php 96 /controllers/front/IndexController.php 97 /classes/controller/FrontController.php 98 /override/classes/controller/FrontController.php 99 /override/controllers/front/IndexController.php 100 /themes/panda/lang/nl.php 101 /classes/Currency.php 102 /classes/Cart.php 103 /classes/Meta.php 104 /classes/Product.php 105 /classes/webservice/WebserviceRequest.php 106 /classes/Media.php 107 /modules/stthemeeditor/stthemeeditor.php 108 /themes/panda/modules/stthemeeditor/translations/nl.php 109 /modules/stthemeeditor/translations/nl.php 110 /modules/stthemeeditor/googlefonts.php 111 /cache/smarty/compile/12/c2/8c/12c28c3749e0d7ff9a85aea5a2b08067068dc55b.file.stthemeeditor-header.tpl.php 112 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_filter_handler.php 113 /modules/socialsharing/socialsharing.php 114 /themes/panda/modules/socialsharing/translations/nl.php 115 /modules/socialsharing/translations/nl.php 116 /modules/blocksocial/blocksocial.php 117 /themes/panda/modules/blocksocial/translations/nl.php 118 /modules/blocksocial/translations/nl.php 119 /modules/blockfacebook/blockfacebook.php 120 /themes/panda/modules/blockfacebook/translations/nl.php 121 /modules/blockfacebook/translations/nl.php 122 /modules/blockcms/blockcms.php 123 /modules/blockcms/BlockCMSModel.php 124 /themes/panda/modules/blockcms/translations/nl.php 125 /modules/blockcms/translations/nl.php 126 /modules/blockcontact/blockcontact.php 127 /themes/panda/modules/blockcontact/translations/nl.php 128 /modules/blockcontact/translations/nl.php 129 /modules/blockcontactinfos/blockcontactinfos.php 130 /themes/panda/modules/blockcontactinfos/translations/nl.php 131 /modules/blockcontactinfos/translations/nl.php 132 /modules/blockmyaccount/blockmyaccount.php 133 /themes/panda/modules/blockmyaccount/translations/nl.php 134 /modules/blockmyaccount/translations/nl.php 135 /modules/blockmyaccountfooter/blockmyaccountfooter.php 136 /themes/panda/modules/blockmyaccountfooter/translations/nl.php 137 /modules/blockmyaccountfooter/translations/nl.php 138 /modules/blocknewproducts/blocknewproducts.php 139 /themes/panda/modules/blocknewproducts/translations/nl.php 140 /modules/blocknewproducts/translations/nl.php 141 /modules/blocknewsletter/blocknewsletter.php 142 /themes/panda/modules/blocknewsletter/translations/nl.php 143 /modules/blocknewsletter/translations/nl.php 144 /modules/editorial/editorial.php 145 /themes/panda/modules/editorial/translations/nl.php 146 /modules/editorial/translations/nl.php 147 /modules/editorial/EditorialClass.php 148 /modules/blockuserinfo/blockuserinfo.php 149 /themes/panda/modules/blockuserinfo/translations/nl.php 150 /modules/blockuserinfo/translations/nl.php 151 /modules/homefeatured/homefeatured.php 152 /themes/panda/modules/homefeatured/translations/nl.php 153 /modules/homefeatured/translations/nl.php 154 /modules/themeconfigurator/themeconfigurator.php 155 /themes/panda/modules/themeconfigurator/translations/nl.php 156 /modules/themeconfigurator/translations/nl.php 157 /modules/blockpermanentlinks/blockpermanentlinks.php 158 /themes/panda/modules/blockpermanentlinks/translations/nl.php 159 /modules/blockpermanentlinks/translations/nl.php 160 /modules/mailalerts/mailalerts.php 161 /modules/mailalerts/MailAlert.php 162 /override/modules/mailalerts/mailalerts.php 163 /themes/panda/modules/mailalerts/translations/nl.php 164 /modules/mailalerts/translations/nl.php 165 /modules/blockwishlist/blockwishlist.php 166 /modules/blockwishlist/WishList.php 167 /themes/panda/modules/blockwishlist/translations/nl.php 168 /modules/blockwishlist/translations/nl.php 169 /modules/htmlbox/htmlbox.php 170 /themes/panda/modules/htmlbox/translations/nl.php 171 /modules/htmlbox/translations/nl.php 172 /modules/whatsappbutton/whatsappbutton.php 173 /themes/panda/modules/whatsappbutton/translations/nl.php 174 /modules/whatsappbutton/translations/nl.php 175 /modules/gsnippetsreviews/gsnippetsreviews.php 176 /modules/gsnippetsreviews/conf/common.conf.php 177 /classes/ImageType.php 178 /modules/gsnippetsreviews/lib/module-tools_class.php 179 /themes/panda/modules/gsnippetsreviews/translations/nl.php 180 /modules/gsnippetsreviews/translations/nl.php 181 /modules/gsnippetsreviews/conf/hook.conf.php 182 /modules/gsnippetsreviews/lib/hook/hook-ctrl_class.php 183 /modules/gsnippetsreviews/lib/hook/hook-base_class.php 184 /modules/gsnippetsreviews/lib/hook/hook-display_class.php 185 /cache/smarty/compile/da/31/59/da3159b3cda622ad2dab95997fbe178a5ec7b7fa.file.header.tpl.php 186 /vendor/smarty/smarty/libs/plugins/modifier.escape.php 187 /modules/feeder/feeder.php 188 /themes/panda/modules/feeder/translations/nl.php 189 /modules/feeder/translations/nl.php 190 /cache/smarty/compile/a7/c9/62/a7c9625ba5dd6aad8318a5658d75c40c290c3d40.file.feederHeader.tpl.php 191 /modules/phgoogletagmanager/phgoogletagmanager.php 192 /themes/panda/modules/phgoogletagmanager/translations/nl.php 193 /modules/phgoogletagmanager/translations/nl.php 194 /cache/smarty/compile/4c/67/70/4c6770e28ea4c2490a318d8b80533869ad60ad5b.file.header.tpl.php 195 /vendor/smarty/smarty/libs/plugins/modifier.replace.php 196 /modules/myparcel/myparcel.php 197 /modules/myparcel/vendor/autoload.php 198 /modules/myparcel/vendor/composer/autoload_real.php 199 /modules/myparcel/vendor/composer/autoload_static.php 200 /modules/myparcel/vendor/ircmaxell/password-compat/lib/password.php 201 /modules/myparcel/vendor/firstred/php-dot-notation/src/helpers.php 202 /modules/myparcel/vendor/symfony/polyfill-php54/bootstrap.php 203 /modules/myparcel/vendor/symfony/polyfill-php55/bootstrap.php 204 /modules/myparcel/classes/helpers.php 205 /themes/panda/modules/myparcel/translations/nl.php 206 /modules/myparcel/translations/nl.php 207 /modules/faktiva_seotk/faktiva_seotk.php 208 /modules/faktiva_seotk/tools/debug.php 209 /themes/panda/modules/faktiva_seotk/translations/nl.php 210 /modules/faktiva_seotk/translations/nl.php 211 /cache/smarty/cache/https_imkershop_nl/1/1/3/3/13/be/bd/0d/bebd0d281c5dc59935784ea4c16399fcce253254.meta-canonical.tpl.php 212 /modules/pdgooglehreflangtagpro/pdgooglehreflangtagpro.php 213 /modules/pdgooglehreflangtagpro/models/HrefLangModel.php 214 /themes/panda/modules/pdgooglehreflangtagpro/translations/nl.php 215 /modules/pdgooglehreflangtagpro/translations/nl.php 216 /cache/smarty/compile/16/82/1f/16821f774f0d0e4f39a3348cb691ead397842dac.file.hook.tpl.php 217 /modules/htmlboxpro/htmlboxpro.php 218 /modules/htmlboxpro/models/hbox.php 219 /themes/panda/modules/htmlboxpro/translations/nl.php 220 /modules/htmlboxpro/translations/nl.php 221 /modules/htmlboxpro/key.php 222 /modules/mollie/mollie.php 223 /modules/mollie/lib/vendor/autoload.php 224 /modules/mollie/lib/vendor/composer/autoload_real.php 225 /modules/mollie/lib/vendor/composer/autoload_static.php 226 /modules/mollie/lib/vendor/ehough/psr7/src/functions_include.php 227 /modules/mollie/lib/vendor/ehough/psr7/src/functions.php 228 /modules/mollie/lib/helpers.php 229 /classes/module/PaymentModule.php 230 /themes/panda/modules/mollie/translations/nl.php 231 /modules/mollie/translations/nl.php 232 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/MollieApiClient.php 233 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Http/Client.php 234 /modules/mollie/lib/vendor/php-curl-class/php-curl-class/src/Curl/Curl.php 235 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Http/ClientInterface.php 236 /modules/mollie/lib/vendor/php-curl-class/php-curl-class/src/Curl/CaseInsensitiveArray.php 237 /modules/mollie/lib/vendor/php-curl-class/php-curl-class/src/Curl/Url.php 238 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/CompatibilityChecker.php 239 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Endpoints/PaymentEndpoint.php 240 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Endpoints/EndpointAbstract.php 241 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Endpoints/MethodEndpoint.php 242 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Endpoints/CustomerEndpoint.php 243 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Endpoints/SettlementsEndpoint.php 244 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Endpoints/SubscriptionEndpoint.php 245 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Endpoints/CustomerPaymentsEndpoint.php 246 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Endpoints/MandateEndpoint.php 247 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Endpoints/ProfileEndpoint.php 248 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Endpoints/InvoiceEndpoint.php 249 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Endpoints/RefundEndpoint.php 250 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Types/PaymentStatus.php 251 /modules/mollie/lib/vendor/firstred/mollie-api-php/src/Types/RefundStatus.php 252 /modules/stmegamenu/stmegamenu.php 253 /modules/stmegamenu/StMegaMenuClass.php 254 /modules/stmegamenu/StMegaColumnClass.php 255 /modules/stmegamenu/StMegaProductClass.php 256 /modules/stmegamenu/StMegaBrandClass.php 257 /themes/panda/modules/stmegamenu/translations/nl.php 258 /modules/stmegamenu/translations/nl.php 259 /cache/smarty/cache/stmegamenu/1/1/3/3/13/e5/f5/02/e5f50238fcabbabf1c492a3bd94e735b1325ecf0.header.tpl.php 260 /modules/stcompare/stcompare.php 261 /themes/panda/modules/stcompare/translations/nl.php 262 /modules/stcompare/translations/nl.php 263 /modules/stiosslider/stiosslider.php 264 /modules/stiosslider/StIosSliderClass.php 265 /modules/stiosslider/StIosSliderGroup.php 266 /modules/stiosslider/StIosSliderFontClass.php 267 /modules/stiosslider/googlefonts.php 268 /themes/panda/modules/stiosslider/translations/nl.php 269 /modules/stiosslider/translations/nl.php 270 /modules/stbanner/stbanner.php 271 /modules/stbanner/StBannerClass.php 272 /modules/stbanner/StBannerGroup.php 273 /modules/stbanner/StBannerFontClass.php 274 /modules/stbanner/googlefonts.php 275 /themes/panda/modules/stbanner/translations/nl.php 276 /modules/stbanner/translations/nl.php 277 /cache/smarty/cache/stbanner/1/1/3/3/13/86/bd/b4/86bdb4013830497038b26a4a5a08238e054eba6a.header.tpl.php 278 /modules/steasycontent/steasycontent.php 279 /modules/steasycontent/StEasyContentClass.php 280 /modules/steasycontent/StEasyContentFontClass.php 281 /themes/panda/modules/steasycontent/translations/nl.php 282 /modules/steasycontent/translations/nl.php 283 /modules/steasycontent/googlefonts.php 284 /cache/smarty/cache/steasycontent/1/1/3/3/13/39/32/f9/3932f92c811308dfb5a1298cae06baffb36dec75.header.tpl.php 285 /modules/crossselling/crossselling.php 286 /themes/panda/modules/crossselling/translations/nl.php 287 /modules/crossselling/translations/nl.php 288 /modules/stparallax/stparallax.php 289 /modules/stparallax/StParallaxClass.php 290 /modules/stparallax/StParallaxGroup.php 291 /modules/stparallax/StParallaxFontClass.php 292 /modules/stparallax/googlefonts.php 293 /themes/panda/modules/stparallax/translations/nl.php 294 /modules/stparallax/translations/nl.php 295 /cache/smarty/cache/stparallax/1/1/3/3/13/bd/23/83/bd238379542d16f1d94622b4ea47cabab26197df.header.tpl.php 296 /modules/stpagebanner/stpagebanner.php 297 /modules/stpagebanner/StPageBannerClass.php 298 /modules/stpagebanner/StPageBannerFontClass.php 299 /modules/stpagebanner/googlefonts.php 300 /themes/panda/modules/stpagebanner/translations/nl.php 301 /modules/stpagebanner/translations/nl.php 302 /cache/smarty/cache/stpagebanner/1/1/3/3/13/06/7f/fb/067ffb33c8df3f52bd31256d769cf29351b895e4.header.tpl.php 303 /modules/stproductlinknav/stproductlinknav.php 304 /themes/panda/modules/stproductlinknav/translations/nl.php 305 /modules/stproductlinknav/translations/nl.php 306 /modules/sthoverimage/sthoverimage.php 307 /themes/panda/modules/sthoverimage/translations/nl.php 308 /modules/sthoverimage/translations/nl.php 309 /modules/blockviewed_mod/blockviewed_mod.php 310 /themes/panda/modules/blockviewed_mod/translations/nl.php 311 /modules/blockviewed_mod/translations/nl.php 312 /modules/blockcart_mod/blockcart_mod.php 313 /themes/panda/modules/blockcart_mod/translations/nl.php 314 /modules/blockcart_mod/translations/nl.php 315 /cache/smarty/cache/blockcart_mod/1/1/3/3/13/da/bf/b4/dabfb49271cf6fcac5872fd3d94f9bb300d85ba6.header.tpl.php 316 /modules/paypal/paypal.php 317 /modules/paypal/api/paypal_lib.php 318 /modules/paypal/api/paypal_connect.php 319 /modules/paypal/api/CallApiPaypalPlus.php 320 /modules/paypal/api/ApiPaypalPlus.php 321 /modules/paypal/paypal_logos.php 322 /modules/paypal/paypal_orders.php 323 /modules/paypal/paypal_tools.php 324 /modules/paypal/paypal_login/paypal_login.php 325 /modules/paypal/paypal_login/PayPalLoginUser.php 326 /modules/paypal/classes/PaypalCapture.php 327 /modules/paypal/classes/AuthenticatePaymentMethods.php 328 /modules/paypal/classes/TLSVerificator.php 329 /modules/paypal/paypalCore.php 330 /themes/panda/modules/paypal/translations/nl.php 331 /modules/paypal/nl.php 332 /modules/ninjacustomer/ninjacustomer.php 333 /themes/panda/modules/ninjacustomer/translations/nl.php 334 /modules/ninjacustomer/translations/nl.php 335 /classes/Employee.php 336 /modules/blocksearch_mod/blocksearch_mod.php 337 /themes/panda/modules/blocksearch_mod/translations/nl.php 338 /modules/blocksearch_mod/translations/nl.php 339 /modules/notarobot/notarobot.php 340 /themes/panda/modules/notarobot/translations/nl.php 341 /cache/smarty/compile/35/76/98/357698864f9a287bd4f68a3e861afee36969e272.file.header.tpl.php 342 /vendor/mrclay/minify/min/lib/JSMin.php 343 /modules/lgcookieslaw/lgcookieslaw.php 344 /themes/panda/modules/lgcookieslaw/translations/nl.php 345 /modules/lgcookieslaw/translations/nl.php 346 /classes/CMS.php 347 /classes/CMSCategory.php 348 /cache/smarty/compile/16/b6/98/16b698d8c7115bb8f0ccd3d30ad24c6cc1ff6f00.file.cookieslaw_header_1_6.tpl.php 349 /cache/smarty/compile/7e/71/a5/7e71a574255e5ddc1c465f5c08576911188d6b09.file.cookieslaw_header_code.tpl.php 350 /cache/smarty/compile/8e/dc/4a/8edc4a31c3c307035a069023a12d08939e4e2667.file.block-last-reviews.tpl.php 351 /cache/smarty/compile/91/a5/ed/91a5edd75e0060a175b78bebd15bed7ee987f098.file.snippets-hp.tpl.php 352 /cache/smarty/compile/b7/09/84/b70984c9bc5cd2c64bb3dc229c347bca98d9c9ea.file.generic-hook.tpl.php 353 /cache/smarty/compile/ca/22/dd/ca22dd273473372679a1426aaea5ad919865f4d0.file.blockwishlist_top.tpl.php 354 /modules/blockcurrencies_mod/blockcurrencies_mod.php 355 /themes/panda/modules/blockcurrencies_mod/translations/nl.php 356 /modules/blockcurrencies_mod/translations/nl.php 357 /cache/smarty/compile/aa/c7/f4/aac7f48bb7fe9d39da249fed9948531d8c9724ef.file.blockuserinfo.tpl.php 358 /modules/blockuserinfo_mod/blockuserinfo_mod.php 359 /themes/panda/modules/blockuserinfo_mod/translations/nl.php 360 /modules/blockuserinfo_mod/translations/nl.php 361 /cache/smarty/compile/91/ba/41/91ba41b50c6b41c4024b9a2e2b0f2e7850b92eb7.file.nav.tpl.php 362 /classes/Combination.php 363 /classes/stock/StockAvailable.php 364 /classes/Customization.php 365 /classes/SpecificPrice.php 366 /classes/Feature.php 367 /classes/tax/Tax.php 368 /classes/Address.php 369 /classes/tax/TaxManagerFactory.php 370 /modules/vatnumber/vatnumber.php 371 /classes/tax/TaxManagerModule.php 372 /themes/panda/modules/vatnumber/translations/nl.php 373 /modules/vatnumber/translations/nl.php 374 /modules/vatnumber/VATNumberTaxManager.php 375 /classes/tax/TaxManagerInterface.php 376 /classes/tax/TaxRulesTaxManager.php 377 /Adapter/Adapter_Configuration.php 378 /Core/Business/Core_Business_ConfigurationInterface.php 379 /classes/tax/TaxCalculator.php 380 /classes/GroupReduction.php 381 /classes/order/Order.php 382 /override/classes/order/Order.php 383 /Adapter/Adapter_AddressFactory.php 384 /Adapter/Adapter_ProductPriceCalculator.php 385 /classes/ProductDownload.php 386 /classes/Carrier.php 387 /classes/Category.php 388 /classes/CartRule.php 389 /modules/myparcel/classes/MyParcelDeliveryOption.php 390 /modules/myparcel/classes/MyParcelObjectModel.php 391 /modules/myparcel/vendor/firstred/php-dot-notation/src/Dot.php 392 /modules/myparcel/classes/MyParcelCarrierDeliverySetting.php 393 /classes/exception/PrestaShopException.php 394 /translations/nl/errors.php 395 /vendor/commerceguys/intl/src/Currency/CurrencyRepository.php 396 /vendor/commerceguys/intl/src/LocaleResolverTrait.php 397 /vendor/commerceguys/intl/src/Currency/CurrencyRepositoryInterface.php 398 /vendor/commerceguys/intl/src/NumberFormat/NumberFormatRepository.php 399 /vendor/commerceguys/intl/src/NumberFormat/NumberFormatRepositoryInterface.php 400 /vendor/commerceguys/intl/src/Currency/Currency.php 401 /vendor/commerceguys/intl/src/Currency/CurrencyEntityInterface.php 402 /vendor/commerceguys/intl/src/Currency/CurrencyInterface.php 403 /vendor/commerceguys/intl/src/NumberFormat/NumberFormat.php 404 /vendor/commerceguys/intl/src/NumberFormat/NumberFormatEntityInterface.php 405 /vendor/commerceguys/intl/src/NumberFormat/NumberFormatInterface.php 406 /vendor/commerceguys/intl/src/Formatter/NumberFormatter.php 407 /vendor/commerceguys/intl/src/Formatter/NumberFormatterInterface.php 408 /cache/smarty/compile/f1/66/11/f16611a83c0a11f2474fe2be1441d5342e56d485.file.html.tpl.php 409 /vendor/smarty/smarty/libs/plugins/modifier.date_format.php 410 /cache/smarty/cache/stmegamenu/1/1/3/3/13_column/88/95/73/8895731e12b02c58bad987c46f1d6d50848e036c.stmegamenu-column.tpl.php 411 /modules/stmultilink/stmultilink.php 412 /modules/stmultilink/StMultiLinkGroup.php 413 /modules/stmultilink/StMultiLinkClass.php 414 /themes/panda/modules/stmultilink/translations/nl.php 415 /modules/stmultilink/translations/nl.php 416 /cache/smarty/compile/f9/85/30/f98530cd3be175ad0241cfd76aa6da275be2cb9d.file.blockwishlist.tpl.php 417 /cache/smarty/compile/4e/53/1d/4e531d87c237ae0ddcdc7b5729b3680d810267b8.file.blockviewed.tpl.php 418 /classes/Image.php 419 /override/classes/Image.php 420 /cache/smarty/cache/stmegamenu/1/1/3/3/13_stmegamenu/b7/02/d2/b702d23b5bb15b5dfa90ad19b5ab4e878431a380.stmegamenu.tpl.php 421 /cache/smarty/compile/7e/9a/58/7e9a5815d535f91b7f0e54ee9075bac40a9b8c09.file.to_top.tpl.php 422 /cache/smarty/compile/31/01/25/31012501cb4989bd66bfa8ca85f6a9b8b2888fcb.file.stcompare.tpl.php 423 /cache/smarty/compile/b1/cc/01/b1cc016a7328d27efb8d9684c4f7ba6eb34f2217.file.blockcart-rightbar.tpl.php 424 /cache/smarty/compile/18/e7/d8/18e7d8b73e104d0e9f7c936c27075d0ee8e0e7cc.file.blocksearch-bar.tpl.php 425 /cache/smarty/compile/e1/4a/52/e14a52aecee59f492cb451767fe7473d4ead9a49.file.side_bar_right.tpl.php 426 /cache/smarty/compile/52/80/6d/52806d79a2c90da59dd0f2d1c5fa9ffd37eb2194.file.stcompare-side.tpl.php 427 /cache/smarty/compile/70/39/f6/7039f6c2850bebad8218ce67a0fff298bdd0426a.file.blockcart-side.tpl.php 428 /cache/smarty/compile/89/6b/b8/896bb8d827f39932badcae64091d85da85485205.file.blocksearch-side.tpl.php 429 /cache/smarty/compile/f0/62/e5/f062e5b7a1892583656d8d4f6cad680cd3152881.file.blockcart-mobilebar.tpl.php 430 /cache/smarty/compile/44/6b/12/446b12115022dedba5ee1d041df5cf606f957e57.file.stmobilebar.tpl.php 431 /cache/smarty/cache/stmegamenu/1/1/3/3/13/92/14/a1/9214a1b329ff74c83670168d146baa6c2930cb76.stmobilemenu-ul.tpl.php 432 /cache/smarty/compile/e4/5d/ae/e45dae36585ab26bf8d479c987bff9a944fbc46b.file.nav-mobile.tpl.php 433 /cache/smarty/compile/a7/59/b1/a759b1cee4bb6b18927d907989fbbc3c60ba4850.file.blocksearch-mobile.tpl.php 434 /cache/smarty/compile/e3/56/c0/e356c0e4e65f3052fded2e9201be4e63a74091b5.file.blockcart.tpl.php 435 /vendor/smarty/smarty/libs/plugins/function.counter.php 436 /cache/smarty/cache/blocksearch_mod/1/1/3/3/13_blocksearch_top/d3/3f/2b/d33f2b23d8d6a8a58b94a45b76a632893d8ee7e1.blocksearch-top.tpl.php 437 /cache/smarty/cache/blockfacebook/1/1/3/3/13/94/dd/a0/94dda0daa9b9a7f9f9f2de62fe8f384f259b59f2.blockfacebook.tpl.php 438 /modules/blockcmsinfo/blockcmsinfo.php 439 /modules/blockcmsinfo/classes/InfoBlock.php 440 /themes/panda/modules/blockcmsinfo/translations/nl.php 441 /modules/blockcmsinfo/translations/nl.php 442 /cache/smarty/cache/blockcmsinfo/1/1/3/3/13/73/ef/40/73ef4055fd7a71943aa05dc240c727c132c04d4e.blockcmsinfo.tpl.php 443 /cache/smarty/cache/homefeatured_tab/1/1/3/3/13/5f/75/da/5f75da4f3ef09353027486fbb9fdf2c820ed111d.tab.tpl.php 444 /cache/smarty/cache/blocknewproducts_tab/20190203/1/1/3/3/13/ca/bc/3c/cabc3cf755016fc2a629edfd716e5d21784215bb.tab.tpl.php 445 /cache/smarty/cache/homefeatured/1/1/3/3/13/68/1b/75/681b7590244d470ef763ff5abe4fce4b5cf267b8.homefeatured.tpl.php 446 /cache/smarty/cache/blocknewproducts_home/20190203/1/1/3/3/13/d3/74/d4/d374d4400718b37403a3114eed8c68b71b740336.blocknewproducts_home.tpl.php 447 /modules/tawkto/tawkto.php 448 /themes/panda/modules/tawkto/translations/nl.php 449 /modules/tawkto/translations/nl.php 450 /cache/smarty/compile/98/a6/73/98a673230d15179c472dc144aba1ee484e94ab66.file.widget.tpl.php 451 /cache/smarty/cache/steasycontent/1/1/3/3/13_3_location/f3/0c/7a/f30c7afc54b704ec1d511663e88dfbeed82aef99.steasycontent-footer.tpl.php 452 /modules/statsdata/statsdata.php 453 /themes/panda/modules/statsdata/translations/nl.php 454 /modules/statsdata/translations/nl.php 455 /classes/Connection.php 456 /classes/ConnectionsSource.php 457 /cache/smarty/compile/d3/80/ee/d380ee67e15856a72932961b61ac6f51351d66b3.file.paypal.js.php 458 /cache/smarty/compile/3f/5f/e6/3f5fe6561e98540f3547b4771832104e169a9003.file.ninjacustomer.tpl.php 459 /cache/smarty/compile/5f/2e/b3/5f2eb393dfece38b09c136c067b1be1722885dd6.file.index.tpl.php 460 /cache/smarty/compile/8d/ab/5c/8dab5c2cdf850e6fc86445a9cac30e35fad2ebfc.file.layout.tpl.php 461 /cache/smarty/compile/9f/e7/c0/9fe7c03125c76808ddf516987a6e8a9771f5b0c4.file.header.tpl.php 462 /cache/smarty/compile/f1/65/b0/f165b0c81fe3b872a44b94ef9ecb781ebe6ef35c.file.ph_google_tag_manager.tpl.php 463 /cache/smarty/compile/89/8b/fd/898bfd06de2320c61b6aac797b9252772c7e975f.file.steasycontent.tpl.php 464 /cache/smarty/compile/21/17/5f/21175f92f3a61f6a78cda6d72e190c709eca5cb0.file.footer.tpl.php 465 /vendor/smarty/smarty/libs/plugins/shared.mb_str_replace.php 466 /cache/smarty/compile/97/51/70/975170c8269de621eef235b810f28ed96bcf4482.file.global.tpl.php 467 /cache/smarty/compile/8a/d4/b8/8ad4b8f0bbfaaf0706e0db81d18533c2665fd848.file.javascript.tpl.php

Okey, so I can eneble it, but it is just disabled yesterday so this will not solve the loading issue. @lesley is there a way to see what scripts cause the processor overload? I did eneble a pwa app. Disabled it yesterday but u installed it and removeed it but the site still is trying to get the service worker. Could that be someting?

We have around 1200 products both stores have the same products. The issue was in both PS and TB.

Thanks for looking into it. I will run the side in a test environment to see if this menu has any influence. We (me and the developer) decided not to use smarty cache as I am running multistore and in one or 2 weeks I will have 1.000.000 cache files. Which slows more down..... Maybe using the Thirty Bees built in cache is also can help the menu? Until now only redis was enabled.... Do you agree: Step 1 look enable TB cache? Step 2 Hire vpn and check menu and all other modules ect? Maybe step 1 1/2 smarty cache? The STmenu is the core of the site.... Not so smart to disable... Maybe? But there might be a good alternative with a good UX developer...

Its a nice curious thing right 😉 Send you PM.

Not at all, especially not this exact custom thirty bees yellow 😅