GET https://dev.sendparcel.com/sitemap.xml

Query Metrics

7 Database Queries
7 Different statements
32.33 ms Query time
0 Invalid entities
1650 Managed entities

Queries

Group similar statements

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.