Symfony Profiler

Query Metrics

16 Database Queries

9 Different statements

4.49 ms Query time

5 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

1.75 ms
(39.11%)

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.api_identifier AS api_identifier_3, t0.name AS name_4, t0.group_name AS group_name_5, t0.brand_name AS brand_name_6, t0.owner_name AS owner_name_7, t0.pms_name AS pms_name_8, t0.pms_version AS pms_version_9, t0.enabled AS enabled_10, t0.standard AS standard_11, t0.rooms AS rooms_12, t0.coordinates AS coordinates_13, t0.inactive_rooms AS inactive_rooms_14, t0.object_type AS object_type_15, t0.checked AS checked_16, t0.approved_by_klips AS approved_by_klips_17, t0.address_manual_content AS address_manual_content_18, t0.klips_access_to_view AS klips_access_to_view_19, t0.reports_currency AS reports_currency_20, t0.convert_ratio_eur AS convert_ratio_eur_21, t0.convert_ratio_usd AS convert_ratio_usd_22, t0.blocked_status AS blocked_status_23, t0.account_type AS account_type_24, t0.account_premium_deadline AS account_premium_deadline_25, t0.invited_by AS invited_by_26, t0.invite_validated AS invite_validated_27, t0.invite_validated_date AS invite_validated_date_28, t0.invite_used AS invite_used_29, t0.google_places_id AS google_places_id_30, t0.booking_id AS booking_id_31, t0.tripadvisor_id AS tripadvisor_id_32, t0.facebook_id AS facebook_id_33, t0.trustmate_id AS trustmate_id_34, t0.is_apartment AS is_apartment_35, t0.short_name AS short_name_36, t0.unlocked_reports_till AS unlocked_reports_till_37, t0.unlocked_future_reports_till AS unlocked_future_reports_till_38, t0.excluded_from_comparison AS excluded_from_comparison_39, t0.system_report_last_checked_date AS system_report_last_checked_date_40, t0.system_report_apartment_last_checked_date AS system_report_apartment_last_checked_date_41, t0.daily_report_checkin_from AS daily_report_checkin_from_42, t0.created_at AS created_at_43, t0.updated_at AS updated_at_44, t45.id AS id_46, t45.continent AS continent_47, t45.country AS country_48, t45.pna AS pna_49, t45.province AS province_50, t45.city AS city_51, t45.street AS street_52, t45.street_number AS street_number_53, t45.hotel_id AS hotel_id_54, t55.id AS id_56, t55.company_name AS company_name_57, t55.first_name AS first_name_58, t55.last_name AS last_name_59, t55.job_name AS job_name_60, t55.phone AS phone_61, t55.email AS email_62, t55.address AS address_63, t55.tax_vat AS tax_vat_64, t55.nip AS nip_65, t55.zip_code AS zip_code_66, t55.city AS city_67, t55.hotel_id AS hotel_id_68, t0.street_id AS street_id_69, t0.klips_seller_id AS klips_seller_id_70, t0.hotels_networks_id AS hotels_networks_id_71, t0.hotels_network_agreement_id AS hotels_network_agreement_id_72, t0.network_id AS network_id_73, t0.network_agreement_id AS network_agreement_id_74, t0.virtual_city_id AS virtual_city_id_75, t0.apartments_clusters_id AS apartments_clusters_id_76, t77.id AS id_78, t77.created_at AS created_at_79, t77.updated_at AS updated_at_80, t77.hotel_id AS hotel_id_81, t77.apartments_clusters_id AS apartments_clusters_id_82 FROM hotels t0 LEFT JOIN hotels_address t45 ON t45.hotel_id = t0.id LEFT JOIN hotel_invoice_data t55 ON t55.hotel_id = t0.id LEFT JOIN hotel_objects t77 ON t77.hotel_id = t0.id WHERE t0.checked IS NULL AND t0.is_apartment = ?

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.identifier AS identifier_2,
  t0.api_identifier AS api_identifier_3,
  t0.name AS name_4,
  t0.group_name AS group_name_5,
  t0.brand_name AS brand_name_6,
  t0.owner_name AS owner_name_7,
  t0.pms_name AS pms_name_8,
  t0.pms_version AS pms_version_9,
  t0.enabled AS enabled_10,
  t0.standard AS standard_11,
  t0.rooms AS rooms_12,
  t0.coordinates AS coordinates_13,
  t0.inactive_rooms AS inactive_rooms_14,
  t0.object_type AS object_type_15,
  t0.checked AS checked_16,
  t0.approved_by_klips AS approved_by_klips_17,
  t0.address_manual_content AS address_manual_content_18,
  t0.klips_access_to_view AS klips_access_to_view_19,
  t0.reports_currency AS reports_currency_20,
  t0.convert_ratio_eur AS convert_ratio_eur_21,
  t0.convert_ratio_usd AS convert_ratio_usd_22,
  t0.blocked_status AS blocked_status_23,
  t0.account_type AS account_type_24,
  t0.account_premium_deadline AS account_premium_deadline_25,
  t0.invited_by AS invited_by_26,
  t0.invite_validated AS invite_validated_27,
  t0.invite_validated_date AS invite_validated_date_28,
  t0.invite_used AS invite_used_29,
  t0.google_places_id AS google_places_id_30,
  t0.booking_id AS booking_id_31,
  t0.tripadvisor_id AS tripadvisor_id_32,
  t0.facebook_id AS facebook_id_33,
  t0.trustmate_id AS trustmate_id_34,
  t0.is_apartment AS is_apartment_35,
  t0.short_name AS short_name_36,
  t0.unlocked_reports_till AS unlocked_reports_till_37,
  t0.unlocked_future_reports_till AS unlocked_future_reports_till_38,
  t0.excluded_from_comparison AS excluded_from_comparison_39,
  t0.system_report_last_checked_date AS system_report_last_checked_date_40,
  t0.system_report_apartment_last_checked_date AS system_report_apartment_last_checked_date_41,
  t0.daily_report_checkin_from AS daily_report_checkin_from_42,
  t0.created_at AS created_at_43,
  t0.updated_at AS updated_at_44,
  t45.id AS id_46,
  t45.continent AS continent_47,
  t45.country AS country_48,
  t45.pna AS pna_49,
  t45.province AS province_50,
  t45.city AS city_51,
  t45.street AS street_52,
  t45.street_number AS street_number_53,
  t45.hotel_id AS hotel_id_54,
  t55.id AS id_56,
  t55.company_name AS company_name_57,
  t55.first_name AS first_name_58,
  t55.last_name AS last_name_59,
  t55.job_name AS job_name_60,
  t55.phone AS phone_61,
  t55.email AS email_62,
  t55.address AS address_63,
  t55.tax_vat AS tax_vat_64,
  t55.nip AS nip_65,
  t55.zip_code AS zip_code_66,
  t55.city AS city_67,
  t55.hotel_id AS hotel_id_68,
  t0.street_id AS street_id_69,
  t0.klips_seller_id AS klips_seller_id_70,
  t0.hotels_networks_id AS hotels_networks_id_71,
  t0.hotels_network_agreement_id AS hotels_network_agreement_id_72,
  t0.network_id AS network_id_73,
  t0.network_agreement_id AS network_agreement_id_74,
  t0.virtual_city_id AS virtual_city_id_75,
  t0.apartments_clusters_id AS apartments_clusters_id_76,
  t77.id AS id_78,
  t77.created_at AS created_at_79,
  t77.updated_at AS updated_at_80,
  t77.hotel_id AS hotel_id_81,
  t77.apartments_clusters_id AS apartments_clusters_id_82
