Query Metrics
7
Database Queries
7
Different statements
167.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.42 ms (82.48%) |
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 124361 187786 187954 390747 391945 396975 400932 400935 406062 406899 407809 410937 411643 411745 413827 416989 418857 420774 423650 424646 427543 427981 428883 432663 432735 439572 439607 439628 444542 445903 447494 452767 454585 454627 459360 460315 462450 467949 468009 473782 474746 478832 479836 493260 495665 507651 507785 508430 512973 513696 518264 518992 522020 526492 529846 530456 530690 536218 537199 540334 544796 545607 546654 560426 565249 565254 565259 580631 584234 588264 590802 592462 597263 598042 609147 612856 614718 614867 621438 627806 628363 628377 628388 628391 628396 628397 628398 628409 630524 631597 633114 633497 633733 637004 637026 637427 640770 641127 647969 651188 677698 692130 698102 698124 701310 707368 709646 719391 720614 720871 739568 747597 769209 788767 790234 790813 790882 799971 814235 823857 ] |
||||||||||||||||||||||||||||||
|
19.34 ms (11.53%) |
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 459360 536218 647969 628377 628409 439572 614867 628391 427543 698124 545607 584234 720614 614718 823857 692130 790813 598042 640770 478832 418857 651188 474746 628397 460315 565259 529846 633733 637004 790234 633114 413827 439607 444542 495665 124361 432735 432663 560426 390747 447494 580631 565249 597263 628388 612856 628396 609147 512973 590802 400935 420774 621438 424646 452767 637427 628398 628363 407809 530456 493260 546654 462450 406062 411643 513696 187786 391945 454627 479836 814235 445903 565254 677698 508430 540334 592462 790882 701310 627806 530690 187954 400932 406899 518992 698102 522020 769209 739568 537199 630524 633497 416989 507651 473782 467949 526492 637026 428883 518264 641127 427981 411745 707368 719391 720871 799971 788767 410937 631597 747597 468009 709646 454585 439628 588264 396975 544796 423650 507785 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.62%) |
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 124361 187786 187954 390747 391945 396975 400932 400935 406062 406899 407809 410937 411643 411745 413827 416989 418857 420774 423650 424646 427543 427981 428883 432663 432735 439572 439607 439628 444542 445903 447494 452767 454585 454627 459360 460315 462450 467949 468009 473782 474746 478832 479836 493260 495665 507651 507785 508430 512973 513696 518264 518992 522020 526492 529846 530456 530690 536218 537199 540334 544796 545607 546654 560426 565249 565254 565259 580631 584234 588264 590802 592462 597263 598042 609147 612856 614718 614867 621438 627806 628363 628377 628388 628391 628396 628397 628398 628409 630524 631597 633114 633497 633733 637004 637026 637427 640770 641127 647969 651188 677698 692130 698102 698124 701310 707368 709646 719391 720614 720871 739568 747597 769209 788767 790234 790813 790882 799971 814235 823857 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal young hard"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал young hard"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал young hard"
]
|
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.