Query Metrics
7
Database Queries
7
Different statements
212.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.26 ms (85.81%) |
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 69969 311697 383119 385634 385826 389258 389565 391149 391241 393027 419094 419273 425641 425916 432414 440533 446175 456062 466905 472657 473542 474442 475491 494952 506487 509632 527321 531265 532985 536217 544613 568671 578404 583569 586268 591015 603795 604916 606792 610107 610163 612233 613697 621840 626351 630666 636719 640865 642115 643455 650374 653004 657143 666483 685492 714942 716364 716534 718287 718919 724797 724839 725004 726052 727972 728467 728563 728615 730280 731609 733445 734218 737828 738212 738475 739646 740057 741199 746587 747942 747951 749047 749969 750692 751478 759107 759812 761609 761834 763697 765408 766242 766519 768144 769256 775617 779949 779973 781060 781097 783768 784103 784340 786713 788386 788662 792591 794590 796283 796720 798535 800071 801064 801982 808619 808712 811130 819926 824848 825073 ] |
||||||||||||||||||||||||||||||
|
16.98 ms (8.00%) |
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 784340 808619 724839 725004 730280 739646 765408 759812 747942 751478 741199 761609 630666 642115 775617 779949 432414 475491 440533 801064 825073 531265 568671 583569 653004 650374 610107 591015 610163 643455 801982 796720 728563 726052 728467 746587 666483 781097 750692 466905 509632 626351 796283 759107 734218 728615 740057 798535 456062 604916 425641 425916 419273 472657 473542 474442 527321 532985 716534 586268 636719 808712 788386 800071 769256 727972 768144 731609 446175 391149 391241 603795 738212 385826 385634 393027 69969 389565 419094 819926 824848 494952 536217 506487 544613 578404 657143 685492 718287 718919 714942 716364 613697 621840 640865 606792 612233 779973 811130 781060 784103 794590 749047 783768 788662 792591 737828 724797 738475 766519 733445 747951 766242 749969 761834 763697 786713 383119 311697 389258 ] |
||||||||||||||||||||||||||||||
|
4.12 ms (1.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cumshot tits"
]
|
||||||||||||||||||||||||||||||
|
3.14 ms (1.48%) |
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 69969 311697 383119 385634 385826 389258 389565 391149 391241 393027 419094 419273 425641 425916 432414 440533 446175 456062 466905 472657 473542 474442 475491 494952 506487 509632 527321 531265 532985 536217 544613 568671 578404 583569 586268 591015 603795 604916 606792 610107 610163 612233 613697 621840 626351 630666 636719 640865 642115 643455 650374 653004 657143 666483 685492 714942 716364 716534 718287 718919 724797 724839 725004 726052 727972 728467 728563 728615 730280 731609 733445 734218 737828 738212 738475 739646 740057 741199 746587 747942 747951 749047 749969 750692 751478 759107 759812 761609 761834 763697 765408 766242 766519 768144 769256 775617 779949 779973 781060 781097 783768 784103 784340 786713 788386 788662 792591 794590 796283 796720 798535 800071 801064 801982 808619 808712 811130 819926 824848 825073 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cumshot сиськ"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cumshot сиськ"
]
|
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.