Query Metrics
7
Database Queries
7
Different statements
32.33 ms
Query time
0
Invalid entities
1650
Managed entities
Queries
trans connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.21 ms |
SELECT MAX(l0_.updated_at) AS sclr_0 FROM lexik_trans_unit_translations l0_
Parameters:
[] |
default connection
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.48 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.setting_description AS setting_description_4 FROM settings t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
"debug_tracking_status"
]
|
||||||||||||||||||||||||||||||||||
| 2 | 24.31 ms |
SELECT t0.id AS id_1, t0.slug_lt AS slug_lt_2, t0.slug_en AS slug_en_3, t0.slug_ru AS slug_ru_4, t0.slug_lv AS slug_lv_5, t0.slug_ee AS slug_ee_6, t0.title_lt AS title_lt_7, t0.title_en AS title_en_8, t0.title_ru AS title_ru_9, t0.title_lv AS title_lv_10, t0.title_ee AS title_ee_11, t0.sub_title_lt AS sub_title_lt_12, t0.sub_title_en AS sub_title_en_13, t0.sub_title_ru AS sub_title_ru_14, t0.sub_title_lv AS sub_title_lv_15, t0.sub_title_ee AS sub_title_ee_16, t0.body_lt AS body_lt_17, t0.body_en AS body_en_18, t0.body_ru AS body_ru_19, t0.body_lv AS body_lv_20, t0.body_ee AS body_ee_21, t0.meta_keywords_lt AS meta_keywords_lt_22, t0.meta_keywords_en AS meta_keywords_en_23, t0.meta_keywords_ru AS meta_keywords_ru_24, t0.meta_keywords_lv AS meta_keywords_lv_25, t0.meta_keywords_ee AS meta_keywords_ee_26, t0.page_key AS page_key_27, t0.show_for_translators AS show_for_translators_28, t0.show_calculator AS show_calculator_29, t0.show_social_links AS show_social_links_30, t0.hide_for_robots_lt AS hide_for_robots_lt_31, t0.hide_for_robots_en AS hide_for_robots_en_32, t0.hide_for_robots_ru AS hide_for_robots_ru_33, t0.hide_for_robots_lv AS hide_for_robots_lv_34, t0.hide_for_robots_ee AS hide_for_robots_ee_35, t0.show_top_photo AS show_top_photo_36, t0.show_bottom_calculator_hint AS show_bottom_calculator_hint_37, t0.show_contact_us_form AS show_contact_us_form_38, t0.show_contact_us_form_new AS show_contact_us_form_new_39, t0.top_photo_url AS top_photo_url_40, t0.file_to_load AS file_to_load_41, t0.body_class AS body_class_42, t0.header_class AS header_class_43, t0.show_new_design AS show_new_design_44, t0.keywords_lt AS keywords_lt_45, t0.keywords_en AS keywords_en_46, t0.keywords_ru AS keywords_ru_47, t0.keywords_lv AS keywords_lv_48, t0.keywords_ee AS keywords_ee_49, t0.faq_questions_ans_lt AS faq_questions_ans_lt_50, t0.faq_questions_ans_en AS faq_questions_ans_en_51, t0.faq_questions_ans_ru AS faq_questions_ans_ru_52, t0.faq_questions_ans_lv AS faq_questions_ans_lv_53, t0.faq_questions_ans_ee AS faq_questions_ans_ee_54, t0.created_at AS created_at_55, t0.updated_at AS updated_at_56, t0.meta_title_lt AS meta_title_lt_57, t0.meta_title_en AS meta_title_en_58, t0.meta_title_ru AS meta_title_ru_59, t0.meta_title_lv AS meta_title_lv_60, t0.meta_title_ee AS meta_title_ee_61, t0.meta_description_lt AS meta_description_lt_62, t0.meta_description_en AS meta_description_en_63, t0.meta_description_ru AS meta_description_ru_64, t0.meta_description_lv AS meta_description_lv_65, t0.meta_description_ee AS meta_description_ee_66, t0.country_from AS country_from_67, t0.country_to AS country_to_68 FROM static_pages t0
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
| 3 | 1.68 ms |
SELECT b0_.id AS id_0, b0_.title_lt AS title_lt_1, b0_.title_en AS title_en_2, b0_.title_ru AS title_ru_3, b0_.title_lv AS title_lv_4, b0_.title_ee AS title_ee_5, b0_.slug_lt AS slug_lt_6, b0_.slug_en AS slug_en_7, b0_.slug_ru AS slug_ru_8, b0_.slug_lv AS slug_lv_9, b0_.slug_ee AS slug_ee_10, b0_.text_lt AS text_lt_11, b0_.text_en AS text_en_12, b0_.text_ru AS text_ru_13, b0_.text_lv AS text_lv_14, b0_.text_ee AS text_ee_15, b0_.confirmed AS confirmed_16, b0_.deleted AS deleted_17, b0_.show_lt AS show_lt_18, b0_.show_en AS show_en_19, b0_.show_ru AS show_ru_20, b0_.show_ee AS show_ee_21, b0_.show_lv AS show_lv_22, b0_.main_photo_url AS main_photo_url_23, b0_.text_excerpt_lt AS text_excerpt_lt_24, b0_.text_excerpt_en AS text_excerpt_en_25, b0_.text_excerpt_ru AS text_excerpt_ru_26, b0_.text_excerpt_lv AS text_excerpt_lv_27, b0_.text_excerpt_ee AS text_excerpt_ee_28, b0_.keywords_lt AS keywords_lt_29, b0_.keywords_en AS keywords_en_30, b0_.keywords_ru AS keywords_ru_31, b0_.keywords_lv AS keywords_lv_32, b0_.keywords_ee AS keywords_ee_33, b0_.meta_title_lt AS meta_title_lt_34, b0_.meta_title_en AS meta_title_en_35, b0_.meta_title_ru AS meta_title_ru_36, b0_.meta_title_lv AS meta_title_lv_37, b0_.meta_title_ee AS meta_title_ee_38, b0_.meta_description_lt AS meta_description_lt_39, b0_.meta_description_en AS meta_description_en_40, b0_.meta_description_ru AS meta_description_ru_41, b0_.meta_description_lv AS meta_description_lv_42, b0_.meta_description_ee AS meta_description_ee_43, b0_.updated_at AS updated_at_44, b0_.created_at AS created_at_45 FROM blog b0_ WHERE b0_.confirmed = 1 AND b0_.deleted = 0 AND b0_.show_en = 1 ORDER BY b0_.created_at DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
| 4 | 1.07 ms |
SELECT n0_.id AS id_0, n0_.title_lt AS title_lt_1, n0_.title_en AS title_en_2, n0_.title_ru AS title_ru_3, n0_.title_ru_lt AS title_ru_lt_4, n0_.title_lv AS title_lv_5, n0_.title_ee AS title_ee_6, n0_.title_pl AS title_pl_7, n0_.slug_lt AS slug_lt_8, n0_.slug_en AS slug_en_9, n0_.slug_ru AS slug_ru_10, n0_.slug_ru_lt AS slug_ru_lt_11, n0_.slug_lv AS slug_lv_12, n0_.slug_ee AS slug_ee_13, n0_.slug_pl AS slug_pl_14, n0_.text_lt AS text_lt_15, n0_.text_en AS text_en_16, n0_.text_ru AS text_ru_17, n0_.textr_ru_lt AS textr_ru_lt_18, n0_.text_lv AS text_lv_19, n0_.text_ee AS text_ee_20, n0_.text_pl AS text_pl_21, n0_.text_excerpt_lt AS text_excerpt_lt_22, n0_.text_excerpt_en AS text_excerpt_en_23, n0_.text_excerpt_ru AS text_excerpt_ru_24, n0_.text_excerpt_ru_lt AS text_excerpt_ru_lt_25, n0_.text_excerpt_lv AS text_excerpt_lv_26, n0_.text_excerpt_ee AS text_excerpt_ee_27, n0_.text_excerpt_pl AS text_excerpt_pl_28, n0_.is_full_url AS is_full_url_29, n0_.confirmed AS confirmed_30, n0_.deleted AS deleted_31, n0_.show_lt AS show_lt_32, n0_.show_en AS show_en_33, n0_.show_ru AS show_ru_34, n0_.show_ru_lt AS show_ru_lt_35, n0_.show_ee AS show_ee_36, n0_.show_lv AS show_lv_37, n0_.keywords_lt AS keywords_lt_38, n0_.keywords_en AS keywords_en_39, n0_.keywords_ru AS keywords_ru_40, n0_.keywords_lv AS keywords_lv_41, n0_.keywords_ee AS keywords_ee_42, n0_.meta_title_lt AS meta_title_lt_43, n0_.meta_title_en AS meta_title_en_44, n0_.meta_title_ru AS meta_title_ru_45, n0_.meta_title_lv AS meta_title_lv_46, n0_.meta_title_ee AS meta_title_ee_47, n0_.meta_description_lt AS meta_description_lt_48, n0_.meta_description_en AS meta_description_en_49, n0_.meta_description_ru AS meta_description_ru_50, n0_.meta_description_lv AS meta_description_lv_51, n0_.meta_description_ee AS meta_description_ee_52, n0_.created_at AS created_at_53, n0_.updated_at AS updated_at_54 FROM news n0_ WHERE n0_.confirmed = 1 AND n0_.deleted = 0 AND n0_.show_en = 1 ORDER BY n0_.created_at DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
| 5 | 0.49 ms |
SELECT t0.id AS id_1, t0.slug_lt AS slug_lt_2, t0.slug_en AS slug_en_3, t0.slug_ru AS slug_ru_4, t0.slug_ru_lt AS slug_ru_lt_5, t0.slug_lv AS slug_lv_6, t0.slug_ee AS slug_ee_7, t0.slug_pl AS slug_pl_8, t0.title_lt AS title_lt_9, t0.title_en AS title_en_10, t0.title_ru AS title_ru_11, t0.title_ru_lt AS title_ru_lt_12, t0.title_lv AS title_lv_13, t0.title_ee AS title_ee_14, t0.title_pl AS title_pl_15, t0.order_number AS order_number_16, t0.logo_id AS logo_id_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM faq_sections t0
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
| 6 | 1.09 ms |
SELECT t0.id AS id_1, t0.title_lt AS title_lt_2, t0.title_en AS title_en_3, t0.title_ru AS title_ru_4, t0.title_ru_lt AS title_ru_lt_5, t0.title_lv AS title_lv_6, t0.title_ee AS title_ee_7, t0.title_pl AS title_pl_8, t0.slug_lt AS slug_lt_9, t0.slug_en AS slug_en_10, t0.slug_ru AS slug_ru_11, t0.slug_ru_lt AS slug_ru_lt_12, t0.slug_lv AS slug_lv_13, t0.slug_ee AS slug_ee_14, t0.slug_pl AS slug_pl_15, t0.body_lt AS body_lt_16, t0.body_en AS body_en_17, t0.body_ru AS body_ru_18, t0.body_ru_lt AS body_ru_lt_19, t0.body_lv AS body_lv_20, t0.body_ee AS body_ee_21, t0.body_pl AS body_pl_22, t0.keywords_lt AS keywords_lt_23, t0.keywords_en AS keywords_en_24, t0.keywords_ru AS keywords_ru_25, t0.keywords_lv AS keywords_lv_26, t0.keywords_ee AS keywords_ee_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.section_id AS section_id_30 FROM faq_sub_sections t0
Parameters:
[]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| trans | doctrine.dbal.trans_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| trans | doctrine.orm.trans_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\StaticPage | 1342 |
| App\Entity\Country | 189 |
| App\Entity\FaqSubSection | 76 |
| App\Entity\News | 19 |
| App\Entity\Blog | 16 |
| App\Entity\FaqSection | 7 |
| App\Entity\Setting | 1 |
trans entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Setting | No errors. |
| App\Entity\StaticPage | No errors. |
| App\Entity\Country | No errors. |
| App\Entity\Blog | No errors. |
| App\Entity\News | No errors. |
| App\Entity\FaqSection | No errors. |
| App\Entity\FaqSubSection | No errors. |
trans entity manager
| Class | Mapping errors |
|---|---|
| Lexik\Bundle\TranslationBundle\Model\Translation | No errors. |
| Lexik\Bundle\TranslationBundle\Entity\Translation | No errors. |