Query Metrics
7
Database Queries
7
Different statements
198.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.85 ms (86.92%) |
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 365978 381791 397130 398874 408810 484245 487661 491579 539030 543542 545946 547356 554120 557617 562392 564357 569093 569912 584109 596186 612656 624238 629124 631356 634289 635742 637630 638101 644675 645721 650030 650032 650238 652553 654405 662786 675862 684183 688127 688706 689323 696975 700497 701794 702008 702674 703775 704480 704984 705223 707808 711117 712791 713974 715828 717109 718583 720505 720664 721200 722350 723916 723970 725764 730275 735421 736610 736842 738419 740762 741889 743033 745848 748694 749006 753266 755733 757895 759228 759385 764049 764810 765883 771200 772859 774079 774635 781051 782763 783002 786824 789450 789867 791660 795112 795660 797569 801219 802632 803707 811818 812258 816749 816768 818109 818254 818379 820146 823908 824426 824616 824693 825785 825883 826076 826146 826411 826553 826565 ] |
||||||||||||||||||||||||||||||
|
16.20 ms (8.15%) |
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 820146 826644 818254 554120 645721 701794 711117 650032 712791 721200 638101 782763 735421 740762 801219 757895 764810 753266 764049 743033 795660 824426 487661 543542 704480 684183 707808 596186 791660 730275 736842 408810 397130 741889 720505 654405 781051 826553 824693 824616 825883 484245 688706 700497 650030 650238 713974 720664 637630 789867 774635 795112 797569 723916 736610 759228 765883 803707 365978 381791 826565 818109 825785 826076 826411 826146 545946 569912 584109 562392 557617 564357 662786 702008 705223 652553 675862 722350 688127 703775 547356 612656 634289 635742 629124 738419 755733 749006 723970 745848 748694 759385 725764 772859 644675 715828 718583 812258 818379 539030 491579 717109 689323 702674 704984 569093 624238 631356 783002 786824 789450 811818 771200 774079 696975 802632 398874 823908 816749 816768 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.39%) |
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 365978 381791 397130 398874 408810 484245 487661 491579 539030 543542 545946 547356 554120 557617 562392 564357 569093 569912 584109 596186 612656 624238 629124 631356 634289 635742 637630 638101 644675 645721 650030 650032 650238 652553 654405 662786 675862 684183 688127 688706 689323 696975 700497 701794 702008 702674 703775 704480 704984 705223 707808 711117 712791 713974 715828 717109 718583 720505 720664 721200 722350 723916 723970 725764 730275 735421 736610 736842 738419 740762 741889 743033 745848 748694 749006 753266 755733 757895 759228 759385 764049 764810 765883 771200 772859 774079 774635 781051 782763 783002 786824 789450 789867 791660 795112 795660 797569 801219 802632 803707 811818 812258 816749 816768 818109 818254 818379 820146 823908 824426 824616 824693 825785 825883 826076 826146 826411 826553 826565 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fucked teen girl"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fucked молодая девушк"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fucked молодая девушк"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.75%) |
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.