Query Metrics
7
Database Queries
7
Different statements
193.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.12 ms (81.68%) |
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 122488 387347 396441 401592 431515 432478 432525 433024 433051 433366 433429 435701 437403 459068 460541 490732 516413 530606 531388 531526 538060 542777 544073 554046 561571 565227 570853 584083 588347 592682 593736 594238 595841 596234 599798 608105 610094 625086 630093 634934 661507 664206 664658 677994 695076 697392 697893 698224 710309 710900 714450 719967 719972 724692 730499 730693 731050 731126 731256 733491 734013 737613 739086 739646 741665 745318 745336 748443 751242 751476 753676 755057 761316 766400 767737 768208 769176 774917 780211 780244 781344 783636 786994 787066 787485 789160 792459 792473 792495 792926 793165 794299 794564 796322 796741 796852 800081 800482 800639 801439 810503 813641 818855 818922 819281 820013 824137 824570 825083 825881 826732 826932 827013 827064 828337 828455 828541 828664 828677 828787 ] |
||||||||||||||||||||||||||||||
|
24.59 ms (12.70%) |
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 734013 751476 761316 396441 387347 774917 733491 745318 435701 431515 813641 588347 787066 433429 122488 827013 819281 828787 828677 584083 800482 787485 731126 794564 741665 730499 767737 737613 745336 792473 792926 530606 538060 542777 561571 570853 544073 554046 565227 664658 661507 710900 664206 677994 697392 697893 719972 592682 593736 595841 608105 599798 780244 794299 789160 800081 731050 751242 753676 769176 739086 739646 755057 768208 634934 714450 719967 796852 433366 432478 490732 698224 594238 748443 433051 437403 432525 433024 610094 401592 460541 625086 731256 796741 766400 724692 730693 516413 596234 459068 818855 825881 826732 820013 826932 827064 818922 824137 824570 828337 825083 828455 828541 828664 531526 531388 695076 710309 630093 780211 792459 792495 793165 796322 800639 801439 810503 781344 783636 786994 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.24%) |
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 122488 387347 396441 401592 431515 432478 432525 433024 433051 433366 433429 435701 437403 459068 460541 490732 516413 530606 531388 531526 538060 542777 544073 554046 561571 565227 570853 584083 588347 592682 593736 594238 595841 596234 599798 608105 610094 625086 630093 634934 661507 664206 664658 677994 695076 697392 697893 698224 710309 710900 714450 719967 719972 724692 730499 730693 731050 731126 731256 733491 734013 737613 739086 739646 741665 745318 745336 748443 751242 751476 753676 755057 761316 766400 767737 768208 769176 774917 780211 780244 781344 783636 786994 787066 787485 789160 792459 792473 792495 792926 793165 794299 794564 796322 796741 796852 800081 800482 800639 801439 810503 813641 818855 818922 819281 820013 824137 824570 825083 825881 826732 826932 827013 827064 828337 828455 828541 828664 828677 828787 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен дрочк"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"соседка дрочит"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен дрочк"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.03%) |
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.