Query Metrics
7
Database Queries
7
Different statements
201.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.55 ms (86.71%) |
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 393723 393728 393735 393758 394240 396554 400460 400490 402085 402257 413252 418049 418407 418495 429086 430286 443729 446376 447242 466154 470729 470840 473073 475220 480437 484129 484130 487370 487910 488306 488330 488361 491200 498496 504354 506213 515110 515111 515116 515135 515152 515171 515195 515200 515205 515217 515717 517195 525117 529117 529127 543547 545000 549256 550230 550437 550609 556408 557064 561321 563464 566516 566520 566534 566536 567150 567156 567159 567166 568573 569667 569672 569677 569679 569684 569686 570060 570071 578457 578472 584539 585603 586628 600793 603304 620934 644697 663393 664288 664296 665238 667312 667472 667490 667858 676445 678802 686064 692859 693078 714447 714478 722688 722916 732457 736403 741445 743034 743039 743118 743147 747875 759649 767960 788471 788749 789228 794656 819963 827117 ] |
||||||||||||||||||||||||||||||
|
16.53 ms (8.21%) |
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 644697 400460 402085 430286 394240 418407 488361 525117 567156 446376 504354 549256 550437 568573 569679 567159 569677 545000 515171 515135 550230 393735 667472 667858 664296 667312 686064 789228 736403 743147 741445 747875 743039 743118 396554 418049 443729 517195 470729 570071 603304 400490 515205 586628 487910 484129 506213 567166 584539 550609 487370 491200 515152 515200 429086 413252 480437 515195 529127 529117 475220 566516 543547 578457 567150 692859 714447 664288 665238 693078 563464 566520 566534 569684 570060 578472 600793 620934 585603 794656 722916 393723 402257 418495 393728 393758 466154 470840 515116 488330 515217 566536 569667 819963 827117 515110 515111 488306 556408 667490 678802 663393 676445 714478 722688 788471 788749 743034 767960 732457 759649 569686 557064 561321 498496 484130 515717 473073 569672 447242 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.44%) |
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 393723 393728 393735 393758 394240 396554 400460 400490 402085 402257 413252 418049 418407 418495 429086 430286 443729 446376 447242 466154 470729 470840 473073 475220 480437 484129 484130 487370 487910 488306 488330 488361 491200 498496 504354 506213 515110 515111 515116 515135 515152 515171 515195 515200 515205 515217 515717 517195 525117 529117 529127 543547 545000 549256 550230 550437 550609 556408 557064 561321 563464 566516 566520 566534 566536 567150 567156 567159 567166 568573 569667 569672 569677 569679 569684 569686 570060 570071 578457 578472 584539 585603 586628 600793 603304 620934 644697 663393 664288 664296 665238 667312 667472 667490 667858 676445 678802 686064 692859 693078 714447 714478 722688 722916 732457 736403 741445 743034 743039 743118 743147 747875 759649 767960 788471 788749 789228 794656 819963 827117 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"старый худая"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"старик и худая"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"старый худая"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.