Query Metrics
7
Database Queries
7
Different statements
164.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.34 ms (85.21%) |
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 4375 48547 68421 79567 97765 234736 389708 390838 391490 391773 395993 398121 401614 403984 429707 435581 441068 444197 457935 475611 480593 487570 500094 504175 521036 530462 531739 535725 542886 544053 547087 548155 551734 558610 560555 562691 566997 582529 583528 584026 585523 586711 589199 591063 595229 596286 600158 608273 610741 614281 614498 617145 623951 626096 626804 644613 653336 653479 659168 664498 671419 675630 679242 681748 689684 693011 696753 699194 700039 700357 701000 701613 706545 717801 719302 723196 737177 738256 740520 743745 750392 750623 751088 753053 754994 755006 758449 762240 763956 764246 766301 766420 772605 778734 779595 782998 783131 786405 786589 786851 787334 787679 789477 789803 790293 790511 791764 791913 791961 792288 792672 798898 803161 803638 804857 807048 808562 810799 814241 ] |
||||||||||||||||||||||||||||||
|
13.59 ms (8.25%) |
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 535725 480593 487570 679242 706545 585523 614498 644613 530462 671419 719302 562691 626096 755006 772605 403984 4375 738256 758449 547087 551734 566997 789477 521036 542886 701613 689684 596286 600158 608273 753053 737177 457935 531739 803638 763956 772628 584026 79567 435581 814241 475611 786589 790293 807048 786405 766420 750392 390838 398121 582529 664498 791913 791961 808562 787334 790511 750623 751088 700357 779595 444197 391773 681748 500094 544053 548155 659168 675630 653336 653479 693011 700039 583528 589199 617145 623951 591063 595229 586711 791764 786851 614281 699194 97765 504175 610741 626804 558610 696753 401614 389708 68421 783131 792288 395993 792672 740520 804857 762240 766301 754994 717801 723196 782998 787679 803161 48547 429707 560555 789803 743745 778734 798898 810799 234736 391490 764246 701000 441068 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.86%) |
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 4375 48547 68421 79567 97765 234736 389708 390838 391490 391773 395993 398121 401614 403984 429707 435581 441068 444197 457935 475611 480593 487570 500094 504175 521036 530462 531739 535725 542886 544053 547087 548155 551734 558610 560555 562691 566997 582529 583528 584026 585523 586711 589199 591063 595229 596286 600158 608273 610741 614281 614498 617145 623951 626096 626804 644613 653336 653479 659168 664498 671419 675630 679242 681748 689684 693011 696753 699194 700039 700357 701000 701613 706545 717801 719302 723196 737177 738256 740520 743745 750392 750623 751088 753053 754994 755006 758449 762240 763956 764246 766301 766420 772605 778734 779595 782998 783131 786405 786589 786851 787334 787679 789477 789803 790293 790511 791764 791913 791961 792288 792672 798898 803161 803638 804857 807048 808562 810799 814241 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"брюнетка дома частное…"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"черноволосая домашн любительск любительск"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.06%) |
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.