Query Metrics
7
Database Queries
7
Different statements
175.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.16 ms (86.72%) |
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 447371 453724 455763 490479 493278 501072 516832 518152 526304 528493 529331 530571 534926 546047 546867 549572 554093 576180 585697 588246 589672 591170 591726 592064 594578 595615 598903 610992 612779 612795 615274 617357 618735 621485 623361 626280 628823 629855 633857 634842 635268 640304 646868 656874 666052 666081 676271 679005 680919 688395 696316 697009 707440 707467 714225 714744 714868 716484 717080 718011 720415 722061 725416 726129 728239 732984 733120 733567 735936 737274 738191 738852 739778 739782 742149 742622 742757 746329 756245 756247 756319 757177 758766 759690 759712 761118 761469 762380 766596 768153 769465 769480 769531 771359 773974 773982 775952 777870 780072 780442 783977 789594 791052 791457 792536 793497 793555 794824 795811 796851 801224 802291 803723 804004 804518 807903 808233 808908 813035 814232 ] |
||||||||||||||||||||||||||||||
|
13.57 ms (7.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 688395 791052 771359 666081 589672 634842 595615 791457 759712 739782 759690 626280 783977 633857 742149 792536 795811 528493 546047 666052 679005 554093 615274 585697 808908 629855 656874 676271 717080 617357 640304 801224 762380 732984 738191 746329 726129 768153 769480 808233 490479 796851 733567 814232 453724 493278 526304 501072 518152 576180 707440 646868 697009 714868 714744 716484 722061 588246 598903 621485 623361 594578 780072 793497 802291 804518 780442 789594 813035 742622 766596 794824 756245 728239 742757 769465 769531 735936 737274 739778 756247 756319 773982 757177 773974 718011 793555 804004 807903 455763 628823 549572 761118 680919 803723 733120 738852 707467 591726 612795 696316 714225 777870 758766 725416 761469 775952 447371 529331 546867 592064 610992 618735 516832 534926 530571 720415 635268 591170 612779 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.39%) |
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 447371 453724 455763 490479 493278 501072 516832 518152 526304 528493 529331 530571 534926 546047 546867 549572 554093 576180 585697 588246 589672 591170 591726 592064 594578 595615 598903 610992 612779 612795 615274 617357 618735 621485 623361 626280 628823 629855 633857 634842 635268 640304 646868 656874 666052 666081 676271 679005 680919 688395 696316 697009 707440 707467 714225 714744 714868 716484 717080 718011 720415 722061 725416 726129 728239 732984 733120 733567 735936 737274 738191 738852 739778 739782 742149 742622 742757 746329 756245 756247 756319 757177 758766 759690 759712 761118 761469 762380 766596 768153 769465 769480 769531 771359 773974 773982 775952 777870 780072 780442 783977 789594 791052 791457 792536 793497 793555 794824 795811 796851 801224 802291 803723 804004 804518 807903 808233 808908 813035 814232 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"обвисшая грудь кремпай"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"обвисшая сиськ кремпа сперм"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.99%) |
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.