92.96 ms (63.60%)
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
407800
411790
414369
420891
428029
444720
450239
454129
458694
458905
459907
462316
484398
484748
486870
487174
495710
495741
495744
496934
501500
504161
506796
509033
519171
520354
523335
524141
528149
529271
533209
534968
537001
543422
543605
547814
557937
566422
573394
578610
583371
590505
590881
590906
595799
596405
609953
610661
615774
622832
640029
644070
644748
645196
649240
654624
687163
708134
714840
724425
726487
726543
]
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 (407800 , 411790 , 414369 , 420891 , 428029 , 444720 , 450239 , 454129 , 458694 , 458905 , 459907 , 462316 , 484398 , 484748 , 486870 , 487174 , 495710 , 495741 , 495744 , 496934 , 501500 , 504161 , 506796 , 509033 , 519171 , 520354 , 523335 , 524141 , 528149 , 529271 , 533209 , 534968 , 537001 , 543422 , 543605 , 547814 , 557937 , 566422 , 573394 , 578610 , 583371 , 590505 , 590881 , 590906 , 595799 , 596405 , 609953 , 610661 , 615774 , 622832 , 640029 , 644070 , 644748 , 645196 , 649240 , 654624 , 687163 , 708134 , 714840 , 724425 , 726487 , 726543 );
Copy
10.43 ms (7.13%)
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
454129
654624
708134
462316
407800
414369
450239
459907
537001
596405
615774
644070
724425
444720
428029
543605
458694
543422
547814
458905
504161
640029
610661
411790
533209
566422
649240
590505
590906
590881
644748
726543
484398
495710
496934
557937
578610
645196
714840
487174
509033
420891
534968
573394
726487
501500
506796
528149
495744
583371
595799
519171
484748
495741
529271
524141
523335
609953
687163
622832
520354
486870
]
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 (454129 , 654624 , 708134 , 462316 , 407800 , 414369 , 450239 , 459907 , 537001 , 596405 , 615774 , 644070 , 724425 , 444720 , 428029 , 543605 , 458694 , 543422 , 547814 , 458905 , 504161 , 640029 , 610661 , 411790 , 533209 , 566422 , 649240 , 590505 , 590906 , 590881 , 644748 , 726543 , 484398 , 495710 , 496934 , 557937 , 578610 , 645196 , 714840 , 487174 , 509033 , 420891 , 534968 , 573394 , 726487 , 501500 , 506796 , 528149 , 495744 , 583371 , 595799 , 519171 , 484748 , 495741 , 529271 , 524141 , 523335 , 609953 , 687163 , 622832 , 520354 , 486870 );
Copy
3.18 ms (2.18%)
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
407800
411790
414369
420891
428029
444720
450239
454129
458694
458905
459907
462316
484398
484748
486870
487174
495710
495741
495744
496934
501500
504161
506796
509033
519171
520354
523335
524141
528149
529271
533209
534968
537001
543422
543605
547814
557937
566422
573394
578610
583371
590505
590881
590906
595799
596405
609953
610661
615774
622832
640029
644070
644748
645196
649240
654624
687163
708134
714840
724425
726487
726543
]
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 (407800 , 411790 , 414369 , 420891 , 428029 , 444720 , 450239 , 454129 , 458694 , 458905 , 459907 , 462316 , 484398 , 484748 , 486870 , 487174 , 495710 , 495741 , 495744 , 496934 , 501500 , 504161 , 506796 , 509033 , 519171 , 520354 , 523335 , 524141 , 528149 , 529271 , 533209 , 534968 , 537001 , 543422 , 543605 , 547814 , 557937 , 566422 , 573394 , 578610 , 583371 , 590505 , 590881 , 590906 , 595799 , 596405 , 609953 , 610661 , 615774 , 622832 , 640029 , 644070 , 644748 , 645196 , 649240 , 654624 , 687163 , 708134 , 714840 , 724425 , 726487 , 726543 );
Copy