| 3 |
16.25 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
482024
522735
799747
420362
501170
525396
566295
619455
806430
62010
502378
486619
511320
464721
460514
392981
427553
449261
588716
454241
486004
799739
700670
600382
809466
445742
502663
718821
438725
463072
516669
595061
784493
481173
460066
425472
398949
472113
439534
449320
445803
448793
533949
496086
515578
411227
447890
529438
510843
418879
521173
537247
641983
423893
508838
693778
467721
769448
678662
534376
743641
548226
507285
403373
505132
562763
639258
628277
625437
584809
612414
599967
748684
425625
]
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 (482024, 522735, 799747, 420362, 501170, 525396, 566295, 619455, 806430, 62010, 502378, 486619, 511320, 464721, 460514, 392981, 427553, 449261, 588716, 454241, 486004, 799739, 700670, 600382, 809466, 445742, 502663, 718821, 438725, 463072, 516669, 595061, 784493, 481173, 460066, 425472, 398949, 472113, 439534, 449320, 445803, 448793, 533949, 496086, 515578, 411227, 447890, 529438, 510843, 418879, 521173, 537247, 641983, 423893, 508838, 693778, 467721, 769448, 678662, 534376, 743641, 548226, 507285, 403373, 505132, 562763, 639258, 628277, 625437, 584809, 612414, 599967, 748684, 425625);
|
| 4 |
3.43 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
62010
392981
398949
403373
411227
418879
420362
423893
425472
425625
427553
438725
439534
445742
445803
447890
448793
449261
449320
454241
460066
460514
463072
464721
467721
472113
481173
482024
486004
486619
496086
501170
502378
502663
505132
507285
508838
510843
511320
515578
516669
521173
522735
525396
529438
533949
534376
537247
548226
562763
566295
584809
588716
595061
599967
600382
612414
619455
625437
628277
639258
641983
678662
693778
700670
718821
743641
748684
769448
784493
799739
799747
806430
809466
]
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 (62010, 392981, 398949, 403373, 411227, 418879, 420362, 423893, 425472, 425625, 427553, 438725, 439534, 445742, 445803, 447890, 448793, 449261, 449320, 454241, 460066, 460514, 463072, 464721, 467721, 472113, 481173, 482024, 486004, 486619, 496086, 501170, 502378, 502663, 505132, 507285, 508838, 510843, 511320, 515578, 516669, 521173, 522735, 525396, 529438, 533949, 534376, 537247, 548226, 562763, 566295, 584809, 588716, 595061, 599967, 600382, 612414, 619455, 625437, 628277, 639258, 641983, 678662, 693778, 700670, 718821, 743641, 748684, 769448, 784493, 799739, 799747, 806430, 809466);
|
| 5 |
314.77 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
62010
392981
398949
403373
411227
418879
420362
423893
425472
425625
427553
438725
439534
445742
445803
447890
448793
449261
449320
454241
460066
460514
463072
464721
467721
472113
481173
482024
486004
486619
496086
501170
502378
502663
505132
507285
508838
510843
511320
515578
516669
521173
522735
525396
529438
533949
534376
537247
548226
562763
566295
584809
588716
595061
599967
600382
612414
619455
625437
628277
639258
641983
678662
693778
700670
718821
743641
748684
769448
784493
799739
799747
806430
809466
]
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 (62010, 392981, 398949, 403373, 411227, 418879, 420362, 423893, 425472, 425625, 427553, 438725, 439534, 445742, 445803, 447890, 448793, 449261, 449320, 454241, 460066, 460514, 463072, 464721, 467721, 472113, 481173, 482024, 486004, 486619, 496086, 501170, 502378, 502663, 505132, 507285, 508838, 510843, 511320, 515578, 516669, 521173, 522735, 525396, 529438, 533949, 534376, 537247, 548226, 562763, 566295, 584809, 588716, 595061, 599967, 600382, 612414, 619455, 625437, 628277, 639258, 641983, 678662, 693778, 700670, 718821, 743641, 748684, 769448, 784493, 799739, 799747, 806430, 809466);
|