Query Metrics
7
Database Queries
7
Different statements
579.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
228.79 ms (39.46%) |
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 760453 800423 750755 728429 745424 748701 758963 735964 761555 727773 735935 741193 756073 758725 702629 702636 707308 715125 718666 718679 718687 552399 473959 410563 489488 523536 674522 590302 624177 591747 740617 461739 447115 468706 475032 531222 531296 535611 531217 535467 536571 536604 536632 537882 519440 532846 530750 533724 537927 545197 583953 545471 545475 590167 606152 607499 632674 636816 612182 733885 756409 733905 736101 741537 758189 461011 411805 718651 693356 722583 585726 602580 755334 759960 733852 737137 495124 720388 719002 694324 698859 596198 735968 739789 748327 726608 761174 673971 581384 733856 499843 708909 761040 530769 536230 476074 681666 453812 438283 448926 472248 503406 512973 540422 533062 571846 733907 469357 468524 509920 487189 503127 474745 480380 519553 487721 545712 672345 704241 722483 ] |
||||||||||||||||||||||||||||||
|
210.48 ms (36.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал кастинг член"
]
|
||||||||||||||||||||||||||||||
|
131.68 ms (22.71%) |
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 410563 411805 438283 447115 448926 453812 461011 461739 468524 468706 469357 472248 473959 474745 475032 476074 480380 487189 487721 489488 495124 499843 503127 503406 509920 512973 519440 519553 523536 530750 530769 531217 531222 531296 532846 533062 533724 535467 535611 536230 536571 536604 536632 537882 537927 540422 545197 545471 545475 545712 552399 571846 581384 583953 585726 590167 590302 591747 596198 602580 606152 607499 612182 624177 632674 636816 672345 673971 674522 681666 693356 694324 698859 702629 702636 704241 707308 708909 715125 718651 718666 718679 718687 719002 720388 722483 722583 726608 727773 728429 733852 733856 733885 733905 733907 735935 735964 735968 736101 737137 739789 740617 741193 741537 745424 748327 748701 750755 755334 756073 756409 758189 758725 758963 759960 760453 761040 761174 761555 800423 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (0.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 410563 411805 438283 447115 448926 453812 461011 461739 468524 468706 469357 472248 473959 474745 475032 476074 480380 487189 487721 489488 495124 499843 503127 503406 509920 512973 519440 519553 523536 530750 530769 531217 531222 531296 532846 533062 533724 535467 535611 536230 536571 536604 536632 537882 537927 540422 545197 545471 545475 545712 552399 571846 581384 583953 585726 590167 590302 591747 596198 602580 606152 607499 612182 624177 632674 636816 672345 673971 674522 681666 693356 694324 698859 702629 702636 704241 707308 708909 715125 718651 718666 718679 718687 719002 720388 722483 722583 726608 727773 728429 733852 733856 733885 733905 733907 735935 735964 735968 736101 737137 739789 740617 741193 741537 745424 748327 748701 750755 755334 756073 756409 758189 758725 758963 759960 760453 761040 761174 761555 800423 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal casting dick"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.