Query Metrics
7
Database Queries
7
Different statements
158.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.67 ms (86.13%) |
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 69883 336884 393164 398679 488565 494312 503388 505936 517739 520364 540606 543153 553701 563382 563962 581289 584956 586978 591919 597829 623407 634597 634599 636399 642041 663223 666001 666402 674616 695693 696220 697731 707729 710819 714360 717958 718400 718533 719215 719284 720082 720272 723156 724810 729186 730717 731277 731429 733138 733198 734402 735841 736643 739253 739542 739981 746725 746730 755605 763002 767801 767807 767816 768974 769221 769840 770067 772339 772371 775159 775162 775165 777452 777961 779047 779781 779783 780250 781034 781465 782691 786841 787222 787258 787269 790057 790705 790766 791605 791617 810044 810216 813634 813955 817001 819718 821429 823875 823897 824113 824948 824973 825006 825045 825108 825179 825180 825208 825347 825417 825425 825460 825464 825837 826240 826586 827108 828193 ] |
||||||||||||||||||||||||||||||
|
12.63 ms (7.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 825417 826524 780250 494312 719215 636399 779783 730717 746730 781465 540606 543153 720272 718400 634599 724810 735841 755605 770067 775165 787269 825837 825179 825347 825464 767816 597829 813955 488565 505936 563962 666001 718533 719284 723156 775159 775162 779781 781034 791617 734402 739253 746725 782691 786841 787258 790705 791605 731277 768974 769221 772339 729186 736643 739981 763002 767801 731429 714360 777961 779047 787222 790766 810044 810216 336884 823875 824973 817001 823897 826240 827108 821429 825108 825180 828193 696220 733198 769840 813634 695693 707729 720082 777452 790057 739542 772371 767807 717958 642041 517739 825045 520364 503388 393164 398679 825006 825460 826137 826586 825425 824948 825208 819718 824113 733138 69883 553701 563382 663223 666402 674616 697731 710819 581289 584956 586978 623407 591919 634597 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.44%) |
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 69883 336884 393164 398679 488565 494312 503388 505936 517739 520364 540606 543153 553701 563382 563962 581289 584956 586978 591919 597829 623407 634597 634599 636399 642041 663223 666001 666402 674616 695693 696220 697731 707729 710819 714360 717958 718400 718533 719215 719284 720082 720272 723156 724810 729186 730717 731277 731429 733138 733198 734402 735841 736643 739253 739542 739981 746725 746730 755605 763002 767801 767807 767816 768974 769221 769840 770067 772339 772371 775159 775162 775165 777452 777961 779047 779781 779783 780250 781034 781465 782691 786841 787222 787258 787269 790057 790705 790766 791605 791617 810044 810216 813634 813955 817001 819718 821429 823875 823897 824113 824948 824973 825006 825045 825108 825179 825180 825208 825347 825417 825425 825460 825464 825837 826240 826586 827108 828193 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mouth sperm"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mouth сперм"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mouth сперм"
]
|
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.