Query Metrics
7
Database Queries
7
Different statements
140.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.30 ms (86.11%) |
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 391762 392391 393475 397114 397438 401540 409189 417154 417559 422790 432445 439470 481755 496479 502087 509163 533387 536107 538767 546493 547407 562492 575308 588138 594412 595393 608007 610140 612301 621990 622886 625831 626948 627332 631024 631059 631062 631816 631849 634605 635389 643849 666669 697933 711416 718641 725430 725654 726267 726925 726978 727500 727569 731088 734959 743083 751269 755172 756354 756979 757995 759153 759171 760630 760888 761023 761053 761679 761912 762879 763832 765429 768628 770356 770564 770714 771187 773449 775475 779730 781053 781123 781366 781590 781758 782544 783180 784159 785742 785900 786747 787437 787787 788659 789362 790282 792348 792668 793138 797024 797810 800641 800798 801672 801844 802581 803243 804297 805455 806098 807705 808175 808815 809425 810083 811844 812062 812980 813428 ] |
||||||||||||||||||||||||||||||
|
9.34 ms (6.63%) |
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 621990 631816 625831 634605 588138 595393 627332 631024 631062 631849 643849 779730 781123 781590 781758 788659 792348 800641 800798 801844 775475 781053 781366 784159 785742 803243 813428 726267 731088 751269 759153 760888 770564 770714 782544 783180 787787 790282 792668 807705 808175 810083 727500 743083 757995 759171 761679 765429 768628 725430 726925 726978 756979 761023 771187 755172 760630 762879 763832 770356 773449 727569 734959 756354 761053 761912 610140 626948 631059 635389 697933 711416 718641 777182 785900 786747 787437 793138 797810 802581 804297 806098 808815 809425 811844 812062 812980 392391 393475 397114 397438 432445 666669 401540 789362 801672 805455 725654 797024 409189 481755 536107 496479 538767 562492 547407 622886 594412 608007 612301 391762 439470 422790 417154 417559 509163 533387 502087 546493 575308 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (2.25%) |
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 391762 392391 393475 397114 397438 401540 409189 417154 417559 422790 432445 439470 481755 496479 502087 509163 533387 536107 538767 546493 547407 562492 575308 588138 594412 595393 608007 610140 612301 621990 622886 625831 626948 627332 631024 631059 631062 631816 631849 634605 635389 643849 666669 697933 711416 718641 725430 725654 726267 726925 726978 727500 727569 731088 734959 743083 751269 755172 756354 756979 757995 759153 759171 760630 760888 761023 761053 761679 761912 762879 763832 765429 768628 770356 770564 770714 771187 773449 775475 779730 781053 781123 781366 781590 781758 782544 783180 784159 785742 785900 786747 787437 787787 788659 789362 790282 792348 792668 793138 797024 797810 800641 800798 801672 801844 802581 803243 804297 805455 806098 807705 808175 808815 809425 810083 811844 812062 812980 813428 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"creampie vagina"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"creampie вагин"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"creampie вагин"
]
|
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.