66.95 ms (46.71%)
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
411945
415781
420207
423267
440620
444303
448149
449086
451464
452228
452282
456427
457975
463087
466007
466242
469335
473479
478380
484821
487315
489210
504661
506415
508158
511830
516045
518548
519341
521552
525705
534683
543175
544796
545601
553280
555136
555140
576636
579592
589590
590343
590633
596616
596992
597216
599772
622932
622978
623292
624504
628380
629428
632563
645993
693954
697459
698102
730386
739532
743065
748365
807326
]
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 (411945 , 415781 , 420207 , 423267 , 440620 , 444303 , 448149 , 449086 , 451464 , 452228 , 452282 , 456427 , 457975 , 463087 , 466007 , 466242 , 469335 , 473479 , 478380 , 484821 , 487315 , 489210 , 504661 , 506415 , 508158 , 511830 , 516045 , 518548 , 519341 , 521552 , 525705 , 534683 , 543175 , 544796 , 545601 , 553280 , 555136 , 555140 , 576636 , 579592 , 589590 , 590343 , 590633 , 596616 , 596992 , 597216 , 599772 , 622932 , 622978 , 623292 , 624504 , 628380 , 629428 , 632563 , 645993 , 693954 , 697459 , 698102 , 730386 , 739532 , 743065 , 748365 , 807326 );
Copy
12.93 ms (9.02%)
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
693954
596992
698102
473479
555140
411945
478380
534683
697459
807326
748365
415781
518548
525705
420207
452282
544796
521552
576636
623292
444303
448149
456427
484821
589590
487315
743065
730386
423267
466242
452228
506415
516045
555136
622978
590633
466007
543175
449086
545601
739532
451464
504661
508158
629428
645993
511830
622932
590343
596616
469335
624504
628380
489210
599772
579592
440620
597216
457975
632563
519341
463087
553280
]
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 (693954 , 596992 , 698102 , 473479 , 555140 , 411945 , 478380 , 534683 , 697459 , 807326 , 748365 , 415781 , 518548 , 525705 , 420207 , 452282 , 544796 , 521552 , 576636 , 623292 , 444303 , 448149 , 456427 , 484821 , 589590 , 487315 , 743065 , 730386 , 423267 , 466242 , 452228 , 506415 , 516045 , 555136 , 622978 , 590633 , 466007 , 543175 , 449086 , 545601 , 739532 , 451464 , 504661 , 508158 , 629428 , 645993 , 511830 , 622932 , 590343 , 596616 , 469335 , 624504 , 628380 , 489210 , 599772 , 579592 , 440620 , 597216 , 457975 , 632563 , 519341 , 463087 , 553280 );
Copy
2.73 ms (1.91%)
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
411945
415781
420207
423267
440620
444303
448149
449086
451464
452228
452282
456427
457975
463087
466007
466242
469335
473479
478380
484821
487315
489210
504661
506415
508158
511830
516045
518548
519341
521552
525705
534683
543175
544796
545601
553280
555136
555140
576636
579592
589590
590343
590633
596616
596992
597216
599772
622932
622978
623292
624504
628380
629428
632563
645993
693954
697459
698102
730386
739532
743065
748365
807326
]
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 (411945 , 415781 , 420207 , 423267 , 440620 , 444303 , 448149 , 449086 , 451464 , 452228 , 452282 , 456427 , 457975 , 463087 , 466007 , 466242 , 469335 , 473479 , 478380 , 484821 , 487315 , 489210 , 504661 , 506415 , 508158 , 511830 , 516045 , 518548 , 519341 , 521552 , 525705 , 534683 , 543175 , 544796 , 545601 , 553280 , 555136 , 555140 , 576636 , 579592 , 589590 , 590343 , 590633 , 596616 , 596992 , 597216 , 599772 , 622932 , 622978 , 623292 , 624504 , 628380 , 629428 , 632563 , 645993 , 693954 , 697459 , 698102 , 730386 , 739532 , 743065 , 748365 , 807326 );
Copy