Tracks by Question

Loading "log" application component

Loading "request" application component

Loading "urlManager" application component

Loading "cache" application component

Running filter PostController.filteraccessControl()

Loading "user" application component

Loading "session" application component

Loading "clientScript" application component

Loading "widgetFactory" application component

Loading "assetManager" application component

Post.count()

Loading "db" application component

Opening DB connection

Querying SQL: SHOW FULL COLUMNS FROM `post`

Querying SQL: SHOW CREATE TABLE `post`

Post.count() eagerly

Querying SQL: SELECT COUNT(DISTINCT `t`.`id`) FROM `post` `t`  WHERE
((rating>9 AND status=2) AND (author LIKE :ycp0))

Post.findAll()

Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`title` AS `t0_c1`,
`t`.`author` AS `t0_c2`, `t`.`author_link` AS `t0_c3`, `t`.`source` AS
`t0_c4`, `t`.`content` AS `t0_c5`, `t`.`purchase_url` AS `t0_c6`,
`t`.`genre` AS `t0_c7`, `t`.`flv_link` AS `t0_c8`, `t`.`tags` AS `t0_c9`,
`t`.`query` AS `t0_c10`, `t`.`status` AS `t0_c11`, `t`.`create_time` AS
`t0_c12`, `t`.`update_time` AS `t0_c13`, `t`.`author_id` AS `t0_c14`,
`t`.`plays` AS `t0_c15`, `t`.`itunes_clicks` AS `t0_c16`,
`t`.`amazon_clicks` AS `t0_c17`, `t`.`emusic_clicks` AS `t0_c18`,
`t`.`image_link` AS `t0_c19`, `t`.`rating` AS `t0_c20`, `t`.`loved_count`
AS `t0_c21`, `t`.`fail_count` AS `t0_c22`, `t`.`offered` AS `t0_c23` FROM
`post` `t`  WHERE ((rating>9 AND status=2) AND (author LIKE :ycp0)) ORDER
BY create_time DESC LIMIT 15

Querying SQL: SHOW FULL COLUMNS FROM `user_favorites`

Querying SQL: SHOW CREATE TABLE `user_favorites`

Querying SQL: SELECT `t`.`post_id` AS `c`, COUNT(*) AS `s` FROM
`user_favorites` `t` WHERE (user_id=0) AND (`t`.`post_id`='3038') GROUP BY
`t`.`post_id`