Query Metrics
7
Database Queries
7
Different statements
131.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.04 ms (87.48%) |
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 2808 387097 391554 400342 401575 426784 438314 459665 463255 466338 470690 473962 477144 477970 478348 486118 487246 497341 510390 542259 544018 547683 548016 549642 551157 557506 558476 559467 575223 581549 581554 590471 618196 619908 629480 637454 666491 667984 669244 669867 669894 669902 672789 673033 695840 697900 705769 705784 716023 719475 719484 719881 723024 730987 732830 732956 733334 733773 734129 734269 739360 739585 741823 742295 743898 747423 748536 749870 751604 759068 759377 761394 761403 762084 766282 766329 766981 767776 768002 768329 768491 769131 769188 780193 782358 784312 789385 790258 791915 793067 794031 794709 795337 795361 797258 799748 800840 801429 801433 801451 801505 801783 802092 802279 809672 811783 811819 811831 812088 816163 817737 818135 819358 820323 823588 824803 824850 825610 825797 ] |
||||||||||||||||||||||||||||||
|
7.86 ms (5.98%) |
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 619908 816163 825610 544018 549642 669902 672789 669867 581549 794709 799748 780193 795361 733334 733773 734269 742295 743898 747423 761394 769131 789385 812088 732830 759068 761403 759377 768329 748536 766282 768002 779805 793067 801429 811831 486118 473962 470690 819358 824850 825797 497341 551157 719475 719484 795337 801433 782358 790258 797258 800840 802092 802279 811819 741823 751604 766981 784312 794031 762084 766329 767776 739585 723024 801451 801505 400342 459665 463255 559467 705784 478348 809672 791915 739360 705769 629480 618196 466338 768491 547683 769188 426784 732956 801783 811783 749870 730987 391554 581554 667984 669244 669894 695840 548016 575223 590471 697900 510390 734129 637454 387097 558476 487246 401575 477970 2808 438314 824803 818135 823588 817737 820323 477144 542259 557506 673033 716023 719881 666491 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.60%) |
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 2808 387097 391554 400342 401575 426784 438314 459665 463255 466338 470690 473962 477144 477970 478348 486118 487246 497341 510390 542259 544018 547683 548016 549642 551157 557506 558476 559467 575223 581549 581554 590471 618196 619908 629480 637454 666491 667984 669244 669867 669894 669902 672789 673033 695840 697900 705769 705784 716023 719475 719484 719881 723024 730987 732830 732956 733334 733773 734129 734269 739360 739585 741823 742295 743898 747423 748536 749870 751604 759068 759377 761394 761403 762084 766282 766329 766981 767776 768002 768329 768491 769131 769188 780193 782358 784312 789385 790258 791915 793067 794031 794709 795337 795361 797258 799748 800840 801429 801433 801451 801505 801783 802092 802279 809672 811783 811819 811831 812088 816163 817737 818135 819358 820323 823588 824803 824850 825610 825797 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"домашнее русская жена…"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск русск жен"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (1.01%) |
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.