| 0.0027 |
SELECT *
FROM `category`
JOIN `category_trans` ON `category_trans`.`category_id`=`category`.`id`
WHERE `category_trans`.`seo_uri` = 'brunette'
AND `category_trans`.`language_id` = 2
|
| 0.0002 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '4148654'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '6270443'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '1839985'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '3675329'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '7447890'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '5740934'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '7479688'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '7478646'
|
| 0.0002 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '3160349'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '9993590'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '524802'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '3148457'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '8404720'
|
| 0.0000 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '3139352'
|
| 0.0002 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '9764486'
|
| 0.0000 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '3225843'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '9239167'
|
| 0.0000 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '5266417'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '2446910'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '9841528'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '1631145'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '9923092'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '4548020'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '9713701'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '5005128'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '1693308'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '9517716'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '436710'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '9859512'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '1065307'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '8406344'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '751001'
|
| 0.0000 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '7798988'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '5246857'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '1709077'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '5090764'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '1858962'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '9533318'
|
| 0.0000 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '3346084'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '524932'
|
| 0.0000 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '5741087'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '1765490'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '4878799'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '1827998'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '6978714'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '1356769'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '4810848'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '1690869'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '4288410'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '1747605'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '5294859'
|
| 0.0000 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '1829645'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '3215771'
|
| 0.0000 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '161762'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '5083160'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '2149256'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '6092127'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '2385243'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '5249057'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '907572'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '5083081'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '1880374'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '3295086'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '2033026'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '3244625'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '24958'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '4016922'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '39712'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '3366730'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '2350090'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '4134035'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '359498'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '3448159'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '500031'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '5216487'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '605062'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '5057839'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '707110'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '4985595'
|
| 0.0002 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '884205'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '4348649'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '1096353'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '5345408'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '345185'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '6235068'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '1271197'
|
| 0.0000 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '5014315'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '1552020'
|
| 0.0002 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '2890110'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '504713'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '2698789'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '2177702'
|
| 0.0002 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '5361877'
|
| 0.0002 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '541959'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '3003098'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '2123924'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '4886117'
|
| 0.0002 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '467653'
|
| 0.0002 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '5967963'
|
| 0.0002 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '177225'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '5970340'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '458220'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '5500492'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '2084334'
|
| 0.0000 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '3865684'
|
| 0.0002 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '1744628'
|
| 0.0002 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '5095368'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '385319'
|
| 0.0002 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '3320001'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '1650669'
|
| 0.0002 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '154137'
|
| 0.0000 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '75819'
|
| 0.0002 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '53532'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '64335'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '1827541'
|
| 0.0000 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '1773706'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '1440314'
|
| 0.0002 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '459453'
|
| 0.0002 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '401558'
|
| 0.0001 |
SELECT *
FROM `video_trans_en`
WHERE `video_id` = '415410'
|
| 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` = 2
|
| 0.0001 |
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` = '60'
|
| 0.0002 |
SELECT *
FROM `category`
JOIN `category_trans` ON `category_trans`.`category_id`=`category`.`id`
WHERE `category`.`id` = '60'
AND `category_trans`.`language_id` = 2
|
| 0.0007 |
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=60
AND c.is_selected=1
AND vt.title LIKE '%brunette%'
ORDER BY category_weight DESC, id ASC
LIMIT 30
|
| 0.0002 |
SELECT *
FROM `video`
LEFT JOIN `video_trans_en` ON `video_trans_en`.`video_id`=`video`.`id`
WHERE `video`.`id` = '4148654'
|
| 0.0001 |
SELECT *
FROM `video`
LEFT JOIN `video_trans_en` ON `video_trans_en`.`video_id`=`video`.`id`
WHERE `video`.`id` = '6270443'
|
| 0.0001 |
SELECT *
FROM `video`
LEFT JOIN `video_trans_en` ON `video_trans_en`.`video_id`=`video`.`id`
WHERE `video`.`id` = '524802'
|
| 0.0003 |
SELECT *
FROM `video`
LEFT JOIN `video_trans_en` ON `video_trans_en`.`video_id`=`video`.`id`
WHERE `video`.`id` = '1839985'
|
| 0.0001 |
SELECT *
FROM `video`
LEFT JOIN `video_trans_en` ON `video_trans_en`.`video_id`=`video`.`id`
WHERE `video`.`id` = '3675329'
|
| 0.0001 |
SELECT *
FROM `video`
LEFT JOIN `video_trans_en` ON `video_trans_en`.`video_id`=`video`.`id`
WHERE `video`.`id` = '2446910'
|
| 0.0001 |
SELECT *
FROM `video`
LEFT JOIN `video_trans_en` ON `video_trans_en`.`video_id`=`video`.`id`
WHERE `video`.`id` = '5740934'
|
| 0.0002 |
SELECT *
FROM `video`
LEFT JOIN `video_trans_en` ON `video_trans_en`.`video_id`=`video`.`id`
WHERE `video`.`id` = '7447890'
|
| 0.0003 |
SELECT *
FROM `video`
LEFT JOIN `video_trans_en` ON `video_trans_en`.`video_id`=`video`.`id`
WHERE `video`.`id` = '1190224'
|
| 0.0002 |
SELECT *
FROM `video`
LEFT JOIN `video_trans_en` ON `video_trans_en`.`video_id`=`video`.`id`
WHERE `video`.`id` = '1631145'
|
| 0.0004 |
SELECT *
FROM `video`
LEFT JOIN `video_trans_en` ON `video_trans_en`.`video_id`=`video`.`id`
WHERE `video`.`id` = '1693308'
|
| 0.0001 |
SELECT *
FROM `video`
LEFT JOIN `video_trans_en` ON `video_trans_en`.`video_id`=`video`.`id`
WHERE `video`.`id` = '436710'
|
| 0.0001 |
SELECT *
FROM `video`
LEFT JOIN `video_trans_en` ON `video_trans_en`.`video_id`=`video`.`id`
WHERE `video`.`id` = '1065307'
|
| 0.0001 |
SELECT *
FROM `video`
LEFT JOIN `video_trans_en` ON `video_trans_en`.`video_id`=`video`.`id`
WHERE `video`.`id` = '2232606'
|
| 0.0001 |
SELECT *
FROM `category_to_video`
WHERE `video_id` = '4148654'
AND `is_selected` = 1
|
| 0.0002 |
SELECT *
FROM `category_to_video`
WHERE `video_id` = '6270443'
AND `is_selected` = 1
|
| 0.0002 |
SELECT *
FROM `category_to_video`
WHERE `video_id` = '524802'
AND `is_selected` = 1
|
| 0.0002 |
SELECT *
FROM `category_to_video`
WHERE `video_id` = '1839985'
AND `is_selected` = 1
|
| 0.0002 |
SELECT *
FROM `category_to_video`
WHERE `video_id` = '3675329'
AND `is_selected` = 1
|
| 0.0002 |
SELECT *
FROM `category_to_video`
WHERE `video_id` = '2446910'
AND `is_selected` = 1
|
| 0.0002 |
SELECT *
FROM `category_to_video`
WHERE `video_id` = '5740934'
AND `is_selected` = 1
|
| 0.0002 |
SELECT *
FROM `category_to_video`
WHERE `video_id` = '7447890'
AND `is_selected` = 1
|
| 0.0002 |
SELECT *
FROM `category_to_video`
WHERE `video_id` = '1190224'
AND `is_selected` = 1
|
| 0.0002 |
SELECT *
FROM `category_to_video`
WHERE `video_id` = '1631145'
AND `is_selected` = 1
|
| 0.0002 |
SELECT *
FROM `category_to_video`
WHERE `video_id` = '1693308'
AND `is_selected` = 1
|
| 0.0002 |
SELECT *
FROM `category_to_video`
WHERE `video_id` = '436710'
AND `is_selected` = 1
|
| 0.0000 |
SELECT *
FROM `category_to_video`
WHERE `video_id` = '1065307'
AND `is_selected` = 1
|
| 0.0002 |
SELECT *
FROM `category_to_video`
WHERE `video_id` = '2232606'
AND `is_selected` = 1
|
| 0.0003 |
SELECT `pornstar`.*
FROM `pornstar`
JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id`
WHERE `pornstar_to_video`.`video_id` = '4148654'
|
| 0.0003 |
SELECT `pornstar`.*
FROM `pornstar`
JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id`
WHERE `pornstar_to_video`.`video_id` = '6270443'
|
| 0.0002 |
SELECT `pornstar`.*
FROM `pornstar`
JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id`
WHERE `pornstar_to_video`.`video_id` = '524802'
|
| 0.0002 |
SELECT `pornstar`.*
FROM `pornstar`
JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id`
WHERE `pornstar_to_video`.`video_id` = '1839985'
|
| 0.0002 |
SELECT `pornstar`.*
FROM `pornstar`
JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id`
WHERE `pornstar_to_video`.`video_id` = '3675329'
|
| 0.0002 |
SELECT `pornstar`.*
FROM `pornstar`
JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id`
WHERE `pornstar_to_video`.`video_id` = '2446910'
|
| 0.0002 |
SELECT `pornstar`.*
FROM `pornstar`
JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id`
WHERE `pornstar_to_video`.`video_id` = '5740934'
|
| 0.0003 |
SELECT `pornstar`.*
FROM `pornstar`
JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id`
WHERE `pornstar_to_video`.`video_id` = '7447890'
|
| 0.0003 |
SELECT `pornstar`.*
FROM `pornstar`
JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id`
WHERE `pornstar_to_video`.`video_id` = '1190224'
|
| 0.0003 |
SELECT `pornstar`.*
FROM `pornstar`
JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id`
WHERE `pornstar_to_video`.`video_id` = '1631145'
|
| 0.0002 |
SELECT `pornstar`.*
FROM `pornstar`
JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id`
WHERE `pornstar_to_video`.`video_id` = '1693308'
|
| 0.0003 |
SELECT `pornstar`.*
FROM `pornstar`
JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id`
WHERE `pornstar_to_video`.`video_id` = '436710'
|
| 0.0001 |
SELECT `pornstar`.*
FROM `pornstar`
JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id`
WHERE `pornstar_to_video`.`video_id` = '1065307'
|
| 0.0002 |
SELECT `pornstar`.*
FROM `pornstar`
JOIN `pornstar_to_video` ON `pornstar_to_video`.`pornstar_id`=`pornstar`.`id`
WHERE `pornstar_to_video`.`video_id` = '2232606'
|
| 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` = 2
|
