=== COCONUT AI - PERFORMANCE DIAGNOSTIC ===
Date: 2026-11-04 18:59:26 UTC
============================================

php_version: 8.2.35
sapi: fpm-fcgi
opcache_enabled: 1
apcu_enabled: 1
max_execution_time: 30
db_connect_localhost_ms: 0.2
db_connect_localhost_error: none
db_connect_127001_ms: 0.42
db_connect_127001_error: none
db_connect_init_real_localhost_ms: 0.1
db_connect_init_real_error: none
db_connect_init_real_127001_ms: 0.3
db_connect_init_real_127001_error: none
query_select1_ms: 0.08
query_auth_constants_ms: 0.33
query_sessions_tables_ms: 0.48
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: translationsMenuItems: 6031 rows, data=1552KB, idx=224KB
  1: translationBaselinesItems: 10014 rows, data=1552KB, idx=464KB
  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: translationsMenuSubCategories: 490 rows, data=64KB, idx=32KB
  8: receiptItems: 228 rows, data=64KB, idx=48KB
  9: menuItems: 307 rows, data=64KB, idx=80KB
  10: translationBaselinesOptionSets: 520 rows, data=64KB, idx=16KB
  11: translationsMenuCategories: 361 rows, data=48KB, idx=16KB
  12: customerUserSecurityEvents: 90 rows, data=48KB, idx=32KB
  13: cacheInvalidationLog: 174 rows, data=48KB, idx=48KB
  14: menuItemTaxAssignments: 164 rows, data=48KB, idx=32KB
apcu_info:
  num_entries: 606
  mem_size_bytes: 12494288
  num_hits: 22335
  num_misses: 9673
  hit_rate_pct: 69.8
apcu_write_ms: 0.03
apcu_read_ms: 0.005
opcache:
  enabled: 1
  cached_scripts: 875
  hits: 1422898
  misses: 1041
  memory_used_mb: 21.4
  memory_free_mb: 103.3
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: 707.11
  namelookup_ms: 4.14
  connect_ms: 176.34
  ssl_ms: 0
  http_code: 200
  curl_error: none
server_load:
  0: 0.11
  1: 0.22
  2: 0.15
total_diagnostic_time_ms: 720.73