Slikicki.com > Collections > UEFA EURO 2012 Poland/Ukraine

Session

{:flash=>{}, :csrf_id=>"3dcf243975dcfe7030cc8cabef7691c1"}

{}

Params

{:action=>"show", :locale=>"slo", :controller=>"collections", :id=>"157-uefa-euro-2012-poland-ukraine"}

Filter chain for CollectionsController

Name	Type	Actions
Footnotes::Filter	:before	[:index, :auto_search, :create, :stickers, :new, :show]
:assign_current_user_to_models	:before	[:index, :auto_search, :create, :stickers, :new, :show]
:handle_user_settings	:before	[:index, :auto_search, :create, :stickers, :new, :show]
:verify_authenticity_token	:before	[:create]
:get_profile	:before	[:index, :auto_search, :create, :stickers, :new, :show]
:set_user_time_zone	:before	[:index, :auto_search, :create, :stickers, :new, :show]
:set_languages	:before	[:index, :auto_search, :create, :stickers, :new, :show]
:set_unread_messages	:before	[:index, :auto_search, :create, :stickers, :new, :show]
:set_locale_from_url	:before	[:index, :auto_search, :create, :stickers, :new, :show]
:login_required	:before	[:create, :new]
:set_main_photo	:before	[:index]
:set_main_photo_details	:before	[:auto_search, :create, :stickers, :new, :show]
Footnotes::Filter	:after	[:index, :auto_search, :create, :stickers, :new, :show]

Routes for CollectionsController

