Query Metrics
7
Database Queries
7
Different statements
193.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.46 ms (86.85%) |
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 181569 182110 382325 403376 468505 471072 486778 495861 509659 530129 531794 532179 532458 533255 535322 536324 536467 536521 540563 543679 546836 547979 548448 553221 555227 555364 558102 563086 563970 568263 568269 568289 589705 591626 592578 592872 593039 593065 593398 596513 599765 599814 602585 605173 615950 626889 631461 632094 636955 641337 643447 660397 672919 681227 700900 701235 704911 708530 708541 709416 710573 713117 713500 715472 720464 722294 725420 728466 733419 733425 736740 740450 744173 744188 744192 744217 744688 744980 749019 749023 749050 753663 759806 770238 781794 781926 785817 785831 785901 787329 787341 790630 790825 794215 794706 797146 799047 799171 799644 802541 803487 803490 803507 803508 804456 807222 811112 811604 811912 813605 817172 817575 817590 819227 819418 819630 825426 826973 827100 827181 ] |
||||||||||||||||||||||||||||||
|
15.76 ms (8.13%) |
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 813605 819227 825426 826973 827100 827181 817575 817590 819418 817172 819630 486778 468505 530129 536521 531794 533255 536324 536467 532458 509659 540563 546836 563970 568263 543679 547979 548448 553221 555227 558102 563086 568289 660397 708530 715472 681227 704911 672919 700900 713500 722294 555364 568269 589705 599765 602585 615950 636955 643447 593398 599814 592872 605173 641337 592578 593039 593065 596513 626889 631461 781926 785817 785831 785901 787329 797146 803487 790825 794215 794706 799644 802541 803490 803507 725420 733419 744173 749023 770238 787341 804456 811112 728466 740450 744188 736740 744980 749019 749050 753663 744192 744217 744688 733425 759806 632094 701235 708541 710573 720464 781794 803508 807222 811604 471072 181569 182110 382325 403376 495861 532179 535322 709416 713117 591626 811912 790630 799171 799047 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.45%) |
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 181569 182110 382325 403376 468505 471072 486778 495861 509659 530129 531794 532179 532458 533255 535322 536324 536467 536521 540563 543679 546836 547979 548448 553221 555227 555364 558102 563086 563970 568263 568269 568289 589705 591626 592578 592872 593039 593065 593398 596513 599765 599814 602585 605173 615950 626889 631461 632094 636955 641337 643447 660397 672919 681227 700900 701235 704911 708530 708541 709416 710573 713117 713500 715472 720464 722294 725420 728466 733419 733425 736740 740450 744173 744188 744192 744217 744688 744980 749019 749023 749050 753663 759806 770238 781794 781926 785817 785831 785901 787329 787341 790630 790825 794215 794706 797146 799047 799171 799644 802541 803487 803490 803507 803508 804456 807222 811112 811604 811912 813605 817172 817575 817590 819227 819418 819630 825426 826973 827100 827181 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo mature masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло mature мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло mature мастурбац"
]
|
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.