Symfony Profiler

Queries

SQL queries

SELECT `animal`.`animal_kind_id`, `animal`.`animal_breed_id`, `animal`.`shelter_id`, `animal`.`curator_id`, `animal`.`uri`, `animal`.`gender`, `animal`.`status`, `animal`.`stream_url`, `animal`.`has_ar`, `animal`.`visible`, `animal`.`petofday`, `animal`.`is_public_translation`, `animal`.`error_video`, `animal`.`dead`, `animal`.`age`, `animal`.`date_from`, `animal`.`ru_content_id`, `animal`.`en_content_id`, `animal`.`jp_content_id`, `animal`.`de_content_id`, `animal`.`fr_content_id`, `animal`.`sp_content_id`, `animal`.`image_id`, `animal`.`gallery_id`, `animal`.`sortable_rank`, `animal`.`created_at`, `animal`.`updated_at`, `animal`.`id` 
FROM `animal` 
WHERE `animal`.`dead`=0 AND `animal`.`petofday`=1 
ORDER BY `animal`.`updated_at` DESC

Time: 0.002 - Memory: 2.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

2) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:169: Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)

3) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:68: Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:49: AppBundle\Service\AnimalService->getPetOfDay()

7) /var/www/teddyfood/src/AppBundle/Service/AnimalService.php:216: Propel\Runtime\ActiveQuery\ModelCriteria->__call('findByPetofday', Array)

8) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:2194: call_user_func_array(Array, Array)

9) [internal function]: Propel\Runtime\ActiveQuery\ModelCriteria->findBy('Petofday', true)

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1273: Propel\Runtime\ActiveQuery\ModelCriteria->find(Object(Propel\Runtime\Connection\DebugPDO))

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:997: Propel\Runtime\ActiveQuery\ModelCriteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1988: Propel\Runtime\ActiveQuery\Criteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

13) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2644: Propel\Runtime\Connection\StatementWrapper->execute()

14) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT `animal`...')

15) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT `animal`...')

16) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `animal`...', Array)

SELECT DISTINCT `shelter_service_scheduler_rel`.`shelter_id`, `shelter_service_scheduler_rel`.`service_id`, `shelter_service_scheduler_rel`.`scheduler_id`, `shelter_service_scheduler_rel`.`urgent`, `shelter_service_scheduler_rel`.`price`, `shelter_service_scheduler_rel`.`price_tf`, `shelter_service_scheduler_rel`.`number_tf`, `shelter_service_scheduler_rel`.`start_at`, `shelter_service_scheduler_rel`.`created_at`, `shelter_service_scheduler_rel`.`updated_at`, `shelter_service_scheduler_rel`.`id` 
FROM `shelter_service_scheduler_rel` 
INNER JOIN `shelter` ON (`shelter_service_scheduler_rel`.`shelter_id`=`shelter`.`id`) 
LEFT JOIN `crowdfunding` ON (`shelter`.`id`=`crowdfunding`.`shelter_id`) 
LEFT JOIN `service` ON (`shelter_service_scheduler_rel`.`service_id`=`service`.`id`) 
WHERE `shelter_service_scheduler_rel`.`urgent`=1 AND `shelter`.`id`=16 AND `crowdfunding`.`service_id` = `shelter_service_scheduler_rel`.`service_id` AND `crowdfunding`.`visible`=1 AND (`crowdfunding`.`animal_kind_id` = 1 OR `crowdfunding`.`animal_kind_id` is null)

Time: 0.001 - Memory: 2.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:50: AppBundle\Model\Animal->getServiceOfDay()

7) /var/www/teddyfood/src/AppBundle/Model/Animal.php:221: AppBundle\Model\Animal->getTopServices()

8) /var/www/teddyfood/src/AppBundle/Model/Animal.php:167: Propel\Runtime\ActiveQuery\ModelCriteria->find()

9) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:997: Propel\Runtime\ActiveQuery\ModelCriteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1988: Propel\Runtime\ActiveQuery\Criteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2644: Propel\Runtime\Connection\StatementWrapper->execute()

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT DISTINCT...')

13) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT DISTINCT...')

14) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT DISTINCT...', Array)

SELECT `animal_service_scheduler_rel`.`animal_id`, `animal_service_scheduler_rel`.`service_id`, `animal_service_scheduler_rel`.`scheduler_id`, `animal_service_scheduler_rel`.`additional_price`, `animal_service_scheduler_rel`.`urgent`, `animal_service_scheduler_rel`.`active`, `animal_service_scheduler_rel`.`visible`, `animal_service_scheduler_rel`.`start_at`, `animal_service_scheduler_rel`.`created_at`, `animal_service_scheduler_rel`.`updated_at`, `animal_service_scheduler_rel`.`id` 
FROM `animal_service_scheduler_rel` 
INNER JOIN `animal` ON (`animal_service_scheduler_rel`.`animal_id`=`animal`.`id`) 
LEFT JOIN `service` ON (`animal_service_scheduler_rel`.`service_id`=`service`.`id`) 
WHERE `animal_service_scheduler_rel`.`visible`=1 AND `animal`.`id`=969 AND `animal_service_scheduler_rel`.`urgent`=1 AND `animal_service_scheduler_rel`.`active`=1

Time: 0.001 - Memory: 2.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:50: AppBundle\Model\Animal->getServiceOfDay()

7) /var/www/teddyfood/src/AppBundle/Model/Animal.php:221: AppBundle\Model\Animal->getTopServices()

8) /var/www/teddyfood/src/AppBundle/Model/Animal.php:178: Propel\Runtime\ActiveQuery\ModelCriteria->find()

9) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:997: Propel\Runtime\ActiveQuery\ModelCriteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1988: Propel\Runtime\ActiveQuery\Criteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2644: Propel\Runtime\Connection\StatementWrapper->execute()

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT `animal_...')

13) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT `animal_...')

14) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `animal_...', Array)

SELECT `country_id`, `city_id`, `phone`, `contact_phone`, `visible`, `created_at`, `updated_at`, `id` 
FROM `shelter` 
WHERE `id` = 16

Time: 0.001 - Memory: 2.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:50: AppBundle\Model\Animal->getServiceOfDay()

7) /var/www/teddyfood/src/AppBundle/Model/Animal.php:225: AppBundle\Model\ShelterServiceSchedulerRel->getCrowdfunding()

8) /var/www/teddyfood/src/AppBundle/Model/ShelterServiceSchedulerRel.php:32: AppBundle\Model\Base\ShelterServiceSchedulerRel->getShelter()

9) /var/www/teddyfood/src/AppBundle/Model/Base/ShelterServiceSchedulerRel.php:1843: AppBundle\Model\Base\ShelterQuery->findPk(16, Object(Propel\Runtime\Connection\DebugPDO))

10) /var/www/teddyfood/src/AppBundle/Model/Base/ShelterQuery.php:228: AppBundle\Model\Base\ShelterQuery->findPkSimple(16, Object(Propel\Runtime\Connection\DebugPDO))

11) /var/www/teddyfood/src/AppBundle/Model/Base/ShelterQuery.php:248: Propel\Runtime\Connection\StatementWrapper->execute()

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT `country...')

13) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT `country...')

14) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `country...', Array)

SELECT `service_category_id`, `show_on_petofday`, `for_dogs`, `for_cats`, `visible`, `image_id`, `created_at`, `updated_at`, `sortable_rank`, `id` 
FROM `service` 
WHERE `id` = 320

Time: 0.001 - Memory: 2.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:50: AppBundle\Model\Animal->getServiceOfDay()

7) /var/www/teddyfood/src/AppBundle/Model/Animal.php:225: AppBundle\Model\ShelterServiceSchedulerRel->getCrowdfunding()

8) /var/www/teddyfood/src/AppBundle/Model/ShelterServiceSchedulerRel.php:32: AppBundle\Model\Base\ShelterServiceSchedulerRel->getService()

9) /var/www/teddyfood/src/AppBundle/Model/Base/ShelterServiceSchedulerRel.php:1894: AppBundle\Model\Base\ServiceQuery->findPk(320, Object(Propel\Runtime\Connection\DebugPDO))

10) /var/www/teddyfood/src/AppBundle/Model/Base/ServiceQuery.php:249: AppBundle\Model\Base\ServiceQuery->findPkSimple(320, Object(Propel\Runtime\Connection\DebugPDO))

11) /var/www/teddyfood/src/AppBundle/Model/Base/ServiceQuery.php:269: Propel\Runtime\Connection\StatementWrapper->execute()

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT `service...')

13) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT `service...')

14) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `service...', Array)

SELECT `crowdfunding`.`animal_id`, `crowdfunding`.`shelter_id`, `crowdfunding`.`service_id`, `crowdfunding`.`report_id`, `crowdfunding`.`target_amount`, `crowdfunding`.`amount`, `crowdfunding`.`completed`, `crowdfunding`.`visible`, `crowdfunding`.`is_mass`, `crowdfunding`.`animal_kind_id`, `crowdfunding`.`started_at`, `crowdfunding`.`finished_at`, `crowdfunding`.`reported_at`, `crowdfunding`.`image_id`, `crowdfunding`.`gallery_id`, `crowdfunding`.`id` 
FROM `crowdfunding` 
WHERE `crowdfunding`.`shelter_id`=16 AND `crowdfunding`.`service_id`=320 AND `crowdfunding`.`visible`=1 AND `crowdfunding`.`started_at`<='2025-12-15 08:19:33.684988' 
LIMIT 1

Time: 0.001 - Memory: 2.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:50: AppBundle\Model\Animal->getServiceOfDay()

7) /var/www/teddyfood/src/AppBundle/Model/Animal.php:225: AppBundle\Model\ShelterServiceSchedulerRel->getCrowdfunding()

8) /var/www/teddyfood/src/AppBundle/Model/ShelterServiceSchedulerRel.php:32: Propel\Runtime\ActiveQuery\ModelCriteria->findOne()

9) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1024: Propel\Runtime\ActiveQuery\ModelCriteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1988: Propel\Runtime\ActiveQuery\Criteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2644: Propel\Runtime\Connection\StatementWrapper->execute()

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT `crowdfu...')

13) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT `crowdfu...')

14) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `crowdfu...', Array)

SELECT COUNT(*) 
FROM `animal` 
LEFT JOIN `animal_i18n` ON (`animal`.`id`=`animal_i18n`.`id` AND `animal_i18n`.`locale` = 'en') 
LEFT JOIN `shelter` ON (`animal`.`shelter_id`=`shelter`.`id`) 
LEFT JOIN `animal_breed` ON (`animal`.`animal_breed_id`=`animal_breed`.`id`) 
LEFT JOIN `image` ON (`animal`.`image_id`=`image`.`id`) 
LEFT JOIN `file` ON (`image`.`file_id`=`file`.`id`) 
WHERE `animal`.`dead`=0 AND `animal_i18n`.`description`<>'' AND `animal`.`visible`=1

Time: 0.002 - Memory: 2.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:51: AppBundle\Service\AnimalService->getList(Object(Symfony\Component\HttpFoundation\Request), 1, 6)

7) /var/www/teddyfood/src/AppBundle/Service/AnimalService.php:157: Propel\Runtime\ActiveQuery\ModelCriteria->paginate(1, 6)

8) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1440: Propel\Runtime\Util\PropelModelPager->init(NULL)

9) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Util/PropelModelPager.php:104: Propel\Runtime\ActiveQuery\ModelCriteria->count(Object(Propel\Runtime\Connection\DebugPDO))

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1367: Propel\Runtime\ActiveQuery\ModelCriteria->doCount(Object(Propel\Runtime\Connection\DebugPDO))

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1388: Propel\Runtime\ActiveQuery\Criteria->doCount(Object(Propel\Runtime\Connection\DebugPDO))

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2527: Propel\Runtime\Connection\StatementWrapper->execute()

13) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT COUNT(*)...')

14) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT COUNT(*)...')

15) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT COUNT(*)...', Array)

