Query Metrics
7
Database Queries
7
Different statements
147.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.18 ms (83.41%) |
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 382098 389888 391767 395184 402021 411917 412535 417137 431594 436860 439455 442027 442139 443111 445713 452846 455345 457353 474192 483240 487443 495980 496279 498123 498171 504325 506233 511890 512298 512765 523926 529963 532617 535895 553708 558845 559287 564609 568259 576614 580097 584609 588234 591234 593516 599111 603761 605950 606500 610832 613217 617348 619856 622827 625369 627788 628828 632918 633708 637613 638490 643334 651217 659931 663567 665831 666050 666477 669504 670373 685425 685892 687466 689139 689998 690866 692651 693284 695826 697666 698009 700006 705691 707744 707833 712943 713053 713676 720509 721209 725095 726948 729345 735318 736252 736570 740755 741808 745670 749608 750830 757155 758903 761655 765867 765898 766054 766387 766728 775218 786072 789128 796572 801517 803471 807309 810027 812335 827573 ] |
||||||||||||||||||||||||||||||
|
14.92 ms (10.11%) |
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 395184 443111 506233 511890 455345 689998 713676 705691 591234 638490 775218 483240 487443 553708 559287 584609 659931 707744 712943 665831 666477 685892 693284 695826 666050 689139 692651 707833 558845 588234 605950 610832 632918 613217 625369 599111 725095 736570 740755 786072 750830 761655 764440 633708 698009 512298 498123 498171 495980 402021 736252 457353 411917 442027 439455 827573 452846 535895 496279 523926 697666 651217 663567 721209 576614 807309 812335 789128 801517 803471 796572 810027 745670 765867 766054 735318 741808 757155 758903 765898 766387 749608 766728 417137 431594 382098 389888 442139 445713 532617 529963 713053 720509 670373 564609 568259 637613 619856 606500 729345 726948 412535 391767 474192 436860 512765 504325 593516 603761 628828 580097 669504 687466 690866 685425 700006 617348 627788 643334 622827 ] |
||||||||||||||||||||||||||||||
|
3.33 ms (2.25%) |
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 382098 389888 391767 395184 402021 411917 412535 417137 431594 436860 439455 442027 442139 443111 445713 452846 455345 457353 474192 483240 487443 495980 496279 498123 498171 504325 506233 511890 512298 512765 523926 529963 532617 535895 553708 558845 559287 564609 568259 576614 580097 584609 588234 591234 593516 599111 603761 605950 606500 610832 613217 617348 619856 622827 625369 627788 628828 632918 633708 637613 638490 643334 651217 659931 663567 665831 666050 666477 669504 670373 685425 685892 687466 689139 689998 690866 692651 693284 695826 697666 698009 700006 705691 707744 707833 712943 713053 713676 720509 721209 725095 726948 729345 735318 736252 736570 740755 741808 745670 749608 750830 757155 758903 761655 765867 765898 766054 766387 766728 775218 786072 789128 796572 801517 803471 807309 810027 812335 827573 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"porn amateur"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"porn любительск"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"porn любительск"
]
|
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.