Query Metrics
7
Database Queries
7
Different statements
191.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.25 ms (86.47%) |
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 25461 194507 382212 382977 383841 387046 398519 403377 403382 405623 422641 424720 424739 427081 432256 445206 448643 452208 458738 459820 461504 470609 471580 474564 475188 478693 479996 487085 488221 492668 501835 502377 506483 508823 513891 515790 522273 524277 526015 535862 541967 548669 549163 552135 552138 552144 552358 554265 556318 563516 564735 568847 569954 572858 575054 575129 575758 579170 584661 589141 589737 589785 591236 594760 594853 594950 599475 601265 603027 606179 610601 611588 611716 611890 611894 611933 611941 612029 612038 612049 617675 618774 619120 622587 630607 632279 632318 643247 643652 645316 664514 667799 667846 671306 691674 698450 703646 712558 714127 715148 716547 721438 721610 724863 729588 731092 732501 735846 758201 776776 780752 785619 787141 796507 797905 799453 804125 810682 820094 ] |
||||||||||||||||||||||||||||||
|
15.12 ms (7.91%) |
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 787141 785619 703646 721610 804125 612049 194507 487085 383841 820094 556318 548669 610601 632318 732501 382212 382977 508823 403382 535862 575129 664514 721438 667846 599475 612029 731092 617675 714127 479996 424720 603027 554265 572858 552138 552358 563516 589141 632279 729588 715148 475188 478693 461504 448643 552135 645316 643652 591236 735846 459820 522273 492668 691674 611890 716547 810682 622587 589737 619120 643247 780752 536850 568847 575054 667799 594950 797905 724863 398519 424739 445206 502377 526015 611894 776776 474564 387046 471580 569954 549163 564735 589785 594853 606179 630607 799453 422641 470609 515790 513891 552144 601265 611588 611933 405623 458738 541967 758201 612038 698450 611716 594760 611941 25461 712558 618774 796507 452208 506483 524277 488221 584661 575758 671306 579170 403377 427081 501835 432256 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.52%) |
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 25461 194507 382212 382977 383841 387046 398519 403377 403382 405623 422641 424720 424739 427081 432256 445206 448643 452208 458738 459820 461504 470609 471580 474564 475188 478693 479996 487085 488221 492668 501835 502377 506483 508823 513891 515790 522273 524277 526015 535862 541967 548669 549163 552135 552138 552144 552358 554265 556318 563516 564735 568847 569954 572858 575054 575129 575758 579170 584661 589141 589737 589785 591236 594760 594853 594950 599475 601265 603027 606179 610601 611588 611716 611890 611894 611933 611941 612029 612038 612049 617675 618774 619120 622587 630607 632279 632318 643247 643652 645316 664514 667799 667846 671306 691674 698450 703646 712558 714127 715148 716547 721438 721610 724863 729588 731092 732501 735846 758201 776776 780752 785619 787141 796507 797905 799453 804125 810682 820094 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck the money"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс money"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс money"
]
|
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.