Path	Name	Options	Requirements
search_collections_mak	/mak/collections/search/	{:action=>"index", :locale=>"mak", :t=>"search"}	{}
search_collections_eng	/collections/search/	{:action=>"index", :locale=>"eng", :t=>"search"}	{}
search_collections_srb	/srb/collections/search/	{:action=>"index", :locale=>"srb", :t=>"search"}	{}
search_collections_cro	/cro/collections/search/	{:action=>"index", :locale=>"cro", :t=>"search"}	{}
search_collections_slo	/slo/collections/search/	{:action=>"index", :locale=>"slo", :t=>"search"}	{}
tag_collections_mak	/mak/collections/tag/:v/	{:action=>"index", :locale=>"mak", :t=>"tag"}	{}
tag_collections_eng	/collections/tag/:v/	{:action=>"index", :locale=>"eng", :t=>"tag"}	{}
tag_collections_srb	/srb/collections/tag/:v/	{:action=>"index", :locale=>"srb", :t=>"tag"}	{}
tag_collections_cro	/cro/collections/tag/:v/	{:action=>"index", :locale=>"cro", :t=>"tag"}	{}
tag_collections_slo	/slo/collections/tag/:v/	{:action=>"index", :locale=>"slo", :t=>"tag"}	{}
publisher_collections_mak	/mak/collections/publisher/:v/	{:action=>"index", :locale=>"mak", :t=>"publisher"}	{}
publisher_collections_eng	/collections/publisher/:v/	{:action=>"index", :locale=>"eng", :t=>"publisher"}	{}
publisher_collections_srb	/srb/collections/publisher/:v/	{:action=>"index", :locale=>"srb", :t=>"publisher"}	{}
publisher_collections_cro	/cro/collections/publisher/:v/	{:action=>"index", :locale=>"cro", :t=>"publisher"}	{}
publisher_collections_slo	/slo/collections/publisher/:v/	{:action=>"index", :locale=>"slo", :t=>"publisher"}	{}
newest_collections_mak	/mak/collections/newest/	{:action=>"index", :locale=>"mak"}	{}
newest_collections_eng	/collections/newest/	{:action=>"index", :locale=>"eng"}	{}
newest_collections_srb	/srb/collections/newest/	{:action=>"index", :locale=>"srb"}	{}
newest_collections_cro	/cro/collections/newest/	{:action=>"index", :locale=>"cro"}	{}
newest_collections_slo	/slo/collections/newest/	{:action=>"index", :locale=>"slo"}	{}
recent_collections_mak	/mak/collections/recent/	{:action=>"index", :locale=>"mak", :s=>"recent"}	{}
recent_collections_eng	/collections/recent/	{:action=>"index", :locale=>"eng", :s=>"recent"}	{}
recent_collections_srb	/srb/collections/recent/	{:action=>"index", :locale=>"srb", :s=>"recent"}	{}
recent_collections_cro	/cro/collections/recent/	{:action=>"index", :locale=>"cro", :s=>"recent"}	{}
recent_collections_slo	/slo/collections/recent/	{:action=>"index", :locale=>"slo", :s=>"recent"}	{}
most_discussed_collections_mak	/mak/collections/most_discussed/	{:action=>"index", :locale=>"mak", :s=>"most_discussed"}	{}
most_discussed_collections_eng	/collections/most_discussed/	{:action=>"index", :locale=>"eng", :s=>"most_discussed"}	{}
most_discussed_collections_srb	/srb/collections/most_discussed/	{:action=>"index", :locale=>"srb", :s=>"most_discussed"}	{}
most_discussed_collections_cro	/cro/collections/most_discussed/	{:action=>"index", :locale=>"cro", :s=>"most_discussed"}	{}
most_discussed_collections_slo	/slo/collections/most_discussed/	{:action=>"index", :locale=>"slo", :s=>"most_discussed"}	{}
most_users_collections_mak	/mak/collections/most_users/	{:action=>"index", :locale=>"mak", :s=>"most_users"}	{}
most_users_collections_eng	/collections/most_users/	{:action=>"index", :locale=>"eng", :s=>"most_users"}	{}
most_users_collections_srb	/srb/collections/most_users/	{:action=>"index", :locale=>"srb", :s=>"most_users"}	{}
most_users_collections_cro	/cro/collections/most_users/	{:action=>"index", :locale=>"cro", :s=>"most_users"}	{}
most_users_collections_slo	/slo/collections/most_users/	{:action=>"index", :locale=>"slo", :s=>"most_users"}	{}
offers_and_req_collections_mak	/mak/collections/offer_and_req/	{:action=>"index", :locale=>"mak", :s=>"offers_and_req"}	{}
offers_and_req_collections_eng	/collections/offer_and_req/	{:action=>"index", :locale=>"eng", :s=>"offers_and_req"}	{}
offers_and_req_collections_srb	/srb/collections/offer_and_req/	{:action=>"index", :locale=>"srb", :s=>"offers_and_req"}	{}
offers_and_req_collections_cro	/cro/collections/offer_and_req/	{:action=>"index", :locale=>"cro", :s=>"offers_and_req"}	{}
offers_and_req_collections_slo	/slo/collections/offer_and_req/	{:action=>"index", :locale=>"slo", :s=>"offers_and_req"}	{}
auto_search_collections_mak	/mak/collections/auto_search/	{:action=>"auto_search", :locale=>"mak"}	{}
auto_search_collections_eng	/collections/auto_search/	{:action=>"auto_search", :locale=>"eng"}	{}
auto_search_collections_srb	/srb/collections/auto_search/	{:action=>"auto_search", :locale=>"srb"}	{}
auto_search_collections_cro	/cro/collections/auto_search/	{:action=>"auto_search", :locale=>"cro"}	{}
auto_search_collections_slo	/slo/collections/auto_search/	{:action=>"auto_search", :locale=>"slo"}	{}
formatted_auto_search_collections_mak	/mak/collections/auto_search.:format/	{:action=>"auto_search", :locale=>"mak"}	{}
formatted_auto_search_collections_eng	/collections/auto_search.:format/	{:action=>"auto_search", :locale=>"eng"}	{}
formatted_auto_search_collections_srb	/srb/collections/auto_search.:format/	{:action=>"auto_search", :locale=>"srb"}	{}
formatted_auto_search_collections_cro	/cro/collections/auto_search.:format/	{:action=>"auto_search", :locale=>"cro"}	{}
formatted_auto_search_collections_slo	/slo/collections/auto_search.:format/	{:action=>"auto_search", :locale=>"slo"}	{}
collections_mak	/mak/collections/	{:action=>"index", :locale=>"mak"}	{}
collections_eng	/collections/	{:action=>"index", :locale=>"eng"}	{}
collections_srb	/srb/collections/	{:action=>"index", :locale=>"srb"}	{}
collections_cro	/cro/collections/	{:action=>"index", :locale=>"cro"}	{}
collections_slo	/slo/collections/	{:action=>"index", :locale=>"slo"}	{}
formatted_collections_mak	/mak/collections.:format/	{:action=>"index", :locale=>"mak"}	{}
formatted_collections_eng	/collections.:format/	{:action=>"index", :locale=>"eng"}	{}
formatted_collections_srb	/srb/collections.:format/	{:action=>"index", :locale=>"srb"}	{}
formatted_collections_cro	/cro/collections.:format/	{:action=>"index", :locale=>"cro"}	{}
formatted_collections_slo	/slo/collections.:format/	{:action=>"index", :locale=>"slo"}	{}
	/mak/collections/	{:action=>"create", :locale=>"mak"}	{}
	/collections/	{:action=>"create", :locale=>"eng"}	{}
	/srb/collections/	{:action=>"create", :locale=>"srb"}	{}
	/cro/collections/	{:action=>"create", :locale=>"cro"}	{}
	/slo/collections/	{:action=>"create", :locale=>"slo"}	{}
	/mak/collections.:format/	{:action=>"create", :locale=>"mak"}	{}
	/collections.:format/	{:action=>"create", :locale=>"eng"}	{}
	/srb/collections.:format/	{:action=>"create", :locale=>"srb"}	{}
	/cro/collections.:format/	{:action=>"create", :locale=>"cro"}	{}
	/slo/collections.:format/	{:action=>"create", :locale=>"slo"}	{}
