Query Metrics
7
Database Queries
7
Different statements
140.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.35 ms (83.57%) |
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 55903 393836 435605 441255 444986 462018 471027 494216 494543 495861 507330 516570 521153 524418 528654 536866 544125 556151 557048 559752 571095 574125 575958 584621 585435 585666 585861 588455 599672 609183 614770 621079 624914 625953 626369 627412 632288 632857 644024 649437 653288 661511 662147 669675 702557 706001 706057 708226 709093 711354 711597 712800 714254 714502 714565 717533 721204 725417 726459 730163 733434 733518 734105 735959 743355 743949 745715 745960 746096 748304 750287 751315 753635 753716 753775 754132 754318 756020 757183 761910 762366 764122 764138 765423 767915 768724 769153 769369 771749 774662 774769 777739 780015 784920 785526 787477 789586 790462 791871 793162 803026 803092 803385 803491 804061 806586 806593 806700 810585 811324 811887 812314 812381 812433 813741 813878 819810 825131 826601 826701 ] |
||||||||||||||||||||||||||||||
|
12.76 ms (9.09%) |
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 733518 753716 754132 745960 746096 714502 721204 774769 780015 784920 393836 528654 536866 662147 55903 711354 644024 714565 435605 819810 825131 495861 516570 471027 557048 574125 653288 575958 632857 588455 785526 790462 811324 811887 812314 812433 806700 810585 812381 725417 803026 803385 803491 806586 806593 734105 762366 767915 726459 750287 748304 769369 609183 709093 787477 789586 791871 793162 803092 804061 524418 507330 494543 669675 702557 712800 649437 714254 614770 599672 627412 761910 621079 632288 444986 544125 706057 661511 585861 745715 764122 764138 624914 441255 826601 826701 813741 813878 462018 521153 494216 559752 556151 717533 706001 708226 711597 571095 584621 585666 626369 585435 625953 774662 730163 733434 735959 743355 743949 751315 768724 756020 769153 754318 771749 753635 753775 757183 765423 777739 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.83%) |
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 55903 393836 435605 441255 444986 462018 471027 494216 494543 495861 507330 516570 521153 524418 528654 536866 544125 556151 557048 559752 571095 574125 575958 584621 585435 585666 585861 588455 599672 609183 614770 621079 624914 625953 626369 627412 632288 632857 644024 649437 653288 661511 662147 669675 702557 706001 706057 708226 709093 711354 711597 712800 714254 714502 714565 717533 721204 725417 726459 730163 733434 733518 734105 735959 743355 743949 745715 745960 746096 748304 750287 751315 753635 753716 753775 754132 754318 756020 757183 761910 762366 764122 764138 765423 767915 768724 769153 769369 771749 774662 774769 777739 780015 784920 785526 787477 789586 790462 791871 793162 803026 803092 803385 803491 804061 806586 806593 806700 810585 811324 811887 812314 812381 812433 813741 813878 819810 825131 826601 826701 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur masturbating"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск masturbating"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск masturbating"
]
|
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.