Career Solutions

Application Log
Timestamp Level Category Message
19:55:02.430607 trace system.CModule
Loading "log" application component
in /var/www/html/careerbd/index.php (15)
19:55:02.430764 trace system.CModule
Loading "request" application component
in /var/www/html/careerbd/index.php (15)
19:55:02.430871 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)
19:55:02.431369 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)
19:55:02.431548 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)
19:55:02.431574 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)
19:55:02.431628 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)
19:55:02.432264 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)
19:55:02.432874 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)
19:55:02.433048 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `jb_category` `t` WHERE `t`.`id`=8 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)
19:55:02.433270 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)
19:55:02.433331 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)
19:55:02.433445 trace system.db.CDbCommand
Executing SQL: DELETE FROM `yii_sessions` WHERE expire<:expire. Bound with
:expire=1529416502
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)
19:55:02.433723 trace system.db.CDbCommand
Querying SQL: SELECT `data`
FROM `yii_sessions`
WHERE expire>:expire AND id=:id. Bound with :expire=1529416502,
:id='9ubn5b4gfod4he6rfc9b2enil7'
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)
19:55:02.433927 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)
19:55:02.434063 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)
19:55:02.434151 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)
19:55:02.434695 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)
19:55:02.435029 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)
19:55:02.435589 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)
19:55:02.435870 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)
19:55:02.436224 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)
19:55:02.436346 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)
19:55:02.436472 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 =8 ) 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)
19:55:02.450077 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)
19:55:02.450294 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 =8 ) 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)
19:55:02.459614 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)
19:55:02.459734 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)
19:55:02.460000 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)
19:55:02.460685 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)
19:55:02.461512 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)
19:55:02.461566 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)
19:55:02.462352 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)
19:55:02.462528 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)
19:55:02.463121 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)
19:55:02.463165 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)