UEFA EURO 2016 France

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

{}

{:action=>"index", :locale=>"eng", :collection_id=>"267-uefa-euro-2016-france", :controller=>"profiles"}

Name	Type	Actions
Footnotes::Filter	:before	[:index, :update, :edit, :my, :auto_complete_for_city_name, :rate, :show]
:assign_current_user_to_models	:before	[:index, :update, :edit, :my, :auto_complete_for_city_name, :rate, :show]
:handle_user_settings	:before	[:index, :update, :edit, :my, :auto_complete_for_city_name, :rate, :show]
:verify_authenticity_token	:before	[:update]
:get_profile	:before	[:index, :update, :edit, :my, :auto_complete_for_city_name, :rate, :show]
:set_user_time_zone	:before	[:index, :update, :edit, :my, :auto_complete_for_city_name, :rate, :show]
:set_languages	:before	[:index, :update, :edit, :my, :auto_complete_for_city_name, :rate, :show]
:set_unread_messages	:before	[:index, :update, :edit, :my, :auto_complete_for_city_name, :rate, :show]
:set_locale_from_url	:before	[:index, :update, :edit, :my, :auto_complete_for_city_name, :rate, :show]
:login_required	:before	[:update, :edit, :my, :auto_complete_for_city_name, :rate, :show]
:set_main_photo	:before	[:index]
:set_main_photo_details	:before	[:update, :edit, :my, :auto_complete_for_city_name, :rate, :show]
Footnotes::Filter	:after	[:index, :update, :edit, :my, :auto_complete_for_city_name, :rate, :show]

