Query Metrics
7
Database Queries
7
Different statements
379.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
349.42 ms (92.15%) |
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 382450 400460 402085 413703 414635 426680 429328 429555 447511 447521 456491 456686 461774 464598 464604 466125 471328 473710 475860 479353 479856 479955 541135 545711 552099 552632 552650 553591 553670 555882 556789 556840 558839 558843 559673 562326 564711 565420 573573 573663 573677 573688 573719 573766 573767 573777 573793 573834 573871 574490 574502 574503 574585 574800 574803 574805 574849 574867 575059 575063 575068 575093 575097 575103 575156 575206 575469 575490 575728 575735 575738 575751 575807 576063 576077 576107 576370 576371 576387 576410 576414 580661 597067 597195 597977 598466 598854 599542 599734 600387 601472 621745 626189 630544 636819 643041 653545 667810 669408 670306 679365 692636 693235 693502 696225 696226 717410 735920 766248 771821 771836 771837 776521 779591 800198 805039 805049 807527 809574 810984 ] |
||||||||||||||||||||||||||||||
|
17.91 ms (4.72%) |
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 576387 556789 556840 573688 573719 573766 573767 573793 574503 574805 574867 575059 575063 575068 575097 575156 576063 576077 576107 576370 576410 576414 541135 545711 552632 553670 558839 562326 564711 573573 573777 574800 574803 575093 575469 575728 575735 575738 575807 576371 693235 696226 653545 669408 679365 692636 693502 717410 667810 670306 696225 552099 552650 553591 555882 558843 559673 565420 573663 573677 573834 573871 574490 574502 574585 574849 575103 575206 575490 575751 580661 599734 601472 636819 597977 598854 600387 621745 626189 643041 597067 597195 598466 599542 630544 779591 800198 807527 776521 805039 805049 810984 735920 771836 771837 766248 771821 809574 382450 400460 402085 414635 429328 473710 475860 447511 456686 461774 466125 479353 479856 429555 447521 456491 464598 464604 471328 479955 413703 426680 ] |
||||||||||||||||||||||||||||||
|
4.11 ms (1.09%) |
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 382450 400460 402085 413703 414635 426680 429328 429555 447511 447521 456491 456686 461774 464598 464604 466125 471328 473710 475860 479353 479856 479955 541135 545711 552099 552632 552650 553591 553670 555882 556789 556840 558839 558843 559673 562326 564711 565420 573573 573663 573677 573688 573719 573766 573767 573777 573793 573834 573871 574490 574502 574503 574585 574800 574803 574805 574849 574867 575059 575063 575068 575093 575097 575103 575156 575206 575469 575490 575728 575735 575738 575751 575807 576063 576077 576107 576370 576371 576387 576410 576414 580661 597067 597195 597977 598466 598854 599542 599734 600387 601472 621745 626189 630544 636819 643041 653545 667810 669408 670306 679365 692636 693235 693502 696225 696226 717410 735920 766248 771821 771836 771837 776521 779591 800198 805039 805049 807527 809574 810984 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.53%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая porn"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая porn"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful porn"
]
|
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.