new_collection_mak	/mak/collections/new/	{:action=>"new", :locale=>"mak"}	{}
new_collection_eng	/collections/new/	{:action=>"new", :locale=>"eng"}	{}
new_collection_srb	/srb/collections/new/	{:action=>"new", :locale=>"srb"}	{}
new_collection_cro	/cro/collections/new/	{:action=>"new", :locale=>"cro"}	{}
new_collection_slo	/slo/collections/new/	{:action=>"new", :locale=>"slo"}	{}
formatted_new_collection_mak	/mak/collections/new.:format/	{:action=>"new", :locale=>"mak"}	{}
formatted_new_collection_eng	/collections/new.:format/	{:action=>"new", :locale=>"eng"}	{}
formatted_new_collection_srb	/srb/collections/new.:format/	{:action=>"new", :locale=>"srb"}	{}
formatted_new_collection_cro	/cro/collections/new.:format/	{:action=>"new", :locale=>"cro"}	{}
formatted_new_collection_slo	/slo/collections/new.:format/	{:action=>"new", :locale=>"slo"}	{}
edit_collection_mak	/mak/collections/:id/edit/	{:action=>"edit", :locale=>"mak"}	{:id=>/[^\/.?]+/}
edit_collection_eng	/collections/:id/edit/	{:action=>"edit", :locale=>"eng"}	{:id=>/[^\/.?]+/}
edit_collection_srb	/srb/collections/:id/edit/	{:action=>"edit", :locale=>"srb"}	{:id=>/[^\/.?]+/}
edit_collection_cro	/cro/collections/:id/edit/	{:action=>"edit", :locale=>"cro"}	{:id=>/[^\/.?]+/}
edit_collection_slo	/slo/collections/:id/edit/	{:action=>"edit", :locale=>"slo"}	{:id=>/[^\/.?]+/}
formatted_edit_collection_mak	/mak/collections/:id/edit.:format/	{:action=>"edit", :locale=>"mak"}	{:id=>/[^\/.?]+/}
formatted_edit_collection_eng	/collections/:id/edit.:format/	{:action=>"edit", :locale=>"eng"}	{:id=>/[^\/.?]+/}
formatted_edit_collection_srb	/srb/collections/:id/edit.:format/	{:action=>"edit", :locale=>"srb"}	{:id=>/[^\/.?]+/}
formatted_edit_collection_cro	/cro/collections/:id/edit.:format/	{:action=>"edit", :locale=>"cro"}	{:id=>/[^\/.?]+/}
formatted_edit_collection_slo	/slo/collections/:id/edit.:format/	{:action=>"edit", :locale=>"slo"}	{:id=>/[^\/.?]+/}
stickers_collection_mak	/mak/collections/:id/stickers/	{:action=>"stickers", :locale=>"mak"}	{}
stickers_collection_eng	/collections/:id/stickers/	{:action=>"stickers", :locale=>"eng"}	{}
stickers_collection_srb	/srb/collections/:id/stickers/	{:action=>"stickers", :locale=>"srb"}	{}
stickers_collection_cro	/cro/collections/:id/stickers/	{:action=>"stickers", :locale=>"cro"}	{}
stickers_collection_slo	/slo/collections/:id/stickers/	{:action=>"stickers", :locale=>"slo"}	{}
formatted_stickers_collection_mak	/mak/collections/:id/stickers.:format/	{:action=>"stickers", :locale=>"mak"}	{}
formatted_stickers_collection_eng	/collections/:id/stickers.:format/	{:action=>"stickers", :locale=>"eng"}	{}
formatted_stickers_collection_srb	/srb/collections/:id/stickers.:format/	{:action=>"stickers", :locale=>"srb"}	{}
formatted_stickers_collection_cro	/cro/collections/:id/stickers.:format/	{:action=>"stickers", :locale=>"cro"}	{}
formatted_stickers_collection_slo	/slo/collections/:id/stickers.:format/	{:action=>"stickers", :locale=>"slo"}	{}
collection_mak	/mak/collections/:id/	{:action=>"show", :locale=>"mak"}	{:id=>/[^\/.?]+/}
collection_eng	/collections/:id/	{:action=>"show", :locale=>"eng"}	{:id=>/[^\/.?]+/}
collection_srb	/srb/collections/:id/	{:action=>"show", :locale=>"srb"}	{:id=>/[^\/.?]+/}
collection_cro	/cro/collections/:id/	{:action=>"show", :locale=>"cro"}	{:id=>/[^\/.?]+/}
collection_slo	/slo/collections/:id/	{:action=>"show", :locale=>"slo"}	{:id=>/[^\/.?]+/}
formatted_collection_mak	/mak/collections/:id.:format/	{:action=>"show", :locale=>"mak"}	{:id=>/[^\/.?]+/}
formatted_collection_eng	/collections/:id.:format/	{:action=>"show", :locale=>"eng"}	{:id=>/[^\/.?]+/}
formatted_collection_srb	/srb/collections/:id.:format/	{:action=>"show", :locale=>"srb"}	{:id=>/[^\/.?]+/}
formatted_collection_cro	/cro/collections/:id.:format/	{:action=>"show", :locale=>"cro"}	{:id=>/[^\/.?]+/}
formatted_collection_slo	/slo/collections/:id.:format/	{:action=>"show", :locale=>"slo"}	{:id=>/[^\/.?]+/}
	/mak/collections/:id/	{:action=>"update", :locale=>"mak"}	{:id=>/[^\/.?]+/}
	/collections/:id/	{:action=>"update", :locale=>"eng"}	{:id=>/[^\/.?]+/}
	/srb/collections/:id/	{:action=>"update", :locale=>"srb"}	{:id=>/[^\/.?]+/}
	/cro/collections/:id/	{:action=>"update", :locale=>"cro"}	{:id=>/[^\/.?]+/}
	/slo/collections/:id/	{:action=>"update", :locale=>"slo"}	{:id=>/[^\/.?]+/}
	/mak/collections/:id.:format/	{:action=>"update", :locale=>"mak"}	{:id=>/[^\/.?]+/}
	/collections/:id.:format/	{:action=>"update", :locale=>"eng"}	{:id=>/[^\/.?]+/}
	/srb/collections/:id.:format/	{:action=>"update", :locale=>"srb"}	{:id=>/[^\/.?]+/}
	/cro/collections/:id.:format/	{:action=>"update", :locale=>"cro"}	{:id=>/[^\/.?]+/}
	/slo/collections/:id.:format/	{:action=>"update", :locale=>"slo"}	{:id=>/[^\/.?]+/}
	/mak/collections/:id/	{:action=>"destroy", :locale=>"mak"}	{:id=>/[^\/.?]+/}
	/collections/:id/	{:action=>"destroy", :locale=>"eng"}	{:id=>/[^\/.?]+/}
	/srb/collections/:id/	{:action=>"destroy", :locale=>"srb"}	{:id=>/[^\/.?]+/}
	/cro/collections/:id/	{:action=>"destroy", :locale=>"cro"}	{:id=>/[^\/.?]+/}
	/slo/collections/:id/	{:action=>"destroy", :locale=>"slo"}	{:id=>/[^\/.?]+/}
	/mak/collections/:id.:format/	{:action=>"destroy", :locale=>"mak"}	{:id=>/[^\/.?]+/}
	/collections/:id.:format/	{:action=>"destroy", :locale=>"eng"}	{:id=>/[^\/.?]+/}
	/srb/collections/:id.:format/	{:action=>"destroy", :locale=>"srb"}	{:id=>/[^\/.?]+/}
	/cro/collections/:id.:format/	{:action=>"destroy", :locale=>"cro"}	{:id=>/[^\/.?]+/}
	/slo/collections/:id.:format/	{:action=>"destroy", :locale=>"slo"}	{:id=>/[^\/.?]+/}
	/mak/:controller/:action/	{:locale=>"mak"}	{}
	/:controller/:action/	{:locale=>"eng"}	{}
	/srb/:controller/:action/	{:locale=>"srb"}	{}
	/cro/:controller/:action/	{:locale=>"cro"}	{}
	/slo/:controller/:action/	{:locale=>"slo"}	{}
	/mak/:controller/:action.:format/	{:locale=>"mak"}	{}
	/:controller/:action.:format/	{:locale=>"eng"}	{}
	/srb/:controller/:action.:format/	{:locale=>"srb"}	{}
	/cro/:controller/:action.:format/	{:locale=>"cro"}	{}
	/slo/:controller/:action.:format/	{:locale=>"slo"}	{}
	/mak/:controller/:action/:id/	{:locale=>"mak"}	{}
	/:controller/:action/:id/	{:locale=>"eng"}	{}
	/srb/:controller/:action/:id/	{:locale=>"srb"}	{}
	/cro/:controller/:action/:id/	{:locale=>"cro"}	{}
	/slo/:controller/:action/:id/	{:locale=>"slo"}	{}
	/mak/:controller/:action/:id.:format/	{:locale=>"mak"}	{}
	/:controller/:action/:id.:format/	{:locale=>"eng"}	{}
	/srb/:controller/:action/:id.:format/	{:locale=>"srb"}	{}
	/cro/:controller/:action/:id.:format/	{:locale=>"cro"}	{}
	/slo/:controller/:action/:id.:format/	{:locale=>"slo"}	{}

