Query Metrics
7
Database Queries
7
Different statements
152.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.28 ms (82.82%) |
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 28568 205809 288045 325867 327170 382245 382282 382971 386904 388150 392508 414043 417600 429755 441749 444246 451780 454752 463661 467722 470910 475394 488841 493578 502596 506697 509248 510553 512066 517365 518495 519325 524345 528719 531280 536978 537237 537604 538971 539235 540931 542131 544587 549609 551525 558235 560835 562502 567757 568581 572333 578459 578774 585945 587066 587330 588191 590176 595037 599345 601176 602068 602595 604301 607394 617322 617672 618460 631870 635279 638113 640131 642908 649601 677180 680284 695042 696291 701970 702863 710050 716697 718841 723988 729012 729862 732939 734927 739135 740048 743959 748002 753146 753963 757287 759749 762337 766283 767516 774862 775976 778281 778716 779288 783445 785343 790883 793487 793596 793914 800394 800903 804024 804550 804866 813361 819442 824706 827924 ] |
||||||||||||||||||||||||||||||
|
16.10 ms (10.56%) |
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 729862 739135 759749 748002 753146 765782 602068 702863 718841 774862 785343 790883 325867 28568 382971 382245 451780 475394 538971 510553 560835 578459 558235 585945 601176 617322 595037 618460 463661 470910 467722 517365 524345 512066 502596 392508 386904 388150 819442 824706 493578 536978 518495 537237 544587 549609 540931 677180 695042 696291 701970 649601 680284 716697 588191 587330 631870 602595 635279 642908 590176 638113 804550 778281 778716 779288 800903 813361 723988 729012 740048 743959 757287 793487 800394 732939 767516 734927 766283 607394 640131 710050 783445 793596 793914 804024 804866 414043 444246 506697 205809 617672 762337 753963 382282 567757 509248 528719 551525 572333 578774 587066 599345 327170 519325 568581 604301 775976 454752 288045 441749 417600 429755 827924 537604 531280 539235 488841 542131 562502 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.76%) |
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 28568 205809 288045 325867 327170 382245 382282 382971 386904 388150 392508 414043 417600 429755 441749 444246 451780 454752 463661 467722 470910 475394 488841 493578 502596 506697 509248 510553 512066 517365 518495 519325 524345 528719 531280 536978 537237 537604 538971 539235 540931 542131 544587 549609 551525 558235 560835 562502 567757 568581 572333 578459 578774 585945 587066 587330 588191 590176 595037 599345 601176 602068 602595 604301 607394 617322 617672 618460 631870 635279 638113 640131 642908 649601 677180 680284 695042 696291 701970 702863 710050 716697 718841 723988 729012 729862 732939 734927 739135 740048 743959 748002 753146 753963 757287 759749 762337 766283 767516 774862 775976 778281 778716 779288 783445 785343 790883 793487 793596 793914 800394 800903 804024 804550 804866 813361 819442 824706 827924 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ridding hard"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"наездниц поз hard"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"наездниц поз hard"
]
|
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.