| 3 |
13.56 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
513098
567837
455195
537209
565243
601322
609604
597491
460066
458384
456790
572338
624805
612507
448293
487583
660306
560195
525058
435207
529420
565201
559989
625729
478946
502974
530757
472531
501641
599545
504895
469193
447240
529556
490496
559155
557039
601886
641983
453522
447890
455729
512851
464365
617633
423893
537207
603124
531407
427182
519556
696499
548226
598172
619110
623116
528040
543659
486102
511231
652236
652931
605865
426551
610046
601485
621643
628277
661565
590493
608771
621520
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 (513098, 567837, 455195, 537209, 565243, 601322, 609604, 597491, 460066, 458384, 456790, 572338, 624805, 612507, 448293, 487583, 660306, 560195, 525058, 435207, 529420, 565201, 559989, 625729, 478946, 502974, 530757, 472531, 501641, 599545, 504895, 469193, 447240, 529556, 490496, 559155, 557039, 601886, 641983, 453522, 447890, 455729, 512851, 464365, 617633, 423893, 537207, 603124, 531407, 427182, 519556, 696499, 548226, 598172, 619110, 623116, 528040, 543659, 486102, 511231, 652236, 652931, 605865, 426551, 610046, 601485, 621643, 628277, 661565, 590493, 608771, 621520, 526203);
|
| 4 |
2.98 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
423893
426551
427182
435207
447240
447890
448293
453522
455195
455729
456790
458384
460066
464365
469193
472531
478946
486102
487583
490496
501641
502974
504895
511231
512851
513098
519556
525058
526203
528040
529420
529556
530757
531407
537207
537209
543659
548226
557039
559155
559989
560195
565201
565243
567837
572338
590493
597491
598172
599545
601322
601485
601886
603124
605865
608771
609604
610046
612507
617633
619110
621520
621643
623116
624805
625729
628277
641983
652236
652931
660306
661565
696499
]
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 (423893, 426551, 427182, 435207, 447240, 447890, 448293, 453522, 455195, 455729, 456790, 458384, 460066, 464365, 469193, 472531, 478946, 486102, 487583, 490496, 501641, 502974, 504895, 511231, 512851, 513098, 519556, 525058, 526203, 528040, 529420, 529556, 530757, 531407, 537207, 537209, 543659, 548226, 557039, 559155, 559989, 560195, 565201, 565243, 567837, 572338, 590493, 597491, 598172, 599545, 601322, 601485, 601886, 603124, 605865, 608771, 609604, 610046, 612507, 617633, 619110, 621520, 621643, 623116, 624805, 625729, 628277, 641983, 652236, 652931, 660306, 661565, 696499);
|
| 5 |
106.41 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
423893
426551
427182
435207
447240
447890
448293
453522
455195
455729
456790
458384
460066
464365
469193
472531
478946
486102
487583
490496
501641
502974
504895
511231
512851
513098
519556
525058
526203
528040
529420
529556
530757
531407
537207
537209
543659
548226
557039
559155
559989
560195
565201
565243
567837
572338
590493
597491
598172
599545
601322
601485
601886
603124
605865
608771
609604
610046
612507
617633
619110
621520
621643
623116
624805
625729
628277
641983
652236
652931
660306
661565
696499
]
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 (423893, 426551, 427182, 435207, 447240, 447890, 448293, 453522, 455195, 455729, 456790, 458384, 460066, 464365, 469193, 472531, 478946, 486102, 487583, 490496, 501641, 502974, 504895, 511231, 512851, 513098, 519556, 525058, 526203, 528040, 529420, 529556, 530757, 531407, 537207, 537209, 543659, 548226, 557039, 559155, 559989, 560195, 565201, 565243, 567837, 572338, 590493, 597491, 598172, 599545, 601322, 601485, 601886, 603124, 605865, 608771, 609604, 610046, 612507, 617633, 619110, 621520, 621643, 623116, 624805, 625729, 628277, 641983, 652236, 652931, 660306, 661565, 696499);
|