Career Solutions

Application Log
Timestamp Level Category Message
15:47:43.710017 trace system.CModule
Loading "log" application component
in /var/www/html/careerbd/index.php (15)
15:47:43.710191 trace system.CModule
Loading "request" application component
in /var/www/html/careerbd/index.php (15)
15:47:43.710298 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)
15:47:43.710778 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)
15:47:43.710956 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)
15:47:43.710982 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)
15:47:43.711034 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)
15:47:43.711582 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)
15:47:43.712174 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)
15:47:43.712347 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `jb_category` `t` WHERE `t`.`id`=12 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)
15:47:43.712575 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)
15:47:43.712637 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)
15:47:43.712750 trace system.db.CDbCommand
Executing SQL: DELETE FROM `yii_sessions` WHERE expire<:expire. Bound with
:expire=1532339263
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)
15:47:43.713010 trace system.db.CDbCommand
Querying SQL: SELECT `data`
FROM `yii_sessions`
WHERE expire>:expire AND id=:id. Bound with :expire=1532339263,
:id='jelll3up68hnocilutj73ooq12'
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)
15:47:43.713216 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)
15:47:43.713356 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)
15:47:43.713435 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)
15:47:43.713982 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)
15:47:43.714318 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)
15:47:43.714871 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)
15:47:43.715156 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)
15:47:43.715498 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)
15:47:43.715617 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)
15:47:43.715745 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 =12 ) 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)
15:47:43.752394 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)
15:47:43.752645 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 =12 ) GROUP BY t.jobseeker_id LIMIT 12
OFFSET 108
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)
15:47:43.772684 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)
15:47:43.772819 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)
15:47:43.773102 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)
15:47:43.773773 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)
15:47:43.774612 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)
15:47:43.774672 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)
15:47:43.775473 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)
15:47:43.775665 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)
15:47:43.776556 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)
15:47:43.776599 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)