Query Metrics
7
Database Queries
7
Different statements
193.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.49 ms (87.42%) |
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 416857 420903 424147 429550 440532 443727 446739 448674 454398 456448 456915 458394 462711 466943 469766 472787 477185 477460 483401 487534 492108 493268 494857 499984 501901 504686 504756 506702 509052 511543 512558 513775 517631 518499 522768 523251 523537 525277 525343 528682 529381 530065 537481 543507 545057 545187 562014 562015 562409 565526 566187 568185 569077 569978 572263 574975 575687 575693 577210 577213 578433 578571 581998 582572 585307 588018 588128 589598 590975 593815 593860 599525 607343 607391 607412 609531 610805 610819 612387 613873 615322 617434 622785 648657 650847 654224 661955 666008 717167 718376 718885 719350 720350 723986 724305 731323 732266 732697 732743 733050 742662 742663 751026 755011 757638 771795 773946 788209 791943 794166 794622 802104 803708 808654 809880 810902 812448 814790 824996 ] |
||||||||||||||||||||||||||||||
|
13.57 ms (7.00%) |
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 732266 771795 607412 615322 454398 446739 462711 522768 578433 617434 477460 523251 569077 574975 577213 588018 607391 812448 803708 742662 794166 808654 424147 504686 609531 440532 458394 466943 494857 593860 523537 518499 545187 566187 802104 757638 416857 469766 528682 593815 448674 810902 456915 568185 575693 666008 650847 742663 499984 575687 562015 543507 675594 717167 720350 654224 562409 578571 581998 588128 794622 590975 443727 501901 814790 493268 529381 569978 513775 477185 483401 506702 511543 719350 809880 429550 420903 504756 622785 791943 565526 492108 530065 517631 509052 537481 572263 589598 788209 512558 472787 610819 732743 610805 724305 599525 607343 733050 824996 487534 582572 545057 661955 731323 723986 732697 456448 525277 525343 562014 577210 648657 718376 612387 613873 585307 751026 773946 755011 718885 ] |
||||||||||||||||||||||||||||||
|
4.30 ms (2.22%) |
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 416857 420903 424147 429550 440532 443727 446739 448674 454398 456448 456915 458394 462711 466943 469766 472787 477185 477460 483401 487534 492108 493268 494857 499984 501901 504686 504756 506702 509052 511543 512558 513775 517631 518499 522768 523251 523537 525277 525343 528682 529381 530065 537481 543507 545057 545187 562014 562015 562409 565526 566187 568185 569077 569978 572263 574975 575687 575693 577210 577213 578433 578571 581998 582572 585307 588018 588128 589598 590975 593815 593860 599525 607343 607391 607412 609531 610805 610819 612387 613873 615322 617434 622785 648657 650847 654224 661955 666008 717167 718376 718885 719350 720350 723986 724305 731323 732266 732697 732743 733050 742662 742663 751026 755011 757638 771795 773946 788209 791943 794166 794622 802104 803708 808654 809880 810902 812448 814790 824996 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck friend mother"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс friend мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс friend мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.