Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

30 Database Queries

17 Different statements

22.52 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.93 ms
(13.01%)

SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 INNER JOIN agent_lang ON t0.id = agent_lang.lang_id WHERE agent_lang.agent_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.iso_2 AS iso_2_2,
  t0.iso_3 AS iso_3_3,
  t0.default_lang AS default_lang_4,
  t0.active AS active_5,
  t0.id AS id_6,
  t0.country AS country_7
FROM
  lang t0
  INNER JOIN agent_lang ON t0.id = agent_lang.lang_id
WHERE
  agent_lang.agent_id = ?

SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 INNER JOIN agent_lang ON t0.id = agent_lang.lang_id WHERE agent_lang.agent_id = 2;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 1064)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 986)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3041)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 698)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 213)
7	Doctrine\ORM\PersistentCollection->initialize (line 294)
8	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 30)
9	App\Service\AgentService->getAgentByLangAndCategory (line 65)
10	App\Service\RenderPdfService->render (line 55)
11	App\Service\RenderPdfService->init (line 180)
12	App\Controller\EstateController->renderAction (line 163)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
15	Symfony\Component\HttpKernel\Kernel->handle (line 42)

2.67 ms
(11.85%)

SELECT l0_.id AS id_0, l0_.token AS token_1 FROM lang_token l0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.token AS token_1
FROM
  lang_token l0_

SELECT l0_.id AS id_0, l0_.token AS token_1 FROM lang_token l0_;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 31)
3	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
4	Doctrine\ORM\Query->_doExecute (line 1212)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
6	Doctrine\ORM\AbstractQuery->execute (line 901)
7	Doctrine\ORM\AbstractQuery->getResult (line 94)
8	NexCRM\BaseBundle\Service\Translator->checkToken (line 38)
9	NexCRM\BaseBundle\Service\Translator->trans (line 134)
10	Symfony\Bridge\Twig\Extension\TranslationExtension->trans (line 139)
11	__TwigTemplate_e5b32e7d13ea568ec64ebf1e26680997f2dd44db200deb3f23a484d7e6518a44->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 379)
14	Twig\Template->render (line 40)
15	Twig\TemplateWrapper->render (line 280)
16	Twig\Environment->render (line 70)
17	App\Service\RenderPdfService->render (line 55)
18	App\Service\RenderPdfService->init (line 180)
19	App\Controller\EstateController->renderAction (line 163)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
22	Symfony\Component\HttpKernel\Kernel->handle (line 42)

2.45 ms
(10.90%)

SELECT t0.setting_key AS setting_key_1, t0.id AS id_2 FROM web_setting t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.setting_key AS setting_key_1,
  t0.id AS id_2
FROM
  web_setting t0

SELECT t0.setting_key AS setting_key_1, t0.id AS id_2 FROM web_setting t0;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 916)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
4	Doctrine\ORM\EntityRepository->findBy (line 20)
5	NexCRM\WebBundle\Repository\SettingRepository->findByToArray (line 64)
6	App\Service\RenderPdfService->render (line 55)
7	App\Service\RenderPdfService->init (line 180)
8	App\Controller\EstateController->renderAction (line 163)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
11	Symfony\Component\HttpKernel\Kernel->handle (line 42)

2.23 ms
(9.92%)

SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.iso_2 AS iso_2_2,
  t0.iso_3 AS iso_3_3,
  t0.default_lang AS default_lang_4,
  t0.active AS active_5,
  t0.id AS id_6,
  t0.country AS country_7
FROM
  lang t0
WHERE
  t0.active = ?

SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.active = 1;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 916)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
4	Doctrine\ORM\EntityRepository->findBy (line 36)
5	NexCRM\BaseBundle\EventListener\LocaleListener->onKernelRequest (line 117)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 154)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
12	Symfony\Component\HttpKernel\Kernel->handle (line 42)

1.67 ms
(7.42%)

SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.iso_2 = ? LIMIT 1

Parameters:

