Database Queries

Total 7 items.
TimeDurationTypeQuery
  
14:05:30.6700.6 msSELECTSELECT * FROM `pvsell_tours` WHERE `active`=1

14:05:30.6711.1 msSELECTSELECT * FROM `pvsell_tour_steps` WHERE `tour_id` IN (1, 2, 12) ORDER BY (CASE WHEN `step_order` IS NULL THEN 1 ELSE 0 END), `step_order`

14:05:30.67610.7 msSELECTSELECT `data` FROM `session` WHERE `expire`>1744430730 AND `id`='jk159hcsq4kt0fot2kmaod5ni5'

14:05:30.6913.6 msINSERTINSERT INTO `snap_log` (`level`, `category`, `log_time`, `prefix`, `message`) VALUES (1, 'yii\\web\\HttpException:404', 1744430730.666, '[3.12.160.150][-][jk159hcsq4kt0fot2kmaod5ni5]', 'yii\\base\\InvalidRouteException: Unable to resolve the request \"robots.txt\". in /var/www/pvsell_staging/vendor/yiisoft/yii2/base/Module.php:460\nStack trace:\n#0 /var/www/pvsell_staging/vendor/yiisoft/yii2/web/Application.php(84): yii\\base\\Module->runAction(\'robots.txt\', Array)\n#1 /var/www/pvsell_staging/vendor/yiisoft/yii2/base/Application.php(375): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))\n#2 /var/www/pvsell_staging/public_html/index.php(39): yii\\base\\Application->run()\n#3 {main}\n\nNext yii\\web\\NotFoundHttpException: Page not found. in /var/www/pvsell_staging/vendor/yiisoft/yii2/web/Application.php:96\nStack trace:\n#0 /var/www/pvsell_staging/vendor/yiisoft/yii2/base/Application.php(375): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))\n#1 /var/www/pvsell_staging/public_html/index.php(39): yii\\base\\Application->run()\n#2 {main}')

14:05:30.6953.5 msINSERTINSERT INTO `snap_log` (`level`, `category`, `log_time`, `prefix`, `message`) VALUES (4, 'application', 1744430730.6641, '[3.12.160.150][-][jk159hcsq4kt0fot2kmaod5ni5]', '$_SESSION = [\n \'__flash\' => []\n]\n\n$_SERVER = [\n \'REDIRECT_SCRIPT_URL\' => \'/robots.txt\'\n \'REDIRECT_SCRIPT_URI\' => \'https://staging.pvsell.com.au/robots.txt\'\n \'REDIRECT_HTTPS\' => \'on\'\n \'REDIRECT_SSL_TLS_SNI\' => \'staging.pvsell.com.au\'\n \'REDIRECT_STATUS\' => \'200\'\n \'SCRIPT_URL\' => \'/robots.txt\'\n \'SCRIPT_URI\' => \'https://staging.pvsell.com.au/robots.txt\'\n \'HTTPS\' => \'on\'\n \'SSL_TLS_SNI\' => \'staging.pvsell.com.au\'\n \'HTTP_ACCEPT\' => \'*/*\'\n \'HTTP_USER_AGENT\' => \'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\'\n \'HTTP_ACCEPT_ENCODING\' => \'gzip, br, zstd, deflate\'\n \'HTTP_HOST\' => \'staging.pvsell.com.au\'\n \'PATH\' => \'/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin\'\n \'SERVER_SIGNATURE\' => \'<address>Apache/2.4.25 (Debian) Server at staging.pvsell.com.au Port 443</address>\n\'\n \'SERVER_SOFTWARE\' => \'Apache/2.4.25 (Debian)\'\n \'SERVER_NAME\' => \'staging.pvsell.com.au\'\n \'SERVER_ADDR\' => \'10.240.0.8\'\n \'SERVER_PORT\' => \'443\'\n \'REMOTE_ADDR\' => \'3.12.160.150\'\n \'DOCUMENT_ROOT\' => \'/var/www/pvsell_staging/public_html\'\n \'REQUEST_SCHEME\' => \'https\'\n \'CONTEXT_PREFIX\' => \'\'\n \'CONTEXT_DOCUMENT_ROOT\' => \'/var/www/pvsell_staging/public_html\'\n \'SERVER_ADMIN\' => \'webmaster@localhost\'\n \'SCRIPT_FILENAME\' => \'/var/www/pvsell_staging/public_html/index.php\'\n \'REMOTE_PORT\' => \'54801\'\n \'REDIRECT_URL\' => \'/robots.txt\'\n \'GATEWAY_INTERFACE\' => \'CGI/1.1\'\n \'SERVER_PROTOCOL\' => \'HTTP/1.1\'\n \'REQUEST_METHOD\' => \'GET\'\n \'QUERY_STRING\' => \'\'\n \'REQUEST_URI\' => \'/robots.txt\'\n \'SCRIPT_NAME\' => \'/index.php\'\n \'PHP_SELF\' => \'/index.php\'\n \'REQUEST_TIME_FLOAT\' => 1744430730.662\n \'REQUEST_TIME\' => 1744430730\n]')

14:05:30.7000.8 msSELECTSELECT `id` FROM `session` WHERE `id`='jk159hcsq4kt0fot2kmaod5ni5'

14:05:30.7013.2 msINSERTINSERT INTO `session` (`data`, `user_id`, `ip`, `id`, `expire`) VALUES ('__flash|a:0:{}', NULL, NULL, 'jk159hcsq4kt0fot2kmaod5ni5', 1744496265)