397553   Resumes       Post free Jobs

Featured Jobs

Global Travels

Travel Agent Manager

Show More
 
00:2441:5141:26
41:51
  • Auto
  • 1080p (4207 kbps)
  • 1080p (2179 kbps)
  • 720p (1583 kbps)
  • 360p (987 kbps)
  • 360p (679 kbps)
  • 360p (478 kbps)
Application Log
Timestamp Level Category Message
15:47:31.103307 trace system.CModule
Loading "log" application component
in /var/www/html/careerbd/index.php (15)
15:47:31.103465 trace system.CModule
Loading "request" application component
in /var/www/html/careerbd/index.php (15)
15:47:31.103573 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:31.103946 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)
15:47:31.103996 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)
15:47:31.104552 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)
15:47:31.105582 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)
15:47:31.105938 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)
15:47:31.106046 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)
15:47:31.144714 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)
15:47:31.145311 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)
15:47:31.145499 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)
15:47:31.145545 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)
15:47:31.148154 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)
15:47:31.148195 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)
15:47:31.149317 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)
15:47:31.149544 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)
15:47:31.150574 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)
15:47:31.150774 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)
15:47:31.151185 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)
15:47:31.151403 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)
15:47:31.851876 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)
15:47:31.852557 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)
15:47:31.852693 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)
15:47:31.852754 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)
15:47:31.853178 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)
15:47:31.853630 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)
15:47:31.853749 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)
15:47:31.853796 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)
15:47:31.854151 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)
15:47:31.854621 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)
15:47:31.854741 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)
15:47:31.854788 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)
15:47:31.855138 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)
15:47:31.855581 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)
15:47:31.855698 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)
15:47:31.855745 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)
15:47:31.855982 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)
15:47:31.856167 trace system.CModule
Loading "clientScript" application component
in /var/www/html/careerbd/protected/views/jb/home.php (153)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:31.856286 trace system.CModule
Loading "session" application component
in /var/www/html/careerbd/protected/views/jb/home.php (276)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:31.856405 trace system.db.CDbCommand
Executing SQL: DELETE FROM `yii_sessions` WHERE expire<:expire. Bound with
:expire=1532339251
in /var/www/html/careerbd/protected/views/jb/home.php (276)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:31.856781 trace system.db.CDbCommand
Querying SQL: SELECT `data`
FROM `yii_sessions`
WHERE expire>:expire AND id=:id. Bound with :expire=1532339251,
:id='1osruesfofpq7fkknhi6ia8mf0'
in /var/www/html/careerbd/protected/views/jb/home.php (276)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:31.856966 trace system.db.ar.CActiveRecord
Jobs.findAll()
in /var/www/html/careerbd/protected/views/jb/home.php (302)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:31.857006 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 (302)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:32.281873 trace system.db.ar.CActiveRecord
Jobseeker.count()
in /var/www/html/careerbd/protected/views/jb/home.php (306)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:32.281938 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_jobseeker`
in /var/www/html/careerbd/protected/views/jb/home.php (306)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:32.282710 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_jobseeker`
in /var/www/html/careerbd/protected/views/jb/home.php (306)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:32.282901 trace system.db.CDbCommand
Querying SQL: SELECT COUNT(*) FROM `jb_jobseeker` `t`
in /var/www/html/careerbd/protected/views/jb/home.php (306)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:32.321530 trace system.db.ar.CActiveRecord
ResumeValue.findByPk()
in /var/www/html/careerbd/protected/views/jb/home.php (307)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:32.321590 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `resume_value`
in /var/www/html/careerbd/protected/views/jb/home.php (307)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:32.322190 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `resume_value`
in /var/www/html/careerbd/protected/views/jb/home.php (307)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:32.322355 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 (307)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:32.322622 trace system.CModule
Loading "widgetFactory" application component
in /var/www/html/careerbd/protected/views/jb/home.php (358)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:32.322904 trace system.CModule
Loading "assetManager" application component
in /var/www/html/careerbd/protected/views/jb/home.php (404)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:32.323137 trace system.db.ar.CActiveRecord
Divisions.findAllByAttributes()
in /var/www/html/careerbd/protected/views/jb/home.php (428)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:32.323175 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_divisions`
in /var/www/html/careerbd/protected/views/jb/home.php (428)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:32.323515 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_divisions`
in /var/www/html/careerbd/protected/views/jb/home.php (428)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:32.323717 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 (428)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:32.324028 trace system.db.ar.CActiveRecord
Divisions.findAll()
in /var/www/html/careerbd/protected/views/jb/home.php (472)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:32.324063 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 (472)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:32.324351 trace system.db.ar.CActiveRecord
lazy loading Divisions.countdiv
in /var/www/html/careerbd/protected/views/jb/home.php (478)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:32.324469 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 (478)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:32.519897 trace system.db.ar.CActiveRecord
lazy loading Divisions.countdiv
in /var/www/html/careerbd/protected/views/jb/home.php (478)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:32.520045 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 (478)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:32.715472 trace system.db.ar.CActiveRecord
lazy loading Divisions.countdiv
in /var/www/html/careerbd/protected/views/jb/home.php (478)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:32.715622 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 (478)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:32.911226 trace system.db.ar.CActiveRecord
lazy loading Divisions.countdiv
in /var/www/html/careerbd/protected/views/jb/home.php (478)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:32.911375 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 (478)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:33.106322 trace system.db.ar.CActiveRecord
lazy loading Divisions.countdiv
in /var/www/html/careerbd/protected/views/jb/home.php (478)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:33.106471 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 (478)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:33.301892 trace system.db.ar.CActiveRecord
lazy loading Divisions.countdiv
in /var/www/html/careerbd/protected/views/jb/home.php (478)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:33.302042 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 (478)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:33.497265 trace system.db.ar.CActiveRecord
lazy loading Divisions.countdiv
in /var/www/html/careerbd/protected/views/jb/home.php (478)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:33.497412 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 (478)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:33.692759 trace system.db.ar.CActiveRecord
lazy loading Divisions.countdiv
in /var/www/html/careerbd/protected/views/jb/home.php (478)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:33.692907 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 (478)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:33.888397 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 (523)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:34.078666 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 (597)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:34.290245 trace system.db.ar.CActiveRecord
Jobs.findAll()
in /var/www/html/careerbd/protected/views/jb/home.php (737)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:34.290330 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='19176', :status='1', :job_posting_type='2',
:job_deadline='2018-07-23'
in /var/www/html/careerbd/protected/views/jb/home.php (737)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:34.291024 trace system.CModule
Loading "easyImage" application component
in /var/www/html/careerbd/protected/views/jb/home.php (751)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:34.291125 trace system.db.ar.CActiveRecord
lazy loading Jobs.employer
in /var/www/html/careerbd/protected/views/jb/home.php (751)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:34.291309 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_employer`
in /var/www/html/careerbd/protected/views/jb/home.php (751)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:34.292109 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_employer`
in /var/www/html/careerbd/protected/views/jb/home.php (751)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:34.292565 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='19176'
in /var/www/html/careerbd/protected/views/jb/home.php (751)
in /var/www/html/careerbd/protected/controllers/JbController.php (129)
in /var/www/html/careerbd/index.php (15)
15:47:34.293653 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)
15:47:34.293700 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)
15:47:34.294449 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)
15:47:34.294610 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)
15:47:34.295491 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)
15:47:34.295532 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)
15:47:34.296062 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)
15:47:34.296116 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)