ConfigurationLogsProfilingDatabaseEventsMailTimelineDumpRouterRequestUserAsset Bundles
Prev Next
All Latest
685dfea7a0b71: GET http://mickey88indo.com/promotion/index at 2025-06-27 09:15:03 am by 172.70.92.141

Log Messages

Total 270 item.
#TimeSince previousLevelCategoryMessage
   
109:15:03.632
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\bootstrap5\i18n\TranslationBootstrap::bootstrap()
209:15:03.657
< 25ms >
traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
309:15:03.657
< 0ms >
traceyii\base\Module::getModuleLoading module: debug
409:15:03.658
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
509:15:03.658
< 0ms >
traceyii\base\Module::getModuleLoading module: gii
609:15:03.658
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
709:15:03.659
< 0ms >
traceyii\redis\Connection::openOpening redis DB connection: tcp://private-redis-agent-staging-do-user-13748639-0.b.db.ondigitalocean.com:25061, database=1
809:15:03.683
< 24ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: AUTH
909:15:03.697
< 13ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
1009:15:03.699
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
1109:15:03.701
< 1ms >
infoyii\web\Session::openSession started
1209:15:03.701
< 0ms >
traceyii\web\Application::handleRequestRoute requested: 'promotion/index'
1309:15:03.702
< 0ms >
traceyii\base\Controller::runActionRoute to run: promotion/index
1409:15:03.702
< 0ms >
traceyii\redis\Connection::openOpening redis DB connection: tcp://private-redis-agent-staging-do-user-13748639-0.b.db.ondigitalocean.com:25061, database=0
1509:15:03.721
< 19ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: AUTH
1609:15:03.725
< 4ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
1709:15:03.726
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
1809:15:03.727
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
1909:15:03.728
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2009:15:03.729
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2109:15:03.730
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2209:15:03.731
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2309:15:03.731
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2409:15:03.739
< 8ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2509:15:03.741
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2609:15:03.741
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2709:15:03.742
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2809:15:03.745
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2909:15:03.746
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3009:15:03.750
< 4ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3109:15:03.751
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3209:15:03.752
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3309:15:03.753
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3409:15:03.754
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3509:15:03.756
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3609:15:03.757
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3709:15:03.759
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3809:15:03.760
< 0ms >
traceyii\base\InlineAction::runWithParamsRunning action: app\controllers\PromotionController::actionIndex()
3909:15:03.760
< 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
4009:15:03.805
< 45ms >
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;
4109:15:03.825
< 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='promotion' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum
4209:15:03.834
< 9ms >
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;
4309:15:03.845
< 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
4409:15:03.852
< 7ms >
traceyii\base\View::renderFileRendering view file: /var/www/member-area/views/promotion/index.php
4509:15:03.854
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4609:15:03.857
< 3ms >
infoyii\db\Command::querySELECT COUNT(*) FROM "promotion" WHERE ("is_deleted"=0) AND ("start_date" <= '2025-06-27') AND ("end_date" >= '2025-06-27') AND ("start_time" <= '09:15') AND ("end_time" >= '09:15') AND ("is_active"=1) AND ("is_deleted"=0)
4709:15:03.864
< 6ms >
infoyii\db\Command::querySELECT * FROM "promotion" WHERE ("is_deleted"=0) AND ("start_date" <= '2025-06-27') AND ("end_date" >= '2025-06-27') AND ("start_time" <= '09:15') AND ("end_time" >= '09:15') AND ("is_active"=1) AND ("is_deleted"=0) ORDER BY "index", "current_join_count" DESC LIMIT 20
4809:15:03.868
< 4ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4909:15:03.870
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5009:15:03.872
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5109:15:03.873
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5209:15:03.874
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5309:15:03.875
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5409:15:03.876
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5509:15:03.877
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5609:15:03.878
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5709:15:03.879
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5809:15:03.880
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5909:15:03.881
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6009:15:03.882
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6109:15:03.883
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6209:15:03.884
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6309:15:03.885
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6409:15:03.885
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6509:15:03.886
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6609:15:03.888
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6709:15:03.889
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6809:15:03.890
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6909:15:03.891
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7009:15:03.893
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7109:15:03.894
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7209:15:03.895
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7309:15:03.896
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7409:15:03.897
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7509:15:03.898
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7609:15:03.899
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7709:15:03.900
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7809:15:03.905
< 5ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7909:15:03.907
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8009:15:03.909
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8109:15:03.910
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8209:15:03.911
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8309:15:03.912
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8409:15:03.913
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8509:15:03.915
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8609:15:03.932
< 17ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8709:15:03.948
< 15ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8809:15:03.959
< 11ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8909:15:03.960
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9009:15:03.961
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9109:15:03.962
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9209:15:03.966
< 3ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9309:15:03.967
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9409:15:03.968
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9509:15:03.969
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9609:15:03.970
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9709:15:03.971
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9809:15:03.972
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9909:15:03.972
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10009:15:03.979
< 6ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10109:15:03.981
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10209:15:03.982
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10309:15:03.987
< 5ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10409:15:03.989
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10509:15:03.990
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10609:15:03.991
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10709:15:03.992
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10809:15:03.993
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10909:15:04.007
< 14ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11009:15:04.009
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11109:15:04.010
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11209:15:04.011
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11309:15:04.015
< 4ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11409:15:04.017
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11509:15:04.019
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11609:15:04.019
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11709:15:04.021
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11809:15:04.032
< 11ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11909:15:04.033
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12009:15:04.034
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12109:15:04.035
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12209:15:04.057
< 21ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12309:15:04.058
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12409:15:04.060
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12509:15:04.061
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12609:15:04.062
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12709:15:04.063
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12809:15:04.064
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12909:15:04.065
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13009:15:04.066
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13109:15:04.067
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13209:15:04.068
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13309:15:04.068
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13409:15:04.069
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13509:15:04.070
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13609:15:04.073
< 3ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13709:15:04.077
< 3ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13809:15:04.079
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13909:15:04.081
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14009:15:04.082
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14109:15:04.089
< 7ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14209:15:04.091
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14309:15:04.092
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14409:15:04.096
< 4ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14509:15:04.097
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14609:15:04.101
< 3ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14709:15:04.103
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14809:15:04.106
< 3ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14909:15:04.107
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15009:15:04.108
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15109:15:04.109
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15209:15:04.110
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15309:15:04.111
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15409:15:04.112
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15509:15:04.113
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15609:15:04.115
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15709:15:04.117
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15809:15:04.119
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15909:15:04.125
< 6ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16009:15:04.129
< 4ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16109:15:04.133
< 3ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16209:15:04.138
< 5ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16309:15:04.139
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16409:15:04.140
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16509:15:04.141
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16609:15:04.145
< 3ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16709:15:04.149
< 3ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16809:15:04.153
< 3ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16909:15:04.154
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17009:15:04.155
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17109:15:04.157
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17209:15:04.161
< 3ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17309:15:04.164
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17409:15:04.175
< 11ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17509:15:04.177
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17609:15:04.179
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17709:15:04.180
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17809:15:04.182
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17909:15:04.188
< 6ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18009:15:04.200
< 11ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18109:15:04.211
< 11ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18209:15:04.214
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18309:15:04.216
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18409:15:04.217
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18509:15:04.218
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18609:15:04.220
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18709:15:04.221
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18809:15:04.223
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18909:15:04.225
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19009:15:04.227
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19109:15:04.228
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19209:15:04.229
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19309:15:04.230
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19409:15:04.231
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19509:15:04.232
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19609:15:04.233
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19709:15:04.234
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19809:15:04.236
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19909:15:04.241
< 5ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20009:15:04.243
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20109:15:04.244
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20209:15:04.245
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20309:15:04.246
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20409:15:04.248
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20509:15:04.249
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20609:15:04.254
< 4ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20709:15:04.255
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20809:15:04.256
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20909:15:04.269
< 12ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21009:15:04.271
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21109:15:04.273
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21209:15:04.278
< 4ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21309:15:04.284
< 6ms >
infoyii\db\Command::querySELECT COUNT(*) FROM "promotion_ongoing" WHERE ("join_date" >= '2025-06-20 00:00:00') AND ("join_date" <= '2025-06-27 23:59:59')
21409:15:04.288
< 3ms >
traceyii\base\View::renderFileRendering view file: /var/www/member-area/views/layouts/main.php
21509:15:04.289
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21609:15:04.291
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21709:15:04.291
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21809:15:04.292
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21909:15:04.293
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22009:15:04.301
< 7ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22109:15:04.302
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22209:15:04.304
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22309:15:04.308
< 4ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22409:15:04.320
< 11ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22509:15:04.323
< 3ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22609:15:04.334
< 10ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22709:15:04.341
< 6ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22809:15:04.345
< 3ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22909:15:04.346
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23009:15:04.347
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23109:15:04.350
< 3ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23209:15:04.352
< 1ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='menu_order'
23309:15:04.370
< 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 = 'agent_setting' AND d.nspname = 'public' ORDER BY a.attnum;
23409:15:04.395
< 24ms >
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
23509:15:04.417
< 21ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='language'
23609:15:04.420
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23709:15:04.421
< 1ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='active_qris'
23809:15:04.447
< 25ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23909:15:04.450
< 3ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24009:15:04.533
< 82ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24109:15:04.541
< 8ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24209:15:04.546
< 4ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24309:15:04.547
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24409:15:04.548
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24509:15:04.549
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24609:15:04.550
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24709:15:04.551
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24809:15:04.552
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24909:15:04.552
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25009:15:04.553
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25109:15:04.554
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25209:15:04.564
< 9ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25309:15:04.575
< 11ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25409:15:04.581
< 5ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25509:15:04.582
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25609:15:04.583
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25709:15:04.583
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25809:15:04.584
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25909:15:04.585
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26009:15:04.585
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26109:15:04.586
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26209:15:04.587
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26309:15:04.587
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26409:15:04.588
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26509:15:04.589
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26609:15:04.589
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26709:15:04.590
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: HGET
26809:15:04.591
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26909:15:04.592
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
27009:15:04.607
< 15ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SET