Query Metrics
7
Database Queries
7
Different statements
143.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.67 ms (82.78%) |
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 261088 387545 388995 395839 417173 422453 425529 426823 427001 431740 452258 453514 456993 460038 460715 462116 473649 475541 480053 483175 483844 488730 490773 491588 495131 496510 506696 509797 510725 511182 514691 521179 521939 523716 524118 540187 540724 541713 550342 553788 561310 562257 562262 562288 562395 563653 564300 564806 567523 567828 571370 576216 577831 578958 582713 584685 584958 585930 586607 588568 589898 590478 590807 599472 599481 601218 602874 603792 603969 604137 605494 605928 606668 615466 615625 615936 617706 618528 622465 624941 625259 641649 644057 648762 650075 650280 650669 651794 673260 684672 691578 697400 709148 715395 739905 748158 748632 751725 755796 758699 761273 764179 766342 776248 784110 784564 785369 786420 788007 788144 797817 799414 801386 801772 803142 805254 807359 807464 809979 ] |
||||||||||||||||||||||||||||||
|
14.73 ms (10.27%) |
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 495131 511182 536850 567523 648762 651794 561310 625259 590807 605928 585930 599481 788007 788144 784110 797817 751725 739905 766342 622465 803142 475541 387545 422453 453514 417173 462116 540724 521179 521939 395839 456993 473649 540187 567828 550342 564300 577831 673260 562395 564806 582713 588568 617706 599472 776248 748632 618528 431740 261088 425529 460038 483844 488730 509797 541713 452258 483175 514691 584958 684672 691578 650669 697400 709148 590478 586607 615466 604137 644057 605494 615625 755796 784564 799414 809979 761273 758699 764179 785369 786420 807464 427001 426823 460715 510725 490773 388995 491588 523716 496510 524118 506696 480053 562257 578958 584685 562262 571370 576216 715395 650075 650280 553788 562288 563653 589898 615936 624941 601218 606668 641649 603969 602874 603792 801386 805254 807359 801772 748158 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.86%) |
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 261088 387545 388995 395839 417173 422453 425529 426823 427001 431740 452258 453514 456993 460038 460715 462116 473649 475541 480053 483175 483844 488730 490773 491588 495131 496510 506696 509797 510725 511182 514691 521179 521939 523716 524118 540187 540724 541713 550342 553788 561310 562257 562262 562288 562395 563653 564300 564806 567523 567828 571370 576216 577831 578958 582713 584685 584958 585930 586607 588568 589898 590478 590807 599472 599481 601218 602874 603792 603969 604137 605494 605928 606668 615466 615625 615936 617706 618528 622465 624941 625259 641649 644057 648762 650075 650280 650669 651794 673260 684672 691578 697400 709148 715395 739905 748158 748632 751725 755796 758699 761273 764179 766342 776248 784110 784564 785369 786420 788007 788144 797817 799414 801386 801772 803142 805254 807359 807464 809979 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"student girl"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"student девушк"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"student девушк"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.99%) |
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.