Query Metrics
7
Database Queries
7
Different statements
166.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.48 ms (85.37%) |
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 408716 413335 421392 436539 439470 441918 442057 442472 443936 492457 496247 498849 502036 504866 505062 507097 507141 508759 547408 555148 564669 567270 567650 571959 575373 581585 585168 585260 585319 590238 592132 599318 601955 606421 606429 606978 612100 618515 622679 627493 631224 631858 637262 640334 640610 656282 665989 668026 672213 676430 693789 703935 705724 707416 707766 709690 712755 716193 719967 727230 727388 727453 727507 727580 728667 729993 730604 732226 732655 735022 736467 737614 738914 743731 754145 756670 757460 759128 763934 764057 765328 765850 767735 769273 775160 781222 782104 783379 783826 783858 783963 784599 788410 790300 792308 792430 792754 794039 795085 795095 796770 797741 797898 798840 798893 802958 806237 809673 810433 812640 814184 816836 818961 819675 819950 823828 824867 825934 826387 ] |
||||||||||||||||||||||||||||||
|
13.58 ms (8.14%) |
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 436539 729993 703935 819675 585168 797898 792754 408716 825934 571959 498849 802958 754145 727230 730604 504866 439470 442472 421392 441918 819950 826387 814184 816836 824867 823828 492457 507097 507141 502036 547408 581585 656282 668026 693789 665989 707416 672213 709690 555148 564669 567270 567650 585260 585319 592132 606421 606429 631858 640334 637262 599318 640610 618515 627493 631224 781222 783858 783963 788410 795085 795095 806237 796770 737614 743731 765328 765850 769273 783379 792430 797741 798840 798893 810433 727453 767735 727388 727507 727580 736467 764057 732226 732655 756670 757460 735022 759128 763934 601955 606978 612100 622679 705724 707766 716193 719967 775160 782104 783826 784599 790300 792308 794039 809673 812640 505062 508759 413335 443936 818961 575373 712755 676430 590238 728667 738914 728648 442057 496247 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (1.92%) |
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 408716 413335 421392 436539 439470 441918 442057 442472 443936 492457 496247 498849 502036 504866 505062 507097 507141 508759 547408 555148 564669 567270 567650 571959 575373 581585 585168 585260 585319 590238 592132 599318 601955 606421 606429 606978 612100 618515 622679 627493 631224 631858 637262 640334 640610 656282 665989 668026 672213 676430 693789 703935 705724 707416 707766 709690 712755 716193 719967 727230 727388 727453 727507 727580 728667 729993 730604 732226 732655 735022 736467 737614 738914 743731 754145 756670 757460 759128 763934 764057 765328 765850 767735 769273 775160 781222 782104 783379 783826 783858 783963 784599 788410 790300 792308 792430 792754 794039 795085 795095 796770 797741 797898 798840 798893 802958 806237 809673 810433 812640 814184 816836 818961 819675 819950 823828 824867 825934 826387 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"morning wife"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"morning жен"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"morning жен"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.03%) |
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.