Query Metrics
7
Database Queries
7
Different statements
145.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.89 ms (82.96%) |
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 3616 16971 152027 382402 391492 392493 393715 395908 397410 398544 398554 401391 422358 445040 466014 470302 506211 507263 518852 546138 548016 565648 577276 577836 579740 585583 585623 589652 594051 594067 596686 603617 604487 611193 627380 631551 631828 637828 637898 641032 644699 660799 663372 663404 665399 678711 684101 684812 687796 695849 702382 707741 710769 715406 716991 718143 721125 721223 725227 726284 726556 728470 730714 730780 732171 734672 735709 736410 738287 738317 738320 738339 738530 741093 744377 746371 747171 747230 747926 748091 750205 750638 755143 756097 757278 762951 764193 764808 765931 776028 778188 778722 780672 782261 782499 786204 786491 790834 793694 795577 795594 796185 796857 798527 800283 800317 800761 801624 802186 803857 813867 814490 823923 825285 826723 827084 827094 827868 827908 ] |
||||||||||||||||||||||||||||||
|
14.81 ms (10.16%) |
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 728470 738339 744377 746371 755143 726556 748091 750205 604487 637828 715406 716991 778188 780672 397410 393715 627380 579740 398554 401391 823923 684101 718143 695849 585623 802186 152027 684812 702382 603617 725227 422358 466014 470302 16971 506211 518852 665399 663404 756097 795594 445040 585583 392493 382402 398544 813867 826723 827084 827094 827868 827908 825285 507263 565648 577836 660799 707741 721125 678711 687796 721223 548016 577276 631828 637898 589652 594051 594067 596686 644699 631551 641032 778722 782499 786204 776028 782261 786491 796185 800317 734672 736410 741093 795577 796857 798527 800761 801624 803857 726284 750638 757278 730714 730780 738317 738320 738530 747171 764808 732171 735709 738287 747926 762951 764193 765931 611193 627511 790834 800283 395908 663372 710769 546138 793694 747230 391492 3616 814490 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.83%) |
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 3616 16971 152027 382402 391492 392493 393715 395908 397410 398544 398554 401391 422358 445040 466014 470302 506211 507263 518852 546138 548016 565648 577276 577836 579740 585583 585623 589652 594051 594067 596686 603617 604487 611193 627380 631551 631828 637828 637898 641032 644699 660799 663372 663404 665399 678711 684101 684812 687796 695849 702382 707741 710769 715406 716991 718143 721125 721223 725227 726284 726556 728470 730714 730780 732171 734672 735709 736410 738287 738317 738320 738339 738530 741093 744377 746371 747171 747230 747926 748091 750205 750638 755143 756097 757278 762951 764193 764808 765931 776028 778188 778722 780672 782261 782499 786204 786491 790834 793694 795577 795594 796185 796857 798527 800283 800317 800761 801624 802186 803857 813867 814490 823923 825285 826723 827084 827094 827868 827908 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old wife"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old жен"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old жен"
]
|
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.