Query Metrics
7
Database Queries
7
Different statements
195.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.31 ms (82.84%) |
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 129916 326081 382727 385080 385302 385706 385913 387174 388772 388925 395413 395698 396684 396726 397054 397295 399338 399393 401976 402541 403904 405939 409015 411218 411258 411451 412177 425679 427762 429823 434544 443042 454828 455387 458156 461443 468699 468711 483814 511357 516564 525326 527491 528952 529027 529058 562326 575063 575096 575157 575798 592416 596255 597241 600182 612438 616561 616795 620711 621288 633722 634541 636951 637054 639295 640714 698880 701967 703564 709589 717656 717974 721431 722262 724943 727698 727852 730329 732425 735946 736440 737947 740093 740904 741996 742818 742941 745250 745915 747624 756523 757549 758635 760214 761578 762707 763490 766157 766851 767588 767976 769077 770303 771015 773683 782711 783356 785727 785777 787959 788255 789845 790256 797817 802164 805660 806614 809342 812993 ] |
||||||||||||||||||||||||||||||
|
23.86 ms (12.18%) |
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 596255 597241 600182 612438 616795 636951 592416 616561 621288 634541 639295 640714 782711 789845 790256 802164 806614 784828 785777 724943 727698 737947 740093 740904 742818 760214 762707 766851 767588 785727 787959 797817 805660 809342 727852 730329 732425 741996 745250 736440 742941 758635 763490 769077 735946 745915 756523 761578 747624 757549 766157 767976 770303 771015 773683 620711 633722 637054 698880 701967 703564 709589 717656 717974 721431 722262 783356 788255 812993 387174 399393 412177 458156 326081 385080 388772 397054 409015 454828 455387 468699 129916 388925 461443 411258 468711 525326 529027 511357 527491 516564 529058 528952 575096 575157 575063 575798 562326 483814 385706 385913 382727 385302 395413 395698 396726 396684 397295 399338 401976 402541 405939 403904 411218 425679 434544 443042 427762 411451 429823 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (1.61%) |
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 129916 326081 382727 385080 385302 385706 385913 387174 388772 388925 395413 395698 396684 396726 397054 397295 399338 399393 401976 402541 403904 405939 409015 411218 411258 411451 412177 425679 427762 429823 434544 443042 454828 455387 458156 461443 468699 468711 483814 511357 516564 525326 527491 528952 529027 529058 562326 575063 575096 575157 575798 592416 596255 597241 600182 612438 616561 616795 620711 621288 633722 634541 636951 637054 639295 640714 698880 701967 703564 709589 717656 717974 721431 722262 724943 727698 727852 730329 732425 735946 736440 737947 740093 740904 741996 742818 742941 745250 745915 747624 756523 757549 758635 760214 761578 762707 763490 766157 766851 767588 767976 769077 770303 771015 773683 782711 783356 785727 785777 787959 788255 789845 790256 797817 802164 805660 806614 809342 812993 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"first teens"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"first teens"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"first teens"
]
|
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.