Query Metrics
7
Database Queries
7
Different statements
201.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.32 ms (84.67%) |
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 13767 123029 249009 249873 316575 375135 382410 386166 394636 395474 396188 396694 396728 397390 399853 402676 404122 404443 408332 408711 412180 412725 414070 414438 416634 416647 416682 418534 421743 423428 430366 432927 436132 439033 440016 441042 446361 447348 447444 452875 456048 477090 483742 500313 510402 513830 521588 523205 524183 524793 527761 527920 530012 530478 531209 532727 532799 533012 533379 534537 534538 535006 536271 564514 567122 568518 575601 579457 587407 593701 595396 597823 599937 604453 632254 633733 634068 636907 639819 651059 660713 662061 675762 676075 677671 691984 706541 713137 713163 715750 717548 722428 740926 744266 745135 749700 752652 752675 752706 752710 752755 757905 766703 766941 769066 770219 770254 770818 776029 777084 778938 782517 782791 790234 793472 800538 800577 800593 814443 817221 ] |
||||||||||||||||||||||||||||||
|
19.25 ms (9.57%) |
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 770219 782791 397390 249009 123029 535006 752755 416682 536271 660713 532727 530478 523205 524183 597823 534538 713163 404122 375135 395474 399853 408332 412180 416634 446361 533379 527920 676075 595396 599937 402676 441042 447348 396188 439033 500313 483742 777084 633733 790234 675762 778938 316575 423428 757905 396728 386166 394636 456048 587407 634068 793472 800538 396694 416647 414438 776029 814443 568518 575601 752706 604453 412725 817221 636907 800577 766703 766941 769066 745135 382410 414070 418534 432927 440016 532799 533012 510402 530012 531209 677671 436132 404443 430366 452875 447444 524793 521588 13767 421743 477090 513830 534537 527761 579457 651059 691984 715750 717548 662061 706541 713137 722428 564514 567122 632254 593701 639819 800593 770818 782517 749700 752652 752675 752710 744266 770254 740926 408711 249873 ] |
||||||||||||||||||||||||||||||
|
4.07 ms (2.02%) |
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 13767 123029 249009 249873 316575 375135 382410 386166 394636 395474 396188 396694 396728 397390 399853 402676 404122 404443 408332 408711 412180 412725 414070 414438 416634 416647 416682 418534 421743 423428 430366 432927 436132 439033 440016 441042 446361 447348 447444 452875 456048 477090 483742 500313 510402 513830 521588 523205 524183 524793 527761 527920 530012 530478 531209 532727 532799 533012 533379 534537 534538 535006 536271 564514 567122 568518 575601 579457 587407 593701 595396 597823 599937 604453 632254 633733 634068 636907 639819 651059 660713 662061 675762 676075 677671 691984 706541 713137 713163 715750 717548 722428 740926 744266 745135 749700 752652 752675 752706 752710 752755 757905 766703 766941 769066 770219 770254 770818 776029 777084 778938 782517 782791 790234 793472 800538 800577 800593 814443 817221 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал teen хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal teen extreme"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал teen хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.