79.67 ms (65.78%)
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
396664
405531
406171
411946
418934
419371
424648
427759
431133
431335
434045
439927
443716
445416
445608
454709
464719
472956
474561
476409
476797
484667
484670
484681
506269
507094
512059
518766
523924
531231
534288
534645
535622
536691
537199
540334
540339
542192
546200
546766
554498
563449
578472
600054
607374
628294
628315
643411
702163
702168
706984
714511
719104
720927
726487
748242
748255
748258
802109
816986
825001
]
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 (396664 , 405531 , 406171 , 411946 , 418934 , 419371 , 424648 , 427759 , 431133 , 431335 , 434045 , 439927 , 443716 , 445416 , 445608 , 454709 , 464719 , 472956 , 474561 , 476409 , 476797 , 484667 , 484670 , 484681 , 506269 , 507094 , 512059 , 518766 , 523924 , 531231 , 534288 , 534645 , 535622 , 536691 , 537199 , 540334 , 540339 , 542192 , 546200 , 546766 , 554498 , 563449 , 578472 , 600054 , 607374 , 628294 , 628315 , 643411 , 702163 , 702168 , 706984 , 714511 , 719104 , 720927 , 726487 , 748242 , 748255 , 748258 , 802109 , 816986 , 825001 );
Copy
11.43 ms (9.44%)
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
748255
464719
424648
406171
439927
643411
445608
431335
484681
445416
535622
719104
748242
427759
706984
628315
825001
816986
720927
628294
802109
411946
484670
540334
507094
454709
546766
714511
434045
748258
443716
472956
476409
537199
702168
546200
563449
600054
431133
518766
484667
536691
506269
702163
396664
726487
419371
474561
540339
534288
531231
542192
607374
578472
418934
476797
554498
523924
534645
512059
405531
]
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 (748255 , 464719 , 424648 , 406171 , 439927 , 643411 , 445608 , 431335 , 484681 , 445416 , 535622 , 719104 , 748242 , 427759 , 706984 , 628315 , 825001 , 816986 , 720927 , 628294 , 802109 , 411946 , 484670 , 540334 , 507094 , 454709 , 546766 , 714511 , 434045 , 748258 , 443716 , 472956 , 476409 , 537199 , 702168 , 546200 , 563449 , 600054 , 431133 , 518766 , 484667 , 536691 , 506269 , 702163 , 396664 , 726487 , 419371 , 474561 , 540339 , 534288 , 531231 , 542192 , 607374 , 578472 , 418934 , 476797 , 554498 , 523924 , 534645 , 512059 , 405531 );
Copy
2.36 ms (1.95%)
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
396664
405531
406171
411946
418934
419371
424648
427759
431133
431335
434045
439927
443716
445416
445608
454709
464719
472956
474561
476409
476797
484667
484670
484681
506269
507094
512059
518766
523924
531231
534288
534645
535622
536691
537199
540334
540339
542192
546200
546766
554498
563449
578472
600054
607374
628294
628315
643411
702163
702168
706984
714511
719104
720927
726487
748242
748255
748258
802109
816986
825001
]
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 (396664 , 405531 , 406171 , 411946 , 418934 , 419371 , 424648 , 427759 , 431133 , 431335 , 434045 , 439927 , 443716 , 445416 , 445608 , 454709 , 464719 , 472956 , 474561 , 476409 , 476797 , 484667 , 484670 , 484681 , 506269 , 507094 , 512059 , 518766 , 523924 , 531231 , 534288 , 534645 , 535622 , 536691 , 537199 , 540334 , 540339 , 542192 , 546200 , 546766 , 554498 , 563449 , 578472 , 600054 , 607374 , 628294 , 628315 , 643411 , 702163 , 702168 , 706984 , 714511 , 719104 , 720927 , 726487 , 748242 , 748255 , 748258 , 802109 , 816986 , 825001 );
Copy