Symfony Profiler

Queries

SQL queries

SELECT `subscription_report`.`yyyymm`, `subscription_report`.`visible`, `subscription_report`.`gallery_id`, `subscription_report`.`created_at`, `subscription_report`.`updated_at`, `subscription_report`.`id` 
FROM `subscription_report` 
WHERE `subscription_report`.`visible`=1 
GROUP BY `subscription_report`.`yyyymm` 
ORDER BY `subscription_report`.`yyyymm` DESC

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

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

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

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

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

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

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

7) /var/www/teddyfood/src/AppBundle/Service/SubscriptionReportService.php:29: AppBundle\Service\SubscriptionReportService->getMonths()

8) /var/www/teddyfood/src/AppBundle/Service/SubscriptionReportService.php:46: 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 `subscri...')

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

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

SELECT COUNT(*) 
FROM `subscription_report` 
WHERE `subscription_report`.`visible`=1 AND `subscription_report`.`yyyymm`='2024-10'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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