69.28 ms (71.09%)
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
126458
383020
388628
388887
401262
418897
419737
443580
445811
457272
458605
458614
462795
476151
523478
535418
537909
541240
558572
558576
558578
559629
563936
578059
583035
587920
648485
649935
665809
666476
669397
671682
674074
674410
676182
676417
676418
676421
676422
676423
676424
676425
684949
685637
685639
685646
700305
700306
700307
709211
718675
735115
764514
764524
780650
798569
805332
813543
818457
821571
]
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 (126458 , 383020 , 388628 , 388887 , 401262 , 418897 , 419737 , 443580 , 445811 , 457272 , 458605 , 458614 , 462795 , 476151 , 523478 , 535418 , 537909 , 541240 , 558572 , 558576 , 558578 , 559629 , 563936 , 578059 , 583035 , 587920 , 648485 , 649935 , 665809 , 666476 , 669397 , 671682 , 674074 , 674410 , 676182 , 676417 , 676418 , 676421 , 676422 , 676423 , 676424 , 676425 , 684949 , 685637 , 685639 , 685646 , 700305 , 700306 , 700307 , 709211 , 718675 , 735115 , 764514 , 764524 , 780650 , 798569 , 805332 , 813543 , 818457 , 821571 );
Copy
15.46 ms (15.86%)
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
709211
674074
822749
676182
669397
676425
558576
685639
676422
685637
764524
700306
685646
676421
805332
798569
700305
583035
674410
676418
764514
578059
676423
676424
559629
541240
700307
676417
558572
648485
821571
813543
735115
383020
126458
419737
666476
671682
418897
665809
445811
684949
457272
458605
388628
401262
818457
649935
780650
462795
535418
388887
563936
718675
537909
587920
523478
443580
476151
458614
558578
]
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 (709211 , 674074 , 822749 , 676182 , 669397 , 676425 , 558576 , 685639 , 676422 , 685637 , 764524 , 700306 , 685646 , 676421 , 805332 , 798569 , 700305 , 583035 , 674410 , 676418 , 764514 , 578059 , 676423 , 676424 , 559629 , 541240 , 700307 , 676417 , 558572 , 648485 , 821571 , 813543 , 735115 , 383020 , 126458 , 419737 , 666476 , 671682 , 418897 , 665809 , 445811 , 684949 , 457272 , 458605 , 388628 , 401262 , 818457 , 649935 , 780650 , 462795 , 535418 , 388887 , 563936 , 718675 , 537909 , 587920 , 523478 , 443580 , 476151 , 458614 , 558578 );
Copy
3.01 ms (3.09%)
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
126458
383020
388628
388887
401262
418897
419737
443580
445811
457272
458605
458614
462795
476151
523478
535418
537909
541240
558572
558576
558578
559629
563936
578059
583035
587920
648485
649935
665809
666476
669397
671682
674074
674410
676182
676417
676418
676421
676422
676423
676424
676425
684949
685637
685639
685646
700305
700306
700307
709211
718675
735115
764514
764524
780650
798569
805332
813543
818457
821571
]
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 (126458 , 383020 , 388628 , 388887 , 401262 , 418897 , 419737 , 443580 , 445811 , 457272 , 458605 , 458614 , 462795 , 476151 , 523478 , 535418 , 537909 , 541240 , 558572 , 558576 , 558578 , 559629 , 563936 , 578059 , 583035 , 587920 , 648485 , 649935 , 665809 , 666476 , 669397 , 671682 , 674074 , 674410 , 676182 , 676417 , 676418 , 676421 , 676422 , 676423 , 676424 , 676425 , 684949 , 685637 , 685639 , 685646 , 700305 , 700306 , 700307 , 709211 , 718675 , 735115 , 764514 , 764524 , 780650 , 798569 , 805332 , 813543 , 818457 , 821571 );
Copy