Query Metrics
7
Database Queries
7
Different statements
226.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
188.44 ms (83.26%) |
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 385380 388151 411036 411044 413464 419147 423988 425578 438077 439601 439668 440988 442695 444041 446293 449158 452388 458005 464391 467888 468019 468281 469066 476331 481964 486884 489127 493115 493280 494207 498425 507214 509272 510918 513023 513630 514390 514680 515133 515624 519655 519994 520015 520020 525369 527168 536547 537483 542369 546898 555377 555410 559052 573746 575031 580127 582431 583205 584766 587157 591338 598325 607569 608931 620579 621344 621712 622976 625947 632186 639010 642928 666068 672825 700821 706569 708150 708573 708587 709325 709404 709807 710682 712634 715373 723175 724921 726975 728478 728808 728937 740347 741053 743497 753033 757434 759356 759739 760602 761889 764234 765514 769158 773908 784624 784667 784876 788528 789968 791117 792819 794761 795058 803489 803826 804721 812067 812384 813416 823786 ] |
||||||||||||||||||||||||||||||
|
26.47 ms (11.70%) |
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 494207 493115 513630 481964 489127 789968 715373 413464 442695 449158 458005 452388 515624 446293 546898 559052 575031 580127 723175 425578 514680 527168 469066 468281 520020 584766 591338 724921 438077 440988 509272 525369 493280 498425 515133 823786 513023 536547 582431 672825 700821 710682 712634 666068 708573 709404 608931 621344 587157 788528 804721 784876 803489 812067 757434 760602 773908 791117 803826 759739 761889 728808 759356 728478 706569 708150 795058 519655 468019 464391 520015 486884 573746 622976 621712 439668 467888 419147 444041 476331 411036 439601 388151 411044 423988 519994 507214 510918 583205 708587 709807 598325 620579 625947 607569 639010 642928 784667 792819 740347 769158 794761 812384 813416 753033 726975 743497 765514 764234 728937 741053 632186 709325 784624 385380 514390 537483 555377 555410 542369 ] |
||||||||||||||||||||||||||||||
|
3.33 ms (1.47%) |
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 385380 388151 411036 411044 413464 419147 423988 425578 438077 439601 439668 440988 442695 444041 446293 449158 452388 458005 464391 467888 468019 468281 469066 476331 481964 486884 489127 493115 493280 494207 498425 507214 509272 510918 513023 513630 514390 514680 515133 515624 519655 519994 520015 520020 525369 527168 536547 537483 542369 546898 555377 555410 559052 573746 575031 580127 582431 583205 584766 587157 591338 598325 607569 608931 620579 621344 621712 622976 625947 632186 639010 642928 666068 672825 700821 706569 708150 708573 708587 709325 709404 709807 710682 712634 715373 723175 724921 726975 728478 728808 728937 740347 741053 743497 753033 757434 759356 759739 760602 761889 764234 765514 769158 773908 784624 784667 784876 788528 789968 791117 792819 794761 795058 803489 803826 804721 812067 812384 813416 823786 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"your mother"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"your мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"your мам женщин"
]
|
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.