Path	Name	Options	Requirements
community_mak	/mak/community/	{:action=>"index", :locale=>"mak"}	{}
community_eng	/community/	{:action=>"index", :locale=>"eng"}	{}
community_srb	/srb/community/	{:action=>"index", :locale=>"srb"}	{}
community_cro	/cro/community/	{:action=>"index", :locale=>"cro"}	{}
community_slo	/slo/community/	{:action=>"index", :locale=>"slo"}	{}
newest_profiles_mak	/mak/profiles/newest/	{:action=>"index", :locale=>"mak"}	{}
newest_profiles_eng	/profiles/newest/	{:action=>"index", :locale=>"eng"}	{}
newest_profiles_srb	/srb/profiles/newest/	{:action=>"index", :locale=>"srb"}	{}
newest_profiles_cro	/cro/profiles/newest/	{:action=>"index", :locale=>"cro"}	{}
newest_profiles_slo	/slo/profiles/newest/	{:action=>"index", :locale=>"slo"}	{}
albums_profiles_mak	/mak/profiles/albums/	{:action=>"index", :locale=>"mak", :t=>"albums"}	{}
albums_profiles_eng	/profiles/albums/	{:action=>"index", :locale=>"eng", :t=>"albums"}	{}
albums_profiles_srb	/srb/profiles/albums/	{:action=>"index", :locale=>"srb", :t=>"albums"}	{}
albums_profiles_cro	/cro/profiles/albums/	{:action=>"index", :locale=>"cro", :t=>"albums"}	{}
albums_profiles_slo	/slo/profiles/albums/	{:action=>"index", :locale=>"slo", :t=>"albums"}	{}
duplicates_profiles_mak	/mak/profiles/duplicates/	{:action=>"index", :locale=>"mak", :t=>"duplicates"}	{}
duplicates_profiles_eng	/profiles/duplicates/	{:action=>"index", :locale=>"eng", :t=>"duplicates"}	{}
duplicates_profiles_srb	/srb/profiles/duplicates/	{:action=>"index", :locale=>"srb", :t=>"duplicates"}	{}
duplicates_profiles_cro	/cro/profiles/duplicates/	{:action=>"index", :locale=>"cro", :t=>"duplicates"}	{}
duplicates_profiles_slo	/slo/profiles/duplicates/	{:action=>"index", :locale=>"slo", :t=>"duplicates"}	{}
missing_profiles_mak	/mak/profiles/missing/	{:action=>"index", :locale=>"mak", :t=>"missing"}	{}
missing_profiles_eng	/profiles/missing/	{:action=>"index", :locale=>"eng", :t=>"missing"}	{}
missing_profiles_srb	/srb/profiles/missing/	{:action=>"index", :locale=>"srb", :t=>"missing"}	{}
missing_profiles_cro	/cro/profiles/missing/	{:action=>"index", :locale=>"cro", :t=>"missing"}	{}
missing_profiles_slo	/slo/profiles/missing/	{:action=>"index", :locale=>"slo", :t=>"missing"}	{}
last_login_profiles_mak	/mak/profiles/last_login/	{:action=>"index", :locale=>"mak", :t=>"last_login"}	{}
last_login_profiles_eng	/profiles/last_login/	{:action=>"index", :locale=>"eng", :t=>"last_login"}	{}
last_login_profiles_srb	/srb/profiles/last_login/	{:action=>"index", :locale=>"srb", :t=>"last_login"}	{}
last_login_profiles_cro	/cro/profiles/last_login/	{:action=>"index", :locale=>"cro", :t=>"last_login"}	{}
last_login_profiles_slo	/slo/profiles/last_login/	{:action=>"index", :locale=>"slo", :t=>"last_login"}	{}
last_activity_profiles_mak	/mak/profiles/last_activity/	{:action=>"index", :locale=>"mak", :t=>"last_activity"}	{}
last_activity_profiles_eng	/profiles/last_activity/	{:action=>"index", :locale=>"eng", :t=>"last_activity"}	{}
last_activity_profiles_srb	/srb/profiles/last_activity/	{:action=>"index", :locale=>"srb", :t=>"last_activity"}	{}
last_activity_profiles_cro	/cro/profiles/last_activity/	{:action=>"index", :locale=>"cro", :t=>"last_activity"}	{}
last_activity_profiles_slo	/slo/profiles/last_activity/	{:action=>"index", :locale=>"slo", :t=>"last_activity"}	{}
auto_search_profiles_mak	/mak/profiles/auto_search/	{:action=>"auto_search", :locale=>"mak"}	{}
auto_search_profiles_eng	/profiles/auto_search/	{:action=>"auto_search", :locale=>"eng"}	{}
auto_search_profiles_srb	/srb/profiles/auto_search/	{:action=>"auto_search", :locale=>"srb"}	{}
auto_search_profiles_cro	/cro/profiles/auto_search/	{:action=>"auto_search", :locale=>"cro"}	{}
auto_search_profiles_slo	/slo/profiles/auto_search/	{:action=>"auto_search", :locale=>"slo"}	{}
formatted_auto_search_profiles_mak	/mak/profiles/auto_search.:format/	{:action=>"auto_search", :locale=>"mak"}	{}
formatted_auto_search_profiles_eng	/profiles/auto_search.:format/	{:action=>"auto_search", :locale=>"eng"}	{}
formatted_auto_search_profiles_srb	/srb/profiles/auto_search.:format/	{:action=>"auto_search", :locale=>"srb"}	{}
formatted_auto_search_profiles_cro	/cro/profiles/auto_search.:format/	{:action=>"auto_search", :locale=>"cro"}	{}
formatted_auto_search_profiles_slo	/slo/profiles/auto_search.:format/	{:action=>"auto_search", :locale=>"slo"}	{}
my_profiles_mak	/mak/profiles/my/	{:action=>"my", :locale=>"mak"}	{}
my_profiles_eng	/profiles/my/	{:action=>"my", :locale=>"eng"}	{}
my_profiles_srb	/srb/profiles/my/	{:action=>"my", :locale=>"srb"}	{}
my_profiles_cro	/cro/profiles/my/	{:action=>"my", :locale=>"cro"}	{}
my_profiles_slo	/slo/profiles/my/	{:action=>"my", :locale=>"slo"}	{}
formatted_my_profiles_mak	/mak/profiles/my.:format/	{:action=>"my", :locale=>"mak"}	{}
formatted_my_profiles_eng	/profiles/my.:format/	{:action=>"my", :locale=>"eng"}	{}
formatted_my_profiles_srb	/srb/profiles/my.:format/	{:action=>"my", :locale=>"srb"}	{}
formatted_my_profiles_cro	/cro/profiles/my.:format/	{:action=>"my", :locale=>"cro"}	{}
formatted_my_profiles_slo	/slo/profiles/my.:format/	{:action=>"my", :locale=>"slo"}	{}
profiles_mak	/mak/profiles/	{:action=>"index", :locale=>"mak"}	{}
profiles_eng	/profiles/	{:action=>"index", :locale=>"eng"}	{}
profiles_srb	/srb/profiles/	{:action=>"index", :locale=>"srb"}	{}
profiles_cro	/cro/profiles/	{:action=>"index", :locale=>"cro"}	{}
profiles_slo	/slo/profiles/	{:action=>"index", :locale=>"slo"}	{}
formatted_profiles_mak	/mak/profiles.:format/	{:action=>"index", :locale=>"mak"}	{}
formatted_profiles_eng	/profiles.:format/	{:action=>"index", :locale=>"eng"}	{}
formatted_profiles_srb	/srb/profiles.:format/	{:action=>"index", :locale=>"srb"}	{}
formatted_profiles_cro	/cro/profiles.:format/	{:action=>"index", :locale=>"cro"}	{}
formatted_profiles_slo	/slo/profiles.:format/	{:action=>"index", :locale=>"slo"}	{}
	/mak/profiles/	{:action=>"create", :locale=>"mak"}	{}
	/profiles/	{:action=>"create", :locale=>"eng"}	{}
	/srb/profiles/	{:action=>"create", :locale=>"srb"}	{}
	/cro/profiles/	{:action=>"create", :locale=>"cro"}	{}
	/slo/profiles/	{:action=>"create", :locale=>"slo"}	{}
	/mak/profiles.:format/	{:action=>"create", :locale=>"mak"}	{}
	/profiles.:format/	{:action=>"create", :locale=>"eng"}	{}
	/srb/profiles.:format/	{:action=>"create", :locale=>"srb"}	{}
	/cro/profiles.:format/	{:action=>"create", :locale=>"cro"}	{}
	/slo/profiles.:format/	{:action=>"create", :locale=>"slo"}	{}
