46.48 ms (61.26%)
1
SELECT phc . post_id , phc . category_id , c . slug , IFNULL (`r` . `name` , `f` . `name` ) as `name` FROM post_has_category phc INNER JOIN category c ON phc . category_id = c . category_id AND c . enabled = 1 LEFT JOIN category_translation f ON c . category_id = f . category_id AND f . lang_id = ? LEFT JOIN category_translation r ON `c` . `category_id` = `r` . `category_id` AND `r` . `lang_id` = ? WHERE phc . post_id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
1
2
395720
446431
456553
464794
482338
490005
492528
492690
500506
509312
515749
520688
520756
522681
523336
526608
526718
532419
544992
561135
562962
568062
568999
578596
590514
591416
599030
599533
616683
618326
625215
629849
645918
693965
]
SELECT phc . post_id , phc . category_id , c . slug , IFNULL (`r` . `name` , `f` . `name` ) as `name` FROM post_has_category phc INNER JOIN category c ON phc . category_id = c . category_id AND c . enabled = 1 LEFT JOIN category_translation f ON c . category_id = f . category_id AND f . lang_id = 1 LEFT JOIN category_translation r ON `c` . `category_id` = `r` . `category_id` AND `r` . `lang_id` = 2 WHERE phc . post_id IN (395720 , 446431 , 456553 , 464794 , 482338 , 490005 , 492528 , 492690 , 500506 , 509312 , 515749 , 520688 , 520756 , 522681 , 523336 , 526608 , 526718 , 532419 , 544992 , 561135 , 562962 , 568062 , 568999 , 578596 , 590514 , 591416 , 599030 , 599533 , 616683 , 618326 , 625215 , 629849 , 645918 , 693965 );
Copy
8.64 ms (11.39%)
1
SELECT p . post_id , p . user_id , p . content_id , p . public_key , p . search_field , p . cover , p . type , p . sexual_orientation , p . orientation , p . quality , p . noindex , p . nofollow , p . contents_num , p . duration , p . likes , p . dislikes , p . views , p . vote_rating , p . params , p . published_at , IFNULL (`r` . `title` , `f` . `title` ) as `title` , IFNULL (`r` . `custom1` , `f` . `custom1` ) as `custom1` , IFNULL (`r` . `custom2` , `f` . `custom2` ) as `custom2` FROM post p LEFT JOIN post_translation f ON `p` . `post_id` = `f` . `post_id` AND `f` . `lang_id` = ? LEFT JOIN post_translation r ON `p` . `post_id` = `r` . `post_id` AND `r` . `lang_id` = ? WHERE p . post_id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
1
2
526718
562962
599533
568999
645918
590514
599030
492690
464794
456553
492528
500506
446431
482338
629849
616683
395720
578596
522681
509312
490005
693965
561135
523336
532419
515749
526608
544992
520688
520756
591416
568062
625215
618326
]
SELECT
p . post_id ,
p . user_id ,
p . content_id ,
p . public_key ,
p . search_field ,
p . cover ,
p . type ,
p . sexual_orientation ,
p . orientation ,
p . quality ,
p . noindex ,
p . nofollow ,
p . contents_num ,
p . duration ,
p . likes ,
p . dislikes ,
p . views ,
p . vote_rating ,
p . params ,
p . published_at ,
IFNULL (`r` . `title` , `f` . `title` ) as `title` ,
IFNULL (`r` . `custom1` , `f` . `custom1` ) as `custom1` ,
IFNULL (`r` . `custom2` , `f` . `custom2` ) as `custom2`
FROM
post p
LEFT JOIN post_translation f ON `p` . `post_id` = `f` . `post_id`
AND `f` . `lang_id` = ?
LEFT JOIN post_translation r ON `p` . `post_id` = `r` . `post_id`
AND `r` . `lang_id` = ?
WHERE
p . post_id IN (
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ?
)
Copy
SELECT p . post_id , p . user_id , p . content_id , p . public_key , p . search_field , p . cover , p . type , p . sexual_orientation , p . orientation , p . quality , p . noindex , p . nofollow , p . contents_num , p . duration , p . likes , p . dislikes , p . views , p . vote_rating , p . params , p . published_at , IFNULL (`r` . `title` , `f` . `title` ) as `title` , IFNULL (`r` . `custom1` , `f` . `custom1` ) as `custom1` , IFNULL (`r` . `custom2` , `f` . `custom2` ) as `custom2` FROM post p LEFT JOIN post_translation f ON `p` . `post_id` = `f` . `post_id` AND `f` . `lang_id` = 1 LEFT JOIN post_translation r ON `p` . `post_id` = `r` . `post_id` AND `r` . `lang_id` = 2 WHERE p . post_id IN (526718 , 562962 , 599533 , 568999 , 645918 , 590514 , 599030 , 492690 , 464794 , 456553 , 492528 , 500506 , 446431 , 482338 , 629849 , 616683 , 395720 , 578596 , 522681 , 509312 , 490005 , 693965 , 561135 , 523336 , 532419 , 515749 , 526608 , 544992 , 520688 , 520756 , 591416 , 568062 , 625215 , 618326 );
Copy
2.80 ms (3.69%)
1
SELECT pht . post_id , pht . tag_id , t . slug , IFNULL (`r` . `name` , `f` . `name` ) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht . tag_id = t . tag_id AND t . enabled = 1 LEFT JOIN tag_translation f ON t . tag_id = f . tag_id AND f . lang_id = ? LEFT JOIN tag_translation r ON `t` . `tag_id` = `r` . `tag_id` AND `r` . `lang_id` = ? WHERE pht . post_id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
1
2
395720
446431
456553
464794
482338
490005
492528
492690
500506
509312
515749
520688
520756
522681
523336
526608
526718
532419
544992
561135
562962
568062
568999
578596
590514
591416
599030
599533
616683
618326
625215
629849
645918
693965
]
SELECT pht . post_id , pht . tag_id , t . slug , IFNULL (`r` . `name` , `f` . `name` ) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht . tag_id = t . tag_id AND t . enabled = 1 LEFT JOIN tag_translation f ON t . tag_id = f . tag_id AND f . lang_id = 1 LEFT JOIN tag_translation r ON `t` . `tag_id` = `r` . `tag_id` AND `r` . `lang_id` = 2 WHERE pht . post_id IN (395720 , 446431 , 456553 , 464794 , 482338 , 490005 , 492528 , 492690 , 500506 , 509312 , 515749 , 520688 , 520756 , 522681 , 523336 , 526608 , 526718 , 532419 , 544992 , 561135 , 562962 , 568062 , 568999 , 578596 , 590514 , 591416 , 599030 , 599533 , 616683 , 618326 , 625215 , 629849 , 645918 , 693965 );
Copy