Query Metrics
7
Database Queries
7
Different statements
144.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.91 ms (84.36%) |
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 386759 389788 392100 397872 398869 406596 411382 414172 432272 436005 439727 445145 451219 453373 454926 460084 468402 480038 481441 485136 504083 504967 515996 519318 529338 534480 537436 542264 547584 552697 555992 568093 568530 579858 580597 584257 585356 586897 589487 590941 592644 597632 598297 598539 602233 604340 604815 613494 616292 618852 619102 620480 623211 623420 624156 626316 637010 640408 651873 657256 660026 661991 667084 668086 671461 671659 685949 692423 704958 711802 717712 717832 722538 722597 723300 726986 726992 728356 729295 730744 737450 738451 745121 746892 747457 750141 750269 758461 759914 764135 765096 765240 765266 768756 769787 769917 770113 771715 774250 783364 785480 785538 790832 791422 791803 792100 794142 794855 794859 794908 795309 795315 795977 796153 797223 798823 803900 803981 811655 814448 ] |
||||||||||||||||||||||||||||||
|
12.92 ms (8.94%) |
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 795315 598297 671659 398869 803981 791803 726986 579858 519318 392100 657256 711802 774250 758461 552697 765266 640408 623420 389788 747457 436005 481441 604815 584257 783364 769787 468402 798823 728356 620480 451219 515996 722538 624156 790832 454926 613494 411382 602233 685949 585356 792100 445145 619102 453373 485136 537436 568093 504967 722597 568530 723300 604340 811655 738451 745121 717712 791422 803900 637010 759914 795977 730744 542264 414172 386759 769917 661991 796153 406596 589487 597632 439727 626316 794859 795309 750141 765240 668086 667084 692423 729295 794142 794855 765096 764135 704958 794908 770113 797223 618852 598539 771715 504083 768756 534480 651873 717832 432272 529338 555992 580597 590941 671461 750269 592644 480038 785480 460084 547584 746892 726992 737450 785538 397872 814448 660026 623211 586897 616292 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.81%) |
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 386759 389788 392100 397872 398869 406596 411382 414172 432272 436005 439727 445145 451219 453373 454926 460084 468402 480038 481441 485136 504083 504967 515996 519318 529338 534480 537436 542264 547584 552697 555992 568093 568530 579858 580597 584257 585356 586897 589487 590941 592644 597632 598297 598539 602233 604340 604815 613494 616292 618852 619102 620480 623211 623420 624156 626316 637010 640408 651873 657256 660026 661991 667084 668086 671461 671659 685949 692423 704958 711802 717712 717832 722538 722597 723300 726986 726992 728356 729295 730744 737450 738451 745121 746892 747457 750141 750269 758461 759914 764135 765096 765240 765266 768756 769787 769917 770113 771715 774250 783364 785480 785538 790832 791422 791803 792100 794142 794855 794859 794908 795309 795315 795977 796153 797223 798823 803900 803981 811655 814448 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass sex anal"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп секс анал"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.