Query Metrics
7
Database Queries
7
Different statements
217.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
189.82 ms (87.45%) |
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 431002 446447 453154 468209 505385 507330 514242 517763 527474 531728 536150 537786 540204 540858 541918 542763 545157 550544 550812 553218 553222 555619 559421 561062 561770 561783 567496 572986 575629 576584 578196 579559 584400 584418 584866 586935 615297 619230 621051 628055 628442 628468 634363 636463 636957 641503 652779 661590 665626 668703 671170 680308 697305 700468 700682 703735 704218 706900 708639 710009 712098 721257 728036 736056 738513 739123 740554 741224 743148 748268 750656 751094 753643 753650 753658 753785 753994 754400 754529 758030 758586 760570 766432 768458 768640 769082 770099 772632 773048 778049 782070 783280 783388 783837 784122 785099 785949 786859 787074 790112 790478 790689 791038 796362 802915 803039 803878 804424 806675 807205 811097 812333 812466 816825 819409 819684 820066 826669 827242 ] |
||||||||||||||||||||||||||||||
|
17.72 ms (8.17%) |
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 567496 575629 576584 584866 680308 665626 703735 615297 628055 641503 790112 786859 753994 760570 770099 796362 803878 806675 807205 753650 753658 766432 738513 741224 743148 754400 740554 748268 753643 754529 708639 783388 790478 791038 812466 820066 784122 768640 431002 507330 584418 652779 790689 772632 751094 704218 803039 446447 453154 505385 514242 527474 578196 579559 661590 668703 700468 700682 636463 619230 621051 811097 758030 753785 782070 468209 517763 816825 540858 819684 827242 819409 821958 826669 536150 537786 540204 531728 545157 572986 541918 550544 542763 553218 559421 710009 721257 697305 671170 706900 712098 550812 553222 555619 561062 561770 561783 584400 628468 634363 636957 586935 628442 783280 787074 802915 804424 778049 785949 736056 750656 758586 768458 769082 773048 783837 785099 812333 728036 739123 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.25%) |
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 431002 446447 453154 468209 505385 507330 514242 517763 527474 531728 536150 537786 540204 540858 541918 542763 545157 550544 550812 553218 553222 555619 559421 561062 561770 561783 567496 572986 575629 576584 578196 579559 584400 584418 584866 586935 615297 619230 621051 628055 628442 628468 634363 636463 636957 641503 652779 661590 665626 668703 671170 680308 697305 700468 700682 703735 704218 706900 708639 710009 712098 721257 728036 736056 738513 739123 740554 741224 743148 748268 750656 751094 753643 753650 753658 753785 753994 754400 754529 758030 758586 760570 766432 768458 768640 769082 770099 772632 773048 778049 782070 783280 783388 783837 784122 785099 785949 786859 787074 790112 790478 790689 791038 796362 802915 803039 803878 804424 806675 807205 811097 812333 812466 816825 819409 819684 820066 826669 827242 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy solo"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy соло"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy соло"
]
|
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.