[
  "cs"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.iso_2 AS iso_2_2,
  t0.iso_3 AS iso_3_3,
  t0.default_lang AS default_lang_4,
  t0.active AS active_5,
  t0.id AS id_6,
  t0.country AS country_7
FROM
  lang t0
WHERE
  t0.iso_2 = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.iso_2 = 'cs' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 750)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
4	Doctrine\ORM\EntityRepository->findOneBy (line 52)
5	NexCRM\BaseBundle\EventListener\LocaleListener->onKernelRequest (line 117)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 154)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
12	Symfony\Component\HttpKernel\Kernel->handle (line 42)

1.44 ms
(6.40%)

SELECT t0.name AS name_1, t0.position AS position_2, t0.text AS text_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM agent_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.position AS position_2,
  t0.text AS text_3,
  t0.id AS id_4,
  t0.locale AS locale_5,
  t0.translatable_id AS translatable_id_6
FROM
  agent_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.name AS name_1, t0.position AS position_2, t0.text AS text_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM agent_translation t0 WHERE t0.translatable_id = 6;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 1863)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1804)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3037)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 698)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 213)
7	Doctrine\ORM\PersistentCollection->initialize (line 119)
8	Doctrine\Common\Collections\AbstractLazyCollection->get (line 441)
9	Doctrine\ORM\PersistentCollection->get (line 193)
10	App\Entity\Agent->findTranslationByLocale (line 141)
11	App\Entity\Agent->doTranslate (line 75)
12	App\Entity\Agent->translate (line 1635)
13	twig_get_attribute (line 736)
14	__TwigTemplate_e5b32e7d13ea568ec64ebf1e26680997f2dd44db200deb3f23a484d7e6518a44->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 379)
17	Twig\Template->render (line 40)
18	Twig\TemplateWrapper->render (line 280)
19	Twig\Environment->render (line 70)
20	App\Service\RenderPdfService->render (line 55)
21	App\Service\RenderPdfService->init (line 180)
22	App\Controller\EstateController->renderAction (line 163)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
25	Symfony\Component\HttpKernel\Kernel->handle (line 42)

1.39 ms
(6.19%)

SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.api_id AS api_id_3, t0.affiliate_id AS affiliate_id_4, t0.stamp AS stamp_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.price AS price_8, t0.currency AS currency_9, t0.area_floor AS area_floor_10, t0.area_use AS area_use_11, t0.area_of_lot AS area_of_lot_12, t0.area_of_balcony AS area_of_balcony_13, t0.balcony AS balcony_14, t0.area_of_loggia AS area_of_loggia_15, t0.loggia AS loggia_16, t0.area_of_terrace AS area_of_terrace_17, t0.terrace AS terrace_18, t0.elevator AS elevator_19, t0.cellar AS cellar_20, t0.area_of_cellar AS area_of_cellar_21, t0.area_of_garden AS area_of_garden_22, t0.garden AS garden_23, t0.dont_advertise_price AS dont_advertise_price_24, t0.image AS image_25, t0.images AS images_26, t0.region AS region_27, t0.district AS district_28, t0.village AS village_29, t0.part_of_village AS part_of_village_30, t0.psc AS psc_31, t0.catastral_area AS catastral_area_32, t0.type_of_estate AS type_of_estate_33, t0.subtype_of_estate AS subtype_of_estate_34, t0.floor AS floor_35, t0.type_of_ownership AS type_of_ownership_36, t0.parking AS parking_37, t0.disposition AS disposition_38, t0.youtube AS youtube_39, t0.energy_performance_rating AS energy_performance_rating_40, t0.electricity AS electricity_41, t0.electricity_on_lot AS electricity_on_lot_42, t0.internet_connection AS internet_connection_43, t0.structure_of_building AS structure_of_building_44, t0.canalization AS canalization_45, t0.water AS water_46, t0.show_external_url_button AS show_external_url_button_47, t0.show_banner AS show_banner_48, t0.price_type AS price_type_49, t0.id AS id_50, t0.sort AS sort_51, t0.files_order AS files_order_52, t0.media_updated AS media_updated_53, t0.seo_id AS seo_id_54, t0.estate_file_id AS estate_file_id_55, t0.category_id AS category_id_56, t0.file_id AS file_id_57 FROM estate t0 WHERE t0.id = ?

