GET https://trattoriasano.pl/promo-popups/get-active

Query Metrics

5 Database Queries
5 Different statements
10.59 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
5.07 ms
(47.87%)
1
SELECT m0_.id AS id_0, m0_.content AS content_1, m0_.url AS url_2, m0_.main_page_only AS main_page_only_3, m0_.start_date AS start_date_4, m0_.end_date AS end_date_5, m0_.is_active AS is_active_6, m1_.id AS id_7, m0_.id_module_multilang_entry AS id_module_multilang_entry_8, m1_.id_module_multilang_entry_lang AS id_module_multilang_entry_lang_9, m1_.id_module_promo_popups AS id_module_promo_popups_10, m1_.id_image_file_repository AS id_image_file_repository_11 FROM module_promo_popups m0_ INNER JOIN module_promo_popups_lang_entry m1_ ON m0_.id = m1_.id_module_promo_popups INNER JOIN module_multilang_entry m2_ ON m0_.id_module_multilang_entry = m2_.id INNER JOIN module_multilang_entry_lang m3_ ON m2_.id = m3_.id_module_multilang_entry WHERE m1_.id_module_multilang_entry_lang = m3_.id AND (m3_.lang = ? AND m3_.content_edited = 1) AND m0_.is_active = 1 AND (m0_.start_date IS NULL AND m0_.end_date IS NULL)
Parameters:
[
  "pl"
]
1.55 ms
(14.64%)
1
SELECT
                            t.foreign_key,
                            t.value
                        FROM
                            translator t
                        WHERE
                            t.foreign_key LIKE ?
Parameters:
[
  "promo_popups_%"
]
1.35 ms
(12.74%)
1
SELECT m0_.id AS id_0, m0_.content AS content_1, m0_.url AS url_2, m0_.main_page_only AS main_page_only_3, m0_.start_date AS start_date_4, m0_.end_date AS end_date_5, m0_.is_active AS is_active_6, m1_.id AS id_7, m0_.id_module_multilang_entry AS id_module_multilang_entry_8, m1_.id_module_multilang_entry_lang AS id_module_multilang_entry_lang_9, m1_.id_module_promo_popups AS id_module_promo_popups_10, m1_.id_image_file_repository AS id_image_file_repository_11 FROM module_promo_popups m0_ INNER JOIN module_promo_popups_lang_entry m1_ ON m0_.id = m1_.id_module_promo_popups INNER JOIN module_multilang_entry m2_ ON m0_.id_module_multilang_entry = m2_.id INNER JOIN module_multilang_entry_lang m3_ ON m2_.id = m3_.id_module_multilang_entry WHERE m1_.id_module_multilang_entry_lang = m3_.id AND (m3_.lang = ? AND m3_.content_edited = 1) AND m0_.is_active = 1 AND (m0_.start_date <= ? AND m0_.end_date IS NULL)
Parameters:
[
  "pl"
  "2024-11-23 19:58:12"
]
1.34 ms
(12.68%)
1
SELECT m0_.id AS id_0, m0_.content AS content_1, m0_.url AS url_2, m0_.main_page_only AS main_page_only_3, m0_.start_date AS start_date_4, m0_.end_date AS end_date_5, m0_.is_active AS is_active_6, m1_.id AS id_7, m0_.id_module_multilang_entry AS id_module_multilang_entry_8, m1_.id_module_multilang_entry_lang AS id_module_multilang_entry_lang_9, m1_.id_module_promo_popups AS id_module_promo_popups_10, m1_.id_image_file_repository AS id_image_file_repository_11 FROM module_promo_popups m0_ INNER JOIN module_promo_popups_lang_entry m1_ ON m0_.id = m1_.id_module_promo_popups INNER JOIN module_multilang_entry m2_ ON m0_.id_module_multilang_entry = m2_.id INNER JOIN module_multilang_entry_lang m3_ ON m2_.id = m3_.id_module_multilang_entry WHERE m1_.id_module_multilang_entry_lang = m3_.id AND (m3_.lang = ? AND m3_.content_edited = 1) AND m0_.is_active = 1 AND (m0_.start_date <= ? AND m0_.end_date >= ?)
Parameters:
[
  "pl"
  "2024-11-23 19:58:12"
  "2024-11-23 19:58:12"
]
1.28 ms
(12.06%)
1
SELECT m0_.id AS id_0, m0_.content AS content_1, m0_.url AS url_2, m0_.main_page_only AS main_page_only_3, m0_.start_date AS start_date_4, m0_.end_date AS end_date_5, m0_.is_active AS is_active_6, m1_.id AS id_7, m0_.id_module_multilang_entry AS id_module_multilang_entry_8, m1_.id_module_multilang_entry_lang AS id_module_multilang_entry_lang_9, m1_.id_module_promo_popups AS id_module_promo_popups_10, m1_.id_image_file_repository AS id_image_file_repository_11 FROM module_promo_popups m0_ INNER JOIN module_promo_popups_lang_entry m1_ ON m0_.id = m1_.id_module_promo_popups INNER JOIN module_multilang_entry m2_ ON m0_.id_module_multilang_entry = m2_.id INNER JOIN module_multilang_entry_lang m3_ ON m2_.id = m3_.id_module_multilang_entry WHERE m1_.id_module_multilang_entry_lang = m3_.id AND (m3_.lang = ? AND m3_.content_edited = 1) AND m0_.is_active = 1 AND (m0_.end_date >= ? AND m0_.start_date IS NULL)
Parameters:
[
  "pl"
  "2024-11-23 19:58:12"
]

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.