SELECT `animal`.`animal_kind_id`, `animal`.`animal_breed_id`, `animal`.`shelter_id`, `animal`.`curator_id`, `animal`.`uri`, `animal`.`gender`, `animal`.`status`, `animal`.`stream_url`, `animal`.`has_ar`, `animal`.`visible`, `animal`.`petofday`, `animal`.`is_public_translation`, `animal`.`error_video`, `animal`.`dead`, `animal`.`age`, `animal`.`date_from`, `animal`.`ru_content_id`, `animal`.`en_content_id`, `animal`.`jp_content_id`, `animal`.`de_content_id`, `animal`.`fr_content_id`, `animal`.`sp_content_id`, `animal`.`image_id`, `animal`.`gallery_id`, `animal`.`sortable_rank`, `animal`.`created_at`, `animal`.`updated_at`, `animal`.`id`, `animal_breed`.`animal_kind_id`, `animal_breed`.`created_at`, `animal_breed`.`updated_at`, `animal_breed`.`id`, `image`.`file_id`, `image`.`id`, `file`.`path`, `file`.`name`, `file`.`original_name`, `file`.`extension`, `file`.`mime`, `file`.`size`, `file`.`id`, IF(`shelter`.`country_id` = 160, 1, 0) AS is_priority_country 
FROM `animal` 
LEFT JOIN `animal_i18n` ON (`animal`.`id`=`animal_i18n`.`id` AND `animal_i18n`.`locale` = 'en') 
LEFT JOIN `shelter` ON (`animal`.`shelter_id`=`shelter`.`id`) 
LEFT JOIN `animal_breed` ON (`animal`.`animal_breed_id`=`animal_breed`.`id`) 
LEFT JOIN `image` ON (`animal`.`image_id`=`image`.`id`) 
LEFT JOIN `file` ON (`image`.`file_id`=`file`.`id`) 
WHERE `animal`.`dead`=0 AND `animal_i18n`.`description`<>'' AND `animal`.`visible`=1 
ORDER BY is_priority_country DESC,`animal`.`sortable_rank` ASC,`animal`.`visible` DESC 
LIMIT 6

Time: 0.004 - Memory: 4.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:51: AppBundle\Service\AnimalService->getList(Object(Symfony\Component\HttpFoundation\Request), 1, 6)

7) /var/www/teddyfood/src/AppBundle/Service/AnimalService.php:164: Propel\Runtime\Util\PropelModelPager->getResults()

8) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Util/PropelModelPager.php:150: Propel\Runtime\ActiveQuery\ModelCriteria->find(Object(Propel\Runtime\Connection\DebugPDO))

9) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:997: Propel\Runtime\ActiveQuery\ModelCriteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1988: Propel\Runtime\ActiveQuery\Criteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2644: Propel\Runtime\Connection\StatementWrapper->execute()

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT `animal`...')

13) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT `animal`...')

14) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `animal`...', Array)

SELECT `animal_i18n`.`id`, `animal_i18n`.`locale`, `animal_i18n`.`title`, `animal_i18n`.`description`, `animal_i18n`.`history_content`, `animal_i18n`.`medical_content` 
FROM `animal_i18n` 
WHERE locale='en' AND `animal_i18n`.`id` IN (93,94,1208,95,623,251)

Time: 0.001 - Memory: 4.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:51: AppBundle\Service\AnimalService->getList(Object(Symfony\Component\HttpFoundation\Request), 1, 6)

7) /var/www/teddyfood/src/AppBundle/Service/AnimalService.php:165: AppBundle\Model\QueryHelper::populateTranslation(Object(Propel\Runtime\Collection\ObjectCollection))

8) /var/www/teddyfood/src/AppBundle/Model/QueryHelper.php:29: Propel\Runtime\Collection\ObjectCollection->populateRelation('AnimalI18n', Object(Propel\Runtime\ActiveQuery\Criteria))

9) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Collection/ObjectCollection.php:347: Propel\Runtime\ActiveQuery\ModelCriteria->find(Object(Propel\Runtime\Connection\DebugPDO))

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:997: Propel\Runtime\ActiveQuery\ModelCriteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1988: Propel\Runtime\ActiveQuery\Criteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2644: Propel\Runtime\Connection\StatementWrapper->execute()

13) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT `animal_...')

14) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT `animal_...')

15) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `animal_...', Array)

SELECT `shelter`.`country_id`, `shelter`.`city_id`, `shelter`.`phone`, `shelter`.`contact_phone`, `shelter`.`visible`, `shelter`.`created_at`, `shelter`.`updated_at`, `shelter`.`id` 
FROM `shelter` 
LEFT JOIN `animal` ON (`shelter`.`id`=`animal`.`shelter_id`) 
WHERE `animal`.`id` IN (93,94,1208,95,623,251)

Time: 0.001 - Memory: 4.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:51: AppBundle\Service\AnimalService->getList(Object(Symfony\Component\HttpFoundation\Request), 1, 6)

7) /var/www/teddyfood/src/AppBundle/Service/AnimalService.php:167: AppBundle\Model\QueryHelper::populateRelation(Object(Propel\Runtime\Collection\ObjectCollection), 'Shelter')

8) /var/www/teddyfood/src/AppBundle/Model/QueryHelper.php:16: Propel\Runtime\Collection\ObjectCollection->populateRelation('Shelter')

9) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Collection/ObjectCollection.php:347: Propel\Runtime\ActiveQuery\ModelCriteria->find(Object(Propel\Runtime\Connection\DebugPDO))

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:997: Propel\Runtime\ActiveQuery\ModelCriteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1988: Propel\Runtime\ActiveQuery\Criteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2644: Propel\Runtime\Connection\StatementWrapper->execute()

13) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT `shelter...')

14) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT `shelter...')

15) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `shelter...', Array)

SELECT `city`.`country_id`, `city`.`visible`, `city`.`created_at`, `city`.`updated_at`, `city`.`sortable_rank`, `city`.`id` 
FROM `city` 
INNER JOIN `shelter` ON (`city`.`id`=`shelter`.`city_id`) 
WHERE `shelter`.`id` IN (8,8,8,8,16,6)

Time: 0 - Memory: 4.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:51: AppBundle\Service\AnimalService->getList(Object(Symfony\Component\HttpFoundation\Request), 1, 6)

7) /var/www/teddyfood/src/AppBundle/Service/AnimalService.php:168: AppBundle\Model\QueryHelper::populateRelation(Object(Propel\Runtime\Collection\ObjectCollection), 'City')

