70.23 ms (58.91%)
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
420700
420804
429155
430366
435398
439151
439301
444204
446986
448572
451695
456397
459334
459339
473738
473838
478514
480207
483478
483737
485297
488797
489067
495163
495550
497690
502630
510573
514986
527832
532370
532442
533917
537319
538354
541409
542706
567334
576951
583027
585826
595572
595646
595871
598504
598616
600242
602268
606076
616013
616315
675378
687318
701292
712433
740407
750426
750637
770382
789002
791385
]
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 (420700 , 420804 , 429155 , 430366 , 435398 , 439151 , 439301 , 444204 , 446986 , 448572 , 451695 , 456397 , 459334 , 459339 , 473738 , 473838 , 478514 , 480207 , 483478 , 483737 , 485297 , 488797 , 489067 , 495163 , 495550 , 497690 , 502630 , 510573 , 514986 , 527832 , 532370 , 532442 , 533917 , 537319 , 538354 , 541409 , 542706 , 567334 , 576951 , 583027 , 585826 , 595572 , 595646 , 595871 , 598504 , 598616 , 600242 , 602268 , 606076 , 616013 , 616315 , 675378 , 687318 , 701292 , 712433 , 740407 , 750426 , 750637 , 770382 , 789002 , 791385 );
Copy
11.38 ms (9.54%)
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
675378
712433
701292
687318
598504
598616
750637
750426
740407
791385
448572
451695
420700
444204
456397
459334
502630
489067
495550
514986
483478
527832
497690
430366
429155
595572
473838
537319
532442
542706
583027
595646
600242
420804
446986
488797
616013
459339
538354
510573
473738
541409
567334
606076
485297
478514
483737
533917
532370
616315
789002
435398
439151
480207
770382
439301
495163
576951
585826
602268
595871
]
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 (675378 , 712433 , 701292 , 687318 , 598504 , 598616 , 750637 , 750426 , 740407 , 791385 , 448572 , 451695 , 420700 , 444204 , 456397 , 459334 , 502630 , 489067 , 495550 , 514986 , 483478 , 527832 , 497690 , 430366 , 429155 , 595572 , 473838 , 537319 , 532442 , 542706 , 583027 , 595646 , 600242 , 420804 , 446986 , 488797 , 616013 , 459339 , 538354 , 510573 , 473738 , 541409 , 567334 , 606076 , 485297 , 478514 , 483737 , 533917 , 532370 , 616315 , 789002 , 435398 , 439151 , 480207 , 770382 , 439301 , 495163 , 576951 , 585826 , 602268 , 595871 );
Copy
2.78 ms (2.33%)
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
420700
420804
429155
430366
435398
439151
439301
444204
446986
448572
451695
456397
459334
459339
473738
473838
478514
480207
483478
483737
485297
488797
489067
495163
495550
497690
502630
510573
514986
527832
532370
532442
533917
537319
538354
541409
542706
567334
576951
583027
585826
595572
595646
595871
598504
598616
600242
602268
606076
616013
616315
675378
687318
701292
712433
740407
750426
750637
770382
789002
791385
]
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 (420700 , 420804 , 429155 , 430366 , 435398 , 439151 , 439301 , 444204 , 446986 , 448572 , 451695 , 456397 , 459334 , 459339 , 473738 , 473838 , 478514 , 480207 , 483478 , 483737 , 485297 , 488797 , 489067 , 495163 , 495550 , 497690 , 502630 , 510573 , 514986 , 527832 , 532370 , 532442 , 533917 , 537319 , 538354 , 541409 , 542706 , 567334 , 576951 , 583027 , 585826 , 595572 , 595646 , 595871 , 598504 , 598616 , 600242 , 602268 , 606076 , 616013 , 616315 , 675378 , 687318 , 701292 , 712433 , 740407 , 750426 , 750637 , 770382 , 789002 , 791385 );
Copy