Parameters:

[
  "2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.documents_order AS documents_order_1,
  t0.active AS active_2,
  t0.api_id AS api_id_3,
  t0.affiliate_id AS affiliate_id_4,
  t0.stamp AS stamp_5,
  t0.lat AS lat_6,
  t0.lng AS lng_7,
  t0.price AS price_8,
  t0.currency AS currency_9,
  t0.area_floor AS area_floor_10,
  t0.area_use AS area_use_11,
  t0.area_of_lot AS area_of_lot_12,
  t0.area_of_balcony AS area_of_balcony_13,
  t0.balcony AS balcony_14,
  t0.area_of_loggia AS area_of_loggia_15,
  t0.loggia AS loggia_16,
  t0.area_of_terrace AS area_of_terrace_17,
  t0.terrace AS terrace_18,
  t0.elevator AS elevator_19,
  t0.cellar AS cellar_20,
  t0.area_of_cellar AS area_of_cellar_21,
  t0.area_of_garden AS area_of_garden_22,
  t0.garden AS garden_23,
  t0.dont_advertise_price AS dont_advertise_price_24,
  t0.image AS image_25,
  t0.images AS images_26,
  t0.region AS region_27,
  t0.district AS district_28,
  t0.village AS village_29,
  t0.part_of_village AS part_of_village_30,
  t0.psc AS psc_31,
  t0.catastral_area AS catastral_area_32,
  t0.type_of_estate AS type_of_estate_33,
  t0.subtype_of_estate AS subtype_of_estate_34,
  t0.floor AS floor_35,
  t0.type_of_ownership AS type_of_ownership_36,
  t0.parking AS parking_37,
  t0.disposition AS disposition_38,
  t0.youtube AS youtube_39,
  t0.energy_performance_rating AS energy_performance_rating_40,
  t0.electricity AS electricity_41,
  t0.electricity_on_lot AS electricity_on_lot_42,
  t0.internet_connection AS internet_connection_43,
  t0.structure_of_building AS structure_of_building_44,
  t0.canalization AS canalization_45,
  t0.water AS water_46,
  t0.show_external_url_button AS show_external_url_button_47,
  t0.show_banner AS show_banner_48,
  t0.price_type AS price_type_49,
  t0.id AS id_50,
  t0.sort AS sort_51,
  t0.files_order AS files_order_52,
  t0.media_updated AS media_updated_53,
  t0.seo_id AS seo_id_54,
  t0.estate_file_id AS estate_file_id_55,
  t0.category_id AS category_id_56,
  t0.file_id AS file_id_57
FROM
  estate t0
WHERE
  t0.id = ?

SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.api_id AS api_id_3, t0.affiliate_id AS affiliate_id_4, t0.stamp AS stamp_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.price AS price_8, t0.currency AS currency_9, t0.area_floor AS area_floor_10, t0.area_use AS area_use_11, t0.area_of_lot AS area_of_lot_12, t0.area_of_balcony AS area_of_balcony_13, t0.balcony AS balcony_14, t0.area_of_loggia AS area_of_loggia_15, t0.loggia AS loggia_16, t0.area_of_terrace AS area_of_terrace_17, t0.terrace AS terrace_18, t0.elevator AS elevator_19, t0.cellar AS cellar_20, t0.area_of_cellar AS area_of_cellar_21, t0.area_of_garden AS area_of_garden_22, t0.garden AS garden_23, t0.dont_advertise_price AS dont_advertise_price_24, t0.image AS image_25, t0.images AS images_26, t0.region AS region_27, t0.district AS district_28, t0.village AS village_29, t0.part_of_village AS part_of_village_30, t0.psc AS psc_31, t0.catastral_area AS catastral_area_32, t0.type_of_estate AS type_of_estate_33, t0.subtype_of_estate AS subtype_of_estate_34, t0.floor AS floor_35, t0.type_of_ownership AS type_of_ownership_36, t0.parking AS parking_37, t0.disposition AS disposition_38, t0.youtube AS youtube_39, t0.energy_performance_rating AS energy_performance_rating_40, t0.electricity AS electricity_41, t0.electricity_on_lot AS electricity_on_lot_42, t0.internet_connection AS internet_connection_43, t0.structure_of_building AS structure_of_building_44, t0.canalization AS canalization_45, t0.water AS water_46, t0.show_external_url_button AS show_external_url_button_47, t0.show_banner AS show_banner_48, t0.price_type AS price_type_49, t0.id AS id_50, t0.sort AS sort_51, t0.files_order AS files_order_52, t0.media_updated AS media_updated_53, t0.seo_id AS seo_id_54, t0.estate_file_id AS estate_file_id_55, t0.category_id AS category_id_56, t0.file_id AS file_id_57 FROM estate t0 WHERE t0.id = '2';

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 750)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 768)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
5	Doctrine\ORM\EntityManager->find (line 197)
6	Doctrine\ORM\EntityRepository->find (line 54)
7	App\Service\RenderPdfService->init (line 180)
8	App\Controller\EstateController->renderAction (line 163)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
11	Symfony\Component\HttpKernel\Kernel->handle (line 42)

