Query Metrics
7
Database Queries
7
Different statements
199.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.06 ms (86.96%) |
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 525945 540061 540150 540774 542444 542452 543680 544617 549040 552606 554716 554828 554846 555259 555320 555388 555392 555401 555447 558889 560493 560947 562051 569537 577052 579826 580025 580382 584267 585057 588389 591476 604636 604715 605512 606253 606271 606322 614819 618295 618864 626402 627833 629830 630521 633182 636707 637036 639655 641313 643705 647837 650608 651922 652779 652799 655569 656523 665071 667471 667944 670465 678492 710026 714489 714619 717147 720598 725487 725536 727042 728276 731099 731762 732869 734403 736534 738694 740213 740472 746091 746603 748935 748937 751357 751360 752840 753707 758176 768093 770039 772107 775815 788537 788979 789111 793723 795812 796092 796577 803960 804437 805836 809741 809800 810093 811785 811862 811882 811889 811896 811907 811916 814157 814278 817207 817709 817879 818694 824438 ] |
||||||||||||||||||||||||||||||
|
13.84 ms (6.96%) |
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 753707 738694 626402 629830 788537 804437 809800 811896 637036 588389 803960 752840 817207 817709 817879 824438 585057 818694 814157 814278 525945 542452 555259 558889 562051 542444 549040 555320 569537 543680 554828 554846 560493 580025 667471 670465 714619 652799 655569 665071 710026 555401 604636 605512 606322 604715 591476 618295 641313 810093 811907 811916 725487 731762 736534 746091 751360 727042 728276 746603 748935 751357 768093 627833 717147 775815 788979 796092 647837 652779 560947 796577 720598 795812 540774 540150 555388 555447 580382 555392 584267 650608 678492 651922 656523 667944 714489 554716 606253 636707 618864 630521 643705 606271 614819 793723 809741 811882 725536 734403 772107 789111 805836 811785 732869 740213 770039 731099 740472 748937 758176 633182 639655 811862 811889 540061 552606 577052 579826 544617 ] |
||||||||||||||||||||||||||||||
|
4.41 ms (2.22%) |
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 525945 540061 540150 540774 542444 542452 543680 544617 549040 552606 554716 554828 554846 555259 555320 555388 555392 555401 555447 558889 560493 560947 562051 569537 577052 579826 580025 580382 584267 585057 588389 591476 604636 604715 605512 606253 606271 606322 614819 618295 618864 626402 627833 629830 630521 633182 636707 637036 639655 641313 643705 647837 650608 651922 652779 652799 655569 656523 665071 667471 667944 670465 678492 710026 714489 714619 717147 720598 725487 725536 727042 728276 731099 731762 732869 734403 736534 738694 740213 740472 746091 746603 748935 748937 751357 751360 752840 753707 758176 768093 770039 772107 775815 788537 788979 789111 793723 795812 796092 796577 803960 804437 805836 809741 809800 810093 811785 811862 811882 811889 811896 811907 811916 814157 814278 817207 817709 817879 818694 824438 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf pissing"
]
|
||||||||||||||||||||||||||||||
|
2.21 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf pissing"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf pissing"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.76%) |
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.