Query Metrics
7
Database Queries
7
Different statements
162.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.59 ms (86.48%) |
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 61707 153376 162000 388716 389234 389582 393687 395422 397172 405128 406045 411769 411907 411960 423971 426016 427208 431681 446012 452350 454404 459858 462604 467037 469284 470431 493020 495287 496315 503974 506075 521727 528036 530097 536585 537842 540086 544669 582469 583352 611530 633954 644905 653392 663871 663964 663994 664285 664305 664368 664801 664810 665038 665210 665248 665270 665273 665833 665873 667279 669457 669779 698113 705705 706625 709623 718331 728443 743767 745536 745952 747186 749016 755989 757543 772107 772119 776402 781772 781782 781783 781785 781796 781801 781809 781818 781829 781833 781837 781863 781874 781883 781889 781893 781911 792592 793649 794175 794828 798640 799989 801014 802418 805868 810734 811991 812391 812943 814711 815369 817870 819189 820715 821761 824331 824354 824441 824688 825241 826910 ] |
||||||||||||||||||||||||||||||
|
11.91 ms (7.32%) |
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 664368 452350 653392 669457 395422 826910 153376 537842 663871 781863 781911 781809 805868 406045 824441 772107 467037 781889 749016 757543 426016 663994 781818 817870 644905 819189 530097 582469 583352 665038 665833 667279 718331 781837 781874 793649 772119 781833 745536 743767 811991 493020 781783 812943 747186 544669 393687 798640 781772 664810 664285 794175 705705 781829 162000 536585 431681 389234 459858 528036 506075 664801 665273 423971 633954 781785 665873 698113 792592 802418 755989 470431 521727 781782 462604 824354 824688 821761 814711 815369 824331 540086 665248 665270 669779 709623 706625 781801 781883 812391 781796 794828 776402 781893 801014 61707 664305 665210 405128 496315 745952 388716 397172 663964 389582 495287 454404 503974 728443 799989 810734 411769 469284 411960 820715 446012 611530 411907 427208 825241 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob bbw"
]
|
||||||||||||||||||||||||||||||
|
2.41 ms (1.48%) |
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 61707 153376 162000 388716 389234 389582 393687 395422 397172 405128 406045 411769 411907 411960 423971 426016 427208 431681 446012 452350 454404 459858 462604 467037 469284 470431 493020 495287 496315 503974 506075 521727 528036 530097 536585 537842 540086 544669 582469 583352 611530 633954 644905 653392 663871 663964 663994 664285 664305 664368 664801 664810 665038 665210 665248 665270 665273 665833 665873 667279 669457 669779 698113 705705 706625 709623 718331 728443 743767 745536 745952 747186 749016 755989 757543 772107 772119 776402 781772 781782 781783 781785 781796 781801 781809 781818 781829 781833 781837 781863 781874 781883 781889 781893 781911 792592 793649 794175 794828 798640 799989 801014 802418 805868 810734 811991 812391 812943 814711 815369 817870 819189 820715 821761 824331 824354 824441 824688 825241 826910 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс bbw"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс bbw"
]
|
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.