Query Metrics
7
Database Queries
7
Different statements
161.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.89 ms (84.71%) |
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 7741 280771 395662 401949 415894 418566 422406 427135 433904 438051 442644 450790 451695 453169 465798 466453 469464 473471 473816 476788 485298 489377 493428 495376 500234 500825 501904 529764 530198 530350 532048 533486 536298 540174 543678 543680 544955 547190 547283 547324 549275 549276 549295 549359 549979 554699 555573 556856 561035 568803 570805 570818 571182 572565 574202 576189 579472 579928 582654 582765 585784 596905 603008 604800 614688 615293 615922 627009 628261 636747 637463 639652 642995 645359 650113 659237 660283 666087 666360 689943 690663 690667 690726 698342 701248 701968 704662 709061 718817 722066 732087 736052 750505 751358 751369 752738 754434 762155 769538 773320 776427 782831 787069 794082 804262 804440 804453 805142 805234 806411 810041 811907 812663 814731 819807 820026 820984 823888 826679 826720 ] |
||||||||||||||||||||||||||||||
|
13.47 ms (8.33%) |
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 603008 637463 732087 627009 427135 451695 476788 395662 465798 418566 442644 450790 453169 466453 495376 489377 485298 280771 7741 401949 438051 422406 826720 814731 469464 500234 536298 500825 556856 582765 582654 543680 689943 690663 645359 650113 659237 690726 701968 718817 660283 690667 698342 704662 709061 554699 555573 568803 576189 585784 615293 628261 604800 614688 615922 636747 639652 642995 596905 805234 806411 776427 782831 804262 812663 736052 787069 794082 804453 811907 751369 752738 762155 754434 773320 751358 750505 701248 722066 804440 805142 810041 473816 415894 473471 493428 501904 826679 819807 820984 530198 533486 572565 574202 579928 547190 570818 666360 666087 549276 549359 579472 769538 433904 549275 547283 549295 570805 823888 820026 529764 530350 540174 532048 544955 547324 549979 561035 543678 571182 ] |
||||||||||||||||||||||||||||||
|
3.46 ms (2.14%) |
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 7741 280771 395662 401949 415894 418566 422406 427135 433904 438051 442644 450790 451695 453169 465798 466453 469464 473471 473816 476788 485298 489377 493428 495376 500234 500825 501904 529764 530198 530350 532048 533486 536298 540174 543678 543680 544955 547190 547283 547324 549275 549276 549295 549359 549979 554699 555573 556856 561035 568803 570805 570818 571182 572565 574202 576189 579472 579928 582654 582765 585784 596905 603008 604800 614688 615293 615922 627009 628261 636747 637463 639652 642995 645359 650113 659237 660283 666087 666360 689943 690663 690667 690726 698342 701248 701968 704662 709061 718817 722066 732087 736052 750505 751358 751369 752738 754434 762155 769538 773320 776427 782831 787069 794082 804262 804440 804453 805142 805234 806411 810041 811907 812663 814731 819807 820026 820984 823888 826679 826720 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bathroom erotic"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ван эротик"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.07%) |
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.