| Variable name | Value |
|---|---|
| PAGE_SHORT_CAPTION | Purchases |
| PAGE_CAPTION | Purchases |
| PAGE_ID | public_purchases |
| PAGE_CSV_EXPORT_LINK | purchases.php?operation=ecsv |
| PAGE_XLS_EXPORT_LINK | purchases.php?operation=eexcel |
| PAGE_PDF_EXPORT_LINK | purchases.php?operation=epdf |
| PAGE_XML_EXPORT_LINK | purchases.php?operation=exml |
| PAGE_WORD_EXPORT_LINK | purchases.php?operation=eword |
| CURRENT_USER_ID | |
| CURRENT_USER_NAME | |
| HTTP_CF_RAY | 9066ca103c3dcf53-FRA |
| HTTP_X_FORWARDED_FOR | 18.227.209.89 |
| HTTP_HOST | populrblog.org |
| HTTP_CF_IPCOUNTRY | US |
| HTTP_ACCEPT_ENCODING | gzip |
| HTTP_USER_AGENT | Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected]) |
| HTTP_X_FORWARDED_PROTO | http |
| HTTP_ACCEPT | */* |
| HTTP_CF_CONNECTING_IP | 18.227.209.89 |
| HTTP_CF_VISITOR | {"scheme":"http"} |
| HTTP_CONNECTION | Keep-Alive |
| HTTP_CDN_LOOP | cloudflare; loops=1 |
| PATH | /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin |
| SERVER_SIGNATURE | Apache/2.4.52 (Ubuntu) Server at populrblog.org Port 80 |
| SERVER_SOFTWARE | Apache/2.4.52 (Ubuntu) |
| SERVER_NAME | populrblog.org |
| SERVER_ADDR | 138.68.109.111 |
| SERVER_PORT | 80 |
| REMOTE_ADDR | 172.70.242.9 |
| DOCUMENT_ROOT | /var/www/html |
| REQUEST_SCHEME | http |
| CONTEXT_PREFIX | |
| CONTEXT_DOCUMENT_ROOT | /var/www/html |
| SERVER_ADMIN | webmaster@localhost |
| SCRIPT_FILENAME | /var/www/html/itemmall/purchases.php |
| REMOTE_PORT | 51268 |
| GATEWAY_INTERFACE | CGI/1.1 |
| SERVER_PROTOCOL | HTTP/1.1 |
| REQUEST_METHOD | GET |
| QUERY_STRING | page=1 |
| REQUEST_URI | /itemmall/purchases.php?page=1 |
| SCRIPT_NAME | /itemmall/purchases.php |
| PHP_SELF | /itemmall/purchases.php |
| REQUEST_TIME_FLOAT | 1737624880.735 |
| REQUEST_TIME | 1737624880 |
| CURRENT_DATETIME | 23-01-2025 17:34:41 |
| CURRENT_DATE | 23-01-2025 |
| CURRENT_TIME | 17:34:41 |
| CURRENT_DATETIME_ISO_8601 | 2025-01-23T17:34:41+08:00 |
| CURRENT_DATETIME_RFC_2822 | 2025-01-23T17:34:41+08:00 |
| CURRENT_UNIX_TIMESTAMP | 1737624881 |
5 queries
SET CLIENT_ENCODING TO 'utf8' SET datestyle = ISO SELECT version() SELECT COUNT(*) FROM "public"."purchases" LEFT OUTER JOIN "public"."account" "LT1" ON "LT1"."id" = "public"."purchases"."account_id" LEFT OUTER JOIN "public"."shop_bundles" "LT2" ON "LT2"."id" = "public"."purchases"."shop_bundle_id" LEFT OUTER JOIN "public"."currency" "LT3" ON "LT3"."id" = "public"."purchases"."currency_id" SELECT "public"."purchases"."id" AS "id", "public"."purchases"."account_id" AS "account_id", "public"."purchases"."shop_bundle_id" AS "shop_bundle_id", "public"."purchases"."bundle_count" AS "bundle_count", "public"."purchases"."total_price" AS "total_price", "public"."purchases"."owner_id" AS "owner_id", "public"."purchases"."currency_id" AS "currency_id", "LT1"."name" AS "LA1", "LT2"."shop_assortment_id" AS "LA2", "LT3"."name" AS "LA3" FROM "public"."purchases" LEFT OUTER JOIN "public"."account" "LT1" ON "LT1"."id" = "public"."purchases"."account_id" LEFT OUTER JOIN "public"."shop_bundles" "LT2" ON "LT2"."id" = "public"."purchases"."shop_bundle_id" LEFT OUTER JOIN "public"."currency" "LT3" ON "LT3"."id" = "public"."purchases"."currency_id"