310.32 ms (81.79%)
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
404175
406132
415230
419358
419783
420891
425740
426383
432929
434669
439467
446162
458437
460099
466611
467577
468548
468694
469182
471716
476115
495690
523021
527414
530034
530054
530789
530836
531174
531179
531239
532343
532963
534842
534992
536339
536546
537685
537917
537933
538428
544803
550415
556037
560664
566022
580264
589145
603622
604172
620205
621946
631597
649110
677777
696214
750827
799990
800262
810404
]
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 (404175 , 406132 , 415230 , 419358 , 419783 , 420891 , 425740 , 426383 , 432929 , 434669 , 439467 , 446162 , 458437 , 460099 , 466611 , 467577 , 468548 , 468694 , 469182 , 471716 , 476115 , 495690 , 523021 , 527414 , 530034 , 530054 , 530789 , 530836 , 531174 , 531179 , 531239 , 532343 , 532963 , 534842 , 534992 , 536339 , 536546 , 537685 , 537917 , 537933 , 538428 , 544803 , 550415 , 556037 , 560664 , 566022 , 580264 , 589145 , 603622 , 604172 , 620205 , 621946 , 631597 , 649110 , 677777 , 696214 , 750827 , 799990 , 800262 , 810404 );
Copy
8.99 ms (2.37%)
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
467577
406132
530034
696214
750827
810404
534992
531179
799990
495690
566022
446162
468694
466611
471716
538428
476115
589145
439467
530836
434669
468548
531239
536546
530054
649110
800262
469182
537917
537933
415230
404175
458437
419358
460099
536339
544803
530789
425740
560664
426383
420891
631597
419783
604172
537685
532343
432929
531174
534842
603622
580264
532963
523021
556037
677777
550415
621946
527414
620205
]
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 (467577 , 406132 , 530034 , 696214 , 750827 , 810404 , 534992 , 531179 , 799990 , 495690 , 566022 , 446162 , 468694 , 466611 , 471716 , 538428 , 476115 , 589145 , 439467 , 530836 , 434669 , 468548 , 531239 , 536546 , 530054 , 649110 , 800262 , 469182 , 537917 , 537933 , 415230 , 404175 , 458437 , 419358 , 460099 , 536339 , 544803 , 530789 , 425740 , 560664 , 426383 , 420891 , 631597 , 419783 , 604172 , 537685 , 532343 , 432929 , 531174 , 534842 , 603622 , 580264 , 532963 , 523021 , 556037 , 677777 , 550415 , 621946 , 527414 , 620205 );
Copy
2.31 ms (0.61%)
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
404175
406132
415230
419358
419783
420891
425740
426383
432929
434669
439467
446162
458437
460099
466611
467577
468548
468694
469182
471716
476115
495690
523021
527414
530034
530054
530789
530836
531174
531179
531239
532343
532963
534842
534992
536339
536546
537685
537917
537933
538428
544803
550415
556037
560664
566022
580264
589145
603622
604172
620205
621946
631597
649110
677777
696214
750827
799990
800262
810404
]
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 (404175 , 406132 , 415230 , 419358 , 419783 , 420891 , 425740 , 426383 , 432929 , 434669 , 439467 , 446162 , 458437 , 460099 , 466611 , 467577 , 468548 , 468694 , 469182 , 471716 , 476115 , 495690 , 523021 , 527414 , 530034 , 530054 , 530789 , 530836 , 531174 , 531179 , 531239 , 532343 , 532963 , 534842 , 534992 , 536339 , 536546 , 537685 , 537917 , 537933 , 538428 , 544803 , 550415 , 556037 , 560664 , 566022 , 580264 , 589145 , 603622 , 604172 , 620205 , 621946 , 631597 , 649110 , 677777 , 696214 , 750827 , 799990 , 800262 , 810404 );
Copy