Career Solutions

Application Log
Timestamp Level Category Message
15:48:21.184356 trace system.CModule
Loading "log" application component
in /var/www/html/careerbd/index.php (15)
15:48:21.184514 trace system.CModule
Loading "request" application component
in /var/www/html/careerbd/index.php (15)
15:48:21.184622 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:48:21.185158 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:48:21.185343 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:48:21.185369 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:48:21.185424 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:48:21.186044 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:48:21.186667 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:48:21.186841 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:48:21.187062 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:48:21.187134 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:48:21.187249 trace system.db.CDbCommand
Executing SQL: DELETE FROM `yii_sessions` WHERE expire<:expire. Bound with
:expire=1532339301
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:48:21.187525 trace system.db.CDbCommand
Querying SQL: SELECT `data`
FROM `yii_sessions`
WHERE expire>:expire AND id=:id. Bound with :expire=1532339301,
:id='pbiihtstdpkrd5utu16qsqap11'
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:48:21.187728 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:48:21.187876 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:48:21.187957 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:48:21.188443 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:48:21.188771 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:48:21.189276 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:48:21.189543 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:48:21.189878 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:48:21.189995 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:48:21.190133 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:48:21.226893 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:48:21.227149 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 84
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:48:21.247245 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:48:21.247380 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:48:21.247735 trace system.CModule
Loading "easyImage" application component
in /var/www/html/careerbd/protected/views/preferable/_view.php (26)
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
15:48:21.324116 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:48:21.324990 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:48:21.325050 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:48:21.325896 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:48:21.326147 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:48:21.326787 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:48:21.326833 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)