Log Messages

Total 162 item.
#TimeSince previousLevelCategoryMessage
   
114:19:40.679
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\bootstrap5\i18n\TranslationBootstrap::bootstrap()
214:19:40.680
< 1ms >
traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
314:19:40.680
< 0ms >
traceyii\base\Module::getModuleLoading module: debug
414:19:40.680
< 0ms >
traceyii\redis\Connection::openOpening redis DB connection: tcp://private-redis-agent-staging-do-user-13748639-0.b.db.ondigitalocean.com:25061, database=1
514:19:40.689
< 8ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: AUTH
614:19:40.691
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
714:19:40.691
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
814:19:40.692
< 0ms >
infoyii\web\Session::openSession started
914:19:40.692
< 0ms >
infoyii\db\Connection::openOpening DB connection: pgsql:host=private-postgresql-agent-staging-do-user-13748639-0.b.db.ondigitalocean.com;port=25060;dbname=defaultdb
1014:19:40.710
< 18ms >
infoyii\db\Command::querySELECT 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 = 'member' AND d.nspname = 'public' ORDER BY a.attnum;
1114:19:40.729
< 18ms >
infoyii\db\Command::queryselect 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='member' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum
1214:19:40.735
< 6ms >
infoyii\db\Command::querySELECT * FROM "member" WHERE ("id"='1ef7843e-431a-6a7e-b3c7-5e1409fc0711') AND ("is_deleted"=0) AND ("status" IN (1, 2))
1314:19:40.738
< 3ms >
traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
1414:19:40.739
< 0ms >
traceyii\base\Module::getModuleLoading module: gii
1514:19:40.739
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
1614:19:40.739
< 0ms >
traceyii\web\Application::handleRequestRoute requested: 'play/slot'
1714:19:40.739
< 0ms >
traceyii\base\Controller::runActionRoute to run: play/slot
1814:19:40.739
< 0ms >
traceyii\redis\Connection::openOpening redis DB connection: tcp://private-redis-agent-staging-do-user-13748639-0.b.db.ondigitalocean.com:25061, database=0
1914:19:40.754
< 14ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: AUTH
2014:19:40.757
< 3ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
2114:19:40.758
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2214:19:40.758
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2314:19:40.759
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2414:19:40.760
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2514:19:40.761
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2614:19:40.762
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2714:19:40.763
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2814:19:40.764
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2914:19:40.764
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3014:19:40.766
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3114:19:40.766
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3214:19:40.767
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3314:19:40.768
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3414:19:40.768
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3514:19:40.769
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3614:19:40.770
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3714:19:40.771
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3814:19:40.771
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3914:19:40.772
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4014:19:40.773
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4114:19:40.774
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4214:19:40.774
< 0ms >
traceyii\base\InlineAction::runWithParamsRunning action: app\controllers\PlayController::actionSlot()
4314:19:40.774
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4414:19:40.775
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4514:19:40.776
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4614:19:40.777
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/member-area/views/play/list.php
4714:19:40.777
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4814:19:40.778
< 0ms >
infoyii\db\Command::querySELECT 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 = 'promotion_ongoing' AND d.nspname = 'public' ORDER BY a.attnum;
4914:19:40.788
< 9ms >
infoyii\db\Command::queryselect 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='promotion_ongoing' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum
5014:19:40.794
< 6ms >
infoyii\db\Command::querySELECT * FROM "promotion_ongoing" WHERE ("member_id"='1ef7843e-431a-6a7e-b3c7-5e1409fc0711') AND ("status"=1)
5114:19:40.796
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5214:19:40.799
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5314:19:40.800
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5414:19:40.801
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5514:19:40.802
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5614:19:40.803
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5714:19:40.804
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5814:19:40.804
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5914:19:40.805
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6014:19:40.806
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6114:19:40.807
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6214:19:40.807
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6314:19:40.808
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6414:19:40.809
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6514:19:40.810
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6614:19:40.811
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6714:19:40.814
< 3ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6814:19:40.815
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6914:19:40.816
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7014:19:40.817
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7114:19:40.818
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7214:19:40.819
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7314:19:40.820
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7414:19:40.820
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7514:19:40.821
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7614:19:40.822
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7714:19:40.823
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7814:19:40.824
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7914:19:40.824
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8014:19:40.825
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8114:19:40.826
< 1ms >
traceyii\base\View::renderFileRendering view file: /var/www/member-area/views/layouts/game.php
8214:19:40.826
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8314:19:40.827
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8414:19:40.828
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8514:19:40.829
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8614:19:40.829
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8714:19:40.830
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8814:19:40.830
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8914:19:40.831
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9014:19:40.831
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9114:19:40.832
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9214:19:40.833
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9314:19:40.833
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9414:19:40.834
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9514:19:40.834
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9614:19:40.835
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9714:19:40.835
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9814:19:40.836
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9914:19:40.837
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10014:19:40.837
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10114:19:40.838
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10214:19:40.839
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10314:19:40.839
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10414:19:40.840
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10514:19:40.841
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/member-area/views/layouts/main.php
10614:19:40.841
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10714:19:40.841
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10814:19:40.842
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10914:19:40.842
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11014:19:40.843
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11114:19:40.843
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11214:19:40.844
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11314:19:40.844
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11414:19:40.845
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11514:19:40.845
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11614:19:40.846
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11714:19:40.846
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11814:19:40.847
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11914:19:40.847
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12014:19:40.848
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12114:19:40.848
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12214:19:40.849
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12314:19:40.849
< 0ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='menu_order'
12414:19:40.851
< 2ms >
infoyii\db\Command::querySELECT 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 = 'agent_setting' AND d.nspname = 'public' ORDER BY a.attnum;
12514:19:40.861
< 9ms >
infoyii\db\Command::queryselect 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='agent_setting' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum
12614:19:40.866
< 5ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='language'
12714:19:40.868
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12814:19:40.869
< 1ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='active_qris'
12914:19:40.871
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13014:19:40.872
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13114:19:40.873
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13214:19:40.874
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13314:19:40.874
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13414:19:40.875
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13514:19:40.875
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13614:19:40.876
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13714:19:40.876
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13814:19:40.877
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13914:19:40.877
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14014:19:40.878
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14114:19:40.878
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14214:19:40.879
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14314:19:40.880
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14414:19:40.880
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14514:19:40.881
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14614:19:40.881
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14714:19:40.882
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14814:19:40.882
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14914:19:40.883
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15014:19:40.883
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15114:19:40.884
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15214:19:40.884
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15314:19:40.885
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15414:19:40.886
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15514:19:40.886
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15614:19:40.887
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15714:19:40.887
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15814:19:40.888
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: HGET
15914:19:40.890
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16014:19:40.894
< 4ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
16114:19:40.895
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: ZADD
16214:19:40.895
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SET