FROM
  hotels t0
  LEFT JOIN hotels_address t45 ON t45.hotel_id = t0.id
  LEFT JOIN hotel_invoice_data t55 ON t55.hotel_id = t0.id
  LEFT JOIN hotel_objects t77 ON t77.hotel_id = t0.id
WHERE
  t0.checked IS NULL
  AND t0.is_apartment = ?

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.api_identifier AS api_identifier_3, t0.name AS name_4, t0.group_name AS group_name_5, t0.brand_name AS brand_name_6, t0.owner_name AS owner_name_7, t0.pms_name AS pms_name_8, t0.pms_version AS pms_version_9, t0.enabled AS enabled_10, t0.standard AS standard_11, t0.rooms AS rooms_12, t0.coordinates AS coordinates_13, t0.inactive_rooms AS inactive_rooms_14, t0.object_type AS object_type_15, t0.checked AS checked_16, t0.approved_by_klips AS approved_by_klips_17, t0.address_manual_content AS address_manual_content_18, t0.klips_access_to_view AS klips_access_to_view_19, t0.reports_currency AS reports_currency_20, t0.convert_ratio_eur AS convert_ratio_eur_21, t0.convert_ratio_usd AS convert_ratio_usd_22, t0.blocked_status AS blocked_status_23, t0.account_type AS account_type_24, t0.account_premium_deadline AS account_premium_deadline_25, t0.invited_by AS invited_by_26, t0.invite_validated AS invite_validated_27, t0.invite_validated_date AS invite_validated_date_28, t0.invite_used AS invite_used_29, t0.google_places_id AS google_places_id_30, t0.booking_id AS booking_id_31, t0.tripadvisor_id AS tripadvisor_id_32, t0.facebook_id AS facebook_id_33, t0.trustmate_id AS trustmate_id_34, t0.is_apartment AS is_apartment_35, t0.short_name AS short_name_36, t0.unlocked_reports_till AS unlocked_reports_till_37, t0.unlocked_future_reports_till AS unlocked_future_reports_till_38, t0.excluded_from_comparison AS excluded_from_comparison_39, t0.system_report_last_checked_date AS system_report_last_checked_date_40, t0.system_report_apartment_last_checked_date AS system_report_apartment_last_checked_date_41, t0.daily_report_checkin_from AS daily_report_checkin_from_42, t0.created_at AS created_at_43, t0.updated_at AS updated_at_44, t45.id AS id_46, t45.continent AS continent_47, t45.country AS country_48, t45.pna AS pna_49, t45.province AS province_50, t45.city AS city_51, t45.street AS street_52, t45.street_number AS street_number_53, t45.hotel_id AS hotel_id_54, t55.id AS id_56, t55.company_name AS company_name_57, t55.first_name AS first_name_58, t55.last_name AS last_name_59, t55.job_name AS job_name_60, t55.phone AS phone_61, t55.email AS email_62, t55.address AS address_63, t55.tax_vat AS tax_vat_64, t55.nip AS nip_65, t55.zip_code AS zip_code_66, t55.city AS city_67, t55.hotel_id AS hotel_id_68, t0.street_id AS street_id_69, t0.klips_seller_id AS klips_seller_id_70, t0.hotels_networks_id AS hotels_networks_id_71, t0.hotels_network_agreement_id AS hotels_network_agreement_id_72, t0.network_id AS network_id_73, t0.network_agreement_id AS network_agreement_id_74, t0.virtual_city_id AS virtual_city_id_75, t0.apartments_clusters_id AS apartments_clusters_id_76, t77.id AS id_78, t77.created_at AS created_at_79, t77.updated_at AS updated_at_80, t77.hotel_id AS hotel_id_81, t77.apartments_clusters_id AS apartments_clusters_id_82 FROM hotels t0 LEFT JOIN hotels_address t45 ON t45.hotel_id = t0.id LEFT JOIN hotel_invoice_data t55 ON t55.hotel_id = t0.id LEFT JOIN hotel_objects t77 ON t77.hotel_id = t0.id WHERE t0.checked IS NULL AND t0.is_apartment = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 22)
4	App\Services\Alerts\AlertsService->getUncheckedHotels (line 22)
5	App\Controller\Backend\AppExtension->getGlobals (line 331)
6	Twig\ExtensionSet->getGlobals (line 788)
7	Twig\Environment->getGlobals (line 801)
8	Twig\Environment->mergeGlobals (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 448)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 275)
16	App\Controller\Frontend\FrontendLoginController->register (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 18)

