short - intresting - videos

Newest short.lt video | Best video of the day | Best video of the week | Best video of the month

All short video, funny video, video with children, animals video, cars video and some more short video (2020 spalis)

  BENCHMARKS  
Loading Time: Base Classes  0.0019
Controller Execution Time ( Listing / Index )  0.0117
Total Execution Time  0.0136
  GET DATA  
No GET data exists
  MEMORY USAGE  
637,424 bytes
  POST DATA  
No POST data exists
  URI STRING  
video-list/all-videos/2020-10
  CLASS/METHOD  
listing/index
  DATABASE:  u278561375_short   QUERIES: 6  (Hide)
0.0006   SELECT vc.*
                      
FROM video_categories AS vc
                     WHERE vc
.category_url_lt LIKE 'all-videos'
                     
LIMIT 1
                     
#getCategoryInfoByName LT 
0.0001   SELECT vc.*
                          
FROM video_categories AS vc
                         WHERE vc
.category_url_en LIKE 'all-videos'
                         
LIMIT 1
                         
#getCategoryInfoByName EN 
0.0016   #getExsistingVideoDates
                
SELECT YEAR(publish_date) AS yearDATE_FORMAT(publish_date'%m') as monthCOUNT(id)
                
FROM video
                GROUP BY year
month
                HAVING year 
0
                ORDER BY year DESC
month DESC 
0.0018   SELECT SQL_CALC_FOUND_ROWS *, CASWHEN (publish_date DATE(2026-03-11) + INTERVAL -1 DAY) THEN 1 ELSE 0 END AS video_is_new
FROM 
(`video`)
WHERE `show_status` =  '1'
AND (show_lang 'en' OR show_lang 'all')
AND 
date(publish_date) >= '2020-10-01' AND date(publish_date) < '2020-10-01' INTERVAL 1 MONTH
ORDER BY 
`publish_datedesc 
0.0001   SELECT FOUND_ROWS() as fr 
0.0002   SELECT *
FROM (`video_categories`)
WHERE `show_status` =  '1'
ORDER BY `sort
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)