Query Metrics
7
Database Queries
7
Different statements
168.82 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.43 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.70 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð╝ðÂð╝ ð¢ð░ÐéÐâÐÇð░ð╗Ðîð¢ð░ÐÅ ð│ÐÇÐâð┤Ð%ÔǪ"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.42 ms |
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 665448 667196 707546 717603 665875 667532 607376 586684 795807 780655 773963 743803 766607 703472 476426 650425 542770 607023 520135 590978 741538 644259 574269 511291 649614 720293 665849 681288 620164 794832 545708 815051 731356 758180 698102 632383 432337 470512 395639 525657 453622 484660 661567 794265 742683 812992 470926 585995 603041 457789 525511 815214 736226 732323 43271 418567 618513 495738 722796 650836 383744 412183 484944 677958 699583 663466 692455 720112 632157 621972 790962 720121 788527 443130 453080 520758 592884 408970 517042 196316 814353 453073 666828 692293 699718 546802 566690 592453 734514 743782 768879 463176 426367 167756 817463 453842 683963 645964 684053 606489 795584 404409 338075 817440 651290 653618 661279 681020 692806 620103 643007 739518 705808 714826 789274 411940 504206 527231 665317 667878 ] |
||||||||||||||||||||||||||||||
| 4 | 1.95 ms |
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 43271 167756 196316 338075 383744 395639 404409 408970 411940 412183 418567 426367 432337 443130 453073 453080 453622 453842 457789 463176 470512 470926 476426 484660 484944 495738 504206 511291 517042 520135 520758 525511 525657 527231 542770 545708 546802 566690 574269 585995 586684 590978 592453 592884 603041 606489 607023 607376 618513 620103 620164 621972 632157 632383 643007 644259 645964 649614 650425 650836 651290 653618 661279 661567 663466 665317 665448 665849 665875 666828 667196 667532 667878 677958 681020 681288 683963 684053 692293 692455 692806 698102 699583 699718 703472 705808 707546 714826 717603 720112 720121 720293 722796 731356 732323 734514 736226 739518 741538 742683 743782 743803 758180 766607 768879 773963 780655 788527 789274 790962 794265 794832 795584 795807 812992 814353 815051 815214 817440 817463 ] |
||||||||||||||||||||||||||||||
| 5 | 144.63 ms |
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 43271 167756 196316 338075 383744 395639 404409 408970 411940 412183 418567 426367 432337 443130 453073 453080 453622 453842 457789 463176 470512 470926 476426 484660 484944 495738 504206 511291 517042 520135 520758 525511 525657 527231 542770 545708 546802 566690 574269 585995 586684 590978 592453 592884 603041 606489 607023 607376 618513 620103 620164 621972 632157 632383 643007 644259 645964 649614 650425 650836 651290 653618 661279 661567 663466 665317 665448 665849 665875 666828 667196 667532 667878 677958 681020 681288 683963 684053 692293 692455 692806 698102 699583 699718 703472 705808 707546 714826 717603 720112 720121 720293 722796 731356 732323 734514 736226 739518 741538 742683 743782 743803 758180 766607 768879 773963 780655 788527 789274 790962 794265 794832 795584 795807 812992 814353 815051 815214 817440 817463 ] |
||||||||||||||||||||||||||||||
| 6 | 1.42 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мжм секс втро натуральные сиськ без силикон"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.26 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.