97.71 ms (66.04%)
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
411425
417473
418018
426547
435324
444313
446551
448375
453069
453073
454509
454669
455795
455799
456138
456887
457595
457611
457723
457729
457774
457780
458991
462644
471080
475849
479637
488541
495275
498402
499720
511028
513828
525647
529358
533631
537268
538653
541606
541638
541712
542525
543612
544828
548849
549356
553957
554751
559736
562903
570832
577666
578494
579814
593245
595877
598097
615831
635577
663992
818638
]
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 (411425 , 417473 , 418018 , 426547 , 435324 , 444313 , 446551 , 448375 , 453069 , 453073 , 454509 , 454669 , 455795 , 455799 , 456138 , 456887 , 457595 , 457611 , 457723 , 457729 , 457774 , 457780 , 458991 , 462644 , 471080 , 475849 , 479637 , 488541 , 495275 , 498402 , 499720 , 511028 , 513828 , 525647 , 529358 , 533631 , 537268 , 538653 , 541606 , 541638 , 541712 , 542525 , 543612 , 544828 , 548849 , 549356 , 553957 , 554751 , 559736 , 562903 , 570832 , 577666 , 578494 , 579814 , 593245 , 595877 , 598097 , 615831 , 635577 , 663992 , 818638 );
Copy
12.63 ms (8.53%)
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
411425
495275
579814
456887
570832
818638
541606
498402
446551
554751
549356
513828
525647
562903
543612
578494
663992
457723
457780
457774
499720
475849
593245
455799
435324
454669
529358
553957
615831
453069
453073
444313
559736
457729
542525
458991
538653
577666
456138
448375
488541
471080
635577
457595
544828
418018
479637
595877
417473
426547
462644
454509
548849
533631
537268
511028
457611
541712
598097
455795
541638
]
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 (411425 , 495275 , 579814 , 456887 , 570832 , 818638 , 541606 , 498402 , 446551 , 554751 , 549356 , 513828 , 525647 , 562903 , 543612 , 578494 , 663992 , 457723 , 457780 , 457774 , 499720 , 475849 , 593245 , 455799 , 435324 , 454669 , 529358 , 553957 , 615831 , 453069 , 453073 , 444313 , 559736 , 457729 , 542525 , 458991 , 538653 , 577666 , 456138 , 448375 , 488541 , 471080 , 635577 , 457595 , 544828 , 418018 , 479637 , 595877 , 417473 , 426547 , 462644 , 454509 , 548849 , 533631 , 537268 , 511028 , 457611 , 541712 , 598097 , 455795 , 541638 );
Copy
3.05 ms (2.06%)
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
411425
417473
418018
426547
435324
444313
446551
448375
453069
453073
454509
454669
455795
455799
456138
456887
457595
457611
457723
457729
457774
457780
458991
462644
471080
475849
479637
488541
495275
498402
499720
511028
513828
525647
529358
533631
537268
538653
541606
541638
541712
542525
543612
544828
548849
549356
553957
554751
559736
562903
570832
577666
578494
579814
593245
595877
598097
615831
635577
663992
818638
]
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 (411425 , 417473 , 418018 , 426547 , 435324 , 444313 , 446551 , 448375 , 453069 , 453073 , 454509 , 454669 , 455795 , 455799 , 456138 , 456887 , 457595 , 457611 , 457723 , 457729 , 457774 , 457780 , 458991 , 462644 , 471080 , 475849 , 479637 , 488541 , 495275 , 498402 , 499720 , 511028 , 513828 , 525647 , 529358 , 533631 , 537268 , 538653 , 541606 , 541638 , 541712 , 542525 , 543612 , 544828 , 548849 , 549356 , 553957 , 554751 , 559736 , 562903 , 570832 , 577666 , 578494 , 579814 , 593245 , 595877 , 598097 , 615831 , 635577 , 663992 , 818638 );
Copy