Tracks tagged with Louis La Roche

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 (tags 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 (tags 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` IN ('2442',
'2359', '2323', '1303', '1074', '646', '527')) GROUP BY `t`.`post_id`