This is a test news

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.05782 sec.
Script running time: 0.03784 sec.
SQL running time: 0.01998 sec.
Total memory usage: 3.71 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\News\Controllers\NewsController
    [5] => Modules
    [6] => Modules\News\Components\NewsComponent
    [7] => ModulesSettings
    [8] => Modules\News\Models\News
    [9] => SocialNetworks
    [10] => FrontendMenus
    [11] => Modules\Testimonials\Components\TestimonialsComponent
    [12] => Modules\Testimonials\Models\Testimonials
    [13] => Modules\Users\Components\UsersComponent
    [14] => Modules\Advertisements\Components\AdvertisementsComponent
    [15] => Modules\Advertisements\Models\Advertisements
    [16] => Modules\Polls\Components\PollsComponent
    [17] => Modules\Polls\Models\Polls
    [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/news/views/news/view.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] => News
    [action] => view
    [params] => Array
(
    [id] => 1
)

    [view] => /home/010host/public_html/mydashboard/protected/modules/news/views/news/view.php
    [render-content] => /home/010host/public_html/mydashboard/protected/views/components/newssubscribers.php
    [layout] => default
    [template] => default
    [running_controller] => Modules\News\Controllers\NewsController
    [running_action] => viewAction
)

$_GET:

Array
(
    [url] => news/view/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
    [news_hits_1] => 1728163143
    [csc_25239r6f8almsduhuvesl0raja] => 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/news/view/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] => backend/
    [11] => d-m-Y H:i:s
    [12] => d-m-Y
    [13] => <div class="title">
<div class="tabs" id="">
<a class="modules-settings-tab" id="tabSettings_link" href="backend/modules/settings/code/news">Settings</a>
<a class="active" id="tabNews_link" href="news/manage">News</a>
<a id="tabSubscribe_link" href="newsSubscribers/manage">Subscribers</a>
</div>
</div>

    [14] => Array
        (
            [0] => Array
                (
                    [value] => {module:ads}
                    [description] => This shortcode allows you to display advertisement on the site pages
                )

            [1] => Array
                (
                    [value] => {module:banners}
                    [description] => This shortcode allows you to display banners on the site pages (main page)
                )

            [2] => Array
                (
                    [value] => {module:events}
                    [description] => This shortcode allows you to display events on the site pages
                )

            [3] => Array
                (
                    [value] => {module:faq}
                    [description] => This shortcode allows you to display faq on the site pages
                )

            [4] => Array
                (
                    [value] => {module:gallery}
                    [description] => This shortcode allows you to display gallery albums on the site
                )

            [5] => Array
                (
                    [value] => {module:gallery|ID}
                    [description] => This shortcode allows you to display single gallery album on the site
                )

            [6] => Array
                (
                    [value] => {module:gallery|ID|opened}
                    [description] => This shortcode allows you to display single gallery album on the site in opened mode
                )

            [7] => Array
                (
                    [value] => {module:polls}
                    [description] => This shortcode allows you to display polls on the site pages
                )

            [8] => Array
                (
                    [value] => {module:testimonials}
                    [description] => This shortcode allows you to display a list of testimonials on the site pages
                )

            [9] => Array
                (
                    [value] => {module:webforms}
                    [description] => This shortcode allows you to display web forms on the site pages
                )

        )

    [15] => This is a test news
    [16] => This is a test news content. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi mauris mauris, tempor id augue et, vehicula sollicitudin libero. Fusce non lectus ut orci elementum molestie eu eu felis.
    [17] => 354
    [18] => 1.png
    [19] => 01-09-2017 12:45:00
    [20] => Array
        (
            [0] => Array
                (
                    [label] => Home
                    [url] => Pages/view
                )

            [1] => Array
                (
                    [label] => All News
                    [url] => news/viewAll
                )

            [2] => Array
                (
                    [label] => This is a test news
                )

        )

    [21] => allow-optional
    [22] => allow-optional
    [23] => no
)

SQL running time: 0.01998 sec.

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

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

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

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

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

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

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

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

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

11. query | 0.00072 sec. | total: 13
SHOW COLUMNS FROM `module_settings`

12. select | 0.0006 sec. | total: 99
SELECT `module_settings`.* FROM `module_settings`

13. select | 0.00054 sec. | total: 11
SELECT ms.*, m.class_code FROM module_settings ms LEFT JOIN modules m ON ms.module_code = m.code WHERE ms.property_key = 'shortcode' AND m.is_active = 1 AND m.is_installed = 1

14. query | 0.0006 sec. | total: 5
SHOW COLUMNS FROM `news`

15. 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 `news`.id = 1 AND (is_published = 1) LIMIT 1

16. update | 0.00061 sec. | total: 1
UPDATE `news` SET `created_at` = '2017-09-01 12:45:00',`hits` = '354',`intro_image` = '1.png',`is_published` = '1' WHERE id = :primary_key

17. select | 0.00067 sec. | total: 11
SELECT ms.*, m.class_code FROM module_settings ms LEFT JOIN modules m ON ms.module_code = m.code WHERE ms.property_key = 'shortcode' AND m.is_active = 1 AND m.is_installed = 1

18. query | 0.0007 sec. | total: 7
SHOW COLUMNS FROM `social_networks`

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

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

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

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

23. query | 0.00061 sec. | total: 10
SHOW COLUMNS FROM `frontend_menus`

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

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

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

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

28. select | 0.00034 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

29. select | 0.00028 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:19:03' ORDER BY created_at DESC LIMIT 0, 5

30. query | 0.00075 sec. | total: 12
SHOW COLUMNS FROM `testimonials`

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

32. query | 0.00085 sec. | total: 14
SHOW COLUMNS FROM `ads`

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

34. query | 0.00087 sec. | total: 14
SHOW COLUMNS FROM `polls`

35. select | 0.00052 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

36. select | 0.00037 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

37. select | 0.00037 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:19:03' ORDER BY created_at DESC LIMIT 0, 3

38. query | 0.00074 sec. | total: 11
SHOW COLUMNS FROM `blog_posts`

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

40. query | 0.00057 sec. | total: 6
SHOW COLUMNS FROM `gallery_album_items`

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

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