Slikicki.com > Profiles

Session

{:flash=>{}, :csrf_id=>"10903f39ec611455ef9e4586031cb831"}

{}

Params

{:action=>"index", :locale=>"slo", :controller=>"profiles", :t=>"last_login"}

Filter chain for ProfilesController

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]

Routes for ProfilesController

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"}	{}

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_IF_MODIFIED_SINCE	Thu, 20 Jan 2022 07:04:31 GMT
HTTP_USER_AGENT	CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO	/slo/profiles/last_login
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/profiles/last_login
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.529809s)
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.000420s)
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)
Profile Load (1.481693s)
SELECT users.last_login as last_login, (SELECT MAX(activities.created_at) FROM activities where activities.profile_id = profiles.id) as last_activity, cities.name as city_name, countries.name as country_name, profiles.* FROM profiles LEFT OUTER JOIN users ON users.id = profiles.user_id LEFT OUTER JOIN cities ON cities.id = profiles.city_id LEFT OUTER JOIN countries ON countries.id = profiles.country_id ORDER BY 1 DESC LIMIT 0, 10

Id	Select type	Table	Type	Possible keys	Key	Key len	Ref	Rows	Filtered	Extra
1	PRIMARY	profiles	ALL					4790	100.00	Using temporary; Using filesort
1	PRIMARY	users	eq_ref	PRIMARY	PRIMARY	4	slikicki.profiles.user_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.profiles.country_id	1	100.00
2	DEPENDENT SUBQUERY	activities	ref	index_activities_on_profile_id	index_activities_on_profile_id	5	slikicki.profiles.id	185	100.00

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/controllers/profiles_controller.rb:32:in `index'

SELECT (explain | trace)
SQL (0.474607s)
SELECT count(*) AS count_all FROM profiles LEFT OUTER JOIN users ON users.id = profiles.user_id LEFT OUTER JOIN cities ON cities.id = profiles.city_id LEFT OUTER JOIN countries ON countries.id = profiles.country_id

Id	Select type	Table	Type	Possible keys	Key	Key len	Ref	Rows	Filtered	Extra
1	SIMPLE	profiles	ALL					4790	100.00
1	SIMPLE	users	eq_ref	PRIMARY	PRIMARY	4	slikicki.profiles.user_id	1	100.00	Using index
1	SIMPLE	cities	eq_ref	PRIMARY	PRIMARY	4	slikicki.profiles.city_id	1	100.00	Using where; Using index
1	SIMPLE	countries	eq_ref	PRIMARY	PRIMARY	4	slikicki.profiles.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/controllers/profiles_controller.rb:32:in `index'

SELECT (explain | trace)
Tag Load (0.527356s)
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/profiles/_left_box.html.erb:42:in `_run_erb_app47views47profiles47_left_box46html46erb_locals_left_box_object'
vendor/plugins/active_scaffold/lib/extensions/action_view_rendering.rb:61:in `render'
app/views/profiles/index.html.erb:3:in `_run_erb_app47views47profiles47index46html46erb'
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'

General (id="general_debug_info")

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

Skupnost