| 3 |
13.02 ms |
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
518393
509100
385946
558835
459901
460024
485086
508273
516991
519016
524773
528439
532913
518940
538768
543777
543426
544463
578423
603549
470442
102235
415655
528181
499597
393076
419740
517779
521292
527425
519909
519911
543849
562355
579647
551259
631902
613177
406298
508662
498551
527767
513607
456518
507651
541998
558413
577435
584488
424385
429482
415540
424627
571027
571428
559959
587185
407597
526041
512059
590667
593499
476907
409001
512952
521141
507681
542594
632059
625001
643316
438896
472750
499852
573315
613487
612809
516842
]
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 (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?
)
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 (518393, 509100, 385946, 558835, 459901, 460024, 485086, 508273, 516991, 519016, 524773, 528439, 532913, 518940, 538768, 543777, 543426, 544463, 578423, 603549, 470442, 102235, 415655, 528181, 499597, 393076, 419740, 517779, 521292, 527425, 519909, 519911, 543849, 562355, 579647, 551259, 631902, 613177, 406298, 508662, 498551, 527767, 513607, 456518, 507651, 541998, 558413, 577435, 584488, 424385, 429482, 415540, 424627, 571027, 571428, 559959, 587185, 407597, 526041, 512059, 590667, 593499, 476907, 409001, 512952, 521141, 507681, 542594, 632059, 625001, 643316, 438896, 472750, 499852, 573315, 613487, 612809, 516842);
|
| 4 |
3.13 ms |
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
102235
385946
393076
406298
407597
409001
415540
415655
419740
424385
424627
429482
438896
456518
459901
460024
470442
472750
476907
485086
498551
499597
499852
507651
507681
508273
508662
509100
512059
512952
513607
516842
516991
517779
518393
518940
519016
519909
519911
521141
521292
524773
526041
527425
527767
528181
528439
532913
538768
541998
542594
543426
543777
543849
544463
551259
558413
558835
559959
562355
571027
571428
573315
577435
578423
579647
584488
587185
590667
593499
603549
612809
613177
613487
625001
631902
632059
643316
]
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 (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?
)
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 (102235, 385946, 393076, 406298, 407597, 409001, 415540, 415655, 419740, 424385, 424627, 429482, 438896, 456518, 459901, 460024, 470442, 472750, 476907, 485086, 498551, 499597, 499852, 507651, 507681, 508273, 508662, 509100, 512059, 512952, 513607, 516842, 516991, 517779, 518393, 518940, 519016, 519909, 519911, 521141, 521292, 524773, 526041, 527425, 527767, 528181, 528439, 532913, 538768, 541998, 542594, 543426, 543777, 543849, 544463, 551259, 558413, 558835, 559959, 562355, 571027, 571428, 573315, 577435, 578423, 579647, 584488, 587185, 590667, 593499, 603549, 612809, 613177, 613487, 625001, 631902, 632059, 643316);
|
| 5 |
101.05 ms |
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
102235
385946
393076
406298
407597
409001
415540
415655
419740
424385
424627
429482
438896
456518
459901
460024
470442
472750
476907
485086
498551
499597
499852
507651
507681
508273
508662
509100
512059
512952
513607
516842
516991
517779
518393
518940
519016
519909
519911
521141
521292
524773
526041
527425
527767
528181
528439
532913
538768
541998
542594
543426
543777
543849
544463
551259
558413
558835
559959
562355
571027
571428
573315
577435
578423
579647
584488
587185
590667
593499
603549
612809
613177
613487
625001
631902
632059
643316
]
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 (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?
)
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 (102235, 385946, 393076, 406298, 407597, 409001, 415540, 415655, 419740, 424385, 424627, 429482, 438896, 456518, 459901, 460024, 470442, 472750, 476907, 485086, 498551, 499597, 499852, 507651, 507681, 508273, 508662, 509100, 512059, 512952, 513607, 516842, 516991, 517779, 518393, 518940, 519016, 519909, 519911, 521141, 521292, 524773, 526041, 527425, 527767, 528181, 528439, 532913, 538768, 541998, 542594, 543426, 543777, 543849, 544463, 551259, 558413, 558835, 559959, 562355, 571027, 571428, 573315, 577435, 578423, 579647, 584488, 587185, 590667, 593499, 603549, 612809, 613177, 613487, 625001, 631902, 632059, 643316);
|