=== COCONUT AI - PERFORMANCE DIAGNOSTIC ===
Date: 2026-03-15 09:04:59 UTC
============================================

php_version: 8.2.30
sapi: fpm-fcgi
opcache_enabled: 1
apcu_enabled: 1
max_execution_time: 30
db_connect_localhost_ms: 0.67
db_connect_localhost_error: none
db_connect_127001_ms: 0.27
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.21
db_connect_init_real_127001_error: none
query_select1_ms: 0.07
query_auth_constants_ms: 0.03
query_sessions_tables_ms: 0.28
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)
  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: 846 rows, data=112KB, idx=48KB
  2: translationBaselinesCategories: 1280 rows, data=96KB, idx=48KB
  3: menuItems: 307 rows, data=80KB, idx=80KB
  4: translationsMenuOptions: 411 rows, data=64KB, idx=16KB
  5: translationBaselinesOptionSets: 520 rows, data=64KB, idx=16KB
  6: cacheInvalidationLog: 174 rows, data=48KB, idx=48KB
  7: translationsMenuCategories: 310 rows, data=48KB, idx=32KB
  8: menuItemOptions: 163 rows, data=48KB, idx=80KB
  9: _archive_receiptItems: 138 rows, data=48KB, idx=16KB
  10: menuTimeRestrictions: 3 rows, data=16KB, idx=16KB
  11: ceoAppUsersVendors: 2 rows, data=16KB, idx=16KB
  12: menuSubCategoriesItems: 255 rows, data=16KB, idx=32KB
  13: sessionAppliedDiscounts: 0 rows, data=16KB, idx=16KB
  14: onlineOrderItemAddons: 13 rows, data=16KB, idx=48KB
apcu_info:
  num_entries: 1074
  mem_size_bytes: 23283728
  num_hits: 119288
  num_misses: 41431
  hit_rate_pct: 74.2
apcu_write_ms: 0.024
apcu_read_ms: 0.004
opcache:
  enabled: 1
  cached_scripts: 700
  hits: 4892433
  misses: 1860
  memory_used_mb: 20.8
  memory_free_mb: 70.5
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: 696.53
  namelookup_ms: 3.41
  connect_ms: 175.68
  ssl_ms: 0
  http_code: 200
  curl_error: none
server_load:
  0: 0.13
  1: 0.07
  2: 0.05
total_diagnostic_time_ms: 706.93