====================================================================================================
INSIGHTS ACTIONS WIDGET DEBUG INFO
Generated at: 2025-12-12 12:05:27
Filters: {
    "date_range": "30_days"
}
====================================================================================================

----------------------------------------------------------------------------------------------------
PAYMENT FAILURE INSIGHT
----------------------------------------------------------------------------------------------------
Result: NO INSIGHT (returned null)

Queries Executed (4):

  Query #1:
    SQL: select count(*) as aggregate from "tbl_customer_subscriptions" where "status" in (2, 3) and "created" between 2025-10-13 00:00:00 and 2025-11-12 00:00:00 and "status" = 3
    Bindings: [
    2,
    3,
    "2025-10-13T00:00:00.000000Z",
    "2025-11-12T00:00:00.000000Z",
    3
]
    Execution Time: 991.79ms

  Query #2:
    SQL: select count(*) as aggregate from "tbl_customer_subscriptions" where "status" in (2, 3) and "created" between 2025-11-13 00:00:00 and 2025-12-12 23:59:59 and "status" = 3
    Bindings: [
    2,
    3,
    "2025-11-13T00:00:00.000000Z",
    "2025-12-12T23:59:59.999999Z",
    3
]
    Execution Time: 149.62ms

  Query #3:
    SQL: select count(*) as aggregate from "tbl_customer_subscriptions" where "status" in (2, 3) and "created" between 2025-10-13 00:00:00 and 2025-11-12 00:00:00
    Bindings: [
    2,
    3,
    "2025-10-13T00:00:00.000000Z",
    "2025-11-12T00:00:00.000000Z"
]
    Execution Time: 105.96ms

  Query #4:
    SQL: select count(*) as aggregate from "tbl_customer_subscriptions" where "status" in (2, 3) and "created" between 2025-11-13 00:00:00 and 2025-12-12 23:59:59
    Bindings: [
    2,
    3,
    "2025-11-13T00:00:00.000000Z",
    "2025-12-12T23:59:59.999999Z"
]
    Execution Time: 158.70ms

----------------------------------------------------------------------------------------------------
CHURN INSIGHT
----------------------------------------------------------------------------------------------------
Result: NO INSIGHT (returned null)

Queries Executed (2):

  Query #1:
    SQL: select count(*) as aggregate from "customers" where "status" in ('inactive', 'suspend', 'blocked', 'deleted') and "updated_at" between 2025-10-13 00:00:00 and 2025-11-12 00:00:00
    Bindings: [
    "inactive",
    "suspend",
    "blocked",
    "deleted",
    "2025-10-13T00:00:00.000000Z",
    "2025-11-12T00:00:00.000000Z"
]
    Execution Time: 103.38ms

  Query #2:
    SQL: select count(*) as aggregate from "customers" where "status" in ('inactive', 'suspend', 'blocked', 'deleted') and "updated_at" between 2025-11-13 00:00:00 and 2025-12-12 23:59:59
    Bindings: [
    "inactive",
    "suspend",
    "blocked",
    "deleted",
    "2025-11-13T00:00:00.000000Z",
    "2025-12-12T23:59:59.999999Z"
]
    Execution Time: 130.73ms

----------------------------------------------------------------------------------------------------
REVENUE INSIGHT
----------------------------------------------------------------------------------------------------
Result: NO INSIGHT (returned null)

Queries Executed (2):

  Query #1:
    SQL: select sum("price") as aggregate from "tbl_customer_subscriptions" where "status" = 2 and "created" between 2025-11-13 00:00:00 and 2025-12-12 23:59:59
    Bindings: [
    2,
    "2025-11-13T00:00:00.000000Z",
    "2025-12-12T23:59:59.999999Z"
]
    Execution Time: 124.89ms

  Query #2:
    SQL: select sum("price") as aggregate from "tbl_customer_subscriptions" where "status" = 2 and "created" between 2025-10-13 00:00:00 and 2025-11-12 00:00:00
    Bindings: [
    2,
    "2025-10-13T00:00:00.000000Z",
    "2025-11-12T00:00:00.000000Z"
]
    Execution Time: 110.74ms

----------------------------------------------------------------------------------------------------
SUPPORT INSIGHT
----------------------------------------------------------------------------------------------------
Result: NO INSIGHT (returned null)

Queries Executed (2):

  Query #1:
    SQL: select count(*) as aggregate from "support_tickets" where "status" = 'open'
    Bindings: [
    "open"
]
    Execution Time: 123.74ms

  Query #2:
    SQL: select count(*) as aggregate from "support_tickets" where "priority" = 'high'
    Bindings: [
    "high"
]
    Execution Time: 167.40ms

====================================================================================================
END OF DEBUG INFO
====================================================================================================


