Query Metrics
103
Database Queries
22
Different statements
60.03 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.16 ms |
SELECT h0_.id AS id_0, h0_.created AS created_1, h0_.updated AS updated_2, h0_.position AS position_3, h0_.headline1 AS headline1_4, h0_.headline2 AS headline2_5, h0_.subline AS subline_6, h0_.link AS link_7, h0_.youtube AS youtube_8, h0_.is_active AS is_active_9, h0_.locale AS locale_10, h0_.user_id AS user_id_11, h0_.asset_id AS asset_id_12 FROM home_banner h0_ WHERE h0_.locale = ? AND h0_.is_active = 1 ORDER BY h0_.position ASC, h0_.id ASC
Parameters:
[
"nl"
]
|
| 2 | 8.13 ms |
SELECT n0_.id AS id_0, n0_.created AS created_1, n0_.updated AS updated_2, n0_.title AS title_3, n0_.subtitle AS subtitle_4, n0_.introduction AS introduction_5, n0_.text AS text_6, n0_.source AS source_7, n0_.author AS author_8, n0_.is_active AS is_active_9, n0_.pub_date AS pub_date_10, n0_.home AS home_11, n0_.in_newsletter AS in_newsletter_12, n0_.in_kabinetsmail AS in_kabinetsmail_13, n0_.newsletter_sended AS newsletter_sended_14, n0_.is_izimi AS is_izimi_15, n0_.spotlight AS spotlight_16, n0_.locale AS locale_17, n0_.is_pers AS is_pers_18, n0_.slug AS slug_19, n0_.is_reduced AS is_reduced_20, n0_.count_clicked AS count_clicked_21, n0_.user_id AS user_id_22, n0_.asset_id AS asset_id_23, n0_.meta_id AS meta_id_24, n0_.first_paragraph_asset_id AS first_paragraph_asset_id_25 FROM news n0_ WHERE n0_.locale = ? AND n0_.home = 1 AND n0_.is_active = 1 AND n0_.pub_date <= ? ORDER BY n0_.spotlight DESC, n0_.pub_date DESC, n0_.id DESC LIMIT 3
Parameters:
[ "nl" "2026-10-22 00:00:00" ] |
| 3 | 1.48 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.locale AS locale_4, t0.title AS title_5, t0.subtitle AS subtitle_6, t0.answer AS answer_7, t0.is_active AS is_active_8, t0.pub_date AS pub_date_9, t0.is_general AS is_general_10, t0.count_clicked AS count_clicked_11, t0.slug AS slug_12, t0.show_in_subsite AS show_in_subsite_13, t0.user_id AS user_id_14, t0.asset_id AS asset_id_15, t0.news_id AS news_id_16, t0.meta_id AS meta_id_17 FROM faq t0 WHERE t0.news_id = ?
Parameters:
[
2497
]
|
| 4 | 1.33 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.locale AS locale_4, t0.title AS title_5, t0.slug AS slug_6, t0.description AS description_7, t0.minutes AS minutes_8, t0.source AS source_9, t0.is_active AS is_active_10, t0.pub_date AS pub_date_11, t0.is_varia AS is_varia_12, t0.is_varia_primary AS is_varia_primary_13, t0.varia_position AS varia_position_14, t0.is_izimi AS is_izimi_15, t0.count_clicked AS count_clicked_16, t0.user_id AS user_id_17, t0.asset_id AS asset_id_18, t0.news_id AS news_id_19, t0.news_izimi_info_id AS news_izimi_info_id_20, t0.primary_subsite AS primary_subsite_21, t0.meta_id AS meta_id_22 FROM video t0 WHERE t0.news_id = ?
Parameters:
[
2497
]
|
| 5 | 1.30 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.locale AS locale_4, t0.title AS title_5, t0.description AS description_6, t0.pages AS pages_7, t0.edition AS edition_8, t0.count_clicked AS count_clicked_9, t0.publisher AS publisher_10, t0.is_active AS is_active_11, t0.pub_date AS pub_date_12, t0.is_general AS is_general_13, t0.general_position AS general_position_14, t0.is_general_primary AS is_general_primary_15, t0.is_izimi AS is_izimi_16, t0.brochureType AS brochureType_17, t0.user_id AS user_id_18, t0.asset_id AS asset_id_19, t0.primary_subsite AS primary_subsite_20, t0.news_id AS news_id_21 FROM brochure t0 WHERE t0.news_id = ?
Parameters:
[
2497
]
|
| 6 | 0.53 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.locale AS locale_4, t0.title AS title_5, t0.subtitle AS subtitle_6, t0.answer AS answer_7, t0.is_active AS is_active_8, t0.pub_date AS pub_date_9, t0.is_general AS is_general_10, t0.count_clicked AS count_clicked_11, t0.slug AS slug_12, t0.show_in_subsite AS show_in_subsite_13, t0.user_id AS user_id_14, t0.asset_id AS asset_id_15, t0.news_id AS news_id_16, t0.meta_id AS meta_id_17 FROM faq t0 WHERE t0.news_id = ?
Parameters:
[
2500
]
|
| 7 | 0.45 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.locale AS locale_4, t0.title AS title_5, t0.slug AS slug_6, t0.description AS description_7, t0.minutes AS minutes_8, t0.source AS source_9, t0.is_active AS is_active_10, t0.pub_date AS pub_date_11, t0.is_varia AS is_varia_12, t0.is_varia_primary AS is_varia_primary_13, t0.varia_position AS varia_position_14, t0.is_izimi AS is_izimi_15, t0.count_clicked AS count_clicked_16, t0.user_id AS user_id_17, t0.asset_id AS asset_id_18, t0.news_id AS news_id_19, t0.news_izimi_info_id AS news_izimi_info_id_20, t0.primary_subsite AS primary_subsite_21, t0.meta_id AS meta_id_22 FROM video t0 WHERE t0.news_id = ?
Parameters:
[
2500
]
|
| 8 | 0.26 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.locale AS locale_4, t0.title AS title_5, t0.description AS description_6, t0.pages AS pages_7, t0.edition AS edition_8, t0.count_clicked AS count_clicked_9, t0.publisher AS publisher_10, t0.is_active AS is_active_11, t0.pub_date AS pub_date_12, t0.is_general AS is_general_13, t0.general_position AS general_position_14, t0.is_general_primary AS is_general_primary_15, t0.is_izimi AS is_izimi_16, t0.brochureType AS brochureType_17, t0.user_id AS user_id_18, t0.asset_id AS asset_id_19, t0.primary_subsite AS primary_subsite_20, t0.news_id AS news_id_21 FROM brochure t0 WHERE t0.news_id = ?
Parameters:
[
2500
]
|
| 9 | 0.29 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.locale AS locale_4, t0.title AS title_5, t0.subtitle AS subtitle_6, t0.answer AS answer_7, t0.is_active AS is_active_8, t0.pub_date AS pub_date_9, t0.is_general AS is_general_10, t0.count_clicked AS count_clicked_11, t0.slug AS slug_12, t0.show_in_subsite AS show_in_subsite_13, t0.user_id AS user_id_14, t0.asset_id AS asset_id_15, t0.news_id AS news_id_16, t0.meta_id AS meta_id_17 FROM faq t0 WHERE t0.news_id = ?
Parameters:
[
2499
]
|
| 10 | 0.26 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.locale AS locale_4, t0.title AS title_5, t0.slug AS slug_6, t0.description AS description_7, t0.minutes AS minutes_8, t0.source AS source_9, t0.is_active AS is_active_10, t0.pub_date AS pub_date_11, t0.is_varia AS is_varia_12, t0.is_varia_primary AS is_varia_primary_13, t0.varia_position AS varia_position_14, t0.is_izimi AS is_izimi_15, t0.count_clicked AS count_clicked_16, t0.user_id AS user_id_17, t0.asset_id AS asset_id_18, t0.news_id AS news_id_19, t0.news_izimi_info_id AS news_izimi_info_id_20, t0.primary_subsite AS primary_subsite_21, t0.meta_id AS meta_id_22 FROM video t0 WHERE t0.news_id = ?
Parameters:
[
2499
]
|
| 11 | 0.24 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.locale AS locale_4, t0.title AS title_5, t0.description AS description_6, t0.pages AS pages_7, t0.edition AS edition_8, t0.count_clicked AS count_clicked_9, t0.publisher AS publisher_10, t0.is_active AS is_active_11, t0.pub_date AS pub_date_12, t0.is_general AS is_general_13, t0.general_position AS general_position_14, t0.is_general_primary AS is_general_primary_15, t0.is_izimi AS is_izimi_16, t0.brochureType AS brochureType_17, t0.user_id AS user_id_18, t0.asset_id AS asset_id_19, t0.primary_subsite AS primary_subsite_20, t0.news_id AS news_id_21 FROM brochure t0 WHERE t0.news_id = ?
Parameters:
[
2499
]
|
| 12 | 1.46 ms |
SELECT m0_.id AS id_0, m0_.column_type AS column_type_1, m0_.position_column AS position_column_2, m0_.position AS position_3, m0_.locale AS locale_4, m0_.link_id AS link_id_5 FROM module_links m0_ INNER JOIN fednot_links f1_ ON m0_.link_id = f1_.id WHERE m0_.column_type = ? AND m0_.position_column = ? AND f1_.is_active = ? AND m0_.locale = ? ORDER BY m0_.position ASC
Parameters:
[ "home1" "L" 1 "nl" ] |
| 13 | 0.57 ms |
SELECT m0_.id AS id_0, m0_.column_type AS column_type_1, m0_.position_column AS position_column_2, m0_.position AS position_3, m0_.locale AS locale_4, m0_.link_id AS link_id_5 FROM module_links m0_ INNER JOIN fednot_links f1_ ON m0_.link_id = f1_.id WHERE m0_.column_type = ? AND m0_.position_column = ? AND f1_.is_active = ? AND m0_.locale = ? ORDER BY m0_.position ASC
Parameters:
[ "home1" "C" 1 "nl" ] |
| 14 | 0.30 ms |
SELECT m0_.id AS id_0, m0_.column_type AS column_type_1, m0_.position_column AS position_column_2, m0_.position AS position_3, m0_.locale AS locale_4, m0_.link_id AS link_id_5 FROM module_links m0_ INNER JOIN fednot_links f1_ ON m0_.link_id = f1_.id WHERE m0_.column_type = ? AND m0_.position_column = ? AND f1_.is_active = ? AND m0_.locale = ? ORDER BY m0_.position ASC
Parameters:
[ "home1" "R" 1 "nl" ] |
| 15 | 0.29 ms |
SELECT m0_.id AS id_0, m0_.column_type AS column_type_1, m0_.position_column AS position_column_2, m0_.position AS position_3, m0_.locale AS locale_4, m0_.link_id AS link_id_5 FROM module_links m0_ INNER JOIN fednot_links f1_ ON m0_.link_id = f1_.id WHERE m0_.column_type = ? AND m0_.position_column = ? AND f1_.is_active = ? AND m0_.locale = ? ORDER BY m0_.position ASC
Parameters:
[ "home2" "L" 1 "nl" ] |
| 16 | 0.33 ms |
SELECT m0_.id AS id_0, m0_.column_type AS column_type_1, m0_.position_column AS position_column_2, m0_.position AS position_3, m0_.locale AS locale_4, m0_.link_id AS link_id_5 FROM module_links m0_ INNER JOIN fednot_links f1_ ON m0_.link_id = f1_.id WHERE m0_.column_type = ? AND m0_.position_column = ? AND f1_.is_active = ? AND m0_.locale = ? ORDER BY m0_.position ASC
Parameters:
[ "home2" "C" 1 "nl" ] |
| 17 | 0.37 ms |
SELECT m0_.id AS id_0, m0_.column_type AS column_type_1, m0_.position_column AS position_column_2, m0_.position AS position_3, m0_.locale AS locale_4, m0_.link_id AS link_id_5 FROM module_links m0_ INNER JOIN fednot_links f1_ ON m0_.link_id = f1_.id WHERE m0_.column_type = ? AND m0_.position_column = ? AND f1_.is_active = ? AND m0_.locale = ? ORDER BY m0_.position ASC
Parameters:
[ "home2" "R" 1 "nl" ] |
| 18 | 0.30 ms |
SELECT m0_.id AS id_0, m0_.column_type AS column_type_1, m0_.position_column AS position_column_2, m0_.position AS position_3, m0_.locale AS locale_4, m0_.link_id AS link_id_5 FROM module_links m0_ INNER JOIN fednot_links f1_ ON m0_.link_id = f1_.id WHERE m0_.column_type = ? AND m0_.position_column = ? AND f1_.is_active = ? AND m0_.locale = ? ORDER BY m0_.position ASC
Parameters:
[ "home3" "L" 1 "nl" ] |
| 19 | 0.27 ms |
SELECT m0_.id AS id_0, m0_.column_type AS column_type_1, m0_.position_column AS position_column_2, m0_.position AS position_3, m0_.locale AS locale_4, m0_.link_id AS link_id_5 FROM module_links m0_ INNER JOIN fednot_links f1_ ON m0_.link_id = f1_.id WHERE m0_.column_type = ? AND m0_.position_column = ? AND f1_.is_active = ? AND m0_.locale = ? ORDER BY m0_.position ASC
Parameters:
[ "home3" "C" 1 "nl" ] |
| 20 | 0.28 ms |
SELECT m0_.id AS id_0, m0_.column_type AS column_type_1, m0_.position_column AS position_column_2, m0_.position AS position_3, m0_.locale AS locale_4, m0_.link_id AS link_id_5 FROM module_links m0_ INNER JOIN fednot_links f1_ ON m0_.link_id = f1_.id WHERE m0_.column_type = ? AND m0_.position_column = ? AND f1_.is_active = ? AND m0_.locale = ? ORDER BY m0_.position ASC
Parameters:
[ "home3" "R" 1 "nl" ] |
| 21 | 0.81 ms |
SELECT v0_.id AS id_0, v0_.created AS created_1, v0_.updated AS updated_2, v0_.locale AS locale_3, v0_.title AS title_4, v0_.slug AS slug_5, v0_.description AS description_6, v0_.minutes AS minutes_7, v0_.source AS source_8, v0_.is_active AS is_active_9, v0_.pub_date AS pub_date_10, v0_.is_varia AS is_varia_11, v0_.is_varia_primary AS is_varia_primary_12, v0_.varia_position AS varia_position_13, v0_.is_izimi AS is_izimi_14, v0_.count_clicked AS count_clicked_15, v0_.user_id AS user_id_16, v0_.asset_id AS asset_id_17, v0_.news_id AS news_id_18, v0_.news_izimi_info_id AS news_izimi_info_id_19, v0_.primary_subsite AS primary_subsite_20, v0_.meta_id AS meta_id_21 FROM video v0_ WHERE v0_.locale = ? AND v0_.is_active = 1 AND v0_.pub_date <= ? ORDER BY v0_.pub_date DESC LIMIT 1
Parameters:
[ "nl" "2026-10-22 13:43:01" ] |
| 22 | 1.28 ms |
select s.id, s.slug, s.page_title, s.oneliner, s.stylesheet, i.filename from subsite as s inner join subsite_banner as sb ON sb.subsite_id = s.id inner join ( SELECT min(position) min_position, subsite_id FROM subsite_banner WHERE is_active =1 GROUP BY subsite_id) as b on b.subsite_id = s.id and b.min_position = sb.position and sb.is_active = 1 inner join asset_image as ai on sb.asset_id = ai.asset_id inner join image as i on i.id = ai.image_id where s.locale = :locale and (s.in_main_nav = 1 or s.slug = :slug) and s.is_active= 1 group by s.id order by s.position
Parameters:
[ "locale" => "nl" "slug" => "notaris" ] |
| 23 | 1.17 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.title AS title_4, t0.description AS description_5, t0.subarea AS subarea_6, t0.talentsquare_id AS talentsquare_id_7, t0.total AS total_8, t0.locale AS locale_9, t0.published_at AS published_at_10, t0.employer_name AS employer_name_11, t0.employer_url AS employer_url_12, t0.address AS address_13, t0.city AS city_14, t0.area AS area_15, t0.zip AS zip_16, t0.country AS country_17 FROM notary_job_general t0 WHERE t0.locale = ?
Parameters:
[
"nl"
]
|
| 24 | 0.77 ms |
SELECT t0.id AS id_1, t0.item AS item_2, t0.sven_id AS sven_id_3, t0.value AS value_4, t0.locale AS locale_5 FROM general t0 WHERE t0.item = ? LIMIT 1
Parameters:
[
"totalImmos"
]
|
| 25 | 2.04 ms |
SELECT `filename` FROM sven_immo i WHERE i.is_active = :active AND filename IS NOT NULL AND filename != '' ORDER BY RAND() LIMIT 1
Parameters:
[ "active" => 1 ] |
| 26 | 0.43 ms |
SELECT s0_.id AS id_0, s0_.locale AS locale_1, s0_.name AS name_2, s0_.slug AS slug_3, s0_.stylesheet AS stylesheet_4, s0_.in_main_nav AS in_main_nav_5, s0_.is_active AS is_active_6, s0_.position AS position_7, s0_.oneliner AS oneliner_8, s0_.welcome_text AS welcome_text_9, s0_.directory AS directory_10, s0_.page_title AS page_title_11, s0_.type AS type_12, s0_.meta_id AS meta_id_13, s0_.language_link_subsite_id AS language_link_subsite_id_14 FROM subsite s0_ WHERE s0_.locale = ? AND s0_.in_main_nav = 1 AND s0_.is_active = 1 ORDER BY s0_.position ASC
Parameters:
[
"nl"
]
|
| 27 | 1.72 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.navigation AS navigation_4, t0.slug AS slug_5, t0.is_active AS is_active_6, t0.pub_date AS pub_date_7, t0.show_navigation AS show_navigation_8, t0.title AS title_9, t0.description AS description_10, t0.position AS position_11, t0.not_delete AS not_delete_12, t0.redirect_url AS redirect_url_13, t0.user_id AS user_id_14, t0.asset_id AS asset_id_15, t0.subsite_id AS subsite_id_16, t0.parent_id AS parent_id_17, t0.meta_id AS meta_id_18 FROM section t0 WHERE t0.subsite_id = ? ORDER BY t0.position ASC
Parameters:
[
57
]
|
| 28 | 0.90 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.navigation AS navigation_4, t0.slug AS slug_5, t0.is_active AS is_active_6, t0.pub_date AS pub_date_7, t0.show_navigation AS show_navigation_8, t0.title AS title_9, t0.description AS description_10, t0.position AS position_11, t0.not_delete AS not_delete_12, t0.redirect_url AS redirect_url_13, t0.user_id AS user_id_14, t0.asset_id AS asset_id_15, t0.subsite_id AS subsite_id_16, t0.parent_id AS parent_id_17, t0.meta_id AS meta_id_18 FROM section t0 WHERE t0.subsite_id = ? ORDER BY t0.position ASC
Parameters:
[
76
]
|
| 29 | 0.63 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.navigation AS navigation_4, t0.slug AS slug_5, t0.is_active AS is_active_6, t0.pub_date AS pub_date_7, t0.show_navigation AS show_navigation_8, t0.title AS title_9, t0.description AS description_10, t0.position AS position_11, t0.not_delete AS not_delete_12, t0.redirect_url AS redirect_url_13, t0.user_id AS user_id_14, t0.asset_id AS asset_id_15, t0.subsite_id AS subsite_id_16, t0.parent_id AS parent_id_17, t0.meta_id AS meta_id_18 FROM section t0 WHERE t0.subsite_id = ? ORDER BY t0.position ASC
Parameters:
[
59
]
|
| 30 | 0.59 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.navigation AS navigation_4, t0.slug AS slug_5, t0.is_active AS is_active_6, t0.pub_date AS pub_date_7, t0.show_navigation AS show_navigation_8, t0.title AS title_9, t0.description AS description_10, t0.position AS position_11, t0.not_delete AS not_delete_12, t0.redirect_url AS redirect_url_13, t0.user_id AS user_id_14, t0.asset_id AS asset_id_15, t0.subsite_id AS subsite_id_16, t0.parent_id AS parent_id_17, t0.meta_id AS meta_id_18 FROM section t0 WHERE t0.subsite_id = ? ORDER BY t0.position ASC
Parameters:
[
60
]
|
| 31 | 0.55 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.navigation AS navigation_4, t0.slug AS slug_5, t0.is_active AS is_active_6, t0.pub_date AS pub_date_7, t0.show_navigation AS show_navigation_8, t0.title AS title_9, t0.description AS description_10, t0.position AS position_11, t0.not_delete AS not_delete_12, t0.redirect_url AS redirect_url_13, t0.user_id AS user_id_14, t0.asset_id AS asset_id_15, t0.subsite_id AS subsite_id_16, t0.parent_id AS parent_id_17, t0.meta_id AS meta_id_18 FROM section t0 WHERE t0.subsite_id = ? ORDER BY t0.position ASC
Parameters:
[
61
]
|
| 32 | 0.50 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.navigation AS navigation_4, t0.slug AS slug_5, t0.is_active AS is_active_6, t0.pub_date AS pub_date_7, t0.show_navigation AS show_navigation_8, t0.title AS title_9, t0.description AS description_10, t0.position AS position_11, t0.not_delete AS not_delete_12, t0.redirect_url AS redirect_url_13, t0.user_id AS user_id_14, t0.asset_id AS asset_id_15, t0.subsite_id AS subsite_id_16, t0.parent_id AS parent_id_17, t0.meta_id AS meta_id_18 FROM section t0 WHERE t0.subsite_id = ? ORDER BY t0.position ASC
Parameters:
[
62
]
|
| 33 | 0.57 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.navigation AS navigation_4, t0.slug AS slug_5, t0.is_active AS is_active_6, t0.pub_date AS pub_date_7, t0.show_navigation AS show_navigation_8, t0.title AS title_9, t0.description AS description_10, t0.position AS position_11, t0.not_delete AS not_delete_12, t0.redirect_url AS redirect_url_13, t0.user_id AS user_id_14, t0.asset_id AS asset_id_15, t0.subsite_id AS subsite_id_16, t0.parent_id AS parent_id_17, t0.meta_id AS meta_id_18 FROM section t0 WHERE t0.subsite_id = ? ORDER BY t0.position ASC
Parameters:
[
65
]
|
| 34 | 0.50 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.navigation AS navigation_4, t0.slug AS slug_5, t0.is_active AS is_active_6, t0.pub_date AS pub_date_7, t0.show_navigation AS show_navigation_8, t0.title AS title_9, t0.description AS description_10, t0.position AS position_11, t0.not_delete AS not_delete_12, t0.redirect_url AS redirect_url_13, t0.user_id AS user_id_14, t0.asset_id AS asset_id_15, t0.subsite_id AS subsite_id_16, t0.parent_id AS parent_id_17, t0.meta_id AS meta_id_18 FROM section t0 WHERE t0.subsite_id = ? ORDER BY t0.position ASC
Parameters:
[
66
]
|
| 35 | 0.99 ms |
SELECT t0.id AS id_1 FROM asset t0 WHERE t0.id = ?
Parameters:
[
50537
]
|
| 36 | 0.40 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.asset_id AS asset_id_3, t0.image_id AS image_id_4 FROM asset_image t0 WHERE t0.asset_id = ? ORDER BY t0.position ASC
Parameters:
[
50537
]
|
| 37 | 0.56 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.caption AS caption_3, t0.alt AS alt_4, t0.url AS url_5, t0.locale AS locale_6, t0.is_full AS is_full_7, t0.created AS created_8, t0.user_id AS user_id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
37934
]
|
| 38 | 0.25 ms |
SELECT t0.id AS id_1 FROM asset t0 WHERE t0.id = ?
Parameters:
[
49944
]
|
| 39 | 0.32 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.asset_id AS asset_id_3, t0.image_id AS image_id_4 FROM asset_image t0 WHERE t0.asset_id = ? ORDER BY t0.position ASC
Parameters:
[
49944
]
|
| 40 | 0.23 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.caption AS caption_3, t0.alt AS alt_4, t0.url AS url_5, t0.locale AS locale_6, t0.is_full AS is_full_7, t0.created AS created_8, t0.user_id AS user_id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
37679
]
|
| 41 | 0.21 ms |
SELECT t0.id AS id_1 FROM asset t0 WHERE t0.id = ?
Parameters:
[
49130
]
|
| 42 | 0.22 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.asset_id AS asset_id_3, t0.image_id AS image_id_4 FROM asset_image t0 WHERE t0.asset_id = ? ORDER BY t0.position ASC
Parameters:
[
49130
]
|
| 43 | 0.22 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.caption AS caption_3, t0.alt AS alt_4, t0.url AS url_5, t0.locale AS locale_6, t0.is_full AS is_full_7, t0.created AS created_8, t0.user_id AS user_id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
37241
]
|
| 44 | 0.30 ms |
SELECT t0.id AS id_1 FROM asset t0 WHERE t0.id = ?
Parameters:
[
48751
]
|
| 45 | 0.23 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.asset_id AS asset_id_3, t0.image_id AS image_id_4 FROM asset_image t0 WHERE t0.asset_id = ? ORDER BY t0.position ASC
Parameters:
[
48751
]
|
| 46 | 0.21 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.caption AS caption_3, t0.alt AS alt_4, t0.url AS url_5, t0.locale AS locale_6, t0.is_full AS is_full_7, t0.created AS created_8, t0.user_id AS user_id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
37031
]
|
| 47 | 0.22 ms |
SELECT t0.id AS id_1 FROM asset t0 WHERE t0.id = ?
Parameters:
[
48466
]
|
| 48 | 0.24 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.asset_id AS asset_id_3, t0.image_id AS image_id_4 FROM asset_image t0 WHERE t0.asset_id = ? ORDER BY t0.position ASC
Parameters:
[
48466
]
|
| 49 | 0.24 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.caption AS caption_3, t0.alt AS alt_4, t0.url AS url_5, t0.locale AS locale_6, t0.is_full AS is_full_7, t0.created AS created_8, t0.user_id AS user_id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
36851
]
|
| 50 | 0.37 ms |
SELECT t0.id AS id_1 FROM asset t0 WHERE t0.id = ?
Parameters:
[
46993
]
|
| 51 | 0.23 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.asset_id AS asset_id_3, t0.image_id AS image_id_4 FROM asset_image t0 WHERE t0.asset_id = ? ORDER BY t0.position ASC
Parameters:
[
46993
]
|
| 52 | 0.22 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.caption AS caption_3, t0.alt AS alt_4, t0.url AS url_5, t0.locale AS locale_6, t0.is_full AS is_full_7, t0.created AS created_8, t0.user_id AS user_id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
36206
]
|
| 53 | 0.21 ms |
SELECT t0.id AS id_1 FROM asset t0 WHERE t0.id = ?
Parameters:
[
36374
]
|
| 54 | 0.25 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.asset_id AS asset_id_3, t0.image_id AS image_id_4 FROM asset_image t0 WHERE t0.asset_id = ? ORDER BY t0.position ASC
Parameters:
[
36374
]
|
| 55 | 0.22 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.caption AS caption_3, t0.alt AS alt_4, t0.url AS url_5, t0.locale AS locale_6, t0.is_full AS is_full_7, t0.created AS created_8, t0.user_id AS user_id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
31697
]
|
| 56 | 0.19 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.is_active AS is_active_3, t0.is_sven AS is_sven_4 FROM fednot_links t0 WHERE t0.id = ?
Parameters:
[
15
]
|
| 57 | 0.16 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.is_active AS is_active_3, t0.is_sven AS is_sven_4 FROM fednot_links t0 WHERE t0.id = ?
Parameters:
[
9
]
|
| 58 | 0.17 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.is_active AS is_active_3, t0.is_sven AS is_sven_4 FROM fednot_links t0 WHERE t0.id = ?
Parameters:
[
19
]
|
| 59 | 0.23 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.is_active AS is_active_3, t0.is_sven AS is_sven_4 FROM fednot_links t0 WHERE t0.id = ?
Parameters:
[
8
]
|
| 60 | 0.16 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.is_active AS is_active_3, t0.is_sven AS is_sven_4 FROM fednot_links t0 WHERE t0.id = ?
Parameters:
[
18
]
|
| 61 | 0.18 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.is_active AS is_active_3, t0.is_sven AS is_sven_4 FROM fednot_links t0 WHERE t0.id = ?
Parameters:
[
10
]
|
| 62 | 0.17 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.is_active AS is_active_3, t0.is_sven AS is_sven_4 FROM fednot_links t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 63 | 0.17 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.is_active AS is_active_3, t0.is_sven AS is_sven_4 FROM fednot_links t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 64 | 0.18 ms |
SELECT t0.id AS id_1 FROM asset t0 WHERE t0.id = ?
Parameters:
[
50658
]
|
| 65 | 0.21 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.asset_id AS asset_id_3, t0.image_id AS image_id_4 FROM asset_image t0 WHERE t0.asset_id = ? ORDER BY t0.position ASC
Parameters:
[
50658
]
|
| 66 | 0.17 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.caption AS caption_3, t0.alt AS alt_4, t0.url AS url_5, t0.locale AS locale_6, t0.is_full AS is_full_7, t0.created AS created_8, t0.user_id AS user_id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
37974
]
|
| 67 | 0.85 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.asset_id AS asset_id_3, t0.video_path_id AS video_path_id_4 FROM asset_video_path t0 WHERE t0.asset_id = ? ORDER BY t0.position ASC
Parameters:
[
50658
]
|
| 68 | 0.67 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.asset_id AS asset_id_3, t0.link_id AS link_id_4 FROM asset_link t0 WHERE t0.asset_id = ? ORDER BY t0.position ASC
Parameters:
[
50658
]
|
| 69 | 0.69 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.asset_id AS asset_id_3, t0.attachment_id AS attachment_id_4 FROM asset_attachment t0 WHERE t0.asset_id = ? ORDER BY t0.position ASC
Parameters:
[
50658
]
|
| 70 | 0.68 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.count_clicked AS count_clicked_6, t0.created AS created_7, t0.updated AS updated_8, t0.user_id AS user_id_9 FROM tag t0 INNER JOIN tag_news ON t0.id = tag_news.tag_id WHERE tag_news.news_id = ?
Parameters:
[
2497
]
|
| 71 | 0.27 ms |
SELECT t0.id AS id_1 FROM asset t0 WHERE t0.id = ?
Parameters:
[
50719
]
|
| 72 | 0.27 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.asset_id AS asset_id_3, t0.image_id AS image_id_4 FROM asset_image t0 WHERE t0.asset_id = ? ORDER BY t0.position ASC
Parameters:
[
50719
]
|
| 73 | 0.25 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.caption AS caption_3, t0.alt AS alt_4, t0.url AS url_5, t0.locale AS locale_6, t0.is_full AS is_full_7, t0.created AS created_8, t0.user_id AS user_id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
38023
]
|
| 74 | 0.23 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.asset_id AS asset_id_3, t0.video_path_id AS video_path_id_4 FROM asset_video_path t0 WHERE t0.asset_id = ? ORDER BY t0.position ASC
Parameters:
[
50719
]
|
| 75 | 0.26 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.asset_id AS asset_id_3, t0.link_id AS link_id_4 FROM asset_link t0 WHERE t0.asset_id = ? ORDER BY t0.position ASC
Parameters:
[
50719
]
|
| 76 | 0.26 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.asset_id AS asset_id_3, t0.attachment_id AS attachment_id_4 FROM asset_attachment t0 WHERE t0.asset_id = ? ORDER BY t0.position ASC
Parameters:
[
50719
]
|
| 77 | 0.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.count_clicked AS count_clicked_6, t0.created AS created_7, t0.updated AS updated_8, t0.user_id AS user_id_9 FROM tag t0 INNER JOIN tag_news ON t0.id = tag_news.tag_id WHERE tag_news.news_id = ?
Parameters:
[
2500
]
|
| 78 | 0.22 ms |
SELECT t0.id AS id_1 FROM asset t0 WHERE t0.id = ?
Parameters:
[
50716
]
|
| 79 | 0.27 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.asset_id AS asset_id_3, t0.image_id AS image_id_4 FROM asset_image t0 WHERE t0.asset_id = ? ORDER BY t0.position ASC
Parameters:
[
50716
]
|
| 80 | 0.24 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.caption AS caption_3, t0.alt AS alt_4, t0.url AS url_5, t0.locale AS locale_6, t0.is_full AS is_full_7, t0.created AS created_8, t0.user_id AS user_id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
38021
]
|
| 81 | 0.25 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.asset_id AS asset_id_3, t0.video_path_id AS video_path_id_4 FROM asset_video_path t0 WHERE t0.asset_id = ? ORDER BY t0.position ASC
Parameters:
[
50716
]
|
| 82 | 0.46 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.asset_id AS asset_id_3, t0.link_id AS link_id_4 FROM asset_link t0 WHERE t0.asset_id = ? ORDER BY t0.position ASC
Parameters:
[
50716
]
|
| 83 | 0.25 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.asset_id AS asset_id_3, t0.attachment_id AS attachment_id_4 FROM asset_attachment t0 WHERE t0.asset_id = ? ORDER BY t0.position ASC
Parameters:
[
50716
]
|
| 84 | 0.32 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.count_clicked AS count_clicked_6, t0.created AS created_7, t0.updated AS updated_8, t0.user_id AS user_id_9 FROM tag t0 INNER JOIN tag_news ON t0.id = tag_news.tag_id WHERE tag_news.news_id = ?
Parameters:
[
2499
]
|
| 85 | 1.01 ms |
SELECT t0.id AS id_1 FROM asset t0 WHERE t0.id = ?
Parameters:
[
35498
]
|
| 86 | 0.78 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.asset_id AS asset_id_3, t0.image_id AS image_id_4 FROM asset_image t0 WHERE t0.asset_id = ? ORDER BY t0.position ASC
Parameters:
[
35498
]
|
| 87 | 0.63 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.caption AS caption_3, t0.alt AS alt_4, t0.url AS url_5, t0.locale AS locale_6, t0.is_full AS is_full_7, t0.created AS created_8, t0.user_id AS user_id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
31443
]
|
| 88 | 0.62 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.is_active AS is_active_3, t0.is_sven AS is_sven_4 FROM fednot_links t0 WHERE t0.id = ?
Parameters:
[
14
]
|
| 89 | 0.34 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.is_active AS is_active_3, t0.is_sven AS is_sven_4 FROM fednot_links t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 90 | 0.49 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.is_active AS is_active_3, t0.is_sven AS is_sven_4 FROM fednot_links t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 91 | 0.33 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.is_active AS is_active_3, t0.is_sven AS is_sven_4 FROM fednot_links t0 WHERE t0.id = ?
Parameters:
[
20
]
|
| 92 | 0.24 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.is_active AS is_active_3, t0.is_sven AS is_sven_4 FROM fednot_links t0 WHERE t0.id = ?
Parameters:
[
6
]
|
| 93 | 0.18 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.is_active AS is_active_3, t0.is_sven AS is_sven_4 FROM fednot_links t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 94 | 0.19 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.is_active AS is_active_3, t0.is_sven AS is_sven_4 FROM fednot_links t0 WHERE t0.id = ?
Parameters:
[
11
]
|
| 95 | 0.37 ms |
SELECT s0_.id AS id_0, s0_.locale AS locale_1, s0_.name AS name_2, s0_.slug AS slug_3, s0_.stylesheet AS stylesheet_4, s0_.in_main_nav AS in_main_nav_5, s0_.is_active AS is_active_6, s0_.position AS position_7, s0_.oneliner AS oneliner_8, s0_.welcome_text AS welcome_text_9, s0_.directory AS directory_10, s0_.page_title AS page_title_11, s0_.type AS type_12, s0_.meta_id AS meta_id_13, s0_.language_link_subsite_id AS language_link_subsite_id_14 FROM subsite s0_ WHERE s0_.locale = ? AND s0_.in_main_nav = 1 AND s0_.is_active = 1 ORDER BY s0_.position ASC
Parameters:
[
"nl"
]
|
| 96 | 1.39 ms |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.slug AS slug_3, t0_.locale AS locale_4, t0_.count_clicked AS count_clicked_5, t0_.created AS created_6, t0_.updated AS updated_7, t0_.user_id AS user_id_8 FROM tag t0_ LEFT JOIN tag_subsite t2_ ON t0_.id = t2_.tag_id LEFT JOIN subsite s1_ ON s1_.id = t2_.subsite_id WHERE s1_.id = ? ORDER BY t0_.count_clicked DESC LIMIT 7
Parameters:
[
57
]
|
| 97 | 0.97 ms |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.slug AS slug_3, t0_.locale AS locale_4, t0_.count_clicked AS count_clicked_5, t0_.created AS created_6, t0_.updated AS updated_7, t0_.user_id AS user_id_8 FROM tag t0_ LEFT JOIN tag_subsite t2_ ON t0_.id = t2_.tag_id LEFT JOIN subsite s1_ ON s1_.id = t2_.subsite_id WHERE s1_.id = ? ORDER BY t0_.count_clicked DESC LIMIT 7
Parameters:
[
76
]
|
| 98 | 1.34 ms |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.slug AS slug_3, t0_.locale AS locale_4, t0_.count_clicked AS count_clicked_5, t0_.created AS created_6, t0_.updated AS updated_7, t0_.user_id AS user_id_8 FROM tag t0_ LEFT JOIN tag_subsite t2_ ON t0_.id = t2_.tag_id LEFT JOIN subsite s1_ ON s1_.id = t2_.subsite_id WHERE s1_.id = ? ORDER BY t0_.count_clicked DESC LIMIT 7
Parameters:
[
59
]
|
| 99 | 0.96 ms |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.slug AS slug_3, t0_.locale AS locale_4, t0_.count_clicked AS count_clicked_5, t0_.created AS created_6, t0_.updated AS updated_7, t0_.user_id AS user_id_8 FROM tag t0_ LEFT JOIN tag_subsite t2_ ON t0_.id = t2_.tag_id LEFT JOIN subsite s1_ ON s1_.id = t2_.subsite_id WHERE s1_.id = ? ORDER BY t0_.count_clicked DESC LIMIT 7
Parameters:
[
60
]
|
| 100 | 0.58 ms |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.slug AS slug_3, t0_.locale AS locale_4, t0_.count_clicked AS count_clicked_5, t0_.created AS created_6, t0_.updated AS updated_7, t0_.user_id AS user_id_8 FROM tag t0_ LEFT JOIN tag_subsite t2_ ON t0_.id = t2_.tag_id LEFT JOIN subsite s1_ ON s1_.id = t2_.subsite_id WHERE s1_.id = ? ORDER BY t0_.count_clicked DESC LIMIT 7
Parameters:
[
61
]
|
| 101 | 0.46 ms |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.slug AS slug_3, t0_.locale AS locale_4, t0_.count_clicked AS count_clicked_5, t0_.created AS created_6, t0_.updated AS updated_7, t0_.user_id AS user_id_8 FROM tag t0_ LEFT JOIN tag_subsite t2_ ON t0_.id = t2_.tag_id LEFT JOIN subsite s1_ ON s1_.id = t2_.subsite_id WHERE s1_.id = ? ORDER BY t0_.count_clicked DESC LIMIT 7
Parameters:
[
62
]
|
| 102 | 0.53 ms |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.slug AS slug_3, t0_.locale AS locale_4, t0_.count_clicked AS count_clicked_5, t0_.created AS created_6, t0_.updated AS updated_7, t0_.user_id AS user_id_8 FROM tag t0_ LEFT JOIN tag_subsite t2_ ON t0_.id = t2_.tag_id LEFT JOIN subsite s1_ ON s1_.id = t2_.subsite_id WHERE s1_.id = ? ORDER BY t0_.count_clicked DESC LIMIT 7
Parameters:
[
65
]
|
| 103 | 0.47 ms |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.slug AS slug_3, t0_.locale AS locale_4, t0_.count_clicked AS count_clicked_5, t0_.created AS created_6, t0_.updated AS updated_7, t0_.user_id AS user_id_8 FROM tag t0_ LEFT JOIN tag_subsite t2_ ON t0_.id = t2_.tag_id LEFT JOIN subsite s1_ ON s1_.id = t2_.subsite_id WHERE s1_.id = ? ORDER BY t0_.count_clicked DESC LIMIT 7
Parameters:
[
66
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| olddatabase | doctrine.dbal.olddatabase_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.