Query Metrics
7
Database Queries
7
Different statements
158.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.89 ms (80.74%) |
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 418886 423657 429762 430389 439529 439714 440991 460412 464932 466294 466572 467868 467888 468433 468631 469536 469566 473249 476119 476128 477554 477555 478530 478832 482788 484821 486316 486450 486665 486763 488747 490428 491266 491407 491784 491786 491937 494171 494231 494513 494516 497899 500430 501081 501228 501474 506038 509024 509660 512215 514709 514836 515329 515934 515969 516972 517001 517847 519107 519549 521204 522925 523019 524142 524257 527916 530487 531104 531419 533727 533831 535045 536233 536403 537202 537885 538803 540944 541644 543860 543868 543871 545081 545375 545648 546200 547546 561068 561132 561140 561142 565150 567347 572189 574951 584024 596900 599902 602563 604849 610692 628312 632694 633780 637413 639810 647995 648861 649596 650486 650851 652316 677973 695184 718745 725392 747236 784315 792554 814908 ] |
||||||||||||||||||||||||||||||
|
19.73 ms (12.46%) |
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 482788 514836 494513 533831 512215 488747 561132 574951 545081 561068 718745 628312 477555 501228 517001 491266 491937 650851 567347 486665 429762 469536 476128 537885 519107 531104 515329 460412 484821 543871 565150 784315 632694 478530 466572 509660 486316 519549 491407 501474 527916 517847 633780 602563 747236 531419 536233 521204 468433 478832 439714 430389 814908 486450 494171 509024 535045 537202 540944 647995 652316 695184 792554 725392 473249 466294 501081 486763 506038 524257 536403 639810 541644 523019 423657 476119 522925 516972 497899 514709 464932 545648 584024 561140 561142 572189 648861 677973 596900 610692 599902 467868 418886 467888 490428 515934 515969 494516 649596 524142 533727 477554 530487 650486 439529 469566 468631 440991 500430 491784 543860 547546 637413 491786 494231 543868 546200 545375 604849 538803 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (2.12%) |
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 418886 423657 429762 430389 439529 439714 440991 460412 464932 466294 466572 467868 467888 468433 468631 469536 469566 473249 476119 476128 477554 477555 478530 478832 482788 484821 486316 486450 486665 486763 488747 490428 491266 491407 491784 491786 491937 494171 494231 494513 494516 497899 500430 501081 501228 501474 506038 509024 509660 512215 514709 514836 515329 515934 515969 516972 517001 517847 519107 519549 521204 522925 523019 524142 524257 527916 530487 531104 531419 533727 533831 535045 536233 536403 537202 537885 538803 540944 541644 543860 543868 543871 545081 545375 545648 546200 547546 561068 561132 561140 561142 565150 567347 572189 574951 584024 596900 599902 602563 604849 610692 628312 632694 633780 637413 639810 647995 648861 649596 650486 650851 652316 677973 695184 718745 725392 747236 784315 792554 814908 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf bdsm anal"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf бдсм анал"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf бдсм анал"
]
|
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.