Verisure AS

Bli en del av et team som beskytter familier og bedrifter hver dag.

Hver dag jobber teamet i Verisure med å beskytte mer enn 240 000 norske hjem og bedrifter. Vi er den ledende leverandøren av profesjonelt overvåket alarmsystem i Europa og integrerer produktutvikling, design, salg, installasjon og service med en profesjonell overvåkingsløsning. Vi er i kontinuerlig vekst og har spennende planer om utvide, endre og lede alarmbransjen inn i fremtiden.

Business Analyst

Verisure er en ledende, profesjonell leverandør av sikkerhetsløsninger som har mer enn 4 millioner kunder i 17 land over hele Europa og Latin-Amerika. Vår forretningsmodell integrerer produktutvikling, design og salg med installasjon, service og en 24/7 profesjonell overvåkingsløsning. 


Takket være et sterkt fokus på høy kvalitet er selskapets kunder blant de mest fornøyde og lojale i bransjen. Konsernet har vokst til å bli den nest største leverandøren av boligalarmer i verden og er i gjennomsnitt 3,5 ganger så stor som sin nærmeste konkurrent i de lokale markedene. Vårt utvalg av produkter inkluderer innbruddssikkerhet, vann- og brannsikkerhet, personlig sikkerhet og smarthussystemer.


I løpet av de siste årene har Verisure opplevd en eksepsjonell kundevekst med tosifret vekstrater hvert år takket være kontinuerlig drivkraft for innovasjon, et sofistikert Go To Market strategi og en forretningsmodell for ekspansjon til nye land. 


Verisure Norge er i dag et av Verisures største markeder med mer enn 600 ansatte og en robust kundeportefølje av fornøyde og lojale kunder. I løpet av de siste fire årene har selskapet sett en sterk vekst og gjør seg nå klar for neste fase av transformasjonen. Vi søker derfor nå etter en talentfull, innovativ og lidenskapelig forretningsanalytiker for å styrke vårt suksessrike team. Rollen vil rapportere til Head of Business Improvement.


Business Analyst
Rollens samarbeidspartnere vil bestå av et bredt spekter av interessenter på tvers av funksjoner og avdelinger. Det vil være en god mulighet for et sterkt talent til å utvikle seg videre i organisasjonen vår.

Vår suksess avhenger av våre medarbeidere, og vi investerer i dem hver eneste dag. Å jobbe i Verisure er å være en del av et bransjeledende selskap i verdensklasse, og du inspireres av vår sterke entreprenørånd.


Hovedansvarsområder
Hovedansvaret for stillingen er å designe og bygge forretnings-KPI'er som er relatert til prestasjonen og lønnsomheten av vår kundeportefølje i Norge. Denne personen kommer til å være eier av den kommersielle delen av vår kundeportefølje rapportering, som er sentral for å kunne forbedre vår kundeportefølje lønnsomhet.


Eksempler på daglige oppgaver

  • Segment analysere vår kundeportefølje for å forstå muligheter for prissetting
  • Analysere muligheter for churn reduksjon 
  • Måle og analysere vår kundeportefølje påvirkning av mersalgsaktiviteter 
  • Analysere segmenter i kundeporteføljen med mersalgsmuligheter

 

For at du skal lykkes i rollen ser vi for oss at du har

  • Relevant akademisk utdanning på universitetsnivå (bachelor eller master) med analytisk bakgrunn
  • 1-3 års erfaring innen rådgivning og forretningsutvikling, eller om du er den rette kandidaten kan du være aktuell om du kommer rett fra studie
  • Tidligere erfaringer fra abonnementsbaserte forretninger er en fordel
  • Pålitelighet - evne til å produsere arbeid av meget høy kvalitet til rett tid samt evne til å prioritere og håndtere flere oppgaver med stramme tidsfrister
  • Smidighet – i stand til å håndtere usikkerhet og tilpasse seg endringer med pragmatisme. Du vet hvordan du får ting gjort i krevende situasjoner
  • Du er en kollegial, ambisiøs, flekisbel og ernergisk bidragsyter
  • Du har et løsningsorientert tankesett
  • Avansert bruker i Excel og gjerne andre analyseverktøyer som Power Bi
  • Du kommuniserer godt på engelsk og norsk, og formidler dine analytiske funn på en spennende og nytenkende måte.

 

