Query Metrics
7
Database Queries
7
Different statements
396.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.84 ms (53.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ден"
]
|
||||||||||||||||||||||||||||||
|
162.84 ms (41.03%) |
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 14225 79570 383045 389307 391045 408639 424535 455675 457408 470951 474412 476993 478709 493392 534855 535868 539204 544757 544869 563124 565546 565629 586349 589457 601021 606020 606648 606773 607200 608006 610538 623929 624055 632664 633049 641048 648077 649207 649598 666813 666955 668788 676446 679082 680390 680779 689833 689847 689849 691871 703506 707560 710497 714548 717009 717065 718742 719302 721898 725005 728558 728987 729115 729132 730112 730489 735437 736659 736918 738583 739682 742169 744522 745300 748266 749269 757705 759823 761126 763499 765947 766387 767223 777315 781356 781569 781801 784017 786414 787136 788367 788943 789129 789316 789981 791637 792367 794187 794343 794378 795864 797858 798667 800496 800548 801835 802353 804266 807425 808572 809370 809912 810812 811235 811666 811716 812716 812793 814670 814909 ] |
||||||||||||||||||||||||||||||
|
13.12 ms (3.31%) |
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 457408 476993 478709 539204 534855 535868 493392 544869 563124 565546 666813 668788 676446 689833 691871 718742 648077 649207 666955 680390 689847 703506 707560 719302 649598 679082 680779 689849 714548 544757 565629 606020 606648 632664 601021 606773 608006 633049 641048 586349 589457 607200 610538 623929 781801 784017 789981 792367 794343 794378 795864 798667 800496 807425 808572 810812 811716 812793 777315 786414 788367 789316 791637 725005 728558 729132 730112 763499 767223 781356 781569 788943 794187 797858 802353 809370 811666 739682 744522 748266 749269 761126 735437 736659 728987 729115 742169 745300 759823 766387 730489 736918 738583 757705 765947 624055 710497 717009 717065 721898 787136 789129 800548 801835 804266 809912 811235 812716 383045 408639 455675 470951 79570 14225 389307 391045 424535 814909 814670 474412 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (0.83%) |
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 14225 79570 383045 389307 391045 408639 424535 455675 457408 470951 474412 476993 478709 493392 534855 535868 539204 544757 544869 563124 565546 565629 586349 589457 601021 606020 606648 606773 607200 608006 610538 623929 624055 632664 633049 641048 648077 649207 649598 666813 666955 668788 676446 679082 680390 680779 689833 689847 689849 691871 703506 707560 710497 714548 717009 717065 718742 719302 721898 725005 728558 728987 729115 729132 730112 730489 735437 736659 736918 738583 739682 742169 744522 745300 748266 749269 757705 759823 761126 763499 765947 766387 767223 777315 781356 781569 781801 784017 786414 787136 788367 788943 789129 789316 789981 791637 792367 794187 794343 794378 795864 797858 798667 800496 800548 801835 802353 804266 807425 808572 809370 809912 810812 811235 811666 811716 812716 812793 814670 814909 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"дену"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.