Query Metrics
7
Database Queries
7
Different statements
211.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
186.28 ms (88.16%) |
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 96514 96761 310295 386813 387601 393004 395661 395701 396707 397873 404953 407454 414729 421654 423350 426712 433239 433297 476323 478562 484735 485229 489973 493260 493482 503044 508187 508720 519092 522907 531121 531250 532748 533063 534129 536212 537591 543497 561131 561416 568423 570775 581292 583730 583873 585332 601536 603649 604214 604403 604580 620794 630633 631930 632038 638565 639879 644301 644309 645241 645904 647602 648539 656904 665662 666584 673613 673719 677723 692188 697274 698102 698550 703062 705278 708468 709942 716789 717034 718870 720003 720111 720197 720711 720911 720950 727744 728200 748326 748529 750466 751512 765297 770124 770196 775772 777078 784700 784801 789647 789841 797949 799946 801949 805490 805589 805599 807191 807617 809413 814536 815057 815557 816502 816520 817284 817537 818290 818848 824423 ] |
||||||||||||||||||||||||||||||
|
14.02 ms (6.64%) |
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 647602 784700 789647 393004 397873 815057 720711 665662 639879 601536 777078 603649 426712 519092 718870 816502 677723 645904 644309 805589 703062 720911 533063 489973 537591 720003 644301 770196 717034 775772 770124 727744 407454 543497 698102 807191 720111 818290 815557 817537 583730 583873 705278 673613 604403 789841 805599 748529 697274 709942 716789 805490 96514 96761 809413 531121 656904 708468 604214 765297 748326 750466 799946 423350 532748 631930 604580 522907 648539 404953 395661 310295 638565 485229 581292 801949 414729 484735 630633 751512 433239 645241 720197 824423 534129 536212 673719 692188 585332 797949 531250 561416 728200 476323 784801 493482 503044 433297 568423 395701 570775 620794 396707 814536 508187 421654 386813 632038 508720 493260 561131 478562 816520 817284 818848 666584 807617 698550 720950 387601 ] |
||||||||||||||||||||||||||||||
|
3.83 ms (1.81%) |
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 96514 96761 310295 386813 387601 393004 395661 395701 396707 397873 404953 407454 414729 421654 423350 426712 433239 433297 476323 478562 484735 485229 489973 493260 493482 503044 508187 508720 519092 522907 531121 531250 532748 533063 534129 536212 537591 543497 561131 561416 568423 570775 581292 583730 583873 585332 601536 603649 604214 604403 604580 620794 630633 631930 632038 638565 639879 644301 644309 645241 645904 647602 648539 656904 665662 666584 673613 673719 677723 692188 697274 698102 698550 703062 705278 708468 709942 716789 717034 718870 720003 720111 720197 720711 720911 720950 727744 728200 748326 748529 750466 751512 765297 770124 770196 775772 777078 784700 784801 789647 789841 797949 799946 801949 805490 805589 805599 807191 807617 809413 814536 815057 815557 816502 816520 817284 817537 818290 818848 824423 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf anal threesome"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf анал секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.76%) |
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.