Query Metrics
7
Database Queries
7
Different statements
185.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.99 ms (85.56%) |
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 88476 154451 181693 212793 382483 383478 383601 389202 403376 412551 414230 435355 439318 444695 449940 450698 452939 453481 454760 460979 461658 468268 496723 499380 530952 531683 533298 535315 541771 547941 550918 552437 553844 554528 554747 555227 556756 558466 559310 560071 560758 568744 573973 574011 576172 576173 582419 590502 602317 602449 605178 605234 605535 612131 616265 619883 640514 663195 663345 664526 673232 681535 689978 706413 707851 708759 723166 728552 730055 736308 736896 738275 740259 741660 742104 743145 751326 751327 751345 751750 752263 753554 753574 756135 770131 773044 774118 774194 776044 776053 776736 777339 778781 780835 780848 781417 781865 782071 783169 783912 783954 784113 785011 785164 785756 787179 790312 793244 793921 806492 806578 807240 812472 813665 814297 816719 819241 822572 823057 825919 ] |
||||||||||||||||||||||||||||||
|
15.38 ms (8.28%) |
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 574011 552437 568744 663345 730055 751345 743145 414230 814297 531683 707851 751327 776053 559310 590502 751750 807240 774194 461658 819241 822572 823057 756135 541771 783169 738275 554747 383601 558466 535315 776736 533298 555227 382483 781865 554528 449940 496723 784113 444695 450698 530952 619883 439318 602317 453481 389202 181693 663195 560071 576172 550918 681535 723166 553844 576173 602449 616265 640514 605178 782071 785011 778781 780835 753554 806578 736308 740259 773044 728552 605234 612131 780848 783912 790312 383478 212793 752263 736896 452939 460979 783954 560758 825919 547941 468268 499380 556756 742104 573973 403376 88476 605535 812472 806492 770131 706413 454760 412551 582419 785756 751326 708759 673232 785164 793921 741660 774118 777339 689978 816719 664526 793244 753574 781417 435355 813665 776044 154451 787179 ] |
||||||||||||||||||||||||||||||
|
3.88 ms (2.09%) |
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 88476 154451 181693 212793 382483 383478 383601 389202 403376 412551 414230 435355 439318 444695 449940 450698 452939 453481 454760 460979 461658 468268 496723 499380 530952 531683 533298 535315 541771 547941 550918 552437 553844 554528 554747 555227 556756 558466 559310 560071 560758 568744 573973 574011 576172 576173 582419 590502 602317 602449 605178 605234 605535 612131 616265 619883 640514 663195 663345 664526 673232 681535 689978 706413 707851 708759 723166 728552 730055 736308 736896 738275 740259 741660 742104 743145 751326 751327 751345 751750 752263 753554 753574 756135 770131 773044 774118 774194 776044 776053 776736 777339 778781 780835 780848 781417 781865 782071 783169 783912 783954 784113 785011 785164 785756 787179 790312 793244 793921 806492 806578 807240 812472 813665 814297 816719 819241 822572 823057 825919 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло мастурбац трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло мастурбац трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo masturbation panties"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.