Query Metrics
7
Database Queries
7
Different statements
148.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.97 ms (84.37%) |
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 71071 197527 385437 453682 474506 479766 485910 517480 517490 519753 530614 533766 533786 533889 534686 536496 536535 537324 537506 537578 537698 538133 543724 543995 545875 545935 546468 546490 547133 548030 548045 548308 549503 550039 550543 552934 552970 553426 555624 557444 558157 559283 562519 565121 565236 566737 568173 570829 571763 574182 575279 576999 582902 583611 587961 601652 629799 632545 645921 651662 651956 663407 667289 668270 668563 670698 686088 701127 714602 716143 716520 719635 751243 753037 762705 783478 783492 783495 783498 783514 788948 794214 794275 814725 815575 817777 818176 818184 818606 818710 819811 820745 821569 822239 823302 823712 823756 823869 823935 823942 823989 824183 824570 824962 825063 825342 825886 825984 826060 826403 826581 826747 827063 827587 827697 828423 828748 828822 ] |
||||||||||||||||||||||||||||||
|
12.21 ms (8.25%) |
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 751243 71071 197527 537324 576999 601652 783514 783478 783498 762705 783492 453682 783495 385437 565121 794275 794214 714602 632545 788948 753037 479766 519753 517490 517480 571763 559283 555624 575279 587961 629799 818710 716520 822239 823989 825886 825984 826403 826581 826060 823712 814725 818184 818606 823935 823942 826747 827063 827697 815575 817777 818176 819811 820745 822900 823302 823756 823869 824183 824570 824962 821569 825063 825342 828423 828822 828748 827587 828527 485910 536496 536535 537698 538133 533766 533786 533889 537506 537578 534686 530614 474506 546490 548030 548045 552934 557444 568173 574182 543724 547133 548308 549503 550039 553426 562519 565236 570829 582902 583611 543995 545875 545935 546468 550543 552970 558157 566737 645921 651662 651956 663407 667289 668270 686088 701127 716143 719635 668563 670698 ] |
||||||||||||||||||||||||||||||
|
3.23 ms (2.18%) |
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 71071 197527 385437 453682 474506 479766 485910 517480 517490 519753 530614 533766 533786 533889 534686 536496 536535 537324 537506 537578 537698 538133 543724 543995 545875 545935 546468 546490 547133 548030 548045 548308 549503 550039 550543 552934 552970 553426 555624 557444 558157 559283 562519 565121 565236 566737 568173 570829 571763 574182 575279 576999 582902 583611 587961 601652 629799 632545 645921 651662 651956 663407 667289 668270 668563 670698 686088 701127 714602 716143 716520 719635 751243 753037 762705 783478 783492 783495 783498 783514 788948 794214 794275 814725 815575 817777 818176 818184 818606 818710 819811 820745 821569 822239 823302 823712 823756 823869 823935 823942 823989 824183 824570 824962 825063 825342 825886 825984 826060 826403 826581 826747 827063 827587 827697 828423 828748 828822 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"natural saggy tits"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"натуральная натуральные saggy сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"натуральная натуральные saggy сиськ"
]
|
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.