Query Metrics
7
Database Queries
7
Different statements
153.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.80 ms (79.87%) |
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 15364 48476 233198 360945 411246 414594 429957 436419 444232 453692 457134 470117 470591 474074 477129 477135 481383 487235 496061 509500 516323 530289 533646 533663 533777 537974 537982 539341 539373 543644 543657 543726 543727 546011 548049 550938 557478 558123 560005 562926 563598 568351 568593 568685 571472 576241 577481 595424 595455 595497 597085 597798 597968 598145 598197 611298 614566 626019 626083 644688 650064 652865 654094 656545 661920 662147 663247 663250 663836 666515 667151 668142 672774 673425 679190 683257 683267 683303 684693 685523 686384 689212 692280 693273 693421 695080 697507 697717 700452 703448 704343 704673 705111 706625 709501 712176 712952 713369 713434 713989 714564 714582 714583 714591 714592 714598 714615 715449 717719 721595 721609 722346 722833 722984 814094 814339 825817 827432 ] |
||||||||||||||||||||||||||||||
|
21.24 ms (13.82%) |
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 509500 233198 825817 568593 15364 48476 360945 411246 444232 414594 429957 436419 827432 814339 814094 457134 470117 481383 453692 474074 477129 487235 530289 496061 533777 537982 516323 533646 533663 537974 539341 539373 470591 477135 543657 562926 571472 543644 543727 568351 543726 548049 558123 568685 576241 577481 650064 654094 661920 663250 667151 673425 684693 685523 689212 693273 700452 714564 714591 715449 719429 722346 722833 662147 663247 663836 666515 668142 672774 679190 683257 683267 683303 686384 692280 697717 704343 704673 705111 713369 713434 713989 714592 714598 714615 721595 721609 722984 652865 656545 693421 695080 697507 703448 706625 709501 712176 712952 714582 714583 717719 546011 550938 557478 560005 563598 597085 597798 597968 598145 626019 626083 644688 595424 595455 595497 598197 611298 614566 586568 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (2.21%) |
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 15364 48476 233198 360945 411246 414594 429957 436419 444232 453692 457134 470117 470591 474074 477129 477135 481383 487235 496061 509500 516323 530289 533646 533663 533777 537974 537982 539341 539373 543644 543657 543726 543727 546011 548049 550938 557478 558123 560005 562926 563598 568351 568593 568685 571472 576241 577481 595424 595455 595497 597085 597798 597968 598145 598197 611298 614566 626019 626083 644688 650064 652865 654094 656545 661920 662147 663247 663250 663836 666515 667151 668142 672774 673425 679190 683257 683267 683303 684693 685523 686384 689212 692280 693273 693421 695080 697507 697717 700452 703448 704343 704673 705111 706625 709501 712176 712952 713369 713434 713989 714564 714582 714583 714591 714592 714598 714615 715449 717719 721595 721609 722346 722833 722984 814094 814339 825817 827432 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"rus xxx"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск xxx"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.30 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск xxx"
]
|
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.