389742   Resumes       Post free Jobs

Set Goal Upper, Step Ahead, Achieve Dream

A better career is out there. We'll help you to find it. We're your first step to becoming everything you want to be
Select Your Category


Connect with Professional

The professional surrounded by you, connect with them for your career enhancement.

Featured Jobs

Daffodil Institiute of IT

Student Counselor

Show More
Application Log
Timestamp Level Category Message
19:47:08.940506 trace system.CModule
Loading "log" application component
in /var/www/html/careerbd/index.php (15)
19:47:08.940665 trace system.CModule
Loading "request" application component
in /var/www/html/careerbd/index.php (15)
19:47:08.940771 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:47:08.941152 trace system.CModule
Loading "db" application component
in /var/www/html/careerbd/protected/controllers/JbController.php (78)
in /var/www/html/careerbd/index.php (15)
19:47:08.941201 trace system.db.CDbConnection
Opening DB connection
in /var/www/html/careerbd/protected/controllers/JbController.php (78)
in /var/www/html/careerbd/index.php (15)
19:47:08.941740 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_jobs`
in /var/www/html/careerbd/protected/controllers/JbController.php (78)
in /var/www/html/careerbd/index.php (15)
19:47:08.942801 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_jobs`
in /var/www/html/careerbd/protected/controllers/JbController.php (78)
in /var/www/html/careerbd/index.php (15)
19:47:08.943172 trace system.db.ar.CActiveRecord
Jobs.findAll()
in /var/www/html/careerbd/protected/models/Jobs.php (628)
in /var/www/html/careerbd/protected/controllers/JbController.php (80)
in /var/www/html/careerbd/index.php (15)
19:47:08.943283 trace system.db.CDbCommand
Querying SQL: SELECT id, position_title, employer_id FROM `jb_jobs` `t`
WHERE ((status=:ycp0) AND (job_posting_type=:ycp1)) AND (job_deadline>=
CURDATE()) GROUP BY employer_id ORDER BY job_publish_date DESC. Bound with
:ycp0=1, :ycp1=2
in /var/www/html/careerbd/protected/models/Jobs.php (628)
in /var/www/html/careerbd/protected/controllers/JbController.php (80)
in /var/www/html/careerbd/index.php (15)
19:47:08.979274 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_districts`
in /var/www/html/careerbd/protected/controllers/JbController.php (85)
in /var/www/html/careerbd/index.php (15)
19:47:08.979877 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_districts`
in /var/www/html/careerbd/protected/controllers/JbController.php (85)
in /var/www/html/careerbd/index.php (15)
19:47:08.980063 trace system.db.ar.CActiveRecord
Districts.findAll()
in /var/www/html/careerbd/protected/controllers/JbController.php (86)
in /var/www/html/careerbd/index.php (15)
19:47:08.980114 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `jb_districts` `t`
in /var/www/html/careerbd/protected/controllers/JbController.php (86)
in /var/www/html/careerbd/index.php (15)
19:47:08.982680 trace system.db.ar.CActiveRecord
ProfessionalZone.findAll()
in /var/www/html/careerbd/protected/controllers/JbController.php (95)
in /var/www/html/careerbd/index.php (15)
19:47:08.982721 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_professional_zone`
in /var/www/html/careerbd/protected/controllers/JbController.php (95)
in /var/www/html/careerbd/index.php (15)
19:47:08.983834 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_professional_zone`
in /var/www/html/careerbd/protected/controllers/JbController.php (95)
in /var/www/html/careerbd/index.php (15)
19:47:08.984015 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `jb_professional_zone` `t` WHERE
deadline>=DATE(NOW()) AND pzstatus = 1  ORDER BY id DESC
in /var/www/html/careerbd/protected/controllers/JbController.php (95)
in /var/www/html/careerbd/index.php (15)
19:47:08.985081 trace system.db.ar.CActiveRecord
Jobs.findAll()
in /var/www/html/careerbd/protected/models/Jobs.php (508)
in /var/www/html/careerbd/protected/controllers/JbController.php (97)
in /var/www/html/careerbd/index.php (15)
19:47:08.985282 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_category`
in /var/www/html/careerbd/protected/models/Jobs.php (508)
in /var/www/html/careerbd/protected/controllers/JbController.php (97)
in /var/www/html/careerbd/index.php (15)
19:47:08.985636 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_category`
in /var/www/html/careerbd/protected/models/Jobs.php (508)
in /var/www/html/careerbd/protected/controllers/JbController.php (97)
in /var/www/html/careerbd/index.php (15)
19:47:08.985851 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`category_id_1` AS `t0_c4`, COUNT(category_id_1)
as gvalue, `t`.`id` AS `t0_c0`, `categoryId1`.`id` AS `t1_c0`,
`categoryId1`.`name` AS `t1_c1`, `categoryId1`.`status` AS `t1_c2` FROM
`jb_jobs` `t`  LEFT OUTER JOIN `jb_category` `categoryId1` ON
(`t`.`category_id_1`=`categoryId1`.`id`)  WHERE (t.status=:status AND
categoryId1.status=:status1 AND job_deadline>=CURDATE()) GROUP BY
category_id_1. Bound with :status=1, :status1=1
in /var/www/html/careerbd/protected/models/Jobs.php (508)
in /var/www/html/careerbd/protected/controllers/JbController.php (97)
in /var/www/html/careerbd/index.php (15)
19:47:09.621186 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_top_university`
in /var/www/html/careerbd/protected/controllers/JbController.php (100)
in /var/www/html/careerbd/index.php (15)
19:47:09.621912 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_top_university`
in /var/www/html/careerbd/protected/controllers/JbController.php (100)
in /var/www/html/careerbd/index.php (15)
19:47:09.622045 trace system.db.ar.CActiveRecord
TopUniversity.findAll()
in /var/www/html/careerbd/protected/models/TopUniversity.php (112)
in /var/www/html/careerbd/protected/controllers/JbController.php (101)
in /var/www/html/careerbd/index.php (15)
19:47:09.622112 trace system.db.CDbCommand
Querying SQL: SELECT university_name, image_path,url_link,status FROM
`jb_top_university` `t` WHERE status=:ycp2. Bound with :ycp2=1
in /var/www/html/careerbd/protected/models/TopUniversity.php (112)
in /var/www/html/careerbd/protected/controllers/JbController.php (101)
in /var/www/html/careerbd/index.php (15)
19:47:09.622535 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_top_employer`
in /var/www/html/careerbd/protected/controllers/JbController.php (104)
in /var/www/html/careerbd/index.php (15)
19:47:09.622993 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_top_employer`
in /var/www/html/careerbd/protected/controllers/JbController.php (104)
in /var/www/html/careerbd/index.php (15)
19:47:09.623116 trace system.db.ar.CActiveRecord
TopEmployer.findAll()
in /var/www/html/careerbd/protected/models/TopEmployer.php (112)
in /var/www/html/careerbd/protected/controllers/JbController.php (105)
in /var/www/html/careerbd/index.php (15)
19:47:09.623163 trace system.db.CDbCommand
Querying SQL: SELECT employer_name, image_path,url_link,status FROM
`jb_top_employer` `t` WHERE status=:ycp3. Bound with :ycp3=1
in /var/www/html/careerbd/protected/models/TopEmployer.php (112)
in /var/www/html/careerbd/protected/controllers/JbController.php (105)
in /var/www/html/careerbd/index.php (15)
19:47:09.623516 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_banner_ads`
in /var/www/html/careerbd/protected/controllers/JbController.php (108)
in /var/www/html/careerbd/index.php (15)
19:47:09.624017 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_banner_ads`
in /var/www/html/careerbd/protected/controllers/JbController.php (108)
in /var/www/html/careerbd/index.php (15)
19:47:09.624139 trace system.db.ar.CActiveRecord
BannerAds.findAll()
in /var/www/html/careerbd/protected/models/BannerAds.php (114)
in /var/www/html/careerbd/protected/controllers/JbController.php (109)
in /var/www/html/careerbd/index.php (15)
19:47:09.624186 trace system.db.CDbCommand
Querying SQL: SELECT banner_title, image_path,url_link,page,position,status
FROM `jb_banner_ads` `t` WHERE status=:ycp4. Bound with :ycp4=1
in /var/www/html/careerbd/protected/models/BannerAds.php (114)
in /var/www/html/careerbd/protected/controllers/JbController.php (109)
in /var/www/html/careerbd/index.php (15)
19:47:09.624535 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_solution`
in /var/www/html/careerbd/protected/controllers/JbController.php (112)
in /var/www/html/careerbd/index.php (15)
19:47:09.624977 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_solution`
in /var/www/html/careerbd/protected/controllers/JbController.php (112)
in /var/www/html/careerbd/index.php (15)
19:47:09.625097 trace system.db.ar.CActiveRecord
Solution.findAll()
in /var/www/html/careerbd/protected/models/Solution.php (107)
in /var/www/html/careerbd/protected/controllers/JbController.php (113)
in /var/www/html/careerbd/index.php (15)
19:47:09.625144 trace system.db.CDbCommand
Querying SQL: SELECT solution_title,image_path,url_link,status FROM
`jb_solution` `t` WHERE status=:ycp5. Bound with :ycp5=1
in /var/www/html/careerbd/protected/models/Solution.php (107)
in /var/www/html/careerbd/protected/controllers/JbController.php (113)
in /var/www/html/careerbd/index.php (15)
19:47:09.625389 trace system.CModule
Loading "themeManager" application component
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:09.625566 trace system.CModule
Loading "clientScript" application component
in /var/www/html/careerbd/protected/views/jb/home.php (150)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:09.625685 trace system.CModule
Loading "session" application component
in /var/www/html/careerbd/protected/views/jb/home.php (273)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:09.625997 trace system.db.CDbCommand
Executing SQL: DELETE FROM `yii_sessions` WHERE expire<:expire. Bound with
:expire=1529416029
in /var/www/html/careerbd/protected/views/jb/home.php (273)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:09.635267 trace system.db.CDbCommand
Querying SQL: SELECT `data`
FROM `yii_sessions`
WHERE expire>:expire AND id=:id. Bound with :expire=1529416029,
:id='69bh0jf1o7t978n1pr65tvus07'
in /var/www/html/careerbd/protected/views/jb/home.php (273)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:09.635485 trace system.db.ar.CActiveRecord
Jobs.findAll()
in /var/www/html/careerbd/protected/views/jb/home.php (299)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:09.635529 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `jb_jobs` `t` WHERE job_deadline>=DATE(NOW())
AND status = 1
in /var/www/html/careerbd/protected/views/jb/home.php (299)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:10.044637 trace system.db.ar.CActiveRecord
Jobseeker.count()
in /var/www/html/careerbd/protected/views/jb/home.php (303)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:10.044701 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_jobseeker`
in /var/www/html/careerbd/protected/views/jb/home.php (303)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:10.045476 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_jobseeker`
in /var/www/html/careerbd/protected/views/jb/home.php (303)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:10.045665 trace system.db.CDbCommand
Querying SQL: SELECT COUNT(*) FROM `jb_jobseeker` `t`
in /var/www/html/careerbd/protected/views/jb/home.php (303)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:10.082427 trace system.db.ar.CActiveRecord
ResumeValue.findByPk()
in /var/www/html/careerbd/protected/views/jb/home.php (304)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:10.082488 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `resume_value`
in /var/www/html/careerbd/protected/views/jb/home.php (304)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:10.083123 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `resume_value`
in /var/www/html/careerbd/protected/views/jb/home.php (304)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:10.083280 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `resume_value` `t` WHERE `t`.`id`=1 LIMIT 1
in /var/www/html/careerbd/protected/views/jb/home.php (304)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:10.083539 trace system.CModule
Loading "widgetFactory" application component
in /var/www/html/careerbd/protected/views/jb/home.php (355)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:10.083813 trace system.CModule
Loading "assetManager" application component
in /var/www/html/careerbd/protected/views/jb/home.php (401)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:10.084033 trace system.db.ar.CActiveRecord
Divisions.findAllByAttributes()
in /var/www/html/careerbd/protected/views/jb/home.php (425)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:10.084079 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_divisions`
in /var/www/html/careerbd/protected/views/jb/home.php (425)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:10.084423 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_divisions`
in /var/www/html/careerbd/protected/views/jb/home.php (425)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:10.084619 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `jb_divisions` `t` WHERE `t`.`country_id`=:yp0.
Bound with :yp0=19
in /var/www/html/careerbd/protected/views/jb/home.php (425)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:10.084937 trace system.db.ar.CActiveRecord
Divisions.findAll()
in /var/www/html/careerbd/protected/views/jb/home.php (469)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:10.084974 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `jb_divisions` `t` WHERE country_id="19" ORDER
BY name
in /var/www/html/careerbd/protected/views/jb/home.php (469)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:10.085262 trace system.db.ar.CActiveRecord
lazy loading Divisions.countdiv
in /var/www/html/careerbd/protected/views/jb/home.php (475)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:10.085382 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`location_division` AS `c`, COUNT(*) AS `s` FROM
`jb_jobs` `t` WHERE (t.job_deadline>=DATE(NOW()) AND t.status = 1) AND
(`t`.`location_division`='6') GROUP BY `t`.`location_division`
in /var/www/html/careerbd/protected/views/jb/home.php (475)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:10.276335 trace system.db.ar.CActiveRecord
lazy loading Divisions.countdiv
in /var/www/html/careerbd/protected/views/jb/home.php (475)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:10.276483 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`location_division` AS `c`, COUNT(*) AS `s` FROM
`jb_jobs` `t` WHERE (t.job_deadline>=DATE(NOW()) AND t.status = 1) AND
(`t`.`location_division`='2') GROUP BY `t`.`location_division`
in /var/www/html/careerbd/protected/views/jb/home.php (475)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:10.485868 trace system.db.ar.CActiveRecord
lazy loading Divisions.countdiv
in /var/www/html/careerbd/protected/views/jb/home.php (475)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:10.486018 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`location_division` AS `c`, COUNT(*) AS `s` FROM
`jb_jobs` `t` WHERE (t.job_deadline>=DATE(NOW()) AND t.status = 1) AND
(`t`.`location_division`='1') GROUP BY `t`.`location_division`
in /var/www/html/careerbd/protected/views/jb/home.php (475)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:10.675476 trace system.db.ar.CActiveRecord
lazy loading Divisions.countdiv
in /var/www/html/careerbd/protected/views/jb/home.php (475)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:10.675623 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`location_division` AS `c`, COUNT(*) AS `s` FROM
`jb_jobs` `t` WHERE (t.job_deadline>=DATE(NOW()) AND t.status = 1) AND
(`t`.`location_division`='4') GROUP BY `t`.`location_division`
in /var/www/html/careerbd/protected/views/jb/home.php (475)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:10.865094 trace system.db.ar.CActiveRecord
lazy loading Divisions.countdiv
in /var/www/html/careerbd/protected/views/jb/home.php (475)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:10.865243 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`location_division` AS `c`, COUNT(*) AS `s` FROM
`jb_jobs` `t` WHERE (t.job_deadline>=DATE(NOW()) AND t.status = 1) AND
(`t`.`location_division`='11') GROUP BY `t`.`location_division`
in /var/www/html/careerbd/protected/views/jb/home.php (475)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:11.055001 trace system.db.ar.CActiveRecord
lazy loading Divisions.countdiv
in /var/www/html/careerbd/protected/views/jb/home.php (475)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:11.055162 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`location_division` AS `c`, COUNT(*) AS `s` FROM
`jb_jobs` `t` WHERE (t.job_deadline>=DATE(NOW()) AND t.status = 1) AND
(`t`.`location_division`='3') GROUP BY `t`.`location_division`
in /var/www/html/careerbd/protected/views/jb/home.php (475)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:11.244740 trace system.db.ar.CActiveRecord
lazy loading Divisions.countdiv
in /var/www/html/careerbd/protected/views/jb/home.php (475)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:11.244889 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`location_division` AS `c`, COUNT(*) AS `s` FROM
`jb_jobs` `t` WHERE (t.job_deadline>=DATE(NOW()) AND t.status = 1) AND
(`t`.`location_division`='7') GROUP BY `t`.`location_division`
in /var/www/html/careerbd/protected/views/jb/home.php (475)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:11.434125 trace system.db.ar.CActiveRecord
lazy loading Divisions.countdiv
in /var/www/html/careerbd/protected/views/jb/home.php (475)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:11.434278 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`location_division` AS `c`, COUNT(*) AS `s` FROM
`jb_jobs` `t` WHERE (t.job_deadline>=DATE(NOW()) AND t.status = 1) AND
(`t`.`location_division`='5') GROUP BY `t`.`location_division`
in /var/www/html/careerbd/protected/views/jb/home.php (475)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:11.623627 trace system.db.CDbCommand
Querying SQL: SELECT jb_category.id,COUNT(jb_jobs.category_id_1) as
COUNTJOB, jb_category.name,
                jb_category.status, jb_jobs.job_deadline, jb_jobs.status
