Query Metrics
7
Database Queries
7
Different statements
158.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.90 ms (83.85%) |
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 154127 188462 386303 388532 410352 410690 416512 416733 440710 441051 445409 448369 457764 466633 478596 483731 502861 513842 527209 530428 533598 534546 538084 539875 545459 546129 555297 564120 568257 570297 575941 577058 582073 584619 587335 588466 591661 594136 594285 595078 599925 602627 615379 630793 630830 631981 632931 633435 636666 641837 649921 666988 678713 690666 693804 695803 696584 708145 713195 726068 730015 731204 738952 739161 739820 744021 744033 744598 745938 747313 750951 752602 752623 752645 752670 754902 758706 760558 762283 764096 765219 765388 765628 768659 769413 770515 777284 780041 780067 781006 783004 783927 784149 784771 786005 787095 788118 788589 788757 790154 790889 791077 791093 791445 796339 796644 796650 800189 801330 803494 803506 805701 807219 807251 809707 813899 817875 819488 825878 827290 ] |
||||||||||||||||||||||||||||||
|
15.38 ms (9.71%) |
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 410690 587335 388532 530428 538084 690666 708145 696584 575941 588466 594285 787095 809707 790889 801330 750951 788589 791077 730015 744021 739820 770515 630793 632931 783927 807251 595078 564120 819488 570297 666988 693804 546129 591661 636666 594136 780041 784149 788757 803506 796339 783004 796644 752623 765388 726068 760558 780067 803494 555297 440710 441051 827290 813899 457764 534546 539875 568257 545459 695803 602627 641837 630830 781006 796650 790154 731204 744033 769413 791093 791445 805701 758706 747313 744598 752645 752670 754902 615379 784771 786005 800189 533598 599925 633435 410352 416512 631981 445409 764096 739161 678713 386303 154127 416733 817875 825878 483731 466633 582073 713195 649921 577058 584619 777284 788118 807219 745938 765628 752602 188462 448369 513842 527209 502861 762283 738952 768659 765219 478596 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.82%) |
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 154127 188462 386303 388532 410352 410690 416512 416733 440710 441051 445409 448369 457764 466633 478596 483731 502861 513842 527209 530428 533598 534546 538084 539875 545459 546129 555297 564120 568257 570297 575941 577058 582073 584619 587335 588466 591661 594136 594285 595078 599925 602627 615379 630793 630830 631981 632931 633435 636666 641837 649921 666988 678713 690666 693804 695803 696584 708145 713195 726068 730015 731204 738952 739161 739820 744021 744033 744598 745938 747313 750951 752602 752623 752645 752670 754902 758706 760558 762283 764096 765219 765388 765628 768659 769413 770515 777284 780041 780067 781006 783004 783927 784149 784771 786005 787095 788118 788589 788757 790154 790889 791077 791093 791445 796339 796644 796650 800189 801330 803494 803506 805701 807219 807251 809707 813899 817875 819488 825878 827290 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"squirt riding"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сквирт оргазм riding"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сквирт оргазм riding"
]
|
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.