Log Messages

Total 113 item.
#TimeSince previousLevelCategoryMessage
   
116:47:41.633
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\bootstrap5\i18n\TranslationBootstrap::bootstrap()
216:47:41.634
< 1ms >
traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
316:47:41.634
< 0ms >
traceyii\base\Module::getModuleLoading module: debug
416:47:41.635
< 0ms >
traceyii\redis\Connection::openOpening redis DB connection: tcp://private-redis-agent-staging-do-user-13748639-0.b.db.ondigitalocean.com:25061, database=1
516:47:41.645
< 10ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: AUTH
616:47:41.654
< 8ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
716:47:41.655
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
816:47:41.656
< 0ms >
infoyii\web\Session::openSession started
916:47:41.656
< 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
1016:47:41.681
< 24ms >
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;
1116:47:41.701
< 19ms >
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
1216:47:41.708
< 7ms >
infoyii\db\Command::querySELECT * FROM "member" WHERE ("id"='1f05e3b5-5aee-6d5a-8f45-5e1409fc0711') AND ("is_deleted"=0) AND ("status" IN (1, 2))
1316:47:41.712
< 4ms >
traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
1416:47:41.712
< 0ms >
traceyii\base\Module::getModuleLoading module: gii
1516:47:41.712
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
1616:47:41.713
< 0ms >
traceyii\web\Application::handleRequestRoute requested: 'withdraw'
1716:47:41.713
< 0ms >
traceyii\base\Controller::runActionRoute to run: withdraw/index
1816:47:41.713
< 0ms >
traceyii\redis\Connection::openOpening redis DB connection: tcp://private-redis-agent-staging-do-user-13748639-0.b.db.ondigitalocean.com:25061, database=0
1916:47:41.725
< 11ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: AUTH
2016:47:41.727
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
2116:47:41.727
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2216:47:41.728
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2316:47:41.728
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2416:47:41.729
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2516:47:41.729
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2616:47:41.730
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2716:47:41.730
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2816:47:41.731
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2916:47:41.732
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3016:47:41.737
< 5ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3116:47:41.738
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3216:47:41.738
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3316:47:41.739
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3416:47:41.739
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3516:47:41.740
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3616:47:41.741
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3716:47:41.741
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3816:47:41.742
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3916:47:41.742
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4016:47:41.743
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4116:47:41.743
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4216:47:41.744
< 0ms >
traceyii\base\InlineAction::runWithParamsRunning action: app\controllers\WithdrawController::actionIndex()
4316:47:41.746
< 1ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='maximum_withdraw'
4416:47:41.749
< 3ms >
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;
4516:47:41.760
< 10ms >
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
4616:47:41.765
< 5ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='minimum_withdraw'
4716:47:41.767
< 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 = 'member_bank' AND d.nspname = 'public' ORDER BY a.attnum;
4816:47:41.779
< 11ms >
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_bank' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum
4916:47:41.786
< 6ms >
infoyii\db\Command::querySELECT * FROM "member_bank" WHERE ("member_id"='1f05e3b5-5aee-6d5a-8f45-5e1409fc0711') AND ("is_withdraw"=1) AND ("is_deleted"=0)
5016:47:41.789
< 3ms >
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 = 'withdraw' AND d.nspname = 'public' ORDER BY a.attnum;
5116:47:41.800
< 10ms >
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='withdraw' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum
5216:47:41.806
< 6ms >
infoyii\db\Command::querySELECT * FROM "withdraw" WHERE ("member_id"='1f05e3b5-5aee-6d5a-8f45-5e1409fc0711') AND ("status" IN (1, -1))
5316:47:41.809
< 3ms >
traceyii\base\View::renderFileRendering view file: /var/www/member-area/views/withdraw/index.php
5416:47:41.810
< 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;
5516:47:41.820
< 10ms >
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
5616:47:41.826
< 5ms >
infoyii\db\Command::querySELECT * FROM "promotion_ongoing" WHERE ("member_id"='1f05e3b5-5aee-6d5a-8f45-5e1409fc0711') AND ("status"=1)
5716:47:41.828
< 2ms >
infoyii\db\Command::querySELECT * FROM "promotion_ongoing" WHERE ("member_id"='1f05e3b5-5aee-6d5a-8f45-5e1409fc0711') AND ("status"=5)
5816:47:41.835
< 6ms >
traceyii\base\View::renderFileRendering view file: /var/www/member-area/views/layouts/main.php
5916:47:41.835
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6016:47:41.836
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6116:47:41.836
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6216:47:41.837
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6316:47:41.837
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6416:47:41.838
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6516:47:41.839
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6616:47:41.839
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6716:47:41.840
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6816:47:41.840
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6916:47:41.841
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7016:47:41.842
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7116:47:41.842
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7216:47:41.843
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7316:47:41.843
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7416:47:41.844
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7516:47:41.845
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7616:47:41.845
< 0ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='menu_order'
7716:47:41.848
< 2ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='language'
7816:47:41.851
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7916:47:41.852
< 1ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='active_qris'
8016:47:41.855
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8116:47:41.856
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8216:47:41.857
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8316:47:41.857
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8416:47:41.858
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8516:47:41.858
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8616:47:41.859
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8716:47:41.860
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8816:47:41.860
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8916:47:41.861
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9016:47:41.861
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9116:47:41.862
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9216:47:41.862
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9316:47:41.863
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9416:47:41.864
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9516:47:41.864
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9616:47:41.865
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9716:47:41.866
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9816:47:41.867
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9916:47:41.867
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10016:47:41.869
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10116:47:41.869
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10216:47:41.870
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10316:47:41.870
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10416:47:41.871
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10516:47:41.872
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10616:47:41.873
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10716:47:41.873
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10816:47:41.874
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10916:47:41.874
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: HGET
11016:47:41.876
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11116:47:41.880
< 4ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
11216:47:41.882
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: ZADD
11316:47:41.883
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SET