Env

Key	Value
GATEWAY_INTERFACE	CGI/1.1
HTTP_ACCEPT	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
HTTP_ACCEPT_ENCODING	br,gzip
HTTP_ACCEPT_LANGUAGE	en-US,en;q=0.5
HTTP_CONNECTION	Keep-Alive
HTTP_COOKIE	See cookies on its tab
HTTP_HOST	www.slikicki.com
HTTP_USER_AGENT	CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO	/slo/collections/157-uefa-euro-2012-poland-ukraine
QUERY_STRING
REMOTE_ADDR	44.200.40.195
REMOTE_HOST	44.200.40.195
REMOTE_USER
REQUEST_METHOD	GET
REQUEST_URI	http://www.slikicki.com/slo/collections/157-uefa-euro-2012-poland-ukraine
SERVER_NAME	www.slikicki.com
SERVER_PORT	80
SERVER_PROTOCOL	HTTP/1.1
SERVER_SOFTWARE	WEBrick/1.3.1 (Ruby/1.8.7/2014-01-28)

Queries

SELECT (explain | trace)
Language Load (0.499811s)
SELECT * FROM languages WHERE (is_translated=1) ORDER BY web_priority

Id	Select type	Table	Partitions	Type	Possible keys	Key	Key len	Ref	Rows	Filtered	Extra
1	SIMPLE	languages		ALL					3	33.33	Using where; Using filesort

