Query Metrics
7
Database Queries
7
Different statements
161.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.18 ms (87.42%) |
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 384504 387515 396687 415372 445285 446301 455094 461458 461544 462960 464161 464293 464872 468020 472657 472763 475108 477570 477574 494847 501809 502551 504444 509399 511038 511719 524716 531149 531600 532544 533034 535570 536809 543085 543110 605960 617095 625960 627335 630222 634542 640503 642115 689335 697352 701007 704701 711853 716403 719964 726123 727689 727798 727824 728994 730030 731031 731693 731774 732041 734052 734472 735252 735594 736401 736962 739451 739604 740003 740058 740585 741306 741418 743750 744604 744728 744951 744977 745181 745451 745626 747387 747636 747711 750043 751672 753651 753902 754036 754356 755780 756835 758183 758665 759223 759812 760586 760919 761180 762109 763101 763442 769774 770605 776265 778350 778814 779140 784276 785772 794843 796436 799756 802033 810709 810922 811338 813537 820469 822674 ] |
||||||||||||||||||||||||||||||
|
10.69 ms (6.62%) |
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 799756 802033 778350 779140 785772 794843 813537 731031 732041 734472 736401 740003 740058 811338 727798 741306 741418 744728 745626 751672 754356 762109 739451 745181 745451 750043 754036 755780 758665 759812 760919 763442 727689 730030 735594 739604 743750 747387 747711 753651 770605 726123 727824 734052 736962 744604 744977 747636 758183 759223 761180 769774 617095 627335 630222 634542 640503 642115 701007 711853 778814 784276 810922 446301 477570 462960 472763 396687 455094 461544 464161 461458 501809 502551 731774 740585 605960 625960 468020 472657 776265 796436 820469 822674 475108 535570 509399 511038 531149 533034 536809 504444 531600 532544 543110 543085 689335 716403 756835 763101 731693 728994 735252 744951 753902 760586 697352 719964 810709 415372 445285 477574 464872 464293 494847 511719 524716 387515 704701 384504 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (1.98%) |
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 384504 387515 396687 415372 445285 446301 455094 461458 461544 462960 464161 464293 464872 468020 472657 472763 475108 477570 477574 494847 501809 502551 504444 509399 511038 511719 524716 531149 531600 532544 533034 535570 536809 543085 543110 605960 617095 625960 627335 630222 634542 640503 642115 689335 697352 701007 704701 711853 716403 719964 726123 727689 727798 727824 728994 730030 731031 731693 731774 732041 734052 734472 735252 735594 736401 736962 739451 739604 740003 740058 740585 741306 741418 743750 744604 744728 744951 744977 745181 745451 745626 747387 747636 747711 750043 751672 753651 753902 754036 754356 755780 756835 758183 758665 759223 759812 760586 760919 761180 762109 763101 763442 769774 770605 776265 778350 778814 779140 784276 785772 794843 796436 799756 802033 810709 810922 811338 813537 820469 822674 ] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие маленькая"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big and small"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.92%) |
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.