Query Metrics
7
Database Queries
7
Different statements
148.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.32 ms (82.77%) |
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 81412 81810 108764 385040 385952 387393 395457 395472 397827 400360 415039 417034 419094 420703 420751 421763 421884 422135 422292 424331 424651 428158 428877 432482 433395 433594 438045 439668 440721 444840 444986 450070 451879 453920 455165 457521 458986 459090 459512 461302 461762 464366 466041 467926 470014 471925 472095 472735 472860 479576 481701 483503 485573 487216 487666 495388 503483 504027 505718 506312 506319 516211 522638 523793 524418 541013 544054 560363 565840 572501 578040 598145 598929 601190 627206 630136 648167 666601 682403 696089 698824 702143 705683 709396 709872 723961 725511 725526 731317 743037 746091 755020 755810 756402 760953 764114 765025 767393 773814 773994 780230 782766 782969 783232 783823 785422 789023 792404 794900 796103 796214 796851 798763 801368 802554 808900 809995 812457 817048 ] |
||||||||||||||||||||||||||||||
|
15.72 ms (10.55%) |
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 760953 725526 746091 773814 725511 743037 755810 767393 756402 765025 773994 627206 702143 709396 709872 723107 796103 385952 433594 444840 467926 472735 395457 432482 440721 470014 472095 420751 424651 455165 481701 504027 495388 505718 524418 506312 459512 487666 464366 523793 428158 458986 421884 438045 439668 81810 385040 108764 395472 81412 387393 397827 400360 415039 417034 419094 444986 422292 421763 424331 420703 422135 433395 428877 817048 453920 459090 466041 471925 479576 451879 461302 461762 483503 450070 457521 485573 506319 503483 522638 516211 472860 487216 544054 541013 565840 560363 578040 698824 705683 648167 666601 682403 696089 572501 598145 598929 601190 630136 780230 782969 783823 789023 796851 812457 783232 785422 798763 802554 808900 809995 723961 755020 764114 782766 792404 794900 796214 801368 731317 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (2.00%) |
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 81412 81810 108764 385040 385952 387393 395457 395472 397827 400360 415039 417034 419094 420703 420751 421763 421884 422135 422292 424331 424651 428158 428877 432482 433395 433594 438045 439668 440721 444840 444986 450070 451879 453920 455165 457521 458986 459090 459512 461302 461762 464366 466041 467926 470014 471925 472095 472735 472860 479576 481701 483503 485573 487216 487666 495388 503483 504027 505718 506312 506319 516211 522638 523793 524418 541013 544054 560363 565840 572501 578040 598145 598929 601190 627206 630136 648167 666601 682403 696089 698824 702143 705683 709396 709872 723961 725511 725526 731317 743037 746091 755020 755810 756402 760953 764114 765025 767393 773814 773994 780230 782766 782969 783232 783823 785422 789023 792404 794900 796103 796214 796851 798763 801368 802554 808900 809995 812457 817048 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum boy"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum парен"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum парен"
]
|
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.