Query Metrics
7
Database Queries
7
Different statements
158.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.41 ms (82.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 7011 119987 282494 388708 390321 390805 391595 392632 396159 396354 397065 402222 410776 413577 418414 426024 429961 439027 439281 441407 443120 447503 451605 452922 454754 465983 466098 466177 466237 470273 479758 479987 480854 483614 490794 494391 494409 513690 524514 526734 530953 534040 537960 537987 560637 561702 565964 567769 575095 575127 575160 594164 595403 595436 595459 595477 596578 596619 596995 597057 597059 597073 597499 597584 597948 597951 597969 598010 598013 598084 598553 598674 598700 598773 598797 600064 600118 600128 632118 650167 652605 654401 654881 663166 664277 670988 670989 673456 677366 699587 719214 720465 722603 722712 725132 725151 727824 740335 742234 743180 743232 746157 746803 746979 748327 752761 753343 753348 753364 753368 753831 753885 770431 779737 785772 786294 788414 789273 811634 817660 ] |
||||||||||||||||||||||||||||||
|
15.74 ms (9.92%) |
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 396159 561702 598773 597948 600118 479758 483614 722603 654401 664277 677366 720465 722712 560637 597499 788414 748327 770431 746803 752761 786294 817660 567769 441407 663166 595459 119987 479987 598010 7011 439281 595436 596578 650167 654881 391595 439027 537987 530953 595477 597073 597951 600128 597059 598084 598553 597969 740335 447503 466177 466237 451605 443120 465983 466098 526734 494391 537960 490794 524514 753364 594164 595403 598700 600064 494409 753343 753831 743180 753368 753348 753885 390321 632118 390805 402222 598013 652605 673456 670988 670989 719214 699587 596995 779737 785772 746157 811634 725132 725151 746979 727824 743232 789273 410776 575095 388708 742234 575160 429961 534040 597584 598797 282494 470273 513690 392632 575127 565964 597057 598674 596619 413577 480854 418414 426024 454754 396354 397065 452922 ] |
||||||||||||||||||||||||||||||
|
3.33 ms (2.10%) |
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 7011 119987 282494 388708 390321 390805 391595 392632 396159 396354 397065 402222 410776 413577 418414 426024 429961 439027 439281 441407 443120 447503 451605 452922 454754 465983 466098 466177 466237 470273 479758 479987 480854 483614 490794 494391 494409 513690 524514 526734 530953 534040 537960 537987 560637 561702 565964 567769 575095 575127 575160 594164 595403 595436 595459 595477 596578 596619 596995 597057 597059 597073 597499 597584 597948 597951 597969 598010 598013 598084 598553 598674 598700 598773 598797 600064 600118 600128 632118 650167 652605 654401 654881 663166 664277 670988 670989 673456 677366 699587 719214 720465 722603 722712 725132 725151 727824 740335 742234 743180 743232 746157 746803 746979 748327 752761 753343 753348 753364 753368 753831 753885 770431 779737 785772 786294 788414 789273 811634 817660 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"rus 18 teen"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (1.33%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск 18 teen"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск 18 teen"
]
|
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.