Query Metrics
7
Database Queries
7
Different statements
167.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.57 ms (82.09%) |
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 65568 389144 396119 401523 419045 422324 429961 435585 440045 441068 441071 441073 443152 447159 457283 459201 460070 460280 460285 467195 477061 481905 487429 488744 493744 496152 497830 500687 501098 506839 514234 514876 518561 519374 519697 524804 529597 531840 531861 531891 532749 532803 534549 534562 536121 536224 536226 536453 536463 543670 543722 546147 547465 547501 555795 559363 568268 578750 583518 586844 599440 605033 605582 608356 630796 630814 637446 639083 641951 642042 642073 648583 648593 651959 651963 656942 660365 661680 664183 664453 665972 666736 666962 668663 668677 669012 670356 672942 672952 694967 713126 713185 718701 720608 725630 740692 742303 744921 750300 752597 757400 765822 780541 788580 789028 790381 791772 792736 795331 796880 800309 801625 801628 801925 802925 805227 806928 812332 824876 824879 ] |
||||||||||||||||||||||||||||||
|
20.58 ms (12.28%) |
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 664183 666962 665972 608356 812332 752597 806928 742303 765822 791772 401523 534562 529597 531840 531861 543670 713126 664453 661680 780541 720608 796880 801925 460280 441073 429961 487429 460070 459201 493744 497830 532803 532749 568268 656942 713185 694967 586844 789028 788580 805227 543722 651959 578750 800309 389144 419045 460285 500687 519374 536453 583518 555795 440045 501098 506839 519697 669012 441071 396119 422324 443152 536226 536463 536224 514234 547465 547501 666736 668663 670356 672952 672942 718701 641951 642042 642073 630796 725630 750300 496152 441068 477061 524804 481905 651963 668677 660365 637446 790381 792736 801628 740692 757400 605033 801625 802925 435585 518561 65568 824876 824879 546147 488744 457283 534549 536121 531891 559363 605582 630814 639083 795331 744921 467195 514876 648593 648583 599440 447159 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.59%) |
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 65568 389144 396119 401523 419045 422324 429961 435585 440045 441068 441071 441073 443152 447159 457283 459201 460070 460280 460285 467195 477061 481905 487429 488744 493744 496152 497830 500687 501098 506839 514234 514876 518561 519374 519697 524804 529597 531840 531861 531891 532749 532803 534549 534562 536121 536224 536226 536453 536463 543670 543722 546147 547465 547501 555795 559363 568268 578750 583518 586844 599440 605033 605582 608356 630796 630814 637446 639083 641951 642042 642073 648583 648593 651959 651963 656942 660365 661680 664183 664453 665972 666736 666962 668663 668677 669012 670356 672942 672952 694967 713126 713185 718701 720608 725630 740692 742303 744921 750300 752597 757400 765822 780541 788580 789028 790381 791772 792736 795331 796880 800309 801625 801628 801925 802925 805227 806928 812332 824876 824879 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fisting girl"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фистинг девушк"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.84%) |
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.