new_profile_mak	/mak/profiles/new/	{:action=>"new", :locale=>"mak"}	{}
new_profile_eng	/profiles/new/	{:action=>"new", :locale=>"eng"}	{}
new_profile_srb	/srb/profiles/new/	{:action=>"new", :locale=>"srb"}	{}
new_profile_cro	/cro/profiles/new/	{:action=>"new", :locale=>"cro"}	{}
new_profile_slo	/slo/profiles/new/	{:action=>"new", :locale=>"slo"}	{}
formatted_new_profile_mak	/mak/profiles/new.:format/	{:action=>"new", :locale=>"mak"}	{}
formatted_new_profile_eng	/profiles/new.:format/	{:action=>"new", :locale=>"eng"}	{}
formatted_new_profile_srb	/srb/profiles/new.:format/	{:action=>"new", :locale=>"srb"}	{}
formatted_new_profile_cro	/cro/profiles/new.:format/	{:action=>"new", :locale=>"cro"}	{}
formatted_new_profile_slo	/slo/profiles/new.:format/	{:action=>"new", :locale=>"slo"}	{}
edit_profile_mak	/mak/profiles/:id/edit/	{:action=>"edit", :locale=>"mak"}	{:id=>/[^\/.?]+/}
edit_profile_eng	/profiles/:id/edit/	{:action=>"edit", :locale=>"eng"}	{:id=>/[^\/.?]+/}
edit_profile_srb	/srb/profiles/:id/edit/	{:action=>"edit", :locale=>"srb"}	{:id=>/[^\/.?]+/}
edit_profile_cro	/cro/profiles/:id/edit/	{:action=>"edit", :locale=>"cro"}	{:id=>/[^\/.?]+/}
edit_profile_slo	/slo/profiles/:id/edit/	{:action=>"edit", :locale=>"slo"}	{:id=>/[^\/.?]+/}
formatted_edit_profile_mak	/mak/profiles/:id/edit.:format/	{:action=>"edit", :locale=>"mak"}	{:id=>/[^\/.?]+/}
formatted_edit_profile_eng	/profiles/:id/edit.:format/	{:action=>"edit", :locale=>"eng"}	{:id=>/[^\/.?]+/}
formatted_edit_profile_srb	/srb/profiles/:id/edit.:format/	{:action=>"edit", :locale=>"srb"}	{:id=>/[^\/.?]+/}
formatted_edit_profile_cro	/cro/profiles/:id/edit.:format/	{:action=>"edit", :locale=>"cro"}	{:id=>/[^\/.?]+/}
formatted_edit_profile_slo	/slo/profiles/:id/edit.:format/	{:action=>"edit", :locale=>"slo"}	{:id=>/[^\/.?]+/}
rate_profile_mak	/mak/profiles/:id/rate/	{:action=>"rate", :locale=>"mak"}	{}
rate_profile_eng	/profiles/:id/rate/	{:action=>"rate", :locale=>"eng"}	{}
rate_profile_srb	/srb/profiles/:id/rate/	{:action=>"rate", :locale=>"srb"}	{}
rate_profile_cro	/cro/profiles/:id/rate/	{:action=>"rate", :locale=>"cro"}	{}
rate_profile_slo	/slo/profiles/:id/rate/	{:action=>"rate", :locale=>"slo"}	{}
formatted_rate_profile_mak	/mak/profiles/:id/rate.:format/	{:action=>"rate", :locale=>"mak"}	{}
formatted_rate_profile_eng	/profiles/:id/rate.:format/	{:action=>"rate", :locale=>"eng"}	{}
formatted_rate_profile_srb	/srb/profiles/:id/rate.:format/	{:action=>"rate", :locale=>"srb"}	{}
formatted_rate_profile_cro	/cro/profiles/:id/rate.:format/	{:action=>"rate", :locale=>"cro"}	{}
formatted_rate_profile_slo	/slo/profiles/:id/rate.:format/	{:action=>"rate", :locale=>"slo"}	{}
profile_mak	/mak/profiles/:id/	{:action=>"show", :locale=>"mak"}	{:id=>/[^\/.?]+/}
profile_eng	/profiles/:id/	{:action=>"show", :locale=>"eng"}	{:id=>/[^\/.?]+/}
profile_srb	/srb/profiles/:id/	{:action=>"show", :locale=>"srb"}	{:id=>/[^\/.?]+/}
profile_cro	/cro/profiles/:id/	{:action=>"show", :locale=>"cro"}	{:id=>/[^\/.?]+/}
profile_slo	/slo/profiles/:id/	{:action=>"show", :locale=>"slo"}	{:id=>/[^\/.?]+/}
formatted_profile_mak	/mak/profiles/:id.:format/	{:action=>"show", :locale=>"mak"}	{:id=>/[^\/.?]+/}
formatted_profile_eng	/profiles/:id.:format/	{:action=>"show", :locale=>"eng"}	{:id=>/[^\/.?]+/}
formatted_profile_srb	/srb/profiles/:id.:format/	{:action=>"show", :locale=>"srb"}	{:id=>/[^\/.?]+/}
formatted_profile_cro	/cro/profiles/:id.:format/	{:action=>"show", :locale=>"cro"}	{:id=>/[^\/.?]+/}
formatted_profile_slo	/slo/profiles/:id.:format/	{:action=>"show", :locale=>"slo"}	{:id=>/[^\/.?]+/}
	/mak/profiles/:id/	{:action=>"update", :locale=>"mak"}	{:id=>/[^\/.?]+/}
	/profiles/:id/	{:action=>"update", :locale=>"eng"}	{:id=>/[^\/.?]+/}
	/srb/profiles/:id/	{:action=>"update", :locale=>"srb"}	{:id=>/[^\/.?]+/}
	/cro/profiles/:id/	{:action=>"update", :locale=>"cro"}	{:id=>/[^\/.?]+/}
	/slo/profiles/:id/	{:action=>"update", :locale=>"slo"}	{:id=>/[^\/.?]+/}
	/mak/profiles/:id.:format/	{:action=>"update", :locale=>"mak"}	{:id=>/[^\/.?]+/}
	/profiles/:id.:format/	{:action=>"update", :locale=>"eng"}	{:id=>/[^\/.?]+/}
	/srb/profiles/:id.:format/	{:action=>"update", :locale=>"srb"}	{:id=>/[^\/.?]+/}
	/cro/profiles/:id.:format/	{:action=>"update", :locale=>"cro"}	{:id=>/[^\/.?]+/}
	/slo/profiles/:id.:format/	{:action=>"update", :locale=>"slo"}	{:id=>/[^\/.?]+/}
	/mak/profiles/:id/	{:action=>"destroy", :locale=>"mak"}	{:id=>/[^\/.?]+/}
	/profiles/:id/	{:action=>"destroy", :locale=>"eng"}	{:id=>/[^\/.?]+/}
	/srb/profiles/:id/	{:action=>"destroy", :locale=>"srb"}	{:id=>/[^\/.?]+/}
	/cro/profiles/:id/	{:action=>"destroy", :locale=>"cro"}	{:id=>/[^\/.?]+/}
	/slo/profiles/:id/	{:action=>"destroy", :locale=>"slo"}	{:id=>/[^\/.?]+/}
	/mak/profiles/:id.:format/	{:action=>"destroy", :locale=>"mak"}	{:id=>/[^\/.?]+/}
	/profiles/:id.:format/	{:action=>"destroy", :locale=>"eng"}	{:id=>/[^\/.?]+/}
	/srb/profiles/:id.:format/	{:action=>"destroy", :locale=>"srb"}	{:id=>/[^\/.?]+/}
	/cro/profiles/:id.:format/	{:action=>"destroy", :locale=>"cro"}	{:id=>/[^\/.?]+/}
	/slo/profiles/:id.:format/	{:action=>"destroy", :locale=>"slo"}	{:id=>/[^\/.?]+/}
