Query Metrics
7
Database Queries
7
Different statements
176.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.35 ms (87.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 48547 69589 85949 150261 353299 387648 391526 397106 398753 399021 400518 404084 414765 420323 469292 474364 511462 514670 517461 522565 536958 536993 537628 537637 545218 548268 555533 556257 558660 580487 582864 583314 585769 588124 589316 591516 595843 598131 602730 613351 625122 627268 628686 628776 629816 636671 637904 639368 650881 651420 662920 665999 666019 666686 667181 670273 683484 689175 689245 695545 695773 702971 702993 705224 710419 713413 715787 718592 718872 718910 724010 725044 726019 729587 730928 732634 734270 738377 741268 742678 746036 747068 749076 749639 752019 754173 754864 757760 758912 759965 760874 761504 762819 765424 770592 771027 771730 773116 776528 778770 779418 780376 783964 787286 788008 788592 789282 795722 797019 797344 798235 798675 801113 801325 802475 803242 804060 809362 812458 814716 ] |
||||||||||||||||||||||||||||||
|
12.84 ms (7.29%) |
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 517461 689245 474364 391526 556257 695545 670273 589316 797344 801113 778770 725044 754864 758912 747068 812458 353299 588124 797019 759965 742678 536958 724010 702971 776528 803242 718910 420323 814716 537628 558660 665999 689175 667181 580487 636671 628686 595843 637904 613351 639368 779418 788008 795722 771027 746036 757760 789282 69589 48547 469292 522565 585769 629816 591516 545218 548268 650881 732634 713413 798675 582864 683484 662920 715787 583314 787286 804060 783964 788592 760874 780376 666019 754173 695773 397106 404084 511462 537637 666686 702993 705224 718872 718592 602730 598131 627268 628776 802475 741268 752019 765424 773116 726019 729587 738377 749076 734270 762819 771730 625122 710419 400518 414765 398753 85949 387648 770592 798235 801325 809362 651420 761504 730928 555533 399021 150261 749639 514670 536993 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.61%) |
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 48547 69589 85949 150261 353299 387648 391526 397106 398753 399021 400518 404084 414765 420323 469292 474364 511462 514670 517461 522565 536958 536993 537628 537637 545218 548268 555533 556257 558660 580487 582864 583314 585769 588124 589316 591516 595843 598131 602730 613351 625122 627268 628686 628776 629816 636671 637904 639368 650881 651420 662920 665999 666019 666686 667181 670273 683484 689175 689245 695545 695773 702971 702993 705224 710419 713413 715787 718592 718872 718910 724010 725044 726019 729587 730928 732634 734270 738377 741268 742678 746036 747068 749076 749639 752019 754173 754864 757760 758912 759965 760874 761504 762819 765424 770592 771027 771730 773116 776528 778770 779418 780376 783964 787286 788008 788592 789282 795722 797019 797344 798235 798675 801113 801325 802475 803242 804060 809362 812458 814716 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"трахается с другом мужа"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс друг жен"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.88%) |
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.