Query Metrics
7
Database Queries
7
Different statements
149.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.42 ms (84.56%) |
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 382363 383556 393424 399346 402081 407756 416870 442747 448068 487917 515234 526768 544484 562064 563857 565332 572727 579668 586585 591726 592582 594223 595511 599747 600204 611933 620983 624394 632022 663425 663442 665378 667013 669336 675370 675382 678783 682523 683745 684571 685767 694160 694447 694533 694585 695913 696309 698045 699650 703137 703142 706931 707265 708801 708803 710960 712723 715083 716076 716168 716244 717645 717681 717764 717814 718689 720583 720667 720776 720816 721368 721439 722099 722596 723675 724824 725165 725648 725676 726476 727400 727526 727748 730071 730381 732387 735564 735796 735821 735849 740536 741647 741649 742194 743127 743224 744572 745738 747604 748142 748235 748681 754141 755406 759581 760222 788194 788579 790369 793636 807551 809705 813343 813914 814073 821725 823493 823630 825822 827942 ] |
||||||||||||||||||||||||||||||
|
13.19 ms (8.82%) |
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 825822 383556 382363 399346 813914 814073 821725 823630 823493 827942 563857 572727 544484 663425 665378 675382 678783 683745 694585 696309 708803 716076 717814 720667 669336 675370 685767 694160 694533 695913 703142 717645 717764 721368 663442 682523 684571 694447 706931 708801 712723 716168 718689 720583 720816 721439 722099 722596 579668 600204 624394 586585 599747 788579 730381 735796 735849 743127 744572 747604 760222 790369 809705 724824 735564 748142 723675 727748 741647 745738 748681 725648 725676 735821 740536 725165 742194 743224 754141 759581 611933 698045 707265 710960 715083 717681 788194 793636 813343 402081 393424 720776 726476 407756 416870 442747 526768 562064 667013 716244 591726 620983 592582 594223 595511 727526 730071 741649 748235 727400 755406 732387 632022 699650 703137 807551 448068 487917 515234 565332 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (2.27%) |
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 382363 383556 393424 399346 402081 407756 416870 442747 448068 487917 515234 526768 544484 562064 563857 565332 572727 579668 586585 591726 592582 594223 595511 599747 600204 611933 620983 624394 632022 663425 663442 665378 667013 669336 675370 675382 678783 682523 683745 684571 685767 694160 694447 694533 694585 695913 696309 698045 699650 703137 703142 706931 707265 708801 708803 710960 712723 715083 716076 716168 716244 717645 717681 717764 717814 718689 720583 720667 720776 720816 721368 721439 722099 722596 723675 724824 725165 725648 725676 726476 727400 727526 727748 730071 730381 732387 735564 735796 735821 735849 740536 741647 741649 742194 743127 743224 744572 745738 747604 748142 748235 748681 754141 755406 759581 760222 788194 788579 790369 793636 807551 809705 813343 813914 814073 821725 823493 823630 825822 827942 ] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young big pussy"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young большие pussy"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young большие pussy"
]
|
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.