Query Metrics
7
Database Queries
7
Different statements
192.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.73 ms (86.65%) |
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 34353 73052 256218 404006 443171 443419 444915 453394 457999 460009 460016 460167 460196 463824 464972 466911 484241 490681 494495 496514 499365 506904 510950 510956 512440 513531 513627 513972 515354 516718 517398 517816 524657 529323 529351 529648 529988 532448 533694 547478 549659 557486 563107 566788 570935 574977 583232 586073 587781 592228 592723 592870 593057 595072 601795 602261 603310 603396 604426 604823 604936 607583 613032 614835 614844 639071 641946 643084 643542 645939 651216 657768 657782 665958 666139 668701 680819 681237 704907 705424 713247 713501 728469 728586 733549 733582 738481 742298 742386 742417 752495 752617 752767 757226 760649 766415 770123 776883 781849 782806 785972 792543 796843 799049 799696 800307 800599 803019 803024 804234 805364 810086 812367 812552 812564 812756 813815 819649 824303 827723 ] |
||||||||||||||||||||||||||||||
|
15.59 ms (8.10%) |
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 463824 529323 566788 705424 444915 533694 752495 457999 460196 494495 496514 510956 460167 570935 563107 681237 657782 587781 592870 812367 460009 524657 490681 680819 516718 73052 34353 443419 819649 827723 824303 813815 529648 532448 583232 574977 666139 713247 651216 665958 713501 549659 586073 601795 592723 595072 602261 613032 614835 593057 603396 799696 803019 805364 812552 776883 792543 800599 728586 803024 810086 812756 742386 757226 733549 738481 742298 752617 614844 641946 404006 517398 604936 512440 645939 603310 607583 506904 466911 464972 668701 604823 639071 592228 643084 643542 782806 785972 799049 800307 804234 796843 812564 733582 766415 742417 770123 728469 752767 704907 781849 256218 484241 513531 510950 513972 513627 517816 557486 529988 657768 499365 443171 515354 760649 604426 453394 529351 460016 547478 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (1.58%) |
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 34353 73052 256218 404006 443171 443419 444915 453394 457999 460009 460016 460167 460196 463824 464972 466911 484241 490681 494495 496514 499365 506904 510950 510956 512440 513531 513627 513972 515354 516718 517398 517816 524657 529323 529351 529648 529988 532448 533694 547478 549659 557486 563107 566788 570935 574977 583232 586073 587781 592228 592723 592870 593057 595072 601795 602261 603310 603396 604426 604823 604936 607583 613032 614835 614844 639071 641946 643084 643542 645939 651216 657768 657782 665958 666139 668701 680819 681237 704907 705424 713247 713501 728469 728586 733549 733582 738481 742298 742386 742417 752495 752617 752767 757226 760649 766415 770123 776883 781849 782806 785972 792543 796843 799049 799696 800307 800599 803019 803024 804234 805364 810086 812367 812552 812564 812756 813815 819649 824303 827723 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature panties solo"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature трусик нижн бел соло"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature трусик нижн бел соло"
]
|
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.