Query Metrics
7
Database Queries
7
Different statements
448.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
219.96 ms (49.03%) |
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 414135 424197 434334 441110 452302 463792 468017 476112 477597 478702 493304 495407 501073 506705 511799 513503 518486 531983 533714 543267 544587 548074 550276 552532 555106 556876 558170 564578 590193 590261 593023 603113 603589 609823 610058 613715 622922 624860 625818 630797 647797 693987 696599 698820 710678 716916 718854 721141 724735 725241 726326 726912 729230 730105 731821 731916 732556 732815 732979 736581 744240 744376 744529 748198 749743 750021 750235 750821 754588 757655 758700 759029 759794 759907 760879 764048 766451 768463 771919 776584 779781 780048 783116 786168 787101 787392 787622 787909 789216 789348 790855 793526 794119 794476 794554 794721 795180 798746 800101 808096 808426 809412 812639 815452 815808 815844 817206 817515 817551 817675 818500 820014 820055 820060 825087 826788 827264 ] |
||||||||||||||||||||||||||||||
|
207.12 ms (46.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother hard"
]
|
||||||||||||||||||||||||||||||
|
13.11 ms (2.92%) |
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 817551 817675 825087 826788 827264 817515 820055 822900 817206 818500 531983 533714 511799 495407 548074 552532 558170 543267 647797 693987 718854 710678 698820 590193 613715 624860 630797 622922 779781 787392 794476 798746 808096 789348 793526 794554 726326 730105 754588 759029 766451 787622 794119 808426 736581 750821 758700 759794 732815 764048 768463 771919 729230 744529 760879 724735 732979 744376 749743 750235 716916 794721 441110 414135 478702 476112 477597 556876 609823 434334 463792 424197 493304 506705 468017 555106 452302 518486 513503 815808 815844 820014 815182 815452 820060 501073 544587 564578 550276 696599 590261 593023 625818 603113 603589 776584 780048 809412 812639 789216 725241 744240 748198 783116 786168 787101 795180 800101 726912 731821 734834 731916 732556 759907 750021 757655 610058 721141 787909 790855 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (0.60%) |
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 414135 424197 434334 441110 452302 463792 468017 476112 477597 478702 493304 495407 501073 506705 511799 513503 518486 531983 533714 543267 544587 548074 550276 552532 555106 556876 558170 564578 590193 590261 593023 603113 603589 609823 610058 613715 622922 624860 625818 630797 647797 693987 696599 698820 710678 716916 718854 721141 724735 725241 726326 726912 729230 730105 731821 731916 732556 732815 732979 736581 744240 744376 744529 748198 749743 750021 750235 750821 754588 757655 758700 759029 759794 759907 760879 764048 766451 768463 771919 776584 779781 780048 783116 786168 787101 787392 787622 787909 789216 789348 790855 793526 794119 794476 794554 794721 795180 798746 800101 808096 808426 809412 812639 815452 815808 815844 817206 817515 817551 817675 818500 820014 820055 820060 825087 826788 827264 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин hard"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.39%) |
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.