Query Metrics
7
Database Queries
7
Different statements
167.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.82 ms (87.05%) |
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 615 3522 8005 79567 97288 135726 210576 310683 337061 382212 384022 385605 388630 391224 393043 396103 396438 401865 406941 420096 442555 477219 479200 494379 518796 540017 548512 551599 561247 572230 574156 586505 593997 600937 606189 610244 617075 619970 622755 625963 637869 638373 640475 641049 641154 642148 642712 651743 658767 658812 660074 660251 662033 671562 673099 676415 677593 677916 678241 679195 680616 681016 683371 683461 686465 689886 693701 696186 700654 705680 709620 712561 714628 717767 717889 719302 725045 726842 728166 730306 730456 732154 741681 742237 744518 745319 750775 751106 753849 755312 757792 758082 762219 762258 763841 764438 765365 766185 768200 769436 771455 773821 774483 777507 779459 779563 781445 781483 782109 787589 791161 793800 795030 797739 799323 800524 801445 804550 809211 824941 ] |
||||||||||||||||||||||||||||||
|
12.05 ms (7.19%) |
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 660074 420096 683371 719302 709620 660251 751106 755312 641049 401865 686465 781483 681016 714628 658812 779563 799323 442555 677916 700654 762258 762219 741681 135726 717767 610244 728166 732154 745319 777507 742237 793800 619970 642712 782109 3522 824941 787589 574156 693701 730306 622755 774483 768200 689886 804550 758082 671562 396438 750775 638373 337061 617075 385605 561247 696186 765365 676415 683461 726842 705680 388630 600937 757792 797739 769436 779459 781445 730456 801445 637869 658767 678241 572230 744518 763841 79567 679195 771455 586505 791161 766185 97288 651743 800524 717889 809211 518796 384022 540017 625963 8005 548512 753849 382212 396103 764438 310683 593997 615 477219 677593 210576 494379 795030 725045 406941 712561 680616 662033 393043 551599 606189 673099 642148 640475 641154 391224 479200 773821 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (1.95%) |
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 615 3522 8005 79567 97288 135726 210576 310683 337061 382212 384022 385605 388630 391224 393043 396103 396438 401865 406941 420096 442555 477219 479200 494379 518796 540017 548512 551599 561247 572230 574156 586505 593997 600937 606189 610244 617075 619970 622755 625963 637869 638373 640475 641049 641154 642148 642712 651743 658767 658812 660074 660251 662033 671562 673099 676415 677593 677916 678241 679195 680616 681016 683371 683461 686465 689886 693701 696186 700654 705680 709620 712561 714628 717767 717889 719302 725045 726842 728166 730306 730456 732154 741681 742237 744518 745319 750775 751106 753849 755312 757792 758082 762219 762258 763841 764438 765365 766185 768200 769436 771455 773821 774483 777507 779459 779563 781445 781483 782109 787589 791161 793800 795030 797739 799323 800524 801445 804550 809211 824941 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex dick"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс член"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс член"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.82%) |
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.