Query Metrics
7
Database Queries
7
Different statements
176.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.69 ms (86.01%) |
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 12405 107060 385247 385425 387000 389789 393306 393558 402771 421567 426631 426633 427142 427172 430450 433594 456363 459172 461163 466297 472677 479162 480560 481357 482616 492155 507780 514662 516144 516188 516764 516984 517620 518819 522177 525576 525869 526302 527582 527786 530684 531264 532057 532536 533056 533118 533539 536958 539788 542015 542346 543657 544869 548889 548891 549581 555287 556429 557965 558390 562219 565630 567942 570111 570851 577088 584940 594934 594949 604287 606921 614566 626572 627851 632435 636477 636929 637486 638906 646964 655260 655857 656625 670578 677104 686231 693349 696870 700864 716751 722443 724324 725507 727884 734280 736258 742329 754187 759009 761089 771269 773045 773379 782774 783760 784735 787778 788181 788983 792615 794508 796968 797215 797884 799549 800142 806674 825255 826859 ] |
||||||||||||||||||||||||||||||
|
14.14 ms (8.02%) |
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 507780 516764 393306 426631 459172 517620 525576 527786 531264 533539 516144 530684 532536 514662 549581 555287 557965 577088 548889 693349 722443 548891 556429 570851 784735 796968 734280 754187 759009 761089 806674 736258 773045 773379 727884 742329 771269 627851 782774 788983 393558 433594 466297 427172 479162 482616 481357 518819 525869 533118 539788 533056 543657 544869 562219 570111 655260 677104 646964 655857 696870 656625 670578 686231 594934 632435 604287 606921 626572 636477 637486 636929 638906 594949 700864 527582 516984 12405 797215 800142 387000 385425 385247 389789 430450 421567 426633 825255 826859 480560 456363 472677 492155 536958 522177 542015 565630 716751 567942 787778 788181 794508 797884 725507 783760 724324 774965 792615 799549 107060 402771 427142 461163 526302 532057 516188 542346 584940 558390 614566 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (1.81%) |
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 12405 107060 385247 385425 387000 389789 393306 393558 402771 421567 426631 426633 427142 427172 430450 433594 456363 459172 461163 466297 472677 479162 480560 481357 482616 492155 507780 514662 516144 516188 516764 516984 517620 518819 522177 525576 525869 526302 527582 527786 530684 531264 532057 532536 533056 533118 533539 536958 539788 542015 542346 543657 544869 548889 548891 549581 555287 556429 557965 558390 562219 565630 567942 570111 570851 577088 584940 594934 594949 604287 606921 614566 626572 627851 632435 636477 636929 637486 638906 646964 655260 655857 656625 670578 677104 686231 693349 696870 700864 716751 722443 724324 725507 727884 734280 736258 742329 754187 759009 761089 771269 773045 773379 782774 783760 784735 787778 788181 788983 792615 794508 796968 797215 797884 799549 800142 806674 825255 826859 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"slave amateur"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"доминирован любительск"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.94%) |
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.