95.85 ms (67.50%)
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
464702
467758
469651
476015
479931
480888
481461
482945
483424
486820
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
554234
555973
555995
556470
557226
557941
596978
602716
605559
615817
621887
625127
649211
713630
756735
783215
806247
]
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 , 464702 , 467758 , 469651 , 476015 , 479931 , 480888 , 481461 , 482945 , 483424 , 486820 , 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 , 554234 , 555973 , 555995 , 556470 , 557226 , 557941 , 596978 , 602716 , 605559 , 615817 , 621887 , 625127 , 649211 , 713630 , 756735 , 783215 , 806247 );
Copy
9.60 ms (6.76%)
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
527391
523465
480888
479931
596978
420565
469651
467758
482945
497062
625127
806247
440657
448561
488550
554234
555995
649211
524833
483424
713630
492567
555973
493191
493017
621887
488571
517261
512086
516819
488867
506794
439710
783215
521502
557226
557941
487472
476015
504186
504183
521507
423913
756735
442533
464702
496566
486820
524174
481461
605559
507703
615817
517769
459485
432650
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 (527391 , 523465 , 480888 , 479931 , 596978 , 420565 , 469651 , 467758 , 482945 , 497062 , 625127 , 806247 , 440657 , 448561 , 488550 , 554234 , 555995 , 649211 , 524833 , 483424 , 713630 , 492567 , 555973 , 493191 , 493017 , 621887 , 488571 , 517261 , 512086 , 516819 , 488867 , 506794 , 439710 , 783215 , 521502 , 557226 , 557941 , 487472 , 476015 , 504186 , 504183 , 521507 , 423913 , 756735 , 442533 , 464702 , 496566 , 486820 , 524174 , 481461 , 605559 , 507703 , 615817 , 517769 , 459485 , 432650 , 528144 , 602716 , 511033 , 556470 );
Copy
2.40 ms (1.69%)
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
464702
467758
469651
476015
479931
480888
481461
482945
483424
486820
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
554234
555973
555995
556470
557226
557941
596978
602716
605559
615817
621887
625127
649211
713630
756735
783215
806247
]
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 , 464702 , 467758 , 469651 , 476015 , 479931 , 480888 , 481461 , 482945 , 483424 , 486820 , 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 , 554234 , 555973 , 555995 , 556470 , 557226 , 557941 , 596978 , 602716 , 605559 , 615817 , 621887 , 625127 , 649211 , 713630 , 756735 , 783215 , 806247 );
Copy