Query Metrics
7
Database Queries
7
Different statements
156.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.22 ms (86.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 33602 156920 161746 341645 384545 389967 398416 399410 408560 434716 465710 476115 532234 533779 533976 537102 537630 541257 546296 556091 568231 577734 577838 578614 579642 579872 580537 584697 586320 588063 588419 590261 593588 593804 596210 596574 604512 605019 605541 606521 606524 606843 610276 613664 615291 616178 616278 616534 616571 616578 616671 616920 617492 622985 623183 626708 628590 629201 629631 630259 630985 633427 633922 633929 633945 633974 634039 639078 641488 641490 642596 645213 645529 646533 647915 648279 648393 648969 649092 651243 651586 651756 652639 652674 652699 653773 654221 654973 654974 661625 665338 668145 674136 675636 677510 682275 688519 691725 694861 694905 696407 698359 704114 704677 705306 706742 709367 711268 712779 712782 719850 738391 748855 752956 814219 817184 817381 823758 827197 ] |
||||||||||||||||||||||||||||||
|
11.15 ms (7.10%) |
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 546296 556091 577734 577838 580537 568231 584697 646533 648279 648393 649092 651243 652639 653773 654974 677510 691725 694861 704114 711268 712779 712782 645213 645529 651756 652674 652699 654221 661625 665338 668145 674136 688519 696407 705306 648969 651586 654973 698359 704677 706742 709367 579642 588063 590261 596574 605541 616178 626708 629631 639078 588419 593588 616278 616920 633929 642596 606521 610276 616571 616671 623183 633427 633974 634039 641488 586320 593804 605019 613664 616578 617492 626934 628590 630985 633922 633945 641490 604512 606524 606843 615291 629201 630259 434716 408560 341645 399410 827197 532234 533976 533779 537630 537102 578614 541257 675636 647915 682275 694905 719850 579872 596210 622985 616534 752956 738391 748855 476115 465710 384545 156920 161746 33602 389967 398416 814219 817184 817381 823758 ] |
||||||||||||||||||||||||||||||
|
2.92 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 33602 156920 161746 341645 384545 389967 398416 399410 408560 434716 465710 476115 532234 533779 533976 537102 537630 541257 546296 556091 568231 577734 577838 578614 579642 579872 580537 584697 586320 588063 588419 590261 593588 593804 596210 596574 604512 605019 605541 606521 606524 606843 610276 613664 615291 616178 616278 616534 616571 616578 616671 616920 617492 622985 623183 626708 628590 629201 629631 630259 630985 633427 633922 633929 633945 633974 634039 639078 641488 641490 642596 645213 645529 646533 647915 648279 648393 648969 649092 651243 651586 651756 652639 652674 652699 653773 654221 654973 654974 661625 665338 668145 674136 675636 677510 682275 688519 691725 694861 694905 696407 698359 704114 704677 705306 706742 709367 711268 712779 712782 719850 738391 748855 752956 814219 817184 817381 823758 827197 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"interracial amateur"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"межрасов любительск"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.