Query Metrics
7
Database Queries
7
Different statements
177.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.54 ms (86.60%) |
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 384491 385947 386740 388133 390278 391915 391950 408685 411374 420866 435355 446792 451502 453170 454516 457063 457656 466984 467099 468290 468504 468506 470195 470994 471013 471015 471020 471026 471057 473025 474475 475640 479351 490232 490599 493744 495286 496144 506092 509762 510923 522702 527333 531381 531737 537158 537949 544527 553436 555191 555547 557468 558314 559418 559421 560409 564230 576824 576880 581392 583651 588930 589123 589351 589942 591161 601824 607213 607692 608670 610209 611260 618475 619694 622195 628692 630453 637245 637902 640108 640997 642786 658140 665822 666055 666684 669291 673534 685527 699537 702914 705999 706679 714319 714493 723950 735912 745257 750632 768713 776464 790275 795334 797070 801532 801764 804264 817199 820365 823572 823774 824533 824633 825959 826203 826825 826826 826995 827293 828464 ] |
||||||||||||||||||||||||||||||
|
13.15 ms (7.41%) |
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 471015 576880 454516 607213 776464 673534 702914 706679 666684 611260 640108 388133 474475 471026 473025 544527 467099 411374 823572 828464 537158 801532 790275 557468 558314 591161 637245 555191 699537 658140 619694 642786 618475 622195 826995 589123 750632 637902 390278 826203 826826 827293 531737 797070 723950 553436 804264 669291 496144 560409 457063 823774 583651 559421 559418 795334 385947 490232 446792 453170 457656 468506 493744 537949 527333 495286 531381 468504 471057 714319 666055 685527 714493 564230 588930 610209 801764 745257 735912 608670 705999 466984 408685 479351 509762 490599 601824 384491 386740 391915 420866 817199 824533 824633 470994 468290 576824 471013 391950 555547 589351 630453 581392 640997 768713 510923 607692 522702 665822 589942 628692 435355 471020 470195 475640 451502 506092 820365 825959 826825 ] |
||||||||||||||||||||||||||||||
|
3.98 ms (2.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 384491 385947 386740 388133 390278 391915 391950 408685 411374 420866 435355 446792 451502 453170 454516 457063 457656 466984 467099 468290 468504 468506 470195 470994 471013 471015 471020 471026 471057 473025 474475 475640 479351 490232 490599 493744 495286 496144 506092 509762 510923 522702 527333 531381 531737 537158 537949 544527 553436 555191 555547 557468 558314 559418 559421 560409 564230 576824 576880 581392 583651 588930 589123 589351 589942 591161 601824 607213 607692 608670 610209 611260 618475 619694 622195 628692 630453 637245 637902 640108 640997 642786 658140 665822 666055 666684 669291 673534 685527 699537 702914 705999 706679 714319 714493 723950 735912 745257 750632 768713 776464 790275 795334 797070 801532 801764 804264 817199 820365 823572 823774 824533 824633 825959 826203 826825 826826 826995 827293 828464 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy masturbation amateur"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая мастурбац любительск"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.84%) |
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.