location_collectors_mak	/mak/collection/:collection_id/profiles/location/	{:action=>"index", :locale=>"mak"}	{}
location_collectors_eng	/collection/:collection_id/profiles/location/	{:action=>"index", :locale=>"eng"}	{}
location_collectors_srb	/srb/collection/:collection_id/profiles/location/	{:action=>"index", :locale=>"srb"}	{}
location_collectors_cro	/cro/collection/:collection_id/profiles/location/	{:action=>"index", :locale=>"cro"}	{}
location_collectors_slo	/slo/collection/:collection_id/profiles/location/	{:action=>"index", :locale=>"slo"}	{}
stickers_collectors_mak	/mak/collection/:collection_id/profiles/stickers/	{:action=>"index", :locale=>"mak", :s=>"stickers"}	{}
stickers_collectors_eng	/collection/:collection_id/profiles/stickers/	{:action=>"index", :locale=>"eng", :s=>"stickers"}	{}
stickers_collectors_srb	/srb/collection/:collection_id/profiles/stickers/	{:action=>"index", :locale=>"srb", :s=>"stickers"}	{}
stickers_collectors_cro	/cro/collection/:collection_id/profiles/stickers/	{:action=>"index", :locale=>"cro", :s=>"stickers"}	{}
stickers_collectors_slo	/slo/collection/:collection_id/profiles/stickers/	{:action=>"index", :locale=>"slo", :s=>"stickers"}	{}
collection_profiles_mak	/mak/collections/:collection_id/profiles/	{:action=>"index", :locale=>"mak"}	{}
collection_profiles_eng	/collections/:collection_id/profiles/	{:action=>"index", :locale=>"eng"}	{}
collection_profiles_srb	/srb/collections/:collection_id/profiles/	{:action=>"index", :locale=>"srb"}	{}
collection_profiles_cro	/cro/collections/:collection_id/profiles/	{:action=>"index", :locale=>"cro"}	{}
collection_profiles_slo	/slo/collections/:collection_id/profiles/	{:action=>"index", :locale=>"slo"}	{}
formatted_collection_profiles_mak	/mak/collections/:collection_id/profiles.:format/	{:action=>"index", :locale=>"mak"}	{}
formatted_collection_profiles_eng	/collections/:collection_id/profiles.:format/	{:action=>"index", :locale=>"eng"}	{}
formatted_collection_profiles_srb	/srb/collections/:collection_id/profiles.:format/	{:action=>"index", :locale=>"srb"}	{}
formatted_collection_profiles_cro	/cro/collections/:collection_id/profiles.:format/	{:action=>"index", :locale=>"cro"}	{}
formatted_collection_profiles_slo	/slo/collections/:collection_id/profiles.:format/	{:action=>"index", :locale=>"slo"}	{}
my_profile_mak	/mak/my_page/profile/	{:action=>"edit", :locale=>"mak"}	{}
my_profile_eng	/my_page/profile/	{:action=>"edit", :locale=>"eng"}	{}
my_profile_srb	/srb/my_page/profile/	{:action=>"edit", :locale=>"srb"}	{}
my_profile_cro	/cro/my_page/profile/	{:action=>"edit", :locale=>"cro"}	{}
my_profile_slo	/slo/my_page/profile/	{:action=>"edit", :locale=>"slo"}	{}
	/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"}	{}

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	/collection/267-uefa-euro-2016-france/profiles/location
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/collection/267-uefa-euro-2016-france/profiles/location
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)

