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.07316 sec.
Script running time: 0.04741 sec.
SQL running time: 0.02575 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] => 1714343677
    [csc_rn4rap5egs2ecea763a5okajbk] => 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://www.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] => 52
    [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.02575 sec.

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

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

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

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

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

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

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

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

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

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

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

13. select | 0.00127 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.00084 sec. | total: 5
SHOW COLUMNS FROM `news`

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

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

17. select | 0.00049 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.001 sec. | total: 7
SHOW COLUMNS FROM `social_networks`

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

20. select | 0.00032 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.00024 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.00046 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.0008 sec. | total: 10
SHOW COLUMNS FROM `frontend_menus`

24. select | 0.00051 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.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 = '9' AND is_active = 1 ORDER BY sort_order ASC

26. 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 parent_id = '1' AND is_active = 1 ORDER BY sort_order ASC

27. select | 0.0003 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.00045 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.00031 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-04-29 01:34:37' ORDER BY created_at DESC LIMIT 0, 5

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

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

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

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

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

35. select | 0.00067 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-04-29') AND polls.is_active = 1 ORDER BY sort_order DESC, created_at DESC

36. select | 0.00045 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.00036 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-04-29 01:34:37' ORDER BY created_at DESC LIMIT 0, 3

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

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

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

41. select | 0.0003 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.00025 sec. | total: 3
SELECT `social_networks`.* FROM `social_networks` WHERE is_active = 1 ORDER BY sort_order ASC