Query Metrics
7
Database Queries
7
Different statements
186.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.33 ms (86.50%) |
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 370928 386949 393865 394552 397174 405437 412311 413908 414946 425998 432837 443921 446022 447550 450777 450795 452335 454050 455976 456736 459850 460664 476905 481874 485462 500578 507115 508450 513117 515022 515802 516758 517280 519836 529518 531997 532063 532126 532207 533959 535010 539611 544236 549719 550976 551154 557500 557815 561460 561465 561990 563182 563898 563931 569952 571494 575241 580007 582976 589923 590812 598225 599703 599716 612922 617195 628075 628653 639304 674743 680846 687940 690091 697221 702283 710374 710604 713065 714049 718984 724295 726406 727190 727637 728259 728472 734688 736770 737315 739762 739965 746107 746663 751007 757071 757866 759898 760616 763280 769163 770006 771749 788160 792287 793547 797052 797950 800926 803217 804073 805945 806164 806741 807394 807452 807454 815995 820148 823263 826663 ] |
||||||||||||||||||||||||||||||
|
15.65 ms (8.39%) |
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 447550 599703 412311 476905 550976 575241 598225 617195 500578 450777 459850 460664 513117 561460 806164 394552 443921 815995 823263 454050 532207 549719 580007 557500 690091 727190 739965 746107 807454 370928 826663 713065 571494 628653 805945 736770 446022 413908 432837 414946 485462 397174 519836 531997 544236 561465 563931 710374 710604 557815 639304 589923 797950 800926 807452 746663 728472 769163 724295 759898 771749 760616 763280 612922 793547 797052 803217 806741 456736 517280 516758 563182 561990 702283 697221 674743 680846 687940 582976 590812 628075 599716 792287 727637 757071 728259 737315 734688 739762 751007 726406 788160 508450 393865 481874 533959 535010 450795 718984 804073 425998 515802 386949 405437 820148 452335 455976 515022 529518 532126 539611 507115 532063 569952 551154 563898 714049 807394 757866 770006 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.68%) |
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 370928 386949 393865 394552 397174 405437 412311 413908 414946 425998 432837 443921 446022 447550 450777 450795 452335 454050 455976 456736 459850 460664 476905 481874 485462 500578 507115 508450 513117 515022 515802 516758 517280 519836 529518 531997 532063 532126 532207 533959 535010 539611 544236 549719 550976 551154 557500 557815 561460 561465 561990 563182 563898 563931 569952 571494 575241 580007 582976 589923 590812 598225 599703 599716 612922 617195 628075 628653 639304 674743 680846 687940 690091 697221 702283 710374 710604 713065 714049 718984 724295 726406 727190 727637 728259 728472 734688 736770 737315 739762 739965 746107 746663 751007 757071 757866 759898 760616 763280 769163 770006 771749 788160 792287 793547 797052 797950 800926 803217 804073 805945 806164 806741 807394 807452 807454 815995 820148 823263 826663 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step big mom"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step большие mom"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step большие mom"
]
|
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.