Query Metrics
7
Database Queries
7
Different statements
171.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.75 ms (85.66%) |
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 383049 385141 385480 385963 391277 398744 399036 404383 405831 409941 411459 412134 422192 423855 423948 434338 439749 440629 443836 444078 446450 451115 457096 457313 457603 458031 458080 458882 460489 461828 461919 469009 470860 472198 483024 485439 486233 487820 488157 490250 492088 492410 493042 496236 499054 501681 502885 504313 509867 510769 510884 510930 511596 512066 512216 512480 514264 515065 516023 518506 519577 520549 520729 523435 525584 526494 527983 533631 538199 538971 540988 546864 552867 555984 558327 560266 584453 585330 588956 590265 592178 592979 593935 596898 597568 601355 603059 604660 607181 611517 617214 621160 621186 622777 631701 634671 657780 662454 675071 675126 681539 684704 694142 697457 701936 711569 720645 725514 733480 738175 739557 741504 742636 761039 761097 766337 788810 789915 791916 819262 ] |
||||||||||||||||||||||||||||||
|
15.79 ms (9.21%) |
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 486233 601355 585330 597568 733480 725514 766337 622777 621186 657780 662454 711569 788810 720645 523435 399036 515065 739557 558327 701936 761097 409941 819262 552867 634671 516023 684704 444078 603059 596898 518506 457603 675126 631701 492088 510930 584453 383049 443836 512066 560266 411459 509867 488157 789915 493042 458882 607181 492410 694142 423855 446450 741504 458031 434338 742636 510884 504313 761039 451115 385480 791916 423948 617214 398744 738175 457313 499054 697457 385963 611517 458080 525584 496236 538199 604660 460489 675071 422192 391277 588956 538971 546864 593935 555984 527983 502885 440629 457096 461828 412134 439749 510769 519577 405831 385141 540988 681539 533631 404383 590265 511596 526494 520549 472198 592178 512216 520729 514264 621160 469009 501681 470860 483024 485439 592979 461919 490250 512480 487820 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.65%) |
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 383049 385141 385480 385963 391277 398744 399036 404383 405831 409941 411459 412134 422192 423855 423948 434338 439749 440629 443836 444078 446450 451115 457096 457313 457603 458031 458080 458882 460489 461828 461919 469009 470860 472198 483024 485439 486233 487820 488157 490250 492088 492410 493042 496236 499054 501681 502885 504313 509867 510769 510884 510930 511596 512066 512216 512480 514264 515065 516023 518506 519577 520549 520729 523435 525584 526494 527983 533631 538199 538971 540988 546864 552867 555984 558327 560266 584453 585330 588956 590265 592178 592979 593935 596898 597568 601355 603059 604660 607181 611517 617214 621160 621186 622777 631701 634671 657780 662454 675071 675126 681539 684704 694142 697457 701936 711569 720645 725514 733480 738175 739557 741504 742636 761039 761097 766337 788810 789915 791916 819262 ] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"doggy style sex"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рак style секс"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак style секс"
]
|
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.