Query Metrics
7
Database Queries
7
Different statements
410.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.62 ms (50.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
181.99 ms (44.31%) |
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 80505 383833 401838 417233 423811 432414 440533 452408 453291 461119 475491 506961 509395 515198 520521 531265 558865 567295 568671 581699 583569 588019 591015 591086 591151 593736 595020 604001 606952 608449 610107 610163 630666 642115 643220 643455 650374 651441 653004 653290 653501 661334 666433 666483 668554 676660 677860 680390 682644 695051 696332 710329 713038 719310 724839 725004 725413 725432 726052 728040 728464 728467 728563 728836 728868 730280 730318 730510 733389 734098 737883 738845 739646 740614 741199 743949 744951 745323 746132 746587 746853 747942 750692 751478 753988 756373 757117 759812 761609 765369 765408 769191 770810 775617 777472 779066 779949 780843 781097 781146 784340 786829 787312 787801 795673 796024 796720 797744 798507 801982 802088 802272 808619 811147 813310 814116 814283 818087 818678 825073 ] |
||||||||||||||||||||||||||||||
|
14.51 ms (3.53%) |
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 733389 746132 728464 728868 730510 753988 765369 730318 740614 746853 606952 797744 802088 802272 401838 417233 818087 814116 461119 453291 520521 581699 668554 666433 680390 682644 719310 713038 591151 591086 588019 604001 608449 798507 787801 813310 725413 737883 743949 770810 787312 769191 744951 725432 728040 728836 745323 734098 710329 781146 423811 509395 80505 383833 814283 818678 452408 515198 558865 567295 653501 677860 695051 696332 651441 676660 653290 661334 595020 643220 593736 779066 795673 796024 811147 777472 780843 786829 756373 757117 784340 808619 724839 725004 730280 739646 765408 759812 747942 751478 741199 761609 630666 642115 775617 779949 432414 475491 440533 738845 825073 531265 568671 583569 653004 650374 610107 591015 610163 643455 801982 796720 728563 726052 728467 746587 666483 781097 750692 506961 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (0.58%) |
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 80505 383833 401838 417233 423811 432414 440533 452408 453291 461119 475491 506961 509395 515198 520521 531265 558865 567295 568671 581699 583569 588019 591015 591086 591151 593736 595020 604001 606952 608449 610107 610163 630666 642115 643220 643455 650374 651441 653004 653290 653501 661334 666433 666483 668554 676660 677860 680390 682644 695051 696332 710329 713038 719310 724839 725004 725413 725432 726052 728040 728464 728467 728563 728836 728868 730280 730318 730510 733389 734098 737883 738845 739646 740614 741199 743949 744951 745323 746132 746587 746853 747942 750692 751478 753988 756373 757117 759812 761609 765369 765408 769191 770810 775617 777472 779066 779949 780843 781097 781146 784340 786829 787312 787801 795673 796024 796720 797744 798507 801982 802088 802272 808619 811147 813310 814116 814283 818087 818678 825073 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits cumshot"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сиськ cumshot"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ cumshot"
]
|
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.