Query Metrics
7
Database Queries
7
Different statements
154.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.85 ms (84.57%) |
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 16870 39532 53932 70359 81412 81571 97191 163536 185820 188437 234067 308328 311176 325253 383715 397106 397495 397631 398017 401641 402949 406282 424263 425157 427033 445831 478653 487458 488017 488565 494312 496059 498217 500998 504895 505936 510565 516000 523032 524965 535575 535808 535920 544258 548267 554875 563962 573506 577314 583170 585599 588172 592834 595751 596559 601828 601900 605794 608106 617030 618289 621360 622872 633649 648347 662776 666899 679578 697613 714360 717247 718533 719127 719284 719452 723156 724874 729255 729441 730165 731125 731277 731429 733447 735534 735890 739253 739981 746725 753641 762499 763002 767633 767801 768151 768974 769221 772353 777175 777817 777961 777993 779781 779923 781034 782359 782613 782691 787222 787236 787258 787392 790594 790705 792355 793793 794784 796040 799711 810216 ] |
||||||||||||||||||||||||||||||
|
12.43 ms (8.03%) |
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 397631 516000 308328 719127 510565 524965 595751 445831 188437 425157 397495 16870 397106 544258 779923 794784 724874 753641 729255 768151 777817 97191 70359 81571 488565 505936 554875 563962 679578 718533 719284 723156 777993 779781 787392 781034 739253 746725 782691 787258 790705 731277 768974 769221 739981 735534 735890 763002 767801 731429 633649 714360 777961 787222 790594 810216 398017 424263 81412 772353 605794 504895 601900 163536 427033 618289 535575 717247 487458 53932 592834 311176 185820 401641 500998 548267 777175 535808 406282 535920 496059 583170 608106 39532 782359 488017 793793 730165 733447 731125 577314 799711 325253 622872 729441 662776 596559 617030 621360 383715 402949 498217 719452 588172 585599 792355 782613 796040 762499 767633 787236 697613 234067 573506 648347 523032 494312 666899 601828 478653 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (2.12%) |
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 16870 39532 53932 70359 81412 81571 97191 163536 185820 188437 234067 308328 311176 325253 383715 397106 397495 397631 398017 401641 402949 406282 424263 425157 427033 445831 478653 487458 488017 488565 494312 496059 498217 500998 504895 505936 510565 516000 523032 524965 535575 535808 535920 544258 548267 554875 563962 573506 577314 583170 585599 588172 592834 595751 596559 601828 601900 605794 608106 617030 618289 621360 622872 633649 648347 662776 666899 679578 697613 714360 717247 718533 719127 719284 719452 723156 724874 729255 729441 730165 731125 731277 731429 733447 735534 735890 739253 739981 746725 753641 762499 763002 767633 767801 768151 768974 769221 772353 777175 777817 777961 777993 779781 779923 781034 782359 782613 782691 787222 787236 787258 787392 790594 790705 792355 793793 794784 796040 799711 810216 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"камшот кончают в ротиÐ…"
]
|
||||||||||||||||||||||||||||||
|
2.19 ms (1.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм сперм в рот"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.13%) |
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.