Query Metrics
7
Database Queries
7
Different statements
190.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.36 ms (84.31%) |
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 27844 391099 410324 437993 457734 461667 465426 466670 470480 485320 487047 489361 489782 501306 506557 511515 511579 513057 514702 518586 519625 520612 523046 523331 526404 526485 526487 530664 531301 532390 533700 533712 534352 534573 535359 535407 536082 536320 538539 540247 543747 546456 548702 550498 552587 555999 563088 567566 568709 572734 575404 576492 577545 581007 582461 584094 592741 593049 597177 606220 606242 606792 607676 612985 614385 619638 626411 630064 631183 631674 634455 647200 651075 661387 661577 664395 667232 673996 695417 695969 696685 698709 721918 733021 734084 734137 739445 748163 757557 759817 760781 762558 768591 768598 774736 780210 785454 789006 793024 797312 799010 799822 800663 802803 804296 804391 813822 818663 819438 820530 821037 825580 828064 828188 828271 828330 ] |
||||||||||||||||||||||||||||||
|
19.62 ms (10.32%) |
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 606792 535359 552587 572734 673996 695969 661387 606220 614385 733021 768591 785454 470480 577545 568709 437993 819438 821037 822935 530664 592741 768598 799010 800663 581007 536320 607676 734137 391099 820530 526485 27844 526404 534573 550498 514702 822787 513057 696685 661577 698709 721918 582461 626411 802803 533712 536082 533700 535407 647200 612985 799822 780210 757557 759817 532390 546456 593049 489361 667232 410324 523331 511579 555999 540247 485320 575404 813822 487047 489782 526487 461667 584094 631674 597177 797312 762558 739445 748163 760781 501306 511515 519625 793024 567566 630064 520612 523046 531301 465426 576492 774736 804391 818663 823697 828396 664395 631183 734084 828271 828188 828064 828330 789006 506557 518586 466670 651075 457734 534352 538539 543747 563088 695417 548702 634455 606242 619638 804296 825580 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.64%) |
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 27844 391099 410324 437993 457734 461667 465426 466670 470480 485320 487047 489361 489782 501306 506557 511515 511579 513057 514702 518586 519625 520612 523046 523331 526404 526485 526487 530664 531301 532390 533700 533712 534352 534573 535359 535407 536082 536320 538539 540247 543747 546456 548702 550498 552587 555999 563088 567566 568709 572734 575404 576492 577545 581007 582461 584094 592741 593049 597177 606220 606242 606792 607676 612985 614385 619638 626411 630064 631183 631674 634455 647200 651075 661387 661577 664395 667232 673996 695417 695969 696685 698709 721918 733021 734084 734137 739445 748163 757557 759817 760781 762558 768591 768598 774736 780210 785454 789006 793024 797312 799010 799822 800663 802803 804296 804391 813822 818663 819438 820530 821037 825580 828064 828188 828271 828330 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits public"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.80%) |
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.