Symfony Profiler

Queries

SQL queries

SELECT `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` 
FROM `customer` 
WHERE `customer`.`secret`='1446274484680557639ee3e1.68331357mLa53IuQNt1yokEQZrT7APPCfiKp7Ck' 
ORDER BY `customer`.`id` DESC,`customer`.`updated_at` DESC 
LIMIT 1

Time: 0.003 - 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\AnimalsController->viewAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/AnimalsController.php:91: AppBundle\Service\CartService->getPurchasedItems()

7) /var/www/teddyfood/src/AppBundle/Service/CartService.php:46: AppBundle\Service\CartService->getItems()

8) /var/www/teddyfood/src/AppBundle/Service/CartService.php:115: AppBundle\Service\CartService->getCustomer()

9) /var/www/teddyfood/src/AppBundle/Service/CartService.php:83: Propel\Runtime\ActiveQuery\ModelCriteria->findOne()

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1024: 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 `custome...')

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

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

INSERT INTO `customer` (`secret`, `locale`, `created_at`, `updated_at`, `id`) 
VALUES ('1446274484680557639ee3e1.68331357mLa53IuQNt1yokEQZrT7APPCfiKp7Ck', 'en', '2025-04-20 20:21:55.656129', '2025-04-20 20:21:55.656173', NULL)

Time: 0 - 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\AnimalsController->viewAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/AnimalsController.php:91: AppBundle\Service\CartService->getPurchasedItems()

7) /var/www/teddyfood/src/AppBundle/Service/CartService.php:46: AppBundle\Service\CartService->getItems()

8) /var/www/teddyfood/src/AppBundle/Service/CartService.php:115: AppBundle\Service\CartService->getCustomer()

9) /var/www/teddyfood/src/AppBundle/Service/CartService.php:106: AppBundle\Model\Base\Customer->save()

10) /var/www/teddyfood/src/AppBundle/Model/Base/Customer.php:1002: Propel\Runtime\Connection\ConnectionWrapper->transaction(Object(Closure))

11) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/TransactionTrait.php:35: call_user_func(Object(Closure))

12) [internal function]: AppBundle\Model\Base\Customer->AppBundle\Model\Base\{closure}()

13) /var/www/teddyfood/src/AppBundle/Model/Base/Customer.php:989: AppBundle\Model\Base\Customer->doSave(Object(Propel\Runtime\Connection\DebugPDO))

14) /var/www/teddyfood/src/AppBundle/Model/Base/Customer.php:1037: AppBundle\Model\Base\Customer->doInsert(Object(Propel\Runtime\Connection\DebugPDO))

15) /var/www/teddyfood/src/AppBundle/Model/Base/Customer.php:1225: Propel\Runtime\Connection\StatementWrapper->execute()

16) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:197: Propel\Runtime\Connection\ConnectionWrapper->log('INSERT INTO `cu...')

17) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/Connection/ConnectionWrapper.php:651: Propel\Bundle\PropelBundle\Logger\PropelLogger->info('INSERT INTO `cu...')

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

SELECT `cart`.`customer_id`, `cart`.`animal_id`, `cart`.`crowdfunding_id`, `cart`.`is_non_tf`, `cart`.`is_success`, `cart`.`created_at`, `cart`.`updated_at`, `cart`.`id` 
FROM `cart` 
WHERE `cart`.`customer_id`=6115288 AND `cart`.`is_non_tf`=0 AND `cart`.`is_success`=0

Time: 0 - 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\AnimalsController->viewAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/AnimalsController.php:91: AppBundle\Service\CartService->getPurchasedItems()

7) /var/www/teddyfood/src/AppBundle/Service/CartService.php:46: AppBundle\Service\CartService->getItems()

