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.14764 sec.
Script running time: 0.09838 sec.
SQL running time: 0.04926 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] => Languages
    [3] => Currencies
    [4] => Modules\Polls\Controllers\PollsController
    [5] => Modules
    [6] => Modules\Polls\Models\Polls
    [7] => Modules\Polls\Components\PollsComponent
    [8] => ModulesSettings
    [9] => SocialNetworks
    [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] => 1
)

    [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/1
)

$_POST:

Array
(
)

$_FILES:

Array
(
)

$_COOKIE:

Array
(
)

$_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_jlb86lnqo6q3ndp7kqg4pn2i2a] => 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/1
)

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] => 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
                    [total_votes] => 13
                    [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] => 
                )

            [_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] => 1
            [_primaryKey:CActiveRecord:private] => id
            [_isNewRecord:CActiveRecord:private] => 
        )

    [11] => Array
        (
            [0] => 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
                    [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
                    [total_votes] => 25
                )

        )

    [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.04926 sec.

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

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

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

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

5. query | 0.00103 sec. | total: 11
SHOW COLUMNS FROM `languages`

6. select | 0.00029 sec. | total: 1
SELECT `languages`.* FROM `languages` WHERE is_default = 1 LIMIT 1

7. query | 0.00271 sec. | total: 11
SHOW COLUMNS FROM `currencies`

8. select | 0.00087 sec. | total: 1
SELECT `currencies`.* , IF(symbol_place = "before", CONCAT(symbol_place, " (", symbol, 100, ")"), CONCAT(symbol_place, " (", 100, "", symbol, ")")) as example_symbol_place FROM `currencies` WHERE is_default = 1 LIMIT 1

9. query | 0.00145 sec. | total: 16
SHOW COLUMNS FROM `modules`

10. select | 0.00044 sec. | total: 17
SELECT `modules`.* FROM `modules`

11. query | 0.0044 sec. | total: 14
SHOW COLUMNS FROM `polls`

12. select | 0.00086 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 = 1 LIMIT 1

13. select | 0.00074 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 != 1 ORDER BY created_at ASC

14. query | 0.00121 sec. | total: 13
SHOW COLUMNS FROM `module_settings`

15. select | 0.00077 sec. | total: 99
SELECT `module_settings`.* FROM `module_settings`

16. query | 0.00098 sec. | total: 7
SHOW COLUMNS FROM `social_networks`

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

18. select | 0.00061 sec. | total: 1
SELECT COUNT(*) as cnt FROM `languages` WHERE is_active = 1 AND used_on IN ('front-end', 'global') LIMIT 1

19. select | 0.00034 sec. | total: 1
SELECT `languages`.* FROM `languages` WHERE is_active = 1 AND used_on IN ('front-end', 'global') ORDER BY sort_order ASC

20. select | 0.00055 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

21. query | 0.0011 sec. | total: 10
SHOW COLUMNS FROM `frontend_menus`

22. select | 0.00088 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

23. select | 0.00323 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

24. select | 0.00357 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

25. select | 0.00042 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

26. select | 0.00832 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

27. query | 0.00111 sec. | total: 5
SHOW COLUMNS FROM `news`

28. select | 0.0005 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 04:06:01' ORDER BY created_at DESC LIMIT 0, 5

29. query | 0.00106 sec. | total: 12
SHOW COLUMNS FROM `testimonials`

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

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

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

33. select | 0.00064 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

34. select | 0.00046 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

35. select | 0.00043 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 04:06:01' ORDER BY created_at DESC LIMIT 0, 3

36. query | 0.00109 sec. | total: 11
SHOW COLUMNS FROM `blog_posts`

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

38. query | 0.00114 sec. | total: 6
SHOW COLUMNS FROM `gallery_album_items`

39. select | 0.00043 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

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