Query Metrics
7
Database Queries
7
Different statements
405.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
379.68 ms (93.54%) |
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 384063 392729 397107 402067 404127 411449 417461 421435 423304 423458 424023 424074 424741 426090 427076 437496 443925 443957 446456 447195 453624 460723 462253 462506 469501 470737 470785 473252 476264 483477 490791 496049 504764 507154 509451 511691 511889 512047 525374 527116 528429 536232 542349 542763 552773 553197 553608 567391 569795 576554 580276 580299 591737 591856 605841 606571 614984 615622 638524 648880 672693 677891 678458 681795 686082 687604 694119 694154 696281 697204 701405 701508 702320 704996 708390 713748 714490 717279 730826 733046 733295 736752 736866 738893 740489 743009 747487 747954 753548 757937 761862 762559 768974 775284 782664 785066 789870 792370 794906 794948 794974 795756 797216 797247 800275 800305 801305 803261 804134 807663 811678 811866 818842 820046 823999 825083 825835 826402 827452 828248 ] |
||||||||||||||||||||||||||||||
|
14.75 ms (3.63%) |
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 789870 794974 801305 803261 797247 800305 736866 740489 743009 753548 761862 762559 747954 702320 775284 800275 807663 424023 470785 404127 462506 473252 453624 490791 542763 614984 747487 424074 509451 496049 483477 672693 504764 511889 580276 605841 615622 733295 704996 678458 828248 827452 426090 384063 820046 713748 717279 736752 392729 527116 701508 686082 694154 591737 811866 470737 443925 681795 696281 677891 701405 569795 733046 757937 697204 782664 730826 424741 437496 411449 423458 507154 553197 580299 714490 687604 694119 553608 567391 591856 811678 785066 708390 794906 402067 417461 427076 476264 511691 528429 606571 397107 818842 804134 792370 797216 825835 823999 826402 825083 542349 576554 552773 638524 794948 768974 738893 795756 648880 536232 423304 469501 421435 443957 446456 447195 460723 462253 512047 525374 ] |
||||||||||||||||||||||||||||||
|
4.28 ms (1.05%) |
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 384063 392729 397107 402067 404127 411449 417461 421435 423304 423458 424023 424074 424741 426090 427076 437496 443925 443957 446456 447195 453624 460723 462253 462506 469501 470737 470785 473252 476264 483477 490791 496049 504764 507154 509451 511691 511889 512047 525374 527116 528429 536232 542349 542763 552773 553197 553608 567391 569795 576554 580276 580299 591737 591856 605841 606571 614984 615622 638524 648880 672693 677891 678458 681795 686082 687604 694119 694154 696281 697204 701405 701508 702320 704996 708390 713748 714490 717279 730826 733046 733295 736752 736866 738893 740489 743009 747487 747954 753548 757937 761862 762559 768974 775284 782664 785066 789870 792370 794906 794948 794974 795756 797216 797247 800275 800305 801305 803261 804134 807663 811678 811866 818842 820046 823999 825083 825835 826402 827452 828248 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск young вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur young webcam"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск young вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.41%) |
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.