Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.slug AS slug_2,
  c0_.content AS content_3,
  c0_.editor_mode AS editor_mode_4,
  c0_.builder_data AS builder_data_5,
  c0_.builder_css AS builder_css_6,
  c0_.published AS published_7,
  c0_.publish_at AS publish_at_8,
  c0_.unpublish_at AS unpublish_at_9,
  c0_.caption AS caption_10,
  c0_.seo_title AS seo_title_11,
  c0_.description AS description_12,
  c0_.keywords AS keywords_13,
  c0_.meta AS meta_14,
  c0_.javascript AS javascript_15,
  c0_.canonical AS canonical_16,
  c0_.access AS access_17,
  c0_.follow AS follow_18,
  c0_.home_page AS home_page_19,
  c0_.error_page AS error_page_20,
  c0_.admin_only AS admin_only_21,
  c0_.login_page AS login_page_22,
  c0_.activation_page AS activation_page_23,
  c0_.account_page AS account_page_24,
  c0_.registration_page AS registration_page_25,
  c0_.search_page AS search_page_26,
  c0_.sitemap_page AS sitemap_page_27,
  c0_.profile_page AS profile_page_28,
  c0_.terms_page AS terms_page_29,
  c0_.created_at AS created_at_30,
  c0_.updated_at AS updated_at_31,
  c0_.deleted_at AS deleted_at_32,
  c0_.lock_version AS lock_version_33
FROM
  cms_page c0_
WHERE
  c0_.slug = ?
  AND c0_.deleted_at IS NULL
  AND c0_.published = 1
  AND (
    (
      c0_.publish_at IS NULL
      OR c0_.publish_at <= ?
    )
  )
  AND (
    (
      c0_.unpublish_at IS NULL
      OR c0_.unpublish_at > ?
    )
  )

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.content AS content_3, c0_.editor_mode AS editor_mode_4, c0_.builder_data AS builder_data_5, c0_.builder_css AS builder_css_6, c0_.published AS published_7, c0_.publish_at AS publish_at_8, c0_.unpublish_at AS unpublish_at_9, c0_.caption AS caption_10, c0_.seo_title AS seo_title_11, c0_.description AS description_12, c0_.keywords AS keywords_13, c0_.meta AS meta_14, c0_.javascript AS javascript_15, c0_.canonical AS canonical_16, c0_.access AS access_17, c0_.follow AS follow_18, c0_.home_page AS home_page_19, c0_.error_page AS error_page_20, c0_.admin_only AS admin_only_21, c0_.login_page AS login_page_22, c0_.activation_page AS activation_page_23, c0_.account_page AS account_page_24, c0_.registration_page AS registration_page_25, c0_.search_page AS search_page_26, c0_.sitemap_page AS sitemap_page_27, c0_.profile_page AS profile_page_28, c0_.terms_page AS terms_page_29, c0_.created_at AS created_at_30, c0_.updated_at AS updated_at_31, c0_.deleted_at AS deleted_at_32, c0_.lock_version AS lock_version_33 FROM cms_page c0_ WHERE c0_.slug = 'kontakt' AND c0_.deleted_at IS NULL AND c0_.published = 1 AND ((c0_.publish_at IS NULL OR c0_.publish_at <= '2026-09-11 05:37:25')) AND ((c0_.unpublish_at IS NULL OR c0_.unpublish_at > '2026-09-11 05:37:25'));

SELECT
  t0.code AS code_1,
  t0.version AS version_2,
  t0.enabled AS enabled_3,
  t0.installed_at AS installed_at_4,
  t0.updated_at AS updated_at_5
FROM
  installed_module t0
WHERE
  t0.code = ?

SELECT t0.code AS code_1, t0.version AS version_2, t0.enabled AS enabled_3, t0.installed_at AS installed_at_4, t0.updated_at AS updated_at_5 FROM installed_module t0 WHERE t0.code = 'settings';

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'shopro4_dev'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  t0.id AS id_1,
  t0.configuration AS configuration_2,
  t0.smtp_password AS smtp_password_3,
  t0.updated_at AS updated_at_4
