Query Metrics
7
Database Queries
7
Different statements
158.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.85 ms (86.45%) |
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 145280 155175 386280 386877 387941 398965 405829 426247 449017 450302 465595 488908 500432 505771 531050 533792 548915 550040 554676 555153 556610 559418 559421 560028 561791 562465 563971 572986 575025 581040 584056 584830 585597 603322 606813 607298 615157 632929 633196 636963 641571 645693 649363 651060 664498 666684 671497 672840 675897 705779 706008 713440 720540 728036 733368 734823 740265 744007 744213 744770 744772 746709 747423 749271 749570 753661 753762 754482 756045 759068 759112 759324 760154 760164 761933 761946 770167 770246 776829 776840 776844 777607 781865 785888 787812 788802 793031 795655 796389 796910 796988 797032 797136 798431 798439 799625 799932 802915 804153 804809 806479 806960 807185 807654 807992 808520 811099 811109 812756 813597 819409 820026 822473 823856 823885 824552 825339 826820 ] |
||||||||||||||||||||||||||||||
|
12.91 ms (8.16%) |
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 796389 804809 744770 747423 760164 808520 749570 759068 753762 761933 761946 770246 615157 145280 386280 488908 585597 798431 387941 813597 555153 550040 788802 734823 781865 756045 749271 822473 820026 825339 826820 823856 824552 819409 821958 823885 533792 548915 554676 562465 572986 561791 559421 651060 706008 720540 556610 559418 563971 581040 636963 603322 606813 777607 785888 802915 804153 807654 807992 796910 807185 754482 770167 797136 811099 728036 766362 759112 740265 744007 744213 753661 759324 733368 633196 705779 776844 793031 798439 806479 155175 386877 426247 449017 465595 672840 607298 812756 398965 405829 505771 500432 664498 776829 776840 675897 531050 560028 575025 584830 584056 645693 649363 666684 671497 641571 795655 799625 799932 797032 806960 811109 744772 796988 746709 760154 632929 713440 787812 450302 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.50%) |
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 145280 155175 386280 386877 387941 398965 405829 426247 449017 450302 465595 488908 500432 505771 531050 533792 548915 550040 554676 555153 556610 559418 559421 560028 561791 562465 563971 572986 575025 581040 584056 584830 585597 603322 606813 607298 615157 632929 633196 636963 641571 645693 649363 651060 664498 666684 671497 672840 675897 705779 706008 713440 720540 728036 733368 734823 740265 744007 744213 744770 744772 746709 747423 749271 749570 753661 753762 754482 756045 759068 759112 759324 760154 760164 761933 761946 770167 770246 776829 776840 776844 777607 781865 785888 787812 788802 793031 795655 796389 796910 796988 797032 797136 798431 798439 799625 799932 802915 804153 804809 806479 806960 807185 807654 807992 808520 811099 811109 812756 813597 819409 820026 822473 823856 823885 824552 825339 826820 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo milf masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло milf мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло milf мастурбац"
]
|
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.