Script name: ApPHP Directy CMF
Script version: 3.1.0
Framework version: 1.2.2
PHP version: 7.4.28
Mysql version: 5.5.510.2.43

Total running time: 0.07252 sec.
Script running time: 0.04812 sec.
SQL running time: 0.0244 sec.
Total memory usage: 3.58 mb

GZip Output compression: no
HTML Output compression: no
CSS Output compression: no
JS Output compression: no
Action: [ Clear Session & Cookies ]
Action: [ Clear Cache & Minified - 0 files ]

LOADED CLASSES:

Array
(
    [0] => Settings
    [1] => SiteInfo
    [2] => Modules\Polls\Controllers\PollsController
    [3] => Modules
    [4] => Modules\Polls\Models\Polls
    [5] => Modules\Polls\Components\PollsComponent
    [6] => ModulesSettings
    [7] => SocialNetworks
    [8] => Languages
    [9] => Currencies
    [10] => FrontendMenus
    [11] => Modules\News\Components\NewsComponent
    [12] => Modules\News\Models\News
    [13] => Modules\Testimonials\Components\TestimonialsComponent
    [14] => Modules\Testimonials\Models\Testimonials
    [15] => Modules\Users\Components\UsersComponent
    [16] => Modules\Advertisements\Components\AdvertisementsComponent
    [17] => Modules\Advertisements\Models\Advertisements
    [18] => Modules\Blog\Components\BlogComponent
    [19] => Modules\Blog\Models\Posts
    [20] => Modules\Gallery\Components\GalleryComponent
    [21] => Modules\Gallery\Models\GalleryAlbumItems
)

INCLUDED FILES:

Array
(
    [0] => /home/010host/public_html/mydashboard/protected/modules/polls/views/polls/show.php
    [1] => /home/010host/public_html/mydashboard/protected/views/components/newssubscribers.php
    [2] => /home/010host/public_html/mydashboard/templates/default/default.php
)

APPLICATION:

Array
(
    [controller] => Polls
    [action] => show
    [params] => Array
(
    [id] => 2
)

    [view] => /home/010host/public_html/mydashboard/protected/modules/polls/views/polls/show.php
    [render-content] => /home/010host/public_html/mydashboard/protected/views/components/newssubscribers.php
    [layout] => default
    [template] => default
    [running_controller] => Modules\Polls\Controllers\PollsController
    [running_action] => showAction
)

$_GET:

Array
(
    [url] => polls/show/id/2
)

$_POST:

Array
(
)

$_FILES:

Array
(
)

$_COOKIE:

Array
(
    [apphp_yhfbj9dsp4] => 02q8a25oeimqlgmga6i6n8ohkc
)

$_SESSION:

Array
(
    [language] => en
    [language_name] => English
    [language_name_native] => English
    [language_locale] => en_US
    [language_direction] => ltr
    [language_icon] => en.gif
    [currency_code] => EUR
    [currency_name] => Euro
    [currency_symbol] => €
    [currency_symbol_place] => before
    [currency_decimals] => 2
    [currency_rate] => 1.0000
    [csc_02q8a25oeimqlgmga6i6n8ohkc] => Array
        (
            [f0938b000d9958410b375b1b0a86edad] => s:1:"1";
            [15e9cf10055e1861e78df80dfbd5209d] => a:1:{s:2:"en";a:2:{s:4:"name";s:7:"English";s:4:"icon";s:6:"en.gif";}}
            [4164a9a764fd9008e11c1562adc86ad4] => a:5:{s:3:"USD";a:2:{s:4:"name";s:9:"US Dollar";s:6:"symbol";s:1:"$";}s:3:"EUR";a:2:{s:4:"name";s:4:"Euro";s:6:"symbol";s:3:"€";}s:3:"GBP";a:2:{s:4:"name";s:8:"GB Pound";s:6:"symbol";s:2:"£";}s:3:"AUD";a:2:{s:4:"name";s:9:"AU Dollar";s:6:"symbol";s:2:"A$";}s:3:"CAD";a:2:{s:4:"name";s:9:"CA Dollar";s:6:"symbol";s:2:"C$";}}
        )

    [last_visited_page] => http://mydashboard.online/polls/show/id/2
)

CONSTANTS:

Array
(
    [APPHP_PATH] => /home/010host/public_html/mydashboard
    [DS] => /
    [APPHP_MODE] => debug
)

VIEW VARIABLES:

