79.87 ms (42.47%)
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
414061
414771
417348
425820
432644
446026
446038
447904
454802
458923
481142
482768
482775
499931
502043
513965
514214
522138
530060
530382
530499
531085
531123
531129
532674
532741
532789
532843
533014
536378
536631
536638
537184
537659
537660
537675
539239
550633
550899
598105
628082
631202
633444
635224
638967
641683
642705
642706
644962
649504
668505
674927
678117
708441
721790
722373
722380
813221
814429
820779
]
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 (414061 , 414771 , 417348 , 425820 , 432644 , 446026 , 446038 , 447904 , 454802 , 458923 , 481142 , 482768 , 482775 , 499931 , 502043 , 513965 , 514214 , 522138 , 530060 , 530382 , 530499 , 531085 , 531123 , 531129 , 532674 , 532741 , 532789 , 532843 , 533014 , 536378 , 536631 , 536638 , 537184 , 537659 , 537660 , 537675 , 539239 , 550633 , 550899 , 598105 , 628082 , 631202 , 633444 , 635224 , 638967 , 641683 , 642705 , 642706 , 644962 , 649504 , 668505 , 674927 , 678117 , 708441 , 721790 , 722373 , 722380 , 813221 , 814429 , 820779 );
Copy
9.59 ms (5.10%)
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
536378
531085
537184
532789
502043
458923
482775
649504
814429
530382
417348
414771
522138
446026
539239
514214
633444
513965
721790
722380
481142
454802
482768
638967
550899
499931
641683
644962
820779
447904
532741
536631
446038
537660
530060
532674
635224
530499
531129
537675
537659
674927
708441
722373
532843
813221
642706
536638
678117
668505
631202
628082
533014
642705
531123
414061
432644
425820
550633
598105
]
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 (536378 , 531085 , 537184 , 532789 , 502043 , 458923 , 482775 , 649504 , 814429 , 530382 , 417348 , 414771 , 522138 , 446026 , 539239 , 514214 , 633444 , 513965 , 721790 , 722380 , 481142 , 454802 , 482768 , 638967 , 550899 , 499931 , 641683 , 644962 , 820779 , 447904 , 532741 , 536631 , 446038 , 537660 , 530060 , 532674 , 635224 , 530499 , 531129 , 537675 , 537659 , 674927 , 708441 , 722373 , 532843 , 813221 , 642706 , 536638 , 678117 , 668505 , 631202 , 628082 , 533014 , 642705 , 531123 , 414061 , 432644 , 425820 , 550633 , 598105 );
Copy
2.31 ms (1.23%)
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
414061
414771
417348
425820
432644
446026
446038
447904
454802
458923
481142
482768
482775
499931
502043
513965
514214
522138
530060
530382
530499
531085
531123
531129
532674
532741
532789
532843
533014
536378
536631
536638
537184
537659
537660
537675
539239
550633
550899
598105
628082
631202
633444
635224
638967
641683
642705
642706
644962
649504
668505
674927
678117
708441
721790
722373
722380
813221
814429
820779
]
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 (414061 , 414771 , 417348 , 425820 , 432644 , 446026 , 446038 , 447904 , 454802 , 458923 , 481142 , 482768 , 482775 , 499931 , 502043 , 513965 , 514214 , 522138 , 530060 , 530382 , 530499 , 531085 , 531123 , 531129 , 532674 , 532741 , 532789 , 532843 , 533014 , 536378 , 536631 , 536638 , 537184 , 537659 , 537660 , 537675 , 539239 , 550633 , 550899 , 598105 , 628082 , 631202 , 633444 , 635224 , 638967 , 641683 , 642705 , 642706 , 644962 , 649504 , 668505 , 674927 , 678117 , 708441 , 721790 , 722373 , 722380 , 813221 , 814429 , 820779 );
Copy