Query Metrics
7
Database Queries
7
Different statements
171.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.05 ms (86.69%) |
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 382398 385324 387910 391089 391907 391929 392111 403067 418265 429778 430526 443045 445291 453612 467645 470533 479071 483518 483900 496728 501377 506813 509075 512949 526122 528670 530256 533658 533772 536996 537631 539515 540100 543360 543654 543982 545414 545433 545598 546664 546667 547933 548005 566392 567997 583454 583511 585950 590627 590898 591167 593858 593859 603544 603608 603632 606584 606662 619275 622189 632249 633537 634293 635833 639330 640020 649227 651270 653177 653612 653622 653830 653923 654269 654295 670721 693380 694025 696250 698104 709915 710274 710668 710953 715089 717636 721988 723074 731325 731334 731481 740161 744856 745548 745723 747234 748781 773966 775794 785963 787379 788101 789823 790413 790753 797126 797132 801535 802488 804508 805339 805462 809184 809510 810106 812998 817445 823720 824326 824423 ] |
||||||||||||||||||||||||||||||
|
13.55 ms (7.88%) |
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 696250 710274 545433 545598 748781 785963 790413 804508 809184 744856 812998 710668 483518 496728 536996 540100 693380 649227 653622 622189 639330 640020 606662 731325 509075 429778 528670 533772 653612 717636 809510 773966 731334 740161 745548 745723 619275 721988 787379 788101 633537 512949 634293 731481 710953 533658 537631 392111 653177 824423 715089 654269 547933 479071 403067 593858 653923 632249 590627 443045 430526 546667 651270 653830 694025 548005 635833 654295 747234 603608 385324 506813 526122 566392 590898 585950 467645 593859 591167 797126 387910 483900 543360 670721 603544 567997 789823 823720 391929 445291 391907 453612 797132 583454 545414 810106 606584 543982 723074 775794 470533 543654 583511 817445 603632 530256 709915 802488 790753 805339 805462 801535 698104 382398 391089 418265 824326 539515 501377 546664 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.42%) |
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 382398 385324 387910 391089 391907 391929 392111 403067 418265 429778 430526 443045 445291 453612 467645 470533 479071 483518 483900 496728 501377 506813 509075 512949 526122 528670 530256 533658 533772 536996 537631 539515 540100 543360 543654 543982 545414 545433 545598 546664 546667 547933 548005 566392 567997 583454 583511 585950 590627 590898 591167 593858 593859 603544 603608 603632 606584 606662 619275 622189 632249 633537 634293 635833 639330 640020 649227 651270 653177 653612 653622 653830 653923 654269 654295 670721 693380 694025 696250 698104 709915 710274 710668 710953 715089 717636 721988 723074 731325 731334 731481 740161 744856 745548 745723 747234 748781 773966 775794 785963 787379 788101 789823 790413 790753 797126 797132 801535 802488 804508 805339 805462 809184 809510 810106 812998 817445 823720 824326 824423 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"мжм домашний реальноÐâ…"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мжм секс втро домашн любительск любительск"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.91%) |
1 |
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.