Query Metrics
7
Database Queries
7
Different statements
147.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.62 ms (82.94%) |
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 426510 460860 464727 469195 497667 540055 540104 540117 540120 540129 542722 547805 548895 550196 550199 550205 553273 554998 555055 555224 555601 555772 555784 556000 558264 568375 570179 570941 571708 576652 580868 583913 584950 585143 590226 597224 597873 600008 600017 600360 604645 606071 607236 612904 614346 617414 618378 633502 634218 635275 637413 637741 639027 639334 639774 639802 640156 647885 647893 647948 647995 648891 649583 650817 661295 664602 666892 666906 668555 674983 675019 678032 683045 691821 710480 714551 715444 716765 716878 718576 718745 726624 727534 729236 729251 729253 734360 736462 739618 745865 749340 751567 757050 758259 758292 765517 775958 781488 789438 795943 795952 800726 801084 801530 801701 801776 801819 801823 804416 811905 813797 817881 818573 824485 826098 826209 826322 826408 827188 827490 ] |
||||||||||||||||||||||||||||||
|
15.56 ms (10.52%) |
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 604645 614346 597224 555055 571708 765517 647893 585143 555784 554998 666906 674983 647948 639334 639774 817881 540120 736462 826098 612904 824485 801701 801819 426510 584950 547805 716765 649583 718576 607236 749340 469195 751567 600360 827188 729253 556000 570179 647995 650817 729251 497667 540055 540104 540117 568375 590226 801823 464727 804416 813797 801776 826209 800726 633502 637413 734360 460860 550199 576652 668555 678032 600008 597873 617414 583913 715444 600017 827490 826408 555224 548895 555772 606071 795952 781488 801530 795943 801084 739618 634218 550196 637741 727534 664602 710480 553273 550205 647885 675019 639802 639027 775958 818573 540129 555601 542722 691821 661295 570941 757050 789438 729236 745865 726624 758259 714551 718745 635275 716878 758292 640156 811905 666892 618378 826322 558264 580868 683045 648891 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.90%) |
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 426510 460860 464727 469195 497667 540055 540104 540117 540120 540129 542722 547805 548895 550196 550199 550205 553273 554998 555055 555224 555601 555772 555784 556000 558264 568375 570179 570941 571708 576652 580868 583913 584950 585143 590226 597224 597873 600008 600017 600360 604645 606071 607236 612904 614346 617414 618378 633502 634218 635275 637413 637741 639027 639334 639774 639802 640156 647885 647893 647948 647995 648891 649583 650817 661295 664602 666892 666906 668555 674983 675019 678032 683045 691821 710480 714551 715444 716765 716878 718576 718745 726624 727534 729236 729251 729253 734360 736462 739618 745865 749340 751567 757050 758259 758292 765517 775958 781488 789438 795943 795952 800726 801084 801530 801701 801776 801819 801823 804416 811905 813797 817881 818573 824485 826098 826209 826322 826408 827188 827490 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"piss milf ass"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"писсинг milf жоп"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"писсинг milf жоп"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.07%) |
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.