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
21:35:15.998364 trace system.CModule
Loading "log" application component
in /var/www/html/careerbd/index.php (15)
21:35:15.998519 trace system.CModule
Loading "request" application component
in /var/www/html/careerbd/index.php (15)
21:35:15.998625 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)
21:35:15.998996 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)
21:35:15.999044 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)
21:35:15.999571 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)
21:35:16.000598 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)
21:35:16.001000 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)
21:35:16.001116 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)
21:35:16.035106 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)
21:35:16.035700 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)
21:35:16.035892 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)
21:35:16.035936 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)
21:35:16.038619 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)
21:35:16.038660 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)
21:35:16.039736 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)
21:35:16.039921 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)
21:35:16.041022 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)
21:35:16.041228 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)
21:35:16.041580 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)
21:35:16.041870 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)
21:35:16.697503 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)
21:35:16.698185 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)
21:35:16.698322 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)
21:35:16.698381 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)
21:35:16.698803 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)
21:35:16.699258 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)
21:35:16.699374 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)
21:35:16.699421 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)
21:35:16.699774 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)
21:35:16.700242 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)
21:35:16.700361 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)
21:35:16.700407 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)
21:35:16.700762 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)
21:35:16.701201 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)
21:35:16.701318 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)
21:35:16.701364 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)
21:35:16.701605 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)
21:35:16.701782 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)
21:35:16.701904 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)
21:35:16.702306 trace system.db.CDbCommand
Executing SQL: DELETE FROM `yii_sessions` WHERE expire<:expire. Bound with
:expire=1527435316
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)
21:35:16.705822 trace system.db.CDbCommand
Querying SQL: SELECT `data`
FROM `yii_sessions`
WHERE expire>:expire AND id=:id. Bound with :expire=1527435316,
:id='aqprbr2hj0hvusrf3sltri91l4'
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)
21:35:16.706048 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)
21:35:16.706100 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)
21:35:17.137118 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)
21:35:17.137181 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)
21:35:17.137932 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)
21:35:17.138134 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)
21:35:17.174778 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)
21:35:17.174838 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)
21:35:17.175406 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)
21:35:17.175565 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)
21:35:17.175822 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)
21:35:17.176114 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)
21:35:17.176342 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)
21:35:17.176381 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)
21:35:17.176774 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)
21:35:17.176980 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)
21:35:17.177309 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)
21:35:17.177346 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)
21:35:17.177628 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)
21:35:17.177820 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)
21:35:17.366446 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)
21:35:17.366595 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)
21:35:17.555294 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)
21:35:17.555442 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)
21:35:17.744256 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)
21:35:17.744404 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)
21:35:17.932486 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)
21:35:17.932632 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)
21:35:18.121759 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)
21:35:18.121908 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)
21:35:18.311093 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)
21:35:18.311243 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)
21:35:18.500374 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)
21:35:18.500524 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)
21:35:18.689618 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)
21:35:18.873421 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)
21:35:18.961430 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)
21:35:18.961517 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-05-27'
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)
21:35:18.962245 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)
21:35:18.962340 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)
21:35:18.962518 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)
21:35:18.963334 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)
21:35:18.963709 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)
21:35:18.964145 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)
21:35:18.964201 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-05-27'
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)
21:35:18.964610 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)
21:35:18.964749 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)
21:35:18.965735 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)
21:35:18.965784 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)
21:35:18.966424 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)
21:35:18.966582 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)
21:35:18.967413 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)
21:35:18.967454 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)
21:35:18.967924 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)
21:35:18.967968 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)