1.21 ms
(5.35%)

SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.default_lang = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.iso_2 AS iso_2_2,
  t0.iso_3 AS iso_3_3,
  t0.default_lang AS default_lang_4,
  t0.active AS active_5,
  t0.id AS id_6,
  t0.country AS country_7
FROM
  lang t0
WHERE
  t0.default_lang = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.default_lang = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 750)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
4	Doctrine\ORM\EntityRepository->findOneBy (line 38)
5	NexCRM\BaseBundle\EventListener\LocaleListener->onKernelRequest (line 117)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 154)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
12	Symfony\Component\HttpKernel\Kernel->handle (line 42)

1.11 ms
(4.93%)

SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.id AS id_3, t0.sort AS sort_4, t0.files_order AS files_order_5, t0.media_updated AS media_updated_6, t0.seo_id AS seo_id_7, t0.category_file_id AS category_file_id_8, t0.file_id AS file_id_9 FROM category t0 INNER JOIN agent_category ON t0.id = agent_category.category_id WHERE agent_category.agent_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.documents_order AS documents_order_1,
  t0.active AS active_2,
  t0.id AS id_3,
  t0.sort AS sort_4,
  t0.files_order AS files_order_5,
  t0.media_updated AS media_updated_6,
  t0.seo_id AS seo_id_7,
  t0.category_file_id AS category_file_id_8,
  t0.file_id AS file_id_9
FROM
  category t0
  INNER JOIN agent_category ON t0.id = agent_category.category_id
WHERE
  agent_category.agent_id = ?

SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.id AS id_3, t0.sort AS sort_4, t0.files_order AS files_order_5, t0.media_updated AS media_updated_6, t0.seo_id AS seo_id_7, t0.category_file_id AS category_file_id_8, t0.file_id AS file_id_9 FROM category t0 INNER JOIN agent_category ON t0.id = agent_category.category_id WHERE agent_category.agent_id = 2;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 1064)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 986)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3041)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 698)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 213)
7	Doctrine\ORM\PersistentCollection->initialize (line 294)
8	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 34)
9	App\Service\AgentService->getAgentByLangAndCategory (line 65)
10	App\Service\RenderPdfService->render (line 55)
11	App\Service\RenderPdfService->init (line 180)
12	App\Controller\EstateController->renderAction (line 163)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
15	Symfony\Component\HttpKernel\Kernel->handle (line 42)

1.02 ms
(4.54%)

SELECT t0.alias AS alias_1, t0.value AS value_2, t0.id AS id_3 FROM setting t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.alias AS alias_1,
  t0.value AS value_2,
  t0.id AS id_3
FROM
  setting t0

