Query Metrics
7
Database Queries
7
Different statements
170.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.83 ms (86.20%) |
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 6745 189743 382281 382579 387874 388888 391735 397188 397352 398869 423497 423516 426548 432688 481824 485136 493581 497443 530496 546784 554956 564252 567055 568477 572331 589422 604263 608545 609899 619241 630399 631356 637234 639293 639601 639825 642659 644059 655149 655289 656607 657145 660701 661660 665904 671247 671628 680431 683052 705348 710736 713895 714033 714660 714975 717920 718714 719308 721453 724030 728718 731025 731213 736741 737049 738121 738241 740637 744090 745457 748825 750263 757762 758192 758906 759474 760892 760983 761036 761172 761698 761776 761787 762273 764242 766600 766604 767058 767127 767279 769107 771322 771353 772406 773379 775208 778836 781565 788565 788833 791006 791190 791783 792986 793910 794897 796121 796134 796904 800372 800539 800796 801303 802053 811941 818175 819252 827038 827588 ] |
||||||||||||||||||||||||||||||
|
13.54 ms (7.95%) |
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 800796 737049 738241 769107 771322 771353 767058 750263 713895 791783 608545 719308 775208 778836 744090 766604 758192 762273 791190 391735 568477 564252 637234 6745 493581 683052 604263 796904 764242 740637 387874 189743 423497 819252 530496 546784 656607 661660 705348 665904 680431 717920 655149 714975 639293 639601 642659 788833 793910 796121 796134 724030 731025 773379 760892 731213 759474 772406 738121 761787 767127 767279 630399 639825 718714 811941 572331 554956 609899 766600 800372 761036 761776 791006 644059 801303 760983 736741 761698 745457 710736 432688 764183 426548 497443 567055 382281 619241 781565 792986 748825 481824 423516 485136 398869 802053 397188 671628 714033 589422 631356 800539 757762 761172 382579 827038 818175 788565 758906 728718 794897 397352 388888 827588 671247 714660 721453 660701 655289 657145 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.61%) |
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 6745 189743 382281 382579 387874 388888 391735 397188 397352 398869 423497 423516 426548 432688 481824 485136 493581 497443 530496 546784 554956 564252 567055 568477 572331 589422 604263 608545 609899 619241 630399 631356 637234 639293 639601 639825 642659 644059 655149 655289 656607 657145 660701 661660 665904 671247 671628 680431 683052 705348 710736 713895 714033 714660 714975 717920 718714 719308 721453 724030 728718 731025 731213 736741 737049 738121 738241 740637 744090 745457 748825 750263 757762 758192 758906 759474 760892 760983 761036 761172 761698 761776 761787 762273 764242 766600 766604 767058 767127 767279 769107 771322 771353 772406 773379 775208 778836 781565 788565 788833 791006 791190 791783 792986 793910 794897 796121 796134 796904 800372 800539 800796 801303 802053 811941 818175 819252 827038 827588 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal ass fucked"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал жоп fucked"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал жоп fucked"
]
|
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.