Query Metrics
7
Database Queries
7
Different statements
172.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.62 ms (81.89%) |
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 435948 436848 445673 452285 455971 455980 457510 457846 462352 463026 463990 464856 467647 470227 473393 473679 473784 478140 479160 480187 487864 499325 500670 501968 502194 504937 505298 506122 514103 521898 524813 525852 528849 529426 534428 534470 539469 541727 544976 545675 553332 556104 556976 557670 558381 559847 560185 560979 561309 562345 564715 565612 566338 568922 569318 570136 571838 572332 573444 574153 575009 577608 578293 578295 583344 587922 590265 590641 592212 592955 593163 593469 593764 597892 598466 599189 599289 601728 602007 603859 605249 605646 605683 607086 607303 609827 609848 615966 618673 623416 624501 626858 626960 627316 629863 644490 651572 660109 662374 672240 678896 689436 771398 775015 775351 776521 777003 778487 779971 781511 781826 790504 790742 792171 797680 799063 801234 803531 806802 811175 ] |
||||||||||||||||||||||||||||||
|
18.77 ms (10.85%) |
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 487864 501968 534428 539469 500670 502194 504937 505298 524813 534470 506122 514103 525852 499325 521898 528849 529426 480187 541727 545675 556104 565612 572332 577608 583344 544976 553332 557670 562345 564715 569318 571838 573444 575009 558381 566338 570136 651572 662374 689436 660109 678896 672240 556976 559847 560185 560979 561309 568922 574153 578293 578295 592955 593163 601728 602007 605646 615966 587922 590265 605249 607086 607303 623416 590641 593469 599189 603859 605683 609827 624501 626858 644490 592212 593764 597892 598466 599289 618673 627316 775351 806802 776521 778487 779971 781511 781826 790742 797680 799063 811175 801234 771398 609848 626960 629863 775015 777003 790504 792171 803531 435948 445673 462352 436848 452285 455980 463990 464856 473679 478140 479160 455971 457510 457846 463026 467647 470227 473393 473784 ] |
||||||||||||||||||||||||||||||
|
3.74 ms (2.16%) |
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 435948 436848 445673 452285 455971 455980 457510 457846 462352 463026 463990 464856 467647 470227 473393 473679 473784 478140 479160 480187 487864 499325 500670 501968 502194 504937 505298 506122 514103 521898 524813 525852 528849 529426 534428 534470 539469 541727 544976 545675 553332 556104 556976 557670 558381 559847 560185 560979 561309 562345 564715 565612 566338 568922 569318 570136 571838 572332 573444 574153 575009 577608 578293 578295 583344 587922 590265 590641 592212 592955 593163 593469 593764 597892 598466 599189 599289 601728 602007 603859 605249 605646 605683 607086 607303 609827 609848 615966 618673 623416 624501 626858 626960 627316 629863 644490 651572 660109 662374 672240 678896 689436 771398 775015 775351 776521 777003 778487 779971 781511 781826 790504 790742 792171 797680 799063 801234 803531 806802 811175 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов hard"
]
|
||||||||||||||||||||||||||||||
|
2.36 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov hard"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов hard"
]
|
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.