Query Metrics
7
Database Queries
7
Different statements
418.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.16 ms (49.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
186.97 ms (44.72%) |
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 390322 409506 414381 419116 420203 420267 420406 423563 423657 425118 425910 426368 432243 436358 443103 443383 448377 448873 459703 461056 463762 463780 467888 469023 471935 475984 478048 478090 478511 491762 492762 496086 503406 511067 511251 511489 512224 512871 515371 515969 516765 517847 518917 519317 520961 522130 522157 522205 523266 523868 524501 526891 527116 527916 529855 530005 530010 530053 530269 530487 530771 530805 530808 531261 531419 532792 532948 533367 533368 533538 533557 534797 535023 535584 536262 536340 536684 537241 537247 537885 542975 551049 559176 560286 566563 580290 583702 592557 593818 593843 595602 605437 618088 623832 634185 637036 638052 648524 648589 648861 653672 664459 674943 683262 689529 713320 718232 720635 733160 736336 742836 764485 778096 782544 784246 792590 793113 796020 796749 796773 ] |
||||||||||||||||||||||||||||||
|
16.70 ms (3.99%) |
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 653672 595602 618088 784246 782544 736336 527116 523266 478048 566563 648589 664459 551049 560286 605437 471935 674943 436358 432243 423657 414381 463762 448873 530010 533538 536340 536684 537241 537885 512224 522130 532792 533368 518917 530005 531261 532948 533367 496086 511489 522205 524501 530771 542975 648861 634185 390322 409506 448377 419116 425910 443383 459703 425118 467888 475984 511251 515371 491762 515969 503406 520961 527916 478511 511067 512871 683262 623832 533557 530808 637036 559176 713320 648524 689529 583702 592557 593843 593818 778096 793113 796020 796749 733160 742836 764485 792590 796773 638052 718232 720635 420267 420203 426368 423563 443103 420406 463780 469023 461056 478090 492762 522157 529855 530269 535023 537247 523868 534797 530053 531419 536262 516765 517847 519317 526891 530487 530805 535584 580290 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (0.60%) |
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 390322 409506 414381 419116 420203 420267 420406 423563 423657 425118 425910 426368 432243 436358 443103 443383 448377 448873 459703 461056 463762 463780 467888 469023 471935 475984 478048 478090 478511 491762 492762 496086 503406 511067 511251 511489 512224 512871 515371 515969 516765 517847 518917 519317 520961 522130 522157 522205 523266 523868 524501 526891 527116 527916 529855 530005 530010 530053 530269 530487 530771 530805 530808 531261 531419 532792 532948 533367 533368 533538 533557 534797 535023 535584 536262 536340 536684 537241 537247 537885 542975 551049 559176 560286 566563 580290 583702 592557 593818 593843 595602 605437 618088 623832 634185 637036 638052 648524 648589 648861 653672 664459 674943 683262 689529 713320 718232 720635 733160 736336 742836 764485 778096 782544 784246 792590 793113 796020 796749 796773 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"хардкор доминирован"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"extreme slave"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.