Query Metrics
7
Database Queries
7
Different statements
177.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.88 ms (87.16%) |
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 233335 381959 390707 391880 392554 397950 403780 420577 420702 423946 426785 431608 433822 444119 444129 444246 453647 454136 457018 459599 459679 461997 462738 465784 466304 466974 470090 470542 470687 471554 471571 473975 475343 478403 488070 494030 494575 495047 498123 500019 504169 525714 533761 533785 534497 534499 535618 537085 539366 543719 544053 558343 562492 566866 567058 571454 574018 578013 578825 588822 595355 597031 599355 600197 600208 600477 602868 620091 628206 641029 645895 650290 663166 663828 673163 675355 685127 687859 688768 692440 692445 694660 695097 705856 708182 734189 741931 752708 761782 762166 762277 764101 764122 766011 768042 778154 778613 779124 782776 783609 784696 786093 786597 790260 790401 792242 796537 799680 803230 803842 804853 811209 817987 818105 819786 824946 825752 ] |
||||||||||||||||||||||||||||||
|
12.08 ms (6.80%) |
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 805512 734189 764122 433822 462738 431608 495047 471554 381959 470542 470687 539366 544053 695097 578825 600208 461997 534497 663166 692445 470090 471571 533785 543719 779124 782776 784696 786093 786597 803842 766011 768042 741931 778154 804853 444246 459599 459679 233335 390707 420577 500019 535618 504169 494030 566866 562492 645895 650290 675355 692440 687859 694660 571454 588822 595355 600197 783609 791973 752708 762277 761782 708182 444119 465784 453647 466304 498123 525714 494575 803230 778613 817987 457018 790401 762166 423946 426785 403780 391880 818105 825752 819786 790260 397950 558343 392554 444129 420702 475343 705856 578013 790440 764101 824946 533761 534499 537085 574018 673163 688768 663828 641029 600477 628206 599355 602868 792242 796537 799680 811209 685127 620091 597031 567058 488070 478403 466974 454136 473975 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (1.87%) |
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 233335 381959 390707 391880 392554 397950 403780 420577 420702 423946 426785 431608 433822 444119 444129 444246 453647 454136 457018 459599 459679 461997 462738 465784 466304 466974 470090 470542 470687 471554 471571 473975 475343 478403 488070 494030 494575 495047 498123 500019 504169 525714 533761 533785 534497 534499 535618 537085 539366 543719 544053 558343 562492 566866 567058 571454 574018 578013 578825 588822 595355 597031 599355 600197 600208 600477 602868 620091 628206 641029 645895 650290 663166 663828 673163 675355 685127 687859 688768 692440 692445 694660 695097 705856 708182 734189 741931 752708 761782 762166 762277 764101 764122 766011 768042 778154 778613 779124 782776 783609 784696 786093 786597 790260 790401 792242 796537 799680 803230 803842 804853 811209 817987 818105 819786 824946 825752 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian teens amateur"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск teens любительск"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск teens любительск"
]
|
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.