Query Metrics
7
Database Queries
7
Different statements
161.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.00 ms (84.87%) |
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 101894 404845 415273 415880 421273 421638 433512 435428 437227 437523 438898 439735 439850 442871 443859 446020 449019 453889 454118 459734 460954 461148 461412 461462 463927 465038 466672 468060 468661 468753 470622 470849 479559 479683 479697 483163 484785 486753 488525 491781 491885 493243 495917 496058 504684 509648 509781 511047 512491 512595 517740 518287 520692 522653 523086 524758 526429 526565 527931 528020 535631 535879 536603 538211 538216 540143 545221 548281 549261 549865 551604 553974 557071 557536 558072 558828 559613 560065 561721 573566 575730 576190 576271 578139 581748 582697 584776 584852 591783 594844 597062 604470 607227 607283 614687 622057 622799 622978 624163 627711 636819 638334 639775 670113 676492 681369 682072 683576 684701 723447 730281 742966 766224 767847 769933 778087 782922 790110 817111 823364 ] |
||||||||||||||||||||||||||||||
|
15.03 ms (9.31%) |
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 535879 520692 470849 575730 573566 558828 442871 496058 101894 433512 437227 465038 466672 581748 551604 557071 549865 553974 561721 607283 594844 421638 468753 538211 493243 509781 523086 488525 549261 766224 463927 437523 683576 509648 461462 538216 438898 446020 453889 449019 522653 540143 559613 468060 479559 461412 512595 817111 607227 470622 636819 443859 582697 491885 421273 526429 518287 558072 536603 548281 584852 723447 778087 742966 730281 769933 524758 527931 415273 684701 439850 622799 435428 404845 535631 454118 460954 511047 545221 597062 624163 584776 526565 439735 468661 461148 578139 670113 504684 604470 486753 576271 681369 560065 627711 622057 528020 459734 415880 576190 639775 782922 790110 767847 638334 479683 676492 622978 591783 614687 483163 484785 491781 512491 479697 823364 517740 682072 557536 495917 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.61%) |
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 101894 404845 415273 415880 421273 421638 433512 435428 437227 437523 438898 439735 439850 442871 443859 446020 449019 453889 454118 459734 460954 461148 461412 461462 463927 465038 466672 468060 468661 468753 470622 470849 479559 479683 479697 483163 484785 486753 488525 491781 491885 493243 495917 496058 504684 509648 509781 511047 512491 512595 517740 518287 520692 522653 523086 524758 526429 526565 527931 528020 535631 535879 536603 538211 538216 540143 545221 548281 549261 549865 551604 553974 557071 557536 558072 558828 559613 560065 561721 573566 575730 576190 576271 578139 581748 582697 584776 584852 591783 594844 597062 604470 607227 607283 614687 622057 622799 622978 624163 627711 636819 638334 639775 670113 676492 681369 682072 683576 684701 723447 730281 742966 766224 767847 769933 778087 782922 790110 817111 823364 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pigtails blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"косичк минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.35 ms (0.84%) |
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.