Query Metrics
7
Database Queries
7
Different statements
316.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
290.83 ms (91.96%) |
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 31583 118900 199865 210576 309095 388213 410193 413262 425935 429252 464137 472305 490586 491010 492164 497660 512932 521447 525062 525481 527596 530658 531955 535371 535601 539598 542322 544032 546814 552547 554046 556093 556593 556673 559345 560166 560502 563132 570890 579455 580944 580956 581004 581621 584293 584363 588293 588596 594409 594872 605225 607025 615650 616276 618659 619132 622036 627894 641479 642962 644847 644905 661329 661342 661576 665302 666014 677749 685527 687304 689868 695984 696688 701204 701623 701644 712570 725793 732923 733506 736031 737569 738352 753028 761483 768503 768770 771406 778228 782292 784252 785136 788137 789025 789062 790380 790881 792598 792623 792786 798169 798821 804263 804418 804636 808295 810621 812523 817627 819195 823121 824269 828039 828060 828138 828197 828371 828372 828425 828762 ] |
||||||||||||||||||||||||||||||
|
16.07 ms (5.08%) |
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 812523 792786 580944 789025 732923 560166 556593 824269 828371 792623 733506 828138 792598 810621 531955 771406 425935 472305 491010 525062 527596 199865 695984 828060 588596 790881 619132 594409 539598 737569 642962 701204 685527 661576 701623 701644 118900 580956 556673 788137 490586 388213 828762 644905 823121 581621 627894 804636 661342 546814 666014 804418 736031 696688 615650 535371 725793 309095 559345 828425 828039 689868 544032 665302 782292 521447 790380 738352 641479 761483 828372 828197 210576 31583 429252 588293 661329 677749 497660 753028 819195 584293 616276 413262 784252 552547 556093 768770 622036 817627 525481 512932 712570 804263 579455 594872 798169 798821 808295 605225 410193 644847 560502 570890 581004 584363 542322 554046 563132 687304 607025 789062 768503 785136 492164 535601 530658 778228 464137 618659 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (0.87%) |
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 31583 118900 199865 210576 309095 388213 410193 413262 425935 429252 464137 472305 490586 491010 492164 497660 512932 521447 525062 525481 527596 530658 531955 535371 535601 539598 542322 544032 546814 552547 554046 556093 556593 556673 559345 560166 560502 563132 570890 579455 580944 580956 581004 581621 584293 584363 588293 588596 594409 594872 605225 607025 615650 616276 618659 619132 622036 627894 641479 642962 644847 644905 661329 661342 661576 665302 666014 677749 685527 687304 689868 695984 696688 701204 701623 701644 712570 725793 732923 733506 736031 737569 738352 753028 761483 768503 768770 771406 778228 782292 784252 785136 788137 789025 789062 790380 790881 792598 792623 792786 798169 798821 804263 804418 804636 808295 810621 812523 817627 819195 823121 824269 828039 828060 828138 828197 828371 828372 828425 828762 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits public"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.54%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.53%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.44%) |
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.