https://notaris.dc-projects.be/

Query Metrics

103 Database Queries
22 Different statements
61.91 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

#▲ Time Info
1 2.06 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 7.41 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.27 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 0.66 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.12 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.58 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.39 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.50 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.50 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.35 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.35 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.50 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.66 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.49 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.61 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.48 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.36 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.34 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.60 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.40 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.83 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 21:01:52"
]
22 2.10 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.32 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.96 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.61 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.59 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 0.87 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 1.06 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.92 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.98 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.61 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.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:
[
  62
]
33 0.77 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.65 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.54 ms
SELECT t0.id AS id_1 FROM asset t0 WHERE t0.id = ?
Parameters:
[
  50537
]
36 0.49 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.62 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.39 ms
SELECT t0.id AS id_1 FROM asset t0 WHERE t0.id = ?
Parameters:
[
  49944
]
39 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:
[
  49944
]
40 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:
[
  37679
]
41 0.34 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.31 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.20 ms
SELECT t0.id AS id_1 FROM asset t0 WHERE t0.id = ?
Parameters:
[
  48751
]
45 0.28 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.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:
[
  37031
]
47 0.24 ms
SELECT t0.id AS id_1 FROM asset t0 WHERE t0.id = ?
Parameters:
[
  48466
]
48 0.31 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.33 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.38 ms
SELECT t0.id AS id_1 FROM asset t0 WHERE t0.id = ?
Parameters:
[
  46993
]
51 0.34 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.28 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.28 ms
SELECT t0.id AS id_1 FROM asset t0 WHERE t0.id = ?
Parameters:
[
  36374
]
54 0.35 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.28 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.30 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.41 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.29 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.25 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.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:
[
  10
]
62 0.21 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.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:
[
  2
]
64 0.49 ms
SELECT t0.id AS id_1 FROM asset t0 WHERE t0.id = ?
Parameters:
[
  50658
]
65 0.36 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.35 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.84 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.76 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.89 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.31 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.28 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.28 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.38 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.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:
[
  50719
]
77 0.30 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.29 ms
SELECT t0.id AS id_1 FROM asset t0 WHERE t0.id = ?
Parameters:
[
  50716
]
79 0.26 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.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:
[
  38021
]
81 0.26 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.25 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.20 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.27 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 0.47 ms
SELECT t0.id AS id_1 FROM asset t0 WHERE t0.id = ?
Parameters:
[
  35498
]
86 0.35 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.28 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.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:
[
  14
]
89 0.21 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.20 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.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:
[
  20
]
92 0.25 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.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:
[
  5
]
94 0.50 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.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"
]
96 1.42 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.64 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 0.60 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.63 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.45 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.44 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.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:
[
  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.

Entities Mapping

Class Mapping errors
Notaris\AdminBundle\Entity\HomeBanner No errors.
Notaris\AdminBundle\Entity\User No errors.
Notaris\AdminBundle\Entity\Asset No errors.
Notaris\AdminBundle\Entity\News No errors.
Notaris\AdminBundle\Entity\Meta No errors.
Notaris\AdminBundle\Entity\Subsite No errors.
Notaris\AdminBundle\Entity\IzimiCategory No errors.
Notaris\AdminBundle\Entity\Faq No errors.
Notaris\AdminBundle\Entity\Video No errors.
Notaris\AdminBundle\Entity\NewsIzimiInfo No errors.
Notaris\AdminBundle\Entity\Brochure No errors.
Notaris\AdminBundle\Entity\Tag No errors.
Notaris\AdminBundle\Entity\NewsParagraph No errors.
Notaris\AdminBundle\Entity\ModuleLinks No errors.
Notaris\AdminBundle\Entity\FednotLinks No errors.
Notaris\AdminBundle\Entity\VideoSubsite No errors.
Notaris\AdminBundle\Entity\NotaryJobGeneral No errors.
Notaris\AdminBundle\Entity\General No errors.
Notaris\AdminBundle\Entity\Immo No errors.
Notaris\AdminBundle\Entity\Section No errors.
Notaris\AdminBundle\Entity\SubsiteBanner No errors.
Notaris\AdminBundle\Entity\SectionParagraph No errors.
Notaris\AdminBundle\Entity\SectionModule No errors.
Notaris\AdminBundle\Entity\AssetImage No errors.
Notaris\AdminBundle\Entity\AssetAttachment No errors.
Notaris\AdminBundle\Entity\AssetLink No errors.
Notaris\AdminBundle\Entity\AssetVideoPath No errors.
Notaris\AdminBundle\Entity\Image No errors.
Notaris\AdminBundle\Entity\VideoPath No errors.
Notaris\AdminBundle\Entity\Link No errors.
Notaris\AdminBundle\Entity\Attachment No errors.
Notaris\AdminBundle\Entity\Glossary No errors.