Query Metrics
7
Database Queries
7
Different statements
217.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
193.78 ms (89.25%) |
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 191057 213627 252068 366040 382289 382690 383581 385826 386350 392766 396300 396371 396873 397911 398462 400835 404590 407432 407792 409227 411624 411757 415571 422278 429292 443824 452391 460556 464338 464563 465375 465545 466023 466264 468045 469121 471894 472609 473333 474463 477671 478929 481328 482443 482782 483054 485948 486543 488573 490932 492633 493101 494184 494722 495514 499329 500884 503843 504464 506404 506836 507269 508663 514864 517238 519260 526047 526456 529247 541926 545876 554452 555103 555788 563200 563209 564920 565026 567113 589679 605156 608925 617380 618759 624788 634271 661615 667010 669457 714936 720535 722107 726493 726914 728342 731769 733251 734090 738324 742603 747087 754138 754232 755991 778575 780707 781663 781749 781993 784189 784241 784632 785706 788345 800914 808496 809648 810031 810098 817714 ] |
||||||||||||||||||||||||||||||
|
14.16 ms (6.52%) |
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 466023 407432 407792 506404 714936 738324 466264 563209 733251 481328 366040 386350 504464 755991 382289 443824 465375 488573 608925 726914 747087 784632 474463 385826 396300 507269 519260 667010 555788 565026 731769 810031 529247 809648 506836 526047 495514 669457 722107 617380 618759 734090 800914 742603 555103 471894 478929 500884 526456 482782 382690 781663 494722 477671 567113 781749 726493 499329 780707 464563 517238 213627 624788 383581 400835 398462 817714 554452 785706 788345 754138 754232 784241 490932 605156 411757 404590 429292 415571 485948 545876 541926 563200 397911 483054 465545 503843 781993 392766 472609 191057 396371 514864 396873 422278 482443 452391 464338 473333 493101 564920 589679 808496 469121 460556 492633 486543 508663 661615 784189 810098 252068 468045 720535 634271 778575 728342 494184 409227 411624 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.33%) |
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 191057 213627 252068 366040 382289 382690 383581 385826 386350 392766 396300 396371 396873 397911 398462 400835 404590 407432 407792 409227 411624 411757 415571 422278 429292 443824 452391 460556 464338 464563 465375 465545 466023 466264 468045 469121 471894 472609 473333 474463 477671 478929 481328 482443 482782 483054 485948 486543 488573 490932 492633 493101 494184 494722 495514 499329 500884 503843 504464 506404 506836 507269 508663 514864 517238 519260 526047 526456 529247 541926 545876 554452 555103 555788 563200 563209 564920 565026 567113 589679 605156 608925 617380 618759 624788 634271 661615 667010 669457 714936 720535 722107 726493 726914 728342 731769 733251 734090 738324 742603 747087 754138 754232 755991 778575 780707 781663 781749 781993 784189 784241 784632 785706 788345 800914 808496 809648 810031 810098 817714 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ебут тещю"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.71%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.64%) |
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.