0.89 ms
(19.80%)

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.attribute_group AS attribute_group_2, h0_.enabled AS enabled_3, h0_.idx_order AS idx_order_4, h0_.created_at AS created_at_5, h0_.updated_at AS updated_at_6 FROM hotels_attribute h0_ WHERE h0_.attribute_group = ? AND h0_.enabled = 1 ORDER BY h0_.idx_order ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  h0_.id AS id_0,
  h0_.name AS name_1,
  h0_.attribute_group AS attribute_group_2,
  h0_.enabled AS enabled_3,
  h0_.idx_order AS idx_order_4,
  h0_.created_at AS created_at_5,
  h0_.updated_at AS updated_at_6
FROM
  hotels_attribute h0_
WHERE
  h0_.attribute_group = ?
  AND h0_.enabled = 1
ORDER BY
  h0_.idx_order ASC

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.attribute_group AS attribute_group_2, h0_.enabled AS enabled_3, h0_.idx_order AS idx_order_4, h0_.created_at AS created_at_5, h0_.updated_at AS updated_at_6 FROM hotels_attribute h0_ WHERE h0_.attribute_group = 1 AND h0_.enabled = 1 ORDER BY h0_.idx_order ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 64)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 182)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 193)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 465)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 85)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildForm (line 102)
15	Symfony\Component\Form\ResolvedFormType->buildForm (line 79)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 100)
17	Symfony\Component\Form\ResolvedFormType->buildForm (line 79)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 58)
19	Symfony\Component\Form\FormFactory->createNamedBuilder (line 85)
20	Symfony\Component\Form\FormBuilder->create (line 212)
21	Symfony\Component\Form\FormBuilder->resolveChildren (line 134)
22	Symfony\Component\Form\FormBuilder->all (line 159)
23	App\Form\Hotels\HotelsCrudFrontendType->bulidBaseRow (line 61)
24	App\Form\Hotels\HotelsCrudFrontendType->preButtonsBuildForm (line 55)
25	App\Form\Core\AbstractCrudFormType->buildForm (line 102)
26	Symfony\Component\Form\ResolvedFormType->buildForm (line 79)
27	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 58)
28	Symfony\Component\Form\FormFactory->createNamedBuilder (line 43)
29	Symfony\Component\Form\FormFactory->createBuilder (line 28)
30	Symfony\Component\Form\FormFactory->create (line 340)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 142)
32	App\Controller\Frontend\FrontendLoginController->register (line 181)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
35	Symfony\Component\HttpKernel\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 18)

