Video

Featured video - Brad Pitt: Latest dramatic scenes from Glasgow movie set

To view content in the STV player you need to enable Javascript.

Summary: The picture, from zombie flick World War Z, shows a bin lorry colliding into a row of cars as pedestrians flee for their lives.

Popular on STV Player

>  ColdBox Debugging Information
 

Framework Info:
ColdBox 2.6.3 RENEWED
Application Name:
STV Video (production)
Template:
/var/www/webapps/video.stv.tv/index.cfm
TimeStamp:
Feb-12-2012 08:15:30 PM
Query String:
urlparam=/bc/programmes-edgeoftheland-s01-e02/
Server Instance:
stv-web1
Current Event:
general.index
Current Layout:
Layout.Main.cfm
Current View:
home
Timestamp Execution Time Framework Method RC Snapshot
08:15:28.629 PM 2 ms interception [afterAspectsLoad] View
{urlparam={/bc/programmes-edgeoftheland-s01-e02/}}
08:15:28.836 PM 1 ms interception [afterPluginCreation] View
{urlparam={/bc/programmes-edgeoftheland-s01-e02/} path_info={/}}
08:15:28.849 PM 1 ms interception [afterHandlerCreation] View
{urlparam={/bc/programmes-edgeoftheland-s01-e02/} event={general.index} path_info={/}}
08:15:28.850 PM 0 ms invoking runEvent [main.onAppInit] View
{urlparam={/bc/programmes-edgeoftheland-s01-e02/} event={general.index} path_info={/}}
08:15:28.852 PM 2 ms interception [preProcess] View
{urlparam={/bc/programmes-edgeoftheland-s01-e02/} event={general.index} path_info={/}}
08:15:28.853 PM 0 ms interception [afterHandlerCreation] View
{urlparam={/bc/programmes-edgeoftheland-s01-e02/} event={general.index} path_info={/}}
08:15:28.864 PM 1 ms interception [afterPluginCreation] View
{urlparam={/bc/programmes-edgeoftheland-s01-e02/} event={general.index} path_info={/}}
08:15:29.454 PM 601 ms invoking runEvent [main.onRequestStart] View
{event={general.index} pagekeywords={stv video tv shows soaps clips latest news sport entertainment showbiz gossip} urlparam={/bc/programmes-edgeoftheland-s01-e02/} MOSTPOPULAR={Query --------------------------------------------------- select vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vl.plays_trend vc.rating from videocache_new vc inner join video_logging vl on vl.videoid = vc.videoid where vc.videoDate > date_add(now() interval -7 day) and vc.isCatchup = 0 order by vl.plays_trailing_week desc limit 10 --------------------------------------------------- Execution Time: 165 --------------------------------------------------- Recordcount: 10 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |plays_trend |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |20946874001 | |Ella Edmondson sings |Ella Edmondson da...|{ts '1970-01-01 00...|ella-edmondson-sings |entertainment-five...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |55221454001 | |Rangers say Boyd d...|Martin Bain tells ...|{ts '1970-01-01 00...|rangers-say-boyd-d...|sport-football-boy...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |6262033001 | |Islanders mark 90-...|Residents of Lewis...|{ts '1970-01-01 00...|islanders-mark-90-...|news-headlines-nt-...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1847316428 | |Glen Michael is back |Glen Michael prob...|{ts '1970-01-01 00...|glen-michael-is-back |entertainment-five...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |50577224001 | |Central Scotland w...|The latest weather...|{ts '1970-01-01 00...|central-scotland-w...|stv-news-weather-s...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |50577222001 | |North of Scotland ...|The latest weather...|{ts '1970-01-01 00...|north-of-scotland-...|stv-news-weather-s...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |30481332001 | |Weather forecast f...|Sean Batty takes a...|{ts '1970-01-01 00...|weather-forecast-f...|scotland-thegather...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |20229945001 | |Old Firm English P...|Chairman of Englis...|{ts '1970-01-01 00...|old-firm-english-p...|news-090420-l2-old...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |18160924001 | |Scottish heather i...|"We want to turn t...|{ts '1970-01-01 00...|scottish-heather-i...|news-headlines-200...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |16951175001 | |Pressley: fearless...|Steven Pressley is...|{ts '1970-01-01 00...|pressley-fearless-...|sport-football-200...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } appname={STV Video} JUSTADDED={Query --------------------------------------------------- select vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vc.rating from videocache_new vc where vc.isCatchup = 0 group by vc.videoID order by vc.video_ModifiedDate desc limit 10 --------------------------------------------------- Execution Time: 2 --------------------------------------------------- Recordcount: 10 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448576666001 | |Dancing on Ice 201...|Chemmy and Sean gi...|{ts '1970-01-01 00...|dancing-on-ice-201...|programmes-dancing...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1447383307001 | |ITV News - Sunday ...|The Sun newspaper ...|{ts '1970-01-01 00...|itv-news-sunday-fe...|catchup-ac2-itvnew...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448569276001 | |STV News (Central ...|The SNP is giving ...|{ts '1970-01-01 00...|stv-news-central-e...|catchup-ac2-news-w...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448569281001 | |STV News (North ed...|The SNP is giving ...|{ts '1970-01-01 00...|stv-news-north-edi...|catchup-ac2-news-w...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448552739001 | |First Minister ins...|Alex Salmond will ...|{ts '1970-01-01 00...|first-minister-ins...|news-120212-g-inde...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448552727001 | |‘Suspicious’ house...|The blaze at a ten...|{ts '1970-01-01 00...|suspicious-house-f...|news-120212-g-fire | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448515721001 | |Police in six-hour...|The stand-off has ...|{ts '1970-01-01 00...|police-in-six-hour...|news-120212-g-siege | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448515715001 | |Teenager killed in...|A 52-year-old driv...|{ts '1970-01-01 00...|teenager-killed-in...|news-120212-g-crash2 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448552707001 | |catchup-ac2-mez-st...|catchup-ac2-mez-st...|{ts '1970-01-01 00...|catchup-ac2-mez-st...|catchup-ac2-mez-st...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448546655001 | |The Latest Forecas...|This is the latest...|{ts '1970-01-01 00...|the-latest-forecas...|stv-news-weather-n...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } popularepisodes={Query --------------------------------------------------- select pl.plays_total pl.plays_trailing_week prog.programmeName prog.archive prog.catchupSlug if(length(prog.programmeNiceName)>30 prog.programmeShortName prog.programmeNiceName) as programmeNiceName prog.programmeURL vc.videoDescription as summary tvl.runDateTime concat('/programmes/' programmeName '/' date_format(runDateTime '%Y-%m-%d-%H%i') '/') as permalink pc.slug as categorySlug pc.genre find_in_set("=GUIDANCE" vc.videoTags) as guidance concat(programmeName '-' date_format(runDateTime '%Y-%m-%d-%H%i')) as episodeName from player_programmes prog inner join stv_feeds.tvlistings tvl on tvl.programName = prog.programmeNiceName inner join player_categories pc on pc.genre = tvl.genre inner join player_parts pp on pp.scheduleDate = tvl.runDateTime inner join videocache vc on vc.videoRefID = pp.RefID inner join player_logging pl on pl.reference_id = pp.RefID and pp.part = 1 group by left(vc.videoDate 10) vc.videoRefID order by pl.plays_trailing_week desc limit 10 --------------------------------------------------- Execution Time: 371 --------------------------------------------------- Recordcount: 10 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |plays_total |plays_trailing_week |programmeName |archive |catchupSlug |programmeNiceName |programmeURL |summary |runDateTime |permalink |categorySlug |genre |guidance |episodeName | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |8116 |8116 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Becky leaves a tra...|{ts '2012-01-23 20...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |5549 |5549 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Becky and Kylie go...|{ts '2012-01-20 20...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |5088 |5088 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|It is Steve and Tr...|{ts '2012-01-23 19...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |4440 |4440 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Will Kylie stop Be...|{ts '2012-01-19 20...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |4239 |4239 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Becky seeks help f...|{ts '2012-01-20 19...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2944 |2944 |love-hate |0 |catchup-lovehate |Love/Hate |http://programmes....|Drama series set i...|{ts '2012-01-19 21...|/programmes/love-h...|drama-series |Drama Series |8 |love-hate-2012-01-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2702 |2702 |emmerdale |0 |catchup-emmerdale |Emmerdale |http://programmes....|Nicola warns Ashle...|{ts '2012-01-20 19...|/programmes/emmerd...|soaps |Soaps |0 |emmerdale-2012-01-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2658 |2658 |take-me-out |0 |catchup-takemeout |Take Me Out | |Paddy McGuinness p...|{ts '2012-01-21 19...|/programmes/take-m...|entertainment |Entertainment |0 |take-me-out-2012-0...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2483 |2483 |emmerdale |0 |catchup-emmerdale |Emmerdale |http://programmes....|Laurel is shocked ...|{ts '2012-01-19 20...|/programmes/emmerd...|soaps |Soaps |0 |emmerdale-2012-01-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2070 |2070 |emmerdale |0 |catchup-emmerdale |Emmerdale |http://programmes....|Laurel's plans for...|{ts '2012-01-19 19...|/programmes/emmerd...|soaps |Soaps |0 |emmerdale-2012-01-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } pagedescription={STV Video | Catch up on TV programmes shows soaps clips latest news sport entertainment showbiz gossip} pagetitle={STV Video | Catch up on TV programmes shows soaps clips latest news sport entertainment showbiz gossip} path_info={/} MOSTCOMMENTED={Query --------------------------------------------------- select vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vc.rating from videocache_new vc inner join video_comment_logging vl on vl.reference_id = vc.videoRefID where vc.isCatchup = 0 order by vl.comments limit 10 --------------------------------------------------- Execution Time: 22 --------------------------------------------------- Recordcount: 5 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |7031877001 | |Get Fit Rachel - L...|The five thirty sh...|{ts '1970-01-01 00...|get-fit-rachel-lac...|entertainment-five...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |25652378001 | |The world’s only w...|Islay woman Ailsa ...|{ts '1970-01-01 00...|the-worlds-only-wh...|entertainment-theh...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |54208705001 | |Supermarket under ...|Alcohol campaigner...|{ts '1970-01-01 00...|supermarket-under-...|news-091204-l2-drink | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |48371638001 | |When Bon Jovi rock...|New Jersey rockers...|{ts '1970-01-01 00...|when-bon-jovi-rock...|news-archive-09110...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |43211611001 | |Mowbray: I will bu...|Celtic boss lookin...|{ts '1970-01-01 00...|mowbray-i-will-buy...|sport-football-mow...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ }}
08:15:29.465 PM 1 ms interception [afterHandlerCreation] View
{event={general.index} pagekeywords={stv video tv shows soaps clips latest news sport entertainment showbiz gossip} urlparam={/bc/programmes-edgeoftheland-s01-e02/} MOSTPOPULAR={Query --------------------------------------------------- select vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vl.plays_trend vc.rating from videocache_new vc inner join video_logging vl on vl.videoid = vc.videoid where vc.videoDate > date_add(now() interval -7 day) and vc.isCatchup = 0 order by vl.plays_trailing_week desc limit 10 --------------------------------------------------- Execution Time: 165 --------------------------------------------------- Recordcount: 10 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |plays_trend |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |20946874001 | |Ella Edmondson sings |Ella Edmondson da...|{ts '1970-01-01 00...|ella-edmondson-sings |entertainment-five...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |55221454001 | |Rangers say Boyd d...|Martin Bain tells ...|{ts '1970-01-01 00...|rangers-say-boyd-d...|sport-football-boy...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |6262033001 | |Islanders mark 90-...|Residents of Lewis...|{ts '1970-01-01 00...|islanders-mark-90-...|news-headlines-nt-...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1847316428 | |Glen Michael is back |Glen Michael prob...|{ts '1970-01-01 00...|glen-michael-is-back |entertainment-five...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |50577224001 | |Central Scotland w...|The latest weather...|{ts '1970-01-01 00...|central-scotland-w...|stv-news-weather-s...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |50577222001 | |North of Scotland ...|The latest weather...|{ts '1970-01-01 00...|north-of-scotland-...|stv-news-weather-s...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |30481332001 | |Weather forecast f...|Sean Batty takes a...|{ts '1970-01-01 00...|weather-forecast-f...|scotland-thegather...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |20229945001 | |Old Firm English P...|Chairman of Englis...|{ts '1970-01-01 00...|old-firm-english-p...|news-090420-l2-old...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |18160924001 | |Scottish heather i...|"We want to turn t...|{ts '1970-01-01 00...|scottish-heather-i...|news-headlines-200...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |16951175001 | |Pressley: fearless...|Steven Pressley is...|{ts '1970-01-01 00...|pressley-fearless-...|sport-football-200...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } appname={STV Video} JUSTADDED={Query --------------------------------------------------- select vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vc.rating from videocache_new vc where vc.isCatchup = 0 group by vc.videoID order by vc.video_ModifiedDate desc limit 10 --------------------------------------------------- Execution Time: 2 --------------------------------------------------- Recordcount: 10 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448576666001 | |Dancing on Ice 201...|Chemmy and Sean gi...|{ts '1970-01-01 00...|dancing-on-ice-201...|programmes-dancing...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1447383307001 | |ITV News - Sunday ...|The Sun newspaper ...|{ts '1970-01-01 00...|itv-news-sunday-fe...|catchup-ac2-itvnew...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448569276001 | |STV News (Central ...|The SNP is giving ...|{ts '1970-01-01 00...|stv-news-central-e...|catchup-ac2-news-w...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448569281001 | |STV News (North ed...|The SNP is giving ...|{ts '1970-01-01 00...|stv-news-north-edi...|catchup-ac2-news-w...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448552739001 | |First Minister ins...|Alex Salmond will ...|{ts '1970-01-01 00...|first-minister-ins...|news-120212-g-inde...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448552727001 | |‘Suspicious’ house...|The blaze at a ten...|{ts '1970-01-01 00...|suspicious-house-f...|news-120212-g-fire | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448515721001 | |Police in six-hour...|The stand-off has ...|{ts '1970-01-01 00...|police-in-six-hour...|news-120212-g-siege | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448515715001 | |Teenager killed in...|A 52-year-old driv...|{ts '1970-01-01 00...|teenager-killed-in...|news-120212-g-crash2 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448552707001 | |catchup-ac2-mez-st...|catchup-ac2-mez-st...|{ts '1970-01-01 00...|catchup-ac2-mez-st...|catchup-ac2-mez-st...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448546655001 | |The Latest Forecas...|This is the latest...|{ts '1970-01-01 00...|the-latest-forecas...|stv-news-weather-n...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } popularepisodes={Query --------------------------------------------------- select pl.plays_total pl.plays_trailing_week prog.programmeName prog.archive prog.catchupSlug if(length(prog.programmeNiceName)>30 prog.programmeShortName prog.programmeNiceName) as programmeNiceName prog.programmeURL vc.videoDescription as summary tvl.runDateTime concat('/programmes/' programmeName '/' date_format(runDateTime '%Y-%m-%d-%H%i') '/') as permalink pc.slug as categorySlug pc.genre find_in_set("=GUIDANCE" vc.videoTags) as guidance concat(programmeName '-' date_format(runDateTime '%Y-%m-%d-%H%i')) as episodeName from player_programmes prog inner join stv_feeds.tvlistings tvl on tvl.programName = prog.programmeNiceName inner join player_categories pc on pc.genre = tvl.genre inner join player_parts pp on pp.scheduleDate = tvl.runDateTime inner join videocache vc on vc.videoRefID = pp.RefID inner join player_logging pl on pl.reference_id = pp.RefID and pp.part = 1 group by left(vc.videoDate 10) vc.videoRefID order by pl.plays_trailing_week desc limit 10 --------------------------------------------------- Execution Time: 371 --------------------------------------------------- Recordcount: 10 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |plays_total |plays_trailing_week |programmeName |archive |catchupSlug |programmeNiceName |programmeURL |summary |runDateTime |permalink |categorySlug |genre |guidance |episodeName | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |8116 |8116 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Becky leaves a tra...|{ts '2012-01-23 20...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |5549 |5549 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Becky and Kylie go...|{ts '2012-01-20 20...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |5088 |5088 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|It is Steve and Tr...|{ts '2012-01-23 19...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |4440 |4440 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Will Kylie stop Be...|{ts '2012-01-19 20...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |4239 |4239 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Becky seeks help f...|{ts '2012-01-20 19...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2944 |2944 |love-hate |0 |catchup-lovehate |Love/Hate |http://programmes....|Drama series set i...|{ts '2012-01-19 21...|/programmes/love-h...|drama-series |Drama Series |8 |love-hate-2012-01-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2702 |2702 |emmerdale |0 |catchup-emmerdale |Emmerdale |http://programmes....|Nicola warns Ashle...|{ts '2012-01-20 19...|/programmes/emmerd...|soaps |Soaps |0 |emmerdale-2012-01-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2658 |2658 |take-me-out |0 |catchup-takemeout |Take Me Out | |Paddy McGuinness p...|{ts '2012-01-21 19...|/programmes/take-m...|entertainment |Entertainment |0 |take-me-out-2012-0...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2483 |2483 |emmerdale |0 |catchup-emmerdale |Emmerdale |http://programmes....|Laurel is shocked ...|{ts '2012-01-19 20...|/programmes/emmerd...|soaps |Soaps |0 |emmerdale-2012-01-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2070 |2070 |emmerdale |0 |catchup-emmerdale |Emmerdale |http://programmes....|Laurel's plans for...|{ts '2012-01-19 19...|/programmes/emmerd...|soaps |Soaps |0 |emmerdale-2012-01-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } pagedescription={STV Video | Catch up on TV programmes shows soaps clips latest news sport entertainment showbiz gossip} pagetitle={STV Video | Catch up on TV programmes shows soaps clips latest news sport entertainment showbiz gossip} path_info={/} MOSTCOMMENTED={Query --------------------------------------------------- select vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vc.rating from videocache_new vc inner join video_comment_logging vl on vl.reference_id = vc.videoRefID where vc.isCatchup = 0 order by vl.comments limit 10 --------------------------------------------------- Execution Time: 22 --------------------------------------------------- Recordcount: 5 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |7031877001 | |Get Fit Rachel - L...|The five thirty sh...|{ts '1970-01-01 00...|get-fit-rachel-lac...|entertainment-five...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |25652378001 | |The world’s only w...|Islay woman Ailsa ...|{ts '1970-01-01 00...|the-worlds-only-wh...|entertainment-theh...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |54208705001 | |Supermarket under ...|Alcohol campaigner...|{ts '1970-01-01 00...|supermarket-under-...|news-091204-l2-drink | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |48371638001 | |When Bon Jovi rock...|New Jersey rockers...|{ts '1970-01-01 00...|when-bon-jovi-rock...|news-archive-09110...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |43211611001 | |Mowbray: I will bu...|Celtic boss lookin...|{ts '1970-01-01 00...|mowbray-i-will-buy...|sport-football-mow...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ }}
08:15:29.494 PM 26 ms invoking runEvent [general.index] View
{welcomemessage={Welcome to ColdBox!} pagekeywords={stv video tv shows soaps clips latest news sport entertainment showbiz gossip} EDITORSPICKS={Query --------------------------------------------------- select vp.playlistNiceName vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vc.rating from videocache_new vc inner join video_playlist_titles vpt on vpt.videoid = vc.videoid inner join video_playlists vp on vp.playlistID = vpt.playlistID where vp.playlistrefid = 'Editors-Picks' and isCatchup = 0 order by vpt.playlistRank asc limit 7 --------------------------------------------------- Execution Time: 19 --------------------------------------------------- Recordcount: 7 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |playlistNiceName |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1118657956001 | |Brad Pitt: Latest ...|The picture from ...|{ts '1970-01-01 00...|brad-pitt-latest-d...|stv-news-bradpitt | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1115914203001 | |Alexandra Burke & ...|Daily poll alert! ...|{ts '1970-01-01 00...|alexandra-burke-be...|xfactor2011-110808...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1115425249001 | |Bagpuss interviews...|It’s the interview...|{ts '1970-01-01 00...|bagpuss-interviews...|entertainment-fest...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1101773767001 | |Jedward sing Oops ...|Jedward performing...|{ts '1970-01-01 00...|jedward-sing-oops-...|xfactor2011-110808...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1117333807001 | |Gary Barlow reveal...|X Factor judge Gar...|{ts '1970-01-01 00...|gary-barlow-reveal...|xfactor2011-110819...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1112147714001 | |Back to School: Dr...|Psychiatrist Dr Al...|{ts '1970-01-01 00...|back-to-school-dr-...|entertainment-web-...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1092144367001 | |The X Factor Final...|The X Factor final...|{ts '1970-01-01 00...|the-x-factor-final...|xfactor2011-110802...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } urlparam={/bc/programmes-edgeoftheland-s01-e02/} pageid={home} path_info={/} VIDEOSTRUCT={{VIDEOSEQUENCE={1118657956001 1115914203001 1115425249001 1101773767001 1117333807001 1112147714001 1092144367001} VIDEOTOTAL={7} CURRENTVIDEO={1118657956001}}} JUSTADDED={Query --------------------------------------------------- select vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vc.rating from videocache_new vc where vc.isCatchup = 0 group by vc.videoID order by vc.video_ModifiedDate desc limit 10 --------------------------------------------------- Execution Time: 2 --------------------------------------------------- Recordcount: 10 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448576666001 | |Dancing on Ice 201...|Chemmy and Sean gi...|{ts '1970-01-01 00...|dancing-on-ice-201...|programmes-dancing...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1447383307001 | |ITV News - Sunday ...|The Sun newspaper ...|{ts '1970-01-01 00...|itv-news-sunday-fe...|catchup-ac2-itvnew...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448569276001 | |STV News (Central ...|The SNP is giving ...|{ts '1970-01-01 00...|stv-news-central-e...|catchup-ac2-news-w...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448569281001 | |STV News (North ed...|The SNP is giving ...|{ts '1970-01-01 00...|stv-news-north-edi...|catchup-ac2-news-w...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448552739001 | |First Minister ins...|Alex Salmond will ...|{ts '1970-01-01 00...|first-minister-ins...|news-120212-g-inde...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448552727001 | |‘Suspicious’ house...|The blaze at a ten...|{ts '1970-01-01 00...|suspicious-house-f...|news-120212-g-fire | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448515721001 | |Police in six-hour...|The stand-off has ...|{ts '1970-01-01 00...|police-in-six-hour...|news-120212-g-siege | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448515715001 | |Teenager killed in...|A 52-year-old driv...|{ts '1970-01-01 00...|teenager-killed-in...|news-120212-g-crash2 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448552707001 | |catchup-ac2-mez-st...|catchup-ac2-mez-st...|{ts '1970-01-01 00...|catchup-ac2-mez-st...|catchup-ac2-mez-st...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448546655001 | |The Latest Forecas...|This is the latest...|{ts '1970-01-01 00...|the-latest-forecas...|stv-news-weather-n...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } appname={STV Video} FEATUREDPLAYLISTS={Query --------------------------------------------------- select * from video_playlists where featured = 1 order by rand() --------------------------------------------------- Execution Time: 3 --------------------------------------------------- Recordcount: 0 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |id |playlistName |playlistNiceName |playlistTags |playlistid |playlistrefid |featured |playlistTotal |playlistThumb |firstVideo |public | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } RUNDATETIME={0} pagedescription={STV Video | Catch up on TV programmes shows soaps clips latest news sport entertainment showbiz gossip} popularepisodes={Query --------------------------------------------------- select pl.plays_total pl.plays_trailing_week prog.programmeName prog.archive prog.catchupSlug if(length(prog.programmeNiceName)>30 prog.programmeShortName prog.programmeNiceName) as programmeNiceName prog.programmeURL vc.videoDescription as summary tvl.runDateTime concat('/programmes/' programmeName '/' date_format(runDateTime '%Y-%m-%d-%H%i') '/') as permalink pc.slug as categorySlug pc.genre find_in_set("=GUIDANCE" vc.videoTags) as guidance concat(programmeName '-' date_format(runDateTime '%Y-%m-%d-%H%i')) as episodeName from player_programmes prog inner join stv_feeds.tvlistings tvl on tvl.programName = prog.programmeNiceName inner join player_categories pc on pc.genre = tvl.genre inner join player_parts pp on pp.scheduleDate = tvl.runDateTime inner join videocache vc on vc.videoRefID = pp.RefID inner join player_logging pl on pl.reference_id = pp.RefID and pp.part = 1 group by left(vc.videoDate 10) vc.videoRefID order by pl.plays_trailing_week desc limit 10 --------------------------------------------------- Execution Time: 371 --------------------------------------------------- Recordcount: 10 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |plays_total |plays_trailing_week |programmeName |archive |catchupSlug |programmeNiceName |programmeURL |summary |runDateTime |permalink |categorySlug |genre |guidance |episodeName | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |8116 |8116 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Becky leaves a tra...|{ts '2012-01-23 20...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |5549 |5549 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Becky and Kylie go...|{ts '2012-01-20 20...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |5088 |5088 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|It is Steve and Tr...|{ts '2012-01-23 19...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |4440 |4440 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Will Kylie stop Be...|{ts '2012-01-19 20...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |4239 |4239 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Becky seeks help f...|{ts '2012-01-20 19...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2944 |2944 |love-hate |0 |catchup-lovehate |Love/Hate |http://programmes....|Drama series set i...|{ts '2012-01-19 21...|/programmes/love-h...|drama-series |Drama Series |8 |love-hate-2012-01-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2702 |2702 |emmerdale |0 |catchup-emmerdale |Emmerdale |http://programmes....|Nicola warns Ashle...|{ts '2012-01-20 19...|/programmes/emmerd...|soaps |Soaps |0 |emmerdale-2012-01-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2658 |2658 |take-me-out |0 |catchup-takemeout |Take Me Out | |Paddy McGuinness p...|{ts '2012-01-21 19...|/programmes/take-m...|entertainment |Entertainment |0 |take-me-out-2012-0...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2483 |2483 |emmerdale |0 |catchup-emmerdale |Emmerdale |http://programmes....|Laurel is shocked ...|{ts '2012-01-19 20...|/programmes/emmerd...|soaps |Soaps |0 |emmerdale-2012-01-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2070 |2070 |emmerdale |0 |catchup-emmerdale |Emmerdale |http://programmes....|Laurel's plans for...|{ts '2012-01-19 19...|/programmes/emmerd...|soaps |Soaps |0 |emmerdale-2012-01-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } event={general.index} currentview={home} MOSTCOMMENTED={Query --------------------------------------------------- select vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vc.rating from videocache_new vc inner join video_comment_logging vl on vl.reference_id = vc.videoRefID where vc.isCatchup = 0 order by vl.comments limit 10 --------------------------------------------------- Execution Time: 22 --------------------------------------------------- Recordcount: 5 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |7031877001 | |Get Fit Rachel - L...|The five thirty sh...|{ts '1970-01-01 00...|get-fit-rachel-lac...|entertainment-five...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |25652378001 | |The world’s only w...|Islay woman Ailsa ...|{ts '1970-01-01 00...|the-worlds-only-wh...|entertainment-theh...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |54208705001 | |Supermarket under ...|Alcohol campaigner...|{ts '1970-01-01 00...|supermarket-under-...|news-091204-l2-drink | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |48371638001 | |When Bon Jovi rock...|New Jersey rockers...|{ts '1970-01-01 00...|when-bon-jovi-rock...|news-archive-09110...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |43211611001 | |Mowbray: I will bu...|Celtic boss lookin...|{ts '1970-01-01 00...|mowbray-i-will-buy...|sport-football-mow...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } MOSTPOPULAR={Query --------------------------------------------------- select vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vl.plays_trend vc.rating from videocache_new vc inner join video_logging vl on vl.videoid = vc.videoid where vc.videoDate > date_add(now() interval -7 day) and vc.isCatchup = 0 order by vl.plays_trailing_week desc limit 10 --------------------------------------------------- Execution Time: 165 --------------------------------------------------- Recordcount: 10 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |plays_trend |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |20946874001 | |Ella Edmondson sings |Ella Edmondson da...|{ts '1970-01-01 00...|ella-edmondson-sings |entertainment-five...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |55221454001 | |Rangers say Boyd d...|Martin Bain tells ...|{ts '1970-01-01 00...|rangers-say-boyd-d...|sport-football-boy...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |6262033001 | |Islanders mark 90-...|Residents of Lewis...|{ts '1970-01-01 00...|islanders-mark-90-...|news-headlines-nt-...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1847316428 | |Glen Michael is back |Glen Michael prob...|{ts '1970-01-01 00...|glen-michael-is-back |entertainment-five...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |50577224001 | |Central Scotland w...|The latest weather...|{ts '1970-01-01 00...|central-scotland-w...|stv-news-weather-s...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |50577222001 | |North of Scotland ...|The latest weather...|{ts '1970-01-01 00...|north-of-scotland-...|stv-news-weather-s...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |30481332001 | |Weather forecast f...|Sean Batty takes a...|{ts '1970-01-01 00...|weather-forecast-f...|scotland-thegather...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |20229945001 | |Old Firm English P...|Chairman of Englis...|{ts '1970-01-01 00...|old-firm-english-p...|news-090420-l2-old...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |18160924001 | |Scottish heather i...|"We want to turn t...|{ts '1970-01-01 00...|scottish-heather-i...|news-headlines-200...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |16951175001 | |Pressley: fearless...|Steven Pressley is...|{ts '1970-01-01 00...|pressley-fearless-...|sport-football-200...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } VIDEOPERMALINK={brad-pitt-latest-dramatic-scenes-from-glasgow-movie-set} currentlayout={Layout.Main.cfm} pagetitle={STV Video | Catch up on TV programmes shows soaps clips latest news sport entertainment showbiz gossip}}
08:15:29.507 PM 1 ms interception [afterPluginCreation] View
{welcomemessage={Welcome to ColdBox!} pagekeywords={stv video tv shows soaps clips latest news sport entertainment showbiz gossip} EDITORSPICKS={Query --------------------------------------------------- select vp.playlistNiceName vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vc.rating from videocache_new vc inner join video_playlist_titles vpt on vpt.videoid = vc.videoid inner join video_playlists vp on vp.playlistID = vpt.playlistID where vp.playlistrefid = 'Editors-Picks' and isCatchup = 0 order by vpt.playlistRank asc limit 7 --------------------------------------------------- Execution Time: 19 --------------------------------------------------- Recordcount: 7 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |playlistNiceName |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1118657956001 | |Brad Pitt: Latest ...|The picture from ...|{ts '1970-01-01 00...|brad-pitt-latest-d...|stv-news-bradpitt | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1115914203001 | |Alexandra Burke & ...|Daily poll alert! ...|{ts '1970-01-01 00...|alexandra-burke-be...|xfactor2011-110808...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1115425249001 | |Bagpuss interviews...|It’s the interview...|{ts '1970-01-01 00...|bagpuss-interviews...|entertainment-fest...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1101773767001 | |Jedward sing Oops ...|Jedward performing...|{ts '1970-01-01 00...|jedward-sing-oops-...|xfactor2011-110808...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1117333807001 | |Gary Barlow reveal...|X Factor judge Gar...|{ts '1970-01-01 00...|gary-barlow-reveal...|xfactor2011-110819...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1112147714001 | |Back to School: Dr...|Psychiatrist Dr Al...|{ts '1970-01-01 00...|back-to-school-dr-...|entertainment-web-...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1092144367001 | |The X Factor Final...|The X Factor final...|{ts '1970-01-01 00...|the-x-factor-final...|xfactor2011-110802...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } urlparam={/bc/programmes-edgeoftheland-s01-e02/} pageid={home} path_info={/} VIDEOSTRUCT={{VIDEOSEQUENCE={1118657956001 1115914203001 1115425249001 1101773767001 1117333807001 1112147714001 1092144367001} VIDEOTOTAL={7} CURRENTVIDEO={1118657956001}}} JUSTADDED={Query --------------------------------------------------- select vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vc.rating from videocache_new vc where vc.isCatchup = 0 group by vc.videoID order by vc.video_ModifiedDate desc limit 10 --------------------------------------------------- Execution Time: 2 --------------------------------------------------- Recordcount: 10 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448576666001 | |Dancing on Ice 201...|Chemmy and Sean gi...|{ts '1970-01-01 00...|dancing-on-ice-201...|programmes-dancing...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1447383307001 | |ITV News - Sunday ...|The Sun newspaper ...|{ts '1970-01-01 00...|itv-news-sunday-fe...|catchup-ac2-itvnew...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448569276001 | |STV News (Central ...|The SNP is giving ...|{ts '1970-01-01 00...|stv-news-central-e...|catchup-ac2-news-w...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448569281001 | |STV News (North ed...|The SNP is giving ...|{ts '1970-01-01 00...|stv-news-north-edi...|catchup-ac2-news-w...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448552739001 | |First Minister ins...|Alex Salmond will ...|{ts '1970-01-01 00...|first-minister-ins...|news-120212-g-inde...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448552727001 | |‘Suspicious’ house...|The blaze at a ten...|{ts '1970-01-01 00...|suspicious-house-f...|news-120212-g-fire | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448515721001 | |Police in six-hour...|The stand-off has ...|{ts '1970-01-01 00...|police-in-six-hour...|news-120212-g-siege | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448515715001 | |Teenager killed in...|A 52-year-old driv...|{ts '1970-01-01 00...|teenager-killed-in...|news-120212-g-crash2 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448552707001 | |catchup-ac2-mez-st...|catchup-ac2-mez-st...|{ts '1970-01-01 00...|catchup-ac2-mez-st...|catchup-ac2-mez-st...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1448546655001 | |The Latest Forecas...|This is the latest...|{ts '1970-01-01 00...|the-latest-forecas...|stv-news-weather-n...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } appname={STV Video} FEATUREDPLAYLISTS={Query --------------------------------------------------- select * from video_playlists where featured = 1 order by rand() --------------------------------------------------- Execution Time: 3 --------------------------------------------------- Recordcount: 0 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |id |playlistName |playlistNiceName |playlistTags |playlistid |playlistrefid |featured |playlistTotal |playlistThumb |firstVideo |public | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } RUNDATETIME={0} pagedescription={STV Video | Catch up on TV programmes shows soaps clips latest news sport entertainment showbiz gossip} popularepisodes={Query --------------------------------------------------- select pl.plays_total pl.plays_trailing_week prog.programmeName prog.archive prog.catchupSlug if(length(prog.programmeNiceName)>30 prog.programmeShortName prog.programmeNiceName) as programmeNiceName prog.programmeURL vc.videoDescription as summary tvl.runDateTime concat('/programmes/' programmeName '/' date_format(runDateTime '%Y-%m-%d-%H%i') '/') as permalink pc.slug as categorySlug pc.genre find_in_set("=GUIDANCE" vc.videoTags) as guidance concat(programmeName '-' date_format(runDateTime '%Y-%m-%d-%H%i')) as episodeName from player_programmes prog inner join stv_feeds.tvlistings tvl on tvl.programName = prog.programmeNiceName inner join player_categories pc on pc.genre = tvl.genre inner join player_parts pp on pp.scheduleDate = tvl.runDateTime inner join videocache vc on vc.videoRefID = pp.RefID inner join player_logging pl on pl.reference_id = pp.RefID and pp.part = 1 group by left(vc.videoDate 10) vc.videoRefID order by pl.plays_trailing_week desc limit 10 --------------------------------------------------- Execution Time: 371 --------------------------------------------------- Recordcount: 10 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |plays_total |plays_trailing_week |programmeName |archive |catchupSlug |programmeNiceName |programmeURL |summary |runDateTime |permalink |categorySlug |genre |guidance |episodeName | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |8116 |8116 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Becky leaves a tra...|{ts '2012-01-23 20...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |5549 |5549 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Becky and Kylie go...|{ts '2012-01-20 20...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |5088 |5088 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|It is Steve and Tr...|{ts '2012-01-23 19...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |4440 |4440 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Will Kylie stop Be...|{ts '2012-01-19 20...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |4239 |4239 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Becky seeks help f...|{ts '2012-01-20 19...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2944 |2944 |love-hate |0 |catchup-lovehate |Love/Hate |http://programmes....|Drama series set i...|{ts '2012-01-19 21...|/programmes/love-h...|drama-series |Drama Series |8 |love-hate-2012-01-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2702 |2702 |emmerdale |0 |catchup-emmerdale |Emmerdale |http://programmes....|Nicola warns Ashle...|{ts '2012-01-20 19...|/programmes/emmerd...|soaps |Soaps |0 |emmerdale-2012-01-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2658 |2658 |take-me-out |0 |catchup-takemeout |Take Me Out | |Paddy McGuinness p...|{ts '2012-01-21 19...|/programmes/take-m...|entertainment |Entertainment |0 |take-me-out-2012-0...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2483 |2483 |emmerdale |0 |catchup-emmerdale |Emmerdale |http://programmes....|Laurel is shocked ...|{ts '2012-01-19 20...|/programmes/emmerd...|soaps |Soaps |0 |emmerdale-2012-01-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2070 |2070 |emmerdale |0 |catchup-emmerdale |Emmerdale |http://programmes....|Laurel's plans for...|{ts '2012-01-19 19...|/programmes/emmerd...|soaps |Soaps |0 |emmerdale-2012-01-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } event={general.index} currentview={home} MOSTCOMMENTED={Query --------------------------------------------------- select vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vc.rating from videocache_new vc inner join video_comment_logging vl on vl.reference_id = vc.videoRefID where vc.isCatchup = 0 order by vl.comments limit 10 --------------------------------------------------- Execution Time: 22 --------------------------------------------------- Recordcount: 5 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |7031877001 | |Get Fit Rachel - L...|The five thirty sh...|{ts '1970-01-01 00...|get-fit-rachel-lac...|entertainment-five...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |25652378001 | |The world’s only w...|Islay woman Ailsa ...|{ts '1970-01-01 00...|the-worlds-only-wh...|entertainment-theh...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |54208705001 | |Supermarket under ...|Alcohol campaigner...|{ts '1970-01-01 00...|supermarket-under-...|news-091204-l2-drink | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |48371638001 | |When Bon Jovi rock...|New Jersey rockers...|{ts '1970-01-01 00...|when-bon-jovi-rock...|news-archive-09110...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |43211611001 | |Mowbray: I will bu...|Celtic boss lookin...|{ts '1970-01-01 00...|mowbray-i-will-buy...|sport-football-mow...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } MOSTPOPULAR={Query --------------------------------------------------- select vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vl.plays_trend vc.rating from videocache_new vc inner join video_logging vl on vl.videoid = vc.videoid where vc.videoDate > date_add(now() interval -7 day) and vc.isCatchup = 0 order by vl.plays_trailing_week desc limit 10 --------------------------------------------------- Execution Time: 165 --------------------------------------------------- Recordcount: 10 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |plays_trend |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |20946874001 | |Ella Edmondson sings |Ella Edmondson da...|{ts '1970-01-01 00...|ella-edmondson-sings |entertainment-five...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |55221454001 | |Rangers say Boyd d...|Martin Bain tells ...|{ts '1970-01-01 00...|rangers-say-boyd-d...|sport-football-boy...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |6262033001 | |Islanders mark 90-...|Residents of Lewis...|{ts '1970-01-01 00...|islanders-mark-90-...|news-headlines-nt-...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1847316428 | |Glen Michael is back |Glen Michael prob...|{ts '1970-01-01 00...|glen-michael-is-back |entertainment-five...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |50577224001 | |Central Scotland w...|The latest weather...|{ts '1970-01-01 00...|central-scotland-w...|stv-news-weather-s...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |50577222001 | |North of Scotland ...|The latest weather...|{ts '1970-01-01 00...|north-of-scotland-...|stv-news-weather-s...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |30481332001 | |Weather forecast f...|Sean Batty takes a...|{ts '1970-01-01 00...|weather-forecast-f...|scotland-thegather...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |20229945001 | |Old Firm English P...|Chairman of Englis...|{ts '1970-01-01 00...|old-firm-english-p...|news-090420-l2-old...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |18160924001 | |Scottish heather i...|"We want to turn t...|{ts '1970-01-01 00...|scottish-heather-i...|news-headlines-200...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |16951175001 | |Pressley: fearless...|Steven Pressley is...|{ts '1970-01-01 00...|pressley-fearless-...|sport-football-200...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } VIDEOPERMALINK={brad-pitt-latest-dramatic-scenes-from-glasgow-movie-set} currentlayout={Layout.Main.cfm} pagetitle={STV Video | Catch up on TV programmes shows soaps clips latest news sport entertainment showbiz gossip}}
08:15:29.514 PM 2 ms rendering View [common/head.cfm] ...
08:15:29.516 PM 2 ms rendering View [common/header.cfm] ...
08:15:29.540 PM 2 ms rendering View [views/viewlets/socialbookmark.cfm] ...
08:15:29.541 PM 1 ms rendering View [views/viewlets/sendtofriend.cfm] ...
08:15:29.547 PM 5 ms rendering View [views/viewlets/featuredvideo.cfm] ...
08:15:29.552 PM 4 ms rendering View [views/viewlets/justadded.cfm] ...
08:15:29.556 PM 4 ms rendering View [views/viewlets/mostdiscussed.cfm] ...
08:15:29.561 PM 4 ms rendering View [views/viewlets/mostpopular.cfm] ...
08:15:29.561 PM 45 ms rendering View [home.cfm] ...
08:15:29.564 PM 2 ms rendering View [common/footer.cfm] ...
08:15:29.566 PM 1 ms rendering View [common/ads.cfm] ...
08:15:29.568 PM 2 ms rendering View [common/javascript.cfm] ...
08:15:29.568 PM 58 ms rendering Layout [Layout.Main.cfm] ...
Total Framework Request Execution Time: 740 ms
>  ColdBox Cache

Cache Performance
Hit Ratio: 48.72% ==> Hits: 19 | Misses: 20 | Evictions: 0 | Garbage Collections: 0
JVM Memory Stats
19.13 % Free | JVM Threshold:0% (0=Unlimited) | Total Assigned Memory: 1,551,736 KB | Max JVM Memory: 3,063,488 KB
Last Reap
Feb-12-2012 08:15:28 PM
Reap Frequency
Every 1 Minute(s)
Eviction Policy
LRU
Default Timeout
60 Minutes
Last Access Timeout
30 Minutes
Total Objects in Cache
11 / 100 (0=Unlimited)
2477367.484375 586120.515625

Cache Content Report (Time: 08:15:33 PM)

Object Hits Timeout (Min) Created Last Accessed Expires On CMDS
interceptor-coldbox.system.interceptors.autowire 1 0 Feb-12
08:15:28 PM		 Feb-12
08:15:28 PM		 ---
interceptor-coldbox.system.interceptors.environmentControl 2 0 Feb-12
08:15:28 PM		 Feb-12
08:15:28 PM		 ---
interceptor-coldbox.system.interceptors.ses 2 0 Feb-12
08:15:28 PM		 Feb-12
08:15:28 PM		 ---
plugin-beanFactory 7 0 Feb-12
08:15:28 PM		 Feb-12
08:15:29 PM		 ---
plugin-json 1 60 Feb-12
08:15:28 PM		 Feb-12
08:15:28 PM		 Feb-12
09:15:28 PM
plugin-logger 1 60 Feb-12
08:15:28 PM		 Feb-12
08:15:28 PM		 Feb-12
09:15:28 PM
plugin-methodInjector 4 60 Feb-12
08:15:28 PM		 Feb-12
08:15:29 PM		 Feb-12
09:15:28 PM
plugin-sessionstorage 2 60 Feb-12
08:15:28 PM		 Feb-12
08:15:30 PM		 Feb-12
09:15:28 PM
plugin-Utilities 4 5 Feb-12
08:15:28 PM		 Feb-12
08:15:30 PM		 Feb-12
08:20:28 PM
programmes 1 0 Feb-12
08:15:28 PM		 Feb-12
08:15:28 PM		 ---
video 9 0 Feb-12
08:15:29 PM		 Feb-12
08:15:29 PM		 ---
>  Request Collection Structure
welcomemessage: Welcome to ColdBox!
pagekeywords: stv, video, tv, shows, soaps, clips, latest news, sport, entertainment, showbiz, gossip
editorspicks:
Query
SQL select vp.playlistNiceName, vc.videoID, vc.videoPlaylist, vc.video_title, vc.videoDescription, sec_to_time((vc.videoLength/1000)) as runTime, vc.videoSlug as permalink, vc.videorefid, vc.rating from videocache_new vc inner join video_playlist_titles vpt on vpt.videoid = vc.videoid inner join video_playlists vp on vp.playlistID = vpt.playlistID where vp.playlistrefid = 'Editors-Picks' and isCatchup = 0 order by vpt.playlistRank asc limit 7
Execution Time (ms) 19
recordcount 7
cached No
result
playlistNiceName videoID videoPlaylist video_title videoDescription runTime permalink videorefid rating
Editor's Picks 1118657956001 Brad Pitt: Latest dramatic scenes from Glasgow movie set The picture, from zombie flick World War Z, shows a bin lorry colliding into a row of cars as pedestrians flee for their lives. {ts '1970-01-01 00:01:51'} brad-pitt-latest-dramatic-scenes-from-glasgow-movie-set stv-news-bradpitt
Editor's Picks 1115914203001 Alexandra Burke & Beyonce's Duet (2008) Daily poll alert! You voted en masse to watch Alexandra Burke's dazzling duet with Beyonce from 2008's X Factor show. 'Listen,' and enjoy! {ts '1970-01-01 00:03:56'} alexandra-burke-beyonces-duet-2008 xfactor2011-110808-ps-alexduet
Editor's Picks 1115425249001 Bagpuss interviews Kevin Cruise at the Edinburgh Fringe 2011 It’s the interview the world has been waiting for, as "old, saggy cloth cat” children’s favourite Bagpuss poses some tough questions for Britain’s Got Talent cruise-ship entertainer Kevin Cruise. {ts '1970-01-01 00:04:27'} bagpuss-interviews-kevin-cruise-at-the-edinburgh-fringe-2011 entertainment-festivals-bagpuss-kevin-cruise-20110817
Editor's Picks 1101773767001 Jedward sing Oops I Did It Again (2009) voted wackiest X Factor moment ever Jedward performing Oops I Did It Again by Britney Spears has been voted X Factor's wackiest moment. Watch the video again. {ts '1970-01-01 00:04:04'} jedward-sing-oops-i-did-it-again-2009-voted-wackiest-x-factor-moment-ever xfactor2011-110808-ps-jedward
Editor's Picks 1117333807001 Gary Barlow reveals all about the X Factor 2011 X Factor judge Gary Barlow gives us a sneak peek into the new series. {ts '1970-01-01 00:02:16'} gary-barlow-reveals-all xfactor2011-110819-bs-gary
Editor's Picks 1112147714001 Back to School: Dr Alex’s tips on settling in without stress Psychiatrist Dr Alex Yellowlees is on The Hour sofa with some tips and advice for young people to minimise anxiety and to help them fit in at school. Broadcast Thursday, August 18, 2011. {ts '1970-01-01 00:02:40'} back-to-school-dr-alexs-tips-on-settling-in-without-stress entertainment-web-thehour-20110816-fitting-in
Editor's Picks 1092144367001 The X Factor Finalists - You Are Not Alone (2009) The X Factor finalists perform Michael Jackson's You Are Not Alone for charity in 2009. {ts '1970-01-01 00:04:13'} the-x-factor-finalists-you-are-not-alone-2009 xfactor2011-110802-ps-s6youarenotalone.mp4
urlparam: /bc/programmes-edgeoftheland-s01-e02/
pageid: home
path_info: /
videostruct:
Struct
CURRENTVIDEO
number 1118657956001
VIDEOSEQUENCE
string 1118657956001,1115914203001,1115425249001,1101773767001,1117333807001,1112147714001,1092144367001
VIDEOTOTAL
number 7
justadded:
Query
SQL select vc.videoID, vc.videoPlaylist, vc.video_title, vc.videoDescription, sec_to_time((vc.videoLength/1000)) as runTime, vc.videoSlug as permalink, vc.videorefid, vc.rating from videocache_new vc where vc.isCatchup = 0 group by vc.videoID order by vc.video_ModifiedDate desc limit 10
Execution Time (ms) 2
recordcount 10
cached No
result
videoID videoPlaylist video_title videoDescription runTime permalink videorefid rating
1448576666001 Dancing on Ice 2012 - Chemmy Alcott week 6 performance Chemmy and Sean give a feisty Valentine's performance. {ts '1970-01-01 00:04:36'} dancing-on-ice-2012-chemmy-alcott-week-6-performance programmes-dancingonice-20120212-chemmy-alcott-week-6-performance
1447383307001 ITV News - Sunday, February 12, 9.20am The Sun newspaper faces a crisis after senior staff were arrested and Rupert Murdoch plans to fly to London. {ts '1970-01-01 00:13:02'} itv-news-sunday-february-12-920am catchup-ac2-itvnews-20120212-0920
1448569276001 STV News (Central edition) 5.45pm - Sunday, February 12, 2012 The SNP is giving the Westminster government another hands-off the referendum warning ahead of the meeting tomorrow between First Minister Alex Salmond and Scottish Secretary Michael Moore. {ts '1970-01-01 00:09:41'} stv-news-central-edition-545pm-sunday-february-12-2012 catchup-ac2-news-weekend-central-20120212
1448569281001 STV News (North edition) 5.45pm - Sunday, February 12, 2012 The SNP is giving the Westminster government another hands-off the referendum warning ahead of the meeting tomorrow between First Minister Alex Salmond and Scottish Secretary Michael Moore. {ts '1970-01-01 00:09:40'} stv-news-north-edition-545pm-sunday-february-12-2012 catchup-ac2-news-weekend-north-20120212
1448552739001 First Minister insists on ‘no-strings’ independence vote Alex Salmond will meet Secretary of State for Scotland Michael Moore on Monday to discuss plans for the referendum scheduled for autumn 2014. {ts '1970-01-01 00:01:22'} first-minister-insists-on-no-strings-independence-vote news-120212-g-independence
1448552727001 ‘Suspicious’ house fire under police probe The blaze at a tenement in Perth saw one person taken to hospital. {ts '1970-01-01 00:00:40'} suspicious-house-fire-under-police-probe news-120212-g-fire
1448515721001 Police in six-hour siege at Newton Mearns house The stand-off has seen two men injured and a further two detained by officers. {ts '1970-01-01 00:00:22'} police-in-six-hour-siege-at-newton-mearns-house news-120212-g-siege
1448515715001 Teenager killed in East Kilbride road crash named A 52-year-old driver has also died in a separate incident in Ayrshire. {ts '1970-01-01 00:00:34'} teenager-killed-in-east-kilbride-road-crash-named news-120212-g-crash2
1448552707001 catchup-ac2-mez-stvnewscentralsuntea-20120212-1729.mpg catchup-ac2-mez-stvnewscentralsuntea-20120212-1729.mpg {ts '1970-01-01 00:05:05'} catchup-ac2-mez-stvnewscentralsuntea-20120212-1729mpg catchup-ac2-mez-stvnewscentralsuntea-20120212-1729.mpg
1448546655001 The Latest Forecast: North of Scotland This is the latest weather forecast for the north of Scotland, posted at 17:34 on Sunday, February 12. {ts '1970-01-01 00:01:59'} the-latest-forecast-north-of-scotland stv-news-weather-north-20120212
appname: STV Video
featuredplaylists:
Query
SQL select * from video_playlists where featured = 1 order by rand()
Execution Time (ms) 3
recordcount 0
cached No
result
id playlistName playlistNiceName playlistTags playlistid playlistrefid featured playlistTotal playlistThumb firstVideo public
rundatetime: 0
pagedescription: STV Video | Catch up on TV programmes, shows, soaps, clips, latest news, sport, entertainment, showbiz, gossip
popularepisodes:
Query
SQL select pl.plays_total, pl.plays_trailing_week, prog.programmeName, prog.archive, prog.catchupSlug, if(length(prog.programmeNiceName)>30,prog.programmeShortName,prog.programmeNiceName) as programmeNiceName, prog.programmeURL, vc.videoDescription as summary, tvl.runDateTime, concat('/programmes/',programmeName,'/',date_format(runDateTime,'%Y-%m-%d-%H%i'),'/') as permalink, pc.slug as categorySlug, pc.genre, find_in_set("=GUIDANCE",vc.videoTags) as guidance, concat(programmeName,'-',date_format(runDateTime,'%Y-%m-%d-%H%i')) as episodeName from player_programmes prog inner join stv_feeds.tvlistings tvl on tvl.programName = prog.programmeNiceName inner join player_categories pc on pc.genre = tvl.genre inner join player_parts pp on pp.scheduleDate = tvl.runDateTime inner join videocache vc on vc.videoRefID = pp.RefID inner join player_logging pl on pl.reference_id = pp.RefID and pp.part = 1 group by left(vc.videoDate,10), vc.videoRefID order by pl.plays_trailing_week desc limit 10
Execution Time (ms) 371
recordcount 10
cached No
result
plays_total plays_trailing_week programmeName archive catchupSlug programmeNiceName programmeURL summary runDateTime permalink categorySlug genre guidance episodeName
8116 8116 coronation-street 0 catchup-coronationstreet Coronation Street http://programmes.stv.tv/coronation-street/ Becky leaves a trail of destruction in her wake. Can Steve salvage his relationship? Mary and Norris set out to dupe Sylvia. {ts '2012-01-23 20:30:00'} /programmes/coronation-street/2012-01-23-2030/ soaps Soaps 0 coronation-street-2012-01-23-2030
5549 5549 coronation-street 0 catchup-coronationstreet Coronation Street http://programmes.stv.tv/coronation-street/ Becky and Kylie go to desperate measures. Eileen is left overwhelmed. Have Owen's actions cost him his relationship? {ts '2012-01-20 20:30:00'} /programmes/coronation-street/2012-01-20-2030/ soaps Soaps 0 coronation-street-2012-01-20-2030
5088 5088 coronation-street 0 catchup-coronationstreet Coronation Street http://programmes.stv.tv/coronation-street/ It is Steve and Tracy's big day but all eyes are on Becky. The pressure mounts for Frank and Carla. Sylvia will not let Roy stand in the way of romance. {ts '2012-01-23 19:30:00'} /programmes/coronation-street/2012-01-23-1930/ soaps Soaps 0 coronation-street-2012-01-23-1930
4440 4440 coronation-street 0 catchup-coronationstreet Coronation Street http://programmes.stv.tv/coronation-street/ Will Kylie stop Becky from jeopardising her future? Anna reads Owen the riot act. Kirsty has to swallow her pride but Tina remains unforgiving. {ts '2012-01-19 20:30:00'} /programmes/coronation-street/2012-01-19-2030/ soaps Soaps 0 coronation-street-2012-01-19-2030
4239 4239 coronation-street 0 catchup-coronationstreet Coronation Street http://programmes.stv.tv/coronation-street/ Becky seeks help from an unlikely ally. Can Eileen handle looking after Lesley alone? Steve has some good news for Tracy. {ts '2012-01-20 19:30:00'} /programmes/coronation-street/2012-01-20-1930/ soaps Soaps 0 coronation-street-2012-01-20-1930
2944 2944 love-hate 0 catchup-lovehate Love/Hate http://programmes.stv.tv/love-hate/ Drama series set in Dublin's gangland. John Boy decides to cross Fran when a drugs shipment is busted down at the docks. <strong>GUIDANCE:</strong> Contains scenes of violence, strong language and drug taking from the outset. {ts '2012-01-19 21:00:00'} /programmes/love-hate/2012-01-19-2100/ drama-series Drama Series 8 love-hate-2012-01-19-2100
2702 2702 emmerdale 0 catchup-emmerdale Emmerdale http://programmes.stv.tv/emmerdale/ Nicola warns Ashley that it is time to forgive and forget if he is to win Laurel back. Gennie is embarrassed when Nikhil is ready to move in. Hazel is hopeful as Aaron seems excited by her plans. {ts '2012-01-20 19:00:00'} /programmes/emmerdale/2012-01-20-1900/ soaps Soaps 0 emmerdale-2012-01-20-1900
2658 2658 take-me-out 0 catchup-takemeout Take Me Out Paddy McGuinness presents the madcap dating show in which he tries to find dates for 30 single girls. This is Catch-Up. Competition may now be closed; if so, do not enter. {ts '2012-01-21 19:00:00'} /programmes/take-me-out/2012-01-21-1900/ entertainment Entertainment 0 take-me-out-2012-01-21-1900
2483 2483 emmerdale 0 catchup-emmerdale Emmerdale http://programmes.stv.tv/emmerdale/ Laurel is shocked by Ashley's reaction to her suspected pregnancy. Carl has no choice but to agree to Rodney's demands. The Spencers' money troubles escalate. {ts '2012-01-19 20:00:00'} /programmes/emmerdale/2012-01-19-2000/ soaps Soaps 0 emmerdale-2012-01-19-2000
2070 2070 emmerdale 0 catchup-emmerdale Emmerdale http://programmes.stv.tv/emmerdale/ Laurel's plans for the future take an unexpected turn. Rodney vows to bleed Carl dry for setting him up. Zak dreads it when Lisa makes a fuss for his 60th birthday. {ts '2012-01-19 19:00:00'} /programmes/emmerdale/2012-01-19-1900/ soaps Soaps 0 emmerdale-2012-01-19-1900
event: general.index
currentview: home
mostcommented:
Query
SQL select vc.videoID, vc.videoPlaylist, vc.video_title, vc.videoDescription, sec_to_time((vc.videoLength/1000)) as runTime, vc.videoSlug as permalink, vc.videorefid, vc.rating from videocache_new vc inner join video_comment_logging vl on vl.reference_id = vc.videoRefID where vc.isCatchup = 0 order by vl.comments limit 10
Execution Time (ms) 22
recordcount 5
cached No
result
videoID videoPlaylist video_title videoDescription runTime permalink videorefid rating
7031877001 Get Fit Rachel - Lacrosse The five thirty show's Rachel McTavish tries her hand at field sport lacrosse as an alternative way to keeping fit. {ts '1970-01-01 00:03:31'} get-fit-rachel-lacrosse entertainment-fivethirty-20090112-lacrosse
25652378001 The world’s only whisky soap Islay woman Ailsa Hayes has embraced the local ingredients of the island, namely the eight distilleries, to create the world’s only whisky soap. {ts '1970-01-01 00:03:19'} the-worlds-only-whisky-soap entertainment-thehour-20090605-islay-soaps
54208705001 Supermarket under fire over cheap beer prices Alcohol campaigners say selling drink so cheaply will encourage people to buy and consume more than normal. {ts '1970-01-01 00:01:39'} supermarket-under-fire-over-cheap-beer-prices news-091204-l2-drink
48371638001 When Bon Jovi rocked the streets of Glasgow New Jersey rockers brought Argyle Street to a halt in 1995 with a special performance. {ts '1970-01-01 00:01:44'} when-bon-jovi-rocked-the-streets-of-glasgow news-archive-091105-jovi
43211611001 Mowbray: I will buy in January Celtic boss looking to improve squad when transfer window opens. {ts '1970-01-01 00:01:04'} mowbray-i-will-buy-in-january sport-football-mowbray-competition-20091002
mostpopular:
Query
SQL select vc.videoID, vc.videoPlaylist, vc.video_title, vc.videoDescription, sec_to_time((vc.videoLength/1000)) as runTime, vc.videoSlug as permalink, vc.videorefid, vl.plays_trend, vc.rating from videocache_new vc inner join video_logging vl on vl.videoid = vc.videoid where vc.videoDate > date_add(now(),interval -7 day) and vc.isCatchup = 0 order by vl.plays_trailing_week desc limit 10
Execution Time (ms) 165
recordcount 10
cached No
result
videoID videoPlaylist video_title videoDescription runTime permalink videorefid plays_trend rating
20946874001 Ella Edmondson sings Ella Edmondson, daughter of Adrian Edmondson and Jennifer Saunders, makes her STV debut. Doesn't she look like her Mum! {ts '1970-01-01 00:03:32'} ella-edmondson-sings entertainment-fivethirty-20090424-ella-edmondson-peformance 1
55221454001 Rangers say Boyd discussions have opened Martin Bain tells AGM he has had talks with Boyd’s agent. {ts '1970-01-01 00:00:55'} rangers-say-boyd-discussions-have-opened sport-football-boyd-20091208 1
6262033001 Islanders mark 90-year anniversary of Iolaire tragedy Residents of Lewis have commemorated the maritime accident which claimed the lives of 200 sailors. {ts '1970-01-01 00:01:13'} islanders-mark-90-year-anniversary-of-iolaire-tragedy news-headlines-nt-iolaire-090102 1
1847316428 Glen Michael is back Glen Michael, probably the most popular children's entertainer Scotland has ever seen, returns to stv to discuss his new Hollywood film role. {ts '1970-01-01 00:08:18'} glen-michael-is-back entertainment-fivethirty-20081009-glen-michael-int 1
50577224001 Central Scotland weather - Tuesday, November 17 The latest weather forecast for central Scotland, presented by Sean Batty. {ts '1970-01-01 00:01:45'} central-scotland-weather-tuesday-november-17 stv-news-weather-six-central-200911-16 0
50577222001 North of Scotland weather - Tuesday, November 17 The latest weather forecast for the north of Scotland, presented by Sean Batty. {ts '1970-01-01 00:01:46'} north-of-scotland-weather-tuesday-november-17 stv-news-weather-six-north-20091016 0
30481332001 Weather forecast for The Gathering Sean Batty takes a look at the weather forecast for The Gathering event taking place this weekend in Edinburgh. {ts '1970-01-01 00:01:14'} weather-forecast-for-the-gathering scotland-thegathering-20090723-weather-forecast 0
20229945001 Old Firm English Premier League move considered Chairman of English club suggests Celtic and Rangers could join division two of new English Premier League. {ts '1970-01-01 00:01:20'} old-firm-english-premier-league-move-considered news-090420-l2-oldfirm 0
18160924001 Scottish heather is new aphrodisiac "We want to turn the world on to heather and heather to turn the world on", says spokesman. {ts '1970-01-01 00:02:12'} scottish-heather-is-new-aphrodisiac news-headlines-20090401-heather-aphrodisiac-properties 0
16951175001 Pressley: fearless Scotland will have a go against Holland Steven Pressley is backing Scotland’s young guns to come out victorious when they come against the dangerous Holland side in the World Cup qualifier in Amsterdam next week. {ts '1970-01-01 00:01:44'} pressley-fearless-scotland-will-have-a-go-against-holland sport-football-20090319-pressley 0
videopermalink: brad-pitt-latest-dramatic-scenes-from-glasgow-movie-set
currentlayout: Layout.Main.cfm
pagetitle: STV Video | Catch up on TV programmes, shows, soaps, clips, latest news, sport, entertainment, showbiz, gossip
Approximate Debug Rendering Time: 4520 ms