511.18 ms (92.70%)
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
397811
398476
403464
407682
413112
414036
418941
435537
443760
460829
472569
474022
486081
500366
500367
505826
515068
518312
523779
530740
532682
533897
533959
537826
549833
555995
557742
561465
567109
576125
584890
586535
603431
613167
623380
713193
714459
714771
715869
718553
726600
730069
734038
740492
741047
747073
755952
768887
785438
790882
796833
796843
798679
800598
801338
806540
808155
808474
813956
819630
825037
]
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 (397811 , 398476 , 403464 , 407682 , 413112 , 414036 , 418941 , 435537 , 443760 , 460829 , 472569 , 474022 , 486081 , 500366 , 500367 , 505826 , 515068 , 518312 , 523779 , 530740 , 532682 , 533897 , 533959 , 537826 , 549833 , 555995 , 557742 , 561465 , 567109 , 576125 , 584890 , 586535 , 603431 , 613167 , 623380 , 713193 , 714459 , 714771 , 715869 , 718553 , 726600 , 730069 , 734038 , 740492 , 741047 , 747073 , 755952 , 768887 , 785438 , 790882 , 796833 , 796843 , 798679 , 800598 , 801338 , 806540 , 808155 , 808474 , 813956 , 819630 , 825037 );
Copy
9.91 ms (1.80%)
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
747073
755952
515068
819630
806540
718553
530740
800598
714771
825037
537826
801338
730069
398476
397811
713193
808474
561465
741047
768887
584890
576125
790882
785438
443760
474022
798679
403464
407682
413112
549833
726600
714459
486081
813956
505826
613167
435537
414036
533897
557742
586535
796843
796833
740492
472569
460829
555995
715869
808155
532682
523779
518312
734038
603431
533959
418941
500367
500366
623380
567109
]
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 (747073 , 755952 , 515068 , 819630 , 806540 , 718553 , 530740 , 800598 , 714771 , 825037 , 537826 , 801338 , 730069 , 398476 , 397811 , 713193 , 808474 , 561465 , 741047 , 768887 , 584890 , 576125 , 790882 , 785438 , 443760 , 474022 , 798679 , 403464 , 407682 , 413112 , 549833 , 726600 , 714459 , 486081 , 813956 , 505826 , 613167 , 435537 , 414036 , 533897 , 557742 , 586535 , 796843 , 796833 , 740492 , 472569 , 460829 , 555995 , 715869 , 808155 , 532682 , 523779 , 518312 , 734038 , 603431 , 533959 , 418941 , 500367 , 500366 , 623380 , 567109 );
Copy
2.81 ms (0.51%)
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
397811
398476
403464
407682
413112
414036
418941
435537
443760
460829
472569
474022
486081
500366
500367
505826
515068
518312
523779
530740
532682
533897
533959
537826
549833
555995
557742
561465
567109
576125
584890
586535
603431
613167
623380
713193
714459
714771
715869
718553
726600
730069
734038
740492
741047
747073
755952
768887
785438
790882
796833
796843
798679
800598
801338
806540
808155
808474
813956
819630
825037
]
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 (397811 , 398476 , 403464 , 407682 , 413112 , 414036 , 418941 , 435537 , 443760 , 460829 , 472569 , 474022 , 486081 , 500366 , 500367 , 505826 , 515068 , 518312 , 523779 , 530740 , 532682 , 533897 , 533959 , 537826 , 549833 , 555995 , 557742 , 561465 , 567109 , 576125 , 584890 , 586535 , 603431 , 613167 , 623380 , 713193 , 714459 , 714771 , 715869 , 718553 , 726600 , 730069 , 734038 , 740492 , 741047 , 747073 , 755952 , 768887 , 785438 , 790882 , 796833 , 796843 , 798679 , 800598 , 801338 , 806540 , 808155 , 808474 , 813956 , 819630 , 825037 );
Copy