Query Metrics
7
Database Queries
7
Different statements
174.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.32 ms (80.32%) |
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 399598 427147 435403 435568 437368 444647 457071 459190 460754 461653 462231 463688 468255 475014 480336 480662 483691 484880 487676 489377 490272 491183 494864 497719 498303 498483 499059 502982 505281 505336 509430 510051 510729 513615 528222 538977 541649 543330 546153 547751 547756 547758 549554 551896 555020 555967 556004 556599 560409 561228 563649 564744 564745 567022 568065 568075 570115 571726 575287 578349 579038 579426 581502 581514 583021 584105 584817 584907 588525 589509 589683 590507 590528 591247 591394 591799 592355 594513 595088 595178 595891 596235 597075 597091 598564 598741 598953 599528 599803 600458 601529 603759 604342 605117 605867 606439 607879 614979 617047 618799 623744 624167 626089 627670 639460 652921 665600 672812 672831 703969 704078 709510 741699 770410 780251 784681 803039 807244 814434 ] |
||||||||||||||||||||||||||||||
|
22.74 ms (13.02%) |
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 463688 578349 459190 427147 498303 595088 555967 549554 437368 487676 497719 505336 543330 570115 581514 627670 468255 489377 528222 703969 665600 579426 551896 462231 499059 491183 510051 599803 556004 592355 560409 741699 814434 567022 709510 591799 599528 475014 399598 494864 538977 547751 563649 568075 617047 784681 461653 490272 704078 672812 556599 614979 618799 780251 807244 435568 444647 435403 510729 502982 505281 590528 607879 547756 601529 509430 598953 460754 498483 483691 547758 564745 546153 564744 568065 581502 770410 480336 480662 513615 594513 605867 591394 604342 598564 600458 598741 588525 579038 571726 590507 595178 603759 555020 541649 561228 672831 584817 626089 803039 796642 457071 652921 623744 589509 595891 606439 597091 596235 591247 605117 624167 597075 484880 639460 589683 584105 584907 575287 583021 ] |
||||||||||||||||||||||||||||||
|
3.95 ms (2.26%) |
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 399598 427147 435403 435568 437368 444647 457071 459190 460754 461653 462231 463688 468255 475014 480336 480662 483691 484880 487676 489377 490272 491183 494864 497719 498303 498483 499059 502982 505281 505336 509430 510051 510729 513615 528222 538977 541649 543330 546153 547751 547756 547758 549554 551896 555020 555967 556004 556599 560409 561228 563649 564744 564745 567022 568065 568075 570115 571726 575287 578349 579038 579426 581502 581514 583021 584105 584817 584907 588525 589509 589683 590507 590528 591247 591394 591799 592355 594513 595088 595178 595891 596235 597075 597091 598564 598741 598953 599528 599803 600458 601529 603759 604342 605117 605867 606439 607879 614979 617047 618799 623744 624167 626089 627670 639460 652921 665600 672812 672831 703969 704078 709510 741699 770410 780251 784681 803039 807244 814434 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"соло оргазм-на-русском"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло оргазм на русск"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.87%) |
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.