91.85 ms (60.29%)
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
381912
387922
395826
396050
396358
396449
408489
414673
417428
418399
418404
418410
418416
418417
421146
421271
426033
426038
426042
426044
430809
447629
447643
447650
447689
452053
461291
468757
478873
487713
491650
491718
506445
518468
531780
550207
574818
575058
575068
575162
576079
576109
576324
576347
576371
596168
597014
621988
631968
633782
636026
714431
714463
714464
714473
714526
742143
742158
775788
775797
775831
]
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 (381912 , 387922 , 395826 , 396050 , 396358 , 396449 , 408489 , 414673 , 417428 , 418399 , 418404 , 418410 , 418416 , 418417 , 421146 , 421271 , 426033 , 426038 , 426042 , 426044 , 430809 , 447629 , 447643 , 447650 , 447689 , 452053 , 461291 , 468757 , 478873 , 487713 , 491650 , 491718 , 506445 , 518468 , 531780 , 550207 , 574818 , 575058 , 575068 , 575162 , 576079 , 576109 , 576324 , 576347 , 576371 , 596168 , 597014 , 621988 , 631968 , 633782 , 636026 , 714431 , 714463 , 714464 , 714473 , 714526 , 742143 , 742158 , 775788 , 775797 , 775831 );
Copy
10.36 ms (6.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
714526
396449
426042
478873
430809
447650
414673
531780
575058
575162
576347
518468
633782
714431
447643
418416
487713
574818
742158
550207
381912
714463
468757
418404
714473
636026
775788
775831
418417
426044
576109
714464
775797
742143
396050
631968
408489
576324
387922
417428
491718
447629
575068
576371
597014
576079
418410
447689
491650
426038
396358
461291
426033
506445
395826
421146
418399
421271
452053
596168
621988
]
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 (714526 , 396449 , 426042 , 478873 , 430809 , 447650 , 414673 , 531780 , 575058 , 575162 , 576347 , 518468 , 633782 , 714431 , 447643 , 418416 , 487713 , 574818 , 742158 , 550207 , 381912 , 714463 , 468757 , 418404 , 714473 , 636026 , 775788 , 775831 , 418417 , 426044 , 576109 , 714464 , 775797 , 742143 , 396050 , 631968 , 408489 , 576324 , 387922 , 417428 , 491718 , 447629 , 575068 , 576371 , 597014 , 576079 , 418410 , 447689 , 491650 , 426038 , 396358 , 461291 , 426033 , 506445 , 395826 , 421146 , 418399 , 421271 , 452053 , 596168 , 621988 );
Copy
2.97 ms (1.95%)
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
381912
387922
395826
396050
396358
396449
408489
414673
417428
418399
418404
418410
418416
418417
421146
421271
426033
426038
426042
426044
430809
447629
447643
447650
447689
452053
461291
468757
478873
487713
491650
491718
506445
518468
531780
550207
574818
575058
575068
575162
576079
576109
576324
576347
576371
596168
597014
621988
631968
633782
636026
714431
714463
714464
714473
714526
742143
742158
775788
775797
775831
]
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 (381912 , 387922 , 395826 , 396050 , 396358 , 396449 , 408489 , 414673 , 417428 , 418399 , 418404 , 418410 , 418416 , 418417 , 421146 , 421271 , 426033 , 426038 , 426042 , 426044 , 430809 , 447629 , 447643 , 447650 , 447689 , 452053 , 461291 , 468757 , 478873 , 487713 , 491650 , 491718 , 506445 , 518468 , 531780 , 550207 , 574818 , 575058 , 575068 , 575162 , 576079 , 576109 , 576324 , 576347 , 576371 , 596168 , 597014 , 621988 , 631968 , 633782 , 636026 , 714431 , 714463 , 714464 , 714473 , 714526 , 742143 , 742158 , 775788 , 775797 , 775831 );
Copy