Query Metrics
7
Database Queries
7
Different statements
210.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.88 ms (88.35%) |
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 386077 398125 398551 410682 418126 418138 424057 434321 434330 434337 434350 439109 446796 456131 458829 460381 460813 467623 467872 467878 467929 470726 479738 486810 495233 500506 500525 506764 511372 511375 513640 518879 519068 519351 529512 538977 550633 554991 562460 565456 569271 574115 578327 580397 582394 583334 583577 583710 584961 585220 585343 589161 593044 600708 602277 602300 604420 606088 606902 611437 614631 614957 620037 620055 628604 634315 636379 637258 644542 651731 660409 673210 691322 696092 713361 714281 714622 719449 726634 739937 744158 747160 749087 749929 750553 751642 751772 752634 757012 758477 759474 761164 761344 774880 777840 784010 787500 788646 789447 791892 793069 795336 796049 796958 798762 800691 801791 808010 808894 809344 810094 816815 819950 823883 824245 824867 826589 827633 828295 ] |
||||||||||||||||||||||||||||||
|
14.77 ms (7.02%) |
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 582394 495233 583334 585343 759474 750553 614631 410682 467623 550633 660409 511372 500506 747160 789447 761344 506764 713361 398125 424057 824245 826589 819950 824867 816815 827633 823883 574115 580397 554991 651731 691322 714281 673210 696092 719449 584961 637258 620037 600708 636379 589161 611437 788646 796049 798762 777840 784010 791892 801791 809344 751772 800691 808010 808894 810094 739937 751642 744158 726634 757012 761164 602277 604420 644542 714622 774880 793069 386077 398551 434337 418126 752634 606902 634315 795336 446796 456131 614957 630427 749087 467872 467929 796958 749929 565456 458829 529512 439109 434330 434350 460381 486810 479738 538977 500525 562460 583577 583710 569271 578327 593044 620055 585220 602300 606088 628604 787500 434321 418138 460813 470726 513640 511375 519351 828295 467878 519068 758477 518879 ] |
||||||||||||||||||||||||||||||
|
3.31 ms (1.58%) |
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 386077 398125 398551 410682 418126 418138 424057 434321 434330 434337 434350 439109 446796 456131 458829 460381 460813 467623 467872 467878 467929 470726 479738 486810 495233 500506 500525 506764 511372 511375 513640 518879 519068 519351 529512 538977 550633 554991 562460 565456 569271 574115 578327 580397 582394 583334 583577 583710 584961 585220 585343 589161 593044 600708 602277 602300 604420 606088 606902 611437 614631 614957 620037 620055 628604 634315 636379 637258 644542 651731 660409 673210 691322 696092 713361 714281 714622 719449 726634 739937 744158 747160 749087 749929 750553 751642 751772 752634 757012 758477 759474 761164 761344 774880 777840 784010 787500 788646 789447 791892 793069 795336 796049 796958 798762 800691 801791 808010 808894 809344 810094 816815 819950 823883 824245 824867 826589 827633 828295 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo my wife"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд my жен"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд my жен"
]
|
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.