91.62 ms (67.20%)
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
398615
413058
422074
423474
423478
423480
423484
423487
423491
423493
423494
423495
423497
423505
432778
448636
448656
452633
452774
452931
452982
459633
466392
468687
499867
500884
508940
509063
523134
531557
543282
549720
565341
576985
583388
590839
593562
635398
640388
680440
690885
710100
725136
740871
740886
742797
759885
761048
761053
761583
773404
773411
773482
788525
791803
795300
796164
797472
800394
801264
803726
]
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 (398615 , 413058 , 422074 , 423474 , 423478 , 423480 , 423484 , 423487 , 423491 , 423493 , 423494 , 423495 , 423497 , 423505 , 432778 , 448636 , 448656 , 452633 , 452774 , 452931 , 452982 , 459633 , 466392 , 468687 , 499867 , 500884 , 508940 , 509063 , 523134 , 531557 , 543282 , 549720 , 565341 , 576985 , 583388 , 590839 , 593562 , 635398 , 640388 , 680440 , 690885 , 710100 , 725136 , 740871 , 740886 , 742797 , 759885 , 761048 , 761053 , 761583 , 773404 , 773411 , 773482 , 788525 , 791803 , 795300 , 796164 , 797472 , 800394 , 801264 , 803726 );
Copy
8.89 ms (6.52%)
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
423478
423497
423494
549720
725136
791803
448656
543282
797472
740886
742797
761053
459633
576985
800394
508940
710100
593562
773411
398615
452982
423474
531557
690885
795300
740871
423493
803726
773482
448636
801264
796164
423487
509063
452931
680440
773404
468687
583388
635398
761048
759885
423505
432778
500884
761583
422074
423491
452774
640388
423484
423495
413058
452633
590839
423480
466392
565341
788525
523134
499867
]
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 (423478 , 423497 , 423494 , 549720 , 725136 , 791803 , 448656 , 543282 , 797472 , 740886 , 742797 , 761053 , 459633 , 576985 , 800394 , 508940 , 710100 , 593562 , 773411 , 398615 , 452982 , 423474 , 531557 , 690885 , 795300 , 740871 , 423493 , 803726 , 773482 , 448636 , 801264 , 796164 , 423487 , 509063 , 452931 , 680440 , 773404 , 468687 , 583388 , 635398 , 761048 , 759885 , 423505 , 432778 , 500884 , 761583 , 422074 , 423491 , 452774 , 640388 , 423484 , 423495 , 413058 , 452633 , 590839 , 423480 , 466392 , 565341 , 788525 , 523134 , 499867 );
Copy
3.25 ms (2.38%)
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
398615
413058
422074
423474
423478
423480
423484
423487
423491
423493
423494
423495
423497
423505
432778
448636
448656
452633
452774
452931
452982
459633
466392
468687
499867
500884
508940
509063
523134
531557
543282
549720
565341
576985
583388
590839
593562
635398
640388
680440
690885
710100
725136
740871
740886
742797
759885
761048
761053
761583
773404
773411
773482
788525
791803
795300
796164
797472
800394
801264
803726
]
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 (398615 , 413058 , 422074 , 423474 , 423478 , 423480 , 423484 , 423487 , 423491 , 423493 , 423494 , 423495 , 423497 , 423505 , 432778 , 448636 , 448656 , 452633 , 452774 , 452931 , 452982 , 459633 , 466392 , 468687 , 499867 , 500884 , 508940 , 509063 , 523134 , 531557 , 543282 , 549720 , 565341 , 576985 , 583388 , 590839 , 593562 , 635398 , 640388 , 680440 , 690885 , 710100 , 725136 , 740871 , 740886 , 742797 , 759885 , 761048 , 761053 , 761583 , 773404 , 773411 , 773482 , 788525 , 791803 , 795300 , 796164 , 797472 , 800394 , 801264 , 803726 );
Copy