Query Metrics
7
Database Queries
7
Different statements
134.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
110.27 ms (82.23%) |
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 108208 404479 478732 480889 481644 485995 488510 489015 495887 499486 507460 508519 508539 509144 509728 510139 510858 511302 513921 518415 520513 520830 521232 521676 522719 523485 527690 527929 528843 536940 538527 538984 539213 539252 539349 540766 541537 543171 546584 547381 547545 550834 551783 552840 553871 554295 555161 555467 555725 557604 557726 557774 557836 557915 558837 564228 568637 574151 574329 574409 574937 575371 576200 577271 577568 577663 578256 578293 579977 580398 582000 582634 582931 584151 584439 584564 585257 585586 586309 588430 588814 589814 591736 592137 592553 595666 596329 596343 598569 599805 601794 602429 602505 602712 602765 603114 604720 604856 604857 605656 606537 607277 610615 612763 613732 617732 620549 628901 630955 638894 640334 641004 652630 656522 670180 671936 675453 678691 686862 688680 ] |
||||||||||||||||||||||||||||||
|
14.56 ms (10.86%) |
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 478732 522719 686862 527690 518415 538527 547381 555467 582931 557604 577271 579977 586309 592137 603114 604857 508519 528843 558837 527929 588814 539349 509144 577663 582000 546584 577568 602765 610615 617732 574409 580398 582634 670180 585586 607277 108208 485995 555725 595666 602505 480889 481644 574151 688680 656522 564228 592553 605656 628901 620549 584564 584151 550834 578293 499486 536940 538984 547545 554295 568637 574329 543171 557774 576200 585257 598569 602429 613732 588430 606537 596329 596343 638894 641004 630955 540766 523485 584439 678691 589814 599805 675453 553871 601794 612763 604720 507460 539213 495887 513921 541537 552840 557726 557836 671936 555161 578256 602712 520513 508539 509728 489015 510858 404479 604856 574937 640334 488510 591736 510139 511302 520830 521232 521676 539252 551783 557915 575371 652630 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.89%) |
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 108208 404479 478732 480889 481644 485995 488510 489015 495887 499486 507460 508519 508539 509144 509728 510139 510858 511302 513921 518415 520513 520830 521232 521676 522719 523485 527690 527929 528843 536940 538527 538984 539213 539252 539349 540766 541537 543171 546584 547381 547545 550834 551783 552840 553871 554295 555161 555467 555725 557604 557726 557774 557836 557915 558837 564228 568637 574151 574329 574409 574937 575371 576200 577271 577568 577663 578256 578293 579977 580398 582000 582634 582931 584151 584439 584564 585257 585586 586309 588430 588814 589814 591736 592137 592553 595666 596329 596343 598569 599805 601794 602429 602505 602712 602765 603114 604720 604856 604857 605656 606537 607277 610615 612763 613732 617732 620549 628901 630955 638894 640334 641004 652630 656522 670180 671936 675453 678691 686862 688680 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"кончает в лицо мужчинâ…"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм в лиц мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.