297.01 ms (82.90%)
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
420769
421250
423329
443991
449933
457192
457332
460099
466493
467583
468035
468046
478096
478568
478608
499334
501255
506790
508187
517609
524898
527029
532101
534784
538360
543392
543602
543613
544640
550292
550667
558979
567208
574224
582134
582821
582935
583371
590879
597152
597753
600030
603605
605453
605532
605663
612792
614020
630915
631908
633903
644917
645196
645201
653869
653956
654294
694032
720923
733071
733573
]
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 (420769 , 421250 , 423329 , 443991 , 449933 , 457192 , 457332 , 460099 , 466493 , 467583 , 468035 , 468046 , 478096 , 478568 , 478608 , 499334 , 501255 , 506790 , 508187 , 517609 , 524898 , 527029 , 532101 , 534784 , 538360 , 543392 , 543602 , 543613 , 544640 , 550292 , 550667 , 558979 , 567208 , 574224 , 582134 , 582821 , 582935 , 583371 , 590879 , 597152 , 597753 , 600030 , 603605 , 605453 , 605532 , 605663 , 612792 , 614020 , 630915 , 631908 , 633903 , 644917 , 645196 , 645201 , 653869 , 653956 , 654294 , 694032 , 720923 , 733071 , 733573 );
Copy
13.06 ms (3.65%)
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
653869
694032
582134
633903
654294
466493
532101
644917
478568
508187
499334
527029
543602
653956
550292
590879
614020
597753
631908
733573
506790
517609
544640
630915
468046
605453
457332
543392
720923
645201
443991
543613
457192
501255
534784
574224
582935
449933
478608
603605
460099
478096
605663
420769
645196
597152
558979
524898
468035
467583
421250
538360
605532
600030
583371
733071
550667
582821
612792
567208
423329
]
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 (653869 , 694032 , 582134 , 633903 , 654294 , 466493 , 532101 , 644917 , 478568 , 508187 , 499334 , 527029 , 543602 , 653956 , 550292 , 590879 , 614020 , 597753 , 631908 , 733573 , 506790 , 517609 , 544640 , 630915 , 468046 , 605453 , 457332 , 543392 , 720923 , 645201 , 443991 , 543613 , 457192 , 501255 , 534784 , 574224 , 582935 , 449933 , 478608 , 603605 , 460099 , 478096 , 605663 , 420769 , 645196 , 597152 , 558979 , 524898 , 468035 , 467583 , 421250 , 538360 , 605532 , 600030 , 583371 , 733071 , 550667 , 582821 , 612792 , 567208 , 423329 );
Copy
2.99 ms (0.83%)
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
420769
421250
423329
443991
449933
457192
457332
460099
466493
467583
468035
468046
478096
478568
478608
499334
501255
506790
508187
517609
524898
527029
532101
534784
538360
543392
543602
543613
544640
550292
550667
558979
567208
574224
582134
582821
582935
583371
590879
597152
597753
600030
603605
605453
605532
605663
612792
614020
630915
631908
633903
644917
645196
645201
653869
653956
654294
694032
720923
733071
733573
]
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 (420769 , 421250 , 423329 , 443991 , 449933 , 457192 , 457332 , 460099 , 466493 , 467583 , 468035 , 468046 , 478096 , 478568 , 478608 , 499334 , 501255 , 506790 , 508187 , 517609 , 524898 , 527029 , 532101 , 534784 , 538360 , 543392 , 543602 , 543613 , 544640 , 550292 , 550667 , 558979 , 567208 , 574224 , 582134 , 582821 , 582935 , 583371 , 590879 , 597152 , 597753 , 600030 , 603605 , 605453 , 605532 , 605663 , 612792 , 614020 , 630915 , 631908 , 633903 , 644917 , 645196 , 645201 , 653869 , 653956 , 654294 , 694032 , 720923 , 733071 , 733573 );
Copy