Query Metrics
7
Database Queries
7
Different statements
170.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.84 ms (85.50%) |
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 396740 422415 426875 442157 443578 460360 470993 476154 480992 486480 487297 488510 490645 492012 495765 496255 496458 500280 505096 505366 505889 506510 508759 510224 512940 517222 518801 519774 522462 523791 524218 527959 528379 529191 530458 536914 538514 543318 547519 547579 548445 550761 551972 554307 554571 555026 556115 556345 556921 557377 559077 559308 559315 562381 563490 563624 566331 568292 569283 575827 577038 578293 578319 579856 579964 580103 581182 581254 581465 581995 582573 583298 583435 583518 583689 583801 584046 584099 584138 584151 584406 586218 588665 610433 618217 622508 628496 634949 647026 648370 649013 650079 650308 652886 660030 663852 664280 664723 666706 666716 666935 667352 674132 674271 675705 676741 678344 684845 688188 708330 723940 749758 754072 760265 768855 771460 778242 794401 801307 807853 ] |
||||||||||||||||||||||||||||||
|
13.11 ms (7.69%) |
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 470993 422415 426875 460360 486480 508759 568292 676741 678344 650079 622508 778242 771460 807853 760265 768855 801307 524218 708330 649013 674271 628496 634949 588665 610433 794401 749758 754072 723940 618217 396740 442157 443578 490645 480992 488510 487297 495765 505096 505366 510224 518801 536914 538514 496255 517222 523791 530458 496458 505889 506510 519774 522462 528379 500280 512940 527959 529191 476154 492012 543318 547519 548445 554307 555026 556345 559077 559315 562381 566331 575827 577038 579856 581465 581995 582573 583298 583518 583689 584046 547579 551972 559308 569283 581254 584099 584151 584406 554571 556115 556921 557377 563490 581182 583435 584138 647026 648370 652886 660030 664723 666706 666716 684845 663852 674132 675705 650308 664280 666935 667352 688188 550761 563624 578293 578319 579964 580103 583801 586218 ] |
||||||||||||||||||||||||||||||
|
3.83 ms (2.24%) |
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 396740 422415 426875 442157 443578 460360 470993 476154 480992 486480 487297 488510 490645 492012 495765 496255 496458 500280 505096 505366 505889 506510 508759 510224 512940 517222 518801 519774 522462 523791 524218 527959 528379 529191 530458 536914 538514 543318 547519 547579 548445 550761 551972 554307 554571 555026 556115 556345 556921 557377 559077 559308 559315 562381 563490 563624 566331 568292 569283 575827 577038 578293 578319 579856 579964 580103 581182 581254 581465 581995 582573 583298 583435 583518 583689 583801 584046 584099 584138 584151 584406 586218 588665 610433 618217 622508 628496 634949 647026 648370 649013 650079 650308 652886 660030 663852 664280 664723 666706 666716 666935 667352 674132 674271 675705 676741 678344 684845 688188 708330 723940 749758 754072 760265 768855 771460 778242 794401 801307 807853 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.72%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"киску"
]
|
||||||||||||||||||||||||||||||
|
1.48 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.