Query Metrics
7
Database Queries
7
Different statements
593.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.53 ms (36.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая большие toys"
]
|
||||||||||||||||||||||||||||||
|
208.58 ms (35.14%) |
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 32030 159036 190204 209385 256218 381921 383527 385653 387047 390644 391384 396057 400195 400971 404739 407763 409795 411643 411808 415197 415200 415946 416706 418692 420171 420200 420385 423736 423933 432724 434849 447509 449020 457171 460187 463159 465645 470058 471105 471107 472543 478510 479009 479997 480760 482622 485797 497103 509079 513220 515275 515979 517038 517740 531789 534169 548515 550681 556331 558668 566031 568477 575610 576868 578292 579271 582443 584338 585995 588037 602608 606636 615296 618687 620220 624220 624229 626746 629851 633465 640785 643005 643194 644311 651851 654898 669756 681785 684701 691598 698972 700996 707844 713027 717862 720701 721831 722623 722625 724147 727939 740833 741531 743178 744520 755954 758226 760615 766646 774287 776280 785357 795149 803454 807595 811643 814049 817191 819978 821139 ] |
||||||||||||||||||||||||||||||
|
147.92 ms (24.92%) |
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 32030 159036 190204 209385 256218 381921 383527 385653 387047 390644 391384 396057 400195 400971 404739 407763 409795 411643 411808 415197 415200 415946 416706 418692 420171 420200 420385 423736 423933 432724 434849 447509 449020 457171 460187 463159 465645 470058 471105 471107 472543 478510 479009 479997 480760 482622 485797 497103 509079 513220 515275 515979 517038 517740 531789 534169 548515 550681 556331 558668 566031 568477 575610 576868 578292 579271 582443 584338 585995 588037 602608 606636 615296 618687 620220 624220 624229 626746 629851 633465 640785 643005 643194 644311 651851 654898 669756 681785 684701 691598 698972 700996 707844 713027 717862 720701 721831 722623 722625 724147 727939 740833 741531 743178 744520 755954 758226 760615 766646 774287 776280 785357 795149 803454 807595 811643 814049 817191 819978 821139 ] |
||||||||||||||||||||||||||||||
|
15.51 ms (2.61%) |
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 423933 517038 575610 568477 698972 669756 713027 558668 626746 776280 743178 760615 766646 624220 720701 566031 383527 418692 420200 423736 479997 515275 681785 691598 717862 651851 582443 606636 629851 774287 740833 785357 256218 420171 509079 548515 387047 409795 457171 449020 531789 556331 579271 585995 807595 795149 633465 390644 432724 396057 479009 534169 700996 618687 727939 32030 817191 819978 460187 470058 472543 517740 615296 643194 811643 209385 391384 415200 416706 550681 684701 707844 654898 722623 624229 602608 588037 620220 643005 644311 755954 744520 724147 741531 722625 803454 471107 420385 515979 482622 407763 485797 513220 578292 640785 758226 404739 463159 434849 400195 385653 447509 190204 471105 821139 584338 159036 400971 576868 721831 381921 411808 415946 411643 415197 814049 480760 465645 478510 497103 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"беловолосая большие toys"
]
|
||||||||||||||||||||||||||||||
|
2.19 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde big toys"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.26%) |
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.