Query Metrics
7
Database Queries
7
Different statements
160.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.58 ms (82.22%) |
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 233269 265933 365962 387422 388200 391705 392030 392671 401559 405494 407759 409100 422525 422604 422609 422610 422625 422855 422871 422896 422923 423009 423025 423026 423039 423396 423398 423401 429086 439656 439806 453714 461105 463262 464286 466319 470154 475122 476264 477216 480392 482322 490924 491078 520159 524566 533783 535318 537732 546883 548833 551250 556845 559145 559365 563182 579998 586761 591441 596820 597807 598871 610669 618115 619367 623519 624143 625973 627660 634545 636252 642832 646858 661652 663444 664531 665835 668848 695565 701774 703448 704641 721489 722281 723828 731756 741294 755776 757105 757377 757982 758283 759978 760007 760382 760523 760963 772635 781714 782262 788553 788800 789170 790220 796994 799591 800557 802554 805023 805243 806054 808057 810963 813573 814711 816558 819701 820229 824920 825505 ] |
||||||||||||||||||||||||||||||
|
16.89 ms (10.55%) |
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 701774 556845 597807 642832 788553 790220 805243 810963 808057 757105 757377 760007 623519 788800 409100 453714 401559 466319 422855 422871 423398 476264 407759 524566 490924 546883 661652 646858 668848 665835 579998 755776 772635 796994 233269 439806 439656 491078 265933 405494 816558 820229 824920 563182 664531 704641 721489 722281 636252 624143 618115 596820 625973 806054 800557 757982 758283 760382 760523 789170 387422 391705 392030 392671 365962 535318 423039 422609 422625 422896 429086 422525 423025 423026 819701 813573 464286 533783 537732 520159 551250 548833 559145 663444 591441 610669 619367 634545 586761 598871 627660 805023 799591 741294 760963 423009 423401 463262 475122 422604 461105 470154 423396 422610 477216 482322 422923 480392 388200 825505 814711 559365 695565 703448 781714 782262 802554 723828 759978 731756 ] |
||||||||||||||||||||||||||||||
|
3.86 ms (2.41%) |
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 233269 265933 365962 387422 388200 391705 392030 392671 401559 405494 407759 409100 422525 422604 422609 422610 422625 422855 422871 422896 422923 423009 423025 423026 423039 423396 423398 423401 429086 439656 439806 453714 461105 463262 464286 466319 470154 475122 476264 477216 480392 482322 490924 491078 520159 524566 533783 535318 537732 546883 548833 551250 556845 559145 559365 563182 579998 586761 591441 596820 597807 598871 610669 618115 619367 623519 624143 625973 627660 634545 636252 642832 646858 661652 663444 664531 665835 668848 695565 701774 703448 704641 721489 722281 723828 731756 741294 755776 757105 757377 757982 758283 759978 760007 760382 760523 760963 772635 781714 782262 788553 788800 789170 790220 796994 799591 800557 802554 805023 805243 806054 808057 810963 813573 814711 816558 819701 820229 824920 825505 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.33%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pantyhose young"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pantyhose young"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pantyhose young"
]
|
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.