Query Metrics
7
Database Queries
7
Different statements
145.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.25 ms (83.22%) |
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 159511 183506 389462 391754 410524 411448 412855 420434 425431 426043 426259 428220 428700 428729 429708 429889 429916 439103 439532 440698 441057 441077 441111 441120 441925 445395 445625 449075 452812 452818 452864 452873 453582 453820 453822 455886 457541 459659 467089 467945 469027 473479 490741 494495 501098 505676 511005 511869 512882 514946 523197 527409 530438 531929 536971 542217 546057 554858 556341 558098 559372 576438 581050 590262 591666 591805 592875 597457 601338 601367 606346 616296 624148 625598 630564 636651 642029 655924 657528 660441 661593 666736 689616 695464 695604 700925 700997 703496 710421 722590 726936 732718 733645 734437 747083 750756 755402 758276 758799 760038 760609 767039 769780 784716 787510 787514 787558 788011 788497 790575 791580 814387 815965 820165 820594 823333 824689 827326 827612 ] |
||||||||||||||||||||||||||||||
|
15.62 ms (10.72%) |
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 530438 505676 531929 657528 695604 769780 760609 787514 428729 546057 420434 467089 824689 710421 767039 823333 815965 820165 554858 700925 661593 636651 597457 788011 747083 758276 787558 501098 827612 426259 471695 601338 457541 425431 429889 527409 523197 412855 473479 426043 439532 441120 410524 734437 726936 159511 536971 542217 666736 695464 590262 625598 791580 790575 428700 440698 429708 453582 469027 556341 389462 429916 391754 490741 700997 452864 441077 441111 441057 411448 428220 814387 820594 827326 452812 452873 453820 455886 445625 511005 494495 511869 512882 514946 467945 581050 558098 559372 576438 655924 660441 689616 703496 722590 624148 591805 592875 601367 606346 616296 630564 642029 787510 733645 758799 760038 784716 755402 732718 750756 788497 445395 449075 183506 441925 459659 591666 439103 452818 453822 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.92%) |
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 159511 183506 389462 391754 410524 411448 412855 420434 425431 426043 426259 428220 428700 428729 429708 429889 429916 439103 439532 440698 441057 441077 441111 441120 441925 445395 445625 449075 452812 452818 452864 452873 453582 453820 453822 455886 457541 459659 467089 467945 469027 473479 490741 494495 501098 505676 511005 511869 512882 514946 523197 527409 530438 531929 536971 542217 546057 554858 556341 558098 559372 576438 581050 590262 591666 591805 592875 597457 601338 601367 606346 616296 624148 625598 630564 636651 642029 655924 657528 660441 661593 666736 689616 695464 695604 700925 700997 703496 710421 722590 726936 732718 733645 734437 747083 750756 755402 758276 758799 760038 760609 767039 769780 784716 787510 787514 787558 788011 788497 790575 791580 814387 815965 820165 820594 823333 824689 827326 827612 ] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass anal masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп анал мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.98%) |
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.