It is a supplementation.
<Output-Mongrel when item list>
SQL (0.000145) select sqlite_version(*)
SQL (0.000652) SELECT count(DISTINCT "items".id) AS count_all FROM
"items" LEFT OUTER JOIN "items_tags" ON "items_tags".item_id =
"items".id LEFT OUTER JOIN "tags" ON "tags".id = "items_tags".tag_id
WHERE (buy_date >= '2008-12-01' and buy_date <'2009-01-01')
Item Load (0.000220) SELECT "items".* FROM "items" WHERE (buy_date >=
'2008-12-01' and buy_date <'2009-01-01') ORDER BY items."id" ASC LIMIT
15 OFFSET 0
Tag Load (0.000993) SELECT "tags".*, t0.item_id as _parent_record_id
FROM "tags" INNER JOIN "items_tags" as t0 ON "tags".id = t0.tag_id
WHERE (t0.item_id IN (39,40))
SQL (0.000272) SELECT sum("items".price) AS sum_price FROM "items"
LEFT OUTER JOIN "items_tags" ON "items_tags".item_id = "items".id LEFT
OUTER JOIN "tags" ON "tags".id = "items_tags".tag_id WHERE (buy_date
>= '2008-12-01' and buy_date <'2009-01-01')
Processing ItemsController#list (for 127.0.0.1 at 2008-12-02 16:54:19)
[GET]
Session ID:
BAh7CCINYXM6aXRlbXN7BjoJbGlzdHsGIglwYWdlaQYiCmZsYXNoSUM6J0Fj
dGlvbkNvbnRyb2xsZXI6OkZsYXNoOjpGbGFzaEhhc2h7AAY6CkB1c2VkewA6
DGNzcmZfaWQiJWE5OTc5NDA5YjczNGUzZjY4ZTEyZDkzMzEyMzRiMTRk--7c52b2c8e95ca63889eb54f7fbfbaac5cbe308bf
Parameters: {"action"=>"list", "controller"=>"items"}
Rendering template within layouts/items
Rendering items/list
Rendered items/_list_header (0.00050)
Rendered items/_list_column_headings (0.00231)
Rendered items/_messages (0.00002)
Rendered items/_list_actions (0.00075)
Rendered items/_list_record (0.00440)
Rendered items/_list_actions (0.00058)
Rendered items/_list_record (0.00219)
Rendered items/_list_calculations (0.00137)
Rendered items/_list (0.01181)
Rendered items/_header (0.00001)
Rendered items/_footer (0.00001)
Completed in 0.02899 (34 reqs/sec) | Rendering: 0.01482 (51%) | DB:
0.00228 (7%) | 200 OK [http://localhost/item/]
<Output-Mongrel when edit an item →sum change correct>
Item Load (0.000221) SELECT * FROM "items" WHERE ("items"."id" = 40)
Tag Load (0.000303) SELECT * FROM "tags" INNER JOIN "items_tags" ON
"tags".id = "items_tags".tag_id WHERE ("items_tags".item_id = 40 )
Tag Load (0.000530) SELECT * FROM "tags"
Processing ItemsController#edit (for 127.0.0.1 at 2008-12-02 16:44:31)
[GET]
Session ID:
BAh7CCINYXM6aXRlbXN7BjoJbGlzdHsAIgpmbGFzaElDOidBY3Rpb25Db250
cm9sbGVyOjpGbGFzaDo6Rmxhc2hIYXNoewAGOgpAdXNlZHsAOgxjc3JmX2lk
IiVhOTk3OTQwOWI3MzRlM2Y2OGUxMmQ5MzMxMjM0YjE0ZA==--0157ea71644a85c9b0f1b5a18cd18fda2801cd62
Parameters: {"adapter"=>"_list_inline_adapter", "_method"=>"get",
"action"=>"edit", "id"=>"40", "controller"=>"items"}
Rendered items/_form_attribute (0.00723)
Rendered items/_form_attribute (0.00021)
Rendered items/_form_attribute (0.00021)
Rendered items/_form_attribute (0.00682)
Rendered items/_form (0.01744)
Rendered items/_update_form (0.01888)
Rendering _list_inline_adapter
Rendered core/_messages (0.00003)
Completed in 0.08502 (11 reqs/sec) | Rendering: 0.06185 (72%) | DB:
0.00000 (0%) | 200 OK [http://localhost/items/edit/40?
_method=get&adapter=_list_inline_adapter]
Item Load (0.000226) SELECT * FROM "items" WHERE ("items"."id" = 40)
Tag Load (0.000301) SELECT * FROM "tags" INNER JOIN "items_tags" ON
"tags".id = "items_tags".tag_id WHERE ("items_tags".item_id = 40 )
SQL (0.000217) SELECT sum("items".price) AS sum_price FROM "items"
WHERE (buy_date >= '2008-12-01' and buy_date <'2009-01-01')
Processing ItemsController#row (for 127.0.0.1 at 2008-12-02 16:44:33)
[GET]
Session ID:
BAh7CCINYXM6aXRlbXN7BjoJbGlzdHsAOgxjc3JmX2lkIiVhOTk3OTQwOWI3
MzRlM2Y2OGUxMmQ5MzMxMjM0YjE0ZCIKZmxhc2hJQzonQWN0aW9uQ29udHJv
bGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==--
a5e002766e1ead49602f74fcf02dcc47f441a57d
Parameters: {"_method"=>"get", "action"=>"row", "id"=>"40",
"controller"=>"items"}
Rendered items/_list_actions (0.00126)
Rendered items/_list_calculations (0.00127)
Rendered items/_list_record (0.01299)
Completed in 0.01742 (57 reqs/sec) | Rendering: 0.01325 (76%) | DB:
0.00074 (4%) | 200 OK [http://localhost/items/row/40?_method=get]
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"ActiveScaffold : Ruby on Rails plugin" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/activescaffold?hl=en
-~----------~----~----~----~------~----~------~--~---