Log Messages

Total 162 item.
#TimeSince previousLevelCategoryMessage
   
122:30:25.233
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\bootstrap5\i18n\TranslationBootstrap::bootstrap()
222:30:25.234
< 1ms >
traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
322:30:25.234
< 0ms >
traceyii\base\Module::getModuleLoading module: debug
422:30:25.234
< 0ms >
traceyii\redis\Connection::openOpening redis DB connection: tcp://private-redis-agent-staging-do-user-13748639-0.b.db.ondigitalocean.com:25061, database=1
522:30:25.243
< 8ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: AUTH
622:30:25.245
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
722:30:25.245
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
822:30:25.246
< 0ms >
infoyii\web\Session::openSession started
922:30:25.246
< 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
1022:30:25.266
< 19ms >
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;
1122:30:25.284
< 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
1222:30:25.292
< 7ms >
infoyii\db\Command::querySELECT * FROM "member" WHERE ("id"='1eebb648-e02e-6a38-b774-5e1409fc0711') AND ("is_deleted"=0) AND ("status" IN (1, 2))
1322:30:25.295
< 3ms >
traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
1422:30:25.296
< 0ms >
traceyii\base\Module::getModuleLoading module: gii
1522:30:25.296
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
1622:30:25.296
< 0ms >
traceyii\web\Application::handleRequestRoute requested: 'play/slot'
1722:30:25.296
< 0ms >
traceyii\base\Controller::runActionRoute to run: play/slot
1822:30:25.296
< 0ms >
traceyii\redis\Connection::openOpening redis DB connection: tcp://private-redis-agent-staging-do-user-13748639-0.b.db.ondigitalocean.com:25061, database=0
1922:30:25.306
< 9ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: AUTH
2022:30:25.307
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
2122:30:25.308
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2222:30:25.308
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2322:30:25.309
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2422:30:25.310
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2522:30:25.310
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2622:30:25.311
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2722:30:25.313
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2822:30:25.313
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2922:30:25.314
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3022:30:25.314
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3122:30:25.315
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3222:30:25.315
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3322:30:25.316
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3422:30:25.316
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3522:30:25.317
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3622:30:25.318
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3722:30:25.318
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3822:30:25.319
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3922:30:25.319
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4022:30:25.320
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4122:30:25.320
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4222:30:25.321
< 0ms >
traceyii\base\InlineAction::runWithParamsRunning action: app\controllers\PlayController::actionSlot()
4322:30:25.321
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4422:30:25.322
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4522:30:25.323
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4622:30:25.324
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/member-area/views/play/list.php
4722:30:25.324
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4822:30:25.325
< 1ms >
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;
4922:30:25.334
< 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
5022:30:25.340
< 6ms >
infoyii\db\Command::querySELECT * FROM "promotion_ongoing" WHERE ("member_id"='1eebb648-e02e-6a38-b774-5e1409fc0711') AND ("status"=1)
5122:30:25.354
< 13ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5222:30:25.355
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5322:30:25.356
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5422:30:25.357
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5522:30:25.358
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5622:30:25.359
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5722:30:25.360
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5822:30:25.373
< 12ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5922:30:25.374
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6022:30:25.375
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6122:30:25.376
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6222:30:25.378
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6322:30:25.379
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6422:30:25.379
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6522:30:25.380
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6622:30:25.381
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6722:30:25.382
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6822:30:25.383
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6922:30:25.384
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7022:30:25.384
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7122:30:25.385
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7222:30:25.386
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7322:30:25.387
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7422:30:25.388
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7522:30:25.389
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7622:30:25.390
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7722:30:25.391
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7822:30:25.391
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7922:30:25.392
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8022:30:25.393
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8122:30:25.394
< 1ms >
traceyii\base\View::renderFileRendering view file: /var/www/member-area/views/layouts/game.php
8222:30:25.394
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8322:30:25.395
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8422:30:25.396
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8522:30:25.397
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8622:30:25.397
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8722:30:25.398
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8822:30:25.399
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8922:30:25.399
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9022:30:25.400
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9122:30:25.401
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9222:30:25.401
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9322:30:25.402
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9422:30:25.403
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9522:30:25.403
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9622:30:25.404
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9722:30:25.404
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9822:30:25.405
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9922:30:25.406
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10022:30:25.406
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10122:30:25.407
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10222:30:25.408
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10322:30:25.408
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10422:30:25.409
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10522:30:25.411
< 1ms >
traceyii\base\View::renderFileRendering view file: /var/www/member-area/views/layouts/main.php
10622:30:25.411
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10722:30:25.412
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10822:30:25.413
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10922:30:25.413
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11022:30:25.414
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11122:30:25.414
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11222:30:25.415
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11322:30:25.417
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11422:30:25.417
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11522:30:25.418
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11622:30:25.418
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11722:30:25.419
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11822:30:25.419
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11922:30:25.420
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12022:30:25.421
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12122:30:25.422
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12222:30:25.422
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12322:30:25.423
< 0ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='menu_order'
12422:30:25.426
< 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;
12522:30:25.435
< 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
12622:30:25.442
< 6ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='language'
12722:30:25.444
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12822:30:25.445
< 0ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='active_qris'
12922:30:25.448
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13022:30:25.449
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13122:30:25.449
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13222:30:25.450
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13322:30:25.450
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13422:30:25.451
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13522:30:25.452
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13622:30:25.452
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13722:30:25.453
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13822:30:25.453
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13922:30:25.454
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14022:30:25.454
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14122:30:25.455
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14222:30:25.455
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14322:30:25.456
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14422:30:25.456
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14522:30:25.457
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14622:30:25.458
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14722:30:25.458
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14822:30:25.459
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14922:30:25.459
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15022:30:25.460
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15122:30:25.460
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15222:30:25.461
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15322:30:25.461
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15422:30:25.462
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15522:30:25.463
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15622:30:25.463
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15722:30:25.464
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15822:30:25.465
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: HGET
15922:30:25.466
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16022:30:25.471
< 5ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
16122:30:25.473
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: ZADD
16222:30:25.474
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SET