User Login

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.07403 sec.
Script running time: 0.04976 sec.
SQL running time: 0.02427 sec.
Total memory usage: 3.89 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\Users\Controllers\UsersController
    [5] => Modules
    [6] => Modules\Users\Components\UsersComponent
    [7] => ModulesSettings
    [8] => Accounts
    [9] => BanLists
    [10] => SocialNetworksLogin
    [11] => SocialNetworks
    [12] => FrontendMenus
    [13] => Modules\News\Components\NewsComponent
    [14] => Modules\News\Models\News
    [15] => Modules\Testimonials\Components\TestimonialsComponent
    [16] => Modules\Testimonials\Models\Testimonials
    [17] => Modules\Advertisements\Components\AdvertisementsComponent
    [18] => Modules\Advertisements\Models\Advertisements
    [19] => Modules\Polls\Components\PollsComponent
    [20] => Modules\Polls\Models\Polls
    [21] => Modules\Blog\Components\BlogComponent
    [22] => Modules\Blog\Models\Posts
    [23] => Modules\Gallery\Components\GalleryComponent
    [24] => Modules\Gallery\Models\GalleryAlbumItems
)

INCLUDED FILES:

Array
(
    [0] => /home/010host/public_html/mydashboard/protected/modules/users/views/users/login.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] => Users
    [action] => login
    [view] => /home/010host/public_html/mydashboard/protected/modules/users/views/users/login.php
    [render-content] => /home/010host/public_html/mydashboard/protected/views/components/newssubscribers.php
    [layout] => default
    [template] => default
    [running_controller] => Modules\Users\Controllers\UsersController
    [running_action] => loginAction
)

$_GET:

Array
(
    [url] => users/login
)

$_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_skog95okeds1fgti1lcpb90j61] => 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$";}}
        )

)

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] => <div class="alert alert-info">Use your accounts username and password to log in here</div>

    [9] => 
    [10] => backend/
    [11] => <div class="title">
<div class="tabs" id="">
<a class="modules-settings-tab" id="tabSettings_link" href="backend/modules/settings/code/users">Settings</a>
<a class="active" id="tabUsers_link" href="users/index">Users</a>
<a id="tabUserGroups_link" href="userGroups/index">User Groups</a>
</div>
</div>

    [12] => 1
    [13] => 1
    [14] => 1
    [15] => 
    [16] => 
    [17] => 
    [18] => 
    [19] => users/login
    [20] => Array
        (
            [0] => Array
                (
                    [label] => Home
                    [url] => Pages/view
                )

            [1] => Array
                (
                    [label] => User Login
                )

        )

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

SQL running time: 0.02427 sec.

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

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

3. query | 0.00098 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.00072 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.00068 sec. | total: 11
SHOW COLUMNS FROM `currencies`

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

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

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

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

13. query | 0.00078 sec. | total: 20
SHOW COLUMNS FROM `accounts`

14. query | 0.00071 sec. | total: 9
SHOW COLUMNS FROM `ban_lists`

15. select | 0.0003 sec. | total: 1
SELECT COUNT(*) as cnt FROM `ban_lists` WHERE item_type = 'ip_address' AND item_value = '3.21.231.245' AND is_active = 1 AND (expires_at IS NULL OR expires_at > '2024-04-28 22:24:48') LIMIT 1

16. query | 0.0012 sec. | total: 7
SHOW COLUMNS FROM `social_networks_login`

17. select | 0.00052 sec. | total: 0 (empty)
SELECT `social_networks_login`.* FROM `social_networks_login` WHERE is_active = 1

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

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

20. select | 0.00027 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.00023 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.0007 sec. | total: 10
SHOW COLUMNS FROM `frontend_menus`

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

25. 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 = '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.00018 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.00039 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. query | 0.00076 sec. | total: 5
SHOW COLUMNS FROM `news`

30. select | 0.00044 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-28 22:24:48' ORDER BY created_at DESC LIMIT 0, 5

31. query | 0.00087 sec. | total: 12
SHOW COLUMNS FROM `testimonials`

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

33. query | 0.00066 sec. | total: 14
SHOW COLUMNS FROM `ads`

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

35. query | 0.00067 sec. | total: 14
SHOW COLUMNS FROM `polls`

36. select | 0.00048 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-28') AND polls.is_active = 1 ORDER BY sort_order DESC, created_at DESC

37. select | 0.00036 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

38. select | 0.00035 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-28 22:24:48' ORDER BY created_at DESC LIMIT 0, 3

39. query | 0.00102 sec. | total: 11
SHOW COLUMNS FROM `blog_posts`

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

41. query | 0.00086 sec. | total: 6
SHOW COLUMNS FROM `gallery_album_items`

42. select | 0.00032 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

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