datavail.getrealproof.com
Open in
urlscan Pro
2a06:98c1:3121::a
Public Scan
Submitted URL: http://datavail.getrealproof.com/
Effective URL: https://datavail.getrealproof.com/
Submission: On May 26 via api from US — Scanned from DE
Effective URL: https://datavail.getrealproof.com/
Submission: On May 26 via api from US — Scanned from DE
Form analysis
5 forms found in the DOMPOST /debug_kit/toolbar_access/sql_explain
<form action="/debug_kit/toolbar_access/sql_explain" id="logForm0_8395" method="post" accept-charset="utf-8">
<div style="display:none;"><input type="hidden" name="_method" value="POST"><input type="hidden" name="data[_Token][key]" value="a7aa400ef2a28afb455f2273ae14325c9359609d" id="Token1317629396"></div><input type="hidden" name="data[log][ds]"
id="logDs0_8395" value="default"><input type="hidden" name="data[log][sql]" id="logSql0_8395"
value="SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `db_datavail`.`acos` AS `Aco` WHERE 1 = 1"><input type="hidden" name="data[log][hash]" id="logHash0_8395"
value="9b9f87b58cd84d016b4723370ecab049e0d31fcd"><input class="sql-explain-link" type="submit" value="Explain">
<div style="display:none;"><input type="hidden" name="data[_Token][fields]" value="789273035d73e5b9644a755d690630bf548a1ac1%3Alog.ds%7Clog.hash%7Clog.sql" id="TokenFields1117643072"><input type="hidden" name="data[_Token][unlocked]" value=""
id="TokenUnlocked140133678"></div>
</form>
POST /debug_kit/toolbar_access/sql_explain
<form action="/debug_kit/toolbar_access/sql_explain" id="logForm1_7763" method="post" accept-charset="utf-8">
<div style="display:none;"><input type="hidden" name="_method" value="POST"><input type="hidden" name="data[_Token][key]" value="a7aa400ef2a28afb455f2273ae14325c9359609d" id="Token1879677415"></div><input type="hidden" name="data[log][ds]"
id="logDs1_7763" value="default"><input type="hidden" name="data[log][sql]" id="logSql1_7763"
value="SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght` FROM `db_datavail`.`aros` AS `Aro` WHERE `model` = 'Group'"><input type="hidden" name="data[log][hash]" id="logHash1_7763"
value="ba09d51c1613dcf700d847f5662c05525907cf17"><input class="sql-explain-link" type="submit" value="Explain">
<div style="display:none;"><input type="hidden" name="data[_Token][fields]" value="2fda16e43fe8757dc9f929538bacc33fe2fb3ee8%3Alog.ds%7Clog.hash%7Clog.sql" id="TokenFields1762527378"><input type="hidden" name="data[_Token][unlocked]" value=""
id="TokenUnlocked366729112"></div>
</form>
POST /debug_kit/toolbar_access/sql_explain
<form action="/debug_kit/toolbar_access/sql_explain" id="logForm2_3160" method="post" accept-charset="utf-8">
<div style="display:none;"><input type="hidden" name="_method" value="POST"><input type="hidden" name="data[_Token][key]" value="a7aa400ef2a28afb455f2273ae14325c9359609d" id="Token501531085"></div><input type="hidden" name="data[log][ds]"
id="logDs2_3160" value="default"><input type="hidden" name="data[log][sql]" id="logSql2_3160"
value="SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght`, `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete` FROM `db_datavail`.`acos` AS `Aco` JOIN `db_datavail`.`aros_acos` AS `Permission` ON (`Permission`.`aro_id` IN (2, 3, 4, 15, 16, 101) AND `Permission`.`aco_id` = `Aco`.`id`) "><input
type="hidden" name="data[log][hash]" id="logHash2_3160" value="0b6669329bf1f471be5a90f61e1206a590ca9f65"><input class="sql-explain-link" type="submit" value="Explain">
<div style="display:none;"><input type="hidden" name="data[_Token][fields]" value="944dd59922954c0d40e634f9cd06a8916edeee99%3Alog.ds%7Clog.hash%7Clog.sql" id="TokenFields674215363"><input type="hidden" name="data[_Token][unlocked]" value=""
id="TokenUnlocked853510401"></div>
</form>
POST /debug_kit/toolbar_access/sql_explain
<form action="/debug_kit/toolbar_access/sql_explain" id="logForm3_3303" method="post" accept-charset="utf-8">
<div style="display:none;"><input type="hidden" name="_method" value="POST"><input type="hidden" name="data[_Token][key]" value="a7aa400ef2a28afb455f2273ae14325c9359609d" id="Token34859292"></div><input type="hidden" name="data[log][ds]"
id="logDs3_3303" value="default"><input type="hidden" name="data[log][sql]" id="logSql3_3303"
value="SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght` FROM `db_datavail`.`aros` AS `Aro` WHERE `model` = 'User'"><input type="hidden" name="data[log][hash]" id="logHash3_3303"
value="e591b791cf7b72998b63897ca06283e2aac41705"><input class="sql-explain-link" type="submit" value="Explain">
<div style="display:none;"><input type="hidden" name="data[_Token][fields]" value="7a9608777d3612beccafaed8ba07063900c6fbe1%3Alog.ds%7Clog.hash%7Clog.sql" id="TokenFields1292650206"><input type="hidden" name="data[_Token][unlocked]" value=""
id="TokenUnlocked1348877339"></div>
</form>
POST /debug_kit/toolbar_access/sql_explain
<form action="/debug_kit/toolbar_access/sql_explain" id="logForm4_4487" method="post" accept-charset="utf-8">
<div style="display:none;"><input type="hidden" name="_method" value="POST"><input type="hidden" name="data[_Token][key]" value="a7aa400ef2a28afb455f2273ae14325c9359609d" id="Token861097658"></div><input type="hidden" name="data[log][ds]"
id="logDs4_4487" value="default"><input type="hidden" name="data[log][sql]" id="logSql4_4487"
value="SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght`, `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete` FROM `db_datavail`.`acos` AS `Aco` JOIN `db_datavail`.`aros_acos` AS `Permission` ON (`Permission`.`aro_id` IN (1, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 29, 30, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 85, 97, 98, 99, 100, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112) AND `Permission`.`aco_id` = `Aco`.`id`) "><input
type="hidden" name="data[log][hash]" id="logHash4_4487" value="5e60aaae3e7dbbba54e96cdd7b7c73913e5f6ee5"><input class="sql-explain-link" type="submit" value="Explain">
<div style="display:none;"><input type="hidden" name="data[_Token][fields]" value="e642376932611a814b75052d7d517a1e8cd7ec33%3Alog.ds%7Clog.hash%7Clog.sql" id="TokenFields273123003"><input type="hidden" name="data[_Token][unlocked]" value=""
id="TokenUnlocked252980729"></div>
</form>
Text Content
* * History + REQUEST HISTORY No previous requests logged. ==== * Session + SESSION * Config(array) * userAgent0f627b53ac79da7d9f80e1ee106c8b67 * time1653667578 * countdown10 * languageen * _Token(array) * keya7aa400ef2a28afb455f2273ae14325c9359609d * allowedControllers(empty) * allowedActions(empty) * unlockedFields(empty) * csrfTokens(array) * a7aa400ef2a28afb455f2273ae14325c9359609d1653582978 ==== * Request + REQUEST CAKE PARAMS * pluginhomes * controllerhomes * actionfront_index * named(empty) * pass(empty) * _Token(array) * keya7aa400ef2a28afb455f2273ae14325c9359609d * unlockedFields(empty) POST DATA No post data. QUERY STRING No querystring data. COOKIE * 0(empty) CURRENT ROUTE * keys(empty) * options(empty) * defaults(array) * pluginhomes * controllerhomes * actionfront_index * template/ ==== * Sql Log + SQL LOGS DEFAULT TOTAL TIME: 8 MS TOTAL QUERIES: 5 QUERIES Query Affected Num. rows Took (ms) ActionsSELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `db_datavail`.`acos` AS `Aco` WHERE 1 = 1 597 597 1 SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght` FROM `db_datavail`.`aros` AS `Aro` WHERE `model` = 'Group' 6 6 0 SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght`, `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete` FROM `db_datavail`.`acos` AS `Aco` JOIN `db_datavail`.`aros_acos` AS `Permission` ON (`Permission`.`aro_id` IN (2, 3, 4, 15, 16, 101) AND `Permission`.`aco_id` = `Aco`.`id`) 1429 1429 5 SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght` FROM `db_datavail`.`aros` AS `Aro` WHERE `model` = 'User' 77 77 1 SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght`, `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete` FROM `db_datavail`.`acos` AS `Aco` JOIN `db_datavail`.`aros_acos` AS `Permission` ON (`Permission`.`aro_id` IN (1, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 29, 30, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 85, 97, 98, 99, 100, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112) AND `Permission`.`aco_id` = `Aco`.`id`) 0 0 1 maybe slow QUERY EXPLAIN: Click an "Explain" link above, to see the query explanation. ==== * Timer + MEMORY Peak Memory Use 10.63 MB Message Memory useComponent initialization 1.63 MB Controller action start 3.21 MB Controller render start 3.29 MB View render complete 3.76 MB TIMERS Total Request Time: 156 (ms) Message Time in ms GraphCore Processing (Derived from $_SERVER["REQUEST_TIME"]) 8.59 Event: Controller.initialize 96.45 Event: Controller.startup 0.52 Controller action 0.45 Event: Controller.beforeRender 7.09 » Processing toolbar data 6.98 Rendering View 9.85 » Event: View.beforeRender 0.05 » Rendering APP/Plugin/Homes/View/Homes/front_index.ctp 0.17 » Event: View.afterRender 0.03 » Event: View.beforeLayout 0.03 » Rendering APP/View/Themed/Kdp/Layouts/default.ctp 5.45 » » Rendering APP/View/Themed/Kdp/Elements/header.ctp 0.16 » » Rendering APP/View/Themed/Kdp/Elements/footer.ctp 0.13 » » Rendering APP/View/Themed/Kdp/Elements/modal.ctp 0.13 Event: View.afterLayout 0.00 ==== * Log + LOGS There were no log entries made this request ==== * Variables + VIEW VARIABLES * title_for_layoutHome Page * availableLanguages(array) * enen * vivi * languageen * modelVisitor * jshomes * $request->data(empty) * $this->validationErrors(array) * Permission(empty) * Aro(empty) * Aco(empty) * Visitor(empty) * Loaded Helpers(array) * 0Html * 1Form * 2Session * 3Acl * 4Time * 5Text * 6Number * 7SimpleGraph * 8DebugTimer * 9Toolbar * 10HtmlToolbar ==== * Environment + APP CONSTANTS Constant ValueENVIRONMENT dev CAKEPHP CONSTANTS Constant ValueAPP /var/www/html/realproofclient/app/ APP_DIR app APPLIBS /var/www/html/realproofclient/app/Lib/ CACHE /var/www/html/realproofclient/app/tmp/cache/ CAKE /var/www/html/realproofclient/lib/Cake/ CAKE_CORE_INCLUDE_PATH /var/www/html/realproofclient/lib CORE_PATH /var/www/html/realproofclient/lib/ CAKE_VERSION 2.5.6 CSS /var/www/html/realproofclient/app/webroot/css/ CSS_URL css/ DS / FULL_BASE_URL http://datavail.getrealproof.com IMAGES /var/www/html/realproofclient/app/webroot/img/ IMAGES_URL img/ JS /var/www/html/realproofclient/app/webroot/js/ JS_URL js/ LOGS /var/www/html/realproofclient/app/tmp/logs/ ROOT /var/www/html/realproofclient TESTS /var/www/html/realproofclient/app/Test/ TMP /var/www/html/realproofclient/app/tmp/ VENDORS /var/www/html/realproofclient/vendors/ WEBROOT_DIR webroot WWW_ROOT /var/www/html/realproofclient/app/webroot/ PHP ENVIRONMENT Environment Variable ValuePhp Version 5.6.37-1+ubuntu16.04.1+deb.sury.org+1 Environment datavail Http Host datavail.getrealproof.com Http Connection Keep-Alive Http Accept Encoding gzip Http Cf Ipcountry DE Http X Forwarded For 2a02:6ea0:c71b:0:1011:4c0:ec7c:89b8 Http Cf Ray 7117c1dc5c589a00-SJC Http X Forwarded Proto https Http Cf Visitor {"scheme":"https"} Http Pragma no-cache Http Cache Control no-cache Http Upgrade Insecure Requests 1 Http User Agent Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.61 Safari/537.36 Http Accept Language de-DE,de;q=0.9 Http Accept text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9 Http Sec Fetch Site none Http Sec Fetch Mode navigate Http Sec Fetch User ?1 Http Sec Fetch Dest document Http Cf Connecting Ip 2a02:6ea0:c71b:0:1011:4c0:ec7c:89b8 Http Cdn Loop cloudflare Path /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin Server Signature <address>Apache/2.4.18 (Ubuntu) Server at datavail.getrealproof.com Port 80</address> Server Software Apache/2.4.18 (Ubuntu) Server Name datavail.getrealproof.com Server Addr 104.248.190.220 Server Port 80 Remote Addr 172.68.133.247 Document Root /var/www/html/realproofclient/app/webroot Request Scheme http Context Prefix Context Document Root /var/www/html/realproofclient/app/webroot Server Admin chuyenlee.html@gmail.com Script Filename /var/www/html/realproofclient/app/webroot/index.php Remote Port 24304 Gateway Interface CGI/1.1 Server Protocol HTTP/1.1 Request Method GET Query String Request Uri / Script Name /index.php Php Self /index.php Request Time Float 1653581178.406 Request Time 1653581178 ==== * Include + INCLUDED FILES INCLUDE PATHS * 0/var/www/html/realproofclient/lib * 2/usr/share/php * 3-> /var/www/html/realproofclient/lib/Cake/ INCLUDED FILES * core(array) * Behavior(array) * 0CORE/Model/Behavior/TreeBehavior.php * Cache(array) * 0CORE/Cache/Cache.php * 1CORE/Cache/Engine/FileEngine.php * 2CORE/Cache/CacheEngine.php * Component(array) * 0CORE/Controller/Component/SessionComponent.php * 1CORE/Controller/Component/AclComponent.php * 2CORE/Controller/Component/Acl/DbAcl.php * 3CORE/Controller/Component/Acl/AclInterface.php * 4CORE/Controller/Component/AuthComponent.php * 5CORE/Controller/Component/CookieComponent.php * 6CORE/Controller/Component/PaginatorComponent.php * 7CORE/Controller/Component/SecurityComponent.php * Config(array) * 0CORE/Config/routes.php * 1CORE/Config/config.php * Controller(array) * 0CORE/Controller/Controller.php * 1CORE/Controller/ComponentCollection.php * 2CORE/Controller/Component.php * Datasource(array) * 0CORE/Model/Datasource/CakeSession.php * 1CORE/Model/Datasource/Database/Mysql.php * 2CORE/Model/Datasource/DboSource.php * 3CORE/Model/Datasource/DataSource.php * Error(array) * 0CORE/Error/exceptions.php * 1CORE/Error/ErrorHandler.php * I18n(array) * 0CORE/I18n/I18n.php * 1CORE/I18n/L10n.php * Log(array) * 0CORE/Log/CakeLog.php * 1CORE/Log/LogEngineCollection.php * 2CORE/Log/Engine/FileLog.php * 3CORE/Log/Engine/BaseLog.php * 4CORE/Log/CakeLogInterface.php * Model(array) * 0CORE/Model/Permission.php * 1CORE/Model/Model.php * 2CORE/Model/BehaviorCollection.php * 3CORE/Model/Aro.php * 4CORE/Model/AclNode.php * 5CORE/Model/Aco.php * 6CORE/Model/ModelBehavior.php * 7CORE/Model/ConnectionManager.php * Network(array) * 0CORE/Network/CakeRequest.php * 1CORE/Network/CakeResponse.php * 2CORE/Network/Email/CakeEmail.php * 3CORE/Network/Email/SmtpTransport.php * 4CORE/Network/Email/AbstractTransport.php * Other(array) * 0CORE/bootstrap.php * 1CORE/basics.php * 2CORE/Core/App.php * 3CORE/Core/Configure.php * 4CORE/Core/CakePlugin.php * 5CORE/Event/CakeEventListener.php * 6CORE/Event/CakeEvent.php * 7CORE/Event/CakeEventManager.php * 8CORE/Core/Object.php * Routing(array) * 0CORE/Routing/Dispatcher.php * 1CORE/Routing/Filter/AssetDispatcher.php * 2CORE/Routing/DispatcherFilter.php * 3CORE/Routing/Filter/CacheDispatcher.php * 4CORE/Routing/Router.php * 5CORE/Routing/Route/CakeRoute.php * 6CORE/Routing/Route/PluginShortRoute.php * Utility(array) * 0CORE/Utility/Hash.php * 1CORE/Utility/Inflector.php * 2CORE/Utility/ObjectCollection.php * 3CORE/Utility/Debugger.php * 4CORE/Utility/String.php * 5CORE/Utility/ClassRegistry.php * 6CORE/Utility/Security.php * View(array) * 0CORE/View/HelperCollection.php * app(array) * Component(array) * 0APP/Controller/Component/SystemConfigComponent.php * 1APP/Controller/Component/CallRailComponent.php * 2APP/Controller/Component/CtmComponent.php * 3APP/Controller/Component/MailerComponent.php * 4APP/Controller/Component/UpdateDataComponent.php * 5APP/Controller/Component/UtilComponent.php * Config(array) * 0APP/Config/core.php * 1APP/Config/bootstrap.php * 2APP/Config/routes.php * 3APP/Config/email.php * 4APP/Config/database.php * Controller(array) * 0APP/Controller/AppController.php * Model(array) * 0APP/Model/AppModel.php * Other(array) * 0APP/webroot/index.php * plugins(array) * Core(array) * Controller(array) * 0Core/Controller/CoreAppController.php * Model(array) * 0Core/Model/CoreAppModel.php * DebugKit(array) * Component(array) * 0DebugKit/Controller/Component/ToolbarComponent.php * Plugin(array) * 0DebugKit/Lib/DebugMemory.php * 1DebugKit/Lib/Panel/HistoryPanel.php * 2DebugKit/Lib/DebugPanel.php * 3DebugKit/Lib/Panel/SessionPanel.php * 4DebugKit/Lib/Panel/RequestPanel.php * 5DebugKit/Lib/Panel/SqlLogPanel.php * 6DebugKit/Lib/Panel/TimerPanel.php * 7DebugKit/Lib/Panel/LogPanel.php * 8DebugKit/Lib/Log/Engine/DebugKitLog.php * 9DebugKit/Lib/Panel/VariablesPanel.php * 10DebugKit/Lib/Panel/EnvironmentPanel.php * 11DebugKit/Lib/Panel/IncludePanel.php * 12DebugKit/Lib/DebugTimer.php * Homes(array) * Controller(array) * 0Homes/Controller/HomesController.php * 1Homes/Controller/HomesAppController.php * Search(array) * Component(array) * 0Search/Controller/Component/PrgComponent.php * Visitors(array) * Model(array) * 0Visitors/Model/Visitor.php * 1Visitors/Model/VisitorsAppModel.php ====