Query Metrics
7
Database Queries
7
Different statements
195.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.63 ms (85.85%) |
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 7748 31134 388098 392750 394582 395292 416277 423129 432366 432556 433384 437974 439668 440871 448096 451629 452312 453295 453300 455278 459241 460627 469418 470652 472016 472134 477168 480833 489634 489776 489791 490514 493299 494703 497197 504964 506552 509651 514116 515592 520201 524955 527739 528088 528187 531268 531945 532706 547409 552367 553359 555900 564113 567076 573381 577718 579300 580022 580653 596234 596704 603847 623650 626231 628459 629409 645387 650011 666991 672903 688254 693396 716267 718909 727017 735834 735840 735868 735875 735959 737178 739700 741009 741084 742545 746461 756058 760534 761858 762670 765557 769094 773000 775054 775690 775818 775857 778034 784857 785062 793496 796959 798600 799522 800620 800623 801430 803906 803910 807367 810479 811246 815117 816959 817080 817348 817371 817416 817889 828337 ] |
||||||||||||||||||||||||||||||
|
14.73 ms (7.54%) |
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 784857 531268 531945 762670 528088 552367 453295 392750 815117 453300 524955 580653 547409 564113 718909 650011 567076 737178 775818 480833 470652 416277 553359 580022 628459 432556 515592 716267 472134 506552 497197 493299 448096 494703 437974 504964 440871 459241 672903 773000 528187 490514 596234 439668 520201 489791 395292 451629 469418 455278 514116 735840 472016 433384 828337 688254 489776 742545 394582 666991 746461 739700 489634 532706 579300 756058 810479 452312 388098 423129 817371 817416 817080 817889 816959 460627 555900 577718 573381 693396 626231 629409 596704 623650 775690 798600 741009 741084 761858 765557 760534 603847 432366 527739 31134 817348 477168 645387 775054 793496 775857 796959 799522 800623 801430 735959 769094 785062 735875 727017 735834 735868 778034 800620 803906 803910 807367 811246 7748 509651 ] |
||||||||||||||||||||||||||||||
|
4.93 ms (2.52%) |
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 7748 31134 388098 392750 394582 395292 416277 423129 432366 432556 433384 437974 439668 440871 448096 451629 452312 453295 453300 455278 459241 460627 469418 470652 472016 472134 477168 480833 489634 489776 489791 490514 493299 494703 497197 504964 506552 509651 514116 515592 520201 524955 527739 528088 528187 531268 531945 532706 547409 552367 553359 555900 564113 567076 573381 577718 579300 580022 580653 596234 596704 603847 623650 626231 628459 629409 645387 650011 666991 672903 688254 693396 716267 718909 727017 735834 735840 735868 735875 735959 737178 739700 741009 741084 742545 746461 756058 760534 761858 762670 765557 769094 773000 775054 775690 775818 775857 778034 784857 785062 793496 796959 798600 799522 800620 800623 801430 803906 803910 807367 810479 811246 815117 816959 817080 817348 817371 817416 817889 828337 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мамки дрочит член"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.94%) |
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.