Provoz veřejného osvětlení a světelných signalizačních zařízení

--------------------------------------------------------------------------------
--- SUMMARY --------------------------------------------------------------------
--------------------------------------------------------------------------------
URL: /provoz-verejneho-osvetleni-a-svetelnych-signalizacnich-zarizeni
Date: 08.10.2024 03.50.28
Used memory: 577 Kb.
Total execution time:    0,17049408 sec.
PHP core execution time: 0,04968977 sec.
Database execution time: 0,12080431 sec.
Database queries: 14

--------------------------------------------------------------------------------
--- CONSTANTS ------------------------------------------------------------------
--------------------------------------------------------------------------------
Array
(
    [APP] => tschrudim.cz/website
    [DATABASE] => Array
        (
            [host] => a027um.forpsi.com
            [port] => 3306
            [name] => f128590
            [user] => f128590
            [password] => wAtmE7ns
            [prefix] => cms
        )

    [DEVELOPMENT] => 
    [FRONTEND_DEFAULT_LANGUAGE] => cs_cz
    [HTTP_PROTOCOL] => https://
    [KEY] => f0edf956fbf56e5a45d73df01ad5064e
    [LANGUAGE] => cs_cz
    [MEDIUM_RESPONSIVE_SIZES] => Array
        (
            [article] => Array
                (
                    [0] => 1500_1000
                    [1] => 1200_800
                    [2] => 900_600
                    [3] => 600_400
                    [4] => 300_200
                    [5] => 1500_842
                    [6] => 1200_674
                    [7] => 900_505
                    [8] => 600_337
                    [9] => 300_168
                    [10] => 1500_750
                    [11] => 1200_600
                    [12] => 900_450
                    [13] => 600_300
                    [14] => 300_150
                )

            [center] => Array
                (
                    [0] => 1500_1000
                    [1] => 1200_800
                    [2] => 900_600
                    [3] => 600_400
                    [4] => 300_200
                    [5] => 1500_842
                    [6] => 1200_674
                    [7] => 900_505
                    [8] => 600_337
                    [9] => 300_168
                    [10] => 1500_750
                    [11] => 1200_600
                    [12] => 900_450
                    [13] => 600_300
                    [14] => 300_150
                )

            [banner] => Array
                (
                    [0] => 1500_600
                    [1] => 1200_480
                    [2] => 900_360
                    [3] => 600_240
                    [4] => 300_120
                    [5] => 1500_500
                    [6] => 1200_400
                    [7] => 900_300
                    [8] => 600_200
                    [9] => 300_100
                    [10] => 1500_428
                    [11] => 1200_342
                    [12] => 900_257
                    [13] => 600_170
                    [14] => 300_85
                )

            [employee] => Array
                (
                    [0] => 500_500
                    [1] => 300_300
                )

        )

    [MEDIUM_RESPONSIVE_SIZE_BACKEND] => Array
        (
            [article] => Array
                (
                    [0] => 1500_1000
                    [1] => 1200_800
                    [2] => 900_600
                    [3] => 600_400
                    [4] => 300_200
                )

            [center] => Array
                (
                    [0] => 1500_1000
                    [1] => 1200_800
                    [2] => 900_600
                    [3] => 600_400
                    [4] => 300_200
                )

            [banner] => Array
                (
                    [0] => 1500_500
                    [1] => 1200_400
                    [2] => 900_300
                    [3] => 600_200
                    [4] => 300_100
                )

            [employee] => Array
                (
                    [0] => 500_500
                    [1] => 300_300
                )

        )

    [MEDIUM_RESPONSIVE_SIZE_FRONTEND] => Array
        (
            [article] => Array
                (
                    [0] => 1500_1000
                    [1] => 1200_800
                    [2] => 900_600
                    [3] => 600_400
                    [4] => 300_200
                )

            [center] => Array
                (
                    [0] => 1500_1000
                    [1] => 1200_800
                    [2] => 900_600
                    [3] => 600_400
                    [4] => 300_200
                )

            [banner] => Array
                (
                    [0] => 1500_500
                    [1] => 1200_400
                    [2] => 900_300
                    [3] => 600_200
                    [4] => 300_100
                )

            [employee] => Array
                (
                    [0] => 500_500
                    [1] => 300_300
                )

        )

    [PATH_APP] => /web/htdocs5/tschrudimcz/home/www/website/application/
    [PATH_LOCALE] => /web/htdocs5/tschrudimcz/home/www/website/locale/
    [PATH_MODULES] => /web/htdocs5/tschrudimcz/home/www/website/application/Modules/
    [PATH_ROOT] => /web/htdocs5/tschrudimcz/home/www
    [PATH_STORAGE_AUDIO] => /web/htdocs5/tschrudimcz/home/www/storage/audio/
    [PATH_STORAGE_FILE] => /web/htdocs5/tschrudimcz/home/www/storage/file/
    [PATH_STORAGE_IMAGE] => /web/htdocs5/tschrudimcz/home/www/storage/image/
    [PATH_STORAGE_VIDEO] => /web/htdocs5/tschrudimcz/home/www/storage/video/
    [PATH_TEMP] => /web/htdocs5/tschrudimcz/home/www/website/temp/
    [SMTP] => Array
        (
            [host] => box.og.cz
            [sender] => noreply@tschrudim.cz
            [username] => noreply@tschrudim.cz
            [password] => 582K(ap*L_
            [secure] => ssl
            [port] => 465
        )

    [URL_AJAX] => https://www.tschrudim.cz/frontend-ajax.php
    [URL_APP] => https://www.tschrudim.cz
    [URL_PLUGIN] => https://www.tschrudim.cz/website/plugin/
    [URL_PUBLIC] => https://www.tschrudim.cz/website/public/
    [URL_ROOT] => https://www.tschrudim.cz
    [URL_STORAGE_AUDIO] => https://www.tschrudim.cz/storage/audio/
    [URL_STORAGE_FILE] => https://www.tschrudim.cz/storage/file/
    [URL_STORAGE_IMAGE] => https://www.tschrudim.cz/storage/image/
    [URL_STORAGE_VIDEO] => https://www.tschrudim.cz/storage/video/
    [URL_TEMP] => https://www.tschrudim.cz/website/temp/
)

--------------------------------------------------------------------------------
--- $_SESSION ------------------------------------------------------------------
--------------------------------------------------------------------------------
Array
(
    [tschrudim.cz/website] => Array
        (
            [initialized] => 1
            [language] => cs_cz
        )

)

--------------------------------------------------------------------------------
--- $_GET ----------------------------------------------------------------------
--------------------------------------------------------------------------------
Array
(
    [url] => provoz-verejneho-osvetleni-a-svetelnych-signalizacnich-zarizeni
)

--------------------------------------------------------------------------------
--- $_POST ---------------------------------------------------------------------
--------------------------------------------------------------------------------
Array
(
)

--------------------------------------------------------------------------------
--- Registry->setting ----------------------------------------------------------
--------------------------------------------------------------------------------
Array
(
    [APP_BUILD] => 20240424
    [APP_DUMP] => 1
    [APP_NAME] => Website
    [APP_SUPPORT_EMAIL] => webdesign@bluetex.cz
    [APP_VERSION] => 1.0.0
    [MODULE_ADDON] => Array
        (
            [addon_cookies] => Modules\Addon\Cookies\Cookies
            [addon_google_analytics] => Modules\Addon\GoogleAnalytics\GoogleAnalytics
            [addon_hotjar] => Modules\Addon\Hotjar\Hotjar
            [addon_smartsupp] => Modules\Addon\Smartsupp\Smartsupp
        )

    [MODULE_ADDON_COOKIES] => 1
    [MODULE_ADDON_COOKIES_CONSENT_MARKETING] => disabled
    [MODULE_ADDON_COOKIES_CONSENT_PREFERENTIAL] => disabled
    [MODULE_ADDON_COOKIES_CONSENT_STATISTICAL] => disabled
    [MODULE_ADDON_COOKIES_CONSENT_TECHNICAL] => on
    [MODULE_ADDON_COOKIES_EXPIRE] => 7889400
    [MODULE_ADDON_COOKIES_LIST] => Array
        (
            [technical] => TECHNICAL
            [preferential] => PREFERENTIAL
            [statistical] => STATISTICAL
            [marketing] => MARKETING
        )

    [MODULE_ADDON_COOKIES_WINDOW_BUTTON_CLOSE] => 1
    [MODULE_ADDON_COOKIES_WINDOW_OVERLAY] => 1
    [MODULE_ADDON_GOOGLE_ANALYTICS] => 
    [MODULE_ADDON_GOOGLE_ANALYTICS_CODE] => 
    [MODULE_ADDON_HOTJAR] => 
    [MODULE_ADDON_HOTJAR_CODE] => 
    [MODULE_ADDON_SMARTSUPP] => 
    [MODULE_ADDON_SMARTSUPP_CODE] => 
    [MODULE_ARTICLE] => 1
    [MODULE_ARTICLE_DOWNLOAD] => 1
    [MODULE_ARTICLE_GALLERY] => 1
    [MODULE_ARTICLE_IMAGE] => 1
    [MODULE_ARTICLE_RECORDS_LIMIT] => 50
    [MODULE_CENTER] => 1
    [MODULE_CENTER_CONTACT] => 1
    [MODULE_CENTER_DOWNLOAD] => 1
    [MODULE_CENTER_GALLERY] => 1
    [MODULE_CENTER_IMAGE] => 1
    [MODULE_CENTER_OPENING_HOUR] => 1
    [MODULE_OPENING_HOUR_NUMBER_TIMES] => 2
    [MODULE_PAGE] => 1
    [PAGE_BODY_SCRIPT] => 
    [PAGE_HEAD_META_DESCRIPTION] => 
    [PAGE_HEAD_META_KEYWORDS] => 
    [PAGE_HEAD_META_SECTION_FIRST] => Array
        (
            [http-equiv] => Array
                (
                    [content-Type] => text/html; charset=UTF-8
                )

            [name] => Array
                (
                    [charset] => utf-8
                    [viewport] => width=device-width, initial-scale=1
                )

        )

    [PAGE_HEAD_META_SECTION_SECOND] => Array
        (
            [name] => Array
                (
                    [author] => all: Jan Koša (Jan Kosa); jackinello@gmail.com
                    [googlebot] => index, follow
                    [robots] => index, follow
                )

        )

    [PAGE_HEAD_SCRIPT] => 
    [PAGE_HEAD_TITLE] => Technické služby Chrudim 2000 spol. s r.o. | %page%
    [PRICE_INCLUDE_VAT] => 1
    [USER_LOGIN_ATTEMPTS] => 3
    [USER_LOGIN_FREQUENCY] => 600
    [USER_LOGIN_TIMEOUT] => 0
    [USER_PASSWORD_MINLENGTH] => 6
    [VAT_PAYER] => 1
    [VAT_RATES] => Array
        (
            [0] => 0
            [1] => 21
            [2] => 15
            [3] => 10
        )

    [REGION_FORMAT_DECIMAL_SEPARATOR] => ,
    [REGION_FORMAT_LONG_DATE] => j. F Y
    [REGION_FORMAT_LONG_TIME] => H.i.s
    [REGION_FORMAT_SHORT_DATE] => j. n. Y
    [REGION_FORMAT_SHORT_TIME] => H.i
    [REGION_FORMAT_THOUSANDS_SEPARATOR] => 
)

--------------------------------------------------------------------------------
--- DATABASE QUERY PERFORMANCE -------------------------------------------------
--------------------------------------------------------------------------------
1. query time: 0,000317812 sec.
        	SELECT
        	    cms_frontend_setting.name AS name,
                cms_frontend_setting.value AS value
        	FROM
                cms_frontend_setting
        
2. query time: 0,000329971 sec.
        	SELECT
                cms_frontend_language.id AS id,
                cms_frontend_language.active AS active,
                cms_frontend_language.code AS code,
                cms_frontend_language.locale AS locale,
                cms_frontend_language.html AS html,
                cms_frontend_language.editor AS editor,
                cms_frontend_language.shortcut AS shortcut,
                cms_frontend_language.title AS title,
                cms_frontend_language.country AS country       
        	FROM
                cms_frontend_language
            ORDER BY
                cms_frontend_language.attribute = 'default' DESC, cms_frontend_language.title
        
3. query time: 0,000291824 sec.
        	SELECT
                cms_frontend_language_setting.name AS name,
                cms_frontend_language_setting.value AS value
        	FROM
                cms_frontend_language_setting
            WHERE
                cms_frontend_language_setting.language_id = :id
        
4. query time: 0,00032115 sec.
            SELECT
                cms_frontend_page.id AS id,
                cms_frontend_page.name AS name,
                cms_frontend_page.title_cs_cz AS title,
                cms_frontend_router.url_cs_cz AS url
            FROM
                cms_frontend_page,
                cms_frontend_router
            WHERE
                cms_frontend_page.active = 1
                AND cms_frontend_page.router_id = cms_frontend_router.id
        
5. query time: 0,001139879 sec.
            SELECT
                cms_frontend_router.id AS id,
                cms_frontend_router.module AS module,
                cms_frontend_router.space AS space,
                cms_frontend_router.controller AS controller,
                cms_frontend_router.method AS method,
                cms_frontend_router.parameters AS parameters
            FROM
                cms_frontend_router
            WHERE
                cms_frontend_router.url_cs_cz = :url
        
6. query time: 0,000339985 sec.
            SELECT
                cms_frontend_variable.name AS name,
                cms_frontend_variable.value_cs_cz AS value
            FROM
                cms_frontend_variable
            WHERE
                cms_frontend_variable.active = 1
        
7. query time: 0,013324976 sec.
            SELECT
                cms_frontend_center.id AS id,
                cms_frontend_center.image_banner_id AS image_banner_id,
                cms_frontend_center.title_cs_cz AS title,
                cms_frontend_center.annotation_cs_cz AS annotation,
                cms_frontend_center.content_cs_cz AS content
        	FROM
                cms_frontend_center
        	WHERE
        	    cms_frontend_center.id = :id
        	    AND cms_frontend_center.active = 1
        	LIMIT 1
        
8. query time: 0,001121998 sec.
            SELECT
                cms_frontend_repository_medium.id AS id,
        	    cms_frontend_repository_medium.type AS type,
        	    cms_frontend_repository_medium.storage AS storage,
                cms_frontend_repository_medium.name AS name,
                cms_frontend_repository_medium.extension AS extension,
                cms_frontend_repository_medium.uploaded AS uploaded
        	FROM
                cms_frontend_repository_medium
        	WHERE
                cms_frontend_repository_medium.id = :id
                AND cms_frontend_repository_medium.uploaded IS NOT NULL
            LIMIT 1
        
9. query time: 0,04343605 sec.
            SELECT
                cms_frontend_repository_person.id AS id,
                TRIM(CONCAT_WS (' ',
                    cms_frontend_repository_person.title,
                    cms_frontend_repository_person.firstname,
                    cms_frontend_repository_person.surname,
                    cms_frontend_repository_person.degree
                )) AS name,
                cms_frontend_repository_person.phone_1 AS phone_1,
                cms_frontend_repository_person.phone_2 AS phone_2,
                cms_frontend_repository_person.phone_3 AS phone_3,
                cms_frontend_repository_person.email_1 AS email_1,
                cms_frontend_repository_person.email_2 AS email_2,
                cms_frontend_repository_person.job_cs_cz AS job,
                cms_frontend_repository_person.note_cs_cz AS note
        	FROM
                cms_frontend_center_contact, cms_frontend_repository_person
        	WHERE
                cms_frontend_center_contact.center_id = :center_id
                AND cms_frontend_center_contact.person_id = cms_frontend_repository_person.id
                AND cms_frontend_repository_person.active = 1
            ORDER BY
                cms_frontend_repository_person.sort
        
10. query time: 0,013671875 sec.
            SELECT
                cms_frontend_repository_opening_time.id AS id,
                cms_frontend_repository_opening_time.open AS open,
                cms_frontend_repository_opening_time.times AS times,
                cms_frontend_repository_opening_time.title_cs_cz AS title
        	FROM
                cms_frontend_center_opening_hour, cms_frontend_repository_opening_time
        	WHERE
                cms_frontend_center_opening_hour.center_id = :center_id
                AND cms_frontend_center_opening_hour.opening_time_id = cms_frontend_repository_opening_time.id
                AND cms_frontend_repository_opening_time.active = 1
            ORDER BY
                cms_frontend_repository_opening_time.sort
        
11. query time: 0,02069211 sec.
            SELECT
                cms_frontend_repository_file.id AS id,
        	    cms_frontend_repository_file.storage AS location,
                cms_frontend_repository_file.extension AS extension,
                cms_frontend_repository_file.uploaded AS uploaded,
                cms_frontend_repository_file.size AS size,
                cms_frontend_repository_file.download_name_cs_cz AS download_name,
                cms_frontend_repository_file.title_cs_cz AS title,
                cms_frontend_repository_file.description_cs_cz AS description
        	FROM
                cms_frontend_center_download, cms_frontend_repository_file
        	WHERE
                cms_frontend_center_download.center_id = :center_id
                AND cms_frontend_center_download.file_id = cms_frontend_repository_file.id
                AND cms_frontend_repository_file.active = 1
                AND cms_frontend_repository_file.uploaded IS NOT NULL
            ORDER BY
                cms_frontend_repository_file.sort
        
12. query time: 0,015066862 sec.
            SELECT
                cms_frontend_repository_medium.id AS id,
        	    cms_frontend_repository_medium.type AS type,
        	    cms_frontend_repository_medium.storage AS storage,
                cms_frontend_repository_medium.name AS name,
                cms_frontend_repository_medium.extension AS extension,
                cms_frontend_repository_medium.uploaded AS uploaded,
                cms_frontend_repository_medium.description_cs_cz AS description
        	FROM
                cms_frontend_center_gallery, cms_frontend_repository_medium
        	WHERE
                cms_frontend_center_gallery.center_id = :center_id
                AND cms_frontend_center_gallery.medium_id = cms_frontend_repository_medium.id
                AND cms_frontend_repository_medium.active = 1
                AND cms_frontend_repository_medium.uploaded IS NOT NULL
            ORDER BY
                cms_frontend_repository_medium.sort
        
13. query time: 0,010366917 sec.
            SELECT
                cms_frontend_page.id AS id,
                cms_frontend_page.lft AS lft,
                cms_frontend_page.rgt AS rgt,
                cms_frontend_page.level AS level,
                cms_frontend_page.name AS name,
                cms_frontend_page.title_cs_cz AS title
            FROM
                cms_frontend_page
            WHERE
                cms_frontend_page.active = 1
        AND cms_frontend_page.name = :name
14. query time: 0,0003829 sec.
            SELECT
                cms_frontend_page.id AS id,
                cms_frontend_page.name AS name,
                cms_frontend_page.title_cs_cz AS title
            FROM
                cms_frontend_page
            WHERE
                cms_frontend_page.active = 1
                AND cms_frontend_page.lft <= :lft
                AND cms_frontend_page.rgt >= :rgt
            ORDER BY
                cms_frontend_page.lft