88.10 ms (69.68%)
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
424097
426836
429837
430814
433273
433901
435557
437243
438460
440770
448774
449508
458812
466705
476391
478291
478948
485403
486145
487887
492506
496481
500282
501065
503761
506635
508004
510364
510975
515264
515570
519237
520232
520392
520526
537857
539906
565726
569935
573354
577326
578185
579433
579687
589654
590148
592990
595906
602426
610149
631957
660044
660648
662107
664222
705053
744461
755544
766300
798645
800926
]
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 (424097 , 426836 , 429837 , 430814 , 433273 , 433901 , 435557 , 437243 , 438460 , 440770 , 448774 , 449508 , 458812 , 466705 , 476391 , 478291 , 478948 , 485403 , 486145 , 487887 , 492506 , 496481 , 500282 , 501065 , 503761 , 506635 , 508004 , 510364 , 510975 , 515264 , 515570 , 519237 , 520232 , 520392 , 520526 , 537857 , 539906 , 565726 , 569935 , 573354 , 577326 , 578185 , 579433 , 579687 , 589654 , 590148 , 592990 , 595906 , 602426 , 610149 , 631957 , 660044 , 660648 , 662107 , 664222 , 705053 , 744461 , 755544 , 766300 , 798645 , 800926 );
Copy
10.71 ms (8.47%)
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
448774
458812
485403
486145
705053
800926
744461
766300
438460
466705
426836
515570
520392
496481
437243
492506
569935
662107
664222
602426
429837
476391
500282
515264
579687
592990
589654
487887
510364
520526
537857
539906
660044
579433
590148
755544
424097
506635
433901
503761
578185
595906
610149
433273
519237
565726
478291
660648
478948
798645
501065
508004
449508
573354
577326
430814
440770
435557
510975
520232
631957
]
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 (448774 , 458812 , 485403 , 486145 , 705053 , 800926 , 744461 , 766300 , 438460 , 466705 , 426836 , 515570 , 520392 , 496481 , 437243 , 492506 , 569935 , 662107 , 664222 , 602426 , 429837 , 476391 , 500282 , 515264 , 579687 , 592990 , 589654 , 487887 , 510364 , 520526 , 537857 , 539906 , 660044 , 579433 , 590148 , 755544 , 424097 , 506635 , 433901 , 503761 , 578185 , 595906 , 610149 , 433273 , 519237 , 565726 , 478291 , 660648 , 478948 , 798645 , 501065 , 508004 , 449508 , 573354 , 577326 , 430814 , 440770 , 435557 , 510975 , 520232 , 631957 );
Copy
2.47 ms (1.96%)
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
424097
426836
429837
430814
433273
433901
435557
437243
438460
440770
448774
449508
458812
466705
476391
478291
478948
485403
486145
487887
492506
496481
500282
501065
503761
506635
508004
510364
510975
515264
515570
519237
520232
520392
520526
537857
539906
565726
569935
573354
577326
578185
579433
579687
589654
590148
592990
595906
602426
610149
631957
660044
660648
662107
664222
705053
744461
755544
766300
798645
800926
]
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 (424097 , 426836 , 429837 , 430814 , 433273 , 433901 , 435557 , 437243 , 438460 , 440770 , 448774 , 449508 , 458812 , 466705 , 476391 , 478291 , 478948 , 485403 , 486145 , 487887 , 492506 , 496481 , 500282 , 501065 , 503761 , 506635 , 508004 , 510364 , 510975 , 515264 , 515570 , 519237 , 520232 , 520392 , 520526 , 537857 , 539906 , 565726 , 569935 , 573354 , 577326 , 578185 , 579433 , 579687 , 589654 , 590148 , 592990 , 595906 , 602426 , 610149 , 631957 , 660044 , 660648 , 662107 , 664222 , 705053 , 744461 , 755544 , 766300 , 798645 , 800926 );
Copy