Query Metrics
6
Database Queries
6
Different statements
338.42 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
240.75 ms (71.14%) |
1 |
SELECT count(*) as cnt FROM (SELECT event.id as id, event.slug as slug, event.event_status as event_status, event.fm_status as fm_status, event.fm_id as fm_id, event.price_from as price_from, event.city_id as city_id, event.building_id as building_id, event.activity_id as activity_id, event.last_status_updated_at as last_status_updated_at, event.currency_id as currency_id, event.use_event_name as use_event_name, event.price_to as price_to, event.event_date as event_date, event.event_old_date as event_old_date, event.event_new_date as event_new_date, event.event_end_date as event_end_date, event_lang.name as event_name, event_lang_default.name as default_event_name, event_lang.status_tooltip as status_tooltip, event.image_big as image_big, event.image_medium as image_medium, event.image_large as image_large, event.image_small as image_small, event.legal_id as legal_id, legal.name as legal_name, organization.name as organization_name, legal.edrpou as legal_edrpou FROM event LEFT JOIN event_lang event_lang ON event_lang.model_id = event.id AND event_lang.language_code = ? LEFT JOIN event_lang event_lang_default ON event_lang_default.model_id = event.id AND event_lang_default.language_code = ? LEFT JOIN legal legal ON legal.id = event.legal_id LEFT JOIN organization organization ON organization.id = event.organization_id WHERE (event.status = ?) AND (event.fm_status IN (?, ?, ?)) AND ((event_lang.name like '%%' OR event_lang_default.name like '%%' OR event_date like '%%' OR event_new_date like '%%' OR legal.name like '%%' OR organization.name like '%%' OR legal.edrpou like '%%'))) dbal_count_tbl
Parameters:
[ "ua" "en" 1 2 1 3 ] |
74.06 ms (21.88%) |
1 |
SELECT event.id as id, event.slug as slug, event.event_status as event_status, event.fm_status as fm_status, event.fm_id as fm_id, event.price_from as price_from, event.city_id as city_id, event.building_id as building_id, event.activity_id as activity_id, event.last_status_updated_at as last_status_updated_at, event.currency_id as currency_id, event.use_event_name as use_event_name, event.price_to as price_to, event.event_date as event_date, event.event_old_date as event_old_date, event.event_new_date as event_new_date, event.event_end_date as event_end_date, event_lang.name as event_name, event_lang_default.name as default_event_name, event_lang.status_tooltip as status_tooltip, event.image_big as image_big, event.image_medium as image_medium, event.image_large as image_large, event.image_small as image_small, event.legal_id as legal_id, legal.name as legal_name, organization.name as organization_name, legal.edrpou as legal_edrpou FROM event LEFT JOIN event_lang event_lang ON event_lang.model_id = event.id AND event_lang.language_code = ? LEFT JOIN event_lang event_lang_default ON event_lang_default.model_id = event.id AND event_lang_default.language_code = ? LEFT JOIN legal legal ON legal.id = event.legal_id LEFT JOIN organization organization ON organization.id = event.organization_id WHERE (event.status = ?) AND (event.fm_status IN (?, ?, ?)) AND ((event_lang.name like '%%' OR event_lang_default.name like '%%' OR event_date like '%%' OR event_new_date like '%%' OR legal.name like '%%' OR organization.name like '%%' OR legal.edrpou like '%%')) ORDER BY event.last_status_updated_at desc LIMIT 10 OFFSET 330
Parameters:
[ "ua" "en" 1 2 1 3 ] |
14.44 ms (4.27%) |
1 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.external_id AS external_id_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.is_index AS is_index_7, t0.css AS css_8, t0.js_head AS js_head_9, t0.js_body_start AS js_body_start_10, t0.js_body_end AS js_body_end_11 FROM page t0 WHERE t0.slug = ? AND t0.status = ? LIMIT 1
Parameters:
[ "info" 1 ] |
7.20 ms (2.13%) |
1 |
SELECT t0.id AS id_1, t0.language_code AS language_code_2, t0.title AS title_3, t0.canonical AS canonical_4, t0.seo_title AS seo_title_5, t0.seo_image AS seo_image_6, t0.seo_description AS seo_description_7, t0.seo_keywords AS seo_keywords_8, t0.model_id AS model_id_9 FROM page_lang t0 WHERE t0.model_id = ?
Parameters:
[
"018b472e-d8e1-77a1-97df-861acfe708ed"
]
|
0.99 ms (0.29%) |
1 |
SELECT activity.id as id, activity.external_id as external_id, activity.sticker_id as sticker_id, activity.sticker_activity_time_from as sticker_activity_time_from, activity.sticker_activity_time_to as sticker_activity_time_to, activity_lang.name as name, activity_lang.description as description, activity_lang_default.name as default_name, activity_lang_default.description as default_description, activity_lang.sticker_description as sticker_description, activity_lang_default.sticker_description as default_sticker_description, event.id as event_id FROM activity LEFT JOIN activity_lang activity_lang ON activity_lang.model_id = activity.id AND activity_lang.language_code = ? LEFT JOIN activity_lang activity_lang_default ON activity_lang_default.model_id = activity.id AND activity_lang_default.language_code = ? INNER JOIN event event ON event.activity_id = activity.id WHERE event.id IN (?)
Parameters:
[ "ua" "en" "018ef632-4784-720f-9fc4-35fbed2f6b1c" ] |
0.98 ms (0.29%) |
1 |
SELECT activity.id as id, activity.external_id as external_id, activity.sticker_id as sticker_id, activity.sticker_activity_time_from as sticker_activity_time_from, activity.sticker_activity_time_to as sticker_activity_time_to, activity_lang.name as name, activity_lang.description as description, activity_lang_default.name as default_name, activity_lang_default.description as default_description, activity_lang.sticker_description as sticker_description, activity_lang_default.sticker_description as default_sticker_description, event.id as event_id FROM activity LEFT JOIN activity_lang activity_lang ON activity_lang.model_id = activity.id AND activity_lang.language_code = ? LEFT JOIN activity_lang activity_lang_default ON activity_lang_default.model_id = activity.id AND activity_lang_default.language_code = ? INNER JOIN event event ON event.activity_id = activity.id WHERE event.id =? LIMIT 1
Parameters:
[ "ua" "en" "018ef632-4784-720f-9fc4-35fbed2f6b1c" ] |
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.