Query Metrics
5
Database Queries
5
Different statements
10.59 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.55 ms |
SELECT t.foreign_key, t.value FROM translator t WHERE t.foreign_key LIKE ?
Parameters:
[
"promo_popups_%"
]
|
2 | 5.07 ms |
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"
]
|
3 | 1.34 ms |
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" ] |
4 | 1.35 ms |
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" ] |
5 | 1.28 ms |
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.
Entities Mapping
Class | Mapping errors |
---|---|
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
Gedmo\Translatable\Entity\Translation | No errors. |
App\Admin\Modules\Translator\Entity\Translator | No errors. |
App\Admin\Modules\ModulePromoPopups\Entity\ModulePromoPopups | No errors. |
App\Admin\Modules\ModulePromoPopups\Entity\ModulePromoPopupsLangEntry | No errors. |
App\Admin\Modules\Module\Entity\ModuleMultilangEntry | No errors. |
App\Admin\Modules\Module\Entity\ModuleMultilangEntryLang | No errors. |
App\Admin\Modules\FileRepository\Entity\FileRepository | No errors. |