Query Metrics
7
Database Queries
7
Different statements
181.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.97 ms (88.19%) |
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 383407 427264 430227 431702 442236 442280 444938 445560 446783 447493 450583 453160 461106 468510 473245 476153 487328 488332 492664 496842 506510 510916 511356 515024 525727 526460 527624 537480 539770 550357 550788 551979 552848 554432 556858 563429 563687 563688 571094 575391 576528 577614 581130 588811 588900 590730 597044 600467 605660 607526 607692 609058 609551 612211 620880 628524 628558 633190 641176 659475 660711 661535 666050 667395 667987 669296 670265 673573 683202 694638 694926 694935 699401 707470 709549 709898 713424 714332 714531 719143 723961 724520 728980 729798 734664 735518 739940 742280 742310 743236 750514 753729 758919 763966 773603 774186 774310 775628 776414 788226 794420 794644 794698 797053 800611 800989 808480 810112 811942 813202 814297 817800 819396 820122 822172 824253 824757 824765 825833 827138 ] |
||||||||||||||||||||||||||||||
|
10.99 ms (6.06%) |
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 811942 723961 743236 774186 739940 774310 728980 753729 607526 641176 709898 714531 794644 797053 476153 588900 724520 550357 758919 431702 442236 453160 510916 742280 824253 515024 556858 817800 794698 734664 763966 576528 525727 552848 527624 814297 537480 554432 571094 563687 667395 683202 660711 661535 694638 694926 666050 667987 694935 550788 620880 628558 633190 588811 609551 612211 794420 800611 808480 810112 788226 750514 729798 719143 776414 813202 492664 820122 577614 825833 800989 773603 699401 819396 824757 827138 824765 468510 628524 742310 427264 430227 444938 442280 445560 461106 511356 473245 590730 822172 673573 775628 447493 506510 707470 450583 597044 446783 735518 383407 487328 496842 526460 539770 488332 563688 581130 551979 563429 575391 659475 714332 669296 670265 709549 713424 600467 605660 607692 609058 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.41%) |
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 383407 427264 430227 431702 442236 442280 444938 445560 446783 447493 450583 453160 461106 468510 473245 476153 487328 488332 492664 496842 506510 510916 511356 515024 525727 526460 527624 537480 539770 550357 550788 551979 552848 554432 556858 563429 563687 563688 571094 575391 576528 577614 581130 588811 588900 590730 597044 600467 605660 607526 607692 609058 609551 612211 620880 628524 628558 633190 641176 659475 660711 661535 666050 667395 667987 669296 670265 673573 683202 694638 694926 694935 699401 707470 709549 709898 713424 714332 714531 719143 723961 724520 728980 729798 734664 735518 739940 742280 742310 743236 750514 753729 758919 763966 773603 774186 774310 775628 776414 788226 794420 794644 794698 797053 800611 800989 808480 810112 811942 813202 814297 817800 819396 820122 822172 824253 824757 824765 825833 827138 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"long hairy pussy"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"длинные волосатая pussy"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"длинные волосатая pussy"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.