Query Metrics
7
Database Queries
7
Different statements
145.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.98 ms (81.77%) |
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 3616 16971 73724 152027 386876 391492 392493 393715 395908 397410 398462 398544 398554 411367 420541 422358 445040 457011 458031 466014 470302 494682 501442 506211 515202 518852 529698 538660 539373 543694 548016 550617 551891 553863 565648 569679 577276 578461 579740 585623 585625 603374 612270 616701 627380 631220 636713 640281 660789 660799 661957 663372 663404 663916 664842 665399 666071 677074 682525 683359 684101 691676 693852 700691 702382 710769 716991 718143 721476 721561 722654 726284 726556 730714 734672 738339 739730 741093 741438 742812 744370 747230 747926 748876 756097 760334 765931 776028 781683 782261 782499 784274 793694 795387 795577 795594 795704 796614 797041 797216 797371 798527 800283 800317 800761 802186 802187 807963 808128 812323 813867 817261 817652 823578 823923 825158 825260 826888 827094 827964 ] |
||||||||||||||||||||||||||||||
|
15.07 ms (10.35%) |
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 569679 640281 797216 603374 781683 393715 826888 661957 16971 506211 386876 796614 784274 823923 152027 825158 666071 553863 812323 744370 760334 700691 817261 823578 543694 693852 721561 683359 550617 551891 612270 616701 631220 739730 738339 827094 395908 577276 782261 795577 730714 422358 718143 627380 663916 470302 813867 782499 776028 741093 665399 445040 398554 684101 585623 802186 702382 458031 466014 518852 392493 398544 565648 660799 548016 800317 734672 798527 800761 726284 747926 765931 800283 73724 825260 529698 636713 797371 797041 795704 726556 716991 397410 663404 756097 795594 398462 793694 411367 3616 827964 660789 677074 807963 808128 501442 579740 538660 515202 682525 817652 721476 691676 802187 748876 741438 742812 795387 722654 585625 663372 578461 747230 391492 539373 710769 457011 664842 420541 494682 ] |
||||||||||||||||||||||||||||||
|
3.74 ms (2.57%) |
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 3616 16971 73724 152027 386876 391492 392493 393715 395908 397410 398462 398544 398554 411367 420541 422358 445040 457011 458031 466014 470302 494682 501442 506211 515202 518852 529698 538660 539373 543694 548016 550617 551891 553863 565648 569679 577276 578461 579740 585623 585625 603374 612270 616701 627380 631220 636713 640281 660789 660799 661957 663372 663404 663916 664842 665399 666071 677074 682525 683359 684101 691676 693852 700691 702382 710769 716991 718143 721476 721561 722654 726284 726556 730714 734672 738339 739730 741093 741438 742812 744370 747230 747926 748876 756097 760334 765931 776028 781683 782261 782499 784274 793694 795387 795577 795594 795704 796614 797041 797216 797371 798527 800283 800317 800761 802186 802187 807963 808128 812323 813867 817261 817652 823578 823923 825158 825260 826888 827094 827964 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old fuck wife"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old секс жен"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old секс жен"
]
|
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.