Query Metrics
7
Database Queries
7
Different statements
353.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.58 ms (59.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск межрасов анал"
]
|
||||||||||||||||||||||||||||||
|
121.95 ms (34.51%) |
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 150507 181544 319164 395451 396595 401733 414108 418061 421743 425601 428062 434716 457228 465146 468020 470400 470427 483561 483570 489953 493805 494447 508427 531298 532708 536971 537941 538360 538749 549088 558342 559105 571015 581237 584034 584385 586021 586031 586970 587323 592182 593560 594226 594569 598645 605012 605407 605677 613494 624355 629510 630043 630156 633602 636956 637567 638932 645525 645669 656117 656537 656544 660059 662136 666583 666820 667741 688248 690885 695343 695387 709223 709922 712781 717673 719950 720015 720669 720780 721870 726282 728718 728739 729286 732450 733571 735026 738216 740874 748658 750275 750277 750303 751857 753513 755588 755843 766845 769900 782040 783085 788169 793075 796904 796941 811663 811716 813716 813848 816606 817163 817241 817264 823877 827434 827828 827829 827851 827874 827878 ] |
||||||||||||||||||||||||||||||
|
12.59 ms (3.56%) |
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 827434 753513 766845 425601 465146 740874 666583 434716 688248 811663 584385 593560 817241 823877 720780 750277 733571 750303 751857 656544 719950 630043 637567 793075 418061 150507 414108 796904 796941 811716 755588 656537 717673 558342 532708 827874 531298 667741 605677 605012 586021 586031 538360 470400 729286 720669 721870 483570 817163 813716 538749 720015 728718 709922 690885 494447 605407 656117 598645 592182 536971 584034 181544 470427 428062 613494 813848 537941 581237 633602 587323 755843 750275 782040 788169 726282 483561 421743 457228 732450 401733 666820 571015 493805 645525 662136 709223 594569 629510 586970 638932 712781 827828 827878 827851 549088 594226 738216 748658 396595 319164 489953 468020 769900 395451 816606 817264 783085 735026 728739 559105 695387 645669 636956 630156 624355 508427 827829 660059 695343 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (0.78%) |
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 150507 181544 319164 395451 396595 401733 414108 418061 421743 425601 428062 434716 457228 465146 468020 470400 470427 483561 483570 489953 493805 494447 508427 531298 532708 536971 537941 538360 538749 549088 558342 559105 571015 581237 584034 584385 586021 586031 586970 587323 592182 593560 594226 594569 598645 605012 605407 605677 613494 624355 629510 630043 630156 633602 636956 637567 638932 645525 645669 656117 656537 656544 660059 662136 666583 666820 667741 688248 690885 695343 695387 709223 709922 712781 717673 719950 720015 720669 720780 721870 726282 728718 728739 729286 732450 733571 735026 738216 740874 748658 750275 750277 750303 751857 753513 755588 755843 766845 769900 782040 783085 788169 793075 796904 796941 811663 811716 813716 813848 816606 817163 817241 817264 823877 827434 827828 827829 827851 827874 827878 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur interracial anal"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.