Query Metrics
7
Database Queries
7
Different statements
159.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.03 ms (82.28%) |
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 382233 386371 386944 395623 396282 398858 400488 404343 406764 408709 420732 423342 430441 435325 438631 446049 446759 450074 451324 455082 455714 455917 460371 460548 466379 466985 489523 492963 493116 497330 500222 510334 510916 512987 516409 521125 524126 531949 532872 534389 538912 547741 547799 547812 554442 568652 575630 579263 586146 586546 587081 589324 596244 598504 601461 602147 606365 608827 610680 615910 621422 631173 642462 651926 662588 663088 669026 670980 671505 683082 692750 703486 707394 716536 722369 722463 722522 722785 724114 725390 733227 734687 737161 738563 739769 739827 740910 740985 753806 754086 755101 757020 758070 759642 763738 774124 774817 777642 777784 778385 780231 782094 784519 787002 787073 799693 799859 804098 805136 807253 810640 811215 812322 813241 813418 815446 815892 820330 820406 823030 ] |
||||||||||||||||||||||||||||||
|
16.38 ms (10.29%) |
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 386944 815446 815892 568652 601461 621422 754086 759642 722463 777642 804098 386371 400488 820406 450074 547741 683082 662588 651926 671505 587081 606365 610680 738563 753806 782094 813418 395623 455714 420732 404343 446049 512987 547812 608827 596244 780231 784519 737161 774124 778385 466379 455917 435325 524126 500222 446759 532872 722369 663088 575630 589324 777784 774817 811215 740985 799859 739827 707394 451324 602147 586146 408709 438631 823030 460371 492963 510916 534389 521125 579263 670980 692750 722522 722785 598504 586546 810640 807253 725390 733227 734687 813241 423342 430441 497330 820330 531949 538912 615910 724114 631173 460548 510334 516409 382233 398858 466985 547799 669026 642462 805136 740910 755101 757020 787073 739769 758070 763738 716536 787002 812322 489523 406764 799693 703486 396282 455082 493116 554442 ] |
||||||||||||||||||||||||||||||
|
4.31 ms (2.71%) |
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 382233 386371 386944 395623 396282 398858 400488 404343 406764 408709 420732 423342 430441 435325 438631 446049 446759 450074 451324 455082 455714 455917 460371 460548 466379 466985 489523 492963 493116 497330 500222 510334 510916 512987 516409 521125 524126 531949 532872 534389 538912 547741 547799 547812 554442 568652 575630 579263 586146 586546 587081 589324 596244 598504 601461 602147 606365 608827 610680 615910 621422 631173 642462 651926 662588 663088 669026 670980 671505 683082 692750 703486 707394 716536 722369 722463 722522 722785 724114 725390 733227 734687 737161 738563 739769 739827 740910 740985 753806 754086 755101 757020 758070 759642 763738 774124 774817 777642 777784 778385 780231 782094 784519 787002 787073 799693 799859 804098 805136 807253 810640 811215 812322 813241 813418 815446 815892 820330 820406 823030 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pink tits"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pink сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pink сиськ"
]
|
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.