Query Metrics
7
Database Queries
7
Different statements
173.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.17 ms (83.86%) |
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 80709 386448 409949 414317 423788 440424 445350 453830 454182 459732 461655 470103 477871 511547 521650 523956 525882 527356 532240 534144 536894 538497 545229 548588 548695 552761 552804 555096 556329 557401 560531 562732 563409 565103 565884 569923 573984 574708 575521 576067 577906 579221 579574 581494 582597 585905 585950 586543 590286 592838 595025 596166 597162 600888 603000 606700 613153 618384 618795 619105 625018 626120 626345 626713 628071 630445 644641 648018 648976 649622 650605 651126 651408 653891 660571 669710 674587 676982 677564 682515 697002 700941 701761 704083 707374 708592 712869 717899 720454 724217 726468 726546 726558 730986 731194 732697 735198 741026 742848 744088 753751 756041 760439 761291 768812 776448 779247 781301 782350 786637 788291 789526 793364 794956 797758 802691 807133 810192 811008 ] |
||||||||||||||||||||||||||||||
|
18.35 ms (10.60%) |
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 562732 563409 545229 548588 548695 552761 555096 556329 565884 573984 576067 577906 581494 649622 651126 677564 682515 700941 717899 720454 648018 648976 651408 653891 704083 707374 708592 712869 659047 660571 669710 674587 676982 552804 575521 582597 592838 595025 596166 585905 606700 618384 626120 630445 586543 618795 619105 626345 585950 600888 603000 626713 779247 793364 760439 781301 726468 726558 730986 744088 761291 768812 731194 735198 756041 613153 625018 628071 644641 782350 788291 810192 811008 511547 523956 80709 414317 440424 445350 454182 461655 470103 532240 534144 536894 538497 527356 557401 560531 579574 565103 574708 650605 569923 579221 590286 597162 802691 789526 797758 753751 742848 724217 726546 732697 741026 697002 701761 776448 786637 794956 807133 386448 453830 459732 423788 409949 477871 521650 525882 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.41%) |
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 80709 386448 409949 414317 423788 440424 445350 453830 454182 459732 461655 470103 477871 511547 521650 523956 525882 527356 532240 534144 536894 538497 545229 548588 548695 552761 552804 555096 556329 557401 560531 562732 563409 565103 565884 569923 573984 574708 575521 576067 577906 579221 579574 581494 582597 585905 585950 586543 590286 592838 595025 596166 597162 600888 603000 606700 613153 618384 618795 619105 625018 626120 626345 626713 628071 630445 644641 648018 648976 649622 650605 651126 651408 653891 660571 669710 674587 676982 677564 682515 697002 700941 701761 704083 707374 708592 712869 717899 720454 724217 726468 726546 726558 730986 731194 732697 735198 741026 742848 744088 753751 756041 760439 761291 768812 776448 779247 781301 782350 786637 788291 789526 793364 794956 797758 802691 807133 810192 811008 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big suck"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие suck"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие suck"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.89%) |
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.