0.43 ms
(9.54%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.is_default AS is_default_3, t0.name_pl AS name_pl_4, t0.name_en AS name_en_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM addressation_lv1_continent t0 WHERE t0.code = ? LIMIT 1

Parameters:

[
  "EU"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.is_default AS is_default_3,
  t0.name_pl AS name_pl_4,
  t0.name_en AS name_en_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  addressation_lv1_continent t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.is_default AS is_default_3, t0.name_pl AS name_pl_4, t0.name_en AS name_en_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM addressation_lv1_continent t0 WHERE t0.code = 'EU' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 205)
4	App\Form\Hotels\HotelsCrudType->buildPickerOptions (line 532)
5	App\Form\Hotels\HotelsCrudType->bulidBaseRow (line 73)
6	App\Form\Hotels\HotelsCrudFrontendType->bulidBaseRow (line 61)
7	App\Form\Hotels\HotelsCrudFrontendType->preButtonsBuildForm (line 55)
8	App\Form\Core\AbstractCrudFormType->buildForm (line 102)
9	Symfony\Component\Form\ResolvedFormType->buildForm (line 79)
10	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 58)
11	Symfony\Component\Form\FormFactory->createNamedBuilder (line 43)
12	Symfony\Component\Form\FormFactory->createBuilder (line 28)
13	Symfony\Component\Form\FormFactory->create (line 340)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 142)
15	App\Controller\Frontend\FrontendLoginController->register (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 18)

0.42 ms
(9.39%)

SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.name_pl AS name_pl_3, t0.name_en AS name_en_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM hotels_type t0 WHERE t0.enabled = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.enabled AS enabled_2,
  t0.name_pl AS name_pl_3,
  t0.name_en AS name_en_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  hotels_type t0
WHERE
  t0.enabled = ?

SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.name_pl AS name_pl_3, t0.name_en AS name_en_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM hotels_type t0 WHERE t0.enabled = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 274)
4	App\Form\Hotels\HotelsCrudType->bulidBaseRow (line 73)
5	App\Form\Hotels\HotelsCrudFrontendType->bulidBaseRow (line 61)
6	App\Form\Hotels\HotelsCrudFrontendType->preButtonsBuildForm (line 55)
7	App\Form\Core\AbstractCrudFormType->buildForm (line 102)
8	Symfony\Component\Form\ResolvedFormType->buildForm (line 79)
9	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 58)
10	Symfony\Component\Form\FormFactory->createNamedBuilder (line 43)
11	Symfony\Component\Form\FormFactory->createBuilder (line 28)
12	Symfony\Component\Form\FormFactory->create (line 340)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 142)
14	App\Controller\Frontend\FrontendLoginController->register (line 181)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 18)

