Soca   |  Dancehall   |  Dub   |  Reggae   |  Ragga   |  Wyszukane   |  Komentarze

Najważniejsze albumy Wykonawcy Byron Lee & The Dragonaires:

Najpopulartniejsze utwoty Wykonawcy Byron Lee & The Dragonaires

Params
array(5) {
  ["module"]=>
  string(5) "index"
  ["controller"]=>
  string(5) "index"
  ["action"]=>
  string(6) "artist"
  ["id"]=>
  string(3) "145"
  ["name"]=>
  string(27) "byron-lee-&-the-dragonaires"
}
Post
array(0) {
}
Session
object(ArrayObject)#138 (1) {
  ["lang"]=>
  string(2) "pl"
}
Authorisation
NULL
QueryExec timeParams
connect0.0002''
SET NAMES latin23E-05''
SELECT items.* FROM ( select * from ( select `vert_categories`.`id` AS `id`,`vert_categories`.`lang` AS `lang`,`vert_categories`.`name` AS `name`,`vert_categories`.`edit_date` AS `edit_date`, substr(edit_by, 1, ';') AS `create_by`,`vert_categories`.`edit_by` AS `edit_by`,`vert_categories`.`system` AS `system`,`vert_categories`.`publish_history` AS `publish_history`,`vert_categories`.`publish_start_date` AS `publish_start_date`,`vert_categories`.`publish_stop_date` AS `publish_stop_date`,`vert_categories`.`access` AS `access`,'categories' AS `type`, con0.first_priority AS first_priority, con0.second_type AS second_type from `vert_categories` JOIN vert_connections con0 ON 'categories' = REPLACE(con0.second_type, '_shortcut', '') AND `vert_categories`.`id` = con0.second_id WHERE con0.first_id = '165' and con0.first_type = 'categories' ORDER BY `vert_categories`.`lang` = 'pl' DESC) x0 GROUP BY x0.id UNION select * from ( select `vert_users`.`id` AS `id`,`vert_users`.`lang` AS `lang`,`vert_users`.`name` AS `name`,`vert_users`.`edit_date` AS `edit_date`, substr(edit_by, 1, ';') AS `create_by`,`vert_users`.`edit_by` AS `edit_by`,`vert_users`.`system` AS `system`,`vert_users`.`publish_history` AS `publish_history`,`vert_users`.`publish_start_date` AS `publish_start_date`,`vert_users`.`publish_stop_date` AS `publish_stop_date`,`vert_users`.`access` AS `access`,'users' AS `type`, con1.first_priority AS first_priority, con1.second_type AS second_type from `vert_users` JOIN vert_connections con1 ON 'users' = REPLACE(con1.second_type, '_shortcut', '') AND `vert_users`.`id` = con1.second_id WHERE con1.first_id = '165' and con1.first_type = 'categories' ORDER BY `vert_users`.`lang` = 'pl' DESC) x1 GROUP BY x1.id UNION select * from ( select `vert_tags`.`id` AS `id`,`vert_tags`.`lang` AS `lang`,`vert_tags`.`name` AS `name`,`vert_tags`.`edit_date` AS `edit_date`, substr(edit_by, 1, ';') AS `create_by`,`vert_tags`.`edit_by` AS `edit_by`,`vert_tags`.`system` AS `system`,`vert_tags`.`publish_history` AS `publish_history`,`vert_tags`.`publish_start_date` AS `publish_start_date`,`vert_tags`.`publish_stop_date` AS `publish_stop_date`,`vert_tags`.`access` AS `access`,'tags' AS `type`, con2.first_priority AS first_priority, con2.second_type AS second_type from `vert_tags` JOIN vert_connections con2 ON 'tags' = REPLACE(con2.second_type, '_shortcut', '') AND `vert_tags`.`id` = con2.second_id WHERE con2.first_id = '165' and con2.first_type = 'categories' ORDER BY `vert_tags`.`lang` = 'pl' DESC) x2 GROUP BY x2.id UNION select * from ( select `vert_artists`.`id` AS `id`,`vert_artists`.`lang` AS `lang`,`vert_artists`.`name` AS `name`,`vert_artists`.`edit_date` AS `edit_date`, substr(edit_by, 1, ';') AS `create_by`,`vert_artists`.`edit_by` AS `edit_by`,`vert_artists`.`system` AS `system`,`vert_artists`.`publish_history` AS `publish_history`,`vert_artists`.`publish_start_date` AS `publish_start_date`,`vert_artists`.`publish_stop_date` AS `publish_stop_date`,`vert_artists`.`access` AS `access`,'artists' AS `type`, con3.first_priority AS first_priority, con3.second_type AS second_type from `vert_artists` JOIN vert_connections con3 ON 'artists' = REPLACE(con3.second_type, '_shortcut', '') AND `vert_artists`.`id` = con3.second_id WHERE con3.first_id = '165' and con3.first_type = 'categories' ORDER BY `vert_artists`.`lang` = 'pl' DESC) x3 GROUP BY x3.id UNION select * from ( select `vert_albums`.`id` AS `id`,`vert_albums`.`lang` AS `lang`,`vert_albums`.`name` AS `name`,`vert_albums`.`edit_date` AS `edit_date`, substr(edit_by, 1, ';') AS `create_by`,`vert_albums`.`edit_by` AS `edit_by`,`vert_albums`.`system` AS `system`,`vert_albums`.`publish_history` AS `publish_history`,`vert_albums`.`publish_start_date` AS `publish_start_date`,`vert_albums`.`publish_stop_date` AS `publish_stop_date`,`vert_albums`.`access` AS `access`,'albums' AS `type`, con4.first_priority AS first_priority, con4.second_type AS second_type from `vert_albums` JOIN vert_connections con4 ON 'albums' = REPLACE(con4.second_type, '_shortcut', '') AND `vert_albums`.`id` = con4.second_id WHERE con4.first_id = '165' and con4.first_type = 'categories' ORDER BY `vert_albums`.`lang` = 'pl' DESC) x4 GROUP BY x4.id UNION select * from ( select `vert_tracks`.`id` AS `id`,`vert_tracks`.`lang` AS `lang`,`vert_tracks`.`name` AS `name`,`vert_tracks`.`edit_date` AS `edit_date`, substr(edit_by, 1, ';') AS `create_by`,`vert_tracks`.`edit_by` AS `edit_by`,`vert_tracks`.`system` AS `system`,`vert_tracks`.`publish_history` AS `publish_history`,`vert_tracks`.`publish_start_date` AS `publish_start_date`,`vert_tracks`.`publish_stop_date` AS `publish_stop_date`,`vert_tracks`.`access` AS `access`,'tracks' AS `type`, con5.first_priority AS first_priority, con5.second_type AS second_type from `vert_tracks` JOIN vert_connections con5 ON 'tracks' = REPLACE(con5.second_type, '_shortcut', '') AND `vert_tracks`.`id` = con5.second_id WHERE con5.first_id = '165' and con5.first_type = 'categories' ORDER BY `vert_tracks`.`lang` = 'pl' DESC) x5 GROUP BY x5.id UNION select * from ( select `vert_comments`.`id` AS `id`,`vert_comments`.`lang` AS `lang`,`vert_comments`.`name` AS `name`,`vert_comments`.`edit_date` AS `edit_date`, substr(edit_by, 1, ';') AS `create_by`,`vert_comments`.`edit_by` AS `edit_by`,`vert_comments`.`system` AS `system`,`vert_comments`.`publish_history` AS `publish_history`,`vert_comments`.`publish_start_date` AS `publish_start_date`,`vert_comments`.`publish_stop_date` AS `publish_stop_date`,`vert_comments`.`access` AS `access`,'comments' AS `type`, con6.first_priority AS first_priority, con6.second_type AS second_type from `vert_comments` JOIN vert_connections con6 ON 'comments' = REPLACE(con6.second_type, '_shortcut', '') AND `vert_comments`.`id` = con6.second_id WHERE con6.first_id = '165' and con6.first_type = 'categories' ORDER BY `vert_comments`.`lang` = 'pl' DESC) x6 GROUP BY x6.id) as items ORDER BY items.first_priority DESC 0.02708''
SELECT * FROM (SELECT * FROM vert_categories i WHERE i.id = ? ORDER BY i.lang DESC) ic 0.00044'176'
SELECT a.* FROM vert_artists a JOIN vert_connections c ON a.id = c.second_id AND REPLACE(c.second_type, '_shortcut', '') = 'artists' WHERE a.id = '145' LIMIT 1 0.00227''
SELECT * FROM vert_connections c WHERE c.second_id = ? and c.second_type = ? ORDER BY c.second_priority DESC0.00041'145', 'artists'
SELECT * FROM vert_connections c WHERE c.first_type = ? AND c.second_type = ? ORDER BY c.first_priority DESC0.00057'categories', 'categories'
SELECT * FROM vert_categories i WHERE i.id IN (1, 165, 195) and i.lang = ? 0.00018'pl'
SELECT * FROM vert_connections c WHERE c.second_id = ? and c.second_type = ? ORDER BY c.second_priority DESC0.00037'145', 'artists'
select * from (select c.* from vert_categories c where id = ? order by lang = ? desc) a group by a.id LIMIT 1 0.0042'195', 'pl'
SELECT a.* FROM vert_albums a JOIN vert_connections c ON a.id = c.second_id AND c.second_type = 'albums' WHERE c.first_type = 'artists_attachments' AND c.first_id = '145' ORDER BY a.id ASC 0.05375''
SELECT t.* FROM vert_tracks t JOIN vert_connections c ON t.id = c.second_id AND c.second_type = 'tracks' WHERE c.first_type = 'artists_attachments' AND c.first_id = '145' ORDER BY t.id ASC 0.00064''
SELECT a.* FROM vert_artists a JOIN vert_connections c ON a.id = c.second_id AND REPLACE(c.second_type, '_shortcut', '') = 'artists' WHERE c.first_id = '195' AND c.first_type = 'categories' 0.00184''
Total: 13, Total queries time: 0.0919723510742
TimestampMessageFrom last
1268719622 start getting matrix from dbcategories categories 1 0.115609884262
1268719622 get all connection ids 0
1268719622 make matrix 0
1268719622 matrix done 0
Total: 0.618692874908 sec