| 3 |
15.74 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
564112
578680
615851
588299
595805
623334
687484
536655
471125
486616
556426
580094
663507
564690
615735
615711
508277
476308
554839
643364
433170
527062
491353
478811
505688
516661
553927
565095
572038
543440
635222
600411
590437
595226
619508
468717
496802
562059
676591
612335
448333
520793
561381
554308
571308
593032
522556
527989
540562
534320
483709
691196
489243
583913
671348
671893
590515
460738
598648
626336
519367
577437
581433
518131
550571
580775
516335
604555
635783
606533
517301
537251
504085
517326
]
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 (564112, 578680, 615851, 588299, 595805, 623334, 687484, 536655, 471125, 486616, 556426, 580094, 663507, 564690, 615735, 615711, 508277, 476308, 554839, 643364, 433170, 527062, 491353, 478811, 505688, 516661, 553927, 565095, 572038, 543440, 635222, 600411, 590437, 595226, 619508, 468717, 496802, 562059, 676591, 612335, 448333, 520793, 561381, 554308, 571308, 593032, 522556, 527989, 540562, 534320, 483709, 691196, 489243, 583913, 671348, 671893, 590515, 460738, 598648, 626336, 519367, 577437, 581433, 518131, 550571, 580775, 516335, 604555, 635783, 606533, 517301, 537251, 504085, 517326);
|
| 4 |
2.64 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
433170
448333
460738
468717
471125
476308
478811
483709
486616
489243
491353
496802
504085
505688
508277
516335
516661
517301
517326
518131
519367
520793
522556
527062
527989
534320
536655
537251
540562
543440
550571
553927
554308
554839
556426
561381
562059
564112
564690
565095
571308
572038
577437
578680
580094
580775
581433
583913
588299
590437
590515
593032
595226
595805
598648
600411
604555
606533
612335
615711
615735
615851
619508
623334
626336
635222
635783
643364
663507
671348
671893
676591
687484
691196
]
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 (433170, 448333, 460738, 468717, 471125, 476308, 478811, 483709, 486616, 489243, 491353, 496802, 504085, 505688, 508277, 516335, 516661, 517301, 517326, 518131, 519367, 520793, 522556, 527062, 527989, 534320, 536655, 537251, 540562, 543440, 550571, 553927, 554308, 554839, 556426, 561381, 562059, 564112, 564690, 565095, 571308, 572038, 577437, 578680, 580094, 580775, 581433, 583913, 588299, 590437, 590515, 593032, 595226, 595805, 598648, 600411, 604555, 606533, 612335, 615711, 615735, 615851, 619508, 623334, 626336, 635222, 635783, 643364, 663507, 671348, 671893, 676591, 687484, 691196);
|
| 5 |
115.97 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
433170
448333
460738
468717
471125
476308
478811
483709
486616
489243
491353
496802
504085
505688
508277
516335
516661
517301
517326
518131
519367
520793
522556
527062
527989
534320
536655
537251
540562
543440
550571
553927
554308
554839
556426
561381
562059
564112
564690
565095
571308
572038
577437
578680
580094
580775
581433
583913
588299
590437
590515
593032
595226
595805
598648
600411
604555
606533
612335
615711
615735
615851
619508
623334
626336
635222
635783
643364
663507
671348
671893
676591
687484
691196
]
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 (433170, 448333, 460738, 468717, 471125, 476308, 478811, 483709, 486616, 489243, 491353, 496802, 504085, 505688, 508277, 516335, 516661, 517301, 517326, 518131, 519367, 520793, 522556, 527062, 527989, 534320, 536655, 537251, 540562, 543440, 550571, 553927, 554308, 554839, 556426, 561381, 562059, 564112, 564690, 565095, 571308, 572038, 577437, 578680, 580094, 580775, 581433, 583913, 588299, 590437, 590515, 593032, 595226, 595805, 598648, 600411, 604555, 606533, 612335, 615711, 615735, 615851, 619508, 623334, 626336, 635222, 635783, 643364, 663507, 671348, 671893, 676591, 687484, 691196);
|