Query Metrics
7
Database Queries
7
Different statements
185.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.01 ms (87.18%) |
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 3671 388773 397080 398385 420370 425540 440801 444156 459636 464234 477418 477538 478508 478549 522510 531564 536421 540680 542264 543668 543768 560933 560968 564607 590775 592548 596796 604981 612927 624209 625765 627332 632094 639355 640312 655241 656291 656521 663738 666378 670720 671889 678868 680259 680290 686721 695380 699415 707160 725009 725556 726219 727732 727736 729153 731095 731228 731274 731363 732810 734332 734471 736099 736231 738718 740871 740878 742728 742748 743829 750135 759895 759927 762104 762287 762288 762774 762792 764850 764963 765227 765497 765634 767701 768328 768761 768764 769035 773312 773424 774076 775228 776999 785051 785196 788544 791415 791607 791853 792946 794385 794915 795319 800276 800489 808101 810045 810407 813422 813944 814333 814387 819425 826155 826731 827220 827492 827721 828165 ] |
||||||||||||||||||||||||||||||
|
13.46 ms (7.24%) |
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 800489 813422 767701 808101 625765 800276 459636 420370 814387 814333 477418 536421 464234 656521 596796 775228 740871 727732 732810 727736 743829 742728 736099 788544 795319 478549 444156 522510 639355 813944 791415 794385 725556 731228 731274 762792 774076 785196 792946 810045 726219 731095 762288 768328 768764 729153 734471 759927 762104 765497 768761 773424 740878 742748 765634 769035 731363 738718 750135 810407 762774 680290 764850 776999 671889 791853 765227 612927 477538 543668 686721 819425 734332 725009 826731 828165 762287 531564 543768 680259 695380 707160 624209 590775 627332 632094 699415 564607 425540 826155 827220 827492 827721 773312 736231 764963 791607 655241 663738 794915 640312 560968 604981 678868 398385 397080 540680 542264 592548 478508 388773 765427 670720 666378 656291 560933 785051 3671 440801 759895 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.53%) |
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 3671 388773 397080 398385 420370 425540 440801 444156 459636 464234 477418 477538 478508 478549 522510 531564 536421 540680 542264 543668 543768 560933 560968 564607 590775 592548 596796 604981 612927 624209 625765 627332 632094 639355 640312 655241 656291 656521 663738 666378 670720 671889 678868 680259 680290 686721 695380 699415 707160 725009 725556 726219 727732 727736 729153 731095 731228 731274 731363 732810 734332 734471 736099 736231 738718 740871 740878 742728 742748 743829 750135 759895 759927 762104 762287 762288 762774 762792 764850 764963 765227 765497 765634 767701 768328 768761 768764 769035 773312 773424 774076 775228 776999 785051 785196 788544 791415 791607 791853 792946 794385 794915 795319 800276 800489 808101 810045 810407 813422 813944 814333 814387 819425 826155 826731 827220 827492 827721 828165 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade milf anal"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск milf анал"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.