a:14:{s:6:"config";s:1474:"a:5:{s:10:"phpVersion";s:24:"7.2.24-0ubuntu0.18.04.17";s:10:"yiiVersion";s:6:"2.0.47";s:11:"application";a:8:{s:3:"yii";s:6:"2.0.47";s:4:"name";s:14:"My Application";s:7:"version";s:3:"1.0";s:8:"language";s:5:"en-US";s:14:"sourceLanguage";s:5:"en-US";s:7:"charset";s:5:"UTF-8";s:3:"env";s:3:"dev";s:5:"debug";b:0;}s:3:"php";a:5:{s:7:"version";s:24:"7.2.24-0ubuntu0.18.04.17";s:6:"xdebug";b:1;s:3:"apc";b:0;s:8:"memcache";b:0;s:9:"memcached";b:0;}s:10:"extensions";a:5:{s:22:"yiisoft/yii2-bootstrap";a:3:{s:4:"name";s:22:"yiisoft/yii2-bootstrap";s:7:"version";s:8:"2.0.11.0";s:5:"alias";a:1:{s:14:"@yii/bootstrap";s:57:"/var/www/html/pacmny-be/vendor/yiisoft/yii2-bootstrap/src";}}s:24:"yiisoft/yii2-swiftmailer";a:3:{s:4:"name";s:24:"yiisoft/yii2-swiftmailer";s:7:"version";s:7:"2.1.3.0";s:5:"alias";a:1:{s:16:"@yii/swiftmailer";s:59:"/var/www/html/pacmny-be/vendor/yiisoft/yii2-swiftmailer/src";}}s:18:"yiisoft/yii2-debug";a:3:{s:4:"name";s:18:"yiisoft/yii2-debug";s:7:"version";s:8:"2.1.22.0";s:5:"alias";a:1:{s:10:"@yii/debug";s:53:"/var/www/html/pacmny-be/vendor/yiisoft/yii2-debug/src";}}s:18:"yiisoft/yii2-faker";a:3:{s:4:"name";s:18:"yiisoft/yii2-faker";s:7:"version";s:7:"2.0.5.0";s:5:"alias";a:1:{s:10:"@yii/faker";s:53:"/var/www/html/pacmny-be/vendor/yiisoft/yii2-faker/src";}}s:16:"yiisoft/yii2-gii";a:3:{s:4:"name";s:16:"yiisoft/yii2-gii";s:7:"version";s:7:"2.1.4.0";s:5:"alias";a:1:{s:8:"@yii/gii";s:51:"/var/www/html/pacmny-be/vendor/yiisoft/yii2-gii/src";}}}}";s:3:"log";s:19684:"a:1:{s:8:"messages";a:46:{i:0;a:6:{i:0;s:254:"Unable to write cache file '/var/www/html/pacmny-be/runtime/cache/83/8301292eb993d3ff19f0b1cfe988b789.bin': file_put_contents(/var/www/html/pacmny-be/runtime/cache/83/8301292eb993d3ff19f0b1cfe988b789.bin): failed to open stream: No such file or directory";i:1;i:2;i:2;s:31:"yii\caching\FileCache::setValue";i:3;d:1794840692.652709;i:4;a:0:{}i:5;i:1524256;}i:1;a:6:{i:0;s:254:"Unable to write cache file '/var/www/html/pacmny-be/runtime/cache/00/00d716905c8ed414aa0103ba17815795.bin': file_put_contents(/var/www/html/pacmny-be/runtime/cache/00/00d716905c8ed414aa0103ba17815795.bin): failed to open stream: No such file or directory";i:1;i:2;i:2;s:31:"yii\caching\FileCache::setValue";i:3;d:1794840692.653082;i:4;a:0:{}i:5;i:1537272;}i:2;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840692.658044;i:4;a:0:{}i:5;i:1772304;}i:5;a:6:{i:0;s:2813:"SELECT
    d.nspname AS table_schema,
    c.relname AS table_name,
    a.attname AS column_name,
    COALESCE(td.typname, tb.typname, t.typname) AS data_type,
    COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
    (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme,
    a.attlen AS character_maximum_length,
    pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
    a.atttypmod AS modifier,
    a.attnotnull = false AS is_nullable,
    CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
    coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) OR attidentity != '' AS is_autoinc,
    pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
    CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
        THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
        ELSE NULL
    END AS enum_values,
    CASE atttypid
         WHEN 21 /*int2*/ THEN 16
         WHEN 23 /*int4*/ THEN 32
         WHEN 20 /*int8*/ THEN 64
         WHEN 1700 /*numeric*/ THEN
              CASE WHEN atttypmod = -1
               THEN null
               ELSE ((atttypmod - 4) >> 16) & 65535
               END
         WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
         WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
         ELSE null
      END   AS numeric_precision,
      CASE
        WHEN atttypid IN (21, 23, 20) THEN 0
        WHEN atttypid IN (1700) THEN
        CASE
            WHEN atttypmod = -1 THEN null
            ELSE (atttypmod - 4) & 65535
        END
           ELSE null
      END AS numeric_scale,
    CAST(
             information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
             AS numeric
    ) AS size,
    a.attnum = any (ct.conkey) as is_pkey,
    COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
FROM
    pg_class c
    LEFT JOIN pg_attribute a ON a.attrelid = c.oid
    LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
    LEFT JOIN pg_type t ON a.atttypid = t.oid
    LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid
    LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
    LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
    LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
WHERE
    a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
    AND c.relname = 'LA_user'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794840692.674369;i:4;a:0:{}i:5;i:2049160;}i:8;a:6:{i:0;s:875:"select
    ct.conname as constraint_name,
    a.attname as column_name,
    fc.relname as foreign_table_name,
    fns.nspname as foreign_table_schema,
    fa.attname as foreign_column_name
from
    (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
       FROM pg_constraint ct
    ) AS ct
    inner join pg_class c on c.oid=ct.conrelid
    inner join pg_namespace ns on c.relnamespace=ns.oid
    inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
    left join pg_class fc on fc.oid=ct.confrelid
    left join pg_namespace fns on fc.relnamespace=fns.oid
    left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
    ct.contype='f'
    and c.relname='LA_user'
    and ns.nspname='public'
order by
    fns.nspname, fc.relname, a.attnum";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794840692.702857;i:4;a:0:{}i:5;i:2150216;}i:11;a:6:{i:0;s:58:"SELECT * FROM "LA_user" WHERE "ZV_user_login"='oldtesting'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794840692.714673;i:4;a:0:{}i:5;i:2176872;}i:14;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840692.943412;i:4;a:0:{}i:5;i:2199848;}i:17;a:6:{i:0;s:53:"select set_config('BUCMULPHR.metaId','SYSTEM',false);";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794840692.947674;i:4;a:0:{}i:5;i:2202520;}i:20;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.014575;i:4;a:0:{}i:5;i:2204368;}i:23;a:6:{i:0;s:90:"UPDATE "LA_user" SET "ZV_user_passwd_retry_timestamp"='2026-11-16 14:51:33' WHERE "id"=446";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.021842;i:4;a:0:{}i:5;i:2224136;}i:26;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.109225;i:4;a:0:{}i:5;i:2225704;}i:29;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.113185;i:4;a:0:{}i:5;i:2226880;}i:32;a:6:{i:0;s:55:"select "ZV_user_externid" from "LA_user" where id = 446";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.116412;i:4;a:0:{}i:5;i:2229264;}i:35;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.15897;i:4;a:0:{}i:5;i:2231056;}i:38;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.162747;i:4;a:0:{}i:5;i:2231808;}i:41;a:6:{i:0;s:55:"select "ZV_user_verified" from "LA_user" where id = 446";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.167176;i:4;a:0:{}i:5;i:2234192;}i:44;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.204451;i:4;a:0:{}i:5;i:2235984;}i:47;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.208731;i:4;a:0:{}i:5;i:2236960;}i:50;a:6:{i:0;s:248:"select "ZV_user_passwd_expiration_timestamp" from "LA_user" as u where u.id = 446 and u."ZV_user_passwd" = '$2y$10$2VLzNPsztLuootPIZkMNfuwwDA0FOeXeX5sGJJEbIRXLLK.Sip2we' and u."ZV_user_passwd_expiration_timestamp" > '2026-11-16 14:51:33'::timestamp";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.212307;i:4;a:0:{}i:5;i:2239944;}i:53;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.248943;i:4;a:0:{}i:5;i:2240520;}i:56;a:6:{i:0;s:92:"SELECT "data" FROM "session" WHERE "expire">1794840693 AND "id"='ml6r0cfa5hcchjkm8jmjlcjpe8'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.254095;i:4;a:0:{}i:5;i:2249608;}i:59;a:6:{i:0;s:2813:"SELECT
    d.nspname AS table_schema,
    c.relname AS table_name,
    a.attname AS column_name,
    COALESCE(td.typname, tb.typname, t.typname) AS data_type,
    COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
    (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme,
    a.attlen AS character_maximum_length,
    pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
    a.atttypmod AS modifier,
    a.attnotnull = false AS is_nullable,
    CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
    coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) OR attidentity != '' AS is_autoinc,
    pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
    CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
        THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
        ELSE NULL
    END AS enum_values,
    CASE atttypid
         WHEN 21 /*int2*/ THEN 16
         WHEN 23 /*int4*/ THEN 32
         WHEN 20 /*int8*/ THEN 64
         WHEN 1700 /*numeric*/ THEN
              CASE WHEN atttypmod = -1
               THEN null
               ELSE ((atttypmod - 4) >> 16) & 65535
               END
         WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
         WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
         ELSE null
      END   AS numeric_precision,
      CASE
        WHEN atttypid IN (21, 23, 20) THEN 0
        WHEN atttypid IN (1700) THEN
        CASE
            WHEN atttypmod = -1 THEN null
            ELSE (atttypmod - 4) & 65535
        END
           ELSE null
      END AS numeric_scale,
    CAST(
             information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
             AS numeric
    ) AS size,
    a.attnum = any (ct.conkey) as is_pkey,
    COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
FROM
    pg_class c
    LEFT JOIN pg_attribute a ON a.attrelid = c.oid
    LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
    LEFT JOIN pg_type t ON a.atttypid = t.oid
    LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid
    LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
    LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
    LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
WHERE
    a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
    AND c.relname = 'session'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.258394;i:4;a:0:{}i:5;i:2252048;}i:62;a:6:{i:0;s:875:"select
    ct.conname as constraint_name,
    a.attname as column_name,
    fc.relname as foreign_table_name,
    fns.nspname as foreign_table_schema,
    fa.attname as foreign_column_name
from
    (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
       FROM pg_constraint ct
    ) AS ct
    inner join pg_class c on c.oid=ct.conrelid
    inner join pg_namespace ns on c.relnamespace=ns.oid
    inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
    left join pg_class fc on fc.oid=ct.confrelid
    left join pg_namespace fns on fc.relnamespace=fns.oid
    left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
    ct.contype='f'
    and c.relname='session'
    and ns.nspname='public'
order by
    fns.nspname, fc.relname, a.attnum";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.26627;i:4;a:0:{}i:5;i:2257648;}i:65;a:6:{i:0;s:1016:"SELECT
    "c"."conname" AS "name",
    "a"."attname" AS "column_name",
    "c"."contype" AS "type",
    "ftcns"."nspname" AS "foreign_table_schema",
    "ftc"."relname" AS "foreign_table_name",
    "fa"."attname" AS "foreign_column_name",
    "c"."confupdtype" AS "on_update",
    "c"."confdeltype" AS "on_delete",
    pg_get_constraintdef("c"."oid") AS "check_expr"
FROM "pg_class" AS "tc"
INNER JOIN "pg_namespace" AS "tcns"
    ON "tcns"."oid" = "tc"."relnamespace"
INNER JOIN "pg_constraint" AS "c"
    ON "c"."conrelid" = "tc"."oid"
INNER JOIN "pg_attribute" AS "a"
    ON "a"."attrelid" = "c"."conrelid" AND "a"."attnum" = ANY ("c"."conkey")
LEFT JOIN "pg_class" AS "ftc"
    ON "ftc"."oid" = "c"."confrelid"
LEFT JOIN "pg_namespace" AS "ftcns"
    ON "ftcns"."oid" = "ftc"."relnamespace"
LEFT JOIN "pg_attribute" "fa"
    ON "fa"."attrelid" = "c"."confrelid" AND "fa"."attnum" = ANY ("c"."confkey")
WHERE "tcns"."nspname" = 'public' AND "tc"."relname" = 'session'
ORDER BY "a"."attnum" ASC, "fa"."attnum" ASC";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.274581;i:4;a:0:{}i:5;i:2270576;}i:68;a:6:{i:0;s:563:"SELECT
    "ic"."relname" AS "name",
    "ia"."attname" AS "column_name",
    "i"."indisunique" AS "index_is_unique",
    "i"."indisprimary" AS "index_is_primary"
FROM "pg_class" AS "tc"
INNER JOIN "pg_namespace" AS "tcns"
    ON "tcns"."oid" = "tc"."relnamespace"
INNER JOIN "pg_index" AS "i"
    ON "i"."indrelid" = "tc"."oid"
INNER JOIN "pg_class" AS "ic"
    ON "ic"."oid" = "i"."indexrelid"
INNER JOIN "pg_attribute" AS "ia"
    ON "ia"."attrelid" = "i"."indexrelid"
WHERE "tcns"."nspname" = 'public' AND "tc"."relname" = 'session'
ORDER BY "ia"."attnum" ASC";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.280738;i:4;a:0:{}i:5;i:2275304;}i:71;a:6:{i:0;s:262:"INSERT INTO "session" ("data", "id", "expire") VALUES ('a:2:{s:7:"__flash";a:0:{}s:5:"_csrf";s:32:"tfayXCmZhVGKUryBa3ADeApkH5cPOu8F";}', 'ml6r0cfa5hcchjkm8jmjlcjpe8', 1794842133) ON CONFLICT ("id") DO UPDATE SET "data"=EXCLUDED."data", "expire"=EXCLUDED."expire"";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.285968;i:4;a:0:{}i:5;i:2279320;}i:74;a:6:{i:0;s:92:"SELECT "data" FROM "session" WHERE "expire">1794840693 AND "id"='tmcur0n5t4d0h3vgh941v351nu'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.29001;i:4;a:0:{}i:5;i:2280656;}i:77;a:6:{i:0;s:63:"SELECT * FROM "session" WHERE "id"='ml6r0cfa5hcchjkm8jmjlcjpe8'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.300871;i:4;a:0:{}i:5;i:2280728;}i:80;a:6:{i:0;s:94:"UPDATE "session" SET "id"='tmcur0n5t4d0h3vgh941v351nu' WHERE "id"='ml6r0cfa5hcchjkm8jmjlcjpe8'";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.305039;i:4;a:0:{}i:5;i:2282808;}i:83;a:6:{i:0;s:52:"User '446' logged in from 127.0.0.1 with duration 0.";i:1;i:4;i:2;s:19:"yii\web\User::login";i:3;d:1794840693.312228;i:4;a:0:{}i:5;i:2285240;}i:84;a:6:{i:0;s:76:"UPDATE "session" SET "patientid"=446 WHERE id = 'tmcur0n5t4d0h3vgh941v351nu'";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.312589;i:4;a:0:{}i:5;i:2362624;}i:87;a:6:{i:0;s:75:"UPDATE "session" SET "agentid"=NULL WHERE id = 'tmcur0n5t4d0h3vgh941v351nu'";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.317057;i:4;a:0:{}i:5;i:2363984;}i:90;a:6:{i:0;s:83:"UPDATE "session" SET "patient"='oldtesting' WHERE id = 'tmcur0n5t4d0h3vgh941v351nu'";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.321295;i:4;a:0:{}i:5;i:2365264;}i:93;a:6:{i:0;s:67:"SELECT patientid from session where id='tmcur0n5t4d0h3vgh941v351nu'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.324744;i:4;a:0:{}i:5;i:2371696;}i:96;a:6:{i:0;s:51:"SELECT bucket FROM frontendcache WHERE "user" = 446";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.328048;i:4;a:0:{}i:5;i:2372952;}i:99;a:6:{i:0;s:65:"SELECT agentid from session where id='tmcur0n5t4d0h3vgh941v351nu'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.370478;i:4;a:0:{}i:5;i:8730816;}i:102;a:6:{i:0;s:38:"SELECT * FROM "LA_user" WHERE "id"=446";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.376367;i:4;a:0:{}i:5;i:8734312;}i:105;a:6:{i:0;s:151:"SELECT "ZV_gender_status" FROM "LA_gender" AS genderList
JOIN "LJ_ugender" AS usergender ON usergender.gender = genderList.id
AND usergender.user = 446";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.417788;i:4;a:0:{}i:5;i:8759368;}i:108;a:6:{i:0;s:43:"SELECT * FROM "LJ_usuffix" WHERE "user"=446";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.439693;i:4;a:0:{}i:5;i:8867064;}i:111;a:6:{i:0;s:1162:"SELECT LAuser."ZV_user_addr2" AS addr2, LAuser."ZV_user_addr" AS address,
LAuser."ZV_user_cell" AS cell, LAuser."ZV_user_cell2" AS cell2,
LAuser."ZV_user_city" AS city, LAuser."ZV_user_dob" AS dob,
LAuser."ZV_user_email" AS email, LAuser."ZV_user_externid" AS "externId",
LAuser."ZV_user_email" AS email, LAuser."ZV_user_externid2" AS "externId2",
LAuser."ZV_user_fst" AS "firstName", LAuser."ZV_user_home" AS home,
LAuser.id AS id, LAuser."ZV_user_lst" AS "lastName",
LAuser."ZV_user_login" AS login, LAuser."ZV_user_maddr" AS maddr,
LAuser."ZV_user_maddr2" AS maddr2, LAuser."ZV_user_mcity" AS mcity,
LAuser."ZV_user_mdl" AS "middleName", LAuser."ZV_user_mzip" AS mzip,
LAuser."ZV_user_phone1" AS phone1, LAuser."ZV_user_phone1type" AS phone1type,
LAuser."ZV_user_phone2" AS phone2, LAuser."ZV_user_phone2type" AS phone2type,
LAuser."ZV_user_ssn" AS ssn, LAuser."ZV_user_work" AS work,
LAuser."ZV_user_zip" AS zip, LArt."ZV_reltype_typ" AS "relDesc",
LAuser."ZV_user_npi" AS npi, LAuser."ZV_user_admin" AS admin 
FROM "LJ_reldesc" LJrd LEFT JOIN "LA_user" LAuser ON LAuser.id = LJrd.of 
LEFT JOIN "LA_reltype" LArt ON LJrd.nature = LArt.id WHERE LJrd.isa = 446";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.446158;i:4;a:0:{}i:5;i:8832904;}i:114;a:6:{i:0;s:38:"SELECT * FROM "LA_user" WHERE "id"=446";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.528341;i:4;a:0:{}i:5;i:8836080;}i:117;a:6:{i:0;s:67:"SELECT * FROM "LJ_pdfs" WHERE "user"=446 ORDER BY "recordedAt" DESC";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.587066;i:4;a:0:{}i:5;i:8877000;}i:120;a:6:{i:0;s:423:"SELECT "LA_rprt".* FROM "LA_rprt" LEFT JOIN "LJ_usrrprt" ON "LA_rprt"."id" = "LJ_usrrprt"."report" LEFT JOIN "LJ_rprtnpi" ON "LA_rprt"."id" = "LJ_rprtnpi"."report" LEFT JOIN "LJ_rprtctgry" ON "LA_rprt"."id" = "LJ_rprtctgry"."report" LEFT JOIN "LJ_procrprt" ON "LA_rprt"."id" = "LJ_procrprt"."rprt" LEFT JOIN "LJ_rprtproc" ON "LA_rprt"."id" = "LJ_rprtproc"."report" WHERE "LJ_usrrprt"."user"=446 ORDER BY "ZV_rprt_when" DESC";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.598245;i:4;a:0:{}i:5;i:8996504;}i:123;a:6:{i:0;s:769:"    with
    cte as (
    select l1.id,j0.npi,j2.ctgry,j3.ccd
    from "LA_rprt" l1
    join "LJ_rprtnpi" j0 on j0.report = l1.id
    join "LJ_usrrprt" j1 on j1.report = l1.id
    join "LJ_rprtctgry" j2 on j2.report = l1.id
    join "LJ_rprtproc" j3 on j3.report = l1.id
    where j1."user" = 446
    order by l1.id desc
    )
    select 'ctgry' as kind,x.ctgry as value
    from (
    select max(id) z,ctgry
    from cte
    group by ctgry
    order by z desc
    ) x
    union all
    select 'ccd' as kind, y.ccd as value
    from (
    select max(id) z,ccd
    from cte
    group by ccd
    order by z desc
    ) y
    union all
    select 'npi' as kind,z.npi as value
    from (
    select max(id) z,npi
    from cte
    group by npi
    order by z desc
    ) z    ";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.622506;i:4;a:0:{}i:5;i:8992680;}i:126;a:6:{i:0;s:92:"SELECT "data" FROM "session" WHERE "expire">1794840693 AND "id"='tmcur0n5t4d0h3vgh941v351nu'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.792521;i:4;a:0:{}i:5;i:3533816;}i:129;a:6:{i:0;s:354:"INSERT INTO "session" ("data", "id", "expire") VALUES ('a:5:{s:7:"__flash";a:0:{}s:5:"_csrf";s:32:"TjVWd7Cu7NKyqZ5hiUiS8vv4nm8nnvLS";s:4:"__id";i:446;s:9:"__authKey";s:23:"6abfbb0f107aa0.22344324";s:8:"__expire";i:1794841293;}', 'tmcur0n5t4d0h3vgh941v351nu', 1794842133) ON CONFLICT ("id") DO UPDATE SET "data"=EXCLUDED."data", "expire"=EXCLUDED."expire"";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.797271;i:4;a:0:{}i:5;i:3538472;}}}";s:9:"profiling";s:37648:"a:3:{s:6:"memory";i:13443368;s:4:"time";d:1.2167699337005615;s:8:"messages";a:86:{i:3;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840692.658085;i:4;a:0:{}i:5;i:1773336;}i:4;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840692.660714;i:4;a:0:{}i:5;i:1773728;}i:6;a:6:{i:0;s:2813:"SELECT
    d.nspname AS table_schema,
    c.relname AS table_name,
    a.attname AS column_name,
    COALESCE(td.typname, tb.typname, t.typname) AS data_type,
    COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
    (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme,
    a.attlen AS character_maximum_length,
    pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
    a.atttypmod AS modifier,
    a.attnotnull = false AS is_nullable,
    CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
    coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) OR attidentity != '' AS is_autoinc,
    pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
    CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
        THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
        ELSE NULL
    END AS enum_values,
    CASE atttypid
         WHEN 21 /*int2*/ THEN 16
         WHEN 23 /*int4*/ THEN 32
         WHEN 20 /*int8*/ THEN 64
         WHEN 1700 /*numeric*/ THEN
              CASE WHEN atttypmod = -1
               THEN null
               ELSE ((atttypmod - 4) >> 16) & 65535
               END
         WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
         WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
         ELSE null
      END   AS numeric_precision,
      CASE
        WHEN atttypid IN (21, 23, 20) THEN 0
        WHEN atttypid IN (1700) THEN
        CASE
            WHEN atttypmod = -1 THEN null
            ELSE (atttypmod - 4) & 65535
        END
           ELSE null
      END AS numeric_scale,
    CAST(
             information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
             AS numeric
    ) AS size,
    a.attnum = any (ct.conkey) as is_pkey,
    COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
FROM
    pg_class c
    LEFT JOIN pg_attribute a ON a.attrelid = c.oid
    LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
    LEFT JOIN pg_type t ON a.atttypid = t.oid
    LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid
    LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
    LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
    LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
WHERE
    a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
    AND c.relname = 'LA_user'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840692.674435;i:4;a:0:{}i:5;i:2059312;}i:7;a:6:{i:0;s:2813:"SELECT
    d.nspname AS table_schema,
    c.relname AS table_name,
    a.attname AS column_name,
    COALESCE(td.typname, tb.typname, t.typname) AS data_type,
    COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
    (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme,
    a.attlen AS character_maximum_length,
    pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
    a.atttypmod AS modifier,
    a.attnotnull = false AS is_nullable,
    CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
    coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) OR attidentity != '' AS is_autoinc,
    pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
    CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
        THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
        ELSE NULL
    END AS enum_values,
    CASE atttypid
         WHEN 21 /*int2*/ THEN 16
         WHEN 23 /*int4*/ THEN 32
         WHEN 20 /*int8*/ THEN 64
         WHEN 1700 /*numeric*/ THEN
              CASE WHEN atttypmod = -1
               THEN null
               ELSE ((atttypmod - 4) >> 16) & 65535
               END
         WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
         WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
         ELSE null
      END   AS numeric_precision,
      CASE
        WHEN atttypid IN (21, 23, 20) THEN 0
        WHEN atttypid IN (1700) THEN
        CASE
            WHEN atttypmod = -1 THEN null
            ELSE (atttypmod - 4) & 65535
        END
           ELSE null
      END AS numeric_scale,
    CAST(
             information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
             AS numeric
    ) AS size,
    a.attnum = any (ct.conkey) as is_pkey,
    COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
FROM
    pg_class c
    LEFT JOIN pg_attribute a ON a.attrelid = c.oid
    LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
    LEFT JOIN pg_type t ON a.atttypid = t.oid
    LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid
    LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
    LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
    LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
WHERE
    a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
    AND c.relname = 'LA_user'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840692.69786;i:4;a:0:{}i:5;i:2342696;}i:9;a:6:{i:0;s:875:"select
    ct.conname as constraint_name,
    a.attname as column_name,
    fc.relname as foreign_table_name,
    fns.nspname as foreign_table_schema,
    fa.attname as foreign_column_name
from
    (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
       FROM pg_constraint ct
    ) AS ct
    inner join pg_class c on c.oid=ct.conrelid
    inner join pg_namespace ns on c.relnamespace=ns.oid
    inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
    left join pg_class fc on fc.oid=ct.confrelid
    left join pg_namespace fns on fc.relnamespace=fns.oid
    left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
    ct.contype='f'
    and c.relname='LA_user'
    and ns.nspname='public'
order by
    fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840692.702912;i:4;a:0:{}i:5;i:2154288;}i:10;a:6:{i:0;s:875:"select
    ct.conname as constraint_name,
    a.attname as column_name,
    fc.relname as foreign_table_name,
    fns.nspname as foreign_table_schema,
    fa.attname as foreign_column_name
from
    (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
       FROM pg_constraint ct
    ) AS ct
    inner join pg_class c on c.oid=ct.conrelid
    inner join pg_namespace ns on c.relnamespace=ns.oid
    inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
    left join pg_class fc on fc.oid=ct.confrelid
    left join pg_namespace fns on fc.relnamespace=fns.oid
    left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
    ct.contype='f'
    and c.relname='LA_user'
    and ns.nspname='public'
order by
    fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840692.710536;i:4;a:0:{}i:5;i:2155104;}i:12;a:6:{i:0;s:58:"SELECT * FROM "LA_user" WHERE "ZV_user_login"='oldtesting'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840692.714733;i:4;a:0:{}i:5;i:2178840;}i:13;a:6:{i:0;s:58:"SELECT * FROM "LA_user" WHERE "ZV_user_login"='oldtesting'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840692.941024;i:4;a:0:{}i:5;i:2211256;}i:15;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840692.943466;i:4;a:0:{}i:5;i:2200904;}i:16;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840692.94624;i:4;a:0:{}i:5;i:2201296;}i:18;a:6:{i:0;s:53:"select set_config('BUCMULPHR.metaId','SYSTEM',false);";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840692.947723;i:4;a:0:{}i:5;i:2203648;}i:19;a:6:{i:0;s:53:"select set_config('BUCMULPHR.metaId','SYSTEM',false);";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840692.950738;i:4;a:0:{}i:5;i:2204768;}i:21;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.014617;i:4;a:0:{}i:5;i:2205400;}i:22;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.017089;i:4;a:0:{}i:5;i:2205792;}i:24;a:6:{i:0;s:90:"UPDATE "LA_user" SET "ZV_user_passwd_retry_timestamp"='2026-11-16 14:51:33' WHERE "id"=446";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.021898;i:4;a:0:{}i:5;i:2225976;}i:25;a:6:{i:0;s:90:"UPDATE "LA_user" SET "ZV_user_passwd_retry_timestamp"='2026-11-16 14:51:33' WHERE "id"=446";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.105922;i:4;a:0:{}i:5;i:2226480;}i:27;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.109282;i:4;a:0:{}i:5;i:2226760;}i:28;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.111944;i:4;a:0:{}i:5;i:2227152;}i:30;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.113224;i:4;a:0:{}i:5;i:2227912;}i:31;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.115291;i:4;a:0:{}i:5;i:2228304;}i:33;a:6:{i:0;s:55:"select "ZV_user_externid" from "LA_user" where id = 446";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.116464;i:4;a:0:{}i:5;i:2232480;}i:34;a:6:{i:0;s:55:"select "ZV_user_externid" from "LA_user" where id = 446";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.156838;i:4;a:0:{}i:5;i:2233384;}i:36;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.159065;i:4;a:0:{}i:5;i:2232112;}i:37;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.161578;i:4;a:0:{}i:5;i:2232504;}i:39;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.162786;i:4;a:0:{}i:5;i:2232840;}i:40;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.165634;i:4;a:0:{}i:5;i:2233232;}i:42;a:6:{i:0;s:55:"select "ZV_user_verified" from "LA_user" where id = 446";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.167242;i:4;a:0:{}i:5;i:2236128;}i:43;a:6:{i:0;s:55:"select "ZV_user_verified" from "LA_user" where id = 446";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.202762;i:4;a:0:{}i:5;i:2238312;}i:45;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.2045;i:4;a:0:{}i:5;i:2237040;}i:46;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.207195;i:4;a:0:{}i:5;i:2237432;}i:48;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.208769;i:4;a:0:{}i:5;i:2237992;}i:49;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.211072;i:4;a:0:{}i:5;i:2238384;}i:51;a:6:{i:0;s:248:"select "ZV_user_passwd_expiration_timestamp" from "LA_user" as u where u.id = 446 and u."ZV_user_passwd" = '$2y$10$2VLzNPsztLuootPIZkMNfuwwDA0FOeXeX5sGJJEbIRXLLK.Sip2we' and u."ZV_user_passwd_expiration_timestamp" > '2026-11-16 14:51:33'::timestamp";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.212356;i:4;a:0:{}i:5;i:2242232;}i:52;a:6:{i:0;s:248:"select "ZV_user_passwd_expiration_timestamp" from "LA_user" as u where u.id = 446 and u."ZV_user_passwd" = '$2y$10$2VLzNPsztLuootPIZkMNfuwwDA0FOeXeX5sGJJEbIRXLLK.Sip2we' and u."ZV_user_passwd_expiration_timestamp" > '2026-11-16 14:51:33'::timestamp";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.246857;i:4;a:0:{}i:5;i:2243616;}i:54;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.24902;i:4;a:0:{}i:5;i:2241576;}i:55;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.251937;i:4;a:0:{}i:5;i:2241968;}i:57;a:6:{i:0;s:92:"SELECT "data" FROM "session" WHERE "expire">1794840693 AND "id"='ml6r0cfa5hcchjkm8jmjlcjpe8'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.254153;i:4;a:0:{}i:5;i:2251440;}i:58;a:6:{i:0;s:92:"SELECT "data" FROM "session" WHERE "expire">1794840693 AND "id"='ml6r0cfa5hcchjkm8jmjlcjpe8'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.256955;i:4;a:0:{}i:5;i:2252368;}i:60;a:6:{i:0;s:2813:"SELECT
    d.nspname AS table_schema,
    c.relname AS table_name,
    a.attname AS column_name,
    COALESCE(td.typname, tb.typname, t.typname) AS data_type,
    COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
    (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme,
    a.attlen AS character_maximum_length,
    pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
    a.atttypmod AS modifier,
    a.attnotnull = false AS is_nullable,
    CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
    coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) OR attidentity != '' AS is_autoinc,
    pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
    CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
        THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
        ELSE NULL
    END AS enum_values,
    CASE atttypid
         WHEN 21 /*int2*/ THEN 16
         WHEN 23 /*int4*/ THEN 32
         WHEN 20 /*int8*/ THEN 64
         WHEN 1700 /*numeric*/ THEN
              CASE WHEN atttypmod = -1
               THEN null
               ELSE ((atttypmod - 4) >> 16) & 65535
               END
         WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
         WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
         ELSE null
      END   AS numeric_precision,
      CASE
        WHEN atttypid IN (21, 23, 20) THEN 0
        WHEN atttypid IN (1700) THEN
        CASE
            WHEN atttypmod = -1 THEN null
            ELSE (atttypmod - 4) & 65535
        END
           ELSE null
      END AS numeric_scale,
    CAST(
             information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
             AS numeric
    ) AS size,
    a.attnum = any (ct.conkey) as is_pkey,
    COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
FROM
    pg_class c
    LEFT JOIN pg_attribute a ON a.attrelid = c.oid
    LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
    LEFT JOIN pg_type t ON a.atttypid = t.oid
    LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid
    LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
    LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
    LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
WHERE
    a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
    AND c.relname = 'session'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.258452;i:4;a:0:{}i:5;i:2262200;}i:61;a:6:{i:0;s:2813:"SELECT
    d.nspname AS table_schema,
    c.relname AS table_name,
    a.attname AS column_name,
    COALESCE(td.typname, tb.typname, t.typname) AS data_type,
    COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
    (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme,
    a.attlen AS character_maximum_length,
    pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
    a.atttypmod AS modifier,
    a.attnotnull = false AS is_nullable,
    CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
    coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) OR attidentity != '' AS is_autoinc,
    pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
    CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
        THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
        ELSE NULL
    END AS enum_values,
    CASE atttypid
         WHEN 21 /*int2*/ THEN 16
         WHEN 23 /*int4*/ THEN 32
         WHEN 20 /*int8*/ THEN 64
         WHEN 1700 /*numeric*/ THEN
              CASE WHEN atttypmod = -1
               THEN null
               ELSE ((atttypmod - 4) >> 16) & 65535
               END
         WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
         WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
         ELSE null
      END   AS numeric_precision,
      CASE
        WHEN atttypid IN (21, 23, 20) THEN 0
        WHEN atttypid IN (1700) THEN
        CASE
            WHEN atttypmod = -1 THEN null
            ELSE (atttypmod - 4) & 65535
        END
           ELSE null
      END AS numeric_scale,
    CAST(
             information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
             AS numeric
    ) AS size,
    a.attnum = any (ct.conkey) as is_pkey,
    COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
FROM
    pg_class c
    LEFT JOIN pg_attribute a ON a.attrelid = c.oid
    LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
    LEFT JOIN pg_type t ON a.atttypid = t.oid
    LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid
    LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
    LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
    LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
WHERE
    a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
    AND c.relname = 'session'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.264614;i:4;a:0:{}i:5;i:2273616;}i:63;a:6:{i:0;s:875:"select
    ct.conname as constraint_name,
    a.attname as column_name,
    fc.relname as foreign_table_name,
    fns.nspname as foreign_table_schema,
    fa.attname as foreign_column_name
from
    (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
       FROM pg_constraint ct
    ) AS ct
    inner join pg_class c on c.oid=ct.conrelid
    inner join pg_namespace ns on c.relnamespace=ns.oid
    inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
    left join pg_class fc on fc.oid=ct.confrelid
    left join pg_namespace fns on fc.relnamespace=fns.oid
    left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
    ct.contype='f'
    and c.relname='session'
    and ns.nspname='public'
order by
    fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.26637;i:4;a:0:{}i:5;i:2261400;}i:64;a:6:{i:0;s:875:"select
    ct.conname as constraint_name,
    a.attname as column_name,
    fc.relname as foreign_table_name,
    fns.nspname as foreign_table_schema,
    fa.attname as foreign_column_name
from
    (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
       FROM pg_constraint ct
    ) AS ct
    inner join pg_class c on c.oid=ct.conrelid
    inner join pg_namespace ns on c.relnamespace=ns.oid
    inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
    left join pg_class fc on fc.oid=ct.confrelid
    left join pg_namespace fns on fc.relnamespace=fns.oid
    left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
    ct.contype='f'
    and c.relname='session'
    and ns.nspname='public'
order by
    fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.272666;i:4;a:0:{}i:5;i:2262216;}i:66;a:6:{i:0;s:1016:"SELECT
    "c"."conname" AS "name",
    "a"."attname" AS "column_name",
    "c"."contype" AS "type",
    "ftcns"."nspname" AS "foreign_table_schema",
    "ftc"."relname" AS "foreign_table_name",
    "fa"."attname" AS "foreign_column_name",
    "c"."confupdtype" AS "on_update",
    "c"."confdeltype" AS "on_delete",
    pg_get_constraintdef("c"."oid") AS "check_expr"
FROM "pg_class" AS "tc"
INNER JOIN "pg_namespace" AS "tcns"
    ON "tcns"."oid" = "tc"."relnamespace"
INNER JOIN "pg_constraint" AS "c"
    ON "c"."conrelid" = "tc"."oid"
INNER JOIN "pg_attribute" AS "a"
    ON "a"."attrelid" = "c"."conrelid" AND "a"."attnum" = ANY ("c"."conkey")
LEFT JOIN "pg_class" AS "ftc"
    ON "ftc"."oid" = "c"."confrelid"
LEFT JOIN "pg_namespace" AS "ftcns"
    ON "ftcns"."oid" = "ftc"."relnamespace"
LEFT JOIN "pg_attribute" "fa"
    ON "fa"."attrelid" = "c"."confrelid" AND "fa"."attnum" = ANY ("c"."confkey")
WHERE "tcns"."nspname" = 'public' AND "tc"."relname" = 'session'
ORDER BY "a"."attnum" ASC, "fa"."attnum" ASC";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.274643;i:4;a:0:{}i:5;i:2275744;}i:67;a:6:{i:0;s:1016:"SELECT
    "c"."conname" AS "name",
    "a"."attname" AS "column_name",
    "c"."contype" AS "type",
    "ftcns"."nspname" AS "foreign_table_schema",
    "ftc"."relname" AS "foreign_table_name",
    "fa"."attname" AS "foreign_column_name",
    "c"."confupdtype" AS "on_update",
    "c"."confdeltype" AS "on_delete",
    pg_get_constraintdef("c"."oid") AS "check_expr"
FROM "pg_class" AS "tc"
INNER JOIN "pg_namespace" AS "tcns"
    ON "tcns"."oid" = "tc"."relnamespace"
INNER JOIN "pg_constraint" AS "c"
    ON "c"."conrelid" = "tc"."oid"
INNER JOIN "pg_attribute" AS "a"
    ON "a"."attrelid" = "c"."conrelid" AND "a"."attnum" = ANY ("c"."conkey")
LEFT JOIN "pg_class" AS "ftc"
    ON "ftc"."oid" = "c"."confrelid"
LEFT JOIN "pg_namespace" AS "ftcns"
    ON "ftcns"."oid" = "ftc"."relnamespace"
LEFT JOIN "pg_attribute" "fa"
    ON "fa"."attrelid" = "c"."confrelid" AND "fa"."attnum" = ANY ("c"."confkey")
WHERE "tcns"."nspname" = 'public' AND "tc"."relname" = 'session'
ORDER BY "a"."attnum" ASC, "fa"."attnum" ASC";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.279064;i:4;a:0:{}i:5;i:2278176;}i:69;a:6:{i:0;s:563:"SELECT
    "ic"."relname" AS "name",
    "ia"."attname" AS "column_name",
    "i"."indisunique" AS "index_is_unique",
    "i"."indisprimary" AS "index_is_primary"
FROM "pg_class" AS "tc"
INNER JOIN "pg_namespace" AS "tcns"
    ON "tcns"."oid" = "tc"."relnamespace"
INNER JOIN "pg_index" AS "i"
    ON "i"."indrelid" = "tc"."oid"
INNER JOIN "pg_class" AS "ic"
    ON "ic"."oid" = "i"."indexrelid"
INNER JOIN "pg_attribute" AS "ia"
    ON "ia"."attrelid" = "i"."indexrelid"
WHERE "tcns"."nspname" = 'public' AND "tc"."relname" = 'session'
ORDER BY "ia"."attnum" ASC";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.280803;i:4;a:0:{}i:5;i:2278808;}i:70;a:6:{i:0;s:563:"SELECT
    "ic"."relname" AS "name",
    "ia"."attname" AS "column_name",
    "i"."indisunique" AS "index_is_unique",
    "i"."indisprimary" AS "index_is_primary"
FROM "pg_class" AS "tc"
INNER JOIN "pg_namespace" AS "tcns"
    ON "tcns"."oid" = "tc"."relnamespace"
INNER JOIN "pg_index" AS "i"
    ON "i"."indrelid" = "tc"."oid"
INNER JOIN "pg_class" AS "ic"
    ON "ic"."oid" = "i"."indexrelid"
INNER JOIN "pg_attribute" AS "ia"
    ON "ia"."attrelid" = "i"."indexrelid"
WHERE "tcns"."nspname" = 'public' AND "tc"."relname" = 'session'
ORDER BY "ia"."attnum" ASC";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.284312;i:4;a:0:{}i:5;i:2280376;}i:72;a:6:{i:0;s:262:"INSERT INTO "session" ("data", "id", "expire") VALUES ('a:2:{s:7:"__flash";a:0:{}s:5:"_csrf";s:32:"tfayXCmZhVGKUryBa3ADeApkH5cPOu8F";}', 'ml6r0cfa5hcchjkm8jmjlcjpe8', 1794842133) ON CONFLICT ("id") DO UPDATE SET "data"=EXCLUDED."data", "expire"=EXCLUDED."expire"";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.28605;i:4;a:0:{}i:5;i:2281336;}i:73;a:6:{i:0;s:262:"INSERT INTO "session" ("data", "id", "expire") VALUES ('a:2:{s:7:"__flash";a:0:{}s:5:"_csrf";s:32:"tfayXCmZhVGKUryBa3ADeApkH5cPOu8F";}', 'ml6r0cfa5hcchjkm8jmjlcjpe8', 1794842133) ON CONFLICT ("id") DO UPDATE SET "data"=EXCLUDED."data", "expire"=EXCLUDED."expire"";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.288611;i:4;a:0:{}i:5;i:2281888;}i:75;a:6:{i:0;s:92:"SELECT "data" FROM "session" WHERE "expire">1794840693 AND "id"='tmcur0n5t4d0h3vgh941v351nu'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.29006;i:4;a:0:{}i:5;i:2282488;}i:76;a:6:{i:0;s:92:"SELECT "data" FROM "session" WHERE "expire">1794840693 AND "id"='tmcur0n5t4d0h3vgh941v351nu'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.298954;i:4;a:0:{}i:5;i:2283048;}i:78;a:6:{i:0;s:63:"SELECT * FROM "session" WHERE "id"='ml6r0cfa5hcchjkm8jmjlcjpe8'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.300928;i:4;a:0:{}i:5;i:2282672;}i:79;a:6:{i:0;s:63:"SELECT * FROM "session" WHERE "id"='ml6r0cfa5hcchjkm8jmjlcjpe8'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.303582;i:4;a:0:{}i:5;i:2284360;}i:81;a:6:{i:0;s:94:"UPDATE "session" SET "id"='tmcur0n5t4d0h3vgh941v351nu' WHERE "id"='ml6r0cfa5hcchjkm8jmjlcjpe8'";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.305093;i:4;a:0:{}i:5;i:2284624;}i:82;a:6:{i:0;s:94:"UPDATE "session" SET "id"='tmcur0n5t4d0h3vgh941v351nu' WHERE "id"='ml6r0cfa5hcchjkm8jmjlcjpe8'";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.310417;i:4;a:0:{}i:5;i:2285096;}i:85;a:6:{i:0;s:76:"UPDATE "session" SET "patientid"=446 WHERE id = 'tmcur0n5t4d0h3vgh941v351nu'";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.312636;i:4;a:0:{}i:5;i:2364400;}i:86;a:6:{i:0;s:76:"UPDATE "session" SET "patientid"=446 WHERE id = 'tmcur0n5t4d0h3vgh941v351nu'";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.315429;i:4;a:0:{}i:5;i:2364904;}i:88;a:6:{i:0;s:75:"UPDATE "session" SET "agentid"=NULL WHERE id = 'tmcur0n5t4d0h3vgh941v351nu'";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.317116;i:4;a:0:{}i:5;i:2365752;}i:89;a:6:{i:0;s:75:"UPDATE "session" SET "agentid"=NULL WHERE id = 'tmcur0n5t4d0h3vgh941v351nu'";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.320002;i:4;a:0:{}i:5;i:2366224;}i:91;a:6:{i:0;s:83:"UPDATE "session" SET "patient"='oldtesting' WHERE id = 'tmcur0n5t4d0h3vgh941v351nu'";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.321346;i:4;a:0:{}i:5;i:2367072;}i:92;a:6:{i:0;s:83:"UPDATE "session" SET "patient"='oldtesting' WHERE id = 'tmcur0n5t4d0h3vgh941v351nu'";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.323608;i:4;a:0:{}i:5;i:2373176;}i:94;a:6:{i:0;s:67:"SELECT patientid from session where id='tmcur0n5t4d0h3vgh941v351nu'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.324796;i:4;a:0:{}i:5;i:2373664;}i:95;a:6:{i:0;s:67:"SELECT patientid from session where id='tmcur0n5t4d0h3vgh941v351nu'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.327016;i:4;a:0:{}i:5;i:2374152;}i:97;a:6:{i:0;s:51:"SELECT bucket FROM frontendcache WHERE "user" = 446";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.328088;i:4;a:0:{}i:5;i:2374880;}i:98;a:6:{i:0;s:51:"SELECT bucket FROM frontendcache WHERE "user" = 446";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.354347;i:4;a:0:{}i:5;i:3780320;}i:100;a:6:{i:0;s:65:"SELECT agentid from session where id='tmcur0n5t4d0h3vgh941v351nu'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.370559;i:4;a:0:{}i:5;i:8732784;}i:101;a:6:{i:0;s:65:"SELECT agentid from session where id='tmcur0n5t4d0h3vgh941v351nu'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.374103;i:4;a:0:{}i:5;i:8733264;}i:103;a:6:{i:0;s:38:"SELECT * FROM "LA_user" WHERE "id"=446";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.376425;i:4;a:0:{}i:5;i:8736200;}i:104;a:6:{i:0;s:38:"SELECT * FROM "LA_user" WHERE "id"=446";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.413066;i:4;a:0:{}i:5;i:8769024;}i:106;a:6:{i:0;s:151:"SELECT "ZV_gender_status" FROM "LA_gender" AS genderList
JOIN "LJ_ugender" AS usergender ON usergender.gender = genderList.id
AND usergender.user = 446";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.417861;i:4;a:0:{}i:5;i:8761616;}i:107;a:6:{i:0;s:151:"SELECT "ZV_gender_status" FROM "LA_gender" AS genderList
JOIN "LJ_ugender" AS usergender ON usergender.gender = genderList.id
AND usergender.user = 446";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.43386;i:4;a:0:{}i:5;i:8762552;}i:109;a:6:{i:0;s:43:"SELECT * FROM "LJ_usuffix" WHERE "user"=446";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.439774;i:4;a:0:{}i:5;i:8868976;}i:110;a:6:{i:0;s:43:"SELECT * FROM "LJ_usuffix" WHERE "user"=446";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.444742;i:4;a:0:{}i:5;i:8869832;}i:112;a:6:{i:0;s:1162:"SELECT LAuser."ZV_user_addr2" AS addr2, LAuser."ZV_user_addr" AS address,
LAuser."ZV_user_cell" AS cell, LAuser."ZV_user_cell2" AS cell2,
LAuser."ZV_user_city" AS city, LAuser."ZV_user_dob" AS dob,
LAuser."ZV_user_email" AS email, LAuser."ZV_user_externid" AS "externId",
LAuser."ZV_user_email" AS email, LAuser."ZV_user_externid2" AS "externId2",
LAuser."ZV_user_fst" AS "firstName", LAuser."ZV_user_home" AS home,
LAuser.id AS id, LAuser."ZV_user_lst" AS "lastName",
LAuser."ZV_user_login" AS login, LAuser."ZV_user_maddr" AS maddr,
LAuser."ZV_user_maddr2" AS maddr2, LAuser."ZV_user_mcity" AS mcity,
LAuser."ZV_user_mdl" AS "middleName", LAuser."ZV_user_mzip" AS mzip,
LAuser."ZV_user_phone1" AS phone1, LAuser."ZV_user_phone1type" AS phone1type,
LAuser."ZV_user_phone2" AS phone2, LAuser."ZV_user_phone2type" AS phone2type,
LAuser."ZV_user_ssn" AS ssn, LAuser."ZV_user_work" AS work,
LAuser."ZV_user_zip" AS zip, LArt."ZV_reltype_typ" AS "relDesc",
LAuser."ZV_user_npi" AS npi, LAuser."ZV_user_admin" AS admin 
FROM "LJ_reldesc" LJrd LEFT JOIN "LA_user" LAuser ON LAuser.id = LJrd.of 
LEFT JOIN "LA_reltype" LArt ON LJrd.nature = LArt.id WHERE LJrd.isa = 446";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.446216;i:4;a:0:{}i:5;i:8838496;}i:113;a:6:{i:0;s:1162:"SELECT LAuser."ZV_user_addr2" AS addr2, LAuser."ZV_user_addr" AS address,
LAuser."ZV_user_cell" AS cell, LAuser."ZV_user_cell2" AS cell2,
LAuser."ZV_user_city" AS city, LAuser."ZV_user_dob" AS dob,
LAuser."ZV_user_email" AS email, LAuser."ZV_user_externid" AS "externId",
LAuser."ZV_user_email" AS email, LAuser."ZV_user_externid2" AS "externId2",
LAuser."ZV_user_fst" AS "firstName", LAuser."ZV_user_home" AS home,
LAuser.id AS id, LAuser."ZV_user_lst" AS "lastName",
LAuser."ZV_user_login" AS login, LAuser."ZV_user_maddr" AS maddr,
LAuser."ZV_user_maddr2" AS maddr2, LAuser."ZV_user_mcity" AS mcity,
LAuser."ZV_user_mdl" AS "middleName", LAuser."ZV_user_mzip" AS mzip,
LAuser."ZV_user_phone1" AS phone1, LAuser."ZV_user_phone1type" AS phone1type,
LAuser."ZV_user_phone2" AS phone2, LAuser."ZV_user_phone2type" AS phone2type,
LAuser."ZV_user_ssn" AS ssn, LAuser."ZV_user_work" AS work,
LAuser."ZV_user_zip" AS zip, LArt."ZV_reltype_typ" AS "relDesc",
LAuser."ZV_user_npi" AS npi, LAuser."ZV_user_admin" AS admin 
FROM "LJ_reldesc" LJrd LEFT JOIN "LA_user" LAuser ON LAuser.id = LJrd.of 
LEFT JOIN "LA_reltype" LArt ON LJrd.nature = LArt.id WHERE LJrd.isa = 446";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.524132;i:4;a:0:{}i:5;i:8841040;}i:115;a:6:{i:0;s:38:"SELECT * FROM "LA_user" WHERE "id"=446";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.52843;i:4;a:0:{}i:5;i:8837968;}i:116;a:6:{i:0;s:38:"SELECT * FROM "LA_user" WHERE "id"=446";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.584299;i:4;a:0:{}i:5;i:8870416;}i:118;a:6:{i:0;s:67:"SELECT * FROM "LJ_pdfs" WHERE "user"=446 ORDER BY "recordedAt" DESC";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.58714;i:4;a:0:{}i:5;i:8878992;}i:119;a:6:{i:0;s:67:"SELECT * FROM "LJ_pdfs" WHERE "user"=446 ORDER BY "recordedAt" DESC";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.594117;i:4;a:0:{}i:5;i:8879840;}i:121;a:6:{i:0;s:423:"SELECT "LA_rprt".* FROM "LA_rprt" LEFT JOIN "LJ_usrrprt" ON "LA_rprt"."id" = "LJ_usrrprt"."report" LEFT JOIN "LJ_rprtnpi" ON "LA_rprt"."id" = "LJ_rprtnpi"."report" LEFT JOIN "LJ_rprtctgry" ON "LA_rprt"."id" = "LJ_rprtctgry"."report" LEFT JOIN "LJ_procrprt" ON "LA_rprt"."id" = "LJ_procrprt"."rprt" LEFT JOIN "LJ_rprtproc" ON "LA_rprt"."id" = "LJ_rprtproc"."report" WHERE "LJ_usrrprt"."user"=446 ORDER BY "ZV_rprt_when" DESC";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.59831;i:4;a:0:{}i:5;i:8999648;}i:122;a:6:{i:0;s:423:"SELECT "LA_rprt".* FROM "LA_rprt" LEFT JOIN "LJ_usrrprt" ON "LA_rprt"."id" = "LJ_usrrprt"."report" LEFT JOIN "LJ_rprtnpi" ON "LA_rprt"."id" = "LJ_rprtnpi"."report" LEFT JOIN "LJ_rprtctgry" ON "LA_rprt"."id" = "LJ_rprtctgry"."report" LEFT JOIN "LJ_procrprt" ON "LA_rprt"."id" = "LJ_procrprt"."rprt" LEFT JOIN "LJ_rprtproc" ON "LA_rprt"."id" = "LJ_rprtproc"."report" WHERE "LJ_usrrprt"."user"=446 ORDER BY "ZV_rprt_when" DESC";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.620874;i:4;a:0:{}i:5;i:9000504;}i:124;a:6:{i:0;s:769:"    with
    cte as (
    select l1.id,j0.npi,j2.ctgry,j3.ccd
    from "LA_rprt" l1
    join "LJ_rprtnpi" j0 on j0.report = l1.id
    join "LJ_usrrprt" j1 on j1.report = l1.id
    join "LJ_rprtctgry" j2 on j2.report = l1.id
    join "LJ_rprtproc" j3 on j3.report = l1.id
    where j1."user" = 446
    order by l1.id desc
    )
    select 'ctgry' as kind,x.ctgry as value
    from (
    select max(id) z,ctgry
    from cte
    group by ctgry
    order by z desc
    ) x
    union all
    select 'ccd' as kind, y.ccd as value
    from (
    select max(id) z,ccd
    from cte
    group by ccd
    order by z desc
    ) y
    union all
    select 'npi' as kind,z.npi as value
    from (
    select max(id) z,npi
    from cte
    group by npi
    order by z desc
    ) z    ";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.622574;i:4;a:0:{}i:5;i:8997120;}i:125;a:6:{i:0;s:769:"    with
    cte as (
    select l1.id,j0.npi,j2.ctgry,j3.ccd
    from "LA_rprt" l1
    join "LJ_rprtnpi" j0 on j0.report = l1.id
    join "LJ_usrrprt" j1 on j1.report = l1.id
    join "LJ_rprtctgry" j2 on j2.report = l1.id
    join "LJ_rprtproc" j3 on j3.report = l1.id
    where j1."user" = 446
    order by l1.id desc
    )
    select 'ctgry' as kind,x.ctgry as value
    from (
    select max(id) z,ctgry
    from cte
    group by ctgry
    order by z desc
    ) x
    union all
    select 'ccd' as kind, y.ccd as value
    from (
    select max(id) z,ccd
    from cte
    group by ccd
    order by z desc
    ) y
    union all
    select 'npi' as kind,z.npi as value
    from (
    select max(id) z,npi
    from cte
    group by npi
    order by z desc
    ) z    ";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.628724;i:4;a:0:{}i:5;i:8997752;}i:127;a:6:{i:0;s:92:"SELECT "data" FROM "session" WHERE "expire">1794840693 AND "id"='tmcur0n5t4d0h3vgh941v351nu'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.79259;i:4;a:0:{}i:5;i:3535648;}i:128;a:6:{i:0;s:92:"SELECT "data" FROM "session" WHERE "expire">1794840693 AND "id"='tmcur0n5t4d0h3vgh941v351nu'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.7958;i:4;a:0:{}i:5;i:3536576;}i:130;a:6:{i:0;s:354:"INSERT INTO "session" ("data", "id", "expire") VALUES ('a:5:{s:7:"__flash";a:0:{}s:5:"_csrf";s:32:"TjVWd7Cu7NKyqZ5hiUiS8vv4nm8nnvLS";s:4:"__id";i:446;s:9:"__authKey";s:23:"6abfbb0f107aa0.22344324";s:8:"__expire";i:1794841293;}', 'tmcur0n5t4d0h3vgh941v351nu', 1794842133) ON CONFLICT ("id") DO UPDATE SET "data"=EXCLUDED."data", "expire"=EXCLUDED."expire"";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.797317;i:4;a:0:{}i:5;i:3540600;}i:131;a:6:{i:0;s:354:"INSERT INTO "session" ("data", "id", "expire") VALUES ('a:5:{s:7:"__flash";a:0:{}s:5:"_csrf";s:32:"TjVWd7Cu7NKyqZ5hiUiS8vv4nm8nnvLS";s:4:"__id";i:446;s:9:"__authKey";s:23:"6abfbb0f107aa0.22344324";s:8:"__expire";i:1794841293;}', 'tmcur0n5t4d0h3vgh941v351nu', 1794842133) ON CONFLICT ("id") DO UPDATE SET "data"=EXCLUDED."data", "expire"=EXCLUDED."expire"";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.802367;i:4;a:0:{}i:5;i:3541152;}}}";s:2:"db";s:37592:"a:1:{s:8:"messages";a:86:{i:3;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840692.658085;i:4;a:0:{}i:5;i:1773336;}i:4;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840692.660714;i:4;a:0:{}i:5;i:1773728;}i:6;a:6:{i:0;s:2813:"SELECT
    d.nspname AS table_schema,
    c.relname AS table_name,
    a.attname AS column_name,
    COALESCE(td.typname, tb.typname, t.typname) AS data_type,
    COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
    (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme,
    a.attlen AS character_maximum_length,
    pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
    a.atttypmod AS modifier,
    a.attnotnull = false AS is_nullable,
    CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
    coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) OR attidentity != '' AS is_autoinc,
    pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
    CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
        THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
        ELSE NULL
    END AS enum_values,
    CASE atttypid
         WHEN 21 /*int2*/ THEN 16
         WHEN 23 /*int4*/ THEN 32
         WHEN 20 /*int8*/ THEN 64
         WHEN 1700 /*numeric*/ THEN
              CASE WHEN atttypmod = -1
               THEN null
               ELSE ((atttypmod - 4) >> 16) & 65535
               END
         WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
         WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
         ELSE null
      END   AS numeric_precision,
      CASE
        WHEN atttypid IN (21, 23, 20) THEN 0
        WHEN atttypid IN (1700) THEN
        CASE
            WHEN atttypmod = -1 THEN null
            ELSE (atttypmod - 4) & 65535
        END
           ELSE null
      END AS numeric_scale,
    CAST(
             information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
             AS numeric
    ) AS size,
    a.attnum = any (ct.conkey) as is_pkey,
    COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
FROM
    pg_class c
    LEFT JOIN pg_attribute a ON a.attrelid = c.oid
    LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
    LEFT JOIN pg_type t ON a.atttypid = t.oid
    LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid
    LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
    LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
    LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
WHERE
    a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
    AND c.relname = 'LA_user'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840692.674435;i:4;a:0:{}i:5;i:2059312;}i:7;a:6:{i:0;s:2813:"SELECT
    d.nspname AS table_schema,
    c.relname AS table_name,
    a.attname AS column_name,
    COALESCE(td.typname, tb.typname, t.typname) AS data_type,
    COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
    (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme,
    a.attlen AS character_maximum_length,
    pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
    a.atttypmod AS modifier,
    a.attnotnull = false AS is_nullable,
    CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
    coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) OR attidentity != '' AS is_autoinc,
    pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
    CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
        THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
        ELSE NULL
    END AS enum_values,
    CASE atttypid
         WHEN 21 /*int2*/ THEN 16
         WHEN 23 /*int4*/ THEN 32
         WHEN 20 /*int8*/ THEN 64
         WHEN 1700 /*numeric*/ THEN
              CASE WHEN atttypmod = -1
               THEN null
               ELSE ((atttypmod - 4) >> 16) & 65535
               END
         WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
         WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
         ELSE null
      END   AS numeric_precision,
      CASE
        WHEN atttypid IN (21, 23, 20) THEN 0
        WHEN atttypid IN (1700) THEN
        CASE
            WHEN atttypmod = -1 THEN null
            ELSE (atttypmod - 4) & 65535
        END
           ELSE null
      END AS numeric_scale,
    CAST(
             information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
             AS numeric
    ) AS size,
    a.attnum = any (ct.conkey) as is_pkey,
    COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
FROM
    pg_class c
    LEFT JOIN pg_attribute a ON a.attrelid = c.oid
    LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
    LEFT JOIN pg_type t ON a.atttypid = t.oid
    LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid
    LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
    LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
    LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
WHERE
    a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
    AND c.relname = 'LA_user'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840692.69786;i:4;a:0:{}i:5;i:2342696;}i:9;a:6:{i:0;s:875:"select
    ct.conname as constraint_name,
    a.attname as column_name,
    fc.relname as foreign_table_name,
    fns.nspname as foreign_table_schema,
    fa.attname as foreign_column_name
from
    (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
       FROM pg_constraint ct
    ) AS ct
    inner join pg_class c on c.oid=ct.conrelid
    inner join pg_namespace ns on c.relnamespace=ns.oid
    inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
    left join pg_class fc on fc.oid=ct.confrelid
    left join pg_namespace fns on fc.relnamespace=fns.oid
    left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
    ct.contype='f'
    and c.relname='LA_user'
    and ns.nspname='public'
order by
    fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840692.702912;i:4;a:0:{}i:5;i:2154288;}i:10;a:6:{i:0;s:875:"select
    ct.conname as constraint_name,
    a.attname as column_name,
    fc.relname as foreign_table_name,
    fns.nspname as foreign_table_schema,
    fa.attname as foreign_column_name
from
    (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
       FROM pg_constraint ct
    ) AS ct
    inner join pg_class c on c.oid=ct.conrelid
    inner join pg_namespace ns on c.relnamespace=ns.oid
    inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
    left join pg_class fc on fc.oid=ct.confrelid
    left join pg_namespace fns on fc.relnamespace=fns.oid
    left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
    ct.contype='f'
    and c.relname='LA_user'
    and ns.nspname='public'
order by
    fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840692.710536;i:4;a:0:{}i:5;i:2155104;}i:12;a:6:{i:0;s:58:"SELECT * FROM "LA_user" WHERE "ZV_user_login"='oldtesting'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840692.714733;i:4;a:0:{}i:5;i:2178840;}i:13;a:6:{i:0;s:58:"SELECT * FROM "LA_user" WHERE "ZV_user_login"='oldtesting'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840692.941024;i:4;a:0:{}i:5;i:2211256;}i:15;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840692.943466;i:4;a:0:{}i:5;i:2200904;}i:16;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840692.94624;i:4;a:0:{}i:5;i:2201296;}i:18;a:6:{i:0;s:53:"select set_config('BUCMULPHR.metaId','SYSTEM',false);";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840692.947723;i:4;a:0:{}i:5;i:2203648;}i:19;a:6:{i:0;s:53:"select set_config('BUCMULPHR.metaId','SYSTEM',false);";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840692.950738;i:4;a:0:{}i:5;i:2204768;}i:21;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.014617;i:4;a:0:{}i:5;i:2205400;}i:22;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.017089;i:4;a:0:{}i:5;i:2205792;}i:24;a:6:{i:0;s:90:"UPDATE "LA_user" SET "ZV_user_passwd_retry_timestamp"='2026-11-16 14:51:33' WHERE "id"=446";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.021898;i:4;a:0:{}i:5;i:2225976;}i:25;a:6:{i:0;s:90:"UPDATE "LA_user" SET "ZV_user_passwd_retry_timestamp"='2026-11-16 14:51:33' WHERE "id"=446";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.105922;i:4;a:0:{}i:5;i:2226480;}i:27;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.109282;i:4;a:0:{}i:5;i:2226760;}i:28;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.111944;i:4;a:0:{}i:5;i:2227152;}i:30;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.113224;i:4;a:0:{}i:5;i:2227912;}i:31;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.115291;i:4;a:0:{}i:5;i:2228304;}i:33;a:6:{i:0;s:55:"select "ZV_user_externid" from "LA_user" where id = 446";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.116464;i:4;a:0:{}i:5;i:2232480;}i:34;a:6:{i:0;s:55:"select "ZV_user_externid" from "LA_user" where id = 446";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.156838;i:4;a:0:{}i:5;i:2233384;}i:36;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.159065;i:4;a:0:{}i:5;i:2232112;}i:37;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.161578;i:4;a:0:{}i:5;i:2232504;}i:39;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.162786;i:4;a:0:{}i:5;i:2232840;}i:40;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.165634;i:4;a:0:{}i:5;i:2233232;}i:42;a:6:{i:0;s:55:"select "ZV_user_verified" from "LA_user" where id = 446";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.167242;i:4;a:0:{}i:5;i:2236128;}i:43;a:6:{i:0;s:55:"select "ZV_user_verified" from "LA_user" where id = 446";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.202762;i:4;a:0:{}i:5;i:2238312;}i:45;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.2045;i:4;a:0:{}i:5;i:2237040;}i:46;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.207195;i:4;a:0:{}i:5;i:2237432;}i:48;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.208769;i:4;a:0:{}i:5;i:2237992;}i:49;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.211072;i:4;a:0:{}i:5;i:2238384;}i:51;a:6:{i:0;s:248:"select "ZV_user_passwd_expiration_timestamp" from "LA_user" as u where u.id = 446 and u."ZV_user_passwd" = '$2y$10$2VLzNPsztLuootPIZkMNfuwwDA0FOeXeX5sGJJEbIRXLLK.Sip2we' and u."ZV_user_passwd_expiration_timestamp" > '2026-11-16 14:51:33'::timestamp";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.212356;i:4;a:0:{}i:5;i:2242232;}i:52;a:6:{i:0;s:248:"select "ZV_user_passwd_expiration_timestamp" from "LA_user" as u where u.id = 446 and u."ZV_user_passwd" = '$2y$10$2VLzNPsztLuootPIZkMNfuwwDA0FOeXeX5sGJJEbIRXLLK.Sip2we' and u."ZV_user_passwd_expiration_timestamp" > '2026-11-16 14:51:33'::timestamp";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.246857;i:4;a:0:{}i:5;i:2243616;}i:54;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.24902;i:4;a:0:{}i:5;i:2241576;}i:55;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.251937;i:4;a:0:{}i:5;i:2241968;}i:57;a:6:{i:0;s:92:"SELECT "data" FROM "session" WHERE "expire">1794840693 AND "id"='ml6r0cfa5hcchjkm8jmjlcjpe8'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.254153;i:4;a:0:{}i:5;i:2251440;}i:58;a:6:{i:0;s:92:"SELECT "data" FROM "session" WHERE "expire">1794840693 AND "id"='ml6r0cfa5hcchjkm8jmjlcjpe8'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.256955;i:4;a:0:{}i:5;i:2252368;}i:60;a:6:{i:0;s:2813:"SELECT
    d.nspname AS table_schema,
    c.relname AS table_name,
    a.attname AS column_name,
    COALESCE(td.typname, tb.typname, t.typname) AS data_type,
    COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
    (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme,
    a.attlen AS character_maximum_length,
    pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
    a.atttypmod AS modifier,
    a.attnotnull = false AS is_nullable,
    CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
    coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) OR attidentity != '' AS is_autoinc,
    pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
    CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
        THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
        ELSE NULL
    END AS enum_values,
    CASE atttypid
         WHEN 21 /*int2*/ THEN 16
         WHEN 23 /*int4*/ THEN 32
         WHEN 20 /*int8*/ THEN 64
         WHEN 1700 /*numeric*/ THEN
              CASE WHEN atttypmod = -1
               THEN null
               ELSE ((atttypmod - 4) >> 16) & 65535
               END
         WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
         WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
         ELSE null
      END   AS numeric_precision,
      CASE
        WHEN atttypid IN (21, 23, 20) THEN 0
        WHEN atttypid IN (1700) THEN
        CASE
            WHEN atttypmod = -1 THEN null
            ELSE (atttypmod - 4) & 65535
        END
           ELSE null
      END AS numeric_scale,
    CAST(
             information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
             AS numeric
    ) AS size,
    a.attnum = any (ct.conkey) as is_pkey,
    COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
FROM
    pg_class c
    LEFT JOIN pg_attribute a ON a.attrelid = c.oid
    LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
    LEFT JOIN pg_type t ON a.atttypid = t.oid
    LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid
    LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
    LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
    LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
WHERE
    a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
    AND c.relname = 'session'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.258452;i:4;a:0:{}i:5;i:2262200;}i:61;a:6:{i:0;s:2813:"SELECT
    d.nspname AS table_schema,
    c.relname AS table_name,
    a.attname AS column_name,
    COALESCE(td.typname, tb.typname, t.typname) AS data_type,
    COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
    (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme,
    a.attlen AS character_maximum_length,
    pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
    a.atttypmod AS modifier,
    a.attnotnull = false AS is_nullable,
    CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
    coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) OR attidentity != '' AS is_autoinc,
    pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
    CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
        THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
        ELSE NULL
    END AS enum_values,
    CASE atttypid
         WHEN 21 /*int2*/ THEN 16
         WHEN 23 /*int4*/ THEN 32
         WHEN 20 /*int8*/ THEN 64
         WHEN 1700 /*numeric*/ THEN
              CASE WHEN atttypmod = -1
               THEN null
               ELSE ((atttypmod - 4) >> 16) & 65535
               END
         WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
         WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
         ELSE null
      END   AS numeric_precision,
      CASE
        WHEN atttypid IN (21, 23, 20) THEN 0
        WHEN atttypid IN (1700) THEN
        CASE
            WHEN atttypmod = -1 THEN null
            ELSE (atttypmod - 4) & 65535
        END
           ELSE null
      END AS numeric_scale,
    CAST(
             information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
             AS numeric
    ) AS size,
    a.attnum = any (ct.conkey) as is_pkey,
    COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
FROM
    pg_class c
    LEFT JOIN pg_attribute a ON a.attrelid = c.oid
    LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
    LEFT JOIN pg_type t ON a.atttypid = t.oid
    LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid
    LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
    LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
    LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
WHERE
    a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
    AND c.relname = 'session'
    AND d.nspname = 'public'
ORDER BY
    a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.264614;i:4;a:0:{}i:5;i:2273616;}i:63;a:6:{i:0;s:875:"select
    ct.conname as constraint_name,
    a.attname as column_name,
    fc.relname as foreign_table_name,
    fns.nspname as foreign_table_schema,
    fa.attname as foreign_column_name
from
    (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
       FROM pg_constraint ct
    ) AS ct
    inner join pg_class c on c.oid=ct.conrelid
    inner join pg_namespace ns on c.relnamespace=ns.oid
    inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
    left join pg_class fc on fc.oid=ct.confrelid
    left join pg_namespace fns on fc.relnamespace=fns.oid
    left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
    ct.contype='f'
    and c.relname='session'
    and ns.nspname='public'
order by
    fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.26637;i:4;a:0:{}i:5;i:2261400;}i:64;a:6:{i:0;s:875:"select
    ct.conname as constraint_name,
    a.attname as column_name,
    fc.relname as foreign_table_name,
    fns.nspname as foreign_table_schema,
    fa.attname as foreign_column_name
from
    (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
       FROM pg_constraint ct
    ) AS ct
    inner join pg_class c on c.oid=ct.conrelid
    inner join pg_namespace ns on c.relnamespace=ns.oid
    inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
    left join pg_class fc on fc.oid=ct.confrelid
    left join pg_namespace fns on fc.relnamespace=fns.oid
    left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
    ct.contype='f'
    and c.relname='session'
    and ns.nspname='public'
order by
    fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.272666;i:4;a:0:{}i:5;i:2262216;}i:66;a:6:{i:0;s:1016:"SELECT
    "c"."conname" AS "name",
    "a"."attname" AS "column_name",
    "c"."contype" AS "type",
    "ftcns"."nspname" AS "foreign_table_schema",
    "ftc"."relname" AS "foreign_table_name",
    "fa"."attname" AS "foreign_column_name",
    "c"."confupdtype" AS "on_update",
    "c"."confdeltype" AS "on_delete",
    pg_get_constraintdef("c"."oid") AS "check_expr"
FROM "pg_class" AS "tc"
INNER JOIN "pg_namespace" AS "tcns"
    ON "tcns"."oid" = "tc"."relnamespace"
INNER JOIN "pg_constraint" AS "c"
    ON "c"."conrelid" = "tc"."oid"
INNER JOIN "pg_attribute" AS "a"
    ON "a"."attrelid" = "c"."conrelid" AND "a"."attnum" = ANY ("c"."conkey")
LEFT JOIN "pg_class" AS "ftc"
    ON "ftc"."oid" = "c"."confrelid"
LEFT JOIN "pg_namespace" AS "ftcns"
    ON "ftcns"."oid" = "ftc"."relnamespace"
LEFT JOIN "pg_attribute" "fa"
    ON "fa"."attrelid" = "c"."confrelid" AND "fa"."attnum" = ANY ("c"."confkey")
WHERE "tcns"."nspname" = 'public' AND "tc"."relname" = 'session'
ORDER BY "a"."attnum" ASC, "fa"."attnum" ASC";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.274643;i:4;a:0:{}i:5;i:2275744;}i:67;a:6:{i:0;s:1016:"SELECT
    "c"."conname" AS "name",
    "a"."attname" AS "column_name",
    "c"."contype" AS "type",
    "ftcns"."nspname" AS "foreign_table_schema",
    "ftc"."relname" AS "foreign_table_name",
    "fa"."attname" AS "foreign_column_name",
    "c"."confupdtype" AS "on_update",
    "c"."confdeltype" AS "on_delete",
    pg_get_constraintdef("c"."oid") AS "check_expr"
FROM "pg_class" AS "tc"
INNER JOIN "pg_namespace" AS "tcns"
    ON "tcns"."oid" = "tc"."relnamespace"
INNER JOIN "pg_constraint" AS "c"
    ON "c"."conrelid" = "tc"."oid"
INNER JOIN "pg_attribute" AS "a"
    ON "a"."attrelid" = "c"."conrelid" AND "a"."attnum" = ANY ("c"."conkey")
LEFT JOIN "pg_class" AS "ftc"
    ON "ftc"."oid" = "c"."confrelid"
LEFT JOIN "pg_namespace" AS "ftcns"
    ON "ftcns"."oid" = "ftc"."relnamespace"
LEFT JOIN "pg_attribute" "fa"
    ON "fa"."attrelid" = "c"."confrelid" AND "fa"."attnum" = ANY ("c"."confkey")
WHERE "tcns"."nspname" = 'public' AND "tc"."relname" = 'session'
ORDER BY "a"."attnum" ASC, "fa"."attnum" ASC";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.279064;i:4;a:0:{}i:5;i:2278176;}i:69;a:6:{i:0;s:563:"SELECT
    "ic"."relname" AS "name",
    "ia"."attname" AS "column_name",
    "i"."indisunique" AS "index_is_unique",
    "i"."indisprimary" AS "index_is_primary"
FROM "pg_class" AS "tc"
INNER JOIN "pg_namespace" AS "tcns"
    ON "tcns"."oid" = "tc"."relnamespace"
INNER JOIN "pg_index" AS "i"
    ON "i"."indrelid" = "tc"."oid"
INNER JOIN "pg_class" AS "ic"
    ON "ic"."oid" = "i"."indexrelid"
INNER JOIN "pg_attribute" AS "ia"
    ON "ia"."attrelid" = "i"."indexrelid"
WHERE "tcns"."nspname" = 'public' AND "tc"."relname" = 'session'
ORDER BY "ia"."attnum" ASC";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.280803;i:4;a:0:{}i:5;i:2278808;}i:70;a:6:{i:0;s:563:"SELECT
    "ic"."relname" AS "name",
    "ia"."attname" AS "column_name",
    "i"."indisunique" AS "index_is_unique",
    "i"."indisprimary" AS "index_is_primary"
FROM "pg_class" AS "tc"
INNER JOIN "pg_namespace" AS "tcns"
    ON "tcns"."oid" = "tc"."relnamespace"
INNER JOIN "pg_index" AS "i"
    ON "i"."indrelid" = "tc"."oid"
INNER JOIN "pg_class" AS "ic"
    ON "ic"."oid" = "i"."indexrelid"
INNER JOIN "pg_attribute" AS "ia"
    ON "ia"."attrelid" = "i"."indexrelid"
WHERE "tcns"."nspname" = 'public' AND "tc"."relname" = 'session'
ORDER BY "ia"."attnum" ASC";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.284312;i:4;a:0:{}i:5;i:2280376;}i:72;a:6:{i:0;s:262:"INSERT INTO "session" ("data", "id", "expire") VALUES ('a:2:{s:7:"__flash";a:0:{}s:5:"_csrf";s:32:"tfayXCmZhVGKUryBa3ADeApkH5cPOu8F";}', 'ml6r0cfa5hcchjkm8jmjlcjpe8', 1794842133) ON CONFLICT ("id") DO UPDATE SET "data"=EXCLUDED."data", "expire"=EXCLUDED."expire"";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.28605;i:4;a:0:{}i:5;i:2281336;}i:73;a:6:{i:0;s:262:"INSERT INTO "session" ("data", "id", "expire") VALUES ('a:2:{s:7:"__flash";a:0:{}s:5:"_csrf";s:32:"tfayXCmZhVGKUryBa3ADeApkH5cPOu8F";}', 'ml6r0cfa5hcchjkm8jmjlcjpe8', 1794842133) ON CONFLICT ("id") DO UPDATE SET "data"=EXCLUDED."data", "expire"=EXCLUDED."expire"";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.288611;i:4;a:0:{}i:5;i:2281888;}i:75;a:6:{i:0;s:92:"SELECT "data" FROM "session" WHERE "expire">1794840693 AND "id"='tmcur0n5t4d0h3vgh941v351nu'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.29006;i:4;a:0:{}i:5;i:2282488;}i:76;a:6:{i:0;s:92:"SELECT "data" FROM "session" WHERE "expire">1794840693 AND "id"='tmcur0n5t4d0h3vgh941v351nu'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.298954;i:4;a:0:{}i:5;i:2283048;}i:78;a:6:{i:0;s:63:"SELECT * FROM "session" WHERE "id"='ml6r0cfa5hcchjkm8jmjlcjpe8'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.300928;i:4;a:0:{}i:5;i:2282672;}i:79;a:6:{i:0;s:63:"SELECT * FROM "session" WHERE "id"='ml6r0cfa5hcchjkm8jmjlcjpe8'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.303582;i:4;a:0:{}i:5;i:2284360;}i:81;a:6:{i:0;s:94:"UPDATE "session" SET "id"='tmcur0n5t4d0h3vgh941v351nu' WHERE "id"='ml6r0cfa5hcchjkm8jmjlcjpe8'";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.305093;i:4;a:0:{}i:5;i:2284624;}i:82;a:6:{i:0;s:94:"UPDATE "session" SET "id"='tmcur0n5t4d0h3vgh941v351nu' WHERE "id"='ml6r0cfa5hcchjkm8jmjlcjpe8'";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.310417;i:4;a:0:{}i:5;i:2285096;}i:85;a:6:{i:0;s:76:"UPDATE "session" SET "patientid"=446 WHERE id = 'tmcur0n5t4d0h3vgh941v351nu'";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.312636;i:4;a:0:{}i:5;i:2364400;}i:86;a:6:{i:0;s:76:"UPDATE "session" SET "patientid"=446 WHERE id = 'tmcur0n5t4d0h3vgh941v351nu'";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.315429;i:4;a:0:{}i:5;i:2364904;}i:88;a:6:{i:0;s:75:"UPDATE "session" SET "agentid"=NULL WHERE id = 'tmcur0n5t4d0h3vgh941v351nu'";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.317116;i:4;a:0:{}i:5;i:2365752;}i:89;a:6:{i:0;s:75:"UPDATE "session" SET "agentid"=NULL WHERE id = 'tmcur0n5t4d0h3vgh941v351nu'";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.320002;i:4;a:0:{}i:5;i:2366224;}i:91;a:6:{i:0;s:83:"UPDATE "session" SET "patient"='oldtesting' WHERE id = 'tmcur0n5t4d0h3vgh941v351nu'";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.321346;i:4;a:0:{}i:5;i:2367072;}i:92;a:6:{i:0;s:83:"UPDATE "session" SET "patient"='oldtesting' WHERE id = 'tmcur0n5t4d0h3vgh941v351nu'";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.323608;i:4;a:0:{}i:5;i:2373176;}i:94;a:6:{i:0;s:67:"SELECT patientid from session where id='tmcur0n5t4d0h3vgh941v351nu'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.324796;i:4;a:0:{}i:5;i:2373664;}i:95;a:6:{i:0;s:67:"SELECT patientid from session where id='tmcur0n5t4d0h3vgh941v351nu'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.327016;i:4;a:0:{}i:5;i:2374152;}i:97;a:6:{i:0;s:51:"SELECT bucket FROM frontendcache WHERE "user" = 446";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.328088;i:4;a:0:{}i:5;i:2374880;}i:98;a:6:{i:0;s:51:"SELECT bucket FROM frontendcache WHERE "user" = 446";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.354347;i:4;a:0:{}i:5;i:3780320;}i:100;a:6:{i:0;s:65:"SELECT agentid from session where id='tmcur0n5t4d0h3vgh941v351nu'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.370559;i:4;a:0:{}i:5;i:8732784;}i:101;a:6:{i:0;s:65:"SELECT agentid from session where id='tmcur0n5t4d0h3vgh941v351nu'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.374103;i:4;a:0:{}i:5;i:8733264;}i:103;a:6:{i:0;s:38:"SELECT * FROM "LA_user" WHERE "id"=446";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.376425;i:4;a:0:{}i:5;i:8736200;}i:104;a:6:{i:0;s:38:"SELECT * FROM "LA_user" WHERE "id"=446";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.413066;i:4;a:0:{}i:5;i:8769024;}i:106;a:6:{i:0;s:151:"SELECT "ZV_gender_status" FROM "LA_gender" AS genderList
JOIN "LJ_ugender" AS usergender ON usergender.gender = genderList.id
AND usergender.user = 446";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.417861;i:4;a:0:{}i:5;i:8761616;}i:107;a:6:{i:0;s:151:"SELECT "ZV_gender_status" FROM "LA_gender" AS genderList
JOIN "LJ_ugender" AS usergender ON usergender.gender = genderList.id
AND usergender.user = 446";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.43386;i:4;a:0:{}i:5;i:8762552;}i:109;a:6:{i:0;s:43:"SELECT * FROM "LJ_usuffix" WHERE "user"=446";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.439774;i:4;a:0:{}i:5;i:8868976;}i:110;a:6:{i:0;s:43:"SELECT * FROM "LJ_usuffix" WHERE "user"=446";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.444742;i:4;a:0:{}i:5;i:8869832;}i:112;a:6:{i:0;s:1162:"SELECT LAuser."ZV_user_addr2" AS addr2, LAuser."ZV_user_addr" AS address,
LAuser."ZV_user_cell" AS cell, LAuser."ZV_user_cell2" AS cell2,
LAuser."ZV_user_city" AS city, LAuser."ZV_user_dob" AS dob,
LAuser."ZV_user_email" AS email, LAuser."ZV_user_externid" AS "externId",
LAuser."ZV_user_email" AS email, LAuser."ZV_user_externid2" AS "externId2",
LAuser."ZV_user_fst" AS "firstName", LAuser."ZV_user_home" AS home,
LAuser.id AS id, LAuser."ZV_user_lst" AS "lastName",
LAuser."ZV_user_login" AS login, LAuser."ZV_user_maddr" AS maddr,
LAuser."ZV_user_maddr2" AS maddr2, LAuser."ZV_user_mcity" AS mcity,
LAuser."ZV_user_mdl" AS "middleName", LAuser."ZV_user_mzip" AS mzip,
LAuser."ZV_user_phone1" AS phone1, LAuser."ZV_user_phone1type" AS phone1type,
LAuser."ZV_user_phone2" AS phone2, LAuser."ZV_user_phone2type" AS phone2type,
LAuser."ZV_user_ssn" AS ssn, LAuser."ZV_user_work" AS work,
LAuser."ZV_user_zip" AS zip, LArt."ZV_reltype_typ" AS "relDesc",
LAuser."ZV_user_npi" AS npi, LAuser."ZV_user_admin" AS admin 
FROM "LJ_reldesc" LJrd LEFT JOIN "LA_user" LAuser ON LAuser.id = LJrd.of 
LEFT JOIN "LA_reltype" LArt ON LJrd.nature = LArt.id WHERE LJrd.isa = 446";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.446216;i:4;a:0:{}i:5;i:8838496;}i:113;a:6:{i:0;s:1162:"SELECT LAuser."ZV_user_addr2" AS addr2, LAuser."ZV_user_addr" AS address,
LAuser."ZV_user_cell" AS cell, LAuser."ZV_user_cell2" AS cell2,
LAuser."ZV_user_city" AS city, LAuser."ZV_user_dob" AS dob,
LAuser."ZV_user_email" AS email, LAuser."ZV_user_externid" AS "externId",
LAuser."ZV_user_email" AS email, LAuser."ZV_user_externid2" AS "externId2",
LAuser."ZV_user_fst" AS "firstName", LAuser."ZV_user_home" AS home,
LAuser.id AS id, LAuser."ZV_user_lst" AS "lastName",
LAuser."ZV_user_login" AS login, LAuser."ZV_user_maddr" AS maddr,
LAuser."ZV_user_maddr2" AS maddr2, LAuser."ZV_user_mcity" AS mcity,
LAuser."ZV_user_mdl" AS "middleName", LAuser."ZV_user_mzip" AS mzip,
LAuser."ZV_user_phone1" AS phone1, LAuser."ZV_user_phone1type" AS phone1type,
LAuser."ZV_user_phone2" AS phone2, LAuser."ZV_user_phone2type" AS phone2type,
LAuser."ZV_user_ssn" AS ssn, LAuser."ZV_user_work" AS work,
LAuser."ZV_user_zip" AS zip, LArt."ZV_reltype_typ" AS "relDesc",
LAuser."ZV_user_npi" AS npi, LAuser."ZV_user_admin" AS admin 
FROM "LJ_reldesc" LJrd LEFT JOIN "LA_user" LAuser ON LAuser.id = LJrd.of 
LEFT JOIN "LA_reltype" LArt ON LJrd.nature = LArt.id WHERE LJrd.isa = 446";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.524132;i:4;a:0:{}i:5;i:8841040;}i:115;a:6:{i:0;s:38:"SELECT * FROM "LA_user" WHERE "id"=446";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.52843;i:4;a:0:{}i:5;i:8837968;}i:116;a:6:{i:0;s:38:"SELECT * FROM "LA_user" WHERE "id"=446";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.584299;i:4;a:0:{}i:5;i:8870416;}i:118;a:6:{i:0;s:67:"SELECT * FROM "LJ_pdfs" WHERE "user"=446 ORDER BY "recordedAt" DESC";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.58714;i:4;a:0:{}i:5;i:8878992;}i:119;a:6:{i:0;s:67:"SELECT * FROM "LJ_pdfs" WHERE "user"=446 ORDER BY "recordedAt" DESC";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.594117;i:4;a:0:{}i:5;i:8879840;}i:121;a:6:{i:0;s:423:"SELECT "LA_rprt".* FROM "LA_rprt" LEFT JOIN "LJ_usrrprt" ON "LA_rprt"."id" = "LJ_usrrprt"."report" LEFT JOIN "LJ_rprtnpi" ON "LA_rprt"."id" = "LJ_rprtnpi"."report" LEFT JOIN "LJ_rprtctgry" ON "LA_rprt"."id" = "LJ_rprtctgry"."report" LEFT JOIN "LJ_procrprt" ON "LA_rprt"."id" = "LJ_procrprt"."rprt" LEFT JOIN "LJ_rprtproc" ON "LA_rprt"."id" = "LJ_rprtproc"."report" WHERE "LJ_usrrprt"."user"=446 ORDER BY "ZV_rprt_when" DESC";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.59831;i:4;a:0:{}i:5;i:8999648;}i:122;a:6:{i:0;s:423:"SELECT "LA_rprt".* FROM "LA_rprt" LEFT JOIN "LJ_usrrprt" ON "LA_rprt"."id" = "LJ_usrrprt"."report" LEFT JOIN "LJ_rprtnpi" ON "LA_rprt"."id" = "LJ_rprtnpi"."report" LEFT JOIN "LJ_rprtctgry" ON "LA_rprt"."id" = "LJ_rprtctgry"."report" LEFT JOIN "LJ_procrprt" ON "LA_rprt"."id" = "LJ_procrprt"."rprt" LEFT JOIN "LJ_rprtproc" ON "LA_rprt"."id" = "LJ_rprtproc"."report" WHERE "LJ_usrrprt"."user"=446 ORDER BY "ZV_rprt_when" DESC";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.620874;i:4;a:0:{}i:5;i:9000504;}i:124;a:6:{i:0;s:769:"    with
    cte as (
    select l1.id,j0.npi,j2.ctgry,j3.ccd
    from "LA_rprt" l1
    join "LJ_rprtnpi" j0 on j0.report = l1.id
    join "LJ_usrrprt" j1 on j1.report = l1.id
    join "LJ_rprtctgry" j2 on j2.report = l1.id
    join "LJ_rprtproc" j3 on j3.report = l1.id
    where j1."user" = 446
    order by l1.id desc
    )
    select 'ctgry' as kind,x.ctgry as value
    from (
    select max(id) z,ctgry
    from cte
    group by ctgry
    order by z desc
    ) x
    union all
    select 'ccd' as kind, y.ccd as value
    from (
    select max(id) z,ccd
    from cte
    group by ccd
    order by z desc
    ) y
    union all
    select 'npi' as kind,z.npi as value
    from (
    select max(id) z,npi
    from cte
    group by npi
    order by z desc
    ) z    ";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.622574;i:4;a:0:{}i:5;i:8997120;}i:125;a:6:{i:0;s:769:"    with
    cte as (
    select l1.id,j0.npi,j2.ctgry,j3.ccd
    from "LA_rprt" l1
    join "LJ_rprtnpi" j0 on j0.report = l1.id
    join "LJ_usrrprt" j1 on j1.report = l1.id
    join "LJ_rprtctgry" j2 on j2.report = l1.id
    join "LJ_rprtproc" j3 on j3.report = l1.id
    where j1."user" = 446
    order by l1.id desc
    )
    select 'ctgry' as kind,x.ctgry as value
    from (
    select max(id) z,ctgry
    from cte
    group by ctgry
    order by z desc
    ) x
    union all
    select 'ccd' as kind, y.ccd as value
    from (
    select max(id) z,ccd
    from cte
    group by ccd
    order by z desc
    ) y
    union all
    select 'npi' as kind,z.npi as value
    from (
    select max(id) z,npi
    from cte
    group by npi
    order by z desc
    ) z    ";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.628724;i:4;a:0:{}i:5;i:8997752;}i:127;a:6:{i:0;s:92:"SELECT "data" FROM "session" WHERE "expire">1794840693 AND "id"='tmcur0n5t4d0h3vgh941v351nu'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.79259;i:4;a:0:{}i:5;i:3535648;}i:128;a:6:{i:0;s:92:"SELECT "data" FROM "session" WHERE "expire">1794840693 AND "id"='tmcur0n5t4d0h3vgh941v351nu'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1794840693.7958;i:4;a:0:{}i:5;i:3536576;}i:130;a:6:{i:0;s:354:"INSERT INTO "session" ("data", "id", "expire") VALUES ('a:5:{s:7:"__flash";a:0:{}s:5:"_csrf";s:32:"TjVWd7Cu7NKyqZ5hiUiS8vv4nm8nnvLS";s:4:"__id";i:446;s:9:"__authKey";s:23:"6abfbb0f107aa0.22344324";s:8:"__expire";i:1794841293;}', 'tmcur0n5t4d0h3vgh941v351nu', 1794842133) ON CONFLICT ("id") DO UPDATE SET "data"=EXCLUDED."data", "expire"=EXCLUDED."expire"";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.797317;i:4;a:0:{}i:5;i:3540600;}i:131;a:6:{i:0;s:354:"INSERT INTO "session" ("data", "id", "expire") VALUES ('a:5:{s:7:"__flash";a:0:{}s:5:"_csrf";s:32:"TjVWd7Cu7NKyqZ5hiUiS8vv4nm8nnvLS";s:4:"__id";i:446;s:9:"__authKey";s:23:"6abfbb0f107aa0.22344324";s:8:"__expire";i:1794841293;}', 'tmcur0n5t4d0h3vgh941v351nu', 1794842133) ON CONFLICT ("id") DO UPDATE SET "data"=EXCLUDED."data", "expire"=EXCLUDED."expire"";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1794840693.802367;i:4;a:0:{}i:5;i:3541152;}}}";s:5:"event";s:6237:"a:36:{i:0;a:5:{s:4:"time";d:1794840692.645527;s:4:"name";s:9:"afterOpen";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"yii\db\Connection";}i:1;a:5:{s:4:"time";d:1794840692.65341;s:4:"name";s:13:"beforeRequest";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:2;a:5:{s:4:"time";d:1794840692.65459;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:3;a:5:{s:4:"time";d:1794840692.655219;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:33:"app\controllers\SessionController";}i:4;a:5:{s:4:"time";d:1794840692.656324;s:4:"name";s:16:"beginTransaction";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"yii\db\Connection";}i:5;a:5:{s:4:"time";d:1794840692.673876;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:6;a:5:{s:4:"time";d:1794840692.942629;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"app\db\models\LA_user";}i:7;a:5:{s:4:"time";d:1794840692.943283;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"app\db\models\LA_user";}i:8;a:5:{s:4:"time";d:1794840693.018422;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"app\db\models\LA_user";}i:9;a:5:{s:4:"time";d:1794840693.018513;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"app\db\models\LA_user";}i:10;a:5:{s:4:"time";d:1794840693.018545;s:4:"name";s:12:"beforeUpdate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"app\db\models\LA_user";}i:11;a:5:{s:4:"time";d:1794840693.109089;s:4:"name";s:11:"afterUpdate";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"app\db\models\LA_user";}i:12;a:5:{s:4:"time";d:1794840693.253768;s:4:"name";s:11:"beforeLogin";s:5:"class";s:17:"yii\web\UserEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\User";}i:13;a:5:{s:4:"time";d:1794840693.312289;s:4:"name";s:10:"afterLogin";s:5:"class";s:17:"yii\web\UserEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\User";}i:14;a:5:{s:4:"time";d:1794840693.375392;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:15;a:5:{s:4:"time";d:1794840693.417107;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"app\db\models\LA_user";}i:16;a:5:{s:4:"time";d:1794840693.417662;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"app\db\models\LA_user";}i:17;a:5:{s:4:"time";d:1794840693.439445;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:18;a:5:{s:4:"time";d:1794840693.528101;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:19;a:5:{s:4:"time";d:1794840693.585581;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"app\db\models\LA_user";}i:20;a:5:{s:4:"time";d:1794840693.586211;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"app\db\models\LA_user";}i:21;a:5:{s:4:"time";d:1794840693.586676;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:22;a:5:{s:4:"time";d:1794840693.596486;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:23;a:5:{s:4:"time";d:1794840693.596669;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"app\db\models\LA_rprt";}i:24;a:5:{s:4:"time";d:1794840693.596916;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:25;a:5:{s:4:"time";d:1794840693.597235;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:26;a:5:{s:4:"time";d:1794840693.597447;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:27;a:5:{s:4:"time";d:1794840693.597652;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:28;a:5:{s:4:"time";d:1794840693.597853;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:29;a:5:{s:4:"time";d:1794840693.639082;s:4:"name";s:17:"commitTransaction";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"yii\db\Connection";}i:30;a:5:{s:4:"time";d:1794840693.712823;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:33:"app\controllers\SessionController";}i:31;a:5:{s:4:"time";d:1794840693.712854;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:32;a:5:{s:4:"time";d:1794840693.71289;s:4:"name";s:12:"afterRequest";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:33;a:5:{s:4:"time";d:1794840693.712911;s:4:"name";s:10:"beforeSend";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}i:34;a:5:{s:4:"time";d:1794840693.713402;s:4:"name";s:12:"afterPrepare";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}i:35;a:5:{s:4:"time";d:1794840693.790634;s:4:"name";s:9:"afterSend";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}}";s:4:"mail";s:6:"a:0:{}";s:8:"timeline";s:92:"a:3:{s:5:"start";d:1794840692.595109;s:3:"end";d:1794840693.812203;s:6:"memory";i:13443368;}";s:4:"dump";s:6:"a:0:{}";s:6:"router";s:123:"a:3:{s:8:"messages";a:0:{}s:5:"route";s:13:"session/login";s:6:"action";s:42:"app\controllers\session\LoginAction::run()";}";s:7:"request";s:5098:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:17:{s:6:"cookie";s:38:"mediSession=ml6r0cfa5hcchjkm8jmjlcjpe8";s:15:"accept-language";s:14:"en-US,en;q=0.9";s:15:"accept-encoding";s:23:"gzip, deflate, br, zstd";s:7:"referer";s:25:"https://13.90.24.85:8080/";s:14:"sec-fetch-dest";s:5:"empty";s:14:"sec-fetch-mode";s:4:"cors";s:14:"sec-fetch-site";s:11:"same-origin";s:6:"origin";s:24:"https://13.90.24.85:8080";s:16:"sec-ch-ua-mobile";s:2:"?0";s:12:"content-type";s:31:"application/json; charset=UTF-8";s:9:"sec-ch-ua";s:65:""Not-A.Brand";v="99", "Google Chrome";v="157", "Chromium";v="157"";s:6:"accept";s:33:"application/json, text/plain, */*";s:10:"user-agent";s:111:"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/157.0.0.0 Safari/537.36";s:18:"sec-ch-ua-platform";s:9:""Windows"";s:14:"content-length";s:3:"183";s:10:"connection";s:5:"close";s:4:"host";s:9:"localhost";}s:15:"responseHeaders";a:10:{s:7:"Expires";s:29:"Thu, 19 Nov 1981 08:52:00 GMT";s:13:"Cache-Control";s:35:"no-store, no-cache, must-revalidate";s:6:"Pragma";s:8:"no-cache";s:10:"Set-Cookie";s:56:"mediSession=tmcur0n5t4d0h3vgh941v351nu; path=/; HttpOnly";s:27:"Access-Control-Allow-Origin";s:24:"https://13.90.24.85:8080";s:32:"Access-Control-Allow-Credentials";s:4:"true";s:12:"Content-Type";s:24:"text/html; charset=UTF-8";s:11:"X-Debug-Tag";s:13:"6afb18749f2b5";s:16:"X-Debug-Duration";s:5:"1,119";s:12:"X-Debug-Link";s:51:"/pacmny-be/web/debug/default/view?tag=6afb18749f2b5";}s:5:"route";s:13:"session/login";s:6:"action";s:42:"app\controllers\session\LoginAction::run()";s:12:"actionParams";a:0:{}s:7:"general";a:5:{s:6:"method";s:4:"POST";s:6:"isAjax";b:0;s:6:"isPjax";b:0;s:7:"isFlash";b:0;s:18:"isSecureConnection";b:0;}s:11:"requestBody";a:3:{s:12:"Content Type";s:31:"application/json; charset=UTF-8";s:3:"Raw";s:183:"{"data":{"patient":"oldtesting","password":"Kathmandu123!"},"action":"requestLogin","_csrf":"RZuarg3QjOR4cAXHRu0vsVEMkOpQGtxFZs_PCLSFs28x_fvXVZPhvhAmQowTn1bzMD_RrjVbrC4u-qxY-_CLKQ=="}";s:7:"Decoded";a:3:{s:4:"data";a:2:{s:7:"patient";s:10:"oldtesting";s:8:"password";s:13:"Kathmandu123!";}s:6:"action";s:12:"requestLogin";s:5:"_csrf";s:88:"RZuarg3QjOR4cAXHRu0vsVEMkOpQGtxFZs_PCLSFs28x_fvXVZPhvhAmQowTn1bzMD_RrjVbrC4u-qxY-_CLKQ==";}}s:6:"SERVER";a:47:{s:14:"OPENAI_API_KEY";s:164:"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";s:21:"HTTP_X_FORWARDED_HOST";s:16:"13.90.24.85:8080";s:22:"HTTP_X_FORWARDED_PROTO";s:5:"https";s:21:"HTTP_X_FORWARDED_PORT";s:4:"8080";s:20:"HTTP_X_FORWARDED_FOR";s:9:"127.0.0.1";s:11:"HTTP_COOKIE";s:38:"mediSession=ml6r0cfa5hcchjkm8jmjlcjpe8";s:20:"HTTP_ACCEPT_LANGUAGE";s:14:"en-US,en;q=0.9";s:20:"HTTP_ACCEPT_ENCODING";s:23:"gzip, deflate, br, zstd";s:12:"HTTP_REFERER";s:25:"https://13.90.24.85:8080/";s:19:"HTTP_SEC_FETCH_DEST";s:5:"empty";s:19:"HTTP_SEC_FETCH_MODE";s:4:"cors";s:19:"HTTP_SEC_FETCH_SITE";s:11:"same-origin";s:11:"HTTP_ORIGIN";s:24:"https://13.90.24.85:8080";s:21:"HTTP_SEC_CH_UA_MOBILE";s:2:"?0";s:12:"CONTENT_TYPE";s:31:"application/json; charset=UTF-8";s:14:"HTTP_SEC_CH_UA";s:65:""Not-A.Brand";v="99", "Google Chrome";v="157", "Chromium";v="157"";s:11:"HTTP_ACCEPT";s:33:"application/json, text/plain, */*";s:15:"HTTP_USER_AGENT";s:111:"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/157.0.0.0 Safari/537.36";s:23:"HTTP_SEC_CH_UA_PLATFORM";s:9:""Windows"";s:14:"CONTENT_LENGTH";s:3:"183";s:15:"HTTP_CONNECTION";s:5:"close";s:9:"HTTP_HOST";s:9:"localhost";s:4:"PATH";s:60:"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin";s:16:"SERVER_SIGNATURE";s:70:"<address>Apache/2.4.29 (Ubuntu) Server at localhost Port 80</address>
";s:15:"SERVER_SOFTWARE";s:22:"Apache/2.4.29 (Ubuntu)";s:11:"SERVER_NAME";s:9:"localhost";s:11:"SERVER_ADDR";s:9:"127.0.0.1";s:11:"SERVER_PORT";s:2:"80";s:11:"REMOTE_ADDR";s:9:"127.0.0.1";s:13:"DOCUMENT_ROOT";s:13:"/var/www/html";s:14:"REQUEST_SCHEME";s:4:"http";s:14:"CONTEXT_PREFIX";s:0:"";s:21:"CONTEXT_DOCUMENT_ROOT";s:13:"/var/www/html";s:12:"SERVER_ADMIN";s:19:"webmaster@localhost";s:15:"SCRIPT_FILENAME";s:37:"/var/www/html/pacmny-be/web/index.php";s:11:"REMOTE_PORT";s:5:"48046";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:14:"REQUEST_METHOD";s:4:"POST";s:12:"QUERY_STRING";s:0:"";s:11:"REQUEST_URI";s:38:"/pacmny-be/web/index.php/session/login";s:11:"SCRIPT_NAME";s:24:"/pacmny-be/web/index.php";s:9:"PATH_INFO";s:14:"/session/login";s:15:"PATH_TRANSLATED";s:27:"/var/www/html/session/login";s:8:"PHP_SELF";s:38:"/pacmny-be/web/index.php/session/login";s:18:"REQUEST_TIME_FLOAT";d:1794840692.592;s:12:"REQUEST_TIME";i:1794840692;}s:3:"GET";a:0:{}s:4:"POST";a:0:{}s:6:"COOKIE";a:1:{s:11:"mediSession";s:26:"ml6r0cfa5hcchjkm8jmjlcjpe8";}s:5:"FILES";a:0:{}s:7:"SESSION";a:5:{s:7:"__flash";a:0:{}s:5:"_csrf";s:32:"TjVWd7Cu7NKyqZ5hiUiS8vv4nm8nnvLS";s:4:"__id";i:446;s:9:"__authKey";s:23:"6abfbb0f107aa0.22344324";s:8:"__expire";i:1794841293;}}";s:4:"user";s:334:"a:5:{s:2:"id";i:446;s:8:"identity";a:6:{s:2:"id";s:3:"446";s:8:"username";s:12:"'oldtesting'";s:8:"password";s:4:"null";s:7:"authKey";s:25:"'6abfbb0f107aa0.22344324'";s:11:"accessToken";s:4:"null";s:5:"email";s:43:"'07e11fb101-4cc3f3+user1@inbox.mailtrap.io'";}s:10:"attributes";N;s:13:"rolesProvider";N;s:19:"permissionsProvider";N;}";s:5:"asset";s:6:"a:0:{}";s:7:"summary";a:12:{s:3:"tag";s:13:"6afb18749f2b5";s:3:"url";s:54:"http://localhost/pacmny-be/web/index.php/session/login";s:4:"ajax";i:0;s:6:"method";s:4:"POST";s:2:"ip";s:9:"127.0.0.1";s:4:"time";d:1794840692.592;s:10:"statusCode";i:200;s:8:"sqlCount";i:43;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:13443368;s:14:"processingTime";d:1.2167699337005615;}s:10:"exceptions";a:0:{}}