8) /var/www/teddyfood/src/AppBundle/Service/CartService.php:118: 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 `cart`.`...')

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

14) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `cart`.`...', 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`, `shelter`.`country_id`, `shelter`.`city_id`, `shelter`.`phone`, `shelter`.`contact_phone`, `shelter`.`visible`, `shelter`.`created_at`, `shelter`.`updated_at`, `shelter`.`id`, `image`.`file_id`, `image`.`id`, `file`.`path`, `file`.`name`, `file`.`original_name`, `file`.`extension`, `file`.`mime`, `file`.`size`, `file`.`id`, `curator`.`background_image_id`, `curator`.`icon_image_id`, `curator`.`created_at`, `curator`.`updated_at`, `curator`.`id`, `CuratorImageRelatedByBackgroundImageId`.`file_id`, `CuratorImageRelatedByBackgroundImageId`.`id`, `ImageRelatedByBackgroundImageIdFile`.`path`, `ImageRelatedByBackgroundImageIdFile`.`name`, `ImageRelatedByBackgroundImageIdFile`.`original_name`, `ImageRelatedByBackgroundImageIdFile`.`extension`, `ImageRelatedByBackgroundImageIdFile`.`mime`, `ImageRelatedByBackgroundImageIdFile`.`size`, `ImageRelatedByBackgroundImageIdFile`.`id` 
FROM `animal` 
LEFT JOIN `shelter` ON (`animal`.`shelter_id`=`shelter`.`id`) 
LEFT JOIN `image` ON (`animal`.`image_id`=`image`.`id`) 
LEFT JOIN `file` ON (`image`.`file_id`=`file`.`id`) 
LEFT JOIN `curator` ON (`animal`.`curator_id`=`curator`.`id`) 
LEFT JOIN `image` `CuratorImageRelatedByBackgroundImageId` ON (`curator`.`background_image_id`=`CuratorImageRelatedByBackgroundImageId`.`id`) 
LEFT JOIN `file` `ImageRelatedByBackgroundImageIdFile` ON (`CuratorImageRelatedByBackgroundImageId`.`file_id`=`ImageRelatedByBackgroundImageIdFile`.`id`) 
WHERE `animal`.`uri`='fifa' 
LIMIT 1

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\AnimalsController->viewAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/AnimalsController.php:114: Propel\Runtime\ActiveQuery\ModelCriteria->__call('findOneByUri', Array)

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

8) [internal function]: Propel\Runtime\ActiveQuery\ModelCriteria->findOneBy('Uri', 'fifa')

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

10) /var/www/teddyfood/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1024: 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 `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` 
LEFT JOIN `animal_i18n` ON (`animal`.`id`=`animal_i18n`.`id` AND `animal_i18n`.`locale` = 'en') 
WHERE `animal`.`id`<>2 AND `animal`.`visible`=1 AND `animal_i18n`.`description`<>'' 
ORDER BY RAND() DESC 
LIMIT 6

Time: 0.004 - 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\AnimalsController->viewAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/AnimalsController.php:117: AppBundle\Model\Animal::findForAnimalPage(2)

