92.35 ms (60.57%)
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
385377
394586
417836
443660
460292
464554
466493
466994
472788
479074
484944
492688
495044
503952
514659
514808
515797
515956
516631
516635
519346
521852
529290
539429
564254
564263
566187
584247
587989
605509
628654
630915
635490
636579
650646
651039
670935
682303
724123
742669
742675
742682
755170
758814
759087
759566
760998
761119
770926
773352
781306
785107
785495
795299
800513
800937
802182
803776
812548
816646
824613
824615
]
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 (385377 , 394586 , 417836 , 443660 , 460292 , 464554 , 466493 , 466994 , 472788 , 479074 , 484944 , 492688 , 495044 , 503952 , 514659 , 514808 , 515797 , 515956 , 516631 , 516635 , 519346 , 521852 , 529290 , 539429 , 564254 , 564263 , 566187 , 584247 , 587989 , 605509 , 628654 , 630915 , 635490 , 636579 , 650646 , 651039 , 670935 , 682303 , 724123 , 742669 , 742675 , 742682 , 755170 , 758814 , 759087 , 759566 , 760998 , 761119 , 770926 , 773352 , 781306 , 785107 , 785495 , 795299 , 800513 , 800937 , 802182 , 803776 , 812548 , 816646 , 824613 , 824615 );
Copy
15.72 ms (10.31%)
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
636579
584247
824613
824615
816646
539429
795299
812548
587989
785495
724123
759566
785107
759087
760998
761119
495044
479074
503952
650646
394586
605509
742669
800513
755170
516631
742682
417836
803776
773352
670935
564263
515797
651039
742675
460292
758814
802182
781306
464554
566187
800937
770926
484944
472788
385377
466493
635490
630915
516635
443660
514659
515956
628654
514808
519346
492688
564254
682303
466994
521852
529290
]
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 (636579 , 584247 , 824613 , 824615 , 816646 , 539429 , 795299 , 812548 , 587989 , 785495 , 724123 , 759566 , 785107 , 759087 , 760998 , 761119 , 495044 , 479074 , 503952 , 650646 , 394586 , 605509 , 742669 , 800513 , 755170 , 516631 , 742682 , 417836 , 803776 , 773352 , 670935 , 564263 , 515797 , 651039 , 742675 , 460292 , 758814 , 802182 , 781306 , 464554 , 566187 , 800937 , 770926 , 484944 , 472788 , 385377 , 466493 , 635490 , 630915 , 516635 , 443660 , 514659 , 515956 , 628654 , 514808 , 519346 , 492688 , 564254 , 682303 , 466994 , 521852 , 529290 );
Copy
3.82 ms (2.51%)
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
385377
394586
417836
443660
460292
464554
466493
466994
472788
479074
484944
492688
495044
503952
514659
514808
515797
515956
516631
516635
519346
521852
529290
539429
564254
564263
566187
584247
587989
605509
628654
630915
635490
636579
650646
651039
670935
682303
724123
742669
742675
742682
755170
758814
759087
759566
760998
761119
770926
773352
781306
785107
785495
795299
800513
800937
802182
803776
812548
816646
824613
824615
]
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 (385377 , 394586 , 417836 , 443660 , 460292 , 464554 , 466493 , 466994 , 472788 , 479074 , 484944 , 492688 , 495044 , 503952 , 514659 , 514808 , 515797 , 515956 , 516631 , 516635 , 519346 , 521852 , 529290 , 539429 , 564254 , 564263 , 566187 , 584247 , 587989 , 605509 , 628654 , 630915 , 635490 , 636579 , 650646 , 651039 , 670935 , 682303 , 724123 , 742669 , 742675 , 742682 , 755170 , 758814 , 759087 , 759566 , 760998 , 761119 , 770926 , 773352 , 781306 , 785107 , 785495 , 795299 , 800513 , 800937 , 802182 , 803776 , 812548 , 816646 , 824613 , 824615 );
Copy