Query Metrics
7
Database Queries
7
Different statements
149.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.57 ms (83.55%) |
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 400885 404071 408810 462905 464619 469193 486144 528624 537552 549292 564210 569857 572210 587502 612460 656957 662896 663433 679309 686088 693432 697719 699703 718557 721251 723966 724434 728886 729989 730651 731230 733223 733280 734351 734369 740064 742456 744156 744814 744826 745901 747490 750607 756313 758620 759794 761253 761480 766552 767331 767560 772572 772599 773349 773357 773376 775568 775644 775659 780291 782765 782768 790027 791789 792218 792295 792305 793317 793675 793806 794146 795668 800017 800058 800078 801189 802391 802428 804395 806286 810861 811722 812323 815766 816397 817675 819014 819388 819445 819986 820315 823748 823860 824085 824693 824826 824956 825153 825158 825775 826079 826169 826380 826381 826382 826408 826456 826541 826651 826724 826773 826889 826979 827121 827191 827267 827300 827483 827577 828514 ] |
||||||||||||||||||||||||||||||
|
14.08 ms (9.44%) |
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 790027 802391 802428 806286 730651 756313 815766 824085 697719 718557 800058 759794 767560 464619 662896 823860 804395 569857 827483 819445 612460 795668 767331 724434 745901 772599 723966 758620 729989 721251 791789 462905 408810 469193 826541 826651 823748 819388 486144 775659 731230 747490 400885 819014 826380 826079 826724 824693 826381 826889 827300 824956 825775 826169 828514 537552 564210 656957 663433 699703 679309 782765 734351 761480 773376 766552 793675 801189 404071 817675 824826 825153 826456 826408 820315 825158 826382 826773 827121 827191 827267 827577 816397 819986 826979 528624 572210 686088 693432 549292 587502 780291 782768 792305 793806 794146 775568 775644 792295 793317 811722 812323 733280 740064 742456 744156 744814 750607 761253 772572 773349 773357 792218 800017 800078 810861 728886 733223 734369 744826 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.96%) |
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 400885 404071 408810 462905 464619 469193 486144 528624 537552 549292 564210 569857 572210 587502 612460 656957 662896 663433 679309 686088 693432 697719 699703 718557 721251 723966 724434 728886 729989 730651 731230 733223 733280 734351 734369 740064 742456 744156 744814 744826 745901 747490 750607 756313 758620 759794 761253 761480 766552 767331 767560 772572 772599 773349 773357 773376 775568 775644 775659 780291 782765 782768 790027 791789 792218 792295 792305 793317 793675 793806 794146 795668 800017 800058 800078 801189 802391 802428 804395 806286 810861 811722 812323 815766 816397 817675 819014 819388 819445 819986 820315 823748 823860 824085 824693 824826 824956 825153 825158 825775 826079 826169 826380 826381 826382 826408 826456 826541 826651 826724 826773 826889 826979 827121 827191 827267 827300 827483 827577 828514 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck pussy"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс pussy"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс pussy"
]
|
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.