7) /var/www/teddyfood/src/AppBundle/Model/Animal.php:364: 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 `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 (90,95,261,94,93,251)

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\AnimalsController->viewAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/AnimalsController.php:117: AppBundle\Model\Animal::findForAnimalPage(2)

7) /var/www/teddyfood/src/AppBundle/Model/Animal.php:366: 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`.`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,8,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\AnimalsController->viewAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/AnimalsController.php:117: AppBundle\Model\Animal::findForAnimalPage(2)

7) /var/www/teddyfood/src/AppBundle/Model/Animal.php:367: 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,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\AnimalsController->viewAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/AnimalsController.php:117: AppBundle\Model\Animal::findForAnimalPage(2)

7) /var/www/teddyfood/src/AppBundle/Model/Animal.php:368: 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 (10,13)

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\AnimalsController->viewAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/AnimalsController.php:117: AppBundle\Model\Animal::findForAnimalPage(2)

7) /var/www/teddyfood/src/AppBundle/Model/Animal.php:369: 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 `animal_breed`.`animal_kind_id`, `animal_breed`.`created_at`, `animal_breed`.`updated_at`, `animal_breed`.`id` 
FROM `animal_breed` 
LEFT JOIN `animal` ON (`animal_breed`.`id`=`animal`.`animal_breed_id`) 
WHERE `animal`.`id` IN (90,95,261,94,93,251)

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\AnimalsController->viewAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/AnimalsController.php:117: AppBundle\Model\Animal::findForAnimalPage(2)

7) /var/www/teddyfood/src/AppBundle/Model/Animal.php:371: AppBundle\Model\QueryHelper::populateRelation(Object(Propel\Runtime\Collection\ObjectCollection), 'AnimalBreed')

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

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 `image`.`file_id`, `image`.`id` 
FROM `image` 
LEFT JOIN `animal` ON (`image`.`id`=`animal`.`image_id`) 
WHERE `animal`.`id` IN (90,95,261,94,93,251)

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\AnimalsController->viewAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/AnimalsController.php:117: AppBundle\Model\Animal::findForAnimalPage(2)

7) /var/www/teddyfood/src/AppBundle/Model/Animal.php:372: AppBundle\Model\QueryHelper::populateRelation(Object(Propel\Runtime\Collection\ObjectCollection), 'Image')

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

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 `image`....')

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

15) /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 (825,860,7434,9426,9417,2641)

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\AnimalsController->viewAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/AnimalsController.php:117: AppBundle\Model\Animal::findForAnimalPage(2)

7) /var/www/teddyfood/src/AppBundle/Model/Animal.php:373: AppBundle\Model\QueryHelper::populateRelation(Object(Propel\Runtime\Collection\ObjectCollection), 'File')

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

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 `file`.`...')

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

15) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `file`.`...', 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: 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\AnimalsController->viewAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/AnimalsController.php:117: AppBundle\Model\Animal::findForAnimalPage(2)

7) /var/www/teddyfood/src/AppBundle/Model/Animal.php:383: 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 (90,95,261,94,93,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)

Explanation

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	animal_service_scheduler_rel	range	fi_animal_service_scheduler_rel_animal_id_animal,fi_animal_service_scheduler_rel_service_id_service	fi_animal_service_scheduler_rel_animal_id_animal	4		74	Using index condition; Using where
1	SIMPLE	service	eq_ref	PRIMARY,fi_service_service_category_id_service_category	PRIMARY	4	teddyfood.animal_service_scheduler_rel.service_id	1	Using where

Time: 0.001 - Memory: 6.00MB - Connection: default - Stacktrace

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\AnimalsController->viewAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/AnimalsController.php:117: AppBundle\Model\Animal::findForAnimalPage(2)

7) /var/www/teddyfood/src/AppBundle/Model/Animal.php:385: 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 (90,95,261,94,93,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: 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\AnimalsController->viewAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/AnimalsController.php:117: AppBundle\Model\Animal::findForAnimalPage(2)

7) /var/www/teddyfood/src/AppBundle/Model/Animal.php:392: 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 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`=1 AND `crowdfunding`.`service_id` = `shelter_service_scheduler_rel`.`service_id` AND `crowdfunding`.`visible`=1 AND (`crowdfunding`.`animal_kind_id` = 2 OR `crowdfunding`.`animal_kind_id` is null)

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\AnimalsController->viewAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/AnimalsController.php:119: AppBundle\Model\Animal->getTopServices()

7) /var/www/teddyfood/src/AppBundle/Model/Animal.php:167: 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 DISTINCT...')

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

