67.03 ms (52.05%)
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
88220
150785
398057
415776
415926
416656
419167
419832
426550
429699
433002
448898
453493
454767
469092
469194
476049
482890
483658
483777
491103
507291
509552
509996
510783
513572
515444
516028
518614
519482
526167
527371
546315
562346
562460
572238
577970
579726
588467
589133
590550
590664
596389
597148
601691
613515
619286
619308
619322
621259
625404
641808
739809
749577
774874
777007
782847
790414
804939
806861
]
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 (88220 , 150785 , 398057 , 415776 , 415926 , 416656 , 419167 , 419832 , 426550 , 429699 , 433002 , 448898 , 453493 , 454767 , 469092 , 469194 , 476049 , 482890 , 483658 , 483777 , 491103 , 507291 , 509552 , 509996 , 510783 , 513572 , 515444 , 516028 , 518614 , 519482 , 526167 , 527371 , 546315 , 562346 , 562460 , 572238 , 577970 , 579726 , 588467 , 589133 , 590550 , 590664 , 596389 , 597148 , 601691 , 613515 , 619286 , 619308 , 619322 , 621259 , 625404 , 641808 , 739809 , 749577 , 774874 , 777007 , 782847 , 790414 , 804939 , 806861 );
Copy
12.21 ms (9.49%)
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
596389
150785
454767
804939
619322
419167
790414
398057
491103
448898
483658
509996
588467
426550
619286
601691
641808
749577
469194
590550
526167
782847
516028
546315
483777
419832
739809
518614
589133
476049
806861
572238
562460
777007
774874
88220
482890
416656
579726
429699
510783
415776
527371
507291
433002
613515
621259
519482
562346
509552
590664
513572
453493
625404
415926
469092
577970
619308
597148
515444
]
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 (596389 , 150785 , 454767 , 804939 , 619322 , 419167 , 790414 , 398057 , 491103 , 448898 , 483658 , 509996 , 588467 , 426550 , 619286 , 601691 , 641808 , 749577 , 469194 , 590550 , 526167 , 782847 , 516028 , 546315 , 483777 , 419832 , 739809 , 518614 , 589133 , 476049 , 806861 , 572238 , 562460 , 777007 , 774874 , 88220 , 482890 , 416656 , 579726 , 429699 , 510783 , 415776 , 527371 , 507291 , 433002 , 613515 , 621259 , 519482 , 562346 , 509552 , 590664 , 513572 , 453493 , 625404 , 415926 , 469092 , 577970 , 619308 , 597148 , 515444 );
Copy
2.64 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
88220
150785
398057
415776
415926
416656
419167
419832
426550
429699
433002
448898
453493
454767
469092
469194
476049
482890
483658
483777
491103
507291
509552
509996
510783
513572
515444
516028
518614
519482
526167
527371
546315
562346
562460
572238
577970
579726
588467
589133
590550
590664
596389
597148
601691
613515
619286
619308
619322
621259
625404
641808
739809
749577
774874
777007
782847
790414
804939
806861
]
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 (88220 , 150785 , 398057 , 415776 , 415926 , 416656 , 419167 , 419832 , 426550 , 429699 , 433002 , 448898 , 453493 , 454767 , 469092 , 469194 , 476049 , 482890 , 483658 , 483777 , 491103 , 507291 , 509552 , 509996 , 510783 , 513572 , 515444 , 516028 , 518614 , 519482 , 526167 , 527371 , 546315 , 562346 , 562460 , 572238 , 577970 , 579726 , 588467 , 589133 , 590550 , 590664 , 596389 , 597148 , 601691 , 613515 , 619286 , 619308 , 619322 , 621259 , 625404 , 641808 , 739809 , 749577 , 774874 , 777007 , 782847 , 790414 , 804939 , 806861 );
Copy