Varietal
Application Log
Timestamp Level Category Message
12:49:46.313019 trace system.CModule
Loading "log" application component
in /home/ue9mg7ka8fqp/public_html/app/index.php (13)
12:49:46.313220 trace system.CModule
Loading "request" application component
in /home/ue9mg7ka8fqp/public_html/app/index.php (13)
12:49:46.313364 trace system.CModule
Loading "urlManager" application component
in /home/ue9mg7ka8fqp/public_html/app/index.php (13)
12:49:46.315036 trace system.CModule
Loading "db" application component
in /home/ue9mg7ka8fqp/public_html/app/protected/models/Restoran.php (46)
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(19)
in /home/ue9mg7ka8fqp/public_html/app/index.php (13)
12:49:46.315161 trace system.db.CDbConnection
Opening DB connection
in /home/ue9mg7ka8fqp/public_html/app/protected/models/Restoran.php (46)
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(19)
in /home/ue9mg7ka8fqp/public_html/app/index.php (13)
12:49:46.317528 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `RSTRNT`
in /home/ue9mg7ka8fqp/public_html/app/protected/models/Restoran.php (46)
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(19)
in /home/ue9mg7ka8fqp/public_html/app/index.php (13)
12:49:46.319089 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `RSTRNT`
in /home/ue9mg7ka8fqp/public_html/app/protected/models/Restoran.php (46)
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(19)
in /home/ue9mg7ka8fqp/public_html/app/index.php (13)
12:49:46.319322 trace system.db.ar.CActiveRecord
Restoran.find()
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(24)
in /home/ue9mg7ka8fqp/public_html/app/index.php (13)
12:49:46.319519 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `RSTRNT` `t` WHERE URL_ADDR=:url LIMIT 1
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(24)
in /home/ue9mg7ka8fqp/public_html/app/index.php (13)
12:49:46.320050 trace system.db.CDbCommand
Querying SQL: 
            SELECT 
                DISHTP_NM
            FROM DISHTP
            WHERE DISHTP_KEY = :dishtyp 
            LIMIT 1
        
in /home/ue9mg7ka8fqp/public_html/app/protected/models/Wine.php (1825)
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(742)
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(507)
12:49:46.320296 trace system.db.CDbCommand
Querying SQL: 
        SELECT
                `wines`.`vrtl_nm` ,
                `wines`.`vrtl_key` ,
                 COUNT( * ) AS cc,
                 vr.POPLR_SALES_NBR,
                 vr.WINTYP_KEY,
                `aflturl`.AFLT_VTRL_URL
                      FROM    `vw_wines` wines
                            JOIN  `VDSTP` vdtp
                                ON vdtp.`vrtl_key` = wines.`vrtl_key`
                            LEFT JOIN VRTL vr ON wines.`vrtl_key` =
vr.vrtl_key
                            LEFT JOIN `AFLT_VTRL_URL` aflturl 
                                ON vdtp.`vrtl_key` = aflturl.`vrtl_key` AND
`aflturl`.`rstrnt_key` = :rest
                      WHERE `vdtp`.`dishtp_key` = :dishtyp AND vr.BEER_IND
IS NULL AND vr.LQRTYP_KEY = 1
                      GROUP BY  `wines`.`vrtl_key`
                      ORDER BY  vr.POPLR_SALES_NBR IS NULL,
vr.POPLR_SALES_NBR ASC, `vrtl_nm` ,  `cntry_nm`
        
in /home/ue9mg7ka8fqp/public_html/app/protected/models/Wine.php (808)
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(745)
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(507)
12:49:46.363358 trace system.db.CDbCommand
Querying SQL: 
        SELECT 
                a.VRTL_NM, 
                a.VRTL_KEY,
                a.POPLR_SALES_NBR,
                a.WINTYP_KEY,
                b.AFLT_VTRL_URL 
        FROM `VRTL` a   LEFT JOIN `AFLT_VTRL_URL` b 
                        ON a.`vrtl_key` = b.`vrtl_key`
        WHERE a.BEER_IND IS NULL AND a.LQRTYP_KEY = 1
        ORDER BY  a.POPLR_SALES_NBR IS NULL, a.POPLR_SALES_NBR ASC,
a.vrtl_nm
        
in /home/ue9mg7ka8fqp/public_html/app/protected/models/Wine.php (1844)
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(747)
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(507)
12:49:46.463085 trace system.CModule
Loading "widgetFactory" application component
in /home/ue9mg7ka8fqp/public_html/app/protected/views/layouts/column1.php
(3)
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(821)
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(507)
12:49:46.465864 trace system.CModule
Loading "clientScript" application component
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(821)
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(507)
in /home/ue9mg7ka8fqp/public_html/app/index.php (13)