8) /var/www/teddyfood/src/AppBundle/Model/QueryHelper.php:16: Propel\Runtime\Collection\ObjectCollection->populateRelation('City')

9) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Collection/ObjectCollection.php:347: Propel\Runtime\ActiveQuery\ModelCriteria->find(Object(Propel\Runtime\Connection\DebugPDO))

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:997: Propel\Runtime\ActiveQuery\ModelCriteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1988: Propel\Runtime\ActiveQuery\Criteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2644: Propel\Runtime\Connection\StatementWrapper->execute()

13) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT `city`.`...')

14) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT `city`.`...')

15) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `city`.`...', Array)

SELECT `shelter_i18n`.`id`, `shelter_i18n`.`locale`, `shelter_i18n`.`title`, `shelter_i18n`.`title_short`, `shelter_i18n`.`description`, `shelter_i18n`.`address`, `shelter_i18n`.`contact_person`, `shelter_i18n`.`comment` 
FROM `shelter_i18n` 
WHERE locale='en' AND `shelter_i18n`.`id` IN (8,16,6)

Time: 0 - Memory: 4.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:51: AppBundle\Service\AnimalService->getList(Object(Symfony\Component\HttpFoundation\Request), 1, 6)

7) /var/www/teddyfood/src/AppBundle/Service/AnimalService.php:169: AppBundle\Model\QueryHelper::populateTranslation(Object(Propel\Runtime\Collection\ObjectCollection))

8) /var/www/teddyfood/src/AppBundle/Model/QueryHelper.php:29: Propel\Runtime\Collection\ObjectCollection->populateRelation('ShelterI18n', Object(Propel\Runtime\ActiveQuery\Criteria))

9) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Collection/ObjectCollection.php:347: Propel\Runtime\ActiveQuery\ModelCriteria->find(Object(Propel\Runtime\Connection\DebugPDO))

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:997: Propel\Runtime\ActiveQuery\ModelCriteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1988: Propel\Runtime\ActiveQuery\Criteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2644: Propel\Runtime\Connection\StatementWrapper->execute()

13) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT `shelter...')

14) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT `shelter...')

15) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `shelter...', Array)

SELECT `city_i18n`.`id`, `city_i18n`.`locale`, `city_i18n`.`title` 
FROM `city_i18n` 
WHERE locale='en' AND `city_i18n`.`id` IN (8,10,14)

Time: 0 - Memory: 4.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:51: AppBundle\Service\AnimalService->getList(Object(Symfony\Component\HttpFoundation\Request), 1, 6)

7) /var/www/teddyfood/src/AppBundle/Service/AnimalService.php:170: AppBundle\Model\QueryHelper::populateTranslation(Object(Propel\Runtime\Collection\ObjectCollection))

8) /var/www/teddyfood/src/AppBundle/Model/QueryHelper.php:29: Propel\Runtime\Collection\ObjectCollection->populateRelation('CityI18n', Object(Propel\Runtime\ActiveQuery\Criteria))

9) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Collection/ObjectCollection.php:347: Propel\Runtime\ActiveQuery\ModelCriteria->find(Object(Propel\Runtime\Connection\DebugPDO))

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:997: Propel\Runtime\ActiveQuery\ModelCriteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1988: Propel\Runtime\ActiveQuery\Criteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2644: Propel\Runtime\Connection\StatementWrapper->execute()

13) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT `city_i1...')

14) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT `city_i1...')

15) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `city_i1...', Array)

SELECT DISTINCT `service_category`.`service_category_id`, `service_category`.`icon_key`, `service_category`.`visible`, `service_category`.`start_at`, `service_category`.`image_id`, `service_category`.`created_at`, `service_category`.`updated_at`, `service_category`.`sortable_rank`, `service_category`.`id` 
FROM `service_category` 
WHERE `service_category`.`service_category_id` IN (3,11,6)

Time: 0.001 - Memory: 4.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:51: AppBundle\Service\AnimalService->getList(Object(Symfony\Component\HttpFoundation\Request), 1, 6)

7) /var/www/teddyfood/src/AppBundle/Service/AnimalService.php:181: AppBundle\Model\ServiceCategoryQuery::getUrgentHelpCategoryIds()

8) /var/www/teddyfood/src/AppBundle/Model/ServiceCategoryQuery.php:25: AppBundle\Model\ServiceCategoryQuery::getSubcategories(Array)

9) /var/www/teddyfood/src/AppBundle/Model/ServiceCategoryQuery.php:40: Propel\Runtime\ActiveQuery\ModelCriteria->find()

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:997: Propel\Runtime\ActiveQuery\ModelCriteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1988: Propel\Runtime\ActiveQuery\Criteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2644: Propel\Runtime\Connection\StatementWrapper->execute()

13) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT DISTINCT...')

14) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT DISTINCT...')

15) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT DISTINCT...', Array)

SELECT `animal_service_scheduler_rel`.`animal_id`, `animal_service_scheduler_rel`.`service_id`, `animal_service_scheduler_rel`.`scheduler_id`, `animal_service_scheduler_rel`.`additional_price`, `animal_service_scheduler_rel`.`urgent`, `animal_service_scheduler_rel`.`active`, `animal_service_scheduler_rel`.`visible`, `animal_service_scheduler_rel`.`start_at`, `animal_service_scheduler_rel`.`created_at`, `animal_service_scheduler_rel`.`updated_at`, `animal_service_scheduler_rel`.`id` 
FROM `animal_service_scheduler_rel` 
LEFT JOIN `service` ON (`animal_service_scheduler_rel`.`service_id`=`service`.`id`) 
WHERE `animal_service_scheduler_rel`.`animal_id` IN (93,94,1208,95,623,251) AND `animal_service_scheduler_rel`.`urgent`=1 AND `animal_service_scheduler_rel`.`active`=1 AND `animal_service_scheduler_rel`.`visible`=1 AND `service`.`service_category_id` IN (3,11,6,8,9,10,12,19,25,26,28,29,30,31,32,33,34,35,39,40,45,46,49)

Time: 0.001 - Memory: 4.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:51: AppBundle\Service\AnimalService->getList(Object(Symfony\Component\HttpFoundation\Request), 1, 6)

7) /var/www/teddyfood/src/AppBundle/Service/AnimalService.php:183: Propel\Runtime\ActiveQuery\ModelCriteria->find()

8) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:997: Propel\Runtime\ActiveQuery\ModelCriteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

9) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1988: Propel\Runtime\ActiveQuery\Criteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2644: Propel\Runtime\Connection\StatementWrapper->execute()

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT `animal_...')

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT `animal_...')

13) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `animal_...', Array)

