Query Metrics
7
Database Queries
7
Different statements
151.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.93 ms (81.63%) |
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 208554 263536 388672 391674 392064 395373 398626 401451 420647 424332 434293 434307 434382 437970 441233 441556 443914 451249 452764 466028 466564 469823 474900 476668 479249 493568 496301 497675 500261 500878 501061 501313 505325 506688 507032 508254 511374 511376 518641 519351 525297 532238 543648 547783 554854 555245 556755 561603 573206 575357 575369 583774 585154 587291 588656 593994 598623 604387 605711 612783 619802 636442 643005 662165 693802 714079 714091 717195 720103 724943 728196 736094 736337 739413 741119 747432 747488 750933 752785 757399 763720 765224 765360 768670 770541 771855 771887 773496 776607 776963 781250 784255 784626 784931 784945 785087 785530 785781 786603 786660 786662 793940 794038 794680 795406 795413 796997 800429 800958 801054 801715 803362 804723 806933 810461 810916 812690 813298 818686 828131 ] |
||||||||||||||||||||||||||||||
|
17.39 ms (11.46%) |
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 543648 575357 612783 776963 747432 728196 752785 768670 750933 771855 736337 776607 506688 573206 619802 593994 796997 434293 434307 497675 511376 828131 263536 786660 813298 401451 643005 588656 598623 208554 500878 508254 561603 388672 420647 474900 451249 507032 518641 479249 720103 555245 781250 784931 786662 800958 810461 810916 812690 784255 795413 757399 801715 736094 771887 739413 770541 773496 785781 395373 500261 801054 714091 714079 501313 556755 786603 747488 525297 493568 547783 636442 784945 693802 585154 443914 441556 532238 501061 575369 662165 784626 724943 741119 765224 785087 794680 800429 765360 434382 437970 441233 496301 476668 587291 785530 795406 763720 452764 466028 511374 519351 804723 803362 717195 424332 554854 583774 604387 466564 469823 605711 391674 818686 806933 793940 794038 398626 392064 505325 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.86%) |
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 208554 263536 388672 391674 392064 395373 398626 401451 420647 424332 434293 434307 434382 437970 441233 441556 443914 451249 452764 466028 466564 469823 474900 476668 479249 493568 496301 497675 500261 500878 501061 501313 505325 506688 507032 508254 511374 511376 518641 519351 525297 532238 543648 547783 554854 555245 556755 561603 573206 575357 575369 583774 585154 587291 588656 593994 598623 604387 605711 612783 619802 636442 643005 662165 693802 714079 714091 717195 720103 724943 728196 736094 736337 739413 741119 747432 747488 750933 752785 757399 763720 765224 765360 768670 770541 771855 771887 773496 776607 776963 781250 784255 784626 784931 784945 785087 785530 785781 786603 786660 786662 793940 794038 794680 795406 795413 796997 800429 800958 801054 801715 803362 804723 806933 810461 810916 812690 813298 818686 828131 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.38%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur squirt"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.04%) |
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.