Query Metrics
7
Database Queries
7
Different statements
151.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.42 ms (84.29%) |
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 385000 388791 415029 418521 419619 423958 427100 440641 452934 455373 457119 470979 487618 488908 488993 490675 492412 494293 505353 506070 507243 510950 517439 517881 529176 533290 537237 540593 544912 546039 555982 563998 569315 590721 590835 591781 599020 600830 602247 602318 603359 606254 607757 607845 610015 612291 615357 615413 617566 618228 626402 628511 630254 634080 637347 637363 638197 643191 643737 644171 651953 664504 666031 666711 669281 680969 683720 698156 706026 708851 710054 711211 714703 719342 720071 726448 727283 730414 731758 733217 740905 742330 742336 743641 746106 748648 749513 750306 750626 750680 766307 772483 774674 776217 781765 783204 784302 787265 788753 792775 794931 795816 795867 795902 798764 800767 801531 801772 802241 802328 803786 804120 806667 807999 810096 812312 812551 816158 816618 826873 ] |
||||||||||||||||||||||||||||||
|
14.42 ms (9.54%) |
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 457119 669281 630254 388791 555982 792775 743641 533290 800767 772483 783204 804120 599020 795867 529176 569315 590721 490675 507243 418521 419619 455373 427100 510950 517439 816618 826873 452934 488908 494293 540593 537237 563998 651953 714703 720071 666031 706026 708851 719342 680969 710054 544912 602247 638197 643191 600830 607757 615413 617566 618228 637363 607845 610015 615357 628511 644171 590835 591781 612291 637347 794931 798764 807999 810096 781765 788753 802241 803786 812312 742336 750306 750680 787265 795902 801531 802328 812551 749513 730414 731758 748648 726448 742330 746106 727283 740905 766307 602318 626402 634080 643737 711211 784302 795816 806667 385000 517881 698156 666711 683720 750626 774674 506070 733217 423958 816158 492412 505353 487618 488993 546039 664504 606254 603359 776217 801772 415029 440641 470979 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.96%) |
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 385000 388791 415029 418521 419619 423958 427100 440641 452934 455373 457119 470979 487618 488908 488993 490675 492412 494293 505353 506070 507243 510950 517439 517881 529176 533290 537237 540593 544912 546039 555982 563998 569315 590721 590835 591781 599020 600830 602247 602318 603359 606254 607757 607845 610015 612291 615357 615413 617566 618228 626402 628511 630254 634080 637347 637363 638197 643191 643737 644171 651953 664504 666031 666711 669281 680969 683720 698156 706026 708851 710054 711211 714703 719342 720071 726448 727283 730414 731758 733217 740905 742330 742336 743641 746106 748648 749513 750306 750626 750680 766307 772483 774674 776217 781765 783204 784302 787265 788753 792775 794931 795816 795867 795902 798764 800767 801531 801772 802241 802328 803786 804120 806667 807999 810096 812312 812551 816158 816618 826873 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy pussy masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая pussy мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая 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.