Query Metrics
7
Database Queries
7
Different statements
158.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.75 ms (80.49%) |
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 16897 34563 96259 225591 387603 397412 397712 403618 418458 420031 420171 420625 420630 420674 430267 438207 445272 447150 449687 450367 454695 456937 459563 459794 463183 463693 467195 471455 473066 473515 475508 484907 485530 488179 504144 512938 513569 515357 515358 516807 518183 519497 519593 520489 521677 521829 526612 530479 531703 532674 533030 533372 533746 535621 547485 560925 566955 567321 569743 570120 574023 576017 576320 582540 585446 590281 593965 595072 595588 596226 599795 599983 601143 601781 602268 604118 605021 615491 632569 637442 642063 651634 677949 697461 709616 711263 722405 736519 738448 741115 743185 751088 752990 753621 754984 755671 757561 760478 773921 777791 777855 783145 787525 788590 789074 789312 792433 799105 806685 806789 807562 811339 814028 816728 819233 821075 821554 821634 822865 ] |
||||||||||||||||||||||||||||||
|
17.35 ms (10.93%) |
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 459794 418458 420031 420171 420674 449687 463183 463693 420625 438207 445272 450367 473515 526612 521677 533030 518183 754984 397712 403618 821554 569743 601143 599795 604118 787525 96259 387603 397412 420630 488179 807562 806789 515358 530479 533372 532674 651634 582540 615491 637442 642063 599983 512938 519497 814028 677949 722405 711263 788590 811339 736519 753621 741115 783145 519593 560925 593965 595588 632569 473066 521829 531703 605021 709616 602268 447150 467195 504144 547485 566955 596226 590281 585446 471455 475508 430267 535621 520489 513569 816728 576320 570120 576017 595072 751088 34563 454695 459563 16897 225591 456937 516807 574023 567321 513476 515357 484907 533746 821075 821634 819233 822865 485530 697461 601781 777855 799105 777791 806685 743185 752990 789074 789312 792433 755671 738448 757561 760478 773921 ] |
||||||||||||||||||||||||||||||
|
5.05 ms (3.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.77%) |
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 16897 34563 96259 225591 387603 397412 397712 403618 418458 420031 420171 420625 420630 420674 430267 438207 445272 447150 449687 450367 454695 456937 459563 459794 463183 463693 467195 471455 473066 473515 475508 484907 485530 488179 504144 512938 513569 515357 515358 516807 518183 519497 519593 520489 521677 521829 526612 530479 531703 532674 533030 533372 533746 535621 547485 560925 566955 567321 569743 570120 574023 576017 576320 582540 585446 590281 593965 595072 595588 596226 599795 599983 601143 601781 602268 604118 605021 615491 632569 637442 642063 651634 677949 697461 709616 711263 722405 736519 738448 741115 743185 751088 752990 753621 754984 755671 757561 760478 773921 777791 777855 783145 787525 788590 789074 789312 792433 799105 806685 806789 807562 811339 814028 816728 819233 821075 821554 821634 822865 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo beauty"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд beauty"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд beauty"
]
|
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.