| 0.0004 |
SELECT vc.* FROM video_categories AS vc WHERE vc.category_url_lt LIKE 'all-videos' LIMIT 1 #getCategoryInfoByName LT
|
| 0.0002 |
SELECT vc.* FROM video_categories AS vc WHERE vc.category_url_en LIKE 'all-videos' LIMIT 1 #getCategoryInfoByName EN
|
| 0.0015 |
#getExsistingVideoDates SELECT YEAR(publish_date) AS year, DATE_FORMAT(publish_date, '%m') as month, COUNT(id) FROM video GROUP BY year, month HAVING year > 0 ORDER BY year DESC, month DESC
|
| 0.0013 |
SELECT SQL_CALC_FOUND_ROWS *, CASE WHEN (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) >= '2015-09-01' AND date(publish_date) < '2015-09-01' + INTERVAL 1 MONTH ORDER BY `publish_date` desc
|
| 0.0001 |
SELECT FOUND_ROWS() as fr
|
| 0.0003 |
SELECT * FROM (`video_categories`) WHERE `show_status` = '1' ORDER BY `sort`
|