Query Metrics
7
Database Queries
7
Different statements
198.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.39 ms (76.26%) |
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 387437 422392 422429 425875 446118 454878 459699 462091 464604 465474 466113 467642 472765 473937 477398 479353 479856 483226 491704 496279 499018 500665 508078 511216 511217 511739 512286 513272 513318 520421 521017 522513 524002 526865 527851 528590 529061 530929 538368 540899 542447 549350 549472 549627 551523 559630 560966 562732 563834 566044 573115 573577 573655 573661 573677 573895 575075 575748 576055 579648 598754 601021 601251 601597 604822 607053 615713 618909 621695 622887 629878 636791 639328 645846 645948 658948 662723 663838 669725 670383 671891 672285 673874 677880 679367 679798 684052 686610 688521 692583 693371 695775 696273 704638 708157 712755 715973 716503 716693 719094 719225 721209 722714 726447 730762 733008 739471 740157 762195 765185 794811 807519 808192 810674 811148 817443 817950 820038 826070 827980 ] |
||||||||||||||||||||||||||||||
|
31.83 ms (16.03%) |
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 559630 679798 716693 573677 808192 387437 425875 473937 479353 479856 422392 446118 462091 464604 422429 454878 477398 459699 466113 472765 511216 511739 520421 491704 508078 511217 526865 527851 528590 540899 499018 512286 522513 538368 483226 513272 513318 521017 524002 726447 551523 562732 573655 670383 740157 467642 579648 575748 500665 817950 826070 820038 817443 827980 465474 496279 530929 529061 542447 549627 576055 549350 563834 573577 549472 573115 573661 658948 671891 673874 679367 686610 688521 708157 712755 719094 722714 645846 663838 669725 677880 684052 693371 695775 696273 719225 645948 662723 672285 692583 704638 715973 716503 721209 560966 566044 573895 575075 604822 607053 636791 601251 621695 639328 601021 615713 622887 598754 601597 618909 629878 807519 810674 794811 730762 739471 765185 811148 733008 762195 ] |
||||||||||||||||||||||||||||||
|
4.01 ms (2.02%) |
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 387437 422392 422429 425875 446118 454878 459699 462091 464604 465474 466113 467642 472765 473937 477398 479353 479856 483226 491704 496279 499018 500665 508078 511216 511217 511739 512286 513272 513318 520421 521017 522513 524002 526865 527851 528590 529061 530929 538368 540899 542447 549350 549472 549627 551523 559630 560966 562732 563834 566044 573115 573577 573655 573661 573677 573895 575075 575748 576055 579648 598754 601021 601251 601597 604822 607053 615713 618909 621695 622887 629878 636791 639328 645846 645948 658948 662723 663838 669725 670383 671891 672285 673874 677880 679367 679798 684052 686610 688521 692583 693371 695775 696273 704638 708157 712755 715973 716503 716693 719094 719225 721209 722714 726447 730762 733008 739471 740157 762195 765185 794811 807519 808192 810674 811148 817443 817950 820038 826070 827980 ] |
||||||||||||||||||||||||||||||
|
3.68 ms (1.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"porn большой большие член"
]
|
||||||||||||||||||||||||||||||
|
3.14 ms (1.58%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"porn big dick"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"porn большой большие член"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
No loaded entities.