88.70 ms (68.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
399700
404777
416439
421448
437585
442363
446659
450514
450608
451171
453688
453721
455496
457149
457630
458333
458394
461100
462322
483327
489179
494614
497447
505575
507047
508486
519460
521503
523026
523767
525513
525802
529143
541215
542791
550985
562500
565866
569026
571690
573751
582220
582373
582376
582417
582693
582728
584754
587854
588057
591997
599359
601181
606649
610339
610375
635185
696890
763136
781178
796118
796804
]
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 (399700 , 404777 , 416439 , 421448 , 437585 , 442363 , 446659 , 450514 , 450608 , 451171 , 453688 , 453721 , 455496 , 457149 , 457630 , 458333 , 458394 , 461100 , 462322 , 483327 , 489179 , 494614 , 497447 , 505575 , 507047 , 508486 , 519460 , 521503 , 523026 , 523767 , 525513 , 525802 , 529143 , 541215 , 542791 , 550985 , 562500 , 565866 , 569026 , 571690 , 573751 , 582220 , 582373 , 582376 , 582417 , 582693 , 582728 , 584754 , 587854 , 588057 , 591997 , 599359 , 601181 , 606649 , 610339 , 610375 , 635185 , 696890 , 763136 , 781178 , 796118 , 796804 );
Copy
11.88 ms (9.16%)
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
562500
571690
696890
582728
610375
610339
606649
781178
796118
525513
494614
489179
796804
416439
483327
437585
635185
450608
582417
565866
421448
455496
505575
508486
587854
550985
461100
542791
582373
453688
450514
519460
404777
525802
451171
462322
457630
458394
458333
582693
573751
591997
507047
601181
569026
763136
529143
521503
588057
453721
497447
541215
582376
582220
399700
457149
523026
584754
442363
599359
523767
446659
]
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 (562500 , 571690 , 696890 , 582728 , 610375 , 610339 , 606649 , 781178 , 796118 , 525513 , 494614 , 489179 , 796804 , 416439 , 483327 , 437585 , 635185 , 450608 , 582417 , 565866 , 421448 , 455496 , 505575 , 508486 , 587854 , 550985 , 461100 , 542791 , 582373 , 453688 , 450514 , 519460 , 404777 , 525802 , 451171 , 462322 , 457630 , 458394 , 458333 , 582693 , 573751 , 591997 , 507047 , 601181 , 569026 , 763136 , 529143 , 521503 , 588057 , 453721 , 497447 , 541215 , 582376 , 582220 , 399700 , 457149 , 523026 , 584754 , 442363 , 599359 , 523767 , 446659 );
Copy
3.10 ms (2.39%)
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
399700
404777
416439
421448
437585
442363
446659
450514
450608
451171
453688
453721
455496
457149
457630
458333
458394
461100
462322
483327
489179
494614
497447
505575
507047
508486
519460
521503
523026
523767
525513
525802
529143
541215
542791
550985
562500
565866
569026
571690
573751
582220
582373
582376
582417
582693
582728
584754
587854
588057
591997
599359
601181
606649
610339
610375
635185
696890
763136
781178
796118
796804
]
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 (399700 , 404777 , 416439 , 421448 , 437585 , 442363 , 446659 , 450514 , 450608 , 451171 , 453688 , 453721 , 455496 , 457149 , 457630 , 458333 , 458394 , 461100 , 462322 , 483327 , 489179 , 494614 , 497447 , 505575 , 507047 , 508486 , 519460 , 521503 , 523026 , 523767 , 525513 , 525802 , 529143 , 541215 , 542791 , 550985 , 562500 , 565866 , 569026 , 571690 , 573751 , 582220 , 582373 , 582376 , 582417 , 582693 , 582728 , 584754 , 587854 , 588057 , 591997 , 599359 , 601181 , 606649 , 610339 , 610375 , 635185 , 696890 , 763136 , 781178 , 796118 , 796804 );
Copy