| # |
type |
message |
| 1 | Routing | connect "/login" |
| 2 | Routing | connect "/logout" |
| 3 | Routing | connect "/request_password" |
| 4 | Context | initialization |
| 5 | Controller | initialization |
| 6 | Routing | match route [default] "/:module/:action/*" |
| 7 | Request | request parameters array ( 'module' => 'sfSimpleBlog', 'action' => 'show', 'stripped_title' => '抜糸しました7.25',) |
| 8 | Controller | dispatch request |
| 9 | Filter | executing filter "sfRenderingFilter" |
| 10 | Filter | executing filter "sfWebDebugFilter" |
| 11 | Filter | executing filter "sfCommonFilter" |
| 12 | Filter | executing filter "sfFlashFilter" |
| 13 | Filter | executing filter "sfExecutionFilter" |
| 14 | Action | change layout to "sf_root_dir/plugins/sfSimpleBlogPlugin/modules/sfSimpleBlog/templates/layout" |
| 15 | Action | call "sfSimpleBlogActions->executeShow()" |
| 16 | Creole | connect(): DSN: array ( 'compat_assoc_lower' => '****', 'compat_rtrim_string' => '****', 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'socket' => '****', 'username' => '****', ), FLAGS: 0 |
| 17 | Creole | prepareStatement(): SELECT sf_blog_post.ID, sf_blog_post.AUTHOR_ID, sf_blog_post.TITLE, sf_blog_post.STRIPPED_TITLE, sf_blog_post.EXTRACT, sf_blog_post.CONTENT, sf_blog_post.IS_PUBLISHED, sf_blog_post.ALLOW_COMMENTS, sf_blog_post.CREATED_AT, sf_blog_post.PUBLISHED_AT FROM sf_blog_post WHERE sf_blog_post.STRIPPED_TITLE=? |
| 18 | Creole | executeQuery(): [0.43 ms] SELECT sf_blog_post.ID, sf_blog_post.AUTHOR_ID, sf_blog_post.TITLE, sf_blog_post.STRIPPED_TITLE, sf_blog_post.EXTRACT, sf_blog_post.CONTENT, sf_blog_post.IS_PUBLISHED, sf_blog_post.ALLOW_COMMENTS, sf_blog_post.CREATED_AT, sf_blog_post.PUBLISHED_AT FROM sf_blog_post WHERE sf_blog_post.STRIPPED_TITLE='抜糸しました7.25' |
| 19 | Creole | prepareStatement(): SELECT sf_blog_comment.ID, sf_blog_comment.SF_BLOG_POST_ID, sf_blog_comment.AUTHOR_NAME, sf_blog_comment.AUTHOR_EMAIL, sf_blog_comment.AUTHOR_URL, sf_blog_comment.CONTENT, sf_blog_comment.IS_MODERATED, sf_blog_comment.CREATED_AT FROM sf_blog_comment, sf_blog_post WHERE sf_blog_comment.IS_MODERATED=? AND sf_blog_comment.SF_BLOG_POST_ID=? AND sf_blog_post.ID=sf_blog_comment.SF_BLOG_POST_ID ORDER BY sf_blog_comment.CREATED_AT ASC |
| 20 | Creole | executeQuery(): [0.37 ms] SELECT sf_blog_comment.ID, sf_blog_comment.SF_BLOG_POST_ID, sf_blog_comment.AUTHOR_NAME, sf_blog_comment.AUTHOR_EMAIL, sf_blog_comment.AUTHOR_URL, sf_blog_comment.CONTENT, sf_blog_comment.IS_MODERATED, sf_blog_comment.CREATED_AT FROM sf_blog_comment, sf_blog_post WHERE sf_blog_comment.IS_MODERATED=0 AND sf_blog_comment.SF_BLOG_POST_ID=104 AND sf_blog_post.ID=sf_blog_comment.SF_BLOG_POST_ID ORDER BY sf_blog_comment.CREATED_AT ASC |
| 21 | View | initialize view for "sfSimpleBlog/show" |
| 22 | View | render "sf_root_dir/plugins/sfSimpleBlogPlugin/modules/sfSimpleBlog/templates/showSuccess.php" |
| 23 | View | initialize view for "sfSimpleBlog/_post" |
| 24 | View | render "sf_root_dir/plugins/sfSimpleBlogPlugin/modules/sfSimpleBlog/templates/_post.php" |
| 25 | Creole | prepareStatement(): SELECT sf_guard_user.ID, sf_guard_user.USERNAME, sf_guard_user.ALGORITHM, sf_guard_user.SALT, sf_guard_user.PASSWORD, sf_guard_user.CREATED_AT, sf_guard_user.LAST_LOGIN, sf_guard_user.IS_ACTIVE, sf_guard_user.IS_SUPER_ADMIN FROM sf_guard_user WHERE sf_guard_user.ID=? |
| 26 | Creole | executeQuery(): [0.31 ms] SELECT sf_guard_user.ID, sf_guard_user.USERNAME, sf_guard_user.ALGORITHM, sf_guard_user.SALT, sf_guard_user.PASSWORD, sf_guard_user.CREATED_AT, sf_guard_user.LAST_LOGIN, sf_guard_user.IS_ACTIVE, sf_guard_user.IS_SUPER_ADMIN FROM sf_guard_user WHERE sf_guard_user.ID=1 |
| 27 | Creole | prepareStatement(): SELECT sf_blog_tag.SF_BLOG_POST_ID, sf_blog_tag.TAG, sf_blog_tag.CREATED_AT FROM sf_blog_tag WHERE sf_blog_tag.SF_BLOG_POST_ID=? |
| 28 | Creole | executeQuery(): [0.64 ms] SELECT sf_blog_tag.SF_BLOG_POST_ID, sf_blog_tag.TAG, sf_blog_tag.CREATED_AT FROM sf_blog_tag WHERE sf_blog_tag.SF_BLOG_POST_ID=104 |
| 29 | View | initialize view for "sfSimpleBlog/_comment_list" |
| 30 | View | render "sf_root_dir/plugins/sfSimpleBlogPlugin/modules/sfSimpleBlog/templates/_comment_list.php" |
| 31 | View | initialize view for "sfSimpleBlog/_sidebar" |
| 32 | View | render "sf_root_dir/plugins/sfSimpleBlogPlugin/modules/sfSimpleBlog/templates/_sidebar.php" |
| 33 | PartialHelper | set slot "sfSimpleBlog_sidebar" |
| 34 | PartialHelper | call "sfSimpleBlog->executeRecentPosts()" |
| 35 | Creole | prepareStatement(): SELECT COUNT(sf_blog_post.ID) FROM sf_blog_post WHERE sf_blog_post.IS_PUBLISHED=? |
| 36 | Creole | executeQuery(): [0.74 ms] SELECT COUNT(sf_blog_post.ID) FROM sf_blog_post WHERE sf_blog_post.IS_PUBLISHED=1 |
| 37 | View | initialize view for "sfSimpleBlog/_recentPosts" |
| 38 | View | render "sf_root_dir/plugins/sfSimpleBlogPlugin/modules/sfSimpleBlog/templates/_recentPosts.php" |
| 39 | Creole | prepareStatement(): SELECT sf_blog_post.ID, sf_blog_post.AUTHOR_ID, sf_blog_post.TITLE, sf_blog_post.STRIPPED_TITLE, sf_blog_post.EXTRACT, sf_blog_post.CONTENT, sf_blog_post.IS_PUBLISHED, sf_blog_post.ALLOW_COMMENTS, sf_blog_post.CREATED_AT, sf_blog_post.PUBLISHED_AT, sf_guard_user.ID, sf_guard_user.USERNAME, sf_guard_user.ALGORITHM, sf_guard_user.SALT, sf_guard_user.PASSWORD, sf_guard_user.CREATED_AT, sf_guard_user.LAST_LOGIN, sf_guard_user.IS_ACTIVE, sf_guard_user.IS_SUPER_ADMIN FROM sf_blog_post, sf_guard_user WHERE sf_blog_post.IS_PUBLISHED=? AND sf_blog_post.AUTHOR_ID=sf_guard_user.ID ORDER BY sf_blog_post.CREATED_AT DESC |
| 40 | Creole | applyLimit(): SELECT sf_blog_post.ID, sf_blog_post.AUTHOR_ID, sf_blog_post.TITLE, sf_blog_post.STRIPPED_TITLE, sf_blog_post.EXTRACT, sf_blog_post.CONTENT, sf_blog_post.IS_PUBLISHED, sf_blog_post.ALLOW_COMMENTS, sf_blog_post.CREATED_AT, sf_blog_post.PUBLISHED_AT, sf_guard_user.ID, sf_guard_user.USERNAME, sf_guard_user.ALGORITHM, sf_guard_user.SALT, sf_guard_user.PASSWORD, sf_guard_user.CREATED_AT, sf_guard_user.LAST_LOGIN, sf_guard_user.IS_ACTIVE, sf_guard_user.IS_SUPER_ADMIN FROM sf_blog_post, sf_guard_user WHERE sf_blog_post.IS_PUBLISHED=1 AND sf_blog_post.AUTHOR_ID=sf_guard_user.ID ORDER BY sf_blog_post.CREATED_AT DESC, offset: 0, limit: 25 |
| 41 | Creole | executeQuery(): [1.70 ms] SELECT sf_blog_post.ID, sf_blog_post.AUTHOR_ID, sf_blog_post.TITLE, sf_blog_post.STRIPPED_TITLE, sf_blog_post.EXTRACT, sf_blog_post.CONTENT, sf_blog_post.IS_PUBLISHED, sf_blog_post.ALLOW_COMMENTS, sf_blog_post.CREATED_AT, sf_blog_post.PUBLISHED_AT, sf_guard_user.ID, sf_guard_user.USERNAME, sf_guard_user.ALGORITHM, sf_guard_user.SALT, sf_guard_user.PASSWORD, sf_guard_user.CREATED_AT, sf_guard_user.LAST_LOGIN, sf_guard_user.IS_ACTIVE, sf_guard_user.IS_SUPER_ADMIN FROM sf_blog_post, sf_guard_user WHERE sf_blog_post.IS_PUBLISHED=1 AND sf_blog_post.AUTHOR_ID=sf_guard_user.ID ORDER BY sf_blog_post.CREATED_AT DESC LIMIT 25 |
| 42 | PartialHelper | call "sfSimpleBlog->executeTagList()" |
| 43 | Creole | prepareStatement(): SELECT sf_blog_tag.TAG, count(sf_blog_tag.SF_BLOG_POST_ID) as count FROM sf_blog_tag GROUP BY sf_blog_tag.TAG |
| 44 | Creole | executeQuery(): [2.37 ms] SELECT sf_blog_tag.TAG, count(sf_blog_tag.SF_BLOG_POST_ID) as count FROM sf_blog_tag GROUP BY sf_blog_tag.TAG |
| 45 | View | initialize view for "sfSimpleBlog/_tagList" |
| 46 | View | render "sf_root_dir/plugins/sfSimpleBlogPlugin/modules/sfSimpleBlog/templates/_tagList.php" |
| 47 | View | decorate content with "sf_root_dir/plugins/sfSimpleBlogPlugin/modules/sfSimpleBlog/templates/layout.php" |
| 48 | View | render "sf_root_dir/plugins/sfSimpleBlogPlugin/modules/sfSimpleBlog/templates/layout.php" |
| 49 | PartialHelper | get slot "auto_discovery_link_tag" |
| 50 | PartialHelper | get slot "sfSimpleBlog_sidebar" |