Query Metrics
7
Database Queries
7
Different statements
187.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.87 ms (85.85%) |
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 174791 191336 381999 388453 400678 410312 453214 457639 458766 465777 474456 487640 491225 492426 492438 492441 506944 507123 509176 514047 514711 517795 525480 528706 537384 538696 538743 538770 539597 551689 554953 556593 560155 561494 562016 562717 564371 574026 584719 586355 589457 589746 593384 596086 597857 598768 599473 601095 601153 601180 601247 604988 609376 610223 615896 617065 618020 619480 619674 619902 620344 620825 621488 626369 631985 632153 640996 642962 651066 663858 665393 667617 678924 680543 687616 694579 699264 702094 703950 710466 712418 714228 714590 719031 732051 732124 738297 738852 740131 742555 743297 754626 756256 770173 774740 781831 781957 783507 789105 790607 793535 794471 798457 798845 804631 805730 807012 807854 808514 811267 816716 823690 824277 824634 828158 828487 828601 828715 828746 ] |
||||||||||||||||||||||||||||||
|
15.22 ms (8.12%) |
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 458766 453214 492438 517795 824277 828158 828746 828487 828715 381999 507123 564371 714228 790607 793535 514711 560155 525480 514047 584719 556593 593384 597857 619480 601180 465777 823690 828601 388453 174791 191336 400678 410312 816716 824634 492426 492441 457639 491225 474456 487640 506944 509176 538743 539597 537384 538770 528706 538696 551689 562016 562717 574026 687616 702094 703950 712418 663858 667617 699264 651066 665393 678924 680543 694579 710466 719031 554953 561494 599473 601095 604988 619674 601247 610223 615896 620344 620825 626369 632153 586355 589746 598768 604910 618020 619902 621488 589457 596086 601153 642962 781957 798845 804631 807012 811267 774740 789105 798457 808514 743297 783507 794471 805730 807854 732051 754626 732124 738297 756256 770173 738852 740131 742555 609376 617065 631985 640996 714590 781831 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (1.70%) |
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 174791 191336 381999 388453 400678 410312 453214 457639 458766 465777 474456 487640 491225 492426 492438 492441 506944 507123 509176 514047 514711 517795 525480 528706 537384 538696 538743 538770 539597 551689 554953 556593 560155 561494 562016 562717 564371 574026 584719 586355 589457 589746 593384 596086 597857 598768 599473 601095 601153 601180 601247 604988 609376 610223 615896 617065 618020 619480 619674 619902 620344 620825 621488 626369 631985 632153 640996 642962 651066 663858 665393 667617 678924 680543 687616 694579 699264 702094 703950 710466 712418 714228 714590 719031 732051 732124 738297 738852 740131 742555 743297 754626 756256 770173 774740 781831 781957 783507 789105 790607 793535 794471 798457 798845 804631 805730 807012 807854 808514 811267 816716 823690 824277 824634 828158 828487 828601 828715 828746 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"natural boobs порно"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"натуральная натуральные boobs порн"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"натуральная натуральные boobs порн"
]
|
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.