77.65 ms (55.55%)
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
426416
428761
446109
448954
449764
454141
455333
455941
455974
455993
457789
458333
472299
474777
482534
485061
486875
489262
496526
496794
501251
503194
510254
517564
517779
518941
519561
519589
525286
527608
527908
528382
529290
537670
537672
537815
540071
550599
560899
562361
562790
564377
564555
564918
572716
594353
599967
600995
601851
603716
605529
606624
609531
615721
625437
626136
639810
651039
681121
730798
]
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 (426416 , 428761 , 446109 , 448954 , 449764 , 454141 , 455333 , 455941 , 455974 , 455993 , 457789 , 458333 , 472299 , 474777 , 482534 , 485061 , 486875 , 489262 , 496526 , 496794 , 501251 , 503194 , 510254 , 517564 , 517779 , 518941 , 519561 , 519589 , 525286 , 527608 , 527908 , 528382 , 529290 , 537670 , 537672 , 537815 , 540071 , 550599 , 560899 , 562361 , 562790 , 564377 , 564555 , 564918 , 572716 , 594353 , 599967 , 600995 , 601851 , 603716 , 605529 , 606624 , 609531 , 615721 , 625437 , 626136 , 639810 , 651039 , 681121 , 730798 );
Copy
13.12 ms (9.39%)
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
454141
455941
426416
448954
485061
537672
537670
594353
600995
606624
517564
455993
537815
518941
560899
605529
615721
603716
455333
446109
474777
528382
651039
496526
681121
609531
472299
482534
496794
626136
639810
601851
449764
455974
529290
519589
517779
625437
564377
564555
428761
564918
572716
525286
540071
458333
486875
519561
527608
501251
489262
503194
599967
562361
510254
457789
562790
730798
527908
550599
]
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 (454141 , 455941 , 426416 , 448954 , 485061 , 537672 , 537670 , 594353 , 600995 , 606624 , 517564 , 455993 , 537815 , 518941 , 560899 , 605529 , 615721 , 603716 , 455333 , 446109 , 474777 , 528382 , 651039 , 496526 , 681121 , 609531 , 472299 , 482534 , 496794 , 626136 , 639810 , 601851 , 449764 , 455974 , 529290 , 519589 , 517779 , 625437 , 564377 , 564555 , 428761 , 564918 , 572716 , 525286 , 540071 , 458333 , 486875 , 519561 , 527608 , 501251 , 489262 , 503194 , 599967 , 562361 , 510254 , 457789 , 562790 , 730798 , 527908 , 550599 );
Copy
2.78 ms (1.99%)
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
426416
428761
446109
448954
449764
454141
455333
455941
455974
455993
457789
458333
472299
474777
482534
485061
486875
489262
496526
496794
501251
503194
510254
517564
517779
518941
519561
519589
525286
527608
527908
528382
529290
537670
537672
537815
540071
550599
560899
562361
562790
564377
564555
564918
572716
594353
599967
600995
601851
603716
605529
606624
609531
615721
625437
626136
639810
651039
681121
730798
]
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 (426416 , 428761 , 446109 , 448954 , 449764 , 454141 , 455333 , 455941 , 455974 , 455993 , 457789 , 458333 , 472299 , 474777 , 482534 , 485061 , 486875 , 489262 , 496526 , 496794 , 501251 , 503194 , 510254 , 517564 , 517779 , 518941 , 519561 , 519589 , 525286 , 527608 , 527908 , 528382 , 529290 , 537670 , 537672 , 537815 , 540071 , 550599 , 560899 , 562361 , 562790 , 564377 , 564555 , 564918 , 572716 , 594353 , 599967 , 600995 , 601851 , 603716 , 605529 , 606624 , 609531 , 615721 , 625437 , 626136 , 639810 , 651039 , 681121 , 730798 );
Copy