Query Metrics
7
Database Queries
7
Different statements
165.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.65 ms (86.20%) |
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 31941 165669 317898 334474 366044 385682 386128 387541 387868 396362 398799 405682 418565 423861 429125 429311 429494 432734 441892 443188 443852 453487 453591 453850 453860 453871 456194 456633 457725 459256 462662 472303 473323 474224 475875 477385 478403 478922 479377 480469 482156 485089 485946 485991 486172 486816 486924 490162 490325 490659 492819 493456 493962 494574 495491 495496 495855 503764 504232 504327 506568 507131 507627 509054 520624 522506 523552 530557 532157 533992 536157 537614 537626 537788 541903 541904 541910 544199 547967 552862 553150 553154 553188 553201 553502 553600 555646 555660 556998 557016 557547 559467 565883 567461 567803 597836 645335 662117 669277 673560 673574 686627 691538 692122 693234 694417 698618 702375 702376 702382 721677 732827 739792 747629 753781 780712 795375 805653 811889 ] |
||||||||||||||||||||||||||||||
|
13.67 ms (8.26%) |
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 443852 565883 555660 472303 492819 503764 532157 537626 553201 553150 702376 669277 553188 493962 544199 504232 507131 485946 507627 522506 490162 396362 486816 559467 691538 694417 317898 478403 386128 366044 486172 520624 811889 441892 530557 537614 533992 490659 541904 547967 541910 557547 662117 693234 673560 553154 805653 739792 165669 456633 536157 645335 698618 747629 753781 482156 477385 504327 398799 405682 429494 443188 418565 453871 506568 597836 453850 480469 429125 453487 453860 485991 385682 721677 686627 692122 780712 795375 732827 453591 432734 495496 523552 526388 509054 541903 553600 567461 553502 462662 485089 459256 334474 387541 429311 456194 457725 473323 474224 486924 490325 537788 555646 567803 702382 702375 423861 387868 31941 479377 475875 478922 494574 495491 495855 493456 552862 557016 673574 556998 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.40%) |
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 31941 165669 317898 334474 366044 385682 386128 387541 387868 396362 398799 405682 418565 423861 429125 429311 429494 432734 441892 443188 443852 453487 453591 453850 453860 453871 456194 456633 457725 459256 462662 472303 473323 474224 475875 477385 478403 478922 479377 480469 482156 485089 485946 485991 486172 486816 486924 490162 490325 490659 492819 493456 493962 494574 495491 495496 495855 503764 504232 504327 506568 507131 507627 509054 520624 522506 523552 530557 532157 533992 536157 537614 537626 537788 541903 541904 541910 544199 547967 552862 553150 553154 553188 553201 553502 553600 555646 555660 556998 557016 557547 559467 565883 567461 567803 597836 645335 662117 669277 673560 673574 686627 691538 692122 693234 694417 698618 702375 702376 702382 721677 732827 739792 747629 753781 780712 795375 805653 811889 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"скрытая съемка камеро…"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скрыт камер камер"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.95%) |
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.