Query Metrics
7
Database Queries
7
Different statements
281.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
257.43 ms (91.36%) |
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 6864 6892 7665 10665 47128 49688 67698 69128 95988 96431 96468 96968 97156 97536 114536 122919 123070 123271 142598 143515 151564 182232 222010 231230 274927 286389 294932 326081 341786 383019 383795 386200 386374 387113 387413 387798 388077 388220 388821 392807 393453 396951 398709 402673 402982 407902 408711 409313 409452 410911 411134 419623 429540 441499 443898 457230 457411 461504 462712 462940 470755 471545 474027 481310 486790 526954 535788 542370 545080 548905 563697 568944 573951 578138 580608 588286 605049 622216 625307 630194 644655 649542 651896 652865 665486 667273 676530 694607 696167 701638 703087 703211 703825 705520 710363 714420 717870 721202 721484 722443 741213 742186 742489 743201 757155 760532 762067 762707 765666 767842 775565 782279 783265 793427 794260 799004 807200 810139 813908 ] |
||||||||||||||||||||||||||||||
|
14.43 ms (5.12%) |
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 274927 701638 69128 10665 782279 143515 762067 123070 545080 398709 7665 6892 810139 765461 67698 443898 775565 481310 535788 568944 714420 783265 767842 388077 742186 151564 341786 47128 676530 743201 703087 122919 114536 665486 605049 97536 457230 96431 123271 526954 625307 142598 813908 722443 441499 703825 710363 387113 387798 410911 649542 652865 388821 411134 667273 696167 807200 457411 588286 6864 703211 429540 717870 721484 757155 96468 396951 95988 419623 407902 383019 222010 231230 97156 471545 393453 409452 409313 573951 651896 794260 742489 741213 765666 799004 408711 474027 392807 49688 694607 542370 548905 580608 622216 386374 182232 387413 578138 644655 461504 563697 760532 294932 96968 388220 286389 705520 630194 326081 386200 402982 383795 486790 470755 721202 762707 793427 462712 402673 462940 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.04%) |
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 6864 6892 7665 10665 47128 49688 67698 69128 95988 96431 96468 96968 97156 97536 114536 122919 123070 123271 142598 143515 151564 182232 222010 231230 274927 286389 294932 326081 341786 383019 383795 386200 386374 387113 387413 387798 388077 388220 388821 392807 393453 396951 398709 402673 402982 407902 408711 409313 409452 410911 411134 419623 429540 441499 443898 457230 457411 461504 462712 462940 470755 471545 474027 481310 486790 526954 535788 542370 545080 548905 563697 568944 573951 578138 580608 588286 605049 622216 625307 630194 644655 649542 651896 652865 665486 667273 676530 694607 696167 701638 703087 703211 703825 705520 710363 714420 717870 721202 721484 722443 741213 742186 742489 743201 757155 760532 762067 762707 765666 767842 775565 782279 783265 793427 794260 799004 807200 810139 813908 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ебет двух"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.60%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс двух"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.60%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.49%) |
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.