68.35 ms (30.96%)
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
398389
409143
420344
426369
427254
444815
452526
454774
464621
469066
487344
491569
513761
556027
556830
568055
580335
591357
591620
603178
607093
626337
659408
699516
718991
721116
721937
738274
742143
747335
748982
751722
758201
761475
775919
776054
787500
787511
792624
800876
804619
811077
811654
]
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 (398389 , 409143 , 420344 , 426369 , 427254 , 444815 , 452526 , 454774 , 464621 , 469066 , 487344 , 491569 , 513761 , 556027 , 556830 , 568055 , 580335 , 591357 , 591620 , 603178 , 607093 , 626337 , 659408 , 699516 , 718991 , 721116 , 721937 , 738274 , 742143 , 747335 , 748982 , 751722 , 758201 , 761475 , 775919 , 776054 , 787500 , 787511 , 792624 , 800876 , 804619 , 811077 , 811654 );
Copy
8.08 ms (3.66%)
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
811077
748982
721937
603178
556830
738274
747335
469066
659408
591620
556027
811654
775919
758201
718991
721116
751722
699516
591357
761475
776054
800876
804619
742143
792624
513761
626337
491569
787511
452526
398389
464621
607093
409143
427254
787500
454774
444815
420344
580335
426369
568055
487344
]
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 (811077 , 748982 , 721937 , 603178 , 556830 , 738274 , 747335 , 469066 , 659408 , 591620 , 556027 , 811654 , 775919 , 758201 , 718991 , 721116 , 751722 , 699516 , 591357 , 761475 , 776054 , 800876 , 804619 , 742143 , 792624 , 513761 , 626337 , 491569 , 787511 , 452526 , 398389 , 464621 , 607093 , 409143 , 427254 , 787500 , 454774 , 444815 , 420344 , 580335 , 426369 , 568055 , 487344 );
Copy
3.06 ms (1.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
398389
409143
420344
426369
427254
444815
452526
454774
464621
469066
487344
491569
513761
556027
556830
568055
580335
591357
591620
603178
607093
626337
659408
699516
718991
721116
721937
738274
742143
747335
748982
751722
758201
761475
775919
776054
787500
787511
792624
800876
804619
811077
811654
]
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 (398389 , 409143 , 420344 , 426369 , 427254 , 444815 , 452526 , 454774 , 464621 , 469066 , 487344 , 491569 , 513761 , 556027 , 556830 , 568055 , 580335 , 591357 , 591620 , 603178 , 607093 , 626337 , 659408 , 699516 , 718991 , 721116 , 721937 , 738274 , 742143 , 747335 , 748982 , 751722 , 758201 , 761475 , 775919 , 776054 , 787500 , 787511 , 792624 , 800876 , 804619 , 811077 , 811654 );
Copy