Query Metrics
7
Database Queries
7
Different statements
159.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.67 ms (83.24%) |
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 383019 410075 429264 438828 441971 446121 455106 459655 461002 462044 483880 486752 487387 487741 489800 490160 494281 502377 508865 511257 513101 517387 520210 526209 528505 534785 534812 541544 550911 561409 563644 567415 568567 575149 581910 585652 601130 601391 602345 602365 605410 606316 609516 611782 619350 625617 625707 627717 632798 634432 644020 646682 646902 654239 654494 654602 654819 655077 656042 656316 656603 657312 657376 659113 660570 665253 665423 666647 667312 669692 686996 689570 689572 693160 696343 696432 698088 698819 699415 700844 703941 705398 709427 713288 714434 715669 721953 721954 721985 723659 725861 725943 725979 726917 729569 731412 732191 732883 734105 737933 741580 743434 743654 745520 746468 748768 753247 753900 753988 756766 757044 757210 761138 761830 768437 777909 817845 820666 821794 825556 ] |
||||||||||||||||||||||||||||||
|
15.56 ms (9.76%) |
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 725861 726917 753247 753988 737933 743654 753900 606316 625617 699415 666647 713288 383019 438828 429264 511257 656603 693160 709427 825556 568567 563644 654239 705398 656316 734105 748768 746468 757210 698088 654819 489800 502377 520210 490160 517387 696432 714434 494281 446121 462044 821794 550911 667312 634432 602345 721954 817845 820666 723659 561409 541544 575149 646682 655077 656042 659113 669692 689570 696343 657312 686996 703941 715669 646902 665423 567415 601391 602365 611782 619350 585652 632798 609516 625707 627717 725979 729569 743434 761138 768437 732883 741580 745520 732191 731412 757044 761830 644020 721985 461002 455106 410075 508865 513101 654494 581910 660570 689572 698819 700844 721953 601130 605410 756766 725943 777909 459655 665253 654602 657376 441971 483880 486752 487387 526209 528505 534785 534812 487741 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (1.97%) |
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 383019 410075 429264 438828 441971 446121 455106 459655 461002 462044 483880 486752 487387 487741 489800 490160 494281 502377 508865 511257 513101 517387 520210 526209 528505 534785 534812 541544 550911 561409 563644 567415 568567 575149 581910 585652 601130 601391 602345 602365 605410 606316 609516 611782 619350 625617 625707 627717 632798 634432 644020 646682 646902 654239 654494 654602 654819 655077 656042 656316 656603 657312 657376 659113 660570 665253 665423 666647 667312 669692 686996 689570 689572 693160 696343 696432 698088 698819 699415 700844 703941 705398 709427 713288 714434 715669 721953 721954 721985 723659 725861 725943 725979 726917 729569 731412 732191 732883 734105 737933 741580 743434 743654 745520 746468 748768 753247 753900 753988 756766 757044 757210 761138 761830 768437 777909 817845 820666 821794 825556 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big dick stranger"
]
|
||||||||||||||||||||||||||||||
|
2.13 ms (1.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большой большие член stranger"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большой большие член stranger"
]
|
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.