app/controllers/application.rb:57:in `set_languages'

SELECT (explain | trace)
Language Load (0.000378s)
SELECT * FROM languages WHERE (languages.key = 'slo') LIMIT 1

Id	Select type	Table	Partitions	Type	Possible keys	Key	Key len	Ref	Rows	Filtered	Extra
1	SIMPLE	languages		ALL					3	33.33	Using where

vendor/plugins/will_paginate/lib/will_paginate/finder.rb:164:in `method_missing'
app/controllers/application.rb:48:in `set_locale_from_url'

SELECT (explain | trace)
Collection Load (0.574717s)
SELECT * FROM collections WHERE (collections.id = 157)

Id	Select type	Table	Partitions	Type	Possible keys	Key	Key len	Ref	Rows	Filtered	Extra
1	SIMPLE	collections		const	PRIMARY	PRIMARY	4	const	1	100.00

app/controllers/collections_controller.rb:20:in `show'

SELECT (explain | trace)
ProfileCollection Load (0.564594s)
SELECT * FROM profile_collections WHERE (profile_collections.collection_id = 157)

Id	Select type	Table	Partitions	Type	Possible keys	Key	Key len	Ref	Rows	Filtered	Extra
1	SIMPLE	profile_collections		ref	index_profile_collections_on_collection_id	index_profile_collections_on_collection_id	5	const	254	100.00

vendor/plugins/will_paginate/lib/will_paginate/finder.rb:164:in `method_missing'
app/controllers/collections_controller.rb:21:in `show'

