Query Metrics
7
Database Queries
7
Different statements
188.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.54 ms (87.25%) |
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 210880 385838 401707 402138 404382 459514 477613 483758 496140 500598 501080 505174 523945 526017 526978 529610 529737 530432 532632 533070 533078 533666 534368 535378 536022 540171 541932 543751 549449 549545 550936 553807 554794 557724 567476 575238 577430 579521 580459 585484 590134 591211 592159 596047 602325 605113 612947 614199 616229 617173 628254 629205 630450 633676 633903 634454 634457 634925 635357 637608 638125 639231 644101 647213 651917 655549 661342 666991 671494 674270 679469 680790 689265 690963 692437 695569 696303 698347 700531 700808 704948 707390 708001 709932 710819 712660 714551 714842 750957 791158 793980 795910 795956 798851 798989 799677 799923 800448 800461 800480 802259 804382 809742 809763 811649 812047 814292 814298 817603 817916 818772 819053 819117 819455 819801 823277 825719 827193 827713 828425 ] |
||||||||||||||||||||||||||||||
|
13.11 ms (6.95%) |
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 700531 385838 800448 496140 700808 809742 530432 483758 541932 689265 671494 674270 695569 710819 549545 567476 575238 633676 612947 617173 634925 714551 532632 698347 690963 628254 644101 634457 614199 402138 798989 809763 819801 828425 800461 401707 533070 529737 533078 533666 536022 505174 529610 535378 540171 557724 579521 580459 543751 647213 679469 707390 680790 696303 655549 549449 590134 602325 605113 634454 585484 596047 750957 616229 629205 637608 819455 477613 814298 500598 793980 802259 818772 800480 804382 819053 827193 791158 210880 817603 817916 825719 526017 523945 811649 814292 819117 827713 823277 798851 799923 795910 812047 795956 799677 714842 591211 501080 692437 526978 635357 404382 709932 577430 630450 550936 712660 708001 592159 554794 651917 661342 666991 633903 638125 534368 553807 639231 704948 459514 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (1.75%) |
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 210880 385838 401707 402138 404382 459514 477613 483758 496140 500598 501080 505174 523945 526017 526978 529610 529737 530432 532632 533070 533078 533666 534368 535378 536022 540171 541932 543751 549449 549545 550936 553807 554794 557724 567476 575238 577430 579521 580459 585484 590134 591211 592159 596047 602325 605113 612947 614199 616229 617173 628254 629205 630450 633676 633903 634454 634457 634925 635357 637608 638125 639231 644101 647213 651917 655549 661342 666991 671494 674270 679469 680790 689265 690963 692437 695569 696303 698347 700531 700808 704948 707390 708001 709932 710819 712660 714551 714842 750957 791158 793980 795910 795956 798851 798989 799677 799923 800448 800461 800480 802259 804382 809742 809763 811649 812047 814292 814298 817603 817916 818772 819053 819117 819455 819801 823277 825719 827193 827713 828425 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public sex amateur"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц секс любительск"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.86%) |
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.