144.02 ms (62.14%)
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
430623
430629
432869
442318
442726
442768
442822
442829
445436
446629
446713
447157
454865
459919
464960
476903
480553
489185
492320
492331
493192
506048
516408
516794
518957
520881
522398
526762
529171
529406
531439
531489
531500
531506
532012
532095
532096
532097
539761
539764
540769
542735
549754
554784
555997
559173
562028
562030
563006
563079
564244
564246
571823
579292
581221
582062
582372
589592
594016
683831
]
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 (430623 , 430629 , 432869 , 442318 , 442726 , 442768 , 442822 , 442829 , 445436 , 446629 , 446713 , 447157 , 454865 , 459919 , 464960 , 476903 , 480553 , 489185 , 492320 , 492331 , 493192 , 506048 , 516408 , 516794 , 518957 , 520881 , 522398 , 526762 , 529171 , 529406 , 531439 , 531489 , 531500 , 531506 , 532012 , 532095 , 532096 , 532097 , 539761 , 539764 , 540769 , 542735 , 549754 , 554784 , 555997 , 559173 , 562028 , 562030 , 563006 , 563079 , 564244 , 564246 , 571823 , 579292 , 581221 , 582062 , 582372 , 589592 , 594016 , 683831 );
Copy
10.68 ms (4.61%)
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
529171
430629
531489
582372
555997
446713
480553
489185
532096
459919
532012
526762
529406
564246
442822
540769
562028
581221
454865
442768
432869
447157
464960
492331
563079
516794
446629
582062
589592
476903
522398
579292
539764
532095
539761
559173
516408
532097
531500
542735
562030
571823
594016
442726
683831
506048
549754
563006
564244
518957
531439
442318
430623
493192
442829
531506
445436
554784
520881
492320
]
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 (529171 , 430629 , 531489 , 582372 , 555997 , 446713 , 480553 , 489185 , 532096 , 459919 , 532012 , 526762 , 529406 , 564246 , 442822 , 540769 , 562028 , 581221 , 454865 , 442768 , 432869 , 447157 , 464960 , 492331 , 563079 , 516794 , 446629 , 582062 , 589592 , 476903 , 522398 , 579292 , 539764 , 532095 , 539761 , 559173 , 516408 , 532097 , 531500 , 542735 , 562030 , 571823 , 594016 , 442726 , 683831 , 506048 , 549754 , 563006 , 564244 , 518957 , 531439 , 442318 , 430623 , 493192 , 442829 , 531506 , 445436 , 554784 , 520881 , 492320 );
Copy
2.39 ms (1.03%)
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
430623
430629
432869
442318
442726
442768
442822
442829
445436
446629
446713
447157
454865
459919
464960
476903
480553
489185
492320
492331
493192
506048
516408
516794
518957
520881
522398
526762
529171
529406
531439
531489
531500
531506
532012
532095
532096
532097
539761
539764
540769
542735
549754
554784
555997
559173
562028
562030
563006
563079
564244
564246
571823
579292
581221
582062
582372
589592
594016
683831
]
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 (430623 , 430629 , 432869 , 442318 , 442726 , 442768 , 442822 , 442829 , 445436 , 446629 , 446713 , 447157 , 454865 , 459919 , 464960 , 476903 , 480553 , 489185 , 492320 , 492331 , 493192 , 506048 , 516408 , 516794 , 518957 , 520881 , 522398 , 526762 , 529171 , 529406 , 531439 , 531489 , 531500 , 531506 , 532012 , 532095 , 532096 , 532097 , 539761 , 539764 , 540769 , 542735 , 549754 , 554784 , 555997 , 559173 , 562028 , 562030 , 563006 , 563079 , 564244 , 564246 , 571823 , 579292 , 581221 , 582062 , 582372 , 589592 , 594016 , 683831 );
Copy