82.88 ms (74.24%)
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
418575
424048
426483
431512
432708
432727
432730
432734
432735
432736
433067
433904
440526
446690
448282
449690
451033
454533
454537
455471
455594
455596
456654
459030
459267
459472
459485
470411
483227
488923
490162
497611
509077
510570
523552
553185
573386
579856
608363
702375
702376
706620
707384
738564
738675
745946
751170
751360
751384
752477
754209
759138
804265
805239
811852
811862
811889
811891
811896
811905
814706
]
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 (418575 , 424048 , 426483 , 431512 , 432708 , 432727 , 432730 , 432734 , 432735 , 432736 , 433067 , 433904 , 440526 , 446690 , 448282 , 449690 , 451033 , 454533 , 454537 , 455471 , 455594 , 455596 , 456654 , 459030 , 459267 , 459472 , 459485 , 470411 , 483227 , 488923 , 490162 , 497611 , 509077 , 510570 , 523552 , 553185 , 573386 , 579856 , 608363 , 702375 , 702376 , 706620 , 707384 , 738564 , 738675 , 745946 , 751170 , 751360 , 751384 , 752477 , 754209 , 759138 , 804265 , 805239 , 811852 , 811862 , 811889 , 811891 , 811896 , 811905 , 814706 );
Copy
8.71 ms (7.80%)
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
432730
432734
811852
459030
449690
811889
456654
553185
426483
608363
752477
509077
455596
432736
510570
455594
702376
814706
811891
433067
454537
490162
702375
523552
759138
432708
432727
432735
451033
754209
573386
440526
811905
751384
811896
804265
448282
706620
805239
738675
751360
424048
579856
707384
751170
811862
431512
454533
459267
418575
745946
470411
738564
488923
483227
433904
497611
446690
455471
459472
459485
]
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 (432730 , 432734 , 811852 , 459030 , 449690 , 811889 , 456654 , 553185 , 426483 , 608363 , 752477 , 509077 , 455596 , 432736 , 510570 , 455594 , 702376 , 814706 , 811891 , 433067 , 454537 , 490162 , 702375 , 523552 , 759138 , 432708 , 432727 , 432735 , 451033 , 754209 , 573386 , 440526 , 811905 , 751384 , 811896 , 804265 , 448282 , 706620 , 805239 , 738675 , 751360 , 424048 , 579856 , 707384 , 751170 , 811862 , 431512 , 454533 , 459267 , 418575 , 745946 , 470411 , 738564 , 488923 , 483227 , 433904 , 497611 , 446690 , 455471 , 459472 , 459485 );
Copy
2.51 ms (2.25%)
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
418575
424048
426483
431512
432708
432727
432730
432734
432735
432736
433067
433904
440526
446690
448282
449690
451033
454533
454537
455471
455594
455596
456654
459030
459267
459472
459485
470411
483227
488923
490162
497611
509077
510570
523552
553185
573386
579856
608363
702375
702376
706620
707384
738564
738675
745946
751170
751360
751384
752477
754209
759138
804265
805239
811852
811862
811889
811891
811896
811905
814706
]
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 (418575 , 424048 , 426483 , 431512 , 432708 , 432727 , 432730 , 432734 , 432735 , 432736 , 433067 , 433904 , 440526 , 446690 , 448282 , 449690 , 451033 , 454533 , 454537 , 455471 , 455594 , 455596 , 456654 , 459030 , 459267 , 459472 , 459485 , 470411 , 483227 , 488923 , 490162 , 497611 , 509077 , 510570 , 523552 , 553185 , 573386 , 579856 , 608363 , 702375 , 702376 , 706620 , 707384 , 738564 , 738675 , 745946 , 751170 , 751360 , 751384 , 752477 , 754209 , 759138 , 804265 , 805239 , 811852 , 811862 , 811889 , 811891 , 811896 , 811905 , 814706 );
Copy