Query Metrics
7
Database Queries
7
Different statements
421.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
394.37 ms (93.65%) |
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 396540 401927 404035 410128 412332 415833 417564 420527 420594 422398 425331 427092 430949 433930 443118 445747 448307 450646 450851 451583 453666 455804 456688 457321 457540 457674 458436 459265 461005 461886 470347 471759 475010 475071 475550 479286 482191 486086 487313 490720 494686 495303 496693 498151 499155 502884 504695 505189 505858 509005 509666 518380 523995 524513 525542 525951 527931 529277 540229 541041 542026 542854 543593 546833 548510 557382 558210 559051 562118 564566 565001 567698 568743 578109 578961 582568 590188 593122 598420 601705 610629 610773 614213 614258 625294 626824 631185 646202 650218 661547 662861 667002 680375 682625 689136 689736 691219 691578 693572 705516 705742 719644 719837 720421 729629 745557 758404 758691 765055 774214 778089 780786 782978 783161 791778 793050 798698 800325 808011 819454 ] |
||||||||||||||||||||||||||||||
|
16.28 ms (3.87%) |
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 443118 420594 646202 498151 396540 631185 662861 471759 496693 691219 562118 691578 800325 504695 499155 705742 546833 568743 567698 791778 470347 610629 541041 451583 525542 448307 457321 682625 614213 445747 798698 412332 518380 745557 729629 540229 529277 778089 680375 479286 719644 610773 461005 505189 578109 425331 494686 509666 650218 450646 582568 614258 417564 487313 422398 502884 459265 774214 455804 819454 693572 542026 410128 705516 598420 401927 720421 548510 524513 490720 404035 475550 525951 593122 689736 689136 782978 758691 765055 430949 453666 509005 808011 457540 486086 625294 475071 450851 667002 495303 758404 793050 475010 458436 564566 415833 557382 559051 565001 601705 780786 523995 433930 626824 427092 527931 461886 457674 661547 456688 783161 505858 558210 578961 482191 543593 590188 420527 719837 542854 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (0.64%) |
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 396540 401927 404035 410128 412332 415833 417564 420527 420594 422398 425331 427092 430949 433930 443118 445747 448307 450646 450851 451583 453666 455804 456688 457321 457540 457674 458436 459265 461005 461886 470347 471759 475010 475071 475550 479286 482191 486086 487313 490720 494686 495303 496693 498151 499155 502884 504695 505189 505858 509005 509666 518380 523995 524513 525542 525951 527931 529277 540229 541041 542026 542854 543593 546833 548510 557382 558210 559051 562118 564566 565001 567698 568743 578109 578961 582568 590188 593122 598420 601705 610629 610773 614213 614258 625294 626824 631185 646202 650218 661547 662861 667002 680375 682625 689136 689736 691219 691578 693572 705516 705742 719644 719837 720421 729629 745557 758404 758691 765055 774214 778089 780786 782978 783161 791778 793050 798698 800325 808011 819454 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (0.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"глубокийминет минет оральн секс в гор природ"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"глубокая глотка в гор%…"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.37%) |
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.