Query Metrics
7
Database Queries
7
Different statements
197.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.98 ms (84.54%) |
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 11998 86241 116720 330409 385454 391296 391643 391681 391729 391875 394581 396254 397062 398144 398789 402887 407260 411418 413898 414066 419463 427226 436058 437888 446840 451216 455531 462666 472649 472940 475802 477739 478067 481177 487364 488037 491089 493532 494573 511412 516175 516604 518477 524926 529704 529889 534676 537253 537347 541255 548510 548910 554225 556552 573277 577603 581744 582591 582709 584211 584997 595518 602031 602572 610011 610837 616668 620245 623432 628681 630351 651901 662206 667410 695164 700885 712549 716599 717226 718582 719732 723616 734304 735559 737932 744537 744664 747195 747220 747228 748696 757024 763583 764993 765987 780426 781598 782935 784426 785026 786921 787765 788733 792423 793354 793756 796590 799378 800544 806868 809105 810626 811764 813556 817753 818650 819267 824943 826066 826245 ] |
||||||||||||||||||||||||||||||
|
20.71 ms (10.49%) |
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 582709 784426 786921 747220 748696 799378 826066 396254 813556 451216 695164 610011 628681 785026 413898 516604 537347 737932 630351 436058 493532 391729 398789 511412 757024 806868 391643 472940 478067 116720 826245 481177 781598 793354 735559 602572 462666 723616 529704 554225 719732 747195 747228 455531 800544 391296 427226 437888 414066 817753 819267 472649 529889 573277 548510 782935 809105 811764 764993 86241 11998 494573 516175 744537 581744 541255 577603 556552 792423 602031 534676 477739 475802 712549 488037 398144 717226 700885 763583 744664 524926 397062 584211 394581 391875 491089 620245 584997 487364 662206 623432 411418 419463 780426 616668 810626 610837 796590 734304 582591 446840 518477 537253 595518 787765 793756 716599 718582 407260 391681 788733 765987 402887 385454 330409 818650 824943 548910 651901 667410 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.16%) |
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 11998 86241 116720 330409 385454 391296 391643 391681 391729 391875 394581 396254 397062 398144 398789 402887 407260 411418 413898 414066 419463 427226 436058 437888 446840 451216 455531 462666 472649 472940 475802 477739 478067 481177 487364 488037 491089 493532 494573 511412 516175 516604 518477 524926 529704 529889 534676 537253 537347 541255 548510 548910 554225 556552 573277 577603 581744 582591 582709 584211 584997 595518 602031 602572 610011 610837 616668 620245 623432 628681 630351 651901 662206 667410 695164 700885 712549 716599 717226 718582 719732 723616 734304 735559 737932 744537 744664 747195 747220 747228 748696 757024 763583 764993 765987 780426 781598 782935 784426 785026 786921 787765 788733 792423 793354 793756 796590 799378 800544 806868 809105 810626 811764 813556 817753 818650 819267 824943 826066 826245 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"горловой-минет-от-женыâ…"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"глубокийминет минет оральн секс жен"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.93%) |
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.