SELECT (explain | trace)
Activity Load (0.562168s)
SELECT * FROM activities WHERE (activitable_type = 'ProfileCollection' and activitable_id in (4198,4200,4209,4223,4225,4230,4241,4253,4285,4287,4289,4295,4302,4303,4304,4305,4306,4308,4309,4310,4314,4317,4319,4320,4321,4322,4325,4326,4332,4334,4337,4338,4339,4340,4341,4342,4343,4344,4345,4347,4349,4350,4351,4353,4354,4357,4358,4359,4360,4363,4364,4365,4366,4369,4371,4372,4378,4381,4384,4390,4392,4395,4396,4397,4398,4400,4401,4402,4405,4407,4408,4409,4411,4412,4413,4414,4415,4416,4417,4418,4419,4420,4422,4423,4424,4425,4427,4429,4430,4431,4433,4435,4437,4439,4443,4447,4449,4451,4452,4453,4454,4455,4456,4457,4458,4459,4461,4463,4465,4467,4472,4473,4474,4477,4479,4480,4481,4482,4484,4488,4494,4496,4497,4498,4499,4500,4501,4504,4505,4506,4509,4510,4512,4514,4516,4522,4524,4525,4526,4527,4530,4532,4535,4537,4538,4541,4544,4545,4546,4547,4549,4552,4553,4554,4555,4556,4557,4561,4562,4565,4572,4573,4574,4583,4584,4586,4588,4593,4594,4596,4597,4599,4600,4601,4603,4605,4606,4607,4608,4610,4613,4614,4617,4619,4620,4621,4622,4629,4634,4637,4642,4643,4645,4646,4650,4652,4654,4655,4656,4657,4658,4659,4660,4661,4662,4664,4665,4666,4668,4669,4671,4675,4677,4679,4680,4681,4682,4683,4684,4688,4689,4691,4692,4697,4700,4703,4705,4706,4712,4715,4721,4725,4727,4728,4730,4735,4736,4771,4807,4818,4964,5046,5194,5308,5341,5398,5472,5497,5692,5775,5805,5881,6089,6109)) ORDER BY created_at DESC LIMIT 3

Id	Select type	Table	Partitions	Type	Possible keys	Key	Key len	Ref	Rows	Filtered	Extra
1	SIMPLE	activities		range	index_activities_on_activitable_id_and_activitable_type	index_activities_on_activitable_id_and_activitable_type	773		11176	100.00	Using index condition; Using filesort

app/controllers/collections_controller.rb:22:in `show'

SELECT (explain | trace)
Comment Load (0.544163s)
SELECT * FROM comments WHERE (comments.commentable_id = 157 AND comments.commentable_type = 'Collection') ORDER BY created_at DESC LIMIT 3

Id	Select type	Table	Partitions	Type	Possible keys	Key	Key len	Ref	Rows	Filtered	Extra
1	SIMPLE	comments		ref	index_comments_on_commentable_id_and_commentable_type	index_comments_on_commentable_id_and_commentable_type	773	const,const	560	100.00	Using index condition; Using filesort

app/controllers/collections_controller.rb:23:in `show'

SELECT (explain | trace)
ProfileCollection Load (0.560145s)
SELECT * FROM profile_collections WHERE (profile_collections.collection_id = 157) ORDER BY updated_at DESC LIMIT 5

Id	Select type	Table	Partitions	Type	Possible keys	Key	Key len	Ref	Rows	Filtered	Extra
1	SIMPLE	profile_collections		ref	index_profile_collections_on_collection_id	index_profile_collections_on_collection_id	5	const	254	100.00	Using index condition; Using filesort

app/controllers/collections_controller.rb:24:in `show'

UPDATE (trace)
Collection Update (0.000616s)
UPDATE collections SET counter = 14940 WHERE id = 157

vendor/plugins/active_scaffold/lib/extensions/unsaved_record.rb:15:in `save'
app/models/collection.rb:152:in `increase_counter'
app/controllers/collections_controller.rb:25:in `show'

SELECT (explain | trace)
Tag Load (0.503867s)
SELECT tags.id, tags.name, COUNT(*) as count FROM tags INNER JOIN taggable_tags ON taggable_tags.tag_id = tags.id INNER JOIN collections ON collections.id = taggable_tags.taggable_id AND taggable_type = 'Collection' WHERE (collections.is_ok = TRUE) GROUP BY tags.name ORDER BY count DESC

Id	Select type	Table	Type	Possible keys	Key	Key len	Ref	Rows	Filtered	Extra
1	SIMPLE	taggable_tags	ALL	index_taggable_tags_on_tag_id,index_taggable_tags_on_taggable_id_and_taggable_type				198	10.00	Using where; Using temporary; Using filesort
1	SIMPLE	tags	eq_ref	PRIMARY	PRIMARY	4	slikicki.taggable_tags.tag_id	1	100.00
1	SIMPLE	collections	eq_ref	PRIMARY	PRIMARY	4	slikicki.taggable_tags.taggable_id	1	10.00	Using where

app/models/tag.rb:30:in `tags'
app/views/shared/_tags.html.erb:12:in `_run_erb_app47views47shared47_tags46html46erb_locals_object_tags'
vendor/plugins/active_scaffold/lib/extensions/action_view_rendering.rb:61:in `render'
app/views/collections/_left_box_collection.html.erb:7:in `_run_erb_app47views47collections47_left_box_collection46html46erb_locals_left_box_collection_object'
vendor/plugins/active_scaffold/lib/extensions/action_view_rendering.rb:61:in `render'
app/views/collections/show.html.erb:3:in `_run_erb_app47views47collections47show46html46erb'
vendor/plugins/active_scaffold/lib/extensions/action_view_rendering.rb:61:in `render'
vendor/plugins/active_scaffold/lib/extensions/action_view_rendering.rb:61:in `render'
vendor/plugins/active_scaffold/lib/extensions/action_controller_rendering.rb:13:in `render'
vendor/plugins/active_scaffold/lib/extensions/action_controller_rendering.rb:13:in `render'

