Query Metrics
7
Database Queries
7
Different statements
163.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.42 ms (85.42%) |
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 117755 117890 118282 118920 368196 383742 401993 415964 416682 416692 416718 416738 416752 427232 429957 430581 439012 439034 439038 440016 441092 441101 443152 447985 456220 459201 459375 460070 469221 480452 487422 490625 508938 511862 512078 512087 512357 515965 517724 519722 525351 527920 527921 528922 532749 532826 534539 536128 536233 536783 539026 539185 542705 544140 550816 555797 568264 568266 572654 575560 575589 575601 579394 579517 586760 587407 592576 597029 597163 597169 597502 616850 629934 633455 634068 639762 639792 639797 639819 641951 642042 642073 644018 649580 656186 656933 656942 660362 662159 663181 666528 666875 673257 709693 710709 713184 713185 716086 722393 725121 725630 729800 735136 738820 749700 752673 761176 775883 780650 786878 788506 791772 796939 797197 800282 805227 805642 806543 817221 ] |
||||||||||||||||||||||||||||||
|
14.65 ms (8.97%) |
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 725121 749700 791772 441092 512087 512357 487422 527920 629934 709693 517724 439012 532826 550816 568264 544140 797197 118920 539185 515965 633455 729800 786878 805642 512078 469221 800282 662159 575601 416718 597163 118282 525351 542705 439034 511862 663181 796939 568266 666875 780650 440016 443152 460070 459201 532749 527921 656942 713185 673257 597169 641951 642042 642073 644018 782849 725630 805227 441101 656186 660362 592576 416692 401993 416752 429957 817221 572654 368196 117890 536233 427232 597029 117755 775883 649580 616850 735136 788506 459375 416738 519722 587407 634068 586760 480452 639792 639797 415964 536128 716086 430581 508938 528922 579394 555797 579517 456220 416682 597502 447985 490625 713184 656933 710709 639819 761176 575589 575560 752673 639762 536783 666528 534539 539026 806543 738820 722393 383742 439038 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.69%) |
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 117755 117890 118282 118920 368196 383742 401993 415964 416682 416692 416718 416738 416752 427232 429957 430581 439012 439034 439038 440016 441092 441101 443152 447985 456220 459201 459375 460070 469221 480452 487422 490625 508938 511862 512078 512087 512357 515965 517724 519722 525351 527920 527921 528922 532749 532826 534539 536128 536233 536783 539026 539185 542705 544140 550816 555797 568264 568266 572654 575560 575589 575601 579394 579517 586760 587407 592576 597029 597163 597169 597502 616850 629934 633455 634068 639762 639792 639797 639819 641951 642042 642073 644018 649580 656186 656933 656942 660362 662159 663181 666528 666875 673257 709693 710709 713184 713185 716086 722393 725121 725630 729800 735136 738820 749700 752673 761176 775883 780650 786878 788506 791772 796939 797197 800282 805227 805642 806543 817221 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen fisting extreme"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen фистинг хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen фистинг хардкор"
]
|
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.