Query Metrics
7
Database Queries
7
Different statements
149.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.84 ms (80.15%) |
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 233459 307342 382735 383596 398883 400298 408875 415826 417592 418565 420020 421420 423929 428754 434113 437977 442409 444117 449735 450183 454714 454786 455827 459986 461684 465869 468029 471150 479933 483741 489087 489329 494883 495870 501984 503095 512011 513727 515521 533090 533528 533808 543147 547817 548143 549823 570173 577073 582040 582072 590020 590084 592584 598229 608096 611117 616470 631426 642201 642982 650264 711577 716158 716796 721311 724159 725128 728086 728259 732065 741583 746057 749361 750593 751167 753697 755517 756701 759626 759788 760751 762098 766382 766766 769459 769993 771064 771678 772644 775471 777998 778002 778661 779256 780896 781981 782444 783416 786288 786324 787609 792733 795303 796638 796712 797398 797433 800892 800900 801269 804540 811562 811718 811857 812609 812614 814222 816982 823557 ] |
||||||||||||||||||||||||||||||
|
18.73 ms (12.53%) |
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 608096 611117 775471 786288 786324 797398 800892 804540 811562 778002 778661 782444 796638 801269 811718 724159 725128 753697 760751 771678 759626 766382 769993 732065 749361 756701 759788 769459 771064 746057 750593 751167 764595 766766 716158 780896 811857 307342 383596 812614 444117 450183 459986 465869 582040 711577 547817 616470 420020 434113 449735 461684 455827 468029 398883 421420 437977 442409 471150 483741 495870 501984 515521 489329 512011 454714 549823 590020 423929 503095 489087 415826 479933 494883 582072 543147 382735 417592 513727 408875 814222 816982 454786 533090 533528 533808 548143 577073 570173 650264 716796 631426 598229 642201 590084 592584 777998 787609 795303 797433 812609 755517 772644 792733 728086 728259 762098 741583 642982 721311 779256 781981 783416 796712 800900 428754 233459 400298 418565 823557 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.95%) |
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 233459 307342 382735 383596 398883 400298 408875 415826 417592 418565 420020 421420 423929 428754 434113 437977 442409 444117 449735 450183 454714 454786 455827 459986 461684 465869 468029 471150 479933 483741 489087 489329 494883 495870 501984 503095 512011 513727 515521 533090 533528 533808 543147 547817 548143 549823 570173 577073 582040 582072 590020 590084 592584 598229 608096 611117 616470 631426 642201 642982 650264 711577 716158 716796 721311 724159 725128 728086 728259 732065 741583 746057 749361 750593 751167 753697 755517 756701 759626 759788 760751 762098 766382 766766 769459 769993 771064 771678 772644 775471 777998 778002 778661 779256 780896 781981 782444 783416 786288 786324 787609 792733 795303 796638 796712 797398 797433 800892 800900 801269 804540 811562 811718 811857 812609 812614 814222 816982 823557 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass in leggings"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.35%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп лосин"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп лосин"
]
|
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.