| 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 | 92f45603caf57fb0-FRA |
| HTTP_X_FORWARDED_FOR | 18.219.43.26 |
| HTTP_HOST | m-mtrade.com |
| HTTP_COOKIE | PHPSESSID=uplect87uaq97nvoefaakb9g66 |
| 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_CDN_LOOP | cloudflare; loops=1 |
| HTTP_ACCEPT | */* |
| HTTP_CF_VISITOR | {"scheme":"http"} |
| HTTP_CF_IPCOUNTRY | US |
| HTTP_CONNECTION | Keep-Alive |
| HTTP_CF_CONNECTING_IP | 18.219.43.26 |
| 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 | 162.158.110.141 |
| 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 | 47562 |
| 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 | 1744477814.44 |
| REQUEST_TIME | 1744477814 |
| CURRENT_DATETIME | 13-04-2025 01:10:15 |
| CURRENT_DATE | 13-04-2025 |
| CURRENT_TIME | 01:10:15 |
| CURRENT_DATETIME_ISO_8601 | 2025-04-13T01:10:15+08:00 |
| CURRENT_DATETIME_RFC_2822 | 2025-04-13T01:10:15+08:00 |
| CURRENT_UNIX_TIMESTAMP | 1744477815 |
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"