Query Metrics
7
Database Queries
7
Different statements
185.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.00 ms (85.84%) |
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 150798 236724 384581 389729 391692 391959 392952 393072 403911 415790 439439 439574 439651 439746 439806 440726 441000 442545 444361 450368 451495 457438 457467 459638 459647 460411 462348 463991 465892 466020 466228 467930 468341 468359 468373 475883 478002 478420 479049 486341 490846 495813 505725 509192 516469 518919 523845 524779 526526 531866 534559 535452 539741 547236 549088 549221 552285 555093 555103 555231 555242 555337 555359 561526 563642 564291 564295 566770 566777 572669 573303 576493 605136 610033 618468 620226 623211 624837 661593 665960 665972 668677 669010 669072 709545 710455 712563 714618 714895 719929 724729 725030 728170 728366 730315 735023 742729 743015 745952 756683 757277 759921 759941 760973 761018 763547 765699 766647 773271 792643 796157 800796 801259 803537 804524 824483 826246 827326 827484 827973 ] |
||||||||||||||||||||||||||||||
|
15.44 ms (8.34%) |
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 730315 150798 478002 524779 669072 451495 460411 623211 661593 665960 403911 439806 495813 439574 465892 486341 827973 555093 555103 709545 719929 804524 441000 516469 563642 466228 475883 439746 389729 518919 564295 576493 665972 792643 728366 745952 714618 459647 393072 467930 561526 442545 457467 444361 457438 535452 826246 757277 463991 531866 534559 564291 669010 668677 710455 549088 620226 618468 742729 756683 761018 765699 773271 728170 415790 490846 555231 549221 450368 523845 526526 440726 439651 555242 801259 610033 827326 468373 760973 509192 462348 479049 439439 572669 466020 478420 384581 824483 459638 605136 800796 796157 724729 236724 468341 555359 566777 759921 735023 743015 391692 392952 539741 468359 573303 552285 555337 566770 714895 624837 763547 803537 759941 766647 391959 505725 827484 547236 712563 725030 ] |
||||||||||||||||||||||||||||||
|
4.07 ms (2.20%) |
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 150798 236724 384581 389729 391692 391959 392952 393072 403911 415790 439439 439574 439651 439746 439806 440726 441000 442545 444361 450368 451495 457438 457467 459638 459647 460411 462348 463991 465892 466020 466228 467930 468341 468359 468373 475883 478002 478420 479049 486341 490846 495813 505725 509192 516469 518919 523845 524779 526526 531866 534559 535452 539741 547236 549088 549221 552285 555093 555103 555231 555242 555337 555359 561526 563642 564291 564295 566770 566777 572669 573303 576493 605136 610033 618468 620226 623211 624837 661593 665960 665972 668677 669010 669072 709545 710455 712563 714618 714895 719929 724729 725030 728170 728366 730315 735023 742729 743015 745952 756683 757277 759921 759941 760973 761018 763547 765699 766647 773271 792643 796157 800796 801259 803537 804524 824483 826246 827326 827484 827973 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск mature анал"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur mature anal"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск mature анал"
]
|
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.