how to speed up magento2 with redis?

Question

I am using magento2 , but its page load time max than 4s.

have alread config useing varnish .

after config use redis , there are still huge sql query at catalog page ？ why ? how to speed up this page ?

redis config is : app/etc/env.php

 'cache' => array(
    'frontend' => array(
        'default' => array(
            'backend' => 'Cm_Cache_Backend_Redis',
            'backend_options' => array(
                'server' => '127.0.0.1',
                'database' => '0',
                'port' => '6379',
            ),
        ),
        'page_cache' => array(
            'backend' => 'Cm_Cache_Backend_Redis',
            'backend_options' => array(
                'server' => '127.0.0.1',
                'port' => '6379',
                'database' => '1',
                'compress_data' => '0',
            ),
        ),
    ),
),

======================= catalog page query is :

enter image description here

Answer 1

To enable Magento2 profiler following below steps:

1. Set environment variable: MAGE_PROFILER = html. Refer to this link.
2. Enable/Set Magento2 developer mode

   php bin/magento deploy:mode:set developer
   

3. Clear the cache. OR You can disable the cache for time being.
4. Open the website in browser incognito(private) window. Browse to the slow webpage & check at the bottom, you will see the profiler stack trace showing calls and time taken.