Query Metrics
7
Database Queries
7
Different statements
237.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.07 ms (90.01%) |
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 386344 388630 392097 392721 457381 468340 492038 507490 537215 538329 541050 543925 546281 548020 550283 551811 556685 566418 571744 577084 579853 585246 588019 588121 588162 589307 591151 592379 592708 592924 593645 599151 603173 604452 607639 611443 616186 618039 619084 626814 631869 635830 636510 638430 640727 642288 644102 645046 648984 653619 653863 665313 665966 665970 671692 675193 675509 675551 679660 688567 689061 690654 693273 697208 697607 701178 702054 704673 705083 705111 705409 707144 711103 712501 712959 713641 715410 718448 720084 721887 724184 728365 728642 730153 731382 732652 733963 735207 739724 742101 744381 745954 748371 749940 754138 756724 763503 764125 766762 769304 778718 783664 783677 783843 784090 791305 791968 792277 794786 795752 801074 801095 801312 816761 819503 824477 824998 827958 ] |
||||||||||||||||||||||||||||||
|
13.92 ms (5.85%) |
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 457381 577084 638430 635830 792277 592379 801095 701178 492038 648984 733963 543925 640727 571744 579853 731382 386344 690654 697607 642288 778718 756724 392721 704673 705111 588019 644102 589307 742101 720084 645046 697208 548020 611443 730153 748371 795752 827958 538329 791968 592708 732652 715410 712959 599151 675193 388630 550283 675509 665966 688567 607639 728642 739724 766762 783664 689061 705083 653619 705409 824550 537215 653863 693273 718448 675551 713641 591151 604452 745954 556685 794786 728365 626814 636510 566418 679660 712501 551811 588121 592924 593645 735207 754138 769304 783677 749940 764125 711103 801074 824998 824477 468340 507490 541050 671692 665970 702054 721887 546281 616186 603173 588162 618039 619084 783843 791305 801312 763503 724184 631869 776114 784090 816761 819503 665313 392097 707144 585246 744381 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (1.28%) |
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 386344 388630 392097 392721 457381 468340 492038 507490 537215 538329 541050 543925 546281 548020 550283 551811 556685 566418 571744 577084 579853 585246 588019 588121 588162 589307 591151 592379 592708 592924 593645 599151 603173 604452 607639 611443 616186 618039 619084 626814 631869 635830 636510 638430 640727 642288 644102 645046 648984 653619 653863 665313 665966 665970 671692 675193 675509 675551 679660 688567 689061 690654 693273 697208 697607 701178 702054 704673 705083 705111 705409 707144 711103 712501 712959 713641 715410 718448 720084 721887 724184 728365 728642 730153 731382 732652 733963 735207 739724 742101 744381 745954 748371 749940 754138 756724 763503 764125 766762 769304 778718 783664 783677 783843 784090 791305 791968 792277 794786 795752 801074 801095 801312 816761 819503 824477 824998 827958 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck friend wife"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс friend жен"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.69%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс 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.