Har du spørsmål til stillingen eller ønsker å søke? 
Ta kontakt med Johan Nepper Sadolin,  Upsell Manager, på mail; johan.sadolin@verisure.com  eller mobil +47 482 94 104

Har du spørsmål rundt ansettelsesprosessen? 
Ta kontakt med Merete Davanger Holtet, HR Business Partner, mobil +47 970 24 888.

Søknader blir behandlet fortløpende – søknadsfrist 31. august 2023.
Vi ser frem til å høre fra deg!

Applikasjonslogg
Tid Nivå Kategori Melding
06:15:31.68520 trace system.CModule
Loading "log" application component
in /www/jobbsys/live/public/index.php (29)
06:15:31.68629 trace system.CModule
Loading "input" application component
in /www/jobbsys/live/public/index.php (29)
06:15:31.68662 trace system.CModule
Loading "request" application component
in /www/jobbsys/live/public/index.php (29)
06:15:31.68712 trace system.CModule
Loading "urlManager" application component
in /www/jobbsys/live/public/index.php (29)
06:15:31.69068 trace system.base.CModule
Loading "job" module
in /www/jobbsys/live/public/index.php (29)
06:15:31.69123 trace system.CModule
Loading "assetManager" application component
in /www/jobbsys/live/protected/base/WebModule.php (255)
in /www/jobbsys/live/protected/base/WebModule.php (233)
in /www/jobbsys/live/protected/modules/job/JobModule.php (38)
06:15:31.69164 trace system.CModule
Loading "clientScript" application component
in /www/jobbsys/live/protected/base/WebModule.php (283)
in /www/jobbsys/live/protected/base/WebModule.php (233)
in /www/jobbsys/live/protected/modules/job/JobModule.php (38)
06:15:31.69189 trace system.base.CModule
Loading "user" module
in /www/jobbsys/live/protected/base/WebModule.php (240)
in /www/jobbsys/live/protected/modules/job/JobModule.php (38)
in /www/jobbsys/live/public/index.php (29)
06:15:31.69284 trace system.base.CModule
Loading "customer" module
in /www/jobbsys/live/protected/base/WebModule.php (240)
in /www/jobbsys/live/protected/modules/user/UserModule.php (41)
in /www/jobbsys/live/protected/base/WebModule.php (240)
06:15:31.69376 trace system.base.CModule
Loading "admin" module
in /www/jobbsys/live/protected/base/WebModule.php (240)
in /www/jobbsys/live/protected/modules/customer/CustomerModule.php (52)
in /www/jobbsys/live/protected/base/WebModule.php (240)
06:15:31.69478 trace system.base.CModule
Loading "content" module
in /www/jobbsys/live/protected/base/WebModule.php (240)
in /www/jobbsys/live/protected/modules/admin/AdminModule.php (58)
in /www/jobbsys/live/protected/base/WebModule.php (240)
06:15:31.69581 trace system.base.CModule
Loading "cv" module
in /www/jobbsys/live/protected/base/WebModule.php (240)
in /www/jobbsys/live/protected/modules/customer/CustomerModule.php (52)
in /www/jobbsys/live/protected/base/WebModule.php (240)
06:15:31.69770 trace system.CModule
Loading "session" application component
in /www/jobbsys/live/protected/base/Controller.php (76)
in /www/jobbsys/live/public/index.php (29)
06:15:31.70034 trace system.web.filters.CFilterChain
Running filter JobController.filteraccessControl()
in /www/jobbsys/live/public/index.php (29)
06:15:31.70060 trace system.CModule
Loading "user" application component
in /www/jobbsys/live/public/index.php (29)
06:15:31.70127 trace system.CModule
Loading "securityManager" application component
in /www/jobbsys/live/protected/components/WebUser.php (34)
in /www/jobbsys/live/public/index.php (29)
06:15:31.70400 trace system.CModule
Loading "messages" application component
in /www/jobbsys/live/protected/helpers/LayoutHelper.php (192)
in /www/jobbsys/live/protected/modules/job/models/Job.php (662)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
06:15:31.70641 trace system.db.ar.CActiveRecord
Job.find()
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
06:15:31.70651 trace system.CModule
Loading "db" application component
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
06:15:31.70676 trace system.db.CDbConnection
Opening DB connection
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
06:15:31.71480 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `job`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
06:15:31.73023 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `job`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
06:15:31.73587 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `customer_client`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
06:15:31.74337 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `customer_client`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
06:15:31.74690 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `customer`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
06:15:31.75607 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `customer`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
06:15:31.76098 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `job_category`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
06:15:31.76704 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `job_category`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
06:15:31.77024 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `job_contact`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
06:15:31.77642 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `job_contact`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
06:15:31.77960 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `contact`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
06:15:31.78752 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `contact`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
06:15:31.79288 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`lang_id` AS `t0_c1`,
`t`.`customer_client_id` AS `t0_c2`, `t`.`address_id` AS `t0_c3`,
`t`.`title` AS `t0_c4`, `t`.`position` AS `t0_c5`, `t`.`visibility` AS
`t0_c6`, `t`.`content` AS `t0_c7`, `t`.`alt_customer_name` AS `t0_c8`,
`t`.`customer_description` AS `t0_c9`, `t`.`reference_number` AS `t0_c10`,
`t`.`last_search_day` AS `t0_c11`, `t`.`date_start` AS `t0_c12`,
`t`.`date_finish` AS `t0_c13`, `t`.`date_modified` AS `t0_c14`,
`t`.`display_rule` AS `t0_c15`, `t`.`default_link` AS `t0_c16`, `t`.`link`
AS `t0_c17`, `t`.`logo` AS `t0_c18`, `t`.`active` AS `t0_c19`, `t`.`status`
AS `t0_c20`, `t`.`created_by` AS `t0_c21`, `t`.`created_date` AS `t0_c22`,
`t`.`modified_by` AS `t0_c23`, `t`.`modified_date` AS `t0_c24`,
`t`.`sort_priority` AS `t0_c25`, `t`.`import_id` AS `t0_c26`,
`t`.`import_source_id` AS `t0_c27`, `t`.`application_list` AS `t0_c28`,
`t`.`application_list_show` AS `t0_c29`, `customerClient`.`id` AS `t1_c0`,
`customerClient`.`agency_id` AS `t1_c1`, `customerClient`.`customer_id` AS
`t1_c2`, `customerClient`.`client_id` AS `t1_c3`,
`customerClient`.`default_view` AS `t1_c4`, `customerClient`.`active` AS
`t1_c5`, `customer`.`id` AS `t2_c0`, `customer`.`primary_user_id` AS
`t2_c1`, `customer`.`name` AS `t2_c2`, `customer`.`orgno` AS `t2_c3`,
`customer`.`type` AS `t2_c4`, `customer`.`catalog` AS `t2_c5`,
`customer`.`homepage` AS `t2_c6`, `customer`.`email` AS `t2_c7`,
`customer`.`phone` AS `t2_c8`, `customer`.`fax` AS `t2_c9`,
`customer`.`description` AS `t2_c10`, `customer`.`default_job_description`
AS `t2_c11`, `customer`.`have_template` AS `t2_c12`,
`customer`.`not_billing` AS `t2_c13`, `customer`.`active` AS `t2_c14`,
`customer`.`logo` AS `t2_c15`, `customer`.`link` AS `t2_c16`,
`customer`.`filter_type` AS `t2_c17`, `customer`.`open_application` AS
`t2_c18`, `customer`.`open_application_description` AS `t2_c19`,
`customer`.`created_by` AS `t2_c20`, `customer`.`created_date` AS `t2_c21`,
`customer`.`modified_by` AS `t2_c22`, `customer`.`modified_date` AS
`t2_c23`, `customer`.`delete_app_days` AS `t2_c24`, `client`.`id` AS
`t3_c0`, `client`.`primary_user_id` AS `t3_c1`, `client`.`name` AS `t3_c2`,
`client`.`orgno` AS `t3_c3`, `client`.`type` AS `t3_c4`, `client`.`catalog`
AS `t3_c5`, `client`.`homepage` AS `t3_c6`, `client`.`email` AS `t3_c7`,
`client`.`phone` AS `t3_c8`, `client`.`fax` AS `t3_c9`,
`client`.`description` AS `t3_c10`, `client`.`default_job_description` AS
`t3_c11`, `client`.`have_template` AS `t3_c12`, `client`.`not_billing` AS
`t3_c13`, `client`.`active` AS `t3_c14`, `client`.`logo` AS `t3_c15`,
`client`.`link` AS `t3_c16`, `client`.`filter_type` AS `t3_c17`,
`client`.`open_application` AS `t3_c18`,
`client`.`open_application_description` AS `t3_c19`, `client`.`created_by`
AS `t3_c20`, `client`.`created_date` AS `t3_c21`, `client`.`modified_by` AS
`t3_c22`, `client`.`modified_date` AS `t3_c23`, `client`.`delete_app_days`
AS `t3_c24`, `jobCategories`.`id` AS `t4_c0`, `jobCategories`.`job_id` AS
`t4_c1`, `jobCategories`.`category_id` AS `t4_c2`, `jobContacts`.`id` AS
`t5_c0`, `jobContacts`.`job_id` AS `t5_c1`, `jobContacts`.`contact_id` AS
`t5_c2`, `jobContacts`.`permission` AS `t5_c3`, `jobContacts`.`type` AS
`t5_c4`, `jobContacts`.`sort_order` AS `t5_c5`, `contact`.`id` AS `t6_c0`,
`contact`.`user_id` AS `t6_c1`, `contact`.`customer_id` AS `t6_c2`,
`contact`.`title` AS `t6_c3`, `contact`.`firstname` AS `t6_c4`,
`contact`.`lastname` AS `t6_c5`, `contact`.`phone` AS `t6_c6`,
`contact`.`cellphone` AS `t6_c7`, `contact`.`email` AS `t6_c8`,
`contact`.`email_display` AS `t6_c9`, `contact`.`perms` AS `t6_c10`,
`contact`.`active` AS `t6_c11`, `contact`.`receive_open_application` AS
`t6_c12`, `contact`.`created_by` AS `t6_c13`, `contact`.`created_date` AS
`t6_c14`, `contact`.`modified_by` AS `t6_c15`, `contact`.`modified_date` AS
`t6_c16` FROM `job` `t`  INNER JOIN `customer_client` `customerClient` ON
(`t`.`customer_client_id`=`customerClient`.`id`) INNER JOIN `customer`
`customer` ON (`customerClient`.`customer_id`=`customer`.`id`) INNER JOIN
`customer` `client` ON (`customerClient`.`client_id`=`client`.`id`) LEFT
JOIN `job_category` `jobCategories` ON (`jobCategories`.`job_id`=`t`.`id`)
LEFT JOIN `job_contact` `jobContacts` ON (`jobContacts`.`job_id`=`t`.`id`)
LEFT JOIN `contact` `contact` ON
(`jobContacts`.`contact_id`=`contact`.`id`) AND ((contact.active!=0) AND
(contact.active = :contactActive)) WHERE ((t.status!=15) AND (t.id = :jobId
AND t.active = :jobActive AND t.status = :jobStatus AND t.date_finish >=
"2024-05-04" AND t.date_start <= "2024-05-04")) ORDER BY contact.firstname
asc, contact.firstname asc. Bound with :jobId='2706932', :jobActive=1,
:jobStatus=11, :contactActive=1
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(167)
in /www/jobbsys/live/public/index.php (29)
06:15:31.80303 trace system.db.CDbCommand
Querying SQL: SELECT *
FROM `category`
WHERE lang_id='no'
ORDER BY `id` ASC
in /www/jobbsys/live/protected/modules/job/models/Category.php (98)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(174)
in /www/jobbsys/live/public/index.php (29)
06:15:31.84772 trace system.db.ar.CActiveRecord
JobStatistic.updateAll()
in /www/jobbsys/live/protected/modules/job/models/JobStatistic.php (218)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(231)
in /www/jobbsys/live/public/index.php (29)
06:15:31.84817 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `job_statistic`
in /www/jobbsys/live/protected/modules/job/models/JobStatistic.php (218)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(231)
in /www/jobbsys/live/public/index.php (29)
06:15:31.85788 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `job_statistic`
in /www/jobbsys/live/protected/modules/job/models/JobStatistic.php (218)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(231)
in /www/jobbsys/live/public/index.php (29)
06:15:31.86061 trace system.db.CDbCommand
Executing SQL: UPDATE `job_statistic` SET `job_post_views`=job_post_views+1
WHERE job_id=:ycp0. Bound with :ycp0='2706932'
in /www/jobbsys/live/protected/modules/job/models/JobStatistic.php (218)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(231)
in /www/jobbsys/live/public/index.php (29)
06:15:31.87841 trace system.db.ar.CActiveRecord
UserFavourites.findAll()
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(262)
in /www/jobbsys/live/public/index.php (29)
06:15:31.87888 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `user_favourites`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(262)
in /www/jobbsys/live/public/index.php (29)
06:15:31.88742 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `user_favourites`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(262)
in /www/jobbsys/live/public/index.php (29)
06:15:31.88992 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `user_favourites` `t`
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(262)
in /www/jobbsys/live/public/index.php (29)
06:15:31.90070 trace system.CModule
Loading "pageTitle" application component
in /www/jobbsys/live/protected/base/Controller.php (108)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(271)
in /www/jobbsys/live/public/index.php (29)
06:15:31.90118 trace system.CModule
Loading "menu" application component
in /www/jobbsys/live/protected/base/Controller.php (108)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(271)
in /www/jobbsys/live/public/index.php (29)
06:15:31.90188 trace system.db.ar.CActiveRecord
User.findByPk()
in /www/jobbsys/live/protected/modules/user/models/User.php (825)
in /www/jobbsys/live/protected/modules/customer/CustomerModule.php (112)
in /www/jobbsys/live/protected/modules/customer/CustomerModule.php (73)
06:15:31.90240 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `user`
in /www/jobbsys/live/protected/modules/user/models/User.php (825)
in /www/jobbsys/live/protected/modules/customer/CustomerModule.php (112)
in /www/jobbsys/live/protected/modules/customer/CustomerModule.php (73)
06:15:31.91120 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `user`
in /www/jobbsys/live/protected/modules/user/models/User.php (825)
in /www/jobbsys/live/protected/modules/customer/CustomerModule.php (112)
in /www/jobbsys/live/protected/modules/customer/CustomerModule.php (73)
06:15:31.91365 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `user` `t` WHERE (t.status!=10) AND (`t`.`id`
IS NULL) LIMIT 1
in /www/jobbsys/live/protected/modules/user/models/User.php (825)
in /www/jobbsys/live/protected/modules/customer/CustomerModule.php (112)
in /www/jobbsys/live/protected/modules/customer/CustomerModule.php (73)
06:15:31.91536 trace system.CModule
Loading "authManager" application component
in /www/jobbsys/live/protected/components/WebUser.php (102)
in /www/jobbsys/live/protected/config/menu.php (104)
in /www/jobbsys/live/protected/components/Menu.php (62)
06:15:31.91877 trace application
Checking ACL for WEB_PAGES::read, userId=
in /www/jobbsys/live/protected/components/AuthManager.php (43)
in /www/jobbsys/live/protected/components/WebUser.php (102)
in /www/jobbsys/live/protected/config/menu.php (104)
06:15:31.91922 trace application
Checking ACL for WEB_PAGES::add, userId=
in /www/jobbsys/live/protected/components/AuthManager.php (43)
in /www/jobbsys/live/protected/components/WebUser.php (102)
in /www/jobbsys/live/protected/modules/admin/AdminModule.php (178)
06:15:31.91943 trace application
Checking ACL for CUSTOMER::add, userId=
in /www/jobbsys/live/protected/components/AuthManager.php (43)
in /www/jobbsys/live/protected/components/WebUser.php (102)
in /www/jobbsys/live/protected/config/menu.php (110)
06:15:31.92040 trace application
Checking ACL for JOB_POST::admin_functions, userId=
in /www/jobbsys/live/protected/components/AuthManager.php (43)
in /www/jobbsys/live/protected/components/WebUser.php (102)
in /www/jobbsys/live/protected/config/menu.php (159)
06:15:31.92088 trace application
Checking ACL for CUSTOMER::edit, userId=
in /www/jobbsys/live/protected/components/AuthManager.php (43)
in /www/jobbsys/live/protected/components/WebUser.php (102)
in /www/jobbsys/live/protected/config/menu.php (219)
06:15:31.92109 trace application
Checking ACL for USER::edit, userId=
in /www/jobbsys/live/protected/components/AuthManager.php (43)
in /www/jobbsys/live/protected/components/WebUser.php (102)
in /www/jobbsys/live/protected/config/menu.php (230)
06:15:31.92128 trace application
Checking ACL for JOB_POST::add, userId=
in /www/jobbsys/live/protected/components/AuthManager.php (43)
in /www/jobbsys/live/protected/components/WebUser.php (102)
in /www/jobbsys/live/protected/config/menu.php (243)
06:15:31.92926 trace system.CModule
Loading "widgetFactory" application component
in /www/jobbsys/live/protected/modules/job/views/jobItemNew.php (36)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(271)
in /www/jobbsys/live/public/index.php (29)
06:15:31.93955 trace system.db.ar.CActiveRecord
lazy loading Job.address
in /www/jobbsys/live/protected/modules/job/views/_companyInformationNew.php
(25)
in /www/jobbsys/live/protected/base/Controller.php (170)
in /www/jobbsys/live/protected/modules/job/views/jobItemNew.php (162)
06:15:31.94172 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `address`
in /www/jobbsys/live/protected/modules/job/views/_companyInformationNew.php
(25)
in /www/jobbsys/live/protected/base/Controller.php (170)
in /www/jobbsys/live/protected/modules/job/views/jobItemNew.php (162)
06:15:31.95068 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `address`
in /www/jobbsys/live/protected/modules/job/views/_companyInformationNew.php
(25)
in /www/jobbsys/live/protected/base/Controller.php (170)
in /www/jobbsys/live/protected/modules/job/views/jobItemNew.php (162)
06:15:31.95362 trace system.db.CDbCommand
Querying SQL: SELECT `address`.`id` AS `t1_c0`, `address`.`country_id` AS
`t1_c1`, `address`.`address` AS `t1_c2`, `address`.`formatted_address` AS
`t1_c3`, `address`.`administrative_area_level_1` AS `t1_c4`,
`address`.`administrative_area_level_2` AS `t1_c5`,
`address`.`administrative_area_level_3` AS `t1_c6`, `address`.`route` AS
`t1_c7`, `address`.`street_number` AS `t1_c8`, `address`.`postal_code` AS
`t1_c9`, `address`.`postal_town` AS `t1_c10`, `address`.`lat` AS `t1_c11`,
`address`.`lng` AS `t1_c12`, `address`.`status` AS `t1_c13` FROM `address`
`address`  WHERE (`address`.`id`=:ypl0). Bound with :ypl0=NULL
in /www/jobbsys/live/protected/modules/job/views/_companyInformationNew.php
(25)
in /www/jobbsys/live/protected/base/Controller.php (170)
in /www/jobbsys/live/protected/modules/job/views/jobItemNew.php (162)
06:15:31.95488 trace system.db.ar.CActiveRecord
lazy loading Customer.streetAddress
in /www/jobbsys/live/protected/modules/job/views/_companyInformationNew.php
(28)
in /www/jobbsys/live/protected/base/Controller.php (170)
in /www/jobbsys/live/protected/modules/job/views/jobItemNew.php (162)
06:15:31.95681 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `customer_address`
in /www/jobbsys/live/protected/modules/job/views/_companyInformationNew.php
(28)
in /www/jobbsys/live/protected/base/Controller.php (170)
in /www/jobbsys/live/protected/modules/job/views/jobItemNew.php (162)
06:15:31.96406 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `customer_address`
in /www/jobbsys/live/protected/modules/job/views/_companyInformationNew.php
(28)
in /www/jobbsys/live/protected/base/Controller.php (170)
in /www/jobbsys/live/protected/modules/job/views/jobItemNew.php (162)
06:15:31.96694 trace system.db.CDbCommand
Querying SQL: SELECT `streetAddress`.`id` AS `t1_c0`,
`streetAddress`.`customer_id` AS `t1_c1`, `streetAddress`.`address_id` AS
`t1_c2`, `streetAddress`.`reference` AS `t1_c3`, `streetAddress`.`type` AS
`t1_c4` FROM `customer_address` `streetAddress`  WHERE (streetAddress.type
= :type) AND (`streetAddress`.`customer_id`=:ypl0). Bound with :type=1,
:ypl0='180100'
in /www/jobbsys/live/protected/modules/job/views/_companyInformationNew.php
(28)
in /www/jobbsys/live/protected/base/Controller.php (170)
in /www/jobbsys/live/protected/modules/job/views/jobItemNew.php (162)
06:15:31.96853 trace system.db.ar.CActiveRecord
lazy loading CustomerAddress.address
in /www/jobbsys/live/protected/modules/job/views/_companyInformationNew.php
(28)
in /www/jobbsys/live/protected/base/Controller.php (170)
in /www/jobbsys/live/protected/modules/job/views/jobItemNew.php (162)
06:15:31.96976 trace system.db.CDbCommand
Querying SQL: SELECT `address`.`id` AS `t1_c0`, `address`.`country_id` AS
`t1_c1`, `address`.`address` AS `t1_c2`, `address`.`formatted_address` AS
`t1_c3`, `address`.`administrative_area_level_1` AS `t1_c4`,
`address`.`administrative_area_level_2` AS `t1_c5`,
`address`.`administrative_area_level_3` AS `t1_c6`, `address`.`route` AS
`t1_c7`, `address`.`street_number` AS `t1_c8`, `address`.`postal_code` AS
`t1_c9`, `address`.`postal_town` AS `t1_c10`, `address`.`lat` AS `t1_c11`,
`address`.`lng` AS `t1_c12`, `address`.`status` AS `t1_c13` FROM `address`
`address`  WHERE (`address`.`id`=:ypl0). Bound with :ypl0='172368'
in /www/jobbsys/live/protected/modules/job/views/_companyInformationNew.php
(28)
in /www/jobbsys/live/protected/base/Controller.php (170)
in /www/jobbsys/live/protected/modules/job/views/jobItemNew.php (162)
06:15:31.98227 trace system.CModule
Loading "statePersister" application component
in /www/jobbsys/live/protected/components/views/newLangBox.php (4)
in /www/jobbsys/live/protected/components/LangBox.php (11)
in /www/jobbsys/live/protected/views/layouts/new.php (130)
06:15:31.98819 trace system.CModule
Loading "systemMsg" application component
in /www/jobbsys/live/protected/widgets/SystemMessagesWidget.php (27)
in /www/jobbsys/live/protected/views/layouts/new.php (248)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(271)
06:15:31.99025 trace system.db.ar.CActiveRecord
ContentCategory.findAll()
in /www/jobbsys/live/protected/modules/content/widgets/BottomMenuWidget.php
(71)
in /www/jobbsys/live/protected/views/layouts/new.php (294)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(271)
06:15:31.99073 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `content_category`
in /www/jobbsys/live/protected/modules/content/widgets/BottomMenuWidget.php
(71)
in /www/jobbsys/live/protected/views/layouts/new.php (294)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(271)
06:15:31.99751 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `content_category`
in /www/jobbsys/live/protected/modules/content/widgets/BottomMenuWidget.php
(71)
in /www/jobbsys/live/protected/views/layouts/new.php (294)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(271)
06:15:31.100083 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `content`
in /www/jobbsys/live/protected/modules/content/widgets/BottomMenuWidget.php
(71)
in /www/jobbsys/live/protected/views/layouts/new.php (294)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(271)
06:15:31.100883 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `content`
in /www/jobbsys/live/protected/modules/content/widgets/BottomMenuWidget.php
(71)
in /www/jobbsys/live/protected/views/layouts/new.php (294)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(271)
06:15:31.101219 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`lang_id` AS `t0_c1`,
`t`.`parent_id` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`grp_alias` AS
`t0_c4`, `pages`.`title` AS `t1_c6`, `pages`.`alias` AS `t1_c8`,
`pages`.`url` AS `t1_c9`, `pages`.`sort_order` AS `t1_c12`, `pages`.`id` AS
`t1_c0` FROM `content_category` `t`  LEFT OUTER JOIN `content` `pages` ON
(`pages`.`category_id`=`t`.`id`) AND (pages.lang_id = :pagesLangId AND
pages.active = 1 AND pages.parent_id IS NULL) WHERE (((t.lang_id=:langId)
AND (t.id=:ycp1)) AND (t.parent_id=:ycp2)) ORDER BY pages.sort_order ASC.
Bound with :langId='no', :ycp1='4', :ycp2='1', :pagesLangId='no'
in /www/jobbsys/live/protected/modules/content/widgets/BottomMenuWidget.php
(71)
in /www/jobbsys/live/protected/views/layouts/new.php (294)
in /www/jobbsys/live/protected/modules/job/controllers/JobController.php
(271)