Query Metrics
7
Database Queries
7
Different statements
143.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.28 ms (85.21%) |
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 386944 402138 438296 526989 530195 534344 541805 548840 549439 549449 567033 567510 576574 584800 585484 588401 590134 592966 593049 595964 596047 599232 599235 599995 604881 605113 607140 614192 614236 614256 614277 614360 615308 615603 615781 619178 620997 623114 625288 628666 629205 629286 629794 633202 634451 639632 639667 642962 643026 644200 645481 646439 648352 651652 655549 658846 665962 669914 673568 677749 680790 686464 696303 701710 701770 701854 706069 708805 716490 736841 736864 739350 741225 741609 746038 748183 749054 750524 750957 751030 751359 751477 751625 752864 752919 753702 756311 757017 757500 759142 763392 766475 769335 770918 772982 778622 779710 780886 780888 780889 781017 784929 785221 786187 786266 786310 786811 792405 798851 799691 802920 803397 804386 805440 811880 811891 812047 812236 812563 ] |
||||||||||||||||||||||||||||||
|
10.94 ms (7.63%) |
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 645481 646439 651652 658846 673568 680790 686464 696303 655549 665962 701710 716490 549439 549449 567033 567510 576574 590134 615308 629794 634451 592966 593049 614236 614277 623114 625288 644200 588401 604881 605113 614256 619178 639632 585484 595964 596047 599235 614360 620997 628666 643026 781017 784929 798851 799691 780889 785221 792405 804386 812563 741225 750524 750957 751477 770918 786187 786266 802920 805440 812047 736864 741609 748183 757017 757500 763392 766475 769335 772982 736841 751625 752864 751030 751359 753702 749054 752919 756311 759142 615781 629205 629286 633202 639667 701854 708805 778622 780886 780888 786310 786801 786811 803397 402138 534344 386944 438296 526989 530195 541805 584800 706069 648352 669914 677749 701770 548840 599232 607140 599995 614192 615603 642962 811891 811880 739350 746038 779710 812236 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (2.08%) |
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 386944 402138 438296 526989 530195 534344 541805 548840 549439 549449 567033 567510 576574 584800 585484 588401 590134 592966 593049 595964 596047 599232 599235 599995 604881 605113 607140 614192 614236 614256 614277 614360 615308 615603 615781 619178 620997 623114 625288 628666 629205 629286 629794 633202 634451 639632 639667 642962 643026 644200 645481 646439 648352 651652 655549 658846 665962 669914 673568 677749 680790 686464 696303 701710 701770 701854 706069 708805 716490 736841 736864 739350 741225 741609 746038 748183 749054 750524 750957 751030 751359 751477 751625 752864 752919 753702 756311 757017 757500 759142 763392 766475 769335 770918 772982 778622 779710 780886 780888 780889 781017 784929 785221 786187 786266 786310 786811 792405 798851 799691 802920 803397 804386 805440 811880 811891 812047 812236 812563 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public dildo solo"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на улиц дилд соло"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.20%) |
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.