102.36 ms (48.74%)
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
394514
421970
428111
454528
457853
465252
466499
466928
469116
473195
477116
489241
496718
511394
519922
528761
529122
545763
546914
558788
568453
570177
582479
607023
610806
617807
618378
624419
624465
639060
666869
676680
690050
700949
703467
704109
714608
727560
727579
728255
728716
733266
733317
739985
742272
742629
759917
765580
767052
773974
788920
794162
795540
796336
796679
800573
801258
813581
817249
817895
824961
]
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 (394514 , 421970 , 428111 , 454528 , 457853 , 465252 , 466499 , 466928 , 469116 , 473195 , 477116 , 489241 , 496718 , 511394 , 519922 , 528761 , 529122 , 545763 , 546914 , 558788 , 568453 , 570177 , 582479 , 607023 , 610806 , 617807 , 618378 , 624419 , 624465 , 639060 , 666869 , 676680 , 690050 , 700949 , 703467 , 704109 , 714608 , 727560 , 727579 , 728255 , 728716 , 733266 , 733317 , 739985 , 742272 , 742629 , 759917 , 765580 , 767052 , 773974 , 788920 , 794162 , 795540 , 796336 , 796679 , 800573 , 801258 , 813581 , 817249 , 817895 , 824961 );
Copy
9.45 ms (4.50%)
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
690050
466499
796679
742629
800573
727579
624419
529122
465252
511394
624465
428111
528761
767052
617807
676680
813581
765580
759917
582479
714608
473195
704109
727560
796336
703467
618378
739985
773974
788920
733266
477116
545763
489241
733317
421970
519922
568453
801258
817895
795540
824961
570177
700949
466928
742272
817249
610806
728716
794162
728255
496718
394514
666869
546914
454528
607023
457853
558788
469116
639060
]
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 (690050 , 466499 , 796679 , 742629 , 800573 , 727579 , 624419 , 529122 , 465252 , 511394 , 624465 , 428111 , 528761 , 767052 , 617807 , 676680 , 813581 , 765580 , 759917 , 582479 , 714608 , 473195 , 704109 , 727560 , 796336 , 703467 , 618378 , 739985 , 773974 , 788920 , 733266 , 477116 , 545763 , 489241 , 733317 , 421970 , 519922 , 568453 , 801258 , 817895 , 795540 , 824961 , 570177 , 700949 , 466928 , 742272 , 817249 , 610806 , 728716 , 794162 , 728255 , 496718 , 394514 , 666869 , 546914 , 454528 , 607023 , 457853 , 558788 , 469116 , 639060 );
Copy
7.28 ms (3.47%)
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
394514
421970
428111
454528
457853
465252
466499
466928
469116
473195
477116
489241
496718
511394
519922
528761
529122
545763
546914
558788
568453
570177
582479
607023
610806
617807
618378
624419
624465
639060
666869
676680
690050
700949
703467
704109
714608
727560
727579
728255
728716
733266
733317
739985
742272
742629
759917
765580
767052
773974
788920
794162
795540
796336
796679
800573
801258
813581
817249
817895
824961
]
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 (394514 , 421970 , 428111 , 454528 , 457853 , 465252 , 466499 , 466928 , 469116 , 473195 , 477116 , 489241 , 496718 , 511394 , 519922 , 528761 , 529122 , 545763 , 546914 , 558788 , 568453 , 570177 , 582479 , 607023 , 610806 , 617807 , 618378 , 624419 , 624465 , 639060 , 666869 , 676680 , 690050 , 700949 , 703467 , 704109 , 714608 , 727560 , 727579 , 728255 , 728716 , 733266 , 733317 , 739985 , 742272 , 742629 , 759917 , 765580 , 767052 , 773974 , 788920 , 794162 , 795540 , 796336 , 796679 , 800573 , 801258 , 813581 , 817249 , 817895 , 824961 );
Copy