Query Metrics
7
Database Queries
7
Different statements
235.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.61 ms (89.95%) |
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 385907 423764 428063 441892 477565 483685 484352 485611 508102 518952 522334 523247 526023 529742 533227 534907 545014 547220 557030 560305 574689 575625 576175 577537 584605 585246 588136 593913 595928 603265 604958 606869 611491 617000 618039 619084 619275 619964 623221 631311 631417 631869 637955 642996 649625 651370 653880 654614 662857 665313 665989 667057 673159 674938 677511 681530 690630 693364 695786 697633 702302 707144 710274 714006 715737 719423 724184 726173 729170 732819 732840 733241 734098 735488 737537 739717 743653 744381 744820 746064 746902 750553 752742 753255 754375 757866 758680 759760 763503 765791 766171 768255 772476 778823 779476 783843 784011 784090 784777 785035 787024 791305 795332 795827 795843 801312 805339 807858 811728 812812 813565 816761 819503 824646 825097 826689 ] |
||||||||||||||||||||||||||||||
|
15.56 ms (6.61%) |
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 618039 619084 783843 791305 801312 763503 724184 631869 776114 784090 816761 819503 665313 707144 585246 744381 759760 423764 752742 754183 787024 518952 619275 485611 619964 758680 795843 757866 737537 784777 673159 428063 824646 533227 575625 574689 674938 588136 593913 729170 750553 606869 595928 623221 732840 826689 483685 508102 523247 662857 665989 681530 690630 714006 577537 637955 642996 779476 811728 812812 739717 735488 726173 604958 631311 807858 710274 547220 654614 751981 649625 753255 584605 805339 733241 617000 484352 522334 576175 784011 795332 441892 813565 560305 702302 545014 557030 611491 772476 785035 744820 766171 739943 765791 529742 653880 754375 693364 603265 667057 734098 746902 732819 746064 795827 825097 526023 534907 677511 697633 651370 631417 743653 768255 715737 695786 477565 719423 778823 385907 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.84%) |
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 385907 423764 428063 441892 477565 483685 484352 485611 508102 518952 522334 523247 526023 529742 533227 534907 545014 547220 557030 560305 574689 575625 576175 577537 584605 585246 588136 593913 595928 603265 604958 606869 611491 617000 618039 619084 619275 619964 623221 631311 631417 631869 637955 642996 649625 651370 653880 654614 662857 665313 665989 667057 673159 674938 677511 681530 690630 693364 695786 697633 702302 707144 710274 714006 715737 719423 724184 726173 729170 732819 732840 733241 734098 735488 737537 739717 743653 744381 744820 746064 746902 750553 752742 753255 754375 757866 758680 759760 763503 765791 766171 768255 772476 778823 779476 783843 784011 784090 784777 785035 787024 791305 795332 795827 795843 801312 805339 807858 811728 812812 813565 816761 819503 824646 825097 826689 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"friend секс жен"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"friend fuck wife"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"friend секс жен"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.60%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.