Query Metrics
7
Database Queries
7
Different statements
215.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
186.80 ms (86.82%) |
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 12900 157194 187990 188507 188515 387337 391287 393082 393486 394639 395550 396890 397916 398559 400858 401640 406062 409234 411351 411362 412988 426531 428412 439697 440801 440947 440996 440997 443139 443999 444255 451464 452940 453126 453471 464138 464341 464975 466018 466020 466025 466140 466801 466907 467114 469390 469581 471405 471417 474629 475874 476796 481124 481918 483351 483386 484646 484738 490424 493185 498228 499881 503845 512608 516093 518919 522504 526745 531878 531970 532271 533920 534680 537261 563087 573918 593842 604562 605208 610042 610473 614723 615726 619522 645962 672794 677971 692813 705452 715786 720008 721693 726960 729814 730100 730347 731025 741066 744994 748256 758152 759946 761030 761031 761056 761600 788546 792660 792670 795540 796945 803655 810358 810774 816250 816793 818438 824014 825318 826531 ] |
||||||||||||||||||||||||||||||
|
17.11 ms (7.95%) |
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 816250 741066 406062 466801 466907 573918 715786 810774 759946 481124 503845 526745 394639 518919 498228 499881 610042 604562 464975 395550 466020 412988 471417 464341 440996 467114 593842 744994 400858 483386 563087 481918 537261 692813 705452 721693 645962 677971 610473 729814 187990 826531 393082 188507 533920 532271 796945 788546 810358 761056 792670 476796 393486 824014 818438 720008 731025 534680 453126 426531 615726 619522 157194 411362 469390 466140 471405 474629 475874 401640 443999 397916 398559 466025 439697 443139 466018 493185 522504 490424 484646 440997 816793 469581 614723 409234 761600 761031 726960 440801 605208 795540 761030 440947 391287 444255 483351 672794 730347 516093 188515 387337 825318 531878 803655 730100 758152 428412 451464 411351 484738 531970 792660 464138 512608 748256 12900 452940 396890 453471 ] |
||||||||||||||||||||||||||||||
|
4.00 ms (1.86%) |
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 12900 157194 187990 188507 188515 387337 391287 393082 393486 394639 395550 396890 397916 398559 400858 401640 406062 409234 411351 411362 412988 426531 428412 439697 440801 440947 440996 440997 443139 443999 444255 451464 452940 453126 453471 464138 464341 464975 466018 466020 466025 466140 466801 466907 467114 469390 469581 471405 471417 474629 475874 476796 481124 481918 483351 483386 484646 484738 490424 493185 498228 499881 503845 512608 516093 518919 522504 526745 531878 531970 532271 533920 534680 537261 563087 573918 593842 604562 605208 610042 610473 614723 615726 619522 645962 672794 677971 692813 705452 715786 720008 721693 726960 729814 730100 730347 731025 741066 744994 748256 758152 759946 761030 761031 761056 761600 788546 792660 792670 795540 796945 803655 810358 810774 816250 816793 818438 824014 825318 826531 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big anal mature"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие анал mature"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие анал mature"
]
|
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.