0.30 ms
(6.76%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.name_pl AS name_pl_3, t0.name_en AS name_en_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.continent_id AS continent_id_7 FROM addressation_lv2_country t0 WHERE t0.code = ? LIMIT 1

Parameters:

[
  "PL"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name_pl AS name_pl_3,
  t0.name_en AS name_en_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.continent_id AS continent_id_7
FROM
  addressation_lv2_country t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.name_pl AS name_pl_3, t0.name_en AS name_en_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.continent_id AS continent_id_7 FROM addressation_lv2_country t0 WHERE t0.code = 'PL' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 212)
4	App\Form\Hotels\HotelsCrudType->buildPickerOptions (line 532)
5	App\Form\Hotels\HotelsCrudType->bulidBaseRow (line 73)
6	App\Form\Hotels\HotelsCrudFrontendType->bulidBaseRow (line 61)
7	App\Form\Hotels\HotelsCrudFrontendType->preButtonsBuildForm (line 55)
8	App\Form\Core\AbstractCrudFormType->buildForm (line 102)
9	Symfony\Component\Form\ResolvedFormType->buildForm (line 79)
10	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 58)
11	Symfony\Component\Form\FormFactory->createNamedBuilder (line 43)
12	Symfony\Component\Form\FormFactory->createBuilder (line 28)
13	Symfony\Component\Form\FormFactory->create (line 340)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 142)
15	App\Controller\Frontend\FrontendLoginController->register (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 18)

0.26 ms
(5.76%)

SELECT t0.id AS id_1, t0.parameter_key AS parameter_key_2, t0.name AS name_3, t0.category AS category_4, t0.description AS description_5, t0.value AS value_6, t0.type AS type_7, t0.rte AS rte_8 FROM core_system_parameters t0 WHERE t0.parameter_key = ? LIMIT 1

Parameters:

[
  "compilation"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.parameter_key AS parameter_key_2,
  t0.name AS name_3,
  t0.category AS category_4,
  t0.description AS description_5,
  t0.value AS value_6,
  t0.type AS type_7,
  t0.rte AS rte_8
FROM
  core_system_parameters t0
WHERE
  t0.parameter_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.parameter_key AS parameter_key_2, t0.name AS name_3, t0.category AS category_4, t0.description AS description_5, t0.value AS value_6, t0.type AS type_7, t0.rte AS rte_8 FROM core_system_parameters t0 WHERE t0.parameter_key = 'compilation' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 28)
4	App\Services\SystemParameters\SystemParametersService->getValue (line 1637)
5	twig_get_attribute (line 67)
6	__TwigTemplate_5d253be34a2e64b0d344de9fc2c35514->doDisplay (line 394)
7	Twig\Template->displayWithErrorHandling (line 367)
8	Twig\Template->display (line 58)
9	__TwigTemplate_9e3f6f4512886f761ae316c470b68778->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 57)
12	__TwigTemplate_dc57a6af174323e8c02c3bc5373413a1->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 52)
15	__TwigTemplate_004e8a69c21b9db8574816f94936814f->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 40)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 275)
24	App\Controller\Frontend\FrontendLoginController->register (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 18)

0.19 ms
(4.13%)

SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM hotels_standard t0 WHERE t0.enabled = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.enabled AS enabled_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  hotels_standard t0
WHERE
  t0.enabled = ?

SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM hotels_standard t0 WHERE t0.enabled = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 282)
4	App\Form\Hotels\HotelsCrudType->bulidBaseRow (line 73)
5	App\Form\Hotels\HotelsCrudFrontendType->bulidBaseRow (line 61)
6	App\Form\Hotels\HotelsCrudFrontendType->preButtonsBuildForm (line 55)
7	App\Form\Core\AbstractCrudFormType->buildForm (line 102)
8	Symfony\Component\Form\ResolvedFormType->buildForm (line 79)
9	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 58)
10	Symfony\Component\Form\FormFactory->createNamedBuilder (line 43)
11	Symfony\Component\Form\FormFactory->createBuilder (line 28)
12	Symfony\Component\Form\FormFactory->create (line 340)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 142)
14	App\Controller\Frontend\FrontendLoginController->register (line 181)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 18)

0.12 ms
(2.79%)