SELECT (explain | trace)
Publisher Load (0.488917s)
SELECT * FROM publishers WHERE (publishers.id = 1)

Id	Select type	Table	Partitions	Type	Possible keys	Key	Key len	Ref	Rows	Filtered	Extra
1	SIMPLE	publishers		const	PRIMARY	PRIMARY	4	const	1	100.00

app/views/collections/show.html.erb:16:in `_run_erb_app47views47collections47show46html46erb'
vendor/plugins/active_scaffold/lib/extensions/action_view_rendering.rb:61:in `render'
vendor/plugins/active_scaffold/lib/extensions/action_view_rendering.rb:61:in `render'
vendor/plugins/active_scaffold/lib/extensions/action_controller_rendering.rb:13:in `render'
vendor/plugins/active_scaffold/lib/extensions/action_controller_rendering.rb:13:in `render'

SELECT (explain | trace)
Profile Load (0.501759s)
SELECT * FROM profiles WHERE (profiles.id = 1)

Id	Select type	Table	Partitions	Type	Possible keys	Key	Key len	Ref	Rows	Filtered	Extra
1	SIMPLE	profiles		const	PRIMARY	PRIMARY	4	const	1	100.00

app/views/collections/show.html.erb:28:in `_run_erb_app47views47collections47show46html46erb'
vendor/plugins/active_scaffold/lib/extensions/action_view_rendering.rb:61:in `render'
vendor/plugins/active_scaffold/lib/extensions/action_view_rendering.rb:61:in `render'
vendor/plugins/active_scaffold/lib/extensions/action_controller_rendering.rb:13:in `render'
vendor/plugins/active_scaffold/lib/extensions/action_controller_rendering.rb:13:in `render'

SELECT (explain | trace)
Profile Load (0.517686s)
SELECT * FROM profiles WHERE (profiles.id = 596)

Id	Select type	Table	Partitions	Type	Possible keys	Key	Key len	Ref	Rows	Filtered	Extra
1	SIMPLE	profiles		const	PRIMARY	PRIMARY	4	const	1	100.00

app/views/collections/show.html.erb:62:in `_run_erb_app47views47collections47show46html46erb'
app/views/collections/show.html.erb:60:in `each'
app/views/collections/show.html.erb:60:in `_run_erb_app47views47collections47show46html46erb'
vendor/plugins/active_scaffold/lib/extensions/action_view_rendering.rb:61:in `render'
vendor/plugins/active_scaffold/lib/extensions/action_view_rendering.rb:61:in `render'
vendor/plugins/active_scaffold/lib/extensions/action_controller_rendering.rb:13:in `render'
vendor/plugins/active_scaffold/lib/extensions/action_controller_rendering.rb:13:in `render'

SELECT (explain | trace)
Profile Load (0.533431s)
SELECT * FROM profiles WHERE (profiles.id = 3812)

Id	Select type	Table	Partitions	Type	Possible keys	Key	Key len	Ref	Rows	Filtered	Extra
1	SIMPLE	profiles		const	PRIMARY	PRIMARY	4	const	1	100.00

SELECT (explain | trace)
Profile Load (0.539209s)
SELECT * FROM profiles WHERE (profiles.id = 902)

Id	Select type	Table	Partitions	Type	Possible keys	Key	Key len	Ref	Rows	Filtered	Extra
1	SIMPLE	profiles		const	PRIMARY	PRIMARY	4	const	1	100.00

SELECT (explain | trace)
Profile Load (0.490555s)
SELECT * FROM profiles WHERE (profiles.id = 2494)

Id	Select type	Table	Partitions	Type	Possible keys	Key	Key len	Ref	Rows	Filtered	Extra
1	SIMPLE	profiles		const	PRIMARY	PRIMARY	4	const	1	100.00

SELECT (explain | trace)
Profile Load (0.637361s)
SELECT * FROM profiles WHERE (profiles.id = 5312)

Id	Select type	Table	Partitions	Type	Possible keys	Key	Key len	Ref	Rows	Filtered	Extra
1	SIMPLE	profiles		const	PRIMARY	PRIMARY	4	const	1	100.00

app/views/collections/show.html.erb:77:in `_run_erb_app47views47collections47show46html46erb'
app/views/collections/show.html.erb:75:in `each'
app/views/collections/show.html.erb:75:in `_run_erb_app47views47collections47show46html46erb'
vendor/plugins/active_scaffold/lib/extensions/action_view_rendering.rb:61:in `render'
vendor/plugins/active_scaffold/lib/extensions/action_view_rendering.rb:61:in `render'
vendor/plugins/active_scaffold/lib/extensions/action_controller_rendering.rb:13:in `render'
vendor/plugins/active_scaffold/lib/extensions/action_controller_rendering.rb:13:in `render'