====================================================================================================
INSIGHTS ACTIONS WIDGET DEBUG INFO
Generated at: 2025-12-12 12:07:07
Filters: {
    "date_range": "30_days"
}
====================================================================================================

----------------------------------------------------------------------------------------------------
PAYMENT FAILURE INSIGHT
----------------------------------------------------------------------------------------------------
Result: NO INSIGHT (returned null)

Queries Executed (4):

  Query #1:
    SQL: select count(*) as aggregate from "tbl_customer_subscriptions" where "status" in (2, 3) and "created" between 2025-10-13 00:00:00 and 2025-11-12 00:00:00 and "status" = 3
    Bindings: [
    2,
    3,
    "2025-10-13T00:00:00.000000Z",
    "2025-11-12T00:00:00.000000Z",
    3
]
    Execution Time: 693.37ms

  Query #2:
    SQL: select count(*) as aggregate from "tbl_customer_subscriptions" where "status" in (2, 3) and "created" between 2025-11-13 00:00:00 and 2025-12-12 23:59:59 and "status" = 3
    Bindings: [
    2,
    3,
    "2025-11-13T00:00:00.000000Z",
    "2025-12-12T23:59:59.999999Z",
    3
]
    Execution Time: 107.68ms

  Query #3:
    SQL: select count(*) as aggregate from "tbl_customer_subscriptions" where "status" in (2, 3) and "created" between 2025-10-13 00:00:00 and 2025-11-12 00:00:00
    Bindings: [
    2,
    3,
    "2025-10-13T00:00:00.000000Z",
    "2025-11-12T00:00:00.000000Z"
]
    Execution Time: 100.90ms

  Query #4:
    SQL: select count(*) as aggregate from "tbl_customer_subscriptions" where "status" in (2, 3) and "created" between 2025-11-13 00:00:00 and 2025-12-12 23:59:59
    Bindings: [
    2,
    3,
    "2025-11-13T00:00:00.000000Z",
    "2025-12-12T23:59:59.999999Z"
]
    Execution Time: 150.60ms

----------------------------------------------------------------------------------------------------
CHURN INSIGHT
----------------------------------------------------------------------------------------------------
Result: NO INSIGHT (returned null)

Queries Executed (2):

  Query #1:
    SQL: select count(*) as aggregate from "customers" where "status" in ('inactive', 'suspend', 'blocked', 'deleted') and "updated_at" between 2025-10-13 00:00:00 and 2025-11-12 00:00:00
    Bindings: [
    "inactive",
    "suspend",
    "blocked",
    "deleted",
    "2025-10-13T00:00:00.000000Z",
    "2025-11-12T00:00:00.000000Z"
]
    Execution Time: 171.57ms

  Query #2:
    SQL: select count(*) as aggregate from "customers" where "status" in ('inactive', 'suspend', 'blocked', 'deleted') and "updated_at" between 2025-11-13 00:00:00 and 2025-12-12 23:59:59
    Bindings: [
    "inactive",
    "suspend",
    "blocked",
    "deleted",
    "2025-11-13T00:00:00.000000Z",
    "2025-12-12T23:59:59.999999Z"
]
    Execution Time: 122.86ms

----------------------------------------------------------------------------------------------------
REVENUE INSIGHT
----------------------------------------------------------------------------------------------------
Result: NO INSIGHT (returned null)

Queries Executed (2):

  Query #1:
    SQL: select sum("price") as aggregate from "tbl_customer_subscriptions" where "status" = 2 and "created" between 2025-11-13 00:00:00 and 2025-12-12 23:59:59
    Bindings: [
    2,
    "2025-11-13T00:00:00.000000Z",
    "2025-12-12T23:59:59.999999Z"
]
    Execution Time: 145.96ms

  Query #2:
    SQL: select sum("price") as aggregate from "tbl_customer_subscriptions" where "status" = 2 and "created" between 2025-10-13 00:00:00 and 2025-11-12 00:00:00
    Bindings: [
    2,
    "2025-10-13T00:00:00.000000Z",
    "2025-11-12T00:00:00.000000Z"
]
    Execution Time: 100.40ms

----------------------------------------------------------------------------------------------------
SUPPORT INSIGHT
----------------------------------------------------------------------------------------------------
Result: NO INSIGHT (returned null)

Queries Executed (2):

  Query #1:
    SQL: select count(*) as aggregate from "support_tickets" where "status" = 'open'
    Bindings: [
    "open"
]
    Execution Time: 124.09ms

  Query #2:
    SQL: select count(*) as aggregate from "support_tickets" where "priority" = 'high'
    Bindings: [
    "high"
]
    Execution Time: 100.51ms

====================================================================================================
END OF DEBUG INFO
====================================================================================================