Varietal
Application Log
Timestamp Level Category Message
19:45:50.310827 trace system.CModule 
Loading "log" application component
in /home/ue9mg7ka8fqp/public_html/app/index.php (13)
19:45:50.311070 trace system.CModule 
Loading "request" application component
in /home/ue9mg7ka8fqp/public_html/app/index.php (13)
19:45:50.311243 trace system.CModule 
Loading "urlManager" application component
in /home/ue9mg7ka8fqp/public_html/app/index.php (13)
19:45:50.313092 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)
19:45:50.313251 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)
19:45:50.315588 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)
19:45:50.317156 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)
19:45:50.317447 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)
19:45:50.317676 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)
19:45:50.318041 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 (1826)
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(758)
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(507)
19:45:50.318414 trace system.db.CDbCommand 
Querying SQL: 
        SELECT
                `wines`.`vrtl_nm` ,
                `wines`.`vrtl_key` ,
                 vr.IMG,
                 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 (809)
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(763)
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(507)
19:45:50.370831 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 (1845)
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(765)
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(507)
19:45:50.385250 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
(839)
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(507)
19:45:50.389029 trace system.CModule 
Loading "clientScript" application component
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(839)
in
/home/ue9mg7ka8fqp/public_html/app/protected/controllers/SiteController.php
(507)
in /home/ue9mg7ka8fqp/public_html/app/index.php (13)