Soca   |  Dancehall   |  Dub   |  Reggae   |  Ragga   |  Wyszukane   |  Komentarze
Binghi Rasta  »  Soca  »  Arrow

Najważniejsze albumy Wykonawcy Arrow:

The Best of Arrow
Putumayo Presents: Caribbean Party
Soca Dance Party
Knock Dem Dead
Reggae Classics on Capital Gold (disc 2)
The Best Latin Party Album in the World... Ever!
The Cutting Edge
In the Summertime
Latin Legends (disc 1)
O'la Soca
Trancemaster 17 (disc 1)
Dynamite Reggae Classics (disc 2)
triple j - earthcore
Rave Mission, Volume 11 (disc 1)
Caribbean Summer Songs 3
Ride De Riddim
Phat
Avant-Garde
The Best Latino Carnival in the World... Ever!
World: The Greatest Songs Ever
Classics and More
Zombie Soca
Soca 101 Vol. 1
GrandMaster Party
Soca Gold 1997
De Après Skihut: Hoe heter hoe beter!
Bling (disc 1)
Bravo Hits 2004
Young & Sexy, Volume 14 (Mixed by DJ L) (Hosted by Buffie the Body)
Summer in the City: Latin Party
Ultra.Dance 06 (disc 1: Vic.Latino)
Fetenhits: Best of 2004 (disc 2)
Crossfade Dancehall Party 2004 (disc 1)
Festivalbar 2004 Compilation Blu (disc 1)
Hit 40 UK (disc 2)
Hot 97: Gold and Platinum Reggae, Volume 3
R&B Anthems 2005 (disc 1)
Bravo Black Hits, Volume 10 (disc 1)
Bravo Hits 44 (disc 1)
R&B Love (disc 1)
Pure Urban Essentials 2 (disc 1)
You, Me And She
Romantic Reggae
Dancehall 101 Vol. 2
Universal Smash Hits 2
Riddim Driven: Applause
Bisous Bisous (Pink)
Rodigan's 25th Anniversary (disc 1)
Liquid Riddim
Bling (disc 1)
Params
array(5) {
  ["module"]=>
  string(5) "index"
  ["controller"]=>
  string(5) "index"
  ["action"]=>
  string(6) "artist"
  ["id"]=>
  string(3) "146"
  ["name"]=>
  string(5) "arrow"
}
Post
array(0) {
}
Session
object(ArrayObject)#238 (1) {
  ["lang"]=>
  string(2) "pl"
}
Authorisation
NULL
QueryExec timeParams
connect0.00018''
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.0149''
SELECT * FROM (SELECT * FROM vert_categories i WHERE i.id = ? ORDER BY i.lang DESC) ic 0.00035'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 = '146' LIMIT 1 0.00022''
SELECT * FROM vert_connections c WHERE c.second_id = ? and c.second_type = ? ORDER BY c.second_priority DESC0.00042'146', 'artists'
SELECT * FROM vert_connections c WHERE c.first_type = ? AND c.second_type = ? ORDER BY c.first_priority DESC0.00055'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.00038'146', 'artists'
select * from (select c.* from vert_categories c where id = ? order by lang = ? desc) a group by a.id LIMIT 1 0.00032'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 = '146' ORDER BY a.id ASC 0.36208''
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 = '146' ORDER BY t.id ASC 0.0018''
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.00096''
Total: 13, Total queries time: 0.382351875305
TimestampMessageFrom last
1268254441 start getting matrix from dbcategories categories 1 -0.62366104126
1268254441 get all connection ids 0
1268254441 make matrix 0
1268254441 matrix done 0
Total: 1.11825704575 sec