作词 : Julian Bunetta/Teddy Geiger/Niall Horan/Alexander Izquierdo/Scott Harris 作曲 : Julian Bunetta/Teddy Geiger/Niall Horan/Alexander Izquierdo/Scott Harris That first night, we were standin' at your door Fumblin' for your keys, then I kissed you Ask me if I wanna come inside 'Cause we didn't wanna end the night Then you took my hand and I followed you Yeah, I see us in black and white Crystal clear on a starlit night In all your gorgeous colours I promise that I'll love you for the rest of my life See you standing in your dress Swear in front of all our friends There'll never be another I promise that I'll love you for the rest of my life Now we're sittin' here in your livin' room Tellin' stories while we share a drink or two And there's a vision I've been holdin' in my mind We're sixty-five and you ask when did I first know, I always knew And I see us in black and white Crystal clear on a starlit night In all your gorgeous colours I promise that I'll love you for the rest of my life See you standing in your dress Swear in front of all our friends There'll never be another I promise that I'll love you for the rest of my life And I want the world to witness When we finally say "I do" It's the way you love, I gotta give it back to you I can't promise picket fences Or sunny afternoons But at night, when I close my eyes I see us in black and white Crystal clear on a starlit night There'll never be another I promise that I'll love you I see us in black and white Crystal clear on a starlit night In all your gorgeous colours I promise that I'll love you for the rest of my life See you standing in your dress Swear in front of all our friends There'll never be another (Never be) I promise that I'll love you for the rest of my life And there'll never be another I promise that I'll love you for the rest of my life
SHOW FULL COLUMNS FROM `tool_lyric` [ RunTime:0.001761s ]
SELECT `id`,`title`,`singer`,`content` FROM `tool_lyric` WHERE `switch` = 1 AND `id` = 694275 LIMIT 1 [ RunTime:0.011322s ]
UPDATE `tool_lyric` SET `views` = `views` + 1 WHERE `id` = 694275 [ RunTime:0.003184s ]
SELECT `id`,`title` FROM `tool_lyric` WHERE `id` IN (702657,377175,69201,687543,766426,550142,711544,247533,201156,602841,143797,510361,507072,670491,820525,439550,270105,57607,421817,391730,580117,738824,525200,133451,636288,316059,679827,814764,635954,37044) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.032080s ]
SELECT `id`,`title` FROM `tool_lyric` WHERE `id` < 694275 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004892s ]