| 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 | 8fbca4349866ad43-FRA |
| HTTP_USER_AGENT | Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected]) |
| HTTP_HOST | m-mtrade.com |
| HTTP_CF_IPCOUNTRY | US |
| HTTP_ACCEPT_ENCODING | gzip, br |
| HTTP_X_FORWARDED_FOR | 18.222.182.226 |
| HTTP_X_FORWARDED_PROTO | https |
| HTTP_ACCEPT | */* |
| HTTP_CF_CONNECTING_IP | 18.222.182.226 |
| HTTP_CF_VISITOR | {"scheme":"https"} |
| 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 m-mtrade.com Port 80 |
| SERVER_SOFTWARE | Apache/2.4.52 (Ubuntu) |
| SERVER_NAME | m-mtrade.com |
| SERVER_ADDR | 138.68.109.111 |
| SERVER_PORT | 80 |
| REMOTE_ADDR | 172.70.247.144 |
| 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 | 9998 |
| GATEWAY_INTERFACE | CGI/1.1 |
| SERVER_PROTOCOL | HTTP/1.1 |
| REQUEST_METHOD | GET |
| QUERY_STRING | page=0 |
| REQUEST_URI | /itemmall/purchases.php?page=0 |
| SCRIPT_NAME | /itemmall/purchases.php |
| PHP_SELF | /itemmall/purchases.php |
| REQUEST_TIME_FLOAT | 1735840750.887 |
| REQUEST_TIME | 1735840750 |
| CURRENT_DATETIME | 03-01-2025 01:59:11 |
| CURRENT_DATE | 03-01-2025 |
| CURRENT_TIME | 01:59:11 |
| CURRENT_DATETIME_ISO_8601 | 2025-01-03T01:59:11+08:00 |
| CURRENT_DATETIME_RFC_2822 | 2025-01-03T01:59:11+08:00 |
| CURRENT_UNIX_TIMESTAMP | 1735840751 |
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"