Query Metrics
7
Database Queries
7
Different statements
154.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.66 ms (83.81%) |
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 81022 385411 391492 391668 391705 397861 400481 400722 400816 412827 421820 421828 421857 422185 422207 423802 423947 424234 424434 428039 433614 439437 439572 439717 439802 440979 443913 443920 447981 449094 450684 451495 454508 456701 459514 460581 461814 462386 462605 462705 466227 466847 467628 467781 468343 470147 470621 470674 470686 475127 475319 480013 481383 482045 483602 483656 485596 485646 485945 486046 486365 487246 491125 493681 499997 501984 502718 503442 503450 504509 504665 508382 508869 509192 516668 521121 525695 526456 526792 530289 533659 537963 543745 543985 544524 546649 555046 578348 579079 581126 590539 599153 699976 710204 716090 726843 726887 731652 733661 738000 749900 759088 761607 762113 762274 764142 769131 778215 782122 791883 794763 794886 795359 802160 803145 805666 809645 827432 828555 ] |
||||||||||||||||||||||||||||||
|
14.29 ms (9.24%) |
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 485945 543985 443920 412827 421857 508382 782122 385411 769131 764595 462605 439717 428039 461814 503442 485646 449094 526456 749900 733661 440979 400816 483656 795359 475127 468343 391668 726843 726887 805666 599153 530289 462705 421828 450684 503450 502718 738000 509192 487246 581126 486046 424234 456701 501984 439572 486365 525695 544524 433614 537963 462386 423802 493681 422207 764142 491125 716090 762113 439437 470686 499997 778215 424434 470674 508869 81022 391705 481383 400481 504665 526792 467628 482045 791883 400722 397861 555046 454508 521121 422185 466227 391492 543745 475319 483602 466847 421820 470621 699976 439802 504509 443913 759088 470147 590539 480013 546649 578348 731652 809645 761607 533659 579079 516668 827432 762274 467781 460581 451495 447981 485596 459514 828555 710204 794886 802160 794763 803145 423947 ] |
||||||||||||||||||||||||||||||
|
3.98 ms (2.57%) |
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 81022 385411 391492 391668 391705 397861 400481 400722 400816 412827 421820 421828 421857 422185 422207 423802 423947 424234 424434 428039 433614 439437 439572 439717 439802 440979 443913 443920 447981 449094 450684 451495 454508 456701 459514 460581 461814 462386 462605 462705 466227 466847 467628 467781 468343 470147 470621 470674 470686 475127 475319 480013 481383 482045 483602 483656 485596 485646 485945 486046 486365 487246 491125 493681 499997 501984 502718 503442 503450 504509 504665 508382 508869 509192 516668 521121 525695 526456 526792 530289 533659 537963 543745 543985 544524 546649 555046 578348 579079 581126 590539 599153 699976 710204 716090 726843 726887 731652 733661 738000 749900 759088 761607 762113 762274 764142 769131 778215 782122 791883 794763 794886 795359 802160 803145 805666 809645 827432 828555 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мамы русское реальное…"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин русск любительск"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.89%) |
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.