Query Metrics
7
Database Queries
7
Different statements
382.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.34 ms (54.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy hard"
]
|
||||||||||||||||||||||||||||||
|
150.13 ms (39.24%) |
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 401525 445603 459752 537653 543094 543250 548074 548760 551515 554447 559960 561725 572434 573087 579507 585214 595052 602789 603546 604945 605794 609939 614789 617631 623209 653264 654583 670770 672629 673339 675042 678817 679115 680616 681228 684528 689336 693680 694600 698822 698879 705230 708828 709615 710541 716986 718629 720094 720234 720455 720566 720987 722688 723588 728955 729230 732496 736285 742404 742540 746884 747270 748406 748832 750293 750729 764666 768382 770980 772439 773444 773884 779859 780084 780377 780518 780635 783853 786924 787646 787681 789806 791071 791795 794119 794482 794535 796218 796309 796701 796737 799550 799631 800524 801206 801859 810057 812437 812522 815848 817107 817527 818500 819687 820150 820198 824237 824443 824654 824700 824957 825473 825761 826850 827059 827264 827363 827962 828727 828835 ] |
||||||||||||||||||||||||||||||
|
13.79 ms (3.60%) |
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 791071 810057 559960 742404 827059 675042 653264 720987 573087 779859 812522 748832 787681 459752 750729 603546 824443 722688 720455 614789 812437 786924 789806 801206 750293 764666 710541 824237 825761 820198 827264 827363 818500 820150 825473 828727 548074 551515 572434 698879 705230 720566 673339 678817 689336 716986 585214 794535 796218 796701 783853 787646 794119 799631 728955 748406 729230 732496 747270 768382 742540 718629 791795 796737 401525 537653 605794 445603 815848 548760 561725 720234 680616 693680 617631 736285 770980 773444 746884 602789 623209 824654 824957 723588 817107 824700 826850 817527 819687 828835 827962 543250 579507 543094 554447 672629 679115 681228 654583 670770 684528 698822 708828 709615 694600 720094 595052 609939 604945 780377 780635 796309 799550 780084 780518 794482 800524 801859 772439 773884 ] |
||||||||||||||||||||||||||||||
|
4.01 ms (1.05%) |
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 401525 445603 459752 537653 543094 543250 548074 548760 551515 554447 559960 561725 572434 573087 579507 585214 595052 602789 603546 604945 605794 609939 614789 617631 623209 653264 654583 670770 672629 673339 675042 678817 679115 680616 681228 684528 689336 693680 694600 698822 698879 705230 708828 709615 710541 716986 718629 720094 720234 720455 720566 720987 722688 723588 728955 729230 732496 736285 742404 742540 746884 747270 748406 748832 750293 750729 764666 768382 770980 772439 773444 773884 779859 780084 780377 780518 780635 783853 786924 787646 787681 789806 791071 791795 794119 794482 794535 796218 796309 796701 796737 799550 799631 800524 801206 801859 810057 812437 812522 815848 817107 817527 818500 819687 820150 820198 824237 824443 824654 824700 824957 825473 825761 826850 827059 827264 827363 827962 828727 828835 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy hard"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy hard"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.