Query Metrics
7
Database Queries
7
Different statements
159.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.79 ms (85.50%) |
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 474789 490169 516985 518956 535258 539965 541175 542344 543176 549965 557139 560150 568716 570170 570875 578002 582419 591120 596128 601757 601860 603113 603383 605262 605265 609206 610580 611343 615352 615395 617677 632929 635721 636119 637454 638956 640682 643405 644016 653902 669874 676581 699764 714408 717003 717225 721782 723098 724122 725635 726113 726667 735436 740457 745036 748509 751200 751593 752194 752915 753573 753673 755474 755495 757525 759611 760148 760158 760816 762062 762621 763874 767759 769401 770137 770234 771358 771683 771944 777654 781835 784235 784587 785157 785688 785750 785756 788121 788684 789216 792132 793486 794272 797700 800680 800684 801346 801617 802034 802718 802856 804969 805584 806096 807210 811484 812639 813412 815496 816066 816718 819779 820113 820392 821156 821268 821379 822229 823163 823557 ] |
||||||||||||||||||||||||||||||
|
12.68 ms (7.93%) |
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 819779 821268 823557 815496 816066 820392 823163 816718 820113 821156 821379 822229 539965 535258 516985 518956 474789 490169 549965 560150 570875 578002 582419 542344 543176 570170 541175 557139 669874 714408 653902 676581 699764 717003 568716 591120 603383 596128 605262 611343 615395 601860 609206 635721 636119 643405 603113 605265 617677 637454 644016 777654 781835 785157 785750 792132 793486 800680 802718 812639 813412 785688 785756 789216 794272 801346 801617 802856 806096 745036 752915 760158 771944 784235 797700 800684 802034 804969 805584 807210 811484 724122 740457 748509 752194 760148 762062 763874 767759 753573 755495 760816 770137 770234 771358 725635 735436 751593 753673 757525 759611 726113 726667 751200 755474 762621 769401 771683 601757 610580 615352 632929 638956 640682 717225 721782 723098 784587 788121 788684 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (1.90%) |
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 474789 490169 516985 518956 535258 539965 541175 542344 543176 549965 557139 560150 568716 570170 570875 578002 582419 591120 596128 601757 601860 603113 603383 605262 605265 609206 610580 611343 615352 615395 617677 632929 635721 636119 637454 638956 640682 643405 644016 653902 669874 676581 699764 714408 717003 717225 721782 723098 724122 725635 726113 726667 735436 740457 745036 748509 751200 751593 752194 752915 753573 753673 755474 755495 757525 759611 760148 760158 760816 762062 762621 763874 767759 769401 770137 770234 771358 771683 771944 777654 781835 784235 784587 785157 785688 785750 785756 788121 788684 789216 792132 793486 794272 797700 800680 800684 801346 801617 802034 802718 802856 804969 805584 806096 807210 811484 812639 813412 815496 816066 816718 819779 820113 820392 821156 821268 821379 822229 823163 823557 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom panties"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.