SET general_log = 1;

SELECT * FROM news WHERE date < 24 hours

SELECT * FROM news WHERE date >= now() - INTERVAL 1 DAY;

php bin/magento dev:profiler:enable html

To fix this issue you need to increase the value of max_input_vars in php.ini file. By default, this value is set to 1000. You should set it to 5000 or 10000.

# php -r “phpinfo();” | grep max_input_vars
max_input_vars => 1000 => 1000

Incrase the value to 5000 in php.ini file

ALTER TABLE table_name ALTER COLUMN column_name SET DEFAULT 'VALUE';

Run the following command

git clone -b mybranch --single-branch git://sub.domain.com/repo.git

The following command saved my day.

 sudo yum-complete-transaction --cleanup-only

SET SQL_MODE='ALLOW_INVALID_DATES'

Done the above configuration change and that solved my problem temporarly.

Run the following commands to list reindex options

magento 2 command reindex options

Run the following commands

composer require algolia/algoliasearch-magento-2
php bin/magento module:enable Algolia_AlgoliaSearch
php bin/magento setup:upgrade
php bin/magento setup:static-content:deploy