Query Metrics
7
Database Queries
7
Different statements
165.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.91 ms (87.43%) |
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 12270 172688 337264 385709 389774 390334 413216 459556 459658 509412 556300 560103 570033 592238 593215 597615 598754 600188 611702 613651 615083 616579 616965 617173 622954 624360 626041 631124 631410 637904 638106 639376 639378 641769 642172 642624 642634 642797 643644 650964 653268 654124 670003 696703 701158 718703 719090 719302 719718 721338 721680 721961 725128 726908 727152 728292 728871 729153 729315 729966 730455 731585 732065 733187 733774 734788 735354 735491 735622 736264 736939 737501 737590 737969 739029 739177 739205 740518 742157 742944 743408 743986 744761 744762 745014 746772 747403 748764 749144 752779 753327 753430 755044 755318 755739 757088 758009 758087 758121 758218 758462 758604 759479 762689 762836 763090 763321 798626 799312 800892 801857 804126 805489 807794 809106 812079 812091 821165 ] |
||||||||||||||||||||||||||||||
|
11.47 ms (6.92%) |
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 616965 634610 641769 642624 597615 615083 622954 624360 639376 639378 642634 642797 611702 616579 617173 637904 592238 593215 600188 631124 631410 638106 642172 643644 799312 800892 809106 798626 725128 730455 733774 734788 737501 737590 739205 742157 747403 752779 755739 757088 758462 758948 762836 763090 804126 805489 807794 812091 729315 729966 731585 735622 736939 744761 744762 753327 726908 728292 729153 735354 736264 739177 740518 745014 746772 748764 755044 758604 762689 732065 733187 735491 737969 742944 743986 753430 758009 758087 758121 759479 763321 727152 728871 739029 743408 749144 758218 696703 701158 719090 719718 721961 801857 812079 337264 12270 172688 390334 821165 459658 459556 650964 755318 389774 413216 385709 509412 556300 560103 654124 670003 721338 653268 718703 719302 721680 570033 598754 613651 626041 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.57%) |
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 12270 172688 337264 385709 389774 390334 413216 459556 459658 509412 556300 560103 570033 592238 593215 597615 598754 600188 611702 613651 615083 616579 616965 617173 622954 624360 626041 631124 631410 637904 638106 639376 639378 641769 642172 642624 642634 642797 643644 650964 653268 654124 670003 696703 701158 718703 719090 719302 719718 721338 721680 721961 725128 726908 727152 728292 728871 729153 729315 729966 730455 731585 732065 733187 733774 734788 735354 735491 735622 736264 736939 737501 737590 737969 739029 739177 739205 740518 742157 742944 743408 743986 744761 744762 745014 746772 747403 748764 749144 752779 753327 753430 755044 755318 755739 757088 758009 758087 758121 758218 758462 758604 759479 762689 762836 763090 763321 798626 799312 800892 801857 804126 805489 807794 809106 812079 812091 821165 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big brunette"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие черноволосая"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие черноволосая"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.89%) |
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.