72.57 ms (65.42%)
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
418018
418068
423829
423848
434792
438729
440650
449171
450508
453525
465411
472559
472593
472645
478268
478993
487410
489257
489258
492162
492926
499395
519160
519209
522764
524199
534801
534829
539331
543342
551669
553637
558180
569071
571826
571833
579321
588276
589290
601101
606575
606633
609795
615014
616401
624172
627743
648599
650374
650935
709758
717136
729223
743708
749374
749909
756622
761167
792558
794612
796707
800611
813987
819706
]
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 (418018 , 418068 , 423829 , 423848 , 434792 , 438729 , 440650 , 449171 , 450508 , 453525 , 465411 , 472559 , 472593 , 472645 , 478268 , 478993 , 487410 , 489257 , 489258 , 492162 , 492926 , 499395 , 519160 , 519209 , 522764 , 524199 , 534801 , 534829 , 539331 , 543342 , 551669 , 553637 , 558180 , 569071 , 571826 , 571833 , 579321 , 588276 , 589290 , 601101 , 606575 , 606633 , 609795 , 615014 , 616401 , 624172 , 627743 , 648599 , 650374 , 650935 , 709758 , 717136 , 729223 , 743708 , 749374 , 749909 , 756622 , 761167 , 792558 , 794612 , 796707 , 800611 , 813987 , 819706 );
Copy
11.81 ms (10.65%)
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
478268
588276
438729
648599
650374
650935
606575
800611
487410
478993
579321
423848
499395
813987
709758
615014
794612
796707
465411
534801
522764
534829
717136
624172
606633
627743
761167
749374
749909
472645
571833
434792
492926
743708
819706
571826
553637
569071
756622
449171
453525
492162
551669
543342
423829
489257
418068
440650
539331
519209
472593
489258
418018
616401
792558
472559
558180
519160
589290
729223
609795
524199
601101
450508
]
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 (478268 , 588276 , 438729 , 648599 , 650374 , 650935 , 606575 , 800611 , 487410 , 478993 , 579321 , 423848 , 499395 , 813987 , 709758 , 615014 , 794612 , 796707 , 465411 , 534801 , 522764 , 534829 , 717136 , 624172 , 606633 , 627743 , 761167 , 749374 , 749909 , 472645 , 571833 , 434792 , 492926 , 743708 , 819706 , 571826 , 553637 , 569071 , 756622 , 449171 , 453525 , 492162 , 551669 , 543342 , 423829 , 489257 , 418068 , 440650 , 539331 , 519209 , 472593 , 489258 , 418018 , 616401 , 792558 , 472559 , 558180 , 519160 , 589290 , 729223 , 609795 , 524199 , 601101 , 450508 );
Copy
2.84 ms (2.56%)
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
418018
418068
423829
423848
434792
438729
440650
449171
450508
453525
465411
472559
472593
472645
478268
478993
487410
489257
489258
492162
492926
499395
519160
519209
522764
524199
534801
534829
539331
543342
551669
553637
558180
569071
571826
571833
579321
588276
589290
601101
606575
606633
609795
615014
616401
624172
627743
648599
650374
650935
709758
717136
729223
743708
749374
749909
756622
761167
792558
794612
796707
800611
813987
819706
]
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 (418018 , 418068 , 423829 , 423848 , 434792 , 438729 , 440650 , 449171 , 450508 , 453525 , 465411 , 472559 , 472593 , 472645 , 478268 , 478993 , 487410 , 489257 , 489258 , 492162 , 492926 , 499395 , 519160 , 519209 , 522764 , 524199 , 534801 , 534829 , 539331 , 543342 , 551669 , 553637 , 558180 , 569071 , 571826 , 571833 , 579321 , 588276 , 589290 , 601101 , 606575 , 606633 , 609795 , 615014 , 616401 , 624172 , 627743 , 648599 , 650374 , 650935 , 709758 , 717136 , 729223 , 743708 , 749374 , 749909 , 756622 , 761167 , 792558 , 794612 , 796707 , 800611 , 813987 , 819706 );
Copy