75.95 ms (66.69%)
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
383367
389458
394447
395531
395560
396414
396934
396962
397023
412261
412262
413090
421838
425478
429675
435934
446284
446297
446306
446313
446625
453013
453721
462322
476276
478680
484775
486902
486915
486958
492137
506824
518944
518954
521807
523905
524286
525154
526181
527017
528355
531935
532001
532004
532041
537126
547601
552762
559048
565730
624003
644027
664975
668948
726403
731204
732358
746638
782153
796202
811263
]
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 (383367 , 389458 , 394447 , 395531 , 395560 , 396414 , 396934 , 396962 , 397023 , 412261 , 412262 , 413090 , 421838 , 425478 , 429675 , 435934 , 446284 , 446297 , 446306 , 446313 , 446625 , 453013 , 453721 , 462322 , 476276 , 478680 , 484775 , 486902 , 486915 , 486958 , 492137 , 506824 , 518944 , 518954 , 521807 , 523905 , 524286 , 525154 , 526181 , 527017 , 528355 , 531935 , 532001 , 532004 , 532041 , 537126 , 547601 , 552762 , 559048 , 565730 , 624003 , 644027 , 664975 , 668948 , 726403 , 731204 , 732358 , 746638 , 782153 , 796202 , 811263 );
Copy
9.34 ms (8.20%)
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
396414
532001
732358
746638
396962
668948
644027
397023
396934
531935
394447
478680
518954
811263
726403
532041
552762
664975
782153
383367
518944
523905
524286
446284
476276
395560
526181
446297
446625
446306
532004
796202
731204
395531
425478
453013
492137
547601
559048
565730
421838
429675
446313
486902
537126
389458
413090
486958
506824
527017
435934
484775
486915
412262
624003
462322
528355
412261
521807
453721
525154
]
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 (396414 , 532001 , 732358 , 746638 , 396962 , 668948 , 644027 , 397023 , 396934 , 531935 , 394447 , 478680 , 518954 , 811263 , 726403 , 532041 , 552762 , 664975 , 782153 , 383367 , 518944 , 523905 , 524286 , 446284 , 476276 , 395560 , 526181 , 446297 , 446625 , 446306 , 532004 , 796202 , 731204 , 395531 , 425478 , 453013 , 492137 , 547601 , 559048 , 565730 , 421838 , 429675 , 446313 , 486902 , 537126 , 389458 , 413090 , 486958 , 506824 , 527017 , 435934 , 484775 , 486915 , 412262 , 624003 , 462322 , 528355 , 412261 , 521807 , 453721 , 525154 );
Copy
2.59 ms (2.28%)
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
383367
389458
394447
395531
395560
396414
396934
396962
397023
412261
412262
413090
421838
425478
429675
435934
446284
446297
446306
446313
446625
453013
453721
462322
476276
478680
484775
486902
486915
486958
492137
506824
518944
518954
521807
523905
524286
525154
526181
527017
528355
531935
532001
532004
532041
537126
547601
552762
559048
565730
624003
644027
664975
668948
726403
731204
732358
746638
782153
796202
811263
]
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 (383367 , 389458 , 394447 , 395531 , 395560 , 396414 , 396934 , 396962 , 397023 , 412261 , 412262 , 413090 , 421838 , 425478 , 429675 , 435934 , 446284 , 446297 , 446306 , 446313 , 446625 , 453013 , 453721 , 462322 , 476276 , 478680 , 484775 , 486902 , 486915 , 486958 , 492137 , 506824 , 518944 , 518954 , 521807 , 523905 , 524286 , 525154 , 526181 , 527017 , 528355 , 531935 , 532001 , 532004 , 532041 , 537126 , 547601 , 552762 , 559048 , 565730 , 624003 , 644027 , 664975 , 668948 , 726403 , 731204 , 732358 , 746638 , 782153 , 796202 , 811263 );
Copy