SELECT t0.id AS id_1, t0.day AS day_2, t0.counted_hotels AS counted_hotels_3, t0.indicator_occ AS indicator_occ_4, t0.indicator_adr AS indicator_adr_5, t0.indicator_rev_par AS indicator_rev_par_6, t0.indicator_dof AS indicator_dof_7, t0.indicator_demand AS indicator_demand_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM report_frontend_cache t0 WHERE t0.day = ? LIMIT 1

Parameters:

[
  "2025-12-05"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.day AS day_2,
  t0.counted_hotels AS counted_hotels_3,
  t0.indicator_occ AS indicator_occ_4,
  t0.indicator_adr AS indicator_adr_5,
  t0.indicator_rev_par AS indicator_rev_par_6,
  t0.indicator_dof AS indicator_dof_7,
  t0.indicator_demand AS indicator_demand_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  report_frontend_cache t0
WHERE
  t0.day = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.day AS day_2, t0.counted_hotels AS counted_hotels_3, t0.indicator_occ AS indicator_occ_4, t0.indicator_adr AS indicator_adr_5, t0.indicator_rev_par AS indicator_rev_par_6, t0.indicator_dof AS indicator_dof_7, t0.indicator_demand AS indicator_demand_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM report_frontend_cache t0 WHERE t0.day = '2025-12-05' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 34)
4	App\Services\FrontendService\FrontendService->fetch (line 117)
5	App\Services\FrontendService\FrontendService->getData (line 1637)
6	twig_get_attribute (line 543)
7	__TwigTemplate_dc57a6af174323e8c02c3bc5373413a1->block_content (line 171)
8	Twig\Template->displayBlock (line 427)
9	__TwigTemplate_dc57a6af174323e8c02c3bc5373413a1->block_content_wrapper (line 171)
10	Twig\Template->displayBlock (line 198)
11	__TwigTemplate_9e3f6f4512886f761ae316c470b68778->block_body (line 171)
12	Twig\Template->displayBlock (line 89)
13	__TwigTemplate_5d253be34a2e64b0d344de9fc2c35514->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 58)
16	__TwigTemplate_9e3f6f4512886f761ae316c470b68778->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 57)
19	__TwigTemplate_dc57a6af174323e8c02c3bc5373413a1->doDisplay (line 394)
20	Twig\Template->displayWithErrorHandling (line 367)
21	Twig\Template->display (line 52)
22	__TwigTemplate_004e8a69c21b9db8574816f94936814f->doDisplay (line 394)
23	Twig\Template->displayWithErrorHandling (line 367)
24	Twig\Template->display (line 379)
25	Twig\Template->render (line 40)
26	Twig\TemplateWrapper->render (line 280)
27	Twig\Environment->render (line 448)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 275)
31	App\Controller\Frontend\FrontendLoginController->register (line 181)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 18)

0.12 ms
(2.74%)

SELECT r0_.id AS id_0, r0_.day AS day_1, r0_.counted_hotels AS counted_hotels_2, r0_.indicator_occ AS indicator_occ_3, r0_.indicator_adr AS indicator_adr_4, r0_.indicator_rev_par AS indicator_rev_par_5, r0_.indicator_dof AS indicator_dof_6, r0_.indicator_demand AS indicator_demand_7, r0_.created_at AS created_at_8, r0_.updated_at AS updated_at_9 FROM report_frontend_cache r0_ WHERE r0_.counted_hotels <> 0 ORDER BY r0_.day DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.day AS day_1,
  r0_.counted_hotels AS counted_hotels_2,
  r0_.indicator_occ AS indicator_occ_3,
  r0_.indicator_adr AS indicator_adr_4,
  r0_.indicator_rev_par AS indicator_rev_par_5,
  r0_.indicator_dof AS indicator_dof_6,
  r0_.indicator_demand AS indicator_demand_7,
  r0_.created_at AS created_at_8,
  r0_.updated_at AS updated_at_9
FROM
  report_frontend_cache r0_
WHERE
  r0_.counted_hotels <> 0
ORDER BY
  r0_.day DESC
LIMIT
  1

