Query Metrics
7
Database Queries
7
Different statements
292.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
266.13 ms (90.94%) |
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 110884 117905 118201 195768 207918 383217 385107 387680 388341 390159 390163 391983 394590 394620 397656 401508 401769 401813 402596 417348 423652 424088 429957 440739 441092 442971 449144 459429 474879 477061 481903 487270 487276 487280 490625 496150 505599 506324 510746 510792 512078 512083 512087 512357 514758 517664 524802 527677 542141 545462 546158 546566 547803 548453 548525 550929 550938 552575 554857 556887 559789 566775 568529 574134 574138 576493 583297 604753 618283 619272 619296 627163 634026 634076 641791 644335 651960 651963 651987 656933 665972 668677 687305 697108 699556 709838 712496 713163 713167 718835 735145 735194 737019 740816 743982 744408 745931 747083 756771 756779 757494 760594 765897 792736 794228 794244 794256 795012 796332 796685 800284 800930 801606 805341 812332 812561 812562 818825 824245 827737 ] |
||||||||||||||||||||||||||||||
|
15.74 ms (5.38%) |
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 385107 390163 506324 517664 542141 583297 651960 713167 548453 619296 740816 812561 474879 552575 627163 390159 510792 514758 547803 487280 110884 713163 424088 441092 512087 117905 429957 550938 735194 391983 512083 644335 449144 554857 568529 651987 665972 812332 394620 512357 487270 524802 207918 394590 387680 401813 824245 827737 510746 545462 574134 546158 548525 566775 574138 712496 687305 604753 619272 795012 800284 801606 794244 796332 796685 805341 737019 794256 735145 744408 747083 757494 743982 745931 756771 756779 760594 765897 618283 697108 709838 718835 812562 417348 496150 442971 397656 487276 550929 546566 459429 477061 794228 388341 401508 401769 423652 490625 556887 576493 656933 559789 634026 634076 505599 527677 641791 402596 818825 699556 481903 651963 668677 792736 800930 440739 512078 383217 195768 118201 ] |
||||||||||||||||||||||||||||||
|
3.40 ms (1.16%) |
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 110884 117905 118201 195768 207918 383217 385107 387680 388341 390159 390163 391983 394590 394620 397656 401508 401769 401813 402596 417348 423652 424088 429957 440739 441092 442971 449144 459429 474879 477061 481903 487270 487276 487280 490625 496150 505599 506324 510746 510792 512078 512083 512087 512357 514758 517664 524802 527677 542141 545462 546158 546566 547803 548453 548525 550929 550938 552575 554857 556887 559789 566775 568529 574134 574138 576493 583297 604753 618283 619272 619296 627163 634026 634076 641791 644335 651960 651963 651987 656933 665972 668677 687305 697108 699556 709838 712496 713163 713167 718835 735145 735194 737019 740816 743982 744408 745931 747083 756771 756779 757494 760594 765897 792736 794228 794244 794256 795012 796332 796685 800284 800930 801606 805341 812332 812561 812562 818825 824245 827737 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife fisting"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (0.67%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.59%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен фистинг"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.50%) |
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.