86.32 ms (74.21%)
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
61051
355652
393124
396784
400833
410265
412122
416294
418051
418053
418057
418323
418844
420658
422753
422769
424713
425786
425823
427299
431603
431664
443523
444487
449580
457759
457981
458617
458623
460074
462288
482824
497664
499027
499036
500743
518011
518949
529822
533431
535451
546085
553259
558578
583289
591278
593002
593092
601716
603460
606493
615447
634215
643149
669532
672251
672261
672264
690925
722438
762136
828324
]
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 (61051 , 355652 , 393124 , 396784 , 400833 , 410265 , 412122 , 416294 , 418051 , 418053 , 418057 , 418323 , 418844 , 420658 , 422753 , 422769 , 424713 , 425786 , 425823 , 427299 , 431603 , 431664 , 443523 , 444487 , 449580 , 457759 , 457981 , 458617 , 458623 , 460074 , 462288 , 482824 , 497664 , 499027 , 499036 , 500743 , 518011 , 518949 , 529822 , 533431 , 535451 , 546085 , 553259 , 558578 , 583289 , 591278 , 593002 , 593092 , 601716 , 603460 , 606493 , 615447 , 634215 , 643149 , 669532 , 672251 , 672261 , 672264 , 690925 , 722438 , 762136 , 828324 );
Copy
9.59 ms (8.25%)
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
669532
591278
424713
722438
762136
553259
61051
690925
497664
393124
529822
533431
601716
410265
416294
672261
643149
422753
431664
499027
672251
603460
518011
355652
593002
593092
449580
431603
828324
396784
462288
499036
672264
418053
460074
443523
400833
422769
535451
457759
412122
425823
418844
444487
458617
518949
420658
458623
482824
418323
500743
427299
558578
634215
418057
425786
546085
606493
457981
615447
418051
583289
]
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 (669532 , 591278 , 424713 , 722438 , 762136 , 553259 , 61051 , 690925 , 497664 , 393124 , 529822 , 533431 , 601716 , 410265 , 416294 , 672261 , 643149 , 422753 , 431664 , 499027 , 672251 , 603460 , 518011 , 355652 , 593002 , 593092 , 449580 , 431603 , 828324 , 396784 , 462288 , 499036 , 672264 , 418053 , 460074 , 443523 , 400833 , 422769 , 535451 , 457759 , 412122 , 425823 , 418844 , 444487 , 458617 , 518949 , 420658 , 458623 , 482824 , 418323 , 500743 , 427299 , 558578 , 634215 , 418057 , 425786 , 546085 , 606493 , 457981 , 615447 , 418051 , 583289 );
Copy
2.57 ms (2.21%)
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
61051
355652
393124
396784
400833
410265
412122
416294
418051
418053
418057
418323
418844
420658
422753
422769
424713
425786
425823
427299
431603
431664
443523
444487
449580
457759
457981
458617
458623
460074
462288
482824
497664
499027
499036
500743
518011
518949
529822
533431
535451
546085
553259
558578
583289
591278
593002
593092
601716
603460
606493
615447
634215
643149
669532
672251
672261
672264
690925
722438
762136
828324
]
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 (61051 , 355652 , 393124 , 396784 , 400833 , 410265 , 412122 , 416294 , 418051 , 418053 , 418057 , 418323 , 418844 , 420658 , 422753 , 422769 , 424713 , 425786 , 425823 , 427299 , 431603 , 431664 , 443523 , 444487 , 449580 , 457759 , 457981 , 458617 , 458623 , 460074 , 462288 , 482824 , 497664 , 499027 , 499036 , 500743 , 518011 , 518949 , 529822 , 533431 , 535451 , 546085 , 553259 , 558578 , 583289 , 591278 , 593002 , 593092 , 601716 , 603460 , 606493 , 615447 , 634215 , 643149 , 669532 , 672251 , 672261 , 672264 , 690925 , 722438 , 762136 , 828324 );
Copy