Desperate times need desperate measures 1.7.* latest loads products in

[datasphere]

Hi guys

2 of us tried literary everything, changing servers settings 

PHP, mysql, apache /  varnish

 

We need third opinion

 

Our setup is common, some 2000 products and strange but for spare parts not so uncommon around 8000 categories which half are disabled

no attributes though

Shop works fast everything front and backend

the only thing that is working slowly is BO loading when trying to load product to edit it

 

Is it possible to be translations missing ?

PLEASE PLEASE HELP IDENTIFY WHAT IS CAUSING THIS  !!!

here is some code from debug

Time	Channel	Message
07:15:21
security	Read existing security token from the session.
Context: { "key": "_security_main" }
07:15:21
security	User was reloaded from a user provider.
Context: { "username": "[email protected]", "provider": "PrestaShopBundle\\Security\\Admin\\EmployeeProvider" }
07:15:21
event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure".
07:15:21
event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelRequest".
07:15:21
event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest".
07:15:21
event	Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\SessionListener::onKernelRequest".
07:15:21
event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\FragmentListener::onKernelRequest".
07:15:21
event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest".
07:15:21
event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest".
07:15:21
event	Notified event "kernel.request" to listener "PrestaShopBundle\EventListener\UserLocaleListener::onKernelRequest".
07:15:21
event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelRequest".
07:15:21
event	Notified event "kernel.request" to listener "Symfony\Component\Security\Http\Firewall::onKernelRequest".
07:15:21
event	Notified event "kernel.request" to listener "PrestaShop\PrestaShop\Adapter\Security\Admin::onKernelRequest".
07:15:21
event	Notified event "kernel.request" to listener "PrestaShop\PrestaShop\Adapter\Security\SslMiddleware::onKernelRequest".
07:15:21
event	Notified event "kernel.request" to listener "PrestaShopBundle\EventListener\TokenizedUrlsListener::onKernelRequest".
07:15:21
event	Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController".
07:15:21
event	Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController".
07:15:21
event	Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController".
07:15:21
event	Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController".
07:15:21
event	Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController".
07:15:21
event	Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelController".
07:15:21
event	Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController".
07:15:30
doctrine	SELECT p0_.id_attribute AS id_attribute_0, p0_.color AS color_1, p0_.position AS position_2, p1_.id_attribute_group AS id_attribute_group_3, p1_.position AS position_4, p2_.public_name AS public_name_5, p0_.id_attribute AS id_attribute_6, p0_.color AS color_7, p0_.position AS position_8, p3_.name AS name_9 FROM ps_attribute p0_ INNER JOIN ps_attribute_group p1_ ON p0_.id_attribute_group = p1_.id_attribute_group INNER JOIN ps_attribute_shop p5_ ON p0_.id_attribute = p5_.id_attribute INNER JOIN ps_shop p4_ ON p4_.id_shop = p5_.id_shop INNER JOIN ps_attribute_lang p3_ ON p0_.id_attribute = p3_.id_attribute INNER JOIN ps_attribute_group_lang p2_ ON p1_.id_attribute_group = p2_.id_attribute_group WHERE p3_.id_lang = ? AND p2_.id_lang = ? AND p4_.id_shop = ? ORDER BY position_8 ASC, position_4 ASC
Context: [1,1,1]
07:15:38
event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure".
07:15:38
event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelRequest".
07:15:38
event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest".
07:15:38
event	Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\SessionListener::onKernelRequest".
07:15:38
event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\FragmentListener::onKernelRequest".
07:15:38
event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest".
07:15:38
event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest".
07:15:38
event	Notified event "kernel.request" to listener "PrestaShopBundle\EventListener\UserLocaleListener::onKernelRequest".
07:15:38
event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelRequest".
07:15:38
event	Notified event "kernel.request" to listener "Symfony\Component\Security\Http\Firewall::onKernelRequest".
07:15:38
event	Notified event "kernel.request" to listener "PrestaShop\PrestaShop\Adapter\Security\Admin::onKernelRequest".
07:15:38
event	Notified event "kernel.request" to listener "PrestaShop\PrestaShop\Adapter\Security\SslMiddleware::onKernelRequest".
07:15:38
event	Notified event "kernel.request" to listener "PrestaShopBundle\EventListener\TokenizedUrlsListener::onKernelRequest".
07:15:38
event	Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController".
07:15:38
event	Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController".
07:15:38
event	Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController".
07:15:38
event	Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController".
07:15:38
event	Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController".
07:15:38
event	Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelController".
07:15:38
event	Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController".
07:15:38
event	Notified event "kernel.response" to listener "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse".
07:15:38
event	Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse".
07:15:38
event	Notified event "kernel.response" to listener "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse".
07:15:38
event	Notified event "kernel.response" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse".
07:15:38
event	Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse".
07:15:38
event	Notified event "kernel.response" to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse".
07:15:38
event	Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SaveSessionListener::onKernelResponse".
07:15:38
event	Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse".
07:15:38
event	Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest".
07:15:38
event	Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelFinishRequest".
07:15:38
event	Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest".
07:15:38
event	Notified event "kernel.finish_request" to listener "Symfony\Component\Security\Http\Firewall::onKernelFinishRequest".
07:15:41
event	Notified event "kernel.view" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelView".
07:15:41
event	Listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelView" stopped propagation of the event "kernel.view".
07:15:41
security	Stored the security token in the session.
Context: { "key": "_security_main" }
07:15:41
event	Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse".
07:15:41
event	Notified event "kernel.response" to listener "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse".
07:15:41
event	Notified event "kernel.response" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse".
07:15:41
event	Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse".
07:15:41
event	Notified event "kernel.response" to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse".
07:15:41
event	Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SaveSessionListener::onKernelResponse".
07:15:41
event	Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse".
07:15:41
event	Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest".
07:15:41
event	Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelFinishRequest".
07:15:41
event	Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest".
07:15:41
event	Notified event "kernel.finish_request" to listener "Symfony\Component\Security\Http\Firewall::onKernelFinishRequest".

 

[datasphere]

Found out this is a known  bug in Prestashop and Team is working on amending it