Query Metrics
7
Database Queries
7
Different statements
191.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.11 ms (87.94%) |
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 386621 398747 490125 533162 535545 540701 545282 546798 549545 555555 557141 570677 591184 592097 615396 627623 632441 632938 634948 644026 650954 651911 657745 669130 671221 678228 687120 687175 688319 689068 696299 696958 697224 700775 705807 710209 713141 713493 713785 714507 719321 719677 720502 726267 726755 729918 730356 730719 731304 731792 735394 736608 737135 739095 739115 740208 740272 743550 745553 748880 749014 749373 753429 754630 754864 757654 759571 760256 763424 763787 764623 764861 765345 766273 769199 771437 777565 778484 780842 781362 781538 781639 783699 785232 787045 788383 789060 791671 792417 792462 794967 796492 797357 797837 798519 798864 799670 800942 801511 801512 804816 805072 809769 811239 812438 813446 816181 817847 817941 817969 818434 819083 820736 820860 822533 823407 824231 824508 826745 828373 ] |
||||||||||||||||||||||||||||||
|
12.49 ms (6.53%) |
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 787045 797357 798519 816181 818434 820860 533162 545282 719321 710209 713141 651911 549545 797837 809769 737135 781362 781538 781639 736608 766273 726755 780842 801512 557141 688319 546798 817969 555555 650954 687175 669130 678228 720502 778484 792462 764623 644026 777565 824231 819083 824508 540701 535545 689068 657745 671221 615396 591184 632441 592097 794967 754630 743550 745553 739115 763787 813446 386621 817941 817847 696958 697224 687120 705807 713493 713785 719677 799670 726267 729918 731792 749014 759571 811239 754864 764861 763424 749373 714507 788383 804816 812438 398747 822533 823407 826745 820736 828373 490125 570677 696299 627623 785232 791671 800942 796492 798864 730719 735394 765345 769199 783699 792417 801511 805072 731304 739095 740208 748880 760256 740272 753429 757654 730356 771437 632938 634948 789060 700775 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (1.61%) |
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 386621 398747 490125 533162 535545 540701 545282 546798 549545 555555 557141 570677 591184 592097 615396 627623 632441 632938 634948 644026 650954 651911 657745 669130 671221 678228 687120 687175 688319 689068 696299 696958 697224 700775 705807 710209 713141 713493 713785 714507 719321 719677 720502 726267 726755 729918 730356 730719 731304 731792 735394 736608 737135 739095 739115 740208 740272 743550 745553 748880 749014 749373 753429 754630 754864 757654 759571 760256 763424 763787 764623 764861 765345 766273 769199 771437 777565 778484 780842 781362 781538 781639 783699 785232 787045 788383 789060 791671 792417 792462 794967 796492 797357 797837 798519 798864 799670 800942 801511 801512 804816 805072 809769 811239 812438 813446 816181 817847 817941 817969 818434 819083 820736 820860 822533 823407 824231 824508 826745 828373 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex room"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс room"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс room"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.