128.98 ms (73.82%)
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
421172
428142
439516
439649
444692
445706
452199
456427
462535
465024
468433
469030
469764
472674
472793
473807
474020
476797
482530
485002
486377
486569
497579
497885
500904
501414
510157
513338
516375
518243
520448
520954
526948
527195
532676
539008
540910
542049
542056
542062
543419
543421
551480
568762
574527
578587
583370
586591
587896
590651
591169
597240
599888
605151
605374
611477
611558
614752
621784
622044
775819
]
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 (421172 , 428142 , 439516 , 439649 , 444692 , 445706 , 452199 , 456427 , 462535 , 465024 , 468433 , 469030 , 469764 , 472674 , 472793 , 473807 , 474020 , 476797 , 482530 , 485002 , 486377 , 486569 , 497579 , 497885 , 500904 , 501414 , 510157 , 513338 , 516375 , 518243 , 520448 , 520954 , 526948 , 527195 , 532676 , 539008 , 540910 , 542049 , 542056 , 542062 , 543419 , 543421 , 551480 , 568762 , 574527 , 578587 , 583370 , 586591 , 587896 , 590651 , 591169 , 597240 , 599888 , 605151 , 605374 , 611477 , 611558 , 614752 , 621784 , 622044 , 775819 );
Copy
15.00 ms (8.59%)
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
469764
497885
439516
444692
456427
472674
510157
540910
542056
542062
568762
543421
551480
445706
473807
485002
501414
486377
462535
518243
578587
586591
465024
539008
542049
439649
469030
520448
482530
583370
622044
421172
497579
516375
605374
468433
621784
611477
614752
532676
452199
526948
775819
428142
599888
513338
590651
591169
472793
520954
500904
476797
474020
527195
605151
486569
574527
587896
543419
597240
611558
]
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 (469764 , 497885 , 439516 , 444692 , 456427 , 472674 , 510157 , 540910 , 542056 , 542062 , 568762 , 543421 , 551480 , 445706 , 473807 , 485002 , 501414 , 486377 , 462535 , 518243 , 578587 , 586591 , 465024 , 539008 , 542049 , 439649 , 469030 , 520448 , 482530 , 583370 , 622044 , 421172 , 497579 , 516375 , 605374 , 468433 , 621784 , 611477 , 614752 , 532676 , 452199 , 526948 , 775819 , 428142 , 599888 , 513338 , 590651 , 591169 , 472793 , 520954 , 500904 , 476797 , 474020 , 527195 , 605151 , 486569 , 574527 , 587896 , 543419 , 597240 , 611558 );
Copy
3.38 ms (1.93%)
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
421172
428142
439516
439649
444692
445706
452199
456427
462535
465024
468433
469030
469764
472674
472793
473807
474020
476797
482530
485002
486377
486569
497579
497885
500904
501414
510157
513338
516375
518243
520448
520954
526948
527195
532676
539008
540910
542049
542056
542062
543419
543421
551480
568762
574527
578587
583370
586591
587896
590651
591169
597240
599888
605151
605374
611477
611558
614752
621784
622044
775819
]
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 (421172 , 428142 , 439516 , 439649 , 444692 , 445706 , 452199 , 456427 , 462535 , 465024 , 468433 , 469030 , 469764 , 472674 , 472793 , 473807 , 474020 , 476797 , 482530 , 485002 , 486377 , 486569 , 497579 , 497885 , 500904 , 501414 , 510157 , 513338 , 516375 , 518243 , 520448 , 520954 , 526948 , 527195 , 532676 , 539008 , 540910 , 542049 , 542056 , 542062 , 543419 , 543421 , 551480 , 568762 , 574527 , 578587 , 583370 , 586591 , 587896 , 590651 , 591169 , 597240 , 599888 , 605151 , 605374 , 611477 , 611558 , 614752 , 621784 , 622044 , 775819 );
Copy