Query Metrics
7
Database Queries
7
Different statements
192.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.63 ms (87.21%) |
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 382207 382934 384271 385690 388795 391371 409016 420140 420299 421257 425786 429881 432884 440641 452363 453390 458504 459388 459472 460196 472606 475296 475636 479148 483522 483745 485661 487008 497792 499568 513010 523058 536524 550125 554405 562159 562536 564475 564480 569315 577692 578323 581130 587451 588811 589120 592681 594136 596792 598814 599239 599354 601071 602222 607683 607686 607692 607716 607755 608650 611280 617045 618799 626807 630254 637363 641807 642022 649372 660383 666160 666704 668628 672754 685526 691558 696584 700468 705349 705999 710847 710878 711624 714203 715420 716241 725742 733549 738292 743231 744805 744985 748431 758780 760485 768650 776148 780418 781792 782057 782093 782094 788753 797053 800657 804241 804432 806995 807590 807827 811125 812467 812480 813793 824531 824632 824633 824733 824837 827395 ] |
||||||||||||||||||||||||||||||
|
14.25 ms (7.41%) |
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 425786 459388 744805 780418 705349 760485 641807 811125 607692 536524 472606 523058 384271 812480 714203 598814 806995 758780 705999 710878 691558 607755 804241 601071 716241 637363 788753 800657 812467 483522 630254 685526 577692 596792 781792 459472 475636 672754 660383 807827 824531 432884 391371 440641 649372 420299 385690 666160 409016 738292 485661 782057 711624 562536 587451 607683 768650 550125 513010 382207 824632 827395 483745 479148 421257 710847 602222 776148 797053 743231 388795 813793 564480 696584 589120 499568 668628 611280 599239 554405 607686 608650 618799 569315 592681 807590 382934 824733 715420 588811 804432 733549 748431 562159 564475 700468 594136 782093 782094 824633 497792 626807 725742 452363 475296 487008 824837 642022 666704 599354 607716 581130 744985 578323 420140 617045 453390 429881 458504 460196 ] |
||||||||||||||||||||||||||||||
|
3.33 ms (1.73%) |
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 382207 382934 384271 385690 388795 391371 409016 420140 420299 421257 425786 429881 432884 440641 452363 453390 458504 459388 459472 460196 472606 475296 475636 479148 483522 483745 485661 487008 497792 499568 513010 523058 536524 550125 554405 562159 562536 564475 564480 569315 577692 578323 581130 587451 588811 589120 592681 594136 596792 598814 599239 599354 601071 602222 607683 607686 607692 607716 607755 608650 611280 617045 618799 626807 630254 637363 641807 642022 649372 660383 666160 666704 668628 672754 685526 691558 696584 700468 705349 705999 710847 710878 711624 714203 715420 716241 725742 733549 738292 743231 744805 744985 748431 758780 760485 768650 776148 780418 781792 782057 782093 782094 788753 797053 800657 804241 804432 806995 807590 807827 811125 812467 812480 813793 824531 824632 824633 824733 824837 827395 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy dildo solo"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая дилд соло"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.