Query Metrics
7
Database Queries
7
Different statements
165.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.92 ms (79.89%) |
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 420314 420322 420749 423187 423515 423606 427041 427620 434412 434422 439900 441850 442107 446716 446999 450150 452740 457060 465000 465310 477850 481019 485184 503796 509632 513321 518800 531270 532286 535247 538665 544073 545176 555487 555958 558775 562676 576445 581229 584948 589607 589996 592830 595638 596508 600726 602547 604635 619974 627154 631055 640868 642536 650098 651544 655602 656268 656628 666483 669634 689492 707690 708045 708905 717922 723716 740508 741582 750692 752509 761314 762330 762659 763120 763604 764025 764280 766923 767189 768722 769346 769585 771628 773532 775617 776277 777536 777619 779017 779558 781064 781097 781185 781283 781574 786694 786778 787742 788386 791101 792050 793172 794399 796183 796707 799045 800367 800611 803444 803667 804640 807855 808257 809303 811318 812729 812876 813292 816634 ] |
||||||||||||||||||||||||||||||
|
22.30 ms (13.50%) |
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 779017 779558 796183 800611 812729 777536 781064 786694 773532 786778 788386 791101 792050 809303 741582 723716 768722 740508 764025 764280 769346 627154 631055 781574 799045 427041 420322 423606 439900 457060 485184 576445 656628 707690 602547 589607 812876 708045 776277 813292 518800 544073 689492 655602 640868 642536 607076 762659 752509 761314 717922 775617 423187 434422 420314 420749 442107 816634 446716 446999 450150 465000 452740 481019 477850 531270 503796 513321 532286 538665 509632 535247 555487 555958 581229 584948 545176 650098 651544 656268 666483 669634 558775 562676 596508 619974 595638 600726 589996 592830 787742 803667 811318 777619 781097 781283 803444 804640 762330 767189 794399 808257 750692 766923 769585 763120 771628 763604 604635 708905 781185 793172 796707 800367 807855 434412 423515 441850 465310 427620 ] |
||||||||||||||||||||||||||||||
|
3.31 ms (2.01%) |
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 420314 420322 420749 423187 423515 423606 427041 427620 434412 434422 439900 441850 442107 446716 446999 450150 452740 457060 465000 465310 477850 481019 485184 503796 509632 513321 518800 531270 532286 535247 538665 544073 545176 555487 555958 558775 562676 576445 581229 584948 589607 589996 592830 595638 596508 600726 602547 604635 619974 627154 631055 640868 642536 650098 651544 655602 656268 656628 666483 669634 689492 707690 708045 708905 717922 723716 740508 741582 750692 752509 761314 762330 762659 763120 763604 764025 764280 766923 767189 768722 769346 769585 771628 773532 775617 776277 777536 777619 779017 779558 781064 781097 781185 781283 781574 786694 786778 787742 788386 791101 792050 793172 794399 796183 796707 799045 800367 800611 803444 803667 804640 807855 808257 809303 811318 812729 812876 813292 816634 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov cumshot"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов cumshot"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов cumshot"
]
|
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.