Query Metrics
7
Database Queries
7
Different statements
210.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.22 ms (88.17%) |
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 30841 103758 387854 396791 397249 398701 402056 403035 417610 420122 432425 433433 466000 472794 485440 486741 487699 493827 500741 509185 509534 510735 521795 523690 529810 530029 530642 530962 530977 533528 533808 533810 533817 535552 538771 540057 540860 542120 552225 554080 554845 558403 568110 568230 574125 576729 585869 585882 588479 589977 590061 590114 590295 592325 593551 595427 595438 595491 595508 596039 597836 600895 604031 604110 610188 610650 614559 615154 618144 619242 621974 622077 627875 633300 635192 643707 702695 703260 729634 732094 734859 739305 740222 740345 743160 743248 744010 744135 746272 750344 750470 751712 752416 753108 755883 757188 758457 758846 759643 765252 772606 777876 782583 782744 782780 784330 785123 785408 786498 788210 788913 791138 796397 806817 810165 810807 814160 814180 814462 820165 ] |
||||||||||||||||||||||||||||||
|
14.69 ms (6.99%) |
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 604031 604110 610188 614559 615154 633300 635192 589977 590114 590295 595427 595438 610650 619242 622077 585869 585882 588479 595491 597836 600895 627875 590061 592325 593551 595508 596039 618144 785123 785408 786498 782583 791138 729634 739305 744010 750344 752416 753108 755883 757188 758457 758846 765252 772606 782744 782780 796397 806817 810165 810807 732094 759643 734859 740222 751712 740345 743160 744135 743248 746272 750470 621974 643707 702695 703260 777876 784330 788210 788913 396791 472794 397249 398701 402056 466000 433433 523690 510735 521795 103758 30841 387854 403035 417610 420122 432425 814160 814180 540860 814462 820165 485440 487699 493827 509185 529810 530977 533810 530642 533528 533817 540057 530029 535552 538771 500741 509534 530962 533808 486741 542120 552225 554080 554845 558403 568110 568230 574125 576729 ] |
||||||||||||||||||||||||||||||
|
4.21 ms (2.00%) |
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 30841 103758 387854 396791 397249 398701 402056 403035 417610 420122 432425 433433 466000 472794 485440 486741 487699 493827 500741 509185 509534 510735 521795 523690 529810 530029 530642 530962 530977 533528 533808 533810 533817 535552 538771 540057 540860 542120 552225 554080 554845 558403 568110 568230 574125 576729 585869 585882 588479 589977 590061 590114 590295 592325 593551 595427 595438 595491 595508 596039 597836 600895 604031 604110 610188 610650 614559 615154 618144 619242 621974 622077 627875 633300 635192 643707 702695 703260 729634 732094 734859 739305 740222 740345 743160 743248 744010 744135 746272 750344 750470 751712 752416 753108 755883 757188 758457 758846 759643 765252 772606 777876 782583 782744 782780 784330 785123 785408 786498 788210 788913 791138 796397 806817 810165 810807 814160 814180 814462 820165 ] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen эротик"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen erotic"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen эротик"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.64%) |
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.