Slikicki.com > Collections > UEFA EURO 2016 France

Session

{:flash=>{}, :csrf_id=>"c1617f5556c077ae634e852874e85240"}

{}

Params

{:locale=>"mak", :action=>"show", :controller=>"collections", :id=>"267-uefa-euro-2016-france"}

Filter chain for CollectionsController

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

Routes for CollectionsController

Path	Name	Options	Requirements
search_collections_eng	/collections/search/	{:action=>"index", :locale=>"eng", :t=>"search"}	{}
search_collections_mak	/mak/collections/search/	{:action=>"index", :locale=>"mak", :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_eng	/collections/tag/:v/	{:action=>"index", :locale=>"eng", :t=>"tag"}	{}
tag_collections_mak	/mak/collections/tag/:v/	{:action=>"index", :locale=>"mak", :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_eng	/collections/publisher/:v/	{:action=>"index", :locale=>"eng", :t=>"publisher"}	{}
publisher_collections_mak	/mak/collections/publisher/:v/	{:action=>"index", :locale=>"mak", :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_eng	/collections/newest/	{:action=>"index", :locale=>"eng"}	{}
newest_collections_mak	/mak/collections/newest/	{:action=>"index", :locale=>"mak"}	{}
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_eng	/collections/recent/	{:action=>"index", :locale=>"eng", :s=>"recent"}	{}
recent_collections_mak	/mak/collections/recent/	{:action=>"index", :locale=>"mak", :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_eng	/collections/most_discussed/	{:action=>"index", :locale=>"eng", :s=>"most_discussed"}	{}
most_discussed_collections_mak	/mak/collections/most_discussed/	{:action=>"index", :locale=>"mak", :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_eng	/collections/most_users/	{:action=>"index", :locale=>"eng", :s=>"most_users"}	{}
most_users_collections_mak	/mak/collections/most_users/	{:action=>"index", :locale=>"mak", :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_eng	/collections/offer_and_req/	{:action=>"index", :locale=>"eng", :s=>"offers_and_req"}	{}
offers_and_req_collections_mak	/mak/collections/offer_and_req/	{:action=>"index", :locale=>"mak", :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_eng	/collections/auto_search/	{:action=>"auto_search", :locale=>"eng"}	{}
auto_search_collections_mak	/mak/collections/auto_search/	{:action=>"auto_search", :locale=>"mak"}	{}
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_eng	/collections/auto_search.:format/	{:action=>"auto_search", :locale=>"eng"}	{}
formatted_auto_search_collections_mak	/mak/collections/auto_search.:format/	{:action=>"auto_search", :locale=>"mak"}	{}
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_eng	/collections/	{:action=>"index", :locale=>"eng"}	{}
collections_mak	/mak/collections/	{:action=>"index", :locale=>"mak"}	{}
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_eng	/collections.:format/	{:action=>"index", :locale=>"eng"}	{}
formatted_collections_mak	/mak/collections.:format/	{:action=>"index", :locale=>"mak"}	{}
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"}	{}
	/collections/	{:action=>"create", :locale=>"eng"}	{}
	/mak/collections/	{:action=>"create", :locale=>"mak"}	{}
	/srb/collections/	{:action=>"create", :locale=>"srb"}	{}
	/cro/collections/	{:action=>"create", :locale=>"cro"}	{}
	/slo/collections/	{:action=>"create", :locale=>"slo"}	{}
	/collections.:format/	{:action=>"create", :locale=>"eng"}	{}
	/mak/collections.:format/	{:action=>"create", :locale=>"mak"}	{}
	/srb/collections.:format/	{:action=>"create", :locale=>"srb"}	{}
	/cro/collections.:format/	{:action=>"create", :locale=>"cro"}	{}
	/slo/collections.:format/	{:action=>"create", :locale=>"slo"}	{}
new_collection_eng	/collections/new/	{:action=>"new", :locale=>"eng"}	{}
new_collection_mak	/mak/collections/new/	{:action=>"new", :locale=>"mak"}	{}
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_eng	/collections/new.:format/	{:action=>"new", :locale=>"eng"}	{}
formatted_new_collection_mak	/mak/collections/new.:format/	{:action=>"new", :locale=>"mak"}	{}
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_eng	/collections/:id/edit/	{:action=>"edit", :locale=>"eng"}	{:id=>/[^\/.?]+/}
edit_collection_mak	/mak/collections/:id/edit/	{:action=>"edit", :locale=>"mak"}	{: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_eng	/collections/:id/edit.:format/	{:action=>"edit", :locale=>"eng"}	{:id=>/[^\/.?]+/}
formatted_edit_collection_mak	/mak/collections/:id/edit.:format/	{:action=>"edit", :locale=>"mak"}	{: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_eng	/collections/:id/stickers/	{:action=>"stickers", :locale=>"eng"}	{}
stickers_collection_mak	/mak/collections/:id/stickers/	{:action=>"stickers", :locale=>"mak"}	{}
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_eng	/collections/:id/stickers.:format/	{:action=>"stickers", :locale=>"eng"}	{}
formatted_stickers_collection_mak	/mak/collections/:id/stickers.:format/	{:action=>"stickers", :locale=>"mak"}	{}
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_eng	/collections/:id/	{:action=>"show", :locale=>"eng"}	{:id=>/[^\/.?]+/}
collection_mak	/mak/collections/:id/	{:action=>"show", :locale=>"mak"}	{: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_eng	/collections/:id.:format/	{:action=>"show", :locale=>"eng"}	{:id=>/[^\/.?]+/}
formatted_collection_mak	/mak/collections/:id.:format/	{:action=>"show", :locale=>"mak"}	{: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=>/[^\/.?]+/}
	/collections/:id/	{:action=>"update", :locale=>"eng"}	{:id=>/[^\/.?]+/}
	/mak/collections/:id/	{:action=>"update", :locale=>"mak"}	{: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=>/[^\/.?]+/}
	/collections/:id.:format/	{:action=>"update", :locale=>"eng"}	{:id=>/[^\/.?]+/}
	/mak/collections/:id.:format/	{:action=>"update", :locale=>"mak"}	{: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=>/[^\/.?]+/}
	/collections/:id/	{:action=>"destroy", :locale=>"eng"}	{:id=>/[^\/.?]+/}
	/mak/collections/:id/	{:action=>"destroy", :locale=>"mak"}	{: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=>/[^\/.?]+/}
	/collections/:id.:format/	{:action=>"destroy", :locale=>"eng"}	{:id=>/[^\/.?]+/}
	/mak/collections/:id.:format/	{:action=>"destroy", :locale=>"mak"}	{: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=>/[^\/.?]+/}
	/:controller/:action/	{:locale=>"eng"}	{}
	/mak/:controller/:action/	{:locale=>"mak"}	{}
	/srb/:controller/:action/	{:locale=>"srb"}	{}
	/cro/:controller/:action/	{:locale=>"cro"}	{}
	/slo/:controller/:action/	{:locale=>"slo"}	{}
	/:controller/:action.:format/	{:locale=>"eng"}	{}
	/mak/:controller/:action.:format/	{:locale=>"mak"}	{}
	/srb/:controller/:action.:format/	{:locale=>"srb"}	{}
	/cro/:controller/:action.:format/	{:locale=>"cro"}	{}
	/slo/:controller/:action.:format/	{:locale=>"slo"}	{}
	/:controller/:action/:id/	{:locale=>"eng"}	{}
	/mak/:controller/:action/:id/	{:locale=>"mak"}	{}
	/srb/:controller/:action/:id/	{:locale=>"srb"}	{}
	/cro/:controller/:action/:id/	{:locale=>"cro"}	{}
	/slo/:controller/:action/:id/	{:locale=>"slo"}	{}
	/:controller/:action/:id.:format/	{:locale=>"eng"}	{}
	/mak/:controller/:action/:id.:format/	{:locale=>"mak"}	{}
	/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	/mak/collections/267-uefa-euro-2016-france
QUERY_STRING
REMOTE_ADDR	18.207.157.152
REMOTE_HOST	18.207.157.152
REMOTE_USER
REQUEST_METHOD	GET
REQUEST_URI	http://www.slikicki.com/mak/collections/267-uefa-euro-2016-france
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.499701s)
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.000326s)
SELECT * FROM languages WHERE (languages.key = 'mak') 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.000440s)
SELECT * FROM collections WHERE (collections.id = 267)

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.001494s)
SELECT * FROM profile_collections WHERE (profile_collections.collection_id = 267)

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	124	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.015926s)
SELECT * FROM activities WHERE (activitable_type = 'ProfileCollection' and activitable_id in (5973,5974,5975,5976,5977,5978,5979,5980,5981,5982,5983,5985,5986,5987,5988,5989,5990,5991,5992,5993,5994,5996,5997,5998,6000,6001,6002,6003,6004,6005,6006,6007,6010,6011,6012,6013,6014,6016,6018,6019,6020,6021,6022,6025,6028,6029,6031,6033,6035,6040,6041,6042,6045,6051,6053,6056,6057,6058,6060,6061,6062,6063,6066,6068,6070,6071,6074,6075,6076,6077,6078,6079,6083,6090,6091,6092,6093,6095,6097,6098,6099,6100,6102,6103,6105,6111,6114,6117,6122,6125,6126,6136,6141,6143,6144,6146,6147,6148,6149,6150,6151,6154,6157,6159,6164,6165,6166,6167,6169,6170,6173,6174,6175,6177,6178,6179,6180,6184,6186,6192,6260,6289,6393,6455)) 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		2991	100.00	Using index condition; Using filesort

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

SELECT (explain | trace)
Comment Load (0.000598s)
SELECT * FROM comments WHERE (comments.commentable_id = 267 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	47	100.00	Using index condition; Using filesort

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

SELECT (explain | trace)
ProfileCollection Load (0.000493s)
SELECT * FROM profile_collections WHERE (profile_collections.collection_id = 267) 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	124	100.00	Using index condition; Using filesort

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

UPDATE (trace)
Collection Update (0.000361s)
UPDATE collections SET counter = 5102 WHERE id = 267

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.001435s)
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.000284s)
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.368658s)
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.371247s)
SELECT * FROM profiles WHERE (profiles.id = 5978)

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.372434s)
SELECT * FROM profiles WHERE (profiles.id = 6003)

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.363276s)
SELECT * FROM profiles WHERE (profiles.id = 4646)

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.361517s)
SELECT * FROM profiles WHERE (profiles.id = 1133)

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.366359s)
SELECT * FROM profiles WHERE (profiles.id = 2721)

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.383996s)
SELECT * FROM profiles WHERE (profiles.id = 2256)

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.367105s)
SELECT * FROM profiles WHERE (profiles.id = 5790)

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.358899s)
SELECT * FROM profile_collections WHERE (profile_collections.id = 6455)

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.363963s)
SELECT * FROM collections WHERE (collections.id = 267)

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

General (id="general_debug_info")

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