Query Metrics
7
Database Queries
7
Different statements
148.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.32 ms (82.26%) |
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 16882 88614 154576 381903 392843 398741 401177 427232 428174 428282 428568 428956 439531 439993 441067 442172 443198 447151 452800 462553 470479 471124 471455 473437 473446 479277 480206 480470 481904 482190 484065 484809 488713 495757 495762 496337 510797 513963 513971 514016 514220 514695 514879 516676 525700 529392 529574 529626 529658 531336 533581 536233 537237 544132 548857 550176 550916 554530 558010 559234 559290 563992 568500 571726 574138 574458 576848 587559 599875 605199 627224 632636 636309 639716 639809 642004 642018 647895 651132 657697 658787 662159 666850 666872 666876 666878 669054 669058 672913 677307 679016 680200 688181 689358 697236 704641 708536 713504 739151 742355 744383 745083 745135 750145 752705 756773 766945 769066 787514 788354 789208 796706 796883 800706 811013 811733 821359 822638 822969 ] |
||||||||||||||||||||||||||||||
|
17.16 ms (11.54%) |
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 531336 439993 471455 428568 480470 513971 513963 550176 689358 574458 811013 481904 529392 536233 642018 599875 632636 636309 544132 688181 745083 666850 657697 789208 554530 563992 443198 470479 516676 480206 401177 488713 381903 473446 800706 442172 666872 452800 482190 495757 533581 496337 514220 559290 514695 525700 428174 484809 484065 571726 428282 647895 680200 796706 756773 529574 766945 750145 787514 529658 392843 88614 16882 821359 822969 529626 537237 651132 672913 708536 587559 788354 796883 744383 742355 627224 697236 811733 154576 495762 548857 769066 745135 510797 514016 677307 639716 514879 658787 447151 471124 550916 669054 473437 739151 713504 398741 559234 558010 642004 752705 471695 439531 462553 568500 479277 576848 605199 666878 441067 639809 669058 679016 666876 427232 428956 822638 574138 662159 704641 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.88%) |
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 16882 88614 154576 381903 392843 398741 401177 427232 428174 428282 428568 428956 439531 439993 441067 442172 443198 447151 452800 462553 470479 471124 471455 473437 473446 479277 480206 480470 481904 482190 484065 484809 488713 495757 495762 496337 510797 513963 513971 514016 514220 514695 514879 516676 525700 529392 529574 529626 529658 531336 533581 536233 537237 544132 548857 550176 550916 554530 558010 559234 559290 563992 568500 571726 574138 574458 576848 587559 599875 605199 627224 632636 636309 639716 639809 642004 642018 647895 651132 657697 658787 662159 666850 666872 666876 666878 669054 669058 672913 677307 679016 680200 688181 689358 697236 704641 708536 713504 739151 742355 744383 745083 745135 750145 752705 756773 766945 769066 787514 788354 789208 796706 796883 800706 811013 811733 821359 822638 822969 ] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass fisting girls"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп фистинг девушк"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.