Query Metrics
7
Database Queries
7
Different statements
139.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.53 ms (82.63%) |
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 3392 6698 6874 6983 73289 92281 105224 185753 226286 293121 346211 384762 385254 385838 385909 386095 386673 387815 388685 388773 389132 390640 390849 391478 392277 392347 393089 393135 393149 393486 396065 397390 397882 397942 401336 401579 405760 413335 420839 421590 425556 441596 441788 442136 443917 447335 448536 468352 468835 470923 477538 479843 485995 498226 499359 503499 505072 511345 515291 521576 530024 532791 533042 534102 543616 546057 547241 547433 549075 559347 559378 560982 564224 572626 590796 603103 604280 613129 626566 629036 634067 639363 639552 657213 671594 674943 695889 698711 711631 714071 717817 719022 720756 721936 723579 725120 726294 733276 735448 741106 747519 761157 761197 761430 766840 767008 768198 768419 789847 791532 792679 800296 800423 800494 803092 803124 805784 810294 824883 826181 ] |
||||||||||||||||||||||||||||||
|
15.49 ms (11.08%) |
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 805784 735448 766840 789847 792679 803124 346211 389132 6874 386095 393135 293121 396065 826181 448536 534102 572626 547433 671594 791532 726294 768198 425556 386673 3392 470923 499359 392347 468352 515291 559347 560982 761197 767008 6983 477538 505072 559378 385838 393089 393149 92281 390640 420839 485995 590796 533042 530024 564224 543616 547241 674943 629036 603103 613129 521576 511345 498226 385909 384762 393486 73289 390849 387815 397942 421590 723579 824883 479843 503499 695889 714071 711631 719022 720756 721936 626566 800494 761430 810294 761157 741106 698711 803092 401336 388685 397882 447335 185753 385254 405760 468835 532791 604280 105224 392277 6698 388773 391478 413335 441596 441788 443917 442136 549075 546057 657213 717817 634067 639363 639552 800296 725120 747519 800423 768419 733276 226286 397390 401579 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.55%) |
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 3392 6698 6874 6983 73289 92281 105224 185753 226286 293121 346211 384762 385254 385838 385909 386095 386673 387815 388685 388773 389132 390640 390849 391478 392277 392347 393089 393135 393149 393486 396065 397390 397882 397942 401336 401579 405760 413335 420839 421590 425556 441596 441788 442136 443917 447335 448536 468352 468835 470923 477538 479843 485995 498226 499359 503499 505072 511345 515291 521576 530024 532791 533042 534102 543616 546057 547241 547433 549075 559347 559378 560982 564224 572626 590796 603103 604280 613129 626566 629036 634067 639363 639552 657213 671594 674943 695889 698711 711631 714071 717817 719022 720756 721936 723579 725120 726294 733276 735448 741106 747519 761157 761197 761430 766840 767008 768198 768419 789847 791532 792679 800296 800423 800494 803092 803124 805784 810294 824883 826181 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal anus"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал анус"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.08%) |
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.