Slikicki.com > Collections > FIFA World Cup

Session

{:flash=>{}, :csrf_id=>"386045f252735c50127ea9e15cc422b5"}

{}

Params

{:locale=>"slo", :action=>"show", :controller=>"collections", :id=>"279-fifa-world-cup-russia-2018"}

Filter chain for CollectionsController

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

Routes for CollectionsController

Path	Name	Options	Requirements
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"}	{}
search_collections_eng	/collections/search/	{:action=>"index", :locale=>"eng", :t=>"search"}	{}
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"}	{}
tag_collections_eng	/collections/tag/:v/	{:action=>"index", :locale=>"eng", :t=>"tag"}	{}
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"}	{}
publisher_collections_eng	/collections/publisher/:v/	{:action=>"index", :locale=>"eng", :t=>"publisher"}	{}
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"}	{}
newest_collections_eng	/collections/newest/	{:action=>"index", :locale=>"eng"}	{}
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"}	{}
recent_collections_eng	/collections/recent/	{:action=>"index", :locale=>"eng", :s=>"recent"}	{}
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_discussed_collections_eng	/collections/most_discussed/	{:action=>"index", :locale=>"eng", :s=>"most_discussed"}	{}
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"}	{}
most_users_collections_eng	/collections/most_users/	{:action=>"index", :locale=>"eng", :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_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"}	{}
offers_and_req_collections_eng	/collections/offer_and_req/	{:action=>"index", :locale=>"eng", :s=>"offers_and_req"}	{}
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"}	{}
auto_search_collections_eng	/collections/auto_search/	{: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"}	{}
formatted_auto_search_collections_eng	/collections/auto_search.:format/	{:action=>"auto_search", :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"}	{}
collections_eng	/collections/	{: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"}	{}
formatted_collections_eng	/collections.:format/	{:action=>"index", :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/	{: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"}	{}
	/collections.:format/	{:action=>"create", :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"}	{}
new_collection_eng	/collections/new/	{: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"}	{}
formatted_new_collection_eng	/collections/new.:format/	{:action=>"new", :locale=>"eng"}	{}
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=>/[^\/.?]+/}
edit_collection_eng	/collections/:id/edit/	{: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=>/[^\/.?]+/}
formatted_edit_collection_eng	/collections/:id/edit.:format/	{:action=>"edit", :locale=>"eng"}	{:id=>/[^\/.?]+/}
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"}	{}
stickers_collection_eng	/collections/:id/stickers/	{: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"}	{}
formatted_stickers_collection_eng	/collections/:id/stickers.:format/	{:action=>"stickers", :locale=>"eng"}	{}
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=>/[^\/.?]+/}
collection_eng	/collections/:id/	{: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=>/[^\/.?]+/}
formatted_collection_eng	/collections/:id.:format/	{:action=>"show", :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/	{: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.:format/	{:action=>"update", :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/	{: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=>/[^\/.?]+/}
	/collections/:id.:format/	{:action=>"destroy", :locale=>"eng"}	{:id=>/[^\/.?]+/}
	/mak/:controller/:action/	{:locale=>"mak"}	{}
	/srb/:controller/:action/	{:locale=>"srb"}	{}
	/cro/:controller/:action/	{:locale=>"cro"}	{}
	/slo/:controller/:action/	{:locale=>"slo"}	{}
	/:controller/:action/	{: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.:format/	{: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/	{: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"}	{}
	/:controller/:action/:id.:format/	{:locale=>"eng"}	{}

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/279-fifa-world-cup-russia-2018
QUERY_STRING
REMOTE_ADDR	54.80.252.84
REMOTE_HOST	54.80.252.84
REMOTE_USER
REQUEST_METHOD	GET
REQUEST_URI	http://www.slikicki.com/slo/collections/279-fifa-world-cup-russia-2018
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.000980s)
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.415592s)
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.000607s)
SELECT * FROM collections WHERE (collections.id = 279)

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

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	162	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.018640s)
SELECT * FROM activities WHERE (activitable_type = 'ProfileCollection' and activitable_id in (6211,6212,6213,6214,6215,6216,6218,6219,6220,6221,6222,6223,6224,6225,6226,6228,6229,6230,6231,6232,6233,6234,6235,6239,6240,6241,6242,6243,6244,6245,6246,6247,6248,6249,6250,6251,6252,6254,6255,6256,6257,6258,6259,6261,6262,6263,6264,6265,6266,6267,6268,6269,6270,6271,6272,6273,6275,6277,6279,6280,6281,6282,6283,6284,6285,6287,6288,6290,6294,6295,6296,6297,6298,6299,6300,6301,6302,6304,6308,6309,6310,6312,6313,6314,6315,6316,6317,6319,6320,6321,6322,6323,6324,6326,6328,6330,6331,6332,6333,6336,6337,6339,6340,6341,6342,6344,6345,6346,6347,6348,6349,6351,6352,6353,6354,6357,6358,6359,6360,6361,6362,6364,6365,6366,6367,6368,6369,6370,6371,6372,6374,6376,6377,6380,6381,6382,6383,6384,6385,6388,6389,6390,6391,6392,6394,6395,6396,6397,6398,6399,6400,6401,6402,6403,6404,6407,6408,6410,6411,6412,6413,6416)) 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		3182	100.00	Using index condition; Using filesort

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

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

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

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

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

UPDATE (trace)
Collection Update (0.000559s)
UPDATE collections SET counter = 5510 WHERE id = 279

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.002185s)
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.405201s)
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.320930s)
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.316646s)
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.322202s)
SELECT * FROM profiles WHERE (profiles.id = 270)

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

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

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

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

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

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

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

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

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.

FIFA World Cup - Russia 2018