Query Metrics
7
Database Queries
7
Different statements
146.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.87 ms (85.38%) |
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 391317 398302 418718 444516 448998 454597 454761 456245 470315 476150 484934 493715 500320 505331 513758 515270 515524 527504 528062 528985 529638 529639 530968 530969 531369 531655 531767 532884 533405 533428 536100 537774 538395 538469 539500 541306 541750 542704 548945 548969 549097 550800 553547 554827 556252 558402 560345 565610 573977 576534 582836 583619 585845 585869 586127 587241 587452 588583 589847 589894 590295 591089 594303 594312 594601 595438 596039 600423 604110 604659 613503 614559 619242 626751 627875 628205 634037 635724 639112 650495 653954 655011 658845 661676 666858 671098 671773 671808 671977 680797 680801 681358 683296 686139 691790 692691 701313 701962 702357 703235 704065 704698 707819 708697 710068 739804 765251 765256 776057 782436 783567 783711 785855 788321 792067 793266 796686 803092 803378 823020 ] |
||||||||||||||||||||||||||||||
|
11.87 ms (8.12%) |
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 691790 553547 556252 585845 639112 591089 604659 776057 796686 765251 765256 739804 613503 702357 703235 803092 803378 454597 476150 391317 398302 470315 515524 456245 628205 513758 505331 484934 527504 594601 594312 448998 418718 444516 530969 536100 558402 594303 823020 454761 493715 529638 529639 530968 531369 532884 538395 515270 528985 531767 538469 539500 500320 528062 531655 533428 533405 537774 541750 542704 548945 565610 541306 549097 560345 582836 583619 650495 658845 661676 666858 671098 671773 671808 692691 701962 704698 653954 680797 683296 686139 704065 655011 671977 680801 681358 701313 707819 708697 710068 548969 550800 554827 573977 576534 586127 587241 600423 604110 614559 634037 590295 595438 619242 635724 585869 588583 589894 627875 587452 589847 596039 626751 783567 783711 785855 788321 792067 793266 782436 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.70%) |
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 391317 398302 418718 444516 448998 454597 454761 456245 470315 476150 484934 493715 500320 505331 513758 515270 515524 527504 528062 528985 529638 529639 530968 530969 531369 531655 531767 532884 533405 533428 536100 537774 538395 538469 539500 541306 541750 542704 548945 548969 549097 550800 553547 554827 556252 558402 560345 565610 573977 576534 582836 583619 585845 585869 586127 587241 587452 588583 589847 589894 590295 591089 594303 594312 594601 595438 596039 600423 604110 604659 613503 614559 619242 626751 627875 628205 634037 635724 639112 650495 653954 655011 658845 661676 666858 671098 671773 671808 671977 680797 680801 681358 683296 686139 691790 692691 701313 701962 702357 703235 704065 704698 707819 708697 710068 739804 765251 765256 776057 782436 783567 783711 785855 788321 792067 793266 796686 803092 803378 823020 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло teen вагин"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo teen vagina"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло teen вагин"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.06%) |
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.