103.50 ms (69.96%)
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
406378
440261
454332
457739
464708
472357
478367
484520
488389
488996
500644
501705
501709
516883
517480
530533
532355
532425
532672
534959
536335
550045
552980
562842
565975
568147
568148
572582
575703
582451
585060
591177
594813
594887
595899
599154
599255
601246
631194
641138
641924
650378
665934
695941
702480
710377
718015
718450
725793
726432
745058
747047
763168
766926
774736
796806
813868
818696
818758
819766
828415
828856
]
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 (
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
?
)
Copy
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 (406378 , 440261 , 454332 , 457739 , 464708 , 472357 , 478367 , 484520 , 488389 , 488996 , 500644 , 501705 , 501709 , 516883 , 517480 , 530533 , 532355 , 532425 , 532672 , 534959 , 536335 , 550045 , 552980 , 562842 , 565975 , 568147 , 568148 , 572582 , 575703 , 582451 , 585060 , 591177 , 594813 , 594887 , 595899 , 599154 , 599255 , 601246 , 631194 , 641138 , 641924 , 650378 , 665934 , 695941 , 702480 , 710377 , 718015 , 718450 , 725793 , 726432 , 745058 , 747047 , 763168 , 766926 , 774736 , 796806 , 813868 , 818696 , 818758 , 819766 , 828415 , 828856 );
Copy
8.01 ms (5.41%)
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
818696
478367
813868
818758
599154
594813
562842
710377
572582
828856
575703
650378
582451
536335
530533
599255
631194
819766
665934
828415
641924
774736
725793
747047
718450
766926
702480
532672
718015
745058
472357
763168
796806
440261
488996
695941
484520
534959
550045
454332
406378
516883
726432
457739
641138
517480
568147
595899
501705
488389
464708
532355
568148
594887
500644
565975
532425
552980
501709
601246
591177
585060
]
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 (818696 , 478367 , 813868 , 818758 , 599154 , 594813 , 562842 , 710377 , 572582 , 828856 , 575703 , 650378 , 582451 , 536335 , 530533 , 599255 , 631194 , 819766 , 665934 , 828415 , 641924 , 774736 , 725793 , 747047 , 718450 , 766926 , 702480 , 532672 , 718015 , 745058 , 472357 , 763168 , 796806 , 440261 , 488996 , 695941 , 484520 , 534959 , 550045 , 454332 , 406378 , 516883 , 726432 , 457739 , 641138 , 517480 , 568147 , 595899 , 501705 , 488389 , 464708 , 532355 , 568148 , 594887 , 500644 , 565975 , 532425 , 552980 , 501709 , 601246 , 591177 , 585060 );
Copy
2.26 ms (1.53%)
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
406378
440261
454332
457739
464708
472357
478367
484520
488389
488996
500644
501705
501709
516883
517480
530533
532355
532425
532672
534959
536335
550045
552980
562842
565975
568147
568148
572582
575703
582451
585060
591177
594813
594887
595899
599154
599255
601246
631194
641138
641924
650378
665934
695941
702480
710377
718015
718450
725793
726432
745058
747047
763168
766926
774736
796806
813868
818696
818758
819766
828415
828856
]
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 (
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
?
)
Copy
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 (406378 , 440261 , 454332 , 457739 , 464708 , 472357 , 478367 , 484520 , 488389 , 488996 , 500644 , 501705 , 501709 , 516883 , 517480 , 530533 , 532355 , 532425 , 532672 , 534959 , 536335 , 550045 , 552980 , 562842 , 565975 , 568147 , 568148 , 572582 , 575703 , 582451 , 585060 , 591177 , 594813 , 594887 , 595899 , 599154 , 599255 , 601246 , 631194 , 641138 , 641924 , 650378 , 665934 , 695941 , 702480 , 710377 , 718015 , 718450 , 725793 , 726432 , 745058 , 747047 , 763168 , 766926 , 774736 , 796806 , 813868 , 818696 , 818758 , 819766 , 828415 , 828856 );
Copy