Query Metrics
7
Database Queries
7
Different statements
183.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.28 ms (84.44%) |
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 384108 391992 394590 416470 416522 416613 416616 416696 419824 432970 441021 441042 443086 443236 448199 451121 452914 459198 466476 466639 467952 468146 468946 469735 483583 483732 483742 486773 487414 488820 493696 505139 511240 511856 511857 512442 515488 517509 519712 526504 529296 531862 541274 541276 541322 541451 545434 545550 547470 547482 548854 548857 561034 564285 573734 574664 576128 576932 581064 583712 590803 590837 594491 595339 597111 602249 604228 604781 609097 609890 614967 619659 619679 624197 636183 640312 641997 642149 656200 656891 656942 663181 669361 669386 670368 695875 696593 700975 707408 713185 715797 735308 738515 745087 749264 750145 752610 752636 752650 752697 770387 776527 777847 782836 783709 783743 784217 785868 799759 800318 804639 804939 806541 806788 806924 808787 811690 814459 814470 ] |
||||||||||||||||||||||||||||||
|
17.89 ms (9.73%) |
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 576128 669361 669386 619679 595339 604781 443086 394590 640312 604228 783743 800318 750145 541322 776527 573734 432970 594491 749264 511240 609890 468146 511857 419824 602249 581064 656891 696593 597111 783709 806788 785868 804639 609097 583712 541451 545550 590837 752650 466476 529296 564285 656200 548857 642149 784217 799759 806924 804939 738515 745087 735308 416613 468946 526504 469735 547470 574664 576932 700975 590803 466639 519712 488820 695875 782836 715797 416522 448199 451121 486773 505139 511856 547482 811690 416616 441042 441021 483732 483742 416470 814459 814470 452914 517509 531862 548854 541276 656942 713185 663181 545434 636183 624197 614967 777847 808787 782849 752610 752697 806541 707408 416696 467952 483583 515488 619659 493696 384108 443236 391992 459198 770387 487414 512442 541274 561034 670368 641997 752636 ] |
||||||||||||||||||||||||||||||
|
3.91 ms (2.13%) |
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 384108 391992 394590 416470 416522 416613 416616 416696 419824 432970 441021 441042 443086 443236 448199 451121 452914 459198 466476 466639 467952 468146 468946 469735 483583 483732 483742 486773 487414 488820 493696 505139 511240 511856 511857 512442 515488 517509 519712 526504 529296 531862 541274 541276 541322 541451 545434 545550 547470 547482 548854 548857 561034 564285 573734 574664 576128 576932 581064 583712 590803 590837 594491 595339 597111 602249 604228 604781 609097 609890 614967 619659 619679 624197 636183 640312 641997 642149 656200 656891 656942 663181 669361 669386 670368 695875 696593 700975 707408 713185 715797 735308 738515 745087 749264 750145 752610 752636 752650 752697 770387 776527 777847 782836 783709 783743 784217 785868 799759 800318 804639 804939 806541 806788 806924 808787 811690 814459 814470 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд анал домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo anal homemade"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.82%) |
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.