Query Metrics
7
Database Queries
7
Different statements
216.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.61 ms (85.80%) |
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 328446 330449 387490 442584 443631 453674 457038 457828 459102 459210 461638 463176 469900 490033 490707 499352 499513 499877 503676 509114 517611 527778 530557 532090 537564 537614 537618 540199 545109 550329 550336 550481 554626 554784 555431 564843 567467 568259 573999 574258 574280 576653 577179 578883 580579 584188 584712 590227 591419 591881 591945 594971 595670 601983 603560 604952 606783 618813 621469 632490 632513 635876 638152 641334 644201 645523 645779 648630 648672 648948 649772 650867 651421 656242 668983 668987 668988 671220 672678 690634 692421 696289 696558 698086 707506 708876 714041 724755 725138 726484 729217 729764 732823 733556 736241 745526 746024 750852 761323 762324 768790 769393 773944 776505 778541 779262 785119 788935 789046 792543 793547 794206 794236 799473 800895 803296 810128 810336 817074 818782 ] |
||||||||||||||||||||||||||||||
|
18.60 ms (8.60%) |
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 550336 567467 729217 708876 503676 668987 696289 668988 621469 574258 649772 724755 537614 650867 577179 604952 635876 736241 632490 453674 648672 672678 696558 645523 578883 590227 638152 769393 793547 499513 532090 773944 810336 576653 714041 729764 746024 545109 817074 648630 778541 785119 591419 632513 692421 668983 745526 459210 530557 690634 499352 606783 457828 733556 644201 725138 527778 568259 591945 792543 762324 442584 698086 537564 574280 594971 509114 779262 641334 584712 461638 328446 732823 818782 595670 799473 768790 330449 457038 499877 584188 469900 580579 803296 387490 707506 750852 540199 550481 550329 651421 591881 656242 555431 794206 794236 459102 517611 564843 648948 789046 603560 671220 776505 490707 463176 490033 554626 788935 601983 726484 554784 645779 761323 618813 800895 573999 443631 537618 810128 ] |
||||||||||||||||||||||||||||||
|
4.01 ms (1.85%) |
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 328446 330449 387490 442584 443631 453674 457038 457828 459102 459210 461638 463176 469900 490033 490707 499352 499513 499877 503676 509114 517611 527778 530557 532090 537564 537614 537618 540199 545109 550329 550336 550481 554626 554784 555431 564843 567467 568259 573999 574258 574280 576653 577179 578883 580579 584188 584712 590227 591419 591881 591945 594971 595670 601983 603560 604952 606783 618813 621469 632490 632513 635876 638152 641334 644201 645523 645779 648630 648672 648948 649772 650867 651421 656242 668983 668987 668988 671220 672678 690634 692421 696289 696558 698086 707506 708876 714041 724755 725138 726484 729217 729764 732823 733556 736241 745526 746024 750852 761323 762324 768790 769393 773944 776505 778541 779262 785119 788935 789046 792543 793547 794206 794236 799473 800895 803296 810128 810336 817074 818782 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"films wife fuck"
]
|
||||||||||||||||||||||||||||||
|
2.20 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фильм жен секс"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.68%) |
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.