Query Metrics
7
Database Queries
7
Different statements
158.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.91 ms (85.38%) |
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 447944 525753 525761 538912 538945 538951 542497 544190 544274 544275 544291 545094 549856 562827 563390 564545 566354 566373 567932 568274 568288 571392 571422 574269 581353 581401 582342 591641 591678 592415 592541 597031 600712 603041 603187 603273 606598 616341 619275 619470 620934 627748 629409 635191 636265 644275 644300 644303 644314 644968 646228 646942 648598 649082 649154 650494 650853 651142 651210 651604 651951 652187 652561 653486 665651 669567 669640 670097 670098 670110 671734 671740 672130 672721 672767 677699 677705 681059 681137 681782 684029 687440 689701 690846 690854 690868 690947 691992 692293 692453 692455 693864 694053 694139 694212 694470 694524 695629 695930 695948 696355 699584 699631 703037 703095 703096 703097 703436 703511 703833 705549 705935 708099 709052 712006 719058 729821 742971 789841 811940 ] |
||||||||||||||||||||||||||||||
|
13.68 ms (8.66%) |
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 677699 665651 694524 703097 646942 629409 811940 644275 703037 703095 542497 651951 636265 651210 568288 690868 705549 447944 592541 571422 616341 544190 581353 651604 544274 681059 695930 672130 694053 563390 644300 600712 789841 703511 705935 525753 538951 566373 544275 544291 646228 651142 669640 670110 699584 687440 690947 606598 708099 649082 619275 620934 566354 650494 652187 672767 692453 694470 719058 648598 670097 677705 690854 695948 696355 669567 671734 671740 689701 694212 709052 545094 592415 627748 729821 742971 703436 525761 564545 649154 653486 690846 538945 703833 549856 619470 538912 672721 693864 699631 591641 603273 597031 568274 652561 694139 681782 635191 591678 644303 712006 574269 582342 581401 681137 644968 567932 571392 695629 703096 650853 670098 684029 691992 692455 692293 562827 603041 603187 644314 ] |
||||||||||||||||||||||||||||||
|
2.19 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 447944 525753 525761 538912 538945 538951 542497 544190 544274 544275 544291 545094 549856 562827 563390 564545 566354 566373 567932 568274 568288 571392 571422 574269 581353 581401 582342 591641 591678 592415 592541 597031 600712 603041 603187 603273 606598 616341 619275 619470 620934 627748 629409 635191 636265 644275 644300 644303 644314 644968 646228 646942 648598 649082 649154 650494 650853 651142 651210 651604 651951 652187 652561 653486 665651 669567 669640 670097 670098 670110 671734 671740 672130 672721 672767 677699 677705 681059 681137 681782 684029 687440 689701 690846 690854 690868 690947 691992 692293 692453 692455 693864 694053 694139 694212 694470 694524 695629 695930 695948 696355 699584 699631 703037 703095 703096 703097 703436 703511 703833 705549 705935 708099 709052 712006 719058 729821 742971 789841 811940 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"handjob retro"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк член ретр"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.