=== COCONUT AI - PERFORMANCE DIAGNOSTIC ===
Date: 2026-09-12 13:21:34 UTC
============================================

php_version: 8.2.33
sapi: fpm-fcgi
opcache_enabled: 1
apcu_enabled: 1
max_execution_time: 30
db_connect_localhost_ms: 0.19
db_connect_localhost_error: none
db_connect_127001_ms: 0.34
db_connect_127001_error: none
db_connect_init_real_localhost_ms: 0.11
db_connect_init_real_error: none
db_connect_init_real_127001_ms: 0.29
db_connect_init_real_127001_error: none
query_select1_ms: 0.08
query_auth_constants_ms: 0.03
query_sessions_tables_ms: 0.02
indexes:
  constants: PRIMARY(name)
  sessions_tables: PRIMARY(id), vendor_table_unique(vendorId), vendor_table_unique(tableId), idx_sessions_tables_vendor(vendorId), idx_sessions_tables_table(tableId), idx_sessions_tables_vendor_table(vendorId), idx_sessions_tables_vendor_table(tableId)
  sessionItems: PRIMARY(id), idx_sessionitems_session_vendor(sessionId), idx_sessionitems_session_vendor(vendorId), idx_sessionitems_vendor_state(vendorId), idx_sessionitems_vendor_state(state), idx_sessionitems_vendor_kitchen(vendorId), idx_sessionitems_vendor_kitchen(kitchenHandled), idx_sessionitems_vendor_kitchen(state), idx_sessionitems_itemset(belongsToSessionItemSetId), idx_sessionitems_vendor_itemset(vendorId), idx_sessionitems_vendor_itemset(isMenuItemSet), idx_sessionitems_online_order(onlineOrderId), idx_sessionitems_online_order_item(onlineOrderItemId), fk_session_item_customer(customerUserId)
  sessionCustomers: PRIMARY(id), uk_sessionCustomers_customer_session_vendor(customerUserId), uk_sessionCustomers_customer_session_vendor(sessionId), uk_sessionCustomers_customer_session_vendor(vendorId), idx_sessioncustomers_session(sessionId), idx_sessioncustomers_authtoken(authToken), idx_sessioncustomers_vendor(vendorId), idx_sessionCustomers_customer_session(customerUserId), idx_sessionCustomers_customer_session(sessionId)
  tables: PRIMARY(id), url(url), idx_tables_vendor(vendorId), idx_tables_vendor_disabled(vendorId), idx_tables_vendor_disabled(disabled), fk_tables_tableGroupId(tableGroupId)
explain_auth:
  id: 1
  select_type: SIMPLE
  table: constants
  type: const
  possible_keys: PRIMARY
  key: PRIMARY
  key_len: 152
  ref: const
  rows: 1
  Extra: 
table_sizes_top15:
  0: translationBaselinesItems: 10014 rows, data=1552KB, idx=464KB
  1: translationsMenuItems: 6031 rows, data=1552KB, idx=224KB
  2: translationsMenuOptions: 2944 rows, data=320KB, idx=96KB
  3: translationsMenuItemModifications: 1426 rows, data=160KB, idx=64KB
  4: translationBaselinesCategories: 1280 rows, data=96KB, idx=48KB
  5: translationsMenuOptionSets: 565 rows, data=80KB, idx=16KB
  6: translationsRequestableItems: 870 rows, data=80KB, idx=0KB
  7: menuItems: 307 rows, data=64KB, idx=80KB
  8: translationsMenuSubCategories: 490 rows, data=64KB, idx=32KB
  9: translationBaselinesOptionSets: 520 rows, data=64KB, idx=16KB
  10: receiptItems: 228 rows, data=64KB, idx=48KB
  11: menuItemTaxAssignments: 164 rows, data=48KB, idx=32KB
  12: translationsMenuCategories: 361 rows, data=48KB, idx=16KB
  13: customerUserSecurityEvents: 90 rows, data=48KB, idx=32KB
  14: _archive_receiptItems: 138 rows, data=48KB, idx=16KB
apcu_info:
  num_entries: 1497
  mem_size_bytes: 31925272
  num_hits: 13550
  num_misses: 5092
  hit_rate_pct: 72.7
apcu_write_ms: 0.027
apcu_read_ms: 0.003
opcache:
  enabled: 1
  cached_scripts: 660
  hits: 729006
  misses: 691
  memory_used_mb: 19.2
  memory_free_mb: 108.8
file_stat_timings:
  lib/common/core.php:
    exists: 
  lib/common/auth-handler.php:
    exists: 
  lib/common/request-data-sanitizer.php:
    exists: 
pusher_connection:
  total_ms: 710.37
  namelookup_ms: 13.4
  connect_ms: 184.65
  ssl_ms: 0
  http_code: 200
  curl_error: none
server_load:
  0: 0.05
  1: 0.05
  2: 0.05
total_diagnostic_time_ms: 730.07