Query Metrics
7
Database Queries
7
Different statements
450.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.32 ms (47.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"соло shower milf"
]
|
||||||||||||||||||||||||||||||
|
209.16 ms (46.46%) |
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 34201 186858 386153 387398 387409 391980 424084 452215 454266 455324 462001 465682 473471 475289 478516 483485 488903 492959 509019 509176 515531 528452 532454 533562 545905 546036 548891 550150 550540 553547 553592 557352 559342 575860 577309 580924 583229 583804 586100 586749 589522 591548 592947 592964 595131 596736 596796 596905 597435 598267 604915 605060 605743 605973 608047 610061 611476 614485 614819 618020 620908 627196 632289 636738 636747 641313 643284 643380 646084 650272 650608 652817 656523 657791 667404 680933 700985 702375 705427 706023 710026 714941 724160 736388 740435 751170 751357 751360 752647 752759 754653 756285 759116 767731 770039 774728 774742 784320 788124 790824 791479 796862 797369 798762 801791 803367 803819 804443 805145 806984 808335 809556 810041 811880 811882 811891 811907 814706 823780 823790 ] |
||||||||||||||||||||||||||||||
|
19.09 ms (4.24%) |
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 710026 714941 548891 553547 553592 557352 583229 605743 636738 592947 596736 610061 614485 643284 586100 598267 605060 611476 636747 596905 608047 620908 627196 641313 774728 774742 798762 803367 806984 808335 788124 801791 784320 797369 811907 736388 767731 724160 751360 754653 751357 702375 705427 790824 810041 387409 473471 528452 657791 823790 452215 475289 583804 545905 591548 604915 643380 596796 752759 632289 391980 509019 796862 424084 386153 186858 34201 387398 814706 823780 483485 455324 454266 465682 478516 509176 533562 532454 515531 462001 488903 492959 550150 559342 580924 546036 550540 577309 650608 667404 700985 650272 706023 646084 652817 656523 680933 575860 592964 589522 595131 605973 618020 586749 597435 614819 805145 811891 803819 804443 809556 811880 811882 752647 756285 791479 740435 751170 770039 759116 ] |
||||||||||||||||||||||||||||||
|
4.13 ms (0.92%) |
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 34201 186858 386153 387398 387409 391980 424084 452215 454266 455324 462001 465682 473471 475289 478516 483485 488903 492959 509019 509176 515531 528452 532454 533562 545905 546036 548891 550150 550540 553547 553592 557352 559342 575860 577309 580924 583229 583804 586100 586749 589522 591548 592947 592964 595131 596736 596796 596905 597435 598267 604915 605060 605743 605973 608047 610061 611476 614485 614819 618020 620908 627196 632289 636738 636747 641313 643284 643380 646084 650272 650608 652817 656523 657791 667404 680933 700985 702375 705427 706023 710026 714941 724160 736388 740435 751170 751357 751360 752647 752759 754653 756285 759116 767731 770039 774728 774742 784320 788124 790824 791479 796862 797369 798762 801791 803367 803819 804443 805145 806984 808335 809556 810041 811880 811882 811891 811907 814706 823780 823790 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло shower milf"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло shower milf"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.36%) |
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.