Query Metrics
7
Database Queries
7
Different statements
165.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.43 ms (82.49%) |
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 13229 391861 391980 392607 411344 423783 430374 434286 434358 434364 434367 434374 439156 439545 440824 440833 440876 444168 444527 461605 466294 467868 467872 467878 467882 467888 467905 468142 468363 474206 476033 478010 480680 493258 494231 502868 505281 505724 505771 508778 509659 510898 511057 511372 511520 513568 513670 514042 519362 530011 531524 533697 547757 547800 547808 547811 547979 549724 550216 552585 555133 555984 558073 560021 594788 594861 595438 600004 604662 605739 609085 631937 636295 650155 658797 659938 669884 669893 669907 683261 712546 718768 718788 725223 731813 734868 735974 736905 741699 742602 744427 744786 750699 750701 751572 751587 751600 764963 768049 774575 776940 778941 783312 792343 794364 794720 794773 795935 795956 802282 803396 803880 805151 806973 810132 810896 811296 816169 816170 824299 ] |
||||||||||||||||||||||||||||||
|
18.11 ms (10.95%) |
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 778941 751572 776940 505724 734868 434358 439156 513568 478010 731813 391861 712546 430374 461605 467888 502868 802282 810896 669893 468142 555133 631937 811296 467872 768049 511372 440876 750699 816169 816170 725223 434374 467882 444527 494231 13229 468363 605739 806973 718768 774575 519362 511520 493258 550216 440833 803880 423783 533697 750701 444168 810132 744427 751600 736905 751587 391980 467878 434364 434286 508778 794364 794773 795956 555984 474206 735974 513670 547757 560021 467905 480680 600004 547811 558073 744786 531524 510898 439545 434367 411344 683261 511057 669907 669884 792343 805151 783312 741699 547800 718788 594861 604662 594788 530011 476033 650155 595438 764963 509659 547979 659938 742602 636295 392607 549724 467868 514042 547808 505281 609085 658797 794720 795935 552585 466294 440824 824299 803396 505771 ] |
||||||||||||||||||||||||||||||
|
4.52 ms (2.73%) |
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 13229 391861 391980 392607 411344 423783 430374 434286 434358 434364 434367 434374 439156 439545 440824 440833 440876 444168 444527 461605 466294 467868 467872 467878 467882 467888 467905 468142 468363 474206 476033 478010 480680 493258 494231 502868 505281 505724 505771 508778 509659 510898 511057 511372 511520 513568 513670 514042 519362 530011 531524 533697 547757 547800 547808 547811 547979 549724 550216 552585 555133 555984 558073 560021 594788 594861 595438 600004 604662 605739 609085 631937 636295 650155 658797 659938 669884 669893 669907 683261 712546 718768 718788 725223 731813 734868 735974 736905 741699 742602 744427 744786 750699 750701 751572 751587 751600 764963 768049 774575 776940 778941 783312 792343 794364 794720 794773 795935 795956 802282 803396 803880 805151 806973 810132 810896 811296 816169 816170 824299 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русские зрелые оргазмы"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск зрелая женщин оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.22 ms (0.74%) |
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.