Query Metrics
7
Database Queries
7
Different statements
364.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.87 ms (59.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old мастурбац"
]
|
||||||||||||||||||||||||||||||
|
125.72 ms (34.51%) |
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 16971 205655 239112 250695 295700 387198 387422 411946 412289 422358 425355 443373 458628 460056 464284 467334 475298 481231 489156 504173 515932 516498 527521 529080 538363 546011 560425 561287 563598 569361 574207 577561 581638 581661 603519 604002 617183 620576 622427 624703 624851 630068 634221 639942 641787 642270 646911 648722 651217 654151 655184 655214 657536 663393 663906 663946 665108 665418 665440 665499 666790 671810 678185 678195 679305 685979 693881 694751 701292 702375 705040 709544 710439 710458 712162 712831 714478 720299 721002 724290 726564 732090 733387 735982 736507 736967 737382 739787 741526 744201 746710 749578 750084 751656 757003 759223 766043 775853 776523 781322 787328 800284 804235 807268 812038 812299 812511 812559 814091 814299 814419 814690 816591 820699 823686 824355 824999 825789 827184 827465 ] |
||||||||||||||||||||||||||||||
|
15.42 ms (4.23%) |
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 665108 467334 411946 701292 634221 460056 489156 646911 694751 781322 736967 736507 741526 812038 516498 814299 824355 814091 823686 814690 827465 529080 577561 574207 648722 654151 655184 678185 679305 685979 655214 663946 671810 693881 705040 712831 657536 666790 709544 720299 569361 581661 603519 639942 624851 630068 604002 617183 620576 624703 641787 800284 775853 733387 744201 746710 812559 732090 737382 751656 726564 724290 739787 749578 766043 735982 750084 757003 759223 622427 702375 710439 712162 721002 776523 787328 807268 812511 295700 387422 239112 464284 581638 812299 804235 481231 443373 475298 538363 504173 560425 422358 412289 16971 561287 642270 250695 205655 387198 425355 814419 825789 827184 816591 820699 824999 458628 515932 527521 678195 651217 663393 663906 665418 665499 714478 665440 710458 546011 563598 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (0.63%) |
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 16971 205655 239112 250695 295700 387198 387422 411946 412289 422358 425355 443373 458628 460056 464284 467334 475298 481231 489156 504173 515932 516498 527521 529080 538363 546011 560425 561287 563598 569361 574207 577561 581638 581661 603519 604002 617183 620576 622427 624703 624851 630068 634221 639942 641787 642270 646911 648722 651217 654151 655184 655214 657536 663393 663906 663946 665108 665418 665440 665499 666790 671810 678185 678195 679305 685979 693881 694751 701292 702375 705040 709544 710439 710458 712162 712831 714478 720299 721002 724290 726564 732090 733387 735982 736507 736967 737382 739787 741526 744201 746710 749578 750084 751656 757003 759223 766043 775853 776523 781322 787328 800284 804235 807268 812038 812299 812511 812559 814091 814299 814419 814690 816591 820699 823686 824355 824999 825789 827184 827465 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.42%) |
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.