Query Metrics
7
Database Queries
7
Different statements
167.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.01 ms (88.72%) |
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 470592 495020 522531 525423 535635 535637 538032 539367 539613 539914 540962 543668 546732 554364 581220 586507 587546 592661 595963 599233 599294 600010 602355 602491 602685 607435 608232 609194 610118 611694 615994 616446 618980 619673 622240 622279 623972 624922 625092 625760 625978 626192 627663 628130 629518 630661 631322 631350 632483 633690 636114 636400 638439 638954 641125 643644 658496 660248 670738 678261 678465 680370 685317 687443 689219 691405 698340 698481 698811 698914 701202 702340 705485 706597 707069 712642 713414 716311 717806 718614 728611 730832 730966 730984 731155 731913 734308 735270 735917 736580 736939 737859 738721 739303 743478 743501 745198 747751 748983 750238 751962 755143 757227 759032 760251 764501 766142 768751 775133 778454 778477 779195 799726 801664 805246 809965 828231 ] |
||||||||||||||||||||||||||||||
|
9.27 ms (5.52%) |
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 622279 626192 629518 632483 633690 586507 587546 607435 608232 615994 618980 636114 636400 595963 599294 611694 616446 627663 638954 641125 619673 643644 778477 805246 780455 801664 730832 730966 735270 736580 750238 757227 728611 730984 734308 736939 737859 739303 743478 743501 751962 745198 747751 764501 731913 735917 748983 755143 731155 738721 766142 610118 628130 630661 631322 631350 698811 701202 702340 705485 712642 713414 716311 717806 775133 778454 779195 470592 685317 718614 638439 706597 525423 535635 535637 687443 602491 824820 689219 539914 543668 707069 691405 680370 625092 625978 799726 760251 609194 698481 698914 623972 539367 538032 540962 678465 581220 592661 600010 599233 602355 660248 678261 622240 495020 670738 554364 759032 698340 546732 624922 768751 539613 658496 673919 625760 602685 809965 828231 522531 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.62%) |
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 470592 495020 522531 525423 535635 535637 538032 539367 539613 539914 540962 543668 546732 554364 581220 586507 587546 592661 595963 599233 599294 600010 602355 602491 602685 607435 608232 609194 610118 611694 615994 616446 618980 619673 622240 622279 623972 624922 625092 625760 625978 626192 627663 628130 629518 630661 631322 631350 632483 633690 636114 636400 638439 638954 641125 643644 658496 660248 670738 678261 678465 680370 685317 687443 689219 691405 698340 698481 698811 698914 701202 702340 705485 706597 707069 712642 713414 716311 717806 718614 728611 730832 730966 730984 731155 731913 734308 735270 735917 736580 736939 737859 738721 739303 743478 743501 745198 747751 748983 750238 751962 755143 757227 759032 760251 764501 766142 768751 775133 778454 778477 779195 799726 801664 805246 809965 828231 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"любители-любители"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск любительск"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.94%) |
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.