Career Solutions

Application Log
Timestamp Level Category Message
20:02:46.061927 trace system.CModule
Loading "log" application component
in /var/www/html/careerbd/index.php (15)
20:02:46.062084 trace system.CModule
Loading "request" application component
in /var/www/html/careerbd/index.php (15)
20:02:46.062200 trace system.CModule
Loading "urlManager" application component
in /var/www/html/careerbd/protected/components/HttpRequest.php (11)
in /var/www/html/careerbd/index.php (15)
20:02:46.062690 trace system.CModule
Loading "themeManager" application component
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
20:02:46.062869 trace system.db.ar.CActiveRecord
Category.findByPk()
in /var/www/html/careerbd/protected/views/preferable/view.php (13)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
20:02:46.062895 trace system.CModule
Loading "db" application component
in /var/www/html/careerbd/protected/views/preferable/view.php (13)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
20:02:46.062947 trace system.db.CDbConnection
Opening DB connection
in /var/www/html/careerbd/protected/views/preferable/view.php (13)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
20:02:46.063568 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_category`
in /var/www/html/careerbd/protected/views/preferable/view.php (13)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
20:02:46.064104 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_category`
in /var/www/html/careerbd/protected/views/preferable/view.php (13)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
20:02:46.064275 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `jb_category` `t` WHERE `t`.`id`=11 LIMIT 1
in /var/www/html/careerbd/protected/views/preferable/view.php (13)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
20:02:46.064505 trace system.CModule
Loading "user" application component
in /var/www/html/careerbd/protected/views/preferable/view.php (15)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
20:02:46.064563 trace system.CModule
Loading "session" application component
in /var/www/html/careerbd/protected/views/preferable/view.php (15)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
20:02:46.064675 trace system.db.CDbCommand
Executing SQL: DELETE FROM `yii_sessions` WHERE expire<:expire. Bound with
:expire=1529416966
in /var/www/html/careerbd/protected/views/preferable/view.php (15)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
20:02:46.064969 trace system.db.CDbCommand
Querying SQL: SELECT `data`
FROM `yii_sessions`
WHERE expire>:expire AND id=:id. Bound with :expire=1529416966,
:id='k0v5hc0rrevutt4dn2s83se4o6'
in /var/www/html/careerbd/protected/views/preferable/view.php (15)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
20:02:46.065172 trace system.CModule
Loading "widgetFactory" application component
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
20:02:46.065311 trace system.db.ar.CActiveRecord
JobAgent.count()
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
20:02:46.065392 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_job_agent`
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
20:02:46.065887 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_job_agent`
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
20:02:46.066207 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_jobseeker`
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
20:02:46.066711 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_jobseeker`
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
20:02:46.066971 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_jobseeker_seeting`
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
20:02:46.067320 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_jobseeker_seeting`
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
20:02:46.067435 trace system.db.ar.CActiveRecord
JobAgent.count() eagerly
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
20:02:46.067562 trace system.db.CDbCommand
Querying SQL: SELECT COUNT(*) FROM (SELECT DISTINCT `t`.`id` AS `t0_c0`,
`t`.`jobseeker_id` AS `t0_c1`, `t`.`agent_name` AS `t0_c2`,
`t`.`agent_desc` AS `t0_c3`, `t`.`keyword` AS `t0_c4`, `t`.`category_id` AS
`t0_c5`, `t`.`position_level` AS `t0_c6`, `t`.`employment_type` AS `t0_c7`,
`t`.`salary_min` AS `t0_c8`, `t`.`salary_max` AS `t0_c9`,
`t`.`is_apply_online` AS `t0_c10`, `t`.`is_apply_by_email` AS `t0_c11`,
`t`.`is_apply_hardcopy` AS `t0_c12`, `jobseeker`.`id` AS `t1_c0`,
`jobseeker`.`primary_email` AS `t1_c1`, `jobseeker`.`password` AS `t1_c2`,
`jobseeker`.`first_name` AS `t1_c3`, `jobseeker`.`last_name` AS `t1_c4`,
`jobseeker`.`student_id` AS `t1_c5`, `jobseeker`.`faculty` AS `t1_c6`,
`jobseeker`.`father_name` AS `t1_c7`, `jobseeker`.`mother_name` AS `t1_c8`,
`jobseeker`.`date_of_birth` AS `t1_c9`, `jobseeker`.`gender` AS `t1_c10`,
`jobseeker`.`marital_status` AS `t1_c11`, `jobseeker`.`photo_upload_date`
AS `t1_c12`, `jobseeker`.`photopath` AS `t1_c13`, `jobseeker`.`status` AS
`t1_c14`, `jobseeker`.`token` AS `t1_c15`, `jobseeker`.`create_date` AS
`t1_c16`, `setting`.`id` AS `t2_c0`, `setting`.`jobseeker_id` AS `t2_c1`,
`setting`.`privacy` AS `t2_c2` FROM `jb_job_agent` `t`  LEFT OUTER JOIN
`jb_jobseeker` `jobseeker` ON (`t`.`jobseeker_id`=`jobseeker`.`id`)  LEFT
OUTER JOIN `jb_jobseeker_seeting` `setting` ON
(`setting`.`jobseeker_id`=`jobseeker`.`id`)  WHERE (jobseeker.status=1 AND
setting.privacy=1 AND category_id =11 ) GROUP BY t.jobseeker_id) sq
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
20:02:46.089389 trace system.db.ar.CActiveRecord
JobAgent.findAll()
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
20:02:46.089629 trace system.db.CDbCommand
Querying SQL: SELECT DISTINCT `t`.`id` AS `t0_c0`, `t`.`jobseeker_id` AS
`t0_c1`, `t`.`agent_name` AS `t0_c2`, `t`.`agent_desc` AS `t0_c3`,
`t`.`keyword` AS `t0_c4`, `t`.`category_id` AS `t0_c5`,
`t`.`position_level` AS `t0_c6`, `t`.`employment_type` AS `t0_c7`,
`t`.`salary_min` AS `t0_c8`, `t`.`salary_max` AS `t0_c9`,
`t`.`is_apply_online` AS `t0_c10`, `t`.`is_apply_by_email` AS `t0_c11`,
`t`.`is_apply_hardcopy` AS `t0_c12`, `jobseeker`.`id` AS `t1_c0`,
`jobseeker`.`primary_email` AS `t1_c1`, `jobseeker`.`password` AS `t1_c2`,
`jobseeker`.`first_name` AS `t1_c3`, `jobseeker`.`last_name` AS `t1_c4`,
`jobseeker`.`student_id` AS `t1_c5`, `jobseeker`.`faculty` AS `t1_c6`,
`jobseeker`.`father_name` AS `t1_c7`, `jobseeker`.`mother_name` AS `t1_c8`,
`jobseeker`.`date_of_birth` AS `t1_c9`, `jobseeker`.`gender` AS `t1_c10`,
`jobseeker`.`marital_status` AS `t1_c11`, `jobseeker`.`photo_upload_date`
AS `t1_c12`, `jobseeker`.`photopath` AS `t1_c13`, `jobseeker`.`status` AS
`t1_c14`, `jobseeker`.`token` AS `t1_c15`, `jobseeker`.`create_date` AS
`t1_c16`, `setting`.`id` AS `t2_c0`, `setting`.`jobseeker_id` AS `t2_c1`,
`setting`.`privacy` AS `t2_c2` FROM `jb_job_agent` `t`  LEFT OUTER JOIN
`jb_jobseeker` `jobseeker` ON (`t`.`jobseeker_id`=`jobseeker`.`id`)  LEFT
OUTER JOIN `jb_jobseeker_seeting` `setting` ON
(`setting`.`jobseeker_id`=`jobseeker`.`id`)  WHERE (jobseeker.status=1 AND
setting.privacy=1 AND category_id =11 ) GROUP BY t.jobseeker_id LIMIT 12
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
20:02:46.100303 trace system.CModule
Loading "assetManager" application component
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
20:02:46.100430 trace system.CModule
Loading "clientScript" application component
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
20:02:46.100701 trace system.CModule
Loading "easyImage" application component
in /var/www/html/careerbd/protected/views/preferable/_view.php (16)
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
20:02:46.101414 trace system.CModule
Loading "coreMessages" application component
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
20:02:46.102250 trace system.db.ar.CActiveRecord
JbTraining.findAll()
in /var/www/html/careerbd/themes/eusiajb/views/layouts/tpl_footer.php (138)
in /var/www/html/careerbd/themes/abound/views/layouts/tpl_footer.php (58)
in /var/www/html/careerbd/themes/abound/views/layouts/main.php (194)
20:02:46.102304 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_training`
in /var/www/html/careerbd/themes/eusiajb/views/layouts/tpl_footer.php (138)
in /var/www/html/careerbd/themes/abound/views/layouts/tpl_footer.php (58)
in /var/www/html/careerbd/themes/abound/views/layouts/main.php (194)
20:02:46.103072 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_training`
in /var/www/html/careerbd/themes/eusiajb/views/layouts/tpl_footer.php (138)
in /var/www/html/careerbd/themes/abound/views/layouts/tpl_footer.php (58)
in /var/www/html/careerbd/themes/abound/views/layouts/main.php (194)
20:02:46.103265 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `jb_training` `t` WHERE published=1 AND
feature_training=0 ORDER BY id DESC LIMIT 5
in /var/www/html/careerbd/themes/eusiajb/views/layouts/tpl_footer.php (138)
in /var/www/html/careerbd/themes/abound/views/layouts/tpl_footer.php (58)
in /var/www/html/careerbd/themes/abound/views/layouts/main.php (194)
20:02:46.103854 trace system.db.ar.CActiveRecord
JbTraining.findAll()
in /var/www/html/careerbd/themes/eusiajb/views/layouts/tpl_footer.php (157)
in /var/www/html/careerbd/themes/abound/views/layouts/tpl_footer.php (58)
in /var/www/html/careerbd/themes/abound/views/layouts/main.php (194)
20:02:46.103899 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `jb_training` `t` WHERE published=1 AND
feature_training=1 ORDER BY id DESC LIMIT 5
in /var/www/html/careerbd/themes/eusiajb/views/layouts/tpl_footer.php (157)
in /var/www/html/careerbd/themes/abound/views/layouts/tpl_footer.php (58)
in /var/www/html/careerbd/themes/abound/views/layouts/main.php (194)