100.21 ms (53.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
338587
402626
414126
418057
418188
420050
422546
422599
422604
422618
422633
422638
422652
423267
425365
425993
429608
431540
448811
448821
449435
451259
463798
464651
468705
469520
469527
469576
478437
532838
535039
536216
538270
540195
543872
543874
547241
550618
550750
551987
552010
554425
566007
579389
583468
583501
586619
600492
604429
614401
619439
621029
622204
622990
642063
650380
662197
663537
680498
694563
788187
803450
818442
823174
]
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 (338587 , 402626 , 414126 , 418057 , 418188 , 420050 , 422546 , 422599 , 422604 , 422618 , 422633 , 422638 , 422652 , 423267 , 425365 , 425993 , 429608 , 431540 , 448811 , 448821 , 449435 , 451259 , 463798 , 464651 , 468705 , 469520 , 469527 , 469576 , 478437 , 532838 , 535039 , 536216 , 538270 , 540195 , 543872 , 543874 , 547241 , 550618 , 550750 , 551987 , 552010 , 554425 , 566007 , 579389 , 583468 , 583501 , 586619 , 600492 , 604429 , 614401 , 619439 , 621029 , 622204 , 622990 , 642063 , 650380 , 662197 , 663537 , 680498 , 694563 , 788187 , 803450 , 818442 , 823174 );
Copy
10.68 ms (5.72%)
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
422604
422652
469520
469576
448811
788187
422638
451259
621029
422546
803450
429608
551987
543872
538270
579389
586619
449435
422618
583501
818442
540195
694563
600492
422633
422599
431540
338587
425365
478437
583468
619439
418188
536216
550618
420050
662197
402626
550750
566007
469527
464651
468705
535039
463798
414126
547241
554425
823174
680498
622990
423267
532838
418057
614401
552010
448821
642063
622204
543874
663537
425993
650380
604429
]
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 (422604 , 422652 , 469520 , 469576 , 448811 , 788187 , 422638 , 451259 , 621029 , 422546 , 803450 , 429608 , 551987 , 543872 , 538270 , 579389 , 586619 , 449435 , 422618 , 583501 , 818442 , 540195 , 694563 , 600492 , 422633 , 422599 , 431540 , 338587 , 425365 , 478437 , 583468 , 619439 , 418188 , 536216 , 550618 , 420050 , 662197 , 402626 , 550750 , 566007 , 469527 , 464651 , 468705 , 535039 , 463798 , 414126 , 547241 , 554425 , 823174 , 680498 , 622990 , 423267 , 532838 , 418057 , 614401 , 552010 , 448821 , 642063 , 622204 , 543874 , 663537 , 425993 , 650380 , 604429 );
Copy
2.27 ms (1.22%)
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
338587
402626
414126
418057
418188
420050
422546
422599
422604
422618
422633
422638
422652
423267
425365
425993
429608
431540
448811
448821
449435
451259
463798
464651
468705
469520
469527
469576
478437
532838
535039
536216
538270
540195
543872
543874
547241
550618
550750
551987
552010
554425
566007
579389
583468
583501
586619
600492
604429
614401
619439
621029
622204
622990
642063
650380
662197
663537
680498
694563
788187
803450
818442
823174
]
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 (338587 , 402626 , 414126 , 418057 , 418188 , 420050 , 422546 , 422599 , 422604 , 422618 , 422633 , 422638 , 422652 , 423267 , 425365 , 425993 , 429608 , 431540 , 448811 , 448821 , 449435 , 451259 , 463798 , 464651 , 468705 , 469520 , 469527 , 469576 , 478437 , 532838 , 535039 , 536216 , 538270 , 540195 , 543872 , 543874 , 547241 , 550618 , 550750 , 551987 , 552010 , 554425 , 566007 , 579389 , 583468 , 583501 , 586619 , 600492 , 604429 , 614401 , 619439 , 621029 , 622204 , 622990 , 642063 , 650380 , 662197 , 663537 , 680498 , 694563 , 788187 , 803450 , 818442 , 823174 );
Copy