Query Metrics
7
Database Queries
7
Different statements
233.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.14 ms (89.86%) |
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 1117 382069 384774 385004 387007 390990 392033 396594 397290 399554 399887 401780 405858 410255 418297 419103 420403 420775 423305 425290 426431 428380 444987 445702 454794 460005 466483 473994 475503 487162 495928 504913 506144 516611 529508 531357 533415 533419 533574 533975 543160 551002 554934 555753 560037 567805 571023 571466 572314 572387 579464 585524 588173 590619 595712 614917 623107 629092 630144 642559 654058 654535 654714 655980 658387 660089 663240 663356 664243 674635 678187 679228 679681 682916 692601 697649 701651 702732 721420 722791 723698 739248 743633 745374 751138 757773 761284 764548 764719 766101 767555 773533 777132 779049 779484 780050 780221 780248 780742 782011 783017 783557 784470 788386 788442 791755 792111 793379 793956 798343 809146 809305 810511 813600 814325 817124 821414 821556 821830 823046 ] |
||||||||||||||||||||||||||||||
|
13.89 ms (5.94%) |
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 533419 506144 678187 679228 595712 588173 783017 809146 701651 420403 418297 475503 495928 529508 428380 757773 397290 723698 722791 721420 572387 572314 444987 454794 487162 387007 445702 405858 419103 420775 516611 533415 531357 554934 702732 660089 663240 692601 585524 590619 623107 780050 792111 793379 809305 810511 780221 780248 780742 783557 793956 739248 745374 761284 788386 798343 743633 766101 764548 764719 614917 779049 782011 784470 399887 423305 460005 425290 504913 382069 1117 779484 773533 384774 426431 630144 767555 396594 821556 571466 655980 629092 777132 751138 791755 390990 571023 401780 399554 533574 567805 679681 697649 682916 642559 788442 410255 473994 466483 385004 392033 813600 817124 821830 823046 814325 821414 533975 543160 551002 560037 555753 579464 654058 654535 658387 654714 663356 664243 674635 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.27%) |
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 1117 382069 384774 385004 387007 390990 392033 396594 397290 399554 399887 401780 405858 410255 418297 419103 420403 420775 423305 425290 426431 428380 444987 445702 454794 460005 466483 473994 475503 487162 495928 504913 506144 516611 529508 531357 533415 533419 533574 533975 543160 551002 554934 555753 560037 567805 571023 571466 572314 572387 579464 585524 588173 590619 595712 614917 623107 629092 630144 642559 654058 654535 654714 655980 658387 660089 663240 663356 664243 674635 678187 679228 679681 682916 692601 697649 701651 702732 721420 722791 723698 739248 743633 745374 751138 757773 761284 764548 764719 766101 767555 773533 777132 779049 779484 780050 780221 780248 780742 782011 783017 783557 784470 788386 788442 791755 792111 793379 793956 798343 809146 809305 810511 813600 814325 817124 821414 821556 821830 823046 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"молодой девушк минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"молодой девушка минет…"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.62%) |
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.