Symfony Profiler

Queries

SQL queries

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

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

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

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

6) /var/www/teddyfood/src/AppBundle/Controller/AnimalsController.php:33: AppBundle\Service\AnimalService->getPetOfDay(0)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

6) /var/www/teddyfood/src/AppBundle/Controller/AnimalsController.php:33: AppBundle\Service\AnimalService->getPetOfDay(0)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT `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`='18465427626941061801b803.12998476gcwp01DO1nrzrUAlAjJc7jiCEmOJzWm' 
ORDER BY `customer`.`id` DESC,`customer`.`updated_at` DESC 
LIMIT 1

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

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

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

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

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

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

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

9) /var/www/teddyfood/src/AppBundle/Service/CartService.php:94: 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`, `created_at`, `updated_at`, `id`) 
VALUES ('18465427626941061801b803.12998476gcwp01DO1nrzrUAlAjJc7jiCEmOJzWm', '2025-12-16 07:11:20.009864', '2025-12-16 07:11:20.009901', NULL)

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

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

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

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

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

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

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

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

10) /var/www/teddyfood/src/AppBundle/Model/Base/Customer.php:1036: 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:1023: AppBundle\Model\Base\Customer->doSave(Object(Propel\Runtime\Connection\DebugPDO))

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

15) /var/www/teddyfood/src/AppBundle/Model/Base/Customer.php:1293: 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`=7564885 AND `cart`.`is_non_tf`=0 AND `cart`.`is_success`=0

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

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

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

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

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

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

8) /var/www/teddyfood/src/AppBundle/Service/CartService.php:146: 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 `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 `shelter_i18n` ON (`shelter`.`id`=`shelter_i18n`.`id` AND `shelter_i18n`.`locale` = 'ru') 
WHERE `shelter`.`visible`=1 AND `shelter`.`country_id`=1 AND `shelter_i18n`.`title_short`<>'' 
ORDER BY `shelter_i18n`.`title_short` ASC

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

6) /var/www/teddyfood/src/AppBundle/Controller/AnimalsController.php:57: AppBundle\Service\AnimalService->getSheltersList(Object(Symfony\Component\HttpFoundation\Request))

7) /var/www/teddyfood/src/AppBundle/Service/AnimalService.php:270: AppBundle\Model\Base\ShelterQuery->findByTitleShort('', '<>')

8) /var/www/teddyfood/src/AppBundle/Model/Base/ShelterQuery.php:1380: 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 `shelter...')

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

14) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `shelter...', 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 `shelter_i18n`.`id`=25 AND `shelter_i18n`.`locale`='ru' 
LIMIT 1

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

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

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

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

6) /var/www/teddyfood/src/AppBundle/Controller/AnimalsController.php:57: AppBundle\Service\AnimalService->getSheltersList(Object(Symfony\Component\HttpFoundation\Request))

7) /var/www/teddyfood/src/AppBundle/Service/AnimalService.php:274: AppBundle\Model\Base\Shelter->getTitleShort('ru')

8) /var/www/teddyfood/src/AppBundle/Model/Base/Shelter.php:3573: AppBundle\Model\Base\Shelter->AppBundle\Model\Base\{closure}('ru')

9) /var/www/teddyfood/src/AppBundle/Model/Base/Shelter.php:3547: AppBundle\Model\Base\Shelter->getTranslation('ru')

10) /var/www/teddyfood/src/AppBundle/Model/Base/Shelter.php:3395: Propel\Runtime\ActiveQuery\ModelCriteria->findOneOrCreate(NULL)

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

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

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

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

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

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

17) /var/www/teddyfood/vendor/psr/log/Psr/Log/LoggerTrait.php:114: Propel\Bundle\PropelBundle\Logger\PropelLogger->log('info', 'SELECT `shelter...', 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 `shelter_i18n`.`id`=24 AND `shelter_i18n`.`locale`='ru' 
LIMIT 1