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

Method
GET
HTTP Status
500
IP
47.128.127.14
Profiled on
Sun, 20 Apr 2025 20:21:55 +0000
Token
8205dd

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))
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: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))
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: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))
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: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))
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: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))
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: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))
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: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))
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: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))
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: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))
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: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))
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: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))
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: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))
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: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)
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))
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: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))
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: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))
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: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))
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: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))
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: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))
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: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))
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: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))
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: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))
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: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 :