Query Metrics
7
Database Queries
7
Different statements
201.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.87 ms (87.94%) |
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 30791 61498 61969 251476 320525 385385 390389 392747 395584 395628 396961 403539 405116 421784 423319 427135 432872 439442 446920 448062 448145 450098 450277 454755 459197 460157 460362 462392 464308 465221 465472 466092 468545 468702 475387 478933 487011 492933 500635 501717 502259 503418 503736 504185 504327 504812 509656 509923 513881 516437 523034 523864 527779 529227 537591 539071 541220 548859 558166 564054 564367 566643 567663 577037 578200 588373 589349 593406 593469 596392 601928 603507 607509 607640 607696 607714 608033 611563 612383 615170 615971 618656 628527 634416 669652 685263 695173 716540 717974 740985 751475 760182 760211 761066 769502 770930 779584 780737 782008 784896 785333 786600 788818 792639 795426 796243 797461 799639 802671 803677 808958 809076 812749 813920 814981 814983 814986 815714 817116 818903 ] |
||||||||||||||||||||||||||||||
|
15.31 ms (7.61%) |
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 459197 468702 460157 541220 446920 454755 251476 395584 30791 403539 817116 475387 566643 578200 669652 786600 740985 796243 751475 802671 392747 502259 465472 529227 564367 607714 607696 466092 320525 61969 421784 423319 450277 615971 795426 784896 797461 788818 427135 395628 504812 396961 405116 814986 814981 814983 509923 516437 523034 537591 548859 567663 695173 577037 634416 596392 603507 612383 601928 607509 785333 809076 799639 760211 782008 812749 760182 761066 769502 608033 780737 432872 450098 504185 492933 504327 385385 61498 439442 813920 818903 513881 539071 685263 593406 611563 618656 588373 628527 803677 808958 792639 770930 717974 779584 390389 815714 448145 462392 468545 558166 589349 593469 465221 564054 478933 448062 503736 503418 527779 716540 607640 464308 487011 500635 523864 615170 460362 501717 509656 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.06%) |
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 30791 61498 61969 251476 320525 385385 390389 392747 395584 395628 396961 403539 405116 421784 423319 427135 432872 439442 446920 448062 448145 450098 450277 454755 459197 460157 460362 462392 464308 465221 465472 466092 468545 468702 475387 478933 487011 492933 500635 501717 502259 503418 503736 504185 504327 504812 509656 509923 513881 516437 523034 523864 527779 529227 537591 539071 541220 548859 558166 564054 564367 566643 567663 577037 578200 588373 589349 593406 593469 596392 601928 603507 607509 607640 607696 607714 608033 611563 612383 615170 615971 618656 628527 634416 669652 685263 695173 716540 717974 740985 751475 760182 760211 761066 769502 770930 779584 780737 782008 784896 785333 786600 788818 792639 795426 796243 797461 799639 802671 803677 808958 809076 812749 813920 814981 814983 814986 815714 817116 818903 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"curvy сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"curvy сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"curvy tits"
]
|
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.