SELECT r0_.id AS id_0, r0_.day AS day_1, r0_.counted_hotels AS counted_hotels_2, r0_.indicator_occ AS indicator_occ_3, r0_.indicator_adr AS indicator_adr_4, r0_.indicator_rev_par AS indicator_rev_par_5, r0_.indicator_dof AS indicator_dof_6, r0_.indicator_demand AS indicator_demand_7, r0_.created_at AS created_at_8, r0_.updated_at AS updated_at_9 FROM report_frontend_cache r0_ WHERE r0_.counted_hotels <> 0 ORDER BY r0_.day DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 33)
7	App\Repository\Report\ReportFrontendCacheRepository->findLatestDayWithNonZeroIndicator (line 56)
8	App\Services\FrontendService\FrontendService->fetch (line 117)
9	App\Services\FrontendService\FrontendService->getData (line 1637)
10	twig_get_attribute (line 543)
11	__TwigTemplate_dc57a6af174323e8c02c3bc5373413a1->block_content (line 171)
12	Twig\Template->displayBlock (line 427)
13	__TwigTemplate_dc57a6af174323e8c02c3bc5373413a1->block_content_wrapper (line 171)
14	Twig\Template->displayBlock (line 198)
15	__TwigTemplate_9e3f6f4512886f761ae316c470b68778->block_body (line 171)
16	Twig\Template->displayBlock (line 89)
17	__TwigTemplate_5d253be34a2e64b0d344de9fc2c35514->doDisplay (line 394)
18	Twig\Template->displayWithErrorHandling (line 367)
19	Twig\Template->display (line 58)
20	__TwigTemplate_9e3f6f4512886f761ae316c470b68778->doDisplay (line 394)
21	Twig\Template->displayWithErrorHandling (line 367)
22	Twig\Template->display (line 57)
23	__TwigTemplate_dc57a6af174323e8c02c3bc5373413a1->doDisplay (line 394)
24	Twig\Template->displayWithErrorHandling (line 367)
25	Twig\Template->display (line 52)
26	__TwigTemplate_004e8a69c21b9db8574816f94936814f->doDisplay (line 394)
27	Twig\Template->displayWithErrorHandling (line 367)
28	Twig\Template->display (line 379)
29	Twig\Template->render (line 40)
30	Twig\TemplateWrapper->render (line 280)
31	Twig\Environment->render (line 448)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 275)
35	App\Controller\Frontend\FrontendLoginController->register (line 181)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 18)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
log	doctrine.dbal.log_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
log	doctrine.orm.log_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Hotels\HotelsType	No errors.
App\Entity\Hotels\HotelsStandard	No errors.
App\Entity\Address\AddressationLv1Continent	No errors.
App\Entity\Address\AddressationLv2Country	The mappings App\Entity\Address\AddressationLv2Country#pnas and App\Entity\Address\AddressationLv3Pna#country are inconsistent with each other.
App\Entity\Address\AddressationLv3Pna	The association App\Entity\Address\AddressationLv3Pna#country refers to the inverse side field App\Entity\Address\AddressationLv2Country#countries which does not exist. The association App\Entity\Address\AddressationLv3Pna#provinces refers to the owning side field App\Entity\Address\AddressationLv4Province#pma which does not exist.
App\Entity\Hotels\HotelsAttribute	No errors.
App\Entity\Hotels\Hotels	No errors.
App\Entity\Compset\Compset	No errors.
App\Entity\SummaryReport\SummaryReport	The association App\Entity\SummaryReport\SummaryReport#parentApartmentsCluster refers to the inverse side field App\Entity\ApartmentsClusters\ApartmentsClusters#summaryReports which does not exist.
App\Entity\SummaryReport\SummaryReportDraft	The association App\Entity\SummaryReport\SummaryReportDraft#parentApartmentsCluster refers to the inverse side field App\Entity\ApartmentsClusters\ApartmentsClusters#summaryReports which does not exist.
App\Entity\Hotels\HotelsAddress	No errors.
App\Entity\Hotels\HotelInvoiceData	No errors.
App\Entity\Address\AddressationLv6Street	No errors.
App\Entity\Core\Admin	No errors.
App\Entity\Hotels\HotelsNetwork	No errors.
App\Entity\Network\Network	No errors.
App\Entity\Hotels\VirtualCity	No errors.
App\Entity\ApartmentsClusters\ApartmentsClusters	The association App\Entity\ApartmentsClusters\ApartmentsClusters#reports refers to the owning side field App\Entity\Reports\Report#parentApartmentsCluster which does not exist.
App\Entity\HotelObjects\HotelObjects	No errors.
App\Entity\Core\SystemParameters	No errors.
App\Entity\Reports\ReportFrontendCache	No errors.

log entity manager

No loaded entities.

Symfony Profiler

GET https://klips.nettom.com.pl/pl/hotel-register

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

log entity manager