Query Metrics
7
Database Queries
7
Different statements
142.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.86 ms (84.19%) |
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 172420 300296 383544 384945 385368 385426 410775 452934 464648 477083 511615 524799 531742 534451 535099 538289 547371 553106 560010 563283 563949 565644 566605 569391 573351 576460 580981 581930 582836 599666 607906 647175 649268 653070 661066 663292 664628 666166 666628 668666 672829 673573 675396 676673 676746 677191 683046 689040 690259 694618 698818 699479 700737 702864 709745 713724 713750 718913 720299 720655 722709 726229 727451 728192 729770 729969 735899 745344 746232 748073 748563 750484 752734 753080 753736 755608 761305 762098 763496 765518 773814 776303 782774 784035 784199 785422 789522 790017 790367 791282 794439 795104 797764 800126 804116 805341 811529 811962 813812 814421 815343 818012 818351 819046 819646 821031 821139 821669 823336 823676 824665 824678 825293 825577 826719 826741 827189 827878 ] |
||||||||||||||||||||||||||||||
|
12.21 ms (8.58%) |
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 791282 805341 729770 750484 765518 789522 752734 762098 726229 761305 773814 729969 753736 735899 748563 700737 709745 723107 784035 784199 790017 811962 599666 785422 811529 746232 763496 385426 827189 813812 535099 673573 690259 698818 683046 720299 607906 776303 794439 795104 755608 790367 797764 800126 745344 748073 727451 728192 753080 720655 722709 782774 804116 383544 385368 384945 172420 300296 410775 818012 819646 821669 823676 826719 814421 818351 819046 823336 824665 824678 825577 826136 821139 815343 821031 825293 827878 826741 464648 477083 452934 511615 531742 534451 524799 538289 573351 581930 547371 560010 565644 566605 576460 580981 553106 563283 563949 569391 582836 663292 672829 675396 677191 699479 713724 713750 649268 661066 664628 666166 676746 689040 694618 702864 718913 647175 653070 666628 668666 676673 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (2.05%) |
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 172420 300296 383544 384945 385368 385426 410775 452934 464648 477083 511615 524799 531742 534451 535099 538289 547371 553106 560010 563283 563949 565644 566605 569391 573351 576460 580981 581930 582836 599666 607906 647175 649268 653070 661066 663292 664628 666166 666628 668666 672829 673573 675396 676673 676746 677191 683046 689040 690259 694618 698818 699479 700737 702864 709745 713724 713750 718913 720299 720655 722709 726229 727451 728192 729770 729969 735899 745344 746232 748073 748563 750484 752734 753080 753736 755608 761305 762098 763496 765518 773814 776303 782774 784035 784199 785422 789522 790017 790367 791282 794439 795104 797764 800126 804116 805341 811529 811962 813812 814421 815343 818012 818351 819046 819646 821031 821139 821669 823336 823676 824665 824678 825293 825577 826719 826741 827189 827878 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.59%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"her pussy"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"her pussy"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"her pussy"
]
|
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.