Query Metrics
7
Database Queries
7
Different statements
171.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.94 ms (86.33%) |
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 394134 398331 419275 433928 446669 453508 460112 463239 463661 506507 529115 538420 540111 540612 542174 545662 546871 548355 555471 556424 557262 561523 570134 571364 576579 579589 581980 584106 585588 590002 591863 592546 595666 597218 603887 604390 609986 610614 613383 615408 615471 619900 622446 626823 628507 640392 643178 644124 650271 651220 653065 654397 656252 663831 666452 670253 672824 678209 679879 684893 687040 691706 695571 697521 698252 709146 709363 712201 713002 717206 723591 742591 763060 763481 771389 772809 773761 774494 774803 775112 777342 778093 783478 790437 792420 800978 805189 813613 814219 814281 817248 817325 817971 817993 818759 819389 819704 820213 820362 823588 823614 823946 824018 824045 825357 825588 825890 826243 826298 826530 826640 826975 827589 827844 827994 828443 828764 828788 ] |
||||||||||||||||||||||||||||||
|
13.09 ms (7.64%) |
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 540612 609986 453508 463661 398331 446669 590002 433928 394134 460112 463239 529115 538420 666452 697521 622446 595666 585588 792420 805189 778093 783478 790437 800978 742591 772809 763481 763060 771389 773761 775112 419275 814219 817971 817993 824018 824045 824638 723591 813613 826640 826530 817248 823588 823614 823946 826243 827589 819389 820362 825357 825588 826298 814281 817325 818759 819704 820213 825890 828764 826975 827994 828788 827844 828443 506507 540111 557262 570134 579589 584106 581980 542174 545662 546871 561523 571364 576579 670253 672824 678209 679879 684893 687040 651220 656252 691706 695571 709146 712201 713002 650271 653065 654397 663831 698164 698252 709363 717206 548355 555471 556424 591863 592546 597218 615408 626823 603887 604390 628507 610614 613383 615471 619900 643178 644124 640392 774494 774803 777342 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.55%) |
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 394134 398331 419275 433928 446669 453508 460112 463239 463661 506507 529115 538420 540111 540612 542174 545662 546871 548355 555471 556424 557262 561523 570134 571364 576579 579589 581980 584106 585588 590002 591863 592546 595666 597218 603887 604390 609986 610614 613383 615408 615471 619900 622446 626823 628507 640392 643178 644124 650271 651220 653065 654397 656252 663831 666452 670253 672824 678209 679879 684893 687040 691706 695571 697521 698252 709146 709363 712201 713002 717206 723591 742591 763060 763481 771389 772809 773761 774494 774803 775112 777342 778093 783478 790437 792420 800978 805189 813613 814219 814281 817248 817325 817971 817993 818759 819389 819704 820213 820362 823588 823614 823946 824018 824045 825357 825588 825890 826243 826298 826530 826640 826975 827589 827844 827994 828443 828764 828788 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum pov"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum пов"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum пов"
]
|
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.