72.73 ms (61.58%)
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
155311
385070
395640
396168
407424
435236
444227
445345
445672
458206
466176
467413
467452
472918
476278
476908
481674
484462
484556
488301
488920
495148
497337
502702
507362
514574
515261
517831
518287
519985
522441
524749
527059
527608
538031
545530
545531
550452
551199
558051
558417
564786
565332
567329
571383
580197
581681
586380
587309
612222
613167
618874
630866
634962
663952
673661
683989
699025
721551
790392
799585
800373
802657
813874
]
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 (155311 , 385070 , 395640 , 396168 , 407424 , 435236 , 444227 , 445345 , 445672 , 458206 , 466176 , 467413 , 467452 , 472918 , 476278 , 476908 , 481674 , 484462 , 484556 , 488301 , 488920 , 495148 , 497337 , 502702 , 507362 , 514574 , 515261 , 517831 , 518287 , 519985 , 522441 , 524749 , 527059 , 527608 , 538031 , 545530 , 545531 , 550452 , 551199 , 558051 , 558417 , 564786 , 565332 , 567329 , 571383 , 580197 , 581681 , 586380 , 587309 , 612222 , 613167 , 618874 , 630866 , 634962 , 663952 , 673661 , 683989 , 699025 , 721551 , 790392 , 799585 , 800373 , 802657 , 813874 );
Copy
11.03 ms (9.34%)
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
495148
565332
683989
587309
800373
545531
497337
699025
634962
155311
507362
721551
545530
484462
581681
558417
580197
395640
558051
444227
472918
663952
790392
527059
514574
813874
524749
538031
458206
802657
385070
476278
567329
571383
586380
445345
518287
612222
488920
445672
673661
519985
484556
799585
467413
550452
481674
435236
466176
488301
407424
502702
467452
551199
515261
618874
613167
517831
522441
564786
396168
476908
630866
527608
]
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 (495148 , 565332 , 683989 , 587309 , 800373 , 545531 , 497337 , 699025 , 634962 , 155311 , 507362 , 721551 , 545530 , 484462 , 581681 , 558417 , 580197 , 395640 , 558051 , 444227 , 472918 , 663952 , 790392 , 527059 , 514574 , 813874 , 524749 , 538031 , 458206 , 802657 , 385070 , 476278 , 567329 , 571383 , 586380 , 445345 , 518287 , 612222 , 488920 , 445672 , 673661 , 519985 , 484556 , 799585 , 467413 , 550452 , 481674 , 435236 , 466176 , 488301 , 407424 , 502702 , 467452 , 551199 , 515261 , 618874 , 613167 , 517831 , 522441 , 564786 , 396168 , 476908 , 630866 , 527608 );
Copy
2.61 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
155311
385070
395640
396168
407424
435236
444227
445345
445672
458206
466176
467413
467452
472918
476278
476908
481674
484462
484556
488301
488920
495148
497337
502702
507362
514574
515261
517831
518287
519985
522441
524749
527059
527608
538031
545530
545531
550452
551199
558051
558417
564786
565332
567329
571383
580197
581681
586380
587309
612222
613167
618874
630866
634962
663952
673661
683989
699025
721551
790392
799585
800373
802657
813874
]
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 (155311 , 385070 , 395640 , 396168 , 407424 , 435236 , 444227 , 445345 , 445672 , 458206 , 466176 , 467413 , 467452 , 472918 , 476278 , 476908 , 481674 , 484462 , 484556 , 488301 , 488920 , 495148 , 497337 , 502702 , 507362 , 514574 , 515261 , 517831 , 518287 , 519985 , 522441 , 524749 , 527059 , 527608 , 538031 , 545530 , 545531 , 550452 , 551199 , 558051 , 558417 , 564786 , 565332 , 567329 , 571383 , 580197 , 581681 , 586380 , 587309 , 612222 , 613167 , 618874 , 630866 , 634962 , 663952 , 673661 , 683989 , 699025 , 721551 , 790392 , 799585 , 800373 , 802657 , 813874 );
Copy