SELECT (explain | trace)
Profile Load (0.569865s)
SELECT * FROM profiles WHERE (profiles.id = 2659)

Id	Select type	Table	Partitions	Type	Possible keys	Key	Key len	Ref	Rows	Filtered	Extra
1	SIMPLE	profiles		const	PRIMARY	PRIMARY	4	const	1	100.00

SELECT (explain | trace)
Profile Load (0.534844s)
SELECT * FROM profiles WHERE (profiles.id = 2613)

Id	Select type	Table	Partitions	Type	Possible keys	Key	Key len	Ref	Rows	Filtered	Extra
1	SIMPLE	profiles		const	PRIMARY	PRIMARY	4	const	1	100.00

SELECT (explain | trace)
ProfileCollection Load (0.494552s)
SELECT * FROM profile_collections WHERE (profile_collections.id = 4334)

Id	Select type	Table	Partitions	Type	Possible keys	Key	Key len	Ref	Rows	Filtered	Extra
1	SIMPLE	profile_collections		const	PRIMARY	PRIMARY	4	const	1	100.00

app/helpers/activities_helper.rb:9:in `get_activitable'
app/views/collections/show.html.erb:109:in `_run_erb_app47views47collections47show46html46erb'
vendor/plugins/translate_routes/lib/translate_routes.rb:204:in `each_with_index'
app/views/collections/show.html.erb:104:in `each'
app/views/collections/show.html.erb:104:in `each_with_index'
app/views/collections/show.html.erb:104:in `_run_erb_app47views47collections47show46html46erb'
vendor/plugins/active_scaffold/lib/extensions/action_view_rendering.rb:61:in `render'
vendor/plugins/active_scaffold/lib/extensions/action_view_rendering.rb:61:in `render'
vendor/plugins/active_scaffold/lib/extensions/action_controller_rendering.rb:13:in `render'
vendor/plugins/active_scaffold/lib/extensions/action_controller_rendering.rb:13:in `render'

SELECT (explain | trace)
Collection Load (0.482905s)
SELECT * FROM collections WHERE (collections.id = 157)

Id	Select type	Table	Partitions	Type	Possible keys	Key	Key len	Ref	Rows	Filtered	Extra
1	SIMPLE	collections		const	PRIMARY	PRIMARY	4	const	1	100.00

SELECT (explain | trace)
ProfileCollection Load (0.550938s)
SELECT * FROM profile_collections WHERE (profile_collections.id = 6109)

Id	Select type	Table	Partitions	Type	Possible keys	Key	Key len	Ref	Rows	Filtered	Extra
1	SIMPLE	profile_collections		const	PRIMARY	PRIMARY	4	const	1	100.00

app/helpers/activities_helper.rb:8:in `get_activitable'
app/views/collections/show.html.erb:109:in `_run_erb_app47views47collections47show46html46erb'
vendor/plugins/translate_routes/lib/translate_routes.rb:204:in `each_with_index'
app/views/collections/show.html.erb:104:in `each'
app/views/collections/show.html.erb:104:in `each_with_index'
app/views/collections/show.html.erb:104:in `_run_erb_app47views47collections47show46html46erb'
vendor/plugins/active_scaffold/lib/extensions/action_view_rendering.rb:61:in `render'
vendor/plugins/active_scaffold/lib/extensions/action_view_rendering.rb:61:in `render'
vendor/plugins/active_scaffold/lib/extensions/action_controller_rendering.rb:13:in `render'
vendor/plugins/active_scaffold/lib/extensions/action_controller_rendering.rb:13:in `render'

SELECT (explain | trace)
ProfileCollection Load (0.508052s)
SELECT * FROM profile_collections WHERE (profile_collections.id = 4198)

Id	Select type	Table	Partitions	Type	Possible keys	Key	Key len	Ref	Rows	Filtered	Extra
1	SIMPLE	profile_collections		const	PRIMARY	PRIMARY	4	const	1	100.00

General (id="general_debug_info")

You can use this tab to debug other parts of your application, for example Javascript.