205.69 ms (67.41%)
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
121824
430838
433984
444829
453231
453326
457455
474409
483356
496408
497064
506471
509353
517430
517773
521838
523400
526646
528663
532370
538003
548657
555538
556602
566616
580123
592210
597224
602261
614743
626362
664172
665513
687107
705403
722380
731867
732067
764423
782039
783316
788497
810943
813580
819655
824251
]
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 (121824 , 430838 , 433984 , 444829 , 453231 , 453326 , 457455 , 474409 , 483356 , 496408 , 497064 , 506471 , 509353 , 517430 , 517773 , 521838 , 523400 , 526646 , 528663 , 532370 , 538003 , 548657 , 555538 , 556602 , 566616 , 580123 , 592210 , 597224 , 602261 , 614743 , 626362 , 664172 , 665513 , 687107 , 705403 , 722380 , 731867 , 732067 , 764423 , 782039 , 783316 , 788497 , 810943 , 813580 , 819655 , 824251 );
Copy
69.05 ms (22.63%)
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
121824
430838
433984
444829
453231
453326
457455
474409
483356
496408
497064
506471
509353
517430
517773
521838
523400
526646
528663
532370
538003
548657
555538
556602
566616
580123
592210
597224
602261
614743
626362
664172
665513
687107
705403
722380
731867
732067
764423
782039
783316
788497
810943
813580
819655
824251
]
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 (121824 , 430838 , 433984 , 444829 , 453231 , 453326 , 457455 , 474409 , 483356 , 496408 , 497064 , 506471 , 509353 , 517430 , 517773 , 521838 , 523400 , 526646 , 528663 , 532370 , 538003 , 548657 , 555538 , 556602 , 566616 , 580123 , 592210 , 597224 , 602261 , 614743 , 626362 , 664172 , 665513 , 687107 , 705403 , 722380 , 731867 , 732067 , 764423 , 782039 , 783316 , 788497 , 810943 , 813580 , 819655 , 824251 );
Copy
9.27 ms (3.04%)
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
819655
687107
121824
517430
523400
810943
626362
664172
665513
813580
824251
764423
731867
782039
566616
705403
602261
509353
517773
783316
732067
788497
592210
433984
453231
548657
444829
474409
496408
597224
497064
506471
430838
528663
526646
457455
538003
532370
556602
722380
453326
521838
555538
483356
614743
580123
]
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 (819655 , 687107 , 121824 , 517430 , 523400 , 810943 , 626362 , 664172 , 665513 , 813580 , 824251 , 764423 , 731867 , 782039 , 566616 , 705403 , 602261 , 509353 , 517773 , 783316 , 732067 , 788497 , 592210 , 433984 , 453231 , 548657 , 444829 , 474409 , 496408 , 597224 , 497064 , 506471 , 430838 , 528663 , 526646 , 457455 , 538003 , 532370 , 556602 , 722380 , 453326 , 521838 , 555538 , 483356 , 614743 , 580123 );
Copy