Query Metrics
7
Database Queries
7
Different statements
170.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.26 ms (84.96%) |
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 2808 233498 233500 366284 389749 391966 392077 397388 401575 417293 424099 424146 426707 443436 443889 443898 443950 444236 448412 451517 461974 464775 469696 470637 477970 479422 485862 487246 495308 498171 506486 513811 533779 534046 534084 534393 535604 538239 543533 543655 543682 543714 543734 547983 549610 552816 561250 563599 565003 567240 571460 575667 576244 578348 590452 600098 601606 608108 608529 608814 612574 617654 637454 644014 661534 661554 667186 672881 683305 685381 687940 695788 701888 702277 703948 711149 712948 717654 729345 731652 731669 732131 732171 733644 736675 740632 742405 743634 747429 749769 758182 761607 764173 764176 765877 766162 767972 769136 769196 774653 776121 779255 783658 786094 788032 788381 793063 793195 794073 794128 802893 803231 803235 804863 804888 804904 809645 809958 ] |
||||||||||||||||||||||||||||||
|
15.44 ms (9.03%) |
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 543734 547983 571460 576244 578348 672881 683305 685381 701888 561250 567240 644014 600098 608108 608529 601606 590452 608814 637454 731652 809645 761607 764173 443889 534084 444236 498171 565003 575667 563599 702277 711149 687940 612574 794128 391966 233498 803231 803235 552816 424099 451517 448412 485862 729345 732131 534393 443898 487246 774653 788032 479422 743634 513811 543655 661554 694097 712948 506486 749769 426707 392077 534046 538239 549610 543682 783658 731669 769136 769196 802893 804888 809958 740632 766162 767972 732171 717654 786094 788381 793063 804904 389749 397388 469696 617654 736675 401575 464775 533779 535604 477970 543714 661534 695788 779255 764176 794073 747429 758182 793195 443436 2808 417293 495308 776121 804863 765877 366284 233500 461974 667186 424146 470637 703948 779905 742405 443950 543533 733644 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (1.88%) |
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 2808 233498 233500 366284 389749 391966 392077 397388 401575 417293 424099 424146 426707 443436 443889 443898 443950 444236 448412 451517 461974 464775 469696 470637 477970 479422 485862 487246 495308 498171 506486 513811 533779 534046 534084 534393 535604 538239 543533 543655 543682 543714 543734 547983 549610 552816 561250 563599 565003 567240 571460 575667 576244 578348 590452 600098 601606 608108 608529 608814 612574 617654 637454 644014 661534 661554 667186 672881 683305 685381 687940 695788 701888 702277 703948 711149 712948 717654 729345 731652 731669 732131 732171 733644 736675 740632 742405 743634 747429 749769 758182 761607 764173 764176 765877 766162 767972 769136 769196 774653 776121 779255 783658 786094 788032 788381 793063 793195 794073 794128 802893 803231 803235 804863 804888 804904 809645 809958 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русское домашнее с же%…"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.86%) |
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.