Query Metrics
7
Database Queries
7
Different statements
157.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.94 ms (83.27%) |
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 81091 112599 146235 147638 357302 382034 382962 384778 386207 388453 400454 404300 412401 415566 418956 421501 426535 430203 432571 433024 433344 433599 441357 441635 442552 452126 453370 456616 464334 465079 466733 470442 470813 473156 480346 483724 495243 506942 506948 509637 510273 512180 513516 515698 523058 528857 529622 530606 544441 547033 547049 548408 548425 554046 555661 561571 562540 563088 565227 568671 574371 577667 577692 583577 585977 586319 590856 595841 596450 601035 603922 604867 607195 628523 638174 650628 658907 661507 681178 709878 718487 719967 723899 728042 730988 731050 731182 733501 736437 738029 738220 739689 739690 739722 746437 746467 746598 748443 748557 748592 753676 755054 755056 755065 758149 759997 761391 772626 774899 778090 783127 783478 791814 793161 795795 795929 796262 808132 812370 812950 ] |
||||||||||||||||||||||||||||||
|
15.74 ms (10.01%) |
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 386207 495243 512180 583577 544441 452126 510273 404300 523058 577692 442552 515698 421501 603922 412401 590856 473156 509637 426535 465079 470813 585977 400454 433344 658907 456616 415566 464334 430203 601035 418956 607195 574371 470442 466733 480346 453370 604867 547049 81091 112599 733501 562540 791814 758149 547033 739689 382962 596450 568671 561571 548408 595841 563088 808132 755054 738220 739722 730988 739690 586319 755056 755065 441357 506942 772626 146235 483724 548425 638174 529622 577667 628523 738029 746467 748557 783478 748443 384778 433024 147638 796262 812950 388453 441635 432571 433599 774899 650628 778090 723899 746437 731182 795929 728042 759997 506948 761391 530606 554046 565227 661507 709878 795795 731050 753676 718487 719967 513516 681178 783127 793161 748592 746598 382034 736437 528857 555661 812370 357302 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.78%) |
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 81091 112599 146235 147638 357302 382034 382962 384778 386207 388453 400454 404300 412401 415566 418956 421501 426535 430203 432571 433024 433344 433599 441357 441635 442552 452126 453370 456616 464334 465079 466733 470442 470813 473156 480346 483724 495243 506942 506948 509637 510273 512180 513516 515698 523058 528857 529622 530606 544441 547033 547049 548408 548425 554046 555661 561571 562540 563088 565227 568671 574371 577667 577692 583577 585977 586319 590856 595841 596450 601035 603922 604867 607195 628523 638174 650628 658907 661507 681178 709878 718487 719967 723899 728042 730988 731050 731182 733501 736437 738029 738220 739689 739690 739722 746437 746467 746598 748443 748557 748592 753676 755054 755056 755065 758149 759997 761391 772626 774899 778090 783127 783478 791814 793161 795795 795929 796262 808132 812370 812950 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"jerking tits"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (1.01%) |
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.