Query Metrics
7
Database Queries
7
Different statements
142.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.33 ms (82.88%) |
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 396555 397528 397548 402172 419490 424682 428657 428724 429709 442992 443220 444753 447150 447152 452834 462780 465307 468873 471858 472441 472483 472531 475073 481789 486568 494349 510146 511269 513657 513675 513779 515058 515808 516429 520157 520409 523042 527427 530175 536699 536853 536864 536913 537679 539898 539913 548872 549854 550097 553489 557229 560484 560513 566832 568324 568589 577409 581241 584565 585366 586472 587164 587729 591687 596659 598126 602967 603248 603431 604460 606494 607293 611241 615914 623312 628086 629129 633444 635306 650802 666883 672999 674927 682508 684096 720394 721999 722706 727786 733994 737976 742945 743841 748671 750747 760068 763367 768871 784919 785302 799455 800588 804469 805484 809302 810668 811051 814822 815112 816975 818072 818119 819565 820967 821844 821909 822288 822448 822573 825561 ] |
||||||||||||||||||||||||||||||
|
15.72 ms (11.01%) |
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 628086 586472 604460 633444 530175 615914 784919 727786 733994 748671 799455 447152 465307 447150 481789 596659 397548 428724 452834 515808 516429 743841 568324 568589 635306 397528 527427 513675 468873 513779 603431 822573 444753 816975 536699 429709 539898 785302 737976 550097 577409 674927 666883 607293 611241 606494 800588 396555 402172 442992 443220 818072 821909 814822 818119 819565 815112 820967 821844 825561 486568 462780 471858 520157 520409 523042 537679 515058 511269 536853 536913 539913 472483 560484 566832 581241 584565 549854 548872 553489 650802 682508 672999 684096 720394 722706 557229 560513 603248 585366 591687 623312 598126 602967 587164 587729 760068 804469 805484 811051 629129 721999 809302 810668 475073 494349 510146 513657 763367 822288 742945 750747 768871 822448 419490 428657 424682 472441 472531 536864 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.58%) |
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 396555 397528 397548 402172 419490 424682 428657 428724 429709 442992 443220 444753 447150 447152 452834 462780 465307 468873 471858 472441 472483 472531 475073 481789 486568 494349 510146 511269 513657 513675 513779 515058 515808 516429 520157 520409 523042 527427 530175 536699 536853 536864 536913 537679 539898 539913 548872 549854 550097 553489 557229 560484 560513 566832 568324 568589 577409 581241 584565 585366 586472 587164 587729 591687 596659 598126 602967 603248 603431 604460 606494 607293 611241 615914 623312 628086 629129 633444 635306 650802 666883 672999 674927 682508 684096 720394 721999 722706 727786 733994 737976 742945 743841 748671 750747 760068 763367 768871 784919 785302 799455 800588 804469 805484 809302 810668 811051 814822 815112 816975 818072 818119 819565 820967 821844 821909 822288 822448 822573 825561 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina small cock"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская маленькая cock"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская маленькая cock"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.93%) |
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.