209.67 ms (51.26%)
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
82307
734841
559425
594375
387854
554712
740487
577026
583410
548186
684883
628524
809077
717758
782528
446764
549040
707441
588939
626163
738110
739408
661378
630239
779765
783218
768969
642286
446768
583300
712108
744178
755489
803516
576440
669318
756618
734853
437244
390286
540107
495525
769409
784896
730338
463435
812043
726816
584379
550367
615910
751428
725527
510938
692743
613800
669269
680706
611032
602092
]
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 (82307 , 734841 , 559425 , 594375 , 387854 , 554712 , 740487 , 577026 , 583410 , 548186 , 684883 , 628524 , 809077 , 717758 , 782528 , 446764 , 549040 , 707441 , 588939 , 626163 , 738110 , 739408 , 661378 , 630239 , 779765 , 783218 , 768969 , 642286 , 446768 , 583300 , 712108 , 744178 , 755489 , 803516 , 576440 , 669318 , 756618 , 734853 , 437244 , 390286 , 540107 , 495525 , 769409 , 784896 , 730338 , 463435 , 812043 , 726816 , 584379 , 550367 , 615910 , 751428 , 725527 , 510938 , 692743 , 613800 , 669269 , 680706 , 611032 , 602092 );
Copy
119.48 ms (29.21%)
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
82307
387854
390286
437244
446764
446768
463435
495525
510938
540107
548186
549040
550367
554712
559425
576440
577026
583300
583410
584379
588939
594375
602092
611032
613800
615910
626163
628524
630239
642286
661378
669269
669318
680706
684883
692743
707441
712108
717758
725527
726816
730338
734841
734853
738110
739408
740487
744178
751428
755489
756618
768969
769409
779765
782528
783218
784896
803516
809077
812043
]
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 (82307 , 387854 , 390286 , 437244 , 446764 , 446768 , 463435 , 495525 , 510938 , 540107 , 548186 , 549040 , 550367 , 554712 , 559425 , 576440 , 577026 , 583300 , 583410 , 584379 , 588939 , 594375 , 602092 , 611032 , 613800 , 615910 , 626163 , 628524 , 630239 , 642286 , 661378 , 669269 , 669318 , 680706 , 684883 , 692743 , 707441 , 712108 , 717758 , 725527 , 726816 , 730338 , 734841 , 734853 , 738110 , 739408 , 740487 , 744178 , 751428 , 755489 , 756618 , 768969 , 769409 , 779765 , 782528 , 783218 , 784896 , 803516 , 809077 , 812043 );
Copy
2.44 ms (0.60%)
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
82307
387854
390286
437244
446764
446768
463435
495525
510938
540107
548186
549040
550367
554712
559425
576440
577026
583300
583410
584379
588939
594375
602092
611032
613800
615910
626163
628524
630239
642286
661378
669269
669318
680706
684883
692743
707441
712108
717758
725527
726816
730338
734841
734853
738110
739408
740487
744178
751428
755489
756618
768969
769409
779765
782528
783218
784896
803516
809077
812043
]
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 (82307 , 387854 , 390286 , 437244 , 446764 , 446768 , 463435 , 495525 , 510938 , 540107 , 548186 , 549040 , 550367 , 554712 , 559425 , 576440 , 577026 , 583300 , 583410 , 584379 , 588939 , 594375 , 602092 , 611032 , 613800 , 615910 , 626163 , 628524 , 630239 , 642286 , 661378 , 669269 , 669318 , 680706 , 684883 , 692743 , 707441 , 712108 , 717758 , 725527 , 726816 , 730338 , 734841 , 734853 , 738110 , 739408 , 740487 , 744178 , 751428 , 755489 , 756618 , 768969 , 769409 , 779765 , 782528 , 783218 , 784896 , 803516 , 809077 , 812043 );
Copy