Query Metrics
7
Database Queries
7
Different statements
190.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.75 ms (88.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 33804 47989 91578 230986 271234 391681 397435 414720 475311 478410 490966 495517 521724 529575 549430 554499 582709 590240 591220 593647 642614 668818 676434 696220 696605 697673 701275 701468 714560 715782 716609 718861 720804 722113 734515 736113 736256 737002 739253 741880 743824 744429 745357 747077 747541 754851 756268 758134 759194 761094 761456 763525 763655 763905 763972 765987 769697 771363 773380 773721 777459 777486 778087 779497 780394 781034 781137 781284 781563 783862 787222 787237 787622 787840 788733 790332 790350 790354 791903 793754 794473 795189 795193 795806 795844 796357 796566 797225 798301 799690 800250 801179 808026 808251 810626 816110 818966 818986 819326 819699 819798 820734 821796 823448 823783 824099 824113 824716 825107 825200 825244 825280 825356 826536 826654 826831 826986 827119 828672 ] |
||||||||||||||||||||||||||||||
|
11.76 ms (6.17%) |
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 701468 642614 821796 825200 826831 827119 783862 790354 741880 771363 773380 763525 47989 33804 790332 761094 495517 414720 391681 788733 696220 758134 819699 816110 828672 529575 715782 718861 781137 778087 737002 763972 781563 745357 736113 714560 716609 787222 800250 824716 824099 818986 825356 795193 797225 736256 271234 826536 825107 826986 824113 819326 790350 769697 795189 820734 823448 810626 697673 765987 744429 796566 676434 582709 780394 793754 230986 825280 825244 799690 796357 801179 739253 763905 787622 795806 798301 747541 754851 761456 763655 763712 781284 787237 787840 791903 747077 826654 521724 549430 696605 668818 701275 593647 591220 590240 777459 777486 779497 743824 773721 756268 759194 808251 818966 795844 808026 722113 794473 475311 91578 490966 478410 819798 781034 720804 734515 554499 397435 823783 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.32%) |
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 33804 47989 91578 230986 271234 391681 397435 414720 475311 478410 490966 495517 521724 529575 549430 554499 582709 590240 591220 593647 642614 668818 676434 696220 696605 697673 701275 701468 714560 715782 716609 718861 720804 722113 734515 736113 736256 737002 739253 741880 743824 744429 745357 747077 747541 754851 756268 758134 759194 761094 761456 763525 763655 763905 763972 765987 769697 771363 773380 773721 777459 777486 778087 779497 780394 781034 781137 781284 781563 783862 787222 787237 787622 787840 788733 790332 790350 790354 791903 793754 794473 795189 795193 795806 795844 796357 796566 797225 798301 799690 800250 801179 808026 808251 810626 816110 818966 818986 819326 819699 819798 820734 821796 823448 823783 824099 824113 824716 825107 825200 825244 825280 825356 826536 826654 826831 826986 827119 828672 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.