Query Metrics
7
Database Queries
7
Different statements
155.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.32 ms (84.72%) |
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 533508 577578 589672 591569 592198 595894 596779 601228 602295 603522 607476 607569 607623 610142 612675 612968 617805 617812 617977 618388 620491 626037 626120 627254 628704 629543 635888 637490 641180 641387 642191 644441 649249 661023 700812 700821 710357 710590 714173 714374 715114 715480 718403 724495 726282 726651 726816 726876 728308 729941 730144 734180 735910 742280 742390 742642 743634 743641 743658 746200 749618 749868 749874 750836 750838 750861 753023 753033 753046 753050 753072 753782 757177 757909 758446 758777 758809 759127 759768 762296 765463 765516 766613 766721 766723 766754 766778 769501 778563 780692 782007 782395 782404 782464 782468 782483 784255 787797 787799 788225 788287 790339 798481 802903 803784 806295 807208 807589 807742 807748 807758 807789 811702 812373 812374 812375 812379 812387 812388 814117 ] |
||||||||||||||||||||||||||||||
|
13.86 ms (8.94%) |
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 714173 812374 533508 661023 628704 726816 753782 807758 766723 700821 602295 617977 782483 788225 812373 758809 753046 750836 724495 730144 644441 782404 806295 807742 700812 577578 592198 715480 790339 784255 812379 812388 758446 798481 812375 749868 762296 769501 787799 642191 641180 726282 714374 607569 788287 753050 757909 728308 742390 758777 743658 742642 782007 626120 641387 617812 759768 749618 629543 814117 718403 612968 778563 812387 782468 753033 766613 766721 782464 753072 715114 710590 607623 627254 603522 591569 601228 780692 807748 729941 759127 807208 750861 726876 742280 750838 743641 757177 710357 782395 607476 589672 811702 807789 734180 746200 766778 766754 618388 612675 726651 743634 617805 610142 635888 649249 596779 626037 620491 637490 595894 803784 807589 802903 753023 765463 787797 735910 765516 749874 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.75%) |
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 533508 577578 589672 591569 592198 595894 596779 601228 602295 603522 607476 607569 607623 610142 612675 612968 617805 617812 617977 618388 620491 626037 626120 627254 628704 629543 635888 637490 641180 641387 642191 644441 649249 661023 700812 700821 710357 710590 714173 714374 715114 715480 718403 724495 726282 726651 726816 726876 728308 729941 730144 734180 735910 742280 742390 742642 743634 743641 743658 746200 749618 749868 749874 750836 750838 750861 753023 753033 753046 753050 753072 753782 757177 757909 758446 758777 758809 759127 759768 762296 765463 765516 766613 766721 766723 766754 766778 769501 778563 780692 782007 782395 782404 782464 782468 782483 784255 787797 787799 788225 788287 790339 798481 802903 803784 806295 807208 807589 807742 807748 807758 807789 811702 812373 812374 812375 812379 812387 812388 814117 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur bbw"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск bbw"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск bbw"
]
|
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.