398203   Resumes       Post free Jobs

Featured Jobs

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
05:12:55.328586 trace system.CModule
Loading "log" application component
in /var/www/html/careerbd/index.php (15)
05:12:55.328738 trace system.CModule
Loading "request" application component
in /var/www/html/careerbd/index.php (15)
05:12:55.328839 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)
05:12:55.329209 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)
05:12:55.329257 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)
05:12:55.329734 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)
05:12:55.330714 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)
05:12:55.331079 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)
05:12:55.331186 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)
05:12:55.384609 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)
05:12:55.385227 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)
05:12:55.385418 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)
05:12:55.385462 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)
05:12:55.388077 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)
05:12:55.388118 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)
05:12:55.389213 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)
05:12:55.389398 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)
05:12:55.390429 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)
05:12:55.390625 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)
05:12:55.391083 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)
05:12:55.391380 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)
05:12:56.305660 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)
05:12:56.306355 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)
05:12:56.306490 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)
05:12:56.306550 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)
05:12:56.306962 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)
05:12:56.307410 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)
05:12:56.307528 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)
05:12:56.307574 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)
05:12:56.307919 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)
05:12:56.308387 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)
05:12:56.308506 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)
05:12:56.308552 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)
05:12:56.308893 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)
05:12:56.309338 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)
05:12:56.309453 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)
05:12:56.309503 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)
05:12:56.309736 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)
05:12:56.309919 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)
05:12:56.310050 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)
05:12:56.310168 trace system.db.CDbCommand
Executing SQL: DELETE FROM `yii_sessions` WHERE expire<:expire. Bound with
:expire=1537657976
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)
05:12:56.310450 trace system.db.CDbCommand
Querying SQL: SELECT `data`
FROM `yii_sessions`
WHERE expire>:expire AND id=:id. Bound with :expire=1537657976,
:id='qu76iu63df6tme2rmadept7ub4'
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)
05:12:56.310631 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)
05:12:56.310672 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)
05:12:56.730856 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)
05:12:56.730918 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)
05:12:56.731662 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)
05:12:56.731863 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)
05:12:56.770370 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)
05:12:56.770432 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)
05:12:56.771044 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)
05:12:56.771209 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)
05:12:56.771481 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)
05:12:56.771770 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)
05:12:56.771994 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)
05:12:56.772038 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)
05:12:56.772377 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)
05:12:56.772574 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)
05:12:56.772891 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)
05:12:56.772927 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)
05:12:56.773217 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)
05:12:56.773413 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)
05:12:56.961782 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)
05:12:56.961930 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)
05:12:57.150402 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)
05:12:57.150552 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)
05:12:57.338912 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)
05:12:57.339068 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)
05:12:57.527400 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)
05:12:57.527550 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)
05:12:57.712697 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)
05:12:57.712846 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)
05:12:57.897905 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)
05:12:57.898061 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)
05:12:58.083216 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)
05:12:58.083367 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)
05:12:58.268388 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)
05:12:58.448726 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)
05:12:58.659496 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)
05:12:58.659559 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)
05:12:58.660363 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)
05:12:58.660540 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)
05:12:58.661447 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)
05:12:58.661490 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)
05:12:58.661967 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)
05:12:58.662019 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)