SELECT `animal_service_scheduler_rel`.`animal_id`, `animal_service_scheduler_rel`.`service_id`, `animal_service_scheduler_rel`.`scheduler_id`, `animal_service_scheduler_rel`.`additional_price`, `animal_service_scheduler_rel`.`urgent`, `animal_service_scheduler_rel`.`active`, `animal_service_scheduler_rel`.`visible`, `animal_service_scheduler_rel`.`start_at`, `animal_service_scheduler_rel`.`created_at`, `animal_service_scheduler_rel`.`updated_at`, `animal_service_scheduler_rel`.`id` 
FROM `animal_service_scheduler_rel` 
WHERE `animal_service_scheduler_rel`.`animal_id` IN (93,94,1208,95,623,251) AND `animal_service_scheduler_rel`.`urgent`=1 AND `animal_service_scheduler_rel`.`active`=1 AND `animal_service_scheduler_rel`.`visible`=1

Time: 0.001 - Memory: 4.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:51: AppBundle\Service\AnimalService->getList(Object(Symfony\Component\HttpFoundation\Request), 1, 6)

7) /var/www/teddyfood/src/AppBundle/Service/AnimalService.php:190: Propel\Runtime\ActiveQuery\ModelCriteria->find()

8) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:997: Propel\Runtime\ActiveQuery\ModelCriteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

9) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1988: Propel\Runtime\ActiveQuery\Criteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2644: Propel\Runtime\Connection\StatementWrapper->execute()

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT `animal_...')

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT `animal_...')

13) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `animal_...', Array)

SELECT COUNT(*) 
FROM `animal`

Time: 0.001 - Memory: 4.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:53: Propel\Runtime\ActiveQuery\ModelCriteria->count()

7) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1367: Propel\Runtime\ActiveQuery\ModelCriteria->doCount(Object(Propel\Runtime\Connection\DebugPDO))

8) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1388: Propel\Runtime\ActiveQuery\Criteria->doCount(Object(Propel\Runtime\Connection\DebugPDO))

9) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2527: Propel\Runtime\Connection\StatementWrapper->execute()

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT COUNT(*)...')

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT COUNT(*)...')

12) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT COUNT(*)...', Array)

SELECT `order_item`.`order_id`, `order_item`.`shelter_service_id`, `order_item`.`animal_service_id`, `order_item`.`crowdfunding_id`, `order_item`.`fundraiser_id`, `order_item`.`certificate_id`, `order_item`.`recurrent_sign`, `order_item`.`number_tf`, `order_item`.`number_tf_ticket`, `order_item`.`price_tf`, `order_item`.`price`, `order_item`.`original_price`, `order_item`.`amount`, `order_item`.`title`, `order_item`.`report`, `order_item`.`completed`, `order_item`.`created_at`, `order_item`.`updated_at`, `order_item`.`id`, `order`.`customer_id`, `order`.`number_tf_ticket`, `order`.`number_tf`, `order`.`price_tf`, `order`.`price`, `order`.`original_price`, `order`.`currency`, `order`.`info`, `order`.`completed`, `order`.`site_version`, `order`.`created_at`, `order`.`updated_at`, `order`.`id`, `customer`.`user_id`, `customer`.`carrotquest_user_id`, `customer`.`stripe_customer_id`, `customer`.`secret`, `customer`.`email`, `customer`.`locale`, `customer`.`created_at`, `customer`.`updated_at`, `customer`.`id`, `user`.`name`, `user`.`country_id`, `user`.`recurrent_id`, `user`.`ref_id`, `user`.`is_akbars_client`, `user`.`is_carrotquest_draft`, `user`.`is_ref_bonus_applied`, `user`.`is_show_ref_banner`, `user`.`is_show_welcome_ref_banner`, `user`.`welcome_bonus_status`, `user`.`email`, `user`.`email_new`, `user`.`city`, `user`.`hash`, `user`.`ref_code`, `user`.`count_buy`, `user`.`token`, `user`.`about`, `user`.`token_expire_at`, `user`.`birth_at`, `user`.`big_image`, `user`.`remind_activities`, `user`.`locale`, `user`.`password`, `user`.`salt`, `user`.`image_id`, `user`.`created_at`, `user`.`updated_at`, `user`.`id`, `userImage`.`file_id`, `userImage`.`id`, `userImageFile`.`path`, `userImageFile`.`name`, `userImageFile`.`original_name`, `userImageFile`.`extension`, `userImageFile`.`mime`, `userImageFile`.`size`, `userImageFile`.`id`, `crowdfunding`.`animal_id`, `crowdfunding`.`shelter_id`, `crowdfunding`.`service_id`, `crowdfunding`.`report_id`, `crowdfunding`.`target_amount`, `crowdfunding`.`amount`, `crowdfunding`.`completed`, `crowdfunding`.`visible`, `crowdfunding`.`is_mass`, `crowdfunding`.`animal_kind_id`, `crowdfunding`.`started_at`, `crowdfunding`.`finished_at`, `crowdfunding`.`reported_at`, `crowdfunding`.`image_id`, `crowdfunding`.`gallery_id`, `crowdfunding`.`id` 
FROM `order_item` 
INNER JOIN `order` ON (`order_item`.`order_id`=`order`.`id`) 
LEFT JOIN `customer` ON (`order`.`customer_id`=`customer`.`id`) 
LEFT JOIN `user` ON (`customer`.`user_id`=`user`.`id`) 
LEFT JOIN `image` `userImage` ON (`user`.`image_id`=`userImage`.`id`) 
LEFT JOIN `file` `userImageFile` ON (`userImage`.`file_id`=`userImageFile`.`id`) 
LEFT JOIN `crowdfunding` ON (`order_item`.`crowdfunding_id`=`crowdfunding`.`id`) 
WHERE `order_item`.`completed`=1 AND `order_item`.`fundraiser_id` IS NULL  AND `order_item`.`certificate_id` IS NULL  
ORDER BY `order_item`.`order_id` DESC 
LIMIT 10

Time: 0.002 - Memory: 6.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:54: AppBundle\Model\OrderQuery->getHistory(1, false)

7) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:45: AppBundle\Model\OrderQuery->getPurchasedServices(1, false)

8) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:85: Propel\Runtime\ActiveQuery\ModelCriteria->find()

9) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:997: Propel\Runtime\ActiveQuery\ModelCriteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1988: Propel\Runtime\ActiveQuery\Criteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2644: Propel\Runtime\Connection\StatementWrapper->execute()

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT `order_i...')

13) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT `order_i...')

14) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `order_i...', Array)

SELECT `animal_service_scheduler_rel`.`animal_id`, `animal_service_scheduler_rel`.`service_id`, `animal_service_scheduler_rel`.`scheduler_id`, `animal_service_scheduler_rel`.`additional_price`, `animal_service_scheduler_rel`.`urgent`, `animal_service_scheduler_rel`.`active`, `animal_service_scheduler_rel`.`visible`, `animal_service_scheduler_rel`.`start_at`, `animal_service_scheduler_rel`.`created_at`, `animal_service_scheduler_rel`.`updated_at`, `animal_service_scheduler_rel`.`id` 
FROM `animal_service_scheduler_rel` 
LEFT JOIN `order_item` ON (`animal_service_scheduler_rel`.`id`=`order_item`.`animal_service_id`) 
WHERE `order_item`.`id` IN (102408,102407,102406,102387,102380,102379,102378,102377,102376,102374)

Time: 0.001 - Memory: 6.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:54: AppBundle\Model\OrderQuery->getHistory(1, false)

7) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:45: AppBundle\Model\OrderQuery->getPurchasedServices(1, false)

8) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:87: AppBundle\Model\QueryHelper::populateRelation(Object(Propel\Runtime\Collection\ObjectCollection), 'AnimalServiceSc...')

9) /var/www/teddyfood/src/AppBundle/Model/QueryHelper.php:16: Propel\Runtime\Collection\ObjectCollection->populateRelation('AnimalServiceSc...')

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Collection/ObjectCollection.php:347: Propel\Runtime\ActiveQuery\ModelCriteria->find(Object(Propel\Runtime\Connection\DebugPDO))

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:997: Propel\Runtime\ActiveQuery\ModelCriteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1988: Propel\Runtime\ActiveQuery\Criteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

13) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2644: Propel\Runtime\Connection\StatementWrapper->execute()

14) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT `animal_...')

15) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT `animal_...')

16) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `animal_...', Array)

SELECT `animal`.`animal_kind_id`, `animal`.`animal_breed_id`, `animal`.`shelter_id`, `animal`.`curator_id`, `animal`.`uri`, `animal`.`gender`, `animal`.`status`, `animal`.`stream_url`, `animal`.`has_ar`, `animal`.`visible`, `animal`.`petofday`, `animal`.`is_public_translation`, `animal`.`error_video`, `animal`.`dead`, `animal`.`age`, `animal`.`date_from`, `animal`.`ru_content_id`, `animal`.`en_content_id`, `animal`.`jp_content_id`, `animal`.`de_content_id`, `animal`.`fr_content_id`, `animal`.`sp_content_id`, `animal`.`image_id`, `animal`.`gallery_id`, `animal`.`sortable_rank`, `animal`.`created_at`, `animal`.`updated_at`, `animal`.`id` 
FROM `animal` 
INNER JOIN `animal_service_scheduler_rel` ON (`animal`.`id`=`animal_service_scheduler_rel`.`animal_id`) 
WHERE `animal_service_scheduler_rel`.`id` IN (10062,10062)

Time: 0.001 - Memory: 6.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:54: AppBundle\Model\OrderQuery->getHistory(1, false)

7) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:45: AppBundle\Model\OrderQuery->getPurchasedServices(1, false)

8) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:88: AppBundle\Model\QueryHelper::populateRelation(Object(Propel\Runtime\Collection\ObjectCollection), 'Animal')

9) /var/www/teddyfood/src/AppBundle/Model/QueryHelper.php:16: Propel\Runtime\Collection\ObjectCollection->populateRelation('Animal')

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Collection/ObjectCollection.php:347: Propel\Runtime\ActiveQuery\ModelCriteria->find(Object(Propel\Runtime\Connection\DebugPDO))

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:997: Propel\Runtime\ActiveQuery\ModelCriteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1988: Propel\Runtime\ActiveQuery\Criteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

13) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2644: Propel\Runtime\Connection\StatementWrapper->execute()

14) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT `animal`...')

15) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT `animal`...')

16) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `animal`...', Array)

SELECT `animal_i18n`.`id`, `animal_i18n`.`locale`, `animal_i18n`.`title`, `animal_i18n`.`description`, `animal_i18n`.`history_content`, `animal_i18n`.`medical_content` 
FROM `animal_i18n` 
WHERE locale='en' AND `animal_i18n`.`id` IN (974)

Time: 0.001 - Memory: 6.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:54: AppBundle\Model\OrderQuery->getHistory(1, false)

7) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:45: AppBundle\Model\OrderQuery->getPurchasedServices(1, false)

8) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:89: AppBundle\Model\QueryHelper::populateTranslation(Object(Propel\Runtime\Collection\ObjectCollection))

9) /var/www/teddyfood/src/AppBundle/Model/QueryHelper.php:29: Propel\Runtime\Collection\ObjectCollection->populateRelation('AnimalI18n', Object(Propel\Runtime\ActiveQuery\Criteria))

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Collection/ObjectCollection.php:347: Propel\Runtime\ActiveQuery\ModelCriteria->find(Object(Propel\Runtime\Connection\DebugPDO))

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:997: Propel\Runtime\ActiveQuery\ModelCriteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1988: Propel\Runtime\ActiveQuery\Criteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

13) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2644: Propel\Runtime\Connection\StatementWrapper->execute()

14) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT `animal_...')

15) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT `animal_...')

16) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `animal_...', Array)

SELECT `image`.`file_id`, `image`.`id` 
FROM `image` 
LEFT JOIN `animal` ON (`image`.`id`=`animal`.`image_id`) 
WHERE `animal`.`id` IN (974)

