Query Metrics
7
Database Queries
7
Different statements
174.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.61 ms (86.53%) |
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 381903 384108 391392 415746 427191 429703 433241 441129 443391 455132 465470 468524 473446 477081 478542 482795 493515 493838 497708 504482 508197 513697 516043 530306 531836 531929 533734 534536 534565 535766 537171 537897 538749 541270 541575 544493 545209 545225 546952 547420 547434 547464 547465 547472 547499 547857 548957 550218 550904 554321 555077 555220 555288 555376 555407 555992 558718 563075 565724 573270 573728 576985 584364 588393 608174 610061 617807 632107 639363 662914 669010 671038 672952 703471 705362 713505 714122 714694 720195 725642 727507 729277 739151 740744 740877 744061 762381 765355 766680 766698 768348 769100 773877 777120 782657 783374 788131 788185 790958 791252 791625 793838 796333 796904 796941 797444 797969 805509 810278 810294 810297 811118 815162 816596 816970 817765 824883 827207 827431 827484 ] |
||||||||||||||||||||||||||||||
|
12.63 ms (7.26%) |
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 555376 563075 632107 810297 482795 565724 573728 573270 816970 824883 493515 531929 610061 790958 791252 788131 810294 727507 714122 720195 797444 827431 815162 817765 537171 538749 531836 545225 662914 714694 576985 588393 788185 797969 768348 783374 810278 555992 541575 433241 504482 547857 555407 384108 534536 550218 545209 827484 530306 534565 535766 537897 508197 541270 550904 584364 546952 547499 705362 547434 548957 639363 793838 796904 796941 791625 805509 766680 769100 765355 617807 703471 429703 796333 725642 468524 455132 740877 554321 744061 713505 547472 608174 391392 516043 544493 816596 739151 381903 473446 533734 547420 547464 669010 555220 782657 811118 740744 555077 558718 555288 766698 827207 729277 762381 773877 777120 465470 477081 441129 547465 672952 671038 493838 497708 478542 415746 443391 427191 513697 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (1.74%) |
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 381903 384108 391392 415746 427191 429703 433241 441129 443391 455132 465470 468524 473446 477081 478542 482795 493515 493838 497708 504482 508197 513697 516043 530306 531836 531929 533734 534536 534565 535766 537171 537897 538749 541270 541575 544493 545209 545225 546952 547420 547434 547464 547465 547472 547499 547857 548957 550218 550904 554321 555077 555220 555288 555376 555407 555992 558718 563075 565724 573270 573728 576985 584364 588393 608174 610061 617807 632107 639363 662914 669010 671038 672952 703471 705362 713505 714122 714694 720195 725642 727507 729277 739151 740744 740877 744061 762381 765355 766680 766698 768348 769100 773877 777120 782657 783374 788131 788185 790958 791252 791625 793838 796333 796904 796941 797444 797969 805509 810278 810294 810297 811118 815162 816596 816970 817765 824883 827207 827431 827484 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gape anal mature"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие дырк анал mature"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие дырк анал mature"
]
|
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.