Query Metrics
7
Database Queries
7
Different statements
177.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.88 ms (83.38%) |
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 182352 388791 390389 397203 414252 420144 420330 421545 427266 429884 429899 432348 432350 449908 452620 452968 455082 457063 459476 463782 465725 471969 472678 472706 476877 483522 495031 499836 510425 510950 513209 525727 528557 529595 529774 543640 555392 558316 561518 574178 574398 577949 578505 580503 581173 581565 586081 587446 587465 588379 591572 593086 595522 597725 598267 604966 607532 614835 614836 618329 625946 628854 643919 660052 666026 666046 666054 666091 667976 679146 681491 710026 710234 710268 711749 712628 713247 714331 714737 730795 736092 738468 742334 750765 753033 755908 758155 759315 769989 770022 773058 776467 776796 778863 780553 785136 793053 795221 796399 796465 798762 800753 800754 800767 801016 802340 803441 804440 806705 807415 807432 808016 808987 810754 812539 812549 813363 818551 819418 825514 ] |
||||||||||||||||||||||||||||||
|
16.48 ms (9.30%) |
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 710026 710234 710268 712628 714331 580503 643919 591572 618329 587465 598267 776467 776796 778863 798762 807415 813363 755908 770022 795221 796399 808987 810754 812549 730795 742334 759315 773058 738468 769989 736092 604966 607532 711749 785136 804440 806705 807432 808016 397203 427266 713247 628854 800767 758155 803441 414252 452968 578505 819418 679146 597725 182352 420330 455082 528557 574398 457063 463782 483522 388791 449908 587446 432348 472678 452620 476877 432350 471969 495031 510950 499836 525727 825514 465725 561518 543640 581565 614835 593086 595522 472706 513209 581173 429884 459476 429899 577949 660052 586081 614836 793053 780553 800753 801016 802340 812539 800754 753033 714737 796465 390389 420144 588379 625946 750765 558316 510425 421545 818551 529595 529774 574178 555392 666026 666054 681491 667976 666046 666091 ] |
||||||||||||||||||||||||||||||
|
3.70 ms (2.09%) |
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 182352 388791 390389 397203 414252 420144 420330 421545 427266 429884 429899 432348 432350 449908 452620 452968 455082 457063 459476 463782 465725 471969 472678 472706 476877 483522 495031 499836 510425 510950 513209 525727 528557 529595 529774 543640 555392 558316 561518 574178 574398 577949 578505 580503 581173 581565 586081 587446 587465 588379 591572 593086 595522 597725 598267 604966 607532 614835 614836 618329 625946 628854 643919 660052 666026 666046 666054 666091 667976 679146 681491 710026 710234 710268 711749 712628 713247 714331 714737 730795 736092 738468 742334 750765 753033 755908 758155 759315 769989 770022 773058 776467 776796 778863 780553 785136 793053 795221 796399 796465 798762 800753 800754 800767 801016 802340 803441 804440 806705 807415 807432 808016 808987 810754 812539 812549 813363 818551 819418 825514 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп волосатая соло"
]
|
||||||||||||||||||||||||||||||
|
2.47 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass hairy solo"
]
|
||||||||||||||||||||||||||||||
|
2.21 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.