=== COCONUT AI - PERFORMANCE DIAGNOSTIC ===
Date: 2026-06-11 00:41:19 UTC
============================================

php_version: 8.2.31
sapi: fpm-fcgi
opcache_enabled: 1
apcu_enabled: 1
max_execution_time: 30
db_connect_localhost_ms: 0.8
db_connect_localhost_error: none
db_connect_127001_ms: 0.33
db_connect_127001_error: none
db_connect_init_real_localhost_ms: 0.09
db_connect_init_real_error: none
db_connect_init_real_127001_ms: 0.22
db_connect_init_real_127001_error: none
query_select1_ms: 0.07
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)
  sessionCustomers: PRIMARY(id), 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: translationsRequestableItems: 870 rows, data=80KB, idx=0KB
  6: translationsMenuOptionSets: 565 rows, data=80KB, idx=16KB
  7: menuItems: 307 rows, data=64KB, idx=80KB
  8: translationBaselinesOptionSets: 520 rows, data=64KB, idx=16KB
  9: translationsMenuSubCategories: 490 rows, data=64KB, idx=32KB
  10: _archive_receiptItems: 138 rows, data=48KB, idx=16KB
  11: customerUserSecurityEvents: 71 rows, data=48KB, idx=32KB
  12: translationsMenuCategories: 361 rows, data=48KB, idx=16KB
  13: cacheInvalidationLog: 174 rows, data=48KB, idx=48KB
  14: menuItemOptions: 163 rows, data=48KB, idx=80KB
apcu_info:
  num_entries: 2431
  mem_size_bytes: 29524520
  num_hits: 53137
  num_misses: 19693
  hit_rate_pct: 73
apcu_write_ms: 0.035
apcu_read_ms: 0.005
opcache:
  enabled: 1
  cached_scripts: 759
  hits: 2380851
  misses: 766
  memory_used_mb: 20.2
  memory_free_mb: 107.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: 709.29
  namelookup_ms: 1.31
  connect_ms: 175.62
  ssl_ms: 0
  http_code: 200
  curl_error: none
server_load:
  0: 0.08
  1: 0.1
  2: 0.12
total_diagnostic_time_ms: 732.17