Query Metrics
7
Database Queries
7
Different statements
404.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.34 ms (51.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny big ass"
]
|
||||||||||||||||||||||||||||||
|
164.69 ms (40.70%) |
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 388976 397319 409948 410623 414662 416200 419813 432236 443084 443982 447422 470344 478044 481150 484801 485233 485502 489506 496636 500580 500590 501535 517086 523579 525211 525725 529988 534546 537467 540846 541861 541919 542705 547477 547485 547501 548747 550732 551292 552064 553881 554309 554339 556485 557349 557938 558624 558819 559664 559711 561334 562775 567184 567531 567779 568524 569736 571009 572690 573198 576142 578325 578434 579312 580122 581300 581467 582811 586134 586539 588568 588610 588843 589251 593935 597815 598728 598796 600319 601322 603096 603605 605145 605345 606738 610300 617969 617993 619451 645400 647898 659414 660359 660382 662024 668690 674064 680190 681570 702163 714475 718934 719470 722522 728194 730692 732072 741541 743105 743111 745129 753688 762257 799007 804531 807399 810684 811850 814657 825001 ] |
||||||||||||||||||||||||||||||
|
18.00 ms (4.45%) |
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 550732 581467 567531 578325 551292 569736 645400 662024 718934 719470 553881 573198 576142 598796 600319 598728 605145 588843 810684 743105 743111 732072 753688 388976 556485 647898 680190 702163 586134 410623 540846 481150 558819 578434 541861 542705 660359 660382 580122 603096 617993 588610 485502 414662 443084 419813 814657 485233 500580 534546 537467 547501 557349 559664 567184 568524 571009 547477 552064 572690 659414 668690 722522 554339 558624 588568 589251 617969 597815 610300 799007 730692 745129 762257 741541 811850 501535 416200 825001 478044 525725 496636 523579 500590 529988 547485 548747 567779 541919 557938 581300 681570 714475 674064 554309 559711 562775 579312 601322 605345 603605 606738 586539 804531 807399 728194 432236 397319 409948 443982 447422 470344 517086 489506 525211 484801 561334 582811 593935 619451 ] |
||||||||||||||||||||||||||||||
|
3.58 ms (0.89%) |
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 388976 397319 409948 410623 414662 416200 419813 432236 443084 443982 447422 470344 478044 481150 484801 485233 485502 489506 496636 500580 500590 501535 517086 523579 525211 525725 529988 534546 537467 540846 541861 541919 542705 547477 547485 547501 548747 550732 551292 552064 553881 554309 554339 556485 557349 557938 558624 558819 559664 559711 561334 562775 567184 567531 567779 568524 569736 571009 572690 573198 576142 578325 578434 579312 580122 581300 581467 582811 586134 586539 588568 588610 588843 589251 593935 597815 598728 598796 600319 601322 603096 603605 605145 605345 606738 610300 617969 617993 619451 645400 647898 659414 660359 660382 662024 668690 674064 680190 681570 702163 714475 718934 719470 722522 728194 730692 732072 741541 743105 743111 745129 753688 762257 799007 804531 807399 810684 811850 814657 825001 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
2.82 ms (0.70%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
2.22 ms (0.55%) |
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.