0.0027 |
SELECT * FROM `category` JOIN `category_trans` ON `category_trans`.`category_id`=`category`.`id` WHERE `category_trans`.`seo_uri` = 'europaeisch' AND `category_trans`.`language_id` = 1
|
0.0001 |
SELECT * FROM `tube`
|
0.0007 |
SELECT SQL_CALC_FOUND_ROWS video.*, video_trans_de.title, category_to_video.weight, category_to_video.category_weight FROM `video` JOIN `category_to_video` ON `video`.`id`=`category_to_video`.`video_id` LEFT JOIN `video_trans_de` ON `video`.`id`=`video_trans_de`.`video_id` WHERE `video`.`is_gay` = 0 AND `video`.`is_trans` = 0 AND `video`.`tube_id` = '1' AND `category_to_video`.`category_id` = '131' ORDER BY `weight` desc LIMIT 1000
|
0.0001 |
SELECT FOUND_ROWS() as total_rows
|
0.0006 |
SELECT SQL_CALC_FOUND_ROWS video.*, video_trans_de.title, category_to_video.weight, category_to_video.category_weight FROM `video` JOIN `category_to_video` ON `video`.`id`=`category_to_video`.`video_id` LEFT JOIN `video_trans_de` ON `video`.`id`=`video_trans_de`.`video_id` WHERE `video`.`is_gay` = 0 AND `video`.`is_trans` = 0 AND `video`.`tube_id` = '2' AND `category_to_video`.`category_id` = '131' ORDER BY `weight` desc LIMIT 1000
|
0.0001 |
SELECT FOUND_ROWS() as total_rows
|
0.0006 |
SELECT SQL_CALC_FOUND_ROWS video.*, video_trans_de.title, category_to_video.weight, category_to_video.category_weight FROM `video` JOIN `category_to_video` ON `video`.`id`=`category_to_video`.`video_id` LEFT JOIN `video_trans_de` ON `video`.`id`=`video_trans_de`.`video_id` WHERE `video`.`is_gay` = 0 AND `video`.`is_trans` = 0 AND `video`.`tube_id` = '3' AND `category_to_video`.`category_id` = '131' ORDER BY `weight` desc LIMIT 1000
|
0.0001 |
SELECT FOUND_ROWS() as total_rows
|
0.0006 |
SELECT SQL_CALC_FOUND_ROWS video.*, video_trans_de.title, category_to_video.weight, category_to_video.category_weight FROM `video` JOIN `category_to_video` ON `video`.`id`=`category_to_video`.`video_id` LEFT JOIN `video_trans_de` ON `video`.`id`=`video_trans_de`.`video_id` WHERE `video`.`is_gay` = 0 AND `video`.`is_trans` = 0 AND `video`.`tube_id` = '4' AND `category_to_video`.`category_id` = '131' ORDER BY `weight` desc LIMIT 1000
|
0.0001 |
SELECT FOUND_ROWS() as total_rows
|
0.0007 |
SELECT SQL_CALC_FOUND_ROWS video.*, video_trans_de.title, category_to_video.weight, category_to_video.category_weight FROM `video` JOIN `category_to_video` ON `video`.`id`=`category_to_video`.`video_id` LEFT JOIN `video_trans_de` ON `video`.`id`=`video_trans_de`.`video_id` WHERE `video`.`is_gay` = 0 AND `video`.`is_trans` = 0 AND `video`.`tube_id` = '5' AND `category_to_video`.`category_id` = '131' ORDER BY `weight` desc LIMIT 1000
|
0.0001 |
SELECT FOUND_ROWS() as total_rows
|
0.0006 |
SELECT SQL_CALC_FOUND_ROWS video.*, video_trans_de.title, category_to_video.weight, category_to_video.category_weight FROM `video` JOIN `category_to_video` ON `video`.`id`=`category_to_video`.`video_id` LEFT JOIN `video_trans_de` ON `video`.`id`=`video_trans_de`.`video_id` WHERE `video`.`is_gay` = 0 AND `video`.`is_trans` = 0 AND `video`.`tube_id` = '6' AND `category_to_video`.`category_id` = '131' ORDER BY `weight` desc LIMIT 1000
|
0.0001 |
SELECT FOUND_ROWS() as total_rows
|
0.0005 |
SELECT SQL_CALC_FOUND_ROWS video.*, video_trans_de.title, category_to_video.weight, category_to_video.category_weight FROM `video` JOIN `category_to_video` ON `video`.`id`=`category_to_video`.`video_id` LEFT JOIN `video_trans_de` ON `video`.`id`=`video_trans_de`.`video_id` WHERE `video`.`is_gay` = 0 AND `video`.`is_trans` = 0 AND `video`.`tube_id` = '7' AND `category_to_video`.`category_id` = '131' ORDER BY `weight` desc LIMIT 1000
|
0.0001 |
SELECT FOUND_ROWS() as total_rows
|
0.0007 |
SELECT SQL_CALC_FOUND_ROWS video.*, video_trans_de.title, category_to_video.weight, category_to_video.category_weight FROM `video` JOIN `category_to_video` ON `video`.`id`=`category_to_video`.`video_id` LEFT JOIN `video_trans_de` ON `video`.`id`=`video_trans_de`.`video_id` WHERE `video`.`is_gay` = 0 AND `video`.`is_trans` = 0 AND `video`.`tube_id` = '8' AND `category_to_video`.`category_id` = '131' ORDER BY `weight` desc LIMIT 1000
|
0.0001 |
SELECT FOUND_ROWS() as total_rows
|
0.0002 |
SELECT * FROM `category_to_video` WHERE `video_id` = '1371660' AND `is_selected` = 1
|
0.0003 |
SELECT * FROM `category_to_video` WHERE `video_id` = '2300627' AND `is_selected` = 1
|
0.0003 |
SELECT * FROM `category_to_video` WHERE `video_id` = '4055529' AND `is_selected` = 1
|
0.0003 |
SELECT * FROM `category_to_video` WHERE `video_id` = '1650669' AND `is_selected` = 1
|
0.0002 |
SELECT * FROM `category_to_video` WHERE `video_id` = '4433189' AND `is_selected` = 1
|
0.0003 |
SELECT * FROM `category_to_video` WHERE `video_id` = '998045' AND `is_selected` = 1
|
0.0002 |
SELECT * FROM `category_to_video` WHERE `video_id` = '7759809' AND `is_selected` = 1
|
0.0003 |
SELECT * FROM `category_to_video` WHERE `video_id` = '996732' AND `is_selected` = 1
|
0.0002 |
SELECT * FROM `category_to_video` WHERE `video_id` = '8860489' AND `is_selected` = 1
|
0.0001 |
SELECT * FROM `category_to_video` WHERE `video_id` = '3679169' AND `is_selected` = 1
|
0.0001 |
SELECT * FROM `category_to_video` WHERE `video_id` = '9240846' AND `is_selected` = 1
|
0.0001 |
SELECT * FROM `category_to_video` WHERE `video_id` = '5967963' AND `is_selected` = 1
|
0.0000 |
SELECT * FROM `category_to_video` WHERE `video_id` = '8315501' AND `is_selected` = 1
|
0.0001 |
SELECT * FROM `category_to_video` WHERE `video_id` = '5970340' AND `is_selected` = 1
|
0.0001 |
SELECT * FROM `category_to_video` WHERE `video_id` = '178178' AND `is_selected` = 1
|
0.0001 |
SELECT * FROM `category_to_video` WHERE `video_id` = '8167649' AND `is_selected` = 1
|
0.0001 |
SELECT * FROM `category_to_video` WHERE `video_id` = '3859305' AND `is_selected` = 1
|
0.0001 |
SELECT * FROM `category_to_video` WHERE `video_id` = '9219759' AND `is_selected` = 1
|
0.0001 |
SELECT * FROM `category_to_video` WHERE `video_id` = '9223359' AND `is_selected` = 1
|
0.0001 |
SELECT * FROM `category_to_video` WHERE `video_id` = '5057839' AND `is_selected` = 1
|
0.0001 |
SELECT * FROM `category_to_video` WHERE `video_id` = '8855433' AND `is_selected` = 1
|
0.0001 |
SELECT * FROM `category_to_video` WHERE `video_id` = '10154708' AND `is_selected` = 1
|
0.0000 |
SELECT * FROM `category_to_video` WHERE `video_id` = '10016826' AND `is_selected` = 1
|
0.0000 |
SELECT * FROM `category_to_video` WHERE `video_id` = '9697988' AND `is_selected` = 1
|
0.0001 |
SELECT * FROM `category_to_video` WHERE `video_id` = '7310904' AND `is_selected` = 1
|
0.0002 |
SELECT * FROM `category_to_video` WHERE `video_id` = '9829698' AND `is_selected` = 1
|
0.0001 |
SELECT * FROM `category_to_video` WHERE `video_id` = '9914161' AND `is_selected` = 1
|
0.0001 |
SELECT * FROM `category_to_video` WHERE `video_id` = '9809240' AND `is_selected` = 1
|
0.0001 |
SELECT * FROM `category_to_video` WHERE `video_id` = '8406344' AND `is_selected` = 1
|
0.0001 |
SELECT * FROM `category_to_video` WHERE `video_id` = '9474569' AND `is_selected` = 1
|
0.0002 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '1371660'
|
0.0001 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '2300627'
|
0.0001 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '4055529'
|
0.0001 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '1650669'
|
0.0002 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '4433189'
|
0.0001 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '998045'
|
0.0001 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '7759809'
|
0.0001 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '996732'
|
0.0001 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '8860489'
|
0.0001 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '3679169'
|
0.0001 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '9240846'
|
0.0001 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '5967963'
|
0.0000 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '8315501'
|
0.0001 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '5970340'
|
0.0001 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '178178'
|
0.0001 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '8167649'
|
0.0001 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '3859305'
|
0.0001 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '9219759'
|
0.0001 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '9223359'
|
0.0001 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '5057839'
|
0.0001 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '8855433'
|
0.0001 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '10154708'
|
0.0000 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '10016826'
|
0.0000 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '9697988'
|
0.0001 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '7310904'
|
0.0001 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '9829698'
|
0.0001 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '9914161'
|
0.0001 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '9809240'
|
0.0001 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '8406344'
|
0.0001 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '9474569'
|
0.0001 |
SELECT * FROM `category` JOIN `category_trans` ON `category_trans`.`category_id`=`category`.`id` WHERE `category`.`id` = '131' AND `category_trans`.`language_id` = 1
|
0.0002 |
UPDATE `category` SET `modification_hash` = '0631a3a12ced853733655622074fbc16', `modification_time` = '2025-06-11 07:12:13', `update_time` = '2025-06-11 07:12:13' WHERE `id` = '131'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '1371660'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '2300627'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '4055529'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '1650669'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '4433189'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '998045'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '7759809'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '996732'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '8860489'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '3679169'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '9240846'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '5967963'
|
0.0000 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '8315501'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '5970340'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '178178'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '8167649'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '3859305'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '9219759'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '9223359'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '5057839'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '8855433'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '10154708'
|
0.0000 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '10016826'
|
0.0000 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '9697988'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '7310904'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '9829698'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '9914161'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '9809240'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '8406344'
|
0.0001 |
SELECT * FROM `video_trans_de` WHERE `video_id` = '9474569'
|
0.0000 |
SELECT * FROM `tube`
|
0.0009 |
SELECT `category`.`id`, `category_trans`.`name`, `category_trans`.`seo_uri` FROM `category` JOIN `category_trans` ON `category_trans`.`category_id`=`category`.`id` WHERE `category_trans`.`language_id` = 1
|
0.0000 |
SELECT * FROM `tube`
|
0.0003 |
SELECT *, `language`.`name` AS `language_name`, `category_trans`.`name` AS `category_name` FROM `category_trans` JOIN `language` ON `category_trans`.`language_id`=`language`.`id` WHERE `language`.`is_active` = 1 AND `category_trans`.`category_id` = '131'
|
0.0002 |
SELECT * FROM `category` JOIN `category_trans` ON `category_trans`.`category_id`=`category`.`id` WHERE `category`.`id` = '131' AND `category_trans`.`language_id` = 2
|
0.0003 |
SELECT video.id
FROM video
JOIN category_to_video c ON c.video_id=video.id
JOIN video_trans_en vt ON vt.video_id=video.id
WHERE c.category_id=131
AND c.is_selected=1
AND vt.title LIKE '%european%'
ORDER BY category_weight DESC, id ASC
LIMIT 30
|
0.0001 |
SELECT * FROM `video` LEFT JOIN `video_trans_de` ON `video_trans_de`.`video_id`=`video`.`id` WHERE `video`.`id` = '7759809'
|
0.0001 |
SELECT * FROM `video` LEFT JOIN `video_trans_de` ON `video_trans_de`.`video_id`=`video`.`id` WHERE `video`.`id` = '8860489'
|
0.0001 |
SELECT * FROM `video` LEFT JOIN `video_trans_de` ON `video_trans_de`.`video_id`=`video`.`id` WHERE `video`.`id` = '1371660'
|
0.0001 |
SELECT * FROM `video` LEFT JOIN `video_trans_de` ON `video_trans_de`.`video_id`=`video`.`id` WHERE `video`.`id` = '4055529'
|
0.0000 |
SELECT * FROM `category_to_video` WHERE `video_id` = '7759809' AND `is_selected` = 1
|
0.0000 |
SELECT * FROM `category_to_video` WHERE `video_id` = '8860489' AND `is_selected` = 1
|
0.0000 |
SELECT * FROM `category_to_video` WHERE `video_id` = '1371660' AND `is_selected` = 1
|
0.0000 |
SELECT * FROM `category_to_video` WHERE `video_id` = '4055529' AND `is_selected` = 1
|
0.0000 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '7759809'
|
0.0000 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '8860489'
|
0.0000 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '1371660'
|
0.0000 |
SELECT `pornstar`.* FROM `pornstar` JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id` WHERE `pornstar_to_video`.`video_id` = '4055529'
|
0.0000 |
SELECT * FROM `tube`
|
0.0001 |
SELECT `category`.`id`, `category_trans`.`name`, `category_trans`.`seo_uri` FROM `category` JOIN `category_trans` ON `category_trans`.`category_id`=`category`.`id` WHERE `category_trans`.`language_id` = 1
|