Query Metrics
7
Database Queries
7
Different statements
155.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.06 ms (79.32%) |
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 382934 400942 406128 434131 443804 461944 470024 472706 481927 486247 487941 490636 492296 493083 494259 494598 519626 522171 529376 531746 536333 536524 537124 538935 542457 544871 544899 546431 550909 554846 555399 555763 557352 562529 565913 569306 573743 579376 580503 585319 587021 587465 587941 589686 591572 591836 594561 598267 599742 604918 604966 617563 618329 618494 619429 628559 632683 636610 638398 645518 649372 656546 664649 670385 673573 693767 699915 700965 706031 707452 710234 712628 713189 713332 714122 714126 714365 714443 714622 718809 725448 728503 730795 733387 736092 738468 742760 751706 755345 755908 761061 770022 771610 776467 782404 782481 786658 788631 788646 794097 796811 798759 798762 801221 801523 803824 806705 807405 809548 810086 810635 813296 813963 815174 816815 819431 824530 824733 826499 826506 ] |
||||||||||||||||||||||||||||||
|
16.21 ms (10.45%) |
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 714443 599742 604918 803824 755345 713332 522171 490636 493083 494598 472706 461944 529376 400942 406128 486247 481927 544871 579376 700965 569306 628559 809548 725448 810086 742760 782404 810635 443804 470024 382934 434131 813963 815174 826499 826506 824530 816815 819431 824733 492296 537124 531746 536524 538935 494259 519626 536333 487941 555399 562529 542457 544899 546431 565913 573743 550909 554846 555763 673573 649372 664649 670385 714126 645518 656546 693767 707452 710234 712628 718809 557352 580503 585319 589686 591836 617563 619429 632683 636610 587941 591572 594561 618329 587465 598267 587021 618494 776467 786658 788631 788646 798762 798759 801523 807405 813296 733387 751706 755908 770022 782481 796811 801221 730795 728503 738468 736092 761061 771610 604966 638398 699915 706031 713189 714122 714365 714622 794097 806705 ] |
||||||||||||||||||||||||||||||
|
8.14 ms (5.25%) |
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 382934 400942 406128 434131 443804 461944 470024 472706 481927 486247 487941 490636 492296 493083 494259 494598 519626 522171 529376 531746 536333 536524 537124 538935 542457 544871 544899 546431 550909 554846 555399 555763 557352 562529 565913 569306 573743 579376 580503 585319 587021 587465 587941 589686 591572 591836 594561 598267 599742 604918 604966 617563 618329 618494 619429 628559 632683 636610 638398 645518 649372 656546 664649 670385 673573 693767 699915 700965 706031 707452 710234 712628 713189 713332 714122 714126 714365 714443 714622 718809 725448 728503 730795 733387 736092 738468 742760 751706 755345 755908 761061 770022 771610 776467 782404 782481 786658 788631 788646 794097 796811 798759 798762 801221 801523 803824 806705 807405 809548 810086 810635 813296 813963 815174 816815 819431 824530 824733 826499 826506 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy milf masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая milf мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая milf мастурбац"
]
|
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.