Query Metrics
7
Database Queries
7
Different statements
157.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.00 ms (83.33%) |
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 330354 391951 396574 397325 415529 426728 427709 432749 441424 455888 461933 461935 464239 469732 478651 484440 490778 490800 509163 517834 533276 537504 542348 549277 555215 557018 564344 569736 570930 578131 580606 582096 583086 583909 589325 593562 607301 607802 621404 622477 623542 634735 644149 651097 652276 664712 664755 665404 667244 674023 675745 680229 680282 684305 713159 713301 714949 715700 717664 717712 719916 722148 724030 724519 726888 726932 728410 729666 730392 731280 731311 733339 734331 734411 734928 734961 736222 736231 742852 743044 743654 745227 750156 753316 755408 757795 758096 758593 758929 760892 765248 766681 766883 767417 769864 771737 775043 775382 779681 779730 781327 785684 786749 786940 788552 788858 791097 797705 799516 799668 800466 801225 802207 802328 802668 802825 817182 820011 824167 826834 ] |
||||||||||||||||||||||||||||||
|
15.59 ms (9.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 634735 802207 758593 397325 713159 652276 667244 675745 674023 722148 644149 775043 779730 730392 724519 719916 330354 580606 583086 664712 549277 582096 775382 781327 726888 750156 745227 757795 743654 802668 753316 461933 665404 799516 396574 817182 555215 427709 824167 717712 779681 432749 684305 826834 583909 680229 717664 607802 785684 788552 797705 802825 736231 771737 800466 802328 726932 731280 758929 734928 621404 484440 415529 820011 517834 714949 664755 715700 622477 589325 788858 734411 742852 786940 728410 731311 734961 729666 461935 478651 651097 623542 733339 441424 607301 801225 765248 743044 455888 557018 564344 569736 713301 786749 734331 766883 769864 767417 490800 490778 509163 537504 680282 578131 593562 799668 724030 736222 766681 755408 760892 758096 791097 391951 426728 464239 469732 533276 570930 542348 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.90%) |
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 330354 391951 396574 397325 415529 426728 427709 432749 441424 455888 461933 461935 464239 469732 478651 484440 490778 490800 509163 517834 533276 537504 542348 549277 555215 557018 564344 569736 570930 578131 580606 582096 583086 583909 589325 593562 607301 607802 621404 622477 623542 634735 644149 651097 652276 664712 664755 665404 667244 674023 675745 680229 680282 684305 713159 713301 714949 715700 717664 717712 719916 722148 724030 724519 726888 726932 728410 729666 730392 731280 731311 733339 734331 734411 734928 734961 736222 736231 742852 743044 743654 745227 750156 753316 755408 757795 758096 758593 758929 760892 765248 766681 766883 767417 769864 771737 775043 775382 779681 779730 781327 785684 786749 786940 788552 788858 791097 797705 799516 799668 800466 801225 802207 802328 802668 802825 817182 820011 824167 826834 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ебля с криками"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс крича вперв"
]
|
||||||||||||||||||||||||||||||
|
1.64 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.