269.10 ms (82.80%)
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
185950
390923
426496
426663
432707
436047
444601
448693
451132
451470
451926
451961
451971
451974
452046
452060
452063
471951
488567
491823
494459
494461
504174
526908
543941
553240
579230
590537
594151
629868
669771
670197
685789
692829
694441
729678
772441
778550
779576
779729
818785
825576
825759
]
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 (185950 , 390923 , 426496 , 426663 , 432707 , 436047 , 444601 , 448693 , 451132 , 451470 , 451926 , 451961 , 451971 , 451974 , 452046 , 452060 , 452063 , 471951 , 488567 , 491823 , 494459 , 494461 , 504174 , 526908 , 543941 , 553240 , 579230 , 590537 , 594151 , 629868 , 669771 , 670197 , 685789 , 692829 , 694441 , 729678 , 772441 , 778550 , 779576 , 779729 , 818785 , 825576 , 825759 );
Copy
10.10 ms (3.11%)
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
494461
494459
825576
543941
825759
692829
779729
818785
685789
694441
629868
553240
772441
185950
669771
590537
779576
778550
451470
444601
729678
426496
390923
670197
579230
594151
426663
452046
448693
488567
432707
436047
471951
451961
451971
504174
451926
452063
526908
451974
452060
451132
491823
]
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 (494461 , 494459 , 825576 , 543941 , 825759 , 692829 , 779729 , 818785 , 685789 , 694441 , 629868 , 553240 , 772441 , 185950 , 669771 , 590537 , 779576 , 778550 , 451470 , 444601 , 729678 , 426496 , 390923 , 670197 , 579230 , 594151 , 426663 , 452046 , 448693 , 488567 , 432707 , 436047 , 471951 , 451961 , 451971 , 504174 , 451926 , 452063 , 526908 , 451974 , 452060 , 451132 , 491823 );
Copy
3.06 ms (0.94%)
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
185950
390923
426496
426663
432707
436047
444601
448693
451132
451470
451926
451961
451971
451974
452046
452060
452063
471951
488567
491823
494459
494461
504174
526908
543941
553240
579230
590537
594151
629868
669771
670197
685789
692829
694441
729678
772441
778550
779576
779729
818785
825576
825759
]
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 (185950 , 390923 , 426496 , 426663 , 432707 , 436047 , 444601 , 448693 , 451132 , 451470 , 451926 , 451961 , 451971 , 451974 , 452046 , 452060 , 452063 , 471951 , 488567 , 491823 , 494459 , 494461 , 504174 , 526908 , 543941 , 553240 , 579230 , 590537 , 594151 , 629868 , 669771 , 670197 , 685789 , 692829 , 694441 , 729678 , 772441 , 778550 , 779576 , 779729 , 818785 , 825576 , 825759 );
Copy