89.54 ms (63.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
75664
392780
398747
406046
419361
422262
422275
422282
422498
435437
436591
437610
438288
442586
446418
447008
450070
450573
451494
452299
453800
453889
453999
454737
455047
456120
456664
459615
461330
462214
463518
464905
465239
467065
478275
482725
486334
504661
516226
518152
521002
524277
526814
530000
537797
559534
566116
569638
592288
592778
635029
690179
730112
730780
758248
759502
769215
772517
791285
795550
800708
801368
818009
]
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 (75664 , 392780 , 398747 , 406046 , 419361 , 422262 , 422275 , 422282 , 422498 , 435437 , 436591 , 437610 , 438288 , 442586 , 446418 , 447008 , 450070 , 450573 , 451494 , 452299 , 453800 , 453889 , 453999 , 454737 , 455047 , 456120 , 456664 , 459615 , 461330 , 462214 , 463518 , 464905 , 465239 , 467065 , 478275 , 482725 , 486334 , 504661 , 516226 , 518152 , 521002 , 524277 , 526814 , 530000 , 537797 , 559534 , 566116 , 569638 , 592288 , 592778 , 635029 , 690179 , 730112 , 730780 , 758248 , 759502 , 769215 , 772517 , 791285 , 795550 , 800708 , 801368 , 818009 );
Copy
12.59 ms (8.95%)
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
521002
769215
730780
398747
406046
537797
635029
690179
75664
442586
758248
453999
465239
518152
566116
759502
772517
795550
392780
791285
461330
450070
730112
801368
422262
818009
800708
422275
482725
452299
451494
478275
419361
516226
455047
524277
569638
559534
504661
422282
422498
456664
462214
486334
592778
435437
446418
438288
437610
453889
450573
464905
454737
436591
467065
453800
447008
456120
463518
459615
526814
530000
592288
]
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 (521002 , 769215 , 730780 , 398747 , 406046 , 537797 , 635029 , 690179 , 75664 , 442586 , 758248 , 453999 , 465239 , 518152 , 566116 , 759502 , 772517 , 795550 , 392780 , 791285 , 461330 , 450070 , 730112 , 801368 , 422262 , 818009 , 800708 , 422275 , 482725 , 452299 , 451494 , 478275 , 419361 , 516226 , 455047 , 524277 , 569638 , 559534 , 504661 , 422282 , 422498 , 456664 , 462214 , 486334 , 592778 , 435437 , 446418 , 438288 , 437610 , 453889 , 450573 , 464905 , 454737 , 436591 , 467065 , 453800 , 447008 , 456120 , 463518 , 459615 , 526814 , 530000 , 592288 );
Copy
2.87 ms (2.04%)
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
75664
392780
398747
406046
419361
422262
422275
422282
422498
435437
436591
437610
438288
442586
446418
447008
450070
450573
451494
452299
453800
453889
453999
454737
455047
456120
456664
459615
461330
462214
463518
464905
465239
467065
478275
482725
486334
504661
516226
518152
521002
524277
526814
530000
537797
559534
566116
569638
592288
592778
635029
690179
730112
730780
758248
759502
769215
772517
791285
795550
800708
801368
818009
]
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 (75664 , 392780 , 398747 , 406046 , 419361 , 422262 , 422275 , 422282 , 422498 , 435437 , 436591 , 437610 , 438288 , 442586 , 446418 , 447008 , 450070 , 450573 , 451494 , 452299 , 453800 , 453889 , 453999 , 454737 , 455047 , 456120 , 456664 , 459615 , 461330 , 462214 , 463518 , 464905 , 465239 , 467065 , 478275 , 482725 , 486334 , 504661 , 516226 , 518152 , 521002 , 524277 , 526814 , 530000 , 537797 , 559534 , 566116 , 569638 , 592288 , 592778 , 635029 , 690179 , 730112 , 730780 , 758248 , 759502 , 769215 , 772517 , 791285 , 795550 , 800708 , 801368 , 818009 );
Copy