Query Metrics
7
Database Queries
7
Different statements
173.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.78 ms (85.35%) |
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 185143 196431 210052 384457 386746 386860 387130 396006 402043 405727 405973 406291 409668 415618 420143 424384 424397 433904 433996 443145 445064 446814 448183 448458 449856 452398 452402 452426 454029 458041 459630 460172 461020 469350 471896 474953 488885 489800 502894 505012 508362 517356 517589 521778 530784 531269 533030 536559 536588 543860 544414 546140 546580 560340 563393 563732 564262 574318 574355 579137 583714 585251 592700 593314 604836 604837 607500 611716 618965 623425 623432 626379 634326 643455 646257 651604 674825 678052 707702 709430 709452 711542 714675 715816 717173 717962 725339 728044 729759 730450 732715 734259 737178 741068 744909 756570 757840 764333 769344 769354 769575 770144 775268 775888 776785 778931 781097 781102 787799 796413 799528 801364 801504 803589 806836 808062 811846 812822 813653 818680 ] |
||||||||||||||||||||||||||||||
|
14.90 ms (8.61%) |
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 460172 474953 543860 634326 730450 405973 433904 674825 592700 776785 775888 769354 799528 770144 781102 502894 536588 210052 717962 741068 769344 623425 452426 563732 517589 448183 415618 505012 585251 185143 488885 574355 452402 564262 604837 643455 801364 812822 801504 734259 574318 678052 489800 618965 769575 546140 563393 546580 717173 387130 386746 424384 533030 405727 433996 709430 607500 796413 732715 813653 808062 811846 778931 787799 536559 386860 409668 651604 454029 452398 531269 384457 579137 646257 604836 806836 781097 729759 728044 744909 458041 445064 469350 424397 560340 196431 420143 471896 714675 757840 402043 443145 461020 406291 818680 544414 709452 711542 725339 508362 459630 521778 530784 583714 449856 517356 396006 448458 707702 593314 626379 611716 775268 737178 756570 764333 623432 715816 803589 446814 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.73%) |
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 185143 196431 210052 384457 386746 386860 387130 396006 402043 405727 405973 406291 409668 415618 420143 424384 424397 433904 433996 443145 445064 446814 448183 448458 449856 452398 452402 452426 454029 458041 459630 460172 461020 469350 471896 474953 488885 489800 502894 505012 508362 517356 517589 521778 530784 531269 533030 536559 536588 543860 544414 546140 546580 560340 563393 563732 564262 574318 574355 579137 583714 585251 592700 593314 604836 604837 607500 611716 618965 623425 623432 626379 634326 643455 646257 651604 674825 678052 707702 709430 709452 711542 714675 715816 717173 717962 725339 728044 729759 730450 732715 734259 737178 741068 744909 756570 757840 764333 769344 769354 769575 770144 775268 775888 776785 778931 781097 781102 787799 796413 799528 801364 801504 803589 806836 808062 811846 812822 813653 818680 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge boobs handjob"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные boobs дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"огромные boobs дрочк член"
]
|
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.