Time: 0 - Memory: 6.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:54: AppBundle\Model\OrderQuery->getHistory(1, false)

7) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:45: AppBundle\Model\OrderQuery->getPurchasedServices(1, false)

8) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:90: AppBundle\Model\QueryHelper::populateRelation(Object(Propel\Runtime\Collection\ObjectCollection), 'Image')

9) /var/www/teddyfood/src/AppBundle/Model/QueryHelper.php:16: Propel\Runtime\Collection\ObjectCollection->populateRelation('Image')

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Collection/ObjectCollection.php:347: Propel\Runtime\ActiveQuery\ModelCriteria->find(Object(Propel\Runtime\Connection\DebugPDO))

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:997: Propel\Runtime\ActiveQuery\ModelCriteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1988: Propel\Runtime\ActiveQuery\Criteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

13) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2644: Propel\Runtime\Connection\StatementWrapper->execute()

14) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT `image`....')

15) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT `image`....')

16) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `image`....', Array)

SELECT `file`.`path`, `file`.`name`, `file`.`original_name`, `file`.`extension`, `file`.`mime`, `file`.`size`, `file`.`id` 
FROM `file` 
LEFT JOIN `image` ON (`file`.`id`=`image`.`file_id`) 
WHERE `image`.`id` IN (10941)

Time: 0 - Memory: 6.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:54: AppBundle\Model\OrderQuery->getHistory(1, false)

7) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:45: AppBundle\Model\OrderQuery->getPurchasedServices(1, false)

8) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:91: AppBundle\Model\QueryHelper::populateRelation(Object(Propel\Runtime\Collection\ObjectCollection), 'File')

9) /var/www/teddyfood/src/AppBundle/Model/QueryHelper.php:16: Propel\Runtime\Collection\ObjectCollection->populateRelation('File')

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Collection/ObjectCollection.php:347: Propel\Runtime\ActiveQuery\ModelCriteria->find(Object(Propel\Runtime\Connection\DebugPDO))

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:997: Propel\Runtime\ActiveQuery\ModelCriteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1988: Propel\Runtime\ActiveQuery\Criteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

13) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2644: Propel\Runtime\Connection\StatementWrapper->execute()

14) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT `file`.`...')

15) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT `file`.`...')

16) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `file`.`...', Array)

SELECT `service`.`service_category_id`, `service`.`show_on_petofday`, `service`.`for_dogs`, `service`.`for_cats`, `service`.`visible`, `service`.`image_id`, `service`.`created_at`, `service`.`updated_at`, `service`.`sortable_rank`, `service`.`id` 
FROM `service` 
LEFT JOIN `animal_service_scheduler_rel` ON (`service`.`id`=`animal_service_scheduler_rel`.`service_id`) 
WHERE `animal_service_scheduler_rel`.`id` IN (10062,10062)

Time: 0.001 - Memory: 6.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:54: AppBundle\Model\OrderQuery->getHistory(1, false)

7) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:45: AppBundle\Model\OrderQuery->getPurchasedServices(1, false)

8) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:92: AppBundle\Model\QueryHelper::populateRelation(Object(Propel\Runtime\Collection\ObjectCollection), 'Service')

9) /var/www/teddyfood/src/AppBundle/Model/QueryHelper.php:16: Propel\Runtime\Collection\ObjectCollection->populateRelation('Service')

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Collection/ObjectCollection.php:347: Propel\Runtime\ActiveQuery\ModelCriteria->find(Object(Propel\Runtime\Connection\DebugPDO))

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:997: Propel\Runtime\ActiveQuery\ModelCriteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1988: Propel\Runtime\ActiveQuery\Criteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

13) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2644: Propel\Runtime\Connection\StatementWrapper->execute()

14) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT `service...')

15) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT `service...')

16) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `service...', Array)

SELECT `service_i18n`.`id`, `service_i18n`.`locale`, `service_i18n`.`title`, `service_i18n`.`description` 
FROM `service_i18n` 
WHERE locale='en' AND `service_i18n`.`id` IN (27)

Time: 0 - Memory: 6.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:54: AppBundle\Model\OrderQuery->getHistory(1, false)

7) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:45: AppBundle\Model\OrderQuery->getPurchasedServices(1, false)

8) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:93: AppBundle\Model\QueryHelper::populateTranslation(Object(Propel\Runtime\Collection\ObjectCollection))

9) /var/www/teddyfood/src/AppBundle/Model/QueryHelper.php:29: Propel\Runtime\Collection\ObjectCollection->populateRelation('ServiceI18n', Object(Propel\Runtime\ActiveQuery\Criteria))

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Collection/ObjectCollection.php:347: Propel\Runtime\ActiveQuery\ModelCriteria->find(Object(Propel\Runtime\Connection\DebugPDO))

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:997: Propel\Runtime\ActiveQuery\ModelCriteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1988: Propel\Runtime\ActiveQuery\Criteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

13) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2644: Propel\Runtime\Connection\StatementWrapper->execute()

14) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT `service...')

15) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT `service...')

16) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `service...', Array)

SELECT `service_category`.`service_category_id`, `service_category`.`icon_key`, `service_category`.`visible`, `service_category`.`start_at`, `service_category`.`image_id`, `service_category`.`created_at`, `service_category`.`updated_at`, `service_category`.`sortable_rank`, `service_category`.`id` 
FROM `service_category` 
LEFT JOIN `service` ON (`service_category`.`id`=`service`.`service_category_id`) 
WHERE `service`.`id` IN (27)

Time: 0.001 - Memory: 6.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:54: AppBundle\Model\OrderQuery->getHistory(1, false)

7) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:45: AppBundle\Model\OrderQuery->getPurchasedServices(1, false)

8) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:94: AppBundle\Model\QueryHelper::populateRelation(Object(Propel\Runtime\Collection\ObjectCollection), 'ServiceCategory')

9) /var/www/teddyfood/src/AppBundle/Model/QueryHelper.php:16: Propel\Runtime\Collection\ObjectCollection->populateRelation('ServiceCategory')

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Collection/ObjectCollection.php:347: Propel\Runtime\ActiveQuery\ModelCriteria->find(Object(Propel\Runtime\Connection\DebugPDO))

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:997: Propel\Runtime\ActiveQuery\ModelCriteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1988: Propel\Runtime\ActiveQuery\Criteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

13) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2644: Propel\Runtime\Connection\StatementWrapper->execute()

14) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT `service...')

15) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT `service...')

16) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `service...', Array)

SELECT `service_category_i18n`.`id`, `service_category_i18n`.`locale`, `service_category_i18n`.`title`, `service_category_i18n`.`description` 
FROM `service_category_i18n` 
WHERE locale='en' AND `service_category_i18n`.`id` IN (12)

Time: 0 - Memory: 6.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:54: AppBundle\Model\OrderQuery->getHistory(1, false)

7) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:45: AppBundle\Model\OrderQuery->getPurchasedServices(1, false)

8) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:95: AppBundle\Model\QueryHelper::populateTranslation(Object(Propel\Runtime\Collection\ObjectCollection))

9) /var/www/teddyfood/src/AppBundle/Model/QueryHelper.php:29: Propel\Runtime\Collection\ObjectCollection->populateRelation('ServiceCategory...', Object(Propel\Runtime\ActiveQuery\Criteria))

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Collection/ObjectCollection.php:347: Propel\Runtime\ActiveQuery\ModelCriteria->find(Object(Propel\Runtime\Connection\DebugPDO))

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:997: Propel\Runtime\ActiveQuery\ModelCriteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1988: Propel\Runtime\ActiveQuery\Criteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

13) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2644: Propel\Runtime\Connection\StatementWrapper->execute()

14) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT `service...')

15) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT `service...')

16) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `service...', Array)

SELECT `shelter_service_scheduler_rel`.`shelter_id`, `shelter_service_scheduler_rel`.`service_id`, `shelter_service_scheduler_rel`.`scheduler_id`, `shelter_service_scheduler_rel`.`urgent`, `shelter_service_scheduler_rel`.`price`, `shelter_service_scheduler_rel`.`price_tf`, `shelter_service_scheduler_rel`.`number_tf`, `shelter_service_scheduler_rel`.`start_at`, `shelter_service_scheduler_rel`.`created_at`, `shelter_service_scheduler_rel`.`updated_at`, `shelter_service_scheduler_rel`.`id` 
FROM `shelter_service_scheduler_rel` 
LEFT JOIN `order_item` ON (`shelter_service_scheduler_rel`.`id`=`order_item`.`shelter_service_id`) 
WHERE `order_item`.`id` IN (102408,102407,102406,102387,102380,102379,102378,102377,102376,102374)

Time: 0.001 - Memory: 6.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:54: AppBundle\Model\OrderQuery->getHistory(1, false)

7) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:45: AppBundle\Model\OrderQuery->getPurchasedServices(1, false)

8) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:97: AppBundle\Model\QueryHelper::populateRelation(Object(Propel\Runtime\Collection\ObjectCollection), 'ShelterServiceS...')

9) /var/www/teddyfood/src/AppBundle/Model/QueryHelper.php:16: Propel\Runtime\Collection\ObjectCollection->populateRelation('ShelterServiceS...')

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Collection/ObjectCollection.php:347: Propel\Runtime\ActiveQuery\ModelCriteria->find(Object(Propel\Runtime\Connection\DebugPDO))

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:997: Propel\Runtime\ActiveQuery\ModelCriteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

12) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1988: Propel\Runtime\ActiveQuery\Criteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

13) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2644: Propel\Runtime\Connection\StatementWrapper->execute()

14) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT `shelter...')

15) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT `shelter...')

16) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `shelter...', Array)

SELECT `service_category`.`service_category_id`, `service_category`.`icon_key`, `service_category`.`visible`, `service_category`.`start_at`, `service_category`.`image_id`, `service_category`.`created_at`, `service_category`.`updated_at`, `service_category`.`sortable_rank`, `service_category`.`id` 
FROM `service_category` 
ORDER BY `service_category`.`sortable_rank` ASC

Time: 0.001 - Memory: 6.00MB - Connection: default - Stacktrace - Explain the query

1) /var/www/teddyfood/web/app_dev.php:31: Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))

4) /var/www/teddyfood/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:153: call_user_func_array(Array, Array)

5) [internal function]: AppBundle\Controller\IndexController->indexAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/IndexController.php:54: AppBundle\Model\OrderQuery->getHistory(1, false)

7) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:45: AppBundle\Model\OrderQuery->buildHistory(Object(Propel\Runtime\Collection\ObjectCollection))

8) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:203: AppBundle\Model\OrderQuery->createDataForHistory(Object(Propel\Runtime\Collection\ObjectCollection))

9) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:226: array_reduce(Array, Object(Closure), Array)

10) [internal function]: AppBundle\Model\OrderQuery->AppBundle\Model\{closure}(Array, Object(AppBundle\Model\OrderItem))

11) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:223: AppBundle\Model\OrderQuery->buildHistoryItem(Object(AppBundle\Model\OrderItem))

12) /var/www/teddyfood/src/AppBundle/Model/OrderQuery.php:285: AppBundle\Model\Service->getRootCatalog()

13) /var/www/teddyfood/src/AppBundle/Model/Service.php:42: AppBundle\Model\Service::getAllServiceCategories()

14) /var/www/teddyfood/src/AppBundle/Model/Service.php:28: Propel\Runtime\ActiveQuery\ModelCriteria->find()

15) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:997: Propel\Runtime\ActiveQuery\ModelCriteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

16) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1988: Propel\Runtime\ActiveQuery\Criteria->doSelect(Object(Propel\Runtime\Connection\DebugPDO))

17) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2644: Propel\Runtime\Connection\StatementWrapper->execute()

18) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('SELECT `service...')

19) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('SELECT `service...')

20) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `service...', Array)

SELECT `service_category_i18n`.`id`, `service_category_i18n`.`locale`, `service_category_i18n`.`title`, `service_category_i18n`.`description` 
FROM `service_category_i18n` 
WHERE locale='en' AND `service_category_i18n`.`id` IN (3,2,11,6,46,38,33,32,31,34,35,36,37,39,40,30,28,12,8,9,10,19,20,22,23,24,25,26,27,42,45,49,44,29,51,52)