Query Metrics
7
Database Queries
7
Different statements
191.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.05 ms (88.06%) |
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 386493 396925 396988 399691 403476 409252 411693 413516 421543 425646 435535 436942 446756 451514 453804 458988 460145 460503 461213 461240 462224 474860 475556 476073 492137 492276 492714 504666 505538 509114 509408 513188 515377 517299 517332 517805 519175 521722 531325 532817 534276 534837 537464 543428 553062 554544 555448 559601 562974 564558 568381 568452 568474 568985 569035 569116 569126 569149 569530 569539 569545 570146 578456 578858 583515 585370 585959 591087 603417 604213 604908 607481 607691 610066 613825 616448 616700 625220 629619 638688 652760 663566 667942 672842 673121 675654 686185 697766 701566 704153 709450 712682 714925 716201 717645 725624 732990 733645 739089 760755 760980 761066 778986 795137 795983 796150 796793 796805 796919 800042 803035 803148 810465 812768 814092 816211 819268 819777 820956 823456 ] |
||||||||||||||||||||||||||||||
|
13.85 ms (7.21%) |
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 652760 796150 760980 532817 513188 559601 460503 760755 800042 819777 819268 476073 509114 531325 492276 569035 570146 701566 709450 717645 712682 585370 591087 796793 803035 725624 732990 778986 396988 820956 446756 462224 534276 537464 583515 562974 564558 569530 578858 604213 733645 409252 413516 451514 436942 517299 517805 505538 519175 814092 795137 399691 403476 816211 474860 453804 460145 521722 509408 553062 569116 543428 663566 672842 704153 555448 568474 569539 604908 616700 607481 625220 603417 607691 616448 629619 638688 795983 796805 796919 803148 810465 812768 739089 610066 613825 697766 396925 411693 515377 568381 569149 716201 673121 667942 761066 461240 568985 475556 492714 421543 425646 435535 823456 458988 492137 534837 504666 461213 554544 569545 675654 714925 568452 517332 578456 686185 569126 585959 386493 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.41%) |
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 386493 396925 396988 399691 403476 409252 411693 413516 421543 425646 435535 436942 446756 451514 453804 458988 460145 460503 461213 461240 462224 474860 475556 476073 492137 492276 492714 504666 505538 509114 509408 513188 515377 517299 517332 517805 519175 521722 531325 532817 534276 534837 537464 543428 553062 554544 555448 559601 562974 564558 568381 568452 568474 568985 569035 569116 569126 569149 569530 569539 569545 570146 578456 578858 583515 585370 585959 591087 603417 604213 604908 607481 607691 610066 613825 616448 616700 625220 629619 638688 652760 663566 667942 672842 673121 675654 686185 697766 701566 704153 709450 712682 714925 716201 717645 725624 732990 733645 739089 760755 760980 761066 778986 795137 795983 796150 796793 796805 796919 800042 803035 803148 810465 812768 814092 816211 819268 819777 820956 823456 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dirty ass milf"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"dirty жоп milf"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"dirty жоп milf"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.70%) |
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.