Query Metrics
7
Database Queries
7
Different statements
170.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.08 ms (85.45%) |
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 31134 233186 251363 384582 395511 395750 395934 400447 423129 451095 454029 464519 465001 466597 466725 467805 471449 476208 483032 492392 492444 498238 503811 505233 505261 508863 512046 516259 516808 534589 534713 536217 544879 550437 557162 559205 572943 575019 590496 590849 605526 605914 605963 606728 620780 626240 626819 626844 638963 642679 648513 650731 663956 670238 672322 674119 678778 678782 678790 679826 693870 694122 698834 704875 707786 709065 725943 726493 726681 727399 728008 731416 734227 737521 747951 751472 755252 756074 759416 759477 767399 768691 770144 770211 773084 774244 776025 777641 780704 781633 781822 785274 785848 786713 789139 789754 790029 790602 794238 799441 799632 800249 801637 806341 810184 812089 814082 814092 815421 816011 816822 817367 817618 818823 820106 820690 822235 822289 823585 825760 ] |
||||||||||||||||||||||||||||||
|
14.28 ms (8.35%) |
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 670238 693870 707786 590496 605914 606728 626240 626844 642679 605526 605963 626819 790602 734227 728008 747951 725943 726493 726681 786713 790029 806341 810184 816011 822235 508863 512046 709065 698834 620780 590849 727399 731416 781633 466597 663956 678778 679826 678782 678790 395934 814092 557162 650731 672322 799441 756074 755252 704875 638963 400447 572943 575019 780704 737521 233186 454029 251363 467805 464519 505233 498238 534589 550437 492392 534713 466725 648513 384582 465001 516259 476208 471449 451095 483032 503811 516808 395750 31134 817618 823585 817367 536217 544879 559205 694122 674119 781822 785848 801637 776025 777641 789754 794238 800249 812089 789139 799632 768691 770211 774244 751472 759477 767399 770144 759416 773084 785274 505261 395511 423129 814082 815421 818823 820106 820690 816822 822289 825760 492444 ] |
||||||||||||||||||||||||||||||
|
3.58 ms (2.09%) |
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 31134 233186 251363 384582 395511 395750 395934 400447 423129 451095 454029 464519 465001 466597 466725 467805 471449 476208 483032 492392 492444 498238 503811 505233 505261 508863 512046 516259 516808 534589 534713 536217 544879 550437 557162 559205 572943 575019 590496 590849 605526 605914 605963 606728 620780 626240 626819 626844 638963 642679 648513 650731 663956 670238 672322 674119 678778 678782 678790 679826 693870 694122 698834 704875 707786 709065 725943 726493 726681 727399 728008 731416 734227 737521 747951 751472 755252 756074 759416 759477 767399 768691 770144 770211 773084 774244 776025 777641 780704 781633 781822 785274 785848 786713 789139 789754 790029 790602 794238 799441 799632 800249 801637 806341 810184 812089 814082 814092 815421 816011 816822 817367 817618 818823 820106 820690 822235 822289 823585 825760 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old handjob"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old дрочк член"
]
|
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.