Query Metrics
7
Database Queries
7
Different statements
142.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.28 ms (85.56%) |
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 12713 107362 381876 386384 386698 392959 393124 400579 407171 411675 421571 426628 430455 437657 441822 441841 441965 453007 453641 456775 466289 477132 477168 477460 478630 480551 480976 481259 482573 483907 484886 485020 487871 489074 492346 503397 505451 506206 508853 510543 511042 511332 516664 516824 517620 518819 521254 521765 522757 523583 529742 531884 532018 532057 534928 535297 537009 537116 539788 541509 542341 542346 543165 551899 552275 555355 556652 558390 558949 561008 562219 570111 580382 584940 594934 594949 604287 613651 614566 626096 626572 626928 627666 637783 638906 646964 653437 655260 656625 662459 662900 686231 687150 690988 714558 725998 729923 735498 737720 742712 750622 769708 774156 792589 793765 794945 794995 796031 796726 796742 799896 808259 811264 813145 813940 814693 817011 817721 817887 ] |
||||||||||||||||||||||||||||||
|
11.45 ms (8.01%) |
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 521254 511332 386698 107362 393124 392959 12713 430455 441965 813940 817887 814693 817721 817011 482573 456775 477168 478630 485020 492346 487871 516824 537116 505451 518819 522757 523583 532057 535297 529742 531884 534928 539788 532018 489074 542346 562219 580382 584940 551899 558390 570111 541509 542341 555355 556652 655260 646964 656625 662900 686231 690988 714558 573272 594934 637783 604287 614566 626572 626928 627666 638906 594949 613651 626096 793765 794945 813145 796031 796726 799896 729923 811264 750622 742712 769708 774156 735498 792589 794995 796742 808259 386384 453641 480551 407171 481259 381876 400579 466289 484886 508853 510543 437657 441841 421571 480976 426628 517620 737720 537009 543165 441822 662459 558949 725998 477132 511042 506206 411675 453007 477460 483907 516664 521765 503397 552275 653437 687150 561008 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.85%) |
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 12713 107362 381876 386384 386698 392959 393124 400579 407171 411675 421571 426628 430455 437657 441822 441841 441965 453007 453641 456775 466289 477132 477168 477460 478630 480551 480976 481259 482573 483907 484886 485020 487871 489074 492346 503397 505451 506206 508853 510543 511042 511332 516664 516824 517620 518819 521254 521765 522757 523583 529742 531884 532018 532057 534928 535297 537009 537116 539788 541509 542341 542346 543165 551899 552275 555355 556652 558390 558949 561008 562219 570111 580382 584940 594934 594949 604287 613651 614566 626096 626572 626928 627666 637783 638906 646964 653437 655260 656625 662459 662900 686231 687150 690988 714558 725998 729923 735498 737720 742712 750622 769708 774156 792589 793765 794945 794995 796031 796726 796742 799896 808259 811264 813145 813940 814693 817011 817721 817887 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife humiliation"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен доминирован"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.94%) |
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.