Query Metrics
7
Database Queries
7
Different statements
150.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.43 ms (77.40%) |
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 342206 384809 394608 404622 404787 404939 410267 413944 416772 418848 419517 420559 425263 426197 427966 427983 429799 429801 432243 447575 483548 484457 486759 509808 510270 511272 515833 521805 522160 524213 527198 530476 530491 530492 531087 531109 531116 531139 531157 531172 531173 531208 531230 531232 531259 531261 531854 532839 533942 534576 535027 535644 536339 536393 536453 536618 536628 536631 536645 536650 536651 537200 537763 537771 537885 537988 540267 540400 542524 543871 544797 544812 547470 547854 548454 550203 550798 554857 599847 599864 600029 600194 600249 600289 600290 600295 600415 601150 601517 603107 617410 628410 629333 633749 634185 634787 636985 639023 642000 649619 650175 656507 656916 662022 666872 666875 666881 676092 678127 678143 678161 679728 705794 715790 720138 752621 777052 781754 790366 813082 ] |
||||||||||||||||||||||||||||||
|
22.24 ms (14.79%) |
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 447575 419517 510270 515833 636985 536453 678143 600029 483548 532839 536645 531259 542524 600415 599847 600249 600289 705794 720138 531854 554857 548454 656916 550798 639023 781754 752621 603107 484457 527198 666875 394608 418848 540267 678127 601150 617410 633749 384809 420559 524213 547470 715790 628410 662022 534576 522160 547854 777052 656507 790366 813082 342206 404622 404939 410267 413944 432243 416772 426197 427966 427983 429799 425263 429801 536393 521805 530491 531157 531208 531230 531232 535027 536618 536651 537763 537771 537885 511272 536339 540400 530476 530492 531087 531109 531116 531139 531172 531173 531261 535644 536631 536650 509808 533942 536628 537200 537988 486759 543871 550203 544812 650175 666872 666881 678161 679728 649619 676092 544797 629333 634185 599864 634787 642000 600290 600194 600295 601517 404787 ] |
||||||||||||||||||||||||||||||
|
3.46 ms (2.30%) |
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 342206 384809 394608 404622 404787 404939 410267 413944 416772 418848 419517 420559 425263 426197 427966 427983 429799 429801 432243 447575 483548 484457 486759 509808 510270 511272 515833 521805 522160 524213 527198 530476 530491 530492 531087 531109 531116 531139 531157 531172 531173 531208 531230 531232 531259 531261 531854 532839 533942 534576 535027 535644 536339 536393 536453 536618 536628 536631 536645 536650 536651 537200 537763 537771 537885 537988 540267 540400 542524 543871 544797 544812 547470 547854 548454 550203 550798 554857 599847 599864 600029 600194 600249 600289 600290 600295 600415 601150 601517 603107 617410 628410 629333 633749 634185 634787 636985 639023 642000 649619 650175 656507 656916 662022 666872 666875 666881 676092 678127 678143 678161 679728 705794 715790 720138 752621 777052 781754 790366 813082 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"двойное проникновение жесткое"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (1.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"двойн проникновен хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.19%) |
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.