Query Metrics
7
Database Queries
7
Different statements
401.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.40 ms (52.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"husband friend жен"
]
|
||||||||||||||||||||||||||||||
|
168.05 ms (41.84%) |
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 385285 392109 419462 427441 437618 441197 447732 454398 459305 474831 479378 479394 484352 485611 490287 496543 509052 511172 517607 518952 528920 536959 543381 545014 551095 556685 556993 559572 568594 572224 574978 575687 577155 577213 579332 579403 579557 579813 579853 583467 588142 588781 590898 592708 603169 603265 604243 605454 610510 623221 625713 628718 635789 640105 644102 648672 649093 650867 653896 654224 666457 667057 668072 672281 675345 687362 688567 689061 695839 697223 700902 702275 704314 707144 710274 712959 715410 720163 721156 728686 730928 731195 732604 732819 733241 733451 736169 737465 739956 741076 744368 745510 753255 756755 757866 761670 766702 767874 771069 778701 785142 787102 791174 793877 795332 795779 795827 795843 796497 797878 802488 803248 803590 805339 807544 809991 824420 ] |
||||||||||||||||||||||||||||||
|
16.80 ms (4.18%) |
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 688567 667057 644102 695839 697223 795779 809991 791174 447732 485611 545014 556685 592708 796497 797878 795843 757866 739943 730928 715410 712959 579853 628718 700902 728686 672281 689061 707144 648672 753255 484352 518952 702275 736169 764584 771069 795332 635789 803590 787102 479378 579813 583467 720163 732819 756755 704314 795827 739956 603265 668072 650867 710274 805339 733241 807544 623221 761670 721156 392109 824420 536959 511172 543381 675345 610510 785142 732604 741076 577213 737465 427441 459305 528920 579332 556993 588142 604243 605454 802488 441197 766702 385285 579557 654224 744368 517607 579403 574978 649093 572224 577155 603169 803248 731195 437618 509052 778701 767874 745510 419462 496543 474831 568594 575687 675594 687362 666457 588781 625713 479394 454398 490287 559572 551095 653896 590898 640105 793877 733451 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (0.59%) |
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 385285 392109 419462 427441 437618 441197 447732 454398 459305 474831 479378 479394 484352 485611 490287 496543 509052 511172 517607 518952 528920 536959 543381 545014 551095 556685 556993 559572 568594 572224 574978 575687 577155 577213 579332 579403 579557 579813 579853 583467 588142 588781 590898 592708 603169 603265 604243 605454 610510 623221 625713 628718 635789 640105 644102 648672 649093 650867 653896 654224 666457 667057 668072 672281 675345 687362 688567 689061 695839 697223 700902 702275 704314 707144 710274 712959 715410 720163 721156 728686 730928 731195 732604 732819 733241 733451 736169 737465 739956 741076 744368 745510 753255 756755 757866 761670 766702 767874 771069 778701 785142 787102 791174 793877 795332 795779 795827 795843 796497 797878 802488 803248 803590 805339 807544 809991 824420 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"husband friend wife"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"husband friend жен"
]
|
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.