Query Metrics
7
Database Queries
7
Different statements
158.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.35 ms (84.83%) |
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 327170 390497 394120 400166 401229 401235 401621 402342 403600 408293 413083 413091 413097 421155 421917 422299 428124 430377 430839 431022 432834 433070 437583 442204 446706 450847 460658 464661 468629 468843 469061 476559 486023 486533 486539 488073 492331 492333 494797 496118 499333 502306 505816 510074 510466 512843 513707 513728 514042 514589 516791 518312 518927 519929 520696 523352 523779 527000 531072 533959 533965 535010 539501 540207 540549 540972 544269 546425 548848 554899 556662 556664 559008 562376 562884 564378 565626 573214 573749 579284 579371 590735 590961 596488 606791 611345 624288 625649 645917 676591 681293 682181 699536 704522 712564 715662 751498 761375 763845 769490 772612 774406 784913 784943 786455 799073 799188 803062 804247 808869 808871 816723 816993 817004 818608 820335 820337 828439 ] |
||||||||||||||||||||||||||||||
|
14.84 ms (9.37%) |
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 494797 403600 432834 442204 468629 523779 518312 682181 564378 624288 408293 401235 469061 437583 519929 523352 513728 533959 535010 486023 518927 499333 573749 554899 579284 590961 488073 510074 492331 476559 327170 446706 514042 486533 512843 492333 450847 431022 531072 816993 818608 799188 799073 704522 808869 774406 816723 828439 544269 539501 808871 513707 505816 556664 676591 460658 527000 824189 390497 413091 413097 820335 820337 715662 712564 645917 681293 546425 562884 596488 590735 625649 769490 763845 772612 751498 697939 786455 401621 402342 413083 422299 421917 430377 433070 784943 804247 400166 464661 510466 540549 562376 548848 606791 611345 699536 401229 430839 394120 468843 533965 520696 486539 496118 514589 516791 421155 817004 540207 573214 784913 803062 761375 540972 428124 502306 565626 579371 559008 556662 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.68%) |
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 327170 390497 394120 400166 401229 401235 401621 402342 403600 408293 413083 413091 413097 421155 421917 422299 428124 430377 430839 431022 432834 433070 437583 442204 446706 450847 460658 464661 468629 468843 469061 476559 486023 486533 486539 488073 492331 492333 494797 496118 499333 502306 505816 510074 510466 512843 513707 513728 514042 514589 516791 518312 518927 519929 520696 523352 523779 527000 531072 533959 533965 535010 539501 540207 540549 540972 544269 546425 548848 554899 556662 556664 559008 562376 562884 564378 565626 573214 573749 579284 579371 590735 590961 596488 606791 611345 624288 625649 645917 676591 681293 682181 699536 704522 712564 715662 751498 761375 763845 769490 772612 774406 784913 784943 786455 799073 799188 803062 804247 808869 808871 816723 816993 817004 818608 820335 820337 828439 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom dick"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom член"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom член"
]
|
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.