FROM `jb_category`
JOIN `jb_jobs` ON jb_category.id=jb_jobs.category_id_1
WHERE jb_jobs.status=:status AND jb_jobs.job_deadline >= CURDATE()
GROUP BY `jb_jobs`.`category_id_1`
ORDER BY `COUNTJOB` DESC LIMIT 16. Bound with :status=1
in /var/www/html/careerbd/protected/views/jb/home.php (520)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:11.807492 trace system.db.CDbCommand
Querying SQL: SELECT jb_category.id, COUNT(jb_job_agent.category_id) as
COUNTCAT, jb_category.name, jb_job_agent.category_id,
                jb_category.status, jb_jobseeker.status
FROM `jb_job_agent`
JOIN `jb_category` ON jb_job_agent.category_id=jb_category.id
JOIN `jb_jobseeker` ON jb_job_agent.jobseeker_id = jb_jobseeker.id
JOIN `jb_jobseeker_seeting` ON jb_jobseeker.id =
jb_jobseeker_seeting.jobseeker_id
WHERE jb_category.status=:status AND jb_jobseeker.status= 1 AND
jb_jobseeker_seeting.privacy=1
GROUP BY `jb_job_agent`.`category_id`
HAVING COUNTCAT > 0 
ORDER BY `COUNTCAT` DESC. Bound with :status=1
in /var/www/html/careerbd/protected/views/jb/home.php (594)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:11.895308 trace system.db.ar.CActiveRecord
Jobs.findAll()
in /var/www/html/careerbd/protected/views/jb/home.php (734)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:11.895395 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `jb_jobs` `t` WHERE employer_id=:employer_id
AND status=:status AND job_posting_type=:job_posting_type AND
job_deadline>=:job_deadline ORDER BY job_publish_date DESC. Bound with
:employer_id='18165', :status='1', :job_posting_type='2',
:job_deadline='2018-06-19'
in /var/www/html/careerbd/protected/views/jb/home.php (734)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:11.896090 trace system.CModule
Loading "easyImage" application component
in /var/www/html/careerbd/protected/views/jb/home.php (748)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:11.896184 trace system.db.ar.CActiveRecord
lazy loading Jobs.employer
in /var/www/html/careerbd/protected/views/jb/home.php (748)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:11.896365 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_employer`
in /var/www/html/careerbd/protected/views/jb/home.php (748)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:11.897178 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_employer`
in /var/www/html/careerbd/protected/views/jb/home.php (748)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:11.897552 trace system.db.CDbCommand
Querying SQL: SELECT `employer`.`id` AS `t1_c0`, `employer`.`company_name`
AS `t1_c1`, `employer`.`stakeholder` AS `t1_c2`,
`employer`.`alternative_company_name` AS `t1_c3`,
`employer`.`primary_email` AS `t1_c4`, `employer`.`password` AS `t1_c5`,
`employer`.`parent_company_id` AS `t1_c6`, `employer`.`contact_person` AS
`t1_c7`, `employer`.`contact_person_designation` AS `t1_c8`,
`employer`.`type_of_company_id` AS `t1_c9`, `employer`.`company_size` AS
`t1_c10`, `employer`.`industry_id` AS `t1_c11`,
`employer`.`business_description` AS `t1_c12`, `employer`.`company_address`
AS `t1_c13`, `employer`.`country_id` AS `t1_c14`, `employer`.`division_id`
AS `t1_c15`, `employer`.`district_id` AS `t1_c16`,
`employer`.`billing_address` AS `t1_c17`, `employer`.`contact_phone` AS
`t1_c18`, `employer`.`contact_mobile` AS `t1_c19`, `employer`.`contact_fax`
AS `t1_c20`, `employer`.`alternate_email` AS `t1_c21`, `employer`.`website`
AS `t1_c22`, `employer`.`logo` AS `t1_c23`, `employer`.`banner_image` AS
`t1_c24`, `employer`.`status` AS `t1_c25`, `employer`.`token` AS `t1_c26`,
`employer`.`employer_type` AS `t1_c27` FROM `jb_employer` `employer`  WHERE
(`employer`.`id`=:ypl0). Bound with :ypl0='18165'
in /var/www/html/careerbd/protected/views/jb/home.php (748)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:11.897973 trace system.db.ar.CActiveRecord
Jobs.findAll()
in /var/www/html/careerbd/protected/views/jb/home.php (734)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:11.898029 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `jb_jobs` `t` WHERE employer_id=:employer_id
AND status=:status AND job_posting_type=:job_posting_type AND
job_deadline>=:job_deadline ORDER BY job_publish_date DESC. Bound with
:employer_id='18167', :status='1', :job_posting_type='2',
:job_deadline='2018-06-19'
in /var/www/html/careerbd/protected/views/jb/home.php (734)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:11.898426 trace system.db.ar.CActiveRecord
lazy loading Jobs.employer
in /var/www/html/careerbd/protected/views/jb/home.php (748)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:11.898570 trace system.db.CDbCommand
Querying SQL: SELECT `employer`.`id` AS `t1_c0`, `employer`.`company_name`
AS `t1_c1`, `employer`.`stakeholder` AS `t1_c2`,
`employer`.`alternative_company_name` AS `t1_c3`,
`employer`.`primary_email` AS `t1_c4`, `employer`.`password` AS `t1_c5`,
`employer`.`parent_company_id` AS `t1_c6`, `employer`.`contact_person` AS
`t1_c7`, `employer`.`contact_person_designation` AS `t1_c8`,
`employer`.`type_of_company_id` AS `t1_c9`, `employer`.`company_size` AS
`t1_c10`, `employer`.`industry_id` AS `t1_c11`,
`employer`.`business_description` AS `t1_c12`, `employer`.`company_address`
AS `t1_c13`, `employer`.`country_id` AS `t1_c14`, `employer`.`division_id`
AS `t1_c15`, `employer`.`district_id` AS `t1_c16`,
`employer`.`billing_address` AS `t1_c17`, `employer`.`contact_phone` AS
`t1_c18`, `employer`.`contact_mobile` AS `t1_c19`, `employer`.`contact_fax`
AS `t1_c20`, `employer`.`alternate_email` AS `t1_c21`, `employer`.`website`
AS `t1_c22`, `employer`.`logo` AS `t1_c23`, `employer`.`banner_image` AS
`t1_c24`, `employer`.`status` AS `t1_c25`, `employer`.`token` AS `t1_c26`,
`employer`.`employer_type` AS `t1_c27` FROM `jb_employer` `employer`  WHERE
(`employer`.`id`=:ypl0). Bound with :ypl0='18167'
in /var/www/html/careerbd/protected/views/jb/home.php (748)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
19:47:11.899621 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/eusiajb/views/layouts/main.php (199)
in /var/www/html/careerbd/themes/eusiajb/views/layouts/column1.php (14)
19:47:11.899668 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/eusiajb/views/layouts/main.php (199)
in /var/www/html/careerbd/themes/eusiajb/views/layouts/column1.php (14)
19:47:11.900353 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/eusiajb/views/layouts/main.php (199)
in /var/www/html/careerbd/themes/eusiajb/views/layouts/column1.php (14)
19:47:11.900512 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/eusiajb/views/layouts/main.php (199)
in /var/www/html/careerbd/themes/eusiajb/views/layouts/column1.php (14)
19:47:11.901351 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/eusiajb/views/layouts/main.php (199)
in /var/www/html/careerbd/themes/eusiajb/views/layouts/column1.php (14)
19:47:11.901392 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/eusiajb/views/layouts/main.php (199)
in /var/www/html/careerbd/themes/eusiajb/views/layouts/column1.php (14)
19:47:11.901866 trace system.db.ar.CActiveRecord
Jobs.findAll()
in /var/www/html/careerbd/themes/eusiajb/views/layouts/newssticky.php (21)
in /var/www/html/careerbd/themes/eusiajb/views/layouts/main.php (204)
in /var/www/html/careerbd/themes/eusiajb/views/layouts/column1.php (14)
19:47:11.901911 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `jb_jobs` `t` WHERE status="1" ORDER BY
job_publish_date DESC LIMIT 30
in /var/www/html/careerbd/themes/eusiajb/views/layouts/newssticky.php (21)
in /var/www/html/careerbd/themes/eusiajb/views/layouts/main.php (204)
in /var/www/html/careerbd/themes/eusiajb/views/layouts/column1.php (14)