2
(default) 35 queries took 914 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `pulseradio`.`cake_sessions` AS `Session` WHERE `id` = '4hg0aj5v4jnmeib3hpe0jcv137' LIMIT 1 -- /profiles/index/genre:166/order:created/search:K0037
2SELECT count(*) as count FROM `profiles` AS `Profile` left JOIN genre_taxonomy AS `GenreTaxonomy` ON (`GenreTaxonomy`.`foreign_key` = `Profile`.`id` AND `GenreTaxonomy`.`model` = 'Profile' AND `GenreTaxonomy`.`genre_id` = 166) WHERE `Profile`.`published` = 1 AND `GenreTaxonomy`.`genre_id` = 166 AND `Profile`.`type` != 'user' ORDER BY `Profile`.`title` asc -- /profiles/index/genre:166/order:created/search:K1138
3SELECT `Profile`.`id`, `Profile`.`title`, `Profile`.`type`, `Profile`.`slug`, `Profile`.`content` FROM `pulseradio`.`profiles` AS `Profile` left JOIN `pulseradio`.`genre_taxonomy` AS `GenreTaxonomy` ON (`GenreTaxonomy`.`foreign_key` = `Profile`.`id` AND `GenreTaxonomy`.`model` = "Profile" AND `GenreTaxonomy`.`genre_id` = "166") WHERE `GenreTaxonomy`.`genre_id` = 166 AND `Profile`.`title` LIKE 'K%' AND `Profile`.`type` != 'user' AND `Profile`.`published` = '1' ORDER BY `Profile`.`created` desc LIMIT 20 -- /profiles/index/genre:166/order:created/search:K0038
4SELECT `Genre`.`id`, `Genre`.`title` FROM `pulseradio`.`genres` AS `Genre` WHERE `deleted` = '0' ORDER BY `title` ASC -- /profiles/index/genre:166/order:created/search:K303024
5SELECT `Profile`.`id`, `Profile`.`type`, `Profile`.`title`, `Profile`.`slug`, `Profile`.`permalink`, `Profile`.`content_summary`, `Profile`.`content`, `Profile`.`created`, `Profile`.`created_by`, `Profile`.`modified`, `Profile`.`viewed`, `Profile`.`published`, `Profile`.`recommended`, `Profile`.`date_of_birth`, `Profile`.`sex`, `Profile`.`country_location_id`, `Profile`.`country_id`, `Profile`.`region_id`, `Profile`.`city`, `Profile`.`website`, `Profile`.`myspace`, `Profile`.`facebook`, `Profile`.`twitter`, `Profile`.`googleplus`, `Profile`.`soundcloud`, `Profile`.`blog`, `Profile`.`email`, `Profile`.`last_fm`, `Profile`.`discogs`, `Profile`.`old_dj_id`, `Profile`.`youtube`, `Profile`.`video_url`, `Profile`.`booking_title`, `Profile`.`booking_url`, `Profile`.`itunes`, `Profile`.`beatport`, `Profile`.`juno`, `Profile`.`twitter_username`, `Profile`.`booking_title_2`, `Profile`.`booking_url_2`, `Profile`.`booking_title_3`, `Profile`.`booking_url_3`, `Profile`.`booking_title_4`, `Profile`.`booking_url_4`, `Profile`.`management_title`, `Profile`.`management_url`, `Profile`.`management_title_2`, `Profile`.`management_url_2`, `Profile`.`management_title_3`, `Profile`.`management_url_3`, `Profile`.`management_title_4`, `Profile`.`management_title_5`, `Profile`.`management_url_5`, `Profile`.`management_url_4`, `Profile`.`fb_id`, `Profile`.`fb_access_token`, `Profile`.`is_facebook_enabled`, `Profile`.`timezone`, `Profile`.`locale`, `Profile`.`requires_review`, `Profile`.`claim_token`, `Profile`.`claimed` FROM `pulseradio`.`profiles` AS `Profile` WHERE `Profile`.`type` IS NULL AND `Profile`.`published` = '1' ORDER BY RAND() ASC LIMIT 20 -- /profiles/index/genre:166/order:created/search:K2020387
6SELECT * FROM attachments as Attachment where foreign_key=51608 && model='Profile' order by id desc limit 1 -- /profiles/index/genre:166/order:created/search:K005
7SELECT * FROM attachments as Attachment where foreign_key=72200 && model='Profile' order by id desc limit 1 -- /profiles/index/genre:166/order:created/search:K005
8SELECT * FROM attachments as Attachment where foreign_key=63897 && model='Profile' order by id desc limit 1 -- /profiles/index/genre:166/order:created/search:K001
9SELECT * FROM attachments as Attachment where foreign_key=70457 && model='Profile' order by id desc limit 1 -- /profiles/index/genre:166/order:created/search:K001
10SELECT * FROM attachments as Attachment where foreign_key=70863 && model='Profile' order by id desc limit 1 -- /profiles/index/genre:166/order:created/search:K001
11SELECT * FROM attachments as Attachment where foreign_key=72309 && model='Profile' order by id desc limit 1 -- /profiles/index/genre:166/order:created/search:K001
12SELECT * FROM attachments as Attachment where foreign_key=75907 && model='Profile' order by id desc limit 1 -- /profiles/index/genre:166/order:created/search:K001
13SELECT * FROM attachments as Attachment where foreign_key=52886 && model='Profile' order by id desc limit 1 -- /profiles/index/genre:166/order:created/search:K001
14SELECT * FROM attachments as Attachment where foreign_key=69381 && model='Profile' order by id desc limit 1 -- /profiles/index/genre:166/order:created/search:K008
15SELECT * FROM attachments as Attachment where foreign_key=59962 && model='Profile' order by id desc limit 1 -- /profiles/index/genre:166/order:created/search:K001
16SELECT * FROM attachments as Attachment where foreign_key=68219 && model='Profile' order by id desc limit 1 -- /profiles/index/genre:166/order:created/search:K001
17SELECT * FROM attachments as Attachment where foreign_key=75524 && model='Profile' order by id desc limit 1 -- /profiles/index/genre:166/order:created/search:K001
18SELECT * FROM attachments as Attachment where foreign_key=61745 && model='Profile' order by id desc limit 1 -- /profiles/index/genre:166/order:created/search:K001
19SELECT * FROM attachments as Attachment where foreign_key=69923 && model='Profile' order by id desc limit 1 -- /profiles/index/genre:166/order:created/search:K001
20SELECT * FROM attachments as Attachment where foreign_key=52331 && model='Profile' order by id desc limit 1 -- /profiles/index/genre:166/order:created/search:K001
21SELECT * FROM attachments as Attachment where foreign_key=70247 && model='Profile' order by id desc limit 1 -- /profiles/index/genre:166/order:created/search:K001
22SELECT * FROM attachments as Attachment where foreign_key=74969 && model='Profile' order by id desc limit 1 -- /profiles/index/genre:166/order:created/search:K003
23SELECT * FROM attachments as Attachment where foreign_key=67129 && model='Profile' order by id desc limit 1 -- /profiles/index/genre:166/order:created/search:K003
24SELECT * FROM attachments as Attachment where foreign_key=49906 && model='Profile' order by id desc limit 1 -- /profiles/index/genre:166/order:created/search:K003
25SELECT * FROM attachments as Attachment where foreign_key=53162 && model='Profile' order by id desc limit 1 -- /profiles/index/genre:166/order:created/search:K005
26SELECT `Setting`.`value` FROM `pulseradio`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Ads.facebook_login_popup' LIMIT 1 -- /profiles/index/genre:166/order:created/search:K114
27SELECT `Setting`.`value` FROM `pulseradio`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Ads.facebook_popup' LIMIT 1 -- /profiles/index/genre:166/order:created/search:K111
28SELECT `Setting`.`value` FROM `pulseradio`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Ads.facebook_like_popup' LIMIT 1 -- /profiles/index/genre:166/order:created/search:K111
29select id from tbl_countries as Country where code='US' -- /profiles/index/genre:166/order:created/search:K114
30SELECT `BgImage`.`id`, `BgImage`.`locations`, `BgImage`.`display_pages`, `BgImage`.`display_urls`, `BgImage`.`position`, `BgImage`.`title`, `BgImage`.`url`, `BgImage`.`image`, `BgImage`.`start_date`, `BgImage`.`end_date`, `BgImage`.`impressions`, `BgImage`.`clicks`, `BgImage`.`status`, `BgImage`.`created`, `BgImage`.`modified` FROM `pulseradio`.`ads` AS `BgImage` WHERE `BgImage`.`status` = '1' AND `BgImage`.`position` = 'body' AND ((DATE_FORMAT(`BgImage`.`start_date`, "%Y-%m-%d") < '2014-11-29') OR (`BgImage`.`start_date` IS NULL)) AND ((DATE_FORMAT(`BgImage`.`end_date`, "%Y-%m-%d") >= '2014-11-29') OR (`BgImage`.`end_date` IS NULL)) AND ((FIND_IN_SET('223', `BgImage`.`locations`)) OR (`BgImage`.`locations` = '0')) LIMIT 1 -- /profiles/index/genre:166/order:created/search:K001
31SELECT `Sitemap`.`base_url` FROM `pulseradio`.`seo_sitemap` AS `Sitemap` WHERE 1 = 1 ORDER BY `Sitemap`.`lft` ASC -- /profiles/index/genre:166/order:created/search:K110
32SELECT `Ad`.`id`, `Ad`.`locations`, `Ad`.`display_pages`, `Ad`.`display_urls`, `Ad`.`position`, `Ad`.`title`, `Ad`.`url`, `Ad`.`image`, `Ad`.`start_date`, `Ad`.`end_date`, `Ad`.`impressions`, `Ad`.`clicks`, `Ad`.`status`, `Ad`.`created`, `Ad`.`modified` FROM `pulseradio`.`ads` AS `Ad` WHERE `Ad`.`status` = '1' AND `Ad`.`position` = 'left' AND ((DATE_FORMAT(`Ad`.`start_date`, "%Y-%m-%d") < '2014-11-29') OR (`Ad`.`start_date` IS NULL)) AND ((DATE_FORMAT(`Ad`.`end_date`, "%Y-%m-%d") >= '2014-11-29') OR (`Ad`.`end_date` IS NULL)) AND ((FIND_IN_SET('223', `Ad`.`locations`)) OR (`Ad`.`locations` = '0')) LIMIT 1 -- /profiles/index/genre:166/order:created/search:K00327
33SELECT `Setting`.`value` FROM `pulseradio`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Ads.home_page_top' LIMIT 1 -- /profiles/index/genre:166/order:created/search:K111
34SELECT `Setting`.`value` FROM `pulseradio`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Ads.rest_site_page_top' LIMIT 1 -- /profiles/index/genre:166/order:created/search:K112
35SELECT `Ad`.`id`, `Ad`.`locations`, `Ad`.`display_pages`, `Ad`.`display_urls`, `Ad`.`position`, `Ad`.`title`, `Ad`.`url`, `Ad`.`image`, `Ad`.`start_date`, `Ad`.`end_date`, `Ad`.`impressions`, `Ad`.`clicks`, `Ad`.`status`, `Ad`.`created`, `Ad`.`modified` FROM `pulseradio`.`ads` AS `Ad` WHERE `Ad`.`status` = '1' AND `Ad`.`position` = 'right' AND ((DATE_FORMAT(`Ad`.`start_date`, "%Y-%m-%d") < '2014-11-29') OR (`Ad`.`start_date` IS NULL)) AND ((DATE_FORMAT(`Ad`.`end_date`, "%Y-%m-%d") >= '2014-11-29') OR (`Ad`.`end_date` IS NULL)) AND ((FIND_IN_SET('223', `Ad`.`locations`)) OR (`Ad`.`locations` = '0')) LIMIT 1 -- /profiles/index/genre:166/order:created/search:K004