FROM
  system_settings t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.configuration AS configuration_2, t0.smtp_password AS smtp_password_3, t0.updated_at AS updated_at_4 FROM system_settings t0 WHERE t0.id = 1;

SELECT
  t0.code AS code_1,
  t0.version AS version_2,
  t0.enabled AS enabled_3,
  t0.installed_at AS installed_at_4,
  t0.updated_at AS updated_at_5
FROM
  installed_module t0
WHERE
  t0.code = ?

SELECT t0.code AS code_1, t0.version AS version_2, t0.enabled AS enabled_3, t0.installed_at AS installed_at_4, t0.updated_at AS updated_at_5 FROM installed_module t0 WHERE t0.code = 'language';

SELECT
  t0.code AS code_1,
  t0.version AS version_2,
  t0.enabled AS enabled_3,
  t0.installed_at AS installed_at_4,
  t0.updated_at AS updated_at_5
FROM
  installed_module t0
WHERE
  t0.code = ?

SELECT t0.code AS code_1, t0.version AS version_2, t0.enabled AS enabled_3, t0.installed_at AS installed_at_4, t0.updated_at AS updated_at_5 FROM installed_module t0 WHERE t0.code = 'cms';

SELECT
  t0.code AS code_1,
  t0.version AS version_2,
  t0.enabled AS enabled_3,
  t0.installed_at AS installed_at_4,
  t0.updated_at AS updated_at_5
FROM
  installed_module t0
WHERE
  t0.code = ?

SELECT t0.code AS code_1, t0.version AS version_2, t0.enabled AS enabled_3, t0.installed_at AS installed_at_4, t0.updated_at AS updated_at_5 FROM installed_module t0 WHERE t0.code = 'identity';

SELECT
  t0.code AS code_1,
  t0.version AS version_2,
  t0.enabled AS enabled_3,
  t0.installed_at AS installed_at_4,
  t0.updated_at AS updated_at_5
FROM
  installed_module t0
WHERE
  t0.code = ?

SELECT t0.code AS code_1, t0.version AS version_2, t0.enabled AS enabled_3, t0.installed_at AS installed_at_4, t0.updated_at AS updated_at_5 FROM installed_module t0 WHERE t0.code = 'media';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.direction AS direction_4,
  t0.author AS author_5,
  t0.subdomain AS subdomain_6,
  t0.active AS active_7,
  t0.default_language AS default_language_8,
  t0.locale AS locale_9,
  t0.currency AS currency_10,
  t0.currency_symbol AS currency_symbol_11,
  t0.decimal_separator AS decimal_separator_12,
  t0.thousands_separator AS thousands_separator_13
FROM
  language t0
WHERE
  t0.default_language = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.direction AS direction_4, t0.author AS author_5, t0.subdomain AS subdomain_6, t0.active AS active_7, t0.default_language AS default_language_8, t0.locale AS locale_9, t0.currency AS currency_10, t0.currency_symbol AS currency_symbol_11, t0.decimal_separator AS decimal_separator_12, t0.thousands_separator AS thousands_separator_13 FROM language t0 WHERE t0.default_language = 1 AND t0.active = 1 LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.slug AS slug_2,
  c0_.content AS content_3,
  c0_.editor_mode AS editor_mode_4,
  c0_.builder_data AS builder_data_5,
  c0_.builder_css AS builder_css_6,
  c0_.published AS published_7,
  c0_.publish_at AS publish_at_8,
  c0_.unpublish_at AS unpublish_at_9,
  c0_.caption AS caption_10,
  c0_.seo_title AS seo_title_11,
  c0_.description AS description_12,
  c0_.keywords AS keywords_13,
  c0_.meta AS meta_14,
  c0_.javascript AS javascript_15,
  c0_.canonical AS canonical_16,
  c0_.access AS access_17,
  c0_.follow AS follow_18,
  c0_.home_page AS home_page_19,
  c0_.error_page AS error_page_20,
  c0_.admin_only AS admin_only_21,
  c0_.login_page AS login_page_22,
  c0_.activation_page AS activation_page_23,
  c0_.account_page AS account_page_24,
  c0_.registration_page AS registration_page_25,
  c0_.search_page AS search_page_26,
  c0_.sitemap_page AS sitemap_page_27,
  c0_.profile_page AS profile_page_28,
  c0_.terms_page AS terms_page_29,
  c0_.created_at AS created_at_30,
  c0_.updated_at AS updated_at_31,
  c0_.deleted_at AS deleted_at_32,
  c0_.lock_version AS lock_version_33
