Smile

Found it: admin\themes\default\template\helpers\form

On the other hand when connecting to the DB using Heidi and requesting 100000 rules from PS_Guest it works perfectly without overload.... Good to mention maybe is that recently we switched from ASM back to the normal stock management..... Small update: I did install a clean TB and did do the same test. When opening orders, there are just 6 order... the no CPU problem at all but when opening 5-6 product pages then I also can get the CPU very hot....

Downloaded a 1.0.3 but can't find this directory or the file.... And cant find it on github either.... true noob.

So guys/girls a short update: I did disabled all overrides from BO -> no effect I did rename the override folder -> no effect I did install a clean TB and connected it to my DB. So all files are brand new, and just the default modules ect... -> No effect I can still back a honey cake on the server. I also did run TB cleaner. Does this mean that it might be a DB issue as with a clean installation the same issue arises?

Misschien zijn de iconen een cache issue? Maar daar had je misschien zelf ook aan gedacht?

Aangezien ik zelf ben overgestapt van PS naar TB stop ik met mijn ambassadeurschap. Hieronder stond info over een PS meetup maar dit vond prestashop niet prettig. Deze heb ik verwijderd.

In the past I could change it so seems like a bug. @wakabayashi What would be the way forward?

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