Raxley «Картинки». ТЕКСТ ПЕСНИ

[2025-04-24 16:17:16] karaoke_site@10.129.0.5:5432> select "page".* from "page" where (url = '/artists/raxley/text/kartinki/')
[2025-04-24 16:17:16] karaoke_site@10.129.0.5:5432> 
            select a.external_id _a_external_id,a.name _a_name,a.urlkey _a_urlkey,a.alias _a_alias,a.song_count _a_song_count,a.created_at _a_created_at,a.updated_at _a_updated_at,a.content_updated_at _a_content_updated_at,a.image_id _a_image_id,a.image_version _a_image_version,a.id _a_id, s.external_id _s_external_id,s.title _s_title,s.lyrics _s_lyrics,s.created_at _s_created_at,s.updated_at _s_updated_at,s.expire_at _s_expire_at,s.copyrights _s_copyrights,s.sort _s_sort,s.urlkey _s_urlkey,s.alias _s_alias,s.can_sing _s_can_sing,s.duration _s_duration,s.has_minus _s_has_minus,s.text_updated_at _s_text_updated_at,s.age_limit _s_age_limit,s.file_dat_id _s_file_dat_id,s.file_dat_version _s_file_dat_version,s.is_free _s_is_free,s.id _s_id, sa.is_main_author _is_main
            from author a
            join song_author sa on a.id = sa.author_id and sa.type_id = 3
            join song s on s.id = sa.song_id
            where 
                a.alias = 'raxley'
                and s.alias = 'kartinki'
            limit 1
[2025-04-24 16:17:16] srv1.dev:11311> get:site_sessqj49bcnbbdtjf7psp5pe8c6man
[2025-04-24 16:17:16] srv1.dev:11211> get:content_author_top5
[2025-04-24 16:17:16] srv1.dev:11211> get:content_collection_top5
[2025-04-24 16:17:16] srv1.dev:11311> get:content_song_top5
[2025-04-24 16:17:16] karaoke_site@10.129.0.5:5432>         select s.*
        from song_author sa
        join song s on s.id = sa.song_id and s.alias is not null and s.expire_at > now()
        left join song_top st on (s.id = st.song_id and st.date = (SELECT max(date) FROM song_top)) 
        where 
            sa.author_id = '1619010'
            and sa.type_id = '3'
        order by st.total_plays desc nulls last
        limit '10'
        offset '0'
[2025-04-24 16:17:16] karaoke_site@10.129.0.5:5432> select "collection".* from "collection_song"
                join "collection" on "collection"."id"
                                                      = "collection_song"."collection_id" INNER JOIN collection_vendor ON collection.id = collection_vendor.collection_id AND (collection_vendor.vendor_id IS NULL or collection_vendor.vendor_id = '6')  where ("song_id" = '3687667') order by "title" asc
[2025-04-24 16:17:16] karaoke_site@10.129.0.5:5432> select "song_author"."song_id" __pr_pk,
                     "song_author"."author_id" __dp_pk, "song_author"."type_id" __dp_type_id, "song_author"."sort" __dp_sort, "song_author"."is_main_author" __dp_is_main_author from "song_author" where ((song_id = '3687667' or type_id = '3')) and ("song_author"."song_id" in (3619847,5557,5270,5040,4814,3687667,3687683,3687668,3687670,3687669,3687684)) order by "is_main_author" desc, "sort" asc
[2025-04-24 16:17:16] karaoke_site@10.129.0.5:5432> select "author".* from "author" where "id" in ('1944','347022','736','2240','1894','1619010','1619008','1619009')
[2025-04-24 16:17:16] karaoke_site@10.129.0.5:5432> 
            select c.*
            from collection c
            LEFT JOIN collection_vendor AS cv ON c.id = cv.collection_id
         where "id" in ('5','4','7','1','3')
[2025-04-24 16:17:16] karaoke_site@10.129.0.5:5432> select "song".* from "song" where "id" in ('3619847','5557','5270','5040','4814')
[2025-04-24 16:17:16] karaoke_site@10.129.0.5:5432> select "collection".* from "collection_song"
                join "collection" on "collection"."id"
                                                      = "collection_song"."collection_id" INNER JOIN collection_vendor ON collection.id = collection_vendor.collection_id AND (collection_vendor.vendor_id IS NULL or collection_vendor.vendor_id = '6')  where ("song_id" = '3687667')
[2025-04-24 16:17:16] karaoke_site@10.129.0.5:5432> select * from "vendor" where "id" = '6'
[2025-04-24 16:17:16] karaoke_site@10.129.0.5:5432> select true from vendor_song where vendor_id = '6' and song_id = '3687667'
        union
        select distinct true from song_vendor_group
        join vendor_group_vendor on vendor_group_vendor.vendor_group_id = song_vendor_group.vendor_group_id
        join vendor on vendor.id = vendor_group_vendor.vendor_id
        where vendor_id = '6' and song_id = '3687667' and song_vendor_group.vendor_group_id <> 2
[2025-04-24 16:17:16] karaoke_site@10.129.0.5:5432> select "counter".* from "counter" where (song_id = '3687667') and (vendor_id in (6,3)) and (type_id = '1')
[2025-04-24 16:17:16] karaoke_site@10.129.0.5:5432> select * from "vendor" where "id" = '6'
[2025-04-24 16:17:16] karaoke_site@10.129.0.5:5432> select true from vendor_song where vendor_id = '6' and song_id = '3687667'
        union
        select distinct true from song_vendor_group
        join vendor_group_vendor on vendor_group_vendor.vendor_group_id = song_vendor_group.vendor_group_id
        join vendor on vendor.id = vendor_group_vendor.vendor_id
        where vendor_id = '6' and song_id = '3687667' and song_vendor_group.vendor_group_id <> 2
[2025-04-24 16:17:16] karaoke_site@10.129.0.5:5432> select "collection".* from "collection_song"
                join "collection" on "collection"."id"
                                                      = "collection_song"."collection_id" INNER JOIN collection_vendor ON collection.id = collection_vendor.collection_id AND (collection_vendor.vendor_id IS NULL or collection_vendor.vendor_id = '6')  where ("song_id" = '3687667')
[2025-04-24 16:17:16] srv1.dev:11211> set:site_sessqj49bcnbbdtjf7psp5pe8c6man
[2025-04-24 16:17:16] srv1.dev:11311> set:site_sessqj49bcnbbdtjf7psp5pe8c6man