89.78 ms (76.14%)
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
51900
271280
402866
416128
419057
437974
438062
461233
461401
465692
467948
483998
485353
491096
501714
514066
516963
522439
527845
531935
540627
548267
558795
585808
592834
605909
622353
631514
635686
638000
638087
638298
638859
641110
644396
645976
653307
667371
714755
718601
719823
731317
733933
734130
744763
756314
761981
763802
763892
767771
775235
778810
779848
781030
781224
793956
793981
794970
797261
798717
798904
818701
818987
826640
]
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 (51900 , 271280 , 402866 , 416128 , 419057 , 437974 , 438062 , 461233 , 461401 , 465692 , 467948 , 483998 , 485353 , 491096 , 501714 , 514066 , 516963 , 522439 , 527845 , 531935 , 540627 , 548267 , 558795 , 585808 , 592834 , 605909 , 622353 , 631514 , 635686 , 638000 , 638087 , 638298 , 638859 , 641110 , 644396 , 645976 , 653307 , 667371 , 714755 , 718601 , 719823 , 731317 , 733933 , 734130 , 744763 , 756314 , 761981 , 763802 , 763892 , 767771 , 775235 , 778810 , 779848 , 781030 , 781224 , 793956 , 793981 , 794970 , 797261 , 798717 , 798904 , 818701 , 818987 , 826640 );
Copy
10.28 ms (8.72%)
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
779848
797261
734130
51900
798904
416128
794970
437974
798717
467948
763802
761981
781030
641110
271280
631514
605909
540627
781224
763892
818701
635686
419057
767771
402866
645976
793956
793981
667371
592834
778810
438062
714755
818987
527845
638000
826640
653307
719823
733933
768323
622353
461233
522439
483998
558795
744763
465692
548267
718601
585808
638087
731317
638859
644396
756314
461401
514066
516963
501714
485353
531935
491096
775235
638298
]
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 (779848 , 797261 , 734130 , 51900 , 798904 , 416128 , 794970 , 437974 , 798717 , 467948 , 763802 , 761981 , 781030 , 641110 , 271280 , 631514 , 605909 , 540627 , 781224 , 763892 , 818701 , 635686 , 419057 , 767771 , 402866 , 645976 , 793956 , 793981 , 667371 , 592834 , 778810 , 438062 , 714755 , 818987 , 527845 , 638000 , 826640 , 653307 , 719823 , 733933 , 768323 , 622353 , 461233 , 522439 , 483998 , 558795 , 744763 , 465692 , 548267 , 718601 , 585808 , 638087 , 731317 , 638859 , 644396 , 756314 , 461401 , 514066 , 516963 , 501714 , 485353 , 531935 , 491096 , 775235 , 638298 );
Copy
2.16 ms (1.83%)
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
51900
271280
402866
416128
419057
437974
438062
461233
461401
465692
467948
483998
485353
491096
501714
514066
516963
522439
527845
531935
540627
548267
558795
585808
592834
605909
622353
631514
635686
638000
638087
638298
638859
641110
644396
645976
653307
667371
714755
718601
719823
731317
733933
734130
744763
756314
761981
763802
763892
767771
775235
778810
779848
781030
781224
793956
793981
794970
797261
798717
798904
818701
818987
826640
]
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 (51900 , 271280 , 402866 , 416128 , 419057 , 437974 , 438062 , 461233 , 461401 , 465692 , 467948 , 483998 , 485353 , 491096 , 501714 , 514066 , 516963 , 522439 , 527845 , 531935 , 540627 , 548267 , 558795 , 585808 , 592834 , 605909 , 622353 , 631514 , 635686 , 638000 , 638087 , 638298 , 638859 , 641110 , 644396 , 645976 , 653307 , 667371 , 714755 , 718601 , 719823 , 731317 , 733933 , 734130 , 744763 , 756314 , 761981 , 763802 , 763892 , 767771 , 775235 , 778810 , 779848 , 781030 , 781224 , 793956 , 793981 , 794970 , 797261 , 798717 , 798904 , 818701 , 818987 , 826640 );
Copy