68.29 ms (49.45%)
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
497459
530681
531115
533915
534027
534032
534378
535505
537890
539203
540518
541197
541201
542583
542595
545410
545611
600363
628333
628382
628383
630537
630764
631195
631200
632635
632978
633451
633743
633770
633792
634115
634116
634139
634780
634801
636293
636296
637021
637141
639716
640784
641975
642060
644916
645258
645858
646896
647313
647830
647936
647952
647972
648257
648809
666899
666901
696204
696579
696582
707391
]
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 (497459 , 530681 , 531115 , 533915 , 534027 , 534032 , 534378 , 535505 , 537890 , 539203 , 540518 , 541197 , 541201 , 542583 , 542595 , 545410 , 545611 , 600363 , 628333 , 628382 , 628383 , 630537 , 630764 , 631195 , 631200 , 632635 , 632978 , 633451 , 633743 , 633770 , 633792 , 634115 , 634116 , 634139 , 634780 , 634801 , 636293 , 636296 , 637021 , 637141 , 639716 , 640784 , 641975 , 642060 , 644916 , 645258 , 645858 , 646896 , 647313 , 647830 , 647936 , 647952 , 647972 , 648257 , 648809 , 666899 , 666901 , 696204 , 696579 , 696582 , 707391 );
Copy
16.68 ms (12.08%)
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
645258
632635
637141
642060
636296
530681
631195
640784
636293
645858
696204
648809
637021
631200
541201
633451
641975
541197
630764
639716
497459
539203
707391
630537
534032
537890
534378
647313
634139
531115
542583
542595
646896
666899
633743
535505
540518
696579
666901
634116
647936
696582
647830
647952
633770
600363
628382
633792
534027
647972
634115
632978
634801
644916
545410
545611
628383
634780
648257
628333
533915
]
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 (645258 , 632635 , 637141 , 642060 , 636296 , 530681 , 631195 , 640784 , 636293 , 645858 , 696204 , 648809 , 637021 , 631200 , 541201 , 633451 , 641975 , 541197 , 630764 , 639716 , 497459 , 539203 , 707391 , 630537 , 534032 , 537890 , 534378 , 647313 , 634139 , 531115 , 542583 , 542595 , 646896 , 666899 , 633743 , 535505 , 540518 , 696579 , 666901 , 634116 , 647936 , 696582 , 647830 , 647952 , 633770 , 600363 , 628382 , 633792 , 534027 , 647972 , 634115 , 632978 , 634801 , 644916 , 545410 , 545611 , 628383 , 634780 , 648257 , 628333 , 533915 );
Copy
2.16 ms (1.56%)
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
497459
530681
531115
533915
534027
534032
534378
535505
537890
539203
540518
541197
541201
542583
542595
545410
545611
600363
628333
628382
628383
630537
630764
631195
631200
632635
632978
633451
633743
633770
633792
634115
634116
634139
634780
634801
636293
636296
637021
637141
639716
640784
641975
642060
644916
645258
645858
646896
647313
647830
647936
647952
647972
648257
648809
666899
666901
696204
696579
696582
707391
]
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 (497459 , 530681 , 531115 , 533915 , 534027 , 534032 , 534378 , 535505 , 537890 , 539203 , 540518 , 541197 , 541201 , 542583 , 542595 , 545410 , 545611 , 600363 , 628333 , 628382 , 628383 , 630537 , 630764 , 631195 , 631200 , 632635 , 632978 , 633451 , 633743 , 633770 , 633792 , 634115 , 634116 , 634139 , 634780 , 634801 , 636293 , 636296 , 637021 , 637141 , 639716 , 640784 , 641975 , 642060 , 644916 , 645258 , 645858 , 646896 , 647313 , 647830 , 647936 , 647952 , 647972 , 648257 , 648809 , 666899 , 666901 , 696204 , 696579 , 696582 , 707391 );
Copy