Query Metrics
7
Database Queries
7
Different statements
164.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.33 ms (85.14%) |
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 32761 33488 92038 153402 187986 196431 237293 249788 310708 330420 330511 382049 384494 386367 386782 387192 388423 388973 389234 389760 396547 401167 401727 404432 405727 405845 406291 406659 407277 408060 408743 411664 413062 413734 419839 420257 426558 428046 429071 429649 430293 442058 443145 443629 443674 444630 444645 444729 447887 450844 452287 453043 453303 454696 454791 454882 454976 456994 457067 457996 458547 460307 461029 462366 463402 464456 465088 468162 469004 469558 472073 474451 476202 476745 476783 476946 477098 479613 481652 482662 484903 486384 487012 488475 492302 494798 500519 506487 507897 508362 511057 517243 517415 523065 524740 525921 526470 528036 532985 533802 533982 533991 534320 534373 536588 536737 542778 544272 546108 607500 719780 724436 725339 732572 751349 753964 776506 794209 823200 ] |
||||||||||||||||||||||||||||||
|
14.15 ms (8.58%) |
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 544272 732572 388973 420257 444729 453303 463402 532985 776506 751349 153402 384494 534373 476783 492302 506487 488475 794209 724436 330511 386782 389760 430293 443145 444630 474451 406659 405727 404432 452287 607500 443629 476202 481652 447887 487012 507897 536737 533991 524740 542778 469558 472073 508362 511057 525921 469004 484903 528036 465088 753964 442058 454882 458547 428046 494798 401167 413734 408060 479613 468318 468162 477098 405845 546108 719780 401727 386367 249788 330420 32761 387192 396547 500519 460307 407277 196431 408743 823200 476946 486384 457067 461029 517415 725339 429649 388423 92038 517243 444645 526470 534320 533802 536588 523065 454696 382049 533982 237293 187986 310708 33488 389234 406291 411664 413062 419839 426558 429071 443674 457996 462366 450844 454791 454976 456994 464456 476745 482662 453043 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.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 32761 33488 92038 153402 187986 196431 237293 249788 310708 330420 330511 382049 384494 386367 386782 387192 388423 388973 389234 389760 396547 401167 401727 404432 405727 405845 406291 406659 407277 408060 408743 411664 413062 413734 419839 420257 426558 428046 429071 429649 430293 442058 443145 443629 443674 444630 444645 444729 447887 450844 452287 453043 453303 454696 454791 454882 454976 456994 457067 457996 458547 460307 461029 462366 463402 464456 465088 468162 469004 469558 472073 474451 476202 476745 476783 476946 477098 479613 481652 482662 484903 486384 487012 488475 492302 494798 500519 506487 507897 508362 511057 517243 517415 523065 524740 525921 526470 528036 532985 533802 533982 533991 534320 534373 536588 536737 542778 544272 546108 607500 719780 724436 725339 732572 751349 753964 776506 794209 823200 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные white сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge white tits"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"огромные white сиськ"
]
|
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.