Array
(
    [0] => MyDashboard Online
    [1] => Your data in an online dashboard
    [2] => MyDashboard Online © <a class="footer_link" target="_blank" rel="noopener noreferrer" href="https://xdsolutions.nl">XD Solutions</a>
    [3] => +31105063304
    [4] => 
    [5] => ops@burgerwarehousing.com
    [6] => Columbusstraat 12-14, 3165 AD, Rotterdam-Albrandswaard
    [7] => Pages/view
    [8] => 
    [9] => 
    [10] => Modules\Polls\Models\Polls Object
        (
            [_table:protected] => polls
            [_tableTranslation:protected] => polls_translations
            [_columnsTranslation:protected] => Array
                (
                    [0] => poll_question
                    [1] => poll_answer_1
                    [2] => poll_answer_2
                    [3] => poll_answer_3
                    [4] => poll_answer_4
                    [5] => poll_answer_5
                )

            [_translationsArray:Modules\Polls\Models\Polls:private] => 
            [_db:protected] => CDatabase Object
                (
                    [_dbPrefix:CDatabase:private] => 
                    [_dbDriver:CDatabase:private] => mysql
                    [_dbName:CDatabase:private] => 010host_bwt
                    [_cache:CDatabase:private] => 
                    [_cacheType:CDatabase:private] => auto
                    [_cacheLifetime:CDatabase:private] => 20
                    [_cacheDir:CDatabase:private] => protected/tmp/cache/
                    [_query:CDatabase:private] => SELECT
					
					`social_networks`.*
					
					
					
				FROM `social_networks`
					
				 WHERE is_active = 1
				
				 ORDER BY sort_order ASC
				
                    [_backQuote:CDatabase:private] => `
                )

            [_dbDriver:protected] => mysql
            [_dbPrefix:protected] => 
            [_error:protected] => 
            [_errorMessage:protected] => 
            [_columns:protected] => Array
                (
                    [id] => 2
                    [poll_answer_1_votes] => 12
                    [poll_answer_2_votes] => 4
                    [poll_answer_3_votes] => 2
                    [poll_answer_4_votes] => 5
                    [poll_answer_5_votes] => 2
                    [type_comparison] => 0
                    [instruction] => 
                    [color_text] => #000000
                    [background_color] => #ffffff
                    [created_at] => 2016-12-02
                    [expires_at] => 
                    [sort_order] => 0
                    [is_active] => 1
                    [total_votes] => 25
                    [poll_question] => What browser do you prefer to use?
                    [poll_answer_1] => Chrome
                    [poll_answer_2] => Firefox
                    [poll_answer_3] => Opera
                    [poll_answer_4] => Internet Explorer
                    [poll_answer_5] => Safary
                )

            [_specialFields:protected] => Array
                (
                )

            [_backQuote:CActiveRecord:private] => `
            [_columnTypes:CActiveRecord:private] => Array
                (
                    [id] => int
                    [poll_answer_1_votes] => int
                    [poll_answer_2_votes] => int
                    [poll_answer_3_votes] => int
                    [poll_answer_4_votes] => int
                    [poll_answer_5_votes] => int
                    [type_comparison] => tinyint
                    [instruction] => varchar
                    [color_text] => varchar
                    [background_color] => varchar
                    [created_at] => date
                    [expires_at] => date
                    [sort_order] => smallint
                    [is_active] => tinyint
                    [total_votes] => varchar
                )

            [_pkValue:CActiveRecord:private] => 2
            [_primaryKey:CActiveRecord:private] => id
            [_isNewRecord:CActiveRecord:private] => 
        )

    [11] => Array
        (
            [0] => Array
                (
                    [id] => 1
                    [poll_answer_1_votes] => 1
                    [poll_answer_2_votes] => 0
                    [poll_answer_3_votes] => 3
                    [poll_answer_4_votes] => 4
                    [poll_answer_5_votes] => 5
                    [type_comparison] => 0
                    [instruction] => 
                    [color_text] => #000000
                    [background_color] => #ffffff
                    [created_at] => 2015-12-14
                    [expires_at] => 
                    [sort_order] => 0
                    [is_active] => 1
                    [poll_question] => Test Question
                    [poll_answer_1] => Answer 1
                    [poll_answer_2] => Answer 2
                    [poll_answer_3] => Answer 3
                    [poll_answer_4] => Answer 4
                    [poll_answer_5] => 
                    [total_votes] => 13
                )

        )

    [12] => Array
        (
            [0] => Array
                (
                    [label] => Home
                    [url] => Pages/view
                )

            [1] => Array
                (
                    [label] => All Polls
                    [url] => polls/showAll
                )

        )

    [13] => allow-optional
    [14] => allow-optional
    [15] => no
)

SQL running time: 0.0244 sec.

1. query | 0.00123 sec. | total: 49
SHOW COLUMNS FROM `settings`

2. select | 0.0005 sec. | total: 1
SELECT `settings`.* FROM `settings` WHERE `settings`.id = 1 LIMIT 1

3. query | 0.00092 sec. | total: 13
SHOW COLUMNS FROM `site_info`

4. select | 0.00043 sec. | total: 1
SELECT `site_info`.* FROM `site_info` WHERE language_code = 'en' LIMIT 1

5. query | 0.001 sec. | total: 16
SHOW COLUMNS FROM `modules`

6. select | 0.00033 sec. | total: 17
SELECT `modules`.* FROM `modules`

7. query | 0.00069 sec. | total: 14
SHOW COLUMNS FROM `polls`

8. select | 0.00047 sec. | total: 1
SELECT `polls`.* , `polls_translations`.poll_question as poll_question, `polls_translations`.poll_answer_1 as poll_answer_1, `polls_translations`.poll_answer_2 as poll_answer_2, `polls_translations`.poll_answer_3 as poll_answer_3, `polls_translations`.poll_answer_4 as poll_answer_4, `polls_translations`.poll_answer_5 as poll_answer_5 , (poll_answer_1_votes + poll_answer_2_votes + poll_answer_3_votes + poll_answer_4_votes + poll_answer_5_votes) as total_votes FROM `polls` LEFT OUTER JOIN `polls_translations` ON `polls`.id = `polls_translations`.polls_id AND language_code = 'en' WHERE `polls`.id = 2 LIMIT 1

9. select | 0.00066 sec. | total: 1
SELECT `polls`.* , `polls_translations`.poll_question as poll_question, `polls_translations`.poll_answer_1 as poll_answer_1, `polls_translations`.poll_answer_2 as poll_answer_2, `polls_translations`.poll_answer_3 as poll_answer_3, `polls_translations`.poll_answer_4 as poll_answer_4, `polls_translations`.poll_answer_5 as poll_answer_5 , (poll_answer_1_votes + poll_answer_2_votes + poll_answer_3_votes + poll_answer_4_votes + poll_answer_5_votes) as total_votes FROM `polls` LEFT OUTER JOIN `polls_translations` ON `polls`.id = `polls_translations`.polls_id AND language_code = 'en' WHERE polls.id != 2 ORDER BY created_at ASC

10. query | 0.00118 sec. | total: 13
SHOW COLUMNS FROM `module_settings`

11. select | 0.00098 sec. | total: 99
SELECT `module_settings`.* FROM `module_settings`

12. query | 0.00132 sec. | total: 7
SHOW COLUMNS FROM `social_networks`

13. select | 0.00038 sec. | total: 3
SELECT `social_networks`.* FROM `social_networks` WHERE is_active = 1 ORDER BY sort_order ASC

14. query | 0.00098 sec. | total: 11
SHOW COLUMNS FROM `languages`

15. query | 0.00122 sec. | total: 11
SHOW COLUMNS FROM `currencies`

16. select | 0.00049 sec. | total: 5
SELECT `currencies`.* , IF(symbol_place = "before", CONCAT(symbol_place, " (", symbol, 100, ")"), CONCAT(symbol_place, " (", 100, "", symbol, ")")) as example_symbol_place FROM `currencies` WHERE is_active = 1 ORDER BY sort_order ASC

17. query | 0.00078 sec. | total: 10
SHOW COLUMNS FROM `frontend_menus`

18. select | 0.0005 sec. | total: 3
SELECT `frontend_menus`.* , `frontend_menu_translations`.name as menu_name , frontend_menus.id as menu_id FROM `frontend_menus` LEFT OUTER JOIN `frontend_menu_translations` ON `frontend_menus`.id = `frontend_menu_translations`.menu_id AND language_code = 'en' WHERE placement = 'top' AND parent_id = 0 AND is_active = 1 ORDER BY sort_order ASC

19. select | 0.00032 sec. | total: 0 (empty)
SELECT `frontend_menus`.* , `frontend_menu_translations`.name as menu_name , frontend_menus.id as menu_id FROM `frontend_menus` LEFT OUTER JOIN `frontend_menu_translations` ON `frontend_menus`.id = `frontend_menu_translations`.menu_id AND language_code = 'en' WHERE parent_id = '9' AND is_active = 1 ORDER BY sort_order ASC

20. select | 0.00035 sec. | total: 0 (empty)
SELECT `frontend_menus`.* , `frontend_menu_translations`.name as menu_name , frontend_menus.id as menu_id FROM `frontend_menus` LEFT OUTER JOIN `frontend_menu_translations` ON `frontend_menus`.id = `frontend_menu_translations`.menu_id AND language_code = 'en' WHERE parent_id = '1' AND is_active = 1 ORDER BY sort_order ASC

21. select | 0.00026 sec. | total: 0 (empty)
SELECT `frontend_menus`.* , `frontend_menu_translations`.name as menu_name , frontend_menus.id as menu_id FROM `frontend_menus` LEFT OUTER JOIN `frontend_menu_translations` ON `frontend_menus`.id = `frontend_menu_translations`.menu_id AND language_code = 'en' WHERE parent_id = '4' AND is_active = 1 ORDER BY sort_order ASC

22. select | 0.0005 sec. | total: 5
SELECT `frontend_menus`.* , `frontend_menu_translations`.name as menu_name , frontend_menus.id as menu_id FROM `frontend_menus` LEFT OUTER JOIN `frontend_menu_translations` ON `frontend_menus`.id = `frontend_menu_translations`.menu_id AND language_code = 'en' WHERE placement = 'right' AND parent_id = 0 AND is_active = 1 ORDER BY sort_order ASC

23. query | 0.00077 sec. | total: 5
SHOW COLUMNS FROM `news`

24. select | 0.00042 sec. | total: 1
SELECT `news`.* , `news_translations`.news_header as news_header, `news_translations`.news_text as news_text FROM `news` LEFT OUTER JOIN `news_translations` ON `news`.id = `news_translations`.news_id AND language_code = 'en' WHERE is_published = '1' AND created_at < '2024-09-08 03:54:12' ORDER BY created_at DESC LIMIT 0, 5

25. query | 0.00171 sec. | total: 12
SHOW COLUMNS FROM `testimonials`

26. select | 0.00044 sec. | total: 2
SELECT `testimonials`.* FROM `testimonials` WHERE is_active = '1' ORDER BY sort_order ASC LIMIT 0, 2

27. query | 0.00105 sec. | total: 14
SHOW COLUMNS FROM `ads`

28. select | 0.00037 sec. | total: 3
SELECT `ads`.* FROM `ads` WHERE ads.is_active = 1 ORDER BY sort_order ASC, created_at DESC

29. select | 0.00046 sec. | total: 2
SELECT `polls`.* , `polls_translations`.poll_question as poll_question, `polls_translations`.poll_answer_1 as poll_answer_1, `polls_translations`.poll_answer_2 as poll_answer_2, `polls_translations`.poll_answer_3 as poll_answer_3, `polls_translations`.poll_answer_4 as poll_answer_4, `polls_translations`.poll_answer_5 as poll_answer_5 , (poll_answer_1_votes + poll_answer_2_votes + poll_answer_3_votes + poll_answer_4_votes + poll_answer_5_votes) as total_votes FROM `polls` LEFT OUTER JOIN `polls_translations` ON `polls`.id = `polls_translations`.polls_id AND language_code = 'en' WHERE (polls.expires_at IS NULL OR polls.expires_at > '2024-09-08') AND polls.is_active = 1 ORDER BY sort_order DESC, created_at DESC

30. select | 0.00034 sec. | total: 0 (empty)
SELECT `frontend_menus`.* , `frontend_menu_translations`.name as menu_name , frontend_menus.id as menu_id FROM `frontend_menus` LEFT OUTER JOIN `frontend_menu_translations` ON `frontend_menus`.id = `frontend_menu_translations`.menu_id AND language_code = 'en' WHERE placement = 'bottom' AND parent_id = 0 AND is_active = 1 ORDER BY sort_order ASC

31. select | 0.00032 sec. | total: 1
SELECT `news`.* , `news_translations`.news_header as news_header, `news_translations`.news_text as news_text FROM `news` LEFT OUTER JOIN `news_translations` ON `news`.id = `news_translations`.news_id AND language_code = 'en' WHERE is_published = '1' AND created_at < '2024-09-08 03:54:12' ORDER BY created_at DESC LIMIT 0, 3

32. query | 0.00098 sec. | total: 11
SHOW COLUMNS FROM `blog_posts`

33. select | 0.00032 sec. | total: 1
SELECT `blog_posts`.* FROM `blog_posts` WHERE publish_status = '1' LIMIT 0, 8

34. query | 0.0009 sec. | total: 6
SHOW COLUMNS FROM `gallery_album_items`

35. select | 0.00052 sec. | total: 0 (empty)
SELECT `gallery_album_items`.* , `gallery_album_translations`.title as album_title, `gallery_album_translations`.description as album_description, `gallery_album_item_translations`.name as album_item_name, `gallery_album_item_translations`.description as album_item_description FROM `gallery_album_items` INNER JOIN `gallery_album_translations` ON `gallery_album_items`.gallery_album_id = `gallery_album_translations`.gallery_album_id AND gallery_album_translations.language_code = 'en' LEFT OUTER JOIN `gallery_album_item_translations` ON `gallery_album_items`.id = `gallery_album_item_translations`.gallery_album_item_id AND gallery_album_item_translations.language_code = 'en' WHERE gallery_album_items.is_active = 1 ORDER BY gallery_album_items.sort_order ASC LIMIT 0,6

36. select | 0.00031 sec. | total: 3
SELECT `social_networks`.* FROM `social_networks` WHERE is_active = 1 ORDER BY sort_order ASC