Query Metrics
7
Database Queries
7
Different statements
141.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.88 ms (82.61%) |
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 191759 275759 383388 389460 389867 395655 396782 400619 401160 428728 450392 458503 459848 474224 516016 526102 538578 538705 538721 538757 538779 538782 545358 550585 552291 555052 557446 558392 560369 568776 574026 579785 587157 589927 594159 594170 594232 594250 597284 597545 600335 600757 601776 604215 604900 605591 621453 621469 621958 622592 624264 625793 628756 628843 629574 629629 635883 636175 649372 662499 664260 664555 668485 670896 709276 712153 740131 740258 750392 751805 753745 754318 754447 754487 754574 756670 759115 768053 769163 770456 771753 771944 771984 776576 782475 782554 783327 783863 784001 784022 784033 784044 784379 784410 784453 784654 785908 791198 794197 795219 796576 797333 800954 803624 804254 807003 807583 808087 808107 808529 808540 808561 808697 809143 811415 812804 818751 819649 823827 826160 ] |
||||||||||||||||||||||||||||||
|
14.26 ms (10.08%) |
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 771944 808087 768053 474224 552291 649372 621453 594159 812804 756670 771753 797333 808529 597284 450392 818751 589927 740258 754318 459848 625793 754447 400619 597545 605591 389867 538782 629629 791198 807003 808561 754487 784001 784379 807583 622592 712153 826160 823827 538578 557446 545358 560369 664555 668485 709276 600757 604900 628843 594170 809143 796576 750392 753745 389460 383388 191759 395655 538705 538757 555052 635883 600335 782475 794197 800954 771984 784410 769163 759115 740131 624264 784044 401160 428728 458503 594250 396782 538779 636175 601776 628756 587157 784453 803624 808540 784022 785908 751805 754574 629574 784033 526102 604215 784654 275759 538721 516016 558392 574026 670896 621469 621958 594232 811415 782554 783327 795219 808107 808697 770456 776576 783863 804254 819649 550585 579785 568776 662499 664260 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (2.19%) |
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 191759 275759 383388 389460 389867 395655 396782 400619 401160 428728 450392 458503 459848 474224 516016 526102 538578 538705 538721 538757 538779 538782 545358 550585 552291 555052 557446 558392 560369 568776 574026 579785 587157 589927 594159 594170 594232 594250 597284 597545 600335 600757 601776 604215 604900 605591 621453 621469 621958 622592 624264 625793 628756 628843 629574 629629 635883 636175 649372 662499 664260 664555 668485 670896 709276 712153 740131 740258 750392 751805 753745 754318 754447 754487 754574 756670 759115 768053 769163 770456 771753 771944 771984 776576 782475 782554 783327 783863 784001 784022 784033 784044 784379 784410 784453 784654 785908 791198 794197 795219 796576 797333 800954 803624 804254 807003 807583 808087 808107 808529 808540 808561 808697 809143 811415 812804 818751 819649 823827 826160 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam busty girl"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер busty девушк"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер busty девушк"
]
|
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.