Query Metrics
7
Database Queries
7
Different statements
400.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.85 ms (53.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен секс втро секс втро"
]
|
||||||||||||||||||||||||||||||
|
165.60 ms (41.34%) |
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 34580 390344 391929 397531 404831 407464 410872 418899 420891 423518 426727 430526 443637 448713 455977 457226 460282 466316 470001 470533 470634 470691 470926 474632 489680 500717 501262 501524 516627 522523 523124 525244 526568 533488 533648 537564 540122 540524 542370 542789 543555 543677 543709 544636 544748 545414 546667 548005 552783 560454 562758 563537 572582 573411 583454 583997 587258 587447 590898 591257 591744 596207 601217 604746 613579 617487 619271 632513 633537 635833 642832 649291 653392 653432 670719 678874 692438 693849 697169 698018 698089 699420 708034 710212 710953 712654 726754 731086 732590 733231 741655 742682 748383 748542 760619 761519 762513 766117 767190 773945 775256 775904 776307 776566 784700 790761 793097 793427 793915 795887 799672 802103 805276 807362 809941 811755 811795 813662 825302 826931 ] |
||||||||||||||||||||||||||||||
|
13.69 ms (3.42%) |
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 742682 762513 732590 733231 632513 710953 773945 448713 563537 596207 543677 544636 544748 670719 692438 591744 617487 793915 731086 601217 802103 642832 776566 500717 573411 811755 760619 748383 470926 525244 560454 423518 470533 809941 420891 466316 540524 697169 619271 776307 418899 470691 489680 443637 552783 604746 526568 410872 649291 34580 710212 775904 455977 460282 583997 474632 741655 470634 587447 613579 784700 426727 391929 397531 430526 813662 543555 546667 693849 698089 548005 635833 805276 761519 793097 726754 748542 470001 678874 523124 522523 542370 633537 807362 699420 795887 562758 826931 533648 653392 572582 591257 793427 407464 540122 790761 799672 811795 767190 390344 404831 501262 708034 712654 590898 775256 766117 698018 587258 501524 653432 542789 457226 825302 516627 533488 537564 583454 543709 545414 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (0.79%) |
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 34580 390344 391929 397531 404831 407464 410872 418899 420891 423518 426727 430526 443637 448713 455977 457226 460282 466316 470001 470533 470634 470691 470926 474632 489680 500717 501262 501524 516627 522523 523124 525244 526568 533488 533648 537564 540122 540524 542370 542789 543555 543677 543709 544636 544748 545414 546667 548005 552783 560454 562758 563537 572582 573411 583454 583997 587258 587447 590898 591257 591744 596207 601217 604746 613579 617487 619271 632513 633537 635833 642832 649291 653392 653432 670719 678874 692438 693849 697169 698018 698089 699420 708034 710212 710953 712654 726754 731086 732590 733231 741655 742682 748383 748542 760619 761519 762513 766117 767190 773945 775256 775904 776307 776566 784700 790761 793097 793427 793915 795887 799672 802103 805276 807362 809941 811755 811795 813662 825302 826931 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife trio threesome"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен секс втро секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.39%) |
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.