SELECT t0.alias AS alias_1, t0.value AS value_2, t0.id AS id_3 FROM setting t0;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 916)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
4	Doctrine\ORM\EntityRepository->findBy (line 207)
5	Doctrine\ORM\EntityRepository->findAll (line 17)
6	NexCRM\BaseBundle\Repository\SettingRepository->findByToArray (line 61)
7	App\Service\RenderPdfService->render (line 55)
8	App\Service\RenderPdfService->init (line 180)
9	App\Controller\EstateController->renderAction (line 163)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
12	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.84 ms
(3.74%)

SELECT t0.name AS name_1, t0.seo AS seo_2, t0.alt AS alt_3, t0.media AS media_4, t0.updated_at AS updated_at_5, t0.file_size AS file_size_6, t0.ext AS ext_7, t0.preview AS preview_8, t0.deleted AS deleted_9, t0.deleted_at AS deleted_at_10, t0.id AS id_11, t0.folder_id AS folder_id_12 FROM media_file t0 WHERE t0.id = ?

Parameters:

[
  180
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.seo AS seo_2,
  t0.alt AS alt_3,
  t0.media AS media_4,
  t0.updated_at AS updated_at_5,
  t0.file_size AS file_size_6,
  t0.ext AS ext_7,
  t0.preview AS preview_8,
  t0.deleted AS deleted_9,
  t0.deleted_at AS deleted_at_10,
  t0.id AS id_11,
  t0.folder_id AS folder_id_12
FROM
  media_file t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.seo AS seo_2, t0.alt AS alt_3, t0.media AS media_4, t0.updated_at AS updated_at_5, t0.file_size AS file_size_6, t0.ext AS ext_7, t0.preview AS preview_8, t0.deleted AS deleted_9, t0.deleted_at AS deleted_at_10, t0.id AS id_11, t0.folder_id AS folder_id_12 FROM media_file t0 WHERE t0.id = 180;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 750)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 768)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 207)
5	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 373)
6	Closure->__invoke (line 373)
7	Proxies\__CG__\NexCRM\BaseBundle\Entity\MediaFile->directoryName (line 1635)
8	twig_get_attribute (line 724)
9	__TwigTemplate_e5b32e7d13ea568ec64ebf1e26680997f2dd44db200deb3f23a484d7e6518a44->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 379)
12	Twig\Template->render (line 40)
13	Twig\TemplateWrapper->render (line 280)
14	Twig\Environment->render (line 70)
15	App\Service\RenderPdfService->render (line 55)
16	App\Service\RenderPdfService->init (line 180)
17	App\Controller\EstateController->renderAction (line 163)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
20	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.78 ms
(3.47%)

SELECT t0.email AS email_1, t0.phone AS phone_2, t0.documents_order AS documents_order_3, t0.active AS active_4, t0.id AS id_5, t0.sort AS sort_6, t0.files_order AS files_order_7, t0.media_updated AS media_updated_8, t0.seo_id AS seo_id_9, t0.agent_file_id AS agent_file_id_10, t0.file_id AS file_id_11 FROM agent t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.email AS email_1,
  t0.phone AS phone_2,
  t0.documents_order AS documents_order_3,
  t0.active AS active_4,
  t0.id AS id_5,
  t0.sort AS sort_6,
  t0.files_order AS files_order_7,
  t0.media_updated AS media_updated_8,
  t0.seo_id AS seo_id_9,
  t0.agent_file_id AS agent_file_id_10,
  t0.file_id AS file_id_11
FROM
  agent t0

