Query Metrics
7
Database Queries
7
Different statements
151.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.39 ms (83.97%) |
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 415309 420011 420012 423765 423773 435572 438013 439307 440633 442608 443804 447997 452963 455284 455500 458527 464962 465434 466035 466252 466749 466756 467922 469113 470007 473400 477140 478523 478537 495381 507032 535332 538480 541377 541847 544959 545901 546971 547763 552379 566659 578768 590337 590538 595660 602131 617796 619877 619895 619901 620260 659360 666006 669892 672825 672843 675596 695477 695543 700965 712627 714307 718744 722216 741691 741750 742285 742298 742303 742364 743490 744178 744380 745466 745485 749029 751528 751554 751571 751574 751613 752950 757918 763726 763729 763745 765815 765849 765863 765868 768603 782553 783303 788120 790634 790648 793103 793940 794033 794038 794041 794841 795979 799217 799859 802282 804829 805137 805154 806955 808342 808411 808562 810483 810896 811771 812067 824303 824735 825514 ] |
||||||||||||||||||||||||||||||
|
14.46 ms (9.53%) |
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 473400 438013 452963 714307 423765 440633 824303 824735 825514 455500 466035 495381 538480 507032 535332 466749 477140 566659 544959 546971 547763 552379 578768 541377 541847 672825 672843 675596 695543 712627 718744 666006 659360 669892 695477 700965 722216 545901 595660 602131 620260 590337 590538 619895 619901 795979 804829 808562 810483 811771 788120 790634 794841 802282 805137 806955 812067 741750 743490 745485 751613 752950 790648 793103 794041 799859 808342 808411 810896 741691 744178 744380 751554 765849 742285 742303 742364 745466 749029 751574 757918 765863 768603 742298 751528 751571 763726 763729 763745 765815 765868 617796 619877 782553 783303 793940 794033 794038 799217 805154 443804 467922 420011 442608 464962 466252 466756 469113 415309 423773 465434 435572 439307 447997 478523 478537 420012 455284 458527 470007 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (2.02%) |
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 415309 420011 420012 423765 423773 435572 438013 439307 440633 442608 443804 447997 452963 455284 455500 458527 464962 465434 466035 466252 466749 466756 467922 469113 470007 473400 477140 478523 478537 495381 507032 535332 538480 541377 541847 544959 545901 546971 547763 552379 566659 578768 590337 590538 595660 602131 617796 619877 619895 619901 620260 659360 666006 669892 672825 672843 675596 695477 695543 700965 712627 714307 718744 722216 741691 741750 742285 742298 742303 742364 743490 744178 744380 745466 745485 749029 751528 751554 751571 751574 751613 752950 757918 763726 763729 763745 765815 765849 765863 765868 768603 782553 783303 788120 790634 790648 793103 793940 794033 794038 794041 794841 795979 799217 799859 802282 804829 805137 805154 806955 808342 808411 808562 810483 810896 811771 812067 824303 824735 825514 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf русск соло"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf russian solo"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf русск соло"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.98%) |
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.