ConfigurationLogsProfilingDatabaseEventsMailTimelineDumpRouterRequestUserAsset Bundles
Prev Next
All Latest
681d5792efc58: GET http://mickey88indo.com/promotion/index at 2025-05-09 08:17:06 am by 172.70.208.168

Log Messages

Total 270 item.
#TimeSince previousLevelCategoryMessage
   
108:17:06.978
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\bootstrap5\i18n\TranslationBootstrap::bootstrap()
208:17:06.981
< 3ms >
traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
308:17:06.981
< 0ms >
traceyii\base\Module::getModuleLoading module: debug
408:17:06.982
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
508:17:06.982
< 0ms >
traceyii\base\Module::getModuleLoading module: gii
608:17:06.982
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
708:17:06.982
< 0ms >
traceyii\redis\Connection::openOpening redis DB connection: tcp://private-redis-agent-staging-do-user-13748639-0.b.db.ondigitalocean.com:25061, database=1
808:17:06.995
< 12ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: AUTH
908:17:06.997
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
1008:17:06.997
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
1108:17:06.998
< 0ms >
infoyii\web\Session::openSession started
1208:17:06.998
< 0ms >
traceyii\web\Application::handleRequestRoute requested: 'promotion/index'
1308:17:06.998
< 0ms >
traceyii\base\Controller::runActionRoute to run: promotion/index
1408:17:06.998
< 0ms >
traceyii\redis\Connection::openOpening redis DB connection: tcp://private-redis-agent-staging-do-user-13748639-0.b.db.ondigitalocean.com:25061, database=0
1508:17:07.007
< 8ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: AUTH
1608:17:07.009
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
1708:17:07.009
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
1808:17:07.011
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
1908:17:07.017
< 6ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2008:17:07.017
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2108:17:07.018
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2208:17:07.019
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2308:17:07.019
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2408:17:07.020
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2508:17:07.025
< 4ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2608:17:07.025
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2708:17:07.026
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2808:17:07.027
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2908:17:07.027
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3008:17:07.028
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3108:17:07.028
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3208:17:07.029
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3308:17:07.029
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3408:17:07.030
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3508:17:07.031
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3608:17:07.031
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3708:17:07.032
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3808:17:07.033
< 0ms >
traceyii\base\InlineAction::runWithParamsRunning action: app\controllers\PromotionController::actionIndex()
3908:17:07.033
< 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
4008:17:07.048
< 14ms >
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' AND d.nspname = 'public' ORDER BY a.attnum;
4108:17:07.069
< 21ms >
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' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum
4208:17:07.075
< 6ms >
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;
4308:17:07.082
< 6ms >
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
4408:17:07.090
< 7ms >
traceyii\base\View::renderFileRendering view file: /var/www/member-area/views/promotion/index.php
4508:17:07.090
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4608:17:07.092
< 1ms >
infoyii\db\Command::querySELECT COUNT(*) FROM "promotion" WHERE ("is_deleted"=0) AND ("start_date" <= '2025-05-09') AND ("end_date" >= '2025-05-09') AND ("start_time" <= '08:17') AND ("end_time" >= '08:17') AND ("is_active"=1) AND ("is_deleted"=0)
4708:17:07.096
< 3ms >
infoyii\db\Command::querySELECT * FROM "promotion" WHERE ("is_deleted"=0) AND ("start_date" <= '2025-05-09') AND ("end_date" >= '2025-05-09') AND ("start_time" <= '08:17') AND ("end_time" >= '08:17') AND ("is_active"=1) AND ("is_deleted"=0) ORDER BY "index", "current_join_count" DESC LIMIT 20
4808:17:07.099
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4908:17:07.102
< 3ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5008:17:07.103
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5108:17:07.104
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5208:17:07.104
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5308:17:07.105
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5408:17:07.106
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5508:17:07.107
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5608:17:07.107
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5708:17:07.108
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5808:17:07.108
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5908:17:07.109
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6008:17:07.109
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6108:17:07.110
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6208:17:07.111
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6308:17:07.111
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6408:17:07.112
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6508:17:07.112
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6608:17:07.113
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6708:17:07.113
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6808:17:07.114
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6908:17:07.115
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7008:17:07.115
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7108:17:07.116
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7208:17:07.117
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7308:17:07.117
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7408:17:07.118
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7508:17:07.119
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7608:17:07.119
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7708:17:07.120
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7808:17:07.120
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7908:17:07.121
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8008:17:07.122
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8108:17:07.122
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8208:17:07.123
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8308:17:07.123
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8408:17:07.124
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8508:17:07.124
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8608:17:07.125
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8708:17:07.126
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8808:17:07.126
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8908:17:07.127
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9008:17:07.127
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9108:17:07.128
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9208:17:07.129
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9308:17:07.129
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9408:17:07.130
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9508:17:07.131
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9608:17:07.131
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9708:17:07.132
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9808:17:07.132
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9908:17:07.133
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10008:17:07.134
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10108:17:07.134
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10208:17:07.135
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10308:17:07.138
< 3ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10408:17:07.140
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10508:17:07.141
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10608:17:07.142
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10708:17:07.143
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10808:17:07.143
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10908:17:07.144
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11008:17:07.145
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11108:17:07.146
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11208:17:07.146
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11308:17:07.147
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11408:17:07.147
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11508:17:07.148
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11608:17:07.148
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11708:17:07.149
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11808:17:07.149
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11908:17:07.150
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12008:17:07.151
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12108:17:07.151
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12208:17:07.152
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12308:17:07.152
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12408:17:07.153
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12508:17:07.154
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12608:17:07.154
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12708:17:07.155
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12808:17:07.155
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12908:17:07.156
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13008:17:07.156
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13108:17:07.157
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13208:17:07.158
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13308:17:07.159
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13408:17:07.159
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13508:17:07.160
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13608:17:07.160
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13708:17:07.161
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13808:17:07.162
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13908:17:07.162
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14008:17:07.163
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14108:17:07.163
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14208:17:07.164
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14308:17:07.164
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14408:17:07.165
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14508:17:07.167
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14608:17:07.167
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14708:17:07.168
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14808:17:07.168
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14908:17:07.169
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15008:17:07.170
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15108:17:07.170
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15208:17:07.171
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15308:17:07.171
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15408:17:07.172
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15508:17:07.173
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15608:17:07.173
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15708:17:07.174
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15808:17:07.175
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15908:17:07.175
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16008:17:07.176
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16108:17:07.177
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16208:17:07.181
< 4ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16308:17:07.184
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16408:17:07.184
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16508:17:07.185
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16608:17:07.186
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16708:17:07.190
< 4ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16808:17:07.191
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16908:17:07.192
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17008:17:07.193
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17108:17:07.194
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17208:17:07.194
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17308:17:07.195
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17408:17:07.195
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17508:17:07.196
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17608:17:07.197
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17708:17:07.197
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17808:17:07.198
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17908:17:07.199
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18008:17:07.199
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18108:17:07.200
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18208:17:07.200
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18308:17:07.201
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18408:17:07.202
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18508:17:07.202
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18608:17:07.203
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18708:17:07.204
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18808:17:07.204
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18908:17:07.205
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19008:17:07.205
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19108:17:07.206
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19208:17:07.207
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19308:17:07.207
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19408:17:07.208
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19508:17:07.208
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19608:17:07.209
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19708:17:07.210
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19808:17:07.210
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19908:17:07.211
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20008:17:07.211
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20108:17:07.212
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20208:17:07.213
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20308:17:07.213
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20408:17:07.214
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20508:17:07.215
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20608:17:07.215
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20708:17:07.216
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20808:17:07.217
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20908:17:07.217
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21008:17:07.218
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21108:17:07.218
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21208:17:07.219
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21308:17:07.220
< 1ms >
infoyii\db\Command::querySELECT COUNT(*) FROM "promotion_ongoing" WHERE ("join_date" >= '2025-05-02 00:00:00') AND ("join_date" <= '2025-05-09 23:59:59')
21408:17:07.222
< 2ms >
traceyii\base\View::renderFileRendering view file: /var/www/member-area/views/layouts/main.php
21508:17:07.223
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21608:17:07.223
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21708:17:07.224
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21808:17:07.225
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21908:17:07.225
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22008:17:07.226
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22108:17:07.226
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22208:17:07.227
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22308:17:07.227
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22408:17:07.228
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22508:17:07.229
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22608:17:07.230
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22708:17:07.230
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22808:17:07.231
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22908:17:07.231
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23008:17:07.232
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23108:17:07.232
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23208:17:07.233
< 1ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='menu_order'
23308:17:07.235
< 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;
23408:17:07.241
< 6ms >
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
23508:17:07.246
< 4ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='language'
23608:17:07.248
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23708:17:07.248
< 0ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='active_qris'
23808:17:07.250
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23908:17:07.251
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24008:17:07.251
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24108:17:07.252
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24208:17:07.252
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24308:17:07.253
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24408:17:07.254
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24508:17:07.254
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24608:17:07.255
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24708:17:07.255
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24808:17:07.256
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24908:17:07.256
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25008:17:07.257
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25108:17:07.257
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25208:17:07.258
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25308:17:07.258
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25408:17:07.259
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25508:17:07.259
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25608:17:07.260
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25708:17:07.260
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25808:17:07.261
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25908:17:07.262
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26008:17:07.262
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26108:17:07.263
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26208:17:07.263
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26308:17:07.264
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26408:17:07.264
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26508:17:07.265
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26608:17:07.265
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26708:17:07.266
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: HGET
26808:17:07.267
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26908:17:07.268
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
27008:17:07.272
< 3ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SET