Varietal
Application Log
Timestamp Level Category Message
00:10:25.088201 trace system.CModule 
Loading "log" application component
in /home/ue9mg7ka8fqp/public_html/app/index.php (13)
00:10:25.088572 trace system.CModule 
Loading "request" application component
in /home/ue9mg7ka8fqp/public_html/app/index.php (13)
00:10:25.088820 trace system.CModule 
Loading "urlManager" application component
in /home/ue9mg7ka8fqp/public_html/app/index.php (13)
00:10:25.091978 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)
00:10:25.092195 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)
00:10:25.096337 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)
00:10:25.099510 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)
00:10:25.100600 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)
00:10:25.100991 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)
00:10:25.101557 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
(746)
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(507)
00:10:25.102190 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
(749)
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(507)
00:10:25.141705 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
(751)
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(507)
00:10:25.165030 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
(825)
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(507)
00:10:25.169790 trace system.CModule 
Loading "clientScript" application component
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(825)
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(507)
in /home/ue9mg7ka8fqp/public_html/app/index.php (13)