Query Metrics
7
Database Queries
7
Different statements
176.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.42 ms (85.13%) |
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 396670 399140 410924 413246 425005 430437 438487 450372 455677 467383 479558 480294 481346 488145 490624 491167 492779 496758 506893 510220 514033 517631 518411 518520 518795 520951 521993 525600 527026 541365 545172 548698 548850 549783 551803 552395 554254 558548 560468 562080 562108 562409 565730 566101 567990 569278 571387 572291 574930 574955 575298 578584 578611 579303 580470 581625 586619 587251 587661 587791 588139 598918 599953 614602 615908 617060 618736 618849 619885 624365 624768 625689 627137 628864 630609 631993 632818 641901 645852 645918 652689 660075 663265 663318 663801 682945 687995 688110 699628 702075 712281 714463 724217 728802 728879 732070 739060 767165 769971 771918 773562 774287 775195 776259 781511 784511 786230 787957 791745 793431 793757 797574 797797 798677 799459 805687 807707 809872 813051 814889 ] |
||||||||||||||||||||||||||||||
|
15.82 ms (8.96%) |
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 518520 554254 551803 562409 574955 580470 614602 625689 618736 799459 784511 797797 728802 450372 506893 517631 575298 628864 739060 775195 527026 776259 797574 728879 574930 699628 805687 652689 702075 645852 732070 773562 688110 624365 774287 769971 724217 430437 518795 579303 660075 687995 558548 425005 480294 552395 578584 572291 560468 571387 663318 588139 587661 781511 813051 488145 548850 545172 714463 569278 624768 787957 809872 767165 615908 712281 518411 541365 562080 682945 565730 578611 627137 496758 645918 438487 520951 663801 514033 586619 617060 521993 793431 413246 814889 567990 631993 467383 455677 548698 549783 587791 786230 510220 479558 490624 581625 525600 562108 663265 771918 619885 798677 491167 492779 566101 618849 791745 632818 807707 598918 410924 399140 587251 630609 641901 396670 481346 599953 793757 ] |
||||||||||||||||||||||||||||||
|
4.10 ms (2.32%) |
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 396670 399140 410924 413246 425005 430437 438487 450372 455677 467383 479558 480294 481346 488145 490624 491167 492779 496758 506893 510220 514033 517631 518411 518520 518795 520951 521993 525600 527026 541365 545172 548698 548850 549783 551803 552395 554254 558548 560468 562080 562108 562409 565730 566101 567990 569278 571387 572291 574930 574955 575298 578584 578611 579303 580470 581625 586619 587251 587661 587791 588139 598918 599953 614602 615908 617060 618736 618849 619885 624365 624768 625689 627137 628864 630609 631993 632818 641901 645852 645918 652689 660075 663265 663318 663801 682945 687995 688110 699628 702075 712281 714463 724217 728802 728879 732070 739060 767165 769971 771918 773562 774287 775195 776259 781511 784511 786230 787957 791745 793431 793757 797574 797797 798677 799459 805687 807707 809872 813051 814889 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"выебал лучшую подругÑ%…"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс лучш подружк"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.