Polls Archive

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.04706 sec.
Script running time: 0.0309 sec.
SQL running time: 0.01616 sec.
Total memory usage: 3.57 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] => SocialNetworks
    [8] => FrontendMenus
    [9] => Modules\News\Components\NewsComponent
    [10] => ModulesSettings
    [11] => Modules\News\Models\News
    [12] => Modules\Testimonials\Components\TestimonialsComponent
    [13] => Modules\Testimonials\Models\Testimonials
    [14] => Modules\Users\Components\UsersComponent
    [15] => Modules\Advertisements\Components\AdvertisementsComponent
    [16] => Modules\Advertisements\Models\Advertisements
    [17] => Modules\Polls\Components\PollsComponent
    [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/showall.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] => showAll
    [view] => /home/010host/public_html/mydashboard/protected/modules/polls/views/polls/showall.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] => showAllAction
)

$_GET:

Array
(
    [url] => polls/showAll
)

$_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_tljo33mthe63g0sjis71dd251i] => 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/showAll
)

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] => 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
                )

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

        )

    [9] => polls/showAll
    [10] => Array
        (
            [0] => Array
                (
                    [label] => Home
                    [url] => Pages/view
                )

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

        )

    [11] => allow-optional
    [12] => allow-optional
    [13] => no
)

SQL running time: 0.01616 sec.

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

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

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

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

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

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

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

8. select | 0.00021 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.00069 sec. | total: 16
SHOW COLUMNS FROM `modules`

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

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

12. select | 0.00038 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' ORDER BY created_at DESC

13. query | 0.00061 sec. | total: 7
SHOW COLUMNS FROM `social_networks`

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

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

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

17. select | 0.00026 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

18. query | 0.00063 sec. | total: 10
SHOW COLUMNS FROM `frontend_menus`

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

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

21. select | 0.00021 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

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

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

24. query | 0.00056 sec. | total: 13
SHOW COLUMNS FROM `module_settings`

25. select | 0.00054 sec. | total: 99
SELECT `module_settings`.* FROM `module_settings`

26. query | 0.00057 sec. | total: 5
SHOW COLUMNS FROM `news`

27. select | 0.00029 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-10-06 00:10:57' ORDER BY created_at DESC LIMIT 0, 5

28. query | 0.0006 sec. | total: 12
SHOW COLUMNS FROM `testimonials`

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

30. query | 0.00056 sec. | total: 14
SHOW COLUMNS FROM `ads`

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

32. select | 0.00042 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-10-06') AND polls.is_active = 1 ORDER BY sort_order DESC, created_at DESC

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

34. select | 0.00023 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-10-06 00:10:57' ORDER BY created_at DESC LIMIT 0, 3

35. query | 0.00066 sec. | total: 11
SHOW COLUMNS FROM `blog_posts`

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

37. query | 0.00047 sec. | total: 6
SHOW COLUMNS FROM `gallery_album_items`

38. select | 0.00023 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

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