140.48 ms (69.46%)
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
386017
389976
392751
398237
400942
414157
424613
427185
434070
434124
445945
454140
461208
463231
464971
466646
467046
468004
468284
470024
470195
471001
471029
472683
474315
475672
490595
492182
494547
495277
514450
529650
543623
544871
548946
562155
576484
576614
583197
584366
585851
587235
590981
603567
610198
615073
620908
634071
640477
642022
649306
653192
710937
733396
739774
742310
752090
757197
760686
761269
826356
]
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 (386017 , 389976 , 392751 , 398237 , 400942 , 414157 , 424613 , 427185 , 434070 , 434124 , 445945 , 454140 , 461208 , 463231 , 464971 , 466646 , 467046 , 468004 , 468284 , 470024 , 470195 , 471001 , 471029 , 472683 , 474315 , 475672 , 490595 , 492182 , 494547 , 495277 , 514450 , 529650 , 543623 , 544871 , 548946 , 562155 , 576484 , 576614 , 583197 , 584366 , 585851 , 587235 , 590981 , 603567 , 610198 , 615073 , 620908 , 634071 , 640477 , 642022 , 649306 , 653192 , 710937 , 733396 , 739774 , 742310 , 752090 , 757197 , 760686 , 761269 , 826356 );
Copy
10.10 ms (4.99%)
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
398237
739774
529650
562155
576484
610198
742310
761269
757197
548946
710937
752090
603567
620908
576614
544871
640477
392751
653192
615073
826356
649306
590981
760686
467046
468284
427185
471029
587235
733396
490595
386017
470195
642022
492182
468004
389976
514450
474315
400942
461208
470024
472683
434070
634071
463231
583197
454140
494547
495277
543623
434124
424613
475672
466646
471001
585851
445945
464971
584366
414157
]
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 (398237 , 739774 , 529650 , 562155 , 576484 , 610198 , 742310 , 761269 , 757197 , 548946 , 710937 , 752090 , 603567 , 620908 , 576614 , 544871 , 640477 , 392751 , 653192 , 615073 , 826356 , 649306 , 590981 , 760686 , 467046 , 468284 , 427185 , 471029 , 587235 , 733396 , 490595 , 386017 , 470195 , 642022 , 492182 , 468004 , 389976 , 514450 , 474315 , 400942 , 461208 , 470024 , 472683 , 434070 , 634071 , 463231 , 583197 , 454140 , 494547 , 495277 , 543623 , 434124 , 424613 , 475672 , 466646 , 471001 , 585851 , 445945 , 464971 , 584366 , 414157 );
Copy
2.86 ms (1.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
386017
389976
392751
398237
400942
414157
424613
427185
434070
434124
445945
454140
461208
463231
464971
466646
467046
468004
468284
470024
470195
471001
471029
472683
474315
475672
490595
492182
494547
495277
514450
529650
543623
544871
548946
562155
576484
576614
583197
584366
585851
587235
590981
603567
610198
615073
620908
634071
640477
642022
649306
653192
710937
733396
739774
742310
752090
757197
760686
761269
826356
]
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 (386017 , 389976 , 392751 , 398237 , 400942 , 414157 , 424613 , 427185 , 434070 , 434124 , 445945 , 454140 , 461208 , 463231 , 464971 , 466646 , 467046 , 468004 , 468284 , 470024 , 470195 , 471001 , 471029 , 472683 , 474315 , 475672 , 490595 , 492182 , 494547 , 495277 , 514450 , 529650 , 543623 , 544871 , 548946 , 562155 , 576484 , 576614 , 583197 , 584366 , 585851 , 587235 , 590981 , 603567 , 610198 , 615073 , 620908 , 634071 , 640477 , 642022 , 649306 , 653192 , 710937 , 733396 , 739774 , 742310 , 752090 , 757197 , 760686 , 761269 , 826356 );
Copy