83.06 ms (70.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
14369
395252
396720
397652
405799
410227
411211
416663
419045
423384
426600
457480
465660
486773
497691
504210
505386
506957
513842
514254
540945
547469
547854
555306
583377
584166
592776
596684
597799
604717
616643
618280
619485
619802
633052
633119
634108
642022
662813
721163
722072
726276
732630
736484
736534
738827
748431
749264
751217
752663
752679
752706
756394
776713
782601
787466
787508
800623
801159
818944
823616
]
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 (14369 , 395252 , 396720 , 397652 , 405799 , 410227 , 411211 , 416663 , 419045 , 423384 , 426600 , 457480 , 465660 , 486773 , 497691 , 504210 , 505386 , 506957 , 513842 , 514254 , 540945 , 547469 , 547854 , 555306 , 583377 , 584166 , 592776 , 596684 , 597799 , 604717 , 616643 , 618280 , 619485 , 619802 , 633052 , 633119 , 634108 , 642022 , 662813 , 721163 , 722072 , 726276 , 732630 , 736484 , 736534 , 738827 , 748431 , 749264 , 751217 , 752663 , 752679 , 752706 , 756394 , 776713 , 782601 , 787466 , 787508 , 800623 , 801159 , 818944 , 823616 );
Copy
9.85 ms (8.31%)
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
732630
801159
751217
633052
506957
726276
736534
736484
756394
721163
604717
800623
748431
540945
616643
749264
752663
618280
662813
752679
722072
465660
514254
596684
619485
505386
583377
634108
738827
752706
642022
619802
410227
405799
823616
397652
782601
818944
547469
787466
395252
547854
423384
504210
555306
584166
597799
776713
633119
787508
419045
457480
497691
396720
14369
513842
426600
411211
486773
592776
416663
]
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 (732630 , 801159 , 751217 , 633052 , 506957 , 726276 , 736534 , 736484 , 756394 , 721163 , 604717 , 800623 , 748431 , 540945 , 616643 , 749264 , 752663 , 618280 , 662813 , 752679 , 722072 , 465660 , 514254 , 596684 , 619485 , 505386 , 583377 , 634108 , 738827 , 752706 , 642022 , 619802 , 410227 , 405799 , 823616 , 397652 , 782601 , 818944 , 547469 , 787466 , 395252 , 547854 , 423384 , 504210 , 555306 , 584166 , 597799 , 776713 , 633119 , 787508 , 419045 , 457480 , 497691 , 396720 , 14369 , 513842 , 426600 , 411211 , 486773 , 592776 , 416663 );
Copy
2.42 ms (2.04%)
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
14369
395252
396720
397652
405799
410227
411211
416663
419045
423384
426600
457480
465660
486773
497691
504210
505386
506957
513842
514254
540945
547469
547854
555306
583377
584166
592776
596684
597799
604717
616643
618280
619485
619802
633052
633119
634108
642022
662813
721163
722072
726276
732630
736484
736534
738827
748431
749264
751217
752663
752679
752706
756394
776713
782601
787466
787508
800623
801159
818944
823616
]
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 (14369 , 395252 , 396720 , 397652 , 405799 , 410227 , 411211 , 416663 , 419045 , 423384 , 426600 , 457480 , 465660 , 486773 , 497691 , 504210 , 505386 , 506957 , 513842 , 514254 , 540945 , 547469 , 547854 , 555306 , 583377 , 584166 , 592776 , 596684 , 597799 , 604717 , 616643 , 618280 , 619485 , 619802 , 633052 , 633119 , 634108 , 642022 , 662813 , 721163 , 722072 , 726276 , 732630 , 736484 , 736534 , 738827 , 748431 , 749264 , 751217 , 752663 , 752679 , 752706 , 756394 , 776713 , 782601 , 787466 , 787508 , 800623 , 801159 , 818944 , 823616 );
Copy