Query Metrics
7
Database Queries
7
Different statements
161.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.21 ms (82.53%) |
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 407314 428686 458803 464924 465133 473621 496321 501104 502762 508450 510718 516836 517696 520207 529179 530554 537393 537820 550062 551033 554525 556582 556995 557005 560493 568992 569192 571095 572243 572951 577623 578792 584788 596964 599584 599597 605476 608105 613390 615020 618769 618821 621967 622887 623460 624143 624218 624819 631284 634253 636419 637869 638542 639328 643920 662147 665359 667151 667472 667879 668548 669206 674259 689514 696189 696493 698647 698819 699161 699824 700798 701160 701844 704447 706351 706620 708137 708157 709556 711354 711803 712083 712971 714571 716172 716915 718572 718600 723908 736480 736514 740484 744081 744638 745072 748330 749933 751242 751656 754132 754184 760297 762366 765893 768040 771074 774349 776491 777327 788318 789054 789068 804527 809333 809798 812652 813548 818117 ] |
||||||||||||||||||||||||||||||
|
15.54 ms (9.63%) |
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 550062 551033 572951 577623 557005 560493 696189 706351 706620 667472 704447 718572 689514 708137 712971 572243 631284 637869 624143 599597 608105 596964 618769 634253 636419 788318 809333 736480 748330 751242 754184 760297 740484 744081 751656 762366 765893 754132 771074 744638 768040 699161 723107 508450 428686 502762 776491 407314 464924 537820 501104 520207 496321 516836 530554 537393 719429 674259 569192 618821 638542 643920 605476 723908 736514 749933 777327 473621 809798 465133 517696 510718 668548 665359 699824 613390 599584 701844 813548 818117 556582 568992 554525 578792 669206 789054 789068 745072 774349 615020 623460 714571 458803 696493 804527 667879 624218 812652 529179 584788 667151 701160 708157 712083 662147 698819 700798 709556 711354 716915 698647 711803 716172 718600 556995 571095 621967 624819 639328 622887 ] |
||||||||||||||||||||||||||||||
|
4.61 ms (2.86%) |
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 407314 428686 458803 464924 465133 473621 496321 501104 502762 508450 510718 516836 517696 520207 529179 530554 537393 537820 550062 551033 554525 556582 556995 557005 560493 568992 569192 571095 572243 572951 577623 578792 584788 596964 599584 599597 605476 608105 613390 615020 618769 618821 621967 622887 623460 624143 624218 624819 631284 634253 636419 637869 638542 639328 643920 662147 665359 667151 667472 667879 668548 669206 674259 689514 696189 696493 698647 698819 699161 699824 700798 701160 701844 704447 706351 706620 708137 708157 709556 711354 711803 712083 712971 714571 716172 716915 718572 718600 723908 736480 736514 740484 744081 744638 745072 748330 749933 751242 751656 754132 754184 760297 762366 765893 768040 771074 774349 776491 777327 788318 789054 789068 804527 809333 809798 812652 813548 818117 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"caught big cock"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"caught большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"caught большие cock"
]
|
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.