Query Metrics
7
Database Queries
7
Different statements
173.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.42 ms (86.91%) |
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 392034 400671 420315 423348 426277 426465 426739 432374 440914 444651 452854 453972 454049 455553 464517 479347 479608 481442 486614 486908 488491 490607 495768 508222 527477 538677 542155 555561 557922 566922 568568 574012 588881 590324 593834 600728 609783 614502 615274 618104 619009 619360 631569 631871 641506 662113 672873 675410 675604 676724 700718 705054 707400 707605 709760 712258 712526 712803 714600 719353 719912 721721 722124 725140 725440 725456 731028 731229 734109 739847 740540 741185 742530 742778 744067 744238 745679 746669 747333 747994 748129 751447 753764 754303 755464 758904 759758 761305 761325 761345 764200 769467 769503 773794 777862 778036 780318 782430 783954 784186 787925 788796 791218 792319 793540 794408 795909 796448 797067 798469 800608 802067 804309 807339 815975 823945 826206 827929 828644 828769 ] |
||||||||||||||||||||||||||||||
|
12.98 ms (7.50%) |
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 740540 747994 734109 755464 590324 440914 746669 479608 538677 557922 675410 712526 722124 615274 800608 807339 761325 791218 609783 400671 444651 479347 486614 568568 676724 707400 707605 709760 712803 672873 700718 555561 600728 641506 618104 619009 631871 784186 797067 798469 741185 758904 795909 804309 731028 748129 725140 725456 731229 742530 764200 769503 742778 759758 773794 725440 739847 753764 719353 719912 721721 792319 426739 464517 420315 486908 527477 566922 488491 490607 495768 614502 452854 662113 423348 508222 432374 823945 574012 783954 793540 796448 454049 455553 828769 769467 754303 826206 815975 827929 828644 712258 714600 675604 705054 619360 593834 777862 780318 794408 778036 787925 744238 782430 745679 761305 744067 747333 751447 761345 788796 392034 453972 426465 481442 542155 631569 588881 802067 426277 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.77%) |
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 392034 400671 420315 423348 426277 426465 426739 432374 440914 444651 452854 453972 454049 455553 464517 479347 479608 481442 486614 486908 488491 490607 495768 508222 527477 538677 542155 555561 557922 566922 568568 574012 588881 590324 593834 600728 609783 614502 615274 618104 619009 619360 631569 631871 641506 662113 672873 675410 675604 676724 700718 705054 707400 707605 709760 712258 712526 712803 714600 719353 719912 721721 722124 725140 725440 725456 731028 731229 734109 739847 740540 741185 742530 742778 744067 744238 745679 746669 747333 747994 748129 751447 753764 754303 755464 758904 759758 761305 761325 761345 764200 769467 769503 773794 777862 778036 780318 782430 783954 784186 787925 788796 791218 792319 793540 794408 795909 796448 797067 798469 800608 802067 804309 807339 815975 823945 826206 827929 828644 828769 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum to panties"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum трусик нижн бел"
]
|
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.