SELECT t0.email AS email_1, t0.phone AS phone_2, t0.documents_order AS documents_order_3, t0.active AS active_4, t0.id AS id_5, t0.sort AS sort_6, t0.files_order AS files_order_7, t0.media_updated AS media_updated_8, t0.seo_id AS seo_id_9, t0.agent_file_id AS agent_file_id_10, t0.file_id AS file_id_11 FROM agent t0;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 916)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
4	Doctrine\ORM\EntityRepository->findBy (line 207)
5	Doctrine\ORM\EntityRepository->findAll (line 62)
6	App\Service\RenderPdfService->render (line 55)
7	App\Service\RenderPdfService->init (line 180)
8	App\Controller\EstateController->renderAction (line 163)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
11	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.71 ms
(3.16%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.lft AS lft_3, t0.rgt AS rgt_4, t0.lvl AS lvl_5, t0.root AS root_6, t0.deleted AS deleted_7, t0.deleted_at AS deleted_at_8, t0.parent_id AS parent_id_9 FROM folder t0 WHERE t0.id = ?

Parameters:

[
  17
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lft AS lft_3,
  t0.rgt AS rgt_4,
  t0.lvl AS lvl_5,
  t0.root AS root_6,
  t0.deleted AS deleted_7,
  t0.deleted_at AS deleted_at_8,
  t0.parent_id AS parent_id_9
FROM
  folder t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.lft AS lft_3, t0.rgt AS rgt_4, t0.lvl AS lvl_5, t0.root AS root_6, t0.deleted AS deleted_7, t0.deleted_at AS deleted_at_8, t0.parent_id AS parent_id_9 FROM folder t0 WHERE t0.id = 17;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 750)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 768)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 207)
5	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 256)
6	Closure->__invoke (line 256)
7	Proxies\__CG__\NexCRM\BaseBundle\Entity\Folder->getName (line 276)
8	NexCRM\BaseBundle\Entity\MediaFile->directoryName (line 375)
9	Proxies\__CG__\NexCRM\BaseBundle\Entity\MediaFile->directoryName (line 1635)
10	twig_get_attribute (line 724)
11	__TwigTemplate_e5b32e7d13ea568ec64ebf1e26680997f2dd44db200deb3f23a484d7e6518a44->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 379)
14	Twig\Template->render (line 40)
15	Twig\TemplateWrapper->render (line 280)
16	Twig\Environment->render (line 70)
17	App\Service\RenderPdfService->render (line 55)
18	App\Service\RenderPdfService->init (line 180)
19	App\Controller\EstateController->renderAction (line 163)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
22	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.68 ms
(3.02%)

SELECT t0.name AS name_1, t0.description AS description_2, t0.longDescription AS longDescription_3, t0.price_comment AS price_comment_4, t0.agent_id AS agent_id_5, t0.external_url AS external_url_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM estate_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.longDescription AS longDescription_3,
  t0.price_comment AS price_comment_4,
  t0.agent_id AS agent_id_5,
  t0.external_url AS external_url_6,
  t0.id AS id_7,
  t0.locale AS locale_8,
  t0.translatable_id AS translatable_id_9
FROM
  estate_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.longDescription AS longDescription_3, t0.price_comment AS price_comment_4, t0.agent_id AS agent_id_5, t0.external_url AS external_url_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM estate_translation t0 WHERE t0.translatable_id = 2;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 1863)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1804)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3037)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 698)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 213)
7	Doctrine\ORM\PersistentCollection->initialize (line 119)
8	Doctrine\Common\Collections\AbstractLazyCollection->get (line 441)
9	Doctrine\ORM\PersistentCollection->get (line 193)
10	App\Entity\Estate->findTranslationByLocale (line 141)
11	App\Entity\Estate->doTranslate (line 75)
12	App\Entity\Estate->translate (line 44)
13	App\Service\AgentService->getAgentByLangAndCategory (line 65)
14	App\Service\RenderPdfService->render (line 55)
15	App\Service\RenderPdfService->init (line 180)
16	App\Controller\EstateController->renderAction (line 163)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
19	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.63 ms
(2.81%)

SELECT t0.trans_value AS trans_value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM setting_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  15
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.trans_value AS trans_value_1,
  t0.id AS id_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  setting_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.trans_value AS trans_value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM setting_translation t0 WHERE t0.translatable_id = 15;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 1863)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1804)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3037)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 698)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 213)
