106.65 ms (76.10%)
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
420565
423913
432650
439710
440657
442533
448561
459485
463185
464702
467758
469651
476015
476264
482945
483424
487472
488550
488571
488867
492567
493017
493191
496566
497062
504183
504186
506794
507703
511033
512086
516819
517261
517769
521502
521507
523465
524174
524833
527391
528144
553591
554234
555973
555995
556470
557226
557941
568096
596978
602716
605559
615817
621887
625127
649211
756735
768570
783215
806247
812675
]
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 (420565 , 423913 , 432650 , 439710 , 440657 , 442533 , 448561 , 459485 , 463185 , 464702 , 467758 , 469651 , 476015 , 476264 , 482945 , 483424 , 487472 , 488550 , 488571 , 488867 , 492567 , 493017 , 493191 , 496566 , 497062 , 504183 , 504186 , 506794 , 507703 , 511033 , 512086 , 516819 , 517261 , 517769 , 521502 , 521507 , 523465 , 524174 , 524833 , 527391 , 528144 , 553591 , 554234 , 555973 , 555995 , 556470 , 557226 , 557941 , 568096 , 596978 , 602716 , 605559 , 615817 , 621887 , 625127 , 649211 , 756735 , 768570 , 783215 , 806247 , 812675 );
Copy
10.58 ms (7.55%)
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
553591
568096
596978
812675
420565
463185
469651
467758
476264
527391
482945
523465
768570
440657
492567
448561
497062
488550
555973
554234
555995
649211
625127
806247
524833
483424
493191
493017
488571
517261
439710
512086
516819
488867
506794
621887
783215
521502
557226
557941
476015
504186
504183
487472
507703
464702
521507
496566
756735
423913
442533
524174
605559
615817
517769
432650
459485
528144
602716
511033
556470
]
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 (553591 , 568096 , 596978 , 812675 , 420565 , 463185 , 469651 , 467758 , 476264 , 527391 , 482945 , 523465 , 768570 , 440657 , 492567 , 448561 , 497062 , 488550 , 555973 , 554234 , 555995 , 649211 , 625127 , 806247 , 524833 , 483424 , 493191 , 493017 , 488571 , 517261 , 439710 , 512086 , 516819 , 488867 , 506794 , 621887 , 783215 , 521502 , 557226 , 557941 , 476015 , 504186 , 504183 , 487472 , 507703 , 464702 , 521507 , 496566 , 756735 , 423913 , 442533 , 524174 , 605559 , 615817 , 517769 , 432650 , 459485 , 528144 , 602716 , 511033 , 556470 );
Copy
2.30 ms (1.64%)
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
420565
423913
432650
439710
440657
442533
448561
459485
463185
464702
467758
469651
476015
476264
482945
483424
487472
488550
488571
488867
492567
493017
493191
496566
497062
504183
504186
506794
507703
511033
512086
516819
517261
517769
521502
521507
523465
524174
524833
527391
528144
553591
554234
555973
555995
556470
557226
557941
568096
596978
602716
605559
615817
621887
625127
649211
756735
768570
783215
806247
812675
]
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 (420565 , 423913 , 432650 , 439710 , 440657 , 442533 , 448561 , 459485 , 463185 , 464702 , 467758 , 469651 , 476015 , 476264 , 482945 , 483424 , 487472 , 488550 , 488571 , 488867 , 492567 , 493017 , 493191 , 496566 , 497062 , 504183 , 504186 , 506794 , 507703 , 511033 , 512086 , 516819 , 517261 , 517769 , 521502 , 521507 , 523465 , 524174 , 524833 , 527391 , 528144 , 553591 , 554234 , 555973 , 555995 , 556470 , 557226 , 557941 , 568096 , 596978 , 602716 , 605559 , 615817 , 621887 , 625127 , 649211 , 756735 , 768570 , 783215 , 806247 , 812675 );
Copy