69.38 ms (59.56%)
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
427246
436756
446109
457199
459061
479955
479956
488858
490517
491373
497636
497865
501293
512936
513024
516483
516670
516780
517885
523021
523907
525848
529290
529692
541096
551183
560416
564132
565007
568216
569629
575997
577593
579532
581418
590622
593022
601444
602355
617175
625437
625440
635074
647023
655591
662431
679306
693799
700727
700731
709874
716270
731382
734044
737587
741824
751958
762855
789437
793944
793997
]
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 (427246 , 436756 , 446109 , 457199 , 459061 , 479955 , 479956 , 488858 , 490517 , 491373 , 497636 , 497865 , 501293 , 512936 , 513024 , 516483 , 516670 , 516780 , 517885 , 523021 , 523907 , 525848 , 529290 , 529692 , 541096 , 551183 , 560416 , 564132 , 565007 , 568216 , 569629 , 575997 , 577593 , 579532 , 581418 , 590622 , 593022 , 601444 , 602355 , 617175 , 625437 , 625440 , 635074 , 647023 , 655591 , 662431 , 679306 , 693799 , 700727 , 700731 , 709874 , 716270 , 731382 , 734044 , 737587 , 741824 , 751958 , 762855 , 789437 , 793944 , 793997 );
Copy
11.43 ms (9.81%)
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
741824
793997
731382
700731
529692
579532
716270
789437
793944
737587
734044
457199
541096
575997
581418
568216
693799
662431
679306
593022
751958
762855
513024
501293
436756
459061
497636
569629
560416
565007
647023
700727
551183
590622
602355
479955
525848
516670
488858
490517
709874
564132
601444
479956
516780
517885
491373
516483
512936
577593
655591
523907
635074
427246
617175
523021
446109
497865
625437
529290
625440
]
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 (741824 , 793997 , 731382 , 700731 , 529692 , 579532 , 716270 , 789437 , 793944 , 737587 , 734044 , 457199 , 541096 , 575997 , 581418 , 568216 , 693799 , 662431 , 679306 , 593022 , 751958 , 762855 , 513024 , 501293 , 436756 , 459061 , 497636 , 569629 , 560416 , 565007 , 647023 , 700727 , 551183 , 590622 , 602355 , 479955 , 525848 , 516670 , 488858 , 490517 , 709874 , 564132 , 601444 , 479956 , 516780 , 517885 , 491373 , 516483 , 512936 , 577593 , 655591 , 523907 , 635074 , 427246 , 617175 , 523021 , 446109 , 497865 , 625437 , 529290 , 625440 );
Copy
2.93 ms (2.51%)
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
427246
436756
446109
457199
459061
479955
479956
488858
490517
491373
497636
497865
501293
512936
513024
516483
516670
516780
517885
523021
523907
525848
529290
529692
541096
551183
560416
564132
565007
568216
569629
575997
577593
579532
581418
590622
593022
601444
602355
617175
625437
625440
635074
647023
655591
662431
679306
693799
700727
700731
709874
716270
731382
734044
737587
741824
751958
762855
789437
793944
793997
]
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 (427246 , 436756 , 446109 , 457199 , 459061 , 479955 , 479956 , 488858 , 490517 , 491373 , 497636 , 497865 , 501293 , 512936 , 513024 , 516483 , 516670 , 516780 , 517885 , 523021 , 523907 , 525848 , 529290 , 529692 , 541096 , 551183 , 560416 , 564132 , 565007 , 568216 , 569629 , 575997 , 577593 , 579532 , 581418 , 590622 , 593022 , 601444 , 602355 , 617175 , 625437 , 625440 , 635074 , 647023 , 655591 , 662431 , 679306 , 693799 , 700727 , 700731 , 709874 , 716270 , 731382 , 734044 , 737587 , 741824 , 751958 , 762855 , 789437 , 793944 , 793997 );
Copy