7	Doctrine\ORM\PersistentCollection->initialize (line 119)
8	Doctrine\Common\Collections\AbstractLazyCollection->get (line 441)
9	Doctrine\ORM\PersistentCollection->get (line 193)
10	NexCRM\BaseBundle\Entity\Setting->findTranslationByLocale (line 141)
11	NexCRM\BaseBundle\Entity\Setting->doTranslate (line 75)
12	NexCRM\BaseBundle\Entity\Setting->translate (line 1635)
13	twig_get_attribute (line 63)
14	__TwigTemplate_01809b37009fb35939f8c169a610898d5b82121526c99859f32646b8d5f73569->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 379)
17	Twig\Template->render (line 40)
18	Twig\TemplateWrapper->render (line 280)
19	Twig\Environment->render (line 74)
20	App\Service\RenderPdfService->render (line 55)
21	App\Service\RenderPdfService->init (line 180)
22	App\Controller\EstateController->renderAction (line 163)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
25	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.50 ms
(2.23%)

SELECT l0_.iso_2 AS iso_2_0 FROM lang l0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.iso_2 AS iso_2_0
FROM
  lang l0_

SELECT l0_.iso_2 AS iso_2_0 FROM lang l0_;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 31)
3	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
4	Doctrine\ORM\Query->_doExecute (line 1212)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
6	Doctrine\ORM\AbstractQuery->execute (line 901)
7	Doctrine\ORM\AbstractQuery->getResult (line 47)
8	App\Service\DefaultLangService->getLang (line 64)
9	App\EventListener\LocaleListener->onKernelRequest (line 117)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 154)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
16	Symfony\Component\HttpKernel\Kernel->handle (line 42)

0.24 ms
(1.06%)

SELECT t0.alias AS alias_1, t0.value AS value_2, t0.id AS id_3 FROM setting t0 WHERE t0.alias = ? LIMIT 1

Parameters:

[
  "default_thumbnail_size"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.alias AS alias_1,
  t0.value AS value_2,
  t0.id AS id_3
FROM
  setting t0
WHERE
  t0.alias = ?
LIMIT
  1

SELECT t0.alias AS alias_1, t0.value AS value_2, t0.id AS id_3 FROM setting t0 WHERE t0.alias = 'default_thumbnail_size' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1294)
2	Doctrine\DBAL\Connection->executeQuery (line 750)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
4	Doctrine\ORM\EntityRepository->findOneBy (line 76)
5	NexCRM\BaseBundle\Service\ImagineExtension->initMaxSize (line 50)
6	NexCRM\BaseBundle\Service\ImagineExtension->filter (line 724)
7	__TwigTemplate_e5b32e7d13ea568ec64ebf1e26680997f2dd44db200deb3f23a484d7e6518a44->doDisplay (line 394)
8	Twig\Template->displayWithErrorHandling (line 367)
9	Twig\Template->display (line 379)
10	Twig\Template->render (line 40)
11	Twig\TemplateWrapper->render (line 280)
12	Twig\Environment->render (line 70)
13	App\Service\RenderPdfService->render (line 55)
14	App\Service\RenderPdfService->init (line 180)
15	App\Controller\EstateController->renderAction (line 163)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
18	Symfony\Component\HttpKernel\Kernel->handle (line 42)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
NexCRM\BaseBundle\Entity\Lang	No errors.
NexCRM\BaseBundle\Entity\Setting	No errors.
NexCRM\BaseBundle\Entity\Country	No errors.
App\Entity\Estate	No errors.
NexCRM\WebBundle\Entity\SEO	No errors.
NexCRM\BaseBundle\Entity\MediaFile	No errors.
App\Entity\Category	No errors.
App\Entity\Tag	No errors.
App\Entity\EstateTranslation	No errors.
NexCRM\BaseBundle\Entity\SettingTranslation	No errors.
App\Entity\Agent	No errors.
App\Entity\AgentTranslation	No errors.
NexCRM\WebBundle\Entity\Setting	No errors.
App\Entity\CategoryTranslation	No errors.
NexCRM\BaseBundle\Entity\LangToken	No errors.
NexCRM\BaseBundle\Entity\Folder	No errors.
NexCRM\BaseBundle\Entity\MediaFileTranslation	No errors.

Symfony Profiler

http://dev80.nexgen.cz/pdf-estate/render/cs/2

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping