Query Metrics
7
Database Queries
7
Different statements
148.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.56 ms (81.98%) |
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 386178 388116 393452 396317 397811 398184 407429 407653 407716 408188 418932 419422 423982 426127 426404 428192 429824 438109 439638 439766 439779 443142 443664 447244 447574 448995 453001 453469 453781 454059 454407 455026 458312 462897 463910 467628 469371 470287 472078 473989 479993 480819 481191 481798 485535 486964 490210 494912 496112 496259 497006 501996 507989 512562 517922 518351 518948 519277 520911 521118 523731 527794 531919 532444 532939 535707 541294 542742 557058 557254 566539 567666 573964 574443 575714 576293 588494 592890 598973 599549 602724 614088 620208 628667 635167 635998 636235 638165 640304 647951 664579 689943 693635 696414 707526 711700 718684 721461 723616 724852 725565 728084 740258 745744 745946 750831 753707 765812 771952 774935 777668 781255 784662 791981 793077 803306 813266 817949 823774 ] |
||||||||||||||||||||||||||||||
|
16.37 ms (11.04%) |
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 725565 455026 535707 463910 542742 473989 467628 462897 523731 497006 501996 527794 447244 745946 520911 393452 429824 664579 628667 531919 567666 479993 518948 532939 426404 481798 784662 512562 481191 573964 439638 496259 386178 541294 454059 635998 439779 418932 472078 507989 453469 419422 453781 458312 532444 494912 408188 707526 647951 793077 728084 438109 557058 490210 443142 447574 521118 696414 779276 765812 635167 781255 423982 638165 693635 426127 517922 518351 486964 602724 496112 592890 428192 576293 598973 398184 439766 575714 470287 740258 823774 723616 407653 407429 689943 443664 711700 620208 599549 614088 750831 448995 519277 588494 771952 777668 453001 745744 388116 480819 469371 724852 803306 791981 566539 721461 397811 407716 485535 454407 574443 774935 557254 817949 718684 813266 753707 636235 396317 640304 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (2.08%) |
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 386178 388116 393452 396317 397811 398184 407429 407653 407716 408188 418932 419422 423982 426127 426404 428192 429824 438109 439638 439766 439779 443142 443664 447244 447574 448995 453001 453469 453781 454059 454407 455026 458312 462897 463910 467628 469371 470287 472078 473989 479993 480819 481191 481798 485535 486964 490210 494912 496112 496259 497006 501996 507989 512562 517922 518351 518948 519277 520911 521118 523731 527794 531919 532444 532939 535707 541294 542742 557058 557254 566539 567666 573964 574443 575714 576293 588494 592890 598973 599549 602724 614088 620208 628667 635167 635998 636235 638165 640304 647951 664579 689943 693635 696414 707526 711700 718684 721461 723616 724852 725565 728084 740258 745744 745946 750831 753707 765812 771952 774935 777668 781255 784662 791981 793077 803306 813266 817949 823774 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"трахнул сисястую в ванной"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс большие сиськ ван"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.94%) |
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.