SELECT (explain | trace)
Language Load (0.593329s)
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.000432s)
SELECT * FROM languages WHERE (languages.key = 'eng') 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.488325s)
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/profiles_controller.rb:17:in `index'

SELECT (explain | trace)
Profile Load (0.613877s)
SELECT profiles.*, cities.name as city_name, countries.name as country_name, (SELECT COUNT(*) FROM profile_stickers WHERE profile_id = profiles.id AND collection_id = 267 AND is_duplicate = TRUE) as duplicates, (SELECT COUNT(*) FROM profile_stickers WHERE profile_id = profiles.id AND collection_id = 267 AND is_duplicate = FALSE) as missing FROM profiles INNER JOIN profile_collections ON profile_collections.profile_id = profiles.id LEFT OUTER JOIN cities ON cities.id = profiles.city_id LEFT OUTER JOIN countries ON countries.id = cities.country_id WHERE (profile_collections.collection_id = 267) ORDER BY countries.name ASC, cities.name ASC, profiles.name ASC LIMIT 0, 10

Id	Select type	Table	Partitions	Type	Possible keys	Key	Key len	Ref	Rows	Filtered	Extra
1	PRIMARY	profile_collections		ref	index_profile_collections_on_profile_id,index_profile_collections_on_collection_id	index_profile_collections_on_collection_id	5	const	124	100.00	Using where; Using temporary; Using filesort
1	PRIMARY	profiles		eq_ref	PRIMARY	PRIMARY	4	slikicki.profile_collections.profile_id	1	100.00
1	PRIMARY	cities		eq_ref	PRIMARY	PRIMARY	4	slikicki.profiles.city_id	1	100.00	Using where
1	PRIMARY	countries		eq_ref	PRIMARY	PRIMARY	4	slikicki.cities.country_id	1	100.00
3	DEPENDENT SUBQUERY	profile_stickers		ref	index_ps_profile_collection	index_ps_profile_collection	10	slikicki.profiles.id,const	115	10.00	Using where
2	DEPENDENT SUBQUERY	profile_stickers		ref	index_ps_profile_collection	index_ps_profile_collection	10	slikicki.profiles.id,const	115	10.00	Using where

vendor/plugins/will_paginate/lib/will_paginate/finder.rb:82:in `send'
vendor/plugins/will_paginate/lib/will_paginate/finder.rb:82:in `paginate'
vendor/plugins/will_paginate/lib/will_paginate/collection.rb:87:in `create'
vendor/plugins/will_paginate/lib/will_paginate/finder.rb:76:in `paginate'
app/models/profile.rb:264:in `collectioners_of_for_collection'
app/controllers/profiles_controller.rb:19:in `index'

SELECT (explain | trace)
SQL (0.478694s)
SELECT count(*) AS count_all FROM profiles INNER JOIN profile_collections ON profile_collections.profile_id = profiles.id LEFT OUTER JOIN cities ON cities.id = profiles.city_id LEFT OUTER JOIN countries ON countries.id = cities.country_id 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_profile_id,index_profile_collections_on_collection_id	index_profile_collections_on_collection_id	5	const	124	100.00	Using where
1	SIMPLE	profiles		eq_ref	PRIMARY	PRIMARY	4	slikicki.profile_collections.profile_id	1	100.00
1	SIMPLE	cities		eq_ref	PRIMARY	PRIMARY	4	slikicki.profiles.city_id	1	100.00	Using where
1	SIMPLE	countries		eq_ref	PRIMARY	PRIMARY	4	slikicki.cities.country_id	1	100.00	Using index

vendor/plugins/will_paginate/lib/will_paginate/finder.rb:215:in `wp_count'
vendor/plugins/will_paginate/lib/will_paginate/finder.rb:227:in `call'
vendor/plugins/will_paginate/lib/will_paginate/finder.rb:227:in `wp_count'
vendor/plugins/will_paginate/lib/will_paginate/finder.rb:85:in `paginate'
vendor/plugins/will_paginate/lib/will_paginate/collection.rb:87:in `create'
vendor/plugins/will_paginate/lib/will_paginate/finder.rb:76:in `paginate'
app/models/profile.rb:264:in `collectioners_of_for_collection'
app/controllers/profiles_controller.rb:19:in `index'

SELECT (explain | trace)
Tag Load (0.470773s)
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	Partitions	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/profiles/_left_box_collectors.html.erb:32:in `_run_erb_app47views47profiles47_left_box_collectors46html46erb_locals_left_box_collectors_object'
vendor/plugins/active_scaffold/lib/extensions/action_view_rendering.rb:61:in `render'
app/views/profiles/collectors.html:3:in `_run_app47views47profiles47collectors46html'
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'
app/controllers/profiles_controller.rb:21:in `index'

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