76.33 ms (45.64%)
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
397940
418068
421077
423633
429805
429817
433231
434874
437504
444838
447722
447898
448414
449115
452097
452456
465354
469200
472286
478065
482559
483567
496756
511266
514241
519299
525440
532876
534166
540167
541635
552623
553480
555317
573212
597170
602928
604109
608414
611567
613515
616822
620163
631171
634178
639301
641644
647995
666850
676428
688369
695123
695127
695181
711283
716394
723287
729344
766694
786463
816007
]
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 (397940 , 418068 , 421077 , 423633 , 429805 , 429817 , 433231 , 434874 , 437504 , 444838 , 447722 , 447898 , 448414 , 449115 , 452097 , 452456 , 465354 , 469200 , 472286 , 478065 , 482559 , 483567 , 496756 , 511266 , 514241 , 519299 , 525440 , 532876 , 534166 , 540167 , 541635 , 552623 , 553480 , 555317 , 573212 , 597170 , 602928 , 604109 , 608414 , 611567 , 613515 , 616822 , 620163 , 631171 , 634178 , 639301 , 641644 , 647995 , 666850 , 676428 , 688369 , 695123 , 695127 , 695181 , 711283 , 716394 , 723287 , 729344 , 766694 , 786463 , 816007 );
Copy
9.46 ms (5.66%)
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
452456
447898
469200
444838
472286
716394
434874
602928
447722
437504
483567
766694
429805
449115
433231
723287
553480
631171
397940
482559
448414
552623
604109
620163
639301
729344
421077
418068
511266
597170
616822
514241
532876
519299
688369
423633
786463
608414
465354
540167
429817
541635
816007
534166
647995
613515
478065
525440
452097
496756
711283
641644
555317
611567
695123
634178
695181
666850
676428
695127
573212
]
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 (452456 , 447898 , 469200 , 444838 , 472286 , 716394 , 434874 , 602928 , 447722 , 437504 , 483567 , 766694 , 429805 , 449115 , 433231 , 723287 , 553480 , 631171 , 397940 , 482559 , 448414 , 552623 , 604109 , 620163 , 639301 , 729344 , 421077 , 418068 , 511266 , 597170 , 616822 , 514241 , 532876 , 519299 , 688369 , 423633 , 786463 , 608414 , 465354 , 540167 , 429817 , 541635 , 816007 , 534166 , 647995 , 613515 , 478065 , 525440 , 452097 , 496756 , 711283 , 641644 , 555317 , 611567 , 695123 , 634178 , 695181 , 666850 , 676428 , 695127 , 573212 );
Copy
2.27 ms (1.35%)
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
397940
418068
421077
423633
429805
429817
433231
434874
437504
444838
447722
447898
448414
449115
452097
452456
465354
469200
472286
478065
482559
483567
496756
511266
514241
519299
525440
532876
534166
540167
541635
552623
553480
555317
573212
597170
602928
604109
608414
611567
613515
616822
620163
631171
634178
639301
641644
647995
666850
676428
688369
695123
695127
695181
711283
716394
723287
729344
766694
786463
816007
]
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 (397940 , 418068 , 421077 , 423633 , 429805 , 429817 , 433231 , 434874 , 437504 , 444838 , 447722 , 447898 , 448414 , 449115 , 452097 , 452456 , 465354 , 469200 , 472286 , 478065 , 482559 , 483567 , 496756 , 511266 , 514241 , 519299 , 525440 , 532876 , 534166 , 540167 , 541635 , 552623 , 553480 , 555317 , 573212 , 597170 , 602928 , 604109 , 608414 , 611567 , 613515 , 616822 , 620163 , 631171 , 634178 , 639301 , 641644 , 647995 , 666850 , 676428 , 688369 , 695123 , 695127 , 695181 , 711283 , 716394 , 723287 , 729344 , 766694 , 786463 , 816007 );
Copy