FROM
  cms_page c0_
WHERE
  c0_.slug = ?
  AND c0_.deleted_at IS NULL
  AND c0_.published = 1
  AND (
    (
      c0_.publish_at IS NULL
      OR c0_.publish_at <= ?
    )
  )
  AND (
    (
      c0_.unpublish_at IS NULL
      OR c0_.unpublish_at > ?
    )
  )

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.content AS content_3, c0_.editor_mode AS editor_mode_4, c0_.builder_data AS builder_data_5, c0_.builder_css AS builder_css_6, c0_.published AS published_7, c0_.publish_at AS publish_at_8, c0_.unpublish_at AS unpublish_at_9, c0_.caption AS caption_10, c0_.seo_title AS seo_title_11, c0_.description AS description_12, c0_.keywords AS keywords_13, c0_.meta AS meta_14, c0_.javascript AS javascript_15, c0_.canonical AS canonical_16, c0_.access AS access_17, c0_.follow AS follow_18, c0_.home_page AS home_page_19, c0_.error_page AS error_page_20, c0_.admin_only AS admin_only_21, c0_.login_page AS login_page_22, c0_.activation_page AS activation_page_23, c0_.account_page AS account_page_24, c0_.registration_page AS registration_page_25, c0_.search_page AS search_page_26, c0_.sitemap_page AS sitemap_page_27, c0_.profile_page AS profile_page_28, c0_.terms_page AS terms_page_29, c0_.created_at AS created_at_30, c0_.updated_at AS updated_at_31, c0_.deleted_at AS deleted_at_32, c0_.lock_version AS lock_version_33 FROM cms_page c0_ WHERE c0_.slug = 'kontakt' AND c0_.deleted_at IS NULL AND c0_.published = 1 AND ((c0_.publish_at IS NULL OR c0_.publish_at <= '2026-09-11 05:37:25')) AND ((c0_.unpublish_at IS NULL OR c0_.unpublish_at > '2026-09-11 05:37:25'));

SELECT
  owner_type,
  owner_id
FROM
  public_slug
WHERE
  locale = ?
  AND slug = ?

SELECT owner_type, owner_id FROM public_slug WHERE locale = '' AND slug = 'kontakt';

SELECT
  t0.id AS id_1,
  t0.translation_key AS translation_key_2,
  t0.value AS value_3,
  t0.language_id AS language_id_4
FROM
  language_translation t0
WHERE
  t0.language_id = ?
  AND t0.translation_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.translation_key AS translation_key_2, t0.value AS value_3, t0.language_id AS language_id_4 FROM language_translation t0 WHERE t0.language_id = 1 AND t0.translation_key = 'page.public_unpublished' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.source_path AS source_path_2,
  t0.target_path AS target_path_3,
  t0.permanent AS permanent_4,
  t0.active AS active_5,
  t0.hits AS hits_6,
  t0.last_used_at AS last_used_at_7
FROM
  cms_url_redirect t0
WHERE
  t0.source_path = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.source_path AS source_path_2, t0.target_path AS target_path_3, t0.permanent AS permanent_4, t0.active AS active_5, t0.hits AS hits_6, t0.last_used_at AS last_used_at_7 FROM cms_url_redirect t0 WHERE t0.source_path = '/kontakt' AND t0.active = 1 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  cms_url_redirect
SET
  hits = ?,
  last_used_at = ?
WHERE
  id = ?

UPDATE cms_url_redirect SET hits = 4, last_used_at = '2026-09-11 05:37:25' WHERE id = 5;

"COMMIT"

"COMMIT";