130.82 ms (35.35%)
|
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
420206
423893
435800
447890
455195
463134
464365
469193
472531
485059
486102
490496
490508
498817
501641
503617
504895
508438
511231
512538
512851
513098
513573
514640
522985
524301
525058
526203
529229
530757
537207
543659
549569
552458
552940
557039
559155
559725
559989
560195
564647
565243
567066
567757
567837
569929
577699
582277
586554
589107
590493
591176
597028
597491
598190
599545
599967
601322
601485
601886
603124
605845
605865
606036
608771
609604
610046
618424
619110
621520
621643
625729
628277
633312
639258
641983
652236
652931
660306
661565
662020
675588
702927
814903
]
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 (420206, 423893, 435800, 447890, 455195, 463134, 464365, 469193, 472531, 485059, 486102, 490496, 490508, 498817, 501641, 503617, 504895, 508438, 511231, 512538, 512851, 513098, 513573, 514640, 522985, 524301, 525058, 526203, 529229, 530757, 537207, 543659, 549569, 552458, 552940, 557039, 559155, 559725, 559989, 560195, 564647, 565243, 567066, 567757, 567837, 569929, 577699, 582277, 586554, 589107, 590493, 591176, 597028, 597491, 598190, 599545, 599967, 601322, 601485, 601886, 603124, 605845, 605865, 606036, 608771, 609604, 610046, 618424, 619110, 621520, 621643, 625729, 628277, 633312, 639258, 641983, 652236, 652931, 660306, 661565, 662020, 675588, 702927, 814903);
|
19.19 ms (5.18%)
|
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
565243
567066
702927
559989
598190
601322
606036
609604
625729
633312
420206
435800
447890
463134
485059
508438
512851
522985
513098
524301
605845
464365
530757
504895
529229
552940
564647
560195
549569
552458
577699
641983
597028
423893
469193
472531
501641
490496
498817
525058
814903
537207
567757
675588
586554
589107
513573
503617
490508
569929
567837
619110
603124
618424
455195
512538
514640
543659
559155
559725
652236
652931
660306
662020
557039
582277
605865
639258
601485
621643
628277
601886
597491
599545
486102
511231
590493
621520
599967
591176
608771
661565
610046
526203
]
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 (565243, 567066, 702927, 559989, 598190, 601322, 606036, 609604, 625729, 633312, 420206, 435800, 447890, 463134, 485059, 508438, 512851, 522985, 513098, 524301, 605845, 464365, 530757, 504895, 529229, 552940, 564647, 560195, 549569, 552458, 577699, 641983, 597028, 423893, 469193, 472531, 501641, 490496, 498817, 525058, 814903, 537207, 567757, 675588, 586554, 589107, 513573, 503617, 490508, 569929, 567837, 619110, 603124, 618424, 455195, 512538, 514640, 543659, 559155, 559725, 652236, 652931, 660306, 662020, 557039, 582277, 605865, 639258, 601485, 621643, 628277, 601886, 597491, 599545, 486102, 511231, 590493, 621520, 599967, 591176, 608771, 661565, 610046, 526203);
|
2.60 ms (0.70%)
|
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
420206
423893
435800
447890
455195
463134
464365
469193
472531
485059
486102
490496
490508
498817
501641
503617
504895
508438
511231
512538
512851
513098
513573
514640
522985
524301
525058
526203
529229
530757
537207
543659
549569
552458
552940
557039
559155
559725
559989
560195
564647
565243
567066
567757
567837
569929
577699
582277
586554
589107
590493
591176
597028
597491
598190
599545
599967
601322
601485
601886
603124
605845
605865
606036
608771
609604
610046
618424
619110
621520
621643
625729
628277
633312
639258
641983
652236
652931
660306
661565
662020
675588
702927
814903
]
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 (420206, 423893, 435800, 447890, 455195, 463134, 464365, 469193, 472531, 485059, 486102, 490496, 490508, 498817, 501641, 503617, 504895, 508438, 511231, 512538, 512851, 513098, 513573, 514640, 522985, 524301, 525058, 526203, 529229, 530757, 537207, 543659, 549569, 552458, 552940, 557039, 559155, 559725, 559989, 560195, 564647, 565243, 567066, 567757, 567837, 569929, 577699, 582277, 586554, 589107, 590493, 591176, 597028, 597491, 598190, 599545, 599967, 601322, 601485, 601886, 603124, 605845, 605865, 606036, 608771, 609604, 610046, 618424, 619110, 621520, 621643, 625729, 628277, 633312, 639258, 641983, 652236, 652931, 660306, 661565, 662020, 675588, 702927, 814903);
|