| 0.0002 |
SELECT vc.*
FROM video_categories AS vc
WHERE vc.category_url_lt LIKE 'auto-moto-video'
LIMIT 1
#getCategoryInfoByName LT
|
| 0.0001 |
SELECT vc.*
FROM video_categories AS vc
WHERE vc.category_url_en LIKE 'auto-moto-video'
LIMIT 1
#getCategoryInfoByName EN
|
| 0.0055 |
#video_model getNewestVideoListByCatId
SELECT SQL_CALC_FOUND_ROWS v.*, CASE WHEN(v.publish_date > DATE('2026-03-16') + INTERVAL -1 DAY) THEN 1 ELSE 0 END AS video_is_new
FROM video AS v
INNER JOIN video_has_categories AS vhc ON v.id=vhc.fk_video_id
WHERE 1=1 AND vhc.fk_video_categories_id = 1 AND
(v.show_lang = 'en' OR v.show_lang = 'all') AND
v.show_status = '1'
ORDER BY v.publish_date DESC
LIMIT 27, 27
|
| 0.0001 |
SELECT FOUND_ROWS() as fr
|
| 0.0002 |
SELECT *
FROM (`video_categories`)
WHERE `show_status` = '1'
ORDER BY `sort`
|
