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

Shaggy - Woman a Pressure Me

Params
array(5) {
  ["module"]=>
  string(5) "index"
  ["controller"]=>
  string(5) "index"
  ["action"]=>
  string(5) "track"
  ["id"]=>
  string(4) "1392"
  ["name"]=>
  string(19) "woman-a-pressure-me"
}
Post
array(0) {
}
Session
object(ArrayObject)#134 (1) {
  ["lang"]=>
  string(2) "pl"
}
Authorisation
NULL
QueryExec timeParams
connect0.00057''
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.01772''
SELECT * FROM (SELECT * FROM vert_categories i WHERE i.id = ? ORDER BY i.lang DESC) ic 0.00036'176'
SELECT * FROM (SELECT * FROM vert_tracks i WHERE i.id = ? ORDER BY i.lang DESC) ic 0.00032'1392'
SELECT * FROM vert_connections c WHERE c.second_id = ? and c.second_type = ? ORDER BY c.second_priority DESC0.00033'1392', 'tracks'
select * from (select c.* from vert_artists c where id = ? order by lang = ? desc) a group by a.id LIMIT 1 0.00036'28', 'pl'
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 = '28' ORDER BY t.id ASC 0.00155''
SELECT * FROM vert_connections c WHERE c.second_id = ? and c.second_type = ? ORDER BY c.second_priority DESC0.00042'28', 'artists'
select * from (select c.* from vert_categories c where id = ? order by lang = ? desc) a group by a.id LIMIT 1 0.00034'191', 'pl'
Total: 10, Total queries time: 0.022011756897
TimestampMessageFrom last
No log messages
Total: 0.531579017639 sec