Query Metrics
7
Database Queries
7
Different statements
192.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.46 ms (87.64%) |
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 205910 382803 386276 390736 393727 393759 398390 400718 400864 402160 403678 418286 419559 421762 423322 425061 425656 433635 434488 439006 439396 444366 445099 451705 453790 454863 463232 467321 467673 477322 478879 481773 483725 483918 484216 486632 486846 486933 504727 509329 510530 510586 519967 523061 524273 542133 548982 556144 560498 579528 580155 580402 585596 587967 592114 592946 593634 594108 595231 599729 600933 607073 607631 612509 614094 618670 622521 626461 638033 660462 661593 677524 679858 682328 683089 684012 684335 702521 713872 722731 736738 739792 741035 746084 746618 749582 756088 759567 759578 763062 763327 767957 767964 768687 772684 775538 777007 779973 780925 782646 783617 784716 784806 784969 785195 785462 787619 789863 789888 792056 799722 805044 806866 807591 811146 814122 817200 818067 820106 827776 ] |
||||||||||||||||||||||||||||||
|
14.22 ms (7.40%) |
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 579528 779973 741035 433635 775538 763327 423322 444366 600933 784969 789863 805044 746084 785462 421762 661593 592114 787619 817200 523061 595231 736738 626461 400718 483918 580402 702521 783617 739792 614094 486933 478879 402160 439006 607073 679858 713872 585596 418286 684335 792056 807591 612509 811146 542133 445099 481773 780925 818067 782646 398390 820106 806866 827776 504727 785195 746618 382803 486632 684012 400864 386276 393759 756088 439396 677524 682328 205910 767957 548982 722731 789888 767964 814122 580155 618670 599729 784716 784806 509329 638033 403678 483725 434488 560498 660462 593634 594108 592946 454863 510530 390736 477322 607631 777007 799722 768687 463232 393727 484216 425061 759567 759578 749582 486846 519967 772684 510586 467321 587967 622521 524273 556144 683089 763062 467673 419559 425656 451705 453790 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.49%) |
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 205910 382803 386276 390736 393727 393759 398390 400718 400864 402160 403678 418286 419559 421762 423322 425061 425656 433635 434488 439006 439396 444366 445099 451705 453790 454863 463232 467321 467673 477322 478879 481773 483725 483918 484216 486632 486846 486933 504727 509329 510530 510586 519967 523061 524273 542133 548982 556144 560498 579528 580155 580402 585596 587967 592114 592946 593634 594108 595231 599729 600933 607073 607631 612509 614094 618670 622521 626461 638033 660462 661593 677524 679858 682328 683089 684012 684335 702521 713872 722731 736738 739792 741035 746084 746618 749582 756088 759567 759578 763062 763327 767957 767964 768687 772684 775538 777007 779973 780925 782646 783617 784716 784806 784969 785195 785462 787619 789863 789888 792056 799722 805044 806866 807591 811146 814122 817200 818067 820106 827776 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"daddy секс девушк"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"daddy sex girls"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"daddy секс девушк"
]
|
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.