Query Metrics
7
Database Queries
7
Different statements
166.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.75 ms (86.21%) |
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 61498 66574 213627 375930 386371 387068 388796 389979 391213 412855 423907 424236 432485 432488 432511 434242 438181 447335 472621 479788 482846 482891 490257 507253 530679 531850 536065 536907 555734 557402 564287 568655 576728 578110 578328 591765 595300 596240 604696 606168 610911 636666 642820 662061 662151 663158 663882 666164 666988 707196 713444 723909 725301 725507 726447 729366 736561 738926 739126 739158 739768 742691 744374 745128 746267 748489 751044 752125 755038 757483 757484 758163 760548 760558 762414 764030 765701 766099 771348 772242 772247 772257 772688 776007 776011 776031 776041 778103 779765 782825 783733 784744 785745 785857 786017 786098 786441 790191 790910 791025 793085 794478 797904 798799 799995 804930 806527 806822 807206 807588 808186 808780 808796 808969 809005 812058 814403 ] |
||||||||||||||||||||||||||||||
|
13.80 ms (8.28%) |
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 790910 808969 725507 760548 772247 785745 786017 794478 804930 772688 739768 752125 772242 762017 713444 776011 798799 447335 412855 568655 438181 536907 530679 536065 555734 662151 591765 610911 779765 786867 799995 797904 725301 757484 772257 786441 751044 758163 723909 739126 746267 748489 739158 755038 764030 744374 778103 783733 790191 793085 807588 423907 432485 391213 482846 814403 472621 531850 490257 578110 578328 662061 663882 604696 642820 606168 595300 808780 809005 776041 765701 785857 786098 807147 729366 745128 762414 757483 776007 791025 806527 806822 375930 389979 387068 424236 434242 479788 596240 386371 66574 213627 61498 388796 432488 432511 482891 507253 564287 557402 663158 666164 666988 707196 576728 636666 776031 782825 807206 808186 808796 726447 771348 736561 738926 766099 742691 760558 784744 812058 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.45%) |
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 61498 66574 213627 375930 386371 387068 388796 389979 391213 412855 423907 424236 432485 432488 432511 434242 438181 447335 472621 479788 482846 482891 490257 507253 530679 531850 536065 536907 555734 557402 564287 568655 576728 578110 578328 591765 595300 596240 604696 606168 610911 636666 642820 662061 662151 663158 663882 666164 666988 707196 713444 723909 725301 725507 726447 729366 736561 738926 739126 739158 739768 742691 744374 745128 746267 748489 751044 752125 755038 757483 757484 758163 760548 760558 762414 764030 765701 766099 771348 772242 772247 772257 772688 776007 776011 776031 776041 778103 779765 782825 783733 784744 785745 785857 786017 786098 786441 790191 790910 791025 793085 794478 797904 798799 799995 804930 806527 806822 807206 807588 808186 808780 808796 808969 809005 812058 814403 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pantyhose riding"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pantyhose riding"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pantyhose riding"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.86%) |
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.