100.70 ms (79.83%)
|
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
416128
419628
431975
438898
451521
453694
454354
457372
457853
458578
458601
458602
459944
460600
461904
468044
468965
468990
469116
470028
472454
474020
477579
483506
487262
489298
489301
489330
491599
491963
493980
494266
496718
504787
506023
506552
509292
514110
514916
516782
516794
517392
517417
517596
517599
524029
524284
524327
524543
524859
527005
527152
528053
531187
538170
540549
542784
555885
555979
565923
571680
571696
573354
582229
583335
583964
591155
591338
591929
593689
595601
598334
598915
604050
611339
617167
625093
626015
639060
666869
672887
687544
698933
]
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 (416128, 419628, 431975, 438898, 451521, 453694, 454354, 457372, 457853, 458578, 458601, 458602, 459944, 460600, 461904, 468044, 468965, 468990, 469116, 470028, 472454, 474020, 477579, 483506, 487262, 489298, 489301, 489330, 491599, 491963, 493980, 494266, 496718, 504787, 506023, 506552, 509292, 514110, 514916, 516782, 516794, 517392, 517417, 517596, 517599, 524029, 524284, 524327, 524543, 524859, 527005, 527152, 528053, 531187, 538170, 540549, 542784, 555885, 555979, 565923, 571680, 571696, 573354, 582229, 583335, 583964, 591155, 591338, 591929, 593689, 595601, 598334, 598915, 604050, 611339, 617167, 625093, 626015, 639060, 666869, 672887, 687544, 698933);
|
14.49 ms (11.48%)
|
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
458602
493980
489298
458578
477579
538170
555979
591338
487262
527152
626015
504787
595601
457372
582229
454354
591155
517417
416128
458601
506552
666869
517392
494266
591929
474020
524859
514916
453694
491599
687544
672887
565923
598334
459944
514110
472454
528053
524327
555885
457853
509292
625093
506023
571696
460600
524543
517599
489301
469116
527005
431975
483506
489330
438898
517596
573354
540549
604050
524029
451521
496718
524284
516794
470028
468044
468990
461904
542784
491963
516782
698933
468965
598915
583335
571680
583964
593689
611339
617167
531187
639060
419628
]
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 (458602, 493980, 489298, 458578, 477579, 538170, 555979, 591338, 487262, 527152, 626015, 504787, 595601, 457372, 582229, 454354, 591155, 517417, 416128, 458601, 506552, 666869, 517392, 494266, 591929, 474020, 524859, 514916, 453694, 491599, 687544, 672887, 565923, 598334, 459944, 514110, 472454, 528053, 524327, 555885, 457853, 509292, 625093, 506023, 571696, 460600, 524543, 517599, 489301, 469116, 527005, 431975, 483506, 489330, 438898, 517596, 573354, 540549, 604050, 524029, 451521, 496718, 524284, 516794, 470028, 468044, 468990, 461904, 542784, 491963, 516782, 698933, 468965, 598915, 583335, 571680, 583964, 593689, 611339, 617167, 531187, 639060, 419628);
|
2.09 ms (1.66%)
|
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
416128
419628
431975
438898
451521
453694
454354
457372
457853
458578
458601
458602
459944
460600
461904
468044
468965
468990
469116
470028
472454
474020
477579
483506
487262
489298
489301
489330
491599
491963
493980
494266
496718
504787
506023
506552
509292
514110
514916
516782
516794
517392
517417
517596
517599
524029
524284
524327
524543
524859
527005
527152
528053
531187
538170
540549
542784
555885
555979
565923
571680
571696
573354
582229
583335
583964
591155
591338
591929
593689
595601
598334
598915
604050
611339
617167
625093
626015
639060
666869
672887
687544
698933
]
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 (416128, 419628, 431975, 438898, 451521, 453694, 454354, 457372, 457853, 458578, 458601, 458602, 459944, 460600, 461904, 468044, 468965, 468990, 469116, 470028, 472454, 474020, 477579, 483506, 487262, 489298, 489301, 489330, 491599, 491963, 493980, 494266, 496718, 504787, 506023, 506552, 509292, 514110, 514916, 516782, 516794, 517392, 517417, 517596, 517599, 524029, 524284, 524327, 524543, 524859, 527005, 527152, 528053, 531187, 538170, 540549, 542784, 555885, 555979, 565923, 571680, 571696, 573354, 582229, 583335, 583964, 591155, 591338, 591929, 593689, 595601, 598334, 598915, 604050, 611339, 617167, 625093, 626015, 639060, 666869, 672887, 687544, 698933);
|