Query Metrics
7
Database Queries
7
Different statements
168.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.59 ms (87.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 65811 298293 398225 398496 404117 448044 454332 462070 463115 468985 488833 495382 506978 507009 516064 529731 534668 534677 540679 541459 541805 542179 549279 552277 555076 555436 555619 565801 567130 568663 572050 581041 584269 584400 584800 592424 602222 604641 612471 613579 618967 625819 627835 634745 636172 638958 641924 648045 648352 649082 649905 651725 658469 665077 666131 667325 684574 686076 690410 692122 698375 701204 712123 715166 715668 718015 721178 721938 722192 723206 727527 727537 732827 734120 734397 736074 736327 736489 736535 738604 740806 743260 745867 745991 751743 754214 757345 764864 768471 768503 770633 772342 780702 783770 784258 785136 787163 791310 792372 792456 795952 798541 799524 804391 804424 809481 809945 812522 817554 819027 819076 819118 819424 819507 822480 824886 825919 826736 827351 828215 ] |
||||||||||||||||||||||||||||||
|
12.33 ms (7.32%) |
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 555619 584400 804424 812522 743260 649905 721938 463115 613579 618967 809945 462070 684574 404117 581041 658469 398225 495382 534677 718015 565801 634745 627835 780702 792372 754214 736535 738604 768503 772342 736074 625819 785136 65811 817554 819076 826736 819027 827351 822480 819118 819424 819507 824886 828215 825919 540679 555436 552277 541459 666131 692122 572050 584269 636172 592424 795952 784258 791310 745991 732827 736327 745867 751743 740806 715166 721178 783770 298293 516064 529731 534668 549279 648045 665077 715668 612471 641924 787163 798541 768471 727527 727537 804391 506978 667325 723206 448044 507009 568663 701204 736489 468985 454332 555076 712123 722192 398496 734120 686076 649082 698375 638958 770633 734397 757345 799524 809481 690410 567130 488833 541805 542179 584800 651725 648352 602222 604641 764864 792456 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (1.99%) |
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 65811 298293 398225 398496 404117 448044 454332 462070 463115 468985 488833 495382 506978 507009 516064 529731 534668 534677 540679 541459 541805 542179 549279 552277 555076 555436 555619 565801 567130 568663 572050 581041 584269 584400 584800 592424 602222 604641 612471 613579 618967 625819 627835 634745 636172 638958 641924 648045 648352 649082 649905 651725 658469 665077 666131 667325 684574 686076 690410 692122 698375 701204 712123 715166 715668 718015 721178 721938 722192 723206 727527 727537 732827 734120 734397 736074 736327 736489 736535 738604 740806 743260 745867 745991 751743 754214 757345 764864 768471 768503 770633 772342 780702 783770 784258 785136 787163 791310 792372 792456 795952 798541 799524 804391 804424 809481 809945 812522 817554 819027 819076 819118 819424 819507 822480 824886 825919 826736 827351 828215 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy public"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.23 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy на улиц"
]
|
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.