Query Metrics
7
Database Queries
7
Different statements
153.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.38 ms (82.83%) |
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 199865 359260 395349 397780 400226 400696 401814 405775 416832 417077 448180 459514 460395 463115 472812 473278 475983 476971 493314 494165 501039 513482 514719 522857 523943 528350 532286 542174 542487 544353 546839 549959 554702 554717 559785 564242 566912 569530 580384 582461 586186 591888 598789 605290 606090 609653 609765 613579 616457 618069 618967 626824 637988 649863 651075 655509 660115 660279 661371 662861 664119 672369 681546 683568 691542 692437 693126 695968 696044 698214 701321 702506 714842 718904 721920 723383 725441 728261 729567 732739 739347 757569 758064 759313 765577 767495 777229 783535 787642 794030 799017 801589 804271 804877 805225 809945 810644 812890 813585 813589 814058 814163 823775 825147 828006 828038 828066 828160 828171 828224 828265 828327 828338 828340 828377 828410 828642 ] |
||||||||||||||||||||||||||||||
|
15.61 ms (10.15%) |
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 729567 757569 783535 804271 810644 823775 828171 828265 828410 828054 828038 828338 828642 544353 397780 813585 463115 493314 514719 522857 532286 501039 460395 662861 695968 649863 696044 613579 591888 618967 799017 718904 681546 416832 448180 475983 661371 672369 655509 660115 586186 794030 804877 805225 812890 725441 618069 698214 809945 359260 400696 528350 828327 767495 822787 825147 828066 828377 828160 701321 549959 199865 692437 637988 473278 566912 559785 564242 523943 513482 582461 616457 823899 828340 828224 400226 494165 546839 542174 580384 693126 721920 664119 683568 691542 714842 598789 609765 777229 801589 787642 732739 728261 405775 651075 723383 605290 759313 476971 569530 660279 609653 702506 401814 554702 554717 626824 828006 542487 606090 758064 765577 739347 472812 395349 417077 813589 814163 814058 459514 ] |
||||||||||||||||||||||||||||||
|
3.57 ms (2.32%) |
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 199865 359260 395349 397780 400226 400696 401814 405775 416832 417077 448180 459514 460395 463115 472812 473278 475983 476971 493314 494165 501039 513482 514719 522857 523943 528350 532286 542174 542487 544353 546839 549959 554702 554717 559785 564242 566912 569530 580384 582461 586186 591888 598789 605290 606090 609653 609765 613579 616457 618069 618967 626824 637988 649863 651075 655509 660115 660279 661371 662861 664119 672369 681546 683568 691542 692437 693126 695968 696044 698214 701321 702506 714842 718904 721920 723383 725441 728261 729567 732739 739347 757569 758064 759313 765577 767495 777229 783535 787642 794030 799017 801589 804271 804877 805225 809945 810644 812890 813585 813589 814058 814163 823775 825147 828006 828038 828066 828160 828171 828224 828265 828327 828338 828340 828377 828410 828642 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на cock улиц"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public cock"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на cock улиц"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.11%) |
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.