Query Metrics
7
Database Queries
7
Different statements
372.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.80 ms (56.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал худые большие"
]
|
||||||||||||||||||||||||||||||
|
137.12 ms (36.77%) |
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 249773 396619 401933 404263 421394 426117 443524 446160 446257 446874 447314 447640 447644 451015 454809 461090 461714 466772 467558 468756 471823 475965 478463 478548 479590 482073 489522 490093 516336 516970 518472 519551 522907 530018 530663 530756 531208 536681 537201 538805 539278 539938 540334 540608 542472 546310 548994 552651 553757 554286 556911 560639 561813 561825 576324 578501 579200 583691 586603 589103 589747 590842 592302 594093 596638 597271 604199 620488 622394 624785 624915 626316 626880 629172 629934 639555 642335 645014 651620 654355 657230 665511 669339 671255 675762 684312 688997 693291 693356 693535 694582 696114 707102 720641 722219 724722 727905 730788 736356 737114 739073 742234 743935 747388 748340 757038 758563 759344 766799 774698 791663 799953 800798 814139 817451 817617 820570 822045 826299 827324 ] |
||||||||||||||||||||||||||||||
|
17.42 ms (4.67%) |
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 688997 693291 669339 696114 739073 743935 820570 707102 722219 624785 443524 447640 446257 539278 530756 537201 426117 467558 404263 522907 471823 451015 586603 468756 478548 479590 482073 560639 561825 578501 594093 589103 596638 421394 539938 446874 466772 583691 576324 651620 597271 622394 759344 629934 447644 461714 396619 538805 817617 814139 737114 758563 589747 624915 554286 401933 817451 540334 684312 553757 519551 693535 552651 542472 654355 671255 799953 747388 629172 826299 827324 791663 249773 548994 774698 530663 531208 536681 530018 540608 446160 516970 518472 693356 461090 478463 475965 490093 489522 516336 822045 454809 556911 561813 645014 579200 592302 730788 447314 657230 665511 720641 694582 546310 604199 620488 642335 590842 626880 639555 800798 766799 736356 727905 748340 757038 675762 724722 742234 626316 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (0.80%) |
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 249773 396619 401933 404263 421394 426117 443524 446160 446257 446874 447314 447640 447644 451015 454809 461090 461714 466772 467558 468756 471823 475965 478463 478548 479590 482073 489522 490093 516336 516970 518472 519551 522907 530018 530663 530756 531208 536681 537201 538805 539278 539938 540334 540608 542472 546310 548994 552651 553757 554286 556911 560639 561813 561825 576324 578501 579200 583691 586603 589103 589747 590842 592302 594093 596638 597271 604199 620488 622394 624785 624915 626316 626880 629172 629934 639555 642335 645014 651620 654355 657230 665511 669339 671255 675762 684312 688997 693291 693356 693535 694582 696114 707102 720641 722219 724722 727905 730788 736356 737114 739073 742234 743935 747388 748340 757038 758563 759344 766799 774698 791663 799953 800798 814139 817451 817617 820570 822045 826299 827324 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal skinny big"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал худые большие"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.