Query Metrics
7
Database Queries
7
Different statements
181.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.97 ms (87.54%) |
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 381778 389278 392864 401414 411549 417469 420897 454353 456106 473087 481351 483682 485530 490597 495170 496723 498541 500779 515823 516035 517054 519646 522804 529051 531009 536006 537026 537039 537055 538765 539943 541111 541918 543187 544892 547162 548219 549522 559981 563460 568219 575244 579953 582183 595876 597009 599145 600512 601239 601781 603972 608781 615537 621004 631274 633504 644033 644035 648545 652291 652961 654083 660269 663352 670464 671072 671078 677834 691466 696149 696157 708974 709616 729436 735999 740937 743185 744111 744139 751018 751046 751745 753024 753127 753595 754624 754974 755290 757894 758038 758982 772940 773026 777717 779372 780117 782127 786190 786803 789074 800229 807956 808330 810803 812333 816698 816874 817645 819091 819107 819118 819234 820968 821075 822005 822442 823016 823111 823128 825231 ] |
||||||||||||||||||||||||||||||
|
12.13 ms (6.68%) |
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 420897 498541 516035 490597 515823 817645 543187 773026 417469 822442 819234 820968 823016 537039 536006 541918 541111 563460 648545 670464 696149 663352 677834 671078 696157 601239 615537 633504 597009 631274 644033 777717 780117 807956 812333 754624 753595 754974 755290 753024 753127 758038 608781 709616 782127 786190 810803 401414 454353 496723 483682 691466 568219 599145 600512 411549 473087 481351 456106 537026 500779 517054 495170 519646 529051 522804 392864 381778 389278 816698 816874 821075 822005 819107 825231 819091 819118 823111 823128 485530 537055 531009 538765 539943 544892 559981 575244 582183 547162 548219 549522 708974 652291 652961 660269 671072 654083 579953 601781 595876 603972 621004 644035 779372 743185 751745 758982 772940 786803 789074 800229 808330 751018 751046 757894 729436 744111 744139 735999 740937 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.68%) |
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 381778 389278 392864 401414 411549 417469 420897 454353 456106 473087 481351 483682 485530 490597 495170 496723 498541 500779 515823 516035 517054 519646 522804 529051 531009 536006 537026 537039 537055 538765 539943 541111 541918 543187 544892 547162 548219 549522 559981 563460 568219 575244 579953 582183 595876 597009 599145 600512 601239 601781 603972 608781 615537 621004 631274 633504 644033 644035 648545 652291 652961 654083 660269 663352 670464 671072 671078 677834 691466 696149 696157 708974 709616 729436 735999 740937 743185 744111 744139 751018 751046 751745 753024 753127 753595 754624 754974 755290 757894 758038 758982 772940 773026 777717 779372 780117 782127 786190 786803 789074 800229 807956 808330 810803 812333 816698 816874 817645 819091 819107 819118 819234 820968 821075 822005 822442 823016 823111 823128 825231 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful solo girl"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая соло девушк"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая соло девушк"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.