Query Metrics
7
Database Queries
7
Different statements
189.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.17 ms (86.65%) |
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 423586 433464 449472 450070 455540 463497 483576 488475 489258 491462 501322 511199 525052 536107 544613 546040 546187 555467 556075 557098 559318 564579 574328 575950 579745 581181 583534 589314 591765 591913 592066 593745 600518 602177 602505 605667 615300 620533 624964 626702 627756 630136 630318 648167 655132 661950 664214 669286 692099 696089 696118 697194 698824 699408 703226 708746 709716 710091 712247 715935 718042 720192 720951 722928 724870 726627 727907 730112 730163 730312 731102 732200 732991 733388 738463 738514 739085 742560 742824 744082 745540 745628 748642 751672 757665 760301 760953 761077 761093 761302 762024 763087 765791 766681 767630 777615 778492 789609 791195 794173 794514 794717 796002 796564 796851 797210 801588 802715 803363 803936 804381 808492 810093 817197 817200 819346 820023 824598 ] |
||||||||||||||||||||||||||||||
|
14.90 ms (7.87%) |
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 801588 802715 803363 804381 810093 732991 738514 745628 751672 760953 761077 762024 766681 726627 733388 738463 724870 732200 763087 727907 630318 699408 703226 712247 722928 491462 620533 627756 778492 820023 463497 710091 669286 591913 808492 794717 765791 794173 489258 583534 777615 536107 579745 602505 793822 803936 423586 433464 817197 824598 819346 817200 449472 455540 450070 483576 501322 511199 525052 488475 544613 546040 575950 546187 555467 557098 559318 574328 661950 664214 698824 709716 648167 692099 696089 697194 708746 715935 720192 655132 696118 718042 720951 556075 564579 581181 592066 602177 615300 624964 630136 589314 593745 600518 626702 591765 605667 789609 791195 796564 796851 794514 796002 730112 730163 757665 797210 730312 731102 739085 744533 748642 761093 767630 742560 745540 760301 761302 742824 744082 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.39%) |
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 423586 433464 449472 450070 455540 463497 483576 488475 489258 491462 501322 511199 525052 536107 544613 546040 546187 555467 556075 557098 559318 564579 574328 575950 579745 581181 583534 589314 591765 591913 592066 593745 600518 602177 602505 605667 615300 620533 624964 626702 627756 630136 630318 648167 655132 661950 664214 669286 692099 696089 696118 697194 698824 699408 703226 708746 709716 710091 712247 715935 718042 720192 720951 722928 724870 726627 727907 730112 730163 730312 731102 732200 732991 733388 738463 738514 739085 742560 742824 744082 745540 745628 748642 751672 757665 760301 760953 761077 761093 761302 762024 763087 765791 766681 767630 777615 778492 789609 791195 794173 794514 794717 796002 796564 796851 797210 801588 802715 803363 803936 804381 808492 810093 817197 817200 819346 820023 824598 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum inside жен"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum inside wife"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum inside жен"
]
|
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.