85.27 ms (78.41%)
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
425552
431749
444316
445988
450495
457435
461854
464721
467598
484295
484618
488240
488359
489612
490864
498355
499159
500525
505433
508429
508474
514676
522831
524848
534568
546478
567623
578445
581532
588991
605455
614768
616760
618982
622454
623468
623472
623972
627638
642227
644015
660013
671487
678893
678896
696223
697000
711355
713305
715020
717606
724711
742791
749979
758408
778888
780373
781063
787455
794083
812169
825710
]
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 (425552 , 431749 , 444316 , 445988 , 450495 , 457435 , 461854 , 464721 , 467598 , 484295 , 484618 , 488240 , 488359 , 489612 , 490864 , 498355 , 499159 , 500525 , 505433 , 508429 , 508474 , 514676 , 522831 , 524848 , 534568 , 546478 , 567623 , 578445 , 581532 , 588991 , 605455 , 614768 , 616760 , 618982 , 622454 , 623468 , 623472 , 623972 , 627638 , 642227 , 644015 , 660013 , 671487 , 678893 , 678896 , 696223 , 697000 , 711355 , 713305 , 715020 , 717606 , 724711 , 742791 , 749979 , 758408 , 778888 , 780373 , 781063 , 787455 , 794083 , 812169 , 825710 );
Copy
10.66 ms (9.80%)
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
467598
488240
450495
514676
534568
567623
614768
464721
445988
616760
717606
488359
508429
623472
490864
444316
578445
499159
780373
546478
715020
711355
742791
825710
696223
431749
588991
644015
724711
781063
671487
794083
787455
623468
524848
713305
484295
498355
678896
623972
489612
522831
461854
581532
618982
508474
622454
642227
778888
697000
812169
749979
758408
425552
505433
500525
678893
605455
660013
457435
484618
627638
]
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 (467598 , 488240 , 450495 , 514676 , 534568 , 567623 , 614768 , 464721 , 445988 , 616760 , 717606 , 488359 , 508429 , 623472 , 490864 , 444316 , 578445 , 499159 , 780373 , 546478 , 715020 , 711355 , 742791 , 825710 , 696223 , 431749 , 588991 , 644015 , 724711 , 781063 , 671487 , 794083 , 787455 , 623468 , 524848 , 713305 , 484295 , 498355 , 678896 , 623972 , 489612 , 522831 , 461854 , 581532 , 618982 , 508474 , 622454 , 642227 , 778888 , 697000 , 812169 , 749979 , 758408 , 425552 , 505433 , 500525 , 678893 , 605455 , 660013 , 457435 , 484618 , 627638 );
Copy
1.96 ms (1.80%)
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
425552
431749
444316
445988
450495
457435
461854
464721
467598
484295
484618
488240
488359
489612
490864
498355
499159
500525
505433
508429
508474
514676
522831
524848
534568
546478
567623
578445
581532
588991
605455
614768
616760
618982
622454
623468
623472
623972
627638
642227
644015
660013
671487
678893
678896
696223
697000
711355
713305
715020
717606
724711
742791
749979
758408
778888
780373
781063
787455
794083
812169
825710
]
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 (425552 , 431749 , 444316 , 445988 , 450495 , 457435 , 461854 , 464721 , 467598 , 484295 , 484618 , 488240 , 488359 , 489612 , 490864 , 498355 , 499159 , 500525 , 505433 , 508429 , 508474 , 514676 , 522831 , 524848 , 534568 , 546478 , 567623 , 578445 , 581532 , 588991 , 605455 , 614768 , 616760 , 618982 , 622454 , 623468 , 623472 , 623972 , 627638 , 642227 , 644015 , 660013 , 671487 , 678893 , 678896 , 696223 , 697000 , 711355 , 713305 , 715020 , 717606 , 724711 , 742791 , 749979 , 758408 , 778888 , 780373 , 781063 , 787455 , 794083 , 812169 , 825710 );
Copy