84.32 ms (66.62%)
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
4306
396065
397095
402833
416138
417003
429523
432552
432685
432762
432777
441566
445051
447086
447507
448560
448650
452228
452634
461923
461930
465293
472647
472972
475462
475805
484298
491313
505846
506303
507685
541629
580241
581064
603824
624158
634742
675638
695892
715700
717666
720828
722627
725119
728410
731311
736470
740287
740288
740678
743068
766610
766883
768346
770295
770435
778427
779730
816607
822209
]
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 (4306 , 396065 , 397095 , 402833 , 416138 , 417003 , 429523 , 432552 , 432685 , 432762 , 432777 , 441566 , 445051 , 447086 , 447507 , 448560 , 448650 , 452228 , 452634 , 461923 , 461930 , 465293 , 472647 , 472972 , 475462 , 475805 , 484298 , 491313 , 505846 , 506303 , 507685 , 541629 , 580241 , 581064 , 603824 , 624158 , 634742 , 675638 , 695892 , 715700 , 717666 , 720828 , 722627 , 725119 , 728410 , 731311 , 736470 , 740287 , 740288 , 740678 , 743068 , 766610 , 766883 , 768346 , 770295 , 770435 , 778427 , 779730 , 816607 , 822209 );
Copy
9.48 ms (7.49%)
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
822209
740678
770435
770295
717666
779730
432762
715700
728410
731311
396065
580241
766883
740288
766610
417003
816607
506303
740287
695892
768346
397095
541629
491313
461923
581064
720828
778427
472972
432552
507685
4306
416138
441566
445051
452634
675638
722627
634742
603824
725119
736470
743068
472647
402833
432777
448650
465293
475805
624158
447507
475462
505846
448560
447086
461930
432685
429523
484298
452228
]
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 (822209 , 740678 , 770435 , 770295 , 717666 , 779730 , 432762 , 715700 , 728410 , 731311 , 396065 , 580241 , 766883 , 740288 , 766610 , 417003 , 816607 , 506303 , 740287 , 695892 , 768346 , 397095 , 541629 , 491313 , 461923 , 581064 , 720828 , 778427 , 472972 , 432552 , 507685 , 4306 , 416138 , 441566 , 445051 , 452634 , 675638 , 722627 , 634742 , 603824 , 725119 , 736470 , 743068 , 472647 , 402833 , 432777 , 448650 , 465293 , 475805 , 624158 , 447507 , 475462 , 505846 , 448560 , 447086 , 461930 , 432685 , 429523 , 484298 , 452228 );
Copy
3.28 ms (2.59%)
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
4306
396065
397095
402833
416138
417003
429523
432552
432685
432762
432777
441566
445051
447086
447507
448560
448650
452228
452634
461923
461930
465293
472647
472972
475462
475805
484298
491313
505846
506303
507685
541629
580241
581064
603824
624158
634742
675638
695892
715700
717666
720828
722627
725119
728410
731311
736470
740287
740288
740678
743068
766610
766883
768346
770295
770435
778427
779730
816607
822209
]
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 (4306 , 396065 , 397095 , 402833 , 416138 , 417003 , 429523 , 432552 , 432685 , 432762 , 432777 , 441566 , 445051 , 447086 , 447507 , 448560 , 448650 , 452228 , 452634 , 461923 , 461930 , 465293 , 472647 , 472972 , 475462 , 475805 , 484298 , 491313 , 505846 , 506303 , 507685 , 541629 , 580241 , 581064 , 603824 , 624158 , 634742 , 675638 , 695892 , 715700 , 717666 , 720828 , 722627 , 725119 , 728410 , 731311 , 736470 , 740287 , 740288 , 740678 , 743068 , 766610 , 766883 , 768346 , 770295 , 770435 , 778427 , 779730 , 816607 , 822209 );
Copy