13) /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`=2 AND `animal_service_scheduler_rel`.`urgent`=1 AND `animal_service_scheduler_rel`.`active`=1

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\AnimalsController->viewAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/AnimalsController.php:119: AppBundle\Model\Animal->getTopServices()

7) /var/www/teddyfood/src/AppBundle/Model/Animal.php:178: 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 `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` 
WHERE 1<>1

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\AnimalsController->viewAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/AnimalsController.php:124: AppBundle\Service\CrowdfundingService->getOrderedTopServices(Array)

7) /var/www/teddyfood/src/AppBundle/Service/CrowdfundingService.php:118: AppBundle\Model\Base\ServiceQuery->findPks(Array)

8) /var/www/teddyfood/src/AppBundle/Model/Base/ServiceQuery.php:324: 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 `service...')

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

13) /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` 
ORDER BY `service_category`.`sortable_rank` ASC

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\AnimalsController->viewAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/AnimalsController.php:126: AppBundle\Model\ServiceQuery::getServicesForAnimal(Object(AppBundle\Model\Animal))

7) /var/www/teddyfood/src/AppBundle/Model/ServiceQuery.php:85: AppBundle\Model\Service::getAllServiceCategories()

8) /var/www/teddyfood/src/AppBundle/Model/Service.php:28: 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 `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 `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)

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\AnimalsController->viewAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/AnimalsController.php:126: AppBundle\Model\ServiceQuery::getServicesForAnimal(Object(AppBundle\Model\Animal))

7) /var/www/teddyfood/src/AppBundle/Model/ServiceQuery.php:85: AppBundle\Model\Service::getAllServiceCategories()

8) /var/www/teddyfood/src/AppBundle/Model/Service.php:29: 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 `crowdfunding`.`animal_id`, `crowdfunding`.`shelter_id`, `crowdfunding`.`service_id`, `crowdfunding`.`report_id`, `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`=1 AND `crowdfunding`.`animal_id` IS NULL  AND `crowdfunding`.`completed`=0 AND `crowdfunding`.`visible`=1 AND `crowdfunding`.`started_at`<='2025-04-20 20:21:55.706401' AND (`crowdfunding`.`animal_kind_id` = 2 OR `crowdfunding`.`animal_kind_id` is null)

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\AnimalsController->viewAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/AnimalsController.php:126: AppBundle\Model\ServiceQuery::getServicesForAnimal(Object(AppBundle\Model\Animal))

7) /var/www/teddyfood/src/AppBundle/Model/ServiceQuery.php:96: 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 `crowdfu...')

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

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

SELECT DISTINCT `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`) 
LEFT JOIN `service_category` ON (`service`.`service_category_id`=`service_category`.`id`) 
LEFT JOIN `shelter_service_scheduler_rel` ON (`service`.`id`=`shelter_service_scheduler_rel`.`service_id`) 
WHERE `animal_service_scheduler_rel`.`visible`=1 AND `animal`.`id`=2 AND `shelter_service_scheduler_rel`.`shelter_id` = `animal`.`shelter_id` AND (`animal_service_scheduler_rel`.`additional_price` > 0 OR (`shelter_service_scheduler_rel`.`price` > 0 OR `shelter_service_scheduler_rel`.`price_tf` > 0)) 
ORDER BY `service`.`sortable_rank` ASC

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\AnimalsController->viewAction(Object(Symfony\Component\HttpFoundation\Request))

6) /var/www/teddyfood/src/AppBundle/Controller/AnimalsController.php:126: AppBundle\Model\ServiceQuery::getServicesForAnimal(Object(AppBundle\Model\Animal))

7) /var/www/teddyfood/src/AppBundle/Model/ServiceQuery.php:153: 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 DISTINCT...')

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

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

Propel configuration

Propel version	2.0.0-dev
Default connection	default
Logging	enabled

Propel connections

Connection name	Configuration parameters
default	Adapter	mysql
	DSN	mysql:host=127.0.0.1;dbname=teddyfood;charset=UTF8
	Class	\Propel\Runtime\Connection\DebugPDO
	Options	ATTR_PERSISTENT :
	Attributes	ATTR_EMULATE_PREPARES :

Symfony Profiler

http://211511.simplecloud.ru/en/animals/fifa/

Queries

Explanation

Propel configuration

Propel connections