| 0.0019 |
#video pagal pavadinima - ieskom lietuviskose
SELECT *
FROM video
WHERE url_lt = '2011-humancar-inc-imagine-ps-phev-power-station' AND show_status = '1'
|
| 0.0425 |
#video pagal pavadinima - ieskom angliskose
SELECT *
FROM video
WHERE url_en = '2011-humancar-inc-imagine-ps-phev-power-station' AND show_status = '1'
|
| 0.0016 |
SELECT vcat.*
FROM video_categories AS vcat
INNER JOIN video_has_categories AS vhc ON vhc.fk_video_categories_id=vcat.id
WHERE vhc.fk_video_id =437
#get_video_categories
|
| 0.0002 |
SELECT *
FROM (`video_categories`)
WHERE `show_status` = '1'
ORDER BY `sort`
|
| 0.0013 |
#video_model getNewestVideoListByCatId
SELECT SQL_CALC_FOUND_ROWS v.*, CASE WHEN(v.publish_date > DATE('2026-03-10') + INTERVAL -1 DAY) THEN 1 ELSE 0 END AS video_is_new
FROM video AS v
WHERE 1=1 AND
(v.show_lang = 'en' OR v.show_lang = 'all') AND
v.show_status = '1'
ORDER BY v.publish_date DESC
LIMIT 0, 15
|
| 0.0019 |
SELECT FOUND_ROWS() as fr
|
| 0.0004 |
SELECT *, CASE WHEN(video.publish_date > DATE('2026-03-10') + INTERVAL -1 DAY) THEN 1 ELSE 0 END AS video_is_new
FROM (`video`)
JOIN `video_has_categories` ON `video`.`id` = `video_has_categories`.`fk_video_id`
WHERE `video_has_categories`.`fk_video_categories_id` = 8
AND `video`.`id` < '437'
AND `video`.`show_status` = '1'
ORDER BY `video`.`id` DESC
LIMIT 15
|
| 0.0152 |
#sekantis video by cat
SELECT video.*
FROM video
INNER JOIN video_has_categories AS vhc ON video.id = vhc.fk_video_id
WHERE publish_date < '2010-10-05 22:10:41'
AND (show_lang = 'all' OR show_lang = 'en')
AND show_status = '1'
AND vhc.fk_video_categories_id = 8
ORDER BY publish_date DESC
LIMIT 1
|
| 0.0157 |
#video_model getTopVideoList - month
SELECT SQL_CALC_FOUND_ROWS v.*,
CASE WHEN(v.publish_date > DATE('2026-03-10') + INTERVAL -1 DAY) THEN 1 ELSE 0 END AS video_is_new
FROM top_video__month AS topv
JOIN video AS v ON v.id = topv.id
WHERE (v.show_lang = 'en' OR v.show_lang = 'all') AND
v.show_status = '1'
ORDER BY topv.total_visits DESC, v.publish_date DESC
LIMIT 0, 20
|
| 0.0011 |
SELECT FOUND_ROWS() as fr
|
| 0.0116 |
#video_model getTopVideoList - month
SELECT SQL_CALC_FOUND_ROWS v.*,
CASE WHEN(v.publish_date > DATE('2026-03-10') + INTERVAL -1 DAY) THEN 1 ELSE 0 END AS video_is_new
FROM top_video__month AS topv
JOIN video AS v ON v.id = topv.id
LEFT JOIN video_has_categories AS vhc ON vhc.fk_video_id = v.id
WHERE (v.show_lang = 'en' OR v.show_lang = 'all') AND
v.show_status = '1'
AND vhc.fk_video_categories_id = 8
ORDER BY topv.total_visits DESC, v.publish_date DESC
LIMIT 0, 11
|
| 0.0027 |
SELECT FOUND_ROWS() as fr
|
![Tank chassis bolt-on conversion [ENG]subtitles](https://short.lt/img/video-thumbs/210x164/crop_1486496776.jpg)
