73.81 ms (60.90%)
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
20051
118098
163370
382971
383744
390614
398043
398105
413044
425804
432317
435618
438588
457248
467715
471092
471137
478025
478030
499885
500680
505804
507290
509776
510266
510581
512180
523373
539232
542181
550643
550761
551941
551953
552917
557709
559865
565479
572721
586588
588228
590958
590978
595637
615767
619441
622652
623510
623606
623610
623697
712197
712475
715293
722426
737127
739791
740362
761289
765721
785568
]
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 (20051 , 118098 , 163370 , 382971 , 383744 , 390614 , 398043 , 398105 , 413044 , 425804 , 432317 , 435618 , 438588 , 457248 , 467715 , 471092 , 471137 , 478025 , 478030 , 499885 , 500680 , 505804 , 507290 , 509776 , 510266 , 510581 , 512180 , 523373 , 539232 , 542181 , 550643 , 550761 , 551941 , 551953 , 552917 , 557709 , 559865 , 565479 , 572721 , 586588 , 588228 , 590958 , 590978 , 595637 , 615767 , 619441 , 622652 , 623510 , 623606 , 623610 , 623697 , 712197 , 712475 , 715293 , 722426 , 737127 , 739791 , 740362 , 761289 , 765721 , 785568 );
Copy
10.92 ms (9.01%)
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
739791
118098
712197
557709
765721
500680
552917
715293
722426
398043
398105
590958
509776
615767
619441
507290
595637
622652
740362
623510
623606
512180
435618
623697
542181
20051
551941
550643
785568
163370
478025
438588
550761
712475
457248
551953
383744
623610
565479
539232
590978
478030
510266
523373
471137
390614
737127
588228
572721
432317
559865
510581
467715
499885
413044
382971
471092
505804
586588
425804
761289
]
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 (739791 , 118098 , 712197 , 557709 , 765721 , 500680 , 552917 , 715293 , 722426 , 398043 , 398105 , 590958 , 509776 , 615767 , 619441 , 507290 , 595637 , 622652 , 740362 , 623510 , 623606 , 512180 , 435618 , 623697 , 542181 , 20051 , 551941 , 550643 , 785568 , 163370 , 478025 , 438588 , 550761 , 712475 , 457248 , 551953 , 383744 , 623610 , 565479 , 539232 , 590978 , 478030 , 510266 , 523373 , 471137 , 390614 , 737127 , 588228 , 572721 , 432317 , 559865 , 510581 , 467715 , 499885 , 413044 , 382971 , 471092 , 505804 , 586588 , 425804 , 761289 );
Copy
2.77 ms (2.29%)
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
20051
118098
163370
382971
383744
390614
398043
398105
413044
425804
432317
435618
438588
457248
467715
471092
471137
478025
478030
499885
500680
505804
507290
509776
510266
510581
512180
523373
539232
542181
550643
550761
551941
551953
552917
557709
559865
565479
572721
586588
588228
590958
590978
595637
615767
619441
622652
623510
623606
623610
623697
712197
712475
715293
722426
737127
739791
740362
761289
765721
785568
]
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 (20051 , 118098 , 163370 , 382971 , 383744 , 390614 , 398043 , 398105 , 413044 , 425804 , 432317 , 435618 , 438588 , 457248 , 467715 , 471092 , 471137 , 478025 , 478030 , 499885 , 500680 , 505804 , 507290 , 509776 , 510266 , 510581 , 512180 , 523373 , 539232 , 542181 , 550643 , 550761 , 551941 , 551953 , 552917 , 557709 , 559865 , 565479 , 572721 , 586588 , 588228 , 590958 , 590978 , 595637 , 615767 , 619441 , 622652 , 623510 , 623606 , 623610 , 623697 , 712197 , 712475 , 715293 , 722426 , 737127 , 739791 , 740362 , 761289 , 765721 , 785568 );
Copy