Query Metrics
7
Database Queries
7
Different statements
161.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.02 ms (83.44%) |
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 307940 405156 446988 448083 459524 462098 475980 482525 484372 488596 490852 492169 506429 511469 512903 513431 516263 516890 517092 520346 520573 521243 521428 523045 525870 528217 543061 546786 547242 551259 554778 554790 556577 556735 557021 558223 562368 563479 564009 567522 568072 568328 568382 568741 570277 572495 572774 573486 573557 577421 579062 582631 584703 586180 589665 589721 592347 594819 594830 595178 595471 595588 595871 596467 596627 597125 597256 597559 597831 598046 598449 598887 598953 599359 601856 601867 601976 602397 602483 603981 604541 605105 606016 607045 608242 608364 608448 611477 613282 613316 613396 613401 613970 614573 615623 616787 617039 617370 619308 620124 620216 620320 621203 622248 623260 623378 624731 625404 626541 628273 632569 639159 651937 652236 652592 652594 653557 653559 653560 679076 ] |
||||||||||||||||||||||||||||||
|
16.27 ms (10.06%) |
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 516263 556577 589665 624731 446988 448083 528217 513431 521243 525870 652236 679076 568741 595471 613282 613401 620124 596627 488596 520346 547242 567522 572495 573486 598046 307940 651937 653560 606016 546786 584703 570277 652592 551259 595588 621203 611477 632569 595178 597559 608364 619308 520573 572774 543061 568382 586180 594819 598887 620320 622248 597256 598449 602483 608242 613316 613970 617370 597125 601867 602397 603981 604541 605105 462098 405156 512903 613396 558223 562368 563479 554778 554790 557021 579062 653557 652594 653559 568072 573557 577421 582631 592347 599359 607045 614573 628273 597831 625404 589721 594830 595871 596467 598953 601856 608448 615623 620216 626541 639159 616787 617039 601976 623260 623378 459524 475980 506429 490852 511469 516890 523045 492169 484372 517092 521428 482525 556735 564009 568328 ] |
||||||||||||||||||||||||||||||
|
4.35 ms (2.69%) |
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 307940 405156 446988 448083 459524 462098 475980 482525 484372 488596 490852 492169 506429 511469 512903 513431 516263 516890 517092 520346 520573 521243 521428 523045 525870 528217 543061 546786 547242 551259 554778 554790 556577 556735 557021 558223 562368 563479 564009 567522 568072 568328 568382 568741 570277 572495 572774 573486 573557 577421 579062 582631 584703 586180 589665 589721 592347 594819 594830 595178 595471 595588 595871 596467 596627 597125 597256 597559 597831 598046 598449 598887 598953 599359 601856 601867 601976 602397 602483 603981 604541 605105 606016 607045 608242 608364 608448 611477 613282 613316 613396 613401 613970 614573 615623 616787 617039 617370 619308 620124 620216 620320 621203 622248 623260 623378 624731 625404 626541 628273 632569 639159 651937 652236 652592 652594 653557 653559 653560 679076 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"взял раком"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"взял рак"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.86%) |
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.