Query Metrics
7
Database Queries
7
Different statements
255.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
234.54 ms (91.93%) |
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 387851 420828 441424 441490 443665 467666 480065 495308 495841 497013 505935 525629 529460 530553 546086 557326 559512 563561 565104 567171 567642 577989 596358 602969 612578 615506 622996 625639 630379 642093 643149 647074 652424 654878 655289 668942 668950 671243 679195 679305 682227 686323 686589 712892 713734 716918 717763 719324 722240 724455 724834 724971 726297 726914 727309 730707 731797 733657 735831 736342 736680 737972 738729 739106 740168 740225 743527 747302 750084 750106 750558 754895 755577 758183 758999 759593 761818 761824 763977 764615 765886 766472 766652 769084 772359 772560 772564 772948 777167 778149 778743 778825 779152 779367 779894 781041 781640 782785 786022 786233 786796 786886 789089 798868 798882 802938 803980 804013 806054 807275 810205 810720 812440 814964 815291 821892 827103 827812 ] |
||||||||||||||||||||||||||||||
|
11.88 ms (4.65%) |
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 778825 786796 786886 736680 750558 810205 763977 735831 724834 727309 747302 761824 764615 630379 717763 722240 781640 802938 495308 505935 671243 731797 814964 647074 781041 786022 737972 772948 596358 766472 726914 758183 443665 441424 529460 565104 712892 642093 807275 810720 789089 804013 736342 769084 782785 765886 750084 771059 612578 387851 480065 497013 530553 713734 652424 682227 577989 643149 803980 730707 733657 772560 740225 724455 724971 738729 750106 755577 441490 821892 827103 567642 679305 694097 679195 557326 559512 625639 778743 779894 806054 812440 779367 798868 739106 759593 743527 772359 719324 779152 798882 420828 815291 827812 467666 525629 495841 563561 546086 686589 716918 654878 655289 668942 668950 686323 567171 602969 615506 622996 778149 777167 786233 758999 761818 740168 754895 766652 726297 772564 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.03%) |
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 387851 420828 441424 441490 443665 467666 480065 495308 495841 497013 505935 525629 529460 530553 546086 557326 559512 563561 565104 567171 567642 577989 596358 602969 612578 615506 622996 625639 630379 642093 643149 647074 652424 654878 655289 668942 668950 671243 679195 679305 682227 686323 686589 712892 713734 716918 717763 719324 722240 724455 724834 724971 726297 726914 727309 730707 731797 733657 735831 736342 736680 737972 738729 739106 740168 740225 743527 747302 750084 750106 750558 754895 755577 758183 758999 759593 761818 761824 763977 764615 765886 766472 766652 769084 772359 772560 772564 772948 777167 778149 778743 778825 779152 779367 779894 781041 781640 782785 786022 786233 786796 786886 789089 798868 798882 802938 803980 804013 806054 807275 810205 810720 812440 814964 815291 821892 827103 827812 ] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex xxx student"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.65%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс xxx student"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.57%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.28 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс xxx student"
]
|
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.