Query Metrics
7
Database Queries
7
Different statements
183.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.24 ms (87.95%) |
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 385057 391749 393968 396765 420614 517747 527581 528472 532633 534495 535802 540440 542842 542850 543683 548202 549545 550573 554509 557148 559317 563764 564124 567714 575018 586881 588501 594567 602700 615492 616920 617755 622922 626783 629375 638485 641049 641359 650363 651565 653098 659751 660327 667850 670016 683277 694634 697725 699145 705786 706260 707228 707726 709277 710542 714141 717019 718162 718197 718283 718569 719803 723602 724593 726474 726631 726646 727401 728160 728862 736067 737467 740741 741021 741338 743567 746315 746691 753584 754463 755246 755866 762627 762629 763042 763134 763771 770898 771667 772289 778073 781066 799302 799418 799544 802858 810503 815824 816636 817520 817653 818355 818606 818693 818731 819856 820573 821307 821625 822411 825176 825583 825792 826345 826451 827031 827222 827586 828366 ] |
||||||||||||||||||||||||||||||
|
11.11 ms (6.06%) |
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 709277 667850 728160 772289 799544 822411 825176 827586 825792 554509 557148 707228 659751 724593 393968 826451 817653 818606 820573 825583 828366 527581 534495 575018 650363 707726 718197 718569 653098 706260 719803 594567 622922 810503 799418 728862 802858 754463 736067 629375 710542 717019 385057 542842 542850 660327 799302 746315 763134 763042 763771 396765 816636 827031 818731 826345 528472 517747 532633 567714 670016 718283 683277 694634 718162 549545 615492 626783 602700 586881 638485 781066 727401 737467 740741 753584 755866 762629 770898 741021 741338 726646 746691 755246 771667 714141 778073 420614 821307 535802 548202 699145 651565 616920 588501 617755 641359 726474 743567 726631 762627 641049 391749 723602 815824 817520 818355 818693 819856 822056 821625 827222 540440 543683 559317 550573 563764 564124 697725 705786 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.47%) |
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 385057 391749 393968 396765 420614 517747 527581 528472 532633 534495 535802 540440 542842 542850 543683 548202 549545 550573 554509 557148 559317 563764 564124 567714 575018 586881 588501 594567 602700 615492 616920 617755 622922 626783 629375 638485 641049 641359 650363 651565 653098 659751 660327 667850 670016 683277 694634 697725 699145 705786 706260 707228 707726 709277 710542 714141 717019 718162 718197 718283 718569 719803 723602 724593 726474 726631 726646 727401 728160 728862 736067 737467 740741 741021 741338 743567 746315 746691 753584 754463 755246 755866 762627 762629 763042 763134 763771 770898 771667 772289 778073 781066 799302 799418 799544 802858 810503 815824 816636 817520 817653 818355 818606 818693 818731 819856 820573 821307 821625 822411 825176 825583 825792 826345 826451 827031 827222 827586 828366 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sucks cock"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sucks cock"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sucks cock"
]
|
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.