Query Metrics
7
Database Queries
7
Different statements
174.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.91 ms (85.91%) |
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 4131 14232 89480 192551 381936 407176 412122 413076 413084 419818 432433 432488 435507 442051 447250 448126 448681 449570 452626 453025 455391 457677 457917 459661 462707 466228 468374 469937 470920 479261 482437 484147 485382 486894 489172 497845 504044 508188 508337 509009 509202 509621 511950 513382 522513 526869 528635 530648 532811 535688 537838 538216 540753 542514 545679 553143 556172 556677 562381 568594 571452 578848 579967 586310 586973 590898 592719 598934 603051 605584 615316 623808 624543 625175 629631 653070 659210 660103 662807 665952 666966 666992 667103 668716 691178 691735 701581 703347 710881 712525 717139 722099 723438 728937 732696 733530 737948 745364 748227 753928 755644 757289 761699 765760 766778 780400 781586 784287 791213 795192 798445 798677 801159 802364 804177 804693 805188 808480 817571 ] |
||||||||||||||||||||||||||||||
|
14.03 ms (8.04%) |
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 532811 540753 526869 579967 659210 723438 666992 701581 710881 653070 665952 667103 624543 629631 801159 804693 804177 755644 737948 753928 765760 733530 703347 776323 780400 795192 798445 192551 660103 528635 413084 459661 486894 448681 452626 432488 412122 817571 530648 712525 668716 691735 722099 603051 791213 745364 728937 784287 419818 484147 538216 381936 413076 482437 535688 511950 545679 556172 662807 691178 717139 666966 586973 805188 615316 407176 432433 457917 509202 489172 497845 485382 578848 748227 466228 449570 537838 468374 571452 590898 625175 802364 732696 761699 470920 14232 568594 542514 508188 598934 513382 798677 442051 509621 766778 757289 623808 781586 435507 89480 4131 457677 562381 553143 556677 592719 453025 462707 479261 469937 448126 508337 509009 522513 605584 447250 504044 586310 808480 455391 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.76%) |
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 4131 14232 89480 192551 381936 407176 412122 413076 413084 419818 432433 432488 435507 442051 447250 448126 448681 449570 452626 453025 455391 457677 457917 459661 462707 466228 468374 469937 470920 479261 482437 484147 485382 486894 489172 497845 504044 508188 508337 509009 509202 509621 511950 513382 522513 526869 528635 530648 532811 535688 537838 538216 540753 542514 545679 553143 556172 556677 562381 568594 571452 578848 579967 586310 586973 590898 592719 598934 603051 605584 615316 623808 624543 625175 629631 653070 659210 660103 662807 665952 666966 666992 667103 668716 691178 691735 701581 703347 710881 712525 717139 722099 723438 728937 732696 733530 737948 745364 748227 753928 755644 757289 761699 765760 766778 780400 781586 784287 791213 795192 798445 798677 801159 802364 804177 804693 805188 808480 817571 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife 69 ass"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен поз 69 жоп"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен поз 69 жоп"
]
|
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.