64.50 ms (51.09%)
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
388110
408339
423783
452640
511273
517807
523245
540743
547762
551814
565127
576943
581873
586407
587151
594150
604933
605021
607288
639326
667077
733454
734823
740919
751627
752860
754351
755022
755383
756045
757416
772548
772584
777651
777719
783242
785812
785888
785901
787328
787358
805544
805577
807211
807571
808562
813597
819243
819248
]
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 (388110 , 408339 , 423783 , 452640 , 511273 , 517807 , 523245 , 540743 , 547762 , 551814 , 565127 , 576943 , 581873 , 586407 , 587151 , 594150 , 604933 , 605021 , 607288 , 639326 , 667077 , 733454 , 734823 , 740919 , 751627 , 752860 , 754351 , 755022 , 755383 , 756045 , 757416 , 772548 , 772584 , 777651 , 777719 , 783242 , 785812 , 785888 , 785901 , 787328 , 787358 , 805544 , 805577 , 807211 , 807571 , 808562 , 813597 , 819243 , 819248 );
Copy
9.28 ms (7.35%)
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
777719
551814
819248
605021
785888
576943
805577
755383
819243
785901
783242
807211
807571
813597
734823
756045
587151
754351
772548
787358
787328
733454
805544
752860
808562
772584
667077
751627
547762
607288
777651
755022
757416
740919
408339
540743
565127
586407
639326
523245
594150
388110
511273
452640
785812
517807
581873
423783
604933
]
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 (777719 , 551814 , 819248 , 605021 , 785888 , 576943 , 805577 , 755383 , 819243 , 785901 , 783242 , 807211 , 807571 , 813597 , 734823 , 756045 , 587151 , 754351 , 772548 , 787358 , 787328 , 733454 , 805544 , 752860 , 808562 , 772584 , 667077 , 751627 , 547762 , 607288 , 777651 , 755022 , 757416 , 740919 , 408339 , 540743 , 565127 , 586407 , 639326 , 523245 , 594150 , 388110 , 511273 , 452640 , 785812 , 517807 , 581873 , 423783 , 604933 );
Copy
2.71 ms (2.15%)
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
388110
408339
423783
452640
511273
517807
523245
540743
547762
551814
565127
576943
581873
586407
587151
594150
604933
605021
607288
639326
667077
733454
734823
740919
751627
752860
754351
755022
755383
756045
757416
772548
772584
777651
777719
783242
785812
785888
785901
787328
787358
805544
805577
807211
807571
808562
813597
819243
819248
]
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 (388110 , 408339 , 423783 , 452640 , 511273 , 517807 , 523245 , 540743 , 547762 , 551814 , 565127 , 576943 , 581873 , 586407 , 587151 , 594150 , 604933 , 605021 , 607288 , 639326 , 667077 , 733454 , 734823 , 740919 , 751627 , 752860 , 754351 , 755022 , 755383 , 756045 , 757416 , 772548 , 772584 , 777651 , 777719 , 783242 , 785812 , 785888 , 785901 , 787328 , 787358 , 805544 , 805577 , 807211 , 807571 , 808562 , 813597 , 819243 , 819248 );
Copy