64.32 ms (57.54%)
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
386767
399868
402012
414609
416931
417221
421673
422587
422646
422832
425206
443796
447572
452170
452975
457884
463840
465894
466987
468089
468534
468860
471434
473925
474714
477079
484434
486061
488600
493160
493822
500571
500581
503269
503934
503958
505420
508243
513603
516025
516684
519628
522089
526005
538473
554833
557259
560153
562825
566688
580185
580646
595421
622938
699610
709524
713146
806860
807873
810032
823479
]
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 (386767 , 399868 , 402012 , 414609 , 416931 , 417221 , 421673 , 422587 , 422646 , 422832 , 425206 , 443796 , 447572 , 452170 , 452975 , 457884 , 463840 , 465894 , 466987 , 468089 , 468534 , 468860 , 471434 , 473925 , 474714 , 477079 , 484434 , 486061 , 488600 , 493160 , 493822 , 500571 , 500581 , 503269 , 503934 , 503958 , 505420 , 508243 , 513603 , 516025 , 516684 , 519628 , 522089 , 526005 , 538473 , 554833 , 557259 , 560153 , 562825 , 566688 , 580185 , 580646 , 595421 , 622938 , 699610 , 709524 , 713146 , 806860 , 807873 , 810032 , 823479 );
Copy
13.57 ms (12.14%)
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
713146
503958
807873
416931
823479
386767
486061
468089
417221
471434
414609
493822
465894
580185
595421
399868
452975
493160
508243
484434
505420
519628
810032
447572
503269
402012
457884
560153
580646
422646
473925
488600
452170
806860
421673
463840
468534
709524
422832
500571
474714
468860
500581
425206
466987
422587
554833
443796
513603
522089
538473
516025
699610
503934
477079
557259
622938
516684
526005
562825
566688
]
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 (713146 , 503958 , 807873 , 416931 , 823479 , 386767 , 486061 , 468089 , 417221 , 471434 , 414609 , 493822 , 465894 , 580185 , 595421 , 399868 , 452975 , 493160 , 508243 , 484434 , 505420 , 519628 , 810032 , 447572 , 503269 , 402012 , 457884 , 560153 , 580646 , 422646 , 473925 , 488600 , 452170 , 806860 , 421673 , 463840 , 468534 , 709524 , 422832 , 500571 , 474714 , 468860 , 500581 , 425206 , 466987 , 422587 , 554833 , 443796 , 513603 , 522089 , 538473 , 516025 , 699610 , 503934 , 477079 , 557259 , 622938 , 516684 , 526005 , 562825 , 566688 );
Copy
2.29 ms (2.05%)
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
386767
399868
402012
414609
416931
417221
421673
422587
422646
422832
425206
443796
447572
452170
452975
457884
463840
465894
466987
468089
468534
468860
471434
473925
474714
477079
484434
486061
488600
493160
493822
500571
500581
503269
503934
503958
505420
508243
513603
516025
516684
519628
522089
526005
538473
554833
557259
560153
562825
566688
580185
580646
595421
622938
699610
709524
713146
806860
807873
810032
823479
]
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 (386767 , 399868 , 402012 , 414609 , 416931 , 417221 , 421673 , 422587 , 422646 , 422832 , 425206 , 443796 , 447572 , 452170 , 452975 , 457884 , 463840 , 465894 , 466987 , 468089 , 468534 , 468860 , 471434 , 473925 , 474714 , 477079 , 484434 , 486061 , 488600 , 493160 , 493822 , 500571 , 500581 , 503269 , 503934 , 503958 , 505420 , 508243 , 513603 , 516025 , 516684 , 519628 , 522089 , 526005 , 538473 , 554833 , 557259 , 560153 , 562825 , 566688 , 580185 , 580646 , 595421 , 622938 , 699610 , 709524 , 713146 , 806860 , 807873 , 810032 , 823479 );
Copy